enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2475518 2475518 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002953 38 Alder Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475519 2475519 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002955 39 Fernwood Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475520 2475520 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000698 45 Dr. Joyanne D. Miller Elementary School   Regular School No Elementary 04 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475521 2475521 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000092 50 H. Russel Swift Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   4.0                                             4
2475522 2475522 NJ Atlantic 1 school 3404860 1410   Estell Manor City 340486000102 50 Estell Manor Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475523 2475523 NJ Atlantic 1 school 3405280 1540   Folsom Boro 340528000104 50 Folsom Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475524 2475524 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000108 15 Arthur Rann Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475525 2475525 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000383 16 Galloway Township Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475526 2475526 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000114 40 Pomona Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475527 2475527 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006028 45 Reeds Road Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475528 2475528 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006088 46 Roland Rogers Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475529 2475529 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006089 48 Smithville Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475530 2475530 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000122 40 Absegami High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475531 2475531 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000124 50 Oakcrest High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475532 2475532 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606003115 60 Cedar Creek High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475533 2475533 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000015 55 George L. Hess Educational Complex   Regular School No Elementary 02 05 2020   pre_kindergarten_full_day                                                   81.0                                             81
2475534 2475534 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000130 60 Joseph C Shaner Memorial Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475535 2475535 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651006029 120 William Davies Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475536 2475536 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000699 30 Hammonton Early Childhood Eductional Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   27.0                                             27
2475537 2475537 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000136 50 Hammonton High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475538 2475538 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000138 55 Warren E. Sooy Jr. Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten_full_day                                                   104.0                                             104
2475539 2475539 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000140 60 Hammonton Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475540 2475540 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000144 20 Belhaven Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475541 2475541 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000150 50 Seaview Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   17.0                                             17
2475542 2475542 NJ Atlantic 1 school 3409360 2910   Mainland Regional 340936000158 50 Mainland Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475543 2475543 NJ Atlantic 1 school 3409690 3020   Margate City 340969000162 10 Eugene A. Tighe Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475544 2475544 NJ Atlantic 1 school 3409690 3020   Margate City 340969000393 25 William H. Ross Iii School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475545 2475545 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000172 20 Mullica Township Primary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475546 2475546 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000174 25 Mullica Township Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475547 2475547 NJ Atlantic 1 school 3411790 3720   Northfield City 341179000215 56 Northfield Community Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475548 2475548 NJ Atlantic 1 school 3411790 3720   Northfield City 341179000217 57 Northfield Community Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475549 2475549 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000192 50 Pleasantville High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475550 2475550 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000219 55 Pleasantville Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475551 2475551 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000194 60 Washington Avenue Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475552 2475552 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000198 80 Leeds Avenue Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475553 2475553 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000200 85 North Main Street Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475554 2475554 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000202 95 South Main Street Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475555 2475555 NJ Atlantic 1 school 3413380 4240   Port Republic City 341338000204 50 Port Republic Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475556 2475556 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000208 50 Dawes Avenue Elementary School   Regular School No Elementary KG 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475557 2475557 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000210 55 Jordan Road Elementary School   Regular School No Middle 04 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475558 2475558 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000533 60 New York Avenue Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475559 2475559 NJ Atlantic 1 school 3416680 5350   Ventnor City 341668000216 40 Ventnor Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475560 2475560 NJ Atlantic 1 school 3416680 5350   Ventnor City 341668000407 45 Ventnor Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475561 2475561 NJ Atlantic 1 school 3417850 5760   Weymouth Twp 341785000220 20 Weymouth Township Elementary School   Regular School No Elementary PK 08 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
2477994 2477994 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000010 10 Atlantic City High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2477995 2477995 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000012 30 Sovereign Avenue School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   73.0                                             73
2477996 2477996 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000016 50 Chelsea Heights School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   49.0                                             49
2477997 2477997 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000018 60 Texas Avenue School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2477998 2477998 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000020 70 New York Avenue School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   44.0                                             44
2477999 2477999 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000022 80 Uptown School Complex   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   59.0                                             59
2478000 2478000 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000026 100 Pennsylvania Ave School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   74.0                                             74
2478001 2478001 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000028 120 Richmond Avenue School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   59.0                                             59
2478002 2478002 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   30.0                                             30
2478003 2478003 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000032 140 Dr Martin Luther King Jr School Complex   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   55.0                                             55
2478004 2478004 NJ Atlantic 1 school 3400960 110   Atlantic City 340096003259 300 Brighton Avenue School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   59.0                                             59
2478005 2478005 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478006 2478006 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478007 2478007 NJ Atlantic 1 school 3400006 125   Atlantic Co Special Serv 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   4.0                                             4
2478008 2478008 NJ Atlantic 1 school 3400006 125   Atlantic Co Special Serv 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478009 2478009 NJ Atlantic 1 school 3402340 570   Brigantine City 340234003479 300 Brigantine Community School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   65.0                                             65
2478010 2478010 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000044 25 Buena Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478011 2478011 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000046 30 Buena Regional Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478012 2478012 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000048 45 Collings Lakes Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   55.0                                             55
2478013 2478013 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000052 55 John C. Milanesi Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   57.0                                             57
2478014 2478014 NJ Atlantic 1 school 3402400 590   Buena Regional 340240003221 300 Dr. J.P. Cleary Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478015 2478015 NJ Atlantic 1 school 3404530 1300   Egg Harbor City 340453000074 20 Charles L. Spragg School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   45.0                                             45
2478016 2478016 NJ Atlantic 1 school 3404530 1300   Egg Harbor City 340453000076 30 Egg Harbor City Community School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478017 2478017 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456005961 5 Egg Harbor Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478018 2478018 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000086 33 Clayton J. Davenport Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478019 2478019 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000051 35 E. H. Slaybaugh Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478020 2478020 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002953 38 Alder Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478021 2478021 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002955 39 Fernwood Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478022 2478022 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000698 45 Dr. Joyanne D. Miller Elementary School   Regular School No Elementary 04 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478023 2478023 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000092 50 H. Russel Swift Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478024 2478024 NJ Atlantic 1 school 3404860 1410   Estell Manor City 340486000102 50 Estell Manor Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478025 2478025 NJ Atlantic 1 school 3405280 1540   Folsom Boro 340528000104 50 Folsom Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   16.0                                             16
2478026 2478026 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000108 15 Arthur Rann Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478027 2478027 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000383 16 Galloway Township Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478028 2478028 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000114 40 Pomona Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   66.0                                             66
2478029 2478029 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006028 45 Reeds Road Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478030 2478030 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006088 46 Roland Rogers Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   22.0                                             22
2478031 2478031 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006089 48 Smithville Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   29.0                                             29
2478032 2478032 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000122 40 Absegami High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478033 2478033 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000124 50 Oakcrest High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478034 2478034 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606003115 60 Cedar Creek High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478035 2478035 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000015 55 George L. Hess Educational Complex   Regular School No Elementary 02 05 2020   pre_kindergarten_half_day                                                   89.0                                             89
2478036 2478036 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000130 60 Joseph C Shaner Memorial Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   119.0                                             119
2478037 2478037 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651006029 120 William Davies Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478038 2478038 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000699 30 Hammonton Early Childhood Eductional Center   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478039 2478039 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000136 50 Hammonton High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478040 2478040 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000138 55 Warren E. Sooy Jr. Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478041 2478041 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000140 60 Hammonton Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478042 2478042 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000144 20 Belhaven Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478043 2478043 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000150 50 Seaview Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   11.0                                             11
2478044 2478044 NJ Atlantic 1 school 3409360 2910   Mainland Regional 340936000158 50 Mainland Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478045 2478045 NJ Atlantic 1 school 3409690 3020   Margate City 340969000162 10 Eugene A. Tighe Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478046 2478046 NJ Atlantic 1 school 3409690 3020   Margate City 340969000393 25 William H. Ross Iii School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478047 2478047 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000172 20 Mullica Township Primary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   56.0                                             56

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