Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by multiracial_int

View and edit SQL

grade

year

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
2451971 CT     school 901260 430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program Alternative School No High 10 12 2019   pk_12_total * 28 50   0 0     0   *   63 31     6             21   94   28 50   0 0     0       63 31     6       21   94
2451974 CT     school 901290 440011   East Haven School District 90129000218 441011 Grove J. Tuttle School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 148 15 96   * 11     0   *   153 127     45             26   280 148 15 96     11     0       153 127     45       26   280
2451977 CT     school 901290 440011   East Haven School District 90129000215 441311 Dominick H. Ferrara School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 111 8 48   * 10     0   *   86 99     16             34   185 111 8 48     10     0       86 99     16       34   185
2451978 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 285 36 166   * 18     0   *   241 270     41             81   511 285 36 166     18     0       241 270     41       81   511
2451979 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 567 30 239   0 47     *   *   473 424     81             124   897 567 30 239   0 47             473 424     81       124   897
2451980 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2019   pk_12_total 49 * *   0 *     0   *   31 26     0             28   57 49       0       0       31 26     0       28   57
2451981 CT     school 901320 450011   East Lyme School District 90132000225 450111 Flanders School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 251 * 30   0 31     0   *   159 175     7             43   334 251   30   0 31     0       159 175     7       43   334
2451985 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2019   pk_12_total * 0 0   0 0     0   *   9 6     0             8   15   0 0   0 0     0       9 6     0       8   15
2451988 CT     school 901350 470011   East Windsor School District 90135000228 470111 Broad Brook Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 236 58 113   * 38     0   *   240 232     33             75   472 236 58 113     38     0       240 232     33       75   472
2451989 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 180 42 77   * 11     0   *   162 157     9             63   319 180 42 77     11     0       162 157     9       63   319
2451990 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2019   pk_12_total 174 47 55   0 *     0   *   168 127     7             64   295 174 47 55   0       0       168 127     7       64   295
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
2451994 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001530 2536114 Quinebaug Middle College Regional Education Service Center Schools Regular School No High 09 12 2019   pk_12_total 128 6 37   * *     0   *   61 117     0             26   178 128 6 37           0       61 117     0       26   178
2451999 CT     school   2420014   EdAdvance 90351200575 2428014 EdAdvance Headstart Program           2019   pk_12_total 146 9 40   * 6     7   *   105 105     0             32   210 146 9 40     6     7       105 105     0       32   210
2452001 CT     school   2420014   EdAdvance   2420114 Steps Program           2019   pk_12_total 14 * *   0 0     0   *   16 6     0             22   22 14       0 0     0       16 6     0       22   22
2452002 CT     school   2420014   EdAdvance   2420214 Torrington Alternative Program             2019   pk_12_total 10 * *   * 0     0   *   11 6     0             *   17 10         0     0       11 6     0           17
2452007 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 412 20 24   0 12     *   *   249 228     *             65   477 412 20 24   0 12             249 228             65   477
2452012 CT     school 900216 2910013   Elm City Montessori School District 90021601683 2910113 Elm City Montessori School Public Charter Schools Regular School Yes Elementary PK 04 2019   pk_12_total 51 83 52   0 *     0   *   95 104     *             8   199 51 83 52   0       0       95 104             8   199
2452013 CT     school 901470 490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program Special Education School No Prekindergarten PK PK 2019   pk_12_total 62 * *   0 *     0   *   48 26     0             46   74 62       0       0       48 26     0       46   74
2452014 CT     school 901470 490011   Enfield School District 90147001810 491011 EPS PK STEAM Academy Program Regular School No Prekindergarten PK PK 2019   pk_12_total 31 17 14   0 *     0   *   39 29     0             10   68 31 17 14   0       0       39 29     0       10   68
2452015 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2019   pk_12_total 59 6 34   0 *     0   *   56 48     0             14   104 59 6 34   0       0       56 48     0       14   104
2452017 CT     school 901470 490011   Enfield School District 90147000247 490411 Hazardville Memorial School Public Schools Regular School No Elementary KG 02 2019   pk_12_total 244 28 63   * 12     0   *   187 169     23             48   356 244 28 63     12     0       187 169     23       48   356
2452022 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2019   pk_12_total * 0 0   0 0     0   *   0 *     0             *   *   0 0   0 0     0       0       0            
2452027 CT     school 901470 490011   Enfield School District 90147000254 491511 Prudence Crandall School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 265 28 77   * 16     0   *   213 186     9             62   399 265 28 77     16     0       213 186     9       62   399
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
2452046 CT     school 901530 510011   Fairfield School District 90153000267 511211 Riverfield School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 339 * 27   0 20     0   *   228 178     6             43   406 339   27   0 20     0       228 178     6       43   406
2452059 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2019   pk_12_total 373 41 58   * 166     0   *   346 315     19             81   661 373 41 58     166     0       346 315     19       81   661
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
2452062 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2019   pk_12_total 6 0 *   0 *     0   *   * *     *             *   9 6 0     0       0                           9
2452063 CT     school 901590 530011   Franklin School District 90159000278 530111 Franklin Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 125 8 9   0 *     0   *   83 71     0             9   154 125 8 9   0       0       83 71     0       9   154
2452064 CT     school   540011   Glastonbury School District 90162001724 540511 PreK-Eastbury Program           2019   pk_12_total 35 * 10   0 6     0   *   43 13     0             44   56 35   10   0 6     0       43 13     0       44   56
2452070 CT     school   540011   Glastonbury School District 90162001801 540111 Links Academy Program           2019   pk_12_total 23 0 8   * 0     0   *   25 8     *             33   33 23 0 8     0     0       25 8             33   33
2452087 CT     school 901710 570011   Greenwich School District 90171000303 570611 New Lebanon School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 47 9 149   * 16     0   *   116 113     40             40   229 47 9 149     16     0       116 113     40       40   229
2452088 CT     school 901710 570011   Greenwich School District 90171000304 570711 North Mianus School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 293 * 75   0 95     0   *   263 229     25             40   492 293   75   0 95     0       263 229     25       40   492
2452092 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 280 38 249   * 46     0   *   323 315     34             93   638 280 38 249     46     0       323 315     34       93   638
2452098 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 09 12 2019   pk_12_total 10 * *   0 0     0   *   * *     0             *   14 10       0 0     0               0           14
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
2452109 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2019   pk_12_total 6 * *   0 0     *   *   9 6     0             15   15 6       0 0             9 6     0       15   15
2452111 CT     school   590011   Groton School District   591011 Transition Academy Program           2019   pk_12_total 11 * *   0 0     0   *   * *     0             15   15 11       0 0     0               0       15   15
2452112 CT     school 901800 600011   Guilford School District 90180000333 600211 Guilford Lakes School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 248 * 26   0 17     0   *   168 142     16             39   310 248   26   0 17     0       168 142     16       39   310
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
2452128 CT     school 901860 620011   Hamden School District 90186000346 620111 Shepherd Glen School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 59 95 61   * 65     0   *   154 143     51             37   297 59 95 61     65     0       154 143     51       37   297
2452130 CT     school 901860 620011   Hamden School District 90186000349 621411 West Woods School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 182 53 39   * 45     0   *   179 162     22             36   341 182 53 39     45     0       179 162     22       36   341
2452132 CT     school   620011   Hamden School District   620911 Bear Path IIC Program           2019   pk_12_total 6 9 *   0 0     0   *   * *     *             24   24 6 9     0 0     0                       24   24
2452136 CT     school   620011   Hamden School District 90186001741 620511 Hamden Collaborative Learning Center Program           2019   pk_12_total 12 24 *   0 0     0   *   29 17     0             28   46 12 24     0 0     0       29 17     0       28   46
2452142 CT     school 901920 640011   Hartford School District 90192001369 643311 Breakthrough Magnet School, South Public Schools Regular School No Elementary PK 08 2019   pk_12_total 59 79 175   * 24     0   *   179 171     47             53   350 59 79 175     24     0       179 171     47       53   350
2452145 CT     school 901920 640011   Hartford School District 90192000360 640711 Dwight-Bellizzi Dual Language Academy Public Schools Regular School No Elementary PK 08 2019   pk_12_total 24 96 452   * 15     0   *   299 297     230             77   596 24 96 452     15     0       299 297     230       77   596
2452146 CT     school   640011   Hartford School District 90192001723 644111 Early Childhood Development Center (ECDC) Program           2019   pk_12_total * 9 32   0 *     0   *   33 11     0             *   44   9 32   0       0       33 11     0           44
2452147 CT     school 901920 640011   Hartford School District 90192000366 640911 Environmental Sciences Magnet at Hooker School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 117 70 371   * 29     0   *   312 295     72             62   607 117 70 371     29     0       312 295     72       62   607
2452148 CT     school 901920 640011   Hartford School District 90192000636 643211 Expeditionary Learning Academy at Moylan School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 24 53 470   0 *     0   *   284 267     170             123   551 24 53 470   0       0       284 267     170       123   551
2452149 CT     school 901920 640011   Hartford School District 90192001643 641311 Hartford PreKindergarten Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 12 50 23   * 57     0   *   71 80     0             6   151 12 50 23     57     0       71 80     0       6   151
2452150 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 22 85 501   * 6     7   *   322 304     197             112   626 22 85 501     6     7       322 304     197       112   626
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
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
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
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
2452157 CT     school 901920 640011   Hartford School District 90192000373 641511 Parkville Community School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 20 47 375   * *     *   *   226 225     175             77   451 20 47 375                   226 225     175       77   451
2452158 CT     school   640011   Hartford School District   640310 Pre-K Integrated - Burr School             2019   pk_12_total * 6 20   0 0     0   *   20 9     0             9   29   6 20   0 0     0       20 9     0       9   29
2452163 CT     school 901920 640011   Hartford School District 90192000026 643011 Sanchez School Public Schools Regular School No Elementary PK 05 2019   pk_12_total * 46 373   0 *     0   *   188 236     198             69   424   46 373   0       0       188 236     198       69   424
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
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
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
2452170 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2019   pk_12_total 20 70 437   6 10     *   *   271 275     231             96   546 20 70 437   6 10             271 275     231       96   546
2452172 CT     school 901920 640011   Hartford School District 90192000377 640111 SAND School Public Schools Regular School No Elementary KG 08 2019   pk_12_total * 138 253   0 0     0   *   218 177     108             86   395   138 253   0 0     0       218 177     108       86   395
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
2452178 CT     school   640011   Hartford School District 90192001673 644411 iGOAL 1 - Rawson School Program           2019   pk_12_total 0 9 *   0 0     0   *   * *     *             18   18 0 9     0 0     0                       18   18
2452179 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2019   pk_12_total 0 * *   0 0     0   *   * *     *             *   * 0       0 0     0                            
2452183 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2019   pk_12_total 46 78 151   0 23     *   *   190 *     37             47   308 46 78 151   0 23             190       37       47   308
2452186 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total * 133 43   0 *     0   *   101 81     18             45   182   133 43   0       0       101 81     18       45   182
2452188 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2019   pk_12_total 150 155 314   * 30     0   *   407 272     71             73   679 150 155 314     30     0       407 272     71       73   679
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
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
2452194 CT     school 901920 640011   Hartford School District 90192001574 647211 HPHS Engineering and Green Technology Academy   Regular School No High 09 12 2019   pk_12_total 13 144 198   0 11     *   *   292 78     119             81   370 13 144 198   0 11             292 78     119       81   370
2452195 CT     school 901920 640011   Hartford School District 90192001576 647411 HPHS Law and Government Academy   Regular School No High 09 12 2019   pk_12_total 6 119 192   0 *     *   *   161 163     79             67   324 6 119 192   0               161 163     79       67   324
2452196 CT     school 901920 640011   Hartford School District 90192001559 647511 HPHS Nursing and Health Sciences Academy   Regular School No High 09 12 2019   pk_12_total 11 114 202   * 15     0   *   102 242     124             58   344 11 114 202     15     0       102 242     124       58   344
2452197 CT     school 901920 640011   Hartford School District 90192001552 647611 High School, Inc.   Regular School No High 09 12 2019   pk_12_total * 81 102   * 0     0   *   95 95     35             45   190   81 102     0     0       95 95     35       45   190
2452198 CT     school 901920 640011   Hartford School District 90192001562 647711 Journalism and Media Academy   Regular School No High 09 12 2019   pk_12_total * 94 70   0 *     0   *   73 97     17             37   170   94 70   0       0       73 97     17       37   170
2452206 CT     school 901920 640011   Hartford School District 90192001650 643911 Capital Community College Magnet Academy   Regular School No High 12 12 2019   pk_12_total * 7 *   0 0     0   *   * *     0             *   11   7     0 0     0               0           11
2452209 CT     school 902010 670011   Hebron School District 90201000387 670211 Gilead Hill School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 286 * 13   0 *     0   *   149 159     *             25   308 286   13   0       0       149 159             25   308
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
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
2452224 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2019   pk_12_total * * *   0 0     0   *   * *     *             15   15         0 0     0                       15   15
2452225 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2019   pk_12_total 6 * *   0 0     0   *   * *     0             11   11 6       0 0     0               0       11   11
2452227 CT     school   2450014   Learn   2450814 Learn SAILS Middle School Program             2019   pk_12_total * * *   0 0     0   *   7 0     0             7   7         0 0     0       7 0     0       7   7
2452229 CT     school   2450014   Learn   2451214 Learn ABA Program at Center School             2019   pk_12_total * * 6   0 *     0   *   * *     *             15   15     6   0       0                       15   15
2452236 CT     school 902130 710011   Lebanon School District 90213000395 710111 Lebanon Elementary School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 325 6 22   * 6     *   *   208 158     7             41   366 325 6 22     6             208 158     7       41   366
2452237 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 257 * 20   * 7     *   *   148 151     *             50   299 257   20     7             148 151             50   299
2452247 CT     school 902220 740011   Litchfield School District 90222000405 740211 Center School Public Schools Regular School No Elementary PK 03 2019   pk_12_total 258 * 13   0 7     *   *   144 141     0             40   285 258   13   0 7             144 141     0       40   285
2452248 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2019   pk_12_total 172 0 10   0 *     0   *   97 93     *             32   190 172 0 10   0       0       97 93             32   190
2452249 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 122 0 6   0 *     *   *   82 56     0             25   138 122 0 6   0               82 56     0       25   138
2452250 CT     school 902220 740011   Litchfield School District 90222000406 746111 Litchfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 252 * 12   0 *     *   *   137 140     0             38   277 252   12   0               137 140     0       38   277
2452254 CT     school 902280 760011   Madison School District 90228000413 760311 Kathleen H. Ryerson Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 169 0 *   0 13     0   *   107 87     *             22   194 169 0     0 13     0       107 87             22   194
2452258 CT     school 902310 770011   Manchester School District 90231000418 770311 Buckley School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 154 89 79   * 41     0   *   205 161     27             56   366 154 89 79     41     0       205 161     27       56   366
2452259 CT     school 902310 770011   Manchester School District 90231000422 770611 Keeney School Public Schools Regular School No Elementary PK 04 2019   pk_12_total 147 47 60   0 28     *   *   150 135     14             45   285 147 47 60   0 28             150 135     14       45   285
2452261 CT     school   770011   Manchester School District 90231000519 778011 Manchester Preschool Center Program           2019   pk_12_total 50 54 72   0 *     0   *   109 79     0             45   188 50 54 72   0       0       109 79     0       45   188
2452263 CT     school 902310 770011   Manchester School District 90231000417 770111 Bowers School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 154 71 95   0 15     *   *   181 159     19             62   340 154 71 95   0 15             181 159     19       62   340
2452264 CT     school 902310 770011   Manchester School District 90231000420 770411 Highland Park School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 113 47 38   * 14     0   *   100 121     11             14   221 113 47 38     14     0       100 121     11       14   221
2452265 CT     school 902310 770011   Manchester School District 90231000425 771611 Martin School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 102 51 55   0 15     *   *   121 106     *             49   227 102 51 55   0 15             121 106             49   227
2452266 CT     school 902310 770011   Manchester School District 90231000429 771211 Verplanck School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 55 86 107   * 16     0   *   160 109     32             35   269 55 86 107     16     0       160 109     32       35   269
2452270 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2019   pk_12_total 9 * 11   0 0     0   *   21 6     0             *   27 9   11   0 0     0       21 6     0           27

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