Data source: Big Local News · About: Big Local

1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by ell_int

View and edit SQL

year

  • 2020 · 1,461

grade

  • pk_12_total · 1,461
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
2777725 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 158 * 24   0 0     0   *   99 96     *             21   195 158   24   0 0     0       99 96             21   195
2777733 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2020   pk_12_total * 0 *   0 0     0   *   * *     *             7   7   0     0 0     0                       7   7
2777734 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2020   pk_12_total 44 48 29   * *     *   *   97 32     *             129   129 44 48 29                   97 32             129   129
2777735 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2020   pk_12_total * 44 22   0 0     0   *   71 15     *             *   86   44 22   0 0     0       71 15                 86
2777741 CT     school   2440014   Area Cooperative Educational Services 90007001502 2449214 Whitney Academy Program           2020   pk_12_total 43 22 30   0 *     0   *   75 25     *             100   100 43 22 30   0       0       75 25             100   100
2777742 CT     school   2440014   Area Cooperative Educational Services 90007001490 2449114 Whitney High School North Program           2020   pk_12_total 13 54 25   0 0     *   *   77 24     *             101   101 13 54 25   0 0             77 24             101   101
2777743 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2020   pk_12_total 20 16 21   0 *     0   *   41 19     *             60   60 20 16 21   0       0       41 19             60   60
2777766 CT     school   90011   Bethel School District   90311 TASK Program           2020   pk_12_total 6 0 *   0 *     0   *   * *     *             *   12 6 0     0       0                           12
2777772 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 9 191 30   * *     0   8   118 123     *             56   241 9 191 30           0   8   118 123             56   241
2777774 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 7 220 28   * *     0   10   134 134     *             58   268 7 220 28           0   10   134 134             58   268
2777777 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 377 28 56   0 10     0   26   243 254     *             52   497 377 28 56   0 10     0   26   243 254             52   497
2777780 CT     school 900390 130011   Bozrah School District 90039000038 130111 Fields Memorial School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 146 * 20   0 0     0   *   101 84     *             28   185 146   20   0 0     0       101 84             28   185
2777788 CT     school   140011   Branford School District   140311 Access Transition Program Program           2020   pk_12_total * 0 0   0 *     0   0   * *     *             15   15   0 0   0       0   0                   15   15
2777827 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2020   pk_12_total 0 16 *   0 *     0   0   22 6     *             28   28 0 16     0       0   0   22 6             28   28
2777836 CT     school   170011   Bristol School District   173811 Greene Hills Extended Resource Program           2020   pk_12_total * 0 *   0 *     0   0   * *     *             6   6   0     0       0   0                   6   6
2777838 CT     school   170011   Bristol School District   172411 Mt. View Extended Resource Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   *         0 0     0   0                        
2777839 CT     school   170011   Bristol School District 90051001755 173011 South Side Extended Resource Program           2020   pk_12_total * * 6   0 0     0   *   * *     *             11   11     6   0 0     0                       11   11
2777845 CT     school   170011   Bristol School District 90051001688 172611 Ivy Drive GOAL Program           2020   pk_12_total * * *   0 0     0   *   7 0     *             7   7         0 0     0       7 0             7   7
2777846 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2020   pk_12_total 12 * *   0 0     0   0   18 6     *             24   24 12       0 0     0   0   18 6             24   24
2777847 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2020   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2777851 CT     school   170011   Bristol School District 90051001748 171011 Chippens Hill Middle School Functional Program Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
2777853 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2020   pk_12_total * 0 8   0 *     0   0   7 7     *             14   14   0 8   0       0   0   7 7             14   14
2777854 CT     school   170011   Bristol School District 90051001753 173411 Chms Goal Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2777855 CT     school   170011   Bristol School District 90051001661 170911 Greene-Hills GOAL Program           2020   pk_12_total * * *   0 0     0   *   * *     *             6   6         0 0     0                       6   6
2777856 CT     school   170011   Bristol School District 90051001651 172711 Northeast MS/Extended Resource Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             6   6   0     0 0     0   0                   6   6
2777863 CT     school   170011   Bristol School District 90051001515 179211 Community/Vocational Program Program           2020   pk_12_total 17 * *   0 0     0   *   13 11     *             24   24 17       0 0     0       13 11             24   24
2777869 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2020   pk_12_total 268 * 34   0 11     *   20   184 156     *             56   340 268   34   0 11         20   184 156             56   340
2777873 CT     school 900690 230011   Canton School District 90069000119 230311 Canton Intermediate School Public Schools Regular School No Middle 04 06 2020   pk_12_total 288 30 23   0 12     *   *   169 192     *             44   361 288 30 23   0 12             169 192             44   361
2777874 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 197 20 24   0 *     0   *   * 125     *             34   250 197 20 24   0       0         125             34   250
2777875 CT     school 900690 230011   Canton School District 90069000118 236111 Canton High School Public Schools Regular School No High 09 12 2020   pk_12_total 396 24 35   0 18     0   7   245 *     *             73   480 396 24 35   0 18     0   7   245               73   480
2777890 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2020   pk_12_total 25 9 10   0 *     0   *   40 9     *             49   49 25 9 10   0       0       40 9             49   49
2777897 CT     school   2410014   Capitol Region Education Council   2411914 CREC Impact Academy Program           2020   pk_12_total * 14 21   0 0     0   *   29 9     *             *   38   14 21   0 0     0       29 9                 38
2777902 CT     school 900720 240011   Chaplin School District 90072000121 240211 Chaplin Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 121 * 8   0 *     0   *   72 67     *             29   139 121   8   0       0       72 67             29   139
2777903 CT     school 900750 250011   Cheshire School District 90075011188 250211 Darcey School Public Schools Regular School No Elementary PK KG 2020   pk_12_total 138 * *   0 14     0   16   114 71     *             50   185 138       0 14     0   16   114 71             50   185
2777905 CT     school 900750 250011   Cheshire School District 90075000122 250111 Chapman School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 271 * 15   0 13     0   *   170 145     *             28   315 271   15   0 13     0       170 145             28   315
2777910 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 520 20 34   * 59     0   *   319 332     *             76   651 520 20 34     59     0       319 332             76   651
2777919 CT     school 900840 280011   Colchester School District 90084000137 280211 Jack Jackter Intermediate School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 383 * 33   0 13     *   20   235 221     *             73   456 383   33   0 13         20   235 221             73   456
2777920 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 434 * 39   * 16     0   22   259 258     *             79   517 434   39     16     0   22   259 258             79   517
2777921 CT     school 900840 280011   Colchester School District 90084000135 286111 Bacon Academy Public Schools Regular School No High 09 12 2020   pk_12_total 657 20 49   0 19     0   27   391 381     *             110   772 657 20 49   0 19     0   27   391 381             110   772
2777924 CT     school 900900 300011   Columbia School District 90090000139 300111 Horace W. Porter School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 363 * 28   * *     0   12   223 185     *             44   408 363   28           0   12   223 185             44   408
2777929 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2020   pk_12_total 80 25 40   0 *     0   *   122 33     *             155   155 80 25 40   0       0       122 33             155   155
2777930 CT     school   2430014   Cooperative Educational Services 90091001554 2439214 Developmental Learning Center (DLC) Program           2020   pk_12_total 16 18 20   0 *     0   *   41 18     *             59   59 16 18 20   0       0       41 18             59   59
2777932 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2020   pk_12_total 18 * 7   0 *     0   *   27 6     *             33   33 18   7   0       0       27 6             33   33
2777960 CT     school   340011   Danbury School District 90102001129 346211 Alternative Center For Excellence Program           2020   pk_12_total 29 9 39   0 *     0   *   37 48     *             20   85 29 9 39   0       0       37 48             20   85
2777965 CT     school 901050 350011   Darien School District 90105000170 351311 Ox Ridge Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 340 0 27   * 28     0   *   200 221     *             70   421 340 0 27     28     0       200 221             70   421
2777969 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2020   pk_12_total 1218 20 79   * 72     0   *   718 686     *             262   1404 1218 20 79     72     0       718 686             262   1404
2777971 CT     school 901110 370011   Derby School District 90111000174 370611 Bradley School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 90 46 71   0 *     *   18   120 111     *             30   231 90 46 71   0           18   120 111             30   231
2777973 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 138 65 128   0 *     *   18   184 177     *             74   361 138 65 128   0           18   184 177             74   361
2777976 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2020   pk_12_total 145 58 92   0 *     *   15   157 157     *             55   314 145 58 92   0           15   157 157             55   314
2777978 CT     school 901170 400011   East Granby School District 90117000183 400211 R. Dudley Seymour School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 134 9 17   * 12     *   7   94 87     *             30   181 134 9 17     12         7   94 87             30   181
2777979 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 144 20 *   0 20     0   *   100 99     *             26   199 144 20     0 20     0       100 99             26   199
2777980 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2020   pk_12_total 189 21 21   * 16     0   *   123 131     *             36   254 189 21 21     16     0       123 131             36   254
2777982 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2020   pk_12_total 342 * 18   * *     0   9   192 187     *             62   379 342   18           0   9   192 187             62   379
2777984 CT     school 901230 420011   East Hampton School District 90123000189 420111 Memorial School Public Schools Regular School No Elementary PK 03 2020   pk_12_total 501 * 40   0 10     *   20   309 269     *             104   578 501   40   0 10         20   309 269             104   578
2777985 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2020   pk_12_total 258 * 14   0 *     0   14   133 160     *             37   293 258   14   0       0   14   133 160             37   293
2777987 CT     school 901230 420011   East Hampton School District 90123000187 426111 East Hampton High School Public Schools Regular School No High 09 12 2020   pk_12_total 452 * 29   0 6     0   *   259 237     *             54   496 452   29   0 6     0       259 237             54   496
2778001 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2020   pk_12_total 43 54 45   * 33     0   *   75 107     *             *   182 43 54 45     33     0       75 107                 182
2778019 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2020   pk_12_total * * 0   0 0     0   0   * *     *             10   10     0   0 0     0   0                   10   10
2778026 CT     school 901410 460011   Easton School District 90141000233 465111 Helen Keller Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 257 6 26   0 31     0   0   156 164     *             45   320 257 6 26   0 31     0   0   156 164             45   320
2778029 CT     school   2420014   EdAdvance   2420114 Steps Program           2020   pk_12_total 16 * 7   * 0     0   0   * *     *             29   29 16   7     0     0   0                   29   29
2778030 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2020   pk_12_total 0 0 *   0 0     0   0   * 0     *             *   * 0 0     0 0     0   0     0                  
2778035 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2020   pk_12_total 406 17 25   0 12     *   *   243 226     *             63   469 406 17 25   0 12             243 226             63   469
2778036 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 325 18 17   * 41     0   *   192 222     *             62   414 325 18 17     41     0       192 222             62   414
2778037 CT     school 901440 480011   Ellington School District 90144000237 486111 Ellington High School Public Schools Regular School No High 09 12 2020   pk_12_total 646 31 31   0 54     0   25   410 377     *             99   787 646 31 31   0 54     0   25   410 377             99   787
2778057 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2020   pk_12_total * * *   0 *     0   0   * *     *             12   12         0       0   0                   12   12
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
2778068 CT     school 901530 510011   Fairfield School District 90153000257 510111 Dwight Elementary School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 225 6 12   0 14     0   17   151 123     *             42   274 225 6 12   0 14     0   17   151 123             42   274
2778072 CT     school 901530 510011   Fairfield School District 90153000263 510711 Mill Hill School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 286 * 19   * 24     0   20   184 170     *             60   354 286   19     24     0   20   184 170             60   354
2778073 CT     school 901530 510011   Fairfield School District 90153000264 511611 North Stratfield School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 285 9 30   0 25     0   23   182 190     *             47   372 285 9 30   0 25     0   23   182 190             47   372
2778074 CT     school 901530 510011   Fairfield School District 90153000609 511811 Osborn Hill School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 318 6 28   0 31     0   24   208 199     *             63   407 318 6 28   0 31     0   24   208 199             63   407
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
2778078 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 706 * 53   * 42     0   34   441 404     *             107   845 706   53     42     0   34   441 404             107   845
2778080 CT     school 901530 510011   Fairfield School District 90153001379 516011 Fairfield Ludlowe High School Public Schools Regular School No High 09 12 2020   pk_12_total 1213 * 130   * 90     0   45   713 787     *             191   1500 1213   130     90     0   45   713 787             191   1500
2778082 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2020   pk_12_total 19 * *   0 0     0   0   20 7     *             *   27 19       0 0     0   0   20 7                 27
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
2778101 CT     school 901620 540011   Glastonbury School District 90162000279 540811 Gideon Welles School Public Schools Regular School No Middle 06 06 2020   pk_12_total 312 * 45   * 54     0   28   230 219     *             44   449 312   45     54     0   28   230 219             44   449
2778105 CT     school 901680 560011   Granby School District 90168000290 560411 Kelly Lane Primary School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 334 29 19   * 12     0   *   207 198     *             59   405 334 29 19     12     0       207 198             59   405
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
2778129 CT     school 901740 580011   Griswold School District 90174000311 586211 Griswold High School Public Schools Regular School No High 09 12 2020   pk_12_total 414 12 47   * 10     *   27   247 274     *             101   521 414 12 47     10         27   247 274             101   521
2778141 CT     school   590011   Groton School District   591011 Transition Academy Program           2020   pk_12_total 7 * *   0 0     0   *   * *     *             14   14 7       0 0     0                       14   14
2778147 CT     school 901800 600011   Guilford School District 90180000331 605111 E. C. Adams Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 437 * 50   0 27     0   *   294 249     *             69   543 437   50   0 27     0       294 249             69   543
2778148 CT     school 901800 600011   Guilford School District 90180000332 606111 Guilford High School Public Schools Regular School No High 08 12 2020   pk_12_total 936 * 77   0 45     *   39   548 566     *             125   1114 936   77   0 45         39   548 566             125   1114
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
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
2778204 CT     school   640011   Hartford School District   649511 iGOAL 1 - Breakthrough Magnet School, North Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             11   11 0       0 0     0   0                   11   11
2778207 CT     school   640011   Hartford School District   648711 iGOAL 1 - Parkville School Program           2020   pk_12_total 0 * *   0 0     0   0   9 0     *             9   9 0       0 0     0   0   9 0             9   9
2778208 CT     school   640011   Hartford School District 90192001673 644411 iGOAL 1 - Rawson School Program           2020   pk_12_total 0 10 *   0 0     0   *   * *     *             *   18 0 10     0 0     0                           18
2778209 CT     school   640011   Hartford School District   644611 RISE - West Middle School Program           2020   pk_12_total 0 * *   0 0     0   0   * 0     *             *   * 0       0 0     0   0     0                  
2778210 CT     school   640011   Hartford School District   649811 iGOAL 1 - Moylan School             2020   pk_12_total 0 * *   0 0     0   *   * *     *             8   8 0       0 0     0                       8   8
2778211 CT     school   640011   Hartford School District   645911 RISE - M.D. Fox School             2020   pk_12_total * * 13   0 0     0   0   * *     *             27   27     13   0 0     0   0                   27   27
2778212 CT     school 901920 640011   Hartford School District 90192001582 644011 Renzulli Gifted and Talented Academy Public Schools Regular School No Middle 04 08 2020   pk_12_total 12 43 53   * 12     0   *   73 56     *             *   129 12 43 53     12     0       73 56                 129
2778214 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2778221 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2020   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2778222 CT     school   640011   Hartford School District   640110 iGOAL 1 - Milner School Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             20   20 0       0 0     0   0                   20   20
2778228 CT     school   640011   Hartford School District 90192001770 648311 RISE - Bulkeley High School Program           2020   pk_12_total * * 14   0 0     0   0   * *     *             20   20     14   0 0     0   0                   20   20
2778229 CT     school   640011   Hartford School District 90192001677 648211 RISE - Hartford Public High School Program           2020   pk_12_total * * 15   0 0     0   0   * *     *             *   24     15   0 0     0   0                       24

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