enrollments

Data source: Big Local News · About: Big Local

991 rows where grade = "grade_1" and state = "NH"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 791 ✖
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
262229 262229 NH     school 3304140 285   Laconia 330414000211 21275 Laconia Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262230 262230 NH     school 3304140 285   Laconia 330414000212 21260 Pleasant Street School   Regular School No Elementary PK 05 2020   grade_1                                                   52.0                                             52
262231 262231 NH     school 3304140 285   Laconia 330414000213 21285 Woodland Heights Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   53.0                                             53
262232 262232 NH     school 3304150 288   Lafayette Regional 330415000215 21405 Lafayette Regional School   Regular School No Elementary KG 06 2020   grade_1                                                   9.0                                             9
262233 262233 NH     school 3304170 291   Landaff 330417000216 21410 Landaff Blue School   Regular School No Elementary PK 03 2020   grade_1                                                   4.0                                             4
262234 262234 NH     school 3304230 295   Lebanon 330423000217 21335 Hanover Street School   Regular School No Elementary KG 04 2020   grade_1                                                   58.0                                             58
262235 262235 NH     school 3304230 295   Lebanon 330423000218 21360 Lebanon High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262236 262236 NH     school 3304230 295   Lebanon 330423000219 21370 Lebanon Middle School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
262237 262237 NH     school 3304230 295   Lebanon 330423000220 21355 Mt. Lebanon School   Regular School No Elementary PK 04 2020   grade_1                                                   31.0                                             31
262238 262238 NH     school 3303303 299   Lempster 330330300719 29169 Lempster Community School   Regular School No Elementary KG 08 2020   grade_1                                                   12.0                                             12
262239 262239 NH     school 3304260 305   Lincoln-Woodstock Cooperative 330426000493 20880 Lin-Wood Public School (Elem)   Regular School No Elementary KG 05 2020   grade_1                                                   19.0                                             19
262240 262240 NH     school 3304260 305   Lincoln-Woodstock Cooperative 330426000532 23110 Lin-Wood Public School (High)   Regular School No High 09 13 2020   grade_1                                                   0.0                                             0
262241 262241 NH     school 3304260 305   Lincoln-Woodstock Cooperative 330426000531 23105 Lin-Wood Public School (Middle)   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262242 262242 NH     school 3304290 306   Lisbon Regional 330429000533 21420 Lisbon Regional School (Elem)   Regular School No Elementary KG 06 2020   grade_1                                                   30.0                                             30
262243 262243 NH     school 3304290 306   Lisbon Regional 330429000227 23100 Lisbon Regional School (High)   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262244 262244 NH     school 3304290 306   Lisbon Regional 330429000534 23095 Lisbon Regional School (Middle)   Regular School No Middle 07 08 2020   grade_1                                                   0.0                                             0
262245 262245 NH     school 3304350 315   Litchfield 330435000674 27715 Campbell High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262246 262246 NH     school 3304350 315   Litchfield 330435000228 21095 Griffin Memorial School   Regular School No Elementary PK 04 2020   grade_1                                                   90.0                                             90
262247 262247 NH     school 3304350 315   Litchfield 330435000514 26640 Litchfield Middle School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
262248 262248 NH     school 3304380 317   Littleton 330438000231 21440 Daisy Bronson Junior High School   Regular School No Middle 07 08 2020   grade_1                                                   0.0                                             0
262249 262249 NH     school 3304380 317   Littleton 330438000229 21445 Littleton High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262250 262250 NH     school 3304380 317   Littleton 330438000230 21450 Mildred C. Lakeway School   Regular School No Elementary KG 06 2020   grade_1                                                   47.0                                             47
262251 262251 NH     school 3304410 319   Londonderry 330441000232 20480 Londonderry Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262252 262252 NH     school 3304410 319   Londonderry 330441000484 20490 Londonderry Senior High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262253 262253 NH     school 3304410 319   Londonderry 330441000233 20485 Matthew Thornton Elementary School   Regular School No Elementary 01 05 2020   grade_1                                                   81.0                                             81
262254 262254 NH     school 3304410 319   Londonderry 330441000594 27905 Moose Hill School   Regular School No Elementary PK KG 2020   grade_1                                                   0.0                                             0
262255 262255 NH     school 3304410 319   Londonderry 330441000234 20470 North Londonderry Elementary School   Regular School No Elementary 01 05 2020   grade_1                                                   95.0                                             95
262256 262256 NH     school 3304410 319   Londonderry 330441000473 20475 South Londonderry Elementary School   Regular School No Elementary 01 05 2020   grade_1                                                   83.0                                             83
262257 262257 NH     school 3304500 327   Lyme 330450000236 20835 Lyme Elementary School   Regular School No Elementary KG 08 2020   grade_1                                                   17.0                                             17
262258 262258 NH     school 3304560 333   Madison 330456000238 20360 Madison Elementary School   Regular School No Elementary KG 06 2020   grade_1                                                   21.0                                             21
262259 262259 NH     school 3304590 335   Manchester 330459000240 21545 Bakersville School   Regular School No Elementary PK 05 2020   grade_1                                                   53.0                                             53
262260 262260 NH     school 3304590 335   Manchester 330459000241 21600 Beech Street School   Regular School No Elementary KG 05 2020   grade_1                                                   88.0                                             88
262261 262261 NH     school 3304590 335   Manchester 330459000246 21530 Gossler Park School   Regular School No Elementary KG 04 2020   grade_1                                                   62.0                                             62
262262 262262 NH     school 3304590 335   Manchester 330459000248 21610 Green Acres School   Regular School No Elementary PK 05 2020   grade_1                                                   67.0                                             67
262263 262263 NH     school 3304590 335   Manchester 330459000249 21625 Hallsville School   Regular School No Elementary KG 05 2020   grade_1                                                   45.0                                             45
262264 262264 NH     school 3304590 335   Manchester 330459000576 27595 Henry J. McLaughlin Jr. Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262265 262265 NH     school 3304590 335   Manchester 330459000263 21640 Henry Wilson Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   72.0                                             72
262266 262266 NH     school 3304590 335   Manchester 330459000250 21560 Highland-Goffes Falls School   Regular School No Elementary PK 05 2020   grade_1                                                   79.0                                             79
262267 262267 NH     school 3304590 335   Manchester 330459000251 21520 Hillside Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262268 262268 NH     school 3304590 335   Manchester 330459000252 21590 Jewett School   Regular School No Elementary PK 05 2020   grade_1                                                   45.0                                             45
262269 262269 NH     school 3304590 335   Manchester 330459000244 21510 Manchester Central High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262270 262270 NH     school 3304590 335   Manchester 330459000253 21505 Manchester Memorial High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262271 262271 NH     school 3304590 335   Manchester 330459000708 29085 Manchester School of Technology (High School)   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262272 262272 NH     school 3304590 335   Manchester 330459000261 21555 Manchester West High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262273 262273 NH     school 3304590 335   Manchester 330459000485 21565 McDonough School   Regular School No Elementary KG 05 2020   grade_1                                                   84.0                                             84
262274 262274 NH     school 3304590 335   Manchester 330459000255 21525 Middle School At Parkside   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
262275 262275 NH     school 3304590 335   Manchester 330459000505 26435 Northwest Elementary School   Regular School No Elementary KG 04 2020   grade_1                                                   105.0                                             105
262276 262276 NH     school 3304590 335   Manchester 330459000254 21540 Parker-Varney School   Regular School No Elementary PK 04 2020   grade_1                                                   83.0                                             83
262277 262277 NH     school 3304590 335   Manchester 330459000257 21605 Smyth Road School   Regular School No Elementary PK 05 2020   grade_1                                                   71.0                                             71
262278 262278 NH     school 3304590 335   Manchester 330459000258 21575 Southside Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262279 262279 NH     school 3304590 335   Manchester 330459000260 21635 Webster School   Regular School No Elementary KG 05 2020   grade_1                                                   94.0                                             94
262280 262280 NH     school 3304590 335   Manchester 330459000262 21515 Weston Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   80.0                                             80
262281 262281 NH     school 3304620 339   Marlborough 330462000264 21210 Marlborough Elementary School   Regular School No Elementary PK 08 2020   grade_1                                                   20.0                                             20
262282 262282 NH     school 3304650 341   Marlow 330465000266 23000 John D. Perkins Academy   Regular School No Elementary PK 06 2020   grade_1                                                   8.0                                             8
262283 262283 NH     school 3304670 342   Mascenic Regional 330467000515 26685 Boynton Middle School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
262284 262284 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_1                                                   88.0                                             88
262285 262285 NH     school 3304670 342   Mascenic Regional 330467000270 23050 Mascenic Regional High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262286 262286 NH     school 3304680 343   Mascoma Valley Regional 330468000273 21315 Canaan Elementary School   Regular School No Elementary PK 04 2020   grade_1                                                   32.0                                             32
262287 262287 NH     school 3304680 343   Mascoma Valley Regional 330468000274 21325 Enfield Village School   Regular School No Elementary PK 04 2020   grade_1                                                   34.0                                             34
262288 262288 NH     school 3304680 343   Mascoma Valley Regional 330468000498 26405 Indian River School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
262289 262289 NH     school 3304680 343   Mascoma Valley Regional 330468000275 21305 Mascoma Valley Regional High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262290 262290 NH     school 3303276 345   Mason 330327610027 23040 Mason Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   11.0                                             11
262291 262291 NH     school 3304740 351   Merrimack 330474000276 21020 James Mastricola Elementary School   Regular School No Elementary PK 04 2020   grade_1                                                   74.0                                             74
262292 262292 NH     school 3304740 351   Merrimack 330474000277 21025 James Mastricola Upper Elementary School   Regular School No Middle 05 06 2020   grade_1                                                   0.0                                             0
262293 262293 NH     school 3304740 351   Merrimack 330474000278 21040 Merrimack High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262294 262294 NH     school 3304740 351   Merrimack 330474000602 28375 Merrimack Middle School   Regular School No Middle 07 08 2020   grade_1                                                   0.0                                             0
262295 262295 NH     school 3304740 351   Merrimack 330474000279 21015 Reeds Ferry School   Regular School No Elementary PK 04 2020   grade_1                                                   94.0                                             94
262296 262296 NH     school 3304740 351   Merrimack 330474000280 21035 Thorntons Ferry School   Regular School No Elementary PK 04 2020   grade_1                                                   106.0                                             106
262297 262297 NH     school 3304760 352   Merrimack Valley 330476000281 22155 Boscawen Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   28.0                                             28
262298 262298 NH     school 3304760 352   Merrimack Valley 330476000282 22180 Loudon Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   51.0                                             51
262299 262299 NH     school 3304760 352   Merrimack Valley 330476000284 22195 Merrimack Valley High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262300 262300 NH     school 3304760 352   Merrimack Valley 330476000506 26585 Merrimack Valley Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262301 262301 NH     school 3304760 352   Merrimack Valley 330476000283 22185 Penacook Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   56.0                                             56
262302 262302 NH     school 3304760 352   Merrimack Valley 330476000285 22200 Salisbury Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   9.0                                             9
262303 262303 NH     school 3304760 352   Merrimack Valley 330476000287 22205 Webster Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   12.0                                             12
262304 262304 NH     school 3304770 353   Middleton 330477000725 29178 Middleton Elementary School   Regular School No Elementary PK 06 2020   grade_1                                                   15.0                                             15
262305 262305 NH     school 3304800 355   Milan 330480000289 20760 Milan Village Elementary School   Regular School No Elementary PK 06 2020   grade_1                                                   17.0                                             17
262306 262306 NH     school 3304830 357   Milford 330483000595 27895 Heron Pond Elementary School   Regular School No Elementary 02 05 2020   grade_1                                                   0.0                                             0
262307 262307 NH     school 3304830 357   Milford 330483000507 26580 Jacques Memorial Elementary School   Regular School No Elementary PK 01 2020   grade_1                                                   155.0                                             155
262308 262308 NH     school 3304830 357   Milford 330483000294 21765 Milford High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262309 262309 NH     school 3304830 357   Milford 330483000293 21760 Milford Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262310 262310 NH     school 3300616 359   Milton 330061600295 22075 Milton Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   42.0                                             42
262311 262311 NH     school 3300616 359   Milton 330061600544 22070 Nute High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262312 262312 NH     school 3300616 359   Milton 330061600296 26540 Nute Junior High School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262313 262313 NH     school 3304890 363   Monadnock Regional 330489000298 21715 Cutler Elementary School   Regular School No Elementary 03 06 2020   grade_1                                                   0.0                                             0
262314 262314 NH     school 3304890 363   Monadnock Regional 330489000299 21665 Dr. George S. Emerson Elementary School   Regular School No Elementary PK 06 2020   grade_1                                                   27.0                                             27
262315 262315 NH     school 3304890 363   Monadnock Regional 330489000300 21670 Gilsum STEAM Academy   Regular School No Elementary KG 06 2020   grade_1                                                   9.0                                             9
262316 262316 NH     school 3304890 363   Monadnock Regional 330489000301 21700 Monadnock Regional High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262317 262317 NH     school 3304890 363   Monadnock Regional 330489000061 26980 Monadnock Regional Middle School   Regular School No Middle 07 08 2020   grade_1                                                   0.0                                             0
262318 262318 NH     school 3304890 363   Monadnock Regional 330489000302 21695 Mt. Caesar Elementary School   Regular School No Elementary PK 02 2020   grade_1                                                   75.0                                             75
262319 262319 NH     school 3304890 363   Monadnock Regional 330489000305 21725 Troy Elementary School   Regular School No Elementary PK 06 2020   grade_1                                                   22.0                                             22
262320 262320 NH     school 3304920 365   Monroe 330492000307 20885 Monroe Consolidated School   Regular School No Elementary PK 08 2020   grade_1                                                   9.0                                             9
262321 262321 NH     school 3304950 367   Mont Vernon 330495000309 21790 Mont Vernon Village School   Regular School No Elementary KG 06 2020   grade_1                                                   28.0                                             28
262322 262322 NH     school 3304960 369   Moultonborough 330496000527 22120 Moultonborough Academy   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262323 262323 NH     school 3304960 369   Moultonborough 330496000147 22115 Moultonborough Central School   Regular School No Elementary PK 04 2020   grade_1                                                   29.0                                             29
262324 262324 NH     school 3304960 369   Moultonborough 330496000092 26960 Moultonborough Middle Level   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
262325 262325 NH     school 3304980 371   Nashua 330498000310 21940 Amherst Street School   Regular School No Elementary KG 05 2020   grade_1                                                   51.0                                             51
262326 262326 NH     school 3304980 371   Nashua 330498000312 21865 Bicentennial Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   84.0                                             84
262327 262327 NH     school 3304980 371   Nashua 330498000313 21895 Birch Hill Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   69.0                                             69
262328 262328 NH     school 3304980 371   Nashua 330498000314 21925 Broad Street Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   42.0                                             42

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