Data source: Big Local News · About: Big Local

4,354 rows where grade = "pk_12_total" and state = "CT" sorted by total descending

View and edit SQL

year

grade

  • pk_12_total · 4,254
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▲ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2452857 CT     school   1460011   Vernon School District   1460811 Renaissance Program Program           2019   pk_12_total * * *   0 0     0   *   * *     0             9   9         0 0     0               0       9   9
2452860 CT     school   1460011   Vernon School District 90468001525 1469011 Next Step Program Program           2019   pk_12_total 6 * *   0 0     0   0   * *     0             9   9 6       0 0     0   0           0       9   9
2452872 CT     school   1480011   Wallingford School District   1481111 STARS Intermediate Program Program           2019   pk_12_total * 0 *   0 *     0   0   * *     *             9   9   0     0       0   0                   9   9
2452907 CT     school   1510011   Waterbury School District   1516911 Gilmartin Scope Program           2019   pk_12_total * * *   0 0     0   0   * *     *             9   9         0 0     0   0                   9   9
2452933 CT     school   1510011   Waterbury School District   1515511 West Side SCOPE Program           2019   pk_12_total * * 7   0 0     0   0   * *     *             9   9     7   0 0     0   0                   9   9
2452934 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2019   pk_12_total * * 6   0 0     0   0   * *     0             9   9     6   0 0     0   0           0       9   9
2453094 CT     school   2070012   Regional School District 07 90372001399 2079012 FLEX Program           2019   pk_12_total 9 0 0   0 0     0   0   * *     0             9   9 9 0 0   0 0     0   0           0       9   9
2757396 CT     school   170011   Bristol School District   173711 Hubbell Autism Program Program           2021   pk_12_total * * *   0 *     0   0   * *     *             9   9         0       0   0                   9   9
2757408 CT     school   170011   Bristol School District 90051001796 172811 Northeast MS/GOAL Program           2021   pk_12_total * * *   0 0     0   0   * *     0             9   9         0 0     0   0           0       9   9
2757447 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2021   pk_12_total * 0 0   0 0     0   *   * *     0             9   9   0 0   0 0     0               0       9   9
2757539 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2021   pk_12_total 9 0 0   0 0     0   0   * *     0             *   9 9 0 0   0 0     0   0           0           9
2757585 CT     school   2420014   EdAdvance   2420614 Partnership Learning Academy Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2757769 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2021   pk_12_total 0 * *   0 0     0   0   * *     *             9   9 0       0 0     0   0                   9   9
2757898 CT     school   830011   Middletown School District 90249001793 830411 ICM- Woodrow Wilson Middle School Program           2021   pk_12_total * * *   0 0     0   *   * *     0             9   9         0 0     0               0       9   9
2757902 CT     school   830011   Middletown School District 90249001765 831711 Virtual Learning Academy - MHS Program           2021   pk_12_total * * *   0 0     0   0   * *     0             *   9         0 0     0   0           0           9
2757903 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2021   pk_12_total * * *   0 0     0   *   * *     0             *   9         0 0     0               0           9
2758137 CT     school   1040011   Norwich School District   1041111 Strive Program @ Kelly Program           2021   pk_12_total * 0 *   0 0     0   0   * *     *             9   9   0     0 0     0   0                   9   9
2758152 CT     school   1080011   Oxford School District   1080411 Connections Alternative Learning Center Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             *   9   0     0 0     0   0           0           9
2758249 CT     school   1180011   Ridgefield School District 90381001607 1189011 Ridgefield 18-21 Transition Program Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
2758298 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2021   pk_12_total * * *   0 0     0   0   9 0     0             *   9         0 0     0   0   9 0     0           9
2758306 CT     school   1310011   Southington School District   1312311 Language Based Classroom II Program           2021   pk_12_total * 0 *   0 *     0   *   * *     *             9   9   0     0       0                       9   9
2758318 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2021   pk_12_total 9 0 0   0 0     0   0   * *     0             9   9 9 0 0   0 0     0   0           0       9   9
2758509 CT     school   1510011   Waterbury School District   1511811 North End ESC Program           2021   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
2777776 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 11 12 2020   pk_12_total 0 9 0   0 0     0   0   * *     0             *   9 0 9 0   0 0     0   0           0           9
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
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
2777885 CT     school   2410014   Capitol Region Education Council   2411414 River Street School Early Learning Center Program           2020   pk_12_total * * *   0 0     0   0   * *     0             0   9         0 0     0   0           0       0   9
2777922 CT     school   280011   Colchester School District   280511 Bacon Academy Alternative Education Program           2020   pk_12_total 9 0 0   0 0     0   0   6 *     0             *   9 9 0 0   0 0     0   0   6       0           9
2778198 CT     school   640011   Hartford School District   640710 iGOAL Pre-K - Naylor School Program           2020   pk_12_total * * 6   0 0     0   *   9 0     0             9   9     6   0 0     0       9 0     0       9   9
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
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
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
2778370 CT     school   840011   Milford School District   840611 Post Grad Transitional Academy Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
2778376 CT     school   850011   Monroe School District 90255001670 850211 Masuk Alternative Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             *   9   0     0 0     0   0           0           9
2778511 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
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
2778692 CT     school   1180011   Ridgefield School District   1181311 District Program RHS Program           2020   pk_12_total * 0 0   0 *     0   0   * *     0             9   9   0 0   0       0   0           0       9   9
2778717 CT     school   1260011   Shelton School District   1260211 Alternative Learning Center 1 Program           2020   pk_12_total 6 * *   0 0     0   *   9 0     *             9   9 6       0 0     0       9 0             9   9
2778744 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2020   pk_12_total 6 * *   0 0     0   0   9 0     0             *   9 6       0 0     0   0   9 0     0           9
2778765 CT     school   1310011   Southington School District 90423001649 1311211 Collaborative Learning Program (CLP) Program           2020   pk_12_total * * *   0 0     0   *   * *     0             9   9         0 0     0               0       9   9
2778825 CT     school   1380011   Stratford School District 90444001756 1381811 Middle School Sails Program           2020   pk_12_total * * *   * 0     0   0   * *     *             9   9           0     0   0                   9   9
2778890 CT     school   1480011   Wallingford School District   1481611 WISE Primary Program Program           2020   pk_12_total * 0 *   0 0     0   *   * *     *             9   9   0     0 0     0                       9   9
2779094 CT     school   1660011   Wolcott School District 90528001772 1660411 Phoenix Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             9   9   0     0 0     0   0           0       9   9
2779145 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2020   pk_12_total * 6 *   0 0     0   0   0 9     0             9   9   6     0 0     0   0   0 9     0       9   9
2779148 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2020   pk_12_total 0 * *   0 0     0   0   9 0     0             9   9 0       0 0     0   0   9 0     0       9   9
2451730 CT     school 900210 70011   Berlin School District 90021000016 76111 Berlin High School Public Schools Regular School No High 09 12 2019   pk_12_total 724 23 93   0 35     0   24   487 412     6             94   899 724 23 93   0 35     0   24   487 412     6       94   899
2758435 CT     school 904680 1460011   Vernon School District 90468000943 1466111 Rockville High School Public Schools Regular School No High 09 12 2021   pk_12_total 556 101 159   * 46     0   *   * 474     24             174   899 556 101 159     46     0         474     24       174   899
2757383 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2021   pk_12_total 454 69 295   * *     0   40   463 435     54             120   898 454 69 295           0   40   463 435     54       120   898
2778011 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2020   pk_12_total 552 42 238   * 51     0   *   466 *     77             133   898 552 42 238     51     0       466       77       133   898
2451979 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 567 30 239   0 47     *   *   473 424     81             124   897 567 30 239   0 47             473 424     81       124   897
2757971 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 171 83 598   0 22     0   23   462 435     205             168   897 171 83 598   0 22     0   23   462 435     205       168   897
2758498 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 68 218 554   6 7     0   43   443 453     107             169   896 68 218 554   6 7     0   43   443 453     107       169   896
2779000 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 517 81 152   0 93     *   *   459 436     41             121   895 517 81 152   0 93             459 436     41       121   895
2758154 CT     school   1090011   Plainfield School District 90327001586 1098011 Early Childhood Center Program           2021   pk_12_total 78 * *   0 *     0   *   42 47     0             32   89 78       0       0       42 47     0       32   89
2757843 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2021   pk_12_total 301 218 300   * 50     *   14   473 416     48             139   889 301 218 300     50         14   473 416     48       139   889
2758690 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2021   pk_12_total 808 8 49   * 20     *   *   456 *     *             111   889 808 8 49     20             456               111   889
2758411 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2021   pk_12_total 444 55 301   * 49     *   33   452 *     74             156   888 444 55 301     49         33   452       74       156   888
2452975 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 489 75 201   * 92     *   27   421 466     34             108   887 489 75 201     92         27   421 466     34       108   887
2451792 CT     school 900450 150011   Bridgeport School District 90045000050 156111 Bassick High School Public Schools Regular School No High 09 12 2019   pk_12_total 55 332 477   * 14     0   *   530 354     194             233   884 55 332 477     14     0       530 354     194       233   884
2451836 CT     school 900540 180011   Brookfield School District 90054000109 186111 Brookfield High School Public Schools Regular School No High 09 12 2019   pk_12_total 680 20 110   0 65     *   *   442 438     15             133   880 680 20 110   0 65             442 438     15       133   880
2757562 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2021   pk_12_total 528 41 260   * 41     0   *   * 451     66             128   880 528 41 260     41     0         451     66       128   880
2453135 CT     school 900018 2720013   Explorations District 90001800834 2726113 Explorations Public Charter Schools Regular School Yes High 09 12 2019   pk_12_total 75 * 9   0 0     0   *   35 53     0             27   88 75   9   0 0     0       35 53     0       27   88
2757706 CT     school   620011   Hamden School District 90186001433 628011 Alice Peck Learning Center Program           2021   pk_12_total 13 37 21   0 *     0   *   58 30     0             65   88 13 37 21   0       0       58 30     0       65   88
2758258 CT     school 903960 1230011   Scotland School District 90396000789 1230111 Scotland Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total * 0 *   0 0     0   0   42 46     0             20   88   0     0 0     0   0   42 46     0       20   88
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
2778166 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2020   pk_12_total 297 273 205   * 54     *   45   449 427     31             160   876 297 273 205     54         45   449 427     31       160   876
2452395 CT     school 902670 890011   New Britain School District 90267000518 895311 Pulaski Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 166 94 573   * 22     0   *   463 412     174             184   875 166 94 573     22     0       463 412     174       184   875
2453139 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2019   pk_12_total 734 * 54   0 33     *   45   454 421     *             96   875 734   54   0 33         45   454 421             96   875
2778858 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2020   pk_12_total 486 44 262   * 51     *   25   460 *     68             149   875 486 44 262     51         25   460       68       149   875
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
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
2451757 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2019   pk_12_total 640 35 102   * 65     0   *   447 424     23             103   871 640 35 102     65     0       447 424     23       103   871
2758549 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 510 80 147   * 86     *   46   459 412     35             123   871 510 80 147     86         46   459 412     35       123   871
2777926 CT     school   2430014   Cooperative Educational Services 90091001520 2438014 School Readiness Program           2020   pk_12_total * 31 53   0 0     0   *   40 47     0             *   87   31 53   0 0     0       40 47     0           87
2779107 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary KG 08 2020   pk_12_total 66 0 12   0 *     0   *   41 46     6             12   87 66 0 12   0       0       41 46     6       12   87
2777867 CT     school 900540 180011   Brookfield School District 90054000109 186111 Brookfield High School Public Schools Regular School No High 09 12 2020   pk_12_total 660 22 103   * 78     *   *   446 423     20             136   869 660 22 103     78             446 423     20       136   869
2758063 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 584 35 161   0 31     0   57   436 432     32             132   868 584 35 161   0 31     0   57   436 432     32       132   868
2758550 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 462 78 208   * 88     *   27   * 446     36             105   867 462 78 208     88         27     446     36       105   867
2452397 CT     school 902670 890011   New Britain School District 90267000522 895211 Slade Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 128 118 584   * *     0   24   482 384     124             180   866 128 118 584           0   24   482 384     124       180   866
2778868 CT     school 904620 1440011   Trumbull School District 90462000933 1445111 Madison Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 573 50 128   * 91     *   20   452 412     12             126   864 573 50 128     91         20   452 412     12       126   864
2778121 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 589 * 114   * 97     0   50   456 406     13             101   862 589   114     97     0   50   456 406     13       101   862
2452716 CT     school   1320011   South Windsor School District   1320511 Preschool Outreach Program Program           2019   pk_12_total 47 * 11   0 15     0   *   48 38     0             50   86 47   11   0 15     0       48 38     0       50   86
2758724 CT     school 900018 2720013   Explorations District 90001800834 2726113 Explorations Public Charter Schools Regular School Yes High 09 12 2021   pk_12_total 68 * 13   0 0     0   *   45 *     0             33   86 68   13   0 0     0       45       0       33   86
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
2453011 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 682 13 48   0 58     0   57   446 412     *             110   858 682 13 48   0 58     0   57   446 412             110   858
2453028 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2019   pk_12_total 648 * *   0 99     0   56   449 409     *             120   858 648       0 99     0   56   449 409             120   858
2777785 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2020   pk_12_total 627 39 91   * 68     0   *   451 404     31             105   855 627 39 91     68     0       451 404     31       105   855
2779177 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2020   pk_12_total 712 7 59   0 33     0   44   430 425     *             105   855 712 7 59   0 33     0   44   430 425             105   855
2451835 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2019   pk_12_total 641 26 104   * 70     *   7   432 422     26             133   854 641 26 104     70         7   432 422     26       133   854
2452859 CT     school 904680 1460011   Vernon School District 90468000943 1466111 Rockville High School Public Schools Regular School No High 09 12 2019   pk_12_total 560 96 114   * 51     0   *   433 421     21             149   854 560 96 114     51     0       433 421     21       149   854
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
2452834 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2019   pk_12_total 497 43 241   * 43     *   25   458 395     62             158   853 497 43 241     43         25   458 395     62       158   853
2779054 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 620 * 67   0 107     0   *   431 422     *             128   853 620   67   0 107     0       431 422             128   853
2757845 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 07 08 2021   pk_12_total 253 219 277   * 77     *   23   425 427     57             122   852 253 219 277     77         23   425 427     57       122   852
2757873 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 264 94 446   * *     0   28   431 420     84             139   851 264 94 446           0   28   431 420     84       139   851
2778882 CT     school 904680 1460011   Vernon School District 90468000943 1466111 Rockville High School Public Schools Regular School No High 09 12 2020   pk_12_total 543 98 132   * 42     0   *   417 434     15             149   851 543 98 132     42     0       417 434     15       149   851
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
2452091 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 613 11 103   0 86     0   32   417 428     8             110   845 613 11 103   0 86     0   32   417 428     8       110   845
2452377 CT     school 902670 890011   New Britain School District 90267000510 891111 DiLoreto Elementary & Middle School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 107 69 641   0 9     0   19   403 442     114             121   845 107 69 641   0 9     0   19   403 442     114       121   845

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