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

13 rows where "createdAt" is on date 2020-04-30

View and edit SQL

Suggested facets: project, ext, updatedAt (date)

createdAt (date)

  • 2020-04-30 · 13
Link project ext createdAt name updatedAt size etag
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2020-04-30T05:18:21.974000+00:00 jhu_covid_time_series_04_30_2020.zip 2020-04-30T05:18:21.974000+00:00    
COVID_Johns_Hopkins_daily_reports UHJvamVjdDowM2ZiMjA5NS03MzcxLTRjODEtOTMzNi05YTFiZGY2YWE2NDU= zip 2020-04-30T05:18:06.019000+00:00 jhu_covid_daily_04_30_2020.zip 2020-04-30T05:18:06.019000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-04-30T05:15:19.274000+00:00 covidtracking_04_30_2020.zip 2020-04-30T05:15:19.274000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-04-30T15:16:48.843000+00:00 covid_usafacts_2020_04_30.zip 2020-04-30T15:16:48.843000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= pdf 2020-04-30T19:56:05.995000+00:00 Illinois_WARN_99-2019.pdf 2020-04-30T19:56:05.995000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= pdf 2020-04-30T19:55:21.068000+00:00 Illinois_warn_2019-2020.pdf 2020-04-30T19:55:21.068000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= md 2020-04-30T16:56:23.059000+00:00 README_california_warn_expanded.md 2020-04-30T16:56:23.059000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-04-30T20:15:22.458000+00:00 indiana_warn_processed.csv 2020-04-30T20:15:22.458000+00:00 117530 "369a81546ed4248a17cd1a00af68f09e"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-04-30T20:19:27.928000+00:00 kentucky_warn_1998-2016_processed.csv 2020-04-30T20:19:27.928000+00:00 28475101 "eef5f3f175a465f7b6cc4549a7129ecc"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-04-30T09:31:59.167000+00:00 louisiana_warn_processed.csv 2020-04-30T09:31:59.167000+00:00 75785 "cec8b9495e01078bdc5ce122fb0e7c31"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-04-30T09:31:36.131000+00:00 louisiana_warn_raw.csv 2020-04-30T09:31:36.131000+00:00 47140 "d07ec3f052dc3d776ab92e7c8bbdc978"
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= pdf 2020-04-30T23:45:53.976000+00:00 minnesota_warn.pdf 2020-04-30T23:45:53.976000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2020-04-30T05:15:31.790000+00:00 ny_times_covid_04_30_2020.zip 2020-04-30T05:15:31.790000+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])
);