enrollments

Data source: Big Local News · About: Big Local

16,847 rows where state = "NH" sorted by rowid descending

✎ 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
356947 356947 NH     school 3307300 582   Winnisquam Regional 330730000466 22955 Winnisquam Regional Middle School Public School Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
356946 356946 NH     school 3307300 582   Winnisquam Regional 330730000466 22955 Winnisquam Regional Middle School Public School Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
356945 356945 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   readiness                                                   0                                             0
356944 356944 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
356943 356943 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   post_graduate                                                   0                                             0
356942 356942 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   pk_12_total                                                   447                                             447
356941 356941 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   kindergarten                                                   0                                             0
356940 356940 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_9                                                   122                                             122
356939 356939 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_8                                                   0                                             0
356938 356938 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
356937 356937 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_6                                                   0                                             0
356936 356936 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_5                                                   0                                             0
356935 356935 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_4                                                   0                                             0
356934 356934 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_3                                                   0                                             0
356933 356933 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_2                                                   0                                             0
356932 356932 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_12                                                   103                                             103
356931 356931 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_11                                                   111                                             111
356930 356930 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_10                                                   111                                             111
356929 356929 NH     school 3307300 582   Winnisquam Regional 330730000465 22950 Winnisquam Regional High School Public School Regular School No High 09 12 2021   grade_1                                                   0                                             0
356928 356928 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   readiness                                                   0                                             0
356927 356927 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   pre_kindergarten                                                   0                                             0
356926 356926 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   post_graduate                                                   3                                             3
356925 356925 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   pk_12_total                                                   1100                                             1100
356924 356924 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   kindergarten                                                   0                                             0
356923 356923 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_9                                                   281                                             281
356922 356922 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_8                                                   0                                             0
356921 356921 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
356920 356920 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_6                                                   0                                             0
356919 356919 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_5                                                   0                                             0
356918 356918 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_4                                                   0                                             0
356917 356917 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_3                                                   0                                             0
356916 356916 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_2                                                   0                                             0
356915 356915 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_12                                                   261                                             261
356914 356914 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_11                                                   273                                             273
356913 356913 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_10                                                   282                                             282
356912 356912 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_1                                                   0                                             0
356911 356911 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   readiness                                                   0                                             0
356910 356910 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   pre_kindergarten                                                   0                                             0
356909 356909 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   post_graduate                                                   0                                             0
356908 356908 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   pk_12_total                                                   509                                             509
356907 356907 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   kindergarten                                                   0                                             0
356906 356906 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
356905 356905 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_8                                                   261                                             261
356904 356904 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_7                                                   248                                             248
356903 356903 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_6                                                   0                                             0
356902 356902 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_5                                                   0                                             0
356901 356901 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_4                                                   0                                             0
356900 356900 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_3                                                   0                                             0
356899 356899 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_2                                                   0                                             0
356898 356898 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_12                                                   0                                             0
356897 356897 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_11                                                   0                                             0
356896 356896 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_10                                                   0                                             0
356895 356895 NH     school 3307170 575   Windham 330717000495 21125 Windham Middle School Public School Regular School No Middle 07 08 2021   grade_1                                                   0                                             0
356894 356894 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   readiness                                                   0                                             0
356893 356893 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
356892 356892 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   post_graduate                                                   0                                             0
356891 356891 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   pk_12_total                                                   1020                                             1020
356890 356890 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   kindergarten                                                   0                                             0
356889 356889 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_9                                                   266                                             266
356888 356888 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_8                                                   0                                             0
356887 356887 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_7                                                   0                                             0
356886 356886 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_6                                                   0                                             0
356885 356885 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_5                                                   0                                             0
356884 356884 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_4                                                   0                                             0
356883 356883 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_3                                                   0                                             0
356882 356882 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_2                                                   0                                             0
356881 356881 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_12                                                   231                                             231
356880 356880 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_11                                                   254                                             254
356879 356879 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_10                                                   269                                             269
356878 356878 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   grade_1                                                   0                                             0
356877 356877 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   readiness                                                   0                                             0
356876 356876 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   pre_kindergarten                                                   0                                             0
356875 356875 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   post_graduate                                                   0                                             0
356874 356874 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   pk_12_total                                                   415                                             415
356873 356873 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   kindergarten                                                   0                                             0
356872 356872 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_9                                                   0                                             0
356871 356871 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_8                                                   0                                             0
356870 356870 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_7                                                   0                                             0
356869 356869 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_6                                                   203                                             203
356868 356868 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_5                                                   212                                             212
356867 356867 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_4                                                   0                                             0
356866 356866 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_3                                                   0                                             0
356865 356865 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_2                                                   0                                             0
356864 356864 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_12                                                   0                                             0
356863 356863 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_11                                                   0                                             0
356862 356862 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_10                                                   0                                             0
356861 356861 NH     school 3307170 575   Windham 330717000460 21135 Windham Center School Public School Regular School No Middle 05 06 2021   grade_1                                                   0                                             0
356860 356860 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   readiness                                                   0                                             0
356859 356859 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
356858 356858 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   post_graduate                                                   0                                             0
356857 356857 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   pk_12_total                                                   245                                             245
356856 356856 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   kindergarten                                                   54                                             54
356855 356855 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_9                                                   0                                             0
356854 356854 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_8                                                   0                                             0
356853 356853 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_7                                                   0                                             0
356852 356852 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_6                                                   0                                             0
356851 356851 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_5                                                   22                                             22
356850 356850 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_4                                                   22                                             22
356849 356849 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_3                                                   23                                             23
356848 356848 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   grade_2                                                   61                                             61

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