Data source: Big Local News · About: Big Local

1,082 rows where grade = "grade_2", state = "CO" and year = 2017 sorted by school_nces_id

View and edit SQL

year

  • 2017 · 1,082

grade

  • grade_2 · 1,082
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
711025 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100214 1608 CHEYENNE WELLS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 13 0 0   0 0     0   0   8 5                       13 13 0 0   0 0     0   0   8 5                 13
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
720562 CO     school 800016 3200   YUMA 1 80001601820 9795 KENNETH P MORRIS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 28 0 25   0 0     0   0   26 27                       53 28 0 25   0 0     0   0   26 27                 53
720573 CO     school 800017 3210   WRAY RD-2 80001701816 9725 WRAY ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 46 0 21   0 0     0   1   32 36                       68 46 0 21   0 0     0   1   32 36                 68
720590 CO     school 800018 3220   IDALIA RJ-3 80001801741 4227 IDALIA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 14 0 4   0 0     0   0   7 11                       18 14 0 4   0 0     0   0   7 11                 18
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
720726 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001569 2035 CROWN POINTE CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 22 0 26   0 3     0   1   30 22                       52 22 0 26   0 3     0   1   30 22                 52
720636 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
720790 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001780 4277 INDIAN PEAKS CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
720718 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001876 1882 COMMUNITY LEADERSHIP ACADEMY   Regular School Yes Elementary PK 05 2017   grade_2 1 0 80   1 0     0   0   40 42                       82 1 0 80   1 0     0   0   40 42                 82
720702 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001912 1791 COLORADO SPRINGS CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 36 2 7   0 1     0   3   22 27                       49 36 2 7   0 1     0   3   22 27                 49
720873 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001913 7512 ROSS MONTESSORI SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 35 0 12   1 0     0   0   25 23                       48 35 0 12   1 0     0   0   25 23                 48
720661 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001926 654 THE PINNACLE CHARTER SCHOOL ELEMENTARY   Regular School Yes Elementary KG 05 2017   grade_2 27 0 119   1 9     0   1   83 74                       157 27 0 119   1 9     0   1   83 74                 157
720679 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 T.R. PAUL ACADEMY OF ARTS & KNOWLEDGE   Regular School Yes Elementary KG 05 2017   grade_2 17 0 9   0 1     0   2   18 11                       29 17 0 9   0 1     0   2   18 11                 29
720651 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002018 653 STONE CREEK SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 23 0 13   0 1     0   2   19 20                       39 23 0 13   0 1     0   2   19 20                 39
720668 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002033 655 HIGH POINT ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 20 25 26   1 1     0   3   42 34                       76 20 25 26   1 1     0   3   42 34                 76
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
720863 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006320 7278 RICARDO FLORES MAGON ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 0 1 40   0 0     0   0   24 17                       41 0 1 40   0 0     0   0   24 17                 41
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
720778 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006503 3439 GLOBAL VILLAGE ACADEMY - NORTHGLENN   Regular School Yes Elementary KG 08 2017   grade_2 79 1 65   0 5     4   0   66 88                       154 79 1 65   0 5     4   0   66 88                 154
720757 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006586 3326 GLOBAL VILLAGE ACADEMY - COLORADO SPRINGS   Regular School Yes Elementary KG 08 2017   grade_2 29 3 31   0 1     0   6   36 34                       70 29 3 31   0 1     0   6   36 34                 70
720826 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006589 5851 MOUNTAIN SONG COMMUNITY SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 20 0 4   0 0     1   4   20 9                       29 20 0 4   0 0     1   4   20 9                 29
720799 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006595 4403 JAMES IRWIN CHARTER ACADEMY   Regular School Yes Elementary KG 05 2017   grade_2 33 7 11   0 0     0   4   20 35                       55 33 7 11   0 0     0   4   20 35                 55
720767 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006596 3399 GLOBAL VILLAGE ACADEMY - FORT COLLINS   Regular School Yes Elementary KG 08 2017   grade_2 31 1 27   1 1     0   9   28 42                       70 31 1 27   1 1     0   9   28 42                 70
720837 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006602 5957 MONTESSORI DEL MUNDO CHARTER SCHOOL   Regular School Yes Elementary PK 04 2017   grade_2 4 1 32   0 0     0   1   19 19                       38 4 1 32   0 0     0   1   19 19                 38
720894 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006635 8821 TWO RIVERS COMMUNITY SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 15 0 6   0 0     0   0   10 11                       21 15 0 6   0 0     0   0   10 11                 21
720883 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
720814 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006701 5423 MOUNTAIN VILLAGE MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 06 2017   grade_2 11 0 0   0 0     0   0   9 2                       11 11 0 0   0 0     0   0   9 2                 11
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
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
714573 CO     school 801920 1040   ACADEMY 20 80192000003 2248 DOUGLASS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 4 12   0 1     0   9   36 25                       61 35 4 12   0 1     0   9   36 25                 61
714585 CO     school 801920 1040   ACADEMY 20 80192000004 2524 EDITH WOLFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 40 0 4   0 1     0   3   29 19                       48 40 0 4   0 1     0   3   29 19                 48
714638 CO     school 801920 1040   ACADEMY 20 80192000005 6158 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 77 4 15   0 4     0   7   51 56                       107 77 4 15   0 4     0   7   51 56                 107
714681 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 43 1 11   0 0     0   4   32 27                       59 43 1 11   0 0     0   4   32 27                 59
714709 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 1 12   1 2     0   4   43 26                       69 49 1 12   1 2     0   4   43 26                 69
714510 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 44 0 6   1 2     0   1   24 30                       54 44 0 6   1 2     0   1   24 30                 54
714659 CO     school 801920 1040   ACADEMY 20 80192000531 7159 PRAIRIE HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 37 1 15   1 1     0   9   35 29                       64 37 1 15   1 1     0   9   35 29                 64
714603 CO     school 801920 1040   ACADEMY 20 80192001319 3104 FOOTHILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 50 0 15   0 1     0   6   41 31                       72 50 0 15   0 1     0   6   41 31                 72
714620 CO     school 801920 1040   ACADEMY 20 80192001320 3985 HIGH PLAINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 27 6 14   1 2     0   4   29 25                       54 27 6 14   1 2     0   4   29 25                 54
714611 CO     school 801920 1040   ACADEMY 20 80192001387 3238 FRONTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 39 1 8   0 1     0   8   30 27                       57 39 1 8   0 1     0   8   30 27                 57
714651 CO     school 801920 1040   ACADEMY 20 80192001430 6960 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 2 19   0 2     0   7   32 33                       65 35 2 19   0 2     0   7   32 33                 65
714594 CO     school 801920 1040   ACADEMY 20 80192001496 2800 EXPLORER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 59 0 12   1 0     0   4   47 29                       76 59 0 12   1 0     0   4   47 29                 76
714529 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2017   grade_2 275 3 23   1 9     0   15   166 160                       326 275 3 23   1 9     0   15   166 160                 326
714473 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 57 5 14   0 3     0   8   38 49                       87 57 5 14   0 3     0   8   38 49                 87
714481 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 73 2 7   0 12     0   9   51 52                       103 73 2 7   0 12     0   9   51 52                 103
714696 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 56 4 6   0 5     0   7   44 34                       78 56 4 6   0 5     0   7   44 34                 78
714521 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 104 9 20   0 5     0   15   75 78                       153 104 9 20   0 5     0   15   75 78                 153
714672 CO     school 801920 1040   ACADEMY 20 80192006336 7247 RANCH CREEK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 74 5 13   0 6     0   3   43 58                       101 74 5 13   0 6     0   3   43 58                 101
714545 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2017   grade_2 5 0 1   0 0     0   2   5 3                       8 5 0 1   0 0     0   2   5 3                 8
714559 CO     school 801920 1040   ACADEMY 20 80192006631 1929 DISCOVERY CANYON CAMPUS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 55 6 2   0 2     1   4   39 31                       70 55 6 2   0 2     1   4   39 31                 70
708368 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 19 2 62   0 1     1   1   49 37                       86 19 2 62   0 1     1   1   49 37                 86
708375 CO     school 801950 30   ADAMS COUNTY 14 80195000012 1426 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 10 2 62   2 0     0   0   37 39                       76 10 2 62   2 0     0   0   37 39                 76
708383 CO     school 801950 30   ADAMS COUNTY 14 80195000013 2308 DUPONT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 11 1 93   1 0     0   3   62 47                       109 11 1 93   1 0     0   3   62 47                 109
708394 CO     school 801950 30   ADAMS COUNTY 14 80195000016 4536 KEMP ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 10 1 69   2 0     0   1   44 39                       83 10 1 69   2 0     0   1   44 39                 83
708404 CO     school 801950 30   ADAMS COUNTY 14 80195000017 5982 MONACO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 13 2 54   0 0     0   0   39 30                       69 13 2 54   0 0     0   0   39 30                 69
708411 CO     school 801950 30   ADAMS COUNTY 14 80195000018 6534 HANSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 1 29   1 0     0   1   21 17                       38 6 1 29   1 0     0   1   21 17                 38
708419 CO     school 801950 30   ADAMS COUNTY 14 80195000019 7500 ROSE HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 18 1 52   1 0     0   3   43 32                       75 18 1 52   1 0     0   3   43 32                 75
717805 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 1 0 6   0 0     0   0   4 3                       7 1 0 6   0 0     0   0   4 3                 7
719909 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_2 26 0 8   0 0     0   0   19 15                       34 26 0 8   0 0     0   0   19 15                 34
708781 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 52 4 135   2 0     0   5   100 98                       198 52 4 135   2 0     0   5   100 98                 198
711126 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000033 248 GUADALUPE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 1 0 20   0 0     0   0   14 7                       21 1 0 20   0 0     0   0   14 7                 21
710011 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 49 0 58   3 0     0   1   64 47                       111 49 0 58   3 0     0   1   64 47                 111
719925 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 1 0 5   0 0     0   0   4 2                       6 1 0 5   0 0     0   0   4 2                 6
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
718980 CO     school 802280 2640   ASPEN 1 80228000045 428 ASPEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 99 0 12   0 2     1   1   56 59                       115 99 0 12   0 2     1   1   56 59                 115
718970 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 14 0 1   0 0     0   1   8 8                       16 14 0 1   0 0     0   1   8 8                 16
720492 CO     school 802310 3145   AULT-HIGHLAND RE-9 80231000049 3958 HIGHLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 55 0 23   0 0     0   0   41 37                       78 55 0 23   0 0     0   0   41 37                 78
709508 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 6 70   0 1     0   0   47 36                       83 6 6 70   0 1     0   0   47 36                 83
709554 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_2 2 6 30   0 8     0   3   26 23                       49 2 6 30   0 8     0   3   26 23                 49
709578 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No Elementary PK 08 2017   grade_2 5 12 32   0 0     0   3   30 22                       52 5 12 32   0 0     0   3   30 22                 52
709593 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000058 1948 CRAWFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 8 15 58   1 28     0   1   60 51                       111 8 15 58   1 28     0   1   60 51                 111
709609 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000059 2114 DARTMOUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 21 8 31   0 2     1   2   37 28                       65 21 8 31   0 2     1   2   37 28                 65
709621 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000061 2618 ELKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 4 23 94   0 5     1   7   77 57                       134 4 23 94   0 5     1   7   77 57                 134
709648 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000062 3272 FULTON ACADEMY OF EXCELLENCE   Regular School No Elementary PK 05 2017   grade_2 4 11 67   0 5     0   4   41 50                       91 4 11 67   0 5     0   4   41 50                 91
709686 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000066 4426 JEWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 12 18 31   0 3     0   4   33 35                       68 12 18 31   0 3     0   4   33 35                 68
709694 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000067 4646 KENTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 2 9 65   0 5     0   3   45 39                       84 2 9 65   0 5     0   3   45 39                 84
709702 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000068 4970 LANSING ELEMENTARY COMMUNITY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 22 31   0 1     0   4   33 31                       64 6 22 31   0 1     0   4   33 31                 64
709710 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000069 4973 LAREDO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 11 14 46   2 1     2   4   45 35                       80 11 14 46   2 1     2   4   45 35                 80
709731 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000070 5361 LYN KNOLL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 7 8 30   0 1     1   3   26 24                       50 7 8 30   0 1     1   3   26 24                 50
709741 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000072 6068 MONTVIEW MATH & HEALTH SCIENCES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 4 4 61   2 0     0   5   48 28                       76 4 4 61   2 0     0   5   48 28                 76
709782 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000075 6728 PARIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 1 15 52   0 6     0   0   36 38                       74 1 15 52   0 6     0   0   36 38                 74
709790 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000076 6758 PARK LANE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 13 43   1 3     1   3   34 36                       70 6 13 43   1 3     1   3   34 36                 70
709823 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000077 7558 SABLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 4 18 46   1 0     2   2   34 39                       73 4 18 46   1 0     2   2   34 39                 73
709839 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000078 7932 SIXTH AVENUE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 4 17 53   0 1     8   3   41 45                       86 4 17 53   0 1     8   3   41 45                 86
709881 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000080 9060 VAUGHN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 6 57   0 4     0   5   36 42                       78 6 6 57   0 4     0   5   36 42                 78
709905 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 10 59   0 1     0   3   48 34                       82 9 10 59   0 1     0   3   48 34                 82
709935 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000083 9514 WHEELING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 19 47   0 3     0   3   41 37                       78 6 19 47   0 3     0   3   41 37                 78
709943 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000085 9756 YALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 17 11 36   0 3     0   7   36 38                       74 17 11 36   0 3     0   7   36 38                 74
709873 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001294 9059 VASSAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 15 21 39   0 6     1   6   50 38                       88 15 21 39   0 6     1   6   50 38                 88
709601 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001295 2095 DALTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 31 21 29   0 1     0   8   40 50                       90 31 21 29   0 1     0   8   40 50                 90
709521 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 17 25 31   0 4     1   6   35 49                       84 17 25 31   0 4     1   6   35 49                 84
709676 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001323 4270 IOWA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 28 44   0 2     1   8   40 49                       89 6 28 44   0 2     1   8   40 49                 89
709856 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Elementary KG 05 2017   grade_2 15 22 51   0 4     2   6   52 48                       100 15 22 51   0 4     2   6   52 48                 100
709570 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001388 1470 CENTURY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 14 16 23   0 1     3   5   33 29                       62 14 16 23   0 1     3   5   33 29                 62
709831 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001432 7865 SIDE CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 25 25 38   0 6     0   8   39 63                       102 25 25 38   0 6     0   8   39 63                 102
709806 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2017   grade_2 32 4 6   0 8     1   3   22 32                       54 32 4 6   0 8     1   3   22 32                 54
709529 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 20 27 30   0 0     0   3   43 37                       80 20 27 30   0 0     0   3   43 37                 80
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
709753 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_2 39 10 29   0 1     0   6   50 35                       85 39 10 29   0 1     0   6   50 35                 85

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