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 ▼
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
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
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
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
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
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
260853 260853 NH     school 3304980 371   Nashua 330498000325 21825 Pennichuck Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
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
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
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
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
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
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
260893 260893 NH     school 3305700 437   Pittsburg 330570000528 26500 Pittsburg School (High)   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
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
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
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
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
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
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
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
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
260938 260938 NH     school 3306150 485   Seabrook 330615000601 27995 Seabrook Middle School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
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
260941 260941 NH     school 3306180 486   Shaker Regional 330618000413 22150 Belmont Middle School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
260942 260942 NH     school 3306180 486   Shaker Regional 330618000412 22165 Canterbury Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260944 260944 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten                                                   0.0                                             0
260945 260945 NH     school 3306240 491   Somersworth 330624000418 22845 Somersworth High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260946 260946 NH     school 3306240 491   Somersworth 330624000420 22830 Somersworth Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260947 260947 NH     school 3306260 493   Souhegan Cooperative 330626000034 26860 Souhegan Coop High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260948 260948 NH     school 3306270 495   South Hampton 330627000422 20815 South Hampton Barnard School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260949 260949 NH     school 3306330 499   Stark 330633000423 22910 Stark Village School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
260951 260951 NH     school 3306390 503   Stoddard 330639000426 20980 James Faulkner Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260952 260952 NH     school 3306420 507   Strafford 330642000427 22100 Strafford School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
260955 260955 NH     school 3306540 515   Sunapee 330654000430 22005 Sunapee Central School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260956 260956 NH     school 3306540 515   Sunapee 330654000101 26965 Sunapee Middle High School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
260957 260957 NH     school 3306540 515   Sunapee 330654000431 22000 Sunapee Sr. High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
260958 260958 NH     school 3306600 525   Tamworth 330660000432 20365 Kenneth A. Brett School   Regular School No Elementary KG 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]);