enrollments

Data source: Big Local News · About: Big Local

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

✎ 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 ▼
260680 260680 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   pre_kindergarten                                                   0.0                                             0
260681 260681 NH     school 3303510 225   Hampton 330351000471 20790 Hampton Academy   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260683 260683 NH     school 3303540 227   Hampton Falls 330354000154 20800 Lincoln Akerman School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260684 260684 NH     school 3303600 233   Hanover 330360000155 20830 Bernice A. Ray School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260685 260685 NH     school 3303630 235   Harrisville 330363000156 21155 Wells Memorial School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260686 260686 NH     school 3303660 238   Haverhill Cooperative 330366000020 26875 Haverhill Cooperative Middle School   Regular School No Middle 04 08 2020   pre_kindergarten                                                   0.0                                             0
260688 260688 NH     school 3303660 238   Haverhill Cooperative 330366000160 20910 Woodsville High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260690 260690 NH     school 3303720 247   Hill 330372000164 20670 Jennie D. Blake School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260692 260692 NH     school 3303750 251   Hillsboro-Deering Cooperative 330375000166 20950 Hillsboro-Deering High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260693 260693 NH     school 3303750 251   Hillsboro-Deering Cooperative 330375000481 20960 Hillsboro-Deering Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260695 260695 NH     school 3303780 255   Hinsdale 330378000168 21675 Hinsdale High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260696 260696 NH     school 3303780 255   Hinsdale 330378000048 26985 Hinsdale Middle High School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260697 260697 NH     school 3303810 257   Holderness 330381000169 22345 Holderness Central School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260699 260699 NH     school 3303840 259   Hollis 330384000566 27530 Hollis Upper Elementary School   Regular School No Middle 04 06 2020   pre_kindergarten                                                   0.0                                             0
260700 260700 NH     school 3303850 260   Hollis-Brookline Cooperative 330385000170 21810 Hollis-Brookline High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260701 260701 NH     school 3303850 260   Hollis-Brookline Cooperative 330385000172 21805 Hollis-Brookline Middle School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
260702 260702 NH     school 3303870 261   Hooksett 330387000618 28050 David R. Cawley Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260704 260704 NH     school 3303870 261   Hooksett 330387000175 20540 Hooksett Memorial School   Regular School No Elementary 03 05 2020   pre_kindergarten                                                   0.0                                             0
260706 260706 NH     school 3303900 263   Hopkinton 330390000177 20970 Hopkinton High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260707 260707 NH     school 3303900 263   Hopkinton 330390000052 27000 Hopkinton Middle School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
260708 260708 NH     school 3303900 263   Hopkinton 330390000178 20965 Maple Street Elementary School   Regular School No Middle 04 06 2020   pre_kindergarten                                                   0.0                                             0
260709 260709 NH     school 3303930 267   Hudson 330393000179 21050 Alvirne High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
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
260712 260712 NH     school 3303930 267   Hudson 330393000181 21060 Hudson Memorial School   Regular School No Middle 06 08 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
260715 260715 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260716 260716 NH     school 3303960 269   Inter-Lakes Cooperative 330396000731 29201 Inter-Lakes Middle School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
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
260719 260719 NH     school 3304030 274   Jaffrey-Rindge Cooperative 330403000188 22265 Conant High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260721 260721 NH     school 3304030 274   Jaffrey-Rindge Cooperative 330403000190 22280 Jaffrey-Rindge Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260723 260723 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
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
260727 260727 NH     school 3304040 276   Kearsarge Regional 330404000193 22015 Kearsarge Regional High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260728 260728 NH     school 3304040 276   Kearsarge Regional 330404000503 26535 Kearsarge Regional Middle School   Regular School No Middle 06 08 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
260734 260734 NH     school 3304050 279   Keene 330405000202 21195 Keene High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260735 260735 NH     school 3304050 279   Keene 330405000203 21185 Keene Middle School   Regular School No Middle 06 08 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
260740 260740 NH     school 3304140 285   Laconia 330414000210 21255 Laconia High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260741 260741 NH     school 3304140 285   Laconia 330414000211 21275 Laconia Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
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
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
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
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
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
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
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
260779 260779 NH     school 3304590 335   Manchester 330459000251 21520 Hillside Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
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
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
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
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
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
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
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
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
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
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

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