Data source: Big Local News · About: Big Local

7,620 rows where grade = "grade_1" and state = "CO" sorted by district_state_id

View and edit SQL

year

grade

  • grade_1 · 7,520
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
1139154 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 45.0 19.0 25.0   0.0 1.0     3.0   12.0   59.0 46.0                       105.0 45 19 25   0 1     3   12   59 46                 105
1139161 CO     school 804080 1000   FOUNTAIN 8 80408006330 3027 EAGLESIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 63.0 6.0 23.0   1.0 2.0     4.0   18.0   67.0 50.0                       117.0 63 6 23   1 2     4   18   67 50                 117
1139168 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 37.0 6.0 28.0   1.0 0.0     0.0   8.0   36.0 44.0                       80.0 37 6 28   1 0     0   8   36 44                 80
1139180 CO     school 804080 1000   FOUNTAIN 8 80408000564 3108 MESA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 40.0 5.0 27.0   0.0 1.0     1.0   10.0   47.0 37.0                       84.0 40 5 27   0 1     1   10   47 37                 84
1139193 CO     school 804080 1000   FOUNTAIN 8 80408001481 4474 JORDAHL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 46.0 3.0 15.0   0.0 0.0     1.0   10.0   43.0 32.0                       75.0 46 3 15   0 0     1   10   43 32                 75
1139201 CO     school 804080 1000   FOUNTAIN 8 80408000856 6138 MOUNTAINSIDE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 42.0 14.0 27.0   1.0 0.0     2.0   11.0   50.0 47.0                       97.0 42 14 27   1 0     2   11   50 47                 97
1139208 CO     school 804080 1000   FOUNTAIN 8 80408000565 6338 PATRIOT ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 61.0 14.0 27.0   0.0 2.0     5.0   11.0   66.0 54.0                       120.0 61 14 27   0 2     5   11   66 54                 120
1139215 CO     school 804080 1000   FOUNTAIN 8 80408006481 9610 WEIKEL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 64.0 18.0 19.0   0.0 0.0     1.0   13.0   59.0 56.0                       115.0 64 18 19   0 0     1   13   59 56                 115
1744436 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2021   grade_1 32 12 26   0 1     2   8   41 40                       81 32 12 26   0 1     2   8   41 40                 81
1744445 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2021   grade_1 53 4 23   0 1     2   15   47 51                       98 53 4 23   0 1     2   15   47 51                 98
1744452 CO     school 804080 1000   Fountain 8 80408000566 3102 Aragon Elementary School   Regular School No Elementary KG 05 2021   grade_1 32 6 14   1 0     1   6   19 41                       60 32 6 14   1 0     1   6   19 41                 60
1744463 CO     school 804080 1000   Fountain 8 80408000564 3108 Mesa Elementary School   Regular School No Elementary KG 05 2021   grade_1 42 9 19   1 2     1   10   46 38                       84 42 9 19   1 2     1   10   46 38                 84
1744475 CO     school 804080 1000   Fountain 8 80408001481 4474 Jordahl Elementary School   Regular School No Elementary KG 05 2021   grade_1 65 9 26   0 3     4   12   57 62                       119 65 9 26   0 3     4   12   57 62                 119
1744482 CO     school 804080 1000   Fountain 8 80408000856 6138 Mountainside Elementary School   Regular School No Elementary KG 05 2021   grade_1 37 14 28   3 0     0   8   49 41                       90 37 14 28   3 0     0   8   49 41                 90
1744489 CO     school 804080 1000   Fountain 8 80408000565 6338 Patriot Elementary School   Regular School No Elementary KG 05 2021   grade_1 57 15 14   0 6     1   13   55 51                       106 57 15 14   0 6     1   13   55 51                 106
1744496 CO     school 804080 1000   Fountain 8 80408006481 9610 Weikel Elementary School   Regular School No Elementary PK 05 2021   grade_1 67 7 19   1 2     2   10   46 62                       108 67 7 19   1 2     2   10   46 62                 108
1805516 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   grade_1 35 10 35   1 2     2   9   46 48                       94 35 10 35   1 2     2   9   46 48                 94
1805523 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2020   grade_1 51 10 11   2 2     4   21   51 50                       101 51 10 11   2 2     4   21   51 50                 101
1805530 CO     school 804080 1000   Fountain 8 80408000566 3102 Aragon Elementary School   Regular School No Elementary PK 05 2020   grade_1 35 7 19   0 1     0   8   32 38                       70 35 7 19   0 1     0   8   32 38                 70
1805542 CO     school 804080 1000   Fountain 8 80408000564 3108 Mesa Elementary School   Regular School No Elementary KG 05 2020   grade_1 55 4 17   0 1     1   11   43 46                       89 55 4 17   0 1     1   11   43 46                 89
1805554 CO     school 804080 1000   Fountain 8 80408001481 4474 Jordahl Elementary School   Regular School No Elementary KG 05 2020   grade_1 49 5 26   1 0     3   8   43 49                       92 49 5 26   1 0     3   8   43 49                 92
1805561 CO     school 804080 1000   Fountain 8 80408000856 6138 Mountainside Elementary School   Regular School No Elementary KG 05 2020   grade_1 52 11 20   2 1     1   13   58 42                       100 52 11 20   2 1     1   13   58 42                 100
1805568 CO     school 804080 1000   Fountain 8 80408000565 6338 Patriot Elementary School   Regular School No Elementary KG 05 2020   grade_1 56 14 30   0 2     3   12   61 56                       117 56 14 30   0 2     3   12   61 56                 117
1805575 CO     school 804080 1000   Fountain 8 80408006481 9610 Weikel Elementary School   Regular School No Elementary PK 05 2020   grade_1 75 13 20   1 3     1   6   50 69                       119 75 13 20   1 3     1   6   50 69                 119
1899845 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 47 15 21   0 2     0   10   46 49                       95 47 15 21   0 2     0   10   46 49                 95
1899854 CO     school 804080 1000   FOUNTAIN 8 80408006330 3027 EAGLESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 51 8 24   0 1     6   11   65 36                       101 51 8 24   0 1     6   11   65 36                 101
1899861 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 28 8 25   0 0     0   3   38 26                       64 28 8 25   0 0     0   3   38 26                 64
1899872 CO     school 804080 1000   FOUNTAIN 8 80408000564 3108 MESA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 40 5 20   0 4     3   11   46 37                       83 40 5 20   0 4     3   11   46 37                 83
1899884 CO     school 804080 1000   FOUNTAIN 8 80408001481 4474 JORDAHL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 49 5 25   1 0     0   14   44 50                       94 49 5 25   1 0     0   14   44 50                 94
1899891 CO     school 804080 1000   FOUNTAIN 8 80408000856 6138 MOUNTAINSIDE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 31 17 25   1 0     2   14   41 49                       90 31 17 25   1 0     2   14   41 49                 90
1899898 CO     school 804080 1000   FOUNTAIN 8 80408000565 6338 PATRIOT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 78 7 24   0 2     0   13   73 51                       124 78 7 24   0 2     0   13   73 51                 124
1899905 CO     school 804080 1000   FOUNTAIN 8 80408006481 9610 WEIKEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 50 22 21   1 1     2   9   49 57                       106 50 22 21   1 1     2   9   49 57                 106
1937222 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 62 16 16   1 0     1   15   53 58                       111 62 16 16   1 0     1   15   53 58                 111
1937231 CO     school 804080 1000   FOUNTAIN 8 80408006330 3027 EAGLESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 46 7 12   1 0     0   12   42 36                       78 46 7 12   1 0     0   12   42 36                 78
1937238 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 34 5 10   2 0     0   11   22 40                       62 34 5 10   2 0     0   11   22 40                 62
1937249 CO     school 804080 1000   FOUNTAIN 8 80408000564 3108 MESA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 64 5 11   1 0     2   16   52 47                       99 64 5 11   1 0     2   16   52 47                 99
1937261 CO     school 804080 1000   FOUNTAIN 8 80408001481 4474 JORDAHL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 47 11 13   1 0     1   11   48 36                       84 47 11 13   1 0     1   11   48 36                 84
1937268 CO     school 804080 1000   FOUNTAIN 8 80408000856 6138 MOUNTAINSIDE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 46 16 13   1 1     1   9   37 50                       87 46 16 13   1 1     1   9   37 50                 87
1937275 CO     school 804080 1000   FOUNTAIN 8 80408000565 6338 PATRIOT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 61 9 13   1 0     2   18   58 46                       104 61 9 13   1 0     2   18   58 46                 104
1937282 CO     school 804080 1000   FOUNTAIN 8 80408006481 9610 WEIKEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 64 10 11   1 1     2   11   59 41                       100 64 10 11   1 1     2   11   59 41                 100
714009 CO     school 803060 1010   COLORADO SPRINGS 11 80306000222 452 AUDUBON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 38 3 18   0 0     0   6   31 34                       65 38 3 18   0 0     0   6   31 34                 65
714017 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2017   grade_1 24 0 7   0 0     0   3   16 18                       34 24 0 7   0 0     0   3   16 18                 34
714033 CO     school 803060 1010   COLORADO SPRINGS 11 80306000224 1032 BRISTOL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 24 3 11   0 0     0   3   22 19                       41 24 3 11   0 0     0   3   22 19                 41
714040 CO     school 803060 1010   COLORADO SPRINGS 11 80306000225 1126 BUENA VISTA ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_1 25 0 7   0 1     0   2   18 17                       35 25 0 7   0 1     0   2   18 17                 35
714048 CO     school 803060 1010   COLORADO SPRINGS 11 80306000226 1340 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 37 9 9   0 1     1   1   26 32                       58 37 9 9   0 1     1   1   26 32                 58
714055 CO     school 803060 1010   COLORADO SPRINGS 11 80306001435 1613 CHIPETA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 58 3 5   0 6     0   7   42 37                       79 58 3 5   0 6     0   7   42 37                 79
714069 CO     school 803060 1010   COLORADO SPRINGS 11 80306006319 1625 MCAULIFFE ELEMENTARY   Regular School No Elementary PK 05 2017   grade_1 47 17 22   0 0     2   12   59 41                       100 47 17 22   0 0     2   12   59 41                 100
714077 CO     school 803060 1010   COLORADO SPRINGS 11 80306000227 1798 COLUMBIA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 24 6 16   0 0     1   4   24 27                       51 24 6 16   0 0     1   4   24 27                 51
714105 CO     school 803060 1010   COLORADO SPRINGS 11 80306000231 2510 EDISON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 19 2 22   0 0     0   4   24 23                       47 19 2 22   0 0     0   4   24 23                 47
714120 CO     school 803060 1010   COLORADO SPRINGS 11 80306006317 3175 FREEDOM ELEMENTARY SCHOOL   Special Education School No Elementary PK 05 2017   grade_1 46 2 8   0 1     1   3   32 29                       61 46 2 8   0 1     1   3   32 29                 61
714128 CO     school 803060 1010   COLORADO SPRINGS 11 80306000236 3218 FREMONT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 39 7 17   0 1     0   5   30 39                       69 39 7 17   0 1     0   5   30 39                 69
714139 CO     school 803060 1010   COLORADO SPRINGS 11 80306001318 3470 GLOBE CHARTER SCHOOL   Regular School Yes Elementary KG 06 2017   grade_1 18 3 5   1 1     0   1   17 12                       29 18 3 5   1 1     0   1   17 12                 29
714147 CO     school 803060 1010   COLORADO SPRINGS 11 80306000238 3592 GRANT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 36 6 33   0 2     0   13   48 42                       90 36 6 33   0 2     0   13   48 42                 90
714154 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 20 16 21   0 0     0   11   32 36                       68 20 16 21   0 0     0   11   32 36                 68
714162 CO     school 803060 1010   COLORADO SPRINGS 11 80306000240 3920 HENRY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 34 3 13   0 0     0   2   27 25                       52 34 3 13   0 0     0   2   27 25                 52
714178 CO     school 803060 1010   COLORADO SPRINGS 11 80306000243 4138 HOWBERT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 40 2 7   0 0     0   1   23 27                       50 40 2 7   0 0     0   1   23 27                 50
714186 CO     school 803060 1010   COLORADO SPRINGS 11 80306000245 4358 JACKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 24 3 25   1 1     0   7   33 28                       61 24 3 25   1 1     0   7   33 28                 61
714198 CO     school 803060 1010   COLORADO SPRINGS 11 80306000247 4530 KELLER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 36 8 30   0 0     0   5   38 41                       79 36 8 30   0 0     0   5   38 41                 79
714211 CO     school 803060 1010   COLORADO SPRINGS 11 80306000251 5404 MADISON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 28 0 14   0 1     0   6   25 24                       49 28 0 14   0 1     0   6   25 24                 49
714219 CO     school 803060 1010   COLORADO SPRINGS 11 80306000252 5576 TWAIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 23 9 30   1 0     0   7   36 34                       70 23 9 30   1 0     0   7   36 34                 70
714227 CO     school 803060 1010   COLORADO SPRINGS 11 80306001379 5604 KING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 34 6 8   0 0     0   5   31 22                       53 34 6 8   0 0     0   5   31 22                 53
714235 CO     school 803060 1010   COLORADO SPRINGS 11 80306001470 5610 MARTINEZ ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 48 2 12   0 3     0   7   30 42                       72 48 2 12   0 3     0   7   30 42                 72
714244 CO     school 803060 1010   COLORADO SPRINGS 11 80306000253 5878 MIDLAND ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 19 2 14   0 0     0   4   21 18                       39 19 2 14   0 0     0   4   21 18                 39
714256 CO     school 803060 1010   COLORADO SPRINGS 11 80306000255 5988 MONROE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 14 10 51   0 1     1   9   58 28                       86 14 10 51   0 1     1   9   58 28                 86
714273 CO     school 803060 1010   COLORADO SPRINGS 11 80306000258 6856 PENROSE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 29 5 20   0 0     0   9   37 26                       63 29 5 20   0 0     0   9   37 26                 63
714282 CO     school 803060 1010   COLORADO SPRINGS 11 80306000260 7228 QUEEN PALMER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 13 8 16   1 0     0   4   28 14                       42 13 8 16   1 0     0   4   28 14                 42
714289 CO     school 803060 1010   COLORADO SPRINGS 11 80306000262 7482 ROOSEVELT CHARTER ACADEMY   Regular School Yes Elementary KG 05 2017   grade_1 24 3 71   0 1     1   10   56 54                       110 24 3 71   0 1     1   10   56 54                 110
714296 CO     school 803060 1010   COLORADO SPRINGS 11 80306001274 7513 RUDY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 43 1 12   0 0     0   5   35 26                       61 43 1 12   0 0     0   5   35 26                 61
714312 CO     school 803060 1010   COLORADO SPRINGS 11 80306001641 7705 SCOTT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 67 6 19   0 2     0   8   55 47                       102 67 6 19   0 2     0   8   55 47                 102
714320 CO     school 803060 1010   COLORADO SPRINGS 11 80306000265 8246 STEELE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 34 0 11   1 0     0   2   19 29                       48 34 0 11   1 0     0   2   19 29                 48
714327 CO     school 803060 1010   COLORADO SPRINGS 11 80306000266 8346 STRATTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 35 0 9   0 0     0   3   29 18                       47 35 0 9   0 0     0   3   29 18                 47
714339 CO     school 803060 1010   COLORADO SPRINGS 11 80306000267 8466 TAYLOR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 21 2 15   1 1     0   5   24 21                       45 21 2 15   1 1     0   5   24 21                 45
714346 CO     school 803060 1010   COLORADO SPRINGS 11 80306001642 8902 TRAILBLAZER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 48 2 10   2 0     0   8   40 30                       70 48 2 10   2 0     0   8   40 30                 70
714358 CO     school 803060 1010   COLORADO SPRINGS 11 80306006416 9445 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 31 2 8   1 0     0   1   24 19                       43 31 2 8   1 0     0   1   24 19                 43
714365 CO     school 803060 1010   COLORADO SPRINGS 11 80306000274 9618 ROGERS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 27 14 39   0 0     0   7   41 46                       87 27 14 39   0 0     0   7   41 46                 87
714372 CO     school 803060 1010   COLORADO SPRINGS 11 80306000275 9660 WILSON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 25 7 31   0 2     0   2   34 33                       67 25 7 31   0 2     0   2   34 33                 67
841624 CO     school   1010   COLORADO SPRINGS 11   452 AUDUBON ELEMENTARY SCHOOL             2016   grade_1 37 2 9   0 0     0   2   24 26                       50 37 2 9   0 0     0   2   24 26                 50
841632 CO     school   1010   COLORADO SPRINGS 11   517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING             2016   grade_1 27 0 6   1 0     0   4   19 19                       38 27 0 6   1 0     0   4   19 19                 38
841648 CO     school 803060 1010   COLORADO SPRINGS 11 80306000224 1032 BRISTOL ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_1 25 1 6   1 0     0   3   20 16                       36 25 1 6   1 0     0   3   20 16                 36
841655 CO     school 803060 1010   COLORADO SPRINGS 11 80306000225 1126 BUENA VISTA ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_1 26 1 5   1 0     0   3   18 18                       36 26 1 5   1 0     0   3   18 18                 36
841664 CO     school 803060 1010   COLORADO SPRINGS 11 80306000226 1340 CARVER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_1 20 4 30   1 1     2   5   29 34                       63 20 4 30   1 1     2   5   29 34                 63
841671 CO     school 803060 1010   COLORADO SPRINGS 11 80306001435 1613 CHIPETA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 54 2 4   0 9     0   7   39 37                       76 54 2 4   0 9     0   7   39 37                 76
841684 CO     school 803060 1010   COLORADO SPRINGS 11 80306006319 1625 MCAULIFFE ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_1 53 13 26   0 0     1   11   62 42                       104 53 13 26   0 0     1   11   62 42                 104
841692 CO     school 803060 1010   COLORADO SPRINGS 11 80306000227 1798 COLUMBIA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 21 7 13   0 0     2   3   25 21                       46 21 7 13   0 0     2   3   25 21                 46
841720 CO     school 803060 1010   COLORADO SPRINGS 11 80306000231 2510 EDISON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 17 3 18   2 0     0   7   30 17                       47 17 3 18   2 0     0   7   30 17                 47
841735 CO     school 803060 1010   COLORADO SPRINGS 11 80306006317 3175 FREEDOM ELEMENTARY SCHOOL   Special Education School No 1.0 PK 05 2016   grade_1 48 4 13   0 3     2   9   47 32                       79 48 4 13   0 3     2   9   47 32                 79
841743 CO     school 803060 1010   COLORADO SPRINGS 11 80306000236 3218 FREMONT ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_1 39 9 25   1 1     0   2   49 28                       77 39 9 25   1 1     0   2   49 28                 77
841754 CO     school 803060 1010   COLORADO SPRINGS 11 80306001318 3470 GLOBE CHARTER SCHOOL   Regular School Yes 1.0 KG 06 2016   grade_1 20 2 3   0 1     0   3   15 14                       29 20 2 3   0 1     0   3   15 14                 29
841762 CO     school 803060 1010   COLORADO SPRINGS 11 80306000238 3592 GRANT ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_1 41 3 25   0 2     1   6   46 32                       78 41 3 25   0 2     1   6   46 32                 78
841769 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 HUNT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 22 16 27   3 0     0   3   41 30                       71 22 16 27   3 0     0   3   41 30                 71
841777 CO     school 803060 1010   COLORADO SPRINGS 11 80306000240 3920 HENRY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 25 3 19   2 0     0   8   34 23                       57 25 3 19   2 0     0   8   34 23                 57
841793 CO     school 803060 1010   COLORADO SPRINGS 11 80306000243 4138 HOWBERT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 25 0 14   0 3     0   5   20 27                       47 25 0 14   0 3     0   5   20 27                 47
841801 CO     school 803060 1010   COLORADO SPRINGS 11 80306000245 4358 JACKSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 36 5 29   1 1     0   5   46 31                       77 36 5 29   1 1     0   5   46 31                 77
841813 CO     school 803060 1010   COLORADO SPRINGS 11 80306000247 4530 KELLER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 55 1 19   0 1     1   4   36 45                       81 55 1 19   0 1     1   4   36 45                 81
841826 CO     school 803060 1010   COLORADO SPRINGS 11 80306000251 5404 MADISON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 32 4 19   0 0     0   3   31 27                       58 32 4 19   0 0     0   3   31 27                 58
841835 CO     school 803060 1010   COLORADO SPRINGS 11 80306000252 5576 TWAIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 30 9 27   2 0     0   5   39 34                       73 30 9 27   2 0     0   5   39 34                 73
841843 CO     school 803060 1010   COLORADO SPRINGS 11 80306001379 5604 KING ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 40 4 11   0 0     0   9   26 38                       64 40 4 11   0 0     0   9   26 38                 64
841851 CO     school 803060 1010   COLORADO SPRINGS 11 80306001470 5610 MARTINEZ ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 62 4 17   0 2     1   8   45 49                       94 62 4 17   0 2     1   8   45 49                 94
841860 CO     school 803060 1010   COLORADO SPRINGS 11 80306000253 5878 MIDLAND ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_1 16 3 14   0 0     0   4   23 14                       37 16 3 14   0 0     0   4   23 14                 37
841873 CO     school 803060 1010   COLORADO SPRINGS 11 80306000255 5988 MONROE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 21 7 55   0 0     0   5   49 39                       88 21 7 55   0 0     0   5   49 39                 88

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