enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 8,432 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▲ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
260995 260995 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
261491 261491 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   kindergarten                                                   0.0                                             0
261987 261987 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   readiness                                                   0.0                                             0
262483 262483 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_1                                                   0.0                                             0
262979 262979 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_2                                                   0.0                                             0
263475 263475 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_3                                                   0.0                                             0
263971 263971 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_4                                                   0.0                                             0
264467 264467 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_5                                                   0.0                                             0
264963 264963 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_6                                                   0.0                                             0
265459 265459 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265955 265955 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_8                                                   0.0                                             0
266451 266451 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_9                                                   864.0                                             864
266947 266947 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_10                                                   796.0                                             796
267443 267443 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_11                                                   797.0                                             797
267939 267939 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_12                                                   674.0                                             674
268435 268435 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   post_graduate                                                   10.0                                             10
268931 268931 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   pk_12_total                                                   3141.0                                             3141
260994 260994 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261490 261490 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
261986 261986 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   readiness                                                   0.0                                             0
262482 262482 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262978 262978 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
263474 263474 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
263970 263970 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
264466 264466 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
264962 264962 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
265458 265458 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265954 265954 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
266450 266450 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_9                                                   182.0                                             182
266946 266946 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_10                                                   156.0                                             156
267442 267442 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_11                                                   173.0                                             173
267938 267938 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_12                                                   179.0                                             179
268434 268434 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   post_graduate                                                   0.0                                             0
268930 268930 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pk_12_total                                                   690.0                                             690
260575 260575 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
261071 261071 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   kindergarten                                                   28.0                                             28
261567 261567 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   readiness                                                   0.0                                             0
262063 262063 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_1                                                   29.0                                             29
262559 262559 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_2                                                   19.0                                             19
263055 263055 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_3                                                   19.0                                             19
263551 263551 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_4                                                   28.0                                             28
264047 264047 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_5                                                   18.0                                             18
264543 264543 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_6                                                   26.0                                             26
265039 265039 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_7                                                   27.0                                             27
265535 265535 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_8                                                   20.0                                             20
266031 266031 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_9                                                   0.0                                             0
266527 266527 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_10                                                   0.0                                             0
267023 267023 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_11                                                   0.0                                             0
267519 267519 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
268015 268015 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   post_graduate                                                   0.0                                             0
268511 268511 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   pk_12_total                                                   214.0                                             214
260996 260996 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261492 261492 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
261988 261988 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   readiness                                                   0.0                                             0
262484 262484 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262980 262980 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
263476 263476 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
263972 263972 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
264468 264468 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
264964 264964 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
265460 265460 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265956 265956 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
266452 266452 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_9                                                   129.0                                             129
266948 266948 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_10                                                   126.0                                             126
267444 267444 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_11                                                   90.0                                             90
267940 267940 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_12                                                   106.0                                             106
268436 268436 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   post_graduate                                                   0.0                                             0
268932 268932 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pk_12_total                                                   451.0                                             451
260574 260574 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
261070 261070 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   kindergarten                                                   35.0                                             35
261566 261566 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   readiness                                                   0.0                                             0
262062 262062 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_1                                                   22.0                                             22
262558 262558 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_2                                                   35.0                                             35
263054 263054 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_3                                                   41.0                                             41
263550 263550 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_4                                                   34.0                                             34
264046 264046 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_5                                                   43.0                                             43
264542 264542 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_6                                                   26.0                                             26
265038 265038 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_7                                                   34.0                                             34
265534 265534 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_8                                                   20.0                                             20
266030 266030 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_9                                                   0.0                                             0
266526 266526 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_10                                                   0.0                                             0
267022 267022 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_11                                                   0.0                                             0
267518 267518 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
268014 268014 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   post_graduate                                                   0.0                                             0
268510 268510 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   pk_12_total                                                   290.0                                             290
260573 260573 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   16.0                                             16
261069 261069 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   kindergarten                                                   45.0                                             45
261565 261565 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   readiness                                                   0.0                                             0
262061 262061 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_1                                                   50.0                                             50
262557 262557 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_2                                                   44.0                                             44
263053 263053 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_3                                                   53.0                                             53
263549 263549 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_4                                                   56.0                                             56
264045 264045 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_5                                                   57.0                                             57
264541 264541 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_6                                                   55.0                                             55
265037 265037 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_7                                                   69.0                                             69
265533 265533 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_8                                                   54.0                                             54
266029 266029 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_9                                                   0.0                                             0
266525 266525 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_10                                                   0.0                                             0
267021 267021 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_11                                                   0.0                                             0
267517 267517 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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