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

7 rows where "createdAt" is on date 2020-12-08

View and edit SQL

Suggested facets: project, ext, updatedAt (date)

createdAt (date)

  • 2020-12-08 · 7
Link project ext createdAt name updatedAt size etag
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2020-12-08T05:30:41.514000+00:00 jhu_covid_time_series_20201208.zip 2020-12-08T05:30:41.514000+00:00    
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2020-12-08T00:05:59.081000+00:00 BLN_Mobility_Report_US_2020_12_04.csv 2020-12-08T00:05:59.081000+00:00 72306499  
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2020-12-08T00:06:27.212000+00:00 BLN_Mobility_Report_nonUS_2020_12_04.csv 2020-12-08T00:06:27.212000+00:00 228583494  
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= csv 2020-12-08T00:06:29.279000+00:00 Google_Mobility_Report_2020_12_04.csv 2020-12-08T00:06:29.279000+00:00 250325562  
Mobility_Google UHJvamVjdDo3N2Q3ZjM0MS1mNWUxLTQ2MzgtOWI4Ny1lMTEyNmJkYjIyY2Y= zip 2020-12-08T00:05:52.091000+00:00 Mobility_Report_2020_12_04.zip 2020-12-08T00:05:52.091000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-12-08T21:05:37.029000+00:00 covid_usafacts_2020_12_08.zip 2020-12-08T21:05:37.029000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2020-12-08T05:20:47.428000+00:00 ny_times_covid_20201208.zip 2020-12-08T05:20:47.428000+00:00    

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