enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,402 ✖

grade ✖

  • pre_kindergarten_full_day · 2,402 ✖
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
2475645 2475645 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000460 20 High Mountain Road School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   6.0                                             6
2475679 2475679 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000526 20 George G White   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475713 2475713 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000616 20 Fieldstone Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475730 2475730 NJ Bergen 3 school 3411850 3740   Norwood Boro 341185000660 20 Norwood Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475837 2475837 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000942 20 Calvin Coolidge Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475848 2475848 NJ Burlington 5 school 3402430 600   Burlington City 340243000966 20 Burlington City High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475891 2475891 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918000222 20 Bobby'S Run Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475959 2475959 NJ Burlington 5 school 3417730 5720   Westampton 341773001256 20 Holly Hills Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   26.0                                             26
2475976 2475976 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001318 20 Bellmawr Park Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475978 2475978 NJ Camden 7 school 3401590 330   Berlin Boro 340159001324 20 Berlin Community School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   15.0                                             15
2475981 2475981 NJ Camden 7 school 3401770 390   Black Horse Pike Regional 340177001336 20 Highland Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476035 2476035 NJ Camden 7 school 3405850 1720   Gibbsboro Boro 340585001490 20 Gibbsboro Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   15.0                                             15
2476039 2476039 NJ Camden 7 school 3406030 1780   Gloucester Twp 340603001508 20 Blackwood Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   20.0                                             20
2476078 2476078 NJ Camden 7 school 3410890 3420   Mount Ephraim Boro 341089001598 20 Raymond W. Kershaw School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476094 2476094 NJ Camden 7 school 3414430 4590   Runnemede Boro 341443001650 20 Aline Bingham Elementary School   Regular School No Elementary KG 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476097 2476097 NJ Camden 7 school 3415000 4790   Somerdale Boro 341500001660 20 Somerdale Park School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   28.0                                             28
2476101 2476101 NJ Camden 7 school 3416830 5400   Voorhees Twp 341683001676 20 Edward T. Hamilton   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476110 2476110 NJ Camden 7 school 3418060 5820   Winslow Twp 341806000439 20 Winslow Township Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476120 2476120 NJ Cape May 9 school 3402740 715   Cape May Co Special Serv 340274001708 20 Cape May County High School   Special Education School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476149 2476149 NJ Cumberland 11 school 3402250 540   Bridgeton City 340225001784 20 Bridgeton High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476195 2476195 NJ Essex 13 school 3401350 250   Belleville Town 340135001954 20 Belleville High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476204 2476204 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183001980 20 Bloomfield High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476246 2476246 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476302 2476302 NJ Essex 13 school 3411340 3570   Newark City 341134002190 20 Barringer High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476379 2476379 NJ Essex 13 school 3414250 4530   Roseland Boro 341425002418 20 Lester C Noecker   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   18.0                                             18
2476413 2476413 NJ Gloucester 15 school 3403210 870   Clearview Regional 340321002506 20 Clearview Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476423 2476423 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   24.0                                             24
2476473 2476473 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707000185 20 Bunker Hill Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476496 2476496 NJ Hudson 17 school 3401260 220   Bayonne City 340126002704 20 Bayonne High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476611 2476611 NJ Hunterdon 19 school 3401710 370   Bethlehem Twp 340171002958 20 Ethel Hoppock Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476613 2476613 NJ Hunterdon 19 school 3401890 430   Bloomsbury Boro 340189002960 20 Bloomsbury Borough School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   12.0                                             12
2476623 2476623 NJ Hunterdon 19 school 3400769 1376   South Hunterdon Regional School District 340076903010 20 Lambertville Public School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476742 2476742 NJ Mercer 21 school 3417700 5715   W Windsor-Plainsboro Reg 341770003258 20 West Windsor-Plainsboro High School South   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476822 2476822 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003442 20 Monroe Township Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476915 2476915 NJ Middlesex 23 school 3418120 5850   Woodbridge Twp 341812003668 20 Colonia High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476942 2476942 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003301 20 Barack Obama Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476946 2476946 NJ Monmouth 25 school 3401020 130   Atlantic Highlands Boro 340102003746 20 Atlantic Highlands Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   15.0                                             15
2476949 2476949 NJ Monmouth 25 school 3401410 270   Belmar Boro 340141003750 20 Belmar Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476950 2476950 NJ Monmouth 25 school 3402130 500   Bradley Beach Boro 340213003752 20 Bradley Beach Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476951 2476951 NJ Monmouth 25 school 3402310 560   Brielle Boro 340231003754 20 Brielle Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   21.0                                             21
2476972 2476972 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003810 20 Joseph J Catena School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476990 2476990 NJ Monmouth 25 school 3407410 2230   Holmdel Twp 340741003850 20 Holmdel High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476998 2476998 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003864 20 Edith M. Griebling Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477073 2477073 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750005989 20 Marine Academy Of Science And Technology   Career and Technical School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477124 2477124 NJ Morris 27 school 3401950 450   Boonton Town 340195004154 20 Boonton High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477128 2477128 NJ Morris 27 school 3402520 630   Butler Boro 340252004166 20 Butler High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477137 2477137 NJ Morris 27 school 3403060 820   Chester Twp 340306004194 20 Black River Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477152 2477152 NJ Morris 27 school 3405250 1530   Florham Park Boro 340525004236 20 Brooklake School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477161 2477161 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004264 20 Jefferson Township High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477192 2477192 NJ Morris 27 school 3410720 3365   Morris County Vocational 341072000522 20 Academy For Mathematics Science And Engineering   Career and Technical School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477200 2477200 NJ Morris 27 school 3410770 3380   Morris Plains Boro 341077004358 20 Morris Plains Borough School   Regular School No Middle 03 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477283 2477283 NJ Ocean 29 school 3401230 210   Bay Head Boro 340123004568 20 Bay Head Elementary   Regular School No Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477284 2477284 NJ Ocean 29 school 3401290 230   Beach Haven Boro 340129004570 20 Beach Haven School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   9.0                                             9
2477285 2477285 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156004574 20 Bayville Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477289 2477289 NJ Ocean 29 school 3402220 530   Brick Twp 340222004582 20 Brick Township High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477303 2477303 NJ Ocean 29 school 3404050 1150   Eagleswood Twp 340405004606 20 Eagleswood Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477305 2477305 NJ Ocean 29 school 3407740 2360   Jackson Twp 340774004612 20 Jackson Memorial High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477315 2477315 NJ Ocean 29 school 3408100 2480   Lacey Twp 340810005935 20 Lacey Township High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477334 2477334 NJ Ocean 29 school 3408910 2760   Long Beach Island 340891004654 20 Ethel A. Jacobsen Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   9.0                                             9
2477343 2477343 NJ Ocean 29 school 3411980 3790   Ocean County Vocational 341198004672 20 Ocean County Vocational Technical School Jackson Center   Career and Technical School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477389 2477389 NJ Passaic 31 school 3401860 420   Bloomingdale Boro 340186004754 20 Martha B. Day Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   6.0                                             6
2477451 2477451 NJ Passaic 31 school 3412690 4010   Paterson City 341269005998 20 Rosa L. Parks School Of Fine And Performing Arts   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477535 2477535 NJ Salem 33 school 3400810 60   Alloway Twp 340081005028 20 Alloway Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   25.0                                             25
2477569 2477569 NJ Somerset 35 school 3401320 240   Bedminster Twp 340132005120 20 Bedminster Township Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   5.0                                             5
2477576 2477576 NJ Somerset 35 school 3402100 490   Bound Brook Boro 340210005144 20 Bound Brook High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477581 2477581 NJ Somerset 35 school 3402160 510   Branchburg Twp 340216005154 20 Branchburg Central Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477635 2477635 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477683 2477683 NJ Sussex 37 school 3415960 5100   Sussex-Wantage Regional 341596005945 20 Clifton E. Lawrence   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477688 2477688 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671005422 20 Vernon Township High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477696 2477696 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477797 2477797 NJ Union 39 school 3414280 4540   Roselle Boro 341428005652 20 Harrison Elementary School   Regular School No Elementary 01 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477832 2477832 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477837 2477837 NJ Union 39 school 3418040 5260   Union County Vocational 341804000584 20 Academy For Allied Health Sciences   Career and Technical School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477867 2477867 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   1.0                                             1
2477869 2477869 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476973 2476973 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003812 21 C. Richard Applegate School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476974 2476974 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003814 23 Clifton T. Barkalow School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477689 2477689 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671006009 23 Cedar Mountain Primary School   Regular School No Elementary KG 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476975 2476975 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003816 24 Dwight D. Eisenhower School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475508 2475508 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000044 25 Buena Regional High School   Regular School No High 09 12 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
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
2475838 2475838 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000944 25 Dwight D. Eisenhower Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475842 2475842 NJ Burlington 5 school 3401740 380   Beverly City 340174000952 25 Beverly City School District   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475861 2475861 NJ Burlington 5 school 3403090 830   Chesterfield Twp 340309001016 25 Chesterfield Township Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   29.0                                             29
2475985 2475985 NJ Camden 7 school 3402640 680   Camden City 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476157 2476157 NJ Cumberland 11 school 3403480 950   Commercial Twp 340348001810 25 Haleyville-Mauricetown Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476196 2476196 NJ Essex 13 school 3401350 250   Belleville Town 340135001956 25 Belleville Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476443 2476443 NJ Gloucester 15 school 3408880 2750   Logan Twp 340888000443 25 Center Square School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476474 2476474 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002644 25 Bells Elementary School   Regular School No Elementary 01 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476743 2476743 NJ Mercer 21 school 3417700 5715   W Windsor-Plainsboro Reg 341770000191 25 West Windsor-Plainsboro High School North   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476976 2476976 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003818 25 Marshall W. Errickson School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476999 2476999 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000097 25 Howell Township Middle School North   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477074 2477074 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750000163 25 Monmouth County Academy Of Allied Health And Science   Career and Technical School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477129 2477129 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477156 2477156 NJ Morris 27 school 3406690 2000   Hanover Twp 340669004250 25 Bee Meadow School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477185 2477185 NJ Morris 27 school 3410650 3340   Montville Twp 341065004334 25 Cedar Hill School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   27.0                                             27
2477259 2477259 NJ Morris 27 school 3414130 4490   Rockaway Twp 341413004516 25 Dennis B O'Brien Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   20.0                                             20
2477286 2477286 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156006125 25 Berkeley Township Elementary School   Regular School No Middle 04 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477290 2477290 NJ Ocean 29 school 3402220 530   Brick Twp 340222005896 25 Brick Township Memorial High School   Regular School No High 09 12 2020   pre_kindergarten_full_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]);