Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by multiracial_int

View and edit SQL

grade

year

  • 2020 · 20,354
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
2777975 CT     school   370011   Derby School District   370211 Alternative Education Program Program           2020   pk_12_total 0 0 0   0 0     0   *   * 0     0             *   * 0 0 0   0 0     0         0     0            
2777979 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 144 20 *   0 20     0   *   100 99     *             26   199 144 20     0 20     0       100 99             26   199
2777980 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2020   pk_12_total 189 21 21   * 16     0   *   123 131     *             36   254 189 21 21     16     0       123 131             36   254
2777983 CT     school 901200 410011   East Haddam School District 90120000185 416111 Nathan Hale-Ray High School Public Schools Regular School No High 09 12 2020   pk_12_total 281 * 8   * 9     0   *   167 135     0             24   302 281   8     9     0       167 135     0       24   302
2777987 CT     school 901230 420011   East Hampton School District 90123000187 426111 East Hampton High School Public Schools Regular School No High 09 12 2020   pk_12_total 452 * 29   0 6     0   *   259 237     *             54   496 452   29   0 6     0       259 237             54   496
2777989 CT     school   430011   East Hartford School District   430211 Early Childhood Learning Center at Hockanum School Program           2020   pk_12_total 42 95 162   0 15     *   *   176 145     0             86   321 42 95 162   0 15             176 145     0       86   321
2777992 CT     school 901260 430011   East Hartford School District 90126000195 432211 Dr. John A. Langford School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 25 102 176   0 *     0   *   183 133     90             50   316 25 102 176   0       0       183 133     90       50   316
2778001 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2020   pk_12_total 43 54 45   * 33     0   *   75 107     *             *   182 43 54 45     33     0       75 107                 182
2778003 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2020   pk_12_total * 27 63   0 0     0   *   68 33     12             30   101   27 63   0 0     0       68 33     12       30   101
2778005 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Elementary PK KG 2020   pk_12_total 99 * 56   0 9     0   *   80 95     0             *   175 99   56   0 9     0       80 95     0           175
2778006 CT     school 901290 440011   East Haven School District 90129000218 441011 Grove J. Tuttle School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 130 15 95   * 12     0   *   132 131     44             25   263 130 15 95     12     0       132 131     44       25   263
2778009 CT     school 901290 440011   East Haven School District 90129000215 441311 Dominick H. Ferrara School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 92 * 46   0 12     0   *   81 83     16             26   164 92   46   0 12     0       81 83     16       26   164
2778010 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 272 40 184   * 12     0   *   257 263     51             82   520 272 40 184     12     0       257 263     51       82   520
2778011 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2020   pk_12_total 552 42 238   * 51     0   *   466 *     77             133   898 552 42 238     51     0       466       77       133   898
2778013 CT     school 901320 450011   East Lyme School District 90132000225 450111 Flanders School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 215 * 21   0 28     0   *   144 140     10             42   284 215   21   0 28     0       144 140     10       42   284
2778034 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 380 27 57   * 178     0   *   355 310     28             89   665 380 27 57     178     0       355 310     28       89   665
2778035 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 406 17 25   0 12     *   *   243 226     *             63   469 406 17 25   0 12             243 226             63   469
2778036 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 325 18 17   * 41     0   *   192 222     *             62   414 325 18 17     41     0       192 222             62   414
2778038 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2020   pk_12_total * 0 0   0 0     0   *   * 0     0             *   *   0 0   0 0     0         0     0            
2778040 CT     school 900216 2910013   Elm City Montessori School District 90021601683 2910113 Elm City Montessori School Public Charter Schools Regular School Yes Elementary PK 05 2020   pk_12_total 68 92 53   0 *     0   *   114 115     6             13   229 68 92 53   0       0       114 115     6       13   229
2778041 CT     school   490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program           2020   pk_12_total 59 * 11   0 *     0   *   49 31     0             49   80 59   11   0       0       49 31     0       49   80
2778042 CT     school   490011   Enfield School District 90147001810 491011 EPS PK STEAM Academy Program           2020   pk_12_total 31 10 16   0 *     0   *   43 24     0             *   67 31 10 16   0       0       43 24     0           67
2778047 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2778049 CT     school 901470 490011   Enfield School District 90147000242 491611 Eli Whitney School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 252 29 55   * 10     0   *   179 179     17             64   358 252 29 55     10     0       179 179     17       64   358
2778050 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2020   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2778051 CT     school   490011   Enfield School District   492411 Eagle Academy Program           2020   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
2778059 CT     school   490011   Enfield School District   492311 Enfield Alternative Education Program Program           2020   pk_12_total * * *   0 0     0   *   * *     0             *   7         0 0     0               0           7
2778062 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2020   pk_12_total 12 * 0   0 *     0   *   10 7     0             17   17 12   0   0       0       10 7     0       17   17
2778064 CT     school   510011   Fairfield School District   510811 Early Childhood Center(0510811) Program           2020   pk_12_total 46 * 14   0 *     0   *   41 27     0             41   68 46   14   0       0       41 27     0       41   68
2778089 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2020   pk_12_total 363 33 55   * 160     0   *   313 321     19             79   634 363 33 55     160     0       313 321     19       79   634
2778090 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 388 35 65   * 172     0   *   346 337     8             78   683 388 35 65     172     0       346 337     8       78   683
2778091 CT     school 901560 520011   Farmington School District 90156000273 526111 Farmington High School Public Schools Regular School No High 09 12 2020   pk_12_total 846 48 74   * 250     0   *   607 637     13             154   1244 846 48 74     250     0       607 637     13       154   1244
2778100 CT     school   540011   Glastonbury School District 90162001801 540111 Links Academy Program           2020   pk_12_total 26 * 10   * 0     0   *   29 15     0             44   44 26   10     0     0       29 15     0       44   44
2778105 CT     school 901680 560011   Granby School District 90168000290 560411 Kelly Lane Primary School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 334 29 19   * 12     0   *   207 198     *             59   405 334 29 19     12     0       207 198             59   405
2778113 CT     school 901710 570011   Greenwich School District 90171000107 571111 Parkway School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 201 0 23   0 10     *   *   144 100     6             50   244 201 0 23   0 10             144 100     6       50   244
2778114 CT     school 901710 570011   Greenwich School District 90171000296 570211 Cos Cob School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 245 * 80   0 32     0   *   195 194     41             42   389 245   80   0 32     0       195 194     41       42   389
2778116 CT     school 901710 570011   Greenwich School District 90171001288 571311 International School At Dundee Public Schools Regular School No Elementary KG 05 2020   pk_12_total 178 * 49   0 106     0   *   189 180     21             27   369 178   49   0 106     0       189 180     21       27   369
2778119 CT     school 901710 570011   Greenwich School District 90171000308 571011 Riverside School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 351 * 68   0 22     0   *   249 208     14             31   457 351   68   0 22     0       249 208     14       31   457
2778122 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 286 29 243   * 51     0   *   335 297     31             99   632 286 29 243     51     0       335 297     31       99   632
2778124 CT     school   570011   Greenwich School District   571511 Windrose Program           2020   pk_12_total 15 * 13   0 0     0   *   15 15     0             12   30 15   13   0 0     0       15 15     0       12   30
2778128 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 08 12 2020   pk_12_total 13 0 0   0 0     *   *   * *     0             15   15 13 0 0   0 0                     0       15   15
2778139 CT     school   590011   Groton School District   590611 Apex Academy Program           2020   pk_12_total * * 0   0 0     0   *   * *     0             *   *     0   0 0     0               0            
2778140 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2020   pk_12_total * * *   0 0     0   *   * *     0             6   6         0 0     0               0       6   6
2778141 CT     school   590011   Groton School District   591011 Transition Academy Program           2020   pk_12_total 7 * *   0 0     0   *   * *     *             14   14 7       0 0     0                       14   14
2778142 CT     school 901800 600011   Guilford School District 90180000333 600211 Guilford Lakes School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 248 * 32   0 17     0   *   165 151     12             42   316 248   32   0 17     0       165 151     12       42   316
2778143 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 206 * 22   0 16     0   *   129 123     13             14   252 206   22   0 16     0       129 123     13       14   252
2778147 CT     school 901800 600011   Guilford School District 90180000331 605111 E. C. Adams Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 437 * 50   0 27     0   *   294 249     *             69   543 437   50   0 27     0       294 249             69   543
2778153 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2020   pk_12_total * 12 8   0 *     0   *   24 7     0             31   31   12 8   0       0       24 7     0       31   31
2778157 CT     school 901860 620011   Hamden School District 90186000346 620111 Shepherd Glen School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 54 110 73   * 61     0   *   163 149     50             32   312 54 110 73     61     0       163 149     50       32   312
2778159 CT     school 901860 620011   Hamden School District 90186000349 621411 West Woods School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 161 62 43   * 48     0   *   179 162     21             38   341 161 62 43     48     0       179 162     21       38   341
2778160 CT     school   620011   Hamden School District   621611 Helen Street IIC Program           2020   pk_12_total 0 8 6   0 *     0   *   * *     *             16   16 0 8 6   0       0                       16   16
2778162 CT     school   620011   Hamden School District   621811 West Woods IIC Program           2020   pk_12_total * 13 *   0 0     0   *   15 8     0             23   23   13     0 0     0       15 8     0       23   23
2778164 CT     school   620011   Hamden School District   621511 Dunbar Hill IIC Program           2020   pk_12_total * 7 *   0 *     0   *   * *     *             16   16   7     0       0                       16   16
2778165 CT     school   620011   Hamden School District   620911 Bear Path IIC Program           2020   pk_12_total * 15 *   0 *     0   *   17 6     0             23   23   15     0       0       17 6     0       23   23
2778167 CT     school   620011   Hamden School District 90186001741 620511 Hamden Collaborative Learning Center Program           2020   pk_12_total 14 20 15   0 *     0   *   32 20     *             32   52 14 20 15   0       0       32 20             32   52
2778170 CT     school 901890 630011   Hampton School District 90189000351 630111 Hampton Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 79 0 *   * 0     0   *   52 38     0             15   90 79 0       0     0       52 38     0       15   90
2778173 CT     school 901920 640011   Hartford School District 90192001369 643311 Breakthrough Magnet School, South Public Schools Regular School No Elementary PK 08 2020   pk_12_total 49 75 170   * 20     0   *   169 158     41             54   327 49 75 170     20     0       169 158     41       54   327
2778174 CT     school 901920 640011   Hartford School District 90192000357 640611 Burns Latino Studies Academy Public Schools Regular School No Elementary PK 05 2020   pk_12_total 8 33 221   * 6     0   *   137 135     120             60   272 8 33 221     6     0       137 135     120       60   272
2778176 CT     school 901920 640011   Hartford School District 90192000360 640711 Dwight-Bellizzi Dual Language Academy Public Schools Regular School No Elementary PK 08 2020   pk_12_total 27 77 425   * 18     0   *   288 267     221             74   555 27 77 425     18     0       288 267     221       74   555
2778177 CT     school   640011   Hartford School District 90192001723 644111 Early Childhood Development Center (ECDC) Program           2020   pk_12_total * 8 8   0 *     0   *   * *     0             19   19   8 8   0       0               0       19   19
2778178 CT     school 901920 640011   Hartford School District 90192000366 640911 Environmental Sciences Magnet at Hooker School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 109 70 374   * 34     0   *   311 295     76             67   606 109 70 374     34     0       311 295     76       67   606
2778180 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 18 56 26   * 56     0   *   76 85     0             9   161 18 56 26     56     0       76 85     0       9   161
2778181 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 26 98 495   * 12     *   *   315 329     204             101   644 26 98 495     12             315 329     204       101   644
2778185 CT     school 901920 640011   Hartford School District 90192001531 643711 Montessori Magnet at Fisher School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 80 161 68   * 33     0   *   177 181     20             28   358 80 161 68     33     0       177 181     20       28   358
2778186 CT     school 901920 640011   Hartford School District 90192000373 641511 Parkville Community School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 35 29 357   * *     *   *   232 200     204             70   432 35 29 357                   232 200     204       70   432
2778192 CT     school 901920 640011   Hartford School District 90192000377 640111 SAND School Public Schools Regular School No Elementary PK 05 2020   pk_12_total * 88 234   * *     0   *   180 153     91             58   333   88 234           0       180 153     91       58   333
2778193 CT     school 901920 640011   Hartford School District 90192000026 643011 Sanchez School Public Schools Regular School No Elementary PK 05 2020   pk_12_total * 35 339   0 0     0   *   170 211     184             57   381   35 339   0 0     0       170 211     184       57   381
2778194 CT     school 901920 640011   Hartford School District 90192000383 642011 Webster Micro Society Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 104 279 162   * 61     0   *   335 300     46             80   635 104 279 162     61     0       335 300     46       80   635
2778195 CT     school 901920 640011   Hartford School District 90192000384 642111 West Middle School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 11 191 232   0 22     *   *   246 216     157             87   462 11 191 232   0 22             246 216     157       87   462
2778196 CT     school 901920 640011   Hartford School District 90192000385 642211 Wish Museum School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 6 129 189   0 *     0   *   174 158     102             87   332 6 129 189   0       0       174 158     102       87   332
2778198 CT     school   640011   Hartford School District   640710 iGOAL Pre-K - Naylor School Program           2020   pk_12_total * * 6   0 0     0   *   9 0     0             9   9     6   0 0     0       9 0     0       9   9
2778200 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 15 97 455   * 7     0   *   321 258     239             97   579 15 97 455     7     0       321 258     239       97   579
2778202 CT     school 901920 640011   Hartford School District 90192000372 641411 Naylor/CCSU Leadership Academy Public Schools Regular School No Elementary KG 08 2020   pk_12_total 56 48 298   * 15     *   *   222 201     139             96   423 56 48 298     15             222 201     139       96   423
2778208 CT     school   640011   Hartford School District 90192001673 644411 iGOAL 1 - Rawson School Program           2020   pk_12_total 0 10 *   0 0     0   *   * *     *             *   18 0 10     0 0     0                           18
2778210 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2020   pk_12_total 0 * *   0 0     0   *   * *     *             8   8 0       0 0     0                       8   8
2778212 CT     school 901920 640011   Hartford School District 90192001582 644011 Renzulli Gifted and Talented Academy Public Schools Regular School No Middle 04 08 2020   pk_12_total 12 43 53   * 12     0   *   73 56     *             *   129 12 43 53     12     0       73 56                 129
2778213 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2020   pk_12_total 39 63 129   * 13     0   *   153 100     31             39   253 39 63 129     13     0       153 100     31       39   253
2778217 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total * 121 42   0 *     0   *   97 72     17             45   169   121 42   0       0       97 72     17       45   169
2778219 CT     school 901920 640011   Hartford School District 90192000381 641911 Milner Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total * 117 194   0 0     0   *   155 165     92             62   320   117 194   0 0     0       155 165     92       62   320
2778220 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2020   pk_12_total 141 146 302   * 32     0   *   385 258     80             75   643 141 146 302     32     0       385 258     80       75   643
2778224 CT     school 901920 640011   Hartford School District 90192001572 647111 Bulkeley High School Public Schools Regular School No High 09 12 2020   pk_12_total 13 140 393   * 8     *   *   290 272     222             101   562 13 140 393     8             290 272     222       101   562
2778236 CT     school 902010 670011   Hebron School District 90201000387 670211 Gilead Hill School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 293 * 10   0 6     0   *   157 160     *             35   317 293   10   0 6     0       157 160             35   317
2778238 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2020   pk_12_total 6 426 20   * 0     *   *   200 260     *             24   460 6 426 20     0             200 260             24   460
2778242 CT     school   690011   Killingly School District 90207000083 698011 Goodyear Early Childhood Center Program           2020   pk_12_total 93 0 11   0 *     0   *   68 49     0             36   117 93 0 11   0       0       68 49     0       36   117
2778250 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2020   pk_12_total 12 7 9   0 *     0   *   27 8     *             35   35 12 7 9   0       0       27 8             35   35
2778252 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2020   pk_12_total 12 * *   0 0     0   *   * *     *             18   18 12       0 0     0                       18   18
2778255 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2020   pk_12_total * * *   0 0     0   *   * 0     0             *   *         0 0     0         0     0            
2778258 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2020   pk_12_total 45 * 14   * *     0   *   18 49     *             *   67 45   14           0       18 49                 67
2778261 CT     school 902130 710011   Lebanon School District 90213000395 710111 Lebanon Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 325 * 29   * *     *   *   206 165     7             59   371 325   29                   206 165     7       59   371
2778262 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 262 6 12   * *     *   *   159 137     *             51   296 262 6 12                   159 137             51   296
2778271 CT     school 902220 740011   Litchfield School District 90222000405 740211 Center School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 273 * 17   0 *     *   *   145 156     0             39   301 273   17   0               145 156     0       39   301
2778272 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2020   pk_12_total 174 * 8   0 *     0   *   102 88     0             29   190 174   8   0       0       102 88     0       29   190
2778273 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 118 0 *   0 *     *   *   68 63     *             23   131 118 0     0               68 63             23   131
2778274 CT     school 902220 740011   Litchfield School District 90222000406 746111 Litchfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 228 * 16   0 *     7   *   131 129     *             48   260 228   16   0       7       131 129             48   260
2778275 CT     school   760011   Madison School District 90228001549 769011 Town Campus Learning Center Program           2020   pk_12_total 40 0 *   0 *     0   *   22 21     0             22   43 40 0     0       0       22 21     0       22   43
2778277 CT     school 902280 760011   Madison School District 90228000413 760311 Kathleen H. Ryerson Elementary School Public Schools Regular School No Elementary KG 03 2020   pk_12_total 240 * 15   0 13     0   *   158 125     14             46   283 240   15   0 13     0       158 125     14       46   283
2778281 CT     school 902310 770011   Manchester School District 90231000418 770311 Buckley School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 146 88 91   * 45     0   *   210 163     22             61   373 146 88 91     45     0       210 163     22       61   373
2778285 CT     school 902310 770011   Manchester School District 90231000417 770111 Bowers School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 138 78 101   0 14     *   *   182 155     22             58   337 138 78 101   0 14             182 155     22       58   337
2778286 CT     school 902310 770011   Manchester School District 90231000420 770411 Highland Park School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 141 75 77   * 17     0   *   156 160     18             34   316 141 75 77     17     0       156 160     18       34   316
2778287 CT     school 902310 770011   Manchester School District 90231000425 771611 Martin School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 99 51 52   0 19     *   *   121 104     *             47   225 99 51 52   0 19             121 104             47   225

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