enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
260602 260602 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   pre_kindergarten                                                   0.0                                             0
261098 261098 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   kindergarten                                                   0.0                                             0
261594 261594 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   readiness                                                   0.0                                             0
262090 262090 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_1                                                   0.0                                             0
262586 262586 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_2                                                   0.0                                             0
263082 263082 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_3                                                   0.0                                             0
263578 263578 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_4                                                   0.0                                             0
264074 264074 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_5                                                   0.0                                             0
264570 264570 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_6                                                   0.0                                             0
265066 265066 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_7                                                   130.0                                             130
265562 265562 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_8                                                   151.0                                             151
266058 266058 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_9                                                   0.0                                             0
266554 266554 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_10                                                   0.0                                             0
267050 267050 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_11                                                   0.0                                             0
267546 267546 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   grade_12                                                   0.0                                             0
268042 268042 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   post_graduate                                                   0.0                                             0
268538 268538 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School   Regular School No Middle 07 08 2020   pk_12_total                                                   281.0                                             281
260584 260584 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0.0                                             0
261080 261080 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   kindergarten                                                   51.0                                             51
261576 261576 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   readiness                                                   0.0                                             0
262072 262072 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_1                                                   50.0                                             50
262568 262568 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_2                                                   58.0                                             58
263064 263064 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_3                                                   59.0                                             59
263560 263560 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_4                                                   65.0                                             65
264056 264056 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_5                                                   60.0                                             60
264552 264552 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
265048 265048 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
265544 265544 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
266040 266040 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_9                                                   0.0                                             0
266536 266536 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_10                                                   0.0                                             0
267032 267032 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_11                                                   0.0                                             0
267528 267528 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   grade_12                                                   0.0                                             0
268024 268024 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   post_graduate                                                   0.0                                             0
268520 268520 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School   Regular School No Elementary KG 05 2020   pk_12_total                                                   343.0                                             343
260999 260999 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261495 261495 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   kindergarten                                                   0.0                                             0
261991 261991 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   readiness                                                   0.0                                             0
262487 262487 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_1                                                   0.0                                             0
262983 262983 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_2                                                   0.0                                             0
263479 263479 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_3                                                   0.0                                             0
263975 263975 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_4                                                   0.0                                             0
264471 264471 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_5                                                   0.0                                             0
264967 264967 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_6                                                   0.0                                             0
265463 265463 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
265959 265959 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_8                                                   0.0                                             0
266455 266455 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   55.0                                             55
266951 266951 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_10                                                   72.0                                             72
267447 267447 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_11                                                   52.0                                             52
267943 267943 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_12                                                   47.0                                             47
268439 268439 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   post_graduate                                                   0.0                                             0
268935 268935 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   226.0                                             226
261000 261000 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
261496 261496 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   kindergarten                                                   0.0                                             0
261992 261992 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   readiness                                                   0.0                                             0
262488 262488 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_1                                                   0.0                                             0
262984 262984 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_2                                                   0.0                                             0
263480 263480 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_3                                                   0.0                                             0
263976 263976 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_4                                                   0.0                                             0
264472 264472 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_5                                                   0.0                                             0
264968 264968 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_6                                                   100.0                                             100
265464 265464 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_7                                                   98.0                                             98
265960 265960 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_8                                                   111.0                                             111
266456 266456 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_9                                                   0.0                                             0
266952 266952 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_10                                                   0.0                                             0
267448 267448 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_11                                                   0.0                                             0
267944 267944 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   grade_12                                                   0.0                                             0
268440 268440 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   post_graduate                                                   0.0                                             0
268936 268936 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total                                                   309.0                                             309
260636 260636 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   pre_kindergarten                                                   0.0                                             0
261132 261132 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   kindergarten                                                   0.0                                             0
261628 261628 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   readiness                                                   0.0                                             0
262124 262124 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_1                                                   5.0                                             5
262620 262620 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_2                                                   8.0                                             8
263116 263116 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_3                                                   6.0                                             6
263612 263612 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_4                                                   3.0                                             3
264108 264108 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_5                                                   0.0                                             0
264604 264604 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_6                                                   0.0                                             0
265100 265100 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_7                                                   0.0                                             0
265596 265596 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_8                                                   0.0                                             0
266092 266092 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_9                                                   0.0                                             0
266588 266588 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_10                                                   0.0                                             0
267084 267084 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_11                                                   0.0                                             0
267580 267580 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   grade_12                                                   0.0                                             0
268076 268076 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   post_graduate                                                   0.0                                             0
268572 268572 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School   Regular School No Elementary 01 04 2020   pk_12_total                                                   22.0                                             22
260680 260680 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   pre_kindergarten                                                   0.0                                             0
261176 261176 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   kindergarten                                                   0.0                                             0
261672 261672 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   readiness                                                   0.0                                             0
262168 262168 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_1                                                   0.0                                             0
262664 262664 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_2                                                   0.0                                             0
263160 263160 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_3                                                   119.0                                             119
263656 263656 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_4                                                   106.0                                             106
264152 264152 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_5                                                   125.0                                             125
264648 264648 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_6                                                   0.0                                             0
265144 265144 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
265640 265640 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_8                                                   0.0                                             0
266136 266136 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_9                                                   0.0                                             0
266632 266632 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_10                                                   0.0                                             0
267128 267128 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 2020   grade_11                                                   0.0                                             0
267624 267624 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School   Regular School No Elementary 03 05 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]);