enrollments

Data source: Big Local News · About: Big Local

16,847 rows where state = "NH" sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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
260698 260698 NH     school 3303840 259   Hollis 330384000171 21815 Hollis Primary School   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   18.0                                             18
260703 260703 NH     school 3303870 261   Hooksett 330387000173 20550 Fred C. Underhill School   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   27.0                                             27
260704 260704 NH     school 3303870 261   Hooksett 330387000175 20540 Hooksett Memorial School   Regular School No Elementary 03 05 2020   pre_kindergarten                                                   0.0                                             0
260705 260705 NH     school 3303900 263   Hopkinton 330390000176 20975 Harold Martin School   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   34.0                                             34
260710 260710 NH     school 3303930 267   Hudson 330393000180 21045 Dr. H. O. Smith Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten                                                   103.0                                             103
260711 260711 NH     school 3303930 267   Hudson 330393000593 27900 Hills Garrison Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten                                                   0.0                                             0
260713 260713 NH     school 3303930 267   Hudson 330393000513 26765 Nottingham West Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten                                                   0.0                                             0
260714 260714 NH     school 3303960 269   Inter-Lakes Cooperative 330396000734 29200 Inter-Lakes Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   16.0                                             16
260717 260717 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260718 260718 NH     school 3303990 271   Jackson 330399000187 20355 Jackson Grammar School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260720 260720 NH     school 3304030 274   Jaffrey-Rindge Cooperative 330403000189 22275 Jaffrey Grade School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   37.0                                             37
260722 260722 NH     school 3304030 274   Jaffrey-Rindge Cooperative 330403000191 22320 Rindge Memorial School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   29.0                                             29
260725 260725 NH     school 3304040 276   Kearsarge Regional 330404000195 21980 Kearsarge Reg. Elem. School at New London   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260726 260726 NH     school 3304040 276   Kearsarge Regional 330404000192 26530 Kearsarge Reg. Elementary School - Bradford   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260729 260729 NH     school 3304040 276   Kearsarge Regional 330404000197 22020 Simonds Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260730 260730 NH     school 3304040 276   Kearsarge Regional 330404000198 22010 Sutton Central Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260731 260731 NH     school 3304050 279   Keene 330405000200 21190 Franklin Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260732 260732 NH     school 3304050 279   Keene 330405000201 21165 Fuller Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260736 260736 NH     school 3304050 279   Keene 330405000206 21170 Symonds Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260737 260737 NH     school 3304050 279   Keene 330405000207 21200 Wheelock Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260738 260738 NH     school 3304080 281   Kensington 330408000208 20605 Kensington Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260739 260739 NH     school 3304140 285   Laconia 330414000209 21290 Elm Street School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   28.0                                             28
260742 260742 NH     school 3304140 285   Laconia 330414000212 21260 Pleasant Street School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   24.0                                             24
260743 260743 NH     school 3304140 285   Laconia 330414000213 21285 Woodland Heights Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   44.0                                             44
260744 260744 NH     school 3304150 288   Lafayette Regional 330415000215 21405 Lafayette Regional School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260745 260745 NH     school 3304170 291   Landaff 330417000216 21410 Landaff Blue School   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   15.0                                             15
260746 260746 NH     school 3304230 295   Lebanon 330423000217 21335 Hanover Street School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260749 260749 NH     school 3304230 295   Lebanon 330423000220 21355 Mt. Lebanon School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   40.0                                             40
260750 260750 NH     school 3303303 299   Lempster 330330300719 29169 Lempster Community School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260751 260751 NH     school 3304260 305   Lincoln-Woodstock Cooperative 330426000493 20880 Lin-Wood Public School (Elem)   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260754 260754 NH     school 3304290 306   Lisbon Regional 330429000533 21420 Lisbon Regional School (Elem)   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260758 260758 NH     school 3304350 315   Litchfield 330435000228 21095 Griffin Memorial School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   41.0                                             41
260762 260762 NH     school 3304380 317   Littleton 330438000230 21450 Mildred C. Lakeway School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260765 260765 NH     school 3304410 319   Londonderry 330441000233 20485 Matthew Thornton Elementary School   Regular School No Elementary 01 05 2020   pre_kindergarten                                                   0.0                                             0
260766 260766 NH     school 3304410 319   Londonderry 330441000594 27905 Moose Hill School   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   124.0                                             124
260767 260767 NH     school 3304410 319   Londonderry 330441000234 20470 North Londonderry Elementary School   Regular School No Elementary 01 05 2020   pre_kindergarten                                                   0.0                                             0
260768 260768 NH     school 3304410 319   Londonderry 330441000473 20475 South Londonderry Elementary School   Regular School No Elementary 01 05 2020   pre_kindergarten                                                   0.0                                             0
260769 260769 NH     school 3304500 327   Lyme 330450000236 20835 Lyme Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260770 260770 NH     school 3304560 333   Madison 330456000238 20360 Madison Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260771 260771 NH     school 3304590 335   Manchester 330459000240 21545 Bakersville School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   72.0                                             72
260772 260772 NH     school 3304590 335   Manchester 330459000241 21600 Beech Street School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260773 260773 NH     school 3304590 335   Manchester 330459000246 21530 Gossler Park School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260774 260774 NH     school 3304590 335   Manchester 330459000248 21610 Green Acres School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   5.0                                             5
260775 260775 NH     school 3304590 335   Manchester 330459000249 21625 Hallsville School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260777 260777 NH     school 3304590 335   Manchester 330459000263 21640 Henry Wilson Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260778 260778 NH     school 3304590 335   Manchester 330459000250 21560 Highland-Goffes Falls School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   14.0                                             14
260780 260780 NH     school 3304590 335   Manchester 330459000252 21590 Jewett School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   104.0                                             104
260785 260785 NH     school 3304590 335   Manchester 330459000485 21565 McDonough School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260787 260787 NH     school 3304590 335   Manchester 330459000505 26435 Northwest Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260788 260788 NH     school 3304590 335   Manchester 330459000254 21540 Parker-Varney School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   94.0                                             94
260789 260789 NH     school 3304590 335   Manchester 330459000257 21605 Smyth Road School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   9.0                                             9
260791 260791 NH     school 3304590 335   Manchester 330459000260 21635 Webster School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260792 260792 NH     school 3304590 335   Manchester 330459000262 21515 Weston Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   90.0                                             90
260793 260793 NH     school 3304620 339   Marlborough 330462000264 21210 Marlborough Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   11.0                                             11
260794 260794 NH     school 3304650 341   Marlow 330465000266 23000 John D. Perkins Academy   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   4.0                                             4
260796 260796 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   19.0                                             19
260798 260798 NH     school 3304680 343   Mascoma Valley Regional 330468000273 21315 Canaan Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   41.0                                             41
260799 260799 NH     school 3304680 343   Mascoma Valley Regional 330468000274 21325 Enfield Village School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   22.0                                             22
260802 260802 NH     school 3303276 345   Mason 330327610027 23040 Mason Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   12.0                                             12
260803 260803 NH     school 3304740 351   Merrimack 330474000276 21020 James Mastricola Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   56.0                                             56
260807 260807 NH     school 3304740 351   Merrimack 330474000279 21015 Reeds Ferry School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   36.0                                             36
260808 260808 NH     school 3304740 351   Merrimack 330474000280 21035 Thorntons Ferry School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   58.0                                             58
260809 260809 NH     school 3304760 352   Merrimack Valley 330476000281 22155 Boscawen Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   20.0                                             20
260810 260810 NH     school 3304760 352   Merrimack Valley 330476000282 22180 Loudon Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260813 260813 NH     school 3304760 352   Merrimack Valley 330476000283 22185 Penacook Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   24.0                                             24
260814 260814 NH     school 3304760 352   Merrimack Valley 330476000285 22200 Salisbury Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260815 260815 NH     school 3304760 352   Merrimack Valley 330476000287 22205 Webster Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260816 260816 NH     school 3304770 353   Middleton 330477000725 29178 Middleton Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   14.0                                             14
260817 260817 NH     school 3304800 355   Milan 330480000289 20760 Milan Village Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   24.0                                             24
260818 260818 NH     school 3304830 357   Milford 330483000595 27895 Heron Pond Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten                                                   0.0                                             0
260819 260819 NH     school 3304830 357   Milford 330483000507 26580 Jacques Memorial Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten                                                   61.0                                             61
260822 260822 NH     school 3300616 359   Milton 330061600295 22075 Milton Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   17.0                                             17
260825 260825 NH     school 3304890 363   Monadnock Regional 330489000298 21715 Cutler Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten                                                   0.0                                             0
260826 260826 NH     school 3304890 363   Monadnock Regional 330489000299 21665 Dr. George S. Emerson Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   23.0                                             23
260827 260827 NH     school 3304890 363   Monadnock Regional 330489000300 21670 Gilsum STEAM Academy   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260830 260830 NH     school 3304890 363   Monadnock Regional 330489000302 21695 Mt. Caesar Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   46.0                                             46
260831 260831 NH     school 3304890 363   Monadnock Regional 330489000305 21725 Troy Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   14.0                                             14
260832 260832 NH     school 3304920 365   Monroe 330492000307 20885 Monroe Consolidated School   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   14.0                                             14
260833 260833 NH     school 3304950 367   Mont Vernon 330495000309 21790 Mont Vernon Village School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260835 260835 NH     school 3304960 369   Moultonborough 330496000147 22115 Moultonborough Central School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   37.0                                             37
260837 260837 NH     school 3304980 371   Nashua 330498000310 21940 Amherst Street School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260838 260838 NH     school 3304980 371   Nashua 330498000312 21865 Bicentennial Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   46.0                                             46
260839 260839 NH     school 3304980 371   Nashua 330498000313 21895 Birch Hill Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   16.0                                             16
260840 260840 NH     school 3304980 371   Nashua 330498000314 21925 Broad Street Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   106.0                                             106
260841 260841 NH     school 3304980 371   Nashua 330498000315 21930 Charlotte Ave Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260842 260842 NH     school 3304980 371   Nashua 330498000486 21835 Dr. Norman W. Crisp School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260844 260844 NH     school 3304980 371   Nashua 330498000508 21840 Fairgrounds Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260846 260846 NH     school 3304980 371   Nashua 330498000320 21915 Ledge Street School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260847 260847 NH     school 3304980 371   Nashua 330498000321 21935 Main Dunstable School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260848 260848 NH     school 3304980 371   Nashua 330498000322 21885 Mt. Pleasant School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   27.0                                             27
260852 260852 NH     school 3304980 371   Nashua 330498000324 21845 New Searles School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   80.0                                             80
260855 260855 NH     school 3304980 371   Nashua 330498000326 21850 Sunset Heights School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260856 260856 NH     school 3305010 375   Nelson 330501000328 21215 Nelson Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260857 260857 NH     school 3305040 377   New Boston 330504000329 20715 New Boston Central School   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   17.0                                             17
260858 260858 NH     school 3305070 381   New Castle 330507000330 22455 Maude H. Trefethen School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260859 260859 NH     school 3305190 387   Newfields 330519000331 20610 Newfields Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260860 260860 NH     school 3305220 388   Newfound Area 330522000590 27685 Bridgewater-Hebron Village School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   23.0                                             23
260861 260861 NH     school 3305220 388   Newfound Area 330522000332 20090 Bristol Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260862 260862 NH     school 3305220 388   Newfound Area 330522000334 20095 Danbury Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260863 260863 NH     school 3305220 388   Newfound Area 330522000337 20105 New Hampton Community School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.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]);