Data source: Big Local News · About: Big Local

7,625 rows where grade = "grade_2" and state = "CO" sorted by ccd_school_high_grade descending

View and edit SQL

year

grade

  • grade_2 · 7,625
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
707867 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_2 6 1 44   0 2     0   1   27 27                       54 6 1 44   0 2     0   1   27 27                 54
707932 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_2 46 2 20   0 2     0   10   48 32                       80 46 2 20   0 2     0   10   48 32                 80
708319 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes Other KG 12 2017   grade_2 37 1 5   1 5     0   0   25 24                       49 37 1 5   1 5     0   0   25 24                 49
709180 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2017   grade_2 29 3 5   0 2     0   4   24 19                       43 29 3 5   0 2     0   4   24 19                 43
709720 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2017   grade_2 5 36 24   0 1     0   2   37 31                       68 5 36 24   0 1     0   2   37 31                 68
709771 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2017   grade_2 79 1 24   0 1     0   8   60 53                       113 79 1 24   0 1     0   8   60 53                 113
709916 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2017   grade_2 18 16 24   0 1     0   2   20 41                       61 18 16 24   0 1     0   2   20 41                 61
709975 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes Other KG 12 2017   grade_2 7 12 72   7 0     0   0   50 48                       98 7 12 72   7 0     0   0   50 48                 98
709989 CO     school 802700 190   BYERS 32J 80270006548 3362 VALIANT ACADEMY   Regular School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
710186 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2017   grade_2 80 1 7   0 3     0   6   57 40                       97 80 1 7   0 3     0   6   57 40                 97
710537 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001572 8927 TWIN PEAKS CHARTER ACADEMY   Regular School Yes Other KG 12 2017   grade_2 41 0 35   0 3     0   3   37 45                       82 41 0 35   0 3     0   3   37 45                 82
710578 CO     school 802490 480   BOULDER VALLEY RE 2 80249006557 866 BOULDER EXPLORE   Regular School No Other KG 12 2017   grade_2 1 0 1   0 0     0   1   1 2                       3 1 0 1   0 0     0   1   1 2                 3
710892 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_2 53 1 9   0 6     0   3   40 32                       72 53 1 9   0 6     0   3   40 32                 72
711145 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   grade_2 0 0 12   0 0     0   0   6 6                       12 0 0 12   0 0     0   0   6 6                 12
711160 CO     school 804140 740   SIERRA GRANDE R-30 80414000572 7880 SIERRA GRANDE K-12 SCHOOL   Regular School No Other PK 12 2017   grade_2 1 0 16   0 0     0   1   8 10                       18 1 0 16   0 0     0   1   8 10                 18
711254 CO     school 803330 870   DELTA COUNTY 50(J) 80333002024 2166 DELTA VISION SCHOOL   Alternative School Yes Other KG 12 2017   grade_2 26 0 4   0 0     0   2   12 20                       32 26 0 4   0 0     0   2   12 20                 32
712039 CO     school 803360 880   DENVER COUNTY 1 80336006442 4795 KUNSMILLER CREATIVE ARTS ACADEMY   Regular School No Other KG 12 2017   grade_2 6 1 43   0 2     0   1   28 25                       53 6 1 43   0 2     0   1   28 25                 53
712824 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006494 1555 CLOVERLEAF HOME EDUCATION   Alternative School No Other KG 12 2017   grade_2 32 0 3   1 0     0   2   20 18                       38 32 0 3   1 0     0   2   20 18                 38
713086 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006493 5259 STEM SCHOOL   Regular School Yes Other KG 12 2017   grade_2 25 0 10   0 16     0   2   28 25                       53 25 0 10   0 16     0   2   28 25                 53
713178 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006455 6365 SKYVIEW ACADEMY   Regular School Yes Other PK 12 2017   grade_2 63 0 9   0 26     0   5   42 61                       103 63 0 9   0 26     0   5   42 61                 103
713538 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
713732 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No Other KG 12 2017   grade_2 24 1 7   0 0     0   0   12 20                       32 24 1 7   0 0     0   0   12 20                 32
714873 CO     school 803870 1110   FALCON 49 80387006462 2877 SPRINGS STUDIO FOR ACADEMIC EXCELLENCE   Regular School No Other KG 12 2017   grade_2 12 0 0   1 1     0   1   10 5                       15 12 0 0   1 1     0   1   10 5                 15
714983 CO     school 803870 1110   FALCON 49 80387002000 7463 ROCKY MOUNTAIN CLASSICAL ACADEMY   Regular School Yes Other KG 12 2017   grade_2 154 5 49   0 2     0   12   94 128                       222 154 5 49   0 2     0   12   94 128                 222
715446 CO     school 804620 1380   HINSDALE COUNTY RE 1 80462001969 4899 LAKE CITY COMMUNITY SCHOOL   Regular School No Other PK 12 2017   grade_2 4 0 0   1 0     0   0   5 0                       5 4 0 0   1 0     0   0   5 0                 5
715504 CO     school 807050 1410   NORTH PARK R-1 80705001209 6358 NORTH PARK SCHOOL   Regular School No Other PK 12 2017   grade_2 7 0 2   0 0     0   0   4 5                       9 7 0 2   0 0     0   0   4 5                 9
715726 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001766 1880 COMPASS MONTESSORI - GOLDEN CHARTER SCHOOL   Regular School Yes Other PK 12 2017   grade_2 15 0 3   0 0     0   1   10 9                       19 15 0 3   0 0     0   1   10 9                 19
715821 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001508 2799 EXCEL ACADEMY CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_2 58 0 7   0 1     0   2   39 29                       68 58 0 7   0 1     0   2   39 29                 68
715994 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001921 4404 JEFFERSON ACADEMY   Regular School Yes Other KG 12 2017   grade_2 48 2 2   0 2     0   2   26 30                       56 48 2 2   0 2     0   2   26 30                 56
716152 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes Other PK 12 2017   grade_2 2 0 2   0 0     0   0   1 3                       4 2 0 2   0 0     0   0   1 3                 4
716202 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No Other PK 12 2017   grade_2 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
716455 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001036 7701 COLLEGIATE ACADEMY OF COLORADO   Regular School Yes Other KG 12 2017   grade_2 20 2 9   0 2     0   0   13 20                       33 20 2 9   0 2     0   0   13 20                 33
716523 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
716616 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006466 8793 TWO ROADS CHARTER SCHOOL   Regular School Yes Other PK 12 2017   grade_2 29 0 4   0 0     0   2   24 11                       35 29 0 4   0 0     0   2   24 11                 35
716840 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2017   grade_2 8 0 3   0 0     0   0   7 4                       11 8 0 3   0 0     0   0   7 4                 11
716855 CO     school 806510 1460   HI-PLAINS R-23 80651001130 7746 HI-PLAINS SCHOOL DISTRICT R-23   Regular School No Other PK 12 2017   grade_2 6 0 1   1 0     0   0   3 5                       8 6 0 1   1 0     0   0   3 5                 8
716887 CO     school 802460 1490   BETHUNE R-5 80246000095 842 BETHUNE PUBLIC SCHOOLS   Regular School No Other PK 12 2017   grade_2 2 0 5   0 0     0   0   4 3                       7 2 0 5   0 0     0   0   4 3                 7
716958 CO     school 803480 1520   DURANGO 9-R 80348006614 2097 DISTRICT 9-R SHARED SCHOOL   Regular School No Other KG 12 2017   grade_2 19 1 1   0 0     0   0   14 7                       21 19 1 1   0 0     0   0   14 7                 21
717076 CO     school 803990 1550   POUDRE R-1 80399001717 146 RIDGEVIEW CLASSICAL CHARTER SCHOOLS   Regular School Yes Other KG 12 2017   grade_2 49 0 8   0 1     0   4   30 32                       62 49 0 8   0 1     0   4   30 32                 62
717245 CO     school 803990 1550   POUDRE R-1 80399001608 5120 LIBERTY COMMON CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_2 81 0 4   0 1     0   1   41 46                       87 81 0 4   0 1     0   1   41 46                 87
717336 CO     school 803990 1550   POUDRE R-1 80399006334 7104 POLARIS EXPEDITIONARY LEARNING SCHOOL   Alternative School No Other KG 12 2017   grade_2 18 0 0   0 0     0   0   7 11                       18 18 0 0   0 0     0   0   7 11                 18
717364 CO     school 803990 1550   POUDRE R-1 80399006431 7198 PSD GLOBAL ACADEMY   Regular School No Other KG 12 2017   grade_2 12 0 0   0 0     0   0   6 6                       12 12 0 0   0 0     0   0   6 6                 12
717587 CO     school 805400 1560   THOMPSON R2-J 80540006558 5121 LEAP SCHOOL   Regular School No Other KG 12 2017   grade_2 15 0 1   0 0     0   2   7 11                       18 15 0 1   0 0     0   2   7 11                 18
717608 CO     school 805400 1560   THOMPSON R2-J 80540006534 5235 LOVELAND CLASSICAL SCHOOL   Regular School Yes Other KG 12 2017   grade_2 69 0 12   0 3     0   1   34 51                       85 69 0 12   0 3     0   1   34 51                 85
717730 CO     school 803810 1570   ESTES PARK R-3 80381006426 2788 ESTES PARK OPTIONS SCHOOL   Alternative School No Other KG 12 2017   grade_2 6 0 0   0 0     0   0   5 1                       6 6 0 0   0 0     0   0   5 1                 6
717794 CO     school 804650 1600   HOEHNE REORGANIZED 3 80465000680 4048 HOEHNE SCHOOLS   Regular School No Other PK 12 2017   grade_2 11 1 13   0 0     0   0   15 10                       25 11 1 13   0 0     0   0   15 10                 25
717824 CO     school 802520 1750   BRANSON REORGANIZED 82 80252001728 948 BRANSON SCHOOL ONLINE   Regular School No Other KG 12 2017   grade_2 12 0 6   1 0     0   1   10 10                       20 12 0 6   1 0     0   1   10 10                 20
717838 CO     school 802520 1750   BRANSON REORGANIZED 82 80252000141 978 BRANSON SCHOOL   Regular School No Other PK 12 2017   grade_2 4 0 2   0 0     0   0   1 5                       6 4 0 2   0 0     0   0   1 5                 6
717869 CO     school 804740 1780   GENOA-HUGO C113 80474000686 4162 GENOA-HUGO SCHOOL   Regular School No Other PK 12 2017   grade_2 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
718157 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000611 3350 GATEWAY SCHOOL   Regular School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
718180 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435006498 3604 GRAND RIVER ACADEMY   Regular School No Other KG 12 2017   grade_2 2 0 0   0 0     0   1   2 1                       3 2 0 0   0 0     0   1   2 1                 3
718224 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435006384 5828 MESA VALLEY COMMUNITY SCHOOL   Regular School Yes Other KG 12 2017   grade_2 20 0 2   0 0     0   0   11 11                       22 20 0 2   0 0     0   0   11 11                 22
718365 CO     school 803150 2010   CREEDE SCHOOL DISTRICT 80315000279 1966 CREEDE SCHOOL   Regular School No Other PK 12 2017   grade_2 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3
718566 CO     school 805790 2180   MONTROSE COUNTY RE-1J 80579006499 6262 PEAK VIRTUAL ACADEMY   Regular School No Other KG 12 2017   grade_2 4 0 1   0 0     0   0   3 2                       5 4 0 1   0 0     0   0   3 2                 5
718642 CO     school 805850 2190   WEST END RE-2 80585001693 6718 PARADOX VALLEY CHARTER SCHOOL   Regular School Yes Other PK 12 2017   grade_2 1 0 2   0 0     0   0   3 0                       3 1 0 2   0 0     0   0   3 0                 3
718814 CO     school 802880 2560   CHERAW 31 80288000182 1546 CHERAW SCHOOL   Regular School No Other PK 12 2017   grade_2 8 0 8   0 0     0   0   4 12                       16 8 0 8   0 0     0   0   4 12                 16
719139 CO     school 806120 2690   PUEBLO CITY 60 80612001730 1488 CHAVEZ/HUERTA K-12 PREPARATORY ACADEMY   Regular School Yes Other KG 12 2017   grade_2 13 2 85   0 0     0   0   52 48                       100 13 2 85   0 0     0   0   52 48                 100
719349 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
719644 CO     school 806300 2790   MOUNTAIN VALLEY RE 1 80630001415 6146 MOUNTAIN VALLEY SCHOOL   Regular School No Other PK 12 2017   grade_2 8 0 4   0 0     0   0   4 8                       12 8 0 4   0 0     0   0   4 8                 12
719659 CO     school 805700 2800   MOFFAT 2 80570001511 2018 CRESTONE CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_2 5 0 1   0 0     0   0   0 6                       6 5 0 1   0 0     0   0   0 6                 6
719673 CO     school 805700 2800   MOFFAT 2 80570000974 5958 MOFFAT PREK-12 SCHOOL   Regular School No Other PK 12 2017   grade_2 5 0 2   0 1     0   0   4 4                       8 5 0 2   0 1     0   0   4 4                 8
719748 CO     school 805880 2840   NORWOOD R-2J 80588001012 6422 NORWOOD PUBLIC SCHOOLS   Regular School No Other PK 12 2017   grade_2 23 0 3   0 0     0   0   14 12                       26 23 0 3   0 0     0   0   14 12                 26
720260 CO     school 804410 3120   GREELEY 6 80441001614 1875 FRONTIER CHARTER ACADEMY   Regular School Yes Other KG 12 2017   grade_2 104 2 31   2 1     0   4   64 80                       144 104 2 31   2 1     0   4   64 80                 144
720285 CO     school 804410 3120   GREELEY 6 80441006505 2825 ENGAGE ONLINE ACADEMY   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
720295 CO     school 804410 3120   GREELEY 6 80441001696 2850 UNIVERSITY SCHOOLS   Regular School Yes Other KG 12 2017   grade_2 73 1 38   0 2     0   1   56 59                       115 73 1 38   0 2     0   1   56 59                 115
720543 CO     school 804440 3148   PAWNEE RE-12 80444000653 6812 PAWNEE SCHOOL PK-12   Regular School No Other PK 12 2017   grade_2 5 0 2   0 0     0   0   4 3                       7 5 0 2   0 0     0   0   4 3                 7
720609 CO     school 800019 3230   LIBERTY J-4 80001901744 5123 LIBERTY SCHOOL   Career and Technical School No Other PK 12 2017   grade_2 9 0 2   0 0     0   0   6 5                       11 9 0 2   0 0     0   0   6 5                 11
720624 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_2 85 1 31   0 10     0   12   87 52                       139 85 1 31   0 10     0   12   87 52                 139
720690 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006305 1279 CAPROCK ACADEMY   Regular School Yes Other KG 12 2017   grade_2 68 1 6   0 1     0   4   36 44                       80 68 1 6   0 1     0   4   36 44                 80
720916 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006338 8929 PIKES PEAK PREP   Regular School Yes Other KG 12 2017   grade_2 13 2 12   0 0     0   1   15 13                       28 13 2 12   0 0     0   1   15 13                 28
720945 CO     school 800023 9000   COLORADO SCHOOL FOR THE DEAF AND BLIND 80002306410 1924 COLORADO SCHOOL FOR THE DEAF AND BLIND   Special Education School No Other PK 12 2017   grade_2 4 1 4   1 0     0   0   5 5                       10 4 1 4   1 0     0   0   5 5                 10
720976 CO     school 800004 9130   EXPEDITIONARY BOCES 80000400709 2840 ROCKY MOUNTAIN SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Other KG 12 2017   grade_2 19 1 2   0 0     0   3   11 14                       25 19 1 2   0 0     0   3   11 14                 25
720990 CO     school 800282 9170   COLORADO DIGITAL BOCES 80028206600 1550 COLORADO PREP ACADEMY   Regular School No Other KG 12 2017   grade_2 66 5 17   1 2     0   6   53 44                       97 66 5 17   1 2     0   6   53 44                 97
835609 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 54 5 21   0 1     0   7   55 33                       88 54 5 21   0 1     0   7   55 33                 88
835980 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes 4.0 KG 12 2016   grade_2 36 1 9   0 0     0   2   25 23                       48 36 1 9   0 0     0   2   25 23                 48
836824 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative Education School No 4.0 KG 12 2016   grade_2 57 3 5   0 4     0   2   36 35                       71 57 3 5   0 4     0   2   36 35                 71
837365 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes 4.0 KG 12 2016   grade_2 14 22 32   0 0     0   1   31 38                       69 14 22 32   0 0     0   1   31 38                 69
837416 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No 4.0 KG 12 2016   grade_2 87 2 13   1 2     0   4   59 50                       109 87 2 13   1 2     0   4   59 50                 109
837617 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes 4.0 KG 12 2016   grade_2 5 13 87   3 0     0   0   52 56                       108 5 13 87   3 0     0   0   52 56                 108
837631 CO     school 802700 190   BYERS 32J 80270006548 3362 GREAT PLAINS ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 3 0 0   0 0     0   1   2 2                       4 3 0 0   0 0     0   1   2 2                 4
838174 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001572 8927 TWIN PEAKS CHARTER ACADEMY   Regular School Yes 4.0 KG 12 2016   grade_2 47 1 27   1 4     0   4   40 44                       84 47 1 27   1 4     0   4   40 44                 84
838529 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes 4.0 KG 12 2016   grade_2 55 0 5   0 11     0   4   42 33                       75 55 0 5   0 11     0   4   42 33                 75
838736 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative Education School No 4.0 KG 12 2016   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838780 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 0 0 19   0 0     0   0   6 13                       19 0 0 19   0 0     0   0   6 13                 19
838795 CO     school 804140 740   SIERRA GRANDE R-30 80414000572 7880 SIERRA GRANDE K-12 SCHOOL   Regular School No 4.0 KG 12 2016   grade_2 7 0 16   0 0     0   2   15 10                       25 7 0 16   0 0     0   2   15 10                 25
838881 CO     school 803330 870   DELTA COUNTY 50(J) 80333002024 2166 DELTA VISION SCHOOL   Alternative Education School Yes 4.0 KG 12 2016   grade_2 31 1 3   1 0     0   0   12 24                       36 31 1 3   1 0     0   0   12 24                 36
839379 CO     school 803360 880   DENVER COUNTY 1 80336001834 2789 ESCUELA TLATELOLCO SCHOOL   Regular School No 4.0 KG 12 2016   grade_2 0 1 2   0 0     0   1   0 4                       4 0 1 2   0 0     0   1   0 4                 4
839670 CO     school 803360 880   DENVER COUNTY 1 80336006442 4795 KUNSMILLER CREATIVE ARTS ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 4 0 52   0 3     0   1   27 33                       60 4 0 52   0 3     0   1   27 33                 60
840457 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006494 1555 CLOVERLEAF HOME EDUCATION   Alternative Education School No 4.0 KG 12 2016   grade_2 35 0 1   0 2     0   2   21 19                       40 35 0 1   0 2     0   2   21 19                 40
840729 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No 4.0 KG 12 2016   grade_2 2 0 2   0 0     0   1   3 2                       5 2 0 2   0 0     0   1   3 2                 5
840807 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006455 6365 SKYVIEW ACADEMY   Regular School Yes 4.0 PK 12 2016   grade_2 74 0 3   0 16     0   10   53 50                       103 74 0 3   0 16     0   10   53 50                 103
841157 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
841346 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 21 0 5   0 0     0   1   14 13                       27 21 0 5   0 0     0   1   14 13                 27
842483 CO     school 803870 1110   FALCON 49 80387006462 2877 SPRINGS STUDIO FOR ACADEMIC EXCELLENCE   Regular School No 4.0 KG 12 2016   grade_2 7 0 4   0 1     0   2   5 9                       14 7 0 4   0 1     0   2   5 9                 14
843051 CO     school 804620 1380   HINSDALE COUNTY RE 1 80462001969 4899 LAKE CITY COMMUNITY SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 6 0 1   1 0     0   1   3 6                       9 6 0 1   1 0     0   1   3 6                 9
843109 CO     school 807050 1410   NORTH PARK R-1 80705001209 6358 NORTH PARK SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 12 0 2   0 0     0   0   8 6                       14 12 0 2   0 0     0   0   8 6                 14
843329 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001766 1880 COMPASS MONTESSORI - GOLDEN CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2016   grade_2 18 0 1   0 0     0   2   14 7                       21 18 0 1   0 0     0   2   14 7                 21
843414 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001508 2799 EXCEL ACADEMY CHARTER SCHOOL   Regular School Yes 4.0 KG 12 2016   grade_2 47 0 5   0 2     1   3   36 22                       58 47 0 5   0 2     1   3   36 22                 58
843587 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001921 4404 JEFFERSON ACADEMY   Regular School Yes 4.0 KG 12 2016   grade_2 33 0 4   2 1     0   2   18 24                       42 33 0 4   2 1     0   2   18 24                 42
843751 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes 4.0 PK 12 2016   grade_2 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2

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