Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by school_nces_id

View and edit SQL

year

  • 2020 · 1,361

grade

  • pk_12_total · 1,361
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
2777778 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2020   pk_12_total 220 12 31   0 7     0   6   146 130     0             34   276 220 12 31   0 7     0   6   146 130     0       34   276
2777780 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 146 * 20   0 0     0   *   101 84     *             28   185 146   20   0 0     0       101 84             28   185
2777786 CT     school 900420 140011   Branford School District 90042000039 146111 Branford High School Public Schools Regular School No High 09 12 2020   pk_12_total 607 22 94   0 60     0   21   * 404     15             104   804 607 22 94   0 60     0   21     404     15       104   804
2777785 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2020   pk_12_total 627 39 91   * 68     0   *   451 404     31             105   855 627 39 91     68     0       451 404     31       105   855
2777784 CT     school 900420 140011   Branford School District 90042000042 141411 Mary T. Murphy School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 232 * 64   * 48     0   21   185 200     62             44   385 232   64     48     0   21   185 200     62       44   385
2777783 CT     school 900420 140011   Branford School District 90042000043 141511 Mary R. Tisko School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 299 10 32   0 14     0   10   188 177     16             34   365 299 10 32   0 14     0   10   188 177     16       34   365
2777781 CT     school   140011   Branford School District 90042000177 148011 Indian Neck School Program           2020   pk_12_total 33 * 10   0 *     0   *   29 21     0             27   50 33   10   0       0       29 21     0       27   50
2777782 CT     school 900420 140011   Branford School District 90042001119 141611 John B. Sliney School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 197 13 49   0 8     0   24   138 153     27             36   291 197 13 49   0 8     0   24   138 153     27       36   291
2777787 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2020   pk_12_total 20 * *   0 0     0   0   18 9     0             *   27 20       0 0     0   0   18 9     0           27
2777806 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 66 183 576   * *     *   9   416 424     366             118   840 66 183 576               9   416 424     366       118   840
2777791 CT     school 900450 150011   Bridgeport School District 90045000049 150111 Barnum School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 51 155 421   * *     0   *   356 283     182             203   639 51 155 421           0       356 283     182       203   639
2777821 CT     school 900450 150011   Bridgeport School District 90045000050 156111 Bassick High School Public Schools Regular School No High 09 12 2020   pk_12_total 54 312 427   * 10     0   *   485 323     198             225   808 54 312 427     10     0       485 323     198       225   808
2777792 CT     school 900450 150011   Bridgeport School District 90045000051 150211 Beardsley School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 16 117 168   * *     0   7   156 156     30             49   312 16 117 168           0   7   156 156     30       49   312
2777793 CT     school 900450 150011   Bridgeport School District 90045000052 150311 Black Rock School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 135 74 282   * 10     0   *   258 247     106             80   505 135 74 282     10     0       258 247     106       80   505
2777794 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 182 276 551   10 38     *   *   589 481     282             141   1070 182 276 551   10 38             589 481     282       141   1070
2777795 CT     school 900450 150011   Bridgeport School District 90045000054 150411 Bryant School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 45 130 131   9 14     *   *   172 160     85             66   332 45 130 131   9 14             172 160     85       66   332
2777824 CT     school 900450 150011   Bridgeport School District 90045000056 156211 Central High School Public Schools Regular School No High 09 12 2020   pk_12_total 223 594 683   15 47     *   *   742 835     246             242   1577 223 594 683   15 47             742 835     246       242   1577
2777798 CT     school 900450 150011   Bridgeport School District 90045000058 150511 Columbus School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 87 134 338   * 0     0   *   311 259     229             73   570 87 134 338     0     0       311 259     229       73   570
2777818 CT     school 900450 150011   Bridgeport School District 90045000059 153911 Wilbur Cross School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 33 125 127   0 *     0   *   160 129     25             56   289 33 125 127   0       0       160 129     25       56   289
2777813 CT     school 900450 150011   Bridgeport School District 90045000060 150711 Edison School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 20 81 71   * 7     *   *   100 86     11             40   186 20 81 71     7             100 86     11       40   186
2777814 CT     school 900450 150011   Bridgeport School District 90045000065 151111 Hall School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 18 93 62   0 *     0   *   80 100     9             31   180 18 93 62   0       0       80 100     9       31   180
2777801 CT     school 900450 150011   Bridgeport School District 90045000066 151211 Hallen School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 25 144 115   * *     0   8   169 130     14             67   299 25 144 115           0   8   169 130     14       67   299
2777826 CT     school 900450 150011   Bridgeport School District 90045000067 156311 Warren Harding High School Public Schools Regular School No High 09 12 2020   pk_12_total 81 385 668   * *     *   9   622 531     363             277   1153 81 385 668               9   622 531     363       277   1153
2777812 CT     school 900450 150011   Bridgeport School District 90045000069 151311 Thomas Hooker School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 38 118 163   * *     *   9   183 151     28             62   334 38 118 163               9   183 151     28       62   334
2777796 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 98 225 782   * 15     *   11   613 528     555             180   1141 98 225 782     15         11   613 528     555       180   1141
2777807 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 54 203 210   * 47     0   *   256 265     40             73   521 54 203 210     47     0       256 265     40       73   521
2777816 CT     school 900450 150011   Bridgeport School District 90045000074 152011 Madison School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 96 135 196   0 *     *   9   254 191     118             87   445 96 135 196   0           9   254 191     118       87   445
2777797 CT     school 900450 150011   Bridgeport School District 90045000075 152111 Classical Studies Academy Public Schools Regular School No Elementary PK 08 2020   pk_12_total 38 225 170   * 17     *   *   216 245     27             61   461 38 225 170     17             216 245     27       61   461
2777804 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 46 250 292   * 13     0   *   323 290     50             162   613 46 250 292     13     0       323 290     50       162   613
2777809 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 60 318 399   * *     *   7   414 375     107             106   789 60 318 399               7   414 375     107       106   789
2777810 CT     school 900450 150011   Bridgeport School District 90045000081 152611 Roosevelt School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 56 168 305   * 14     *   *   258 291     136             98   549 56 168 305     14             258 291     136       98   549
2777790 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2020   pk_12_total 36 46 121   0 *     0   *   141 69     0             137   210 36 46 121   0       0       141 69     0       137   210
2777811 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 30 162 309   * *     *   7   263 251     80             113   514 30 162 309               7   263 251     80       113   514
2777800 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 68 197 468   10 21     0   14   413 365     243             156   778 68 197 468   10 21     0   14   413 365     243       156   778
2777805 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 115 190 294   * 34     *   16   355 297     86             94   652 115 190 294     34         16   355 297     86       94   652
2777817 CT     school 900450 150011   Bridgeport School District 90045001127 154611 Multicultural Magnet School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 107 44 281   24 6     *   *   205 262     127             43   467 107 44 281   24 6             205 262     127       43   467
2777808 CT     school 900450 150011   Bridgeport School District 90045001161 154111 Paul Laurence Dunbar School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 15 128 156   0 *     0   *   148 161     35             52   309 15 128 156   0       0       148 161     35       52   309
2777815 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 38 231 258   * 24     *   6   290 272     132             86   562 38 231 258     24         6   290 272     132       86   562
2777802 CT     school 900450 150011   Bridgeport School District 90045001163 154511 High Horizons Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 69 182 190   * 8     0   *   218 236     15             45   454 69 182 190     8     0       218 236     15       45   454
2777819 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2020   pk_12_total 0 44 *   0 *     0   0   67 9     7             *   76 0 44     0       0   0   67 9     7           76
2777803 CT     school 900450 150011   Bridgeport School District 90045001590 153711 Interdistrict Discovery Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 131 140 177   * 27     0   *   230 256     9             40   486 131 140 177     27     0       230 256     9       40   486
2777823 CT     school 900450 150011   Bridgeport School District 90045001631 151611 Bridgeport Military Academy Public Schools Regular School No High 09 12 2020   pk_12_total 30 85 205   * 0     *   *   161 163     49             72   324 30 85 205     0             161 163     49       72   324
2777825 CT     school 900450 150011   Bridgeport School District 90045001633 151511 Information Technology & Software Engineering Magnet High School Public Schools Regular School No High 09 12 2020   pk_12_total 63 117 181   * 24     0   *   275 123     16             38   398 63 117 181     24     0       275 123     16       38   398
2777822 CT     school 900450 150011   Bridgeport School District 90045001636 150611 Biotechnology, Research & Zoological Studies Magnet High School Public Schools Regular School No High 09 12 2020   pk_12_total 80 137 183   * 29     *   *   112 321     16             25   433 80 137 183     29             112 321     16       25   433
2777820 CT     school 900450 150011   Bridgeport School District 90045001639 150811 Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School Public Schools Regular School No High 09 12 2020   pk_12_total 81 119 136   * 23     *   *   227 139     12             33   366 81 119 136     23             227 139     12       33   366
2777799 CT     school 900450 150011   Bridgeport School District 90045001918 153111 Geraldine Claytor Magnet Academy Public Schools Regular School No Elementary PK 08 2020   pk_12_total 32 178 216   * *     *   7   218 223     71             76   441 32 178 216               7   218 223     71       76   441
2777850 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 350 60 249   0 34     0   27   347 373     46             119   720 350 60 249   0 34     0   27   347 373     46       119   720
2777859 CT     school 900510 170011   Bristol School District 90051000092 176111 Bristol Central High School Public Schools Regular School No High 09 12 2020   pk_12_total 669 81 352   * *     0   48   606 *     42             225   1187 669 81 352           0   48   606       42       225   1187
2777860 CT     school 900510 170011   Bristol School District 90051000093 176211 Bristol Eastern High School Public Schools Regular School No High 09 12 2020   pk_12_total 677 67 260   * 36     *   35   * 545     30             216   1079 677 67 260     36         35     545     30       216   1079
2777835 CT     school 900510 170011   Bristol School District 90051000096 170311 Edgewood School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 145 * 99   * 15     0   13   150 136     20             35   286 145   99     15     0   13   150 136     20       35   286
2777830 CT     school 900510 170011   Bristol School District 90051000097 171411 Ellen P. Hubbell School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 174 28 154   * *     0   25   204 194     29             59   398 174 28 154           0   25   204 194     29       59   398
2777831 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 449 76 307   * 44     *   31   469 440     72             123   909 449 76 307     44         31   469 440     72       123   909
2777832 CT     school 900510 170011   Bristol School District 90051000099 171911 Ivy Drive School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 231 29 78   0 7     0   19   171 193     13             65   364 231 29 78   0 7     0   19   171 193     13       65   364
2777833 CT     school 900510 170011   Bristol School District 90051000103 171711 Mountain View School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 202 17 86   0 17     0   16   172 166     23             42   338 202 17 86   0 17     0   16   172 166     23       42   338
2777858 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 281 37 106   0 24     0   21   237 232     15             81   469 281 37 106   0 24     0   21   237 232     15       81   469
2777834 CT     school 900510 170011   Bristol School District 90051000105 171111 South Side School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 279 31 152   * *     0   16   253 239     17             61   492 279 31 152           0   16   253 239     17       61   492
2777841 CT     school 900510 170011   Bristol School District 90051000106 171211 Stafford School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 178 35 123   0 *     *   15   161 200     16             65   361 178 35 123   0           15   161 200     16       65   361
2777846 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2020   pk_12_total 12 * *   0 0     0   0   18 6     *             24   24 12       0 0     0   0   18 6             24   24
2777863 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2020   pk_12_total 17 * *   0 0     0   *   13 11     *             24   24 17       0 0     0       13 11             24   24
2777842 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 412 55 374   * *     0   58   456 463     83             168   919 412 55 374           0   58   456 463     83       168   919
2777843 CT     school   170011   Bristol School District 90051001646 172111 Hubbell/Extended Resource Program           2020   pk_12_total 0 0 *   0 *     0   0   * *     0             *   * 0 0     0       0   0           0            
2777856 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2777855 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2020   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2777845 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2020   pk_12_total * * *   0 0     0   *   7 0     *             7   7         0 0     0       7 0             7   7
2777837 CT     school   170011   Bristol School District 90051001692 172311 Ivy Drive Medically Fragile Program           2020   pk_12_total * * *   0 0     0   0   * *     0             *   *         0 0     0   0           0            
2777840 CT     school   170011   Bristol School District 90051001707 173211 Stafford Autism Program           2020   pk_12_total * * *   * *     0   0   * *     0             14   14                 0   0           0       14   14
2777848 CT     school   170011   Bristol School District 90051001711 173111 South Side GOAL Program           2020   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2777844 CT     school   170011   Bristol School District 90051001726 172511 Mt. View GOAL Program           2020   pk_12_total 0 * *   0 0     0   0   * *     0             *   * 0       0 0     0   0           0            
2777828 CT     school   170011   Bristol School District 90051001728 172911 BECC Autism Program           2020   pk_12_total * 0 *   0 0     0   *   * *     0             6   6   0     0 0     0               0       6   6
2777861 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2020   pk_12_total 26 * 11   0 0     0   *   32 8     0             0   40 26   11   0 0     0       32 8     0       0   40
2777851 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2777854 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2777839 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2020   pk_12_total * * 6   0 0     0   *   * *     *             11   11     6   0 0     0                       11   11
2777829 CT     school 900510 170011   Bristol School District 90051001774 170411 Bristol Early Childhood Center-BECC Public Schools Special Education School No Prekindergarten PK PK 2020   pk_12_total 68 0 31   0 *     0   *   75 38     0             70   113 68 0 31   0       0       75 38     0       70   113
2777857 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2020   pk_12_total * * 0   0 0     0   0   * *     0             *   *     0   0 0     0   0           0            
2777867 CT     school 900540 180011   Brookfield School District 90054000109 186111 Brookfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 660 22 103   * 78     *   *   446 423     20             136   869 660 22 103     78             446 423     20       136   869
2777864 CT     school 900540 180011   Brookfield School District 90054000110 180311 Center Elementary School Public Schools Regular School No Elementary PK 01 2020   pk_12_total 320 * 34   * 16     0   9   191 197     28             61   388 320   34     16     0   9   191 197     28       61   388
2777866 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 628 17 111   * 61     *   *   416 413     25             125   829 628 17 111     61             416 413     25       125   829
2777865 CT     school 900540 180011   Brookfield School District 90054001186 180411 Huckleberry Hill Elementary School Public Schools Regular School No Elementary 02 04 2020   pk_12_total 404 13 55   * 39     0   *   266 257     42             58   523 404 13 55     39     0       266 257     42       58   523
2777868 CT     school 900570 190011   Brooklyn School District 90057000113 190111 Brooklyn Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 446 14 68   * *     0   20   273 290     10             80   563 446 14 68           0   20   273 290     10       80   563
2777869 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 268 * 34   0 11     *   20   184 156     *             56   340 268   34   0 11         20   184 156             56   340
2779103 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 63 0 *   0 0     0   *   38 29     *             10   67 63 0     0 0     0       38 29             10   67
2777871 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 165 0 9   * *     0   0   84 93     0             19   177 165 0 9           0   0   84 93     0       19   177
2777870 CT     school 900660 220011   Canterbury School District 90066001188 220211 Canterbury Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 263 * 18   0 *     0   *   153 139     0             35   292 263   18   0       0       153 139     0       35   292
2777875 CT     school 900690 230011   Canton School District 90069000118 236111 Canton High School Public Schools Regular School No High 09 12 2020   pk_12_total 396 24 35   0 18     0   7   245 *     *             73   480 396 24 35   0 18     0   7   245               73   480
2777873 CT     school 900690 230011   Canton School District 90069000119 230311 Canton Intermediate School Public Schools Regular School No Middle 04 06 2020   pk_12_total 288 30 23   0 12     *   *   169 192     *             44   361 288 30 23   0 12             169 192             44   361
2777872 CT     school 900690 230011   Canton School District 90069000120 230211 Cherry Brook Primary School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 392 17 32   0 *     *   20   258 211     6             52   469 392 17 32   0           20   258 211     6       52   469
2777874 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 197 20 24   0 *     0   *   * 125     *             34   250 197 20 24   0       0         125             34   250
2777876 CT     school   230011   Canton School District 90069001695 230411 Canton Academy Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2777880 CT     school 900700 2410014   Capitol Region Education Council 90070000072 2410114 Glastonbury/East Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 105 107 176   * 50     0   *   228 231     53             68   459 105 107 176     50     0       228 231     53       68   459
2777882 CT     school 900700 2410014   Capitol Region Education Council 90070000210 2413114 Montessori Magnet School Regional Education Service Center Schools Regular School No Elementary PK 06 2020   pk_12_total 81 31 210   0 *     *   21   177 177     50             63   354 81 31 210   0           21   177 177     50       63   354
2777894 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2020   pk_12_total 116 348 168   * 24     *   37   309 388     19             121   697 116 348 168     24         37   309 388     19       121   697
2777888 CT     school   2410014   Capitol Region Education Council 90070001154 2419014 John J. Allison Polaris Center Program           2020   pk_12_total * * 34   0 0     0   0   37 18     6             *   55     34   0 0     0   0   37 18     6           55
2777887 CT     school 900700 2410014   Capitol Region Education Council 90070001357 2410214 University of Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 98 217 115   * 22     *   23   229 248     22             90   477 98 217 115     22         23   229 248     22       90   477
2777895 CT     school 900700 2410014   Capitol Region Education Council 90070001364 2415014 Two Rivers Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2020   pk_12_total 120 202 302   * *     0   23   375 291     60             136   666 120 202 302           0   23   375 291     60       136   666
2777896 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2020   pk_12_total 8 * 0   0 0     0   *   * *     0             *   11 8   0   0 0     0               0           11
2777886 CT     school   2410014   Capitol Region Education Council 90070001492 2419114 Soundbridge Program           2020   pk_12_total 24 0 6   0 *     *   0   21 12     0             8   33 24 0 6   0           0   21 12     0       8   33
2777889 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2020   pk_12_total 57 28 24   0 *     0   *   96 20     0             116   116 57 28 24   0       0       96 20     0       116   116
2777899 CT     school 900700 2410014   Capitol Region Education Council 90070001497 2416414 Greater Hartford Academy of the Arts High School - Full Day Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 113 126 192   0 *     0   *   128 324     15             69   452 113 126 192   0       0       128 324     15       69   452
2777890 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2020   pk_12_total 25 9 10   0 *     0   *   40 9     *             49   49 25 9 10   0       0       40 9             49   49

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