Data source: Big Local News · About: Big Local

1,104 rows where grade = "grade_2", state = "CO" and year = 2019 sorted by school

View and edit SQL

year

  • 2019 · 1,104

grade

  • grade_2 · 1,104
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
1942663 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_2 2 0 1   0 0     0   1   2 2                       4 2 0 1   0 0     0   1   2 2                 4
1937223 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 33 12 18   1 2     0   12   44 34                       78 33 12 18   1 2     0   12   44 34                 78
1935479 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   grade_2 18 0 41   0 1     0   1   33 28                       61 18 0 41   0 1     0   1   33 28                 61
1934562 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   grade_2 3 4 9   0 0     0   1   6 11                       17 3 4 9   0 0     0   1   6 11                 17
1935934 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 63 2 10   0 2     0   4   36 45                       81 63 2 10   0 2     0   4   36 45                 81
1937765 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 60 2 7   0 3     0   8   34 46                       80 60 2 7   0 3     0   8   34 46                 80
1937307 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 27 0 4   0 0     0   1   16 16                       32 27 0 4   0 0     0   1   16 16                 32
1937773 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 62 4 12   0 15     0   10   48 55                       103 62 4 12   0 15     0   10   48 55                 103
1932694 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 11 24 35   1 2     0   6   37 42                       79 11 24 35   1 2     0   6   37 42                 79
1943992 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_2 28 1 1   0 0     1   1   14 18                       32 28 1 1   0 0     1   1   14 18                 32
1943944 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_2 92 1 37   0 6     0   4   75 65                       140 92 1 37   0 6     0   4   75 65                 140
1931022 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_2 9 1 35   0 1     0   0   23 23                       46 9 1 35   0 1     0   0   23 23                 46
1935945 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 29 1 10   1 17     1   7   34 32                       66 29 1 10   1 17     1   7   34 32                 66
1937447 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 21 18 29   0 0     1   4   38 35                       73 21 18 29   0 0     1   4   38 35                 73
1938857 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 4 16   0 2     0   2   34 30                       64 40 4 16   0 2     0   2   34 30                 64
1938906 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006643 491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL   Regular School Yes Elementary PK 05 2019   grade_2 54 0 17   0 1     0   2   34 40                       74 54 0 17   0 1     0   2   34 40                 74
1931042 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_2 6 0 39   0 1     0   2   27 21                       48 6 0 39   0 1     0   2   27 21                 48
1936919 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 3 0 1   0 0     0   0   2 2                       4 3 0 1   0 0     0   0   2 2                 4
1941130 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 0 4   0 0     0   0   5 5                       10 6 0 4   0 0     0   0   5 5                 10
1943229 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2019   grade_2 24 0 8   2 0     0   1   20 15                       35 24 0 8   2 0     0   1   20 15                 35
1931965 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 48 2 141   4 0     2   6   111 92                       203 48 2 141   4 0     2   6   111 92                 203
1932052 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 10 1 56   1 0     0   4   43 29                       72 10 1 56   1 0     0   4   43 29                 72
1934146 CO     school 802490 480   BOULDER VALLEY RE 2 80249001403 7592 ALICIA SANCHEZ INTERNATIONAL SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 2 35   0 3     0   1   31 28                       59 18 2 35   0 3     0   1   31 28                 59
1938888 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 12 2 9   0 0     0   0   11 12                       23 12 2 9   0 0     0   0   11 12                 23
1938160 CO     school 803870 1110   DISTRICT 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2019   grade_2 10 0 2   0 0     0   0   8 4                       12 10 0 2   0 0     0   0   8 4                 12
1933388 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001832 61 ALPINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 1 21   0 0     0   1   32 31                       63 40 1 21   0 0     0   1   32 31                 63
1931529 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 14 0 64   0 0     0   1   36 43                       79 14 0 64   0 0     0   1   36 43                 79
1942318 CO     school 805220 2660   LAMAR RE-2 80522000860 200 ALTA VISTA CHARTER SCHOOL   Regular School Yes Elementary KG 06 2019   grade_2 9 0 10   0 0     0   1   13 7                       20 9 0 10   0 0     0   1   13 7                 20
1932087 CO     school 802910 130   CHERRY CREEK 5 80291006750 102 ALTITUDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 61 7 19   2 7     0   6   49 53                       102 61 7 19   2 7     0   6   49 53                 102
1932717 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 7 60   1 2     0   0   45 35                       80 10 7 60   1 2     0   0   45 35                 80
1935983 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 223 2 24   2 51     0   21   167 156                       323 223 2 24   2 51     0   21   167 156                 323
1940245 CO     school 803480 1520   DURANGO 9-R 80348001066 225 ANIMAS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 25 0 12   3 0     0   1   26 15                       41 25 0 12   3 0     0   1   26 15                 41
1932099 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 63 8 24   0 5     1   7   59 49                       108 63 8 24   0 5     1   7   59 49                 108
1937802 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 35 1 5   1 2     0   2   24 22                       46 35 1 5   1 2     0   2   24 22                 46
1933411 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2019   grade_2 60 0 14   0 2     0   2   44 34                       78 60 0 14   0 2     0   2   44 34                 78
1941354 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000597 262 APPLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 45 1 12   1 1     1   2   30 33                       63 45 1 12   1 1     1   2   30 33                 63
1937239 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 25 12 22   0 0     0   6   40 25                       65 25 12 22   0 0     0   6   40 25                 65
1931136 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 47 0 40   1 2     0   3   46 47                       93 47 0 40   1 2     0   3   46 47                 93
1943245 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 0 3   0 0     0   0   4 5                       9 6 0 3   0 0     0   0   4 5                 9
1932725 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 16 16   0 1     1   5   22 35                       57 18 16 16   0 1     1   5   22 35                 57
1932113 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 41 9 17   0 3     0   6   48 28                       76 41 9 17   0 3     0   6   48 28                 76
1936020 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001757 354 ARROWWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 25 1 6   0 1     1   3   18 19                       37 25 1 6   0 1     1   3   18 19                 37
1938878 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006489 109 ARVADA K-8   Regular School No Elementary KG 08 2019   grade_2 17 3 22   0 2     0   1   28 17                       45 17 3 22   0 2     0   1   28 17                 45
1934578 CO     school 803360 880   DENVER COUNTY 1 80336000307 388 ASBURY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 33 2 19   0 2     0   1   33 24                       57 33 2 19   0 2     0   1   33 24                 57
1935956 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006760 79 ASCENT CLASSICAL ACADEMY   Regular School Yes Other KG 10 2019   grade_2 19 0 6   0 1     0   2   16 12                       28 19 0 6   0 1     0   2   16 12                 28
1934593 CO     school 803360 880   DENVER COUNTY 1 80336000309 418 ASHLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 5 13 38   0 0     0   3   32 27                       59 5 13 38   0 0     0   3   32 27                 59
1942274 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 13 0 1   0 0     1   0   8 7                       15 13 0 1   0 0     1   0   8 7                 15
1933802 CO     school 802490 480   BOULDER VALLEY RE 2 80249001758 441 ASPEN CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_2 59 2 9   0 4     0   3   38 39                       77 59 2 9   0 4     0   3   38 39                 77
1932121 CO     school 802910 130   CHERRY CREEK 5 80291001879 442 ASPEN CROSSING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 61 9 11   0 8     0   6   50 45                       95 61 9 11   0 8     0   6   50 45                 95
1942284 CO     school 802280 2640   ASPEN 1 80228000045 428 ASPEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_2 97 0 10   1 1     0   1   48 62                       110 97 0 10   1 1     0   1   48 62                 110
1933397 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006530 71 ASPEN RIDGE PREPARATORY SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 45 0 6   0 6     0   0   28 29                       57 45 0 6   0 6     0   0   28 29                 57
1936418 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006588 6019 ASPEN VIEW ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 81 0 12   0 2     0   4   49 50                       99 81 0 12   0 2     0   4   49 50                 99
1937299 CO     school 803060 1010   COLORADO SPRINGS 11 80306000222 452 AUDUBON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 39 4 18   1 1     0   4   38 29                       67 39 4 18   1 1     0   4   38 29                 67
1932733 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 11 16 17   2 2     0   3   26 25                       51 11 16 17   2 2     0   3   26 25                 51
1932747 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2019   grade_2 19 4 13   0 18     0   3   29 28                       57 19 4 13   0 18     0   3   29 28                 57
1933011 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2019   grade_2 24 11 10   0 7     0   3   25 30                       55 24 11 10   0 7     0   3   25 30                 55
1934198 CO     school 802640 490   BUENA VISTA R-31 80264000159 4306 AVERY/PARSONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 54 0 5   0 0     0   2   30 31                       61 54 0 5   0 0     0   2   30 31                 61
1936716 CO     school 803540 910   EAGLE COUNTY RE 50 80354001530 471 AVON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 2 0 18   0 1     0   0   10 11                       21 2 0 18   0 1     0   0   10 11                 21
1942634 CO     school 806150 2700   PUEBLO COUNTY 70 80615001069 472 AVONDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 0 16   0 0     0   2   12 12                       24 6 0 16   0 0     0   2   12 12                 24
1932706 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 9 21 17   1 1     0   2   24 27                       51 9 21 17   1 1     0   2   24 27                 51
1941235 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 85 2 53   1 0     0   3   79 65                       144 85 2 53   1 0     0   3   79 65                 144
1940823 CO     school 805400 1560   THOMPSON R2-J 80540000924 865 B F KITCHEN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 28 0 10   0 0     0   2   15 25                       40 28 0 10   0 0     0   2   15 25                 40
1940412 CO     school 803990 1550   POUDRE R-1 80399001973 490 BACON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 83 1 5   0 4     0   2   49 46                       95 83 1 5   0 4     0   2   49 46                 95
1941978 CO     school 804050 2405   FORT MORGAN RE-3 80405006698 1009 BAKER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 13 1 41   0 1     0   0   29 27                       56 13 1 41   0 1     0   0   29 27                 56
1938167 CO     school 803870 1110   DISTRICT 49 80387002027 555 BANNING LEWIS RANCH ACADEMY   Regular School Yes Other KG 10 2019   grade_2 87 8 19   0 5     0   16   60 75                       135 87 8 19   0 5     0   16   60 75                 135
1934601 CO     school 803360 880   DENVER COUNTY 1 80336000311 520 BARNUM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 3 3 52   0 0     0   1   23 36                       59 3 3 52   0 0     0   1   23 36                 59
1938513 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_2 47 0 61   0 0     0   0   61 47                       108 47 0 61   0 0     0   0   61 47                 108
1941738 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309001093 609 BATTLE ROCK CHARTER SCHOOL   Regular School Yes Elementary KG 06 2019   grade_2 9 1 4   0 0     0   0   5 9                       14 9 1 4   0 0     0   0   5 9                 14
1940429 CO     school 803990 1550   POUDRE R-1 80399000519 612 BAUDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 65 2 16   0 0     1   1   43 42                       85 65 2 16   0 0     1   1   43 42                 85
1940364 CO     school 802400 1530   BAYFIELD 10 JT-R 80240006747 642 BAYFIELD PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 79 0 16   3 1     0   8   64 43                       107 79 0 16   3 1     0   8   64 43                 107
1938663 CO     school 804380 1220   GARFIELD 16 80438000630 3578 BEA UNDERWOOD ELEMENTARY SCHOOL   Regular School No Elementary 02 05 2019   grade_2 49 0 31   0 0     0   3   49 34                       83 49 0 31   0 0     0   3   49 34                 83
1934609 CO     school 803360 880   DENVER COUNTY 1 80336000313 650 BEACH COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 2 1 37   0 0     0   0   18 22                       40 2 1 37   0 0     0   0   18 22                 40
1936030 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006159 651 BEAR CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 52 0 7   0 2     0   5   32 34                       66 52 0 7   0 2     0   5   32 34                 66
1933813 CO     school 802490 480   BOULDER VALLEY RE 2 80249000099 652 BEAR CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 56 0 5   0 7     0   3   41 30                       71 56 0 5   0 7     0   3   41 30                 71
1938087 CO     school 805820 1080   LEWIS-PALMER 38 80582001371 3539 BEAR CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 87 1 10   0 0     0   15   57 56                       113 87 1 10   0 0     0   15   57 56                 113
1938915 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000696 660 BEAR CREEK K-8 SCHOOL   Regular School No Elementary KG 08 2019   grade_2 46 2 42   3 10     0   7   57 53                       110 46 2 42   3 10     0   7   57 53                 110
1940438 CO     school 803990 1550   POUDRE R-1 80399000520 678 BEATTIE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 26 0 9   0 1     1   6   19 24                       43 26 0 9   0 1     1   6   19 24                 43
1943540 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2019   grade_2 10 10 80   0 1     0   0   61 40                       101 10 10 80   0 1     0   0   61 40                 101
1931590 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 23 1 45   0 2     0   2   47 26                       73 23 1 45   0 2     0   2   47 26                 73
1932129 CO     school 802910 130   CHERRY CREEK 5 80291000184 714 BELLEVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 2 9   0 35     0   4   42 48                       90 40 2 9   0 35     0   4   42 48                 90
1938935 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000699 724 BELMAR ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 24 3 18   1 0     0   2   20 28                       48 24 3 18   1 0     0   2   20 28                 48
1942380 CO     school 806120 2690   PUEBLO CITY 60 80612001029 738 BELMONT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 23 1 61   0 2     0   0   42 45                       87 23 1 61   0 2     0   0   42 45                 87
1935968 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006492 135 BEN FRANKLIN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 80 1 10   1 9     0   3   58 46                       104 80 1 10   1 9     0   3   58 46                 104
1931787 CO     school 802430 50   BENNETT 29J 80243000091 770 BENNETT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 43 0 20   0 0     0   4   37 30                       67 43 0 20   0 0     0   4   37 30                 67
1940447 CO     school 803990 1550   POUDRE R-1 80399000521 766 BENNETT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 63 2 9   0 2     0   4   38 42                       80 63 2 9   0 2     0   4   38 42                 80
1938178 CO     school 803870 1110   DISTRICT 49 80387006766 696 BENNETT RANCH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 31 0 9   0 1     0   5   23 23                       46 31 0 9   0 1     0   5   23 23                 46
1938944 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 71 0 4   0 0     0   4   39 40                       79 71 0 4   0 0     0   4   39 40                 79
1940810 CO     school 805400 1560   THOMPSON R2-J 80540000926 808 BERTHOUD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 54 0 9   0 0     0   2   31 34                       65 54 0 9   0 0     0   2   31 34                 65
1942396 CO     school 806120 2690   PUEBLO CITY 60 80612001031 822 BESSEMER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 3 1 19   0 0     0   0   10 13                       23 3 1 19   0 0     0   0   10 13                 23
1940421 CO     school 803990 1550   POUDRE R-1 80399006380 498 BETHKE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 73 0 7   1 5     0   2   43 45                       88 73 0 7   1 5     0   2   43 45                 88
1940193 CO     school 802460 1490   BETHUNE R-5 80246000095 842 BETHUNE PUBLIC SCHOOLS   Regular School No Other PK 12 2019   grade_2 5 0 3   0 1     0   0   2 7                       9 5 0 3   0 1     0   0   2 7                 9
1942642 CO     school 806150 2700   PUEBLO COUNTY 70 80615001071 852 BEULAH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 11 0 6   0 0     0   1   15 3                       18 11 0 6   0 0     0   1   15 3                 18
1942404 CO     school 806120 2690   PUEBLO CITY 60 80612001032 860 BEULAH HEIGHTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 14 2 45   0 0     0   0   28 33                       61 14 2 45   0 0     0   0   28 33                 61
1940830 CO     school 805400 1560   THOMPSON R2-J 80540000928 870 BIG THOMPSON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 30 0 8   0 1     0   3   25 17                       42 30 0 8   0 1     0   3   25 17                 42
1942844 CO     school 805760 2740   MONTE VISTA C-8 80576000985 6036 BILL METZ ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 9 0 51   1 0     0   0   34 27                       61 9 0 51   1 0     0   0   34 27                 61
1933820 CO     school 802490 480   BOULDER VALLEY RE 2 80249000100 872 BIRCH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 45 1 8   0 4     0   1   27 32                       59 45 1 8   0 4     0   1   27 32                 59
1932332 CO     school 802910 130   CHERRY CREEK 5 80291006544 4448 BLACK FOREST HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 53 6 13   1 7     0   10   51 39                       90 53 6 13   1 7     0   10   51 39                 90
1933426 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006409 875 BLACK ROCK ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 71 1 3   1 1     0   2   37 42                       79 71 1 3   1 1     0   2   37 42                 79
1938960 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001919 951 BLUE HERON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 44 0 17   1 4     0   2   39 29                       68 44 0 17   1 4     0   2   39 29                 68
1933435 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006381 878 BLUE MOUNTAIN ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 77 0 5   0 8     0   6   52 44                       96 77 0 5   0 8     0   6   52 44                 96

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