enrollments

Data source: Big Local News · About: Big Local

45,036 rows where state = "NJ" and year = 2020 sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 45,000 ✖
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
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
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
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
2475482 2475482 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 07 2020   pk_12_total 1.0 50.0 121.0 0.0   0.0 0.0       0.0             0   0.0     80.8     172.0 1 50 121 0   0 0       0                       172
2477984 2477984 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 07 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480486 2480486 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 07 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482988 2482988 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 07 2020   kindergarten_full_day                                                   0.0                                             0
2485490 2485490 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 07 2020   kindergarten_half_day                                                   0.0                                             0
2487992 2487992 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 07 2020   ungraded                                                   0.0                                             0
2490494 2490494 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 07 2020   grade_1                                                   0.0                                             0
2492996 2492996 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 07 2020   grade_2                                                   0.0                                             0
2495498 2495498 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 07 2020   grade_3                                                   0.0                                             0
2498000 2498000 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 07 2020   grade_4                                                   0.0                                             0
2500502 2500502 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 07 2020   grade_5                                                   0.0                                             0
2503004 2503004 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 07 2020   grade_6                                                   101.0                                             101
2505506 2505506 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 07 2020   grade_7                                                   71.0                                             71
2508008 2508008 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 07 2020   grade_8                                                   0.0                                             0
2510510 2510510 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 07 2020   grade_9                                                   0.0                                             0
2513012 2513012 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 07 2020   grade_10                                                   0.0                                             0
2515514 2515514 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 07 2020   grade_11                                                   0.0                                             0
2518016 2518016 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 07 2020   grade_12                                                   0.0                                             0
2474107 2474107 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   pk_12_total 240.0 2.0 21.0 0.0   10.0 0.0       2.0             0   0.0     5.4     275.0 240 2 21 0   10 0       2                       275
2474108 2474108 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   pk_12_total 173.0 3.0 12.0 0.0   8.0 0.0       7.0             0   0.0     6.9     203.0 173 3 12 0   8 0       7                       203
2476609 2476609 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476610 2476610 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2479111 2479111 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479112 2479112 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   37.0                                             37
2481613 2481613 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   kindergarten_full_day                                                   0.0                                             0
2481614 2481614 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   kindergarten_full_day                                                   37.0                                             37
2484115 2484115 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   kindergarten_half_day                                                   0.0                                             0
2484116 2484116 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   kindergarten_half_day                                                   0.0                                             0
2486617 2486617 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   ungraded                                                   0.0                                             0
2486618 2486618 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   ungraded                                                   0.0                                             0
2489119 2489119 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_1                                                   0.0                                             0
2489120 2489120 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_1                                                   35.0                                             35
2491621 2491621 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_2                                                   0.0                                             0
2491622 2491622 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_2                                                   49.0                                             49
2494123 2494123 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_3                                                   0.0                                             0
2494124 2494124 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_3                                                   45.0                                             45
2496625 2496625 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_4                                                   58.0                                             58
2496626 2496626 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2499127 2499127 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_5                                                   53.0                                             53
2499128 2499128 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2501629 2501629 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_6                                                   57.0                                             57
2501630 2501630 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_6                                                   0.0                                             0
2504131 2504131 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_7                                                   60.0                                             60
2504132 2504132 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_7                                                   0.0                                             0
2506633 2506633 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_8                                                   47.0                                             47
2506634 2506634 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_8                                                   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]);