schools: enrollments: 5,007 rows where where grade = "pre_kindergarten_half_day" and state = "NJ" sorted by ccd_school

Data source: Big Local News · About: Big Local

5,007 rows where grade = "pre_kindergarten_half_day" and state = "NJ" sorted by ccd_school_lvl descending

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
2479793	2479793	NJ	Ocean	29	school	3402220	530	Brick Twp	340222000166	27	Warren H. Wolf Early Childhood Development Center	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	258.0	258
2479835	2479835	NJ	Ocean	29	school	3408700	2690	Little Egg Harbor Twp	340870003199	300	Robert C. Wood Sr Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	321.0	321
2479867	2479867	NJ	Ocean	29	school	3415690	5020	Stafford Twp	341569004716	50	Oxycocus Elementary School	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	69.0	69
2479911	2479911	NJ	Passaic	31	school	3403300	900	Clifton City	340330003436	301	Clifton Early Learner Academies	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	235.0	235
2479935	2479935	NJ	Passaic	31	school	3412540	3970	Passaic City	341254000403	180	School No.16	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	487.0	487
2479984	2479984	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003473	302	14# Avenue Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	93.0	93
2480053	2480053	NJ	Salem	33	school	3413110	4150	Pittsgrove Twp	341311005082	50	Norma Elementary School	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	118.0	118
2480195	2480195	NJ	Sussex	37	school	3416710	5360	Vernon Twp	341671005428	50	Walnut Ridge Primary School	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	0.0	0
2480207	2480207	NJ	Union	39	school	3403150	850	Clark Twp	340315003295	300	Clark Preschool Annex	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	6.0	6
2480243	2480243	NJ	Union	39	school	3404590	1320	Elizabeth City	340459000467	350	Frances C. Smith Early Childhood Center No 50	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	297.0	297
2480244	2480244	NJ	Union	39	school	3404590	1320	Elizabeth City	340459006131	355	Donald Stewart Early Childhood Center No 51	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	298.0	298
2480245	2480245	NJ	Union	39	school	3404590	1320	Elizabeth City	340459000567	360	Dr. Martin Luther King Jr. Early Childhood Center No 52	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	299.0	299
2480304	2480304	NJ	Union	39	school	3414280	4540	Roselle Boro	341428003147	120	Roselle Preschool	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_half_day	45.0	45
2372986	2372986	NJ	Bergen	3	school	3401450	285	Bergen County Special Services School District	340145000240	70	Life Skills	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2372987	2372987	NJ	Bergen	3	school	3401450	285	Bergen County Special Services School District	340145006020	40	Multiply Handicapped	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2372988	2372988	NJ	Bergen	3	school	3401450	285	Bergen County Special Services School District	340145000234	30	Hearing Impaired	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	9.0	9
2372989	2372989	NJ	Bergen	3	school	3401450	285	Bergen County Special Services School District	340145000238	50	Emotionally Disturbed	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2372990	2372990	NJ	Bergen	3	school	3401450	285	Bergen County Special Services School District	340145000073	100	Autistic	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2372991	2372991	NJ	Bergen	3	school	3401450	285	Bergen County Special Services School District	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	1.0	1
2373185	2373185	NJ	Bergen	3	school	3413770	4370	Ridgefield School District	341377000750	100	Slocum Skewes School	Regular School	No	Other	02	09	2021	pre_kindergarten_half_day	0.0	0
2373275	2373275	NJ	Burlington	5	school	3402440	605	Burlington County Special Services School District	340244000982	30	Westampton Campus	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	4.0	4
2373472	2373472	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	Other	KG	09	2021	pre_kindergarten_half_day	0.0	0
2373474	2373474	NJ	Camden	7	school	3400772	1802	Mastery Schools Of Camden Inc.	340077203313	112	Mastery Schools Of Camden Inc.	Regular School	No	Other	KG	12	2021	pre_kindergarten_half_day	0.0	0
2373725	2373725	NJ	Essex	13	school	3411340	3570	Newark Public School District	341134002296	477	John F. Kennedy School	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2373726	2373726	NJ	Essex	13	school	3411340	3570	Newark Public School District	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2021	pre_kindergarten_half_day	0.0	0
2373862	2373862	NJ	Gloucester	15	school	3480363	1774	Gloucester County Special Services School District	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	2.0	2
2373987	2373987	NJ	Hudson	17	school	3407830	2390	Jersey City Public Schools	340783005980	11	Regional Day School	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2374233	2374233	NJ	Middlesex	23	school	3480180	3145	Educational Services Commission Of New Jersey	348018005951	30	Academy Learning Center	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	1.0	1
2374236	2374236	NJ	Middlesex	23	school	3480180	3145	Educational Services Commission Of New Jersey	348018005991	6	Piscataway Regional Day School	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2374237	2374237	NJ	Middlesex	23	school	3480180	3145	Educational Services Commission Of New Jersey	348018002926	31	Center For Lifelong Learning	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2374238	2374238	NJ	Middlesex	23	school	3480180	3145	Educational Services Commission Of New Jersey	348018000799	90	Nuview Academy	Special Education School	No	Other	KG	12	2021	pre_kindergarten_half_day	0.0	0
2374375	2374375	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_half_day	0.0	0
2374618	2374618	NJ	Morris	27	school	3480260	3364	Educational Services Commission Of Morris County	348026000519	85	Central Park School	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2374763	2374763	NJ	Ocean	29	school	3409450	2940	Manchester Township School District	340945005983	8	Manchester Regional Day School	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2374881	2374881	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269004894	150	Newcomers	Regular School	No	Other	03	10	2021	pre_kindergarten_half_day	0.0	0
2374986	2374986	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2374987	2374987	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2021	pre_kindergarten_half_day	0.0	0
2374988	2374988	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2375113	2375113	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day	0.0	0
2375259	2375259	NJ	Union	39	school	3416400	5245	Union County Educational Services Commission	341640005726	30	Westlake	Special Education School	No	Other	04	12	2021	pre_kindergarten_half_day	0.0	0
2375331	2375331	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_half_day	0.0	0
2375332	2375332	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_half_day	0.0	0
2375333	2375333	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_half_day	0.0	0
2375339	2375339	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_half_day	32.0	32
2375346	2375346	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_half_day	50.0	50
2375351	2375351	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_half_day	0.0	0
2375354	2375354	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_half_day	0.0	0
2375355	2375355	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_half_day	0.0	0
2375356	2375356	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_half_day	0.0	0
2375361	2375361	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_half_day	0.0	0
2375364	2375364	NJ	Charters	80	school	3400779	6101	College Achieve Central Charter School	340077903353	992	College Achieve Central Charter School	Regular School	Yes	Other	KG	11	2021	pre_kindergarten_half_day	0.0	0
2375370	2375370	NJ	Charters	80	school	3400785	6107	Camden'S Promise Charter School	340078503390	998	Camden'S Promise Charter School	Regular School	Yes	Other	PK	12	2021	pre_kindergarten_half_day	61.0	61
2375376	2375376	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_half_day	0.0	0
2375383	2375383	NJ	Charters	80	school	3400032	6720	Hoboken Charter School	340003200302	930	Hoboken Charter School	Regular School	Yes	Other	KG	12	2021	pre_kindergarten_half_day	0.0	0
2375388	2375388	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_half_day	0.0	0
2375390	2375390	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_half_day	56.0	56
2375392	2375392	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_half_day	0.0	0
2375393	2375393	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_half_day	0.0	0
2375396	2375396	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_half_day	0.0	0
2375398	2375398	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_half_day	0.0	0
2375406	2375406	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	Other	KG	09	2021	pre_kindergarten_half_day	0.0	0
2375407	2375407	NJ	Charters	80	school	3400793	7892	College Achieve Paterson Charter School	340079303413	909	College Achieve Paterson Charter School	Regular School	Yes	Other	KG	09	2021	pre_kindergarten_half_day	0.0	0
2375412	2375412	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_half_day	0.0	0
2478067	2478067	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	1.0	1
2478068	2478068	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145000234	30	Hearing Impaired	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	7.0	7
2478069	2478069	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145006020	40	Multiply Handicapped	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	1.0	1
2478070	2478070	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145000238	50	Emotionally Disturbed	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2478071	2478071	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145000240	70	Life Skills	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2478072	2478072	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145000073	100	Autistic	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	1.0	1
2478266	2478266	NJ	Bergen	3	school	3413770	4370	Ridgefield Boro	341377000750	100	Slocum Skewes School	Regular School	No	Other	01	12	2020	pre_kindergarten_half_day	0.0	0
2478355	2478355	NJ	Burlington	5	school	3402440	605	Burlington Co Spec Serv	340244000982	30	Westampton Campus	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	4.0	4
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
2478750	2478750	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2478802	2478802	NJ	Essex	13	school	3411340	3570	Newark City	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2478843	2478843	NJ	Essex	13	school	3411340	3570	Newark City	341134002296	477	John F. Kennedy School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2478937	2478937	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	5.0	5
2479029	2479029	NJ	Hudson	17	school	3407830	2390	Jersey City	340783005980	11	Regional Day School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2479308	2479308	NJ	Middlesex	23	school	3480180	3145	Educational Services Commission Of New Jersey	348018005991	6	Piscataway Regional Day School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2479309	2479309	NJ	Middlesex	23	school	3480180	3145	Educational Services Commission Of New Jersey	348018005951	30	Academy Learning Center	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	3.0	3
2479310	2479310	NJ	Middlesex	23	school	3480180	3145	Educational Services Commission Of New Jersey	348018002926	31	Center For Lifelong Learning	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2479311	2479311	NJ	Middlesex	23	school	3480180	3145	Educational Services Commission Of New Jersey	348018000799	90	Nuview Academy	Special Education School	No	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2479450	2479450	NJ	Monmouth	25	school	3400069	225	Bayshore Jointure Comm	340006900719	30	Developmental Learning Center	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2479693	2479693	NJ	Morris	27	school	3480260	3364	Educ Serv Comm Morris Co	348026000519	85	Central Park School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2479838	2479838	NJ	Ocean	29	school	3409450	2940	Manchester Twp	340945005983	8	Manchester Regional Day School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	2.0	2
2479970	2479970	NJ	Passaic	31	school	3412690	4010	Paterson City	341269004894	150	Newcomers	Regular School	No	Other	03	09	2020	pre_kindergarten_half_day	0.0	0
2480061	2480061	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	pre_kindergarten_half_day	0.0	0
2480062	2480062	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2480063	2480063	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2480188	2480188	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day	0.0	0
2480336	2480336	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640005726	30	Westlake	Special Education School	No	Other	04	12	2020	pre_kindergarten_half_day	0.0	0
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
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
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
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
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
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
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
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

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