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_int 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 ▲
2476576 2476576 NJ Hudson 17 school 3411460 3610   North Bergen Twp 341146002890 90 Lincoln Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   264.0                                             264
2476010 2476010 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300000263 62 Barclay Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   163.0                                             163
2477543 2477543 NJ Salem 33 school 3412840 4070   Penns Grv-Carneys Pt Reg 341284005056 100 Lafayette - Pershing   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   128.0                                             128
2476415 2476415 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390000708 30 Central Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   122.0                                             122
2475517 2475517 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000051 35 E. H. Slaybaugh Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   118.0                                             118
2475538 2475538 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000138 55 Warren E. Sooy Jr. Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten_full_day                                                   104.0                                             104
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
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
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
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
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
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
2476099 2476099 NJ Camden 7 school 3415870 5080   Stratford Boro 341587001666 45 Parkivew Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   38.0                                             38
2475885 2475885 NJ Burlington 5 school 3405220 1520   Florence Twp 340522001086 70 Roebling Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   37.0                                             37
2475914 2475914 NJ Burlington 5 school 3410710 3360   Moorestown Twp 341071001142 120 South Valley Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   37.0                                             37
2476286 2476286 NJ Essex 13 school 3410200 3190   Millburn Twp 341020000230 100 South Mountain School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   37.0                                             37
2477619 2477619 NJ Somerset 35 school 3409630 3000   Manville Boro 340963005244 90 Weston Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   37.0                                             37
2476489 2476489 NJ Gloucester 15 school 3417790 5740   Westville Boro 341779002684 40 Parkview Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   36.0                                             36
2477383 2477383 NJ Ocean 29 school 3416230 5190   Toms River Regional 341623004740 95 Silver Bay Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   36.0                                             36
2476253 2476253 NJ Essex 13 school 3405010 1465   Fairfield Twp 340501002086 5 Stevenson   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   35.0                                             35
2476567 2476567 NJ Hudson 17 school 3407890 2410   Kearny Town 340789002870 80 Garfield Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   35.0                                             35
2477120 2477120 NJ Monmouth 25 school 3416890 5420   Wall Twp 341689000099 78 Wall Primary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   35.0                                             35
2477307 2477307 NJ Ocean 29 school 3407740 2360   Jackson Twp 340774000463 30 Crawford-Rodriguez Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   35.0                                             35
2477813 2477813 NJ Union 39 school 3414670 4670   Scotch Plains-Fanwood Reg 341467005684 80 Howard B. Brunner Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   35.0                                             35
2475693 2475693 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000564 100 Wilson School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   34.0                                             34
2475751 2475751 NJ Bergen 3 school 3412450 3940   Park Ridge Boro 341245000714 70 West Ridge Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   34.0                                             34
2476508 2476508 NJ Hudson 17 school 3404200 1200   East Newark Boro 340420002732 50 East Newark Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   34.0                                             34
2477123 2477123 NJ Monmouth 25 school 3417490 5640   West Long Branch Boro 341749006107 80 Betty Mcelmon Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   34.0                                             34
2477774 2477774 NJ Union 39 school 3411310 3560   New Providence Boro 341131005594 55 Allen W. Roberts School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   34.0                                             34
2475691 2475691 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885005975 80 Roosevelt School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   33.0                                             33
2476433 2476433 NJ Gloucester 15 school 3405880 1730   Glassboro 340588002566 80 J. Harvey Rodgers School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   33.0                                             33
2476694 2476694 NJ Mercer 21 school 3407530 2280   Hopewell Valley Regional 340753003138 35 Bear Tavern Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   33.0                                             33
2476993 2476993 NJ Monmouth 25 school 3407410 2230   Holmdel Twp 340741003856 80 Village School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   33.0                                             33
2477029 2477029 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Reg 340939002941 120 John I. Dawes Early Learning Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   33.0                                             33
2477587 2477587 NJ Somerset 35 school 3402280 555   Bridgewater-Raritan Reg 340228005168 40 Bradley Gardens Primary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   33.0                                             33
2476411 2476411 NJ Gloucester 15 school 3403180 860   Clayton Boro 340318002500 40 Herma S. Simmons Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   32.0                                             32
2476425 2476425 NJ Gloucester 15 school 3404620 1330   Elk Twp 340462002538 10 Aura Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   32.0                                             32
2477501 2477501 NJ Passaic 31 school 3413470 4270   Prospect Park Boro 341347004938 10 Prospect Park School No. 1   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   32.0                                             32
2477523 2477523 NJ Passaic 31 school 3417280 5570   Wayne Twp 341728004992 150 Theunis Dey Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   32.0                                             32
2477623 2477623 NJ Somerset 35 school 3410590 3320   Montgomery Twp 341059005254 80 Orchard Hill Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   32.0                                             32
2476790 2476790 NJ Middlesex 23 school 3404500 1290   Edison Twp 340450003237 302 Franklin D Roosevelt School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   31.0                                             31
2477506 2477506 NJ Passaic 31 school 3416260 5200   Totowa Boro 341626004952 50 Memorial School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   31.0                                             31
2477757 2477757 NJ Union 39 school 3407920 2420   Kenilworth Boro 340792005552 50 Warren G. Harding Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   31.0                                             31
2475692 2475692 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000562 90 Washington School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   30.0                                             30
2475695 2475695 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000570 60 Columbus School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   30.0                                             30
2476058 2476058 NJ Camden 7 school 3406360 1890   Haddon Twp 340636001542 60 Thomas A. Edison Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   30.0                                             30
2476200 2476200 NJ Essex 13 school 3401350 250   Belleville Town 340135001968 70 Belleville Ps7   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   30.0                                             30
2476470 2476470 NJ Gloucester 15 school 3415990 5120   Swedesboro-Woolwich 341599000184 70 Margaret C. Clifford School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   30.0                                             30
2476895 2476895 NJ Middlesex 23 school 3415210 4860   South Brunswick Twp 341521000509 85 Brooks Crossing Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   30.0                                             30
2477148 2477148 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004224 30 Central Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   30.0                                             30

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