enrollments

Data source: Big Local News · About: Big Local

90,126 rows where state = "NJ" sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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
2394598 2394598 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_5                                                   289.0                                             289
2397103 2397103 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_6                                                   0.0                                             0
2399608 2399608 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_7                                                   0.0                                             0
2402113 2402113 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_8                                                   0.0                                             0
2404618 2404618 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_9                                                   0.0                                             0
2407123 2407123 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_10                                                   0.0                                             0
2409628 2409628 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_11                                                   0.0                                             0
2412133 2412133 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_12                                                   0.0                                             0
2474631 2474631 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   pk_12_total 480.0 4.0 45.0 0.0   80.0 0.0       50.0             1.1   0.0     1.9000000000000001     659.0 480 4 45 0   80 0       50                       659
2477133 2477133 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2479635 2479635 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482137 2482137 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   kindergarten_full_day                                                   0.0                                             0
2484639 2484639 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   kindergarten_half_day                                                   0.0                                             0
2487141 2487141 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   ungraded                                                   15.0                                             15
2489643 2489643 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_1                                                   0.0                                             0
2492145 2492145 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_2                                                   0.0                                             0
2494647 2494647 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_3                                                   0.0                                             0
2497149 2497149 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_4                                                   291.0                                             291
2499651 2499651 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_5                                                   353.0                                             353
2502153 2502153 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_6                                                   0.0                                             0
2504655 2504655 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_7                                                   0.0                                             0
2507157 2507157 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_8                                                   0.0                                             0
2509659 2509659 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_9                                                   0.0                                             0
2512161 2512161 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_10                                                   0.0                                             0
2514663 2514663 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_11                                                   0.0                                             0
2517165 2517165 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_12                                                   0.0                                             0
2369551 2369551 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   pk_12_total 195.0 2.0 23.0 0.0   38.0 0.0       26.0             1.1   0.0     0.7     284.0 195 2 23 0   38 0       26                       284
2372056 2372056 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   pre_kindergarten_full_day                                                   45.0                                             45
2374561 2374561 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377066 2377066 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   kindergarten_full_day                                                   3.0                                             3
2379571 2379571 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   kindergarten_half_day                                                   45.0                                             45
2382076 2382076 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   ungraded                                                   26.0                                             26
2384581 2384581 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_1                                                   52.0                                             52
2387086 2387086 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_2                                                   59.0                                             59
2389591 2389591 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_3                                                   54.0                                             54
2392096 2392096 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_4                                                   0.0                                             0
2394601 2394601 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_5                                                   0.0                                             0
2397106 2397106 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_6                                                   0.0                                             0
2399611 2399611 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2402116 2402116 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_8                                                   0.0                                             0
2404621 2404621 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2407126 2407126 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_10                                                   0.0                                             0
2409631 2409631 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_11                                                   0.0                                             0
2412136 2412136 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_12                                                   0.0                                             0
2474632 2474632 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   pk_12_total 200.0 2.0 26.0 0.0   30.0 0.0       24.0             .4   0.0     1.1     282.0 200 2 26 0   30 0       24                       282
2477134 2477134 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   27.0                                             27
2479636 2479636 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   1.0                                             1
2482138 2482138 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   kindergarten_full_day                                                   24.0                                             24
2484640 2484640 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   kindergarten_half_day                                                   28.0                                             28
2487142 2487142 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   ungraded                                                   28.0                                             28
2489644 2489644 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_1                                                   59.0                                             59
2492146 2492146 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_2                                                   54.0                                             54
2494648 2494648 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_3                                                   61.0                                             61
2497150 2497150 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2499652 2499652 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2502154 2502154 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_6                                                   0.0                                             0
2504656 2504656 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_7                                                   0.0                                             0
2507158 2507158 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_8                                                   0.0                                             0
2509660 2509660 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_9                                                   0.0                                             0
2512162 2512162 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_10                                                   0.0                                             0
2514664 2514664 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_11                                                   0.0                                             0
2517166 2517166 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_12                                                   0.0                                             0
2369549 2369549 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   pk_12_total 212.0 2.0 30.0 0.0   51.0 0.0       19.0             1.9   0.0     1.9     314.0 212 2 30 0   51 0       19                       314
2372054 2372054 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   pre_kindergarten_full_day                                                   0.0                                             0
2374559 2374559 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377064 2377064 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   kindergarten_full_day                                                   2.0                                             2
2379569 2379569 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   kindergarten_half_day                                                   50.0                                             50
2382074 2382074 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   ungraded                                                   8.0                                             8
2384579 2384579 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_1                                                   75.0                                             75
2387084 2387084 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_2                                                   78.0                                             78
2389589 2389589 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_3                                                   101.0                                             101
2392094 2392094 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_4                                                   0.0                                             0
2394599 2394599 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_5                                                   0.0                                             0
2397104 2397104 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_6                                                   0.0                                             0
2399609 2399609 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2402114 2402114 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_8                                                   0.0                                             0
2404619 2404619 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2407124 2407124 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_10                                                   0.0                                             0
2409629 2409629 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_11                                                   0.0                                             0
2412134 2412134 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_12                                                   0.0                                             0
2474633 2474633 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   pk_12_total 238.0 3.0 20.0 0.0   51.0 0.0       16.0             0   0.0     2.1     328.0 238 3 20 0   51 0       16                       328
2477135 2477135 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2479637 2479637 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482139 2482139 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   kindergarten_full_day                                                   25.0                                             25
2484641 2484641 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   kindergarten_half_day                                                   35.0                                             35
2487143 2487143 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   ungraded                                                   8.0                                             8
2489645 2489645 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_1                                                   70.0                                             70
2492147 2492147 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_2                                                   104.0                                             104
2494649 2494649 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_3                                                   86.0                                             86
2497151 2497151 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2499653 2499653 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2502155 2502155 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_6                                                   0.0                                             0
2504657 2504657 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_7                                                   0.0                                             0
2507159 2507159 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_8                                                   0.0                                             0
2509661 2509661 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_9                                                   0.0                                             0
2512163 2512163 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_10                                                   0.0                                             0
2514665 2514665 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_11                                                   0.0                                             0
2517167 2517167 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_12                                                   0.0                                             0
2369552 2369552 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2021   pk_12_total 289.0 2.0 18.0 1.0   70.0 1.0       33.0             2.2   0.0     0.7     414.0 289 2 18 1   70 1       33                       414
2372057 2372057 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2021   pre_kindergarten_full_day                                                   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]);