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 total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • pre_kindergarten_full_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
2477055 2477055 NJ Monmouth 25 school 3410110 3160   Middletown Twp 341011003992 95 Harmony Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   95.0                                             95
2475918 2475918 NJ Burlington 5 school 3410950 3440   Mount Laurel Twp 341095001156 10 Countryside Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   9.0                                             9
2475922 2475922 NJ Burlington 5 school 3410950 3440   Mount Laurel Twp 341095006070 55 Larchmont Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   9.0                                             9
2475925 2475925 NJ Burlington 5 school 3410950 3440   Mount Laurel Twp 341095000423 75 Springville Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   9.0                                             9
2475933 2475933 NJ Burlington 5 school 3412390 3920   Palmyra Boro 341239001190 60 Charles Street School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   9.0                                             9
2476494 2476494 NJ Gloucester 15 school 3418180 5870   Woodbury Heights Boro 341818002698 50 Woodbury Heights Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   9.0                                             9
2477244 2477244 NJ Morris 27 school 3412900 4080   Pequannock Twp 341290004474 60 North Boulevard School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   9.0                                             9
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
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
2477527 2477527 NJ Passaic 31 school 3417520 5650   West Milford Twp 341752005004 60 Maple Road Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   9.0                                             9
2477873 2477873 NJ Warren 41 school 3405670 1670   Frelinghuysen Twp 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   9.0                                             9
2476096 2476096 NJ Camden 7 school 3414430 4590   Runnemede Boro 341443001654 40 Mary E. Volz Elementary School   Regular School No Middle 04 08 2020   pre_kindergarten_full_day                                                   88.0                                             88
2475881 2475881 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489006065 65 Richard L Rice School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   87.0                                             87
2476886 2476886 NJ Middlesex 23 school 3414640 4660   Sayreville Boro 341464000553 85 Samsel Upper Elementary School   Regular School No Elementary 04 05 2020   pre_kindergarten_full_day                                                   84.0                                             84
2475533 2475533 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000015 55 George L. Hess Educational Complex   Regular School No Elementary 02 05 2020   pre_kindergarten_full_day                                                   81.0                                             81
2475948 2475948 NJ Burlington 5 school 3414010 4450   Riverside Twp 341401001236 60 Riverside Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   81.0                                             81
2476581 2476581 NJ Hudson 17 school 3414850 4730   Secaucus Town 341485002904 70 Huber Street School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   81.0                                             81
2476986 2476986 NJ Monmouth 25 school 3413680 2105   Hazlet Twp 341368003838 100 Sycamore Drive Early Childhood Learning Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   80.0                                             80
2477001 2477001 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003866 30 Land O'Pines Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   80.0                                             80
2475614 2475614 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000374 80 Gilbert Avenue School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   8.0                                             8
2475681 2475681 NJ Bergen 3 school 3407320 2200   Ho Ho Kus Boro 340732000530 50 Ho-Ho-Kus Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   8.0                                             8
2476483 2476483 NJ Gloucester 15 school 3417340 5590   Wenonah Boro 341734002658 50 Wenonah Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   8.0                                             8
2476622 2476622 NJ Hunterdon 19 school 3404080 1160   East Amwell Twp 340408002980 50 East Amwell Township   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   8.0                                             8
2476627 2476627 NJ Hunterdon 19 school 3405190 1510   Flemington-Raritan Reg 340519000145 33 Copper Hill Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   8.0                                             8
2477144 2477144 NJ Morris 27 school 3403930 1110   Dover Town 340393004214 50 Academy Street Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   8.0                                             8
2475785 2475785 NJ Bergen 3 school 3413950 4430   River Vale Twp 341395000802 70 Woodside Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   7.0                                             7
2475797 2475797 NJ Bergen 3 school 3414520 4620   Saddle River Boro 341452000834 50 Wandell School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   7.0                                             7
2475858 2475858 NJ Burlington 5 school 3402460 620   Burlington Twp 340246001010 30 B. Bernice Young Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   7.0                                             7
2476143 2476143 NJ Cape May 9 school 3417400 5610   West Cape May Boro 341740001762 50 West Cape May Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   7.0                                             7
2476824 2476824 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003446 40 Mill Lake   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   7.0                                             7
2475636 2475636 NJ Bergen 3 school 3405070 1470   Fairview Boro 340507000256 65 Lincoln School Annex   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   69.0                                             69
2475871 2475871 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001050 50 Millbridge Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   65.0                                             65
2477693 2477693 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671005428 50 Walnut Ridge Primary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   65.0                                             65
2477818 2477818 NJ Union 39 school 3415630 5000   Springfield Twp 341563006036 50 Edward V. Walton Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   64.0                                             64
2476104 2476104 NJ Camden 7 school 3416830 5400   Voorhees Twp 341683006061 95 Signal Hill School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   62.0                                             62
2476439 2476439 NJ Gloucester 15 school 3406900 2070   Harrison Twp 340690002578 50 Harrison Township Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   61.0                                             61
2476452 2476452 NJ Gloucester 15 school 3410470 3280   Monroe Twp 341047005938 95 Radix Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   60.0                                             60
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
2476632 2476632 NJ Hunterdon 19 school 3405460 1600   Franklin Twp 340546002990 50 Franklin Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   6.0                                             6
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
2475591 2475591 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000310 70 School #5   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   58.0                                             58
2476421 2476421 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002526 130 Pine Acres Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   58.0                                             58
2476751 2476751 NJ Mercer 21 school 3417700 5715   W Windsor-Plainsboro Reg 341770000147 160 Village Elementary School   Regular School No Elementary 04 05 2020   pre_kindergarten_full_day                                                   58.0                                             58
2476793 2476793 NJ Middlesex 23 school 3407170 2150   Highland Park Boro 340717003376 70 Irving Primary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   58.0                                             58
2475704 2475704 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000492 65 Lenape Meadows   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   56.0                                             56
2477814 2477814 NJ Union 39 school 3414670 4670   Scotch Plains-Fanwood Reg 341467005686 85 J. Ackerman Coles Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   54.0                                             54
2477698 2477698 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153000203 35 Mary Kay Mcmillin Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   52.0                                             52
2477518 2477518 NJ Passaic 31 school 3417280 5570   Wayne Twp 341728004982 110 Packanack Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   51.0                                             51
2475665 2475665 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000490 90 Clara E Coleman School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   5.0                                             5
2475712 2475712 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014003209 300 Godwin Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   5.0                                             5
2475841 2475841 NJ Burlington 5 school 3401200 200   Bass River Twp 340120000950 50 Bass River Township Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   5.0                                             5
2476221 2476221 NJ Essex 13 school 3402580 660   Caldwell-West Caldwell 340258003425 300 Harrison School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   5.0                                             5
2476566 2476566 NJ Hudson 17 school 3407890 2410   Kearny Town 340789002868 70 Franklin Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   5.0                                             5
2476612 2476612 NJ Hunterdon 19 school 3401710 370   Bethlehem Twp 340171005895 70 Thomas B. Conley Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   5.0                                             5
2476962 2476962 NJ Monmouth 25 school 3405130 1490   Farmingdale Boro 340513003782 50 Farmingdale Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   5.0                                             5
2477212 2477212 NJ Morris 27 school 3410860 3410   Mount Arlington Boro 341086004392 45 Edith M. Decker Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   5.0                                             5
2477272 2477272 NJ Morris 27 school 3417130 5520   Washington Twp 341713000815 50 Benedict A. Cucinella School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   5.0                                             5
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
2477647 2477647 NJ Somerset 35 school 3417190 5540   Watchung Boro 341719005316 40 Bayberry School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   5.0                                             5
2477749 2477749 NJ Union 39 school 3405790 1710   Garwood Boro 340579005532 50 Lincoln   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   5.0                                             5
2477875 2477875 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   5.0                                             5
2477901 2477901 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   pre_kindergarten_full_day                                                   5.0                                             5
2477644 2477644 NJ Somerset 35 school 3416980 5470   Warren Twp 341698005310 35 Mt. Horeb School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   49.0                                             49
2477712 2477712 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   49.0                                             49
2477849 2477849 NJ Union 39 school 3416500 5290   Union Twp 341650000247 83 Hannah Caldwell Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   49.0                                             49
2477060 2477060 NJ Monmouth 25 school 3410110 3160   Middletown Twp 341011004002 143 New Monmouth Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   48.0                                             48
2477615 2477615 NJ Somerset 35 school 3407230 2170   Hillsborough Twp 340723005234 85 Woods Road Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   48.0                                             48
2475606 2475606 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000348 80 Selzer Elementary\Middle School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   46.0                                             46
2477248 2477248 NJ Morris 27 school 3413650 4330   Randolph Twp 341365004488 57 Center Grove School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   46.0                                             46
2476771 2476771 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003318 138 Warnsdorfer Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   45.0                                             45
2477864 2477864 NJ Union 39 school 3417760 5730   Westfield Town 341776002999 170 Lincoln Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   45.0                                             45
2477876 2477876 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   45.0                                             45
2475796 2475796 NJ Bergen 3 school 3414490 4610   Saddle Brook Twp 341449000119 100 Washington School   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   44.0                                             44
2476275 2476275 NJ Essex 13 school 3408820 2730   Livingston Twp 340882006052 70 Burnet Hill Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   44.0                                             44
2476892 2476892 NJ Middlesex 23 school 3415210 4860   South Brunswick Twp 341521003614 60 Cambridge Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   44.0                                             44
2476898 2476898 NJ Middlesex 23 school 3415210 4860   South Brunswick Twp 341521003628 110 Monmouth Junction Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   44.0                                             44
2477679 2477679 NJ Sussex 37 school 3415510 4960   Sparta Twp 341551005402 70 Alpine Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   44.0                                             44
2476789 2476789 NJ Middlesex 23 school 3404500 1290   Edison Twp 340450003179 300 Edison Early Learning Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   43.0                                             43
2477100 2477100 NJ Monmouth 25 school 3414370 4570   Rumson Boro 341437004090 40 Deane-Porter Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   43.0                                             43
2477232 2477232 NJ Morris 27 school 3412480 3950   Parsippany-Troy Hills Twp 341248000401 70 Lake Hiawatha Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   43.0                                             43
2477593 2477593 NJ Somerset 35 school 3402280 555   Bridgewater-Raritan Reg 340228006126 85 Milltown Primary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   43.0                                             43
2475618 2475618 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000384 70 Memorial School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   42.0                                             42
2476211 2476211 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183000133 120 The Early Childhood Center @ Forest Glen   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   42.0                                             42
2476509 2476509 NJ Hudson 17 school 3406240 1850   Guttenberg Town 340624002734 50 Anna L. Klein   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   42.0                                             42
2477513 2477513 NJ Passaic 31 school 3417280 5570   Wayne Twp 341728004970 78 Albert Payson Terhune Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   42.0                                             42
2477575 2477575 NJ Somerset 35 school 3401650 350   Bernards Twp 340165000355 100 Mount Prospect Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   42.0                                             42
2477140 2477140 NJ Morris 27 school 3403870 1090   Denville Twp 340387004202 50 Lakeview Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   41.0                                             41
2477188 2477188 NJ Morris 27 school 3410650 3340   Montville Twp 341065004340 55 Valley View School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   41.0                                             41
2476819 2476819 NJ Middlesex 23 school 3410290 3220   Milltown Boro 341029003434 60 Parkview School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   40.0                                             40
2476929 2476929 NJ Middlesex 23 school 3418120 5850   Woodbridge Twp 341812003702 180 Kennedy Park Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   40.0                                             40
2477815 2477815 NJ Union 39 school 3414670 4670   Scotch Plains-Fanwood Reg 341467005688 90 Evergreen Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   40.0                                             40
2475521 2475521 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000092 50 H. Russel Swift Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   4.0                                             4
2475709 2475709 NJ Bergen 3 school 3409810 3060   Maywood Boro 340981000604 70 Memorial School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   4.0                                             4
2477011 2477011 NJ Monmouth 25 school 3407950 2430   Keyport Boro 340795003890 60 Keyport Central School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   4.0                                             4
2477108 2477108 NJ Monmouth 25 school 3416200 5185   Tinton Falls 341620004112 30 Mahala F. Atchison School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   4.0                                             4
2477222 2477222 NJ Morris 27 school 3411010 3460   Mountain Lakes Boro 341101004420 70 Lake Drive Program For Hearing Impared   Special Education School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   4.0                                             4
2477668 2477668 NJ Sussex 37 school 3408130 2490   Lafayette Twp 340813005374 50 Lafayette Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   4.0                                             4
2476427 2476427 NJ Gloucester 15 school 3405430 1590   Franklin Twp 340543002546 80 Mary F. Janvier School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   39.0                                             39
2477229 2477229 NJ Morris 27 school 3412480 3950   Parsippany-Troy Hills Twp 341248004438 62 Eastlake Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   39.0                                             39
2475904 2475904 NJ Burlington 5 school 3409870 3080   Medford Twp 340987000540 45 Kirby'S Mill Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   38.0                                             38

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