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

6 rows where "createdAt" is on date 2020-10-01 and ext = "zip"

View and edit SQL

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

Link project ext createdAt name updatedAt size etag
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2020-10-01T05:30:41.279000+00:00 jhu_covid_time_series_20201001.zip 2020-10-01T05:30:41.279000+00:00    
CMS-Nursing-Home-Full-Deficiencies UHJvamVjdDo1ZDlhNThmNy0wYTEzLTRlNzgtODk0OC1lNTBhM2I0NjMyNjY= zip 2020-10-01T16:05:42.614000+00:00 cms_national.zip 2020-10-01T16:05:42.614000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-10-01T05:15:47.207000+00:00 covidtracking_20201001.zip 2020-10-01T05:15:47.207000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-10-01T05:14:06.028000+00:00 covid_usafacts_2020_09_30.zip 2020-10-01T05:14:06.028000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-10-01T20:06:07.442000+00:00 covid_usafacts_2020_10_01.zip 2020-10-01T20:06:07.442000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2020-10-01T05:20:37.713000+00:00 ny_times_covid_20201001.zip 2020-10-01T05:20:37.713000+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])
);