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/15	Hawaii	country/USA	United States	Median_AssessmentScore_Student_CharterNo_SchoolGrade8_Mathematics_MeasurementScale	2022	269.8695007	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Median_AssessmentScore_Student_CharterNo_SchoolGrade8_Mathematics_MeasurementScale
geoId/15	Hawaii	country/USA	United States	Median_AssessmentScore_Student_CharterNo_SchoolGrade8_Mathematics_MeasurementScale	2019	276.1869995	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Median_AssessmentScore_Student_CharterNo_SchoolGrade8_Mathematics_MeasurementScale
geoId/15	Hawaii	country/USA	United States	Median_AssessmentScore_Student_CharterNo_SchoolGrade8_Mathematics_MeasurementScale	2017	277.8399994	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Median_AssessmentScore_Student_CharterNo_SchoolGrade8_Mathematics_MeasurementScale
geoId/15	Hawaii	country/USA	United States	Median_AssessmentScore_Student_SchoolGrade8_Reading_GainInformationEvaluationScale	2017	266.3150024	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Median_AssessmentScore_Student_SchoolGrade8_Reading_GainInformationEvaluationScale
geoId/15	Hawaii	country/USA	United States	Median_AssessmentScore_Student_SchoolGrade8_Reading_GainInformationEvaluationScale	2019	264.0434998	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Median_AssessmentScore_Student_SchoolGrade8_Reading_GainInformationEvaluationScale
geoId/15	Hawaii	country/USA	United States	Median_AssessmentScore_Student_SchoolGrade8_Reading_GainInformationEvaluationScale	2022	265.2450027	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Median_AssessmentScore_Student_SchoolGrade8_Reading_GainInformationEvaluationScale
geoId/15	Hawaii	country/USA	United States	Percent_NAEP_CumulativeBelowBasic_In_Count_Student_HispanicOrLatino_SchoolGrade8_Mathematics	2017	40.5574895	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Percent_NAEP_CumulativeBelowBasic_In_Count_Student_HispanicOrLatino_SchoolGrade8_Mathematics
geoId/15	Hawaii	country/USA	United States	Percent_NAEP_CumulativeBelowBasic_In_Count_Student_HispanicOrLatino_SchoolGrade8_Mathematics	2022	49.15591554	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Percent_NAEP_CumulativeBelowBasic_In_Count_Student_HispanicOrLatino_SchoolGrade8_Mathematics
geoId/15	Hawaii	country/USA	United States	Percent_NAEP_CumulativeBelowBasic_In_Count_Student_HispanicOrLatino_SchoolGrade8_Mathematics	2019	34.37478846	NCES_NationalAssessmentOfEducationalProgress		NCES_NationsReportCard	ed.gov	https://datacommons.org/browser/geoId/15?statVar=Percent_NAEP_CumulativeBelowBasic_In_Count_Student_HispanicOrLatino_SchoolGrade8_Mathematics
geoId/15	Hawaii	country/USA	United States	dc/hy2s283ffp9m1	2015	94.4		P1Y	CensusSAHIE	census.gov	https://datacommons.org/browser/geoId/15?statVar=dc/hy2s283ffp9m1


CREATE TABLE hawaii_geoid_15 (
  "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
);