Data source: Big Local News · About: Big Local

16,847 rows where state = "NH" sorted by district_nces_id

View and edit SQL

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
268467 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   post_graduate                                                   0.0                                             0
268963 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   pk_12_total                                                   297.0                                             297
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
260665 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
260666 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
260667 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
261161 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   kindergarten                                                   21.0                                             21
261162 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
261163 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   kindergarten                                                   0.0                                             0
261657 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   readiness                                                   0.0                                             0
261658 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   readiness                                                   0.0                                             0
261659 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   readiness                                                   0.0                                             0
262153 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_1                                                   25.0                                             25
262154 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262155 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262649 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_2                                                   23.0                                             23

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]);