Data source: Big Local News · About: Big Local

13,286 rows where state = "CO" and year = 2021 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2021 · 13,286
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
1738260 CO     school   10   Mapleton 1   0 Not a school             2021   grade_12 3 0 3   0 0     0   0   5 1                       6 3 0 3   0 0     0   0   5 1                 6
1738261 CO     school   10   Mapleton 1   0 Not a school             2021   pk_12_total 3 0 3   0 0     0   0   5 1                       6 3 0 3   0 0     0   0   5 1                 6
1739969 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_11 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
1739970 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_12 1 0 1   0 0     0   1   2 1                       3 1 0 1   0 0     0   1   2 1                 3
1739971 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_3 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
1739972 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_4 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1739973 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_6 1 0 1   0 0     0   2   3 1                       4 1 0 1   0 0     0   2   3 1                 4
1739974 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_7 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1739975 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_8 0 1 3   0 0     0   0   2 2                       4 0 1 3   0 0     0   0   2 2                 4
1739976 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_9 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1739977 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   pk_12_total 3 2 9   0 1     0   3   10 8                       18 3 2 9   0 1     0   3   10 8                 18
1741270 CO     school   480   Boulder Valley Re 2   3629 Children's House Preschool             2021   pk_12_total 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1741271 CO     school   480   Boulder Valley Re 2   3629 Children's House Preschool             2021   pre_kindergarten 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1743208 CO     school   890   Dolores County RE No.2   4771 Dove's Nest Early Care and Education Center             2021   pk_12_total 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
1743209 CO     school   890   Dolores County RE No.2   4771 Dove's Nest Early Care and Education Center             2021   pre_kindergarten 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
1744504 CO     school   1010   Colorado Springs 11   0 Not a school             2021   grade_12 8 0 1   0 0     0   0   3 6                       9 8 0 1   0 0     0   0   3 6                 9
1744505 CO     school   1010   Colorado Springs 11   0 Not a school             2021   pk_12_total 8 0 1   0 0     0   0   3 6                       9 8 0 1   0 0     0   0   3 6                 9
1746074 CO     school   1390   Huerfano Re-1   8421 Spanish Peaks Child Care Center             2021   pk_12_total 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1746075 CO     school   1390   Huerfano Re-1   8421 Spanish Peaks Child Care Center             2021   pre_kindergarten 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1746112 CO     school   1420   Jefferson County R-1   0 Not a school             2021   grade_11 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1746113 CO     school   1420   Jefferson County R-1   0 Not a school             2021   grade_12 7 0 2   0 1     0   0   3 7                       10 7 0 2   0 1     0   0   3 7                 10
1746114 CO     school   1420   Jefferson County R-1   0 Not a school             2021   pk_12_total 7 0 3   0 1     0   0   3 8                       11 7 0 3   0 1     0   0   3 8                 11
1747581 CO     school   1550   Poudre R-1   0 Not a school             2021   grade_11 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1747582 CO     school   1550   Poudre R-1   0 Not a school             2021   pk_12_total 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1749499 CO     school   2690   Pueblo City 60   0 Not a school             2021   grade_11 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1749500 CO     school   2690   Pueblo City 60   0 Not a school             2021   grade_12 17 1 18   1 0     0   0   17 20                       37 17 1 18   1 0     0   0   17 20                 37
1749501 CO     school   2690   Pueblo City 60   0 Not a school             2021   pk_12_total 17 1 19   1 0     0   0   17 21                       38 17 1 19   1 0     0   0   17 21                 38
1751539 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_10 11 5 9   0 1     0   1   25 2                       27 11 5 9   0 1     0   1   25 2                 27
1751540 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_11 13 2 15   0 2     0   1   28 5                       33 13 2 15   0 2     0   1   28 5                 33
1751541 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_12 9 3 9   0 0     0   1   16 6                       22 9 3 9   0 0     0   1   16 6                 22
1751542 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_7 3 1 1   0 0     0   0   5 0                       5 3 1 1   0 0     0   0   5 0                 5
1751543 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_8 5 1 2   0 1     0   0   9 0                       9 5 1 2   0 1     0   0   9 0                 9
1751544 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_9 7 8 14   0 0     0   2   27 4                       31 7 8 14   0 0     0   2   27 4                 31
1751545 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   pk_12_total 48 20 50   0 4     0   5   110 17                       127 48 20 50   0 4     0   5   110 17                 127
1742043 CO     school 803360 880   Denver County 1 80336000331 1908 Cory Elementary School   Regular School No Elementary 01 05 2021   grade_1 53 4 8   0 2     0   8   37 38                       75 53 4 8   0 2     0   8   37 38                 75
1742044 CO     school 803360 880   Denver County 1 80336000331 1908 Cory Elementary School   Regular School No Elementary 01 05 2021   grade_2 62 2 6   0 5     0   6   42 39                       81 62 2 6   0 5     0   6   42 39                 81
1742045 CO     school 803360 880   Denver County 1 80336000331 1908 Cory Elementary School   Regular School No Elementary 01 05 2021   grade_3 60 2 6   0 3     0   11   41 41                       82 60 2 6   0 3     0   11   41 41                 82
1742046 CO     school 803360 880   Denver County 1 80336000331 1908 Cory Elementary School   Regular School No Elementary 01 05 2021   grade_4 62 1 9   0 2     0   5   40 39                       79 62 1 9   0 2     0   5   40 39                 79
1742047 CO     school 803360 880   Denver County 1 80336000331 1908 Cory Elementary School   Regular School No Elementary 01 05 2021   grade_5 58 3 5   0 3     0   9   43 35                       78 58 3 5   0 3     0   9   43 35                 78
1742048 CO     school 803360 880   Denver County 1 80336000331 1908 Cory Elementary School   Regular School No Elementary 01 05 2021   pk_12_total 295 12 34   0 15     0   39   203 192                       395 295 12 34   0 15     0   39   203 192                 395
1742061 CO     school 803360 880   Denver County 1 80336001767 2027 Polaris Elementary School   Regular School No Elementary 01 05 2021   grade_1 28 3 6   0 2     0   8   28 19                       47 28 3 6   0 2     0   8   28 19                 47
1742062 CO     school 803360 880   Denver County 1 80336001767 2027 Polaris Elementary School   Regular School No Elementary 01 05 2021   grade_2 39 2 2   1 4     0   4   30 22                       52 39 2 2   1 4     0   4   30 22                 52
1742063 CO     school 803360 880   Denver County 1 80336001767 2027 Polaris Elementary School   Regular School No Elementary 01 05 2021   grade_3 50 0 9   1 5     0   10   45 30                       75 50 0 9   1 5     0   10   45 30                 75
1742064 CO     school 803360 880   Denver County 1 80336001767 2027 Polaris Elementary School   Regular School No Elementary 01 05 2021   grade_4 57 5 5   0 1     0   9   44 33                       77 57 5 5   0 1     0   9   44 33                 77
1742065 CO     school 803360 880   Denver County 1 80336001767 2027 Polaris Elementary School   Regular School No Elementary 01 05 2021   grade_5 63 3 8   0 5     0   2   39 42                       81 63 3 8   0 5     0   2   39 42                 81
1742066 CO     school 803360 880   Denver County 1 80336001767 2027 Polaris Elementary School   Regular School No Elementary 01 05 2021   pk_12_total 237 13 30   2 17     0   33   186 146                       332 237 13 30   2 17     0   33   186 146                 332
1742318 CO     school 803360 880   Denver County 1 80336001864 3340 Lena Archuleta Elementary School   Regular School No Elementary 01 05 2021   grade_1 3 11 60   0 5     2   1   42 40                       82 3 11 60   0 5     2   1   42 40                 82
1742319 CO     school 803360 880   Denver County 1 80336001864 3340 Lena Archuleta Elementary School   Regular School No Elementary 01 05 2021   grade_2 2 10 63   0 2     2   4   39 44                       83 2 10 63   0 2     2   4   39 44                 83
1742320 CO     school 803360 880   Denver County 1 80336001864 3340 Lena Archuleta Elementary School   Regular School No Elementary 01 05 2021   grade_3 4 12 73   0 5     1   4   51 48                       99 4 12 73   0 5     1   4   51 48                 99
1742321 CO     school 803360 880   Denver County 1 80336001864 3340 Lena Archuleta Elementary School   Regular School No Elementary 01 05 2021   grade_4 3 11 81   0 1     3   4   57 46                       103 3 11 81   0 1     3   4   57 46                 103
1742322 CO     school 803360 880   Denver County 1 80336001864 3340 Lena Archuleta Elementary School   Regular School No Elementary 01 05 2021   grade_5 3 13 78   0 2     0   0   54 42                       96 3 13 78   0 2     0   0   54 42                 96
1742323 CO     school 803360 880   Denver County 1 80336001864 3340 Lena Archuleta Elementary School   Regular School No Elementary 01 05 2021   pk_12_total 15 57 355   0 15     8   13   243 220                       463 15 57 355   0 15     8   13   243 220                 463
1749096 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2021   grade_1 17 4 33   0 0     0   1   31 24                       55 17 4 33   0 0     0   1   31 24                 55
1749097 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2021   grade_2 10 4 33   0 0     0   0   21 26                       47 10 4 33   0 0     0   0   21 26                 47
1749098 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2021   grade_3 17 2 37   0 0     0   1   34 23                       57 17 2 37   0 0     0   1   34 23                 57
1749099 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2021   grade_4 13 1 48   0 1     0   2   33 32                       65 13 1 48   0 1     0   2   33 32                 65
1749100 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2021   grade_5 14 3 46   0 0     0   1   34 30                       64 14 3 46   0 0     0   1   34 30                 64
1749101 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2021   pk_12_total 71 14 197   0 1     0   5   153 135                       288 71 14 197   0 1     0   5   153 135                 288
1749102 CO     school 804050 2405   Fort Morgan Re-3 80405000556 1850 Columbine Elementary School   Regular School No Elementary 01 05 2021   grade_1 39 0 51   0 1     0   0   51 40                       91 39 0 51   0 1     0   0   51 40                 91
1749103 CO     school 804050 2405   Fort Morgan Re-3 80405000556 1850 Columbine Elementary School   Regular School No Elementary 01 05 2021   grade_2 27 4 34   1 1     0   1   30 38                       68 27 4 34   1 1     0   1   30 38                 68
1749104 CO     school 804050 2405   Fort Morgan Re-3 80405000556 1850 Columbine Elementary School   Regular School No Elementary 01 05 2021   grade_3 24 1 50   1 1     0   0   40 37                       77 24 1 50   1 1     0   0   40 37                 77
1749105 CO     school 804050 2405   Fort Morgan Re-3 80405000556 1850 Columbine Elementary School   Regular School No Elementary 01 05 2021   grade_4 27 0 54   0 2     0   1   41 43                       84 27 0 54   0 2     0   1   41 43                 84
1749106 CO     school 804050 2405   Fort Morgan Re-3 80405000556 1850 Columbine Elementary School   Regular School No Elementary 01 05 2021   grade_5 11 2 42   0 0     0   2   27 30                       57 11 2 42   0 0     0   2   27 30                 57
1749107 CO     school 804050 2405   Fort Morgan Re-3 80405000556 1850 Columbine Elementary School   Regular School No Elementary 01 05 2021   pk_12_total 128 7 231   2 5     0   4   189 188                       377 128 7 231   2 5     0   4   189 188                 377
1749117 CO     school 804050 2405   Fort Morgan Re-3 80405000558 3620 Green Acres Elementary School   Regular School No Elementary 01 05 2021   grade_1 28 1 40   0 0     0   0   40 29                       69 28 1 40   0 0     0   0   40 29                 69
1749118 CO     school 804050 2405   Fort Morgan Re-3 80405000558 3620 Green Acres Elementary School   Regular School No Elementary 01 05 2021   grade_2 25 3 33   0 0     0   0   24 37                       61 25 3 33   0 0     0   0   24 37                 61
1749119 CO     school 804050 2405   Fort Morgan Re-3 80405000558 3620 Green Acres Elementary School   Regular School No Elementary 01 05 2021   grade_3 28 1 28   0 0     0   2   24 35                       59 28 1 28   0 0     0   2   24 35                 59
1749120 CO     school 804050 2405   Fort Morgan Re-3 80405000558 3620 Green Acres Elementary School   Regular School No Elementary 01 05 2021   grade_4 27 1 32   1 0     0   1   34 28                       62 27 1 32   1 0     0   1   34 28                 62
1749121 CO     school 804050 2405   Fort Morgan Re-3 80405000558 3620 Green Acres Elementary School   Regular School No Elementary 01 05 2021   grade_5 19 0 26   0 0     0   0   23 22                       45 19 0 26   0 0     0   0   23 22                 45
1749122 CO     school 804050 2405   Fort Morgan Re-3 80405000558 3620 Green Acres Elementary School   Regular School No Elementary 01 05 2021   pk_12_total 127 6 159   1 0     0   3   145 151                       296 127 6 159   1 0     0   3   145 151                 296
1749128 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2021   grade_1 5 5 47   2 1     0   1   31 30                       61 5 5 47   2 1     0   1   31 30                 61
1749129 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2021   grade_2 10 4 32   0 0     0   0   22 24                       46 10 4 32   0 0     0   0   22 24                 46
1749130 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2021   grade_3 15 11 37   0 0     0   1   33 31                       64 15 11 37   0 0     0   1   33 31                 64
1749131 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2021   grade_4 13 5 50   1 0     0   0   36 33                       69 13 5 50   1 0     0   0   36 33                 69
1749132 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2021   grade_5 14 7 51   1 0     0   2   43 32                       75 14 7 51   1 0     0   2   43 32                 75
1749133 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2021   pk_12_total 57 32 217   4 1     0   4   165 150                       315 57 32 217   4 1     0   4   165 150                 315
1749966 CO     school 805760 2740   Monte Vista C-8 80576000985 6036 Bill Metz Elementary School   Regular School No Elementary 01 05 2021   grade_1 26 0 62   3 1     0   1   51 42                       93 26 0 62   3 1     0   1   51 42                 93
1749967 CO     school 805760 2740   Monte Vista C-8 80576000985 6036 Bill Metz Elementary School   Regular School No Elementary 01 05 2021   grade_2 14 0 62   1 0     0   1   44 34                       78 14 0 62   1 0     0   1   44 34                 78
1749968 CO     school 805760 2740   Monte Vista C-8 80576000985 6036 Bill Metz Elementary School   Regular School No Elementary 01 05 2021   grade_3 17 1 39   1 0     0   0   33 25                       58 17 1 39   1 0     0   0   33 25                 58
1749969 CO     school 805760 2740   Monte Vista C-8 80576000985 6036 Bill Metz Elementary School   Regular School No Elementary 01 05 2021   grade_4 12 0 50   1 0     0   0   34 29                       63 12 0 50   1 0     0   0   34 29                 63
1749970 CO     school 805760 2740   Monte Vista C-8 80576000985 6036 Bill Metz Elementary School   Regular School No Elementary 01 05 2021   grade_5 22 0 63   1 0     0   2   39 49                       88 22 0 63   1 0     0   2   39 49                 88
1749971 CO     school 805760 2740   Monte Vista C-8 80576000985 6036 Bill Metz Elementary School   Regular School No Elementary 01 05 2021   pk_12_total 91 1 276   7 1     0   4   201 179                       380 91 1 276   7 1     0   4   201 179                 380
1745384 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2021   grade_2 16 0 1   0 0     0   1   11 7                       18 16 0 1   0 0     0   1   11 7                 18
1745385 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2021   grade_3 31 2 8   0 0     0   5   20 26                       46 31 2 8   0 0     0   5   20 26                 46
1745386 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2021   grade_4 17 0 4   0 0     0   2   10 13                       23 17 0 4   0 0     0   2   10 13                 23
1745387 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2021   grade_5 25 1 7   0 0     0   4   17 20                       37 25 1 7   0 0     0   4   17 20                 37
1745388 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2021   pk_12_total 89 3 20   0 0     0   12   58 66                       124 89 3 20   0 0     0   12   58 66                 124
1745920 CO     school 804380 1220   Garfield 16 80438000630 3578 Bea Underwood Elementary School   Regular School No Elementary 02 05 2021   grade_2 57 1 36   1 0     0   3   54 44                       98 57 1 36   1 0     0   3   54 44                 98
1745921 CO     school 804380 1220   Garfield 16 80438000630 3578 Bea Underwood Elementary School   Regular School No Elementary 02 05 2021   grade_3 37 2 38   0 0     0   3   45 35                       80 37 2 38   0 0     0   3   45 35                 80
1745922 CO     school 804380 1220   Garfield 16 80438000630 3578 Bea Underwood Elementary School   Regular School No Elementary 02 05 2021   grade_4 47 0 29   0 0     0   2   46 32                       78 47 0 29   0 0     0   2   46 32                 78
1745923 CO     school 804380 1220   Garfield 16 80438000630 3578 Bea Underwood Elementary School   Regular School No Elementary 02 05 2021   grade_5 43 0 37   0 0     0   4   49 35                       84 43 0 37   0 0     0   4   49 35                 84
1745924 CO     school 804380 1220   Garfield 16 80438000630 3578 Bea Underwood Elementary School   Regular School No Elementary 02 05 2021   pk_12_total 184 3 140   1 0     0   12   194 146                       340 184 3 140   1 0     0   12   194 146                 340
1739231 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   grade_3 42 0 89   1 0     0   2   85 49                       134 42 0 89   1 0     0   2   85 49                 134
1739232 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   grade_4 31 0 107   0 0     2   5   83 62                       145 31 0 107   0 0     2   5   83 62                 145
1739233 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   grade_5 47 0 106   0 1     0   6   76 84                       160 47 0 106   0 1     0   6   76 84                 160
1739234 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   pk_12_total 120 0 302   1 1     2   13   244 195                       439 120 0 302   1 1     2   13   244 195                 439
1739329 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2021   grade_3 8 1 53   1 3     0   3   31 38                       69 8 1 53   1 3     0   3   31 38                 69
1739330 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2021   grade_4 10 1 54   1 0     0   3   37 32                       69 10 1 54   1 0     0   3   37 32                 69
1739331 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2021   grade_5 10 3 62   0 1     0   1   38 39                       77 10 3 62   0 1     0   1   38 39                 77
1739332 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2021   grade_6 15 5 73   0 3     0   3   47 52                       99 15 5 73   0 3     0   3   47 52                 99

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