Data source: Big Local News · About: Big Local

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

View and edit SQL

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
2475500 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475526 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000114 40 Pomona Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475558 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000533 60 New York Avenue Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475648 NJ Bergen 3 school 3405760 1700   Garfield City 340576006110 40 Garfield Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475653 NJ Bergen 3 school 3405760 1700   Garfield City 340576000386 86 Garfield Public Preschool Annex   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475659 NJ Bergen 3 school 3405760 1700   Garfield City 340576003431 302 Garfield Public Preschool 3 At Headstart   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475772 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000221 80 Glen School   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2475943 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281003167 300 Pemberton Early Childhood Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475985 NJ Camden 7 school 3402640 680   Camden City 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475993 NJ Camden 7 school 3402640 680   Camden City 340264006084 175 Riletta Twyne Cream Family School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476033 NJ Camden 7 school 3403420 940   Collingswood Boro 340342003485 300 Collingswood Pre School At Oaklyn   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476075 NJ Camden 7 school 3408640 2670   Lindenwold Boro 340864003271 300 Lindenwold Preschool Building   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476083 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287001622 90 Baldwin Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476156 NJ Cumberland 11 school 3402250 540   Bridgeton City 340225000581 150 Geraldine O Foster Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476171 NJ Cumberland 11 school 3410320 3230   Millville City 341032001874 68 Child Family Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476189 NJ Cumberland 11 school 3416800 5390   Vineland City 341680000225 176 Casimer M. Dallago Jr. Impact Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2476261 NJ Essex 13 school 3407680 2330   Irvington Township 340768002949 71 Augusta Preschool Academy   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476321 NJ Essex 13 school 3411340 3570   Newark City 341134003153 306 Early Childhood School - South   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476323 NJ Essex 13 school 3411340 3570   Newark City 341134003193 308 Early Childhood School - West   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476325 NJ Essex 13 school 3411340 3570   Newark City 341134003281 314 Early Childhood School - Central   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476326 NJ Essex 13 school 3411340 3570   Newark City 341134003327 316 Early Childhood School - North   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476378 NJ Essex 13 school 3412270 3880   City Of Orange Twp 341227003148 300 Orange Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476389 NJ Essex 13 school 3415330 4900   South Orange-Maplewood 341533003339 300 Montrose Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476409 NJ Essex 13 school 3417610 5680   West Orange Town 341761003416 300 Betty Maddalena Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   27.0                                             27
2476516 NJ Hudson 17 school 3407350 2210   Hoboken City 340735002760 63 Early Childhood Learning Center At Calabro School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476601 NJ Hudson 17 school 3417580 5670   West New York Town 341758000445 55 Early Childhood School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476616 NJ Hunterdon 19 school 3403360 920   Clinton Twp 340336002968 30 Spruce Run   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476862 NJ Middlesex 23 school 3412930 4090   Perth Amboy City 341293000551 75 Ignacio Cruz Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476863 NJ Middlesex 23 school 3412930 4090   Perth Amboy City 341293002998 80 Edmund Hmieleski Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476979 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564006120 70 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477008 NJ Monmouth 25 school 3407860 2400   Keansburg Boro 340786003882 40 Port Monmouth Road School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477040 NJ Monmouth 25 school 3409750 3040   Matawan-Aberdeen Regional 340975000723 40 Cambridge Park Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477083 NJ Monmouth 25 school 3411160 3510   Neptune Twp 341116000457 59 Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2477206 NJ Morris 27 school 3410810 3385   Morris School District 341081004376 85 Lafayette Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477291 NJ Ocean 29 school 3402220 530   Brick Twp 340222000166 27 Warren H. Wolf Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477333 NJ Ocean 29 school 3408700 2690   Little Egg Harbor Twp 340870003199 300 Robert C. Wood Sr Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477365 NJ Ocean 29 school 3415690 5020   Stafford Twp 341569004716 50 Oxycocus Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477409 NJ Passaic 31 school 3403300 900   Clifton City 340330003436 301 Clifton Early Learner Academies   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477433 NJ Passaic 31 school 3412540 3970   Passaic City 341254000403 180 School No.16   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477482 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477551 NJ Salem 33 school 3413110 4150   Pittsgrove Twp 341311005082 50 Norma Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2477705 NJ Union 39 school 3403150 850   Clark Twp 340315003295 300 Clark Preschool Annex   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   12.0                                             12
2477741 NJ Union 39 school 3404590 1320   Elizabeth City 340459000467 350 Frances C. Smith Early Childhood Center No 50   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477742 NJ Union 39 school 3404590 1320   Elizabeth City 340459006131 355 Donald Stewart Early Childhood Center No 51   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477743 NJ Union 39 school 3404590 1320   Elizabeth City 340459000567 360 Dr. Martin Luther King Jr. Early Childhood Center No 52   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477802 NJ Union 39 school 3414280 4540   Roselle Boro 341428003147 120 Roselle Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   28.0                                             28
2475621 NJ Bergen 3 school 3404740 1370   Englewood City 340474000392 70 Donald A. Quarles Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2475740 NJ Bergen 3 school 3412360 3910   Palisades Park 341236000789 80 Charles R Smith Early Chilhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   20.0                                             20
2475805 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000846 80 William Cullen Bryant School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475968 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003459 302 J. C. Stuart Early Childhood Development Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2476107 NJ Camden 7 school 3417250 5560   Waterford Twp 341725005924 60 Thomas Richards Elementary School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476129 NJ Cape May 9 school 3409150 2840   Lower Twp 340915005909 70 David C. Douglass Memorial School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2476236 NJ Essex 13 school 3404230 1210   East Orange 340423000275 107 Althea Gibson Academy   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476245 NJ Essex 13 school 3404230 1210   East Orange 340423000381 210 Wahlstrom Early Childhood Academy   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2476448 NJ Gloucester 15 school 3409600 2990   Mantua Twp 340960002590 50 Sewell Elementary School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2476478 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707006038 30 Grenloch Terrace Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   27.0                                             27
2476594 NJ Hudson 17 school 3416380 5240   Union City 341638000819 145 Eugenio Maria De Hostos Center For Early Childhood Education   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
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
2476800 NJ Middlesex 23 school 3409990 3120   Metuchen Boro 340999003400 90 Mildred B. Moss Elementary School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   12.0                                             12
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
2477017 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003912 80 Morris Avenue Elementry School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477018 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894000333 85 Joseph M. Ferraina Early Childhood Learning Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477020 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003918 120 Lenna W. Conrow Elementary School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2477034 NJ Monmouth 25 school 3409720 3030   Marlboro Twp 340972000454 43 David C Abbott Early Learning Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477166 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004276 50 Milton Elementary School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   15.0                                             15
2477328 NJ Ocean 29 school 3408220 2520   Lakewood Twp 340822003249 300 Lakewood Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477369 NJ Ocean 29 school 3415690 5020   Stafford Twp 341569000796 75 Ronald L. Meinders Primary Learning Center   Regular School No Elementary KG KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477427 NJ Passaic 31 school 3412540 3970   Passaic City 341254004846 110 Ulysses S. Grant School No. 7   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477432 NJ Passaic 31 school 3412540 3970   Passaic City 341254000347 170 Vincent Capuana School No. 15   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2477568 NJ Salem 33 school 3418330 5910   Woodstown-Pilesgrove Reg 341833003250 300 William Roper Early Childhood Learning Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   29.0                                             29
2477803 NJ Union 39 school 3414280 4540   Roselle Boro 341428003166 300 Kindergarten Success Academy   Regular School No Elementary KG KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477829 NJ Union 39 school 3415900 5090   Summit City 341590002987 150 Primary Center At Jefferson   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   12.0                                             12
2477830 NJ Union 39 school 3415900 5090   Summit City 341590002985 160 Primary Center At Wilson   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   21.0                                             21
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
2475492 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000010 10 Atlantic City High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475503 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475504 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475506 NJ Atlantic 1 school 3400006 125   Atlantic Co Special Serv 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475508 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000044 25 Buena Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475515 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456005961 5 Egg Harbor Township High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475530 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000122 40 Absegami High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475531 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000124 50 Oakcrest High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475532 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606003115 60 Cedar Creek High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475537 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000136 50 Hammonton High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475542 NJ Atlantic 1 school 3409360 2910   Mainland Regional 340936000158 50 Mainland Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475549 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000192 50 Pleasantville High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475565 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145005978 2 N. A. Bleshman Regional Day School   Special Education School No Other PK 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475566 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000234 30 Hearing Impaired   Special Education School No Other PK 12 2020   pre_kindergarten_full_day                                                   1.0                                             1

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