Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by black_int

View and edit SQL

grade

year

  • 2021 · 20,216
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
2757288 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 141 * 22   0 0     0   *   86 87     *             22   173 141   22   0 0     0       86 87             22   173
2757289 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2021   pk_12_total 14 * 26   0 0     0   *   28 23     0             15   51 14   26   0 0     0       28 23     0       15   51
2757295 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2021   pk_12_total * * 0   0 0     0   *   6 0     0             *   6     0   0 0     0       6 0     0           6
2757305 CT     school 900150 50011   Barkhamsted School District 90015000015 50111 Barkhamsted Elementary School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 169 * *   0 *     0   8   88 95     0             38   183 169       0       0   8   88 95     0       38   183
2757309 CT     school 900210 70011   Berlin School District 90021000021 70111 Richard D. Hubbard School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 151 * 28   0 13     0   *   98 110     26             28   208 151   28   0 13     0       98 110     26       28   208
2757311 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2021   pk_12_total 716 * 102   * 36     0   32   469 434     10             119   903 716   102     36     0   32   469 434     10       119   903
2757313 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 301 * 36   * 19     0   7   191 178     12             52   369 301   36     19     0   7   191 178     12       52   369
2757314 CT     school 900270 90011   Bethel School District 90027000027 90111 Frank A. Berry School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 195 * 89   * 39     0   14   201 155     35             70   356 195   89     39     0   14   201 155     35       70   356
2757319 CT     school   90011   Bethel School District   90311 TASK Program           2021   pk_12_total 10 * *   0 *     0   0   7 8     *             *   15 10       0       0   0   7 8                 15
2757323 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             15   15 0       0 0     0   0                   15   15
2757333 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2021   pk_12_total 28 * 8   0 *     0   *   28 15     0             27   43 28   8   0       0       28 15     0       27   43
2757334 CT     school 900420 140011   Branford School District 90042001119 141611 John B. Sliney School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 161 * 45   0 *     0   20   120 123     28             35   243 161   45   0       0   20   120 123     28       35   243
2757335 CT     school 900420 140011   Branford School District 90042000043 141511 Mary R. Tisko School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 266 * 32   0 11     *   12   179 151     19             33   330 266   32   0 11         12   179 151     19       33   330
2757381 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2021   pk_12_total 46 * 38   0 *     0   10   63 33     0             71   96 46   38   0       0   10   63 33     0       71   96
2757389 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2021   pk_12_total * * *   0 0     0   *   * *     0             7   7         0 0     0               0       7   7
2757391 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2021   pk_12_total * * *   * *     0   0   * *     0             13   13                 0   0           0       13   13
2757396 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2021   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2757398 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2021   pk_12_total * * *   0 0     0   *   * *     *             8   8         0 0     0                       8   8
2757399 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2021   pk_12_total 12 * *   0 0     0   0   20 6     *             26   26 12       0 0     0   0   20 6             26   26
2757401 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2021   pk_12_total * * *   0 0     0   *   * *     0             *   *         0 0     0               0            
2757403 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2021   pk_12_total * * *   0 0     0   *   * *     *             11   11         0 0     0                       11   11
2757405 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2021   pk_12_total * * 9   0 0     0   0   9 6     *             15   15     9   0 0     0   0   9 6             15   15
2757406 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2021   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2757408 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2021   pk_12_total * * *   0 0     0   0   * *     0             9   9         0 0     0   0           0       9   9
2757413 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2021   pk_12_total 27 * 17   0 0     0   *   33 14     0             *   47 27   17   0 0     0       33 14     0           47
2757415 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2021   pk_12_total 14 * *   0 0     0   *   13 9     0             22   22 14       0 0     0       13 9     0       22   22
2757422 CT     school 900660 220011   Canterbury School District 90066001188 220211 Canterbury Elementary School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 222 * 16   * 0     0   *   123 123     0             24   246 222   16     0     0       123 123     0       24   246
2757423 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 169 * 10   * 0     0   *   85 97     *             19   182 169   10     0     0       85 97             19   182
2757437 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2021   pk_12_total * * *   0 0     0   0   * *     0             0   6         0 0     0   0           0       0   6
2757452 CT     school 900720 240011   Chaplin School District 90072000121 240211 Chaplin Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 115 * 7   0 *     0   *   69 61     *             24   130 115   7   0       0       69 61             24   130
2757453 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   pk_12_total 118 * 18   0 *     0   11   82 74     *             45   156 118   18   0       0   11   82 74             45   156
2757456 CT     school   250011   Cheshire School District   250711 Highland School Autism Program Program           2021   pk_12_total 11 * *   0 *     0   0   * *     0             15   15 11       0       0   0           0       15   15
2757462 CT     school   250011   Cheshire School District 90075001682 250911 Humiston Alternative School Program           2021   pk_12_total 20 * *   0 *     0   0   14 10     0             *   24 20       0       0   0   14 10     0           24
2757465 CT     school 900810 270011   Clinton School District 90081000132 270311 Lewin G. Joel Jr. School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 366 * 136   0 *     0   12   270 256     65             56   526 366   136   0       0   12   270 256     65       56   526
2757466 CT     school 900810 270011   Clinton School District 90081000133 275111 Jared Eliot School Public Schools Regular School No Middle 05 08 2021   pk_12_total 344 * 103   * 16     0   *   256 217     23             75   473 344   103     16     0       256 217     23       75   473
2757467 CT     school 900810 270011   Clinton School District 90081000134 276111 The Morgan School Public Schools Regular School No High 09 12 2021   pk_12_total 452 * 80   * 20     0   8   300 264     20             75   564 452   80     20     0   8   300 264     20       75   564
2757469 CT     school 900840 280011   Colchester School District 90084000137 280211 Jack Jackter Intermediate School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 373 * 35   * 14     0   17   225 220     *             74   445 373   35     14     0   17   225 220             74   445
2757471 CT     school 900840 280011   Colchester School District 90084000135 286111 Bacon Academy Public Schools Regular School No High 09 12 2021   pk_12_total 603 * 60   * 20     0   35   375 358     0             98   733 603   60     20     0   35   375 358     0       98   733
2757478 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2021   pk_12_total 0 * 0   * 0     0   0   * 0     0             0   * 0   0     0     0   0     0     0       0    
2757483 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 83 * 12   0 7     0   *   51 53     *             11   104 83   12   0 7     0       51 53             11   104
2757485 CT     school 900960 320011   Coventry School District 90096000142 320211 Coventry Grammar School Public Schools Regular School No Elementary KG 02 2021   pk_12_total 293 * 16   0 *     0   15   148 180     6             27   328 293   16   0       0   15   148 180     6       27   328
2757486 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 308 * 40   * 6     0   17   201 175     7             53   376 308   40     6     0   17   201 175     7       53   376
2757487 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2021   pk_12_total 344 * 24   0 *     0   9   200 187     *             62   387 344   24   0       0   9   200 187             62   387
2757488 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2021   pk_12_total 363 * 33   * *     0   16   * 229     0             57   419 363   33           0   16     229     0       57   419
2757495 CT     school 901020 340011   Danbury School District 90102000151 341111 Great Plain School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 114 * 124   0 30     0   *   152 132     72             56   284 114   124   0 30     0       152 132     72       56   284
2757516 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 364 * 21   0 25     0   *   225 209     13             72   434 364   21   0 25     0       225 209     13       72   434
2757517 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 355 * 23   * 26     0   20   232 197     8             55   429 355   23     26     0   20   232 197     8       55   429
2757519 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 956 * 74   * 61     0   37   581 562     8             182   1143 956   74     61     0   37   581 562     8       182   1143
2757520 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2021   pk_12_total 1182 * 87   * 78     0   17   714 668     *             265   1382 1182   87     78     0   17   714 668             265   1382
2757521 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 18 * 16   0 *     0   *   25 18     0             18   43 18   16   0       0       25 18     0       18   43
2757529 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 146 * 20   0 20     0   *   102 107     *             28   209 146   20   0 20     0       102 107             28   209
2757531 CT     school 901200 410011   East Haddam School District 90120000184 410111 East Haddam Elementary School Public Schools Regular School No Elementary PK 03 2021   pk_12_total 264 * 10   0 *     0   7   161 126     *             41   287 264   10   0       0   7   161 126             41   287
2757532 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2021   pk_12_total 313 * 21   * *     0   8   176 173     *             53   349 313   21           0   8   176 173             53   349
2757533 CT     school 901200 410011   East Haddam School District 90120000185 416111 Nathan Hale-Ray High School Public Schools Regular School No High 09 12 2021   pk_12_total 276 * 6   0 8     0   *   162 132     0             32   294 276   6   0 8     0       162 132     0       32   294
2757535 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2021   pk_12_total 477 * 43   0 9     *   21   293 *     0             100   559 477   43   0 9         21   293       0       100   559
2757536 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2021   pk_12_total 262 * 17   0 *     0   15   149 152     *             55   301 262   17   0       0   15   149 152             55   301
2757537 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 380 * 24   * *     0   15   196 232     0             62   428 380   24           0   15   196 232     0       62   428
2757538 CT     school 901230 420011   East Hampton School District 90123000187 426111 East Hampton High School Public Schools Regular School No High 09 12 2021   pk_12_total 468 * 37   0 6     *   7   267 256     *             51   523 468   37   0 6         7   267 256             51   523
2757556 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 55 * 36   0 7     0   *   56 51     0             *   107 55   36   0 7     0       56 51     0           107
2757564 CT     school 901320 450011   East Lyme School District 90132000225 450111 Flanders School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 203 * 22   0 24     0   *   136 135     13             47   271 203   22   0 24     0       136 135     13       47   271
2757565 CT     school 901320 450011   East Lyme School District 90132000226 450411 Lillie B. Haynes School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 191 * 27   * 42     0   15   140 143     22             50   283 191   27     42     0   15   140 143     22       50   283
2757566 CT     school 901320 450011   East Lyme School District 90132000227 450211 Niantic Center School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 183 * 19   0 *     0   13   106 114     9             32   220 183   19   0       0   13   106 114     9       32   220
2757570 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2021   pk_12_total 15 * *   0 0     0   0   9 10     *             19   19 15       0 0     0   0   9 10             19   19
2757577 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001937 2530314 LEAP Alternative High School Regional Education Service Center Schools Alternative School No High 09 12 2021   pk_12_total * * *   0 0     0   *   * *     *             *   8         0 0     0                           8
2757578 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001530 2536114 Quinebaug Middle College Regional Education Service Center Schools Regular School No High 09 12 2021   pk_12_total 121 * 27   0 *     0   11   62 103     *             30   165 121   27   0       0   11   62 103             30   165
2757581 CT     school 901380 390011   Eastford School District 90138000232 390111 Eastford Elementary School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 111 * 13   0 0     0   *   72 66     *             25   138 111   13   0 0     0       72 66             25   138
2757586 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2021   pk_12_total 17 * *   * *     0   0   * *     0             26   26 17               0   0           0       26   26
2757587 CT     school   2420014   EdAdvance   2420114 Steps Program           2021   pk_12_total 19 * 8   * 0     0   *   26 6     0             *   32 19   8     0     0       26 6     0           32
2757588 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             *   * 0       0 0     0   0                        
2757590 CT     school   2420014   EdAdvance   2420514 University Pathways Program Program           2021   pk_12_total 14 * *   0 0     0   *   12 9     0             21   21 14       0 0     0       12 9     0       21   21
2757601 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2021   pk_12_total 46 * 29   0 *     0   9   50 40     0             18   90 46   29   0       0   9   50 40     0       18   90
2757604 CT     school   490011   Enfield School District 90147001792 490311 Henry Barnard - Autism Spectrum Disorder (ASD) Program           2021   pk_12_total * * 0   0 0     0   0   8 0     0             8   8     0   0 0     0   0   8 0     0       8   8
2757605 CT     school   490011   Enfield School District 90147001743 490811 Henry Barnard - Primary Adaptive Learning (PAL) Program           2021   pk_12_total * * *   0 0     0   *   * *     0             8   8         0 0     0               0       8   8
2757608 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2021   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2757609 CT     school   490011   Enfield School District   492411 Eagle Academy Program           2021   pk_12_total 10 * *   0 0     0   0   * *     0             17   17 10       0 0     0   0           0       17   17
2757612 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2021   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2757613 CT     school   490011   Enfield School District 90147001702 490711 Prudence Crandall - Educational Counseling Program (ECP) Program           2021   pk_12_total * * 0   0 0     0   *   * 0     0             *   *     0   0 0     0         0     0            
2757615 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2021   pk_12_total 8 * *   0 *     0   0   7 9     *             16   16 8       0       0   0   7 9             16   16
2757617 CT     school   490011   Enfield School District   492311 Enfield Alternative Education Program Program           2021   pk_12_total 7 * *   0 0     0   0   * *     0             *   13 7       0 0     0   0           0           13
2757620 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2021   pk_12_total 12 * *   0 *     0   *   9 7     0             16   16 12       0       0       9 7     0       16   16
2757621 CT     school 901500 500011   Essex School District 90150000255 500111 Essex Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 265 * 25   0 *     0   13   159 152     6             53   311 265   25   0       0   13   159 152     6       53   311
2757622 CT     school   510011   Fairfield School District   510811 Early Childhood Center(0510811) Program           2021   pk_12_total 34 * 10   0 6     0   *   33 19     0             35   52 34   10   0 6     0       33 19     0       35   52
2757624 CT     school 901530 510011   Fairfield School District 90153000269 511311 Sherman School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 363 * 22   0 *     0   15   205 208     *             49   413 363   22   0       0   15   205 208             49   413
2757625 CT     school 901530 510011   Fairfield School District 90153001378 510211 Burr Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 255 * 29   * 29     0   27   176 174     13             55   350 255   29     29     0   27   176 174     13       55   350
2757630 CT     school 901530 510011   Fairfield School District 90153000263 510711 Mill Hill School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 285 * 26   * 22     0   25   178 182     7             54   360 285   26     22     0   25   178 182     7       54   360
2757632 CT     school 901530 510011   Fairfield School District 90153000609 511811 Osborn Hill School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 284 * 32   0 25     0   *   192 179     *             59   371 284   32   0 25     0       192 179             59   371
2757633 CT     school 901530 510011   Fairfield School District 90153000267 511211 Riverfield School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 305 * 22   0 *     0   19   204 161     *             48   365 305   22   0       0   19   204 161             48   365
2757636 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 689 * 45   * 39     0   31   397 420     *             109   817 689   45     39     0   31   397 420             109   817
2757637 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 423 * 116   0 37     *   37   327 311     17             90   638 423   116   0 37         37   327 311     17       90   638
2757639 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2021   pk_12_total 1033 * 235   * 91     0   60   765 *     42             193   1472 1033   235     91     0   60   765       42       193   1472
2757640 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2021   pk_12_total 20 * *   0 0     0   0   16 13     *             *   29 20       0 0     0   0   16 13                 29
2757644 CT     school 901560 520011   Farmington School District 90156001206 520411 East Farms School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 219 * 49   * 138     0   25   247 207     49             34   454 219   49     138     0   25   247 207     49       34   454
2757651 CT     school 901590 530011   Franklin School District 90159000278 530111 Franklin Elementary School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 138 * 9   * *     0   11   86 *     0             13   164 138   9           0   11   86       0       13   164
2757652 CT     school   540011   Glastonbury School District 90162001724 540511 PreK-Eastbury Program           2021   pk_12_total 35 * *   0 *     0   6   33 19     0             35   52 35       0       0   6   33 19     0       35   52
2757655 CT     school 901620 540011   Glastonbury School District 90162000286 540611 Hopewell School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 347 * 60   * 90     0   29   286 256     15             36   542 347   60     90     0   29   286 256     15       36   542
2757658 CT     school   540011   Glastonbury School District 90162001801 540111 Links Academy Program           2021   pk_12_total 30 * 10   0 *     0   *   27 20     0             *   47 30   10   0       0       27 20     0           47
2757660 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 619 * 96   * 116     0   55   448 462     8             92   910 619   96     116     0   55   448 462     8       92   910
2757662 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2021   pk_12_total 10 * *   0 *     0   0   * *     0             16   16 10       0       0   0           0       16   16
2757667 CT     school 901710 570011   Greenwich School District 90171000296 570211 Cos Cob School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 235 * 65   0 34     0   *   187 175     35             41   362 235   65   0 34     0       187 175     35       41   362
2757669 CT     school 901710 570011   Greenwich School District 90171001288 571311 International School At Dundee Public Schools Regular School No Elementary PK 05 2021   pk_12_total 179 * 45   0 96     0   *   180 181     20             23   361 179   45   0 96     0       180 181     20       23   361

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