Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 2,502

grade

  • pre_kindergarten_half_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
2478878 NJ Essex 13 school 3412270 3880   City Of Orange Twp 341227002410 115 Orange Preparatory Academy   Regular School No Secondary 08 09 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479238 NJ Mercer 21 school 3416290 5210   Trenton Public School District 341629003449 302 Trenton Central High School-9th Grade Academy   Regular School No Secondary 09 09 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479264 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003296 55 Churchill Jr High School   Regular School No Secondary 08 09 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478002 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   30.0                                             30
2478028 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000114 40 Pomona Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   66.0                                             66
2478060 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_half_day                                                   68.0                                             68
2478150 NJ Bergen 3 school 3405760 1700   Garfield City 340576006110 40 Garfield Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   241.0                                             241
2478155 NJ Bergen 3 school 3405760 1700   Garfield City 340576000386 86 Garfield Public Preschool Annex   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   150.0                                             150
2478161 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_half_day                                                   105.0                                             105
2478274 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000221 80 Glen School   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   53.0                                             53
2478298 NJ Bergen 3 school 3414490 4610   Saddle Brook Twp 341449000119 100 Washington School   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   16.0                                             16
2478445 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281003167 300 Pemberton Early Childhood Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   403.0                                             403
2478487 NJ Camden 7 school 3402640 680   Camden City 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   292.0                                             292
2478495 NJ Camden 7 school 3402640 680   Camden City 340264006084 175 Riletta Twyne Cream Family School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   122.0                                             122
2478535 NJ Camden 7 school 3403420 940   Collingswood Boro 340342003485 300 Collingswood Pre School At Oaklyn   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   54.0                                             54
2478577 NJ Camden 7 school 3408640 2670   Lindenwold Boro 340864003271 300 Lindenwold Preschool Building   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   186.0                                             186
2478585 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287001622 90 Baldwin Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   98.0                                             98
2478658 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_half_day                                                   672.0                                             672
2478673 NJ Cumberland 11 school 3410320 3230   Millville City 341032001874 68 Child Family Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   601.0                                             601
2478691 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_half_day                                                   301.0                                             301
2478713 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_half_day                                                   109.0                                             109
2478763 NJ Essex 13 school 3407680 2330   Irvington Township 340768002949 71 Augusta Preschool Academy   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   323.0                                             323
2478823 NJ Essex 13 school 3411340 3570   Newark City 341134003153 306 Early Childhood School - South   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   177.0                                             177
2478825 NJ Essex 13 school 3411340 3570   Newark City 341134003193 308 Early Childhood School - West   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   125.0                                             125
2478827 NJ Essex 13 school 3411340 3570   Newark City 341134003281 314 Early Childhood School - Central   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   166.0                                             166
2478828 NJ Essex 13 school 3411340 3570   Newark City 341134003327 316 Early Childhood School - North   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   130.0                                             130
2478880 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_half_day                                                   111.0                                             111
2478891 NJ Essex 13 school 3415330 4900   South Orange-Maplewood 341533003339 300 Montrose Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   127.0                                             127
2478911 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_half_day                                                   0.0                                             0
2479018 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_half_day                                                   101.0                                             101
2479103 NJ Hudson 17 school 3417580 5670   West New York Town 341758000445 55 Early Childhood School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   452.0                                             452
2479118 NJ Hunterdon 19 school 3403360 920   Clinton Twp 340336002968 30 Spruce Run   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   32.0                                             32
2479364 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_half_day                                                   697.0                                             697
2479365 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_half_day                                                   356.0                                             356
2479481 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564006120 70 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   75.0                                             75
2479510 NJ Monmouth 25 school 3407860 2400   Keansburg Boro 340786003882 40 Port Monmouth Road School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   201.0                                             201
2479542 NJ Monmouth 25 school 3409750 3040   Matawan-Aberdeen Regional 340975000723 40 Cambridge Park Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   120.0                                             120
2479585 NJ Monmouth 25 school 3411160 3510   Neptune Twp 341116000457 59 Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   175.0                                             175
2479622 NJ Monmouth 25 school 3416890 5420   Wall Twp 341689000099 78 Wall Primary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479708 NJ Morris 27 school 3410810 3385   Morris School District 341081004376 85 Lafayette Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   98.0                                             98
2479793 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_half_day                                                   258.0                                             258
2479835 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_half_day                                                   321.0                                             321
2479867 NJ Ocean 29 school 3415690 5020   Stafford Twp 341569004716 50 Oxycocus Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   69.0                                             69
2479911 NJ Passaic 31 school 3403300 900   Clifton City 340330003436 301 Clifton Early Learner Academies   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   235.0                                             235
2479935 NJ Passaic 31 school 3412540 3970   Passaic City 341254000403 180 School No.16   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   487.0                                             487
2479984 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   93.0                                             93
2480053 NJ Salem 33 school 3413110 4150   Pittsgrove Twp 341311005082 50 Norma Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   118.0                                             118
2480195 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671005428 50 Walnut Ridge Primary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480207 NJ Union 39 school 3403150 850   Clark Twp 340315003295 300 Clark Preschool Annex   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   6.0                                             6
2480243 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_half_day                                                   297.0                                             297
2480244 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_half_day                                                   298.0                                             298
2480245 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_half_day                                                   299.0                                             299
2480304 NJ Union 39 school 3414280 4540   Roselle Boro 341428003147 120 Roselle Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   45.0                                             45
2478067 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_half_day                                                   1.0                                             1
2478068 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000234 30 Hearing Impaired   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   7.0                                             7
2478069 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145006020 40 Multiply Handicapped   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   1.0                                             1
2478070 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000238 50 Emotionally Disturbed   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478071 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000240 70 Life Skills   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478072 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000073 100 Autistic   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   1.0                                             1
2478266 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377000750 100 Slocum Skewes School   Regular School No Other 01 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478355 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244000982 30 Westampton Campus   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   4.0                                             4
2478554 NJ Camden 7 school 3400772 1802   Mastery Schools Of Camden, Inc. 340077203313 112 Mastery Schools Of Camden Inc.   Regular School No Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478750 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478802 NJ Essex 13 school 3411340 3570   Newark City 341134005985 4 Nj Regional Day School - Newark   Special Education School No Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478843 NJ Essex 13 school 3411340 3570   Newark City 341134002296 477 John F. Kennedy School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478937 NJ Gloucester 15 school 3480363 1774   Gloucester Co Spec Serv 348036300413 15 Bankbridge Regional School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   5.0                                             5
2479029 NJ Hudson 17 school 3407830 2390   Jersey City 340783005980 11 Regional Day School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479308 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018005991 6 Piscataway Regional Day School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479309 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018005951 30 Academy Learning Center   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   3.0                                             3
2479310 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018002926 31 Center For Lifelong Learning   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479311 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018000799 90 Nuview Academy   Special Education School No Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479450 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Comm 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479693 NJ Morris 27 school 3480260 3364   Educ Serv Comm Morris Co 348026000519 85 Central Park School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2479838 NJ Ocean 29 school 3409450 2940   Manchester Twp 340945005983 8 Manchester Regional Day School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   2.0                                             2
2479970 NJ Passaic 31 school 3412690 4010   Paterson City 341269004894 150 Newcomers   Regular School No Other 03 09 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480061 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103297 9 Salem Campus   Special Education School No Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480062 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036106102 50 Daretown School   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480063 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480188 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480336 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640005726 30 Westlake   Special Education School No Other 04 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480407 NJ Charters 80 school 3400715 6013   Bergen Arts And Sciences Charter School 340071502923 900 Bergen Arts And Sciences Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480408 NJ Charters 80 school 3400717 6017   Foundation Academy Cs 340071702925 932 Foundation Academy Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480409 NJ Charters 80 school 3400090 6018   Central Jersey College Prep Charter School 340009000829 900 Central Jersey College Prep Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480415 NJ Charters 80 school 3400729 6028   Vineland Public Charter School 340072903027 910 Vineland Public Charter School   Regular School Yes Other PK 11 2020   pre_kindergarten_half_day                                                   34.0                                             34
2480422 NJ Charters 80 school 3400751 6053   Great Oaks Legacy Charter School 340075103180 917 Great Oaks Legacy Charter School   Regular School Yes Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480428 NJ Charters 80 school 3400749 6069   Millville Public Charter School 340074903184 952 Millville Public Charter School   Regular School Yes Other KG 10 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480431 NJ Charters 80 school 3400745 6080   Passaic Arts And Science Charter School 340074503137 966 Passaic Arts And Science Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480432 NJ Charters 80 school 3400746 6081   Thomas Edison Energysmart Charter School 340074603143 967 Thomas Edison Energysmart Charter School   Regular School Yes Other KG 11 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480433 NJ Charters 80 school 3400759 6082   Beloved Community Charter School 340075903196 963 Beloved Community Charter School   Regular School Yes Other KG 09 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480438 NJ Charters 80 school 3400765 6096   Paterson Arts And Science Charter School 340076503254 982 Paterson Arts And Science Charter School   Regular School Yes Other KG 11 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480441 NJ Charters 80 school 3400779 6101   College Achieve Central Charter School 340077903353 992 College Achieve Central Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480447 NJ Charters 80 school 3400785 6107   Camden’S Promise Charter School 340078503390 998 Camden'S Promise Charter School   Regular School Yes Other PK 12 2020   pre_kindergarten_half_day                                                   60.0                                             60
2480453 NJ Charters 80 school 3400080 6240   Freedom Prep Charter School 340008000566 900 Freedom Prep Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480460 NJ Charters 80 school 3400032 6720   Hoboken Cs 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480465 NJ Charters 80 school 3400078 7109   Leap Academy University Cs 340007800487 931 Leap Academy University Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480467 NJ Charters 80 school 3400022 7210   Marion P. Thomas Cs 340002200285 940 Marion P. Thomas Charter School   Regular School Yes Other PK 12 2020   pre_kindergarten_half_day                                                   70.0                                             70
2480469 NJ Charters 80 school 3400024 7320   North Star Academy Charter School 340002400289 960 North Star Academy Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480470 NJ Charters 80 school 3400070 7325   Team Academy Charter School 340007000529 965 Team Academy Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480473 NJ Charters 80 school 3400087 7503   Paterson Cs For Sci/Tech 340008700735 970 Paterson Charter School For Science/Technology   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480489 NJ Charters 80 school 3400083 8010   Union County Teams Cs 340008300573 980 Union County Teams Charter School   Regular School Yes Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);