enrollments

Data source: Big Local News · About: Big Local

90,126 rows where state = "NJ" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▲ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2388776 2388776 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003061 581 Park Elementary School   Regular School No Elementary PK 08 2021   grade_3                                                   99.0                                             99
2389220 2389220 NJ Middlesex 23 school 3404110 1170   East Brunswick Township School District 340411003310 120 Memorial Elementary School   Regular School No Elementary PK 05 2021   grade_3                                                   99.0                                             99
2389451 2389451 NJ Monmouth 25 school 3407560 2290   Howell Township Public School District 340756003868 32 Newbury Elementary School   Regular School No Elementary 03 05 2021   grade_3                                                   99.0                                             99
2389594 2389594 NJ Morris 27 school 3403060 820   Chester Township School District 340306004196 30 Bragg Elementary School   Regular School No Elementary 03 05 2021   grade_3                                                   99.0                                             99
2391149 2391149 NJ Cumberland 11 school 3416800 5390   Vineland Public School District 341680005921 260 Dr. William Mennies Elementary School   Regular School No Elementary KG 05 2021   grade_4                                                   99.0                                             99
2391302 2391302 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002342 615 Roberto Clemente Elementary School   Regular School No Elementary PK 06 2021   grade_4                                                   99.0                                             99
2391343 2391343 NJ Essex 13 school 3415330 4900   South Orange-Maplewood School District 341533002428 60 Clinton Elementary School   Regular School No Elementary PK 05 2021   grade_4                                                   99.0                                             99
2391591 2391591 NJ Hunterdon 19 school 3405190 1510   Flemington-Raritan Regional School District 340519006086 35 Francis A. Desmares Elementary School   Regular School No Elementary KG 04 2021   grade_4                                                   99.0                                             99
2391781 2391781 NJ Middlesex 23 school 3410290 3220   Milltown School District 341029003432 50 Joyce Kilmer School   Regular School No Middle 04 08 2021   grade_4                                                   99.0                                             99
2391806 2391806 NJ Middlesex 23 school 3411490 3620   North Brunswick Township School District 341149003484 60 John Adams   Regular School No Elementary PK 04 2021   grade_4                                                   99.0                                             99
2391989 2391989 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939003936 90 Taylor Mills School   Regular School No Not reported M M 2021   grade_4                                                   99.0                                             99
2391990 2391990 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939003930 63 Milford Brook School   Regular School No Not reported M M 2021   grade_4                                                   99.0                                             99
2392212 2392212 NJ Morris 27 school 3413650 4330   Randolph Township School District 341365004490 65 Fernbrook School   Regular School No Elementary KG 05 2021   grade_4                                                   99.0                                             99
2393616 2393616 NJ Cumberland 11 school 3402250 540   Bridgeton City School District 340225001786 30 Broad Street School   Regular School No Elementary KG 08 2021   grade_5                                                   99.0                                             99
2393849 2393849 NJ Essex 13 school 3415330 4900   South Orange-Maplewood School District 341533002442 140 South Mountain Elementary School   Regular School No Elementary PK 05 2021   grade_5                                                   99.0                                             99
2394013 2394013 NJ Hudson 17 school 3407830 2390   Jersey City Public Schools 340783002848 370 Jotham W. Wakeman School   Regular School No Elementary PK 05 2021   grade_5                                                   99.0                                             99
2394024 2394024 NJ Hudson 17 school 3407830 2390   Jersey City Public Schools 340783002814 250 Christa Mcauliffe School   Regular School No Elementary PK 08 2021   grade_5                                                   99.0                                             99
2394221 2394221 NJ Middlesex 23 school 3402820 750   Carteret Public School District 340282003272 50 Columbus Elementary School   Regular School No Elementary PK 05 2021   grade_5                                                   99.0                                             99
2394620 2394620 NJ Morris 27 school 3405250 1530   Florham Park School District 340525004236 20 Brooklake School   Regular School No Elementary 03 05 2021   grade_5                                                   99.0                                             99
2394839 2394839 NJ Ocean 29 school 3416230 5190   Toms River Regional School District 341623004740 95 Silver Bay Elementary School   Regular School No Elementary PK 05 2021   grade_5                                                   99.0                                             99
2395105 2395105 NJ Somerset 35 school 3415090 4820   Somerville Public School District 341509005296 90 Van Derveer Elementary School   Regular School No Elementary PK 05 2021   grade_5                                                   99.0                                             99
2396213 2396213 NJ Essex 13 school 3404230 1210   East Orange School District 340423002064 150 Cicely L. Tyson Community Middle/High School   Regular School No High 06 12 2021   grade_6                                                   99.0                                             99
2397195 2397195 NJ Morris 27 school 3411010 3460   Mountain Lakes Public School District 341101004418 60 Briarcliff Middle School   Regular School No Middle 06 08 2021   grade_6                                                   99.0                                             99
2402257 2402257 NJ Morris 27 school 3417880 5770   Wharton Borough School District 341788004558 30 Alfred C. Mackinnon Middle School   Regular School No Middle 06 08 2021   grade_8                                                   99.0                                             99
2402723 2402723 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005482 35 Joseph Battin School No 4   Regular School No Elementary KG 08 2021   grade_8                                                   99.0                                             99
2407929 2407929 NJ Charters 80 school 3400779 6101   College Achieve Central Charter School 340077903353 992 College Achieve Central Charter School   Regular School Yes Other KG 11 2021   grade_10                                                   99.0                                             99
2473993 2473993 NJ Hudson 17 school 3401260 220   Bayonne City 340126003447 10 Bayonne Alternative High School   Regular School No High 09 12 2020   pk_12_total 22.0 15.0 54.0 0.0   4.0 0.0       4.0             2   1.0     57.6     99.0 22 15 54 0   4 0       4                       99
2478054 2478054 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000198 80 Leeds Avenue Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   99.0                                             99
2479100 2479100 NJ Hudson 17 school 3417310 5580   Weehawken Twp 341731002930 70 Daniel Webster School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   99.0                                             99
2481045 2481045 NJ Camden 7 school 3406030 1780   Gloucester Twp 340603001512 40 Chews Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   99.0                                             99
2481568 2481568 NJ Hudson 17 school 3407830 2390   Jersey City 340783002848 370 Jotham W. Wakeman School   Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   99.0                                             99
2481585 2481585 NJ Hudson 17 school 3414850 4730   Secaucus Town 341485002904 70 Huber Street School   Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   99.0                                             99
2481595 2481595 NJ Hudson 17 school 3416380 5240   Union City 341638002922 120 George Washington Elementary School   Regular School No Elementary PK 06 2020   kindergarten_full_day                                                   99.0                                             99
2482121 2482121 NJ Monmouth 25 school 3416890 5420   Wall Twp 341689004136 70 Central Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   99.0                                             99
2482317 2482317 NJ Ocean 29 school 3407740 2360   Jackson Twp 340774004622 50 Switlik Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   99.0                                             99
2482321 2482321 NJ Ocean 29 school 3408100 2480   Lacey Twp 340810004628 50 Forked River Elementary School   Regular School No Elementary KG 04 2020   kindergarten_full_day                                                   99.0                                             99
2482476 2482476 NJ Passaic 31 school 3412690 4010   Paterson City 341269004902 190 School 15   Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   99.0                                             99
2482743 2482743 NJ Union 39 school 3404590 1320   Elizabeth City 340459002997 310 Dr. Antonia Pantoja School No. 27   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   99.0                                             99
2482833 2482833 NJ Union 39 school 3415900 5090   Summit City 341590002987 150 Primary Center At Jefferson   Regular School No Elementary PK KG 2020   kindergarten_full_day                                                   99.0                                             99
2486345 2486345 NJ Essex 13 school 3411340 3570   Newark City 341134002280 440 Dr William H. Horton Elementary School   Regular School No Elementary PK 08 2020   ungraded                                                   99.0                                             99
2487466 2487466 NJ Passaic 31 school 3412690 4010   Paterson City 341269004876 60 School 2   Regular School No Elementary KG 08 2020   ungraded                                                   99.0                                             99
2488327 2488327 NJ Bergen 3 school 3416620 5330   Upper Saddle River Boro 341662000884 70 Robert D Reynolds Primary School   Regular School No Elementary PK 02 2020   grade_1                                                   99.0                                             99
2488469 2488469 NJ Burlington 5 school 3417730 5720   Westampton 341773001256 20 Holly Hills Elementary School   Regular School No Elementary PK 03 2020   grade_1                                                   99.0                                             99
2488774 2488774 NJ Essex 13 school 3407680 2330   Irvington Township 340768005965 100 Florence Avenue Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   99.0                                             99
2489028 2489028 NJ Hudson 17 school 3407350 2210   Hoboken City 340735002764 70 Wallace Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   99.0                                             99
2490369 2490369 NJ Union 39 school 3417760 5730   Westfield Town 341776005774 120 Jefferson Elementary School   Regular School No Elementary 01 05 2020   grade_1                                                   99.0                                             99
2490873 2490873 NJ Burlington 5 school 3403090 830   Chesterfield Twp 340309001016 25 Chesterfield Township Elementary School   Regular School No Elementary PK 06 2020   grade_2                                                   99.0                                             99
2491203 2491203 NJ Cumberland 11 school 3416800 5390   Vineland City 341680005921 260 Dr. William Mennies Elementary School   Regular School No Elementary KG 05 2020   grade_2                                                   99.0                                             99
2491486 2491486 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002644 25 Bells Elementary School   Regular School No Elementary 01 05 2020   grade_2                                                   99.0                                             99
2491745 2491745 NJ Mercer 21 school 3416290 5210   Trenton Public School District 341629003242 280 Robbins Elementary School   Regular School No Elementary KG 05 2020   grade_2                                                   99.0                                             99
2492058 2492058 NJ Monmouth 25 school 3409750 3040   Matawan-Aberdeen Regional 340975003972 80 Strathmore Elementary School   Regular School No Elementary KG 03 2020   grade_2                                                   99.0                                             99
2492112 2492112 NJ Monmouth 25 school 3414370 4570   Rumson Boro 341437004090 40 Deane-Porter Elementary School   Regular School No Elementary PK 03 2020   grade_2                                                   99.0                                             99
2492159 2492159 NJ Morris 27 school 3403930 1110   Dover Town 340393004220 70 North Dover Elementary School   Regular School No Elementary PK 06 2020   grade_2                                                   99.0                                             99
2492678 2492678 NJ Sussex 37 school 3407440 2240   Hopatcong 340744005370 70 Tulsa Trail Elementary School   Regular School No Elementary 02 03 2020   grade_2                                                   99.0                                             99
2493228 2493228 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000618 30 Memorial Elementary School   Regular School No Elementary PK 04 2020   grade_3                                                   99.0                                             99
2493302 2493302 NJ Bergen 3 school 3414460 4600   Rutherford Boro 341446000812 70 Lincoln School   Regular School No Elementary PK 03 2020   grade_3                                                   99.0                                             99
2494113 2494113 NJ Hudson 17 school 3417310 5580   Weehawken Twp 341731002932 80 Theodore Roosevelt School   Regular School No Elementary 03 06 2020   grade_3                                                   99.0                                             99
2494354 2494354 NJ Middlesex 23 school 3411490 3620   North Brunswick Twp 341149003482 55 Arthur M. Judd   Regular School No Elementary PK 05 2020   grade_3                                                   99.0                                             99
2494661 2494661 NJ Morris 27 school 3403930 1110   Dover Town 340393004220 70 North Dover Elementary School   Regular School No Elementary PK 06 2020   grade_3                                                   99.0                                             99
2495100 2495100 NJ Somerset 35 school 3402280 555   Bridgewater-Raritan Reg 340228005166 30 Adamsville Primary School   Regular School No Elementary PK 04 2020   grade_3                                                   99.0                                             99
2495288 2495288 NJ Union 39 school 3411310 3560   New Providence Boro 341131005594 55 Allen W. Roberts School   Regular School No Elementary PK 06 2020   grade_3                                                   99.0                                             99
2495419 2495419 NJ Charters 80 school 3400715 6013   Bergen Arts And Sciences Charter School 340071502923 900 Bergen Arts And Sciences Charter School   Regular School Yes Other KG 12 2020   grade_3                                                   99.0                                             99
2495753 2495753 NJ Bergen 3 school 3412240 3870   Oradell Boro 341224000678 50 Oradell Public School   Regular School No Elementary PK 06 2020   grade_4                                                   99.0                                             99
2495850 2495850 NJ Bergen 3 school 3418210 5880   Woodcliff Lake Boro 341821000934 30 Dorchester Elementary School   Regular School No Elementary PK 05 2020   grade_4                                                   99.0                                             99
2495867 2495867 NJ Burlington 5 school 3402430 600   Burlington City 340243000976 85 Wilbur Watts Intermediate School   Regular School No Elementary 03 06 2020   grade_4                                                   99.0                                             99
2496495 2496495 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002650 40 Hurffville Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   99.0                                             99
2496615 2496615 NJ Hudson 17 school 3417310 5580   Weehawken Twp 341731002932 80 Theodore Roosevelt School   Regular School No Elementary 03 06 2020   grade_4                                                   99.0                                             99
2497303 2497303 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156004576 30 Clara B. Worth Elementary School   Regular School No Elementary PK 04 2020   grade_4                                                   99.0                                             99
2497324 2497324 NJ Ocean 29 school 3407740 2360   Jackson Twp 340774000725 35 Elms Elementary School   Regular School No Elementary PK 05 2020   grade_4                                                   99.0                                             99
2497756 2497756 NJ Union 39 school 3404590 1320   Elizabeth City 340459002983 315 Juan Pablo Duarte - Jose Julian Marti School No 28   Regular School No Elementary PK 08 2020   grade_4                                                   99.0                                             99
2498080 2498080 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000224 10 Brookside School   Regular School No Middle 04 08 2020   grade_5                                                   99.0                                             99
2498849 2498849 NJ Essex 13 school 3411340 3570   Newark City 341134002270 390 Elliott Street Elementary School   Regular School No Elementary PK 08 2020   grade_5                                                   99.0                                             99
2498891 2498891 NJ Essex 13 school 3412270 3880   City Of Orange Twp 341227002406 100 Lincoln Avenue Elementary School   Regular School No Elementary PK 07 2020   grade_5                                                   99.0                                             99
2499286 2499286 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003310 120 Memorial Elementary School   Regular School No Elementary PK 05 2020   grade_5                                                   99.0                                             99
2499305 2499305 NJ Middlesex 23 school 3404500 1290   Edison Twp 340450003364 150 Washington Elementary School   Regular School No Elementary KG 05 2020   grade_5                                                   99.0                                             99
2499336 2499336 NJ Middlesex 23 school 3410290 3220   Milltown Boro 341029003432 50 Joyce Kilmer School   Regular School No Middle 04 08 2020   grade_5                                                   99.0                                             99
2499514 2499514 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003862 10 Ardena Elementary School   Regular School No Elementary 03 05 2020   grade_5                                                   99.0                                             99
2500992 2500992 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001302 50 Mansion Avenue School   Regular School No Elementary 03 06 2020   grade_6                                                   99.0                                             99
2501332 2501332 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   grade_6                                                   99.0                                             99
2501367 2501367 NJ Essex 13 school 3411340 3570   Newark City 341134002326 570 Mt Vernon Place School   Regular School No Elementary PK 08 2020   grade_6                                                   99.0                                             99
2501483 2501483 NJ Gloucester 15 school 3413080 4140   Pitman Boro 341308000095 75 Pitman Middle School   Regular School No Middle 06 08 2020   grade_6                                                   99.0                                             99
2501626 2501626 NJ Hudson 17 school 3417580 5670   West New York Town 341758002948 90 Public School Number Five   Regular School No Elementary KG 06 2020   grade_6                                                   99.0                                             99
2502456 2502456 NJ Passaic 31 school 3412540 3970   Passaic City 341254003433 301 Passaic Academy For Science And Engineering   Regular School No High 06 12 2020   grade_6                                                   99.0                                             99
2502794 2502794 NJ Union 39 school 3411310 3560   New Providence Boro 341131005594 55 Allen W. Roberts School   Regular School No Elementary PK 06 2020   grade_6                                                   99.0                                             99
2503896 2503896 NJ Essex 13 school 3412270 3880   City Of Orange Twp 341227006117 105 Rosa Parks /Central Community School   Regular School No Elementary PK 07 2020   grade_7                                                   99.0                                             99
2506521 2506521 NJ Hudson 17 school 3401260 220   Bayonne City 340126002710 30 Walter F. Robinson Community School   Regular School No Elementary PK 08 2020   grade_8                                                   99.0                                             99
2508837 2508837 NJ Essex 13 school 3411340 3570   Newark City 341134000791 87 American History High School   Regular School No High 09 12 2020   grade_9                                                   99.0                                             99
2514288 2514288 NJ Middlesex 23 school 3404020 1140   Dunellen Boro 340402003286 40 Dunellen High School   Regular School No High 09 12 2020   grade_11                                                   99.0                                             99
2515793 2515793 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377000742 50 Ridgefield Memorial High School   Regular School No High 09 12 2020   grade_12                                                   99.0                                             99
2516274 2516274 NJ Essex 13 school 3404230 1210   East Orange 340423002064 150 Cicely L. Tyson Community Middle/High School   Regular School No High 06 12 2020   grade_12                                                   99.0                                             99
2518021 2518021 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   grade_12                                                   99.0                                             99
2368065 2368065 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000470 70 Garfield Middle School   Regular School No Middle 06 08 2021   pk_12_total 349.0 97.0 526.0 0.0   11.0 1.0       5.0             4.3   0.3     62.8     989.0 349 97 526 0   11 1       5                       989
2369306 2369306 NJ Middlesex 23 school 3414640 4660   Sayreville School District 341464000553 85 Samsel Upper Elementary School   Regular School No Elementary 04 05 2021   pk_12_total 401.0 143.0 201.0 6.0   173.0 1.0       64.0             2.9   0.2     36.3     989.0 401 143 201 6   173 1       64                       989
2369207 2369207 NJ Middlesex 23 school 3404500 1290   Edison Township School District 340450003366 160 Woodbrook Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 32.0 30.0 34.0 21.0   861.0 0.0       10.0             2.5   1.2     3.4000000000000004     988.0 32 30 34 21   861 0       10                       988
2369448 2369448 NJ Monmouth 25 school 3409420 2930   Manasquan School District 340942003940 50 Manasquan High School   Regular School No High 09 12 2021   pk_12_total 822.5 9.0 136.0 2.0   8.0 2.0       7.0             1.9   0.1     10.9     986.5 822 9 136 2   8 2       7                       986
2369197 2369197 NJ Middlesex 23 school 3404500 1290   Edison Township School District 340450003328 55 John Adams Middle School   Regular School No Middle 06 08 2021   pk_12_total 47.0 62.0 31.0 6.0   823.0 0.0       17.0             0.6   0.6     6.300000000000001     986.0 47 62 31 6   823 0       17                       986
2475022 2475022 NJ Passaic 31 school 3417520 5650   West Milford Twp 341752004996 40 West Milford High School   Regular School No High 09 12 2020   pk_12_total 859.0 12.0 81.0 4.0   18.0 1.0       10.0             .4   0.4     15.5     985.0 859 12 81 4   18 1       10                       985
2369550 2369550 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2021   pk_12_total 748.0 3.0 64.0 0.0   118.0 0.0       51.0             0.4   0.0     1.3     984.0 748 3 64 0   118 0       51                       984
2473434 2473434 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001202 55 Pemberton Township High School   Regular School No High 09 12 2020   pk_12_total 521.0 244.0 175.0 3.0   22.0 3.0       16.0             .7   0.8     50.3     984.0 521 244 175 3   22 3       16                       984
2474083 2474083 NJ Hudson 17 school 3416380 5240   Union City 341638002912 70 Thomas A Edison Elementary School   Regular School No Elementary PK 06 2020   pk_12_total 16.0 14.0 942.0 0.0   12.0 0.0       0.0             42.7   0.3     98.6     984.0 16 14 942 0   12 0       0                       984

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