enrollments

Data source: Big Local News · About: Big Local

90,126 rows where state = "NJ" sorted by district_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
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
2514666 2514666 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2020   grade_11                                                   0.0                                             0
2517163 2517163 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2020   grade_12                                                   312.5                                             312
2517164 2517164 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2020   grade_12                                                   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
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
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
2517168 2517168 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2020   grade_12                                                   0.0                                             0
2370185 2370185 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   pk_12_total 15.0 27.0 20.0 0.0   4.0 0.0       2.0             0.0   0.0     22.1     68.0 15 27 20 0   4 0       2                       68
2370186 2370186 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   pk_12_total 56.0 41.0 30.0 0.0   21.0 1.0       1.0             0.0   0.7     8.0     150.0 56 41 30 0   21 1       1                       150
2372690 2372690 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372691 2372691 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375195 2375195 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375196 2375196 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377700 2377700 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   kindergarten_full_day                                                   0.0                                             0
2377701 2377701 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   kindergarten_full_day                                                   0.0                                             0
2380205 2380205 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   kindergarten_half_day                                                   0.0                                             0
2380206 2380206 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   kindergarten_half_day                                                   0.0                                             0
2382710 2382710 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   ungraded                                                   56.0                                             56
2382711 2382711 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   ungraded                                                   128.0                                             128
2385215 2385215 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_1                                                   2.0                                             2
2385216 2385216 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_1                                                   0.0                                             0
2387720 2387720 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_2                                                   2.0                                             2
2387721 2387721 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_2                                                   0.0                                             0
2390225 2390225 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_3                                                   1.0                                             1
2390226 2390226 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_3                                                   0.0                                             0
2392730 2392730 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_4                                                   4.0                                             4
2392731 2392731 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_4                                                   0.0                                             0
2395235 2395235 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_5                                                   1.0                                             1
2395236 2395236 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_5                                                   0.0                                             0
2397740 2397740 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_6                                                   2.0                                             2
2397741 2397741 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_6                                                   0.0                                             0
2400245 2400245 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_7                                                   0.0                                             0
2400246 2400246 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_7                                                   0.0                                             0
2402750 2402750 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_8                                                   0.0                                             0
2402751 2402751 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_8                                                   3.0                                             3
2405255 2405255 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_9                                                   0.0                                             0
2405256 2405256 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_9                                                   0.0                                             0
2407760 2407760 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_10                                                   0.0                                             0
2407761 2407761 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_10                                                   5.0                                             5
2410265 2410265 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_11                                                   0.0                                             0
2410266 2410266 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_11                                                   3.0                                             3
2412770 2412770 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_12                                                   0.0                                             0
2412771 2412771 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_12                                                   11.0                                             11
2475267 2475267 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   pk_12_total 14.0 23.0 15.0 0.0   3.0 0.0       1.0             0   0.0     25.0     56.0 14 23 15 0   3 0       1                       56
2475268 2475268 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   pk_12_total 62.0 47.0 32.0 0.0   22.0 1.0       1.0             0   1.8     9.7     165.0 62 47 32 0   22 1       1                       165
2477769 2477769 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477770 2477770 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480271 2480271 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480272 2480272 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482773 2482773 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   kindergarten_full_day                                                   0.0                                             0
2482774 2482774 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   kindergarten_full_day                                                   0.0                                             0
2485275 2485275 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   kindergarten_half_day                                                   0.0                                             0
2485276 2485276 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2487777 2487777 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   ungraded                                                   50.0                                             50
2487778 2487778 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   ungraded                                                   152.0                                             152
2490279 2490279 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_1                                                   1.0                                             1
2490280 2490280 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_1                                                   0.0                                             0
2492781 2492781 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_2                                                   0.0                                             0
2492782 2492782 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_2                                                   0.0                                             0
2495283 2495283 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_3                                                   4.0                                             4
2495284 2495284 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_3                                                   0.0                                             0
2497785 2497785 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_4                                                   0.0                                             0
2497786 2497786 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_4                                                   0.0                                             0
2500287 2500287 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_5                                                   0.0                                             0
2500288 2500288 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_5                                                   0.0                                             0
2502789 2502789 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_6                                                   1.0                                             1
2502790 2502790 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_6                                                   0.0                                             0
2505291 2505291 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_7                                                   0.0                                             0
2505292 2505292 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_7                                                   1.0                                             1
2507793 2507793 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_8                                                   0.0                                             0
2507794 2507794 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_8                                                   0.0                                             0
2510295 2510295 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_9                                                   0.0                                             0
2510296 2510296 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_9                                                   2.0                                             2
2512797 2512797 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_10                                                   0.0                                             0
2512798 2512798 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_10                                                   2.0                                             2
2515299 2515299 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_11                                                   0.0                                             0
2515300 2515300 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_11                                                   1.0                                             1
2517801 2517801 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_12                                                   0.0                                             0
2517802 2517802 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_12                                                   7.0                                             7
2367916 2367916 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   pk_12_total 43.0 28.0 38.0 1.0   4.0 1.0       0.0             0.0   0.0     47.8     115.0 43 28 38 1   4 1       0                       115
2367917 2367917 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   pk_12_total 52.0 54.0 70.0 0.0   7.0 4.0       4.0             0.5   1.6     44.0     191.0 52 54 70 0   7 4       4                       191
2370421 2370421 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370422 2370422 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372926 2372926 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2372927 2372927 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   4.0                                             4
2375431 2375431 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   kindergarten_full_day                                                   0.0                                             0
2375432 2375432 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   kindergarten_full_day                                                   0.0                                             0
2377936 2377936 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2377937 2377937 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380441 2380441 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   ungraded                                                   93.0                                             93
2380442 2380442 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   ungraded                                                   151.0                                             151
2382946 2382946 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   grade_1                                                   0.0                                             0
2382947 2382947 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   grade_1                                                   0.0                                             0
2385451 2385451 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   grade_2                                                   0.0                                             0
2385452 2385452 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   grade_2                                                   8.0                                             8
2387956 2387956 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   grade_3                                                   0.0                                             0
2387957 2387957 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   grade_3                                                   4.0                                             4
2390461 2390461 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   grade_4                                                   0.0                                             0
2390462 2390462 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   grade_4                                                   3.0                                             3

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]);