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,402 ✖

grade ✖

  • pre_kindergarten_half_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
2478147 2478147 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000460 20 High Mountain Road School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   34.0                                             34
2478181 2478181 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000526 20 George G White   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478215 2478215 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000616 20 Fieldstone Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478232 2478232 NJ Bergen 3 school 3411850 3740   Norwood Boro 341185000660 20 Norwood Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   11.0                                             11
2478339 2478339 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000942 20 Calvin Coolidge Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478350 2478350 NJ Burlington 5 school 3402430 600   Burlington City 340243000966 20 Burlington City High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478393 2478393 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918000222 20 Bobby'S Run Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478461 2478461 NJ Burlington 5 school 3417730 5720   Westampton 341773001256 20 Holly Hills Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478478 2478478 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001318 20 Bellmawr Park Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   153.0                                             153
2478480 2478480 NJ Camden 7 school 3401590 330   Berlin Boro 340159001324 20 Berlin Community School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478483 2478483 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_half_day                                                   0.0                                             0
2478537 2478537 NJ Camden 7 school 3405850 1720   Gibbsboro Boro 340585001490 20 Gibbsboro Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478541 2478541 NJ Camden 7 school 3406030 1780   Gloucester Twp 340603001508 20 Blackwood Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   20.0                                             20
2478580 2478580 NJ Camden 7 school 3410890 3420   Mount Ephraim Boro 341089001598 20 Raymond W. Kershaw School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   10.0                                             10
2478596 2478596 NJ Camden 7 school 3414430 4590   Runnemede Boro 341443001650 20 Aline Bingham Elementary School   Regular School No Elementary KG 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478599 2478599 NJ Camden 7 school 3415000 4790   Somerdale Boro 341500001660 20 Somerdale Park School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478603 2478603 NJ Camden 7 school 3416830 5400   Voorhees Twp 341683001676 20 Edward T. Hamilton   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478612 2478612 NJ Camden 7 school 3418060 5820   Winslow Twp 341806000439 20 Winslow Township Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478622 2478622 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_half_day                                                   0.0                                             0
2478651 2478651 NJ Cumberland 11 school 3402250 540   Bridgeton City 340225001784 20 Bridgeton High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478697 2478697 NJ Essex 13 school 3401350 250   Belleville Town 340135001954 20 Belleville High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478706 2478706 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183001980 20 Bloomfield High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478748 2478748 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_half_day                                                   0.0                                             0
2478804 2478804 NJ Essex 13 school 3411340 3570   Newark City 341134002190 20 Barringer High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478881 2478881 NJ Essex 13 school 3414250 4530   Roseland Boro 341425002418 20 Lester C Noecker   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478915 2478915 NJ Gloucester 15 school 3403210 870   Clearview Regional 340321002506 20 Clearview Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478925 2478925 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   2.0                                             2
2478975 2478975 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707000185 20 Bunker Hill Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478998 2478998 NJ Hudson 17 school 3401260 220   Bayonne City 340126002704 20 Bayonne High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479113 2479113 NJ Hunterdon 19 school 3401710 370   Bethlehem Twp 340171002958 20 Ethel Hoppock Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479115 2479115 NJ Hunterdon 19 school 3401890 430   Bloomsbury Boro 340189002960 20 Bloomsbury Borough School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479125 2479125 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_half_day                                                   29.0                                             29
2479244 2479244 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_half_day                                                   0.0                                             0
2479324 2479324 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003442 20 Monroe Township Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479417 2479417 NJ Middlesex 23 school 3418120 5850   Woodbridge Twp 341812003668 20 Colonia High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479444 2479444 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003301 20 Barack Obama Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   46.0                                             46
2479448 2479448 NJ Monmouth 25 school 3401020 130   Atlantic Highlands Boro 340102003746 20 Atlantic Highlands Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   34.0                                             34
2479451 2479451 NJ Monmouth 25 school 3401410 270   Belmar Boro 340141003750 20 Belmar Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   52.0                                             52
2479452 2479452 NJ Monmouth 25 school 3402130 500   Bradley Beach Boro 340213003752 20 Bradley Beach Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   28.0                                             28
2479453 2479453 NJ Monmouth 25 school 3402310 560   Brielle Boro 340231003754 20 Brielle Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479474 2479474 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003810 20 Joseph J Catena School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479492 2479492 NJ Monmouth 25 school 3407410 2230   Holmdel Twp 340741003850 20 Holmdel High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479500 2479500 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003864 20 Edith M. Griebling Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479575 2479575 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_half_day                                                   0.0                                             0
2479626 2479626 NJ Morris 27 school 3401950 450   Boonton Town 340195004154 20 Boonton High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479630 2479630 NJ Morris 27 school 3402520 630   Butler Boro 340252004166 20 Butler High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479639 2479639 NJ Morris 27 school 3403060 820   Chester Twp 340306004194 20 Black River Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479654 2479654 NJ Morris 27 school 3405250 1530   Florham Park Boro 340525004236 20 Brooklake School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479663 2479663 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004264 20 Jefferson Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479694 2479694 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_half_day                                                   0.0                                             0
2479702 2479702 NJ Morris 27 school 3410770 3380   Morris Plains Boro 341077004358 20 Morris Plains Borough School   Regular School No Middle 03 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479785 2479785 NJ Ocean 29 school 3401230 210   Bay Head Boro 340123004568 20 Bay Head Elementary   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479786 2479786 NJ Ocean 29 school 3401290 230   Beach Haven Boro 340129004570 20 Beach Haven School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479787 2479787 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156004574 20 Bayville Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   97.0                                             97
2479791 2479791 NJ Ocean 29 school 3402220 530   Brick Twp 340222004582 20 Brick Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479805 2479805 NJ Ocean 29 school 3404050 1150   Eagleswood Twp 340405004606 20 Eagleswood Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   28.0                                             28
2479807 2479807 NJ Ocean 29 school 3407740 2360   Jackson Twp 340774004612 20 Jackson Memorial High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479817 2479817 NJ Ocean 29 school 3408100 2480   Lacey Twp 340810005935 20 Lacey Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479836 2479836 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_half_day                                                   15.0                                             15
2479845 2479845 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_half_day                                                   0.0                                             0
2479891 2479891 NJ Passaic 31 school 3401860 420   Bloomingdale Boro 340186004754 20 Martha B. Day Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   5.0                                             5
2479953 2479953 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_half_day                                                   0.0                                             0
2480037 2480037 NJ Salem 33 school 3400810 60   Alloway Twp 340081005028 20 Alloway Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480071 2480071 NJ Somerset 35 school 3401320 240   Bedminster Twp 340132005120 20 Bedminster Township Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   1.0                                             1
2480078 2480078 NJ Somerset 35 school 3402100 490   Bound Brook Boro 340210005144 20 Bound Brook High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480083 2480083 NJ Somerset 35 school 3402160 510   Branchburg Twp 340216005154 20 Branchburg Central Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480137 2480137 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480185 2480185 NJ Sussex 37 school 3415960 5100   Sussex-Wantage Regional 341596005945 20 Clifton E. Lawrence   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   8.0                                             8
2480190 2480190 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671005422 20 Vernon Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480198 2480198 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480299 2480299 NJ Union 39 school 3414280 4540   Roselle Boro 341428005652 20 Harrison Elementary School   Regular School No Elementary 01 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480334 2480334 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_half_day                                                   0.0                                             0
2480339 2480339 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_half_day                                                   0.0                                             0
2480369 2480369 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480371 2480371 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479475 2479475 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003812 21 C. Richard Applegate School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479476 2479476 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003814 23 Clifton T. Barkalow School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480191 2480191 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671006009 23 Cedar Mountain Primary School   Regular School No Elementary KG 01 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479477 2479477 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003816 24 Dwight D. Eisenhower School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
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
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
2478048 2478048 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000174 25 Mullica Township Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478340 2478340 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000944 25 Dwight D. Eisenhower Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478344 2478344 NJ Burlington 5 school 3401740 380   Beverly City 340174000952 25 Beverly City School District   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   45.0                                             45
2478363 2478363 NJ Burlington 5 school 3403090 830   Chesterfield Twp 340309001016 25 Chesterfield Township Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478487 2478487 NJ Camden 7 school 3402640 680   Camden City 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   292.0                                             292
2478659 2478659 NJ Cumberland 11 school 3403480 950   Commercial Twp 340348001810 25 Haleyville-Mauricetown Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   44.0                                             44
2478698 2478698 NJ Essex 13 school 3401350 250   Belleville Town 340135001956 25 Belleville Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478945 2478945 NJ Gloucester 15 school 3408880 2750   Logan Twp 340888000443 25 Center Square School   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   85.0                                             85
2478976 2478976 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002644 25 Bells Elementary School   Regular School No Elementary 01 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479245 2479245 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_half_day                                                   0.0                                             0
2479478 2479478 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003818 25 Marshall W. Errickson School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479501 2479501 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000097 25 Howell Township Middle School North   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479576 2479576 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_half_day                                                   0.0                                             0
2479631 2479631 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479658 2479658 NJ Morris 27 school 3406690 2000   Hanover Twp 340669004250 25 Bee Meadow School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479687 2479687 NJ Morris 27 school 3410650 3340   Montville Twp 341065004334 25 Cedar Hill School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   4.0                                             4
2479761 2479761 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_half_day                                                   0.0                                             0
2479788 2479788 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156006125 25 Berkeley Township Elementary School   Regular School No Middle 04 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479792 2479792 NJ Ocean 29 school 3402220 530   Brick Twp 340222005896 25 Brick Township Memorial High School   Regular School No High 09 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]);