Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2019 · 20,252
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
2453144 CT     school 900031 2820013   Stamford Academy District 90003101405 2826013 Stamford Academy   Regular School Yes High 09 12 2019   pk_12_total 9 70 66   0 *     0   *   84 68     9             54   152 9 70 66   0       0       84 68     9       54   152
2453102 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2019   pk_12_total 887 8 26   * 24     0   *   477 475     *             120   952 887 8 26     24     0       477 475             120   952
2453053 CT     school 905220 1640011   Windsor School District 90522001093 1640511 Poquonock Elementary School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 88 117 81   0 22     0   25   175 158     6             57   333 88 117 81   0 22     0   25   175 158     6       57   333
2451769 CT     school 900450 150011   Bridgeport School District 90045000058 150511 Columbus School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 87 160 302   * *     0   9   294 271     180             56   565 87 160 302           0   9   294 271     180       56   565
2451796 CT     school 900450 150011   Bridgeport School District 90045001633 151511 Information Technology & Software Engineering Magnet High School Public Schools Regular School No High 09 12 2019   pk_12_total 87 143 205   * 27     0   *   320 155     14             37   475 87 143 205     27     0       320 155     14       37   475
2452414 CT     school 902760 920011   New Hartford School District 90276000539 920111 Bakerville Consolidated School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 87 0 *   0 0     0   *   50 40     0             6   90 87 0     0 0     0       50 40     0       6   90
2451864 CT     school 900700 2410014   Capitol Region Education Council 90070001625 2415314 Greater Hartford Academy of the Arts Magnet Middle Regional Education Service Center Schools Regular School No Middle 06 08 2019   pk_12_total 86 79 155   0 *     0   *   88 247     16             88   335 86 79 155   0       0       88 247     16       88   335
2452231 CT     school 903450 2450014   Learn 90345001581 2456014 Connecticut River Academy at Goodwin University Regional Education Service Center Schools Regular School No High 09 12 2019   pk_12_total 86 97 262   * 14     *   15   232 244     38             78   476 86 97 262     14         15   232 244     38       78   476
2452154 CT     school 901920 640011   Hartford School District 90192001641 640511 Montessori Magnet at Batchelder School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 85 58 177   * 11     0   *   163 182     61             36   345 85 58 177     11     0       163 182     61       36   345
2452184 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2019   pk_12_total 85 230 182   0 *     *   20   * 288     39             85   533 85 230 182   0           20     288     39       85   533
2452413 CT     school 902760 920011   New Hartford School District 90276000540 920211 New Hartford Elementary School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 85 * *   0 *     0   *   53 43     *             10   96 85       0       0       53 43             10   96
2452061 CT     school 901560 520011   Farmington School District 90156000273 526111 Farmington High School Public Schools Regular School No High 09 12 2019   pk_12_total 849 62 73   * 243     0   *   629 617     14             156   1246 849 62 73     243     0       629 617     14       156   1246
2452155 CT     school 901920 640011   Hartford School District 90192001531 643711 Montessori Magnet at Fisher School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 84 152 63   * 35     0   *   178 174     21             24   352 84 152 63     35     0       178 174     21       24   352
2452378 CT     school 902670 890011   New Britain School District 90267000512 890511 Gaffney Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 84 39 281   0 9     0   21   207 227     55             83   434 84 39 281   0 9     0   21   207 227     55       83   434
2452898 CT     school 904830 1510011   Waterbury School District 90483000990 1510811 Wendell L. Cross School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 84 58 167   * 21     0   *   182 167     45             63   349 84 58 167     21     0       182 167     45       63   349
2451851 CT     school 900700 2410014   Capitol Region Education Council 90070000210 2413114 Montessori Magnet School Regional Education Service Center Schools Regular School No Elementary PK 06 2019   pk_12_total 83 37 204   0 11     0   22   178 179     46             57   357 83 37 204   0 11     0   22   178 179     46       57   357
2452127 CT     school 901860 620011   Hamden School District 90186000345 621111 Ridge Hill School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 83 84 103   0 24     0   11   149 156     31             28   305 83 84 103   0 24     0   11   149 156     31       28   305
2452925 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 83 234 576   * *     0   24   463 465     86             182   928 83 234 576           0   24   463 465     86       182   928
2453128 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 83 77 250   0 *     0   *   235 186     22             53   421 83 77 250   0       0       235 186     22       53   421
2452497 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2019   pk_12_total 827 76 221   * 114     *   68   693 617     16             147   1310 827 76 221     114         68   693 617     16       147   1310
2452519 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 827 38 73   * 64     *   29   528 506     11             117   1034 827 38 73     64         29   528 506     11       117   1034
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
2451992 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2019   pk_12_total 82 6 26   * 0     0   *   94 26     *             120   120 82 6 26     0     0       94 26             120   120
2452139 CT     school 901890 630011   Hampton School District 90189000351 630111 Hampton Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 82 0 *   * *     0   6   51 42     0             17   93 82 0             0   6   51 42     0       17   93
2452390 CT     school 902670 890011   New Britain School District 90267000524 891311 Smith Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 82 56 366   * *     0   16   276 260     79             73   536 82 56 366           0   16   276 260     79       73   536
2452507 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 82 0 *   0 0     0   *   54 41     *             18   95 82 0     0 0     0       54 41             18   95
2451773 CT     school 900450 150011   Bridgeport School District 90045001163 154511 High Horizons Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 81 192 167   * 8     0   *   206 248     11             45   454 81 192 167     8     0       206 248     11       45   454
2451941 CT     school 901110 370011   Derby School District 90111000178 370411 Irving School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 81 64 142   0 *     0   *   166 147     20             62   313 81 64 142   0       0       166 147     20       62   313
2452798 CT     school 904440 1380011   Stratford School District 90444000892 1381511 Stratford Academy - Johnson House Public Schools Regular School No Elementary 02 06 2019   pk_12_total 81 167 184   0 *     *   24   224 248     62             65   472 81 167 184   0           24   224 248     62       65   472
2453022 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 805 52 191   6 66     0   20   * 582     26             130   1140 805 52 191   6 66     0   20     582     26       130   1140
2452354 CT     school 902550 850011   Monroe School District 90255000489 856111 Masuk High School Public Schools Regular School No High 09 12 2019   pk_12_total 801 22 88   0 52     0   34   503 494     6             112   997 801 22 88   0 52     0   34   503 494     6       112   997
2452036 CT     school   510011   Fairfield School District 90153000989 518011 Early Childhood Center(0518011) Program           2019   pk_12_total 80 * 15   0 *     0   *   66 42     0             83   108 80   15   0       0       66 42     0       83   108
2451743 CT     school 900330 110011   Bloomfield School District 90033000033 110511 Metacomet School Public Schools Regular School No Elementary 03 04 2019   pk_12_total 8 213 28   * *     0   10   129 134     8             45   263 8 213 28           0   10   129 134     8       45   263
2451744 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 8 207 23   0 *     *   6   123 123     *             45   246 8 207 23   0           6   123 123             45   246
2451746 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 8 173 25   * *     0   13   127 96     *             45   223 8 173 25           0   13   127 96             45   223
2451817 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2019   pk_12_total 8 * 8   0 0     *   0   * *     *             20   20 8   8   0 0         0                   20   20
2452108 CT     school   590011   Groton School District   590611 Apex Academy Program           2019   pk_12_total 8 0 6   * 0     0   *   11 6     *             11   17 8 0 6     0     0       11 6             11   17
2452292 CT     school   800011   Meriden School District   800911 STEP - ES Program           2019   pk_12_total 8 * 15   0 0     0   *   * *     *             28   28 8   15   0 0     0                       28   28
2452375 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2019   pk_12_total 8 * *   0 0     0   0   * *     *             0   15 8       0 0     0   0                   0   15
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
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
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
2452809 CT     school   1380011   Stratford School District 90444001437 1389011 Strive-Stratford Program           2019   pk_12_total 8 * *   0 0     0   *   * *     *             15   15 8       0 0     0                       15   15
2452904 CT     school   1510011   Waterbury School District   1514111 Chase Bilingual Program           2019   pk_12_total 8 0 122   0 0     0   0   78 52     130             22   130 8 0 122   0 0     0   0   78 52     130       22   130
2452912 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2019   pk_12_total 8 24 65   0 *     0   *   77 25     24             *   102 8 24 65   0       0       77 25     24           102
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
2452879 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2019   pk_12_total 795 33 198   0 39     *   *   502 572     24             164   1074 795 33 198   0 39             502 572     24       164   1074
2452029 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 791 68 194   * 40     *   50   598 551     18             167   1149 791 68 194     40         50   598 551     18       167   1149
2453077 CT     school 900870 290011   Colebrook School District 90087000138 290111 Colebrook Consolidated School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 79 * *   0 0     0   *   54 30     0             18   84 79       0 0     0       54 30     0       18   84
2453140 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2019   pk_12_total 783 * 96   0 45     *   144   533 558     9             135   1091 783   96   0 45         144   533 558     9       135   1091
2452365 CT     school   880011   Naugatuck School District 90264001384 888111 Head Start Program           2019   pk_12_total 78 15 21   0 *     0   *   67 64     0             13   131 78 15 21   0       0       67 64     0       13   131
2452389 CT     school 902670 890011   New Britain School District 90267000523 891211 Smalley Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 78 47 514   0 *     0   *   327 334     174             96   661 78 47 514   0       0       327 334     174       96   661
2452887 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 78 88 275   * 11     *   17   246 230     45             71   476 78 88 275     11         17   246 230     45       71   476
2452977 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2019   pk_12_total 771 143 297   * 195     0   *   763 707     53             171   1470 771 143 297     195     0       763 707     53       171   1470
2453027 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2019   pk_12_total 770 * 66   * 104     0   54   471 532     *             138   1003 770   66     104     0   54   471 532             138   1003
2451898 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2019   pk_12_total 77 28 36   0 *     0   *   123 29     *             152   152 77 28 36   0       0       123 29             152   152
2451986 CT     school 901320 450011   East Lyme School District 90132000223 456111 East Lyme High School Public Schools Regular School No High 09 12 2019   pk_12_total 750 23 74   * 96     *   53   506 496     *             132   1002 750 23 74     96         53   506 496             132   1002
2452156 CT     school 901920 640011   Hartford School District 90192000372 641411 Naylor/CCSU Leadership Academy Public Schools Regular School No Elementary PK 08 2019   pk_12_total 75 53 369   * 20     *   *   276 245     153             101   521 75 53 369     20             276 245     153       101   521
2452883 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 75 103 258   * *     0   19   257 216     68             87   473 75 103 258           0   19   257 216     68       87   473
2453135 CT     school 900018 2720013   Explorations District 90001800834 2726113 Explorations Public Charter Schools Regular School Yes High 09 12 2019   pk_12_total 75 * 9   0 0     0   *   35 53     0             27   88 75   9   0 0     0       35 53     0       27   88
2451923 CT     school 901020 340011   Danbury School District 90102000162 341011 South Street School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 74 36 250   0 21     0   9   189 201     202             45   390 74 36 250   0 21     0   9   189 201     202       45   390
2451973 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 9 55   0 9     0   12   69 90     0             7   159 74 9 55   0 9     0   12   69 90     0       7   159
2452419 CT     school 902790 930011   New Haven School District 90279000543 930311 Beecher School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 74 256 136   * *     0   9   253 228     20             54   481 74 256 136           0   9   253 228     20       54   481
2452526 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 74 14 54   0 15     0   6   100 63     0             104   163 74 14 54   0 15     0   6   100 63     0       104   163
2452824 CT     school 904560 1420011   Tolland School District 90456000914 1426111 Tolland High School Public Schools Regular School No High 09 12 2019   pk_12_total 735 12 26   * 21     *   *   394 407     *             70   801 735 12 26     21             394 407             70   801
2453139 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2019   pk_12_total 734 * 54   0 33     *   45   454 421     *             96   875 734   54   0 33         45   454 421             96   875
2451777 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 73 204 527   * *     *   8   399 419     319             109   818 73 204 527               8   399 419     319       109   818
2452193 CT     school 901920 640011   Hartford School District 90192001403 647911 Great Path Academy at MCC Public Schools Regular School No High 09 12 2019   pk_12_total 73 107 130   0 *     0   *   119 207     15             35   326 73 107 130   0       0       119 207     15       35   326
2452488 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 729 * 153   * 40     0   44   537 *     29             150   991 729   153     40     0   44   537       29       150   991
2451730 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2019   pk_12_total 724 23 93   0 35     0   24   487 412     6             94   899 724 23 93   0 35     0   24   487 412     6       94   899
2452173 CT     school 901920 640011   Hartford School District 90192000362 642511 STEM Magnet at Annie Fisher School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 72 166 51   0 59     *   *   210 156     29             51   366 72 166 51   0 59             210 156     29       51   366
2452555 CT     school 903120 1040011   Norwich School District 90312000677 1041811 Veterans' Memorial School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 72 57 113   * 22     *   29   149 149     75             43   298 72 57 113     22         29   149 149     75       43   298
2453037 CT     school 905190 1630011   Windham School District 90519001214 1630311 North Windham School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 72 15 347   * *     0   *   229 215     160             71   444 72 15 347           0       229 215     160       71   444
2452374 CT     school 902640 880011   Naugatuck School District 90264000505 886111 Naugatuck High School Public Schools Regular School No High 09 12 2019   pk_12_total 718 117 309   * *     0   65   678 575     37             226   1253 718 117 309           0   65   678 575     37       226   1253
2452048 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 711 7 55   0 32     0   25   442 388     *             99   830 711 7 55   0 32     0   25   442 388             99   830
2452556 CT     school 903120 1040011   Norwich School District 90312000678 1041511 Wequonnoc Magnet School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 71 43 103   * *     *   37   139 120     52             37   259 71 43 103               37   139 120     52       37   259
2453078 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 71 0 13   0 *     0   *   53 38     *             11   91 71 0 13   0       0       53 38             11   91
2452813 CT     school 904470 1390011   Suffield School District 90447000904 1396111 Suffield High School Public Schools Regular School No High 09 12 2019   pk_12_total 709 20 40   * 29     *   7   373 437     *             90   810 709 20 40     29         7   373 437             90   810
2452346 CT     school 902520 840011   Milford School District 90252000473 846311 Joseph A. Foran High School Public Schools Regular School No High 09 12 2019   pk_12_total 708 50 58   * 53     *   *   437 437     *             138   874 708 50 58     53             437 437             138   874
2451829 CT     school 900510 170011   Bristol School District 90051000093 176211 Bristol Eastern High School Public Schools Regular School No High 09 12 2019   pk_12_total 701 74 227   * 28     *   31   539 526     22             220   1065 701 74 227     28         31   539 526     22       220   1065
2452615 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2019   pk_12_total 700 7 31   * 10     *   *   372 385     0             82   757 700 7 31     10             372 385     0       82   757
2451993 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2019   pk_12_total 70 * 32   * 0     0   9   30 90     *             23   120 70   32     0     0   9   30 90             23   120
2452391 CT     school 902670 890011   New Britain School District 90267000527 891511 Vance Elementary School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 70 53 313   * *     0   21   228 235     77             70   463 70 53 313           0   21   228 235     77       70   463
2451883 CT     school   250011   Cheshire School District   251011 QU College Life Program           2019   pk_12_total 7 0 0   0 0     0   0   * *     0             7   7 7 0 0   0 0     0   0           0       7   7
2451892 CT     school   280011   Colchester School District   280611 School Resilience Program             2019   pk_12_total 7 0 0   0 0     0   0   * *     0             *   7 7 0 0   0 0     0   0           0           7
2451900 CT     school   2430014   Cooperative Educational Services 90091001555 2439314 RISE Transitional Program Program           2019   pk_12_total 7 * 0   0 0     0   *   * *     0             10   10 7   0   0 0     0               0       10   10
2451931 CT     school   340011   Danbury School District   340711 Western Connection Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             9   9 7       0 0     0   0           0       9   9
2452035 CT     school   510011   Fairfield School District   510811 Early Childhood Center(0510811) Program           2019   pk_12_total 7 0 0   0 0     0   0   * *     0             7   7 7 0 0   0 0     0   0           0       7   7
2452153 CT     school 901920 640011   Hartford School District 90192000381 641911 Milner Middle School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 7 126 191   * 0     0   *   168 161     76             26   329 7 126 191     0     0       168 161     76       26   329
2452245 CT     school   720011   Ledyard School District   720511 Ledyard Transition Academy Program           2019   pk_12_total 7 * 0   * 0     0   0   * *     0             9   9 7   0     0     0   0           0       9   9
2452328 CT     school   830011   Middletown School District   832211 MHS- Alternative Education Program 3 Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             *   11 7       0 0     0   0           0           11
2452543 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2019   pk_12_total 7 * *   0 0     0   0   10 7     *             17   17 7       0 0     0   0   10 7             17   17
2452552 CT     school   1040011   Norwich School District   1040411 Strive Autism Program @ Huntington Program           2019   pk_12_total 7 * 6   0 *     0   *   * *     8             21   21 7   6   0       0               8       21   21
2452643 CT     school   2160012   Regional School District 16 90353801747 2160412 WRHS Alternative Education Program Program           2019   pk_12_total 7 * *   0 0     *   0   * *     0             *   10 7       0 0         0           0           10
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
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
2452867 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2019   pk_12_total 7 * *   * 0     0   0   * *     0             12   12 7         0     0   0           0       12   12
2452881 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2019   pk_12_total 7 * *   0 *     0   0   * *     *             13   13 7       0       0   0                   13   13
2452969 CT     school   1550011   West Hartford School District 90492001790 1559611 Wolcott Learning Center Program           2019   pk_12_total 7 * 8   0 *     0   *   13 6     *             19   19 7   8   0       0       13 6             19   19
2453023 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2019   pk_12_total 7 * *   0 0     0   0   * *     0             11   11 7       0 0     0   0           0       11   11

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