Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2020 · 20,354
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
2778063 CT     school 901500 500011   Essex School District 90150000255 500111 Essex Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 280 * 25   0 *     0   17   172 158     8             60   330 280   25   0       0   17   172 158     8       60   330
2778064 CT     school   510011   Fairfield School District   510811 Early Childhood Center(0510811) Program           2020   pk_12_total 46 * 14   0 *     0   *   41 27     0             41   68 46   14   0       0       41 27     0       41   68
2778066 CT     school 901530 510011   Fairfield School District 90153000269 511311 Sherman School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 370 * 25   0 *     0   18   206 217     *             53   423 370   25   0       0   18   206 217             53   423
2778075 CT     school 901530 510011   Fairfield School District 90153000267 511211 Riverfield School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 341 * 26   0 *     0   20   223 183     *             51   406 341   26   0       0   20   223 183             51   406
2778083 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2020   pk_12_total 16 * *   0 *     0   0   13 7     0             20   20 16       0       0   0   13 7     0       20   20
2778092 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2020   pk_12_total * * *   0 *     0   0   * *     *             *   7         0       0   0                       7
2778093 CT     school 901590 530011   Franklin School District 90159000278 530111 Franklin Elementary School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 134 * 12   * *     0   7   86 *     *             7   159 134   12           0   7   86               7   159
2778094 CT     school   540011   Glastonbury School District 90162001724 540511 PreK-Eastbury Program           2020   pk_12_total 44 * 8   0 *     0   0   38 18     0             38   56 44   8   0       0   0   38 18     0       38   56
2778104 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2020   pk_12_total 7 * *   0 *     0   0   * *     0             12   12 7       0       0   0           0       12   12
2778106 CT     school 901680 560011   Granby School District 90168000293 560311 Wells Road Intermediate School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 321 21 18   * *     0   11   176 205     0             64   381 321 21 18           0   11   176 205     0       64   381
2778107 CT     school 901680 560011   Granby School District 90168000291 565111 Granby Memorial Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 353 25 14   * *     0   12   207 208     0             64   415 353 25 14           0   12   207 208     0       64   415
2778108 CT     school 901680 560011   Granby School District 90168000289 566111 Granby Memorial High School Public Schools Regular School No High 09 12 2020   pk_12_total 511 25 19   * *     *   26   311 278     *             70   589 511 25 19               26   311 278             70   589
2778109 CT     school 901710 570011   Greenwich School District 90171000301 570511 Hamilton Avenue School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 98 29 197   * *     0   21   191 176     24             54   367 98 29 197           0   21   191 176     24       54   367
2778115 CT     school 901710 570011   Greenwich School District 90171000299 570411 Glenville School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 272 * 62   0 *     0   33   216 188     14             35   404 272   62   0       0   33   216 188     14       35   404
2778125 CT     school   570011   Greenwich School District 90171001664 571211 Community Connections Program           2020   pk_12_total 10 * *   0 *     0   0   12 6     0             *   18 10       0       0   0   12 6     0           18
2778127 CT     school 901740 580011   Griswold School District 90174000019 585111 Griswold Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 431 15 54   * *     0   47   287 272     8             89   559 431 15 54           0   47   287 272     8       89   559
2778133 CT     school 901770 590011   Groton School District 90177000325 590111 S. B. Butler School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 204 15 44   * *     0   34   181 128     7             85   309 204 15 44           0   34   181 128     7       85   309
2778144 CT     school 901800 600011   Guilford School District 90180000330 600411 Calvin Leete School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 216 * 14   0 *     0   11   135 115     15             22   250 216   14   0       0   11   135 115     15       22   250
2778153 CT     school   620011   Hamden School District   620711 Alice Peck IIC Program           2020   pk_12_total * 12 8   0 *     0   *   24 7     0             31   31   12 8   0       0       24 7     0       31   31
2778155 CT     school   620011   Hamden School District   621711 Ridge Hill IIC Program           2020   pk_12_total 0 7 *   0 *     0   0   * *     0             15   15 0 7     0       0   0           0       15   15
2778158 CT     school 901860 620011   Hamden School District 90186000348 621011 Spring Glen School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 264 50 55   0 *     *   25   193 213     22             37   406 264 50 55   0           25   193 213     22       37   406
2778160 CT     school   620011   Hamden School District   621611 Helen Street IIC Program           2020   pk_12_total 0 8 6   0 *     0   *   * *     *             16   16 0 8 6   0       0                       16   16
2778163 CT     school   620011   Hamden School District   621311 Church Street IIC Program           2020   pk_12_total * 6 7   0 *     0   0   10 6     *             16   16   6 7   0       0   0   10 6             16   16
2778164 CT     school   620011   Hamden School District   621511 Dunbar Hill IIC Program           2020   pk_12_total * 7 *   0 *     0   *   * *     *             16   16   7     0       0                       16   16
2778165 CT     school   620011   Hamden School District   620911 Bear Path IIC Program           2020   pk_12_total * 15 *   0 *     0   *   17 6     0             23   23   15     0       0       17 6     0       23   23
2778167 CT     school   620011   Hamden School District 90186001741 620511 Hamden Collaborative Learning Center Program           2020   pk_12_total 14 20 15   0 *     0   *   32 20     *             32   52 14 20 15   0       0       32 20             32   52
2778169 CT     school   620011   Hamden School District   620611 Hamden Transition Academy @ SCSU (AACPB) Program           2020   pk_12_total * 7 0   0 *     0   0   * *     *             10   10   7 0   0       0   0                   10   10
2778177 CT     school   640011   Hartford School District 90192001723 644111 Early Childhood Development Center (ECDC) Program           2020   pk_12_total * 8 8   0 *     0   *   * *     0             19   19   8 8   0       0               0       19   19
2778179 CT     school 901920 640011   Hartford School District 90192000636 643211 Expeditionary Learning Academy at Moylan School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 20 57 422   * *     *   6   256 254     156             105   510 20 57 422               6   256 254     156       105   510
2778182 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2020   pk_12_total 136 166 346   * *     0   30   275 436     69             137   711 136 166 346           0   30   275 436     69       137   711
2778184 CT     school 901920 640011   Hartford School District 90192001641 640511 Montessori Magnet at Batchelder School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 88 50 205   * *     0   11   * 191     76             45   367 88 50 205           0   11     191     76       45   367
2778186 CT     school 901920 640011   Hartford School District 90192000373 641511 Parkville Community School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 35 29 357   * *     *   *   232 200     204             70   432 35 29 357                   232 200     204       70   432
2778188 CT     school   640011   Hartford School District   640510 Pre-K Integrated - Naylor School Program           2020   pk_12_total * 8 29   0 *     0   0   23 18     0             22   41   8 29   0       0   0   23 18     0       22   41
2778190 CT     school   640011   Hartford School District   640610 Pre-K Integrated - West Middle School Program           2020   pk_12_total * 7 7   0 *     0   0   10 8     0             10   18   7 7   0       0   0   10 8     0       10   18
2778191 CT     school 901920 640011   Hartford School District 90192000376 641711 Rawson School Public Schools Regular School No Elementary PK 05 2020   pk_12_total * 234 80   * *     *   9   170 162     44             57   332   234 80               9   170 162     44       57   332
2778192 CT     school 901920 640011   Hartford School District 90192000377 640111 SAND School Public Schools Regular School No Elementary PK 05 2020   pk_12_total * 88 234   * *     0   *   180 153     91             58   333   88 234           0       180 153     91       58   333
2778196 CT     school 901920 640011   Hartford School District 90192000385 642211 Wish Museum School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 6 129 189   0 *     0   *   174 158     102             87   332 6 129 189   0       0       174 158     102       87   332
2778201 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Other KG 12 2020   pk_12_total * 326 238   0 *     0   11   275 308     87             104   583   326 238   0       0   11   275 308     87       104   583
2778205 CT     school   640011   Hartford School District   644711 iGOAL 1 - Burns School Program           2020   pk_12_total 0 * 26   0 *     0   0   24 8     10             32   32 0   26   0       0   0   24 8     10       32   32
2778215 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2020   pk_12_total 52 184 172   0 *     *   10   * 237     40             75   429 52 184 172   0           10     237     40       75   429
2778217 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total * 121 42   0 *     0   *   97 72     17             45   169   121 42   0       0       97 72     17       45   169
2778231 CT     school   640011   Hartford School District 90192000382 646311 Weaver High School Public Schools           2020   pk_12_total * 229 178   * *     0   6   * 215     53             103   423   229 178           0   6     215     53       103   423
2778237 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2020   pk_12_total 311 * 15   0 *     0   7   177 164     *             50   341 311   15   0       0   7   177 164             50   341
2778240 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2020   pk_12_total * 650 39   * *     0   8   * 367     6             42   706   650 39           0   8     367     6       42   706
2778241 CT     school 902040 680011   Kent School District 90204000389 680111 Kent Center School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 173 * 15   0 *     0   7   103 102     *             21   205 173   15   0       0   7   103 102             21   205
2778242 CT     school   690011   Killingly School District 90207000083 698011 Goodyear Early Childhood Center Program           2020   pk_12_total 93 0 11   0 *     0   *   68 49     0             36   117 93 0 11   0       0       68 49     0       36   117
2778249 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2020   pk_12_total 184 54 192   0 *     *   55   263 240     23             51   503 184 54 192   0           55   263 240     23       51   503
2778250 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2020   pk_12_total 12 7 9   0 *     0   *   27 8     *             35   35 12 7 9   0       0       27 8             35   35
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
2778260 CT     school   2450014   Learn 90345001795 2450614 Learn High School Program           2020   pk_12_total * 0 *   0 *     0   0   * *     0             *   *   0     0       0   0           0            
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
2778264 CT     school 902160 720011   Ledyard School District 90216000398 720411 Gallup Hill School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 430 14 66   31 *     *   29   319 267     9             111   586 430 14 66   31           29   319 267     9       111   586
2778266 CT     school 902160 720011   Ledyard School District 90216000399 720311 Juliet W. Long School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 212 12 22   0 *     *   8   134 129     6             43   263 212 12 22   0           8   134 129     6       43   263
2778267 CT     school 902160 720011   Ledyard School District 90216000402 725111 Ledyard Middle School Public Schools Regular School No Middle 06 10 2020   pk_12_total 390 22 54   16 *     *   46   285 259     *             108   544 390 22 54   16           46   285 259             108   544
2778269 CT     school   720011   Ledyard School District   720511 Ledyard Transition Academy Program           2020   pk_12_total * * 0   0 *     0   0   * *     0             8   8     0   0       0   0           0       8   8
2778271 CT     school 902220 740011   Litchfield School District 90222000405 740211 Center School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 273 * 17   0 *     *   *   145 156     0             39   301 273   17   0               145 156     0       39   301
2778272 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2020   pk_12_total 174 * 8   0 *     0   *   102 88     0             29   190 174   8   0       0       102 88     0       29   190
2778273 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 118 0 *   0 *     *   *   68 63     *             23   131 118 0     0               68 63             23   131
2778274 CT     school 902220 740011   Litchfield School District 90222000406 746111 Litchfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 228 * 16   0 *     7   *   131 129     *             48   260 228   16   0       7       131 129             48   260
2778275 CT     school   760011   Madison School District 90228001549 769011 Town Campus Learning Center Program           2020   pk_12_total 40 0 *   0 *     0   *   22 21     0             22   43 40 0     0       0       22 21     0       22   43
2778282 CT     school 902310 770011   Manchester School District 90231000422 770611 Keeney School Public Schools Regular School No Elementary PK 04 2020   pk_12_total 127 38 80   0 *     *   0   145 129     21             41   274 127 38 80   0           0   145 129     21       41   274
2778303 CT     school 902400 800011   Meriden School District 90240000439 800111 Benjamin Franklin School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 106 32 193   0 *     *   20   * 182     37             55   356 106 32 193   0           20     182     37       55   356
2778306 CT     school   800011   Meriden School District   802611 PRIDE Program           2020   pk_12_total 25 * 53   0 *     0   *   64 24     0             88   88 25   53   0       0       64 24     0       88   88
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
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
2778324 CT     school   800011   Meriden School District   801811 STARS - HS Program           2020   pk_12_total * 0 *   0 *     0   0   8 0     *             8   8   0     0       0   0   8 0             8   8
2778325 CT     school   800011   Meriden School District   802011 TLC - MHS Program           2020   pk_12_total 9 * 24   0 *     0   0   26 13     11             39   39 9   24   0       0   0   26 13     11       39   39
2778326 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2020   pk_12_total * * 10   0 *     0   *   11 9     *             20   20     10   0       0       11 9             20   20
2778333 CT     school 902490 830011   Middletown School District 90249000461 831111 Snow School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 153 59 86   0 *     *   39   188 175     15             71   363 153 59 86   0           39   188 175     15       71   363
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
2778358 CT     school 902520 840011   Milford School District 90252000481 841811 Orchard Hills School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 255 * 42   0 *     0   11   163 159     *             47   322 255   42   0       0   11   163 159             47   322
2778371 CT     school 902550 850011   Monroe School District 90255000490 850111 Monroe Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 289 10 48   0 *     *   9   193 169     *             63   362 289 10 48   0           9   193 169             63   362
2778379 CT     school   860011   Montville School District 90258001663 860311 Pre School Program Program           2020   pk_12_total 37 0 11   0 *     0   *   28 26     0             22   54 37 0 11   0       0       28 26     0       22   54
2778380 CT     school 902580 860011   Montville School District 90258000496 860511 Oakdale School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 195 * 29   0 *     0   33   142 125     7             41   267 195   29   0       0   33   142 125     7       41   267
2778384 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2020   pk_12_total * * 0   0 *     0   0   * *     0             7   7     0   0       0   0           0       7   7
2778386 CT     school   880011   Naugatuck School District 90264001384 888111 Head Start Program           2020   pk_12_total 63 17 38   0 *     0   *   69 63     0             12   132 63 17 38   0       0       69 63     0       12   132
2778387 CT     school 902640 880011   Naugatuck School District 90264000499 880811 Andrew Avenue School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 129 21 86   0 *     0   *   125 124     36             33   249 129 21 86   0       0       125 124     36       33   249
2778388 CT     school 902640 880011   Naugatuck School District 90264000506 880511 Hop Brook Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 149 44 89   0 *     *   21   159 154     53             50   313 149 44 89   0           21   159 154     53       50   313
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
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
2778397 CT     school   880011   Naugatuck School District   881011 Naugatuck Community Program Program           2020   pk_12_total 10 * *   0 *     0   *   10 7     0             17   17 10       0       0       10 7     0       17   17
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
2778407 CT     school 902670 890011   New Britain School District 90267000517 890911 Northend Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 18 39 197   0 *     0   *   129 137     34             40   266 18 39 197   0       0       129 137     34       40   266
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
2778410 CT     school   890011   New Britain School District   891911 Smith Pathways Program           2020   pk_12_total 0 * 13   0 *     0   *   9 7     *             16   16 0   13   0       0       9 7             16   16
2778411 CT     school 902670 890011   New Britain School District 90267000527 891511 Vance Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 61 51 361   0 *     0   *   260 236     91             77   496 61 51 361   0       0       260 236     91       77   496
2778418 CT     school   890011   New Britain School District   891711 Slade KEY Middle Program           2020   pk_12_total * * 10   0 *     0   *   19 0     0             19   19     10   0       0       19 0     0       19   19
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
2778430 CT     school 902730 910011   New Fairfield School District 90273000535 910111 Consolidated School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 401 7 65   0 *     *   15   243 251     42             87   494 401 7 65   0           15   243 251     42       87   494
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
2778435 CT     school 902760 920011   New Hartford School District 90276000540 920211 New Hartford Elementary School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 82 0 *   0 *     0   *   52 38     *             16   90 82 0     0       0       52 38             16   90
2778437 CT     school 902760 920011   New Hartford School District 90276000538 920311 Ann Antolini School Public Schools Regular School No Elementary 03 06 2020   pk_12_total 227 * *   0 *     0   10   117 125     *             32   242 227       0       0   10   117 125             32   242
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

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