enrollments

Data source: Big Local News · About: Big Local

991 rows where grade = "grade_2" and state = "NH" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 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 ▲
262968 262968 NH     school 3307170 575   Windham 330717000461 21130 Golden Brook Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   205.0                                             205
351017 351017 NH     school 3307170 575   Windham 330717000461 21130 Golden Brook Elementary School Public School Regular School No Elementary PK 04 2021   grade_2                                                   194                                             194
262619 262619 NH     school 3302970 173   Exeter 330297000109 20575 Main Street School   Regular School No Elementary PK 02 2020   grade_2                                                   154.0                                             154
351578 351578 NH     school 3304830 357   Milford 330483000595 27895 Heron Pond Elementary School Public School Regular School No Elementary 02 05 2021   grade_2                                                   145                                             145
349759 349759 NH     school 3301470 17   Amherst 330147000006 21750 Clark-Wilkins School Public School Regular School No Elementary PK 04 2021   grade_2                                                   144                                             144
350796 350796 NH     school 3303870 261   Hooksett 330387000173 20550 Fred C. Underhill School Public School Regular School No Elementary PK 02 2021   grade_2                                                   137                                             137
353023 353023 NH     school 3302970 173   Exeter 330297000109 20575 Main Street School Public School Regular School No Elementary PK 02 2021   grade_2                                                   134                                             134
262802 262802 NH     school 3304830 357   Milford 330483000595 27895 Heron Pond Elementary School   Regular School No Elementary 02 05 2020   grade_2                                                   133.0                                             133
262529 262529 NH     school 3301470 17   Amherst 330147000006 21750 Clark-Wilkins School   Regular School No Elementary PK 04 2020   grade_2                                                   128.0                                             128
262697 262697 NH     school 3303930 267   Hudson 330393000513 26765 Nottingham West Elementary School   Regular School No Elementary 02 05 2020   grade_2                                                   127.0                                             127
262771 262771 NH     school 3304590 335   Manchester 330459000505 26435 Northwest Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   127.0                                             127
262687 262687 NH     school 3303870 261   Hooksett 330387000173 20550 Fred C. Underhill School   Regular School No Elementary PK 02 2020   grade_2                                                   126.0                                             126
353176 353176 NH     school 3303240 199   Goffstown 330324000139 20690 Maple Avenue School Public School Regular School No Elementary 01 04 2021   grade_2                                                   123                                             123
354689 354689 NH     school 3305550 425   Pelham 330555000600 27970 Pelham Elementary School Public School Regular School No Elementary PK 05 2021   grade_2                                                   123                                             123
355267 355267 NH     school 3301740 41   Bedford 330174000580 27680 Riddle Brook School Public School Regular School No Elementary KG 04 2021   grade_2                                                   121                                             121
353686 353686 NH     school 3302460 111   Concord 330246000056 20250 Mill Brook School Public School Regular School No Elementary PK 02 2021   grade_2                                                   120                                             120
262543 262543 NH     school 3301740 41   Bedford 330174000580 27680 Riddle Brook School   Regular School No Elementary KG 04 2020   grade_2                                                   117.0                                             117
262647 262647 NH     school 3303240 199   Goffstown 330324000139 20690 Maple Avenue School   Regular School No Elementary 01 04 2020   grade_2                                                   116.0                                             116
262868 262868 NH     school 3305550 425   Pelham 330555000600 27970 Pelham Elementary School   Regular School No Elementary PK 05 2020   grade_2                                                   116.0                                             116
262749 262749 NH     school 3304410 319   Londonderry 330441000233 20485 Matthew Thornton Elementary School   Regular School No Elementary 01 05 2020   grade_2                                                   113.0                                             113
262573 262573 NH     school 3302460 111   Concord 330246000056 20250 Mill Brook School   Regular School No Elementary PK 02 2020   grade_2                                                   109.0                                             109
262751 262751 NH     school 3304410 319   Londonderry 330441000234 20470 North Londonderry Elementary School   Regular School No Elementary 01 05 2020   grade_2                                                   108.0                                             108
351952 351952 NH     school 3306240 491   Somersworth 330624000732 29202 Idlehurst Elementary School Public School Regular School No Elementary PK 02 2021   grade_2                                                   106                                             106
351391 351391 NH     school 3303510 225   Hampton 330351000469 20770 Hampton Centre School Public School Regular School No Elementary PK 02 2021   grade_2                                                   104                                             104
262927 262927 NH     school 3306240 491   Somersworth 330624000732 29202 Idlehurst Elementary School   Regular School No Elementary PK 02 2020   grade_2                                                   103.0                                             103
354808 354808 NH     school 3301740 41   Bedford 330174000019 21000 Peter Woodbury School Public School Regular School No Elementary KG 04 2021   grade_2                                                   103                                             103
262695 262695 NH     school 3303930 267   Hudson 330393000593 27900 Hills Garrison Elementary School   Regular School No Elementary 02 05 2020   grade_2                                                   102.0                                             102
356270 356270 NH     school 3304740 351   Merrimack 330474000280 21035 Thorntons Ferry School Public School Regular School No Elementary PK 04 2021   grade_2                                                   102                                             102
349300 349300 NH     school 3301950 57   Bow 330195000480 20680 Bow Elementary School Public School Regular School No Elementary PK 04 2021   grade_2                                                   101                                             101
262542 262542 NH     school 3301740 41   Bedford 330174000019 21000 Peter Woodbury School   Regular School No Elementary KG 04 2020   grade_2                                                   100.0                                             100
262662 262662 NH     school 3303480 223   Hampstead 330348000153 22755 Hampstead Central School   Regular School No Elementary PK 04 2020   grade_2                                                   100.0                                             100
262752 262752 NH     school 3304410 319   Londonderry 330441000473 20475 South Londonderry Elementary School   Regular School No Elementary 01 05 2020   grade_2                                                   100.0                                             100
262792 262792 NH     school 3304740 351   Merrimack 330474000280 21035 Thorntons Ferry School   Regular School No Elementary PK 04 2020   grade_2                                                   100.0                                             100
356015 356015 NH     school 3306480 511   Stratham 330648000429 20615 Stratham Memorial School Public School Regular School No Elementary PK 05 2021   grade_2                                                   100                                             100
354485 354485 NH     school 3303930 267   Hudson 330393000513 26765 Nottingham West Elementary School Public School Regular School No Elementary 02 05 2021   grade_2                                                   99                                             99
355216 355216 NH     school 3304740 351   Merrimack 330474000279 21015 Reeds Ferry School Public School Regular School No Elementary PK 04 2021   grade_2                                                   99                                             99
262742 262742 NH     school 3304350 315   Litchfield 330435000228 21095 Griffin Memorial School   Regular School No Elementary PK 04 2020   grade_2                                                   98.0                                             98
262756 262756 NH     school 3304590 335   Manchester 330459000241 21600 Beech Street School   Regular School No Elementary KG 05 2020   grade_2                                                   97.0                                             97
262549 262549 NH     school 3301950 57   Bow 330195000480 20680 Bow Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   96.0                                             96
262534 262534 NH     school 3301650 33   Barrington 330165000013 22045 Barrington Elementary School   Regular School No Elementary 01 04 2020   grade_2                                                   95.0                                             95
262604 262604 NH     school 3302640 141   Dover 330264000090 20430 Garrison School   Regular School No Elementary KG 04 2020   grade_2                                                   95.0                                             95
348977 348977 NH     school 3301650 33   Barrington 330165000013 22045 Barrington Elementary School Public School Regular School No Elementary 01 04 2021   grade_2                                                   95                                             95
352581 352581 NH     school 3305880 453   Raymond 330588000384 21385 Lamprey River Elementary School Public School Regular School No Elementary KG 03 2021   grade_2                                                   95                                             95
349572 349572 NH     school 3306930 555   Weare 330693000025 26810 Center Woods School Public School Regular School No Elementary PK 05 2021   grade_2                                                   93                                             93
351782 351782 NH     school 3303840 259   Hollis 330384000171 21815 Hollis Primary School Public School Regular School No Elementary PK 03 2021   grade_2                                                   93                                             93
350065 350065 NH     school 3306080 476   Sanborn Regional 330608000478 20625 Daniel J. Bakie School Public School Regular School No Elementary PK 03 2021   grade_2                                                   92                                             92
262938 262938 NH     school 3306480 511   Stratham 330648000429 20615 Stratham Memorial School   Regular School No Elementary PK 05 2020   grade_2                                                   91.0                                             91
262606 262606 NH     school 3302640 141   Dover 330264000094 20460 Woodman Park School   Regular School No Elementary PK 04 2020   grade_2                                                   90.0                                             90
350609 350609 NH     school 3304980 371   Nashua 330498000508 21840 Fairgrounds Elementary School Public School Regular School No Elementary KG 05 2021   grade_2                                                   90                                             90
351629 351629 NH     school 3303930 267   Hudson 330393000593 27900 Hills Garrison Elementary School Public School Regular School No Elementary 02 05 2021   grade_2                                                   90                                             90
354434 354434 NH     school 3304590 335   Manchester 330459000505 26435 Northwest Elementary School Public School Regular School No Elementary KG 04 2021   grade_2                                                   90                                             90
350490 350490 NH     school 3302880 165   Epping 330288000102 26510 Epping Elementary School Public School Regular School No Elementary PK 05 2021   grade_2                                                   88                                             88
262758 262758 NH     school 3304590 335   Manchester 330459000248 21610 Green Acres School   Regular School No Elementary PK 05 2020   grade_2                                                   87.0                                             87
262851 262851 NH     school 3305280 399   Newmarket 330528000340 21300 Newmarket Elementary School   Regular School No Elementary PK 05 2020   grade_2                                                   87.0                                             87
262863 262863 NH     school 3305520 423   Oyster River Coop 330552000352 22805 Mast Way School   Regular School No Elementary KG 04 2020   grade_2                                                   87.0                                             87
354366 354366 NH     school 3304410 319   Londonderry 330441000234 20470 North Londonderry Elementary School Public School Regular School No Elementary 01 05 2021   grade_2                                                   87                                             87
262545 262545 NH     school 3301860 51   Berlin 330186000163 27035 Berlin Elementary School   Regular School No Elementary PK 05 2020   grade_2                                                   86.0                                             86
262830 262830 NH     school 3304980 371   Nashua 330498000320 21915 Ledge Street School   Regular School No Elementary KG 05 2020   grade_2                                                   86.0                                             86
349232 349232 NH     school 3304980 371   Nashua 330498000312 21865 Bicentennial Elementary School Public School Regular School No Elementary PK 05 2021   grade_2                                                   86                                             86
351238 351238 NH     school 3304350 315   Litchfield 330435000228 21095 Griffin Memorial School Public School Regular School No Elementary PK 04 2021   grade_2                                                   86                                             86
262554 262554 NH     school 3302070 71   Brookline 330207000031 21800 Richard Maghakian Memorial School   Regular School No Elementary PK 03 2020   grade_2                                                   85.0                                             85
262822 262822 NH     school 3304980 371   Nashua 330498000312 21865 Bicentennial Elementary School   Regular School No Elementary PK 05 2020   grade_2                                                   85.0                                             85
354230 354230 NH     school 3305280 399   Newmarket 330528000340 21300 Newmarket Elementary School Public School Regular School No Elementary PK 05 2021   grade_2                                                   85                                             85
262668 262668 NH     school 3303600 233   Hanover 330360000155 20830 Bernice A. Ray School   Regular School No Elementary KG 05 2020   grade_2                                                   83.0                                             83
262682 262682 NH     school 3303840 259   Hollis 330384000171 21815 Hollis Primary School   Regular School No Elementary PK 03 2020   grade_2                                                   83.0                                             83
262892 262892 NH     school 3305880 453   Raymond 330588000384 21385 Lamprey River Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   83.0                                             83
349079 349079 NH     school 3304590 335   Manchester 330459000241 21600 Beech Street School Public School Regular School No Elementary KG 05 2021   grade_2                                                   83                                             83
353363 353363 NH     school 3304410 319   Londonderry 330441000233 20485 Matthew Thornton Elementary School Public School Regular School No Elementary 01 05 2021   grade_2                                                   83                                             83
357001 357001 NH     school 3302640 141   Dover 330264000094 20460 Woodman Park School Public School Regular School No Elementary PK 04 2021   grade_2                                                   83                                             83
262773 262773 NH     school 3304590 335   Manchester 330459000257 21605 Smyth Road School   Regular School No Elementary PK 05 2020   grade_2                                                   82.0                                             82
262775 262775 NH     school 3304590 335   Manchester 330459000260 21635 Webster School   Regular School No Elementary KG 05 2020   grade_2                                                   82.0                                             82
262791 262791 NH     school 3304740 351   Merrimack 330474000279 21015 Reeds Ferry School   Regular School No Elementary PK 04 2020   grade_2                                                   82.0                                             82
262826 262826 NH     school 3304980 371   Nashua 330498000486 21835 Dr. Norman W. Crisp School   Regular School No Elementary KG 05 2020   grade_2                                                   82.0                                             82
350558 350558 NH     school 3302610 131   Derry Cooperative 330261000607 28465 Ernest P. Barka Elementary School Public School Regular School No Elementary KG 05 2021   grade_2                                                   82                                             82
262597 262597 NH     school 3302610 131   Derry Cooperative 330261000607 28465 Ernest P. Barka Elementary School   Regular School No Elementary KG 05 2020   grade_2                                                   81.0                                             81
262828 262828 NH     school 3304980 371   Nashua 330498000508 21840 Fairgrounds Elementary School   Regular School No Elementary KG 05 2020   grade_2                                                   81.0                                             81
354077 354077 NH     school 3305040 377   New Boston 330504000329 20715 New Boston Central School Public School Regular School No Elementary PK 06 2021   grade_2                                                   81                                             81
262666 262666 NH     school 3303510 225   Hampton 330351000469 20770 Hampton Centre School   Regular School No Elementary PK 02 2020   grade_2                                                   80.0                                             80
262956 262956 NH     school 3306930 555   Weare 330693000025 26810 Center Woods School   Regular School No Elementary PK 05 2020   grade_2                                                   80.0                                             80
348926 348926 NH     school 3301590 29   Auburn 330159000011 20530 Auburn Village School Public School Regular School No Elementary KG 08 2021   grade_2                                                   80                                             80
353414 353414 NH     school 3304590 335   Manchester 330459000485 21565 McDonough School Public School Regular School No Elementary KG 05 2021   grade_2                                                   80                                             80
355811 355811 NH     school 3304410 319   Londonderry 330441000473 20475 South Londonderry Elementary School Public School Regular School No Elementary 01 05 2021   grade_2                                                   80                                             80
262814 262814 NH     school 3304890 363   Monadnock Regional 330489000302 21695 Mt. Caesar Elementary School   Regular School No Elementary PK 02 2020   grade_2                                                   79.0                                             79
353448 353448 NH     school 3301740 41   Bedford 330174000018 20990 Memorial School Public School Regular School No Elementary PK 04 2021   grade_2                                                   78                                             78
356678 356678 NH     school 3304590 335   Manchester 330459000262 21515 Weston Elementary School Public School Regular School No Elementary PK 05 2021   grade_2                                                   78                                             78
262605 262605 NH     school 3302640 141   Dover 330264000091 20445 Horne Street School   Regular School No Elementary KG 04 2020   grade_2                                                   76.0                                             76
349147 349147 NH     school 3301860 51   Berlin 330186000163 27035 Berlin Elementary School Public School Regular School No Elementary PK 05 2021   grade_2                                                   76                                             76
262541 262541 NH     school 3301740 41   Bedford 330174000018 20990 Memorial School   Regular School No Elementary PK 04 2020   grade_2                                                   75.0                                             75
262831 262831 NH     school 3304980 371   Nashua 330498000321 21935 Main Dunstable School   Regular School No Elementary KG 05 2020   grade_2                                                   75.0                                             75
262883 262883 NH     school 3305820 449   Portsmouth 330582000376 22515 Little Harbour School   Regular School No Elementary KG 05 2020   grade_2                                                   75.0                                             75
262946 262946 NH     school 3306720 534   Timberlane Regional 330672000436 22765 Pollard Elementary School   Regular School No Elementary PK 05 2020   grade_2                                                   75.0                                             75
352139 352139 NH     school 3304740 351   Merrimack 330474000276 21020 James Mastricola Elementary School Public School Regular School No Elementary PK 04 2021   grade_2                                                   75                                             75
354638 354638 NH     school 3304590 335   Manchester 330459000254 21540 Parker-Varney School Public School Regular School No Elementary PK 04 2021   grade_2                                                   75                                             75
349198 349198 NH     school 3303600 233   Hanover 330360000155 20830 Bernice A. Ray School Public School Regular School No Elementary KG 05 2021   grade_2                                                   74                                             74
350847 350847 NH     school 3302640 141   Dover 330264000090 20430 Garrison School Public School Regular School No Elementary KG 04 2021   grade_2                                                   74                                             74
351612 351612 NH     school 3304590 335   Manchester 330459000250 21560 Highland-Goffes Falls School Public School Regular School No Elementary PK 05 2021   grade_2                                                   73                                             73
262780 262780 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   72.0                                             72
262872 262872 NH     school 3305580 427   Pembroke 330558000361 22615 Pembroke Hill School   Regular School No Elementary KG 04 2020   grade_2                                                   72.0                                             72
349096 349096 NH     school 3306180 486   Shaker Regional 330618000490 22135 Belmont Elementary School Public School Regular School No Elementary PK 04 2021   grade_2                                                   72                                             72
351340 351340 NH     school 3303480 223   Hampstead 330348000153 22755 Hampstead Central School Public School Regular School No Elementary PK 04 2021   grade_2                                                   72                                             72

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