schools: enrollments: 2,502 rows where where grade = "pre_kindergarten_half_day", state = "NJ" and year = 2020 sorted by school_nces

Data source: Big Local News · About: Big Local

2,502 rows where grade = "pre_kindergarten_half_day", state = "NJ" and year = 2020 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
2480470	2480470	NJ	Charters	80	school	3400070	7325	Team Academy Charter School	340007000529	965	Team Academy Charter School	Regular School	Yes	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480491	2480491	NJ	Charters	80	school	3400073	8060	University Academy Cs	340007300531	990	University Academy Charter High School	Regular School	Yes	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2480461	2480461	NJ	Charters	80	school	3400076	6740	Hope Academy Cs	340007600483	950	Hope Academy Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480465	2480465	NJ	Charters	80	school	3400078	7109	Leap Academy University Cs	340007800487	931	Leap Academy University Charter School	Regular School	Yes	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480452	2480452	NJ	Charters	80	school	3400079	6232	Environment Community Cs	340007906129	920	Environment Community Opportunity (Eco) Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480453	2480453	NJ	Charters	80	school	3400080	6240	Freedom Prep Charter School	340008000566	900	Freedom Prep Charter School	Regular School	Yes	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480477	2480477	NJ	Charters	80	school	3400082	7727	Ridge And Valley Cs	340008200569	900	Ridge And Valley Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480489	2480489	NJ	Charters	80	school	3400083	8010	Union County Teams Cs	340008300573	980	Union County Teams Charter School	Regular School	Yes	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480492	2480492	NJ	Charters	80	school	3400084	8065	University Heights Cs	340008400575	980	University Heights Charter School	Regular School	Yes	Elementary	PK	08	2020	pre_kindergarten_half_day	120.0	120
2480473	2480473	NJ	Charters	80	school	3400087	7503	Paterson Cs For Sci/Tech	340008700735	970	Paterson Charter School For Science/Technology	Regular School	Yes	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480409	2480409	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	2020	pre_kindergarten_half_day	0.0	0
2477992	2477992	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	pre_kindergarten_half_day	0.0	0
2477993	2477993	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_half_day	62.0	62
2479111	2479111	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	pre_kindergarten_half_day	0.0	0
2479112	2479112	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	pre_kindergarten_half_day	37.0	37
2480407	2480407	NJ	Charters	80	school	3400715	6013	Bergen Arts And Sciences Charter School	340071502923	900	Bergen Arts And Sciences Charter School	Regular School	Yes	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480408	2480408	NJ	Charters	80	school	3400717	6017	Foundation Academy Cs	340071702925	932	Foundation Academy Charter School	Regular School	Yes	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480411	2480411	NJ	Charters	80	school	3400718	6021	Community Charter School Of Paterso	340071803014	905	Community Charter School Of Paterson	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480410	2480410	NJ	Charters	80	school	3400719	6020	Pride Academy Charter School	340071903017	985	Pride Academy Charter School	Regular School	Yes	Middle	05	08	2020	pre_kindergarten_half_day	0.0	0
2480369	2480369	NJ	Warren	41	school	3400720	30	Allamuchy Twp	340072003066	20	Mountain Villa School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten_half_day	0.0	0
2480368	2480368	NJ	Warren	41	school	3400720	30	Allamuchy Twp	340072005788	10	Allamuchy Township School	Regular School	No	Middle	03	08	2020	pre_kindergarten_half_day	0.0	0
2480413	2480413	NJ	Charters	80	school	3400723	6025	Paul Robeson Humanities Charter School	340072303015	907	Paul Robeson Charter School For The Humanities	Regular School	Yes	Middle	04	08	2020	pre_kindergarten_half_day	0.0	0
2480412	2480412	NJ	Charters	80	school	3400724	6022	Burch Charter School Of Excellence	340072403011	990	Burch Charter School Of Excellence	Regular School	Yes	Elementary	KG	05	2020	pre_kindergarten_half_day	0.0	0
2480417	2480417	NJ	Charters	80	school	3400727	6030	The Ethical Community Charter School	340072703029	912	The Ethical Community Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480415	2480415	NJ	Charters	80	school	3400729	6028	Vineland Public Charter School	340072903027	910	Vineland Public Charter School	Regular School	Yes	Other	PK	11	2020	pre_kindergarten_half_day	34.0	34
2480416	2480416	NJ	Charters	80	school	3400730	6029	Newark Educators Community Charter School	340073003028	911	Newark Educators Community Charter School	Regular School	Yes	Elementary	PK	04	2020	pre_kindergarten_half_day	41.0	41
2480414	2480414	NJ	Charters	80	school	3400731	6026	Riverbank Charter School Of Excelle	340073103022	908	Riverbank Charter School Of Excellence	Regular School	Yes	Elementary	KG	03	2020	pre_kindergarten_half_day	0.0	0
2480420	2480420	NJ	Charters	80	school	3400734	6036	Hola Hoboken Dual Lang Cs	340073403037	921	Hoboken Dual Language Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480421	2480421	NJ	Charters	80	school	3400735	6041	Hatikvah International Cs	340073503055	916	Hatikvah International Academy Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480419	2480419	NJ	Charters	80	school	3400740	6033	The Barack Obama Green Charter High School	340074003047	902	The Barack Obama Green Charter High School	Regular School	Yes	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2480418	2480418	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	2020	pre_kindergarten_half_day	0.0	0
2480429	2480429	NJ	Charters	80	school	3400744	6076	Benjamin Banneker Prep Cs	340074403139	961	Benjamin Banneker Preparatory Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480431	2480431	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	2020	pre_kindergarten_half_day	0.0	0
2480432	2480432	NJ	Charters	80	school	3400746	6081	Thomas Edison Energysmart Charter School	340074603143	967	Thomas Edison Energysmart Charter School	Regular School	Yes	Other	KG	11	2020	pre_kindergarten_half_day	0.0	0
2480430	2480430	NJ	Charters	80	school	3400748	6079	John P Holland Charter School	340074803144	964	John P. Holland Charter School	Regular School	Yes	Elementary	PK	08	2020	pre_kindergarten_half_day	88.0	88
2480428	2480428	NJ	Charters	80	school	3400749	6069	Millville Public Charter School	340074903184	952	Millville Public Charter School	Regular School	Yes	Other	KG	10	2020	pre_kindergarten_half_day	0.0	0
2478064	2478064	NJ	Bergen	3	school	3400750	40	Allendale Boro	340075000224	10	Brookside School	Regular School	No	Middle	04	08	2020	pre_kindergarten_half_day	0.0	0
2478065	2478065	NJ	Bergen	3	school	3400750	40	Allendale Boro	340075000226	20	Hillside Elementary School	Regular School	No	Elementary	PK	03	2020	pre_kindergarten_half_day	0.0	0
2480422	2480422	NJ	Charters	80	school	3400751	6053	Great Oaks Legacy Charter School	340075103180	917	Great Oaks Legacy Charter School	Regular School	Yes	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2480427	2480427	NJ	Charters	80	school	3400753	6068	M E T S Charter School	340075303183	951	M.E.T.S. Charter School	Regular School	Yes	High	06	12	2020	pre_kindergarten_half_day	0.0	0
2480423	2480423	NJ	Charters	80	school	3400754	6057	Peoples Preparatory Charter School	340075403181	938	Peoples Preparatory Charter School	Regular School	Yes	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2480424	2480424	NJ	Charters	80	school	3400755	6058	Roseville Community Cs	340075503187	939	Roseville Community Charter School	Regular School	Yes	Elementary	KG	04	2020	pre_kindergarten_half_day	0.0	0
2480426	2480426	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	2020	pre_kindergarten_half_day	0.0	0
2480433	2480433	NJ	Charters	80	school	3400759	6082	Beloved Community Charter School	340075903196	963	Beloved Community Charter School	Regular School	Yes	Other	KG	09	2020	pre_kindergarten_half_day	0.0	0
2480434	2480434	NJ	Charters	80	school	3400763	6086	Hope Community Cs	340076303247	972	Hope Community Charter School	Regular School	Yes	Elementary	KG	05	2020	pre_kindergarten_half_day	0.0	0
2480437	2480437	NJ	Charters	80	school	3400764	6094	Phillip'S Academy Charter School	340076403256	968	Philip'S Academy Charter School	Regular School	Yes	Elementary	PK	08	2020	pre_kindergarten_half_day	60.0	60
2480438	2480438	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	11	2020	pre_kindergarten_half_day	0.0	0
2480435	2480435	NJ	Charters	80	school	3400766	6089	Compass Academy Cs	340076603265	976	Compass Academy Charter School	Regular School	Yes	Elementary	KG	05	2020	pre_kindergarten_half_day	0.0	0
2480436	2480436	NJ	Charters	80	school	3400767	6093	Jersey City Global Cs	340076703251	981	Jersey City Global Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2479125	2479125	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903010	20	Lambertville Public School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_half_day	29.0	29
2479127	2479127	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903036	50	South Hunterdon Regional High School	Regular School	No	High	07	12	2020	pre_kindergarten_half_day	0.0	0
2479126	2479126	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903048	30	West Amwell Township School	Regular School	No	Elementary	KG	06	2020	pre_kindergarten_half_day	0.0	0
2480450	2480450	NJ	Charters	80	school	3400770	6183	Trenton Stem-To-Civics Cs	340077003291	914	Trenton Stem-To-Civics Charter School	Regular School	Yes	High	06	12	2020	pre_kindergarten_half_day	0.0	0
2480425	2480425	NJ	Charters	80	school	3400771	6060	Atlantic Community Charter School	340077103287	942	Atlantic Community Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2478554	2478554	NJ	Camden	7	school	3400772	1802	Mastery Schools Of Camden, Inc.	340077203313	112	Mastery Schools Of Camden Inc.	Regular School	No	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480439	2480439	NJ	Charters	80	school	3400773	6099	Link Community Charter School	340077303275	986	Link Community Charter School	Regular School	Yes	Middle	05	08	2020	pre_kindergarten_half_day	0.0	0
2478553	2478553	NJ	Camden	7	school	3400776	1801	Camden Prep, Inc.	340077603299	113	Camden Prep Inc.	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2478552	2478552	NJ	Camden	7	school	3400777	1799	Kipp: Cooper Norcross, A New Jersey Nonprofit Corporation	340077703307	111	Kipp: Cooper Norcross A New Jersey Nonprofit Corporation	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2479170	2479170	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2479171	2479171	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803377	300	Marie H Katzenbach Elementary/ Middle School For The Deaf	Special Education School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	2.0	2
2480441	2480441	NJ	Charters	80	school	3400779	6101	College Achieve Central Charter School	340077903353	992	College Achieve Central Charter School	Regular School	Yes	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480443	2480443	NJ	Charters	80	school	3400781	6103	Empowerment Academy Charter School	340078103335	994	Empowerment Academy Charter School	Regular School	Yes	Elementary	KG	05	2020	pre_kindergarten_half_day	0.0	0
2480440	2480440	NJ	Charters	80	school	3400782	6100	Bridgeton Public Charter School	340078203371	991	Bridgeton Public Charter School	Regular School	Yes	Elementary	KG	04	2020	pre_kindergarten_half_day	0.0	0
2480444	2480444	NJ	Charters	80	school	3400783	6104	Principle Academy Charter School	340078303345	995	Principle Academy Charter School	Regular School	Yes	Elementary	KG	06	2020	pre_kindergarten_half_day	0.0	0
2480446	2480446	NJ	Charters	80	school	3400784	6106	Philip’S Charter School Of Paterson	340078403383	997	Philip'S Academy Charter School Of Paterson	Regular School	Yes	Elementary	KG	03	2020	pre_kindergarten_half_day	0.0	0
2480447	2480447	NJ	Charters	80	school	3400785	6107	Camden’S Promise Charter School	340078503390	998	Camden'S Promise Charter School	Regular School	Yes	Other	PK	12	2020	pre_kindergarten_half_day	60.0	60
2480442	2480442	NJ	Charters	80	school	3400786	6102	Cresthaven Academy Charter School	340078603385	993	Cresthaven Academy Charter School	Regular School	Yes	Elementary	KG	03	2020	pre_kindergarten_half_day	0.0	0
2480445	2480445	NJ	Charters	80	school	3400787	6105	Hudson Arts And Science Charter School	340078703387	996	Hudson Arts And Science Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480448	2480448	NJ	Charters	80	school	3400788	6109	Lead Charter School	340078803423	953	Lead Charter School	Regular School	Yes	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2480485	2480485	NJ	Charters	80	school	3400789	7893	Ocean Academy Charter School	340078903411	918	Ocean Academy Charter School	Regular School	Yes	Elementary	KG	04	2020	pre_kindergarten_half_day	0.0	0
2480483	2480483	NJ	Charters	80	school	3400791	7891	College Achieve Greater Asbury Park Charter School	340079103403	904	College Achieve Greater Asbury Park Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480449	2480449	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	pre_kindergarten_half_day	0.0	0
2480484	2480484	NJ	Charters	80	school	3400793	7892	College Achieve Paterson Charter School	340079303413	909	College Achieve Paterson Charter School	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480486	2480486	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	pre_kindergarten_half_day	0.0	0
2480487	2480487	NJ	Charters	80	school	3400795	7896	Middlesex Charter School	340079503451	923	Middlesex County Stem Charter School	Regular School	Yes	Elementary	KG	03	2020	pre_kindergarten_half_day	0.0	0
2480488	2480488	NJ	Charters	80	school	3400805	7897	Creativity Colaboratory Charter School	340080503481	923	Creativity Colaboratory Charter School	Regular School	Yes	Middle	05	08	2020	pre_kindergarten_half_day	0.0	0
2480037	2480037	NJ	Salem	33	school	3400810	60	Alloway Twp	340081005028	20	Alloway Township School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	0.0	0
2480370	2480370	NJ	Warren	41	school	3400840	70	Alpha Boro	340084005790	10	Alpha Borough School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	5.0	5
2478066	2478066	NJ	Bergen	3	school	3400870	80	Alpine Boro	340087000228	10	Alpine Elementary School	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2480152	2480152	NJ	Sussex	37	school	3400900	90	Andover Reg	340090005324	10	Florence M. Burd	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_half_day	12.0	12
2480153	2480153	NJ	Sussex	37	school	3400900	90	Andover Reg	340090005326	40	Long Pond School	Regular School	No	Middle	05	08	2020	pre_kindergarten_half_day	0.0	0
2479447	2479447	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093000157	100	Thurgood Marshall Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_half_day	56.0	56
2479444	2479444	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003301	20	Barack Obama Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_half_day	46.0	46
2479443	2479443	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003732	10	Asbury Park High School	Regular School	No	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2479445	2479445	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003740	40	Bradley Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_half_day	70.0	70
2479446	2479446	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003742	70	Dr. Martin Luther King Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_half_day	0.0	0
2477994	2477994	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000010	10	Atlantic City High School	Regular School	No	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2477995	2477995	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000012	30	Sovereign Avenue School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	73.0	73
2477996	2477996	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000016	50	Chelsea Heights School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	49.0	49
2477997	2477997	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000018	60	Texas Avenue School	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_half_day	0.0	0
2477998	2477998	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000020	70	New York Avenue School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	44.0	44
2477999	2477999	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000022	80	Uptown School Complex	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	59.0	59
2478000	2478000	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000026	100	Pennsylvania Ave School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	74.0	74
2478001	2478001	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000028	120	Richmond Avenue School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	59.0	59
2478002	2478002	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000030	130	Venice Park School	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	30.0	30
2478003	2478003	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000032	140	Dr Martin Luther King Jr School Complex	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day	55.0	55
2478004	2478004	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096003259	300	Brighton Avenue School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_half_day	59.0	59
2478005	2478005	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099000034	10	Atlantic County Institute Of Technology	Career and Technical School	No	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2478006	2478006	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	pre_kindergarten_half_day	0.0	0
2479448	2479448	NJ	Monmouth	25	school	3401020	130	Atlantic Highlands Boro	340102003746	20	Atlantic Highlands Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_half_day	34.0	34

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