enrollments

Data source: Big Local News · About: Big Local

991 rows where grade = "grade_7" and state = "NH" sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 891 ✖
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
355340 355340 NH     school 3303287 737   Robert Frost Charter School 330328700703 29070 Robert Frost Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_7                                                   2                                             2
355323 355323 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate School           2021   grade_7                                                   0                                             0
355306 355306 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate School           2021   grade_7                                                   14                                             14
355289 355289 NH     school 3304030 274   Jaffrey-Rindge Cooperative 330403000191 22320 Rindge Memorial School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
355272 355272 NH     school 3301740 41   Bedford 330174000580 27680 Riddle Brook School Public School Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
355255 355255 NH     school 3305310 401   Newport 330531000343 21995 Richards Elementary School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
355238 355238 NH     school 3302070 71   Brookline 330207000031 21800 Richard Maghakian Memorial School Public School Regular School No Elementary PK 03 2021   grade_7                                                   0                                             0
355221 355221 NH     school 3304740 351   Merrimack 330474000279 21015 Reeds Ferry School Public School Regular School No Elementary PK 04 2021   grade_7                                                   0                                             0
355204 355204 NH     school   453   Raymond     Raymond School District Preschool Program             2021   grade_7                                                   0                                             0
355187 355187 NH     school 3305880 453   Raymond 330588000385 21390 Raymond High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
355170 355170 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Joint Maintenance Agreement Regular School No High 09 12 2021   grade_7                                                   0                                             0
355153 355153 NH     school 3305830 450   Profile 330583000382 21395 Profile Senior High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
355136 355136 NH     school 3305830 450   Profile 330583000097 26990 Profile Junior High School Public School Regular School No Middle 07 08 2021   grade_7                                                   49                                             49
355119 355119 NH     school 3305820 449   Portsmouth 330582000378 22510 Portsmouth Middle School Public School Regular School No Middle 06 08 2021   grade_7                                                   177                                             177
355102 355102 NH     school 3305820 449   Portsmouth 330582000379 22565 Portsmouth High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
355085 355085 NH     school 3306720 534   Timberlane Regional 330672000436 22765 Pollard Elementary School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
355068 355068 NH     school 3303290 735   Polaris Charter School 330329000706 29065 Polaris Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_7                                                   0                                             0
355051 355051 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
355034 355034 NH     school 3305790 447   Plymouth 330579000370 22355 Plymouth Elementary School Public School Regular School No Elementary KG 08 2021   grade_7                                                   49                                             49
355017 355017 NH     school 3304140 285   Laconia 330414000212 21260 Pleasant Street School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
355000 355000 NH     school 3305760 441   Plainfield 330576000368 21375 Plainfield Elementary School Public School Regular School No Elementary KG 08 2021   grade_7                                                   16                                             16
354983 354983 NH     school 3305730 439   Pittsfield 330573000539 26550 Pittsfield Middle School Public School Regular School No Middle 06 08 2021   grade_7                                                   38                                             38
354966 354966 NH     school 3305730 439   Pittsfield 330573000366 22500 Pittsfield High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
354949 354949 NH     school 3305730 439   Pittsfield 330573000509 26595 Pittsfield Elementary School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
354932 354932 NH     school 3305700 437   Pittsburg 330570000528 26500 Pittsburg School (High) Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
354915 354915 NH     school 3305700 437   Pittsburg 330570000363 20205 Pittsburg School (Elem) Public School Regular School No Elementary KG 08 2021   grade_7                                                   6                                             6
354898 354898 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_7                                                   0                                             0
354881 354881 NH     school 3302490 113   Conway 330249000079 20330 Pine Tree Elementary School Public School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
354864 354864 NH     school 3305670 435   Piermont 330567000362 20895 Piermont Village School Public School Regular School No Elementary PK 08 2021   grade_7                                                   4                                             4
354847 354847 NH     school 3302480 112   Contoocook Valley 330248000074 22225 Pierce Elementary School Public School Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
354830 354830 NH     school 3302480 112   Contoocook Valley 330248000072 22310 Peterborough Elementary School Public School Regular School No Elementary PK 04 2021   grade_7                                                   0                                             0
354813 354813 NH     school 3301740 41   Bedford 330174000019 21000 Peter Woodbury School Public School Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
354796 354796 NH     school 3304980 371   Nashua 330498000325 21825 Pennichuck Middle School Public School Regular School No Middle 06 08 2021   grade_7                                                   213                                             213
354779 354779 NH     school 3304760 352   Merrimack Valley 330476000283 22185 Penacook Elementary School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
354762 354762 NH     school 3305580 427   Pembroke 330558000361 22615 Pembroke Hill School Public School Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
354745 354745 NH     school 3305580 427   Pembroke 330558000359 22620 Pembroke Academy Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
354728 354728 NH     school 3305550 425   Pelham 330555000357 21110 Pelham Memorial School Public School Regular School No Middle 06 08 2021   grade_7                                                   138                                             138
354711 354711 NH     school 3305550 425   Pelham 330555000358 21105 Pelham High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
354694 354694 NH     school 3305550 425   Pelham 330555000600 27970 Pelham Elementary School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
354677 354677 NH     school 3306780 543   Wakefield 330678000442 22110 Paul Elementary School Public School Regular School No Elementary PK 08 2021   grade_7                                                   42                                             42
354660 354660 NH     school 3303090 185   Franklin 330309000130 20650 Paul A. Smith School Public School Regular School No Elementary PK 03 2021   grade_7                                                   0                                             0
354643 354643 NH     school 3304590 335   Manchester 330459000254 21540 Parker-Varney School Public School Regular School No Elementary PK 04 2021   grade_7                                                   0                                             0
354626 354626 NH     school 3305820 449   Portsmouth 330582000547 22560 PEEP School - Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
354609 354609 NH     school 3303292 728   PACE Career Academy Charter School 330329200701 29035 PACE Career Academy Charter School Charter Schools approved by local district Regular School Yes High 09 13 2021   grade_7                                                   0                                             0
354592 354592 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
354575 354575 NH     school 3305520 423   Oyster River Coop 330552000355 22790 Oyster River Middle School Public School Regular School No Middle 05 08 2021   grade_7                                                   160                                             160
354558 354558 NH     school 3305520 423   Oyster River Coop 330552000354 22800 Oyster River High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354541 354541 NH     school 3303330 208   Governor Wentworth Regional 330333000149 22405 Ossipee Central School Public School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
354524 354524 NH     school 3300616 359   Milton 330061600296 26540 Nute Junior High School Public School Regular School No Middle 06 08 2021   grade_7                                                   43                                             43
354507 354507 NH     school 3300616 359   Milton 330061600544 22070 Nute High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
354490 354490 NH     school 3303930 267   Hudson 330393000513 26765 Nottingham West Elementary School Public School Regular School No Elementary 02 05 2021   grade_7                                                   0                                             0
354473 354473 NH     school 3305460 413   Nottingham 330546000349 22095 Nottingham Elementary School Public School Regular School No Elementary KG 08 2021   grade_7                                                   71                                             71
354456 354456 NH     school 3305430 411   Northwood 330543000348 22085 Northwood Elementary School Public School Regular School No Elementary KG 08 2021   grade_7                                                   39                                             39
354439 354439 NH     school 3304590 335   Manchester 330459000505 26435 Northwest Elementary School Public School Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
354422 354422 NH     school 3303316 716   Northeast Woodland Chartered Public School 330331600741 29231 Northeast Woodland Chartered Public School Charter Schools approved by the state Regular School Yes Elementary PK 07 2021   grade_7                                                   17                                             17
354405 354405 NH     school 3302990 174   Fall Mountain Regional 330299000118 23005 North Walpole School Public School Regular School No Elementary 02 04 2021   grade_7                                                   0                                             0
354388 354388 NH     school 3306060 473   Salem 330606000406 22890 North Salem Elementary School Public School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
354371 354371 NH     school 3304410 319   Londonderry 330441000234 20470 North Londonderry Elementary School Public School Regular School No Elementary 01 05 2021   grade_7                                                   0                                             0
354354 354354 NH     school 3305370 405   North Hampton 330537000345 20805 North Hampton School Public School Regular School No Elementary PK 08 2021   grade_7                                                   25                                             25
354337 354337 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_7                                                   0                                             0
354320 354320 NH     school 3303291 740   Next Charter School 330329100707 29105 Next Charter School Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_7                                                   0                                             0
354303 354303 NH     school 3305310 401   Newport 330531000093 26970 Newport Middle School Public School Regular School No Middle 06 08 2021   grade_7                                                   82                                             82
354286 354286 NH     school 3305310 401   Newport 330531000342 21985 Newport Middle High School (High) Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354269 354269 NH     school 3305280 399   Newmarket 330528000518 23115 Newmarket Jr.-Sr. High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354252 354252 NH     school 3305280 399   Newmarket 330528000542 26560 Newmarket Jr.-Sr. High (Elem) Public School Regular School No Middle 06 08 2021   grade_7                                                   85                                             85
354235 354235 NH     school 3305280 399   Newmarket 330528000340 21300 Newmarket Elementary School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
354218 354218 NH     school 3305250 391   Newington 330525000339 22465 Newington Public School Public School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
354201 354201 NH     school 3305220 388   Newfound Area 330522000336 20085 Newfound Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354184 354184 NH     school 3305220 388   Newfound Area 330522000517 26680 Newfound Memorial Middle School Public School Regular School No Middle 06 08 2021   grade_7                                                   78                                             78
354167 354167 NH     school 3305190 387   Newfields 330519000331 20610 Newfields Elementary School Public School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
354150 354150 NH     school 3304980 371   Nashua 330498000324 21845 New Searles School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
354133 354133 NH     school 3305220 388   Newfound Area 330522000337 20105 New Hampton Community School Public School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
354116 354116 NH     school 3305820 449   Portsmouth 330582000377 22525 New Franklin School Public School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
354099 354099 NH     school 3303330 208   Governor Wentworth Regional 330333000148 22400 New Durham Elementary School Public School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
354082 354082 NH     school 3305040 377   New Boston 330504000329 20715 New Boston Central School Public School Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
354065 354065 NH     school 3305010 375   Nelson 330501000328 21215 Nelson Elementary School Public School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
354048 354048 NH     school 3304980 371   Nashua 330498000714 29152 Nashua Title I Preschool Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
354031 354031 NH     school 3304980 371   Nashua 330498000323 21860 Nashua High School South Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
354014 354014 NH     school 3304980 371   Nashua 330498000598 27960 Nashua High School North Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
353997 353997 NH     school 3305940 461   Rochester 330594000522 22660 Nancy Loud School Public School Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
353980 353980 NH     school 3302990 174   Fall Mountain Regional 330299000117 22980 N. Charlestown Community School Public School Regular School No Elementary 01 05 2021   grade_7                                                   0                                             0
353963 353963 NH     school 3304980 371   Nashua 330498000322 21885 Mt. Pleasant School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
353946 353946 NH     school 3304230 295   Lebanon 330423000220 21355 Mt. Lebanon School Public School Regular School No Elementary PK 04 2021   grade_7                                                   0                                             0
353929 353929 NH     school 3304890 363   Monadnock Regional 330489000302 21695 Mt. Caesar Elementary School Public School Regular School No Elementary PK 02 2021   grade_7                                                   0                                             0
353912 353912 NH     school 3303297 704   Mountain Village Charter School 330329700715 29154 Mountain Village Charter School Charter Schools approved by the state Regular School Yes Elementary 01 08 2021   grade_7                                                   6                                             6
353895 353895 NH     school 3303240 199   Goffstown 330324000536 26820 Mountain View Middle School Public School Regular School No Middle 05 08 2021   grade_7                                                   276                                             276
353878 353878 NH     school 3304960 369   Moultonborough 330496000092 26960 Moultonborough Middle Level Public School Regular School No Middle 05 08 2021   grade_7                                                   48                                             48
353861 353861 NH     school 3304960 369   Moultonborough 330496000147 22115 Moultonborough Central School Public School Regular School No Elementary PK 04 2021   grade_7                                                   0                                             0
353844 353844 NH     school 3304960 369   Moultonborough 330496000527 22120 Moultonborough Academy Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
353827 353827 NH     school 3304410 319   Londonderry 330441000594 27905 Moose Hill School Public School Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
353810 353810 NH     school 3304950 367   Mont Vernon 330495000309 21790 Mont Vernon Village School Public School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
353793 353793 NH     school 3304920 365   Monroe 330492000307 20885 Monroe Consolidated School Public School Regular School No Elementary PK 08 2021   grade_7                                                   6                                             6
353776 353776 NH     school 3304890 363   Monadnock Regional 330489000061 26980 Monadnock Regional Middle School Public School Regular School No Middle 07 08 2021   grade_7                                                   122                                             122
353759 353759 NH     school 3304890 363   Monadnock Regional 330489000301 21700 Monadnock Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
353742 353742 NH     school 3305520 423   Oyster River Coop 330552000520 26660 Moharimet School Public School Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
353725 353725 NH     school 3300616 359   Milton 330061600295 22075 Milton Elementary School Public School Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
353708 353708 NH     school 3303280 729   Mill Falls Charter School 330328000699 29040 Mill Falls Charter School Charter Schools approved by the state Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
353691 353691 NH     school 3302460 111   Concord 330246000056 20250 Mill Brook School Public School Regular School No Elementary PK 02 2021   grade_7                                                   0                                             0
353674 353674 NH     school 3304830 357   Milford 330483000293 21760 Milford Middle School Public School Regular School No Middle 06 08 2021   grade_7                                                   171                                             171
353657 353657 NH     school 3304830 357   Milford 330483000294 21765 Milford High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0

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