Data source: Big Local News · About: Big Local

8,432 rows where state = "NH" and year = 2020 sorted by school_nces_id

View and edit SQL

year

  • 2020 · 8,432
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
260723 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261219 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
261715 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   readiness                                                   0.0                                             0
262211 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262707 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
263203 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
263699 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
264195 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
264691 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
265187 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265683 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
266179 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_9                                                   146.0                                             146
266675 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_10                                                   143.0                                             143
267171 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_11                                                   175.0                                             175
267667 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_12                                                   146.0                                             146
268163 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   post_graduate                                                   0.0                                             0
268659 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   pk_12_total                                                   610.0                                             610
260633 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
261129 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   kindergarten                                                   0.0                                             0
261625 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   readiness                                                   0.0                                             0
262121 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_1                                                   0.0                                             0
262617 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_2                                                   0.0                                             0
263113 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_3                                                   0.0                                             0
263609 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_4                                                   0.0                                             0
264105 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_5                                                   0.0                                             0
264601 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_6                                                   0.0                                             0
265097 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265593 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_8                                                   0.0                                             0
266089 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_9                                                   437.0                                             437
266585 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_10                                                   392.0                                             392
267081 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_11                                                   409.0                                             409
267577 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_12                                                   404.0                                             404
268073 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   post_graduate                                                   1.0                                             1
268569 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   pk_12_total                                                   1643.0                                             1643
260632 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
261128 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   kindergarten                                                   0.0                                             0
261624 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   readiness                                                   0.0                                             0
262120 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262616 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_2                                                   0.0                                             0
263112 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_3                                                   0.0                                             0
263608 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
264104 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
264600 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_6                                                   356.0                                             356
265096 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_7                                                   387.0                                             387
265592 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_8                                                   373.0                                             373
266088 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_9                                                   0.0                                             0
266584 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_10                                                   0.0                                             0
267080 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_11                                                   0.0                                             0
267576 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   grade_12                                                   0.0                                             0
268072 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   post_graduate                                                   0.0                                             0
268568 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   1116.0                                             1116
261022 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261518 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   kindergarten                                                   0.0                                             0
262014 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   readiness                                                   0.0                                             0
262510 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_1                                                   0.0                                             0
263006 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_2                                                   0.0                                             0
263502 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_3                                                   0.0                                             0
263998 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_4                                                   0.0                                             0
264494 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_5                                                   0.0                                             0
264990 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_6                                                   0.0                                             0
265486 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
265982 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_8                                                   0.0                                             0
266478 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   1.0                                             1
266974 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_10                                                   12.0                                             12
267470 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_11                                                   26.0                                             26
267966 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_12                                                   14.0                                             14
268462 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   post_graduate                                                   0.0                                             0
268958 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   53.0                                             53
261023 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   pre_kindergarten                                                   0.0                                             0
261519 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   kindergarten                                                   0.0                                             0
262015 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   readiness                                                   0.0                                             0
262511 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_1                                                   0.0                                             0
263007 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_2                                                   0.0                                             0
263503 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_3                                                   0.0                                             0
263999 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_4                                                   0.0                                             0
264495 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_5                                                   0.0                                             0
264991 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_6                                                   0.0                                             0
265487 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_7                                                   0.0                                             0
265983 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_8                                                   1.0                                             1
266479 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_9                                                   0.0                                             0
266975 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_10                                                   0.0                                             0
267471 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_11                                                   0.0                                             0
267967 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_12                                                   0.0                                             0
268463 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   post_graduate                                                   0.0                                             0
268959 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   pk_12_total                                                   1.0                                             1
261027 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
261523 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   kindergarten                                                   38.0                                             38
262019 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   readiness                                                   0.0                                             0
262515 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_1                                                   34.0                                             34
263011 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_2                                                   31.0                                             31
263507 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_3                                                   32.0                                             32
264003 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_4                                                   31.0                                             31
264499 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_5                                                   33.0                                             33
264995 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_6                                                   32.0                                             32
265491 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_7                                                   33.0                                             33
265987 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_8                                                   33.0                                             33
266483 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
266979 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_10                                                   0.0                                             0
267475 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_11                                                   0.0                                             0
267971 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_12                                                   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]);