States

place_id Place Id	place_name Place Name	parent_place_id Parent Place Id	parent_place_name Parent Place Name	variable Variable	date Date	value Value	measurement_method Measurement Method	observation_period Observation Period	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
geoId/10	Delaware	country/USA	United States	dc/em06p1ltp38f5	2017	97155000			USEconomicCensus	census.gov	https://datacommons.org/browser/geoId/10?statVar=dc/em06p1ltp38f5
geoId/10	Delaware	country/USA	United States	dc/em06p1ltp38f5	2002	97124000			USEconomicCensus	census.gov	https://datacommons.org/browser/geoId/10?statVar=dc/em06p1ltp38f5
geoId/10	Delaware	country/USA	United States	CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent	2013-10	4	NFIPInsuranceClaims	P1M	USFEMA_FloodInsuranceClaims	fema.gov	https://datacommons.org/browser/geoId/10?statVar=CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent
geoId/10	Delaware	country/USA	United States	CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent	2012-09	2	NFIPInsuranceClaims	P1M	USFEMA_FloodInsuranceClaims	fema.gov	https://datacommons.org/browser/geoId/10?statVar=CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent
geoId/10	Delaware	country/USA	United States	CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent	1983-05	1	NFIPInsuranceClaims	P1M	USFEMA_FloodInsuranceClaims	fema.gov	https://datacommons.org/browser/geoId/10?statVar=CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent
geoId/10	Delaware	country/USA	United States	CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent	1996-06	1	NFIPInsuranceClaims	P1M	USFEMA_FloodInsuranceClaims	fema.gov	https://datacommons.org/browser/geoId/10?statVar=CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent
geoId/10	Delaware	country/USA	United States	CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent	1996-10	1	NFIPInsuranceClaims	P1M	USFEMA_FloodInsuranceClaims	fema.gov	https://datacommons.org/browser/geoId/10?statVar=CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent
geoId/10	Delaware	country/USA	United States	CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent	2010-03	6	NFIPInsuranceClaims	P1M	USFEMA_FloodInsuranceClaims	fema.gov	https://datacommons.org/browser/geoId/10?statVar=CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent
geoId/10	Delaware	country/USA	United States	CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent	2021-09	21	NFIPInsuranceClaims	P1M	USFEMA_FloodInsuranceClaims	fema.gov	https://datacommons.org/browser/geoId/10?statVar=CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent
geoId/10	Delaware	country/USA	United States	CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent	2016-02	3	NFIPInsuranceClaims	P1M	USFEMA_FloodInsuranceClaims	fema.gov	https://datacommons.org/browser/geoId/10?statVar=CountOfClaims_NaturalHazardInsurance_FEMALowRiskFloodZone_BuildingStructureAndContents_FloodEvent


CREATE TABLE delaware_geoid_10 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);