Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by ell descending

View and edit SQL

grade

year

  • 2019 · 20,186
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
2452390 CT     school 902670 890011   New Britain School District 90267000524 891311 Smith Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 82 56 366   * *     0   16   276 260     79             73   536 82 56 366           0   16   276 260     79       73   536
2452532 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 129 56 203   0 17     0   13   217 201     79             47   418 129 56 203   0 17     0   13   217 201     79       47   418
2452717 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 238 33 42   0 179     0   41   282 251     79             42   533 238 33 42   0 179     0   41   282 251     79       42   533
2452185 CT     school 901920 640011   Hartford School District 90192001295 645411 Hartford Magnet Trinity College Academy Public Schools Regular School No High 06 12 2019   pk_12_total 192 272 485   * 48     *   53   487 570     78             126   1057 192 272 485     48         53   487 570     78       126   1057
2451958 CT     school 901260 430011   East Hartford School District 90126000191 430911 Anna E. Norris School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 11 69 206   0 10     0   12   173 135     77             60   308 11 69 206   0 10     0   12   173 135     77       60   308
2452140 CT     school 901920 640011   Hartford School District 90192001192 642811 Betances Learning Lab Magnet School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 48 64 188   * 78     *   6   194 197     77             50   391 48 64 188     78         6   194 197     77       50   391
2452391 CT     school 902670 890011   New Britain School District 90267000527 891511 Vance Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 70 53 313   * *     0   21   228 235     77             70   463 70 53 313           0   21   228 235     77       70   463
2452153 CT     school 901920 640011   Hartford School District 90192000381 641911 Milner Middle School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 7 126 191   * 0     0   *   168 161     76             26   329 7 126 191     0     0       168 161     76       26   329
2452425 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 53 267 325   * 7     *   *   327 335     76             70   662 53 267 325     7             327 335     76       70   662
2452760 CT     school 904320 1350011   Stamford School District 90432000860 1350611 Newfield School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 194 74 206   0 28     0   22   269 255     76             63   524 194 74 206   0 28     0   22   269 255     76       63   524
2452830 CT     school 904590 1430011   Torrington School District 90459001211 1431311 Vogel-Wetmore School Public Schools Regular School No Elementary KG 03 2019   pk_12_total 384 19 158   0 16     0   18   314 281     76             107   595 384 19 158   0 16     0   18   314 281     76       107   595
2452882 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 138 85 273   0 6     0   39   272 269     76             60   541 138 85 273   0 6     0   39   272 269     76       60   541
2451718 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 367 35 43   * 156     0   *   297 329     75             55   626 367 35 43     156     0       297 329     75       55   626
2452479 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 124 83 242   * 7     *   87   223 323     75             76   546 124 83 242     7         87   223 323     75       76   546
2452549 CT     school 903120 1040011   Norwich School District 90312000668 1042011 Moriarty Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 166 66 127   * *     0   34   210 203     75             62   413 166 66 127           0   34   210 203     75       62   413
2452555 CT     school 903120 1040011   Norwich School District 90312000677 1041811 Veterans' Memorial School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 72 57 113   * 22     *   29   149 149     75             43   298 72 57 113     22         29   149 149     75       43   298
2452754 CT     school 904320 1350011   Stamford School District 90432000859 1350511 K. T. Murphy School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 96 58 242   0 85     0   20   265 236     75             52   501 96 58 242   0 85     0   20   265 236     75       52   501
2452910 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 92 132 288   * *     0   33   294 268     75             68   562 92 132 288           0   33   294 268     75       68   562
2451811 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 447 52 345   0 20     0   46   452 458     74             157   910 447 52 345   0 20     0   46   452 458     74       157   910
2452714 CT     school 904170 1320011   South Windsor School District 90417000824 1320611 Orchard Hill School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 301 36 54   0 187     0   38   295 321     74             54   616 301 36 54   0 187     0   38   295 321     74       54   616
2452895 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 29 101 252   * *     0   18   208 196     74             48   404 29 101 252           0   18   208 196     74       48   404
2452909 CT     school 904830 1510011   Waterbury School District 90483000978 1511311 Hopeville School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 58 58 214   * 0     0   *   181 172     74             50   353 58 58 214     0     0       181 172     74       50   353
2451913 CT     school 901020 340011   Danbury School District 90102000151 341111 Great Plain School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 124 14 125   0 26     0   11   156 144     72             68   300 124 14 125   0 26     0   11   156 144     72       68   300
2452147 CT     school 901920 640011   Hartford School District 90192000366 640911 Environmental Sciences Magnet at Hooker School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 117 70 371   * 29     0   *   312 295     72             62   607 117 70 371     29     0       312 295     72       62   607
2452151 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2019   pk_12_total 177 179 403   * *     0   45   312 521     72             139   833 177 179 403           0   45   312 521     72       139   833
2453035 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2019   pk_12_total 278 8 247   * 6     *   25   289 278     72             70   567 278 8 247     6         25   289 278     72       70   567
2452188 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2019   pk_12_total 150 155 314   * 30     0   *   407 272     71             73   679 150 155 314     30     0       407 272     71       73   679
2452223 CT     school 903450 2450014   Learn 90345000079 2450114 Regional Multicultural Magnet School Regional Education Service Center Schools Regular School No Elementary KG 05 2019   pk_12_total 159 70 208   * 11     *   70   257 263     71             65   520 159 70 208     11         70   257 263     71       65   520
2452267 CT     school 902310 770011   Manchester School District 90231000430 771311 Waddell School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 141 110 122   * 96     *   9   231 250     71             34   481 141 110 122     96         9   231 250     71       34   481
2452418 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 97 255 169   0 20     *   *   270 276     71             57   546 97 255 169   0 20             270 276     71       57   546
2452439 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 121 207 300   0 23     0   7   348 310     71             55   658 121 207 300   0 23     0   7   348 310     71       55   658
2452454 CT     school 902790 930011   New Haven School District 90279000588 933811 Worthington Hooker School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 181 73 59   * 129     0   *   239 214     71             26   453 181 73 59     129     0       239 214     71       26   453
2453118 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 32 177 444   * 13     *   *   339 338     71             64   677 32 177 444     13             339 338     71       64   677
2451770 CT     school 900450 150011   Bridgeport School District 90045001918 153111 Geraldine Claytor Magnet Academy Public Schools Regular School No Elementary PK 08 2019   pk_12_total 42 187 223   * *     *   7   233 233     70             71   466 42 187 223               7   233 233     70       71   466
2451802 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 462 68 313   0 45     *   *   472 446     70             115   918 462 68 313   0 45             472 446     70       115   918
2452137 CT     school 901860 620011   Hamden School District 90186000339 626111 Hamden High School Public Schools Regular School No High 09 12 2019   pk_12_total 533 453 284   6 115     0   63   733 721     70             219   1454 533 453 284   6 115     0   63   733 721     70       219   1454
2452758 CT     school 904320 1350011   Stamford School District 90432000167 1352211 Hart School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 127 81 259   0 108     0   37   305 307     70             59   612 127 81 259   0 108     0   37   305 307     70       59   612
2451749 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 403 31 55   0 10     0   21   245 275     7             50   520 403 31 55   0 10     0   21   245 275     7       50   520
2451841 CT     school 900690 230011   Canton School District 90069000120 230211 Cherry Brook Primary School Public Schools Regular School No Elementary PK 03 2019   pk_12_total 376 25 32   0 *     *   18   225 232     7             47   457 376 25 32   0           18   225 232     7       47   457
2451911 CT     school 900990 330011   Cromwell School District 90099000145 336111 Cromwell High School Public Schools Regular School No High 09 12 2019   pk_12_total 384 51 42   * 39     0   *   272 254     7             58   526 384 51 42     39     0       272 254     7       58   526
2451932 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 386 * *   0 28     0   23   249 211     7             60   460 386       0 28     0   23   249 211     7       60   460
2451981 CT     school 901320 450011   East Lyme School District 90132000225 450111 Flanders School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 251 * 30   0 31     0   *   159 175     7             43   334 251   30   0 31     0       159 175     7       43   334
2451990 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2019   pk_12_total 174 47 55   0 *     0   *   168 127     7             64   295 174 47 55   0       0       168 127     7       64   295
2452005 CT     school 901440 480011   Ellington School District 90144000236 480211 Crystal Lake School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 262 17 18   0 15     0   12   162 162     7             46   324 262 17 18   0 15     0   12   162 162     7       46   324
2452019 CT     school 901470 490011   Enfield School District 90147000248 491811 Henry Barnard School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 241 36 65   0 *     *   22   187 191     7             73   378 241 36 65   0           22   187 191     7       73   378
2452044 CT     school 901530 510011   Fairfield School District 90153000264 511611 North Stratfield School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 282 9 38   0 28     0   20   186 191     7             47   377 282 9 38   0 28     0   20   186 191     7       47   377
2452105 CT     school 901770 590011   Groton School District 90177001488 591911 Northeast Academy Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 307 * 44   0 19     *   33   206 205     7             47   411 307   44   0 19         33   206 205     7       47   411
2452236 CT     school 902130 710011   Lebanon School District 90213000395 710111 Lebanon Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 325 6 22   * 6     *   *   208 158     7             41   366 325 6 22     6             208 158     7       41   366
2452337 CT     school 902520 840011   Milford School District 90252000481 841811 Orchard Hills School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 261 7 29   0 13     0   11   162 159     7             43   321 261 7 29   0 13     0   11   162 159     7       43   321
2452351 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 418 * 52   * 42     0   20   272 276     7             64   548 418   52     42     0   20   272 276     7       64   548
2452441 CT     school 902790 930011   New Haven School District 90279000647 934911 West Rock Authors Academy Public Schools Regular School No Elementary PK 04 2019   pk_12_total 32 89 42   * 6     0   *   87 87     7             13   174 32 89 42     6     0       87 87     7       13   174
2452455 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2019   pk_12_total 0 * *   0 0     0   0   6 8     7             14   14 0       0 0     0   0   6 8     7       14   14
2452508 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 333 * 23   0 *     0   0   188 180     7             40   368 333   23   0       0   0   188 180     7       40   368
2452513 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 213 * 28   0 *     0   9   127 128     7             42   255 213   28   0       0   9   127 128     7       42   255
2452579 CT     school 903270 1090011   Plainfield School District 90327000695 1096111 Plainfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 565 16 20   * 12     *   *   319 306     7             103   625 565 16 20     12             319 306     7       103   625
2452588 CT     school 903330 1110011   Plymouth School District 90333000705 1115111 Eli Terry Jr. Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 308 * 24   * 10     0   6   199 155     7             64   354 308   24     10     0   6   199 155     7       64   354
2452599 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 232 * 28   0 *     *   9   150 128     7             53   278 232   28   0           9   150 128     7       53   278
2452607 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 300 * 48   0 *     0   19   194 *     7             53   379 300   48   0       0   19   194       7       53   379
2452642 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 474 18 37   * 6     0   *   250 288     7             79   538 474 18 37     6     0       250 288     7       79   538
2452683 CT     school 903990 1240011   Seymour School District 90399000794 1245111 Seymour Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 373 25 99   * 19     0   *   264 260     7             77   524 373 25 99     19     0       264 260     7       77   524
2452702 CT     school 904110 1280011   Simsbury School District 90411000810 1280111 Central School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 272 * 32   * 36     0   25   213 164     7             35   377 272   32     36     0   25   213 164     7       35   377
2452707 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2019   pk_12_total 1100 69 113   0 89     *   *   740 652     7             182   1392 1100 69 113   0 89             740 652     7       182   1392
2452725 CT     school 904230 1310011   Southington School District 90423000829 1311511 Derynoski Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 437 11 48   0 16     0   23   280 255     7             69   535 437 11 48   0 16     0   23   280 255     7       69   535
2452730 CT     school 904230 1310011   Southington School District 90423000836 1310611 Oshana Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 202 * 36   0 6     *   13   139 126     7             29   265 202   36   0 6         13   139 126     7       29   265
2452800 CT     school 904440 1380011   Stratford School District 90444000900 1385211 David Wooster Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 207 114 177   0 10     0   16   246 278     7             58   524 207 114 177   0 10     0   16   246 278     7       58   524
2452948 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2019   pk_12_total 643 19 98   * 52     *   20   432 *     7             138   838 643 19 98     52         20   432       7       138   838
2453064 CT     school 905280 1660011   Wolcott School District 90528001102 1665111 Tyrrell Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 447 26 43   * *     0   24   289 263     7             75   552 447 26 43           0   24   289 263     7       75   552
2452894 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 54 89 330   0 *     0   *   249 255     69             49   504 54 89 330   0       0       249 255     69       49   504
2452093 CT     school 901710 570011   Greenwich School District 90171000300 576111 Greenwich High School Public Schools Regular School No High 09 12 2019   pk_12_total 1789 78 588   * 199     *   86   1401 *     68             316   2746 1789 78 588     199         86   1401       68       316   2746
2452883 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 75 103 258   * *     0   19   257 216     68             87   473 75 103 258           0   19   257 216     68       87   473
2452959 CT     school 904920 1550011   West Hartford School District 90492001217 1551711 Smith School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 110 49 116   0 67     0   9   182 169     68             26   351 110 49 116   0 67     0   9   182 169     68       26   351
2452982 CT     school 904950 1560011   West Haven School District 90495001027 1560811 Alma E. Pagels School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 143 82 98   * 24     0   *   210 150     68             101   360 143 82 98     24     0       210 150     68       101   360
2452533 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 256 47 155   * 9     *   20   234 255     67             62   489 256 47 155     9         20   234 255     67       62   489
2452673 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 378 * 68   * 113     0   26   301 307     67             61   608 378   68     113     0   26   301 307     67       61   608
2451782 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 34 172 280   * *     0   0   257 233     66             94   490 34 172 280           0   0   257 233     66       94   490
2452298 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 259 82 371   * *     0   27   393 362     66             139   755 259 82 371           0   27   393 362     66       139   755
2452538 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 186 74 261   0 17     0   11   296 253     66             76   549 186 74 261   0 17     0   11   296 253     66       76   549
2452950 CT     school 904890 1530011   Watertown School District 90489001135 1530211 John Trumbull Primary School Public Schools Regular School No Elementary PK 03 2019   pk_12_total 572 19 34   * *     0   17   359 297     66             81   656 572 19 34           0   17   359 297     66       81   656
2452986 CT     school 904950 1560011   West Haven School District 90495001039 1560411 Seth G. Haley School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 197 61 95   * 13     0   *   206 175     65             62   381 197 61 95     13     0       206 175     65       62   381
2452833 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 601 42 259   * 42     *   37   516 469     64             185   985 601 42 259     42         37   516 469     64       185   985
2452480 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 150 84 191   * 10     *   78   279 237     62             70   516 150 84 191     10         78   279 237     62       70   516
2452798 CT     school 904440 1380011   Stratford School District 90444000892 1381511 Stratford Academy - Johnson House Public Schools Regular School No Elementary 02 06 2019   pk_12_total 81 167 184   0 *     *   24   224 248     62             65   472 81 167 184   0           24   224 248     62       65   472
2452834 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2019   pk_12_total 497 43 241   * 43     *   25   458 395     62             158   853 497 43 241     43         25   458 395     62       158   853
2452899 CT     school 904830 1510011   Waterbury School District 90483000685 1513211 Woodrow Wilson School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 18 109 271   * *     *   10   231 184     62             53   415 18 109 271               10   231 184     62       53   415
2452154 CT     school 901920 640011   Hartford School District 90192001641 640511 Montessori Magnet at Batchelder School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 85 58 177   * 11     0   *   163 182     61             36   345 85 58 177     11     0       163 182     61       36   345
2452466 CT     school 902790 930011   New Haven School District 90279000556 936311 Hill Regional Career High School Public Schools Regular School No High 09 12 2019   pk_12_total 59 295 305   * 30     0   *   295 405     61             70   700 59 295 305     30     0       295 405     61       70   700
2452808 CT     school 904440 1380011   Stratford School District 90444000897 1386111 Stratford High School Public Schools Regular School No High 09 12 2019   pk_12_total 367 237 313   0 31     *   *   503 470     61             106   973 367 237 313   0 31             503 470     61       106   973
2452891 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 33 107 318   * *     0   17   252 226     61             80   478 33 107 318           0   17   252 226     61       80   478
2452283 CT     school 902400 800011   Meriden School District 90240000443 800411 Israel Putnam School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 142 42 262   0 18     0   25   230 259     60             56   489 142 42 262   0 18     0   25   230 259     60       56   489
2452550 CT     school 903120 1040011   Norwich School District 90312000672 1040811 Samuel Huntington School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 155 66 84   0 *     *   50   187 *     60             51   372 155 66 84   0           50   187       60       51   372
2453015 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 285 15 93   0 16     0   23   218 214     60             57   432 285 15 93   0 16     0   23   218 214     60       57   432
2453084 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes Middle 06 10 2019   pk_12_total 22 224 209   * 0     *   7   216 249     60             85   465 22 224 209     0         7   216 249     60       85   465
2451721 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 339 21 34   0 96     0   21   251 260     6             48   511 339 21 34   0 96     0   21   251 260     6       48   511
2451730 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2019   pk_12_total 724 23 93   0 35     0   24   487 412     6             94   899 724 23 93   0 35     0   24   487 412     6       94   899
2451904 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 334 * 17   0 *     0   10   201 171     6             54   372 334   17   0       0   10   201 171     6       54   372
2451929 CT     school 901020 340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program Alternative School No Not reported M M 2019   pk_12_total 30 10 44   * *     0   *   49 42     6             16   91 30 10 44           0       49 42     6       16   91
2451942 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 147 56 109   0 *     *   18   167 174     6             69   341 147 56 109   0           18   167 174     6       69   341
2451969 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2019   pk_12_total 43 59 48   * 35     0   *   83 108     6             *   191 43 59 48     35     0       83 108     6           191
2451971 CT     school 901260 430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program Alternative School No High 10 12 2019   pk_12_total * 28 50   0 0     0   *   63 31     6             21   94   28 50   0 0     0       63 31     6       21   94
2451983 CT     school 901320 450011   East Lyme School District 90132000227 450211 Niantic Center School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 146 * 11   0 *     0   13   88 88     6             23   176 146   11   0       0   13   88 88     6       23   176

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