Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2020 · 20,454
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
2777725 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 158 * 24   0 0     0   *   99 96     *             21   195 158   24   0 0     0       99 96             21   195
2777732 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   8 0       0 0     0   0           0           8
2777737 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2020   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2777751 CT     school 900150 50011   Barkhamsted School District 90015000015 50111 Barkhamsted Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 183 * *   0 *     0   9   94 103     0             48   197 183       0       0   9   94 103     0       48   197
2777756 CT     school 900210 70011   Berlin School District 90021000021 70111 Richard D. Hubbard School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 156 * 28   0 16     0   *   97 116     29             30   213 156   28   0 16     0       97 116     29       30   213
2777758 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2020   pk_12_total 741 * 87   * 39     0   30   486 425     6             113   911 741   87     39     0   30   486 425     6       113   911
2777760 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 306 * 28   * 23     0   7   174 195     13             51   369 306   28     23     0   7   174 195     13       51   369
2777762 CT     school 900270 90011   Bethel School District 90027000023 90411 Anna H. Rockwell School Public Schools Regular School No Elementary KG 03 2020   pk_12_total 255 * 103   * 28     0   20   221 203     61             34   424 255   103     28     0   20   221 203     61       34   424
2777780 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 146 * 20   0 0     0   *   101 84     *             28   185 146   20   0 0     0       101 84             28   185
2777781 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2020   pk_12_total 33 * 10   0 *     0   *   29 21     0             27   50 33   10   0       0       29 21     0       27   50
2777784 CT     school 900420 140011   Branford School District 90042000042 141411 Mary T. Murphy School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 232 * 64   * 48     0   21   185 200     62             44   385 232   64     48     0   21   185 200     62       44   385
2777787 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2020   pk_12_total 20 * *   0 0     0   0   18 9     0             *   27 20       0 0     0   0   18 9     0           27
2777835 CT     school 900510 170011   Bristol School District 90051000096 170311 Edgewood School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 145 * 99   * 15     0   13   150 136     20             35   286 145   99     15     0   13   150 136     20       35   286
2777837 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2777838 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   *         0 0     0   0                        
2777839 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2020   pk_12_total * * 6   0 0     0   *   * *     *             11   11     6   0 0     0                       11   11
2777840 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2020   pk_12_total * * *   * *     0   0   * *     0             14   14                 0   0           0       14   14
2777844 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2777845 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2020   pk_12_total * * *   0 0     0   *   7 0     *             7   7         0 0     0       7 0             7   7
2777846 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2020   pk_12_total 12 * *   0 0     0   0   18 6     *             24   24 12       0 0     0   0   18 6             24   24
2777847 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2020   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2777851 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2777855 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2020   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2777857 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2777861 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2020   pk_12_total 26 * 11   0 0     0   *   32 8     0             0   40 26   11   0 0     0       32 8     0       0   40
2777862 CT     school   170011   Bristol School District   170211 ACCESS Program           2020   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
2777863 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2020   pk_12_total 17 * *   0 0     0   *   13 11     *             24   24 17       0 0     0       13 11             24   24
2777864 CT     school 900540 180011   Brookfield School District 90054000110 180311 Center Elementary School Public Schools Regular School No Elementary PK 01 2020   pk_12_total 320 * 34   * 16     0   9   191 197     28             61   388 320   34     16     0   9   191 197     28       61   388
2777869 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 268 * 34   0 11     *   20   184 156     *             56   340 268   34   0 11         20   184 156             56   340
2777870 CT     school 900660 220011   Canterbury School District 90066001188 220211 Canterbury Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 263 * 18   0 *     0   *   153 139     0             35   292 263   18   0       0       153 139     0       35   292
2777885 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2020   pk_12_total * * *   0 0     0   0   * *     0             0   9         0 0     0   0           0       0   9
2777888 CT     school   2410014   Capitol Region Education Council 90070001154 2419014 John J. Allison Polaris Center Program           2020   pk_12_total * * 34   0 0     0   0   37 18     6             *   55     34   0 0     0   0   37 18     6           55
2777896 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2020   pk_12_total 8 * 0   0 0     0   *   * *     0             *   11 8   0   0 0     0               0           11
2777902 CT     school 900720 240011   Chaplin School District 90072000121 240211 Chaplin Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 121 * 8   0 *     0   *   72 67     *             29   139 121   8   0       0       72 67             29   139
2777903 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   pk_12_total 138 * *   0 14     0   16   114 71     *             50   185 138       0 14     0   16   114 71             50   185
2777904 CT     school 900750 250011   Cheshire School District 90075000127 250411 Highland School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 557 * 54   * 75     0   17   358 363     16             68   721 557   54     75     0   17   358 363     16       68   721
2777905 CT     school 900750 250011   Cheshire School District 90075000122 250111 Chapman School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 271 * 15   0 13     0   *   170 145     *             28   315 271   15   0 13     0       170 145             28   315
2777906 CT     school   250011   Cheshire School District   250711 Highland School Autism Program Program           2020   pk_12_total 12 * *   0 *     0   0   * *     0             17   17 12       0       0   0           0       17   17
2777908 CT     school   250011   Cheshire School District   251111 Doolittle Bridges Program Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2777912 CT     school   250011   Cheshire School District 90075001682 250911 Humiston Alternative School Program           2020   pk_12_total 27 * *   0 0     0   0   15 15     0             *   30 27       0 0     0   0   15 15     0           30
2777915 CT     school 900810 270011   Clinton School District 90081000132 270311 Lewin G. Joel Jr. School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 405 * 128   * 13     0   9   292 267     54             73   559 405   128     13     0   9   292 267     54       73   559
2777916 CT     school 900810 270011   Clinton School District 90081000133 275111 Jared Eliot School Public Schools Regular School No Middle 05 08 2020   pk_12_total 398 * 93   * 17     0   8   271 251     30             84   522 398   93     17     0   8   271 251     30       84   522
2777917 CT     school 900810 270011   Clinton School District 90081000134 276111 The Morgan School Public Schools Regular School No High 09 12 2020   pk_12_total 484 * 83   * 18     *   7   306 292     19             81   598 484   83     18         7   306 292     19       81   598
2777918 CT     school 900840 280011   Colchester School District 90084001444 280411 Colchester Elementary School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 481 * 40   0 *     0   26   290 265     6             117   555 481   40   0       0   26   290 265     6       117   555
2777919 CT     school 900840 280011   Colchester School District 90084000137 280211 Jack Jackter Intermediate School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 383 * 33   0 13     *   20   235 221     *             73   456 383   33   0 13         20   235 221             73   456
2777920 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 434 * 39   * 16     0   22   259 258     *             79   517 434   39     16     0   22   259 258             79   517
2777924 CT     school 900900 300011   Columbia School District 90090000139 300111 Horace W. Porter School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 363 * 28   * *     0   12   223 185     *             44   408 363   28           0   12   223 185             44   408
2777932 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2020   pk_12_total 18 * 7   0 *     0   *   27 6     *             33   33 18   7   0       0       27 6             33   33
2777935 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 312 * 33   0 *     0   12   196 171     6             58   367 312   33   0       0   12   196 171     6       58   367
2777936 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2020   pk_12_total 355 * 23   0 *     0   13   204 196     0             51   400 355   23   0       0   13   204 196     0       51   400
2777938 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2020   pk_12_total 379 * 28   * *     0   19   * 234     0             54   431 379   28           0   19     234     0       54   431
2777943 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 46 * 81   0 13     0   *   101 54     0             80   155 46   81   0 13     0       101 54     0       80   155
2777962 CT     school   340011   Danbury School District   340711 Western Connection Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             11   11     0   0 0     0   0           0       11   11
2777963 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 381 * 27   0 27     0   *   252 208     9             72   460 381   27   0 27     0       252 208     9       72   460
2777968 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 979 * 65   * 66     0   33   584 572     6             169   1156 979   65     66     0   33   584 572     6       169   1156
2777974 CT     school   370011   Derby School District   370511 RAISE Academy Program           2020   pk_12_total 8 * *   0 0     0   *   * *     0             9   17 8       0 0     0               0       9   17
2777981 CT     school 901200 410011   East Haddam School District 90120000184 410111 East Haddam Elementary School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 289 * 11   * *     0   10   172 143     0             42   315 289   11           0   10   172 143     0       42   315
2777982 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2020   pk_12_total 342 * 18   * *     0   9   192 187     *             62   379 342   18           0   9   192 187             62   379
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
2777984 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 501 * 40   0 10     *   20   309 269     *             104   578 501   40   0 10         20   309 269             104   578
2777985 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2020   pk_12_total 258 * 14   0 *     0   14   133 160     *             37   293 258   14   0       0   14   133 160             37   293
2777986 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 412 * 29   * *     *   12   218 244     0             57   462 412   29               12   218 244     0       57   462
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
2778004 CT     school 901290 440011   East Haven School District 90129000214 440111 Deer Run School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 138 * 68   0 8     *   11   131 103     19             75   234 138   68   0 8         11   131 103     19       75   234
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
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
2778012 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2020   pk_12_total 47 * *   0 *     0   0   24 26     0             24   50 47       0       0   0   24 26     0       24   50
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
2778014 CT     school 901320 450011   East Lyme School District 90132000226 450411 Lillie B. Haynes School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 222 * 20   * 40     0   18   172 138     16             54   310 222   20     40     0   18   172 138     16       54   310
2778015 CT     school 901320 450011   East Lyme School District 90132000227 450211 Niantic Center School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 186 * 25   0 *     0   13   117 115     11             34   232 186   25   0       0   13   117 115     11       34   232
2778016 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 589 * 68   * 77     0   38   404 385     7             129   789 589   68     77     0   38   404 385     7       129   789
2778019 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     *             10   10     0   0 0     0   0                   10   10
2778025 CT     school 901410 460011   Easton School District 90141000234 460111 Samuel Staples Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 459 * 40   0 31     *   17   295 266     16             94   561 459   40   0 31         17   295 266     16       94   561
2778028 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2020   pk_12_total 14 * 7   * *     0   0   25 0     0             25   25 14   7           0   0   25 0     0       25   25
2778029 CT     school   2420014   EdAdvance   2420114 Steps Program           2020   pk_12_total 16 * 7   * 0     0   0   * *     *             29   29 16   7     0     0   0                   29   29
2778032 CT     school   2420014   EdAdvance   2420514 University Pathways Program Program           2020   pk_12_total 9 * *   0 0     0   0   9 6     0             15   15 9       0 0     0   0   9 6     0       15   15
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
2778043 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2020   pk_12_total 59 * 29   0 *     0   9   55 47     0             10   102 59   29   0       0   9   55 47     0       10   102
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            
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
2778054 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2778057 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2020   pk_12_total * * *   0 *     0   0   * *     *             12   12         0       0   0                   12   12
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
2778063 CT     school 901500 500011   Essex School District 90150000255 500111 Essex Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 280 * 25   0 *     0   17   172 158     8             60   330 280   25   0       0   17   172 158     8       60   330
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
2778066 CT     school 901530 510011   Fairfield School District 90153000269 511311 Sherman School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 370 * 25   0 *     0   18   206 217     *             53   423 370   25   0       0   18   206 217             53   423
2778067 CT     school 901530 510011   Fairfield School District 90153001378 510211 Burr Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 262 * 35   * 29     0   31   187 179     15             49   366 262   35     29     0   31   187 179     15       49   366
2778072 CT     school 901530 510011   Fairfield School District 90153000263 510711 Mill Hill School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 286 * 19   * 24     0   20   184 170     *             60   354 286   19     24     0   20   184 170             60   354
2778075 CT     school 901530 510011   Fairfield School District 90153000267 511211 Riverfield School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 341 * 26   0 *     0   20   223 183     *             51   406 341   26   0       0   20   223 183             51   406
2778078 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 706 * 53   * 42     0   34   441 404     *             107   845 706   53     42     0   34   441 404             107   845
2778080 CT     school 901530 510011   Fairfield School District 90153001379 516011 Fairfield Ludlowe High School Public Schools Regular School No High 09 12 2020   pk_12_total 1213 * 130   * 90     0   45   713 787     *             191   1500 1213   130     90     0   45   713 787             191   1500
2778081 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2020   pk_12_total 1022 * 225   0 85     *   55   740 698     42             198   1438 1022   225   0 85         55   740 698     42       198   1438
2778082 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2020   pk_12_total 19 * *   0 0     0   0   20 7     *             *   27 19       0 0     0   0   20 7                 27
2778083 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2020   pk_12_total 16 * *   0 *     0   0   13 7     0             20   20 16       0       0   0   13 7     0       20   20
2778085 CT     school 901560 520011   Farmington School District 90156000276 520111 Union School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 189 * 37   * 48     0   31   171 148     14             39   319 189   37     48     0   31   171 148     14       39   319
2778088 CT     school 901560 520011   Farmington School District 90156000277 520311 West District School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 201 * 31   * 61     0   16   170 153     38             27   323 201   31     61     0   16   170 153     38       27   323
2778092 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2020   pk_12_total * * *   0 *     0   0   * *     *             *   7         0       0   0                       7
2778093 CT     school 901590 530011   Franklin School District 90159000278 530111 Franklin Elementary School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 134 * 12   * *     0   7   86 *     *             7   159 134   12           0   7   86               7   159

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