Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by native_american_alaskan_native_int

View and edit SQL

grade

year

  • 2020 · 20,254
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
2778244 CT     school 902070 690011   Killingly School District 90207000394 690311 Killingly Memorial School Public Schools Regular School No Elementary 02 04 2020   pk_12_total 422 6 52   * 7     *   35   261 266     23             79   527 422 6 52     7         35   261 266     23       79   527
2778245 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 08 2020   pk_12_total 510 17 70   * 22     *   26   310 338     14             99   648 510 17 70     22         26   310 338     14       99   648
2778248 CT     school 903450 2450014   Learn 90345001627 2450314 Riverside Magnet School at Goodwin University Regional Education Service Center Schools Regular School No Elementary PK 05 2020   pk_12_total 105 133 194   * 11     *   30   236 240     84             65   476 105 133 194     11         30   236 240     84       65   476
2778251 CT     school 903450 2450014   Learn 90345000079 2450114 Regional Multicultural Magnet School Regional Education Service Center Schools Regular School No Elementary KG 05 2020   pk_12_total 136 70 210   * 7     *   78   243 262     60             75   505 136 70 210     7         78   243 262     60       75   505
2778256 CT     school 903450 2450014   Learn 90345001581 2456014 Connecticut River Academy at Goodwin University Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 78 99 270   * 17     *   15   226 255     39             81   481 78 99 270     17         15   226 255     39       81   481
2778257 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2020   pk_12_total 200 * 35   * 11     0   17   135 137     *             26   272 200   35     11     0   17   135 137             26   272
2778258 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2020   pk_12_total 45 * 14   * *     0   *   18 49     *             *   67 45   14           0       18 49                 67
2778261 CT     school 902130 710011   Lebanon School District 90213000395 710111 Lebanon Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 325 * 29   * *     *   *   206 165     7             59   371 325   29                   206 165     7       59   371
2778262 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 262 6 12   * *     *   *   159 137     *             51   296 262 6 12                   159 137             51   296
2778265 CT     school 902160 720011   Ledyard School District 90216000397 720211 Gales Ferry School Public Schools Regular School No Elementary KG 02 2020   pk_12_total 187 9 26   * 22     *   11   136 122     *             39   258 187 9 26     22         11   136 122             39   258
2778268 CT     school 902160 720011   Ledyard School District 90216000401 726111 Ledyard High School Public Schools Regular School No High 09 12 2020   pk_12_total 528 58 93   * 29     *   24   * 392     11             140   754 528 58 93     29         24     392     11       140   754
2778279 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 499 * 31   * 18     *   34   318 *     *             89   588 499   31     18         34   318               89   588
2778280 CT     school 902280 760011   Madison School District 90228000411 766111 Daniel Hand High School Public Schools Regular School No High 09 12 2020   pk_12_total 885 * 45   * 41     0   34   542 *     *             118   1014 885   45     41     0   34   542               118   1014
2778281 CT     school 902310 770011   Manchester School District 90231000418 770311 Buckley School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 146 88 91   * 45     0   *   210 163     22             61   373 146 88 91     45     0       210 163     22       61   373
2778286 CT     school 902310 770011   Manchester School District 90231000420 770411 Highland Park School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 141 75 77   * 17     0   *   156 160     18             34   316 141 75 77     17     0       156 160     18       34   316
2778288 CT     school 902310 770011   Manchester School District 90231000429 771211 Verplanck School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 107 139 187   * 31     0   *   264 214     57             61   478 107 139 187     31     0       264 214     57       61   478
2778290 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2020   pk_12_total 290 231 302   * 64     *   15   465 442     71             157   907 290 231 302     64         15   465 442     71       157   907
2778292 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 272 203 257   * 68     *   35   426 411     60             125   837 272 203 257     68         35   426 411     60       125   837
2778294 CT     school 902310 770011   Manchester School District 90231000424 776111 Manchester High School Public Schools Regular School No High 09 12 2020   pk_12_total 546 403 443   * 127     *   66   800 797     96             200   1597 546 403 443     127         66   800 797     96       200   1597
2778296 CT     school   770011   Manchester School District 90231001717 770711 New Horizons Program           2020   pk_12_total * 10 8   * 0     0   0   * *     0             8   24   10 8     0     0   0           0       8   24
2778300 CT     school 902340 780011   Mansfield School District 90234000435 780511 Southeast Elementary School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 111 6 24   * 17     0   *   78 83     8             25   161 111 6 24     17     0       78 83     8       25   161
2778301 CT     school 902340 780011   Mansfield School District 90234000433 785111 Mansfield Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 375 * 66   * 69     0   26   267 285     11             66   552 375   66     69     0   26   267 285     11       66   552
2778302 CT     school 902370 790011   Marlborough School District 90237000437 790111 Elmer Thienes-Mary Hall Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 388 * 28   * 8     0   15   226 222     6             52   448 388   28     8     0   15   226 222     6       52   448
2778307 CT     school 902400 800011   Meriden School District 90240000450 800811 Roger Sherman School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 94 35 300   * 8     *   35   236 239     92             86   475 94 35 300     8         35   236 239     92       86   475
2778310 CT     school 902400 800011   Meriden School District 90240000440 801111 Casimir Pulaski School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 109 59 403   * *     0   29   314 296     136             90   610 109 59 403           0   29   314 296     136       90   610
2778315 CT     school 902400 800011   Meriden School District 90240000447 805211 Lincoln Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 204 94 460   * *     0   25   411 388     131             136   799 204 94 460           0   25   411 388     131       136   799
2778320 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 266 84 395   * 14     *   24   403 384     66             139   787 266 84 395     14         24   403 384     66       139   787
2778323 CT     school 902400 800011   Meriden School District 90240000449 806211 Orville H. Platt High School Public Schools Regular School No High 09 12 2020   pk_12_total 227 122 578   * *     0   28   488 492     124             165   980 227 122 578           0   28   488 492     124       165   980
2778328 CT     school   800011   Meriden School District   801711 TSC - PHS Program           2020   pk_12_total * * 16   * 0     0   0   * *     *             22   22     16     0     0   0                   22   22
2778332 CT     school   800011   Meriden School District   802111 Community Collaborative Classroom - ACADEMY Program           2020   pk_12_total 6 * *   * 0     0   0   * *     *             14   14 6         0     0   0                   14   14
2778335 CT     school 902490 830011   Middletown School District 90249000455 830511 Farm Hill School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 129 50 80   * *     0   38   149 160     18             28   309 129 50 80           0   38   149 160     18       28   309
2778337 CT     school 902490 830011   Middletown School District 90249000458 830911 MacDonough School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 78 40 60   * 13     *   28   116 106     28             21   222 78 40 60     13         28   116 106     28       21   222
2778339 CT     school 902490 830011   Middletown School District 90249000462 830111 Spencer School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 133 39 73   * 7     *   28   146 137     18             32   283 133 39 73     7         28   146 137     18       32   283
2778346 CT     school 902490 830011   Middletown School District 90249000456 831511 Keigwin Middle School Public Schools Regular School No Middle 06 06 2020   pk_12_total 159 51 62   * 14     *   28   152 164     14             38   316 159 51 62     14         28   152 164     14       38   316
2778347 CT     school 902490 830011   Middletown School District 90249000459 835411 Woodrow Wilson Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 274 149 126   * 19     *   47   313 305     15             78   618 274 149 126     19         47   313 305     15       78   618
2778349 CT     school 902490 830011   Middletown School District 90249000465 836211 Middletown High School Public Schools Regular School No High 09 12 2020   pk_12_total 652 277 211   * 64     *   75   616 667     27             148   1283 652 277 211     64         75   616 667     27       148   1283
2778354 CT     school   830011   Middletown School District 90249001598 839111 Middletown Transition Center Program           2020   pk_12_total 10 * *   * 0     0   *   11 7     0             18   18 10         0     0       11 7     0       18   18
2778356 CT     school 902520 840011   Milford School District 90252000476 841611 Live Oaks School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 219 * 33   * 32     0   19   172 143     12             68   315 219   33     32     0   19   172 143     12       68   315
2778364 CT     school 902520 840011   Milford School District 90252000468 845211 Harborside Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 305 12 51   * 44     0   *   243 181     7             59   424 305 12 51     44     0       243 181     7       59   424
2778365 CT     school 902520 840011   Milford School District 90252000474 845311 West Shore Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 295 31 77   * 60     *   *   241 230     9             74   471 295 31 77     60             241 230     9       74   471
2778366 CT     school 902520 840011   Milford School District 90252000472 846211 Jonathan Law High School Public Schools Regular School No High 09 12 2020   pk_12_total 608 41 86   * 66     *   9   419 397     14             107   816 608 41 86     66         9   419 397     14       107   816
2778372 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 431 * 73   * 33     0   23   284 286     7             62   570 431   73     33     0   23   284 286     7       62   570
2778375 CT     school 902550 850011   Monroe School District 90255000489 856111 Masuk High School Public Schools Regular School No High 09 12 2020   pk_12_total 798 * 102   * 48     0   29   492 505     9             116   997 798   102     48     0   29   492 505     9       116   997
2778378 CT     school 902580 860011   Montville School District 90258000494 860111 Mohegan School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 152 11 61   * 54     *   42   176 152     48             58   328 152 11 61     54         42   176 152     48       58   328
2778381 CT     school 902580 860011   Montville School District 90258000035 865111 Leonard J. Tyl Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 343 14 71   * 33     *   61   276 *     15             99   531 343 14 71     33         61   276       15       99   531
2778382 CT     school 902580 860011   Montville School District 90258000495 866111 Montville High School Public Schools Regular School No High 09 12 2020   pk_12_total 335 * 70   * 56     0   59   * 282     15             64   541 335   70     56     0   59     282     15       64   541
2778389 CT     school 902640 880011   Naugatuck School District 90264001223 880311 Maple Hill School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 292 25 143   * *     0   22   263 233     24             89   496 292 25 143           0   22   263 233     24       89   496
2778391 CT     school 902640 880011   Naugatuck School District 90264000508 880711 Western School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 125 25 81   * *     0   18   126 127     19             25   253 125 25 81           0   18   126 127     19       25   253
2778392 CT     school 902640 880011   Naugatuck School District 90264000502 880211 Cross Street Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 184 31 78   * 19     0   *   162 164     13             62   326 184 31 78     19     0       162 164     13       62   326
2778393 CT     school 902640 880011   Naugatuck School District 90264000504 880411 Hillside Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 157 32 116   * *     0   25   178 158     29             59   336 157 32 116           0   25   178 158     29       59   336
2778394 CT     school 902640 880011   Naugatuck School District 90264000501 885111 City Hill Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 390 56 187   * 13     *   33   373 314     36             135   687 390 56 187     13         33   373 314     36       135   687
2778398 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 2020   pk_12_total 21 298 175   * *     *   6   246 259     9             47   505 21 298 175               6   246 259     9       47   505
2778404 CT     school 902670 890011   New Britain School District 90267000509 890311 Chamberlain Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 54 50 313   * *     0   17   230 212     53             78   442 54 50 313           0   17   230 212     53       78   442
2778406 CT     school 902670 890011   New Britain School District 90267000515 890811 Lincoln Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 95 65 428   * *     0   26   318 302     111             120   620 95 65 428           0   26   318 302     111       120   620
2778408 CT     school 902670 890011   New Britain School District 90267000523 891211 Smalley Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 70 47 469   * *     0   20   311 299     177             104   610 70 47 469           0   20   311 299     177       104   610
2778409 CT     school 902670 890011   New Britain School District 90267000524 891311 Smith Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 70 60 354   * *     0   16   263 251     90             72   514 70 60 354           0   16   263 251     90       72   514
2778417 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 158 83 613   * 23     0   *   500 401     184             194   901 158 83 613     23     0       500 401     184       194   901
2778419 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 118 108 588   * *     0   22   450 404     130             177   854 118 108 588           0   22   450 404     130       177   854
2778421 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2020   pk_12_total 407 317 1375   * 68     *   48   1170 1051     421             513   2221 407 317 1375     68         48   1170 1051     421       513   2221
2778426 CT     school 902700 900011   New Canaan School District 90270000533 900211 South School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 423 * 34   * 46     0   30   282 256     14             66   538 423   34     46     0   30   282 256     14       66   538
2778427 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 1079 18 68   * 110     *   43   682 642     8             159   1324 1079 18 68     110         43   682 642     8       159   1324
2778428 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2020   pk_12_total 1120 * 62   * 79     0   38   678 646     *             170   1324 1120   62     79     0   38   678 646             170   1324
2778431 CT     school 902730 910011   New Fairfield School District 90273001195 910211 Meeting House Hill School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 338 7 77   * *     0   14   221 221     28             79   442 338 7 77           0   14   221 221     28       79   442
2778432 CT     school 902730 910011   New Fairfield School District 90273001224 915211 New Fairfield Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 446 9 63   * *     0   10   277 260     7             59   537 446 9 63           0   10   277 260     7       59   537
2778433 CT     school 902730 910011   New Fairfield School District 90273000537 916111 New Fairfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 581 10 81   * 17     0   *   342 356     6             93   698 581 10 81     17     0       342 356     6       93   698
2778438 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 25 240 158   * *     0   10   228 209     45             57   437 25 240 158           0   10   228 209     45       57   437
2778440 CT     school 902790 930011   New Haven School District 90279000543 930311 Beecher School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 64 274 133   * *     0   13   249 244     25             51   493 64 274 133           0   13   249 244     25       51   493
2778442 CT     school 902790 930011   New Haven School District 90279000544 931811 Benjamin Jepson Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 91 127 263   * *     *   22   249 260     46             62   509 91 127 263               22   249 260     46       62   509
2778443 CT     school 902790 930011   New Haven School District 90279001585 932111 Brennan Rogers School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 27 245 132   * *     *   7   204 212     26             74   416 27 245 132               7   204 212     26       74   416
2778447 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 59 248 353   * 7     *   21   350 343     73             77   693 59 248 353     7         21   350 343     73       77   693
2778448 CT     school 902790 930011   New Haven School District 90279000551 930911 Davis Academy for Arts & Design Innovation Public Schools Regular School No Elementary PK 08 2020   pk_12_total 99 295 95   * *     0   14   261 253     6             51   514 99 295 95           0   14   261 253     6       51   514
2778449 CT     school   930011   New Haven School District   932711 Dr. Reginald Mayo Early Learning Center Program           2020   pk_12_total 20 191 92   * *     0   14   189 136     0             77   325 20 191 92           0   14   189 136     0       77   325
2778450 CT     school 902790 930011   New Haven School District 90279000552 934611 East Rock Community Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 62 170 189   * 26     *   7   218 239     80             76   457 62 170 189     26         7   218 239     80       76   457
2778458 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 90 273 151   * *     0   14   281 257     51             72   538 90 273 151           0   14   281 257     51       72   538
2778459 CT     school 902790 930011   New Haven School District 90279000568 931411 Nathan Hale School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 217 69 230   * *     0   11   269 266     48             76   535 217 69 230           0   11   269 266     48       76   535
2778464 CT     school 902790 930011   New Haven School District 90279000553 931211 Edgewood School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 127 213 72   * *     0   23   205 238     28             45   443 127 213 72           0   23   205 238     28       45   443
2778482 CT     school 902790 930011   New Haven School District 90279000545 935511 Betsy Ross Arts Magnet School Public Schools Regular School No Middle 05 08 2020   pk_12_total 73 194 158   * *     0   12   151 293     28             45   444 73 194 158           0   12   151 293     28       45   444
2778484 CT     school 902790 930011   New Haven School District 90279001207 936411 Cooperative High School - Inter-District Magnet Public Schools Regular School No High 09 12 2020   pk_12_total 89 257 220   * *     0   8   188 393     23             78   581 89 257 220           0   8   188 393     23       78   581
2778485 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2020   pk_12_total 24 103 128   * *     0   *   131 134     40             53   265 24 103 128           0       131 134     40       53   265
2778486 CT     school 902790 930011   New Haven School District 90279000556 936311 Hill Regional Career High School Public Schools Regular School No High 09 12 2020   pk_12_total 46 241 308   * 27     0   *   252 380     68             56   632 46 241 308     27     0       252 380     68       56   632
2778487 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2020   pk_12_total 47 604 394   * 12     *   14   568 506     190             224   1074 47 604 394     12         14   568 506     190       224   1074
2778488 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2020   pk_12_total 34 148 204   * 6     0   *   213 184     40             45   397 34 148 204     6     0       213 184     40       45   397
2778489 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2020   pk_12_total 29 186 73   * *     0   *   142 154     *             63   296 29 186 73           0       142 154             63   296
2778491 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2020   pk_12_total 159 43 130   * *     0   *   186 149     15             85   335 159 43 130           0       186 149     15       85   335
2778492 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2020   pk_12_total 173 410 936   * 28     0   *   781 772     316             259   1553 173 410 936     28     0       781 772     316       259   1553
2778497 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2020   pk_12_total 35 53 358   * *     0   28   242 235     217             51   477 35 53 358           0   28   242 235     217       51   477
2778498 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 39 46 164   * *     0   21   149 131     57             50   280 39 46 164           0   21   149 131     57       50   280
2778500 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 122 79 235   * 6     *   92   226 310     61             82   536 122 79 235     6         92   226 310     61       82   536
2778501 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 136 87 192   * 8     *   77   275 230     59             72   505 136 87 192     8         77   275 230     59       72   505
2778502 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 19 43 189   * *     0   11   138 128     103             43   266 19 43 189           0   11   138 128     103       43   266
2778503 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Middle 06 10 2020   pk_12_total 48 40 82   * *     0   29   91 113     26             47   204 48 40 82           0   29   91 113     26       47   204
2778504 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2020   pk_12_total 132 117 194   * 12     *   87   307 241     44             73   548 132 117 194     12         87   307 241     44       73   548
2778505 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2020   pk_12_total 36 128 352   * *     *   43   317 251     169             141   568 36 128 352               43   317 251     169       141   568
2778509 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 668 * 164   * 30     0   52   490 449     35             154   939 668   164     30     0   52   490 449     35       154   939
2778513 CT     school 902880 940011   Newington School District 90288000604 940211 Elizabeth Green School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 142 17 85   * 26     0   *   163 121     39             52   284 142 17 85     26     0       163 121     39       52   284
2778515 CT     school 902880 940011   Newington School District 90288000612 940711 Ruth Chaffee School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 179 * 65   * 35     0   24   157 167     30             53   324 179   65     35     0   24   157 167     30       53   324
2778517 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 334 35 174   * 49     0   *   296 333     27             85   629 334 35 174     49     0       296 333     27       85   629
2778518 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2020   pk_12_total 786 80 255   * 114     *   64   694 607     19             150   1301 786 80 255     114         64   694 607     19       150   1301
2778522 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 296 6 44   * *     0   *   188 168     *             46   356 296 6 44           0       188 168             46   356
2778524 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 474 * 38   * 20     0   16   283 277     *             78   560 474   38     20     0   16   283 277             78   560

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