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

7 rows where "createdAt" is on date 2020-03-18

View and edit SQL

Suggested facets: project, ext, updatedAt (date)

createdAt (date)

  • 2020-03-18 · 7
Link project ext createdAt name updatedAt size etag
COVID_HospitalBeds_CountyDemographics_NursingHomes UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE= csv 2020-03-18T23:49:26.220000+00:00 hospital_data.csv 2020-03-18T23:49:26.220000+00:00 1683948 "61489f0c8cadf960c64256acdae71fd1"
COVID_HospitalBeds_CountyDemographics_NursingHomes UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE= csv 2020-03-18T23:49:26.222000+00:00 nh_gen_info_geocoded_final.csv 2020-03-18T23:49:26.222000+00:00 9501796 "122364197f4c79762351917fa5a26991"
COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= pdf 2020-03-18T23:39:44.874000+00:00 SVI2018Documentation.pdf 2020-03-18T23:39:44.874000+00:00    
COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= csv 2020-03-18T23:40:26.279000+00:00 SVI2018_US.csv 2020-03-18T23:40:26.279000+00:00 44704458 "34dc9bc76fc77f227af4d4ffe4e69c15"
COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= zip 2020-03-18T23:41:26.907000+00:00 SVI2018_US.zip 2020-03-18T23:41:26.907000+00:00    
COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= csv 2020-03-18T23:40:02.307000+00:00 SVI2018_US_COUNTY.csv 2020-03-18T23:40:02.307000+00:00 1885419 "01ce905c04ddf3b7bff299f0dbc05543"
COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= zip 2020-03-18T23:40:32.915000+00:00 SVI2018_US_COUNTY.zip 2020-03-18T23:40:32.915000+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])
);