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

14 rows where "createdAt" is on date 2020-05-11

View and edit SQL

Suggested facets: project, ext, name, updatedAt (date)

createdAt (date)

  • 2020-05-11 · 14
Link project ext createdAt name updatedAt size etag
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= pdf 2020-05-11T22:52:36.869000+00:00 Comparison of COVID-19 data - Source-OpenNews.pdf 2020-05-11T22:52:36.869000+00:00    
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2020-05-11T05:19:06.146000+00:00 jhu_covid_time_series_05_11_2020.zip 2020-05-11T05:19:06.146000+00:00    
AHA_Staffing UHJvamVjdDo2YjJiYjVhOS00OTAzLTRkMDItYTU4MS00NjI0NzIyNTFkNmQ= pdf 2020-05-11T22:46:26.360000+00:00 README.pdf 2020-05-11T22:46:26.360000+00:00    
COVID_Johns_Hopkins_daily_reports UHJvamVjdDowM2ZiMjA5NS03MzcxLTRjODEtOTMzNi05YTFiZGY2YWE2NDU= pdf 2020-05-11T22:52:55.377000+00:00 Comparison of COVID-19 data - Source-OpenNews.pdf 2020-05-11T22:52:55.377000+00:00    
COVID_Johns_Hopkins_daily_reports UHJvamVjdDowM2ZiMjA5NS03MzcxLTRjODEtOTMzNi05YTFiZGY2YWE2NDU= zip 2020-05-11T05:18:30.244000+00:00 jhu_covid_daily_05_11_2020.zip 2020-05-11T05:18:30.244000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= pdf 2020-05-11T22:54:01.355000+00:00 Comparison of COVID-19 data - Source-OpenNews.pdf 2020-05-11T22:54:01.355000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-05-11T05:15:27.619000+00:00 covidtracking_05_11_2020.zip 2020-05-11T05:15:27.619000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= pdf 2020-05-11T22:53:26.750000+00:00 Comparison of COVID-19 data - Source-OpenNews.pdf 2020-05-11T22:53:26.750000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-05-11T16:48:12.965000+00:00 covid_usafacts_2020_05_09.zip 2020-05-11T16:48:12.965000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-05-11T16:48:14.196000+00:00 covid_usafacts_2020_05_10.zip 2020-05-11T16:48:14.196000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-05-11T16:48:15.559000+00:00 covid_usafacts_2020_05_11.zip 2020-05-11T16:48:15.559000+00:00    
COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= csv 2020-05-11T04:58:51.703000+00:00 kentucky_warn_processed.csv 2020-05-11T04:58:51.703000+00:00 154782 "85131889778348a516fa6b49d9f65914"
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= pdf 2020-05-11T22:53:09.209000+00:00 Comparison of COVID-19 data - Source-OpenNews.pdf 2020-05-11T22:53:09.209000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2020-05-11T05:15:47.347000+00:00 ny_times_covid_05_11_2020.zip 2020-05-11T05:15:47.347000+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])
);