schools: enrollments: 2,505 rows where where grade = "pre_kindergarten_full_day", state = "NJ" and year = 2021 sorted by school_nces

Data source: Big Local News · About: Big Local

2,505 rows where grade = "pre_kindergarten_full_day", state = "NJ" and year = 2021 sorted by school_nces_id

Search:

descending

Link	rowid	state	county	county_state_id	admin_level	district_nces_id	district_state_id	district	school_nces_id ▼	school_state_id	school	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
2372052	2372052	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406014	10	Chatham High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372055	2372055	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406015	30	Chatham Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten_full_day	0.0	0
2372053	2372053	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	pre_kindergarten_full_day	0.0	0
2372056	2372056	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day	45.0	45
2372054	2372054	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day	0.0	0
2372057	2372057	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day	0.0	0
2372691	2372691	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	pre_kindergarten_full_day	0.0	0
2372690	2372690	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	pre_kindergarten_full_day	0.0	0
2370422	2370422	NJ	Atlantic	1	school	3400006	125	Atlantic County Special Services School District	340000600695	30	Atlantic County Elementary And Middle Schools	Special Education School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2370421	2370421	NJ	Atlantic	1	school	3400006	125	Atlantic County Special Services School District	340000600697	60	Atlantic County High School	Special Education School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2370715	2370715	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Commission School District	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	06	2021	pre_kindergarten_full_day	10.0	10
2370716	2370716	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Commission School District	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2370717	2370717	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Commission School District	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2021	pre_kindergarten_full_day	0.0	0
2372795	2372795	NJ	Warren	41	school	3400008	1785	Great Meadows Regional School District	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day	7.0	7
2372796	2372796	NJ	Warren	41	school	3400008	1785	Great Meadows Regional School District	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2021	pre_kindergarten_full_day	0.0	0
2372558	2372558	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional School District	340000900176	20	Bernards High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372557	2372557	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional School District	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2021	pre_kindergarten_full_day	1.0	1
2372559	2372559	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional School District	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2021	pre_kindergarten_full_day	0.0	0
2372875	2372875	NJ	Charters	80	school	3400014	6430	Englewood On The Palisades Charter School	340001400258	930	Englewood On The Palisades Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372900	2372900	NJ	Charters	80	school	3400015	7890	Teaneck Community Charter School	340001500259	920	Teaneck Community Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372889	2372889	NJ	Charters	80	school	3400019	7410	Chartertech High School For The Performing Arts	340001900269	940	Chartertech High School For The Performing Arts	Regular School	Yes	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372872	2372872	NJ	Charters	80	school	3400020	6320	Discovery Charter School	340002000282	920	Discovery Charter School	Regular School	Yes	Middle	04	08	2021	pre_kindergarten_full_day	0.0	0
2372873	2372873	NJ	Charters	80	school	3400021	6410	East Orange Community Charter School	340002100283	920	East Orange Community Charter School	Regular School	Yes	Elementary	KG	04	2021	pre_kindergarten_full_day	0.0	0
2372885	2372885	NJ	Charters	80	school	3400022	7210	Marion P. Thomas Charter School	340002200285	940	Marion P. Thomas Charter School	Regular School	Yes	Other	PK	12	2021	pre_kindergarten_full_day	0.0	0
2372886	2372886	NJ	Charters	80	school	3400023	7290	New Horizons Community Charter School	340002300287	957	New Horizons Community Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372887	2372887	NJ	Charters	80	school	3400024	7320	North Star Academy Charter School	340002400289	960	North Star Academy Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372896	2372896	NJ	Charters	80	school	3400025	7730	Robert Treat Academy Charter School	340002500291	970	Robert Treat Academy Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372897	2372897	NJ	Charters	80	school	3400026	7735	Maria L. Varisco-Rogers Charter School	340002600292	975	Maria Varisco Rogers Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372874	2372874	NJ	Charters	80	school	3400029	6420	Elysian Charter School	340002900297	925	Elysian Charter School Of Hoboken	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372878	2372878	NJ	Charters	80	school	3400032	6720	Hoboken Charter School	340003200302	930	Hoboken Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372881	2372881	NJ	Charters	80	school	3400033	6910	Jersey City Community Charter School	340003300303	940	Jersey City Community Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372882	2372882	NJ	Charters	80	school	3400034	6915	Jersey City Golden Door Charter School	340003400305	950	Jersey City Golden Door Charter School	Regular School	Yes	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2372884	2372884	NJ	Charters	80	school	3400035	7115	The Learning Community Charter School	340003500307	960	Learning Community Charter School	Regular School	Yes	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2372898	2372898	NJ	Charters	80	school	3400036	7830	Soaring Heights Charter School	340003600309	980	Soaring Heights Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372880	2372880	NJ	Charters	80	school	3400041	6810	International Charter School Of Trenton	340004100321	940	International Charter School	Regular School	Yes	Elementary	KG	04	2021	pre_kindergarten_full_day	0.0	0
2372890	2372890	NJ	Charters	80	school	3400042	7500	Pace Charter School Of Hamilton	340004200322	900	Pace Charter School Of Hamilton	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372892	2372892	NJ	Charters	80	school	3400043	7540	Princeton Charter School	340004300323	930	Princeton Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372911	2372911	NJ	Charters	80	school	3400046	8140	The Village Charter School	340004600329	990	The Village Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372876	2372876	NJ	Charters	80	school	3400047	6635	Greater Brunswick Charter School	340004700330	930	Greater Brunswick Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372825	2372825	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372894	2372894	NJ	Charters	80	school	3400049	7720	Red Bank Charter School	340004900336	915	Red Bank Charter School	Regular School	Yes	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2371561	2371561	NJ	Hunterdon	19	school	3400050	2308	Hunterdon County Vocational School District	340005000021	50	Hunterdon County Vocational School District Central Campus	Career and Technical School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2371563	2371563	NJ	Hunterdon	19	school	3400050	2308	Hunterdon County Vocational School District	340005000716	30	Hunterdon Polytech Bartles Corner Campus	Career and Technical School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2371562	2371562	NJ	Hunterdon	19	school	3400050	2308	Hunterdon County Vocational School District	340005003405	300	Hunterdon County Academies	Career and Technical School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372908	2372908	NJ	Charters	80	school	3400051	8050	Unity Charter School	340005100339	990	Unity Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372869	2372869	NJ	Charters	80	school	3400052	6230	Classical Academy Charter School Of Clifton	340005200351	915	Classical Academy Charter School Of Clifton	Regular School	Yes	Middle	06	08	2021	pre_kindergarten_full_day	0.0	0
2372899	2372899	NJ	Charters	80	school	3400055	7850	Sussex County Technology Charter School	340005500361	960	Sussex County Technology Charter School	Regular School	Yes	Middle	06	08	2021	pre_kindergarten_full_day	0.0	0
2372893	2372893	NJ	Charters	80	school	3400061	7600	The Queen City Academy Charter School District	340006100378	960	The Queen City Academy Charter School	Regular School	Yes	Other	KG	09	2021	pre_kindergarten_full_day	0.0	0
2372877	2372877	NJ	Charters	80	school	3400064	6665	Gray Charter School	340006400373	930	The Gray Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2371870	2371870	NJ	Monmouth	25	school	3400069	225	Bayshore Jointure Commission School District	340006900719	30	Developmental Learning Center	Special Education School	No	Other	PK	12	2021	pre_kindergarten_full_day	0.0	0
2372888	2372888	NJ	Charters	80	school	3400070	7325	Team Academy Charter School	340007000529	965	Team Academy Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372909	2372909	NJ	Charters	80	school	3400073	8060	University Academy Charter High School	340007300531	990	University Academy Charter High School	Regular School	Yes	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372879	2372879	NJ	Charters	80	school	3400076	6740	Hope Academy Charter School	340007600483	950	Hope Academy Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372883	2372883	NJ	Charters	80	school	3400078	7109	Leap Academy University Charter School	340007800487	931	Leap Academy University Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372870	2372870	NJ	Charters	80	school	3400079	6232	Environment Community Opportunity (Eco) Charter School	340007906129	920	Environment Community Opportunity (Eco) Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372871	2372871	NJ	Charters	80	school	3400080	6240	Freedom Prep Charter School	340008000566	900	Freedom Prep Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372895	2372895	NJ	Charters	80	school	3400082	7727	Ridge And Valley Charter School	340008200569	900	Ridge And Valley Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372907	2372907	NJ	Charters	80	school	3400083	8010	Union County Teams Charter School-High School/College La	340008300573	980	Union County Teams Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372910	2372910	NJ	Charters	80	school	3400084	8065	University Heights Charter School	340008400575	980	University Heights Charter School	Regular School	Yes	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2372891	2372891	NJ	Charters	80	school	3400087	7503	Paterson Charter School For Science And Technology	340008700735	970	Paterson Charter School For Science/Technology	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372828	2372828	NJ	Charters	80	school	3400090	6018	Central Jersey College Prep Charter School	340009000829	900	Central Jersey College Prep Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2370407	2370407	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	pre_kindergarten_full_day	0.0	0
2370408	2370408	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	pre_kindergarten_full_day	0.0	0
2371531	2371531	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	pre_kindergarten_full_day	0.0	0
2371532	2371532	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day	0.0	0
2372826	2372826	NJ	Charters	80	school	3400715	6013	Bergen Arts And Science Charter School	340071502923	900	Bergen Arts And Sciences Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372827	2372827	NJ	Charters	80	school	3400717	6017	Foundation Academy Charter School	340071702925	932	Foundation Academy Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372830	2372830	NJ	Charters	80	school	3400718	6021	Community Charter School Of Paterson	340071803014	905	Community Charter School Of Paterson	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372829	2372829	NJ	Charters	80	school	3400719	6020	Pride Academy Charter School District	340071903017	985	Pride Academy Charter School	Regular School	Yes	Middle	05	08	2021	pre_kindergarten_full_day	0.0	0
2372788	2372788	NJ	Warren	41	school	3400720	30	Allamuchy Township School District	340072003066	20	Mountain Villa School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten_full_day	13.0	13
2372787	2372787	NJ	Warren	41	school	3400720	30	Allamuchy Township School District	340072005788	10	Allamuchy Township School	Regular School	No	Middle	03	08	2021	pre_kindergarten_full_day	0.0	0
2372832	2372832	NJ	Charters	80	school	3400723	6025	Paul Robeson Charter School For The Humanities	340072303015	907	Paul Robeson Charter School For The Humanities	Regular School	Yes	Middle	03	08	2021	pre_kindergarten_full_day	0.0	0
2372831	2372831	NJ	Charters	80	school	3400724	6022	Burch Charter School Of Excellence	340072403011	990	Burch Charter School Of Excellence	Regular School	Yes	Elementary	KG	05	2021	pre_kindergarten_full_day	0.0	0
2372836	2372836	NJ	Charters	80	school	3400727	6030	The Ethical Community Charter School	340072703029	912	The Ethical Community Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372834	2372834	NJ	Charters	80	school	3400729	6028	Vineland Public Charter School	340072903027	910	Vineland Public Charter School	Regular School	Yes	Other	PK	11	2021	pre_kindergarten_full_day	0.0	0
2372835	2372835	NJ	Charters	80	school	3400730	6029	Newark Educators Community Charter School	340073003028	911	Newark Educators Community Charter School	Regular School	Yes	Elementary	PK	04	2021	pre_kindergarten_full_day	0.0	0
2372833	2372833	NJ	Charters	80	school	3400731	6026	Riverbank Charter School Of Excellence	340073103022	908	Riverbank Charter School Of Excellence	Regular School	Yes	Elementary	KG	03	2021	pre_kindergarten_full_day	0.0	0
2372839	2372839	NJ	Charters	80	school	3400734	6036	Hoboken Dual Language Charter School	340073403037	921	Hoboken Dual Language Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372840	2372840	NJ	Charters	80	school	3400735	6041	Hatikvah International Academy Charter School	340073503055	916	Hatikvah International Academy Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372838	2372838	NJ	Charters	80	school	3400740	6033	The Barack Obama Green Charter High School District	340074003047	902	The Barack Obama Green Charter High School	Regular School	Yes	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372837	2372837	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2021	pre_kindergarten_full_day	0.0	0
2372847	2372847	NJ	Charters	80	school	3400744	6076	Benjamin Banneker Preparatory Charter School	340074403139	961	Benjamin Banneker Preparatory Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372849	2372849	NJ	Charters	80	school	3400745	6080	Passaic Arts And Science Charter School	340074503137	966	Passaic Arts And Science Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372850	2372850	NJ	Charters	80	school	3400746	6081	Thomas Edison Energysmart Charter School	340074603143	967	Thomas Edison Energysmart Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372848	2372848	NJ	Charters	80	school	3400748	6079	John P Holland Charter School	340074803144	964	John P. Holland Charter School	Regular School	Yes	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2372846	2372846	NJ	Charters	80	school	3400749	6069	Millville Public Charter School	340074903184	952	Millville Public Charter School	Regular School	Yes	Other	KG	10	2021	pre_kindergarten_full_day	0.0	0
2370479	2370479	NJ	Bergen	3	school	3400750	40	Allendale Public School District	340075000224	10	Brookside School	Regular School	No	Middle	04	08	2021	pre_kindergarten_full_day	0.0	0
2370478	2370478	NJ	Bergen	3	school	3400750	40	Allendale Public School District	340075000226	20	Hillside Elementary School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day	18.0	18
2372841	2372841	NJ	Charters	80	school	3400751	6053	Great Oaks Legacy Charter School	340075103180	917	Great Oaks Legacy Charter School	Regular School	Yes	Other	PK	12	2021	pre_kindergarten_full_day	0.0	0
2372842	2372842	NJ	Charters	80	school	3400754	6057	Peoples Preparatory Charter School District	340075403181	938	Peoples Preparatory Charter School	Regular School	Yes	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372843	2372843	NJ	Charters	80	school	3400755	6058	Roseville Community Charter School	340075503187	939	Roseville Community Charter School	Regular School	Yes	Elementary	KG	04	2021	pre_kindergarten_full_day	0.0	0
2372845	2372845	NJ	Charters	80	school	3400756	6064	Dr Lena Edwards Academic Charter School	340075603185	946	Dr Lena Edwards Academic Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2372851	2372851	NJ	Charters	80	school	3400759	6082	Beloved Community Charter School	340075903196	963	Beloved Community Charter School	Regular School	Yes	Other	KG	10	2021	pre_kindergarten_full_day	0.0	0
2372852	2372852	NJ	Charters	80	school	3400763	6086	Hope Community Charter School	340076303247	972	Hope Community Charter School	Regular School	Yes	Elementary	KG	06	2021	pre_kindergarten_full_day	0.0	0
2372855	2372855	NJ	Charters	80	school	3400764	6094	Phillip'S Academy Charter School	340076403256	968	Philip'S Academy Charter School	Regular School	Yes	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2372856	2372856	NJ	Charters	80	school	3400765	6096	Paterson Arts And Science Charter School	340076503254	982	Paterson Arts And Science Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_full_day	0.0	0
2372853	2372853	NJ	Charters	80	school	3400766	6089	Compass Academy Charter School	340076603265	976	Compass Academy Charter School	Regular School	Yes	Elementary	PK	05	2021	pre_kindergarten_full_day	0.0	0
2372854	2372854	NJ	Charters	80	school	3400767	6093	Jersey City Global Charter School	340076703251	981	Jersey City Global Charter School	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2371546	2371546	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903010	20	Lambertville Public School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten_full_day	0.0	0
2371547	2371547	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903036	50	South Hunterdon Regional High School	Regular School	No	High	07	12	2021	pre_kindergarten_full_day	0.0	0

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);