Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 1,449

grade

  • pk_12_total · 1,449
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
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
2453072 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 19 681 360   * *     0   21   509 574     118             71   1083 19 681 360           0   21   509 574     118       71   1083
2452213 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   pk_12_total * 666 38   0 *     0   *   336 381     0             42   717   666 38   0       0       336 381     0       42   717
2451970 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2019   pk_12_total 230 624 782   * 101     *   34   948 829     147             311   1777 230 624 782     101         34   948 829     147       311   1777
2452467 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2019   pk_12_total 46 597 289   * 8     *   *   507 439     156             192   946 46 597 289     8             507 439     156       192   946
2451795 CT     school 900450 150011   Bridgeport School District 90045000056 156211 Central High School Public Schools Regular School No High 09 12 2019   pk_12_total 211 591 639   13 44     *   *   741 774     205             258   1515 211 591 639   13 44             741 774     205       258   1515
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
2453058 CT     school 905220 1640011   Windsor School District 90522001096 1646111 Windsor High School Public Schools Regular School No High 09 12 2019   pk_12_total 273 552 190   0 *     *   54   570 540     22             209   1110 273 552 190   0           54   570 540     22       209   1110
2453080 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total 15 529 197   * *     0   12   371 385     41             60   756 15 529 197           0   12   371 385     41       60   756
2452211 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2019   pk_12_total * 477 17   0 0     0   *   227 275     0             26   502   477 17   0 0     0       227 275     0       26   502
2453075 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2019   pk_12_total * 463 167   * 0     0   *   323 311     *             71   634   463 167     0     0       323 311             71   634
2451747 CT     school 900330 110011   Bloomfield School District 90033000029 116111 Bloomfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 13 456 56   * *     0   17   287 260     14             97   547 13 456 56           0   17   287 260     14       97   547
2452137 CT     school 901860 620011   Hamden School District 90186000339 626111 Hamden High School Public Schools Regular School No High 09 12 2019   pk_12_total 533 453 284   6 115     0   63   733 721     70             219   1454 533 453 284   6 115     0   63   733 721     70       219   1454
2452473 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2019   pk_12_total 179 429 944   * 34     0   *   805 789     314             254   1594 179 429 944     34     0       805 789     314       254   1594
2451797 CT     school 900450 150011   Bridgeport School District 90045000067 156311 Warren Harding High School Public Schools Regular School No High 09 12 2019   pk_12_total 67 403 597   * *     *   7   598 484     319             229   1082 67 403 597               7   598 484     319       229   1082
2452273 CT     school 902310 770011   Manchester School District 90231000424 776111 Manchester High School Public Schools Regular School No High 09 12 2019   pk_12_total 562 399 452   * 128     *   77   821 807     90             180   1628 562 399 452     128         77   821 807     90       180   1628
2452434 CT     school 902790 930011   New Haven School District 90279001388 933011 King/Robinson Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 41 381 69   0 *     0   *   250 259     24             62   509 41 381 69   0       0       250 259     24       62   509
2452773 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2019   pk_12_total 581 367 647   0 100     *   *   857 886     241             209   1743 581 367 647   0 100             857 886     241       209   1743
2452994 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 462 362 520   * 70     *   57   749 727     122             202   1476 462 362 520     70         57   749 727     122       202   1476
2452171 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Other KG 12 2019   pk_12_total * 345 238   0 *     0   8   284 315     88             97   599   345 238   0       0   8   284 315     88       97   599
2451865 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 2019   pk_12_total 137 337 159   * 28     *   46   314 396     14             104   710 137 337 159     28         46   314 396     14       104   710
2451792 CT     school 900450 150011   Bridgeport School District 90045000050 156111 Bassick High School Public Schools Regular School No High 09 12 2019   pk_12_total 55 332 477   * 14     0   *   530 354     194             233   884 55 332 477     14     0       530 354     194       233   884
2451780 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 57 331 388   * *     *   12   405 392     90             113   797 57 331 388               12   405 392     90       113   797
2452542 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2019   pk_12_total 554 330 740   * 74     *   22   912 810     184             213   1722 554 330 740     74         22   912 810     184       213   1722
2453136 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   pk_12_total 1123 330 366   22 174     22   197   1084 1150     187             247   2234 1123 330 366   22 174     22   197   1084 1150     187       247   2234
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
2452144 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2019   pk_12_total 43 323 121   0 11     0   25   263 260     29             62   523 43 323 121   0 11     0   25   263 260     29       62   523
2453056 CT     school 905220 1640011   Windsor School District 90522001095 1645311 Sage Park Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 196 322 122   0 *     *   54   367 351     26             107   718 196 322 122   0           54   367 351     26       107   718
2451967 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 107 321 519   * 42     *   60   537 514     120             203   1051 107 321 519     42         60   537 514     120       203   1051
2452426 CT     school 902790 930011   New Haven School District 90279000551 930911 Davis Academy for Arts & Design Innovation Public Schools Regular School No Elementary PK 08 2019   pk_12_total 99 309 91   * *     0   10   251 266     8             59   517 99 309 91           0   10   251 266     8       59   517
2453073 CT     school 900217 2950013   Booker T. Washington Academy District 90021701750 2950113 Booker T. Washington Academy Public Charter Schools Regular School Yes Elementary KG 05 2019   pk_12_total * 309 45   0 0     0   *   186 174     27             22   360   309 45   0 0     0       186 174     27       22   360
2452935 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2019   pk_12_total 172 306 645   * 13     *   18   637 525     188             311   1162 172 306 645     13         18   637 525     188       311   1162
2452540 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2019   pk_12_total 363 300 823   0 51     0   25   807 *     213             208   1562 363 300 823   0 51     0   25   807       213       208   1562
2452399 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2019   pk_12_total 402 299 1385   * 70     0   *   1158 1050     390             502   2208 402 299 1385     70     0       1158 1050     390       502   2208
2452376 CT     school 900028 2800013   New Beginnings Inc Family Academy District 90002801366 2800113 New Beginnings Inc Family Academy Public Charter Schools Regular School Yes Elementary PK 08 2019   pk_12_total 10 298 166   0 *     *   *   246 236     *             40   482 10 298 166   0               246 236             40   482
2452466 CT     school 902790 930011   New Haven School District 90279000556 936311 Hill Regional Career High School Public Schools Regular School No High 09 12 2019   pk_12_total 59 295 305   * 30     0   *   295 405     61             70   700 59 295 305     30     0       295 405     61       70   700
2451765 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 221 293 487   * 41     *   13   606 461     237             151   1067 221 293 487     41         13   606 461     237       151   1067
2452422 CT     school 902790 930011   New Haven School District 90279001585 932111 Brennan Rogers School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 27 293 144   * *     0   8   233 245     33             77   478 27 293 144           0   8   233 245     33       77   478
2452135 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 323 292 181   0 54     0   50   482 418     30             167   900 323 292 181   0 54     0   50   482 418     30       167   900
2452940 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2019   pk_12_total 100 284 590   * *     0   19   545 457     177             239   1002 100 284 590           0   19   545 457     177       239   1002
2452329 CT     school 902490 830011   Middletown School District 90249000465 836211 Middletown High School Public Schools Regular School No High 09 12 2019   pk_12_total 681 283 221   * *     0   64   640 672     27             150   1312 681 283 221           0   64   640 672     27       150   1312
2452164 CT     school 901920 640011   Hartford School District 90192000383 642011 Webster Micro Society Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 104 281 163   * 45     0   *   322 300     33             76   622 104 281 163     45     0       322 300     33       76   622
2451775 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 54 278 293   * 11     *   6   346 301     27             156   647 54 278 293     11         6   346 301     27       156   647
2452463 CT     school 902790 930011   New Haven School District 90279001207 936411 Cooperative High School - Inter-District Magnet Public Schools Regular School No High 09 12 2019   pk_12_total 100 278 234   * *     0   9   200 430     33             83   630 100 278 234           0   9   200 430     33       83   630
2452438 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 98 274 157   * 9     0   *   289 259     53             74   548 98 274 157     9     0       289 259     53       74   548
2451741 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 19 273 28   * *     0   22   167 187     21             46   354 19 273 28           0   22   167 187     21       46   354
2451708 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2019   pk_12_total 117 272 129   * 23     *   21   267 297     36             71   564 117 272 129     23         21   267 297     36       71   564
2452185 CT     school 901920 640011   Hartford School District 90192001295 645411 Hartford Magnet Trinity College Academy Public Schools Regular School No High 06 12 2019   pk_12_total 192 272 485   * 48     *   53   487 570     78             126   1057 192 272 485     48         53   487 570     78       126   1057
2452162 CT     school 901920 640011   Hartford School District 90192000376 641711 Rawson School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 0 268 83   * 0     *   8   185 177     53             67   362 0 268 83     0         8   185 177     53       67   362
2452436 CT     school 902790 930011   New Haven School District 90279000566 932011 Lincoln-Bassett School Public Schools Regular School No Elementary PK 06 2019   pk_12_total * 268 83   0 9     0   *   210 161     10             70   371   268 83   0 9     0       210 161     10       70   371
2452425 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 53 267 325   * 7     *   *   327 335     76             70   662 53 267 325     7             327 335     76       70   662
2452443 CT     school 902790 930011   New Haven School District 90279000586 933211 Wexler/Grant Community School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 10 266 91   0 0     0   6   196 177     18             56   373 10 266 91   0 0     0   6   196 177     18       56   373
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
2452805 CT     school 904440 1380011   Stratford School District 90444000885 1386211 Bunnell High School Public Schools Regular School No High 09 12 2019   pk_12_total 444 256 296   0 29     0   21   516 530     13             121   1046 444 256 296   0 29     0   21   516 530     13       121   1046
2452418 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 97 255 169   0 20     *   *   270 276     71             57   546 97 255 169   0 20             270 276     71       57   546
2451930 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2019   pk_12_total 1078 251 1445   * 225     *   81   1612 1474     434             425   3086 1078 251 1445     225         81   1612 1474     434       425   3086
2452936 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2019   pk_12_total 246 250 692   11 21     0   24   635 609     223             259   1244 246 250 692   11 21     0   24   635 609     223       259   1244
2452921 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 143 248 599   10 22     0   30   543 509     122             199   1052 143 248 599   10 22     0   30   543 509     122       199   1052
2452417 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 32 243 178   0 *     0   *   253 206     51             65   459 32 243 178   0       0       253 206     51       65   459
2452462 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2019   pk_12_total 197 237 119   0 38     0   10   396 205     13             36   601 197 237 119   0 38     0   10   396 205     13       36   601
2452808 CT     school 904440 1380011   Stratford School District 90444000897 1386111 Stratford High School Public Schools Regular School No High 09 12 2019   pk_12_total 367 237 313   0 31     *   *   503 470     61             106   973 367 237 313   0 31             503 470     61       106   973
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
2452990 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 315 234 352   * 26     *   29   466 494     87             144   960 315 234 352     26         29   466 494     87       144   960
2452269 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2019   pk_12_total 289 233 296   * 75     *   27   467 455     58             136   922 289 233 296     75         27   467 455     58       136   922
2451788 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 42 230 251   8 25     *   *   278 284     109             89   562 42 230 251   8 25             278 284     109       89   562
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
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
2451768 CT     school 900450 150011   Bridgeport School District 90045000075 152111 Classical Studies Academy Public Schools Regular School No Elementary PK 08 2019   pk_12_total 48 226 153   * 11     *   8   224 229     25             62   453 48 226 153     11         8   224 229     25       62   453
2453084 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes Middle 06 10 2019   pk_12_total 22 224 209   * 0     *   7   216 249     60             85   465 22 224 209     0         7   216 249     60       85   465
2452918 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 165 220 535   10 17     0   31   497 481     109             186   978 165 220 535   10 17     0   31   497 481     109       186   978
2452427 CT     school   930011   New Haven School District   932711 Dr. Reginald Mayo Early Learning Center Program           2019   pk_12_total 18 218 140   * *     0   10   201 196     0             82   397 18 218 140           0   10   201 196     0       82   397
2453121 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201140 9001416 Eli Whitney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 66 215 288   * 7     *   14   304 289     46             93   593 66 215 288     7         14   304 289     46       93   593
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
2453119 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201137 9001116 Bullard-Havens Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 30 213 488   * *     0   20   362 398     53             35   760 30 213 488           0   20   362 398     53       35   760
2451856 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 2019   pk_12_total 91 211 113   * 31     0   *   218 258     33             89   476 91 211 113     31     0       218 258     33       89   476
2452989 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 281 211 357   * 30     *   36   510 408     91             145   918 281 211 357     30         36   510 408     91       145   918
2451767 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 90 210 730   8 25     *   *   585 487     478             155   1072 90 210 730   8 25             585 487     478       155   1072
2451778 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 58 210 198   * 50     0   *   252 271     24             69   523 58 210 198     50     0       252 271     24       69   523
2452423 CT     school 902790 930011   New Haven School District 90279001484 934811 Celentano BioTech, Health and Medical Magnet School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 31 210 127   0 11     0   9   174 214     40             69   388 31 210 127   0 11     0   9   174 214     40       69   388
2452897 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2019   pk_12_total 171 208 372   7 25     0   25   334 474     27             67   808 171 208 372   7 25     0   25   334 474     27       67   808
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
2452439 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 121 207 300   0 23     0   7   348 310     71             55   658 121 207 300   0 23     0   7   348 310     71       55   658
2452470 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2019   pk_12_total 25 206 66   0 *     0   *   149 155     *             58   304 25 206 66   0       0       149 155             58   304
2451852 CT     school 900700 2410014   Capitol Region Education Council 90070001601 2410514 Museum Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2019   pk_12_total 114 205 137   * *     0   38   267 254     33             50   521 114 205 137           0   38   267 254     33       50   521
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
2452444 CT     school 902790 930011   New Haven School District 90279000553 931211 Edgewood School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 134 204 73   * *     0   17   213 225     31             46   438 134 204 73           0   17   213 225     31       46   438
2451771 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 69 203 474   15 27     0   11   414 385     228             144   799 69 203 474   15 27     0   11   414 385     228       144   799
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
2452192 CT     school 901920 640011   Hartford School District 90192001572 647111 Bulkeley High School Public Schools Regular School No High 09 12 2019   pk_12_total 13 202 439   0 15     *   *   356 324     264             122   680 13 202 439   0 15             356 324     264       122   680
2451776 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 188 201 215   * 37     *   18   354 310     88             80   664 188 201 215     37         18   354 310     88       80   664
2451781 CT     school 900450 150011   Bridgeport School District 90045000081 152611 Roosevelt School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 65 197 293   6 21     *   *   271 313     127             94   584 65 197 293   6 21             271 313     127       94   584
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
2451770 CT     school 900450 150011   Bridgeport School District 90045001918 153111 Geraldine Claytor Magnet Academy Public Schools Regular School No Elementary PK 08 2019   pk_12_total 42 187 223   * *     *   7   233 233     70             71   466 42 187 223               7   233 233     70       71   466
2452461 CT     school 902790 930011   New Haven School District 90279000545 935511 Betsy Ross Arts Magnet School Public Schools Regular School No Middle 05 08 2019   pk_12_total 90 187 157   * 7     0   *   147 301     30             45   448 90 187 157     7     0       147 301     30       45   448
2452166 CT     school 901920 640011   Hartford School District 90192000385 642211 Wish Museum School Public Schools Regular School No Elementary PK 08 2019   pk_12_total * 185 306   0 *     0   *   254 248     167             129   502   185 306   0       0       254 248     167       129   502
2452165 CT     school 901920 640011   Hartford School District 90192000384 642111 West Middle School Public Schools Regular School No Elementary PK 08 2019   pk_12_total * 184 248   0 32     0   *   243 237     163             76   480   184 248   0 32     0       243 237     163       76   480
2451866 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 2019   pk_12_total 142 183 272   * *     0   39   389 277     43             122   666 142 183 272           0   39   389 277     43       122   666
2452271 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 285 181 243   6 52     0   36   423 380     40             122   803 285 181 243   6 52     0   36   423 380     40       122   803
2452151 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2019   pk_12_total 177 179 403   * *     0   45   312 521     72             139   833 177 179 403           0   45   312 521     72       139   833
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

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