enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
262981 262981 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_2                                                   0.0                                             0
262982 262982 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_2                                                   0.0                                             0
353635 353635 NH     school   357   Milford     Milford Early Education Experiences             2021   grade_2                                                   0                                             0
355199 355199 NH     school   453   Raymond     Raymond School District Preschool Program             2021   grade_2                                                   0                                             0
355301 355301 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate School           2021   grade_2                                                   0                                             0
355318 355318 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate School           2021   grade_2                                                   0                                             0
262631 262631 NH     school 3302990 174   Fall Mountain Regional 330299000121 23010 Walpole Primary School   Regular School No Elementary PK 01 2020   grade_2                                                   0.0                                             0
262694 262694 NH     school 3303930 267   Hudson 330393000180 21045 Dr. H. O. Smith Elementary School   Regular School No Elementary PK 01 2020   grade_2                                                   0.0                                             0
262803 262803 NH     school 3304830 357   Milford 330483000507 26580 Jacques Memorial Elementary School   Regular School No Elementary PK 01 2020   grade_2                                                   0.0                                             0
350235 350235 NH     school 3303930 267   Hudson 330393000180 21045 Dr. H. O. Smith Elementary School Public School Regular School No Elementary KG 01 2021   grade_2                                                   0                                             0
352054 352054 NH     school 3304830 357   Milford 330483000507 26580 Jacques Memorial Elementary School Public School Regular School No Elementary KG 01 2021   grade_2                                                   0                                             0
356491 356491 NH     school 3302990 174   Fall Mountain Regional 330299000121 23010 Walpole Primary School Public School Regular School No Elementary PK 01 2021   grade_2                                                   0                                             0
262573 262573 NH     school 3302460 111   Concord 330246000056 20250 Mill Brook School   Regular School No Elementary PK 02 2020   grade_2                                                   109.0                                             109
262619 262619 NH     school 3302970 173   Exeter 330297000109 20575 Main Street School   Regular School No Elementary PK 02 2020   grade_2                                                   154.0                                             154
262666 262666 NH     school 3303510 225   Hampton 330351000469 20770 Hampton Centre School   Regular School No Elementary PK 02 2020   grade_2                                                   80.0                                             80
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
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
262927 262927 NH     school 3306240 491   Somersworth 330624000732 29202 Idlehurst Elementary School   Regular School No Elementary PK 02 2020   grade_2                                                   103.0                                             103
262975 262975 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_2                                                   65.0                                             65
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
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
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
352615 352615 NH     school 3304170 291   Landaff 330417000216 21410 Landaff Blue School Public School Regular School No Elementary KG 02 2021   grade_2                                                   5                                             5
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
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
353924 353924 NH     school 3304890 363   Monadnock Regional 330489000302 21695 Mt. Caesar Elementary School Public School Regular School No Elementary PK 02 2021   grade_2                                                   69                                             69
356372 356372 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School Public School Regular School No Elementary PK 02 2021   grade_2                                                   69                                             69
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
262634 262634 NH     school 3303000 175   Farmington 330300000597 27980 Valley View Community School   Regular School No Elementary PK 03 2020   grade_2                                                   57.0                                             57
262637 262637 NH     school 3303090 185   Franklin 330309000130 20650 Paul A. Smith School   Regular School No Elementary PK 03 2020   grade_2                                                   60.0                                             60
262652 262652 NH     school 3303330 208   Governor Wentworth Regional 330333000144 22430 Carpenter Elementary School   Regular School No Elementary KG 03 2020   grade_2                                                   59.0                                             59
262671 262671 NH     school 3303660 238   Haverhill Cooperative 330366000159 20905 Woodsville Elementary School   Regular School No Elementary PK 03 2020   grade_2                                                   48.0                                             48
262682 262682 NH     school 3303840 259   Hollis 330384000171 21815 Hollis Primary School   Regular School No Elementary PK 03 2020   grade_2                                                   83.0                                             83
262689 262689 NH     school 3303900 263   Hopkinton 330390000176 20975 Harold Martin School   Regular School No Elementary PK 03 2020   grade_2                                                   64.0                                             64
262729 262729 NH     school 3304170 291   Landaff 330417000216 21410 Landaff Blue School   Regular School No Elementary PK 03 2020   grade_2                                                   0.0                                             0
349555 349555 NH     school 3303330 208   Governor Wentworth Regional 330333000144 22430 Carpenter Elementary School Public School Regular School No Elementary KG 03 2021   grade_2                                                   61                                             61
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
351459 351459 NH     school 3303900 263   Hopkinton 330390000176 20975 Harold Martin School Public School Regular School No Elementary PK 03 2021   grade_2                                                   59                                             59
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
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
354655 354655 NH     school 3303090 185   Franklin 330309000130 20650 Paul A. Smith School Public School Regular School No Elementary PK 03 2021   grade_2                                                   68                                             68
355233 355233 NH     school 3302070 71   Brookline 330207000031 21800 Richard Maghakian Memorial School Public School Regular School No Elementary PK 03 2021   grade_2                                                   69                                             69
356406 356406 NH     school 3303000 175   Farmington 330300000597 27980 Valley View Community School Public School Regular School No Elementary PK 03 2021   grade_2                                                   53                                             53
357018 357018 NH     school 3303660 238   Haverhill Cooperative 330366000159 20905 Woodsville Elementary School Public School Regular School No Elementary PK 03 2021   grade_2                                                   29                                             29
262525 262525 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   33.0                                             33
262529 262529 NH     school 3301470 17   Amherst 330147000006 21750 Clark-Wilkins School   Regular School No Elementary PK 04 2020   grade_2                                                   128.0                                             128
262534 262534 NH     school 3301650 33   Barrington 330165000013 22045 Barrington Elementary School   Regular School No Elementary 01 04 2020   grade_2                                                   95.0                                             95
262541 262541 NH     school 3301740 41   Bedford 330174000018 20990 Memorial School   Regular School No Elementary PK 04 2020   grade_2                                                   75.0                                             75
262542 262542 NH     school 3301740 41   Bedford 330174000019 21000 Peter Woodbury School   Regular School No Elementary KG 04 2020   grade_2                                                   100.0                                             100
262543 262543 NH     school 3301740 41   Bedford 330174000580 27680 Riddle Brook School   Regular School No Elementary KG 04 2020   grade_2                                                   117.0                                             117
262549 262549 NH     school 3301950 57   Bow 330195000480 20680 Bow Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   96.0                                             96
262575 262575 NH     school 3302480 112   Contoocook Valley 330248000065 22215 Antrim Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   28.0                                             28
262577 262577 NH     school 3302480 112   Contoocook Valley 330248000068 22230 Dublin Consolidated School   Regular School No Elementary KG 04 2020   grade_2                                                   6.0                                             6
262578 262578 NH     school 3302480 112   Contoocook Valley 330248000069 22245 Francestown Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   10.0                                             10
262580 262580 NH     school 3302480 112   Contoocook Valley 330248000070 22250 Greenfield Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   18.0                                             18
262581 262581 NH     school 3302480 112   Contoocook Valley 330248000071 22260 Hancock Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   12.0                                             12
262582 262582 NH     school 3302480 112   Contoocook Valley 330248000072 22310 Peterborough Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   64.0                                             64
262583 262583 NH     school 3302480 112   Contoocook Valley 330248000074 22225 Pierce Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   17.0                                             17
262585 262585 NH     school 3302480 112   Contoocook Valley 330248000075 22330 Temple Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   14.0                                             14
262592 262592 NH     school 3302550 117   Croydon 330255000081 21960 Croydon Village School   Regular School No Elementary KG 04 2020   grade_2                                                   6.0                                             6
262604 262604 NH     school 3302640 141   Dover 330264000090 20430 Garrison School   Regular School No Elementary KG 04 2020   grade_2                                                   95.0                                             95
262605 262605 NH     school 3302640 141   Dover 330264000091 20445 Horne Street School   Regular School No Elementary KG 04 2020   grade_2                                                   76.0                                             76
262606 262606 NH     school 3302640 141   Dover 330264000094 20460 Woodman Park School   Regular School No Elementary PK 04 2020   grade_2                                                   90.0                                             90
262620 262620 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_2                                                   8.0                                             8
262621 262621 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School   Regular School No Elementary PK 04 2020   grade_2                                                   20.0                                             20
262627 262627 NH     school 3302990 174   Fall Mountain Regional 330299000118 23005 North Walpole School   Regular School No Elementary 02 04 2020   grade_2                                                   32.0                                             32
262628 262628 NH     school 3302990 174   Fall Mountain Regional 330299000119 22995 Sarah Porter School   Regular School No Elementary 01 04 2020   grade_2                                                   3.0                                             3
262640 262640 NH     school 3303180 191   Gilford 330318000133 21245 Gilford Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   68.0                                             68
262644 262644 NH     school 3303240 199   Goffstown 330324000138 20695 Bartlett Elementary School   Regular School No Elementary 01 04 2020   grade_2                                                   52.0                                             52
262647 262647 NH     school 3303240 199   Goffstown 330324000139 20690 Maple Avenue School   Regular School No Elementary 01 04 2020   grade_2                                                   116.0                                             116
262662 262662 NH     school 3303480 223   Hampstead 330348000153 22755 Hampstead Central School   Regular School No Elementary PK 04 2020   grade_2                                                   100.0                                             100
262730 262730 NH     school 3304230 295   Lebanon 330423000217 21335 Hanover Street School   Regular School No Elementary KG 04 2020   grade_2                                                   63.0                                             63
262733 262733 NH     school 3304230 295   Lebanon 330423000220 21355 Mt. Lebanon School   Regular School No Elementary PK 04 2020   grade_2                                                   47.0                                             47
262742 262742 NH     school 3304350 315   Litchfield 330435000228 21095 Griffin Memorial School   Regular School No Elementary PK 04 2020   grade_2                                                   98.0                                             98
262757 262757 NH     school 3304590 335   Manchester 330459000246 21530 Gossler Park School   Regular School No Elementary KG 04 2020   grade_2                                                   61.0                                             61
262771 262771 NH     school 3304590 335   Manchester 330459000505 26435 Northwest Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   127.0                                             127
262772 262772 NH     school 3304590 335   Manchester 330459000254 21540 Parker-Varney School   Regular School No Elementary PK 04 2020   grade_2                                                   68.0                                             68
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
262782 262782 NH     school 3304680 343   Mascoma Valley Regional 330468000273 21315 Canaan Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   31.0                                             31
262783 262783 NH     school 3304680 343   Mascoma Valley Regional 330468000274 21325 Enfield Village School   Regular School No Elementary PK 04 2020   grade_2                                                   37.0                                             37
262787 262787 NH     school 3304740 351   Merrimack 330474000276 21020 James Mastricola Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   68.0                                             68
262791 262791 NH     school 3304740 351   Merrimack 330474000279 21015 Reeds Ferry School   Regular School No Elementary PK 04 2020   grade_2                                                   82.0                                             82
262792 262792 NH     school 3304740 351   Merrimack 330474000280 21035 Thorntons Ferry School   Regular School No Elementary PK 04 2020   grade_2                                                   100.0                                             100
262819 262819 NH     school 3304960 369   Moultonborough 330496000147 22115 Moultonborough Central School   Regular School No Elementary PK 04 2020   grade_2                                                   24.0                                             24
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
262864 262864 NH     school 3305520 423   Oyster River Coop 330552000520 26660 Moharimet School   Regular School No Elementary KG 04 2020   grade_2                                                   63.0                                             63
262872 262872 NH     school 3305580 427   Pembroke 330558000361 22615 Pembroke Hill School   Regular School No Elementary KG 04 2020   grade_2                                                   72.0                                             72
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
262900 262900 NH     school 3305940 461   Rochester 330594000522 22660 Nancy Loud School   Regular School No Elementary KG 04 2020   grade_2                                                   14.0                                             14
262902 262902 NH     school 3305940 461   Rochester 330594000393 22720 School Street School   Regular School No Elementary KG 04 2020   grade_2                                                   15.0                                             15
262907 262907 NH     school 3306030 471   Rye 330603000398 22475 Rye Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   51.0                                             51
262921 262921 NH     school 3306150 485   Seabrook 330615000410 20810 Seabrook Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   70.0                                             70
262923 262923 NH     school 3306180 486   Shaker Regional 330618000490 22135 Belmont Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   61.0                                             61
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
263020 263020 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Public Charter Schools Regular School Yes Elementary KG 04 2020   grade_2                                                   21.0                                             21
348705 348705 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_2                                                   6                                             6
348739 348739 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_2                                                   33                                             33
348756 348756 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_2                                                   11                                             11
348858 348858 NH     school 3302480 112   Contoocook Valley 330248000065 22215 Antrim Elementary School Public School Regular School No Elementary PK 04 2021   grade_2                                                   18                                             18
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

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