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
2511976 2511976 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Comm 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2020   grade_10                                                   1.0                                             1
2514478 2514478 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Comm 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2020   grade_11                                                   1.0                                             1
2516980 2516980 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Comm 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2020   grade_12                                                   0.0                                             0
2370383 2370383 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   pk_12_total 4.0 4419.0 606.0 0.0   3.0 2.0       229.0             1.7   1.2     85.7     5263.0 4 4419 606 0   3 2       229                       5263
2372888 2372888 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375393 2375393 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377898 2377898 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   kindergarten_full_day                                                   575.0                                             575
2380403 2380403 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   kindergarten_half_day                                                   0.0                                             0
2382908 2382908 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   ungraded                                                   0.0                                             0
2385413 2385413 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   571.0                                             571
2387918 2387918 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_2                                                   462.0                                             462
2390423 2390423 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_3                                                   465.0                                             465
2392928 2392928 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_4                                                   468.0                                             468
2395433 2395433 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_5                                                   478.0                                             478
2397938 2397938 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_6                                                   471.0                                             471
2400443 2400443 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_7                                                   351.0                                             351
2402948 2402948 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_8                                                   347.0                                             347
2405453 2405453 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_9                                                   327.0                                             327
2407958 2407958 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_10                                                   326.0                                             326
2410463 2410463 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_11                                                   213.0                                             213
2412968 2412968 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2021   grade_12                                                   209.0                                             209
2475466 2475466 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   pk_12_total 12.0 4215.5 385.0 13.0   4.0 8.0       143.0             1.6   1.4     86.6     4780.5 12 4215 385 13   4 8       143                       4780
2477968 2477968 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480470 2480470 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482972 2482972 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   kindergarten_full_day                                                   562.0                                             562
2485474 2485474 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   kindergarten_half_day                                                   0.0                                             0
2487976 2487976 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   ungraded                                                   0.0                                             0
2490478 2490478 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_1                                                   454.0                                             454
2492980 2492980 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_2                                                   451.0                                             451
2495482 2495482 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_3                                                   454.0                                             454
2497984 2497984 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_4                                                   455.0                                             455
2500486 2500486 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_5                                                   447.0                                             447
2502988 2502988 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_6                                                   346.0                                             346
2505490 2505490 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_7                                                   339.0                                             339
2507992 2507992 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_8                                                   347.0                                             347
2510494 2510494 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_9                                                   344.5                                             344
2512996 2512996 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_10                                                   218.0                                             218
2515498 2515498 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_11                                                   204.0                                             204
2518000 2518000 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   grade_12                                                   159.0                                             159
2370404 2370404 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   pk_12_total 18.0 240.0 142.0 0.0   39.0 0.0       0.0             0.0   0.0     63.1     439.0 18 240 142 0   39 0       0                       439
2372909 2372909 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375414 2375414 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377919 2377919 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   kindergarten_full_day                                                   0.0                                             0
2380424 2380424 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2382929 2382929 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   ungraded                                                   0.0                                             0
2385434 2385434 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_1                                                   0.0                                             0
2387939 2387939 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_2                                                   0.0                                             0
2390444 2390444 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_3                                                   0.0                                             0
2392949 2392949 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_4                                                   0.0                                             0
2395454 2395454 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_5                                                   0.0                                             0
2397959 2397959 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_6                                                   0.0                                             0
2400464 2400464 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_7                                                   0.0                                             0
2402969 2402969 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_8                                                   0.0                                             0
2405474 2405474 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_9                                                   116.0                                             116
2407979 2407979 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_10                                                   118.0                                             118
2410484 2410484 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_11                                                   105.0                                             105
2412989 2412989 NJ Charters 80 school 3400073 8060   University Academy Charter High School 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2021   grade_12                                                   100.0                                             100
2475487 2475487 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   pk_12_total 15.0 246.0 132.0 0.0   38.0 0.0       0.0             0   0.0     68.2     431.0 15 246 132 0   38 0       0                       431
2477989 2477989 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480491 2480491 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482993 2482993 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2485495 2485495 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2487997 2487997 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   ungraded                                                   0.0                                             0
2490499 2490499 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_1                                                   0.0                                             0
2493001 2493001 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_2                                                   0.0                                             0
2495503 2495503 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_3                                                   0.0                                             0
2498005 2498005 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_4                                                   0.0                                             0
2500507 2500507 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_5                                                   0.0                                             0
2503009 2503009 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_6                                                   0.0                                             0
2505511 2505511 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
2508013 2508013 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_8                                                   0.0                                             0
2510515 2510515 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_9                                                   118.0                                             118
2513017 2513017 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_10                                                   113.0                                             113
2515519 2515519 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_11                                                   101.0                                             101
2518021 2518021 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_12                                                   99.0                                             99
2370374 2370374 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   pk_12_total 1.0 82.0 167.0 0.0   1.0 0.0       5.0             18.4   0.0     90.6     256.0 1 82 167 0   1 0       5                       256
2372879 2372879 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375384 2375384 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377889 2377889 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   kindergarten_full_day                                                   25.0                                             25
2380394 2380394 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2382899 2382899 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   ungraded                                                   0.0                                             0
2385404 2385404 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   40.0                                             40
2387909 2387909 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_2                                                   40.0                                             40
2390414 2390414 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_3                                                   32.0                                             32
2392919 2392919 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   24.0                                             24
2395424 2395424 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_5                                                   23.0                                             23
2397929 2397929 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_6                                                   24.0                                             24
2400434 2400434 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_7                                                   25.0                                             25
2402939 2402939 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_8                                                   23.0                                             23
2405444 2405444 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2407949 2407949 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_10                                                   0.0                                             0
2410454 2410454 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_11                                                   0.0                                             0
2412959 2412959 NJ Charters 80 school 3400076 6740   Hope Academy Charter School 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_12                                                   0.0                                             0
2475457 2475457 NJ Charters 80 school 3400076 6740   Hope Academy Cs 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 2.0 87.0 157.0 0.0   1.0 0.0       6.0             13.8   0.0     92.5     253.0 2 87 157 0   1 0       6                       253
2477959 2477959 NJ Charters 80 school 3400076 6740   Hope Academy Cs 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480461 2480461 NJ Charters 80 school 3400076 6740   Hope Academy Cs 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482963 2482963 NJ Charters 80 school 3400076 6740   Hope Academy Cs 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2020   kindergarten_full_day                                                   40.0                                             40
2485465 2485465 NJ Charters 80 school 3400076 6740   Hope Academy Cs 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2020   kindergarten_half_day                                                   0.0                                             0
2487967 2487967 NJ Charters 80 school 3400076 6740   Hope Academy Cs 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2020   ungraded                                                   0.0                                             0
2490469 2490469 NJ Charters 80 school 3400076 6740   Hope Academy Cs 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   40.0                                             40

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