enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
2400380 2400380 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_7                                                   0.0                                             0
2402885 2402885 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_8                                                   0.0                                             0
2405390 2405390 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_9                                                   24.5                                             24
2407895 2407895 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_10                                                   48.0                                             48
2410400 2410400 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_11                                                   42.5                                             42
2412905 2412905 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_12                                                   41.5                                             41
2475402 2475402 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   pk_12_total 4.0 98.5 72.5 0.0   0.0 0.0       5.0             2.8   0.0     81.69999999999999     180.0 4 98 72 0   0 0       5                       180
2477904 2477904 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480406 2480406 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482908 2482908 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2485410 2485410 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2487912 2487912 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   ungraded                                                   0.0                                             0
2490414 2490414 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_1                                                   0.0                                             0
2492916 2492916 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_2                                                   0.0                                             0
2495418 2495418 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_3                                                   0.0                                             0
2497920 2497920 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_4                                                   0.0                                             0
2500422 2500422 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_5                                                   0.0                                             0
2502924 2502924 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_6                                                   0.0                                             0
2505426 2505426 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
2507928 2507928 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_8                                                   0.0                                             0
2510430 2510430 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_9                                                   46.0                                             46
2512932 2512932 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_10                                                   45.5                                             45
2515434 2515434 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_11                                                   41.5                                             41
2517936 2517936 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_12                                                   47.0                                             47
2370332 2370332 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   pk_12_total 1.0 24.0 458.0 0.0   1.0 2.0       0.0             14.2   0.0     75.5     486.0 1 24 458 0   1 2       0                       486
2372837 2372837 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375342 2375342 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377847 2377847 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   kindergarten_full_day                                                   0.0                                             0
2380352 2380352 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   kindergarten_half_day                                                   0.0                                             0
2382857 2382857 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   ungraded                                                   0.0                                             0
2385362 2385362 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_1                                                   0.0                                             0
2387867 2387867 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_2                                                   0.0                                             0
2390372 2390372 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_3                                                   0.0                                             0
2392877 2392877 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_4                                                   0.0                                             0
2395382 2395382 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_5                                                   0.0                                             0
2397887 2397887 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_6                                                   0.0                                             0
2400392 2400392 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_7                                                   36.0                                             36
2402897 2402897 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_8                                                   67.0                                             67
2405402 2405402 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_9                                                   88.0                                             88
2407907 2407907 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_10                                                   104.0                                             104
2410412 2410412 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_11                                                   89.0                                             89
2412917 2412917 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2021   grade_12                                                   102.0                                             102
2475414 2475414 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   pk_12_total 4.0 24.0 517.0 0.0   1.0 2.0       1.0             14.6   0.0     66.3     549.0 4 24 517 0   1 2       1                       549
2477916 2477916 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480418 2480418 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482920 2482920 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   kindergarten_full_day                                                   0.0                                             0
2485422 2485422 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   kindergarten_half_day                                                   0.0                                             0
2487924 2487924 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   ungraded                                                   0.0                                             0
2490426 2490426 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_1                                                   0.0                                             0
2492928 2492928 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_2                                                   0.0                                             0
2495430 2495430 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_3                                                   0.0                                             0
2497932 2497932 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_4                                                   0.0                                             0
2500434 2500434 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_5                                                   0.0                                             0
2502936 2502936 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_6                                                   0.0                                             0
2505438 2505438 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_7                                                   61.0                                             61
2507940 2507940 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_8                                                   86.0                                             86
2510442 2510442 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_9                                                   110.0                                             110
2512944 2512944 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_10                                                   93.0                                             93
2515446 2515446 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_11                                                   103.0                                             103
2517948 2517948 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_12                                                   96.0                                             96
2370362 2370362 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   pk_12_total 3.0 161.0 19.0 0.0   0.0 0.0       0.0             0.0   2.7     35.5     183.0 3 161 19 0   0 0       0                       183
2372867 2372867 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375372 2375372 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377877 2377877 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   kindergarten_full_day                                                   1.0                                             1
2380382 2380382 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   kindergarten_half_day                                                   0.0                                             0
2382887 2382887 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   ungraded                                                   0.0                                             0
2385392 2385392 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_1                                                   51.0                                             51
2387897 2387897 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_2                                                   45.0                                             45
2390402 2390402 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_3                                                   61.0                                             61
2392907 2392907 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_4                                                   0.0                                             0
2395412 2395412 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_5                                                   0.0                                             0
2397917 2397917 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_6                                                   25.0                                             25
2400422 2400422 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_7                                                   0.0                                             0
2402927 2402927 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_8                                                   0.0                                             0
2405432 2405432 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_9                                                   0.0                                             0
2407937 2407937 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_10                                                   0.0                                             0
2410442 2410442 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_11                                                   0.0                                             0
2412947 2412947 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 07 2021   grade_12                                                   0.0                                             0
2475445 2475445 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   pk_12_total 5.0 272.0 38.0 0.0   0.0 0.0       0.0             0   2.5     46.0     315.0 5 272 38 0   0 0       0                       315
2477947 2477947 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480449 2480449 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482951 2482951 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   kindergarten_full_day                                                   60.0                                             60
2485453 2485453 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   kindergarten_half_day                                                   0.0                                             0
2487955 2487955 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   ungraded                                                   0.0                                             0
2490457 2490457 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_1                                                   49.0                                             49
2492959 2492959 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_2                                                   67.0                                             67
2495461 2495461 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_3                                                   47.0                                             47
2497963 2497963 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_4                                                   0.0                                             0
2500465 2500465 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_5                                                   29.0                                             29
2502967 2502967 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_6                                                   63.0                                             63
2505469 2505469 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_7                                                   0.0                                             0
2507971 2507971 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_8                                                   0.0                                             0
2510473 2510473 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_9                                                   0.0                                             0
2512975 2512975 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_10                                                   0.0                                             0
2515477 2515477 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_11                                                   0.0                                             0
2517979 2517979 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_12                                                   0.0                                             0
2370399 2370399 NJ Charters 80 school 3400794 7895   Achievers Early College Prep Charter School 340079403457 920 Achievers Early College Prep Charter School   Regular School Yes Middle 06 08 2021   pk_12_total 8.0 82.0 172.0 1.0   0.0 0.0       1.0             0.0   0.0     86.8     264.0 8 82 172 1   0 0       1                       264
2372904 2372904 NJ Charters 80 school 3400794 7895   Achievers Early College Prep Charter School 340079403457 920 Achievers Early College Prep Charter School   Regular School Yes Middle 06 08 2021   pre_kindergarten_full_day                                                   0.0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);