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

12 rows where "createdAt" is on date 2020-05-01

View and edit SQL

Suggested facets: project, ext, updatedAt (date)

createdAt (date)

  • 2020-05-01 · 12
Link project ext createdAt name updatedAt size etag
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2020-05-01T05:18:49.365000+00:00 jhu_covid_time_series_05_01_2020.zip 2020-05-01T05:18:49.365000+00:00    
COVID_Johns_Hopkins_daily_reports UHJvamVjdDowM2ZiMjA5NS03MzcxLTRjODEtOTMzNi05YTFiZGY2YWE2NDU= zip 2020-05-01T05:18:33.988000+00:00 jhu_covid_daily_05_01_2020.zip 2020-05-01T05:18:33.988000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-05-01T05:15:18.839000+00:00 covidtracking_05_01_2020.zip 2020-05-01T05:15:18.839000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-05-01T16:37:08.249000+00:00 covid_usafacts_2020_05_01.zip 2020-05-01T16:37:08.249000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-01T05:58:34.659000+00:00 Iowa_warn_raw.csv 2020-05-01T05:58:34.659000+00:00 34560 "31415e3df900a5464a9643101f7f038e"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= md 2020-05-01T07:05:36.482000+00:00 README.md 2020-05-01T07:05:36.482000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-01T05:10:49.281000+00:00 alaska_warn_processed.csv 2020-05-01T05:10:49.281000+00:00 5093 "2666f1edd052098a9284905164b91103"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-01T05:34:27.806000+00:00 arizona_warn_processed.csv 2020-05-01T05:34:27.806000+00:00 21630 "e52f04e2ba2d7025df9704eb5da64e70"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-01T06:15:47.834000+00:00 montana_warn_raw.csv 2020-05-01T06:15:47.834000+00:00 1397 "a3087c3e1737903fb5bf289fd0ff9d7f"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-01T02:29:14.744000+00:00 newmexico_warn_raw.csv 2020-05-01T02:29:14.744000+00:00 5110 "70891e704a269a8c0aca77391b6b94ba"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-01T00:43:33.923000+00:00 northcarolina_warn_processed.csv 2020-05-01T00:43:33.923000+00:00 77635 "e9b3e2ec1db52abc34682c72be632d23"
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2020-05-01T05:15:32.745000+00:00 ny_times_covid_05_01_2020.zip 2020-05-01T05:15:32.745000+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])
);