Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int ▼ homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2452229 CT     school   2450014   Learn   2451214 Learn ABA Program at Center School             2019   pk_12_total * * 6   0 *     0   *   * *     *             15   15     6   0       0                       15   15
2452232 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2019   pk_12_total 203 * 31   * 9     0   20   123 148     *             32   271 203   31     9     0   20   123 148             32   271
2452234 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2019   pk_12_total 42 * 14   * *     0   7   25 42     *             7   67 42   14           0   7   25 42             7   67
2452235 CT     school   2450014   Learn 90345001757 2450414 LEARN Transition Academy Program           2019   pk_12_total * 0 *   0 *     0   0   * 0     *             *   *   0     0       0   0     0                  
2452237 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 257 * 20   * 7     *   *   148 151     *             50   299 257   20     7             148 151             50   299
2452240 CT     school 902160 720011   Ledyard School District 90216000398 720411 Gallup Hill School Public Schools Regular School No Elementary KG 06 2019   pk_12_total 199 * 41   20 10     *   30   167 145     *             58   312 199   41   20 10         30   167 145             58   312
2452241 CT     school 902160 720011   Ledyard School District 90216000400 720111 Ledyard Center School   Regular School No Elementary KG 06 2019   pk_12_total 277 * 36   12 13     *   23   193 181     *             58   374 277   36   12 13         23   193 181             58   374
2452248 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2019   pk_12_total 172 0 10   0 *     0   *   97 93     *             32   190 172 0 10   0       0       97 93             32   190
2452254 CT     school 902280 760011   Madison School District 90228000413 760311 Kathleen H. Ryerson Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 169 0 *   0 13     0   *   107 87     *             22   194 169 0     0 13     0       107 87             22   194
2452255 CT     school 902280 760011   Madison School District 90228001382 760611 Dr. Robert H. Brown Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 321 * 17   * 15     *   22   193 187     *             54   380 321   17     15         22   193 187             54   380
2452256 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 364 * 24   0 *     0   21   236 *     *             64   423 364   24   0       0   21   236               64   423
2452265 CT     school 902310 770011   Manchester School District 90231000425 771611 Martin School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 102 51 55   0 15     *   *   121 106     *             49   227 102 51 55   0 15             121 106             49   227
2452268 CT     school   770011   Manchester School District   771111 Elementary Site 2             2019   pk_12_total * 0 0   0 *     0   0   * *     *             0   *   0 0   0       0   0                   0    
2452272 CT     school   770011   Manchester School District 90231000427 779011 Manchester Regional Academy Program           2019   pk_12_total 24 20 20   0 *     0   *   46 21     *             50   67 24 20 20   0       0       46 21             50   67
2452274 CT     school   770011   Manchester School District 90231001769 770211 Manchester High School-Site 2 Program           2019   pk_12_total 15 9 17   0 0     0   0   25 16     *             18   41 15 9 17   0 0     0   0   25 16             18   41
2452276 CT     school   770011   Manchester School District 90231001599 779111 Manchester Transition Center Program           2019   pk_12_total * 6 8   0 *     0   0   16 6     *             22   22   6 8   0       0   0   16 6             22   22
2452288 CT     school   800011   Meriden School District   800611 STARS - ES Program           2019   pk_12_total 13 * 27   0 0     0   *   37 9     *             46   46 13   27   0 0     0       37 9             46   46
2452292 CT     school   800011   Meriden School District   800911 STEP - ES Program           2019   pk_12_total 8 * 15   0 0     0   *   * *     *             28   28 8   15   0 0     0                       28   28
2452296 CT     school   800011   Meriden School District   802411 SOAR - WMS Program           2019   pk_12_total * * *   0 0     0   0   * *     *             14   14         0 0     0   0                   14   14
2452297 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2019   pk_12_total 6 * 11   0 0     0   *   18 6     *             24   24 6   11   0 0     0       18 6             24   24
2452299 CT     school   800011   Meriden School District   801511 STARS-MS Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2452300 CT     school   800011   Meriden School District   801311 Venture Academy Program           2019   pk_12_total 13 * 31   0 0     0   *   40 11     *             51   51 13   31   0 0     0       40 11             51   51
2452303 CT     school   800011   Meriden School District   802511 SOAR - PHS Program           2019   pk_12_total * * 6   0 *     0   0   * *     *             12   12     6   0       0   0                   12   12
2452304 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2019   pk_12_total * * 7   0 *     0   *   7 6     *             13   13     7   0       0       7 6             13   13
2452305 CT     school   800011   Meriden School District   801611 TSC - MHS Program           2019   pk_12_total * * 10   0 0     0   0   * *     *             19   19     10   0 0     0   0                   19   19
2452308 CT     school   800011   Meriden School District   801411 Success Academy Program           2019   pk_12_total 6 * 26   0 0     0   *   15 23     *             12   38 6   26   0 0     0       15 23             12   38
2452309 CT     school   800011   Meriden School District   802011 TLC - MHS Program           2019   pk_12_total * * 6   0 *     0   0   * *     *             14   14     6   0       0   0                   14   14
2452310 CT     school   800011   Meriden School District 90240001800 800211 Community Classroom Collaborative Program           2019   pk_12_total * * *   * 0     0   0   * *     *             11   11           0     0   0                   11   11
2452311 CT     school   800011   Meriden School District   802111 Community Collaborative Classroom - ACADEMY Program           2019   pk_12_total * * *   0 0     0   0   * *     *             8   8         0 0     0   0                   8   8
2452320 CT     school 902490 830011   Middletown School District 90249000464 831411 Wesley School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 134 44 36   0 8     0   19   125 116     *             27   241 134 44 36   0 8     0   19   125 116             27   241
2452333 CT     school   830011   Middletown School District 90249001598 839111 Middletown Transition Center Program           2019   pk_12_total 10 * *   * 0     0   *   14 6     *             20   20 10         0     0       14 6             20   20
2452338 CT     school 902520 840011   Milford School District 90252000483 841011 Pumpkin Delight School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 167 28 40   0 19     *   *   131 134     *             39   265 167 28 40   0 19             131 134             39   265
2452342 CT     school 902520 840011   Milford School District 90252000484 845111 East Shore Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 310 * 30   0 27     0   *   179 216     *             57   395 310   30   0 27     0       179 216             57   395
2452346 CT     school 902520 840011   Milford School District 90252000473 846311 Joseph A. Foran High School Public Schools Regular School No High 09 12 2019   pk_12_total 708 50 58   * 53     *   *   437 437     *             138   874 708 50 58     53             437 437             138   874
2452348 CT     school   840011   Milford School District   840411 Fifth Year Vocational Experience Program           2019   pk_12_total * * 0   0 0     0   0   * *     *             6   6     0   0 0     0   0                   6   6
2452350 CT     school 902550 850011   Monroe School District 90255000490 850111 Monroe Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 314 9 35   0 *     0   *   191 175     *             67   366 314 9 35   0       0       191 175             67   366
2452353 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2019   pk_12_total 627 * 58   * 39     0   18   361 395     *             101   756 627   58     39     0   18   361 395             101   756
2452359 CT     school 902580 860011   Montville School District 90258000496 860511 Oakdale School Public Schools Regular School No Elementary KG 05 2019   pk_12_total 208 * 27   0 *     0   34   147 133     *             37   280 208   27   0       0   34   147 133             37   280
2452363 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2019   pk_12_total 6 * 0   0 *     0   0   8 0     *             8   8 6   0   0       0   0   8 0             8   8
2452375 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2019   pk_12_total 8 * *   0 0     0   0   * *     *             0   15 8       0 0     0   0                   0   15
2452376 CT     school 900028 2800013   New Beginnings Inc Family Academy District 90002801366 2800113 New Beginnings Inc Family Academy Public Charter Schools Regular School Yes Elementary PK 08 2019   pk_12_total 10 298 166   0 *     *   *   246 236     *             40   482 10 298 166   0               246 236             40   482
2452384 CT     school   890011   New Britain School District   890211 Chamberlain Bridges Program           2019   pk_12_total * * 19   0 0     0   0   * *     *             *   24     19   0 0     0   0                       24
2452385 CT     school   890011   New Britain School District   890411 Holmes Bridges Program           2019   pk_12_total * * 15   0 0     0   0   * *     *             18   18     15   0 0     0   0                   18   18
2452392 CT     school   890011   New Britain School District 90267001566 899011 New Britain Transition Center Program           2019   pk_12_total * * 34   0 0     0   0   30 17     *             *   47     34   0 0     0   0   30 17                 47
2452393 CT     school   890011   New Britain School District   891911 Smith Pathways Program           2019   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2452396 CT     school   890011   New Britain School District   891711 Slade KEY Middle Program           2019   pk_12_total * * 9   0 *     0   *   * *     *             17   17     9   0       0                       17   17
2452401 CT     school   890011   New Britain School District 90267001609 899411 CLIMB Program           2019   pk_12_total * * 14   0 0     0   0   14 10     *             24   24     14   0 0     0   0   14 10             24   24
2452406 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2019   pk_12_total 1096 23 53   * 77     *   32   647 637     *             167   1284 1096 23 53     77         32   647 637             167   1284
2452411 CT     school 902730 910011   New Fairfield School District 90273000537 916111 New Fairfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 661 11 71   * 19     *   12   401 376     *             94   777 661 11 71     19         12   401 376             94   777
2452413 CT     school 902760 920011   New Hartford School District 90276000540 920211 New Hartford Elementary School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 85 * *   0 *     0   *   53 43     *             10   96 85       0       0       53 43             10   96
2452457 CT     school   930011   New Haven School District   937711 Nathan Hale Self Contained ID Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             10   10     7   0 0     0   0                   10   10
2452460 CT     school   930011   New Haven School District   937411 Celentano Self Contained ID Program           2019   pk_12_total * * *   0 0     0   *   * *     *             12   12         0 0     0                       12   12
2452464 CT     school   930011   New Haven School District   930110 Gateway to College Program Program           2019   pk_12_total * 29 *   0 0     0   0   26 21     *             14   47   29     0 0     0   0   26 21             14   47
2452468 CT     school   930011   New Haven School District   930210 James Hillhouse Self Contained MD Program           2019   pk_12_total 0 * *   0 0     0   0   * *     *             *   9 0       0 0     0   0                       9
2452470 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2019   pk_12_total 25 206 66   0 *     0   *   149 155     *             58   304 25 206 66   0       0       149 155             58   304
2452474 CT     school   930011   New Haven School District   938511 Wilbur Cross Self Contained MD Program           2019   pk_12_total * * 12   0 0     0   0   12 8     *             20   20     12   0 0     0   0   12 8             20   20
2452499 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 270 * 26   0 8     0   *   154 156     *             50   310 270   26   0 8     0       154 156             50   310
2452500 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 242 * 27   0 6     0   *   153 130     *             35   283 242   27   0 6     0       153 130             35   283
2452501 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 296 * 41   * 8     0   10   187 174     *             43   361 296   41     8     0   10   187 174             43   361
2452503 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 527 11 44   0 26     0   16   299 325     *             95   624 527 11 44   0 26     0   16   299 325             95   624
2452505 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2019   pk_12_total 1383 18 83   0 69     0   22   811 *     *             143   1575 1383 18 83   0 69     0   22   811               143   1575
2452507 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 82 0 *   0 0     0   *   54 41     *             18   95 82 0     0 0     0       54 41             18   95
2452509 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 352 * 29   * 11     0   0   222 178     *             48   400 352   29     11     0   0   222 178             48   400
2452510 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2019   pk_12_total 355 15 31   0 14     0   0   226 189     *             58   415 355 15 31   0 14     0   0   226 189             58   415
2452511 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2019   pk_12_total 476 * 38   * 15     0   0   242 302     *             88   544 476   38     15     0   0   242 302             88   544
2452541 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2019   pk_12_total 112 49 84   0 *     0   *   84 197     *             10   281 112 49 84   0       0       84 197             10   281
2452543 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2019   pk_12_total 7 * *   0 0     0   0   10 7     *             17   17 7       0 0     0   0   10 7             17   17
2452546 CT     school   1040011   Norwich School District   1040511 Special Needs Program @ Mahan Program           2019   pk_12_total * * 6   0 *     0   *   6 6     *             12   12     6   0       0       6 6             12   12
2452553 CT     school   1040011   Norwich School District   1041211 Strive Program @ Stanton Program           2019   pk_12_total * * *   0 0     0   0   * *     *             6   6         0 0     0   0                   6   6
2452558 CT     school   1040011   Norwich School District   1041111 Strive Program @ Kelly Program           2019   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2452561 CT     school   1040011   Norwich School District   1041011 Transition Academy Program           2019   pk_12_total 16 * *   0 *     0   *   14 9     *             23   23 16       0       0       14 9             23   23
2452571 CT     school 903240 1080011   Oxford School District 90324000690 1085111 Oxford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 428 * 33   * 11     0   *   233 250     *             58   483 428   33     11     0       233 250             58   483
2452576 CT     school 903270 1090011   Plainfield School District 90327000692 1090111 Moosup Elementary School Public Schools Regular School No Elementary KG 03 2019   pk_12_total 259 10 23   0 *     *   *   139 162     *             29   301 259 10 23   0               139 162             29   301
2452586 CT     school 903330 1110011   Plymouth School District 90333000706 1110211 Plymouth Center School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 270 * 34   0 0     0   *   158 156     *             56   314 270   34   0 0     0       158 156             56   314
2452589 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2019   pk_12_total 356 * 34   0 *     0   12   211 203     *             61   414 356   34   0       0   12   211 203             61   414
2452590 CT     school 903360 1120011   Pomfret School District 90336000709 1120111 Pomfret Community School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 338 * 19   0 15     *   *   208 171     *             38   379 338   19   0 15             208 171             38   379
2452593 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2019   pk_12_total 162 * 27   0 *     0   14   107 107     *             24   214 162   27   0       0   14   107 107             24   214
2452594 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 157 * 27   0 *     0   12   105 100     *             23   205 157   27   0       0   12   105 100             23   205
2452597 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2019   pk_12_total 113 * 11   * *     0   8   66 79     *             24   145 113   11           0   8   66 79             24   145
2452603 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 328 * 24   0 *     0   19   201 188     *             60   389 328   24   0       0   19   201 188             60   389
2452608 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2019   pk_12_total 170 * *   0 0     0   11   94 99     *             28   193 170       0 0     0   11   94 99             28   193
2452609 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2019   pk_12_total 116 * 9   * 0     0   *   72 *     *             30   132 116   9     0     0       72               30   132
2452611 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2019   pk_12_total 471 8 15   * *     *   *   224 285     *             93   509 471 8 15                   224 285             93   509
2452612 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2019   pk_12_total 329 6 8   * 0     0   *   173 175     *             54   348 329 6 8     0     0       173 175             54   348
2452614 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2019   pk_12_total 693 * 15   * 17     *   *   387 347     *             88   734 693   15     17             387 347             88   734
2452616 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 123 * 13   0 *     0   *   63 77     *             12   140 123   13   0       0       63 77             12   140
2452618 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 48 0 *   0 *     0   *   29 24     *             *   53 48 0     0       0       29 24                 53
2452619 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2019   pk_12_total 373 * 31   0 *     0   *   207 210     *             70   417 373   31   0       0       207 210             70   417
2452621 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 03 2019   pk_12_total 240 0 13   * *     0   *   135 126     *             46   261 240 0 13           0       135 126             46   261
2452623 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2019   pk_12_total 265 * 30   0 *     0   11   153 159     *             51   312 265   30   0       0   11   153 159             51   312
2452625 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 468 * 25   * 12     0   7   269 *     *             77   515 468   25     12     0   7   269               77   515
2452626 CT     school   2130012   Regional School District 13 90353501731 2130312 Middlesex Transition Academy Program           2019   pk_12_total 19 * *   0 *     0   0   18 6     *             24   24 19       0       0   0   18 6             24   24
2452627 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 249 * 8   * *     0   6   139 129     *             39   268 249   8           0   6   139 129             39   268
2452629 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 304 * 20   * 8     0   *   160 177     *             63   337 304   20     8     0       160 177             63   337
2452630 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2019   pk_12_total 635 * 25   * 14     0   6   * 385     *             112   688 635   25     14     0   6     385             112   688
2452632 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2019   pk_12_total 434 10 26   0 27     0   18   282 233     *             105   515 434 10 26   0 27     0   18   282 233             105   515
2452635 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2019   pk_12_total 297 6 36   0 11     0   8   199 159     *             59   358 297 6 36   0 11     0   8   199 159             59   358
2452637 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2019   pk_12_total 368 * 21   * 19     0   10   222 207     *             76   429 368   21     19     0   10   222 207             76   429
2452644 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2019   pk_12_total 591 27 43   0 *     0   *   355 320     *             73   675 591 27 43   0       0       355 320             73   675
2452645 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary PK 04 2019   pk_12_total 236 * 11   0 6     0   *   137 120     *             59   257 236   11   0 6     0       137 120             59   257

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