enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "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 ✖

  • 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
2480538 2480538 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000130 60 Joseph C Shaner Memorial Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   264.0                                             264
2480540 2480540 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000699 30 Hammonton Early Childhood Eductional Center   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   168.0                                             168
2480603 2480603 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000332 30 County Road School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   54.0                                             54
2480919 2480919 NJ Burlington 5 school 3410920 3430   Mount Holly Twp 341092001148 40 John Brainerd Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   104.0                                             104
2481419 2481419 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390000708 30 Central Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   199.0                                             199
2481425 2481425 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002526 130 Pine Acres Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   84.0                                             84
2481447 2481447 NJ Gloucester 15 school 3408880 2750   Logan Twp 340888000443 25 Center Square School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   53.0                                             53
2481797 2481797 NJ Middlesex 23 school 3407170 2150   Highland Park Boro 340717003376 70 Irving Primary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   111.0                                             111
2481914 2481914 NJ Middlesex 23 school 3415390 4920   South River Boro 341539000548 70 South River Primary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   141.0                                             141
2481917 2481917 NJ Middlesex 23 school 3415540 4970   Spotswood Boro 341554003664 60 G Austin Schoenly Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   100.0                                             100
2482244 2482244 NJ Morris 27 school 3412660 4000   Long Hill Twp 341266004464 50 Gillette Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   91.0                                             91
2482331 2482331 NJ Ocean 29 school 3408220 2520   Lakewood Twp 340822004646 90 Spruce Street Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   217.0                                             217
2482393 2482393 NJ Passaic 31 school 3401860 420   Bloomingdale Boro 340186004754 20 Martha B. Day Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   63.0                                             63
2482553 2482553 NJ Salem 33 school 3409120 4075   Pennsville 340912005076 90 Valley Park Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   76.0                                             76
2482558 2482558 NJ Salem 33 school 3413110 4150   Pittsgrove Twp 341311003113 80 Elmer Elementary School   Regular School No Elementary KG 01 2020   kindergarten_full_day                                                   105.0                                             105
2482581 2482581 NJ Somerset 35 school 3402100 490   Bound Brook Boro 340210000790 36 Lamonte-Annex Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   117.0                                             117
2482668 2482668 NJ Sussex 37 school 3407440 2240   Hopatcong 340744005366 35 Durban Avenue Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   102.0                                             102
2482693 2482693 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671006009 23 Cedar Mountain Primary School   Regular School No Elementary KG 01 2020   kindergarten_full_day                                                   217.0                                             217
2482702 2482702 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153000203 35 Mary Kay Mcmillin Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   0.0                                             0
2482758 2482758 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   199.0                                             199
2482884 2482884 NJ Warren 41 school 3406300 1870   Hackettstown 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   145.0                                             145
2482898 2482898 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   199.0                                             199
2480514 2480514 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000048 45 Collings Lakes Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   41.0                                             41
2480515 2480515 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000052 55 John C. Milanesi Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   67.0                                             67
2480614 2480614 NJ Bergen 3 school 3404440 1270   Edgewater Boro 340444003211 300 George Washington School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   136.0                                             136
2480622 2480622 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000384 70 Memorial School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   75.0                                             75
2480627 2480627 NJ Bergen 3 school 3404740 1370   Englewood City 340474003063 86 Dr. John Grieco Elementary School   Regular School No Elementary 01 02 2020   kindergarten_full_day                                                   0.0                                             0
2480628 2480628 NJ Bergen 3 school 3404770 1380   Englewood Cliffs Boro 340477000402 40 North Cliff School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   47.0                                             47
2480699 2480699 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000570 60 Columbus School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   51.0                                             51
2480700 2480700 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000572 70 Franklin School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   77.0                                             77
2480704 2480704 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000582 120 Washington School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   74.0                                             74
2480716 2480716 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014003209 300 Godwin Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   66.0                                             66
2480821 2480821 NJ Bergen 3 school 3416620 5330   Upper Saddle River Boro 341662000884 70 Robert D Reynolds Primary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   93.0                                             93
2480849 2480849 NJ Burlington 5 school 3402030 475   Bordentown Regional 340203005925 60 Clara Barton Elementary   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   81.0                                             81
2480853 2480853 NJ Burlington 5 school 3402430 600   Burlington City 340243000968 40 Captain James Lawrence Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   95.0                                             95
2480854 2480854 NJ Burlington 5 school 3402430 600   Burlington City 340243000974 80 Samuel Smith Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   42.0                                             42
2480862 2480862 NJ Burlington 5 school 3402460 620   Burlington Twp 340246001010 30 B. Bernice Young Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   244.0                                             244
2480868 2480868 NJ Burlington 5 school 3403120 840   Cinnaminson Twp 340312001026 55 New Albany Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   0.0                                             0
2480875 2480875 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001050 50 Millbridge Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   201.0                                             201
2480896 2480896 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918001098 50 Florence L. Walther School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   103.0                                             103
2480898 2480898 NJ Burlington 5 school 3409510 2960   Mansfield Twp 340951001100 30 John Hydock Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   84.0                                             84
2480902 2480902 NJ Burlington 5 school 3409660 3010   Maple Shade Twp 340966001108 90 Howard R. Yocum Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   189.0                                             189
2480905 2480905 NJ Burlington 5 school 3409840 3070   Medford Lakes Boro 340984001116 50 Nokomis School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   43.0                                             43
2480941 2480941 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001208 85 Howard L. Emmons   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   103.0                                             103
2480942 2480942 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001210 90 Harker-Wylie School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   86.0                                             86
2480948 2480948 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281003399 301 Isaiah Haines   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   89.0                                             89
2480957 2480957 NJ Burlington 5 school 3415420 4930   Southampton Township School District 341542001242 50 Southampton Township School #1   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   57.0                                             57
2480975 2480975 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001300 40 Haviland Avenue School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   81.0                                             81
2481110 2481110 NJ Camden 7 school 3417250 5560   Waterford Twp 341725001686 40 Atco Elementary School   Regular School No Elementary 01 02 2020   kindergarten_full_day                                                   0.0                                             0
2481134 2481134 NJ Cape May 9 school 3409150 2840   Lower Twp 340915006054 80 Carl T. Mitnick School   Regular School No Elementary 01 02 2020   kindergarten_full_day                                                   0.0                                             0
2481136 2481136 NJ Cape May 9 school 3410020 3130   Middle Twp 341002001734 80 Middle Township Elementary #1   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   173.0                                             173
2481146 2481146 NJ Cape May 9 school 3416650 5340   Upper Twp 341665006104 55 Upper Township Primary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   176.0                                             176
2481260 2481260 NJ Essex 13 school 3405940 1750   Glen Ridge Boro 340594002096 70 Forest Avenue School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   74.0                                             74
2481262 2481262 NJ Essex 13 school 3405940 1750   Glen Ridge Boro 340594005963 80 Linden Avenue School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   72.0                                             72
2481263 2481263 NJ Essex 13 school 3405940 1750   Glen Ridge Boro 340594003475 300 Central School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   0.0                                             0
2481300 2481300 NJ Essex 13 school 3410560 3310   Montclair Town 341056002180 130 Nishuane Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   170.0                                             170
2481389 2481389 NJ Essex 13 school 3415330 4900   South Orange-Maplewood 341533002434 100 Marshall Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   164.0                                             164
2481427 2481427 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   175.0                                             175
2481431 2481431 NJ Gloucester 15 school 3405430 1590   Franklin Twp 340543002546 80 Mary F. Janvier School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   175.0                                             175
2481461 2481461 NJ Gloucester 15 school 3412720 4020   Paulsboro Boro 341272002610 60 Billingsport Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   100.0                                             100
2481472 2481472 NJ Gloucester 15 school 3415990 5120   Swedesboro-Woolwich 341599000709 50 Governor Charles C. Stratton   Regular School No Elementary 01 02 2020   kindergarten_full_day                                                   0.0                                             0
2481490 2481490 NJ Gloucester 15 school 3417430 5620   West Deptford Twp 341743002670 100 Oakview Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   200.0                                             200
2481491 2481491 NJ Gloucester 15 school 3417430 5620   West Deptford Twp 341743002672 111 Red Bank Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   0.0                                             0
2481602 2481602 NJ Hudson 17 school 3417310 5580   Weehawken Twp 341731002930 70 Daniel Webster School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   125.0                                             125
2481621 2481621 NJ Hunterdon 19 school 3403360 920   Clinton Twp 340336006027 35 Patrick Mcgaheran   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   110.0                                             110
2481662 2481662 NJ Mercer 21 school 3404320 1245   East Windsor Regional 340432003056 55 Ethel Mcknight Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   183.0                                             183
2481666 2481666 NJ Mercer 21 school 3404320 1245   East Windsor Regional 340432003064 80 Walter C. Black Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   153.0                                             153
2481710 2481710 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   kindergarten_full_day                                                   5.0                                             5
2481752 2481752 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   kindergarten_full_day                                                   12.0                                             12
2481784 2481784 NJ Middlesex 23 school 3404500 1290   Edison Twp 340450003344 92 James Madison Primary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   1.0                                             1
2481825 2481825 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003440 10 Barclay Brook School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   0.0                                             0
2481874 2481874 NJ Middlesex 23 school 3412930 4090   Perth Amboy City 341293003467 301 Rose M. Lopez Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   250.0                                             250
2481958 2481958 NJ Monmouth 25 school 3403450 945   Colts Neck Twp 340345000513 60 Conover Road Primary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   97.0                                             97
2481962 2481962 NJ Monmouth 25 school 3404410 1260   Eatontown Boro 340441003772 80 Meadowbrook   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   108.0                                             108
2481998 2481998 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000721 3 Adelphia Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   106.0                                             106
2482001 2482001 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000722 12 Greenville Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   103.0                                             103
2482002 2482002 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003864 20 Edith M. Griebling Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   73.0                                             73
2482005 2482005 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003866 30 Land O'Pines Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   103.0                                             103
2482009 2482009 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003874 60 Taunton Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   128.0                                             128
2482070 2482070 NJ Monmouth 25 school 3410230 3200   Millstone Twp 341023002931 80 Millstone Township Primary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   48.0                                             48
2482112 2482112 NJ Monmouth 25 school 3416200 5185   Tinton Falls 341620004112 30 Mahala F. Atchison School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   136.0                                             136
2482130 2482130 NJ Morris 27 school 3401950 450   Boonton Town 340195004158 40 School Street School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   81.0                                             81
2482143 2482143 NJ Morris 27 school 3403060 820   Chester Twp 340306006026 40 Dickerson Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   92.0                                             92
2482153 2482153 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004226 35 Frank J Smith Elementary   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   119.0                                             119
2482155 2482155 NJ Morris 27 school 3405250 1530   Florham Park Boro 340525004234 15 Briarwood School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   93.0                                             93
2482167 2482167 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004270 33 Cozy Lake Elementary School   Regular School No Elementary 01 02 2020   kindergarten_full_day                                                   0.0                                             0
2482168 2482168 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004272 40 Ellen T. Briggs Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   71.0                                             71
2482173 2482173 NJ Morris 27 school 3408040 2460   Kinnelon Boro 340804004284 60 Kiel Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   39.0                                             39
2482205 2482205 NJ Morris 27 school 3410770 3380   Morris Plains Boro 341077004362 30 Mountain Way School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   81.0                                             81
2482208 2482208 NJ Morris 27 school 3410810 3385   Morris School District 341081004370 65 Alfred Vail School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   98.0                                             98
2482211 2482211 NJ Morris 27 school 3410810 3385   Morris School District 341081004378 90 Hillcrest School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   89.0                                             89
2482215 2482215 NJ Morris 27 school 3410810 3385   Morris School District 341081004388 115 Woodland School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   92.0                                             92
2482216 2482216 NJ Morris 27 school 3410860 3410   Mount Arlington Boro 341086004392 45 Edith M. Decker Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   40.0                                             40
2482333 2482333 NJ Ocean 29 school 3408220 2520   Lakewood Twp 340822003357 301 Piner Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   136.0                                             136
2482336 2482336 NJ Ocean 29 school 3408700 2690   Little Egg Harbor Twp 340870004650 50 George J. Mitchell Elementary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   171.0                                             171
2482338 2482338 NJ Ocean 29 school 3408910 2760   Long Beach Island 340891004654 20 Ethel A. Jacobsen Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   29.0                                             29
2482371 2482371 NJ Ocean 29 school 3415690 5020   Stafford Twp 341569000343 65 Ocean Acres Elementary School   Regular School No Elementary 01 02 2020   kindergarten_full_day                                                   0.0                                             0
2482422 2482422 NJ Passaic 31 school 3408730 2700   Little Falls Twp 340873004824 60 Little Falls Township Public School # 2   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   106.0                                             106
2482459 2482459 NJ Passaic 31 school 3412690 4010   Paterson City 341269004870 45 Dale Avenue   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   192.0                                             192
2482510 2482510 NJ Passaic 31 school 3416260 5200   Totowa Boro 341626004952 50 Memorial School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   83.0                                             83

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