enrollments

Data source: Big Local News · About: Big Local

16,847 rows where state = "NH" sorted by school_state_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
260547 260547 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
261043 261043 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   kindergarten                                                   22.0                                             22
261539 261539 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   readiness                                                   0.0                                             0
262035 262035 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_1                                                   22.0                                             22
262531 262531 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_2                                                   16.0                                             16
263027 263027 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_3                                                   28.0                                             28
263523 263523 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_4                                                   16.0                                             16
264019 264019 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_5                                                   16.0                                             16
264515 264515 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_6                                                   14.0                                             14
265011 265011 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_7                                                   14.0                                             14
265507 265507 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_8                                                   21.0                                             21
266003 266003 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_9                                                   0.0                                             0
266499 266499 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_10                                                   0.0                                             0
266995 266995 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_11                                                   0.0                                             0
267491 267491 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
267987 267987 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   post_graduate                                                   0.0                                             0
268483 268483 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School   Regular School No Elementary KG 08 2020   pk_12_total                                                   169.0                                             169
348888 348888 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_1                                                   19                                             19
348889 348889 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_10                                                   0                                             0
348890 348890 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_11                                                   0                                             0
348891 348891 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_12                                                   0                                             0
348892 348892 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_2                                                   24                                             24
348893 348893 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_3                                                   14                                             14
348894 348894 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_4                                                   23                                             23
348895 348895 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_5                                                   16                                             16
348896 348896 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_6                                                   17                                             17
348897 348897 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_7                                                   12                                             12
348898 348898 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_8                                                   16                                             16
348899 348899 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   grade_9                                                   0                                             0
348900 348900 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   kindergarten                                                   18                                             18
348901 348901 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   pk_12_total                                                   159                                             159
348902 348902 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   post_graduate                                                   0                                             0
348903 348903 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   pre_kindergarten                                                   0                                             0
348904 348904 NH     school 3301560 23   Ashland 330156000010 20010 Ashland Elementary School Public School Regular School No Elementary KG 08 2021   readiness                                                   0                                             0
260715 260715 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
261211 261211 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   kindergarten                                                   0.0                                             0
261707 261707 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   readiness                                                   0.0                                             0
262203 262203 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_1                                                   0.0                                             0
262699 262699 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_2                                                   0.0                                             0
263195 263195 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_3                                                   0.0                                             0
263691 263691 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_4                                                   0.0                                             0
264187 264187 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_5                                                   0.0                                             0
264683 264683 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_6                                                   0.0                                             0
265179 265179 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265675 265675 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_8                                                   0.0                                             0
266171 266171 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_9                                                   64.0                                             64
266667 266667 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_10                                                   85.0                                             85
267163 267163 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_11                                                   69.0                                             69
267659 267659 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_12                                                   80.0                                             80
268155 268155 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   post_graduate                                                   3.0                                             3
268651 268651 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   pk_12_total                                                   301.0                                             301
351999 351999 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_1                                                   0                                             0
352000 352000 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_10                                                   62                                             62
352001 352001 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_11                                                   81                                             81
352002 352002 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_12                                                   70                                             70
352003 352003 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_2                                                   0                                             0
352004 352004 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_3                                                   0                                             0
352005 352005 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_4                                                   0                                             0
352006 352006 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_5                                                   0                                             0
352007 352007 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_6                                                   0                                             0
352008 352008 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
352009 352009 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_8                                                   0                                             0
352010 352010 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   grade_9                                                   77                                             77
352011 352011 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   kindergarten                                                   0                                             0
352012 352012 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   pk_12_total                                                   290                                             290
352013 352013 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   post_graduate                                                   0                                             0
352014 352014 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
352015 352015 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School Public School Regular School No High 09 12 2021   readiness                                                   0                                             0
260717 260717 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   pre_kindergarten                                                   0.0                                             0
261213 261213 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   kindergarten                                                   9.0                                             9
261709 261709 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   readiness                                                   0.0                                             0
262205 262205 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_1                                                   13.0                                             13
262701 262701 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_2                                                   8.0                                             8
263197 263197 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_3                                                   8.0                                             8
263693 263693 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_4                                                   17.0                                             17
264189 264189 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_5                                                   5.0                                             5
264685 264685 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_6                                                   17.0                                             17
265181 265181 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_7                                                   0.0                                             0
265677 265677 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_8                                                   0.0                                             0
266173 266173 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_9                                                   0.0                                             0
266669 266669 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_10                                                   0.0                                             0
267165 267165 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_11                                                   0.0                                             0
267661 267661 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   grade_12                                                   0.0                                             0
268157 268157 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   post_graduate                                                   0.0                                             0
268653 268653 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School   Regular School No Elementary KG 06 2020   pk_12_total                                                   77.0                                             77
355603 355603 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_1                                                   8                                             8
355604 355604 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
355605 355605 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_11                                                   0                                             0
355606 355606 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_12                                                   0                                             0
355607 355607 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_2                                                   12                                             12
355608 355608 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_3                                                   8                                             8
355609 355609 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_4                                                   5                                             5
355610 355610 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_5                                                   15                                             15
355611 355611 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_6                                                   3                                             3
355612 355612 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_7                                                   0                                             0
355613 355613 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_8                                                   0                                             0
355614 355614 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
355615 355615 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   kindergarten                                                   11                                             11
355616 355616 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   pk_12_total                                                   62                                             62
355617 355617 NH     school 3303960 269   Inter-Lakes Cooperative 330396000183 20040 Sandwich Central School Public School Regular School No Elementary KG 06 2021   post_graduate                                                   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);