enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
348668 348668 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_10                                                   50                                             50
348669 348669 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_11                                                   67                                             67
348670 348670 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_12                                                   42                                             42
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
348678 348678 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_9                                                   63                                             63
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
348680 348680 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   pk_12_total                                                   222                                             222
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
348692 348692 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_6                                                   100                                             100
348693 348693 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_7                                                   109                                             109
348694 348694 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_8                                                   110                                             110
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
348697 348697 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   pk_12_total                                                   319                                             319
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
260541 260541 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten                                                   0.0                                             0
260542 260542 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   pre_kindergarten                                                   0.0                                             0
261037 261037 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   kindergarten                                                   37.0                                             37
261038 261038 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   kindergarten                                                   0.0                                             0
261533 261533 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   readiness                                                   0.0                                             0
261534 261534 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   readiness                                                   0.0                                             0
262029 262029 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_1                                                   28.0                                             28
262030 262030 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
262525 262525 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_2                                                   33.0                                             33
262526 262526 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_2                                                   0.0                                             0
263021 263021 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_3                                                   46.0                                             46
263022 263022 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_3                                                   0.0                                             0
263517 263517 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_4                                                   40.0                                             40
263518 263518 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
264013 264013 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_5                                                   0.0                                             0
264014 264014 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_5                                                   41.0                                             41
264509 264509 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_6                                                   0.0                                             0
264510 264510 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_6                                                   37.0                                             37
265005 265005 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_7                                                   0.0                                             0
265006 265006 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_7                                                   47.0                                             47
265501 265501 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_8                                                   0.0                                             0
265502 265502 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_8                                                   43.0                                             43
265997 265997 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_9                                                   0.0                                             0
265998 265998 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_9                                                   0.0                                             0
266493 266493 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_10                                                   0.0                                             0
266494 266494 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_10                                                   0.0                                             0
266989 266989 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_11                                                   0.0                                             0
266990 266990 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_11                                                   0.0                                             0
267485 267485 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   grade_12                                                   0.0                                             0
267486 267486 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   grade_12                                                   0.0                                             0
267981 267981 NH     school 3301380 9   Allenstown 330138000001 22580 Allenstown Elementary School   Regular School No Elementary KG 04 2020   post_graduate                                                   0.0                                             0
267982 267982 NH     school 3301380 9   Allenstown 330138000002 22575 Armand R. Dupont School   Regular School No Middle 05 08 2020   post_graduate                                                   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]);