enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 45,090 ✖
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
2367902 2367902 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   pk_12_total 194.0 57.0 88.0 0.0   19.0 0.0       19.0             5.0   0.3     47.7     377.0 194 57 88 0   19 0       19                       377
2367903 2367903 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   pk_12_total 253.0 76.0 120.0 0.0   38.0 0.0       23.0             11.4   0.2     45.9     510.0 253 76 120 0   38 0       23                       510
2370407 2370407 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370408 2370408 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372912 2372912 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2372913 2372913 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   pre_kindergarten_half_day                                                   48.0                                             48
2375417 2375417 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   kindergarten_full_day                                                   0.0                                             0
2375418 2375418 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   kindergarten_full_day                                                   83.0                                             83
2377922 2377922 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   kindergarten_half_day                                                   0.0                                             0
2377923 2377923 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   kindergarten_half_day                                                   0.0                                             0
2380427 2380427 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   ungraded                                                   11.0                                             11
2380428 2380428 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   ungraded                                                   14.0                                             14
2382932 2382932 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_1                                                   0.0                                             0
2382933 2382933 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_1                                                   94.0                                             94
2385437 2385437 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_2                                                   0.0                                             0
2385438 2385438 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_2                                                   76.0                                             76
2387942 2387942 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_3                                                   0.0                                             0
2387943 2387943 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_3                                                   107.0                                             107
2390447 2390447 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_4                                                   0.0                                             0
2390448 2390448 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_4                                                   88.0                                             88
2392952 2392952 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_5                                                   84.0                                             84
2392953 2392953 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_5                                                   0.0                                             0
2395457 2395457 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_6                                                   94.0                                             94
2395458 2395458 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_6                                                   0.0                                             0
2397962 2397962 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_7                                                   94.0                                             94
2397963 2397963 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2400467 2400467 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_8                                                   94.0                                             94
2400468 2400468 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_8                                                   0.0                                             0
2402972 2402972 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_9                                                   0.0                                             0
2402973 2402973 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_9                                                   0.0                                             0
2405477 2405477 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_10                                                   0.0                                             0
2405478 2405478 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_10                                                   0.0                                             0
2407982 2407982 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_11                                                   0.0                                             0
2407983 2407983 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_11                                                   0.0                                             0
2410487 2410487 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2021   grade_12                                                   0.0                                             0
2410488 2410488 NJ Atlantic 1 school 3400660 10   Absecon Public Schools District 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2021   grade_12                                                   0.0                                             0
2369359 2369359 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   pk_12_total 10.0 182.0 177.0 0.0   0.0 0.0       1.0             13.2   1.9     65.9     370.0 10 182 177 0   0 0       1                       370
2369360 2369360 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   pk_12_total 13.0 162.0 122.0 0.0   0.0 0.0       4.0             5.6   3.7     63.1     301.0 13 162 122 0   0 0       4                       301
2369361 2369361 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   pk_12_total 12.0 340.0 324.5 0.0   1.0 0.0       1.0             12.2   2.7     54.6     678.5 12 340 324 0   1 0       1                       678
2369362 2369362 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   pk_12_total 14.0 126.0 107.0 0.0   0.0 0.0       0.0             7.3   3.6     47.4     247.0 14 126 107 0   0 0       0                       247
2371864 2371864 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371865 2371865 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371866 2371866 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371867 2371867 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   pre_kindergarten_full_day                                                   0.0                                             0
2374369 2374369 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   pre_kindergarten_half_day                                                   0.0                                             0
2374370 2374370 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   pre_kindergarten_half_day                                                   52.0                                             52
2374371 2374371 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2374372 2374372 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   pre_kindergarten_half_day                                                   50.0                                             50
2376874 2376874 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   kindergarten_full_day                                                   0.0                                             0
2376875 2376875 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   kindergarten_full_day                                                   55.0                                             55
2376876 2376876 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   kindergarten_full_day                                                   0.0                                             0
2376877 2376877 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   kindergarten_full_day                                                   44.0                                             44
2379379 2379379 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   kindergarten_half_day                                                   0.0                                             0
2379380 2379380 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   kindergarten_half_day                                                   0.0                                             0
2379381 2379381 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   kindergarten_half_day                                                   0.0                                             0
2379382 2379382 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   kindergarten_half_day                                                   0.0                                             0
2381884 2381884 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   ungraded                                                   36.0                                             36
2381885 2381885 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   ungraded                                                   28.0                                             28
2381886 2381886 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   ungraded                                                   48.5                                             48
2381887 2381887 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   ungraded                                                   1.0                                             1
2384389 2384389 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_1                                                   0.0                                             0
2384390 2384390 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_1                                                   49.0                                             49
2384391 2384391 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_1                                                   0.0                                             0
2384392 2384392 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_1                                                   45.0                                             45
2386894 2386894 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_2                                                   0.0                                             0
2386895 2386895 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_2                                                   64.0                                             64
2386896 2386896 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_2                                                   0.0                                             0
2386897 2386897 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_2                                                   56.0                                             56
2389399 2389399 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_3                                                   0.0                                             0
2389400 2389400 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_3                                                   53.0                                             53
2389401 2389401 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_3                                                   0.0                                             0
2389402 2389402 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_3                                                   51.0                                             51
2391904 2391904 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_4                                                   117.0                                             117
2391905 2391905 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_4                                                   0.0                                             0
2391906 2391906 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_4                                                   0.0                                             0
2391907 2391907 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_4                                                   0.0                                             0
2394409 2394409 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_5                                                   100.0                                             100
2394410 2394410 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_5                                                   0.0                                             0
2394411 2394411 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_5                                                   0.0                                             0
2394412 2394412 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_5                                                   0.0                                             0
2396914 2396914 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_6                                                   117.0                                             117
2396915 2396915 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_6                                                   0.0                                             0
2396916 2396916 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_6                                                   0.0                                             0
2396917 2396917 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_6                                                   0.0                                             0
2399419 2399419 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_7                                                   0.0                                             0
2399420 2399420 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2399421 2399421 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_7                                                   96.0                                             96
2399422 2399422 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2401924 2401924 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_8                                                   0.0                                             0
2401925 2401925 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_8                                                   0.0                                             0
2401926 2401926 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_8                                                   90.0                                             90
2401927 2401927 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_8                                                   0.0                                             0
2404429 2404429 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_9                                                   0.0                                             0
2404430 2404430 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2404431 2404431 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_9                                                   115.0                                             115
2404432 2404432 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2406934 2406934 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003742 70 Dr. Martin Luther King Upper Elementary School   Regular School No Middle 04 06 2021   grade_10                                                   0.0                                             0
2406935 2406935 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 03 2021   grade_10                                                   0.0                                             0
2406936 2406936 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_10                                                   123.0                                             123
2406937 2406937 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 03 2021   grade_10                                                   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]);