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

5 rows where "createdAt" is on date 2021-01-13 and ext = "csv"

View and edit SQL

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

Link project ext createdAt name updatedAt size etag
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-13T00:53:42.533000+00:00 BLN_Mobility_Report_US_2021_01_08.csv 2021-01-13T00:53:42.533000+00:00 81375310  
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-13T00:54:01.809000+00:00 BLN_Mobility_Report_nonUS_2021_01_08.csv 2021-01-13T00:54:01.809000+00:00 258468289  
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2021-01-13T00:54:03.346000+00:00 Google_Mobility_Report_2021_01_08.csv 2021-01-13T00:54:03.346000+00:00 282610773  
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= csv 2021-01-13T05:16:14.891000+00:00 ltc_nv.csv 2021-01-13T05:16:14.891000+00:00 16174 "4d284878ecd9d7c127ecbc53ebe4d76f"
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= csv 2021-01-13T05:16:16.985000+00:00 ltc_wv.csv 2021-01-13T05:16:16.985000+00:00 7456 "2cd444aec122fba84d8b14e8365ed23c"

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])
);