Data source: Big Local News · About: Big Local

8,432 rows where state = "NH" and year = 2020 sorted by total_int descending

View and edit SQL

year

  • 2020 · 8,432
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 ▲
268931 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   pk_12_total                                                   3141.0                                             3141
268786 NH     school 3304980 371   Nashua 330498000323 21860 Nashua High School South   Regular School No High 09 12 2020   pk_12_total                                                   1842.0                                             1842
268785 NH     school 3304980 371   Nashua 330498000598 27960 Nashua High School North   Regular School No High 09 12 2020   pk_12_total                                                   1682.0                                             1682
268569 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   pk_12_total                                                   1643.0                                             1643
268524 NH     school 3302460 111   Concord 330246000055 20285 Concord High School   Regular School No High 09 13 2020   pk_12_total                                                   1520.0                                             1520
268491 NH     school 3301740 41   Bedford 330174000680 28555 Bedford High School   Regular School No High 09 12 2020   pk_12_total                                                   1498.0                                             1498
268555 NH     school 3302640 141   Dover 330264000088 20455 Dover Senior High School   Regular School No High 09 12 2020   pk_12_total                                                   1461.0                                             1461
268700 NH     school 3304410 319   Londonderry 330441000484 20490 Londonderry Senior High School   Regular School No High 09 12 2020   pk_12_total                                                   1461.0                                             1461
268718 NH     school 3304590 335   Manchester 330459000253 21505 Manchester Memorial High School   Regular School No High 09 12 2020   pk_12_total                                                   1405.0                                             1405
268670 NH     school 3304050 279   Keene 330405000202 21195 Keene High School   Regular School No High 09 12 2020   pk_12_total                                                   1364.0                                             1364
268855 NH     school 3305940 461   Rochester 330594000394 22700 Spaulding High School   Regular School No High 09 12 2020   pk_12_total                                                   1307.0                                             1307
268717 NH     school 3304590 335   Manchester 330459000244 21510 Manchester Central High School   Regular School No High 09 12 2020   pk_12_total                                                   1306.0                                             1306
268741 NH     school 3304740 351   Merrimack 330474000278 21040 Merrimack High School   Regular School No High 09 12 2020   pk_12_total                                                   1207.0                                             1207
268864 NH     school 3306060 473   Salem 330606000407 22880 Salem High School   Regular School No High 09 12 2020   pk_12_total                                                   1173.0                                             1173
268839 NH     school 3305820 449   Portsmouth 330582000379 22565 Portsmouth High School   Regular School No High 09 12 2020   pk_12_total                                                   1129.0                                             1129
268568 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   1116.0                                             1116
268554 NH     school 3302640 141   Dover 330264000089 20435 Dover Middle School   Regular School No Middle 05 08 2020   pk_12_total                                                   1115.0                                             1115
268779 NH     school 3304980 371   Nashua 330498000317 21890 Elm Street Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   1110.0                                             1110
268645 NH     school 3303930 267   Hudson 330393000179 21050 Alvirne High School   Regular School No High 09 12 2020   pk_12_total                                                   1106.0                                             1106
268901 NH     school 3306720 534   Timberlane Regional 330672000439 22770 Timberlane Regional High School   Regular School No High 09 12 2020   pk_12_total                                                   1084.0                                             1084
268598 NH     school 3303240 199   Goffstown 330324000137 20700 Goffstown High School   Regular School No High 09 12 2020   pk_12_total                                                   1071.0                                             1071
268924 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School   Regular School No High 09 13 2020   pk_12_total                                                   1052.0                                             1052
268920 NH     school 3307170 575   Windham 330717000461 21130 Golden Brook Elementary School   Regular School No Elementary PK 04 2020   pk_12_total                                                   1038.0                                             1038
268922 NH     school 3307170 575   Windham 330717000692 28640 Windham High School   Regular School No High 09 13 2020   pk_12_total                                                   986.0                                             986
268526 NH     school 3302460 111   Concord 330246000063 20270 Rundlett Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   947.0                                             947
268853 NH     school 3305940 461   Rochester 330594000395 22705 Rochester Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   929.0                                             929
268699 NH     school 3304410 319   Londonderry 330441000232 20480 Londonderry Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   923.0                                             923
268600 NH     school 3303240 199   Goffstown 330324000536 26820 Mountain View Middle School   Regular School No Middle 05 08 2020   pk_12_total                                                   869.0                                             869
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
268636 NH     school 3303850 260   Hollis-Brookline Cooperative 330385000170 21810 Hollis-Brookline High School   Regular School No High 09 12 2020   pk_12_total                                                   858.0                                             858
268715 NH     school 3304590 335   Manchester 330459000251 21520 Hillside Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   857.0                                             857
268722 NH     school 3304590 335   Manchester 330459000255 21525 Middle School At Parkside   Regular School No Middle 05 08 2020   pk_12_total                                                   841.0                                             841
268817 NH     school 3305520 423   Oyster River Coop 330552000354 22800 Oyster River High School   Regular School No High 09 12 2020   pk_12_total                                                   832.0                                             832
268756 NH     school 3304830 357   Milford 330483000294 21765 Milford High School   Regular School No High 09 12 2020   pk_12_total                                                   811.0                                             811
268902 NH     school 3306720 534   Timberlane Regional 330672000440 22760 Timberlane Regional Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   808.0                                             808
268868 NH     school 3306060 473   Salem 330606000409 22850 Woodbury School   Regular School No Middle 06 08 2020   pk_12_total                                                   799.0                                             799
267443 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_11                                                   797.0                                             797
266947 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_10                                                   796.0                                             796
268747 NH     school 3304760 352   Merrimack Valley 330476000284 22195 Merrimack Valley High School   Regular School No High 09 12 2020   pk_12_total                                                   795.0                                             795
268607 NH     school 3303330 208   Governor Wentworth Regional 330333000146 22425 Kingswood Regional High School   Regular School No High 09 12 2020   pk_12_total                                                   784.0                                             784
268720 NH     school 3304590 335   Manchester 330459000261 21555 Manchester West High School   Regular School No High 09 12 2020   pk_12_total                                                   783.0                                             783
268648 NH     school 3303930 267   Hudson 330393000181 21060 Hudson Memorial School   Regular School No Middle 06 08 2020   pk_12_total                                                   774.0                                             774
268823 NH     school 3305580 427   Pembroke 330558000359 22620 Pembroke Academy   Regular School No High 09 12 2020   pk_12_total                                                   763.0                                             763
268820 NH     school 3305550 425   Pelham 330555000600 27970 Pelham Elementary School   Regular School No Elementary PK 05 2020   pk_12_total                                                   758.0                                             758
268883 NH     school 3306260 493   Souhegan Cooperative 330626000034 26860 Souhegan Coop High School   Regular School No High 09 12 2020   pk_12_total                                                   750.0                                             750
268496 NH     school 3301740 41   Bedford 330174000681 28560 Ross A. Lurgio Middle School   Regular School No Middle 07 08 2020   pk_12_total                                                   747.0                                             747
268560 NH     school 3302670 142   Dresden 330267000096 20820 Hanover High School   Regular School No High 09 12 2020   pk_12_total                                                   742.0                                             742
268671 NH     school 3304050 279   Keene 330405000203 21185 Keene Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   741.0                                             741
268712 NH     school 3304590 335   Manchester 330459000576 27595 Henry J. McLaughlin Jr. Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   730.0                                             730
268528 NH     school 3302480 112   Contoocook Valley 330248000067 22290 Conval Regional High School   Regular School No High 09 12 2020   pk_12_total                                                   713.0                                             713
268541 NH     school 3302490 113   Conway 330249000076 20345 Kennett High School   Regular School No High 09 12 2020   pk_12_total                                                   713.0                                             713
268781 NH     school 3304980 371   Nashua 330498000319 21875 Fairgrounds Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   696.0                                             696
268492 NH     school 3301740 41   Bedford 330174000017 21005 McKelvie Intermediate School   Regular School No Middle 05 06 2020   pk_12_total                                                   691.0                                             691
268726 NH     school 3304590 335   Manchester 330459000258 21575 Southside Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   691.0                                             691
268930 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pk_12_total                                                   690.0                                             690
268481 NH     school 3301470 17   Amherst 330147000006 21750 Clark-Wilkins School   Regular School No Elementary PK 04 2020   pk_12_total                                                   685.0                                             685
267939 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_12                                                   674.0                                             674
268818 NH     school 3305520 423   Oyster River Coop 330552000355 22790 Oyster River Middle School   Regular School No Middle 05 08 2020   pk_12_total                                                   665.0                                             665
268789 NH     school 3304980 371   Nashua 330498000325 21825 Pennichuck Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   650.0                                             650
268871 NH     school 3306080 476   Sanborn Regional 330608000479 20620 Sanborn Regional High School   Regular School No High 09 12 2020   pk_12_total                                                   646.0                                             646
268484 NH     school 3301590 29   Auburn 330159000011 20530 Auburn Village School   Regular School No Elementary KG 08 2020   pk_12_total                                                   644.0                                             644
268826 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   pk_12_total                                                   635.0                                             635
268502 NH     school 3301950 57   Bow 330195000563 27375 Bow High School   Regular School No High 09 12 2020   pk_12_total                                                   634.0                                             634
268480 NH     school 3301470 17   Amherst 330147000007 21745 Amherst Middle School   Regular School No Middle 05 08 2020   pk_12_total                                                   623.0                                             623
268908 NH     school 3306930 555   Weare 330693000025 26810 Center Woods School   Regular School No Elementary PK 05 2020   pk_12_total                                                   623.0                                             623
268550 NH     school 3302610 131   Derry Cooperative 330261000086 20420 Gilbert H. Hood Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   614.0                                             614
268659 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   pk_12_total                                                   610.0                                             610
268683 NH     school 3304230 295   Lebanon 330423000218 21360 Lebanon High School   Regular School No High 09 12 2020   pk_12_total                                                   603.0                                             603
268821 NH     school 3305550 425   Pelham 330555000358 21105 Pelham High School   Regular School No High 09 12 2020   pk_12_total                                                   599.0                                             599
268754 NH     school 3304830 357   Milford 330483000595 27895 Heron Pond Elementary School   Regular School No Elementary 02 05 2020   pk_12_total                                                   598.0                                             598
268553 NH     school 3302610 131   Derry Cooperative 330261000194 27065 West Running Brook Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   583.0                                             583
268740 NH     school 3304740 351   Merrimack 330474000277 21025 James Mastricola Upper Elementary School   Regular School No Middle 05 06 2020   pk_12_total                                                   571.0                                             571
268793 NH     school 3305040 377   New Boston 330504000329 20715 New Boston Central School   Regular School No Elementary PK 06 2020   pk_12_total                                                   570.0                                             570
268774 NH     school 3304980 371   Nashua 330498000312 21865 Bicentennial Elementary School   Regular School No Elementary PK 05 2020   pk_12_total                                                   569.0                                             569
268744 NH     school 3304740 351   Merrimack 330474000280 21035 Thorntons Ferry School   Regular School No Elementary PK 04 2020   pk_12_total                                                   568.0                                             568
268708 NH     school 3304590 335   Manchester 330459000241 21600 Beech Street School   Regular School No Elementary KG 05 2020   pk_12_total                                                   566.0                                             566
268495 NH     school 3301740 41   Bedford 330174000580 27680 Riddle Brook School   Regular School No Elementary KG 04 2020   pk_12_total                                                   558.0                                             558
268723 NH     school 3304590 335   Manchester 330459000505 26435 Northwest Elementary School   Regular School No Elementary KG 04 2020   pk_12_total                                                   553.0                                             553
268890 NH     school 3306480 511   Stratham 330648000429 20615 Stratham Memorial School   Regular School No Elementary PK 05 2020   pk_12_total                                                   551.0                                             551
268517 NH     school 3302340 101   Claremont 330234000045 20140 Stevens High School   Regular School No High 09 13 2020   pk_12_total                                                   547.0                                             547
268748 NH     school 3304760 352   Merrimack Valley 330476000506 26585 Merrimack Valley Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   547.0                                             547
268803 NH     school 3305280 399   Newmarket 330528000340 21300 Newmarket Elementary School   Regular School No Elementary PK 05 2020   pk_12_total                                                   546.0                                             546
268742 NH     school 3304740 351   Merrimack 330474000602 28375 Merrimack Middle School   Regular School No Middle 07 08 2020   pk_12_total                                                   542.0                                             542
268501 NH     school 3301950 57   Bow 330195000480 20680 Bow Elementary School   Regular School No Elementary PK 04 2020   pk_12_total                                                   541.0                                             541
268676 NH     school 3304140 285   Laconia 330414000210 21255 Laconia High School   Regular School No High 09 13 2020   pk_12_total                                                   539.0                                             539
268757 NH     school 3304830 357   Milford 330483000293 21760 Milford Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   539.0                                             539
268545 NH     school 3302580 127   Deerfield 330258000082 22595 Deerfield Community School   Regular School No Elementary PK 08 2020   pk_12_total                                                   531.0                                             531
268780 NH     school 3304980 371   Nashua 330498000508 21840 Fairgrounds Elementary School   Regular School No Elementary KG 05 2020   pk_12_total                                                   528.0                                             528
268649 NH     school 3303930 267   Hudson 330393000513 26765 Nottingham West Elementary School   Regular School No Elementary 02 05 2020   pk_12_total                                                   527.0                                             527
268814 NH     school 3305460 413   Nottingham 330546000349 22095 Nottingham Elementary School   Regular School No Elementary KG 08 2020   pk_12_total                                                   526.0                                             526
268923 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School   Regular School No Middle 07 08 2020   pk_12_total                                                   526.0                                             526
268494 NH     school 3301740 41   Bedford 330174000019 21000 Peter Woodbury School   Regular School No Elementary KG 04 2020   pk_12_total                                                   518.0                                             518
268701 NH     school 3304410 319   Londonderry 330441000233 20485 Matthew Thornton Elementary School   Regular School No Elementary 01 05 2020   pk_12_total                                                   516.0                                             516
266306 NH     school 3304980 371   Nashua 330498000323 21860 Nashua High School South   Regular School No High 09 12 2020   grade_9                                                   515.0                                             515
268728 NH     school 3304590 335   Manchester 330459000262 21515 Weston Elementary School   Regular School No Elementary PK 05 2020   pk_12_total                                                   514.0                                             514
268840 NH     school 3305820 449   Portsmouth 330582000378 22510 Portsmouth Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   512.0                                             512
268844 NH     school 3305880 453   Raymond 330588000384 21385 Lamprey River Elementary School   Regular School No Elementary PK 04 2020   pk_12_total                                                   508.0                                             508
268558 NH     school 3302640 141   Dover 330264000094 20460 Woodman Park School   Regular School No Elementary PK 04 2020   pk_12_total                                                   507.0                                             507
268503 NH     school 3301950 57   Bow 330195000029 20675 Bow Memorial School   Regular School No Middle 05 08 2020   pk_12_total                                                   505.0                                             505
268663 NH     school 3304040 276   Kearsarge Regional 330404000193 22015 Kearsarge Regional High School   Regular School No High 09 13 2020   pk_12_total                                                   504.0                                             504

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