schools: enrollments: 512 rows where where grade = "grade_9" and state = "MD" sorted by rowid descending

Data source: Big Local News · About: Big Local

512 rows where grade = "grade_9" and state = "MD" sorted by rowid descending

Search:

descending

Link	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	grade	total	total_int
1315548	1315548	MD	school	2400480	15	Montgomery	240048000496	799	Stephen Knolls School	Special Education School	No	Other	PK	12	2021	grade_9	*
1315533	1315533	MD	school	2400480	15	Montgomery	240048000926	798	Springbrook High	Regular School	No	High	09	12	2021	grade_9	543	543
1315520	1315520	MD	school	2400480	15	Montgomery	240048001366	796	Northwood High School	Regular School	No	High	09	12	2021	grade_9	526	526
1315485	1315485	MD	school	2400480	15	Montgomery	240048000773	789	Albert Einstein High	Regular School	No	High	09	12	2021	grade_9	586	586
1315444	1315444	MD	school	2400480	15	Montgomery	240048000951	782	Wheaton High	Regular School	No	High	09	12	2021	grade_9	737	737
1315333	1315333	MD	school	2400480	15	Montgomery	240048000877	757	Montgomery Blair High	Regular School	No	High	09	12	2021	grade_9	894	894
1315254	1315254	MD	school	2400480	15	Montgomery	240048001455	701	Damascus High	Regular School	No	High	09	12	2021	grade_9	372	372
1315203	1315203	MD	school	2400480	15	Montgomery	240048000956	602	Winston Churchill High	Regular School	No	High	09	12	2021	grade_9	554	554
1315064	1315064	MD	school	2400480	15	Montgomery	240048000838	551	Gaithersburg High	Regular School	No	High	09	12	2021	grade_9	728	728
1315043	1315043	MD	school	2400480	15	Montgomery	240048001525	545	Watkins Mill High	Regular School	No	High	09	12	2021	grade_9	468	468
1315033	1315033	MD	school	2400480	15	Montgomery	240048001441	522	Lakelands Park Middle	Regular School	No	Middle	06	09	2021	grade_9	*
1314973	1314973	MD	school	2400480	15	Montgomery	240048000808	510	Col. Zadok Magruder High	Regular School	No	High	09	12	2021	grade_9	422	422
1314932	1314932	MD	school	2400480	15	Montgomery	240048000921	503	Sherwood High	Regular School	No	High	09	12	2021	grade_9	452	452
1314907	1314907	MD	school	2400480	15	Montgomery	240048000941	427	Walt Whitman High	Regular School	No	High	09	12	2021	grade_9	503	503
1314894	1314894	MD	school	2400480	15	Montgomery	240048000942	424	Walter Johnson High	Regular School	No	High	09	12	2021	grade_9	732	732
1314830	1314830	MD	school	2400480	15	Montgomery	240048000784	406	Bethesda-Chevy Chase High	Regular School	No	High	09	12	2021	grade_9	602	602
1314723	1314723	MD	school	2400480	15	Montgomery	240048001044	321	James Hubert Blake High	Regular School	No	High	09	12	2021	grade_9	531	531
1314710	1314710	MD	school	2400480	15	Montgomery	240048000890	315	Paint Branch High	Regular School	No	High	09	12	2021	grade_9	606	606
1314624	1314624	MD	school	2400480	15	Montgomery	240048001541	249	Clarksburg High	Regular School	No	High	09	12	2021	grade_9	618	618
1314611	1314611	MD	school	2400480	15	Montgomery	240048001040	246	Northwest High	Regular School	No	High	09	12	2021	grade_9	648	648
1314562	1314562	MD	school	2400480	15	Montgomery	240048000934	234	Thomas S. Wootton High	Regular School	No	High	09	12	2021	grade_9	467	467
1314545	1314545	MD	school	2400480	15	Montgomery	240048000912	230	Rockville High	Regular School	No	High	09	12	2021	grade_9	383	383
1314431	1314431	MD	school	2400480	15	Montgomery	240048000902	201	Richard Montgomery High	Regular School	No	High	09	12	2021	grade_9	627	627
1314387	1314387	MD	school	2400480	15	Montgomery	240048000897	152	Poolesville High	Regular School	No	High	09	12	2021	grade_9	328	328
1314382	1314382	MD	school	2400480	15	Montgomery	240048001509	125	Quince Orchard High	Regular School	No	High	09	12	2021	grade_9	528	528
1314325	1314325	MD	school	2400480	15	Montgomery	240048000918	104	Seneca Valley High	Regular School	No	High	09	12	2021	grade_9	710	710
1314268	1314268	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2021	grade_9	158	158
1314243	1314243	MD	school	2400420	13	Howard	240042000822	623	Long Reach High	Regular School	No	High	09	12	2021	grade_9	440	440
1314218	1314218	MD	school	2400420	13	Howard	240042000735	619	Hammond High	Regular School	No	High	09	12	2021	grade_9	307	307
1314178	1314178	MD	school	2400420	13	Howard	240042000745	611	Oakland Mills High	Regular School	No	High	09	12	2021	grade_9	365	365
1314103	1314103	MD	school	2400420	13	Howard	240042001200	527	Reservoir High	Regular School	No	High	09	12	2021	grade_9	468	468
1314086	1314086	MD	school	2400420	13	Howard	240042000816	524	River Hill High	Regular School	No	High	09	12	2021	grade_9	362	362
1314073	1314073	MD	school	2400420	13	Howard	240042001415	522	Cedar Lane Special Center	Special Education School	No	Other	PK	12	2021	grade_9	*
1314035	1314035	MD	school	2400420	13	Howard	240042000762	516	Wilde Lake High	Regular School	No	High	09	12	2021	grade_9	403	403
1314002	1314002	MD	school	2400420	13	Howard	240042000719	509	Atholton High	Regular School	No	High	09	12	2021	grade_9	350	350
1313971	1313971	MD	school	2400420	13	Howard	240042000731	404	Glenelg High	Regular School	No	High	09	12	2021	grade_9	341	341
1313966	1313966	MD	school	2400420	13	Howard	240042001437	308	Marriotts Ridge High	Regular School	No	High	09	12	2021	grade_9	432	432
1313897	1313897	MD	school	2400420	13	Howard	240042000722	214	Centennial High	Regular School	No	High	09	12	2021	grade_9	350	350
1313862	1313862	MD	school	2400420	13	Howard	240042000743	207	Mount Hebron High	Regular School	No	High	09	12	2021	grade_9	403	403
1313850	1313850	MD	school	2400420	13	Howard	240042000738	203	Howard High	Regular School	No	High	09	12	2021	grade_9	444	444
1313777	1313777	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	07	12	2021	grade_9	31	31
1313766	1313766	MD	school	2400390	12	Harford	240039000697	678	Havre de Grace High	Regular School	No	High	09	12	2021	grade_9	218	218
1313733	1313733	MD	school	2400390	12	Harford	240039000710	580	North Harford High	Regular School	No	High	09	12	2021	grade_9	317	317
1313684	1313684	MD	school	2400390	12	Harford	240039000703	391	John Archer School	Special Education School	No	Other	PK	12	2021	grade_9	11	11
1313665	1313665	MD	school	2400390	12	Harford	240039001380	385	C. Milton Wright High	Regular School	No	High	09	12	2021	grade_9	357	357
1313660	1313660	MD	school	2400390	12	Harford	240039000691	382	Fallston High	Regular School	No	High	09	12	2021	grade_9	257	257
1313651	1313651	MD	school	2400390	12	Harford	240039000683	373	Bel Air High	Regular School	No	High	09	12	2021	grade_9	415	415
1313561	1313561	MD	school	2400390	12	Harford	240039000694	304	Harford Technical High	Career and Technical School	No	High	09	12	2021	grade_9	264	264
1313556	1313556	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_9	36	36
1313548	1313548	MD	school	2400390	12	Harford	240039000679	270	Aberdeen High	Regular School	No	High	09	12	2021	grade_9	464	464
1313511	1313511	MD	school	2400390	12	Harford	240039001638	187	Patterson Mill High School	Regular School	No	High	09	12	2021	grade_9	212	212
1313502	1313502	MD	school	2400390	12	Harford	240039000705	181	Joppatowne High	Regular School	No	High	09	12	2021	grade_9	258	258
1313493	1313493	MD	school	2400390	12	Harford	240039000690	176	Edgewood High	Regular School	No	High	09	12	2021	grade_9	411	411
1313410	1313410	MD	school	2400360	11	Garrett	240036000674	3709	Southern Garrett High School	Regular School	No	High	09	12	2021	grade_9	169	169
1313405	1313405	MD	school	2400360	11	Garrett	240036000671	3512	Northern Garrett High School	Regular School	No	High	09	12	2021	grade_9	120	120
1313319	1313319	MD	school	2400330	10	Frederick	240033000655	2610	Walkersville High	Regular School	No	High	09	12	2021	grade_9	333	333
1313290	1313290	MD	school	2400330	10	Frederick	240033000627	2503	Brunswick High	Regular School	No	High	09	12	2021	grade_9	197	197
1313285	1313285	MD	school	2400330	10	Frederick	240033000647	2404	Rock Creek	Special Education School	No	Other	PK	12	2021	grade_9	*
1313254	1313254	MD	school	2400330	10	Frederick	240033001550	2307	Tuscarora High	Regular School	No	High	09	12	2021	grade_9	450	450
1313182	1313182	MD	school	2400330	10	Frederick	240033000629	1509	Catoctin High	Regular School	No	High	09	12	2021	grade_9	199	199
1313140	1313140	MD	school	2400330	10	Frederick	240033001688	920	Oakdale High	Regular School	No	High	09	12	2021	grade_9	391	391
1313090	1313090	MD	school	2400330	10	Frederick	240033000638	912	Linganore High	Regular School	No	High	09	12	2021	grade_9	381	381
1313048	1313048	MD	school	2400330	10	Frederick	240033000616	713	Urbana High	Regular School	No	High	09	12	2021	grade_9	520	520
1313015	1313015	MD	school	2400330	10	Frederick	240033000641	313	Middletown High	Regular School	No	High	09	12	2021	grade_9	292	292
1312952	1312952	MD	school	2400330	10	Frederick	240033000634	213	Gov. Thomas Johnson High	Regular School	No	High	09	12	2021	grade_9	498	498
1312935	1312935	MD	school	2400330	10	Frederick	240033000632	209	Frederick High	Regular School	No	High	09	12	2021	grade_9	430	430
1312930	1312930	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	grade_9	*
1312876	1312876	MD	school	2400300	9	Dorchester	240030000612	713	Cambridge-South Dorchester High School	Regular School	No	High	09	12	2021	grade_9	241	241
1312828	1312828	MD	school	2400300	9	Dorchester	240030000618	207	North Dorchester High School	Regular School	No	High	09	12	2021	grade_9	189	189
1312815	1312815	MD	school	2400270	8	Charles	240027000597	1002	Henry E. Lackey High School	Regular School	No	High	09	12	2021	grade_9	296	296
1312794	1312794	MD	school	2400270	8	Charles	240027001727	802	St. Charles High School	Regular School	No	High	09	12	2021	grade_9	364	364
1312773	1312773	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	grade_9	*
1312722	1312722	MD	school	2400270	8	Charles	240027001416	623	North Point High School	Regular School	No	High	09	12	2021	grade_9	452	452
1312697	1312697	MD	school	2400270	8	Charles	240027000144	619	Westlake High School	Regular School	No	High	09	12	2021	grade_9	311	311
1312628	1312628	MD	school	2400270	8	Charles	240027000607	605	Thomas Stone High School	Regular School	No	High	09	12	2021	grade_9	287	287
1312587	1312587	MD	school	2400270	8	Charles	240027000600	108	Maurice J. McDonough High School	Regular School	No	High	09	12	2021	grade_9	273	273
1312582	1312582	MD	school	2400270	8	Charles	240027000596	106	La Plata High School	Regular School	No	High	09	12	2021	grade_9	298	298
1312565	1312565	MD	school	2400240	7	Cecil	240024090469	905	Rising Sun High	Regular School	No	High	09	12	2021	grade_9	266	266
1312544	1312544	MD	school	2400240	7	Cecil	240024000577	705	Perryville High	Regular School	No	High	09	12	2021	grade_9	225	225
1312499	1312499	MD	school	2400240	7	Cecil	240024000575	514	North East High	Regular School	No	High	09	12	2021	grade_9	299	299
1312410	1312410	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2021	grade_9	302	302
1312393	1312393	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2021	grade_9	160	160
1312380	1312380	MD	school	2400210	6	Carroll	240021000546	1401	South Carroll High	Regular School	No	High	09	12	2021	grade_9	261	261
1312346	1312346	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2021	grade_9	*
1312308	1312308	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2021	grade_9	*
1312288	1312288	MD	school	2400210	6	Carroll	240021000527	712	Carroll Springs School	Special Education School	No	Other	01	12	2021	grade_9	*
1312261	1312261	MD	school	2400210	6	Carroll	240021000552	707	Westminster High	Regular School	No	High	09	12	2021	grade_9	373	373
1312248	1312248	MD	school	2400210	6	Carroll	240021001185	704	Winters Mill High	Regular School	No	High	09	12	2021	grade_9	276	276
1312227	1312227	MD	school	2400210	6	Carroll	240021001672	602	Manchester Valley High	Regular School	No	High	09	12	2021	grade_9	365	365
1312214	1312214	MD	school	2400210	6	Carroll	240021001161	510	Century High	Regular School	No	High	09	12	2021	grade_9	275	275
1312197	1312197	MD	school	2400210	6	Carroll	240021001394	507	Liberty High	Regular School	No	High	09	12	2021	grade_9	237	237
1312133	1312133	MD	school	2400210	6	Carroll	240021000533	202	Francis Scott Key High	Regular School	No	High	09	12	2021	grade_9	246	246
1312112	1312112	MD	school	2400180	5	Caroline	240018000518	801	Colonel Richardson High School	Regular School	No	High	09	12	2021	grade_9	151	151
1312107	1312107	MD	school	2400180	5	Caroline	240018000523	703	North Caroline High School	Regular School	No	High	09	12	2021	grade_9	342	342
1312034	1312034	MD	school	2400150	4	Calvert	240015000516	314	Northern High	Regular School	No	High	09	12	2021	grade_9	378	378
1312014	1312014	MD	school	2400150	4	Calvert	240015001342	217	Huntingtown High School	Regular School	No	High	09	12	2021	grade_9	332	332
1311997	1311997	MD	school	2400150	4	Calvert	240015000508	213	Calvert High	Regular School	No	High	09	12	2021	grade_9	283	283
1311968	1311968	MD	school	2400150	4	Calvert	240015000509	206	Calvert Country School	Special Education School	No	Other	03	12	2021	grade_9	*
1311932	1311932	MD	school	2400150	4	Calvert	240015000611	113	Patuxent High	Regular School	No	High	09	12	2021	grade_9	303	303
1311908	1311908	MD	school	2400120	3	Baltimore County	240012000379	1575	Eastern Technical High School	Career and Technical School	No	High	09	12	2021	grade_9	315	315

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