enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • pre_kindergarten_full_day · 2,502 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▼ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2475534 2475534 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_full_day                                                   0.0                                             0
2475536 2475536 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000699 30 Hammonton Early Childhood Eductional Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   27.0                                             27
2475599 2475599 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000332 30 County Road School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475915 2475915 NJ Burlington 5 school 3410920 3430   Mount Holly Twp 341092001148 40 John Brainerd Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   1.0                                             1
2476415 2476415 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390000708 30 Central Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   122.0                                             122
2476421 2476421 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002526 130 Pine Acres Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   58.0                                             58
2476443 2476443 NJ Gloucester 15 school 3408880 2750   Logan Twp 340888000443 25 Center Square School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476793 2476793 NJ Middlesex 23 school 3407170 2150   Highland Park Boro 340717003376 70 Irving Primary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   58.0                                             58
2476910 2476910 NJ Middlesex 23 school 3415390 4920   South River Boro 341539000548 70 South River Primary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476913 2476913 NJ Middlesex 23 school 3415540 4970   Spotswood Boro 341554003664 60 G Austin Schoenly Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477240 2477240 NJ Morris 27 school 3412660 4000   Long Hill Twp 341266004464 50 Gillette Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   29.0                                             29
2477327 2477327 NJ Ocean 29 school 3408220 2520   Lakewood Twp 340822004646 90 Spruce Street Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477389 2477389 NJ Passaic 31 school 3401860 420   Bloomingdale Boro 340186004754 20 Martha B. Day Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   6.0                                             6
2477549 2477549 NJ Salem 33 school 3409120 4075   Pennsville 340912005076 90 Valley Park Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477554 2477554 NJ Salem 33 school 3413110 4150   Pittsgrove Twp 341311003113 80 Elmer Elementary School   Regular School No Elementary KG 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477577 2477577 NJ Somerset 35 school 3402100 490   Bound Brook Boro 340210000790 36 Lamonte-Annex Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477664 2477664 NJ Sussex 37 school 3407440 2240   Hopatcong 340744005366 35 Durban Avenue Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477689 2477689 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671006009 23 Cedar Mountain Primary School   Regular School No Elementary KG 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477698 2477698 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153000203 35 Mary Kay Mcmillin Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   52.0                                             52
2477754 2477754 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477880 2477880 NJ Warren 41 school 3406300 1870   Hackettstown 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477894 2477894 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475510 2475510 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000048 45 Collings Lakes Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475511 2475511 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000052 55 John C. Milanesi Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475610 2475610 NJ Bergen 3 school 3404440 1270   Edgewater Boro 340444003211 300 George Washington School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475618 2475618 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000384 70 Memorial School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   42.0                                             42
2475623 2475623 NJ Bergen 3 school 3404740 1370   Englewood City 340474003063 86 Dr. John Grieco Elementary School   Regular School No Elementary 01 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475624 2475624 NJ Bergen 3 school 3404770 1380   Englewood Cliffs Boro 340477000402 40 North Cliff School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475695 2475695 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000570 60 Columbus School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   30.0                                             30
2475696 2475696 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000572 70 Franklin School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   18.0                                             18
2475700 2475700 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000582 120 Washington School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475712 2475712 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014003209 300 Godwin Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   5.0                                             5
2475817 2475817 NJ Bergen 3 school 3416620 5330   Upper Saddle River Boro 341662000884 70 Robert D Reynolds Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   24.0                                             24
2475845 2475845 NJ Burlington 5 school 3402030 475   Bordentown Regional 340203005925 60 Clara Barton Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475849 2475849 NJ Burlington 5 school 3402430 600   Burlington City 340243000968 40 Captain James Lawrence Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475850 2475850 NJ Burlington 5 school 3402430 600   Burlington City 340243000974 80 Samuel Smith Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475858 2475858 NJ Burlington 5 school 3402460 620   Burlington Twp 340246001010 30 B. Bernice Young Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   7.0                                             7
2475864 2475864 NJ Burlington 5 school 3403120 840   Cinnaminson Twp 340312001026 55 New Albany Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   16.0                                             16
2475871 2475871 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001050 50 Millbridge Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   65.0                                             65
2475892 2475892 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918001098 50 Florence L. Walther School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475894 2475894 NJ Burlington 5 school 3409510 2960   Mansfield Twp 340951001100 30 John Hydock Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475898 2475898 NJ Burlington 5 school 3409660 3010   Maple Shade Twp 340966001108 90 Howard R. Yocum Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475901 2475901 NJ Burlington 5 school 3409840 3070   Medford Lakes Boro 340984001116 50 Nokomis School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   26.0                                             26
2475937 2475937 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001208 85 Howard L. Emmons   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475938 2475938 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001210 90 Harker-Wylie School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475944 2475944 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281003399 301 Isaiah Haines   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475953 2475953 NJ Burlington 5 school 3415420 4930   Southampton Township School District 341542001242 50 Southampton Township School #1   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475971 2475971 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001300 40 Haviland Avenue School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   19.0                                             19
2476106 2476106 NJ Camden 7 school 3417250 5560   Waterford Twp 341725001686 40 Atco Elementary School   Regular School No Elementary 01 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476130 2476130 NJ Cape May 9 school 3409150 2840   Lower Twp 340915006054 80 Carl T. Mitnick School   Regular School No Elementary 01 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476132 2476132 NJ Cape May 9 school 3410020 3130   Middle Twp 341002001734 80 Middle Township Elementary #1   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476142 2476142 NJ Cape May 9 school 3416650 5340   Upper Twp 341665006104 55 Upper Township Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476256 2476256 NJ Essex 13 school 3405940 1750   Glen Ridge Boro 340594002096 70 Forest Avenue School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476258 2476258 NJ Essex 13 school 3405940 1750   Glen Ridge Boro 340594005963 80 Linden Avenue School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476259 2476259 NJ Essex 13 school 3405940 1750   Glen Ridge Boro 340594003475 300 Central School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476296 2476296 NJ Essex 13 school 3410560 3310   Montclair Town 341056002180 130 Nishuane Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476385 2476385 NJ Essex 13 school 3415330 4900   South Orange-Maplewood 341533002434 100 Marshall Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476423 2476423 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   24.0                                             24
2476427 2476427 NJ Gloucester 15 school 3405430 1590   Franklin Twp 340543002546 80 Mary F. Janvier School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   39.0                                             39
2476457 2476457 NJ Gloucester 15 school 3412720 4020   Paulsboro Boro 341272002610 60 Billingsport Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476468 2476468 NJ Gloucester 15 school 3415990 5120   Swedesboro-Woolwich 341599000709 50 Governor Charles C. Stratton   Regular School No Elementary 01 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476486 2476486 NJ Gloucester 15 school 3417430 5620   West Deptford Twp 341743002670 100 Oakview Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476487 2476487 NJ Gloucester 15 school 3417430 5620   West Deptford Twp 341743002672 111 Red Bank Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476598 2476598 NJ Hudson 17 school 3417310 5580   Weehawken Twp 341731002930 70 Daniel Webster School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476617 2476617 NJ Hunterdon 19 school 3403360 920   Clinton Twp 340336006027 35 Patrick Mcgaheran   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476658 2476658 NJ Mercer 21 school 3404320 1245   East Windsor Regional 340432003056 55 Ethel Mcknight Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476662 2476662 NJ Mercer 21 school 3404320 1245   East Windsor Regional 340432003064 80 Walter C. Black Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476706 2476706 NJ Mercer 21 school 3480200 3103   Mercer County Special Services School District 348020005952 50 Joseph F. Cappello School   Special Education School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476748 2476748 NJ Mercer 21 school 3417700 5715   W Windsor-Plainsboro Reg 341770000505 130 Town Center Elementary School At Plainsboro   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476780 2476780 NJ Middlesex 23 school 3404500 1290   Edison Twp 340450003344 92 James Madison Primary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476821 2476821 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003440 10 Barclay Brook School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   12.0                                             12
2476870 2476870 NJ Middlesex 23 school 3412930 4090   Perth Amboy City 341293003467 301 Rose M. Lopez Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476954 2476954 NJ Monmouth 25 school 3403450 945   Colts Neck Twp 340345000513 60 Conover Road Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   24.0                                             24
2476958 2476958 NJ Monmouth 25 school 3404410 1260   Eatontown Boro 340441003772 80 Meadowbrook   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476994 2476994 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000721 3 Adelphia Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476997 2476997 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000722 12 Greenville Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476998 2476998 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003864 20 Edith M. Griebling Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477001 2477001 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003866 30 Land O'Pines Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   80.0                                             80
2477005 2477005 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003874 60 Taunton Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477066 2477066 NJ Monmouth 25 school 3410230 3200   Millstone Twp 341023002931 80 Millstone Township Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   24.0                                             24
2477108 2477108 NJ Monmouth 25 school 3416200 5185   Tinton Falls 341620004112 30 Mahala F. Atchison School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   4.0                                             4
2477126 2477126 NJ Morris 27 school 3401950 450   Boonton Town 340195004158 40 School Street School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477139 2477139 NJ Morris 27 school 3403060 820   Chester Twp 340306006026 40 Dickerson Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   18.0                                             18
2477149 2477149 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004226 35 Frank J Smith Elementary   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477151 2477151 NJ Morris 27 school 3405250 1530   Florham Park Boro 340525004234 15 Briarwood School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   20.0                                             20
2477163 2477163 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004270 33 Cozy Lake Elementary School   Regular School No Elementary 01 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477164 2477164 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004272 40 Ellen T. Briggs Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477169 2477169 NJ Morris 27 school 3408040 2460   Kinnelon Boro 340804004284 60 Kiel Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   19.0                                             19
2477201 2477201 NJ Morris 27 school 3410770 3380   Morris Plains Boro 341077004362 30 Mountain Way School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477204 2477204 NJ Morris 27 school 3410810 3385   Morris School District 341081004370 65 Alfred Vail School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477207 2477207 NJ Morris 27 school 3410810 3385   Morris School District 341081004378 90 Hillcrest School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477211 2477211 NJ Morris 27 school 3410810 3385   Morris School District 341081004388 115 Woodland School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477212 2477212 NJ Morris 27 school 3410860 3410   Mount Arlington Boro 341086004392 45 Edith M. Decker Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   5.0                                             5
2477329 2477329 NJ Ocean 29 school 3408220 2520   Lakewood Twp 340822003357 301 Piner Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477332 2477332 NJ Ocean 29 school 3408700 2690   Little Egg Harbor Twp 340870004650 50 George J. Mitchell Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477334 2477334 NJ Ocean 29 school 3408910 2760   Long Beach Island 340891004654 20 Ethel A. Jacobsen Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   9.0                                             9
2477367 2477367 NJ Ocean 29 school 3415690 5020   Stafford Twp 341569000343 65 Ocean Acres Elementary School   Regular School No Elementary 01 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477418 2477418 NJ Passaic 31 school 3408730 2700   Little Falls Twp 340873004824 60 Little Falls Township Public School # 2   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   19.0                                             19
2477455 2477455 NJ Passaic 31 school 3412690 4010   Paterson City 341269004870 45 Dale Avenue   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477506 2477506 NJ Passaic 31 school 3416260 5200   Totowa Boro 341626004952 50 Memorial School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   31.0                                             31

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