enrollments

Data source: Big Local News · About: Big Local

16,847 rows where state = "NH"

✎ 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
260741 260741 NH     school 3304140 285   Laconia 330414000211 21275 Laconia Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
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
260747 260747 NH     school 3304230 295   Lebanon 330423000218 21360 Lebanon High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260748 260748 NH     school 3304230 295   Lebanon 330423000219 21370 Lebanon Middle School   Regular School No Middle 05 08 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
260752 260752 NH     school 3304260 305   Lincoln-Woodstock Cooperative 330426000532 23110 Lin-Wood Public School (High)   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260753 260753 NH     school 3304260 305   Lincoln-Woodstock Cooperative 330426000531 23105 Lin-Wood Public School (Middle)   Regular School No Middle 06 08 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
260755 260755 NH     school 3304290 306   Lisbon Regional 330429000227 23100 Lisbon Regional School (High)   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260756 260756 NH     school 3304290 306   Lisbon Regional 330429000534 23095 Lisbon Regional School (Middle)   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
260757 260757 NH     school 3304350 315   Litchfield 330435000674 27715 Campbell High School   Regular School No High 09 12 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
260759 260759 NH     school 3304350 315   Litchfield 330435000514 26640 Litchfield Middle School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
260760 260760 NH     school 3304380 317   Littleton 330438000231 21440 Daisy Bronson Junior High School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
260761 260761 NH     school 3304380 317   Littleton 330438000229 21445 Littleton High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
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
260763 260763 NH     school 3304410 319   Londonderry 330441000232 20480 Londonderry Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260764 260764 NH     school 3304410 319   Londonderry 330441000484 20490 Londonderry Senior High School   Regular School No High 09 12 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
260776 260776 NH     school 3304590 335   Manchester 330459000576 27595 Henry J. McLaughlin Jr. Middle School   Regular School No Middle 06 08 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
260779 260779 NH     school 3304590 335   Manchester 330459000251 21520 Hillside Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260780 260780 NH     school 3304590 335   Manchester 330459000252 21590 Jewett School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   104.0                                             104
260781 260781 NH     school 3304590 335   Manchester 330459000244 21510 Manchester Central High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260782 260782 NH     school 3304590 335   Manchester 330459000253 21505 Manchester Memorial High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260783 260783 NH     school 3304590 335   Manchester 330459000708 29085 Manchester School of Technology (High School)   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260784 260784 NH     school 3304590 335   Manchester 330459000261 21555 Manchester West High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260785 260785 NH     school 3304590 335   Manchester 330459000485 21565 McDonough School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260786 260786 NH     school 3304590 335   Manchester 330459000255 21525 Middle School At Parkside   Regular School No Middle 05 08 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
260790 260790 NH     school 3304590 335   Manchester 330459000258 21575 Southside Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
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
260795 260795 NH     school 3304670 342   Mascenic Regional 330467000515 26685 Boynton Middle School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
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
260797 260797 NH     school 3304670 342   Mascenic Regional 330467000270 23050 Mascenic Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
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
260800 260800 NH     school 3304680 343   Mascoma Valley Regional 330468000498 26405 Indian River School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
260801 260801 NH     school 3304680 343   Mascoma Valley Regional 330468000275 21305 Mascoma Valley Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
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
260804 260804 NH     school 3304740 351   Merrimack 330474000277 21025 James Mastricola Upper Elementary School   Regular School No Middle 05 06 2020   pre_kindergarten                                                   0.0                                             0
260805 260805 NH     school 3304740 351   Merrimack 330474000278 21040 Merrimack High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260806 260806 NH     school 3304740 351   Merrimack 330474000602 28375 Merrimack Middle School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
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
260811 260811 NH     school 3304760 352   Merrimack Valley 330476000284 22195 Merrimack Valley High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260812 260812 NH     school 3304760 352   Merrimack Valley 330476000506 26585 Merrimack Valley Middle School   Regular School No Middle 06 08 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
260820 260820 NH     school 3304830 357   Milford 330483000294 21765 Milford High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260821 260821 NH     school 3304830 357   Milford 330483000293 21760 Milford Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260822 260822 NH     school 3300616 359   Milton 330061600295 22075 Milton Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   17.0                                             17
260823 260823 NH     school 3300616 359   Milton 330061600544 22070 Nute High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260824 260824 NH     school 3300616 359   Milton 330061600296 26540 Nute Junior High School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
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
260828 260828 NH     school 3304890 363   Monadnock Regional 330489000301 21700 Monadnock Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260829 260829 NH     school 3304890 363   Monadnock Regional 330489000061 26980 Monadnock Regional Middle School   Regular School No Middle 07 08 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
260834 260834 NH     school 3304960 369   Moultonborough 330496000527 22120 Moultonborough Academy   Regular School No High 09 12 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
260836 260836 NH     school 3304960 369   Moultonborough 330496000092 26960 Moultonborough Middle Level   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
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

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