Data source: Big Local News · About: Big Local

8,415 rows where state = "NH" and year = 2021 sorted by school_nces_id

View and edit SQL

year

  • 2021 · 8,415
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
352237 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_1                                                   0                                             0
352238 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_10                                                   146                                             146
352239 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_11                                                   132                                             132
352240 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_12                                                   169                                             169
352241 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_2                                                   0                                             0
352242 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_3                                                   0                                             0
352243 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_4                                                   0                                             0
352244 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_5                                                   0                                             0
352245 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_6                                                   0                                             0
352246 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
352247 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_8                                                   0                                             0
352248 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   grade_9                                                   167                                             167
352249 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   kindergarten                                                   0                                             0
352250 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   pk_12_total                                                   614                                             614
352251 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   post_graduate                                                   0                                             0
352252 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
352253 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School Public School Regular School No High 09 12 2021   readiness                                                   0                                             0
350588 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_1                                                   0                                             0
350589 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_10                                                   420                                             420
350590 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_11                                                   384                                             384
350591 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_12                                                   400                                             400
350592 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_2                                                   0                                             0
350593 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_3                                                   0                                             0
350594 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_4                                                   0                                             0
350595 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_5                                                   0                                             0
350596 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_6                                                   0                                             0
350597 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
350598 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_8                                                   0                                             0
350599 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   grade_9                                                   368                                             368
350600 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   kindergarten                                                   0                                             0
350601 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   pk_12_total                                                   1572                                             1572
350602 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   post_graduate                                                   0                                             0
350603 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
350604 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School Public School Regular School No High 09 12 2021   readiness                                                   0                                             0
349942 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
349943 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
349944 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_11                                                   0                                             0
349945 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
349946 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
349947 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_3                                                   0                                             0
349948 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
349949 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_5                                                   0                                             0
349950 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_6                                                   338                                             338
349951 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_7                                                   335                                             335
349952 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_8                                                   384                                             384
349953 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
349954 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
349955 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   pk_12_total                                                   1057                                             1057
349956 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   post_graduate                                                   0                                             0
349957 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
349958 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   readiness                                                   0                                             0
354328 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_1                                                   0                                             0
354329 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_10                                                   5                                             5
354330 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_11                                                   16                                             16
354331 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_12                                                   26                                             26
354332 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_2                                                   0                                             0
354333 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_3                                                   0                                             0
354334 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_4                                                   0                                             0
354335 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_5                                                   0                                             0
354336 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_6                                                   0                                             0
354337 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_7                                                   0                                             0
354338 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_8                                                   0                                             0
354339 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_9                                                   0                                             0
354340 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   kindergarten                                                   0                                             0
354341 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   pk_12_total                                                   47                                             47
354342 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   post_graduate                                                   0                                             0
354343 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   pre_kindergarten                                                   0                                             0
354344 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   readiness                                                   0                                             0
355688 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_1                                                   35                                             35
355689 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_10                                                   0                                             0
355690 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_11                                                   0                                             0
355691 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
355692 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_2                                                   33                                             33
355693 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_3                                                   31                                             31
355694 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_4                                                   33                                             33
355695 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_5                                                   33                                             33
355696 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_6                                                   32                                             32
355697 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_7                                                   36                                             36
355698 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_8                                                   33                                             33
355699 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
355700 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   kindergarten                                                   30                                             30
355701 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pk_12_total                                                   296                                             296
355702 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   post_graduate                                                   0                                             0
355703 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   0                                             0
355704 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   readiness                                                   0                                             0
351064 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
351065 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
351066 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_11                                                   0                                             0
351067 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
351068 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
351069 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_3                                                   0                                             0
351070 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
351071 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_5                                                   0                                             0
351072 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_6                                                   32                                             32
351073 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_7                                                   35                                             35
351074 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_8                                                   35                                             35
351075 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
351076 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
351077 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   pk_12_total                                                   102                                             102
351078 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 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]);