enrollments

Data source: Big Local News · About: Big Local

16,847 rows where state = "NH" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▼ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
348633 348633 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_1                                                   0                                             0
348634 348634 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_10                                                   0                                             0
348635 348635 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_11                                                   0                                             0
348636 348636 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_12                                                   0                                             0
348637 348637 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_2                                                   0                                             0
348638 348638 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_3                                                   0                                             0
348639 348639 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_4                                                   0                                             0
348640 348640 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_5                                                   0                                             0
348641 348641 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_6                                                   0                                             0
348644 348644 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
348645 348645 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   kindergarten                                                   0                                             0
348647 348647 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   post_graduate                                                   0                                             0
348648 348648 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   pre_kindergarten                                                   0                                             0
348649 348649 NH     school 3302490 113   Conway 330249000043 27010 A. Crosby Kennett Middle School Public School Regular School No Middle 07 08 2021   readiness                                                   0                                             0
348651 348651 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   grade_10                                                   0                                             0
348652 348652 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   grade_11                                                   0                                             0
348653 348653 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
348658 348658 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   grade_6                                                   0                                             0
348659 348659 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   grade_7                                                   0                                             0
348660 348660 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   grade_8                                                   0                                             0
348661 348661 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   grade_9                                                   0                                             0
348664 348664 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   post_graduate                                                   0                                             0
348665 348665 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
348666 348666 NH     school 3302460 111   Concord 330246000054 20240 Abbot-Downing School Public School Regular School No Elementary KG 05 2021   readiness                                                   0                                             0
348667 348667 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_1                                                   0                                             0
348671 348671 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_2                                                   0                                             0
348672 348672 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_3                                                   0                                             0
348673 348673 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_4                                                   0                                             0
348674 348674 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_5                                                   0                                             0
348675 348675 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_6                                                   0                                             0
348676 348676 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_7                                                   0                                             0
348677 348677 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   grade_8                                                   0                                             0
348679 348679 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   kindergarten                                                   0                                             0
348681 348681 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   post_graduate                                                   0                                             0
348682 348682 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   pre_kindergarten                                                   0                                             0
348683 348683 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   readiness                                                   0                                             0
348684 348684 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_1                                                   0                                             0
348685 348685 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_10                                                   0                                             0
348686 348686 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_11                                                   0                                             0
348687 348687 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_12                                                   0                                             0
348688 348688 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_2                                                   0                                             0
348689 348689 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_3                                                   0                                             0
348690 348690 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_4                                                   0                                             0
348691 348691 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_5                                                   0                                             0
348695 348695 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   grade_9                                                   0                                             0
348696 348696 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   kindergarten                                                   0                                             0
348698 348698 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   post_graduate                                                   0                                             0
348699 348699 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   pre_kindergarten                                                   0                                             0
348700 348700 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   readiness                                                   0                                             0
348702 348702 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_10                                                   0                                             0
348703 348703 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_11                                                   0                                             0
348704 348704 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_12                                                   0                                             0
348708 348708 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_5                                                   0                                             0
348709 348709 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_6                                                   0                                             0
348710 348710 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_7                                                   0                                             0
348711 348711 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_8                                                   0                                             0
348712 348712 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   grade_9                                                   0                                             0
348713 348713 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   kindergarten                                                   0                                             0
348715 348715 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   post_graduate                                                   0                                             0
348716 348716 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   pre_kindergarten                                                   0                                             0
348717 348717 NH     school 3302990 174   Fall Mountain Regional 330299000112 22960 Acworth Elementary School Public School Regular School No Elementary 01 04 2021   readiness                                                   0                                             0
348718 348718 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
348719 348719 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_10                                                   0                                             0
348720 348720 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_11                                                   0                                             0
348721 348721 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_12                                                   0                                             0
348722 348722 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_2                                                   0                                             0
348726 348726 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_6                                                   0                                             0
348727 348727 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_7                                                   0                                             0
348728 348728 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_8                                                   0                                             0
348729 348729 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   grade_9                                                   0                                             0
348730 348730 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   kindergarten                                                   0                                             0
348732 348732 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   post_graduate                                                   0                                             0
348733 348733 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   pre_kindergarten                                                   0                                             0
348734 348734 NH     school 3303510 225   Hampton 330351000470 20795 Adeline C. Marston School Public School Regular School No Elementary 03 05 2021   readiness                                                   0                                             0
348736 348736 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_10                                                   0                                             0
348737 348737 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_11                                                   0                                             0
348738 348738 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_12                                                   0                                             0
348742 348742 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_5                                                   0                                             0
348743 348743 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_6                                                   0                                             0
348744 348744 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
348745 348745 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_8                                                   0                                             0
348746 348746 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   grade_9                                                   0                                             0
348749 348749 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   post_graduate                                                   0                                             0
348750 348750 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   pre_kindergarten                                                   0                                             0
348751 348751 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School Public School Regular School No Elementary KG 04 2021   readiness                                                   0                                             0
348753 348753 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_10                                                   0                                             0
348754 348754 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_11                                                   0                                             0
348755 348755 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_12                                                   0                                             0
348759 348759 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_5                                                   0                                             0
348760 348760 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_6                                                   0                                             0
348761 348761 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_7                                                   0                                             0
348762 348762 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_8                                                   0                                             0
348763 348763 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   grade_9                                                   0                                             0
348766 348766 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   post_graduate                                                   0                                             0
348768 348768 NH     school 3302990 174   Fall Mountain Regional 330299000113 22965 Alstead Primary School Public School Regular School No Elementary PK 04 2021   readiness                                                   0                                             0
348770 348770 NH     school 3301440 15   Alton 330144000003 22480 Alton Central School (Elem) Public School Regular School No Elementary PK 08 2021   grade_10                                                   0                                             0
348771 348771 NH     school 3301440 15   Alton 330144000003 22480 Alton Central School (Elem) Public School Regular School No Elementary PK 08 2021   grade_11                                                   0                                             0
348772 348772 NH     school 3301440 15   Alton 330144000003 22480 Alton Central School (Elem) Public School Regular School No Elementary PK 08 2021   grade_12                                                   0                                             0
348780 348780 NH     school 3301440 15   Alton 330144000003 22480 Alton Central School (Elem) Public School Regular School No Elementary PK 08 2021   grade_9                                                   0                                             0
348783 348783 NH     school 3301440 15   Alton 330144000003 22480 Alton Central School (Elem) Public School Regular School No Elementary PK 08 2021   post_graduate                                                   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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