Data source: Big Local News · About: Big Local

1,449 rows where grade = "pk_12_total", state = "CT" and year = 2019 sorted by district_state_id

View and edit SQL

year

  • 2019 · 1,317

grade

  • pk_12_total · 1,317
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
2453082 CT     school 904020 1250011   Sharon School District 90402000795 1250111 Sharon Center School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 98 0 10   0 *     *   *   61 54     *             25   115 98 0 10   0               61 54             25   115
2452685 CT     school 904050 1260011   Shelton School District 90405000804 1260911 Mohegan School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 237 10 46   0 *     0   *   152 151     16             46   303 237 10 46   0       0       152 151     16       46   303
2452686 CT     school 904050 1260011   Shelton School District 90405000796 1261011 Booth Hill School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 264 19 43   0 *     0   *   184 161     37             29   345 264 19 43   0       0       184 161     37       29   345
2452687 CT     school 904050 1260011   Shelton School District 90405000798 1260511 Elizabeth Shelton School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 343 20 64   * 29     0   *   237 233     29             44   470 343 20 64     29     0       237 233     29       44   470
2452688 CT     school 904050 1260011   Shelton School District 90405000803 1260811 Long Hill School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 198 32 108   0 26     0   14   204 174     49             46   378 198 32 108   0 26     0   14   204 174     49       46   378
2452689 CT     school   1260011   Shelton School District   1260111 Pre-Kindergarten Program           2019   pk_12_total 13 * *   0 *     0   *   * *     0             23   23 13       0       0               0       23   23
2452690 CT     school 904050 1260011   Shelton School District 90405000003 1260611 Sunnyside School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 122 33 52   * 11     0   *   116 110     26             37   226 122 33 52     11     0       116 110     26       37   226
2452691 CT     school   1260011   Shelton School District   1261311 Alternative Learning Center 2 Program           2019   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2452692 CT     school   1260011   Shelton School District   1260311 Life Skills Program           2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   *   0 0   0 0     0               0            
2452693 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2019   pk_12_total * * *   0 0     0   0   7 0     *             7   7         0 0     0   0   7 0             7   7
2452694 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2019   pk_12_total * * *   0 0     0   0   6 0     *             6   6         0 0     0   0   6 0             6   6
2452695 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2019   pk_12_total 496 44 112   0 49     *   *   392 337     31             108   729 496 44 112   0 49             392 337     31       108   729
2452696 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 07 08 2019   pk_12_total 546 45 105   * 40     *   32   394 376     22             127   770 546 45 105     40         32   394 376     22       127   770
2452697 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2019   pk_12_total 983 79 196   * 98     0   *   717 *     18             160   1401 983 79 196     98     0       717       18       160   1401
2452698 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2019   pk_12_total 14 * *   0 0     0   0   8 9     0             17   17 14       0 0     0   0   8 9     0       17   17
2452699 CT     school 904080 1270011   Sherman School District 90408000808 1270111 Sherman School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 254 * 10   * *     0   *   141 138     *             36   279 254   10           0       141 138             36   279
2452701 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 463 * 64   0 42     *   28   318 305     12             107   623 463   64   0 42         28   318 305     12       107   623
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
2452703 CT     school 904110 1280011   Simsbury School District 90411000812 1280611 Latimer Lane School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 285 24 44   0 33     0   20   204 202     24             43   406 285 24 44   0 33     0   20   204 202     24       43   406
2452704 CT     school 904110 1280011   Simsbury School District 90411000815 1280311 Tariffville School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 164 45 13   0 14     0   12   114 134     11             30   248 164 45 13   0 14     0   12   114 134     11       30   248
2452705 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 265 23 41   0 18     0   23   173 197     *             49   370 265 23 41   0 18     0   23   173 197             49   370
2452706 CT     school 904110 1280011   Simsbury School District 90411000811 1285111 Henry James Memorial School Public Schools Regular School No Middle 07 08 2019   pk_12_total 452 34 54   0 50     0   16   313 293     *             82   606 452 34 54   0 50     0   16   313 293             82   606
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
2452708 CT     school   1280011   Simsbury School District   1280211 Farmington Valley Transition Academy Program           2019   pk_12_total 28 * *   0 *     0   *   22 15     0             37   37 28       0       0       22 15     0       37   37
2452709 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 518 16 28   * *     0   6   304 272     *             86   576 518 16 28           0   6   304 272             86   576
2452710 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 308 * 13   0 6     0   *   164 172     *             44   336 308   13   0 6     0       164 172             44   336
2452711 CT     school 904140 1290011   Somers School District 90414000819 1296111 Somers High School Public Schools Regular School No High 09 12 2019   pk_12_total 406 14 18   0 11     *   *   232 227     *             56   459 406 14 18   0 11             232 227             56   459
2452712 CT     school   1290011   Somers School District   1290511 Aspire Program           2019   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2451752 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 157 * *   0 0     0   21   112 89     *             27   201 157       0 0     0   21   112 89             27   201
2452722 CT     school 904230 1310011   Southington School District 90423001804 1312111 Southington Public Schools Preschool Program Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total * * 0   0 0     0   0   9 10     0             11   19     0   0 0     0   0   9 10     0       11   19
2452723 CT     school 904230 1310011   Southington School District 90423001808 1312011 Southington Public Schools Preschool Program at Hatton School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 56 * 7   0 *     0   *   52 18     0             46   70 56   7   0       0       52 18     0       46   70
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
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
2452726 CT     school 904230 1310011   Southington School District 90423000830 1311311 Flanders Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 207 * 45   0 12     *   12   142 144     26             31   286 207   45   0 12         12   142 144     26       31   286
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
2452728 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2019   pk_12_total 8 * *   0 0     0   0   * *     0             10   10 8       0 0     0   0           0       10   10
2452729 CT     school   1310011   Southington School District 90423001759 1311811 Language Based Classroom, Multihandicapped Program           2019   pk_12_total 12 0 *   0 *     0   *   * *     0             15   15 12 0     0       0               0       15   15
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
2452731 CT     school 904230 1310011   Southington School District 90423000837 1310711 South End Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 180 * 35   0 *     0   8   118 115     *             23   233 180   35   0       0   8   118 115             23   233
2452732 CT     school 904230 1310011   Southington School District 90423000839 1310811 Strong Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 212 9 32   0 8     0   20   140 141     11             33   281 212 9 32   0 8     0   20   140 141     11       33   281
2452733 CT     school 904230 1310011   Southington School District 90423000840 1310911 Thalberg Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 337 11 47   0 28     0   23   241 205     24             36   446 337 11 47   0 28     0   23   241 205     24       36   446
2452734 CT     school   1310011   Southington School District 90423001786 1310411 Language Based Classroom at Hatton School Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             11   11   0     0 0     0   0           0       11   11
2452735 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 637 * 58   * 22     0   23   363 401     6             97   764 637   58     22     0   23   363 401     6       97   764
2452736 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11
2452737 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 609 21 63   * 24     *   21   398 343     6             116   741 609 21 63     24         21   398 343     6       116   741
2452738 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2019   pk_12_total * 0 0   0 0     0   *   10 0     0             10   10   0 0   0 0     0       10 0     0       10   10
2452739 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2019   pk_12_total 13 * *   0 0     0   0   * *     0             15   15 13       0 0     0   0           0       15   15
2452740 CT     school   1310011   Southington School District 90423001649 1311211 Collaborative Learning Program (CLP) Program           2019   pk_12_total 8 * *   0 0     0   0   9 6     0             15   15 8       0 0     0   0   9 6     0       15   15
2452741 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2019   pk_12_total 1620 * 153   0 82     *   71   962 1008     12             233   1970 1620   153   0 82         71   962 1008     12       233   1970
2452742 CT     school   1310011   Southington School District 90423001665 1310111 The Karen Smith Academy Program           2019   pk_12_total 26 * *   0 0     0   0   15 17     0             11   32 26       0 0     0   0   15 17     0       11   32
2452743 CT     school   1310011   Southington School District   1312211 STELLAR Program           2019   pk_12_total 7 * 0   0 *     0   0   * *     0             9   9 7   0   0       0   0           0       9   9
2452713 CT     school 904170 1320011   South Windsor School District 90417000822 1320711 Eli Terry School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 279 30 49   * 64     0   *   230 213     26             74   443 279 30 49     64     0       230 213     26       74   443
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
2452715 CT     school 904170 1320011   South Windsor School District 90417000821 1320111 Philip R. Smith School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 230 8 31   0 107     0   18   199 195     50             29   394 230 8 31   0 107     0   18   199 195     50       29   394
2452716 CT     school   1320011   South Windsor School District   1320511 Preschool Outreach Program Program           2019   pk_12_total 47 * 11   0 15     0   *   48 38     0             50   86 47   11   0 15     0       48 38     0       50   86
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
2452718 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2019   pk_12_total 563 62 80   0 220     *   *   499 482     14             124   981 563 62 80   0 220             499 482     14       124   981
2452719 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2019   pk_12_total * * 0   0 0     0   0   * *     0             *   12     0   0 0     0   0           0           12
2452720 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2019   pk_12_total 826 84 122   * 180     *   46   675 591     14             190   1266 826 84 122     180         46   675 591     14       190   1266
2452721 CT     school   1320011   South Windsor School District 90417001605 1329011 Project Worth Young Adult Academy Program           2019   pk_12_total * * *   0 *     0   *   * *     0             9   9         0       0               0       9   9
2452744 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Other PK 12 2019   pk_12_total 217 6 47   * *     *   35   178 135     *             50   313 217 6 47               35   178 135             50   313
2452745 CT     school 904290 1340011   Stafford School District 90429000847 1340311 Staffordville School Public Schools Regular School No Elementary PK 01 2019   pk_12_total 127 * 13   0 0     0   *   86 61     0             20   147 127   13   0 0     0       86 61     0       20   147
2452746 CT     school 904290 1340011   Stafford School District 90429000848 1340411 West Stafford School Public Schools Regular School No Elementary PK 01 2019   pk_12_total 124 * 10   0 *     0   *   78 66     *             17   144 124   10   0       0       78 66             17   144
2452747 CT     school 904290 1340011   Stafford School District 90429001503 1340611 Stafford Elementary School Public Schools Regular School No Elementary 02 05 2019   pk_12_total 412 6 32   * *     0   18   231 239     *             69   470 412 6 32           0   18   231 239             69   470
2452748 CT     school 904290 1340011   Stafford School District 90429000061 1345211 Stafford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 306 7 21   * *     0   11   185 164     0             48   349 306 7 21           0   11   185 164     0       48   349
2452749 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2019   pk_12_total 326 * 38   * 10     0   6   194 *     0             57   384 326   38     10     0   6   194       0       57   384
2452750 CT     school   1340011   Stafford School District   1340211 Stafford Tutoring Program             2019   pk_12_total * 0 0   0 0     0   *   * *     0             *   7   0 0   0 0     0               0           7
2452752 CT     school   1350011   Stamford School District 90432001703 1350111 Apples PreK Program           2019   pk_12_total 61 24 59   0 16     0   8   107 61     0             110   168 61 24 59   0 16     0   8   107 61     0       110   168
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
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
2452755 CT     school   1350011   Stamford School District 90432000665 1358011 Preschool Team Program           2019   pk_12_total 13 6 31   0 *     0   *   41 14     0             55   55 13 6 31   0       0       41 14     0       55   55
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
2452757 CT     school 904320 1350011   Stamford School District 90432000861 1351811 Northeast School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 292 73 204   * 20     *   26   318 300     105             81   618 292 73 204     20         26   318 300     105       81   618
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
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
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
2452761 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 353 65 309   * 51     *   28   407 403     39             77   810 353 65 309     51         28   407 403     39       77   810
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
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
2452764 CT     school 904320 1350011   Stamford School District 90432001916 1350711 Strawberry Hill an ext. of Rogers International Public Schools Regular School No Elementary KG 03 2019   pk_12_total 142 59 121   * 81     0   *   210 226     16             32   436 142 59 121     81     0       210 226     16       32   436
2452765 CT     school 904320 1350011   Stamford School District 90432000008 1351911 Toquam Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 131 79 341   * 58     *   24   351 286     133             65   637 131 79 341     58         24   351 286     133       65   637
2452766 CT     school 904320 1350011   Stamford School District 90432000872 1351411 Westover School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 167 158 251   0 82     0   27   346 339     51             70   685 167 158 251   0 82     0   27   346 339     51       70   685
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
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
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
2452770 CT     school 904320 1350011   Stamford School District 90432000009 1355711 Scofield Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 224 74 251   0 89     0   8   325 321     24             41   646 224 74 251   0 89     0   8   325 321     24       41   646
2452771 CT     school 904320 1350011   Stamford School District 90432000870 1355511 Turn of River School Public Schools Regular School No Middle 06 08 2019   pk_12_total 197 100 268   0 61     0   27   339 314     122             88   653 197 100 268   0 61     0   27   339 314     122       88   653
2452772 CT     school   1350011   Stamford School District 90432001744 1350411 Anchor Program           2019   pk_12_total 24 * 29   0 0     0   *   38 35     6             40   73 24   29   0 0     0       38 35     6       40   73
2452773 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2019   pk_12_total 581 367 647   0 100     *   *   857 886     241             209   1743 581 367 647   0 100             857 886     241       209   1743
2452774 CT     school 904320 1350011   Stamford School District 90432001468 1356411 The Academy of Information, Technology & Engineering Public Schools Regular School No High 09 12 2019   pk_12_total 293 112 140   0 69     *   *   346 292     *             69   638 293 112 140   0 69             346 292             69   638
2452775 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2019   pk_12_total 798 324 825   * 134     *   40   1060 1067     395             277   2127 798 324 825     134         40   1060 1067     395       277   2127
2452776 CT     school   1350011   Stamford School District 90432001749 1350211 Individuals Achieving Independence Program           2019   pk_12_total * * 10   0 0     0   0   12 9     *             21   21     10   0 0     0   0   12 9             21   21
2452777 CT     school 904350 1360011   Sterling School District 90435001491 1360311 Sterling Community School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 304 8 20   * *     0   21   198 163     0             50   361 304 8 20           0   21   198 163     0       50   361
2452778 CT     school 904380 1370011   Stonington School District 90438001637 1370111 Stonington BOE Pre-School   Special Education School No Prekindergarten PK PK 2019   pk_12_total 22 0 *   0 *     0   0   15 11     0             16   26 22 0     0       0   0   15 11     0       16   26
2452779 CT     school 904380 1370011   Stonington School District 90438001635 1370211 Stonington HS PreK   Special Education School No Prekindergarten PK PK 2019   pk_12_total 22 0 *   0 0     0   *   17 9     0             17   26 22 0     0 0     0       17 9     0       17   26
2452780 CT     school 904380 1370011   Stonington School District 90438000876 1370511 Deans Mill School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 324 * 22   * 11     *   16   190 188     *             34   378 324   22     11         16   190 188             34   378
2452781 CT     school 904380 1370011   Stonington School District 90438000883 1370611 West Vine Street School Public Schools Regular School No Elementary KG 03 2019   pk_12_total 139 7 11   0 6     0   20   94 89     *             20   183 139 7 11   0 6     0   20   94 89             20   183
2452782 CT     school 904380 1370011   Stonington School District 90438000882 1370411 West Broad Street School   Regular School No Elementary 03 04 2019   pk_12_total 90 * 6   * *     0   10   50 61     *             20   111 90   6           0   10   50 61             20   111
2452783 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   pk_12_total 244 * 24   * *     0   8   158 124     0             55   282 244   24           0   8   158 124     0       55   282
2452784 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 312 * 21   0 *     0   9   169 182     *             51   351 312   21   0       0   9   169 182             51   351

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