Data source: Big Local News · About: Big Local

991 rows where grade = "grade_9" and state = "NH" sorted by rowid 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
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
357025 NH     school 3303660 238   Haverhill Cooperative 330366000159 20905 Woodsville Elementary School Public School Regular School No Elementary PK 03 2021   grade_9                                                   0                                             0
357008 NH     school 3302640 141   Dover 330264000094 20460 Woodman Park School Public School Regular School No Elementary PK 04 2021   grade_9                                                   0                                             0
356991 NH     school 3304140 285   Laconia 330414000213 21285 Woodland Heights Elementary School Public School Regular School No Elementary PK 05 2021   grade_9                                                   0                                             0
356974 NH     school 3306060 473   Salem 330606000409 22850 Woodbury School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
356957 NH     school 3307300 582   Winnisquam Regional 330730000466 22955 Winnisquam Regional Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
356940 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_9                                                   122                                             122
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
356906 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
356889 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_9                                                   266                                             266
356872 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_9                                                   0                                             0
356855 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_9                                                   0                                             0
356838 NH     school 3307140 573   Winchester 330714000459 21735 Winchester School Public School Regular School No Elementary PK 08 2021   grade_9                                                   0                                             0
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
356804 NH     school 3307115 572   Wilton-Lyndeborough Cooperative 330711500110 26955 Wilton-Lyndeboro Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
356787 NH     school 3306060 473   Salem 330606000400 22865 William T. Barron Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356770 NH     school 3306060 473   Salem 330606000403 22860 William E. Lancaster School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356753 NH     school 3305940 461   Rochester 330594000386 22690 William Allen School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356736 NH     school 3307050 568   White Mountains Regional 330705000004 26930 Whitefield Elementary School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
356719 NH     school 3307050 568   White Mountains Regional 330705000454 21480 White Mountains Regional High School Public School Regular School No High 09 13 2021   grade_9                                                   128                                             128
356702 NH     school 3304050 279   Keene 330405000207 21200 Wheelock Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356685 NH     school 3304590 335   Manchester 330459000262 21515 Weston Elementary School Public School Regular School No Elementary PK 05 2021   grade_9                                                   0                                             0
356668 NH     school 3307020 563   Westmoreland 330702000450 21230 Westmoreland School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
356651 NH     school 3302610 131   Derry Cooperative 330261000194 27065 West Running Brook Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
356634 NH     school 3306990 559   Wentworth 330699000449 22390 Wentworth Elementary School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
356617 NH     school 3303630 235   Harrisville 330363000156 21155 Wells Memorial School Public School Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
356600 NH     school 3304590 335   Manchester 330459000260 21635 Webster School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356583 NH     school 3304760 352   Merrimack Valley 330476000287 22205 Webster Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356566 NH     school 3306930 555   Weare 330693000023 20720 Weare Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
356549 NH     school 3306910 553   Waterville Valley 330691000446 22385 Waterville Valley Elementary School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
356532 NH     school 3306900 551   Washington 330690000445 20985 Washington Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356515 NH     school 3306870 549   Warren 330687000444 20900 Warren Village School Public School Regular School No Elementary PK 08 2021   grade_9                                                   0                                             0
356498 NH     school 3302990 174   Fall Mountain Regional 330299000121 23010 Walpole Primary School Public School Regular School No Elementary PK 01 2021   grade_9                                                   0                                             0
356481 NH     school 3302990 174   Fall Mountain Regional 330299000122 23015 Walpole Elementary School Public School Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
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
356447 NH     school 3303271 727   Virtual Learning Academy Charter School 330327100693 28650 Virtual Learning Academy (E) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_9                                                   0                                             0
356430 NH     school 3302990 174   Fall Mountain Regional 330299000120 22970 Vilas Elementary School Public School Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
356413 NH     school 3303000 175   Farmington 330300000597 27980 Valley View Community School Public School Regular School No Elementary PK 03 2021   grade_9                                                   0                                             0
356396 NH     school 3306750 539   Unity 330675000441 20180 Unity Elementary School Public School Regular School No Elementary PK 08 2021   grade_9                                                   0                                             0
356379 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School Public School Regular School No Elementary PK 02 2021   grade_9                                                   0                                             0
356362 NH     school 3303330 208   Governor Wentworth Regional 330333000150 22410 Tuftonboro Central School Public School Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
356345 NH     school 3304890 363   Monadnock Regional 330489000305 21725 Troy Elementary School Public School Regular School No Elementary PK 06 2021   grade_9                                                   0                                             0
356328 NH     school 3306720 534   Timberlane Regional 330672000440 22760 Timberlane Regional Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
356311 NH     school 3306720 534   Timberlane Regional 330672000439 22770 Timberlane Regional High School Public School Regular School No High 09 12 2021   grade_9                                                   240                                             240
356294 NH     school 3305580 427   Pembroke 330558000042 26925 Three Rivers School Public School Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
356277 NH     school 3304740 351   Merrimack 330474000280 21035 Thorntons Ferry School Public School Regular School No Elementary PK 04 2021   grade_9                                                   0                                             0
356260 NH     school 3306660 531   Thornton 330666000433 22380 Thornton Central School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
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
356226 NH     school 3303298 741   The Founders Academy Charter School 330329800713 29150 The Founders Academy Charter School (E) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_9                                                   0                                             0
356209 NH     school 3303286 731   The Birches Academy of Academics & Art A Public Charter Sch 330328600704 29055 The Birches Academy of Academics - Art A Public Charter Sch Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
356192 NH     school 3302480 112   Contoocook Valley 330248000075 22330 Temple Elementary School Public School Regular School No Elementary KG 04 2021   grade_9                                                   0                                             0
356175 NH     school 3304050 279   Keene 330405000206 21170 Symonds Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356158 NH     school 3302010 63   Brentwood 330201000030 20555 Swasey Central School Public School Regular School No Elementary PK 05 2021   grade_9                                                   0                                             0
356141 NH     school 3304040 276   Kearsarge Regional 330404000198 22010 Sutton Central Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356124 NH     school 3300039 717   Surry Village Charter School 330003900617 28515 Surry Village Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
356107 NH     school 3304980 371   Nashua 330498000326 21850 Sunset Heights School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
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
356073 NH     school 3306540 515   Sunapee 330654000101 26965 Sunapee Middle High School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
356056 NH     school 3306540 515   Sunapee 330654000430 22005 Sunapee Central School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
356039 NH     school 3300042 721   Strong Foundations Charter School 330004200683 28570 Strong Foundations Charter School Charter Schools approved by the state Regular School Yes Elementary 01 08 2021   grade_9                                                   0                                             0
356022 NH     school 3306480 511   Stratham 330648000429 20615 Stratham Memorial School Public School Regular School No Elementary PK 05 2021   grade_9                                                   0                                             0
356005 NH     school 3306450 509   Stratford 330645000428 22915 Stratford Public School Public School Regular School No Elementary PK 08 2021   grade_9                                                   0                                             0
355988 NH     school 3306420 507   Strafford 330642000427 22100 Strafford School Public School Regular School No Elementary PK 08 2021   grade_9                                                   0                                             0
355971 NH     school 3306360 501   Stewartstown 330636000579 27560 Stewartstown Community School Public School Regular School No Elementary PK 08 2021   grade_9                                                   0                                             0
355954 NH     school 3302340 101   Claremont 330234000045 20140 Stevens High School Public School Regular School No High 09 13 2021   grade_9                                                   124                                             124
355937 NH     school 3306330 499   Stark 330633000423 22910 Stark Village School Public School Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
355920 NH     school 3305940 461   Rochester 330594000394 22700 Spaulding High School Public School Regular School No High 09 12 2021   grade_9                                                   410                                             410
355903 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   grade_9                                                   12                                             12
355886 NH     school 3307300 582   Winnisquam Regional 330730000204 27070 Southwick School Public School Regular School No Elementary 03 05 2021   grade_9                                                   0                                             0
355869 NH     school 3304590 335   Manchester 330459000258 21575 Southside Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
355852 NH     school 3302610 131   Derry Cooperative 330261000087 20405 South Range Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
355835 NH     school 3302480 112   Contoocook Valley 330248000073 22295 South Meadow School Public School Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
355818 NH     school 3304410 319   Londonderry 330441000473 20475 South Londonderry Elementary School Public School Regular School No Elementary 01 05 2021   grade_9                                                   0                                             0
355801 NH     school 3306270 495   South Hampton 330627000422 20815 South Hampton Barnard School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
355784 NH     school 3306260 493   Souhegan Cooperative 330626000034 26860 Souhegan Coop High School Public School Regular School No High 09 12 2021   grade_9                                                   160                                             160
355767 NH     school 3306240 491   Somersworth 330624000420 22830 Somersworth Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
355750 NH     school 3306240 491   Somersworth 330624000418 22845 Somersworth High School Public School Regular School No High 09 12 2021   grade_9                                                   109                                             109
355733 NH     school 3304590 335   Manchester 330459000257 21605 Smyth Road School Public School Regular School No Elementary PK 05 2021   grade_9                                                   0                                             0
355716 NH     school 3304040 276   Kearsarge Regional 330404000197 22020 Simonds Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
355699 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
355682 NH     school 3306150 485   Seabrook 330615000601 27995 Seabrook Middle School Public School Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
355665 NH     school 3306150 485   Seabrook 330615000410 20810 Seabrook Elementary School Public School Regular School No Elementary PK 04 2021   grade_9                                                   0                                             0
355648 NH     school 3305940 461   Rochester 330594000393 22720 School Street School Public School Regular School No Elementary KG 04 2021   grade_9                                                   0                                             0
355631 NH     school 3302990 174   Fall Mountain Regional 330299000119 22995 Sarah Porter School Public School Regular School No Elementary 01 04 2021   grade_9                                                   0                                             0
355614 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
355597 NH     school 3306720 534   Timberlane Regional 330672000596 27910 Sandown North Elementary School Public School Regular School No Elementary 01 05 2021   grade_9                                                   0                                             0
355580 NH     school 3306720 534   Timberlane Regional 330672000438 22775 Sandown Central School Public School Regular School No Elementary PK KG 2021   grade_9                                                   0                                             0
355563 NH     school 3307300 582   Winnisquam Regional 330730000464 22925 Sanbornton Central School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
355546 NH     school 3306080 476   Sanborn Regional 330608000476 20630 Sanborn Regional Middle School Public School Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
355529 NH     school 3306080 476   Sanborn Regional 330608000479 20620 Sanborn Regional High School Public School Regular School No High 09 12 2021   grade_9                                                   145                                             145
355512 NH     school 3304760 352   Merrimack Valley 330476000285 22200 Salisbury Elementary School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
355495 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool Public School Regular School No Prekindergarten PK PK 2021   grade_9                                                   0                                             0
355478 NH     school 3306060 473   Salem 330606000407 22880 Salem High School Public School Regular School No High 09 13 2021   grade_9                                                   285                                             285
355461 NH     school 3306030 471   Rye 330603000399 22470 Rye Junior High School Public School Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
355444 NH     school 3306030 471   Rye 330603000398 22475 Rye Elementary School Public School Regular School No Elementary PK 04 2021   grade_9                                                   0                                             0
355427 NH     school 3306000 467   Rumney 330600000397 22375 Russell Elementary School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
355410 NH     school 3302460 111   Concord 330246000063 20270 Rundlett Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
355393 NH     school 3301740 41   Bedford 330174000681 28560 Ross A. Lurgio Middle School Public School Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
355376 NH     school 3305970 463   Rollinsford 330597000396 22810 Rollinsford Grade School Public School Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
355359 NH     school 3305940 461   Rochester 330594000395 22705 Rochester Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   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]);