schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select rowid, state, county, county_state_id, admin_level, district_nces_id, district_state_id, district_state_type, 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, term, grade, white, black, hispanic, native_american, native_american_alaskan_native, asian, native_hawaiian, asian_pacific_islander, native_hawaiian_pacific_islander, pacific_islander, multiracial, unknown_race, male, female, non_binary, unknown_gender, ell, ell_percent, homeless, homeless_percent, low_income, free_and_reduced, free_and_reduced_percent, disability, section_504, total, white_int, black_int, hispanic_int, native_american_int, native_american_alaskan_native_int, asian_int, native_hawaiian_int, asian_pacific_islander_int, native_hawaiian_pacific_islander_int, pacific_islander_int, multiracial_int, unknown_race_int, male_int, female_int, non_binary_int, unknown_gender_int, ell_int, homeless_int, low_income_int, free_and_reduced_int, disability_int, section_504_int, total_int from enrollments where "grade" = :p0 and "state" = :p1 and (district_state_id > :p3 or (district_state_id = :p3 and rowid > :p2)) order by district_state_id, rowid limit 101

Query parameters

This data as json, CSV

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
2371877	NJ	Monmouth	25	school	3403630	1000	Deal Boro School District	340363003764	40	Deal Elementary School	Regular School	No	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2476955	NJ	Monmouth	25	school	3403630	1000	Deal Boro	340363003764	40	Deal Elementary School	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_full_day	0.0	0
2371077	NJ	Cumberland	11	school	3403660	1020	Deerfield Township School District	340366001826	40	Deerfield Township Elementary School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2476161	NJ	Cumberland	11	school	3403660	1020	Deerfield Twp	340366001826	40	Deerfield Township School District	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2370783	NJ	Burlington	5	school	3403690	1030	Delanco Township School District	340369001036	60	Walnut Street School	Regular School	No	Middle	06	08	2021	pre_kindergarten_full_day	0.0	0
2370784	NJ	Burlington	5	school	3403690	1030	Delanco Township School District	340369001032	30	M. Joan Pearson Elementary School	Regular School	No	Elementary	KG	05	2021	pre_kindergarten_full_day	0.0	0
2475866	NJ	Burlington	5	school	3403690	1030	Delanco Twp	340369001032	30	M. Joan Pearson Elementary School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2475867	NJ	Burlington	5	school	3403690	1030	Delanco Twp	340369001036	60	Walnut Street School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2371542	NJ	Hunterdon	19	school	3403720	1040	Delaware Township School District	340372002974	40	Delaware Township School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2476620	NJ	Hunterdon	19	school	3403720	1040	Delaware Twp	340372002974	40	Delaware Township School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2371543	NJ	Hunterdon	19	school	3403750	1050	Delaware Valley Regional High School District	340375002978	40	Delaware Valley Regional High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2476621	NJ	Hunterdon	19	school	3403750	1050	Delaware Valley Regional	340375002978	40	Delaware Valley Regional High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2370785	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2370786	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378000123	15	Delran Intermediate School	Regular School	No	Elementary	03	05	2021	pre_kindergarten_full_day	0.0	0
2370787	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001042	7	Delran Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten_full_day	0.0	0
2370788	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001050	50	Millbridge Elementary School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten_full_day	12.0	12
2475868	NJ	Burlington	5	school	3403780	1060	Delran Twp	340378001040	5	Delran High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2475869	NJ	Burlington	5	school	3403780	1060	Delran Twp	340378001042	7	Delran Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2475870	NJ	Burlington	5	school	3403780	1060	Delran Twp	340378000123	15	Delran Intermediate School	Regular School	No	Elementary	03	05	2020	pre_kindergarten_full_day	0.0	0
2475871	NJ	Burlington	5	school	3403780	1060	Delran Twp	340378001050	50	Millbridge Elementary School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten_full_day	65.0	65
2370515	NJ	Bergen	3	school	3403810	1070	Demarest School District	340381000334	40	Demarest Middle School	Regular School	No	Middle	05	08	2021	pre_kindergarten_full_day	0.0	0
2370516	NJ	Bergen	3	school	3403810	1070	Demarest School District	340381006085	50	Luther Lee Emerson School	Regular School	No	Elementary	02	04	2021	pre_kindergarten_full_day	0.0	0
2370517	NJ	Bergen	3	school	3403810	1070	Demarest School District	340381000332	30	County Road School	Regular School	No	Elementary	PK	01	2021	pre_kindergarten_full_day	0.0	0
2475599	NJ	Bergen	3	school	3403810	1070	Demarest Boro	340381000332	30	County Road School	Regular School	No	Elementary	PK	01	2020	pre_kindergarten_full_day	0.0	0
2475600	NJ	Bergen	3	school	3403810	1070	Demarest Boro	340381000334	40	Demarest Middle School	Regular School	No	Middle	05	08	2020	pre_kindergarten_full_day	0.0	0
2475601	NJ	Bergen	3	school	3403810	1070	Demarest Boro	340381006085	50	Luther Lee Emerson School	Regular School	No	Elementary	02	04	2020	pre_kindergarten_full_day	0.0	0
2371040	NJ	Cape May	9	school	3403840	1080	Dennis Township School District	340384006115	50	Dennis Township Elementary/Middle Schools	Regular School	No	Middle	03	08	2021	pre_kindergarten_full_day	0.0	0
2371041	NJ	Cape May	9	school	3403840	1080	Dennis Township School District	340384001716	40	Dennis Township Primary School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten_full_day	0.0	0
2476123	NJ	Cape May	9	school	3403840	1080	Dennis Twp	340384001716	40	Dennis Township Primary School	Regular School	No	Elementary	PK	03	2020	pre_kindergarten_full_day	0.0	0
2476124	NJ	Cape May	9	school	3403840	1080	Dennis Twp	340384006115	50	Dennis Township Elementary/Middle Schools	Regular School	No	Middle	04	08	2020	pre_kindergarten_full_day	0.0	0
2372061	NJ	Morris	27	school	3403870	1090	Denville Township K-8 School District	340387004202	50	Lakeview Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten_full_day	30.0	30
2372062	NJ	Morris	27	school	3403870	1090	Denville Township K-8 School District	340387004208	80	Valleyview Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten_full_day	0.0	0
2372063	NJ	Morris	27	school	3403870	1090	Denville Township K-8 School District	340387004206	70	Riverview Elementary School	Regular School	No	Elementary	KG	05	2021	pre_kindergarten_full_day	0.0	0
2477140	NJ	Morris	27	school	3403870	1090	Denville Twp	340387004202	50	Lakeview Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day	41.0	41
2477141	NJ	Morris	27	school	3403870	1090	Denville Twp	340387004206	70	Riverview Elementary School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2477142	NJ	Morris	27	school	3403870	1090	Denville Twp	340387004208	80	Valleyview Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2370409	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000018	60	Texas Avenue School	Regular School	No	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2370410	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000012	30	Sovereign Avenue School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2370411	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000028	120	Richmond Avenue School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2370412	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000030	130	Venice Park School	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten_full_day	0.0	0
2370413	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000026	100	Pennsylvania Ave School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2370414	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096003259	300	Brighton Avenue School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten_full_day	0.0	0
2370415	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000016	50	Chelsea Heights School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2370416	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000010	10	Atlantic City High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2370417	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000020	70	New York Avenue School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2370418	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000032	140	Dr Martin Luther King Jr School Complex	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2370419	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000022	80	Uptown School Complex	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2475492	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000010	10	Atlantic City High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2475493	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000012	30	Sovereign Avenue School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2475494	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000016	50	Chelsea Heights School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2475495	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000018	60	Texas Avenue School	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_full_day	0.0	0
2475496	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000020	70	New York Avenue School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2475497	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000022	80	Uptown School Complex	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2475498	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000026	100	Pennsylvania Ave School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2475499	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000028	120	Richmond Avenue School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2475500	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000030	130	Venice Park School	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_full_day	0.0	0
2475501	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_full_day	0.0	0
2475502	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096003259	300	Brighton Avenue School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day	0.0	0
2371337	NJ	Gloucester	15	school	3403900	1100	Deptford Township Public School District	340390000708	30	Central Early Childhood Center	Regular School	No	Elementary	PK	01	2021	pre_kindergarten_full_day	72.0	72
2371338	NJ	Gloucester	15	school	3403900	1100	Deptford Township Public School District	340390002518	90	Good Intent Elementary School	Regular School	No	Elementary	02	06	2021	pre_kindergarten_full_day	0.0	0
2371339	NJ	Gloucester	15	school	3403900	1100	Deptford Township Public School District	340390002512	40	Deptford Township High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2371340	NJ	Gloucester	15	school	3403900	1100	Deptford Township Public School District	340390002528	140	Shady Lane Elementary School	Regular School	No	Elementary	02	06	2021	pre_kindergarten_full_day	0.0	0
2371341	NJ	Gloucester	15	school	3403900	1100	Deptford Township Public School District	340390002526	130	Pine Acres Early Childhood Center	Regular School	No	Elementary	PK	01	2021	pre_kindergarten_full_day	48.0	48
2371342	NJ	Gloucester	15	school	3403900	1100	Deptford Township Public School District	340390002524	120	Oak Valley Elementary School	Regular School	No	Elementary	02	06	2021	pre_kindergarten_full_day	0.0	0
2371343	NJ	Gloucester	15	school	3403900	1100	Deptford Township Public School District	340390002514	45	Deptford Township Middle School	Regular School	No	Middle	07	08	2021	pre_kindergarten_full_day	0.0	0
2371344	NJ	Gloucester	15	school	3403900	1100	Deptford Township Public School District	340390002520	105	Lake Tract Elementary School	Regular School	No	Elementary	02	06	2021	pre_kindergarten_full_day	0.0	0
2476415	NJ	Gloucester	15	school	3403900	1100	Deptford Twp	340390000708	30	Central Early Childhood Center	Regular School	No	Elementary	PK	01	2020	pre_kindergarten_full_day	122.0	122
2476416	NJ	Gloucester	15	school	3403900	1100	Deptford Twp	340390002512	40	Deptford Township High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476417	NJ	Gloucester	15	school	3403900	1100	Deptford Twp	340390002514	45	Monongahela Middle School	Regular School	No	Middle	07	08	2020	pre_kindergarten_full_day	0.0	0
2476418	NJ	Gloucester	15	school	3403900	1100	Deptford Twp	340390002518	90	Good Intent Elementary School	Regular School	No	Elementary	02	06	2020	pre_kindergarten_full_day	0.0	0
2476419	NJ	Gloucester	15	school	3403900	1100	Deptford Twp	340390002520	105	Lake Tract Elementary School	Regular School	No	Elementary	02	06	2020	pre_kindergarten_full_day	0.0	0
2476420	NJ	Gloucester	15	school	3403900	1100	Deptford Twp	340390002524	120	Oak Valley Elementary School	Regular School	No	Elementary	02	06	2020	pre_kindergarten_full_day	0.0	0
2476421	NJ	Gloucester	15	school	3403900	1100	Deptford Twp	340390002526	130	Pine Acres Early Childhood Center	Regular School	No	Elementary	PK	01	2020	pre_kindergarten_full_day	58.0	58
2476422	NJ	Gloucester	15	school	3403900	1100	Deptford Twp	340390002528	140	Shady Lane Elementary School	Regular School	No	Elementary	02	06	2020	pre_kindergarten_full_day	0.0	0
2372064	NJ	Morris	27	school	3403930	1110	Dover Public School District	340393004214	50	Academy Street Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten_full_day	5.0	5
2372065	NJ	Morris	27	school	3403930	1110	Dover Public School District	340393004212	40	Dover High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2372066	NJ	Morris	27	school	3403930	1110	Dover Public School District	340393004220	70	North Dover Elementary School	Regular School	No	Elementary	PK	06	2021	pre_kindergarten_full_day	0.0	0
2372067	NJ	Morris	27	school	3403930	1110	Dover Public School District	340393004216	60	East Dover Elementary School	Regular School	No	Elementary	KG	06	2021	pre_kindergarten_full_day	0.0	0
2372068	NJ	Morris	27	school	3403930	1110	Dover Public School District	340393003478	300	Votech	Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten_full_day	0.0	0
2372069	NJ	Morris	27	school	3403930	1110	Dover Public School District	340393000005	65	Dover Middle School	Regular School	No	Middle	07	08	2021	pre_kindergarten_full_day	0.0	0
2477143	NJ	Morris	27	school	3403930	1110	Dover Town	340393004212	40	Dover High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477144	NJ	Morris	27	school	3403930	1110	Dover Town	340393004214	50	Academy Street Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_full_day	8.0	8
2477145	NJ	Morris	27	school	3403930	1110	Dover Town	340393004216	60	East Dover Elementary School	Regular School	No	Elementary	KG	06	2020	pre_kindergarten_full_day	0.0	0
2477146	NJ	Morris	27	school	3403930	1110	Dover Town	340393000005	65	Dover Middle School	Regular School	No	Middle	07	08	2020	pre_kindergarten_full_day	0.0	0
2477147	NJ	Morris	27	school	3403930	1110	Dover Town	340393004220	70	North Dover Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_full_day	0.0	0
2371078	NJ	Cumberland	11	school	3403960	1120	Downe Township School District	340396001832	45	Downe Township Elementary School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	0.0	0
2476162	NJ	Cumberland	11	school	3403960	1120	Downe Twp	340396001832	45	Downe Township Elementary School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2370518	NJ	Bergen	3	school	3403990	1130	Dumont Public School District	340399000348	80	Selzer Elementary\Middle School	Regular School	No	Elementary	PK	08	2021	pre_kindergarten_full_day	38.0	38
2370519	NJ	Bergen	3	school	3403990	1130	Dumont Public School District	340399000344	60	Honiss Elementary\Middle School	Regular School	No	Elementary	KG	08	2021	pre_kindergarten_full_day	0.0	0
2370520	NJ	Bergen	3	school	3403990	1130	Dumont Public School District	340399000342	50	Grant Elementary School	Regular School	No	Elementary	KG	05	2021	pre_kindergarten_full_day	0.0	0
2370521	NJ	Bergen	3	school	3403990	1130	Dumont Public School District	340399000346	70	Lincoln Elementary School	Regular School	No	Elementary	KG	05	2021	pre_kindergarten_full_day	0.0	0
2370522	NJ	Bergen	3	school	3403990	1130	Dumont Public School District	340399000340	40	Dumont High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2475602	NJ	Bergen	3	school	3403990	1130	Dumont Boro	340399000340	40	Dumont High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2475603	NJ	Bergen	3	school	3403990	1130	Dumont Boro	340399000342	50	Grant Elementary School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2475604	NJ	Bergen	3	school	3403990	1130	Dumont Boro	340399000344	60	Honiss Elementary\Middle School	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_full_day	0.0	0
2475605	NJ	Bergen	3	school	3403990	1130	Dumont Boro	340399000346	70	Lincoln Elementary School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2475606	NJ	Bergen	3	school	3403990	1130	Dumont Boro	340399000348	80	Selzer Elementary\Middle School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	46.0	46
2371680	NJ	Middlesex	23	school	3404020	1140	Dunellen Public School District	340402003286	40	Dunellen High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day	0.0	0
2371681	NJ	Middlesex	23	school	3404020	1140	Dunellen Public School District	340402000149	60	Lincoln Middle School	Regular School	No	Middle	06	08	2021	pre_kindergarten_full_day	0.0	0
2371682	NJ	Middlesex	23	school	3404020	1140	Dunellen Public School District	340402003288	50	John P. Faber Elementary School	Regular School	No	Elementary	PK	05	2021	pre_kindergarten_full_day	0.0	0
2476758	NJ	Middlesex	23	school	3404020	1140	Dunellen Boro	340402003286	40	Dunellen High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0