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
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
260843 260843 NH     school 3304980 371   Nashua 330498000317 21890 Elm Street Middle School   Regular School No Middle 06 08 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
260845 260845 NH     school 3304980 371   Nashua 330498000319 21875 Fairgrounds Middle School   Regular School No Middle 06 08 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
260849 260849 NH     school 3304980 371   Nashua 330498000598 27960 Nashua High School North   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260850 260850 NH     school 3304980 371   Nashua 330498000323 21860 Nashua High School South   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260851 260851 NH     school 3304980 371   Nashua 330498000714 29152 Nashua Title I Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   46.0                                             46
260852 260852 NH     school 3304980 371   Nashua 330498000324 21845 New Searles School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   80.0                                             80
260853 260853 NH     school 3304980 371   Nashua 330498000325 21825 Pennichuck Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260854 260854 NH     school 3304980 371   Nashua 330498000682 28610 Purple Panthers Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   35.0                                             35
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
260864 260864 NH     school 3305220 388   Newfound Area 330522000517 26680 Newfound Memorial Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260865 260865 NH     school 3305220 388   Newfound Area 330522000336 20085 Newfound Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260866 260866 NH     school 3305250 391   Newington 330525000339 22465 Newington Public School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260867 260867 NH     school 3305280 399   Newmarket 330528000340 21300 Newmarket Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   42.0                                             42
260868 260868 NH     school 3305280 399   Newmarket 330528000542 26560 Newmarket Jr.-Sr. High (Elem)   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260869 260869 NH     school 3305280 399   Newmarket 330528000518 23115 Newmarket Jr.-Sr. High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260870 260870 NH     school 3305310 401   Newport 330531000342 21985 Newport Middle High School (High)   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260871 260871 NH     school 3305310 401   Newport 330531000093 26970 Newport Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260872 260872 NH     school 3305310 401   Newport 330531000343 21995 Richards Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   26.0                                             26
260873 260873 NH     school 3305370 405   North Hampton 330537000345 20805 North Hampton School   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   13.0                                             13
260874 260874 NH     school 3305400 407   Northumberland 330540000346 22905 Groveton Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260875 260875 NH     school 3305400 407   Northumberland 330540000347 22900 Groveton High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260876 260876 NH     school 3305400 407   Northumberland 330540000529 26600 Groveton High School (Middle)   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260877 260877 NH     school 3305430 411   Northwood 330543000348 22085 Northwood Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260878 260878 NH     school 3305460 413   Nottingham 330546000349 22095 Nottingham Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260879 260879 NH     school 3305520 423   Oyster River Coop 330552000352 22805 Mast Way School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260880 260880 NH     school 3305520 423   Oyster River Coop 330552000520 26660 Moharimet School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260881 260881 NH     school 3305520 423   Oyster River Coop 330552000354 22800 Oyster River High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260882 260882 NH     school 3305520 423   Oyster River Coop 330552000355 22790 Oyster River Middle School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
260883 260883 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   34.0                                             34
260884 260884 NH     school 3305550 425   Pelham 330555000600 27970 Pelham Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   66.0                                             66
260885 260885 NH     school 3305550 425   Pelham 330555000358 21105 Pelham High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260886 260886 NH     school 3305550 425   Pelham 330555000357 21110 Pelham Memorial School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260887 260887 NH     school 3305580 427   Pembroke 330558000359 22620 Pembroke Academy   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260888 260888 NH     school 3305580 427   Pembroke 330558000361 22615 Pembroke Hill School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260889 260889 NH     school 3305580 427   Pembroke 330558000042 26925 Three Rivers School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
260890 260890 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260891 260891 NH     school 3305670 435   Piermont 330567000362 20895 Piermont Village School   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   9.0                                             9
260892 260892 NH     school 3305700 437   Pittsburg 330570000363 20205 Pittsburg School (Elem)   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   4.0                                             4
260893 260893 NH     school 3305700 437   Pittsburg 330570000528 26500 Pittsburg School (High)   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260894 260894 NH     school 3305730 439   Pittsfield 330573000509 26595 Pittsfield Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   13.0                                             13
260895 260895 NH     school 3305730 439   Pittsfield 330573000366 22500 Pittsfield High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260896 260896 NH     school 3305730 439   Pittsfield 330573000539 26550 Pittsfield Middle School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
260897 260897 NH     school 3305760 441   Plainfield 330576000368 21375 Plainfield Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260898 260898 NH     school 3305790 447   Plymouth 330579000370 22355 Plymouth Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   30.0                                             30
260899 260899 NH     school 3305820 449   Portsmouth 330582000376 22515 Little Harbour School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260900 260900 NH     school 3305820 449   Portsmouth 330582000373 22545 Mary C. Dondero Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260901 260901 NH     school 3305820 449   Portsmouth 330582000377 22525 New Franklin School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260902 260902 NH     school 3305820 449   Portsmouth 330582000547 22560 PEEP School - Pre School Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   16.0                                             16
260903 260903 NH     school 3305820 449   Portsmouth 330582000379 22565 Portsmouth High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260904 260904 NH     school 3305820 449   Portsmouth 330582000378 22510 Portsmouth Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260905 260905 NH     school 3305830 450   Profile 330583000097 26990 Profile Junior High School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
260906 260906 NH     school 3305830 450   Profile 330583000382 21395 Profile Senior High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260907 260907 NH     school 3305880 453   Raymond 330588000521 26525 Iber Holmes Gove Middle School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
260908 260908 NH     school 3305880 453   Raymond 330588000384 21385 Lamprey River Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   47.0                                             47
260909 260909 NH     school 3305880 453   Raymond 330588000385 21390 Raymond High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260910 260910 NH     school 3305940 461   Rochester 330594000694 22675 Bud Carlson Academy   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260911 260911 NH     school 3305940 461   Rochester 330594000388 22695 Chamberlain Street School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260912 260912 NH     school 3305940 461   Rochester 330594000392 22650 East Rochester School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   69.0                                             69
260913 260913 NH     school 3305940 461   Rochester 330594000389 22725 Gonic School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260914 260914 NH     school 3305940 461   Rochester 330594000709 29080 Maple Street Magnet School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260915 260915 NH     school 3305940 461   Rochester 330594000391 22665 McClelland School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260916 260916 NH     school 3305940 461   Rochester 330594000522 22660 Nancy Loud School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260917 260917 NH     school 3305940 461   Rochester 330594000395 22705 Rochester Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260918 260918 NH     school 3305940 461   Rochester 330594000393 22720 School Street School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260919 260919 NH     school 3305940 461   Rochester 330594000394 22700 Spaulding High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260920 260920 NH     school 3305940 461   Rochester 330594000386 22690 William Allen School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260921 260921 NH     school 3305970 463   Rollinsford 330597000396 22810 Rollinsford Grade School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260922 260922 NH     school 3306000 467   Rumney 330600000397 22375 Russell Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260923 260923 NH     school 3306030 471   Rye 330603000398 22475 Rye Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   20.0                                             20
260924 260924 NH     school 3306030 471   Rye 330603000399 22470 Rye Junior High School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
260925 260925 NH     school 3306060 473   Salem 330606000401 22895 Dr. L. F. Soule School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260926 260926 NH     school 3306060 473   Salem 330606000404 22875 Mary A. Fisk Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260927 260927 NH     school 3306060 473   Salem 330606000406 22890 North Salem Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260928 260928 NH     school 3306060 473   Salem 330606000407 22880 Salem High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260929 260929 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   87.0                                             87
260930 260930 NH     school 3306060 473   Salem 330606000403 22860 William E. Lancaster School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260931 260931 NH     school 3306060 473   Salem 330606000400 22865 William T. Barron Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260932 260932 NH     school 3306060 473   Salem 330606000409 22850 Woodbury School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260933 260933 NH     school 3306080 476   Sanborn Regional 330608000478 20625 Daniel J. Bakie School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   27.0                                             27
260934 260934 NH     school 3306080 476   Sanborn Regional 330608000477 20635 Memorial School   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   24.0                                             24
260935 260935 NH     school 3306080 476   Sanborn Regional 330608000479 20620 Sanborn Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260936 260936 NH     school 3306080 476   Sanborn Regional 330608000476 20630 Sanborn Regional Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260937 260937 NH     school 3306150 485   Seabrook 330615000410 20810 Seabrook Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   39.0                                             39
260938 260938 NH     school 3306150 485   Seabrook 330615000601 27995 Seabrook Middle School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
260939 260939 NH     school 3306180 486   Shaker Regional 330618000490 22135 Belmont Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   34.0                                             34
260940 260940 NH     school 3306180 486   Shaker Regional 330618000411 22145 Belmont High School   Regular School No High 09 12 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]);