Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by native_hawaiian_pacific_islander descending

View and edit SQL

grade

year

  • 2021 · 20,116
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
2757415 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2021   pk_12_total 14 * *   0 0     0   *   13 9     0             22   22 14       0 0     0       13 9     0       22   22
2757416 CT     school 900540 180011   Brookfield School District 90054000110 180311 Center Elementary School Public Schools Regular School No Elementary PK 01 2021   pk_12_total 273 9 25   * 27     0   *   177 169     15             57   346 273 9 25     27     0       177 169     15       57   346
2757417 CT     school 900540 180011   Brookfield School District 90054001186 180411 Huckleberry Hill Elementary School Public Schools Regular School No Elementary 02 04 2021   pk_12_total 371 16 70   8 36     0   9   255 255     46             47   510 371 16 70   8 36     0   9   255 255     46       47   510
2757420 CT     school 900570 190011   Brooklyn School District 90057000113 190111 Brooklyn Elementary School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 378 10 62   * *     0   21   240 242     9             78   482 378 10 62           0   21   240 242     9       78   482
2757421 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 266 6 34   0 7     0   21   172 162     *             49   334 266 6 34   0 7     0   21   172 162             49   334
2757422 CT     school 900660 220011   Canterbury School District 90066001188 220211 Canterbury Elementary School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 222 * 16   * 0     0   *   123 123     0             24   246 222   16     0     0       123 123     0       24   246
2757423 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2021   pk_12_total 169 * 10   * 0     0   *   85 97     *             19   182 169   10     0     0       85 97             19   182
2757426 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 193 23 16   0 *     0   *   125 118     *             38   243 193 23 16   0       0       125 118             38   243
2757427 CT     school 900690 230011   Canton School District 90069000118 236111 Canton High School Public Schools Regular School No High 09 12 2021   pk_12_total 390 27 40   * 16     0   *   241 *     *             68   481 390 27 40     16     0       241               68   481
2757430 CT     school 900700 2410014   Capitol Region Education Council 90070001597 2418114 Discovery Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2021   pk_12_total 144 78 244   * 28     0   *   260 262     54             54   522 144 78 244     28     0       260 262     54       54   522
2757431 CT     school 900700 2410014   Capitol Region Education Council 90070000072 2410114 Glastonbury/East Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2021   pk_12_total 80 116 190   * 49     0   *   237 228     53             71   465 80 116 190     49     0       237 228     53       71   465
2757432 CT     school 900700 2410014   Capitol Region Education Council 90070001511 2410414 International Magnet School for Global Citizenship Regional Education Service Center Schools Regular School No Elementary PK 05 2021   pk_12_total 49 166 151   * 104     0   *   247 249     34             61   496 49 166 151     104     0       247 249     34       61   496
2757433 CT     school 900700 2410014   Capitol Region Education Council 90070000210 2413114 Montessori Magnet School Regional Education Service Center Schools Regular School No Elementary PK 06 2021   pk_12_total 73 39 212   0 12     0   22   173 185     53             60   358 73 39 212   0 12     0   22   173 185     53       60   358
2757434 CT     school 900700 2410014   Capitol Region Education Council 90070001601 2410514 Museum Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2021   pk_12_total 80 234 149   * *     0   38   255 266     28             49   521 80 234 149           0   38   255 266     28       49   521
2757435 CT     school 900700 2410014   Capitol Region Education Council 90070001516 2410314 Reggio Magnet School of the Arts Regional Education Service Center Schools Regular School No Elementary PK 05 2021   pk_12_total 137 142 187   * *     0   35   229 283     55             93   512 137 142 187           0   35   229 283     55       93   512
2757436 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2021   pk_12_total 22 9 9   0 *     0   *   37 9     *             46   46 22 9 9   0       0       37 9             46   46
2757437 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2021   pk_12_total * * *   0 0     0   0   * *     0             0   6         0 0     0   0           0       0   6
2757438 CT     school   2410014   Capitol Region Education Council 90070001492 2419114 Soundbridge Program           2021   pk_12_total 12 0 *   0 *     0   0   8 7     0             *   15 12 0     0       0   0   8 7     0           15
2757439 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 2021   pk_12_total 77 221 123   * *     0   33   232 246     20             93   478 77 221 123           0   33   232 246     20       93   478
2757440 CT     school   2410014   Capitol Region Education Council 90070001154 2419014 John J. Allison Polaris Center Program           2021   pk_12_total 9 19 25   0 0     0   0   34 19     *             *   53 9 19 25   0 0     0   0   34 19                 53
2757441 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2021   pk_12_total 50 28 23   0 *     0   *   91 18     0             109   109 50 28 23   0       0       91 18     0       109   109
2757442 CT     school 900700 2410014   Capitol Region Education Council 90070001513 2415114 Academy of Aerospace and Engineering Regional Education Service Center Schools Regular School No High 06 12 2021   pk_12_total 125 253 304   * 68     0   *   479 297     38             130   776 125 253 304     68     0       479 297     38       130   776
2757443 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2021   pk_12_total 160 186 366   * *     0   32   425 *     63             134   778 160 186 366           0   32   425       63       134   778
2757444 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 2021   pk_12_total 66 95 170   0 0     0   18   * 251     25             81   349 66 95 170   0 0     0   18     251     25       81   349
2757446 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 2021   pk_12_total 90 202 339   * *     0   27   360 316     79             138   676 90 202 339           0   27   360 316     79       138   676
2757447 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             9   9   0 0   0 0     0               0       9   9
2757448 CT     school   2410014   Capitol Region Education Council   2411914 CREC Impact Academy Program           2021   pk_12_total * 15 24   0 0     0   *   27 16     *             *   43   15 24   0 0     0       27 16                 43
2757450 CT     school 900700 2410014   Capitol Region Education Council 90070001497 2416414 Greater Hartford Academy of the Arts High School - Full Day Regional Education Service Center Schools Regular School No High 09 12 2021   pk_12_total 95 105 217   0 *     0   *   122 317     15             85   439 95 105 217   0       0       122 317     15       85   439
2757452 CT     school 900720 240011   Chaplin School District 90072000121 240211 Chaplin Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 115 * 7   0 *     0   *   69 61     *             24   130 115   7   0       0       69 61             24   130
2757453 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2021   pk_12_total 118 * 18   0 *     0   11   82 74     *             45   156 118   18   0       0   11   82 74             45   156
2757454 CT     school 900750 250011   Cheshire School District 90075000127 250411 Highland School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 571 20 61   0 75     0   19   370 376     33             70   746 571 20 61   0 75     0   19   370 376     33       70   746
2757455 CT     school 900750 250011   Cheshire School District 90075000122 250111 Chapman School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 269 6 16   0 16     0   13   167 153     *             32   320 269 6 16   0 16     0   13   167 153             32   320
2757456 CT     school   250011   Cheshire School District   250711 Highland School Autism Program Program           2021   pk_12_total 11 * *   0 *     0   0   * *     0             15   15 11       0       0   0           0       15   15
2757457 CT     school 900750 250011   Cheshire School District 90075000129 250511 Norton School Public Schools Regular School No Elementary KG 06 2021   pk_12_total 310 15 21   0 43     0   14   215 188     12             40   403 310 15 21   0 43     0   14   215 188     12       40   403
2757458 CT     school   250011   Cheshire School District   251111 Doolittle Bridges Program Program           2021   pk_12_total * 0 *   0 0     0   0   * 0     0             *   *   0     0 0     0   0     0     0            
2757459 CT     school 900750 250011   Cheshire School District 90075000126 250611 Doolittle School Public Schools Regular School No Elementary 01 06 2021   pk_12_total 316 20 30   0 31     0   32   245 184     12             54   429 316 20 30   0 31     0   32   245 184     12       54   429
2757460 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 481 21 44   * 70     0   *   308 325     6             67   633 481 21 44     70     0       308 325     6       67   633
2757461 CT     school 900750 250011   Cheshire School District 90075000123 256111 Cheshire High School Public Schools Regular School No High 09 12 2021   pk_12_total 1085 41 74   * 146     0   *   * 704     *             178   1368 1085 41 74     146     0         704             178   1368
2757462 CT     school   250011   Cheshire School District 90075001682 250911 Humiston Alternative School Program           2021   pk_12_total 20 * *   0 *     0   0   14 10     0             *   24 20       0       0   0   14 10     0           24
2757463 CT     school   250011   Cheshire School District 90075001766 250311 Cheshire Quinnipiac University Transition Collaborative Program           2021   pk_12_total * 0 0   0 *     0   0   * *     0             *   *   0 0   0       0   0           0            
2757464 CT     school   250011   Cheshire School District   251011 QU College Life Program           2021   pk_12_total 7 0 0   0 0     0   0   * *     0             7   7 7 0 0   0 0     0   0           0       7   7
2757465 CT     school 900810 270011   Clinton School District 90081000132 270311 Lewin G. Joel Jr. School Public Schools Regular School No Elementary PK 04 2021   pk_12_total 366 * 136   0 *     0   12   270 256     65             56   526 366   136   0       0   12   270 256     65       56   526
2757466 CT     school 900810 270011   Clinton School District 90081000133 275111 Jared Eliot School Public Schools Regular School No Middle 05 08 2021   pk_12_total 344 * 103   * 16     0   *   256 217     23             75   473 344   103     16     0       256 217     23       75   473
2757467 CT     school 900810 270011   Clinton School District 90081000134 276111 The Morgan School Public Schools Regular School No High 09 12 2021   pk_12_total 452 * 80   * 20     0   8   300 264     20             75   564 452   80     20     0   8   300 264     20       75   564
2757468 CT     school 900840 280011   Colchester School District 90084001444 280411 Colchester Elementary School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 424 6 37   * *     0   25   262 236     7             92   498 424 6 37           0   25   262 236     7       92   498
2757469 CT     school 900840 280011   Colchester School District 90084000137 280211 Jack Jackter Intermediate School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 373 * 35   * 14     0   17   225 220     *             74   445 373   35     14     0   17   225 220             74   445
2757470 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 415 10 42   0 11     0   23   267 234     *             74   501 415 10 42   0 11     0   23   267 234             74   501
2757471 CT     school 900840 280011   Colchester School District 90084000135 286111 Bacon Academy Public Schools Regular School No High 09 12 2021   pk_12_total 603 * 60   * 20     0   35   375 358     0             98   733 603   60     20     0   35   375 358     0       98   733
2757472 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757473 CT     school   280011   Colchester School District   280711 Community Transition Academy of Colchester Program           2021   pk_12_total * 0 0   0 0     0   0   * *     0             *   *   0 0   0 0     0   0           0            
2757474 CT     school 900900 300011   Columbia School District 90090000139 300111 Horace W. Porter School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 346 6 27   * *     0   18   222 178     *             42   400 346 6 27           0   18   222 178             42   400
2757476 CT     school   2430014   Cooperative Educational Services 90091001520 2438014 School Readiness Program           2021   pk_12_total * 24 24   0 *     0   *   22 30     0             *   52   24 24   0       0       22 30     0           52
2757477 CT     school 900910 2430014   Cooperative Educational Services 90091000340 2430114 Six-Six Magnet School Regional Education Service Center Schools Regular School No Elementary PK 08 2021   pk_12_total 108 107 189   * 25     0   *   229 220     31             39   449 108 107 189     25     0       229 220     31       39   449
2757478 CT     school   2430014   Cooperative Educational Services   2430314 Eastern Fairfield County Diagnostic Center Program           2021   pk_12_total 0 * 0   * 0     0   0   * 0     0             0   * 0   0     0     0   0     0     0       0    
2757479 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2021   pk_12_total 66 21 36   * *     0   11   112 24     *             136   136 66 21 36           0   11   112 24             136   136
2757480 CT     school   2430014   Cooperative Educational Services 90091001554 2439214 Developmental Learning Center (DLC) Program           2021   pk_12_total * 14 18   0 0     0   *   34 16     *             50   50   14 18   0 0     0       34 16             50   50
2757482 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2021   pk_12_total 16 8 *   0 *     0   *   * *     *             32   32 16 8     0       0                       32   32
2757483 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 83 * 12   0 7     0   *   51 53     *             11   104 83   12   0 7     0       51 53             11   104
2757484 CT     school   320011   Coventry School District   320311 Hale Early Education Center Program           2021   pk_12_total 72 0 *   0 0     0   *   43 37     0             14   80 72 0     0 0     0       43 37     0       14   80
2757485 CT     school 900960 320011   Coventry School District 90096000142 320211 Coventry Grammar School Public Schools Regular School No Elementary KG 02 2021   pk_12_total 293 * 16   0 *     0   15   148 180     6             27   328 293   16   0       0   15   148 180     6       27   328
2757486 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 308 * 40   * 6     0   17   201 175     7             53   376 308   40     6     0   17   201 175     7       53   376
2757487 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2021   pk_12_total 344 * 24   0 *     0   9   200 187     *             62   387 344   24   0       0   9   200 187             62   387
2757488 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2021   pk_12_total 363 * 33   * *     0   16   * 229     0             57   419 363   33           0   16     229     0       57   419
2757489 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2021   pk_12_total 9 0 *   0 0     0   *   12 0     0             *   12 9 0     0 0     0       12 0     0           12
2757490 CT     school 900990 330011   Cromwell School District 90099000146 330211 Edna C. Stevens School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 318 30 85   0 26     0   32   256 235     55             61   491 318 30 85   0 26     0   32   256 235     55       61   491
2757493 CT     school 900990 330011   Cromwell School District 90099000145 336111 Cromwell High School Public Schools Regular School No High 09 12 2021   pk_12_total 397 50 50   0 44     0   11   297 255     10             56   552 397 50 50   0 44     0   11   297 255     10       56   552
2757494 CT     school 901020 340011   Danbury School District 90102001634 340111 DPS Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 31 12 80   0 *     0   *   80 54     0             97   134 31 12 80   0       0       80 54     0       97   134
2757495 CT     school 901020 340011   Danbury School District 90102000151 341111 Great Plain School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 114 * 124   0 30     0   *   152 132     72             56   284 114   124   0 30     0       152 132     72       56   284
2757496 CT     school 901020 340011   Danbury School District 90102000152 340211 Hayestown Avenue School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 117 30 249   * 54     0   *   241 220     157             97   461 117 30 249     54     0       241 220     157       97   461
2757497 CT     school 901020 340011   Danbury School District 90102000159 341411 Ellsworth Avenue School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 104 13 337   * 14     0   *   250 229     255             44   479 104 13 337     14     0       250 229     255       44   479
2757498 CT     school 901020 340011   Danbury School District 90102000153 341311 King Street Primary School Public Schools Regular School No Elementary KG 03 2021   pk_12_total 125 17 222   0 15     0   9   237 151     142             38   388 125 17 222   0 15     0   9   237 151     142       38   388
2757499 CT     school 901020 340011   Danbury School District 90102000154 340511 Mill Ridge Primary School Public Schools Regular School No Elementary KG 03 2021   pk_12_total 120 47 150   0 25     0   13   186 169     79             36   355 120 47 150   0 25     0   13   186 169     79       36   355
2757500 CT     school 901020 340011   Danbury School District 90102000156 340611 Morris Street School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 56 14 268   * *     0   12   173 189     210             33   362 56 14 268           0   12   173 189     210       33   362
2757502 CT     school 901020 340011   Danbury School District 90102000158 341511 Pembroke School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 103 28 162   0 36     0   12   215 126     102             106   341 103 28 162   0 36     0   12   215 126     102       106   341
2757504 CT     school 901020 340011   Danbury School District 90102000162 341011 South Street School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 106 31 238   0 20     0   6   197 204     202             48   401 106 31 238   0 20     0   6   197 204     202       48   401
2757505 CT     school 901020 340011   Danbury School District 90102000163 341611 Stadley Rough School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 173 36 241   * 21     0   *   223 264     200             35   487 173 36 241     21     0       223 264     200       35   487
2757506 CT     school 901020 340011   Danbury School District 90102001438 341911 Western CT Academy of International Studies Elementary Magnet School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 157 32 118   0 29     0   10   187 159     55             29   346 157 32 118   0 29     0   10   187 159     55       29   346
2757507 CT     school 901020 340011   Danbury School District 90102001166 341711 King Street Intermediate School Public Schools Regular School No Elementary 04 05 2021   pk_12_total 155 37 183   0 *     0   *   209 186     104             51   395 155 37 183   0       0       209 186     104       51   395
2757508 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 312 82 534   * 59     0   *   541 482     177             165   1023 312 82 534     59     0       541 482     177       165   1023
2757510 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2021   pk_12_total 321 49 308   0 53     0   13   * 374     72             44   744 321 49 308   0 53     0   13     374     72       44   744
2757511 CT     school   340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program           2021   pk_12_total 27 8 35   0 *     0   *   45 35     *             21   80 27 8 35   0       0       45 35             21   80
2757513 CT     school   340011   Danbury School District   340711 Western Connection Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             11   11   0     0 0     0   0           0       11   11
2757514 CT     school 901050 350011   Darien School District 90105000170 351311 Ox Ridge Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 357 0 34   0 27     0   27   217 228     *             67   445 357 0 34   0 27     0   27   217 228             67   445
2757515 CT     school 901050 350011   Darien School District 90105000171 350511 Royle Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 333 8 22   0 11     0   13   221 166     8             79   387 333 8 22   0 11     0   13   221 166     8       79   387
2757516 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 364 * 21   0 25     0   *   225 209     13             72   434 364   21   0 25     0       225 209     13       72   434
2757517 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 355 * 23   * 26     0   20   232 197     8             55   429 355   23     26     0   20   232 197     8       55   429
2757518 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 347 0 32   0 28     0   26   223 210     8             53   433 347 0 32   0 28     0   26   223 210     8       53   433
2757519 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 956 * 74   * 61     0   37   581 562     8             182   1143 956   74     61     0   37   581 562     8       182   1143
2757520 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2021   pk_12_total 1182 * 87   * 78     0   17   714 668     *             265   1382 1182   87     78     0   17   714 668             265   1382
2757521 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   pk_12_total 18 * 16   0 *     0   *   25 18     0             18   43 18   16   0       0       25 18     0       18   43
2757523 CT     school 901110 370011   Derby School District 90111000178 370411 Irving School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 72 49 129   0 *     0   *   150 122     10             62   272 72 49 129   0       0       150 122     10       62   272
2757524 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 113 64 115   0 8     0   22   178 144     6             66   322 113 64 115   0 8     0   22   178 144     6       66   322
2757525 CT     school   370011   Derby School District   370511 RAISE Academy Program           2021   pk_12_total 7 6 *   0 0     0   *   * *     0             12   22 7 6     0 0     0               0       12   22
2757527 CT     school 901170 400011   East Granby School District 90117000180 400111 Allgrove School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 138 11 *   0 *     0   11   94 81     *             23   175 138 11     0       0   11   94 81             23   175
2757528 CT     school 901170 400011   East Granby School District 90117000183 400211 R. Dudley Seymour School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 136 14 12   * 12     0   *   108 75     *             27   183 136 14 12     12     0       108 75             27   183
2757529 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 146 * 20   0 20     0   *   102 107     *             28   209 146   20   0 20     0       102 107             28   209
2757530 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2021   pk_12_total 187 29 19   0 15     0   9   137 122     *             40   259 187 29 19   0 15     0   9   137 122             40   259
2757531 CT     school 901200 410011   East Haddam School District 90120000184 410111 East Haddam Elementary School Public Schools Regular School No Elementary PK 03 2021   pk_12_total 264 * 10   0 *     0   7   161 126     *             41   287 264   10   0       0   7   161 126             41   287
2757532 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2021   pk_12_total 313 * 21   * *     0   8   176 173     *             53   349 313   21           0   8   176 173             53   349
2757533 CT     school 901200 410011   East Haddam School District 90120000185 416111 Nathan Hale-Ray High School Public Schools Regular School No High 09 12 2021   pk_12_total 276 * 6   0 8     0   *   162 132     0             32   294 276   6   0 8     0       162 132     0       32   294

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