enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id ▼ school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
267115 267115 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_11                                                   0.0                                             0
267611 267611 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_12                                                   0.0                                             0
268107 268107 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   post_graduate                                                   0.0                                             0
268603 268603 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   pk_12_total                                                   99.0                                             99
351064 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
351079 351079 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
351080 351080 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School Public School Regular School No Middle 06 08 2021   readiness                                                   0                                             0
260665 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
261161 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
261657 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
262153 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
262649 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
263145 263145 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_3                                                   28.0                                             28
263641 263641 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_4                                                   21.0                                             21
264137 264137 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_5                                                   30.0                                             30
264633 264633 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
265129 265129 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
265625 265625 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
266121 266121 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_9                                                   0.0                                             0
266617 266617 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_10                                                   0.0                                             0
267113 267113 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_11                                                   0.0                                             0
267609 267609 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   grade_12                                                   0.0                                             0
268105 268105 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   post_graduate                                                   0.0                                             0
268601 268601 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School   Regular School No Elementary KG 05 2020   pk_12_total                                                   148.0                                             148
350384 350384 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_1                                                   26                                             26
350385 350385 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_10                                                   0                                             0
350386 350386 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_11                                                   0                                             0
350387 350387 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
350388 350388 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_2                                                   26                                             26
350389 350389 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_3                                                   24                                             24
350390 350390 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_4                                                   23                                             23
350391 350391 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_5                                                   22                                             22
350392 350392 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_6                                                   0                                             0
350393 350393 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
350394 350394 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_8                                                   0                                             0
350395 350395 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
350396 350396 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   kindergarten                                                   22                                             22
350397 350397 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   pk_12_total                                                   143                                             143
350398 350398 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   post_graduate                                                   0                                             0
350399 350399 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
350400 350400 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500141 20745 Edward Fenn School Public School Regular School No Elementary KG 05 2021   readiness                                                   0                                             0
260666 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
261162 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
261658 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
262154 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
262650 262650 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
263146 263146 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
263642 263642 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
264138 264138 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
264634 264634 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
265130 265130 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265626 265626 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
266122 266122 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_9                                                   34.0                                             34
266618 266618 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_10                                                   39.0                                             39
267114 267114 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_11                                                   34.0                                             34
267610 267610 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_12                                                   29.0                                             29
268106 268106 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   post_graduate                                                   0.0                                             0
268602 268602 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   pk_12_total                                                   136.0                                             136
351047 351047 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_1                                                   0                                             0
351048 351048 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_10                                                   36                                             36
351049 351049 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_11                                                   38                                             38
351050 351050 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_12                                                   35                                             35
351051 351051 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_2                                                   0                                             0
351052 351052 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_3                                                   0                                             0
351053 351053 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_4                                                   0                                             0
351054 351054 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_5                                                   0                                             0
351055 351055 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_6                                                   0                                             0
351056 351056 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
351057 351057 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_8                                                   0                                             0
351058 351058 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   grade_9                                                   32                                             32
351059 351059 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   kindergarten                                                   0                                             0
351060 351060 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   pk_12_total                                                   141                                             141
351061 351061 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   post_graduate                                                   0                                             0
351062 351062 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
351063 351063 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School Public School Regular School No High 09 12 2021   readiness                                                   0                                             0
261003 261003 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261499 261499 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   kindergarten                                                   0.0                                             0
261995 261995 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   readiness                                                   0.0                                             0
262491 262491 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   grade_1                                                   0.0                                             0
262987 262987 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   grade_2                                                   0.0                                             0
263483 263483 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   grade_3                                                   0.0                                             0
263979 263979 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   grade_4                                                   0.0                                             0
264475 264475 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   grade_5                                                   0.0                                             0
264971 264971 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   grade_6                                                   0.0                                             0
265467 265467 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
265963 265963 NH     school 3300036 707   Cocheco Academy for the Arts 330003600614 28455 Cocheco Academy for the Arts Public Charter Schools Regular School Yes High 09 12 2020   grade_8                                                   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]);