Data source: Big Local News · About: big-local-datasette

5 rows where project = "UHJvamVjdDo4NTBjOWJmYy03YzAyLTRkNDgtYjYzMS04OThhODFmZjQxNDQ="

View and edit SQL

Suggested facets: ext, createdAt (date), updatedAt (date)

project

  • COVID_twitter_data · 5
Link project ext createdAt name updatedAt size etag
COVID_twitter_data UHJvamVjdDo4NTBjOWJmYy03YzAyLTRkNDgtYjYzMS04OThhODFmZjQxNDQ= pdf 2020-04-20T17:43:50.821000+00:00 Updated README.pdf 2020-04-20T17:43:50.821000+00:00    
COVID_twitter_data UHJvamVjdDo4NTBjOWJmYy03YzAyLTRkNDgtYjYzMS04OThhODFmZjQxNDQ= csv 2020-06-13T16:36:23.488000+00:00 congress_tweets.csv 2020-06-13T16:36:23.488000+00:00 160980793  
COVID_twitter_data UHJvamVjdDo4NTBjOWJmYy03YzAyLTRkNDgtYjYzMS04OThhODFmZjQxNDQ= csv 2020-06-13T16:36:41.581000+00:00 edu_tweets.csv 2020-06-13T16:36:41.581000+00:00 15579082 "bc47e00667d143c67afa2e8f17b24bc3"
COVID_twitter_data UHJvamVjdDo4NTBjOWJmYy03YzAyLTRkNDgtYjYzMS04OThhODFmZjQxNDQ= csv 2020-06-13T16:36:34.422000+00:00 gov_tweets.csv 2020-06-13T16:36:34.422000+00:00 35857562 "3bd8af9706d28343dd36f1730b00b7c9"
COVID_twitter_data UHJvamVjdDo4NTBjOWJmYy03YzAyLTRkNDgtYjYzMS04OThhODFmZjQxNDQ= csv 2020-06-13T16:36:52.113000+00:00 health_tweets.csv 2020-06-13T16:36:52.113000+00:00 27229398 "a355fa10eff27bc36f3180ac3eba314e"

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "files" (
   [project] TEXT REFERENCES [projects]([id]),
   [ext] TEXT,
   [createdAt] TEXT,
   [name] TEXT,
   [updatedAt] TEXT,
   [size] INTEGER,
   [etag] TEXT,
   PRIMARY KEY ([project], [name])
);