schools: enrollments: 33,145 rows where where grade = "grade_1" and state = "NY" sorted by total descending

Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_1" and state = "NY" sorted by total descending

Search:

descending

Link	rowid	state	county	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	school_state_type	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	white	black	hispanic	native_american_alaskan_native	asian_pacific_islander	multiracial	male	female	ell	low_income	disability	total ▲	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	low_income_int	disability_int	total_int
761102	761102	NY	Dutchess	school	3603270	131601060000	ARLINGTON	360327000095	131601060005	TRAVER ROAD PRIMARY SCHOOL	public	Regular School	No	1.0	KG	02	2015	grade_1	72.0	6.0	14.0	0.0	2.0	5.0	53.0	46.0		*	20	99	72	6	14	0	2	5	53	46			20	99
771229	771229	NY	Kings	school	3600092	331500010000	NYC GEOG DIST #15 - BROOKLYN	360009202557	331500010154	WINDSOR TERRACE SCHOOL (THE)	public	Regular School	No	1	KG	5	2015	grade_1	64.0	4.0	20.0	0.0	1.0	10.0	51.0	48.0		15	25	99	64	4	20	0	1	10	51	48		15	25	99
778943	778943	NY	Kings	school	3600097	333200010000	NYC GEOG DIST #32 - BROOKLYN	360009702199	333200010045	PS/IS 45 HORACE E GREENE	public	Regular School	No	1	PK	08	2015	grade_1	0.0	46.0	46.0	1.0	5.0	1.0	52.0	47.0		82	14	99	0	46	46	1	5	1	52	47		82	14	99
783636	783636	NY	Monroe	school	3625170	261701060000	RUSH HENRIETTA	362517003486	261701060004	MONICA B LEARY ELEMENTARY SCHOOL	public	Regular School	No	1	KG	05	2015	grade_1	65.0	15.0	4.0		9.0	6.0	54.0	45.0		26	5	99	65	15	4		9	6	54	45		26	5	99
785726	785726	NY	Nassau	school	3611550	280209030000	FREEPORT	361155001636	280209030009	NEW VISIONS ELEMENTARY SCHOOL	public	Regular School	No	1	KG	04	2015	grade_1	17.0	23.0	54.0	1.0	2.0	2.0	46.0	53.0		58	*	99	17	23	54	1	2	2	46	53		58		99
785897	785897	NY	Nassau	school	3621570	280211030000	OCEANSIDE	362157003061	280211030003	SCHOOL 3	public	Regular School	No	1	01	06	2015	grade_1	78.0	2.0	11.0		3.0	5.0	61.0	38.0		12	15	99	78	2	11		3	5	61	38		12	15	99
790115	790115	NY	Nassau	school	3618630	280523030000	MASSAPEQUA	361863001683	280523030001	BIRCH LANE ELEMENTARY SCHOOL	public	Regular School	No	1	KG	06	2015	grade_1	92.0	0.0	5.0	0.0	2.0	0.0	48.0	51.0		10	7	99	92	0	5	0	2	0	48	51		10	7	99
794599	794599	NY	New York	school	3600078	310300010000	NYC GEOG DIST # 3 - MANHATTAN	360007802591	310300010165	PS 165 ROBERT E SIMON	public	Regular School	No	1	PK	08	2015	grade_1	23.0	10.0	60.0	0.0	5.0	1.0	52.0	47.0		70	*	99	23	10	60	0	5	1	52	47		70		99
803643	803643	NY	Orange	school	3623010	440401060000	PINE BUSH	362301004820	440401060009	PINE BUSH ELEMENTARY SCHOOL	public	Regular School	No	1	KG	05	2015	grade_1	75.0	7.0	11.0	0.0	2.0	4.0	63.0	36.0		48	8	99	75	7	11	0	2	4	63	36		48	8	99
804422	804422	NY	Orange	school	3620700	441600010000	NEWBURGH	362070002915	441600010012	VAILS GATE HIGH TECH MAGNET SCHOOL	public	Regular School	No	1	KG	05	2015	grade_1	8.0	32.0	51.0		2.0	6.0	46.0	53.0		93	*	99	8	32	51		2	6	46	53		93		99
808032	808032	NY	Queens	school	3600122	342500010000	NYC GEOG DIST #25 - QUEENS	360012202661	342500010193	PS 193 ALFRED J KENNEDY	public	Regular School	No	1	PK	05	2015	grade_1	53.0	1.0	14.0	0.0	29.0	2.0	55.0	44.0		35	15	99	53	1	14	0	29	2	55	44		35	15	99
811699	811699	NY	Queens	school	3600101	342900010000	NYC GEOG DIST #29 - QUEENS	360010102617	342900010176	PS 176 CAMBRIA HEIGHTS	public	Regular School	No	1	PK	05	2015	grade_1	1.0	90.0	3.0	1.0	4.0	0.0	45.0	54.0		77	11	99	1	90	3	1	4	0	45	54		77	11	99
814093	814093	NY	Richmond	school	3600103	353100010000	NYC GEOG DIST #31 - SI	360010304816	353100010006	PS 6 CPL ALLAN F KIVLEHAN SCHOOL	public	Regular School	No	1	PK	05	2015	grade_1	79.0	1.0	11.0	2.0	2.0	4.0	56.0	43.0		39	22	99	79	1	11	2	2	4	56	43		39	22	99
818881	818881	NY	Schenectady	school	3626010	530600010000	SCHENECTADY	362601003588	530600010014	PLEASANT VALLEY SCHOOL	public	Regular School	No	1	PK	06	2015	grade_1	12.0	24.0	28.0		27.0	8.0	58.0	41.0		84	13	99	12	24	28		27	8	58	41		84	13	99
820667	820667	NY	Suffolk	school	3617380	580104030000	LINDENHURST	361738001551	580104030008	WILLIAM RALL SCHOOL	public	Regular School	No	1	KG	05	2015	grade_1	56.0	6.0	30.0		4.0	3.0	49.0	50.0		42	8	99	56	6	30		4	3	49	50		42	8	99
821199	821199	NY	Suffolk	school	3628200	580201060000	THREE VILLAGE	362820003808	580201060007	SETAUKET ELEMENTARY SCHOOL	public	Regular School	No	1	KG	06	2015	grade_1	84.0	1.0	6.0	1.0	3.0	4.0	55.0	44.0		*	*	99	84	1	6	1	3	4	55	44				99
822453	822453	NY	Suffolk	school	3622470	580224030000	PATCHOGUE-MEDFORD	362247003163	580224030004	MEDFORD ELEMENTARY SCHOOL	public	Regular School	No	1	KG	05	2015	grade_1	30.0	5.0	58.0	1.0	3.0	2.0	43.0	56.0		70	*	99	30	5	58	1	3	2	43	56		70		99
826177	826177	NY	Suffolk	school	3616260	580805060000	KINGS PARK	361626001464	580805060006	FORT SALONGA ELEMENTARY SCHOOL	public	Regular School	No	1	KG	03	2015	grade_1	84.0	0.0	11.0		2.0	2.0	48.0	51.0		11	*	99	84	0	11		2	2	48	51		11		99
827260	827260	NY	Tioga	school	3620670	600402040000	NEWARK VALLEY	362067002898	600402040003	NATHAN T HALL SCHOOL	public	Regular School	No	1	PK	03	2015	grade_1	94.0	0.0	2.0	1.0		2.0	47.0	52.0		59	7	99	94	0	2	1		2	47	52		59	7	99
831231	831231	NY	Westchester	school	3613950	660404030000	HASTINGS ON HUDSON	361395001132	660404030001	HILLSIDE ELEMENTARY SCHOOL	public	Regular School	No	1	KG	04	2015	grade_1	81.0	0.0	11.0		1.0	6.0	51.0	48.0		*	9	99	81	0	11		1	6	51	48			9	99
946538	946538	NY	Bronx	school	3600086	320900010000	NYC GEOG DIST # 9 - BRONX	360008600728	320900010170	PS 170	public	Regular School	No	Elementary	KG	02	2017	grade_1	1.0	29.0	68.0	0.0	1.0		51.0	48.0	37	76	11	99	1	29	68	0	1		51	48	37	76	11	99
946975	946975	NY	Bronx	school	3600086	320900010000	NYC GEOG DIST # 9 - BRONX	360008606150	320900010457	SHERIDAN ACADEMY FOR YOUNG LEADERS	public	Regular School	No	Elementary	KG	05	2017	grade_1	0.0	24.0	74.0	1.0	0.0		43.0	56.0	23	93	17	99	0	24	74	1	0		43	56	23	93	17	99
951820	951820	NY	Broome	school	3607260	30101060000	CHENANGO FORKS	360726000512	30101060001	CHENANGO FORKS ELEMENTARY SCHOOL	public	Regular School	No	Elementary	PK	05	2017	grade_1	97.0	0.0	1.0	0.0	0.0	1.0	50.0	49.0	*	41	*	99	97	0	1	0	0	1	50	49		41		99
958831	958831	NY	Erie	school	3631470	140203060000	WILLIAMSVILLE	363147004211	140203060007	FOREST ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	4	2017	grade_1	72.0	4.0	3.0	0.0	9.0	11.0	41.0	58.0	8	29	12	99	72	4	3	0	9	11	41	58	8	29	12	99
981707	981707	NY	Nassau	school	3617160	280205030000	LEVITTOWN	361716001529	280205030011	NORTHSIDE SCHOOL	public	Regular School	No	Elementary	KG	05	2017	grade_1	56.0	0.0	26.0		15.0	2.0	51.0	48.0	7	11	6	99	56	0	26		15	2	51	48	7	11	6	99
983550	983550	NY	Nassau	school	3629850	280223030000	WANTAGH	362985004012	280223030004	WANTAGH SCHOOL	public	Regular School	No	Elementary	KG	05	2017	grade_1	85.0		4.0		5.0	5.0	46.0	53.0	*	8	14	99	85		4		5	5	46	53		8	14	99
985184	985184	NY	Nassau	school	3614280	280409030000	HERRICKS	361428001175	280409030002	DENTON AVENUE SCHOOL	public	Regular School	No	Elementary	KG	05	2017	grade_1	16.0	0.0	7.0	0.0	73.0	3.0	44.0	55.0	15	8	5	99	16	0	7	0	73	3	44	55	15	8	5	99
985203	985203	NY	Nassau	school	3614280	280409030000	HERRICKS	361428001178	280409030004	SEARINGTOWN SCHOOL	public	Regular School	No	Elementary	KG	06	2017	grade_1	24.0	0.0	3.0		67.0	5.0	62.0	37.0	19	10	11	99	24	0	3		67	5	62	37	19	10	11	99
988509	988509	NY	New York	school	3600077	310200010000	NYC GEOG DIST # 2 - MANHATTAN	360007702058	310200010006	PS 6 LILLIE D BLAKE	public	Regular School	No	Elementary	PK	05	2017	grade_1	76.0	0.0	7.0	0.0	16.0	0.0	50.0	49.0	*	*	16	99	76	0	7	0	16	0	50	49			16	99
993411	993411	NY	New York	school	3600083	310600010000	NYC GEOG DIST # 6 - MANHATTAN	360008301676	310600010008	PS 8 LUIS BELLIARD	public	Regular School	No	Elementary	PK	05	2017	grade_1	1.0	3.0	95.0		0.0	0.0	52.0	47.0	42	96	25	99	1	3	95		0	0	52	47	42	96	25	99
993449	993449	NY	New York	school	3600083	310600010000	NYC GEOG DIST # 6 - MANHATTAN	360008302135	310600010028	PS 28 WRIGHT BROTHERS	public	Regular School	No	Elementary	PK	05	2017	grade_1	2.0	9.0	86.0	0.0	2.0	0.0	56.0	43.0	52	86	19	99	2	9	86	0	2	0	56	43	52	86	19	99
996280	996280	NY	Oneida	school	3629370	412300010000	UTICA	362937003948	412300010006	GENERAL HERKIMER ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	06	2017	grade_1	35.0	22.0	19.0	1.0	17.0	5.0	47.0	52.0	20	82	*	99	35	22	19	1	17	5	47	52	20	82		99
998750	998750	NY	Onondaga	school	3628590	421800010000	SYRACUSE	362859003883	421800010043	WEBSTER ELEMENTARY SCHOOL	public	Regular School	No	Elementary	PK	05	2017	grade_1	29.0	35.0	9.0	0.0	15.0	11.0	54.0	45.0	25	89	16	99	29	35	9	0	15	11	54	45	25	89	16	99
1000612	1000612	NY	Orange	school	3620700	441600010000	NEWBURGH	362070002904	441600010005	GARDNERTOWN FUNDAMENTAL MAGNET SCHOO	public	Regular School	No	Elementary	PK	05	2017	grade_1	20.0	14.0	51.0	0.0	0.0	14.0	47.0	52.0	27	77	15	99	20	14	51	0	0	14	47	52	27	77	15	99
1006084	1006084	NY	Queens	school	3600123	342700010000	NYC GEOG DIST #27 - QUEENS	360012305728	342700010253	PS 253	public	Regular School	No	Elementary	PK	05	2017	grade_1	4.0	27.0	62.0	0.0	5.0	1.0	42.0	57.0	46	97	22	99	4	27	62	0	5	1	42	57	46	97	22	99
1017883	1017883	NY	Suffolk	school	3625350	580205060000	SACHEM	362535003498	580205060013	CAYUGA SCHOOL	public	Regular School	No	Elementary	KG	05	2017	grade_1	71.0	5.0	19.0	0.0	2.0	2.0	47.0	52.0		29	13	99	71	5	19	0	2	2	47	52		29	13	99
1018928	1018928	NY	Suffolk	school	3618690	580232030000	WILLIAM FLOYD	361869004674	580232030005	TANGIER SMITH ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	05	2017	grade_1	50.0	12.0	27.0	1.0	1.0	8.0	56.0	43.0	7	61	19	99	50	12	27	1	1	8	56	43	7	61	19	99
1023393	1023393	NY	Tioga	school	3630270	600101060000	WAVERLY	363027004068	600101060004	LINCOLN STREET ELEMENTARY SCHOOL	public	Regular School	No	Elementary	PK	02	2017	grade_1	91.0	0.0	2.0	0.0	1.0	5.0	57.0	42.0		69	11	99	91	0	2	0	1	5	57	42		69	11	99
1048663	1048663	NY	Erie	school	3631470	140203060000	WILLIAMSVILLE	363147004211	140203060007	FOREST ELEMENTARY SCHOOL	public	Regular School	No	1.0	KG	4	2016	grade_1	71.0	8.0	3.0	0.0	12.0	5.0	54.0	45.0		15	*	99	71	8	3	0	12	5	54	45		15		99
1056757	1056757	NY	Kings	school	3600119	331400010000	NYC GEOG DIST #14 - BROOKLYN	360011902773	331400010257	PS 257 JOHN F HYLAN	public	Regular School	No	1.0	PK	5	2016	grade_1	4.0	23.0	72.0		0.0	0.0	48.0	51.0		70	23	99	4	23	72		0	0	48	51		70	23	99
1070950	1070950	NY	Nassau	school	3614130	280201030000	HEMPSTEAD	361413001150	280201030001	FRANKLIN SCHOOL	public	Regular School	No	1.0	PK	05	2016	grade_1	4.0	24.0	70.0	0.0	1.0	0.0	44.0	55.0		76	*	99	4	24	70	0	1	0	44	55		76		99
1075358	1075358	NY	Nassau	school	3606540	280411030000	CARLE PLACE	360654000436	280411030001	CHERRY LANE SCHOOL	public	Regular School	No	1.0	KG	02	2016	grade_1	73.0	2.0	18.0		6.0		42.0	57.0		16	8	99	73	2	18		6		42	57		16	8	99
1083661	1083661	NY	New York	school	3600083	310600010000	NYC GEOG DIST # 6 - MANHATTAN	360008302472	310600010128	PS 128 AUDUBON	public	Regular School	No	1.0	PK	05	2016	grade_1	1.0	0.0	98.0	0.0	0.0		48.0	51.0		90	21	99	1	0	98	0	0		48	51		90	21	99
1085637	1085637	NY	Oneida	school	3607770	411101060000	CLINTON	360777000555	411101060001	CLINTON ELEMENTARY SCHOOL	public	Regular School	No	1.0	KG	05	2016	grade_1	94.0	1.0	1.0	0.0	1.0	2.0	58.0	41.0		29	7	99	94	1	1	0	1	2	58	41		29	7	99
1086283	1086283	NY	Oneida	school	3614580	412201060000	HOLLAND PATENT	361458001208	412201060005	GENERAL WILLIAM FLOYD ELEM SCHOOL	public	Regular School	No	1.0	PK	02	2016	grade_1	99.0	0.0					57.0	42.0		50	8	99	99	0					57	42		50	8	99
1088544	1088544	NY	Onondaga	school	3628590	421800010000	SYRACUSE	362859003865	421800010015	HUNTINGTON K-8 SCHOOL	public	Regular School	No	4.0	PK	09	2016	grade_1	37.0	27.0	6.0	1.0	13.0	15.0	62.0	37.0		73	15	99	37	27	6	1	13	15	62	37		73	15	99
1088677	1088677	NY	Onondaga	school	3628590	421800010000	SYRACUSE	362859003879	421800010028	SEYMOUR DUAL LANGUAGE ACADEMY	public	Regular School	No	1.0	PK	05	2016	grade_1	5.0	40.0	47.0	1.0	1.0	5.0	58.0	41.0		76	23	99	5	40	47	1	1	5	58	41		76	23	99
1089855	1089855	NY	Orange	school	3608430	440301060000	CORNWALL	360843000641	440301060004	CORNWALL ELEMENTARY SCHOOL	public	Regular School	No	1.0	KG	04	2016	grade_1	63.0	10.0	22.0	0.0	3.0	1.0	59.0	40.0		21	15	99	63	10	22	0	3	1	59	40		21	15	99
1094548	1094548	NY	Queens	school	3600122	342500010000	NYC GEOG DIST #25 - QUEENS	360012204892	342500010242	PS 242 LP STAVISKY EARLY CHILDHOOD	public	Regular School	No	1.0	PK	03	2016	grade_1	4.0	2.0	23.0	1.0	68.0	1.0	50.0	49.0		70	23	99	4	2	23	1	68	1	50	49		70	23	99
1097740	1097740	NY	Queens	school	3600101	342900010000	NYC GEOG DIST #29 - QUEENS	360010102162	342900010035	PS 35 NATHANIEL WOODHULL	public	Regular School	No	1.0	PK	05	2016	grade_1	2.0	26.0	31.0	13.0	26.0	1.0	51.0	48.0		85	*	99	2	26	31	13	26	1	51	48		85		99
1108988	1108988	NY	Suffolk	school	3622470	580224030000	PATCHOGUE-MEDFORD	362247003162	580224030009	EAGLE ELEMENTARY SCHOOL	public	Regular School	No	1.0	KG	05	2016	grade_1	47.0	3.0	44.0		2.0	3.0	52.0	47.0		57	14	99	47	3	44		2	3	52	47		57	14	99
1110356	1110356	NY	Suffolk	school	3608130	580410030000	COMMACK	360813000594	580410030014	WOOD PARK SCHOOL	public	Regular School	No	1.0	KG	02	2016	grade_1	77.0	2.0	8.0		9.0	3.0	59.0	40.0		7	28	99	77	2	8		9	3	59	40		7	28	99
1116151	1116151	NY	Wayne	school	3620640	650101060000	NEWARK	362064002897	650101060001	PERKINS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	02	2016	grade_1	74.0	4.0	15.0		0.0	6.0	54.0	45.0		69	13	99	74	4	15		0	6	54	45		69	13	99
1116740	1116740	NY	Wayne	school	3616980	651501060000	NORTH ROSE WOLCOTT	361698001512	651501060002	NORTH ROSE-WOLCOTT ELEMENTARY	public	Regular School	No	1.0	PK	04	2016	grade_1	79.0	0.0	14.0		1.0	5.0	49.0	50.0		67	*	99	79	0	14		1	5	49	50		67		99
1447549	1447549	NY	Columbia	school	3615210	101401040000	KINDERHOOK	361521001278	101401040004	ICHABOD CRANE ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	03	2021	grade_1	80.0	2.0	10.0	0.0	0.0	7.0	37.0	62.0	7	44	12	99	80	2	10	0	0	7	37	62	7	44	12	99
1450646	1450646	NY	Erie	school	3605850	140600010000	BUFFALO	360585000355	140600010064	PS 64 FREDERICK LAW OLMSTED	public	Regular School	No	Elementary	PK	04	2021	grade_1	60.0	16.0	15.0		1.0	7.0	46.0	53.0	10	25	12	99	60	16	15		1	7	46	53	10	25	12	99
1454484	1454484	NY	Fulton	school	3612270	170500010000	GLOVERSVILLE	361227000991	170500010007	PARK TERRACE SCHOOL	public	Regular School	No	Elementary	PK	02	2021	grade_1	73.0	3.0	13.0	1.0	1.0	8.0	52.0	47.0		75	9	99	73	3	13	1	1	8	52	47		75	9	99
1462198	1462198	NY	Kings	school	3600120	331900010000	NYC GEOG DIST #19 - BROOKLYN	360012004351	331900010007	PS 7 ABRAHAM LINCOLN	public	Regular School	No	Elementary	PK	05	2021	grade_1	2.0	11.0	84.0	2.0	0.0	0.0	48.0	51.0	19	94	18	99	2	11	84	2	0	0	48	51	19	94	18	99
1463376	1463376	NY	Kings	school	3600151	332000010000	NYC GEOG DIST #20 - BROOKLYN	360015102212	332000010048	PS 48 MAPLETON	public	Regular School	No	Elementary	PK	05	2021	grade_1	26.0	0.0	33.0	1.0	38.0	1.0	47.0	52.0	34	72	25	99	26	0	33	1	38	1	47	52	34	72	25	99
1464573	1464573	NY	Kings	school	3600152	332100010000	NYC GEOG DIST #21 - BROOKLYN	360015202734	332100010226	PS 226 ALFRED DE B MASON	public	Regular School	No	Elementary	PK	08	2021	grade_1	38.0	3.0	25.0	2.0	28.0	3.0	58.0	41.0	51	80	*	99	38	3	25	2	28	3	58	41	51	80		99
1479659	1479659	NY	New York	school	3600077	310200010000	NYC GEOG DIST # 2 - MANHATTAN	360007702152	310200010033	PS 33 CHELSEA PREP	public	Regular School	No	Elementary	PK	05	2021	grade_1	23.0	15.0	19.0	1.0	31.0	10.0	50.0	49.0	13	49	16	99	23	15	19	1	31	10	50	49	13	49	16	99
1493472	1493472	NY	Putnam	school	3618120	480101060000	MAHOPAC	361812001620	480101060002	AUSTIN ROAD ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	05	2021	grade_1	68.0	3.0	22.0		1.0	5.0	46.0	53.0	*	27	18	99	68	3	22		1	5	46	53		27	18	99
1494422	1494422	NY	Queens	school	3600098	342400010000	NYC GEOG DIST #24 - QUEENS	360009802678	342400010199	PS 199 MAURICE A FITZGERALD	public	Regular School	No	Elementary	PK	05	2021	grade_1	13.0	5.0	51.0	1.0	29.0	0.0	50.0	49.0	47	79	*	99	13	5	51	1	29	0	50	49	47	79		99
1499096	1499096	NY	Queens	school	3600101	342900010000	NYC GEOG DIST #29 - QUEENS	360010102432	342900010116	PS/IS 116 WILLIAM C HUGHLEY	public	Regular School	No	Elementary	PK	08	2021	grade_1	1.0	37.0	42.0	4.0	15.0		50.0	49.0	28	79	16	99	1	37	42	4	15		50	49	28	79	16	99
1507912	1507912	NY	Suffolk	school	3603720	580101030000	BABYLON	360372000120	580101030003	BABYLON ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	02	2021	grade_1	76.0	3.0	16.0		1.0	3.0	49.0	50.0	*	*	11	99	76	3	16		1	3	49	50			11	99
1526019	1526019	NY	Bronx	school	3600085	320800010000	NYC GEOG DIST # 8 - BRONX	360008502085	320800010014	PS 14 SENATOR JOHN CALANDRA	public	Regular School	No	Elementary	KG	05	2020	grade_1	24.0	4.0	65.0	1.0	5.0	0.0	54.0	45.0	9	68	24	99	24	4	65	1	5	0	54	45	9	68	24	99
1528831	1528831	NY	Bronx	school	3600087	321000010000	NYC GEOG DIST #10 - BRONX	360008702067	321000010009	PS 9 RYER AVENUE ELEMENTARY SCHOOL	public	Regular School	No	Elementary	PK	05	2020	grade_1	1.0	16.0	77.0	1.0	4.0	0.0	55.0	44.0	32	95	23	99	1	16	77	1	4	0	55	44	32	95	23	99
1530712	1530712	NY	Bronx	school	3600088	321100010000	NYC GEOG DIST #11 - BRONX	360008802312	321100010078	PS 78 ANNE HUTCHINSON	public	Regular School	No	Elementary	PK	05	2020	grade_1	1.0	72.0	25.0	1.0	0.0	0.0	45.0	54.0	*	84	*	99	1	72	25	1	0	0	45	54		84		99
1541732	1541732	NY	Erie	school	3601173	140600861109	REACH ACADEMY CHARTER SCHOOL	360117306635	140600861109	REACH ACADEMY CHARTER SCHOOL	charter	Regular School	Yes	Elementary	KG	03	2020	grade_1	6.0	71.0	13.0	0.0	0.0	9.0	53.0	46.0	8	91	18	99	6	71	13	0	0	9	53	46	8	91	18	99
1555393	1555393	NY	Kings	school	3600153	332200010000	NYC GEOG DIST #22 - BROOKLYN	360015302697	332200010207	PS 207 ELIZABETH G LEARY	public	Regular School	No	Elementary	PK	08	2020	grade_1	32.0	29.0	16.0	0.0	18.0	4.0	52.0	47.0	8	49	19	99	32	29	16	0	18	4	52	47	8	49	19	99
1559611	1559611	NY	Monroe	school	3622710	261201060000	PENFIELD	362271003197	261201060005	SCRIBNER ROAD ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	05	2020	grade_1	73.0	4.0	8.0		7.0	7.0	49.0	50.0	*	20	11	99	73	4	8		7	7	49	50		20	11	99
1561587	1561587	NY	Monroe	school	3630360	261901060000	WEBSTER	363036004709	261901060004	PLANK ROAD NORTH ELEMENTARY SCHOOL	public	Regular School	No	Elementary	PK	05	2020	grade_1	77.0	4.0	11.0	1.0	3.0	3.0	43.0	56.0	6	34	*	99	77	4	11	1	3	3	43	56	6	34		99
1561682	1561682	NY	Monroe	school	3630360	261901060000	WEBSTER	363036004086	261901060011	PLANK ROAD SOUTH ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	05	2020	grade_1	78.0	2.0	7.0		8.0	4.0	50.0	49.0	*	17	*	99	78	2	7		8	4	50	49		17		99
1564817	1564817	NY	Nassau	school	3629850	280223030000	WANTAGH	362985004012	280223030004	WANTAGH SCHOOL	public	Regular School	No	Elementary	KG	05	2020	grade_1	84.0	0.0	6.0	1.0	5.0	3.0	49.0	50.0	6	12	18	99	84	0	6	1	5	3	49	50	6	12	18	99
1566318	1566318	NY	Nassau	school	3612510	280407030000	GREAT NECK	361251001023	280407030010	SADDLE ROCK SCHOOL	public	Regular School	No	Elementary	KG	05	2020	grade_1	50.0	4.0	15.0		26.0	4.0	53.0	46.0	9	21	16	99	50	4	15		26	4	53	46	9	21	16	99
1569795	1569795	NY	New York	school	3600077	310200010000	NYC GEOG DIST # 2 - MANHATTAN	360007702058	310200010006	PS 6 LILLIE D BLAKE	public	Regular School	No	Elementary	PK	05	2020	grade_1	65.0	5.0	6.0	0.0	22.0	1.0	47.0	52.0	*	*	19	99	65	5	6	0	22	1	47	52			19	99
1574450	1574450	NY	New York	school	3600140	310500860886	HARLEM CHLDRN ZONE ACADEMY II	360014005777	310500860886	HARLEM CHLDRN ZONE ACADEMY II	charter	Regular School	Yes	Other	KG	12	2020	grade_1	1.0	74.0	23.0	0.0	0.0	1.0	49.0	50.0	6	97	17	99	1	74	23	0	0	1	49	50	6	97	17	99
1575685	1575685	NY	New York	school	3601171	310600861140	ZETA CHARTER SCHOOL - INWOOD	360117106637	310600861140	ZETA CHARTER SCHOOL - INWOOD 1	charter	Regular School	Yes	Elementary	KG	02	2020	grade_1	6.0	8.0	84.0	1.0	0.0	0.0	41.0	58.0	26	78	21	99	6	8	84	1	0	0	41	58	26	78	21	99
1581860	1581860	NY	Orange	school	3620700	441600010000	NEWBURGH	362070002905	441600010006	GAMS HIGH TECH MAGNET SCHOOL	public	Regular School	No	Elementary	PK	05	2020	grade_1	5.0	13.0	73.0	0.0	2.0	6.0	45.0	54.0	33	81	12	99	5	13	73	0	2	6	45	54	33	81	12	99
1586287	1586287	NY	Queens	school	3600099	342600010000	NYC GEOG DIST #26 - QUEENS	360009902580	342600010162	PS 162 JOHN GOLDEN	public	Regular School	No	Elementary	PK	05	2020	grade_1	14.0	3.0	12.0	1.0	66.0	3.0	46.0	53.0	29	59	16	99	14	3	12	1	66	3	46	53	29	59	16	99
1588168	1588168	NY	Queens	school	3600100	342800010000	NYC GEOG DIST #28 - QUEENS	360010002322	342800010082	PS 82 HAMMOND	public	Regular School	No	Elementary	KG	05	2020	grade_1	1.0	7.0	63.0	1.0	25.0	2.0	44.0	55.0	28	82	9	99	1	7	63	1	25	2	44	55	28	82	9	99
1588529	1588529	NY	Queens	school	3600100	342800010000	NYC GEOG DIST #28 - QUEENS	360010002723	342800010220	PS 220 EDWARD MANDEL	public	Regular School	No	Elementary	PK	05	2020	grade_1	32.0	6.0	26.0	0.0	32.0	3.0	36.0	63.0	25	70	11	99	32	6	26	0	32	3	36	63	25	70	11	99
1594476	1594476	NY	Saint Lawrence	school	3606470	510201060000	CANTON	360647000427	510201060001	F S BANFORD ELEMENTARY SCHOOL	public	Regular School	No	Elementary	PK	04	2020	grade_1	88.0	0.0	4.0		2.0	5.0	54.0	45.0		53	7	99	88	0	4		2	5	54	45		53	7	99
1601392	1601392	NY	Suffolk	school	3613290	580405060000	HALF HOLLOW HILLS	361329001093	580405060011	VANDERBILT ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	05	2020	grade_1	50.0	12.0	14.0		16.0	7.0	49.0	50.0	*	19	9	99	50	12	14		16	7	49	50		19	9	99
1605914	1605914	NY	Ulster	school	3614400	620803040000	HIGHLAND	361440001191	620803040001	HIGHLAND ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	05	2020	grade_1	67.0	4.0	16.0	0.0	7.0	5.0	50.0	49.0	*	*	*	99	67	4	16	0	7	5	50	49				99
1608612	1608612	NY	Westchester	school	3605640	660303030000	BRONXVILLE	360564000290	660303030003	BRONXVILLE ELEMENTARY SCHOOL	public	Regular School	No	Other	KG	09	2020	grade_1	79.0	0.0	6.0		6.0	8.0	58.0	41.0	*	*	*	99	79	0	6		6	8	58	41				99
2049717	2049717	NY	Albany	school	3600128	10100860867	KIPP TECH VALLEY CHARTER SCH	360012805750	10100860867	KIPP TECH VALLEY CHARTER SCHOOL	charter	Regular School	Yes	Middle	KG	08	2018	grade_1	5.0	77.0	9.0	0.0	4.0	4.0	40.0	59.0		86	*	99	5	77	9	0	4	4	40	59		86		99
2059730	2059730	NY	Broome	school	3631380	31401060000	WHITNEY POINT	363138004199	31401060005	CARYL E ADAMS PRIMARY SCHOOL	public	Regular School	No	Elementary	PK	03	2018	grade_1	99.0	0.0	0.0			0.0	51.0	48.0		58	11	99	99	0	0			0	51	48		58	11	99
2072840	2072840	NY	Jefferson	school	3606630	222201060000	CARTHAGE	360663000443	222201060002	BLACK RIVER SCHOOL	public	Regular School	No	Elementary	KG	04	2018	grade_1	67.0	11.0	9.0	1.0	3.0	8.0	46.0	53.0	*	51	12	99	67	11	9	1	3	8	46	53		51	12	99
2078502	2078502	NY	Kings	school	3600120	331900010000	NYC GEOG DIST #19 - BROOKLYN	360012002538	331900010149	PS 149 DANNY KAYE	public	Regular School	No	Elementary	PK	05	2018	grade_1	1.0	59.0	33.0	1.0	3.0	2.0	53.0	46.0	8	97	19	99	1	59	33	1	3	2	53	46	8	97	19	99
2079528	2079528	NY	Kings	school	3600151	332000010000	NYC GEOG DIST #20 - BROOKLYN	360015102212	332000010048	PS 48 MAPLETON	public	Regular School	No	Elementary	PK	05	2018	grade_1	29.0	0.0	24.0	0.0	46.0	0.0	47.0	52.0	29	81	17	99	29	0	24	0	46	0	47	52	29	81	17	99
2081694	2081694	NY	Kings	school	3600153	332200010000	NYC GEOG DIST #22 - BROOKLYN	360015303385	332200010315	PS 315	public	Regular School	No	Elementary	PK	05	2018	grade_1	10.0	56.0	27.0	1.0	5.0	0.0	52.0	47.0	20	92	29	99	10	56	27	1	5	0	52	47	20	92	29	99
2082587	2082587	NY	Kings	school	3600969	332300860912	ACHIEVEMENT FIRST BROWNSVILL	360096906014	332300860912	ACHIEVEMENT FIRST BROWNSVILLE CHARTE	charter	Regular School	Yes	Other	KG	10	2018	grade_1	0.0	94.0	3.0	1.0	1.0	0.0	47.0	52.0	*	83	12	99	0	94	3	1	1	0	47	52		83	12	99
2084031	2084031	NY	Madison	school	3606780	250201060000	CAZENOVIA	360678000465	250201060006	BURTON STREET ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	04	2018	grade_1	92.0	0.0	1.0		2.0	4.0	56.0	43.0	*	33	*	99	92	0	1		2	4	56	43		33		99
2084962	2084962	NY	Monroe	school	3612630	260501060000	GREECE	361263000486	260501060024	PINE BROOK ELEMENTARY SCHOOL	public	Regular School	No	Elementary	KG	05	2018	grade_1	75.0	9.0	10.0	0.0	4.0	1.0	50.0	49.0	*	41	7	99	75	9	10	0	4	1	50	49		41	7	99
2091802	2091802	NY	Nassau	school	3630960	280401030000	WESTBURY	363096004160	280401030005	POWELLS LANE SCHOOL	public	Regular School	No	Elementary	01	05	2018	grade_1	1.0	30.0	65.0	1.0	2.0	0.0	49.0	50.0	34	71	9	99	1	30	65	1	2	0	49	50	34	71	9	99
2095887	2095887	NY	New York	school	3600077	310200010000	NYC GEOG DIST # 2 - MANHATTAN	360007702184	310200010041	PS 41 GREENWICH VILLAGE	public	Regular School	No	Elementary	PK	05	2018	grade_1	69.0	1.0	11.0		12.0	6.0	43.0	56.0	*	7	18	99	69	1	11		12	6	43	56		7	18	99
2095906	2095906	NY	New York	school	3600077	310200010000	NYC GEOG DIST # 2 - MANHATTAN	360007702187	310200010042	PS 42 BENJAMIN ALTMAN	public	Regular School	No	Elementary	PK	05	2018	grade_1	0.0	2.0	11.0	0.0	86.0	0.0	51.0	48.0	55	80	20	99	0	2	11	0	86	0	51	48	55	80	20	99
2100618	2100618	NY	New York	school	3600954	310500860921	SUCCESS ACAD-HARLEM 2	360095406017	310500860921	SUCCESS ACAD CHARTER SCH-HARLEM 2	charter	Regular School	Yes	Other	KG	10	2018	grade_1	2.0	68.0	26.0	0.0	3.0	0.0	45.0	54.0	5	83	18	99	2	68	26	0	3	0	45	54	5	83	18	99
2103582	2103582	NY	Oneida	school	3614580	412201060000	HOLLAND PATENT	361458001208	412201060005	GENERAL WILLIAM FLOYD ELEM SCHOOL	public	Regular School	No	Elementary	PK	02	2018	grade_1	99.0						58.0	41.0		43	10	99	99						58	41		43	10	99

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