enrollments

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_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,402 ✖

grade ✖

  • pre_kindergarten_half_day · 2,402 ✖
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
2478012 2478012 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000048 45 Collings Lakes Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   55.0                                             55
2478013 2478013 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000052 55 John C. Milanesi Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   57.0                                             57
2478014 2478014 NJ Atlantic 1 school 3402400 590   Buena Regional 340240003221 300 Dr. J.P. Cleary Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478015 2478015 NJ Atlantic 1 school 3404530 1300   Egg Harbor City 340453000074 20 Charles L. Spragg School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   45.0                                             45
2478016 2478016 NJ Atlantic 1 school 3404530 1300   Egg Harbor City 340453000076 30 Egg Harbor City Community School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478017 2478017 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_half_day                                                   0.0                                             0
2478018 2478018 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000086 33 Clayton J. Davenport Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478019 2478019 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000051 35 E. H. Slaybaugh Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478020 2478020 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002953 38 Alder Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478021 2478021 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002955 39 Fernwood Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478022 2478022 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000698 45 Dr. Joyanne D. Miller Elementary School   Regular School No Elementary 04 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478023 2478023 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000092 50 H. Russel Swift Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478024 2478024 NJ Atlantic 1 school 3404860 1410   Estell Manor City 340486000102 50 Estell Manor Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478025 2478025 NJ Atlantic 1 school 3405280 1540   Folsom Boro 340528000104 50 Folsom Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   16.0                                             16
2478026 2478026 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000108 15 Arthur Rann Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478027 2478027 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000383 16 Galloway Township Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478029 2478029 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006028 45 Reeds Road Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478030 2478030 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006088 46 Roland Rogers Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   22.0                                             22
2478031 2478031 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006089 48 Smithville Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   29.0                                             29
2478032 2478032 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000122 40 Absegami High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478033 2478033 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000124 50 Oakcrest High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478034 2478034 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_half_day                                                   0.0                                             0
2478035 2478035 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000015 55 George L. Hess Educational Complex   Regular School No Elementary 02 05 2020   pre_kindergarten_half_day                                                   89.0                                             89
2478036 2478036 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000130 60 Joseph C Shaner Memorial Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   119.0                                             119
2478037 2478037 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651006029 120 William Davies Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478038 2478038 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000699 30 Hammonton Early Childhood Eductional Center   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478039 2478039 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000136 50 Hammonton High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478040 2478040 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000138 55 Warren E. Sooy Jr. Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478041 2478041 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000140 60 Hammonton Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478042 2478042 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000144 20 Belhaven Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478043 2478043 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000150 50 Seaview Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   11.0                                             11
2478044 2478044 NJ Atlantic 1 school 3409360 2910   Mainland Regional 340936000158 50 Mainland Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478045 2478045 NJ Atlantic 1 school 3409690 3020   Margate City 340969000162 10 Eugene A. Tighe Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478046 2478046 NJ Atlantic 1 school 3409690 3020   Margate City 340969000393 25 William H. Ross Iii School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478047 2478047 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000172 20 Mullica Township Primary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   56.0                                             56
2478048 2478048 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000174 25 Mullica Township Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478049 2478049 NJ Atlantic 1 school 3411790 3720   Northfield City 341179000215 56 Northfield Community Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478050 2478050 NJ Atlantic 1 school 3411790 3720   Northfield City 341179000217 57 Northfield Community Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   20.0                                             20
2478051 2478051 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000192 50 Pleasantville High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   28.0                                             28
2478052 2478052 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000219 55 Pleasantville Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478053 2478053 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000194 60 Washington Avenue Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478054 2478054 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000198 80 Leeds Avenue Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   99.0                                             99
2478055 2478055 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000200 85 North Main Street Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   77.0                                             77
2478056 2478056 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000202 95 South Main Street Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   29.0                                             29
2478057 2478057 NJ Atlantic 1 school 3413380 4240   Port Republic City 341338000204 50 Port Republic Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478058 2478058 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000208 50 Dawes Avenue Elementary School   Regular School No Elementary KG 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478059 2478059 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000210 55 Jordan Road Elementary School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478060 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
2478061 2478061 NJ Atlantic 1 school 3416680 5350   Ventnor City 341668000216 40 Ventnor Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478062 2478062 NJ Atlantic 1 school 3416680 5350   Ventnor City 341668000407 45 Ventnor Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   72.0                                             72
2478063 2478063 NJ Atlantic 1 school 3417850 5760   Weymouth Twp 341785000220 20 Weymouth Township Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   11.0                                             11
2478064 2478064 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000224 10 Brookside School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478065 2478065 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000226 20 Hillside Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478066 2478066 NJ Bergen 3 school 3400870 80   Alpine Boro 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478078 2478078 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000268 20 Bergenfield High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478079 2478079 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000270 40 Franklin Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   15.0                                             15
2478080 2478080 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000272 50 Hoover Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   14.0                                             14
2478081 2478081 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000274 60 Jefferson Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478082 2478082 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000276 70 Lincoln Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   2.0                                             2
2478083 2478083 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000278 75 Roy W. Brown Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478084 2478084 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000280 80 Washington Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478085 2478085 NJ Bergen 3 school 3401920 440   Bogota Boro 340192000284 20 Bogota Jr./Sr. High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478086 2478086 NJ Bergen 3 school 3401920 440   Bogota Boro 340192000286 30 E. Roy Bixby   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   4.0                                             4
2478087 2478087 NJ Bergen 3 school 3401920 440   Bogota Boro 340192000290 50 Lillian M. Steen   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   14.0                                             14
2478088 2478088 NJ Bergen 3 school 3402790 740   Carlstadt Boro 340279000813 50 Carlstadt Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   2.0                                             2
2478089 2478089 NJ Bergen 3 school 3402800 745   Carlstadt-East Rutherford 340280000300 50 Henry P. Becton Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478090 2478090 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000304 30 Cliffside Park High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478091 2478091 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000306 50 School #3   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478092 2478092 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000308 60 School #4   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478093 2478093 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000310 70 School #5   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   30.0                                             30
2478094 2478094 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000312 80 School #6/Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478095 2478095 NJ Bergen 3 school 3403390 930   Closter Boro 340339000316 50 Hillside Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   23.0                                             23
2478096 2478096 NJ Bergen 3 school 3403390 930   Closter Boro 340339000318 60 Tenakill Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478097 2478097 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000324 40 Cresskill High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478098 2478098 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360002993 45 Cresskill Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478099 2478099 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000326 50 Edward H. Bryan   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478100 2478100 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000328 60 Merritt Memorial   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478101 2478101 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000332 30 County Road School   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   45.0                                             45
2478102 2478102 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000334 40 Demarest Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478103 2478103 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381006085 50 Luther Lee Emerson School   Regular School No Elementary 02 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478104 2478104 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000340 40 Dumont High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478105 2478105 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000342 50 Grant Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478106 2478106 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000344 60 Honiss Elementary\Middle School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478107 2478107 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000346 70 Lincoln Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478108 2478108 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000348 80 Selzer Elementary\Middle School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478109 2478109 NJ Bergen 3 school 3404290 1230   East Rutherford Boro 340429000352 40 Alfred S. Faust   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478110 2478110 NJ Bergen 3 school 3404290 1230   East Rutherford Boro 340429000474 80 Mckenzie School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   25.0                                             25
2478111 2478111 NJ Bergen 3 school 3404440 1270   Edgewater Boro 340444000362 50 Eleanor Van Gelder   Regular School No Elementary 03 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478112 2478112 NJ Bergen 3 school 3404440 1270   Edgewater Boro 340444003211 300 George Washington School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   80.0                                             80
2478113 2478113 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000368 50 Memorial Senior High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478114 2478114 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000075 60 Memorial Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478115 2478115 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000372 70 Gantner Avenue School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478116 2478116 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000374 80 Gilbert Avenue School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478117 2478117 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000376 90 Sixteenth Avenue School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   15.0                                             15
2478118 2478118 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000380 50 Emerson Jr Sr High   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478119 2478119 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000382 60 Patrick M Villano School   Regular School No Elementary 03 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478120 2478120 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000384 70 Memorial School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478121 2478121 NJ Bergen 3 school 3404740 1370   Englewood City 340474000388 40 Dwight Morrow High School/Academies@Englewood   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478122 2478122 NJ Bergen 3 school 3404740 1370   Englewood City 340474000390 60 Dr. Leroy Mccloud Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478123 2478123 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_half_day                                                   232.0                                             232

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