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,036 ✖
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
2472988 2472988 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   pk_12_total 195.0 59.0 86.0 0.0   16.0 0.0       24.0             5.5   0.8     48.7     380.0 195 59 86 0   16 0       24                       380
2472989 2472989 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   pk_12_total 284.0 72.0 111.0 0.0   36.0 1.0       23.0             8.5   0.4     47.5     527.0 284 72 111 0   36 1       23                       527
2475490 2475490 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475491 2475491 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477992 2477992 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2477993 2477993 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   62.0                                             62
2480494 2480494 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   kindergarten_full_day                                                   0.0                                             0
2480495 2480495 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   kindergarten_full_day                                                   96.0                                             96
2482996 2482996 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   kindergarten_half_day                                                   0.0                                             0
2482997 2482997 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   kindergarten_half_day                                                   0.0                                             0
2485498 2485498 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   ungraded                                                   13.0                                             13
2485499 2485499 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   ungraded                                                   19.0                                             19
2488000 2488000 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
2488001 2488001 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_1                                                   79.0                                             79
2490502 2490502 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_2                                                   0.0                                             0
2490503 2490503 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_2                                                   104.0                                             104
2493004 2493004 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_3                                                   0.0                                             0
2493005 2493005 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_3                                                   84.0                                             84
2495506 2495506 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
2495507 2495507 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_4                                                   83.0                                             83
2498008 2498008 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_5                                                   90.0                                             90
2498009 2498009 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2500510 2500510 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_6                                                   95.0                                             95
2500511 2500511 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
2503012 2503012 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_7                                                   91.0                                             91
2503013 2503013 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
2505514 2505514 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_8                                                   91.0                                             91
2505515 2505515 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_8                                                   0.0                                             0
2508016 2508016 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_9                                                   0.0                                             0
2508017 2508017 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_9                                                   0.0                                             0
2510518 2510518 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_10                                                   0.0                                             0
2510519 2510519 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_10                                                   0.0                                             0
2513020 2513020 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_11                                                   0.0                                             0
2513021 2513021 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_11                                                   0.0                                             0
2515522 2515522 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_12                                                   0.0                                             0
2515523 2515523 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_12                                                   0.0                                             0
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

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