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

6 rows where project = "UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE="

View and edit SQL

Suggested facets: ext, createdAt (date), updatedAt (date)

Link project ext createdAt name updatedAt size etag
COVID_HospitalBeds_CountyDemographics_NursingHomes UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE= csv 2020-03-20T11:26:06.374000+00:00 2018_county_census.csv 2020-03-20T11:26:06.374000+00:00 504921 "7a973576c2ac1b5b05037a6837216bcb"
COVID_HospitalBeds_CountyDemographics_NursingHomes UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE= pdf 2020-03-19T01:03:11.524000+00:00 README.pdf 2020-03-19T01:03:11.524000+00:00    
COVID_HospitalBeds_CountyDemographics_NursingHomes UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE= zip 2020-03-20T11:27:20.010000+00:00 counties_geo.zip 2020-03-20T11:27:20.010000+00:00    
COVID_HospitalBeds_CountyDemographics_NursingHomes UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE= zip 2020-03-19T00:41:37.464000+00:00 hosp_geo.zip 2020-03-19T00:41:37.464000+00:00    
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"

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])
);