Data source: Big Local News · About: Big Local

4,354 rows where grade = "pk_12_total" and state = "CT" sorted by school

View and edit SQL

year

grade

  • pk_12_total · 4,354
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
2452116 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   pk_12_total 413 8 40   0 22     0   19   270 232     11             67   502 413 8 40   0 22     0   19   270 232     11       67   502
2757703 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   pk_12_total 385 * 30   0 21     *   26   244 224     10             66   468 385   30   0 21         26   244 224     10       66   468
2778146 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   pk_12_total 389 * 31   0 21     *   25   251 221     11             54   472 389   31   0 21         25   251 221     11       54   472
2453118 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 32 177 444   * 13     *   *   339 338     71             64   677 32 177 444     13             339 338     71       64   677
2758705 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   pk_12_total 42 204 500   * 13     *   18   406 375     91             124   781 42 204 500     13         18   406 375     91       124   781
2779156 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   pk_12_total 39 177 471   * 14     *   12   369 347     83             92   716 39 177 471     14         12   369 347     83       92   716
2452113 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 225 * 18   0 *     0   12   138 128     11             18   266 225   18   0       0   12   138 128     11       18   266
2757700 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2021   pk_12_total 187 * 20   0 21     0   *   121 120     15             22   241 187   20   0 21     0       121 120     15       22   241
2778143 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 206 * 22   0 16     0   *   129 123     13             14   252 206   22   0 16     0       129 123     13       14   252
2452810 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 367 10 25   0 16     0   12   226 204     14             67   430 367 10 25   0 16     0   12   226 204     14       67   430
2758387 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 376 15 32   0 20     0   10   237 216     29             67   453 376 15 32   0 20     0   10   237 216     29       67   453
2778834 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 373 12 35   0 18     0   16   240 214     24             77   454 373 12 35   0 18     0   16   240 214     24       77   454
2451761 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 41 63 107   0 *     0   *   145 81     0             127   226 41 63 107   0       0       145 81     0       127   226
2757342 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 20 58 117   * 6     0   *   125 80     0             126   205 20 58 117     6     0       125 80     0       126   205
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
2452874 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   pk_12_total 16 0 *   0 0     0   *   * *     0             21   21 16 0     0 0     0               0       21   21
2778899 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2020   pk_12_total 12 * *   0 0     0   0   * *     0             16   16 12       0 0     0   0           0       16   16
2453019 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   pk_12_total 0 * *   0 0     0   *   * *     *             7   7 0       0 0     0                       7   7
2758587 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2021   pk_12_total * * 10   0 *     0   *   9 9     6             18   18     10   0       0       9 9     6       18   18
2779040 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2020   pk_12_total * * 10   0 *     0   *   8 8     *             16   16     10   0       0       8 8             16   16
2452790 CT     school   1380011   Stratford School District 90444001734 1380611 ABA - K-6 Program           2019   pk_12_total 12 * *   0 *     0   *   15 6     0             21   21 12       0       0       15 6     0       21   21
2758366 CT     school   1380011   Stratford School District 90444001734 1380611 ABA - K-6 Program           2021   pk_12_total 11 7 9   0 *     0   *   23 8     0             31   31 11 7 9   0       0       23 8     0       31   31
2778813 CT     school   1380011   Stratford School District 90444001734 1380611 ABA - K-6 Program           2020   pk_12_total 9 * 7   0 *     0   *   18 7     0             25   25 9   7   0       0       18 7     0       25   25
2453061 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2019   pk_12_total * 0 *   0 0     0   0   * *     0             *   *   0     0 0     0   0           0            
2758639 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             7   7   0 0   0 0     0               0       7   7
2779090 CT     school   1660011   Wolcott School District 90528001783 1660311 ABC Classroom Program           2020   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2451831 CT     school   170011   Bristol School District   170211 ACCESS Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2757414 CT     school   170011   Bristol School District   170211 ACCESS Program           2021   pk_12_total * 0 8   0 0     0   *   8 *     0             11   11   0 8   0 0     0       8       0       11   11
2777862 CT     school   170011   Bristol School District   170211 ACCESS Program           2020   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
2452003 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2019   pk_12_total * 0 0   0 0     0   0   * 0     0             *   *   0 0   0 0     0   0     0     0            
2757589 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2778031 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2020   pk_12_total * 0 0   0 0     0   0   * 0     0             0   *   0 0   0 0     0   0     0     0       0    
2451707 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2019   pk_12_total * 16 14   0 0     0   *   33 8     *             41   41   16 14   0 0     0       33 8             41   41
2758649 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2021   pk_12_total * 38 20   0 0     0   *   65 17     *             74   82   38 20   0 0     0       65 17             74   82
2777735 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2020   pk_12_total * 44 22   0 0     0   *   71 15     *             *   86   44 22   0 0     0       71 15                 86
2758652 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2021   pk_12_total * * *   0 0     0   *   * *     0             10   10         0 0     0               0       10   10
2777737 CT     school   2440014   Area Cooperative Educational Services   2440414 ACES at Mead Elementary School Program           2020   pk_12_total 0 * *   0 0     0   *   * *     0             *   * 0       0 0     0               0            
2453097 CT     school   2070012   Regional School District 07 90372001400 2079112 AIM Program           2019   pk_12_total 17 * *   0 0     0   0   10 11     0             21   21 17       0 0     0   0   10 11     0       21   21
2758685 CT     school   2070012   Regional School District 07 90372001400 2079112 AIM Program           2021   pk_12_total * * 0   0 0     0   0   11 10     0             21   21     0   0 0     0   0   11 10     0       21   21
2779134 CT     school   2070012   Regional School District 07 90372001400 2079112 AIM Program           2020   pk_12_total 18 * *   0 0     0   *   11 11     0             22   22 18       0 0     0       11 11     0       22   22
2452799 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2019   pk_12_total * * *   0 0     0   0   6 0     0             6   6         0 0     0   0   6 0     0       6   6
2758375 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2021   pk_12_total * * 0   0 0     0   0   * 0     0             *   *     0   0 0     0   0     0     0            
2778822 CT     school   1380011   Stratford School District   1382711 ALL Class Room - Second Hill Lane Program           2020   pk_12_total * * *   0 0     0   0   * 0     0             *   *         0 0     0   0     0     0            
2452804 CT     school   1380011   Stratford School District 90444001701 1380511 ALPHA Program           2019   pk_12_total 8 16 *   0 *     0   0   19 12     0             9   31 8 16     0       0   0   19 12     0       9   31
2758380 CT     school   1380011   Stratford School District 90444001701 1380511 ALPHA Program           2021   pk_12_total * 13 11   0 0     0   *   15 17     *             10   32   13 11   0 0     0       15 17             10   32
2778827 CT     school   1380011   Stratford School District 90444001701 1380511 ALPHA Program           2020   pk_12_total 7 16 13   0 *     0   *   23 16     *             11   39 7 16 13   0       0       23 16             11   39
2452988 CT     school   1560011   West Haven School District   1561111 ASD Lab             2019   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2779015 CT     school   1560011   West Haven School District   1561111 ASD Lab             2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
2451987 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2019   pk_12_total 6 * *   0 0     0   0   * *     0             8   8 6       0 0     0   0           0       8   8
2757570 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2021   pk_12_total 15 * *   0 0     0   0   9 10     *             19   19 15       0 0     0   0   9 10             19   19
2778019 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     *             10   10     0   0 0     0   0                   10   10
2451885 CT     school 900810 270011   Clinton School District 90081000131 270111 Abraham Pierson School   Regular School No Elementary 04 05 2019   pk_12_total 187 * 48   * 7     0   6   130 121     24             36   251 187   48     7     0   6   130 121     24       36   251
2451862 CT     school 900700 2410014   Capitol Region Education Council 90070001513 2415114 Academy of Aerospace and Engineering Regional Education Service Center Schools Regular School No High 06 12 2019   pk_12_total 166 229 286   * 75     *   27   542 244     33             108   786 166 229 286     75         27   542 244     33       108   786
2757442 CT     school 900700 2410014   Capitol Region Education Council 90070001513 2415114 Academy of Aerospace and Engineering Regional Education Service Center Schools Regular School No High 06 12 2021   pk_12_total 125 253 304   * 68     0   *   479 297     38             130   776 125 253 304     68     0       479 297     38       130   776
2777891 CT     school 900700 2410014   Capitol Region Education Council 90070001513 2415114 Academy of Aerospace and Engineering Regional Education Service Center Schools Regular School No High 06 12 2020   pk_12_total 147 241 287   * 68     0   *   509 261     43             116   770 147 241 287     68     0       509 261     43       116   770
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
2757428 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 2021   pk_12_total 110 131 162   * 87     *   30   261 263     90             61   524 110 131 162     87         30   261 263     90       61   524
2777877 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 2020   pk_12_total 105 123 149   * 84     *   16   250 230     90             67   480 105 123 149     84         16   250 230     90       67   480
2451863 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2019   pk_12_total 165 203 362   * 38     *   27   378 423     36             116   801 165 203 362     38         27   378 423     36       116   801
2757443 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2021   pk_12_total 160 186 366   * *     0   32   425 *     63             134   778 160 186 366           0   32   425       63       134   778
2777892 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2020   pk_12_total 162 199 334   * 32     0   *   378 377     52             124   755 162 199 334     32     0       378 377     52       124   755
2757340 CT     school   140011   Branford School District   140311 Access Transition Program Program           2021   pk_12_total * 0 0   0 *     0   0   * *     *             14   14   0 0   0       0   0                   14   14
2777788 CT     school   140011   Branford School District   140311 Access Transition Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             15   15   0 0   0       0   0                   15   15
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
2758318 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2021   pk_12_total 9 0 0   0 0     0   0   * *     0             9   9 9 0 0   0 0     0   0           0       9   9
2778764 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2020   pk_12_total 13 * *   0 0     0   0   * *     0             17   17 13       0 0     0   0           0       17   17
2453070 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 13 584 480   * 9     *   *   512 581     131             97   1093 13 584 480     9             512 581     131       97   1093
2758646 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   pk_12_total 12 597 502   * 9     *   *   527 600     130             106   1127 12 597 502     9             527 600     130       106   1127
2779099 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total 13 596 487   * 6     *   *   524 586     148             112   1110 13 596 487     6             524 586     148       112   1110
2453071 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 782 304   * *     *   15   519 593     52             115   1112   782 304               15   519 593     52       115   1112
2758647 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   pk_12_total * 840 294   10 *     *   14   * 607     70             115   1164   840 294   10           14     607     70       115   1164
2779100 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   pk_12_total * 842 299   6 *     *   15   553 616     70             117   1169   842 299   6           15   553 616     70       117   1169
2451791 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 2019   pk_12_total 95 150 173   * 26     *   *   294 155     15             45   449 95 150 173     26             294 155     15       45   449
2757372 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 2021   pk_12_total 68 96 119   * 21     *   *   203 111     14             30   314 68 96 119     21             203 111     14       30   314
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
2452957 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 234 37 67   * 62     0   *   196 224     41             58   420 234 37 67     62     0       196 224     41       58   420
2758532 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 241 36 47   * 60     *   16   183 220     46             45   403 241 36 47     60         16   183 220     46       45   403
2778983 CT     school 904920 1550011   West Hartford School District 90492000004 1551611 Aiken School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 252 38 56   * 66     0   *   202 230     49             53   432 252 38 56     66     0       202 230     49       53   432
2452675 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 359 21 76   * 147     0   *   312 310     21             72   622 359 21 76     147     0       312 310     21       72   622
2758253 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 326 19 66   0 179     0   20   302 308     20             94   610 326 19 66   0 179     0   20   302 308     20       94   610
2778699 CT     school 903840 1190011   Rocky Hill School District 90384000782 1195111 Albert D. Griswold Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 337 * 60   * 150     0   20   292 291     15             83   583 337   60     150     0   20   292 291     15       83   583
2453060 CT     school 905280 1660011   Wolcott School District 90528001105 1660611 Alcott School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 212 7 38   0 8     0   6   151 120     16             44   271 212 7 38   0 8     0   6   151 120     16       44   271
2758636 CT     school 905280 1660011   Wolcott School District 90528001105 1660611 Alcott School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 242 * 22   * 7     0   8   160 127     14             65   287 242   22     7     0   8   160 127     14       65   287
2779089 CT     school 905280 1660011   Wolcott School District 90528001105 1660611 Alcott School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 212 6 46   * 8     0   *   148 130     14             45   278 212 6 46     8     0       148 130     14       45   278
2453014 CT     school 905070 1590011   Wethersfield School District 90507001059 1590811 Alfred W. Hanmer School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 261 * 48   * 20     0   15   179 181     52             43   360 261   48     20     0   15   179 181     52       43   360
2758592 CT     school 905070 1590011   Wethersfield School District 90507001059 1590811 Alfred W. Hanmer School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 213 21 40   0 18     0   11   145 158     36             32   303 213 21 40   0 18     0   11   145 158     36       32   303
2779044 CT     school 905070 1590011   Wethersfield School District 90507001059 1590811 Alfred W. Hanmer School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 243 20 46   0 21     0   14   161 183     41             47   344 243 20 46   0 21     0   14   161 183     41       47   344
2452123 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2019   pk_12_total * 16 7   0 *     0   *   25 7     0             32   32   16 7   0       0       25 7     0       32   32
2757710 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2021   pk_12_total * 16 8   0 8     0   *   * *     *             *   40   16 8   0 8     0                           40
2778153 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2020   pk_12_total * 12 8   0 *     0   *   24 7     0             31   31   12 8   0       0       24 7     0       31   31
2452119 CT     school   620011   Hamden School District 90186001433 628011 Alice Peck Learning Center Program           2019   pk_12_total 42 27 19   0 15     0   11   69 45     0             57   114 42 27 19   0 15     0   11   69 45     0       57   114
2757706 CT     school   620011   Hamden School District 90186001433 628011 Alice Peck Learning Center Program           2021   pk_12_total 13 37 21   0 *     0   *   58 30     0             65   88 13 37 21   0       0       58 30     0       65   88
2778149 CT     school   620011   Hamden School District 90186001433 628011 Alice Peck Learning Center Program           2020   pk_12_total 36 36 25   0 16     0   9   66 56     0             58   122 36 36 25   0 16     0   9   66 56     0       58   122
2451945 CT     school 901170 400011   East Granby School District 90117000180 400111 Allgrove School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 151 10 9   * 11     *   6   105 84     *             23   189 151 10 9     11         6   105 84             23   189
2757527 CT     school 901170 400011   East Granby School District 90117000180 400111 Allgrove School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 138 11 *   0 *     0   11   94 81     *             23   175 138 11     0       0   11   94 81             23   175
2777977 CT     school 901170 400011   East Granby School District 90117000180 400111 Allgrove School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 145 16 *   * 12     0   13   107 90     10             28   197 145 16       12     0   13   107 90     10       28   197
2452982 CT     school 904950 1560011   West Haven School District 90495001027 1560811 Alma E. Pagels School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 143 82 98   * 24     0   *   210 150     68             101   360 143 82 98     24     0       210 150     68       101   360
2758557 CT     school 904950 1560011   West Haven School District 90495001027 1560811 Alma E. Pagels School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 114 88 105   0 34     0   21   200 162     80             112   362 114 88 105   0 34     0   21   200 162     80       112   362
2779009 CT     school 904950 1560011   West Haven School District 90495001027 1560811 Alma E. Pagels School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 128 89 103   * 29     0   *   210 157     68             110   367 128 89 103     29     0       210 157     68       110   367
2451929 CT     school 901020 340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program Alternative School No Not reported M M 2019   pk_12_total 30 10 44   * *     0   *   49 42     6             16   91 30 10 44           0       49 42     6       16   91

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