enrollments

Data source: Big Local News · About: Big Local

8,432 rows where state = "NH" and year = 2020 sorted by school_nces_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
260997 260997 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   pre_kindergarten                                                   0.0                                             0
260998 260998 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   pre_kindergarten                                                   0.0                                             0
261493 261493 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   kindergarten                                                   0.0                                             0
261494 261494 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   kindergarten                                                   0.0                                             0
261989 261989 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   readiness                                                   0.0                                             0
261990 261990 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   readiness                                                   0.0                                             0
262485 262485 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_1                                                   0.0                                             0
262486 262486 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_1                                                   0.0                                             0
262981 262981 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_2                                                   0.0                                             0
262982 262982 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_2                                                   0.0                                             0
263477 263477 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_3                                                   0.0                                             0
263478 263478 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_3                                                   0.0                                             0
263973 263973 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_4                                                   0.0                                             0
263974 263974 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_4                                                   0.0                                             0
264469 264469 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_5                                                   0.0                                             0
264470 264470 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_5                                                   0.0                                             0
264965 264965 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_6                                                   0.0                                             0
264966 264966 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_6                                                   0.0                                             0
265461 265461 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_7                                                   9.0                                             9
265462 265462 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_7                                                   0.0                                             0
265957 265957 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_8                                                   9.0                                             9
265958 265958 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_8                                                   0.0                                             0
266453 266453 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_9                                                   0.0                                             0
266454 266454 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_9                                                   12.0                                             12
266949 266949 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_10                                                   0.0                                             0
266950 266950 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_10                                                   11.0                                             11
267445 267445 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_11                                                   0.0                                             0
267446 267446 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_11                                                   18.0                                             18
267941 267941 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   grade_12                                                   0.0                                             0
267942 267942 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   grade_12                                                   15.0                                             15
268437 268437 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   post_graduate                                                   0.0                                             0
268438 268438 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   post_graduate                                                   0.0                                             0
268933 268933 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   pk_12_total                                                   18.0                                             18
268934 268934 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   pk_12_total                                                   56.0                                             56
260890 260890 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261386 261386 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
261882 261882 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   readiness                                                   0.0                                             0
262378 262378 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262874 262874 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
263370 263370 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
263866 263866 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
264362 264362 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
264858 264858 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
265354 265354 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265850 265850 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
266346 266346 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_9                                                   153.0                                             153
266842 266842 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_10                                                   154.0                                             154
267338 267338 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_11                                                   162.0                                             162
267834 267834 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   grade_12                                                   166.0                                             166
268330 268330 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   post_graduate                                                   0.0                                             0
268826 268826 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School   Regular School No High 09 12 2020   pk_12_total                                                   635.0                                             635
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
260991 260991 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   29.0                                             29
261487 261487 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   kindergarten                                                   73.0                                             73
261983 261983 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   readiness                                                   0.0                                             0
262479 262479 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_1                                                   82.0                                             82
262975 262975 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_2                                                   65.0                                             65
263471 263471 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_3                                                   0.0                                             0
263967 263967 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_4                                                   0.0                                             0
264463 264463 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
264959 264959 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
265455 265455 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
265951 265951 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_8                                                   0.0                                             0
266447 266447 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_9                                                   0.0                                             0
266943 266943 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_10                                                   0.0                                             0
267439 267439 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 2020   grade_11                                                   0.0                                             0
267935 267935 NH     school 3307300 582   Winnisquam Regional 330730000467 22945 Union Sanborn School   Regular School No Elementary PK 02 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]);