enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "pre_kindergarten_half_day", state = "NJ" and year = 2020 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • pre_kindergarten_half_day · 2,502 ✖
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
2479170 2479170 NJ Mercer 21 school 3400778 1431   Katzenbach 340077803329 1 Marie H Katzenbach High School   Special Education School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479947 2479947 NJ Passaic 31 school 3412690 4010   Paterson City 341269003101 1 School Of Information Technology   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478067 2478067 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145005978 2 N. A. Bleshman Regional Day School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   1.0                                             1
2479028 2479028 NJ Hudson 17 school 3407830 2390   Jersey City 340783003121 2 Infinity Institute   Regular School No High 06 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479948 2479948 NJ Passaic 31 school 3412690 4010   Paterson City 341269003103 2 School Of Culinary Arts Hospitality And Tourism   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479496 2479496 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000721 3 Adelphia Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479572 2479572 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750000161 3 Class Academy   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479949 2479949 NJ Passaic 31 school 3412690 4010   Paterson City 341269003105 3 School Of Government And Public Administration   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478802 2478802 NJ Essex 13 school 3411340 3570   Newark City 341134005985 4 Nj Regional Day School - Newark   Special Education School No Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479573 2479573 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750000409 4 Communications High School   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479950 2479950 NJ Passaic 31 school 3412690 4010   Paterson City 341269003107 4 School Of Health Science   Regular School No High 09 12 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
2478370 2478370 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001040 5 Delran High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478573 2478573 NJ Camden 7 school 3408640 2670   Lindenwold Boro 340864000429 5 Lindenwold High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478755 2478755 NJ Essex 13 school 3405010 1465   Fairfield Twp 340501002086 5 Stevenson   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   1.0                                             1
2479016 2479016 NJ Hudson 17 school 3407350 2210   Hoboken City 340735002746 5 Hoboken High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479111 2479111 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479322 2479322 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003438 5 Monroe Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479497 2479497 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003860 5 Aldrich Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479951 2479951 NJ Passaic 31 school 3412690 4010   Paterson City 341269003109 5 School Of Earth And Space Science   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480086 2480086 NJ Somerset 35 school 3402280 555   Bridgewater-Raritan Reg 340228000173 5 Bridgewater-Raritan High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480197 2480197 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153000201 5 Governor Livingston High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480203 2480203 NJ Union 39 school 3403150 850   Clark Twp 340315000205 5 Arthur L. Johnson High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479308 2479308 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018005991 6 Piscataway Regional Day School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479952 2479952 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478371 2478371 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001042 7 Delran Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479838 2479838 NJ Ocean 29 school 3409450 2940   Manchester Twp 340945005983 8 Manchester Regional Day School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   2.0                                             2
2480061 2480061 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103297 9 Salem Campus   Special Education School No Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
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
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
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
2478064 2478064 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000224 10 Brookside School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478066 2478066 NJ Bergen 3 school 3400870 80   Alpine Boro 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478180 2478180 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478338 2478338 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478359 2478359 NJ Burlington 5 school 3402460 620   Burlington Twp 340246001004 10 Burlington Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478420 2478420 NJ Burlington 5 school 3410950 3440   Mount Laurel Twp 341095001156 10 Countryside Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   9.0                                             9
2478472 2478472 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001298 10 Audubon Junior/Senior High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478475 2478475 NJ Camden 7 school 3401170 190   Barrington Boro 340117001308 10 Avon Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478486 2478486 NJ Camden 7 school 3402370 580   Brooklawn Boro 340237001340 10 Alice Costello Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   17.0                                             17
2478527 2478527 NJ Camden 7 school 3403240 880   Clementon Boro 340324005899 10 Clementon Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478592 2478592 NJ Camden 7 school 3412990 4110   Pine Hill Boro 341299000432 10 Overbrook Senior High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478611 2478611 NJ Camden 7 school 3418060 5820   Winslow Twp 341806000437 10 Winslow Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478620 2478620 NJ Cape May 9 school 3401110 170   Avalon Boro 340111001702 10 Avalon Elementary School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   25.0                                             25
2478803 2478803 NJ Essex 13 school 3411340 3570   Newark City 341134002188 10 Arts High School   Regular School No High 08 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478927 2478927 NJ Gloucester 15 school 3404620 1330   Elk Twp 340462002538 10 Aura Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478938 2478938 NJ Gloucester 15 school 3406040 1775   Gloucester Co Vocational 340604002570 10 Gloucester County Institute Of Technology   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478974 2478974 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002640 10 Washington Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478997 2478997 NJ Hudson 17 school 3401260 220   Bayonne City 340126003447 10 Bayonne Alternative High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479112 2479112 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   37.0                                             37
2479314 2479314 NJ Middlesex 23 school 3410080 3150   Middlesex Co Vocational 341008000395 10 Middlesex County Voc Academy Math Science &Engineering Techn   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479323 2479323 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003440 10 Barclay Brook School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479443 2479443 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003732 10 Asbury Park High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479449 2479449 NJ Monmouth 25 school 3401140 180   Avon Boro 340114003748 10 Avon Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   7.0                                             7
2479468 2479468 NJ Monmouth 25 school 3405610 1650   Freehold Regional 340561000237 10 Colts Neck High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479498 2479498 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003862 10 Ardena Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479508 2479508 NJ Monmouth 25 school 3407860 2400   Keansburg Boro 340786003880 10 Keansburg High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479574 2479574 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750006095 10 High Technology High School   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479633 2479633 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479686 2479686 NJ Morris 27 school 3410650 3340   Montville Twp 341065004332 10 Montville Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479716 2479716 NJ Morris 27 school 3410980 3450   Mount Olive Twp 341098004398 10 Mount Olive High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479758 2479758 NJ Morris 27 school 3414130 4490   Rockaway Twp 341413004510 10 Birchwood Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479779 2479779 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647004564 10 Lillian M. Dunfee Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   54.0                                             54
2479844 2479844 NJ Ocean 29 school 3411980 3790   Ocean County Vocational 341198004670 10 Ocean County Vocational Technical School Brick Center   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479855 2479855 NJ Ocean 29 school 3413230 4190   Plumsted Twp 341323000341 10 New Egypt High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479943 2479943 NJ Passaic 31 school 3412600 3980   Passaic Co Manchester Reg 341260004856 10 Passaic County-Manchester Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480003 2480003 NJ Passaic 31 school 3413470 4270   Prospect Park Boro 341347004938 10 Prospect Park School No. 1   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   40.0                                             40
2480041 2480041 NJ Salem 33 school 3412210 3860   Oldmans Twp 341221005042 10 Oldmans Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480087 2480087 NJ Somerset 35 school 3402280 555   Bridgewater-Raritan Reg 340228005162 10 Bridgewater-Raritan Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480152 2480152 NJ Sussex 37 school 3400900 90   Andover Reg 340090005324 10 Florence M. Burd   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   12.0                                             12
2480154 2480154 NJ Sussex 37 school 3402550 640   Byram Twp 340255000728 10 Byram Lakes Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480189 2480189 NJ Sussex 37 school 3415930 5110   Sussex County Vocational 341593005416 10 Sussex County Technical School   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480258 2480258 NJ Union 39 school 3407920 2420   Kenilworth Boro 340792000209 10 David Brearley Middle/High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480298 2480298 NJ Union 39 school 3414280 4540   Roselle Boro 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480319 2480319 NJ Union 39 school 3415630 5000   Springfield Twp 341563000213 10 Jonathan Dayton High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480333 2480333 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640005988 10 Lamberts Mill Academy   Special Education School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480368 2480368 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480370 2480370 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   5.0                                             5
2478354 2478354 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479029 2479029 NJ Hudson 17 school 3407830 2390   Jersey City 340783005980 11 Regional Day School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479499 2479499 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000722 12 Greenville Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
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
2478146 2478146 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000117 15 Franklin Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478372 2478372 NJ Burlington 5 school 3403780 1060   Delran Twp 340378000123 15 Delran Intermediate School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478477 2478477 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001316 15 Bell Oaks Upper Elementary School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478937 2478937 NJ Gloucester 15 school 3480363 1774   Gloucester Co Spec Serv 348036300413 15 Bankbridge Regional School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   5.0                                             5
2479653 2479653 NJ Morris 27 school 3405250 1530   Florham Park Boro 340525004234 15 Briarwood School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   13.0                                             13
2479759 2479759 NJ Morris 27 school 3414130 4490   Rockaway Twp 341413004512 15 Copeland Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479780 2479780 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647005947 15 Cecil S. Collins Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   93.0                                             93
2479912 2479912 NJ Passaic 31 school 3406450 1920   Haledon Boro 340645005904 15 Haledon Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   48.0                                             48
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
2479760 2479760 NJ Morris 27 school 3414130 4490   Rockaway Twp 341413004514 19 Catherine A Dwyer Elementary School   Regular School No Elementary KG 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
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
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
2478063 2478063 NJ Atlantic 1 school 3417850 5760   Weymouth Twp 341785000220 20 Weymouth Township Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   11.0                                             11
2478065 2478065 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000226 20 Hillside Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478073 2478073 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000250 20 Bergen County Academies   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478078 2478078 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000268 20 Bergenfield High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478085 2478085 NJ Bergen 3 school 3401920 440   Bogota Boro 340192000284 20 Bogota Jr./Sr. High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   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]);