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,286
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
2452287 CT     school 902400 800011   Meriden School District 90240000450 800811 Roger Sherman School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 98 37 321   * 7     *   22   250 237     99             80   487 98 37 321     7         22   250 237     99       80   487
2452888 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 117 135 349   8 25     0   24   369 289     96             76   658 117 135 349   8 25     0   24   369 289     96       76   658
2452285 CT     school 902400 800011   Meriden School District 90240000448 800711 Nathan Hale School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 159 67 339   0 9     0   22   317 279     95             80   596 159 67 339   0 9     0   22   317 279     95       80   596
2451766 CT     school 900450 150011   Bridgeport School District 90045000054 150411 Bryant School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 59 138 132   17 *     0   *   180 186     94             73   366 59 138 132   17       0       180 186     94       73   366
2452539 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 166 135 338   * 26     0   *   349 326     93             110   675 166 135 338     26     0       349 326     93       110   675
2452187 CT     school 901920 640011   Hartford School District 90192000371 641211 McDonough Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total * 35 249   0 *     0   0   162 132     92             69   294   35 249   0       0   0   162 132     92       69   294
2452989 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 281 211 357   * 30     *   36   510 408     91             145   918 281 211 357     30         36   510 408     91       145   918
2451780 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 57 331 388   * *     *   12   405 392     90             113   797 57 331 388               12   405 392     90       113   797
2451964 CT     school 901260 430011   East Hartford School District 90126000206 431811 Robert J. O'Brien School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 19 130 211   0 *     *   14   193 193     90             57   386 19 130 211   0           14   193 193     90       57   386
2452273 CT     school 902310 770011   Manchester School District 90231000424 776111 Manchester High School Public Schools Regular School No High 09 12 2019   pk_12_total 562 399 452   * 128     *   77   821 807     90             180   1628 562 399 452     128         77   821 807     90       180   1628
2452763 CT     school 904320 1350011   Stamford School District 90432000868 1352111 Stillmeadow School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 203 52 305   0 42     *   *   336 300     90             101   636 203 52 305   0 42             336 300     90       101   636
2451716 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 344 8 31   0 *     *   20   210 199     9             47   409 344 8 31   0           20   210 199     9       47   409
2451720 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   pk_12_total 309 28 44   * 104     0   *   243 266     9             49   509 309 28 44     104     0       243 266     9       49   509
2451732 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 294 * 32   * 28     0   *   173 191     9             53   364 294   32     28     0       173 191     9       53   364
2451936 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 380 * *   0 23     0   25   230 219     9             53   449 380       0 23     0   25   230 219     9       53   449
2451968 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 46 92 152   * *     0   18   152 171     9             50   323 46 92 152           0   18   152 171     9       50   323
2451989 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 180 42 77   * 11     0   *   162 157     9             63   319 180 42 77     11     0       162 157     9       63   319
2452027 CT     school 901470 490011   Enfield School District 90147000254 491511 Prudence Crandall School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 265 28 77   * 16     0   *   213 186     9             62   399 265 28 77     16     0       213 186     9       62   399
2452033 CT     school 901500 500011   Essex School District 90150000255 500111 Essex Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 281 * 24   0 *     0   19   176 156     9             59   332 281   24   0       0   19   176 156     9       59   332
2452037 CT     school 901530 510011   Fairfield School District 90153000270 511411 Stratfield School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 336 7 51   0 17     0   21   232 200     9             39   432 336 7 51   0 17     0   21   232 200     9       39   432
2452141 CT     school 901920 640011   Hartford School District 90192001534 643511 Breakthrough Magnet School, North Public Schools Regular School No Elementary PK 05 2019   pk_12_total 20 122 65   * 63     *   21   152 144     9             30   296 20 122 65     63         21   152 144     9       30   296
2452176 CT     school   640011   Hartford School District 90192001732 645711 iGOAL 1 - M.D. Fox School Program           2019   pk_12_total 0 * 16   0 *     0   0   * *     9             20   20 0   16   0       0   0           9       20   20
2452203 CT     school   640011   Hartford School District 90192001660 644911 iGOAL 1 - HPHS Program           2019   pk_12_total * 11 12   0 *     0   0   * *     9             25   25   11 12   0       0   0           9       25   25
2452216 CT     school 902070 690011   Killingly School District 90207000391 690111 Killingly Central School Public Schools Regular School No Elementary PK 01 2019   pk_12_total 300 * 43   * *     0   41   193 199     9             60   392 300   43           0   41   193 199     9       60   392
2452218 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 08 2019   pk_12_total 515 15 60   * 24     *   31   315 333     9             87   648 515 15 60     24         31   315 333     9       87   648
2452313 CT     school 902490 830011   Middletown School District 90249000453 830211 Bielefield School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 101 72 56   0 15     0   37   131 150     9             42   281 101 72 56   0 15     0   37   131 150     9       42   281
2452318 CT     school 902490 830011   Middletown School District 90249000460 831211 Moody School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 129 24 28   0 15     0   26   116 106     9             22   222 129 24 28   0 15     0   26   116 106     9       22   222
2452334 CT     school 902520 840011   Milford School District 90252000471 841911 J. F. Kennedy School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 208 13 50   0 41     0   12   169 155     9             43   324 208 13 50   0 41     0   12   169 155     9       43   324
2452335 CT     school 902520 840011   Milford School District 90252000476 841611 Live Oaks School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 228 * 27   * 30     0   12   169 134     9             50   303 228   27     30     0   12   169 134     9       50   303
2452343 CT     school 902520 840011   Milford School District 90252000468 845211 Harborside Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 332 10 59   * 53     0   *   256 204     9             66   460 332 10 59     53     0       256 204     9       66   460
2452344 CT     school 902520 840011   Milford School District 90252000474 845311 West Shore Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 314 33 65   * 44     *   *   237 225     9             61   462 314 33 65     44             237 225     9       61   462
2452398 CT     school   890011   New Britain School District 90267001557 899111 Brookside School Program           2019   pk_12_total * 7 25   0 0     0   *   22 15     9             18   37   7 25   0 0     0       22 15     9       18   37
2452405 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 1102 8 72   * 105     *   42   686 648     9             162   1334 1102 8 72     105         42   686 648     9       162   1334
2452471 CT     school   930011   New Haven School District 90279001550 939111 Riverside Education Academy Program           2019   pk_12_total 6 72 47   0 0     0   0   77 48     9             69   125 6 72 47   0 0     0   0   77 48     9       69   125
2452565 CT     school 903210 1070011   Orange School District 90321001225 1070211 Mary L. Tracy School Public Schools Regular School No Elementary PK KG 2019   pk_12_total 143 * 14   0 22     0   *   86 105     9             25   191 143   14   0 22     0       86 105     9       25   191
2452577 CT     school 903270 1090011   Plainfield School District 90327000696 1090311 Plainfield Memorial School Public Schools Regular School No Elementary 04 05 2019   pk_12_total 273 12 16   * 6     *   *   155 159     9             45   314 273 12 16     6             155 159     9       45   314
2452634 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 284 10 21   * 16     0   *   167 173     9             40   340 284 10 21     16     0       167 173     9       40   340
2452641 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 245 * 30   0 *     0   8   155 141     9             36   296 245   30   0       0   8   155 141     9       36   296
2452679 CT     school 903930 1220011   Salisbury School District 90393000788 1220111 Salisbury Central School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 231 9 17   * *     0   22   137 150     9             29   287 231 9 17           0   22   137 150     9       29   287
2452684 CT     school 903990 1240011   Seymour School District 90399000793 1246111 Seymour High School Public Schools Regular School No High 09 12 2019   pk_12_total 511 35 81   * 26     0   *   318 342     9             81   660 511 35 81     26     0       318 342     9       81   660
2452727 CT     school 904230 1310011   Southington School District 90423000831 1310211 Hatton Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 263 * 27   * 7     0   16   163 158     9             43   321 263   27     7     0   16   163 158     9       43   321
2452880 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2019   pk_12_total 608 20 102   0 59     0   6   380 415     9             87   795 608 20 102   0 59     0   6   380 415     9       87   795
2452930 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2019   pk_12_total 138 51 121   * *     0   17   137 197     9             47   334 138 51 121           0   17   137 197     9       47   334
2452968 CT     school 904920 1550011   West Hartford School District 90492001019 1551011 Norfeldt School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 186 * 27   0 38     *   27   157 148     9             24   305 186   27   0 38         27   157 148     9       24   305
2452998 CT     school 905010 1570011   Weston School District 90501001045 1570111 Hurlbutt Elementary School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 300 11 49   0 22     0   36   228 190     9             52   418 300 11 49   0 22     0   36   228 190     9       52   418
2453013 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2019   pk_12_total 1560 44 107   0 110     0   37   959 899     9             218   1858 1560 44 107   0 110     0   37   959 899     9       218   1858
2453079 CT     school 901080 360011   Deep River School District 90108000173 360111 Deep River Elementary School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 205 * 21   0 *     0   10   125 117     9             33   242 205   21   0       0   10   125 117     9       33   242
2453140 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2019   pk_12_total 783 * 96   0 45     *   144   533 558     9             135   1091 783   96   0 45         144   533 558     9       135   1091
2453144 CT     school 900031 2820013   Stamford Academy District 90003101405 2826013 Stamford Academy   Regular School Yes High 09 12 2019   pk_12_total 9 70 66   0 *     0   *   84 68     9             54   152 9 70 66   0       0       84 68     9       54   152
2452762 CT     school 904320 1350011   Stamford School District 90432000866 1351111 Springdale School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 178 47 307   * *     0   30   282 293     89             45   575 178 47 307           0   30   282 293     89       45   575
2452829 CT     school 904590 1430011   Torrington School District 90459000923 1430911 Torringford School Public Schools Regular School No Elementary KG 03 2019   pk_12_total 378 25 195   0 37     *   *   328 330     89             119   658 378 25 195   0 37             328 330     89       119   658
2451776 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 188 201 215   * 37     *   18   354 310     88             80   664 188 201 215     37         18   354 310     88       80   664
2451959 CT     school 901260 430011   East Hartford School District 90126000194 430611 Dr. Franklin H. Mayberry School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 21 117 195   * *     0   14   177 184     88             57   361 21 117 195           0   14   177 184     88       57   361
2452171 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Other KG 12 2019   pk_12_total * 345 238   0 *     0   8   284 315     88             97   599   345 238   0       0   8   284 315     88       97   599
2451917 CT     school 901020 340011   Danbury School District 90102000158 341511 Pembroke School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 122 21 157   0 32     0   13   212 133     87             115   345 122 21 157   0 32     0   13   212 133     87       115   345
2451960 CT     school 901260 430011   East Hartford School District 90126000195 432211 Dr. John A. Langford School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 31 109 199   0 8     0   6   209 144     87             65   353 31 109 199   0 8     0   6   209 144     87       65   353
2452756 CT     school 904320 1350011   Stamford School District 90432000865 1350911 Roxbury School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 170 90 249   * 35     *   23   299 272     87             87   571 170 90 249     35         23   299 272     87       87   571
2452769 CT     school 904320 1350011   Stamford School District 90432001353 1355811 Rippowam Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 222 153 317   * 37     *   19   385 366     87             116   751 222 153 317     37         19   385 366     87       116   751
2452990 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 315 234 352   * 26     *   29   466 494     87             144   960 315 234 352     26         29   466 494     87       144   960
2453018 CT     school 905070 1590011   Wethersfield School District 90507001060 1591011 Charles Wright School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 213 7 79   0 11     0   18   168 160     87             41   328 213 7 79   0 11     0   18   168 160     87       41   328
2451846 CT     school 900700 2410014   Capitol Region Education Council 90070001629 2410714 Academy of Aerospace and Engineering Elementary Regional Education Service Center Schools Regular School No Elementary PK 05 2019   pk_12_total 121 124 150   * 85     *   19   263 238     86             68   501 121 124 150     85         19   263 238     86       68   501
2452925 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 83 234 576   * *     0   24   463 465     86             182   928 83 234 576           0   24   463 465     86       182   928
2453041 CT     school 905190 1630011   Windham School District 90519001085 1630511 Windham Center School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 65 * 160   0 0     0   *   117 112     86             34   229 65   160   0 0     0       117 112     86       34   229
2452759 CT     school 904320 1350011   Stamford School District 90432000858 1351211 Julia A. Stark School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 195 86 279   0 *     *   21   326 274     85             73   600 195 86 279   0           21   326 274     85       73   600
2452428 CT     school 902790 930011   New Haven School District 90279000552 934611 East Rock Community Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 69 176 205   * 25     0   *   222 260     84             71   482 69 176 205     25     0       222 260     84       71   482
2452557 CT     school 903120 1040011   Norwich School District 90312000670 1045111 Kelly STEAM Magnet Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 182 109 226   0 *     *   70   316 315     84             78   631 182 109 226   0           70   316 315     84       78   631
2451925 CT     school 901020 340011   Danbury School District 90102001166 341711 King Street Intermediate School Public Schools Regular School No Elementary 04 05 2019   pk_12_total 141 28 178   0 13     0   10   * 187     83             34   370 141 28 178   0 13     0   10     187     83       34   370
2452221 CT     school 903450 2450014   Learn 90345001627 2450314 Riverside Magnet School at Goodwin University Regional Education Service Center Schools Regular School No Elementary PK 05 2019   pk_12_total 109 126 189   * 11     *   26   230 234     83             50   464 109 126 189     11         26   230 234     83       50   464
2452548 CT     school 903120 1040011   Norwich School District 90312000667 1041411 John B. Stanton School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 68 57 136   * 23     *   32   172 147     83             46   319 68 57 136     23         32   172 147     83       46   319
2452768 CT     school 904320 1350011   Stamford School District 90432000853 1355311 Dolan School Public Schools Regular School No Middle 06 08 2019   pk_12_total 203 107 253   * 26     *   12   303 301     83             107   604 203 107 253     26         12   303 301     83       107   604
2452042 CT     school 901530 510011   Fairfield School District 90153000262 510611 McKinley School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 195 28 144   0 44     0   27   224 214     82             49   438 195 28 144   0 44     0   27   224 214     82       49   438
2452554 CT     school 903120 1040011   Norwich School District 90312000676 1041911 Uncas Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 51 70 111   0 *     *   19   131 135     82             34   266 51 70 111   0           19   131 135     82       34   266
2451979 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 567 30 239   0 47     *   *   473 424     81             124   897 567 30 239   0 47             473 424     81       124   897
2452386 CT     school 902670 890011   New Britain School District 90267000514 890711 Jefferson Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 123 43 257   0 17     *   *   230 223     81             61   453 123 43 257   0 17             230 223     81       61   453
2452753 CT     school 904320 1350011   Stamford School District 90432000852 1352011 Davenport Ridge School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 298 83 172   * 52     *   18   326 300     81             65   626 298 83 172     52         18   326 300     81       65   626
2452767 CT     school 904320 1350011   Stamford School District 90432000851 1355611 Cloonan School Public Schools Regular School No Middle 06 08 2019   pk_12_total 173 129 265   * 41     *   20   352 280     81             100   632 173 129 265     41         20   352 280     81       100   632
2452382 CT     school 902670 890011   New Britain School District 90267000513 890611 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 176 54 230   0 33     0   25   275 243     80             52   518 176 54 230   0 33     0   25   275 243     80       52   518
2451743 CT     school 900330 110011   Bloomfield School District 90033000033 110511 Metacomet School Public Schools Regular School No Elementary 03 04 2019   pk_12_total 8 213 28   * *     0   10   129 134     8             45   263 8 213 28           0   10   129 134     8       45   263
2451772 CT     school 900450 150011   Bridgeport School District 90045000066 151211 Hallen School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 30 154 98   0 *     0   *   163 126     8             70   289 30 154 98   0       0       163 126     8       70   289
2451774 CT     school 900450 150011   Bridgeport School District 90045001590 153711 Interdistrict Discovery Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 143 139 165   * 27     0   *   223 265     8             42   488 143 139 165     27     0       223 265     8       42   488
2452038 CT     school 901530 510011   Fairfield School District 90153000269 511311 Sherman School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 378 * 29   * 9     0   25   214 233     8             48   447 378   29     9     0   25   214 233     8       48   447
2452060 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 405 27 54   0 156     0   13   333 322     8             78   655 405 27 54   0 156     0   13   333 322     8       78   655
2452082 CT     school 901710 570011   Greenwich School District 90171000107 571111 Parkway School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 206 0 23   0 14     0   8   144 107     8             39   251 206 0 23   0 14     0   8   144 107     8       39   251
2452091 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 613 11 103   0 86     0   32   417 428     8             110   845 613 11 103   0 86     0   32   417 428     8       110   845
2452175 CT     school   640011   Hartford School District   644711 iGOAL 1 - Burns School Program           2019   pk_12_total 0 * 21   0 *     0   0   20 8     8             28   28 0   21   0       0   0   20 8     8       28   28
2452278 CT     school 902340 780011   Mansfield School District 90234000434 780211 Dorothy C. Goodwin School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 120 * 16   0 34     0   *   102 84     8             12   186 120   16   0 34     0       102 84     8       12   186
2452360 CT     school 902580 860011   Montville School District 90258000035 865111 Leonard J. Tyl Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 333 * 52   9 34     *   64   244 256     8             84   500 333   52   9 34         64   244 256     8       84   500
2452426 CT     school 902790 930011   New Haven School District 90279000551 930911 Davis Academy for Arts & Design Innovation Public Schools Regular School No Elementary PK 08 2019   pk_12_total 99 309 91   * *     0   10   251 266     8             59   517 99 309 91           0   10   251 266     8       59   517
2452502 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 302 * 38   * 12     0   8   189 175     8             47   364 302   38     12     0   8   189 175     8       47   364
2452514 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 275 13 28   * 11     0   *   174 160     8             18   334 275 13 28     11     0       174 160     8       18   334
2452552 CT     school   1040011   Norwich School District   1040411 Strive Autism Program @ Huntington Program           2019   pk_12_total 7 * 6   0 *     0   *   * *     8             21   21 7   6   0       0               8       21   21
2452587 CT     school 903330 1110011   Plymouth School District 90333001521 1110411 Harry S. Fisher Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 261 * 51   0 *     0   18   180 157     8             58   337 261   51   0       0   18   180 157     8       58   337
2452600 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2019   pk_12_total 221 7 31   0 *     *   12   122 152     8             45   274 221 7 31   0           12   122 152     8       45   274
2452602 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 384 9 47   * 10     *   13   236 229     8             90   465 384 9 47     10         13   236 229     8       90   465
2452658 CT     school 903810 1180011   Ridgefield School District 90381000525 1180611 Branchville Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 303 * 23   * 20     0   12   201 159     8             59   360 303   23     20     0   12   201 159     8       59   360
2452659 CT     school 903810 1180011   Ridgefield School District 90381000778 1180311 Ridgebury Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 266 * 35   0 19     0   *   177 155     8             42   332 266   35   0 19     0       177 155     8       42   332
2452724 CT     school 904230 1310011   Southington School District 90423000841 1311411 Urbin T. Kelley School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 246 * 18   0 *     0   16   158 133     8             29   291 246   18   0       0   16   158 133     8       29   291
2452821 CT     school 904560 1420011   Tolland School District 90456000948 1420111 Birch Grove Primary School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 414 12 22   * 18     0   *   278 198     8             63   476 414 12 22     18     0       278 198     8       63   476
2453104 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2019   pk_12_total * 160 113   * *     0   0   139 142     8             55   281   160 113           0   0   139 142     8       55   281
2452195 CT     school 901920 640011   Hartford School District 90192001576 647411 HPHS Law and Government Academy   Regular School No High 09 12 2019   pk_12_total 6 119 192   0 *     *   *   161 163     79             67   324 6 119 192   0               161 163     79       67   324

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