Data source: Big Local News · About: Big Local

5,007 rows where grade = "pre_kindergarten_half_day" and state = "NJ" sorted by rowid descending

View and edit SQL

year

grade

  • pre_kindergarten_half_day · 5,007
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
2480493 NJ Charters 80 school 3400046 8140   Village Cs 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480492 NJ Charters 80 school 3400084 8065   University Heights Cs 340008400575 980 University Heights Charter School   Regular School Yes Elementary PK 08 2020   pre_kindergarten_half_day                                                   120.0                                             120
2480491 NJ Charters 80 school 3400073 8060   University Academy Cs 340007300531 990 University Academy Charter High School   Regular School Yes High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480490 NJ Charters 80 school 3400051 8050   Unity Cs 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 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
2480488 NJ Charters 80 school 3400805 7897   Creativity Colaboratory Charter School 340080503481 923 Creativity Colaboratory Charter School   Regular School Yes Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480487 NJ Charters 80 school 3400795 7896   Middlesex Charter School 340079503451 923 Middlesex County Stem Charter School   Regular School Yes Elementary KG 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480486 NJ Charters 80 school 3400794 7895   Achievers Early College Prep Charter School 340079403457 920 Achievers Early College Prep Charter School   Regular School Yes Middle 06 07 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480485 NJ Charters 80 school 3400789 7893   Ocean Academy Charter School 340078903411 918 Ocean Academy Charter School   Regular School Yes Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480484 NJ Charters 80 school 3400793 7892   College Achieve Paterson Charter School 340079303413 909 College Achieve Paterson Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480483 NJ Charters 80 school 3400791 7891   College Achieve Greater Asbury Park Charter School 340079103403 904 College Achieve Greater Asbury Park Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480482 NJ Charters 80 school 3400015 7890   Teaneck Community Cs 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480481 NJ Charters 80 school 3400055 7850   Sussex County Technology Charter School 340005500361 960 Sussex County Technology Charter School   Regular School Yes Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480480 NJ Charters 80 school 3400036 7830   Soaring Heights Cs 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480479 NJ Charters 80 school 3400026 7735   Maria L. Varisco-Rogers Cs 340002600292 975 Maria Varisco Rogers Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480478 NJ Charters 80 school 3400025 7730   Robert Treat Academy Cs 340002500291 970 Robert Treat Academy Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480477 NJ Charters 80 school 3400082 7727   Ridge And Valley Cs 340008200569 900 Ridge And Valley Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480476 NJ Charters 80 school 3400049 7720   The Red Bank Cs 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2020   pre_kindergarten_half_day                                                   20.0                                             20
2480475 NJ Charters 80 school 3400061 7600   Queen City Academy Cs 340006100378 960 The Queen City Academy Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480474 NJ Charters 80 school 3400043 7540   Princeton Cs 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 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
2480472 NJ Charters 80 school 3400042 7500   Pace Cs Of Hamilton 340004200322 900 Pace Charter School Of Hamilton   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480471 NJ Charters 80 school 3400019 7410   Charter~Tech High School 340001900269 940 Chartertech High School For The Performing Arts   Regular School Yes High 09 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
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
2480468 NJ Charters 80 school 3400023 7290   New Horizons Comm. Cs 340002300287 957 New Horizons Community Charter School   Regular School Yes Elementary KG 08 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
2480466 NJ Charters 80 school 3400035 7115   Learning Community Cs 340003500307 960 Learning Community Charter School   Regular School Yes Elementary PK 08 2020   pre_kindergarten_half_day                                                   44.0                                             44
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
2480464 NJ Charters 80 school 3400034 6915   Jersey City Golden Door Charter School 340003400305 950 Jersey City Golden Door Charter School   Regular School Yes Elementary PK 08 2020   pre_kindergarten_half_day                                                   43.0                                             43
2480463 NJ Charters 80 school 3400033 6910   Jersey City Comm. Cs 340003300303 940 Jersey City Community Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480462 NJ Charters 80 school 3400041 6810   International Charter School 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480461 NJ Charters 80 school 3400076 6740   Hope Academy Cs 340007600483 950 Hope Academy Charter School   Regular School Yes Elementary KG 08 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
2480459 NJ Charters 80 school 3400064 6665   Gray Cs 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480458 NJ Charters 80 school 3400047 6635   Greater Brunswick Cs 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480457 NJ Charters 80 school 3400014 6430   Englewood On The Palisades Charter School 340001400258 930 Englewood On The Palisades Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480456 NJ Charters 80 school 3400029 6420   Elysian Cs Of Hoboken 340002900297 925 Elysian Charter School Of Hoboken   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480455 NJ Charters 80 school 3400021 6410   East Orange Community Cs 340002100283 920 East Orange Community Charter School   Regular School Yes Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480454 NJ Charters 80 school 3400020 6320   Discovery Cs 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
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
2480452 NJ Charters 80 school 3400079 6232   Environment Community Cs 340007906129 920 Environment Community Opportunity (Eco) Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480451 NJ Charters 80 school 3400052 6230   Classical Academy Charter School Of Clifton 340005200351 915 Classical Academy Charter School Of Clifton   Regular School Yes Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480450 NJ Charters 80 school 3400770 6183   Trenton Stem-To-Civics Cs 340077003291 914 Trenton Stem-To-Civics Charter School   Regular School Yes High 06 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480449 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480448 NJ Charters 80 school 3400788 6109   Lead Charter School 340078803423 953 Lead Charter School   Regular School Yes High 09 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
2480446 NJ Charters 80 school 3400784 6106   Philip’S Charter School Of Paterson 340078403383 997 Philip'S Academy Charter School Of Paterson   Regular School Yes Elementary KG 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480445 NJ Charters 80 school 3400787 6105   Hudson Arts And Science Charter School 340078703387 996 Hudson Arts And Science Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480444 NJ Charters 80 school 3400783 6104   Principle Academy Charter School 340078303345 995 Principle Academy Charter School   Regular School Yes Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480443 NJ Charters 80 school 3400781 6103   Empowerment Academy Charter School 340078103335 994 Empowerment Academy Charter School   Regular School Yes Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480442 NJ Charters 80 school 3400786 6102   Cresthaven Academy Charter School 340078603385 993 Cresthaven Academy Charter School   Regular School Yes Elementary KG 03 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
2480440 NJ Charters 80 school 3400782 6100   Bridgeton Public Charter School 340078203371 991 Bridgeton Public Charter School   Regular School Yes Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480439 NJ Charters 80 school 3400773 6099   Link Community Charter School 340077303275 986 Link Community Charter School   Regular School Yes Middle 05 08 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
2480437 NJ Charters 80 school 3400764 6094   Phillip'S Academy Charter School 340076403256 968 Philip'S Academy Charter School   Regular School Yes Elementary PK 08 2020   pre_kindergarten_half_day                                                   60.0                                             60
2480436 NJ Charters 80 school 3400767 6093   Jersey City Global Cs 340076703251 981 Jersey City Global Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480435 NJ Charters 80 school 3400766 6089   Compass Academy Cs 340076603265 976 Compass Academy Charter School   Regular School Yes Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480434 NJ Charters 80 school 3400763 6086   Hope Community Cs 340076303247 972 Hope Community Charter School   Regular School Yes Elementary KG 05 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
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
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
2480430 NJ Charters 80 school 3400748 6079   John P Holland Charter School 340074803144 964 John P. Holland Charter School   Regular School Yes Elementary PK 08 2020   pre_kindergarten_half_day                                                   88.0                                             88
2480429 NJ Charters 80 school 3400744 6076   Benjamin Banneker Prep Cs 340074403139 961 Benjamin Banneker Preparatory Charter School   Regular School Yes Elementary KG 08 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
2480427 NJ Charters 80 school 3400753 6068   M E T S Charter School 340075303183 951 M.E.T.S. Charter School   Regular School Yes High 06 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480426 NJ Charters 80 school 3400756 6064   Dr Lena Edwards Academic Charter School 340075603185 946 Dr Lena Edwards Academic Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480425 NJ Charters 80 school 3400771 6060   Atlantic Community Charter School 340077103287 942 Atlantic Community Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480424 NJ Charters 80 school 3400755 6058   Roseville Community Cs 340075503187 939 Roseville Community Charter School   Regular School Yes Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480423 NJ Charters 80 school 3400754 6057   Peoples Preparatory Charter School 340075403181 938 Peoples Preparatory Charter School   Regular School Yes High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
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
2480421 NJ Charters 80 school 3400735 6041   Hatikvah International Cs 340073503055 916 Hatikvah International Academy Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480420 NJ Charters 80 school 3400734 6036   Hola Hoboken Dual Lang Cs 340073403037 921 Hoboken Dual Language Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480419 NJ Charters 80 school 3400740 6033   The Barack Obama Green Charter High School 340074003047 902 The Barack Obama Green Charter High School   Regular School Yes High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480418 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480417 NJ Charters 80 school 3400727 6030   The Ethical Community Charter School 340072703029 912 The Ethical Community Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480416 NJ Charters 80 school 3400730 6029   Newark Educators Community Charter School 340073003028 911 Newark Educators Community Charter School   Regular School Yes Elementary PK 04 2020   pre_kindergarten_half_day                                                   41.0                                             41
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
2480414 NJ Charters 80 school 3400731 6026   Riverbank Charter School Of Excelle 340073103022 908 Riverbank Charter School Of Excellence   Regular School Yes Elementary KG 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480413 NJ Charters 80 school 3400723 6025   Paul Robeson Humanities Charter School 340072303015 907 Paul Robeson Charter School For The Humanities   Regular School Yes Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480412 NJ Charters 80 school 3400724 6022   Burch Charter School Of Excellence 340072403011 990 Burch Charter School Of Excellence   Regular School Yes Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480411 NJ Charters 80 school 3400718 6021   Community Charter School Of Paterso 340071803014 905 Community Charter School Of Paterson   Regular School Yes Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480410 NJ Charters 80 school 3400719 6020   Pride Academy Charter School 340071903017 985 Pride Academy Charter School   Regular School Yes Middle 05 08 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
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
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
2480406 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480405 NJ Warren 41 school 3417910 5780   White Twp 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480404 NJ Warren 41 school 3417160 5530   Washington Twp 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480403 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480402 NJ Warren 41 school 3417010 5480   Washington Boro 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   34.0                                             34
2480401 NJ Warren 41 school 3417010 5480   Washington Boro 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480400 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480399 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480398 NJ Warren 41 school 3417920 5460   Warren County Vocational 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480397 NJ Warren 41 school 3413260 4200   Pohatcong Twp 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480396 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   241.0                                             241
2480395 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480394 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 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]);