enrollments

Data source: Big Local News · About: Big Local

45,090 rows where state = "NJ" and year = 2021 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 44,944 ✖
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
2375224 2375224 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377729 2377729 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   kindergarten_full_day                                                   0.0                                             0
2380234 2380234 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2382739 2382739 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   ungraded                                                   30.5                                             30
2385244 2385244 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_1                                                   0.0                                             0
2387749 2387749 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_2                                                   0.0                                             0
2390254 2390254 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
2392759 2392759 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2395264 2395264 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2397769 2397769 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2400274 2400274 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2402779 2402779 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2405284 2405284 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_9                                                   206.0                                             206
2407789 2407789 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_10                                                   195.5                                             195
2410294 2410294 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_11                                                   145.0                                             145
2412799 2412799 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_12                                                   197.0                                             197
2368253 2368253 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 254.0 2.0 23.0 0.0   12.0 0.0       13.0             1.0   0.0     0.0     304.0 254 2 23 0   12 0       13                       304
2370758 2370758 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2373263 2373263 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375768 2375768 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   45.0                                             45
2378273 2378273 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380778 2380778 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   ungraded                                                   0.0                                             0
2383283 2383283 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_1                                                   64.0                                             64
2385788 2385788 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_2                                                   45.0                                             45
2388293 2388293 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_3                                                   48.0                                             48
2390798 2390798 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_4                                                   60.0                                             60
2393303 2393303 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_5                                                   42.0                                             42
2395808 2395808 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_6                                                   0.0                                             0
2398313 2398313 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2400818 2400818 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_8                                                   0.0                                             0
2403323 2403323 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_9                                                   0.0                                             0
2405828 2405828 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_10                                                   0.0                                             0
2408333 2408333 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_11                                                   0.0                                             0
2410838 2410838 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_12                                                   0.0                                             0
2368060 2368060 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   pk_12_total 64.0 26.0 271.0 1.0   0.0 1.0       2.0             11.0   0.8     54.5     365.0 64 26 271 1   0 1       2                       365
2370565 2370565 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2373070 2373070 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   pre_kindergarten_half_day                                                   36.0                                             36
2375575 2375575 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   53.0                                             53
2378080 2378080 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380585 2380585 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   ungraded                                                   43.0                                             43
2383090 2383090 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_1                                                   57.0                                             57
2385595 2385595 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_2                                                   51.0                                             51
2388100 2388100 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_3                                                   40.0                                             40
2390605 2390605 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_4                                                   42.0                                             42
2393110 2393110 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_5                                                   43.0                                             43
2395615 2395615 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_6                                                   0.0                                             0
2398120 2398120 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2400625 2400625 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_8                                                   0.0                                             0
2403130 2403130 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_9                                                   0.0                                             0
2405635 2405635 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_10                                                   0.0                                             0
2408140 2408140 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_11                                                   0.0                                             0
2410645 2410645 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_12                                                   0.0                                             0
2370152 2370152 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   pk_12_total 70.0 97.0 670.0 0.0   20.0 2.0       1.0             28.4   0.0     76.2     860.0 70 97 670 0   20 2       1                       860
2372657 2372657 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375162 2375162 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377667 2377667 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   kindergarten_full_day                                                   105.0                                             105
2380172 2380172 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2382677 2382677 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   ungraded                                                   50.0                                             50
2385182 2385182 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_1                                                   100.0                                             100
2387687 2387687 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_2                                                   70.0                                             70
2390192 2390192 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_3                                                   82.0                                             82
2392697 2392697 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_4                                                   82.0                                             82
2395202 2395202 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_5                                                   105.0                                             105
2397707 2397707 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_6                                                   91.0                                             91
2400212 2400212 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_7                                                   81.0                                             81
2402717 2402717 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_8                                                   94.0                                             94
2405222 2405222 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_9                                                   0.0                                             0
2407727 2407727 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_10                                                   0.0                                             0
2410232 2410232 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_11                                                   0.0                                             0
2412737 2412737 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   grade_12                                                   0.0                                             0
2367943 2367943 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   pk_12_total 437.0 235.0 258.0 0.0   152.0 3.0       47.0             1.1   1.0     51.0     1132.0 437 235 258 0   152 3       47                       1132
2370448 2370448 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372953 2372953 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375458 2375458 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   kindergarten_full_day                                                   0.0                                             0
2377963 2377963 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380468 2380468 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   ungraded                                                   20.0                                             20
2382973 2382973 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_1                                                   0.0                                             0
2385478 2385478 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_2                                                   0.0                                             0
2387983 2387983 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
2390488 2390488 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2392993 2392993 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2395498 2395498 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2398003 2398003 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400508 2400508 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2403013 2403013 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_9                                                   297.0                                             297
2405518 2405518 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_10                                                   276.0                                             276
2408023 2408023 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_11                                                   263.0                                             263
2410528 2410528 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Regional High School District 340606000122 40 Absegami High School   Regular School No High 09 12 2021   grade_12                                                   276.0                                             276
2370320 2370320 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   pk_12_total 2.0 78.0 73.5 0.0   0.0 0.0       3.0             3.5   0.0     78.60000000000001     156.5 2 78 73 0   0 0       3                       156
2372825 2372825 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375330 2375330 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377835 2377835 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   kindergarten_full_day                                                   0.0                                             0
2380340 2380340 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2382845 2382845 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   ungraded                                                   0.0                                             0
2385350 2385350 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_1                                                   0.0                                             0
2387855 2387855 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_2                                                   0.0                                             0
2390360 2390360 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_3                                                   0.0                                             0
2392865 2392865 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_4                                                   0.0                                             0
2395370 2395370 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_5                                                   0.0                                             0
2397875 2397875 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_6                                                   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]);