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

10 rows where "createdAt" is on date 2020-05-10

View and edit SQL

Suggested facets: project, ext, updatedAt (date)

createdAt (date)

  • 2020-05-10 · 10
Link project ext createdAt name updatedAt size etag
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2020-05-10T05:19:19.924000+00:00 jhu_covid_time_series_05_10_2020.zip 2020-05-10T05:19:19.924000+00:00    
COVID_Johns_Hopkins_daily_reports UHJvamVjdDowM2ZiMjA5NS03MzcxLTRjODEtOTMzNi05YTFiZGY2YWE2NDU= zip 2020-05-10T05:18:36.874000+00:00 jhu_covid_daily_05_10_2020.zip 2020-05-10T05:18:36.874000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-05-10T05:15:18.511000+00:00 covidtracking_05_10_2020.zip 2020-05-10T05:15:18.511000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-10T09:18:48.320000+00:00 Colorado_warn_raw.csv 2020-05-10T09:18:48.320000+00:00 42191 "a28992e80defa3f947acf6ea2baf6d97"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-10T09:49:55.317000+00:00 Connecticut_warn_raw.csv 2020-05-10T09:49:55.317000+00:00 33172 "937e6c59ed862ca355b510a356036e79"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-10T10:14:30.861000+00:00 Idaho_warn_raw.csv 2020-05-10T10:14:30.861000+00:00 13373 "e13ea161329d3297eab60a377022fcb4"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-10T10:38:03.271000+00:00 Illinois_warn_raw.csv 2020-05-10T10:38:03.271000+00:00 50149 "a203e0e25f9250f8245fb5452168a93d"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= md 2020-05-10T10:40:38.644000+00:00 WARN_layout.md 2020-05-10T10:40:38.644000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-10T09:59:01.589000+00:00 georgia_warn_raw.csv 2020-05-10T09:59:01.589000+00:00 263839 "74e931b8c21631c1f3622b4185c95888"
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2020-05-10T05:15:31.104000+00:00 ny_times_covid_05_10_2020.zip 2020-05-10T05:15:31.104000+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])
);