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 "year" = :p2 order by total_int desc limit 101

Query parameters

This data as json, CSV

rowid	state	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	term	grade	total	total_int
2027182	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2020	fall	grade_9	615	615
610748	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2020	spring	grade_9	611	611
610099	LA	school	2200090	003	Ascension Parish	220009001541	3016	Dutchtown High School	Regular School	No	High	09	12	2020	spring	grade_9	598	598
2026533	LA	school	2200090	003	Ascension Parish	220009001541	3016	Dutchtown High School	Regular School	No	High	09	12	2020	fall	grade_9	598	598
610097	LA	school	2200090	003	Ascension Parish	220009000046	3014	St. Amant High School	Regular School	No	High	09	12	2020	spring	grade_9	555	555
2026531	LA	school	2200090	003	Ascension Parish	220009000046	3014	St. Amant High School	Regular School	No	High	09	12	2020	fall	grade_9	554	554
2026589	LA	school	2200270	008	Bossier Parish	220027000112	8001	Airline High School	Regular School	No	High	08	12	2020	fall	grade_9	543	543
2026724	LA	school	2200330	010	Calcasieu Parish	220033000266	10052	Sulphur High School	Regular School	No	High	09	12	2020	fall	grade_9	531	531
610155	LA	school	2200270	008	Bossier Parish	220027000112	8001	Airline High School	Regular School	No	High	08	12	2020	spring	grade_9	525	525
610736	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2020	spring	grade_9	520	520
610290	LA	school	2200330	010	Calcasieu Parish	220033000266	10052	Sulphur High School	Regular School	No	High	09	12	2020	spring	grade_9	518	518
2027501	LA	school	2201650	052	St. Tammany Parish	220165001285	52026	Mandeville High School	Regular School	No	High	09	12	2020	fall	grade_9	514	514
2026688	LA	school	2200330	010	Calcasieu Parish	220033000216	10003	Alfred M. Barbe High School	Regular School	No	High	09	12	2020	fall	grade_9	512	512
2027170	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2020	fall	grade_9	512	512
610254	LA	school	2200330	010	Calcasieu Parish	220033000216	10003	Alfred M. Barbe High School	Regular School	No	High	09	12	2020	spring	grade_9	506	506
2027551	LA	school	2201680	053	Tangipahoa Parish	220168001319	53024	Ponchatoula High School	Regular School	No	High	09	12	2020	fall	grade_9	505	505
610818	LA	school	2201200	037	Ouachita Parish	220120001017	37036	West Monroe High School	Regular School	No	High	08	12	2020	spring	grade_9	503	503
611067	LA	school	2201650	052	St. Tammany Parish	220165001285	52026	Mandeville High School	Regular School	No	High	09	12	2020	spring	grade_9	503	503
2027252	LA	school	2201200	037	Ouachita Parish	220120001017	37036	West Monroe High School	Regular School	No	High	08	12	2020	fall	grade_9	497	497
611117	LA	school	2201680	053	Tangipahoa Parish	220168001319	53024	Ponchatoula High School	Regular School	No	High	09	12	2020	spring	grade_9	496	496
2027538	LA	school	2201680	053	Tangipahoa Parish	220168001304	53009	Hammond High Magnet School	Regular School	No	High	09	12	2020	fall	grade_9	469	469
610922	LA	school	2201410	044	St. Bernard Parish	220141001125	44006	Chalmette High School	Regular School	No	High	09	12	2020	spring	grade_9	462	462
2027511	LA	school	2201650	052	St. Tammany Parish	220165001294	52037	Slidell High School	Regular School	No	High	09	12	2020	fall	grade_9	462	462
2027522	LA	school	2201650	052	St. Tammany Parish	220165000412	52052	Fontainebleau High School	Regular School	No	High	09	12	2020	fall	grade_9	462	462
2026523	LA	school	2200090	003	Ascension Parish	220009000038	3005	East Ascension High School	Regular School	No	High	09	12	2020	fall	grade_9	457	457
2027356	LA	school	2201410	044	St. Bernard Parish	220141001125	44006	Chalmette High School	Regular School	No	High	09	12	2020	fall	grade_9	455	455
611077	LA	school	2201650	052	St. Tammany Parish	220165001294	52037	Slidell High School	Regular School	No	High	09	12	2020	spring	grade_9	452	452
611104	LA	school	2201680	053	Tangipahoa Parish	220168001304	53009	Hammond High Magnet School	Regular School	No	High	09	12	2020	spring	grade_9	451	451
611088	LA	school	2201650	052	St. Tammany Parish	220165000412	52052	Fontainebleau High School	Regular School	No	High	09	12	2020	spring	grade_9	448	448
2026630	LA	school	2200300	009	Caddo Parish	220030000151	9013	Captain Shreve High School	Regular School	No	High	09	12	2020	fall	grade_9	445	445
2027490	LA	school	2201650	052	St. Tammany Parish	220165001274	52013	Covington High School	Regular School	No	High	09	12	2020	fall	grade_9	444	444
610089	LA	school	2200090	003	Ascension Parish	220009000038	3005	East Ascension High School	Regular School	No	High	09	12	2020	spring	grade_9	440	440
610196	LA	school	2200300	009	Caddo Parish	220030000151	9013	Captain Shreve High School	Regular School	No	High	09	12	2020	spring	grade_9	436	436
2027062	LA	school	2200870	028	Lafayette Parish	220087000678	28019	Lafayette High School	Regular School	No	High	09	12	2020	fall	grade_9	436	436
611056	LA	school	2201650	052	St. Tammany Parish	220165001274	52013	Covington High School	Regular School	No	High	09	12	2020	spring	grade_9	435	435
2027086	LA	school	2200870	028	Lafayette Parish	220087002442	28055	Southside High School	Regular School	No	High	09	12	2020	fall	grade_9	433	433
611079	LA	school	2201650	052	St. Tammany Parish	220165001650	52039	Northshore High School	Regular School	No	High	09	12	2020	spring	grade_9	431	431
611336	LA	school		CHA	Type 2 Charters		345001	University View Academy, Inc. (FRM LA Connections)						2020	spring	grade_9	427	427
2027513	LA	school	2201650	052	St. Tammany Parish	220165001650	52039	Northshore High School	Regular School	No	High	09	12	2020	fall	grade_9	427	427
610652	LA	school	2200870	028	Lafayette Parish	220087002442	28055	Southside High School	Regular School	No	High	09	12	2020	spring	grade_9	426	426
610628	LA	school	2200870	028	Lafayette Parish	220087000678	28019	Lafayette High School	Regular School	No	High	09	12	2020	spring	grade_9	423	423
2026793	LA	school	2200540	017	East Baton Rouge Parish	220054000347	17008	Baton Rouge Magnet High School	Regular School	No	High	09	12	2020	fall	grade_9	423	423
2027771	LA	school		CHA	Type 2 Charters		345001	University View Academy, Inc. (FRM LA Connections)						2020	fall	grade_9	423	423
610962	LA	school	2201530	048	St. John the Baptist Parish	220153001488	48001	East St. John High School	Regular School	No	High	09	12	2020	spring	grade_9	421	421
2026961	LA	school	2200840	026	Jefferson Parish	220084000598	26023	John Ehret High School	Regular School	No	High	09	12	2020	fall	grade_9	418	418
610359	LA	school	2200540	017	East Baton Rouge Parish	220054000347	17008	Baton Rouge Magnet High School	Regular School	No	High	09	12	2020	spring	grade_9	417	417
2027396	LA	school	2201530	048	St. John the Baptist Parish	220153001488	48001	East St. John High School	Regular School	No	High	09	12	2020	fall	grade_9	416	416
2026851	LA	school	2200540	017	East Baton Rouge Parish	220054000447	17102	Woodlawn High School	Regular School	No	High	09	12	2020	fall	grade_9	414	414
610193	LA	school	2200300	009	Caddo Parish	220030000147	9008	C.E. Byrd High School	Regular School	No	High	09	12	2020	spring	grade_9	413	413
2026627	LA	school	2200300	009	Caddo Parish	220030000147	9008	C.E. Byrd High School	Regular School	No	High	09	12	2020	fall	grade_9	411	411
610417	LA	school	2200540	017	East Baton Rouge Parish	220054000447	17102	Woodlawn High School	Regular School	No	High	09	12	2020	spring	grade_9	410	410
610527	LA	school	2200840	026	Jefferson Parish	220084000598	26023	John Ehret High School	Regular School	No	High	09	12	2020	spring	grade_9	400	400
611290	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2020	spring	grade_9	390	390
2027724	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2020	fall	grade_9	389	389
610519	LA	school	2200840	026	Jefferson Parish	220084000585	26010	Bonnabel Magnet Academy High School	Regular School	No	High	09	12	2020	spring	grade_9	384	384
2027207	LA	school	2201140	035	Natchitoches Parish	220114000834	35009	Natchitoches Central High School	Regular School	No	High	09	12	2020	fall	grade_9	375	375
2026953	LA	school	2200840	026	Jefferson Parish	220084000585	26010	Bonnabel Magnet Academy High School	Regular School	No	High	09	12	2020	fall	grade_9	372	372
2027093	LA	school	2200900	029	Lafourche Parish	220090000699	29003	Central Lafourche High School	Regular School	No	High	09	12	2020	fall	grade_9	372	372
610937	LA	school	2201440	045	St. Charles Parish	220144001141	45005	Hahnville High School	Regular School	No	High	09	12	2020	spring	grade_9	370	370
2027371	LA	school	2201440	045	St. Charles Parish	220144001141	45005	Hahnville High School	Regular School	No	High	09	12	2020	fall	grade_9	369	369
2027305	LA	school	2201290	040	Rapides Parish	220129001069	40033	Pineville High School	Regular School	No	High	09	12	2020	fall	grade_9	365	365
610936	LA	school	2201440	045	St. Charles Parish	220144001139	45003	Destrehan High School	Regular School	No	High	09	12	2020	spring	grade_9	362	362
610486	LA	school	2200720	023	Iberia Parish	220072000527	23024	New Iberia Senior High School	Regular School	No	High	09	12	2020	spring	grade_9	360	360
2026920	LA	school	2200720	023	Iberia Parish	220072000527	23024	New Iberia Senior High School	Regular School	No	High	09	12	2020	fall	grade_9	360	360
610659	LA	school	2200900	029	Lafourche Parish	220090000699	29003	Central Lafourche High School	Regular School	No	High	09	12	2020	spring	grade_9	359	359
610871	LA	school	2201290	040	Rapides Parish	220129001069	40033	Pineville High School	Regular School	No	High	09	12	2020	spring	grade_9	359	359
2027370	LA	school	2201440	045	St. Charles Parish	220144001139	45003	Destrehan High School	Regular School	No	High	09	12	2020	fall	grade_9	357	357
610773	LA	school	2201140	035	Natchitoches Parish	220114000834	35009	Natchitoches Central High School	Regular School	No	High	09	12	2020	spring	grade_9	356	356
2027598	LA	school	2201740	055	Terrebonne Parish	220174001368	55036	Terrebonne High School	Regular School	No	High	09	12	2020	fall	grade_9	343	343
610224	LA	school	2200300	009	Caddo Parish	220030000197	9059	Southwood High School	Regular School	No	High	09	12	2020	spring	grade_9	340	340
610726	LA	school	2201020	032	Livingston Parish	220102000767	32014	Live Oak High School	Regular School	No	High	08	12	2020	spring	grade_9	340	340
2026604	LA	school	2200270	008	Bossier Parish	220027000130	8020	Parkway High School	Regular School	No	High	08	12	2020	fall	grade_9	338	338
611140	LA	school	2201740	055	Terrebonne Parish	220174001338	55005	H. L. Bourgeois High School	Regular School	No	High	09	12	2020	spring	grade_9	337	337
2027283	LA	school	2201290	040	Rapides Parish	220129001040	40003	Alexandria Senior High School	Regular School	No	High	09	12	2020	fall	grade_9	337	337
2027574	LA	school	2201740	055	Terrebonne Parish	220174001338	55005	H. L. Bourgeois High School	Regular School	No	High	09	12	2020	fall	grade_9	337	337
2026658	LA	school	2200300	009	Caddo Parish	220030000197	9059	Southwood High School	Regular School	No	High	09	12	2020	fall	grade_9	336	336
611164	LA	school	2201740	055	Terrebonne Parish	220174001368	55036	Terrebonne High School	Regular School	No	High	09	12	2020	spring	grade_9	334	334
2027160	LA	school	2201020	032	Livingston Parish	220102000767	32014	Live Oak High School	Regular School	No	High	08	12	2020	fall	grade_9	332	332
2027736	LA	school	2200125	069	Central Community School District	220012500363	69004	Central High School	Regular School	No	High	09	12	2020	fall	grade_9	330	330
611302	LA	school	2200125	069	Central Community School District	220012500363	69004	Central High School	Regular School	No	High	09	12	2020	spring	grade_9	328	328
2027046	LA	school	2200870	028	Lafayette Parish	220087000660	28002	Acadiana High School	Regular School	No	High	09	12	2020	fall	grade_9	326	326
610849	LA	school	2201290	040	Rapides Parish	220129001040	40003	Alexandria Senior High School	Regular School	No	High	09	12	2020	spring	grade_9	324	324
610612	LA	school	2200870	028	Lafayette Parish	220087000660	28002	Acadiana High School	Regular School	No	High	09	12	2020	spring	grade_9	322	322
2026601	LA	school	2200270	008	Bossier Parish	220027000127	8017	Haughton High School	Regular School	No	High	08	12	2020	fall	grade_9	321	321
610170	LA	school	2200270	008	Bossier Parish	220027000130	8020	Parkway High School	Regular School	No	High	08	12	2020	spring	grade_9	320	320
2026593	LA	school	2200270	008	Bossier Parish	220027000117	8006	Benton High School	Regular School	No	High	08	12	2020	fall	grade_9	318	318
2026862	LA	school	2200540	017	East Baton Rouge Parish	220054002342	17138	Lee High School	Regular School	No	High	09	12	2020	fall	grade_9	310	310
610167	LA	school	2200270	008	Bossier Parish	220027000127	8017	Haughton High School	Regular School	No	High	08	12	2020	spring	grade_9	309	309
2027256	LA	school	2201200	037	Ouachita Parish	220120001939	37046	West Ouachita High School	Regular School	No	High	08	12	2020	fall	grade_9	308	308
2027116	LA	school	2200900	029	Lafourche Parish	220090000725	29029	Thibodaux High School	Regular School	No	High	09	12	2020	fall	grade_9	307	307
610822	LA	school	2201200	037	Ouachita Parish	220120001939	37046	West Ouachita High School	Regular School	No	High	08	12	2020	spring	grade_9	306	306
2026982	LA	school	2200840	026	Jefferson Parish	220084000625	26051	Grace King High School	Regular School	No	High	09	12	2020	fall	grade_9	306	306
610195	LA	school	2200300	009	Caddo Parish	220030001551	9012	Caddo Parish Magnet High School	Regular School	No	High	09	12	2020	spring	grade_9	305	305
2026629	LA	school	2200300	009	Caddo Parish	220030001551	9012	Caddo Parish Magnet High School	Regular School	No	High	09	12	2020	fall	grade_9	305	305
610159	LA	school	2200270	008	Bossier Parish	220027000117	8006	Benton High School	Regular School	No	High	08	12	2020	spring	grade_9	302	302
610548	LA	school	2200840	026	Jefferson Parish	220084000625	26051	Grace King High School	Regular School	No	High	09	12	2020	spring	grade_9	299	299
610682	LA	school	2200900	029	Lafourche Parish	220090000725	29029	Thibodaux High School	Regular School	No	High	09	12	2020	spring	grade_9	299	299
610428	LA	school	2200540	017	East Baton Rouge Parish	220054002342	17138	Lee High School	Regular School	No	High	09	12	2020	spring	grade_9	298	298
2026704	LA	school	2200330	010	Calcasieu Parish	220033000237	10025	Sam Houston High School	Regular School	No	High	09	12	2020	fall	grade_9	296	296
610807	LA	school	2201200	037	Ouachita Parish	220120001001	37019	Ouachita Parish High School	Regular School	No	High	08	12	2020	spring	grade_9	294	294
610270	LA	school	2200330	010	Calcasieu Parish	220033000237	10025	Sam Houston High School	Regular School	No	High	09	12	2020	spring	grade_9	293	293