enrollments

Data source: Big Local News · About: Big Local

16,847 rows where state = "NH" sorted by district_state_id descending

✎ 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
260995 260995 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
261491 261491 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   kindergarten                                                   0.0                                             0
261987 261987 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   readiness                                                   0.0                                             0
262483 262483 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_1                                                   0.0                                             0
262979 262979 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_2                                                   0.0                                             0
263475 263475 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_3                                                   0.0                                             0
263971 263971 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_4                                                   0.0                                             0
264467 264467 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_5                                                   0.0                                             0
264963 264963 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_6                                                   0.0                                             0
265459 265459 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265955 265955 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_8                                                   0.0                                             0
266451 266451 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_9                                                   864.0                                             864
266947 266947 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_10                                                   796.0                                             796
267443 267443 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_11                                                   797.0                                             797
267939 267939 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_12                                                   674.0                                             674
268435 268435 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   post_graduate                                                   10.0                                             10
268931 268931 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   pk_12_total                                                   3141.0                                             3141
354889 354889 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_1                                                   0                                             0
354890 354890 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_10                                                   757                                             757
354891 354891 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_11                                                   773                                             773
354892 354892 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_12                                                   694                                             694
354893 354893 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_2                                                   0                                             0
354894 354894 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_3                                                   0                                             0
354895 354895 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_4                                                   0                                             0
354896 354896 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_5                                                   0                                             0
354897 354897 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_6                                                   0                                             0
354898 354898 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_7                                                   0                                             0
354899 354899 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_8                                                   0                                             0
354900 354900 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_9                                                   929                                             929
354901 354901 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   kindergarten                                                   0                                             0
354902 354902 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   pk_12_total                                                   3163                                             3163
354903 354903 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   post_graduate                                                   10                                             10
354904 354904 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   pre_kindergarten                                                   0                                             0
354905 354905 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   readiness                                                   0                                             0
260994 260994 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261490 261490 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
261986 261986 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   readiness                                                   0.0                                             0
262482 262482 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262978 262978 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
263474 263474 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
263970 263970 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
264466 264466 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
264962 264962 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
265458 265458 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265954 265954 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
266450 266450 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_9                                                   182.0                                             182
266946 266946 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_10                                                   156.0                                             156
267442 267442 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_11                                                   173.0                                             173
267938 267938 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_12                                                   179.0                                             179
268434 268434 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   post_graduate                                                   0.0                                             0
268930 268930 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pk_12_total                                                   690.0                                             690
349789 349789 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_1                                                   0                                             0
349790 349790 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_10                                                   171                                             171
349791 349791 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_11                                                   159                                             159
349792 349792 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_12                                                   167                                             167
349793 349793 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_2                                                   0                                             0
349794 349794 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_3                                                   0                                             0
349795 349795 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_4                                                   0                                             0
349796 349796 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_5                                                   0                                             0
349797 349797 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_6                                                   0                                             0
349798 349798 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_7                                                   0                                             0
349799 349799 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_8                                                   0                                             0
349800 349800 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   grade_9                                                   176                                             176
349801 349801 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   kindergarten                                                   0                                             0
349802 349802 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   pk_12_total                                                   673                                             673
349803 349803 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   post_graduate                                                   0                                             0
349804 349804 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
349805 349805 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academy Regular School No High 09 12 2021   readiness                                                   0                                             0
260575 260575 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
261071 261071 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   kindergarten                                                   28.0                                             28
261567 261567 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   readiness                                                   0.0                                             0
262063 262063 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_1                                                   29.0                                             29
262559 262559 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_2                                                   19.0                                             19
263055 263055 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_3                                                   19.0                                             19
263551 263551 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_4                                                   28.0                                             28
264047 264047 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_5                                                   18.0                                             18
264543 264543 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_6                                                   26.0                                             26
265039 265039 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_7                                                   27.0                                             27
265535 265535 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_8                                                   20.0                                             20
266031 266031 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_9                                                   0.0                                             0
266527 266527 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_10                                                   0.0                                             0
267023 267023 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_11                                                   0.0                                             0
267519 267519 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
268015 268015 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   post_graduate                                                   0.0                                             0
268511 268511 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   pk_12_total                                                   214.0                                             214
349687 349687 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_1                                                   25                                             25
349688 349688 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_10                                                   0                                             0
349689 349689 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_11                                                   0                                             0
349690 349690 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_12                                                   0                                             0
349691 349691 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_2                                                   27                                             27
349692 349692 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_3                                                   20                                             20
349693 349693 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_4                                                   18                                             18
349694 349694 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_5                                                   27                                             27
349695 349695 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_6                                                   19                                             19
349696 349696 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_7                                                   24                                             24
349697 349697 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_8                                                   27                                             27
349698 349698 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
349699 349699 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   kindergarten                                                   21                                             21
349700 349700 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   pk_12_total                                                   208                                             208
349701 349701 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School Public School Regular School No Elementary KG 08 2021   post_graduate                                                   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]);