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

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

View and edit SQL

Suggested facets: project, ext, updatedAt (date)

createdAt (date)

  • 2020-05-08 · 11
Link project ext createdAt name updatedAt size etag
Johns Hopkins COVID data - time series UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= zip 2020-05-08T05:18:35.333000+00:00 jhu_covid_time_series_05_08_2020.zip 2020-05-08T05:18:35.333000+00:00    
AHA_Staffing UHJvamVjdDo2YjJiYjVhOS00OTAzLTRkMDItYTU4MS00NjI0NzIyNTFkNmQ= csv 2020-05-08T23:34:45.560000+00:00 aha2018staffing_cbsa.csv 2020-05-08T23:34:45.560000+00:00 48514 "6c6cde6a684967b0e7b1f3748af5bde2"
AHA_Staffing UHJvamVjdDo2YjJiYjVhOS00OTAzLTRkMDItYTU4MS00NjI0NzIyNTFkNmQ= csv 2020-05-08T23:34:45.130000+00:00 aha2018staffing_state.csv 2020-05-08T23:34:45.130000+00:00 7034 "6dd0ec9fc02c46923a486a152739e673"
AHA_Staffing UHJvamVjdDo2YjJiYjVhOS00OTAzLTRkMDItYTU4MS00NjI0NzIyNTFkNmQ= zip 2020-05-08T23:50:17.286000+00:00 aha_staffing_allfiles.zip 2020-05-08T23:50:17.286000+00:00    
AHA_Staffing UHJvamVjdDo2YjJiYjVhOS00OTAzLTRkMDItYTU4MS00NjI0NzIyNTFkNmQ= csv 2020-05-08T23:34:31.277000+00:00 pop2018_cbsa.csv 2020-05-08T23:34:31.277000+00:00 144733 "571869e6450c3e5903bbbfaf4fd059a8"
AHA_Staffing UHJvamVjdDo2YjJiYjVhOS00OTAzLTRkMDItYTU4MS00NjI0NzIyNTFkNmQ= csv 2020-05-08T23:34:32.170000+00:00 pop2018_state.csv 2020-05-08T23:34:32.170000+00:00 7618 "1dbee40129fe7fc132b1ab99be64eb3b"
COVID_Johns_Hopkins_daily_reports UHJvamVjdDowM2ZiMjA5NS03MzcxLTRjODEtOTMzNi05YTFiZGY2YWE2NDU= zip 2020-05-08T05:18:16.486000+00:00 jhu_covid_daily_05_08_2020.zip 2020-05-08T05:18:16.486000+00:00    
COVIDtracking data archive UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= zip 2020-05-08T05:15:15.536000+00:00 covidtracking_05_08_2020.zip 2020-05-08T05:15:15.536000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-05-08T17:08:49.955000+00:00 covid_usafacts_2020_05_07.zip 2020-05-08T17:08:49.955000+00:00    
COVID_USAFacts_county_cases UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= zip 2020-05-08T17:08:51.256000+00:00 covid_usafacts_2020_05_08.zip 2020-05-08T17:08:51.256000+00:00    
New York Times COVID data UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= zip 2020-05-08T05:15:28.025000+00:00 ny_times_covid_05_08_2020.zip 2020-05-08T05:15:28.025000+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])
);