Data source: Big Local News · About: Big Local

991 rows where grade = "grade_9" and state = "NH" sorted by total descending

View and edit SQL

year

grade

  • grade_9 · 991
Link 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
353319 NH     school 3304680 343   Mascoma Valley Regional 330468000275 21305 Mascoma Valley Regional High School Public School Regular School No High 09 12 2021   grade_9                                                   97                                             97
266175 NH     school 3304030 274   Jaffrey-Rindge Cooperative 330403000188 22265 Conant High School   Regular School No High 09 12 2020   grade_9                                                   96.0                                             96
351874 NH     school 3303900 263   Hopkinton 330390000177 20970 Hopkinton High School Public School Regular School No High 09 13 2021   grade_9                                                   94                                             94
354288 NH     school 3305310 401   Newport 330531000342 21985 Newport Middle High School (High) Public School Regular School No High 09 13 2021   grade_9                                                   93                                             93
354900 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_9                                                   929                                             929
349120 NH     school 3306180 486   Shaker Regional 330618000411 22145 Belmont High School Public School Regular School No High 09 13 2021   grade_9                                                   88                                             88
266257 NH     school 3304680 343   Mascoma Valley Regional 330468000275 21305 Mascoma Valley Regional High School   Regular School No High 09 12 2020   grade_9                                                   87.0                                             87
266451 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_9                                                   864.0                                             864
266396 NH     school 3306180 486   Shaker Regional 330618000411 22145 Belmont High School   Regular School No High 09 12 2020   grade_9                                                   86.0                                             86
349885 NH     school 3304030 274   Jaffrey-Rindge Cooperative 330403000188 22265 Conant High School Public School Regular School No High 09 12 2021   grade_9                                                   85                                             85
354271 NH     school 3305280 399   Newmarket 330528000518 23115 Newmarket Jr.-Sr. High School Public School Regular School No High 09 13 2021   grade_9                                                   85                                             85
266162 NH     school 3303900 263   Hopkinton 330390000177 20970 Hopkinton High School   Regular School No High 09 12 2020   grade_9                                                   80.0                                             80
352010 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_9                                                   77                                             77
266326 NH     school 3305310 401   Newport 330531000342 21985 Newport Middle High School (High)   Regular School No High 09 13 2020   grade_9                                                   76.0                                             76
356464 NH     school 3303271 727   Virtual Learning Academy Charter School 330327100679 28605 Virtual Learning Academy (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_9                                                   70                                             70
266349 NH     school 3305700 437   Pittsburg 330570000528 26500 Pittsburg School (High)   Regular School No High 09 12 2020   grade_9                                                   7.0                                             7
266461 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H) Public Charter Schools Regular School Yes Secondary 09 09 2020   grade_9                                                   7.0                                             7
354934 NH     school 3305700 437   Pittsburg 330570000528 26500 Pittsburg School (High) Public School Regular School No High 09 12 2021   grade_9                                                   7                                             7
266084 NH     school 3302880 165   Epping 330288000103 20515 Epping High School   Regular School No High 09 12 2020   grade_9                                                   69.0                                             69
353302 NH     school 3304670 342   Mascenic Regional 330467000270 23050 Mascenic Regional High School Public School Regular School No High 09 12 2021   grade_9                                                   68                                             68
266144 NH     school 3303660 238   Haverhill Cooperative 330366000160 20910 Woodsville High School   Regular School No High 09 12 2020   grade_9                                                   67.0                                             67
352894 NH     school 3304380 317   Littleton 330438000229 21445 Littleton High School Public School Regular School No High 09 12 2021   grade_9                                                   67                                             67
266253 NH     school 3304670 342   Mascenic Regional 330467000270 23050 Mascenic Regional High School   Regular School No High 09 12 2020   grade_9                                                   65.0                                             65
266171 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_9                                                   64.0                                             64
348678 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_9                                                   63                                             63
266325 NH     school 3305280 399   Newmarket 330528000518 23115 Newmarket Jr.-Sr. High School   Regular School No High 09 13 2020   grade_9                                                   62.0                                             62
357042 NH     school 3303660 238   Haverhill Cooperative 330366000160 20910 Woodsville High School Public School Regular School No High 09 12 2021   grade_9                                                   61                                             61
266366 NH     school 3305940 461   Rochester 330594000694 22675 Bud Carlson Academy   Regular School No High 09 12 2020   grade_9                                                   6.0                                             6
352690 NH     school 3300043 719   Ledyard Charter School 330004300695 28565 Ledyard Charter School Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_9                                                   6                                             6
350514 NH     school 3302880 165   Epping 330288000103 20515 Epping High School Public School Regular School No High 09 12 2021   grade_9                                                   59                                             59
354968 NH     school 3305730 439   Pittsfield 330573000366 22500 Pittsfield High School Public School Regular School No High 09 12 2021   grade_9                                                   59                                             59
266351 NH     school 3305730 439   Pittsfield 330573000366 22500 Pittsfield High School   Regular School No High 09 12 2020   grade_9                                                   55.0                                             55
266455 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   55.0                                             55
356243 NH     school 3303298 741   The Founders Academy Charter School 330329800717 29149 The Founders Academy Charter School (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_9                                                   55                                             55
354033 NH     school 3304980 371   Nashua 330498000323 21860 Nashua High School South Public School Regular School No High 09 12 2021   grade_9                                                   547                                             547
266104 NH     school 3303000 175   Farmington 330300000123 22050 Farmington Senior High School   Regular School No High 09 12 2020   grade_9                                                   53.0                                             53
266491 NH     school 3303271 727   Virtual Learning Academy Charter School 330327100679 28605 Virtual Learning Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   53.0                                             53
350684 NH     school 3303000 175   Farmington 330300000123 22050 Farmington Senior High School Public School Regular School No High 09 12 2021   grade_9                                                   53                                             53
266306 NH     school 3304980 371   Nashua 330498000323 21860 Nashua High School South   Regular School No High 09 12 2020   grade_9                                                   515.0                                             515
349443 NH     school 3305940 461   Rochester 330594000694 22675 Bud Carlson Academy Public School Regular School No High 09 12 2021   grade_9                                                   5                                             5
349868 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   grade_9                                                   5                                             5
266217 NH     school 3304380 317   Littleton 330438000229 21445 Littleton High School   Regular School No High 09 12 2020   grade_9                                                   49.0                                             49
266438 NH     school 3307115 572   Wilton-Lyndeborough Cooperative 330711500457 23070 Wilton-Lyndeboro Senior High School   Regular School No High 09 12 2020   grade_9                                                   46.0                                             46
354016 NH     school 3304980 371   Nashua 330498000598 27960 Nashua High School North Public School Regular School No High 09 12 2021   grade_9                                                   457                                             457
266305 NH     school 3304980 371   Nashua 330498000598 27960 Nashua High School North   Regular School No High 09 12 2020   grade_9                                                   450.0                                             450
354509 NH     school 3300616 359   Milton 330061600544 22070 Nute High School Public School Regular School No High 09 12 2021   grade_9                                                   45                                             45
266089 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_9                                                   437.0                                             437
266331 NH     school 3305400 407   Northumberland 330540000347 22900 Groveton High School   Regular School No High 09 12 2020   grade_9                                                   43.0                                             43
266151 NH     school 3303780 255   Hinsdale 330378000168 21675 Hinsdale High School   Regular School No High 09 12 2020   grade_9                                                   42.0                                             42
266238 NH     school 3304590 335   Manchester 330459000253 21505 Manchester Memorial High School   Regular School No High 09 12 2020   grade_9                                                   418.0                                             418
266044 NH     school 3302460 111   Concord 330246000055 20285 Concord High School   Regular School No High 09 13 2020   grade_9                                                   410.0                                             410
355920 NH     school 3305940 461   Rochester 330594000394 22700 Spaulding High School Public School Regular School No High 09 12 2021   grade_9                                                   410                                             410
355155 NH     school 3305830 450   Profile 330583000382 21395 Profile Senior High School Public School Regular School No High 09 12 2021   grade_9                                                   41                                             41
266075 NH     school 3302640 141   Dover 330264000088 20455 Dover Senior High School   Regular School No High 09 12 2020   grade_9                                                   405.0                                             405
266489 NH     school 3303298 741   The Founders Academy Charter School 330329800717 29149 The Founders Academy Charter School (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   40.0                                             40
350208 NH     school 3302640 141   Dover 330264000088 20455 Dover Senior High School Public School Regular School No High 09 12 2021   grade_9                                                   395                                             395
266413 NH     school 3306540 515   Sunapee 330654000431 22000 Sunapee Sr. High School   Regular School No High 09 13 2020   grade_9                                                   39.0                                             39
351738 NH     school 3303780 255   Hinsdale 330378000168 21675 Hinsdale High School Public School Regular School No High 09 12 2021   grade_9                                                   39                                             39
266220 NH     school 3304410 319   Londonderry 330441000484 20490 Londonderry Senior High School   Regular School No High 09 12 2020   grade_9                                                   382.0                                             382
266237 NH     school 3304590 335   Manchester 330459000244 21510 Manchester Central High School   Regular School No High 09 12 2020   grade_9                                                   372.0                                             372
266279 NH     school 3300616 359   Milton 330061600544 22070 Nute High School   Regular School No High 09 12 2020   grade_9                                                   37.0                                             37
266290 NH     school 3304960 369   Moultonborough 330496000527 22120 Moultonborough Academy   Regular School No High 09 12 2020   grade_9                                                   37.0                                             37
350599 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_9                                                   368                                             368
349902 NH     school 3302460 111   Concord 330246000055 20285 Concord High School Public School Regular School No High 09 13 2021   grade_9                                                   366                                             366
349069 NH     school 3301740 41   Bedford 330174000680 28555 Bedford High School Public School Regular School No High 09 13 2021   grade_9                                                   364                                             364
266039 NH     school 3302400 105   Colebrook 330240000049 20185 Colebrook Academy and Elementary School (H)   Regular School No High 09 12 2020   grade_9                                                   36.0                                             36
266362 NH     school 3305830 450   Profile 330583000382 21395 Profile Senior High School   Regular School No High 09 12 2020   grade_9                                                   36.0                                             36
351296 NH     school 3305400 407   Northumberland 330540000347 22900 Groveton High School Public School Regular School No High 09 12 2021   grade_9                                                   36                                             36
352367 NH     school 3304050 279   Keene 330405000202 21195 Keene High School Public School Regular School No High 09 12 2021   grade_9                                                   357                                             357
266011 NH     school 3301740 41   Bedford 330174000680 28555 Bedford High School   Regular School No High 09 12 2020   grade_9                                                   355.0                                             355
266375 NH     school 3305940 461   Rochester 330594000394 22700 Spaulding High School   Regular School No High 09 12 2020   grade_9                                                   343.0                                             343
266122 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_9                                                   34.0                                             34
351109 NH     school 3303296 702   Granite State Arts Academy Charter School 330329600711 29153 Granite State Arts Academy Charter School Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_9                                                   34                                             34
352486 NH     school 3303308 708   Kreiva Academy Public Charter School District 330330800727 29192 Kreiva Academy Public Charter School (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_9                                                   34                                             34
266190 NH     school 3304050 279   Keene 330405000202 21195 Keene High School   Regular School No High 09 12 2020   grade_9                                                   339.0                                             339
356821 NH     school 3307115 572   Wilton-Lyndeborough Cooperative 330711500457 23070 Wilton-Lyndeboro Senior High School Public School Regular School No High 09 12 2021   grade_9                                                   33                                             33
353115 NH     school 3304590 335   Manchester 330459000253 21505 Manchester Memorial High School Public School Regular School No High 09 12 2021   grade_9                                                   323                                             323
352928 NH     school 3304410 319   Londonderry 330441000484 20490 Londonderry Senior High School Public School Regular School No High 09 12 2021   grade_9                                                   321                                             321
353098 NH     school 3304590 335   Manchester 330459000244 21510 Manchester Central High School Public School Regular School No High 09 12 2021   grade_9                                                   321                                             321
351058 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_9                                                   32                                             32
356090 NH     school 3306540 515   Sunapee 330654000431 22000 Sunapee Sr. High School Public School Regular School No High 09 13 2021   grade_9                                                   32                                             32
351007 NH     school 3303240 199   Goffstown 330324000137 20700 Goffstown High School Public School Regular School No High 09 12 2021   grade_9                                                   311                                             311
266384 NH     school 3306060 473   Salem 330606000407 22880 Salem High School   Regular School No High 09 12 2020   grade_9                                                   310.0                                             310
352826 NH     school 3304290 306   Lisbon Regional 330429000227 23100 Lisbon Regional School (High) Public School Regular School No High 09 13 2021   grade_9                                                   30                                             30
266444 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School   Regular School No High 09 13 2020   grade_9                                                   299.0                                             299
266471 NH     school 3303289 733   Making Community Connections Charter School 330328900720 29160 Making Community Connections Charter School - Monadnock Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   29.0                                             29
353846 NH     school 3304960 369   Moultonborough 330496000527 22120 Moultonborough Academy Public School Regular School No High 09 13 2021   grade_9                                                   29                                             29
266118 NH     school 3303240 199   Goffstown 330324000137 20700 Goffstown High School   Regular School No High 09 12 2020   grade_9                                                   288.0                                             288
266359 NH     school 3305820 449   Portsmouth 330582000379 22565 Portsmouth High School   Regular School No High 09 12 2020   grade_9                                                   285.0                                             285
355478 NH     school 3306060 473   Salem 330606000407 22880 Salem High School Public School Regular School No High 09 13 2021   grade_9                                                   285                                             285
353489 NH     school 3304740 351   Merrimack 330474000278 21040 Merrimack High School Public School Regular School No High 09 12 2021   grade_9                                                   282                                             282
356923 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_9                                                   281                                             281
266464 NH     school 3303296 702   Granite State Arts Academy Charter School 330329600711 29153 Granite State Arts Academy Charter School Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   28.0                                             28
349834 NH     school 3302400 105   Colebrook 330240000049 20185 Colebrook Academy and Elementary School (H) Public School Regular School No High 09 12 2021   grade_9                                                   28                                             28
266165 NH     school 3303930 267   Hudson 330393000179 21050 Alvirne High School   Regular School No High 09 12 2020   grade_9                                                   278.0                                             278
348797 NH     school 3303930 267   Hudson 330393000179 21050 Alvirne High School Public School Regular School No High 09 12 2021   grade_9                                                   275                                             275
266261 NH     school 3304740 351   Merrimack 330474000278 21040 Merrimack High School   Regular School No High 09 12 2020   grade_9                                                   274.0                                             274
266442 NH     school 3307170 575   Windham 330717000692 28640 Windham High School   Regular School No High 09 13 2020   grade_9                                                   271.0                                             271
266421 NH     school 3306720 534   Timberlane Regional 330672000439 22770 Timberlane Regional High School   Regular School No High 09 12 2020   grade_9                                                   270.0                                             270
356889 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_9                                                   266                                             266

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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