Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by ell_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
2778233 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2020   pk_12_total 0 6 10   0 0     0   0   * *     *             16   16 0 6 10   0 0     0   0                   16   16
2778235 CT     school 901950 650011   Hartland School District 90195000386 650111 Hartland School Public Schools Regular School No Elementary PK 08 2020   pk_12_total 135 * 7   0 0     *   11   92 65     *             30   157 135   7   0 0         11   92 65             30   157
2778236 CT     school 902010 670011   Hebron School District 90201000387 670211 Gilead Hill School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 293 * 10   0 6     0   *   157 160     *             35   317 293   10   0 6     0       157 160             35   317
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
2778238 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2020   pk_12_total 6 426 20   * 0     *   *   200 260     *             24   460 6 426 20     0             200 260             24   460
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
2778246 CT     school 902070 690011   Killingly School District 90207000392 696111 Killingly High School Public Schools Regular School No High 09 12 2020   pk_12_total 633 20 62   10 19     0   37   * 414     *             125   781 633 20 62   10 19     0   37     414             125   781
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
2778252 CT     school   2450014   Learn   2451614 LEARN SAILS Program Program           2020   pk_12_total 12 * *   0 0     0   *   * *     *             18   18 12       0 0     0                       18   18
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
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
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
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
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
2778287 CT     school 902310 770011   Manchester School District 90231000425 771611 Martin School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 99 51 52   0 19     *   *   121 104     *             47   225 99 51 52   0 19             121 104             47   225
2778293 CT     school   770011   Manchester School District 90231000427 779011 Manchester Regional Academy Program           2020   pk_12_total * 21 26   0 0     0   *   51 15     *             57   66   21 26   0 0     0       51 15             57   66
2778295 CT     school   770011   Manchester School District 90231001769 770211 Manchester High School-Site 2 Program           2020   pk_12_total 16 10 15   0 0     0   0   25 16     *             20   41 16 10 15   0 0     0   0   25 16             20   41
2778297 CT     school   770011   Manchester School District 90231001599 779111 Manchester Transition Center Program           2020   pk_12_total 11 7 8   0 0     0   0   17 9     *             26   26 11 7 8   0 0     0   0   17 9             26   26
2778313 CT     school   800011   Meriden School District   800611 STARS - ES Program           2020   pk_12_total 9 * 32   0 0     0   *   38 11     *             49   49 9   32   0 0     0       38 11             49   49
2778314 CT     school   800011   Meriden School District   800911 STEP - ES Program           2020   pk_12_total 9 * 23   0 0     0   *   36 7     *             43   43 9   23   0 0     0       36 7             43   43
2778318 CT     school   800011   Meriden School District   801511 STARS-MS Program           2020   pk_12_total * * *   0 0     0   *   * *     *             10   10         0 0     0                       10   10
2778319 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2020   pk_12_total 10 * 10   0 0     0   *   * *     *             24   24 10   10   0 0     0                       24   24
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
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
2778327 CT     school   800011   Meriden School District   801611 TSC - MHS Program           2020   pk_12_total * * 8   0 0     0   *   * *     *             14   14     8   0 0     0                       14   14
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
2778331 CT     school   800011   Meriden School District 90240001800 800211 Community Classroom Collaborative Program           2020   pk_12_total * * 6   0 0     0   0   * *     *             11   11     6   0 0     0   0                   11   11
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
2778340 CT     school 902490 830011   Middletown School District 90249000464 831411 Wesley School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 123 46 36   0 9     0   22   126 110     *             37   236 123 46 36   0 9     0   22   126 110             37   236
2778352 CT     school   830011   Middletown School District 90249001768 831911 MHS - Alternative Education Program 2 Program           2020   pk_12_total 0 * *   0 0     0   *   * *     *             *   9 0       0 0     0                           9
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
2778360 CT     school 902520 840011   Milford School District 90252000467 840111 Calf Pen Meadow School Public Schools Regular School No Elementary KG 05 2020   pk_12_total 217 8 26   0 8     0   14   142 131     *             37   273 217 8 26   0 8     0   14   142 131             37   273
2778363 CT     school 902520 840011   Milford School District 90252000484 845111 East Shore Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 319 28 29   0 24     0   7   199 208     *             64   407 319 28 29   0 24     0   7   199 208             64   407
2778367 CT     school 902520 840011   Milford School District 90252000473 846311 Joseph A. Foran High School Public Schools Regular School No High 09 12 2020   pk_12_total 687 50 71   0 59     *   *   428 444     *             121   872 687 50 71   0 59             428 444             121   872
2778369 CT     school   840011   Milford School District   840411 Fifth Year Vocational Experience Program           2020   pk_12_total 6 * *   0 0     0   0   * *     *             8   8 6       0 0     0   0                   8   8
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
2778374 CT     school 902550 850011   Monroe School District 90255000920 855211 Jockey Hollow School Public Schools Regular School No Middle 06 08 2020   pk_12_total 603 17 66   0 43     0   26   387 368     *             105   755 603 17 66   0 43     0   26   387 368             105   755
2778383 CT     school   860011   Montville School District 90258001481 869011 Palmer Academy Program           2020   pk_12_total 28 * *   0 0     0   *   22 *     *             18   35 28       0 0     0       22               18   35
2778396 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2020   pk_12_total * * *   0 0     0   0   * *     *             0   11         0 0     0   0                   0   11
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
2778412 CT     school   890011   New Britain School District   890211 Chamberlain Bridges Program           2020   pk_12_total * * 16   0 0     0   0   * *     *             *   22     16   0 0     0   0                       22
2778413 CT     school   890011   New Britain School District   890411 Holmes Bridges Program           2020   pk_12_total * * 14   0 0     0   0   * *     *             18   18     14   0 0     0   0                   18   18
2778414 CT     school   890011   New Britain School District   891011 Lincoln SCS Program           2020   pk_12_total * * 16   0 0     0   *   * *     *             *   22     16   0 0     0                           22
2778415 CT     school   890011   New Britain School District 90267001566 899011 New Britain Transition Center Program           2020   pk_12_total 9 * 23   0 0     0   *   21 20     *             *   41 9   23   0 0     0       21 20                 41
2778423 CT     school   890011   New Britain School District 90267001609 899411 CLIMB Program           2020   pk_12_total 6 * 18   0 0     0   *   16 11     *             27   27 6   18   0 0     0       16 11             27   27
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
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
2778436 CT     school 902760 920011   New Hartford School District 90276000539 920111 Bakerville Consolidated School Public Schools Regular School No Elementary KG 02 2020   pk_12_total 98 0 *   0 0     0   *   52 50     *             8   102 98 0     0 0     0       52 50             8   102
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
2778463 CT     school   930011   New Haven School District   930410 West Rock Integrated PK Program           2020   pk_12_total * * *   0 0     0   0   * *     *             *   8         0 0     0   0                       8
2778466 CT     school   930011   New Haven School District   937611 Barack H. Obama Self Contained Autism Program           2020   pk_12_total * * 11   0 0     0   0   * *     *             21   21     11   0 0     0   0                   21   21
2778468 CT     school   930011   New Haven School District   937911 Bishop Woods Self Contained Autism Program           2020   pk_12_total * * 8   0 0     0   0   * *     *             12   12     8   0 0     0   0                   12   12
2778469 CT     school   930011   New Haven School District   937411 Celentano Self Contained ID Program           2020   pk_12_total * 9 7   0 0     0   *   * *     *             20   20   9 7   0 0     0                       20   20
2778471 CT     school   930011   New Haven School District   937811 Clinton Self Contained ID Program           2020   pk_12_total * * 9   0 0     0   0   * *     *             11   11     9   0 0     0   0                   11   11
2778475 CT     school   930011   New Haven School District   937711 Nathan Hale Self Contained ID Program           2020   pk_12_total * * 9   0 0     0   0   9 8     *             17   17     9   0 0     0   0   9 8             17   17
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
2778493 CT     school   930011   New Haven School District   930110 Gateway to College Program Program           2020   pk_12_total * 33 17   0 *     0   0   31 21     *             9   52   33 17   0       0   0   31 21             9   52
2778494 CT     school   930011   New Haven School District   930210 James Hillhouse Self Contained MD Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             6   6 0       0 0     0   0                   6   6
2778520 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 255 * 30   0 7     0   *   150 149     *             40   299 255   30   0 7     0       150 149             40   299
2778521 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 256 * 28   0 *     0   *   156 140     *             35   296 256   28   0       0       156 140             35   296
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
2778523 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2020   pk_12_total 311 * 36   0 10     0   *   182 187     *             66   369 311   36   0 10     0       182 187             66   369
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
2778525 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 578 12 52   0 20     0   18   * 347     *             97   680 578 12 52   0 20     0   18     347             97   680
2778526 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   pk_12_total 1306 24 103   0 65     0   18   770 *     *             151   1516 1306 24 103   0 65     0   18   770               151   1516
2778528 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 61 0 *   0 0     0   *   38 35     *             21   73 61 0     0 0     0       38 35             21   73
2778530 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 344 * 33   * 9     0   6   205 192     *             69   397 344   33     9     0   6   205 192             69   397
2778531 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   pk_12_total 335 12 29   * *     0   7   225 165     *             56   390 335 12 29           0   7   225 165             56   390
2778532 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   pk_12_total 458 12 39   0 9     0   6   239 285     *             84   524 458 12 39   0 9     0   6   239 285             84   524
2778562 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   pk_12_total 120 38 83   0 29     0   7   90 187     *             10   277 120 38 83   0 29     0   7   90 187             10   277
2778563 CT     school   1030011   Norwalk School District   1031011 Norwalk Alternative Opportunity Program Program           2020   pk_12_total * * *   0 *     0   *   * *     *             *   8         0       0                           8
2778566 CT     school   1030011   Norwalk School District   1031111 Norwalk 18-21 Next Steps (NNS) Program           2020   pk_12_total * 7 *   0 0     0   0   8 6     *             14   14   7     0 0     0   0   8 6             14   14
2778567 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             10   10   0     0 0     0   0                   10   10
2778577 CT     school   1040011   Norwich School District   1040511 Special Needs Program @ Mahan Program           2020   pk_12_total * 0 *   0 *     0   0   * *     *             8   8   0     0       0   0                   8   8
2778579 CT     school   1040011   Norwich School District   1040411 Strive Autism Program @ Huntington Program           2020   pk_12_total * * *   0 *     0   0   * *     *             11   11         0       0   0                   11   11
2778580 CT     school   1040011   Norwich School District   1041211 Strive Program @ Stanton Program           2020   pk_12_total 0 * *   0 0     0   0   * *     *             *   * 0       0 0     0   0                        
2778582 CT     school   1040011   Norwich School District   1041111 Strive Program @ Kelly Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2778584 CT     school   1040011   Norwich School District 90312001622 1049211 Virtual Learning Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * *     *             *   7   0     0 0     0   0                       7
2778585 CT     school   1040011   Norwich School District   1041011 Transition Academy Program           2020   pk_12_total 11 * *   0 *     0   *   14 9     *             23   23 11       0       0       14 9             23   23
2778604 CT     school 903270 1090011   Plainfield School District 90327000695 1096111 Plainfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 526 21 24   * 6     *   6   285 305     *             109   590 526 21 24     6         6   285 305             109   590
2778611 CT     school 903330 1110011   Plymouth School District 90333000706 1110211 Plymouth Center School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 258 * 32   0 *     0   14   158 149     *             50   307 258   32   0       0   14   158 149             50   307
2778613 CT     school 903330 1110011   Plymouth School District 90333000705 1115111 Eli Terry Jr. Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 300 * 41   * *     0   9   191 168     *             70   359 300   41           0   9   191 168             70   359
2778614 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2020   pk_12_total 313 7 33   0 11     0   10   185 189     *             59   374 313 7 33   0 11     0   10   185 189             59   374
2778618 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2020   pk_12_total 138 10 29   0 *     *   13   107 *     *             30   193 138 10 29   0           13   107               30   193
2778619 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 150 * 30   0 *     0   10   101 101     *             23   202 150   30   0       0   10   101 101             23   202
2778620 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2020   pk_12_total 301 13 32   * *     0   19   185 *     *             47   371 301 13 32           0   19   185               47   371
2778622 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2020   pk_12_total 122 * 7   * *     0   9   72 75     *             29   147 122   7           0   9   72 75             29   147
2778625 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2020   pk_12_total 193 * 27   0 *     *   10   109 129     *             43   238 193   27   0           10   109 129             43   238
2778630 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2020   pk_12_total 111 * 9   0 0     0   *   63 *     *             29   126 111   9   0 0     0       63               29   126
2778632 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2020   pk_12_total 461 7 20   * *     *   9   215 293     *             86   508 461 7 20               9   215 293             86   508
2778634 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2020   pk_12_total 308 * *   0 0     0   30   180 177     *             50   357 308       0 0     0   30   180 177             50   357
2778636 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2020   pk_12_total 628 * 27   * 8     0   47   391 325     *             102   716 628   27     8     0   47   391 325             102   716
2778637 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2020   pk_12_total 598 7 38   0 10     0   65   358 360     *             74   718 598 7 38   0 10     0   65   358 360             74   718
2778638 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2020   pk_12_total 119 0 *   0 0     0   *   55 83     *             11   138 119 0     0 0     0       55 83             11   138
2778639 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2020   pk_12_total 65 * *   0 *     0   *   32 39     *             10   71 65       0       0       32 39             10   71
2778641 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2020   pk_12_total 381 * 34   0 *     0   6   213 219     *             68   432 381   34   0       0   6   213 219             68   432

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