Data source: Big Local News · About: Big Local

13,321 rows where state = "CO" and year = 2020 sorted by school

View and edit SQL

year

  • 2020 · 13,121
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
1807204 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_5 25 1 10   0 5     0   3   23 21                       44 25 1 10   0 5     0   3   23 21                 44
1807205 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 25 4 9   0 2     0   3   23 20                       43 25 4 9   0 2     0   3   23 20                 43
1807206 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day 2 0 2   0 0     0   0   4 0                       4 2 0 2   0 0     0   0   4 0                 4
1807207 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 225 14 97   1 25     0   19   208 173                       381 225 14 97   1 25     0   19   208 173                 381
1807208 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 42 3 6   0 4     0   3   35 23                       58 42 3 6   0 4     0   3   35 23                 58
1799479 CO     school 806900 20   Adams 12 Five Star Schools 80690006435 70 Adams12 Five Star Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total 52 3 135   0 15     0   2   121 86                       207 52 3 135   0 15     0   2   121 86                 207
1799480 CO     school 806900 20   Adams 12 Five Star Schools 80690006435 70 Adams12 Five Star Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 52 3 135   0 15     0   2   121 86                       207 52 3 135   0 15     0   2   121 86                 207
1807332 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   grade_10 30 0 9   0 1     0   1   23 18                       41 30 0 9   0 1     0   1   23 18                 41
1807333 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   grade_11 35 0 10   0 1     0   0   27 19                       46 35 0 10   0 1     0   0   27 19                 46
1807334 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   grade_12 19 1 5   0 0     0   0   11 14                       25 19 1 5   0 0     0   0   11 14                 25
1807335 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   grade_6 50 1 23   0 2     0   1   30 47                       77 50 1 23   0 2     0   1   30 47                 77
1807336 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   grade_7 47 1 13   1 2     0   5   42 27                       69 47 1 13   1 2     0   5   42 27                 69
1807337 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   grade_8 39 1 27   0 2     0   2   31 40                       71 39 1 27   0 2     0   2   31 40                 71
1807338 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   grade_9 47 0 16   0 0     0   4   36 31                       67 47 0 16   0 0     0   4   36 31                 67
1807339 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   pk_12_total 267 4 103   1 8     0   13   200 196                       396 267 4 103   1 8     0   13   200 196                 396
1807249 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   grade_1 50 1 10   0 0     0   4   29 36                       65 50 1 10   0 0     0   4   29 36                 65
1807250 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   grade_2 46 1 14   0 1     0   1   29 34                       63 46 1 14   0 1     0   1   29 34                 63
1807251 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   grade_3 43 0 19   0 1     0   1   27 37                       64 43 0 19   0 1     0   1   27 37                 64
1807252 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   grade_4 46 1 15   0 2     0   4   28 40                       68 46 1 15   0 2     0   4   28 40                 68
1807253 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   grade_5 52 2 20   1 1     0   2   37 41                       78 52 2 20   1 1     0   2   37 41                 78
1807254 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   kindergarten_full_day 34 0 7   0 2     0   3   18 28                       46 34 0 7   0 2     0   3   18 28                 46
1807255 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   kindergarten_half_day 24 0 4   0 0     0   1   15 14                       29 24 0 4   0 0     0   1   15 14                 29
1807256 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   pk_12_total 321 6 98   1 7     0   16   197 252                       449 321 6 98   1 7     0   16   197 252                 449
1807257 CO     school 804800 1420   Jefferson County R-1 80480006643 491 Addenbrooke Classical Grammar School   Regular School Yes Elementary PK 05 2020   pre_kindergarten 26 1 9   0 0     0   0   14 22                       36 26 1 9   0 0     0   0   14 22                 36
1799394 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_1 9 0 40   0 1     0   0   32 18                       50 9 0 40   0 1     0   0   32 18                 50
1799395 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_2 6 1 33   0 0     0   1   15 26                       41 6 1 33   0 0     0   1   15 26                 41
1799396 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_3 8 0 47   0 0     0   3   28 30                       58 8 0 47   0 0     0   3   28 30                 58
1799397 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_4 7 0 34   2 0     0   1   28 16                       44 7 0 34   2 0     0   1   28 16                 44
1799398 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_5 5 1 43   0 0     0   1   23 27                       50 5 1 43   0 0     0   1   23 27                 50
1799399 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_6 4 0 52   1 1     0   1   29 30                       59 4 0 52   1 1     0   1   29 30                 59
1799400 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   kindergarten_full_day 2 0 55   0 1     1   0   31 28                       59 2 0 55   0 1     1   0   31 28                 59
1799401 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   pk_12_total 44 3 365   3 4     1   8   212 216                       428 44 3 365   3 4     1   8   212 216                 428
1799402 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 3 1 61   0 1     0   1   26 41                       67 3 1 61   0 1     0   1   26 41                 67
1805201 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_1 6 0 1   0 0     0   0   4 3                       7 6 0 1   0 0     0   0   4 3                 7
1805202 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 0 1   0 0     0   0   4 0                       4 3 0 1   0 0     0   0   4 0                 4
1805203 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_3 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1805204 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_4 6 0 1   0 0     0   0   5 2                       7 6 0 1   0 0     0   0   5 2                 7
1805205 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_5 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1805206 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1805207 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 27 0 5   0 0     0   0   19 13                       32 27 0 5   0 0     0   0   19 13                 32
1805208 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 6 0 1   0 0     0   0   2 5                       7 6 0 1   0 0     0   0   2 5                 7
1805209 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_10 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3
1805210 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_6 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1805211 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_7 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
1805212 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1805213 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_9 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1805214 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   pk_12_total 11 0 1   0 0     0   0   6 6                       12 11 0 1   0 0     0   0   6 6                 12
1809401 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   grade_1 4 0 5   0 0     0   1   6 4                       10 4 0 5   0 0     0   1   6 4                 10
1809402 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   grade_2 4 0 6   0 0     0   0   7 3                       10 4 0 6   0 0     0   0   7 3                 10
1809403 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   grade_3 5 0 4   0 0     0   0   3 6                       9 5 0 4   0 0     0   0   3 6                 9
1809404 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   grade_4 4 0 5   0 0     0   0   3 6                       9 4 0 5   0 0     0   0   3 6                 9
1809405 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   grade_5 2 0 4   0 0     0   0   4 2                       6 2 0 4   0 0     0   0   4 2                 6
1809406 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 7 0 4   0 0     0   1   9 3                       12 7 0 4   0 0     0   1   9 3                 12
1809407 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 34 0 32   0 0     0   3   36 33                       69 34 0 32   0 0     0   3   36 33                 69
1809408 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 8 0 4   0 0     0   1   4 9                       13 8 0 4   0 0     0   1   4 9                 13
1809409 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_10 2 0 2   0 0     0   0   1 3                       4 2 0 2   0 0     0   0   1 3                 4
1809410 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_11 0 0 3   0 0     0   0   1 2                       3 0 0 3   0 0     0   0   1 2                 3
1809411 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_12 2 0 6   0 0     0   0   6 2                       8 2 0 6   0 0     0   0   6 2                 8
1809412 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_6 2 0 7   0 0     0   0   7 2                       9 2 0 7   0 0     0   0   7 2                 9
1809413 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_7 5 0 2   0 0     0   1   3 5                       8 5 0 2   0 0     0   1   3 5                 8
1809414 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_8 6 0 5   0 0     0   0   6 5                       11 6 0 5   0 0     0   0   6 5                 11
1809415 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_9 2 0 7   0 0     0   0   5 4                       9 2 0 7   0 0     0   0   5 4                 9
1809416 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   pk_12_total 19 0 32   0 0     0   1   29 23                       52 19 0 32   0 0     0   1   29 23                 52
1806086 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_10 242 10 47   1 15     0   32   179 168                       347 242 10 47   1 15     0   32   179 168                 347
1806087 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_11 253 10 47   0 8     1   22   171 170                       341 253 10 47   0 8     1   22   171 170                 341
1806088 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_12 247 11 47   2 15     0   27   176 173                       349 247 11 47   2 15     0   27   176 173                 349
1806089 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_9 263 15 49   1 18     0   20   189 177                       366 263 15 49   1 18     0   20   189 177                 366
1806090 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   pk_12_total 1005 46 190   4 56     1   101   715 688                       1403 1005 46 190   4 56     1   101   715 688                 1403
1811480 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_1 18 0 5   0 0     0   2   12 13                       25 18 0 5   0 0     0   2   12 13                 25
1811481 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_2 24 0 5   0 0     0   2   14 17                       31 24 0 5   0 0     0   2   14 17                 31
1811482 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_3 24 0 10   1 0     0   1   21 15                       36 24 0 10   1 0     0   1   21 15                 36
1811483 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_4 21 0 3   0 0     0   2   16 10                       26 21 0 3   0 0     0   2   16 10                 26
1811484 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_5 21 0 7   0 1     0   2   16 15                       31 21 0 7   0 1     0   2   16 15                 31
1811485 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_6 19 0 6   1 0     0   0   15 11                       26 19 0 6   1 0     0   0   15 11                 26
1811486 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_7 25 0 8   0 0     0   1   21 13                       34 25 0 8   0 0     0   1   21 13                 34
1811487 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_8 21 0 2   0 0     0   2   12 13                       25 21 0 2   0 0     0   2   12 13                 25
1811488 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   kindergarten_full_day 26 0 8   0 0     0   2   17 19                       36 26 0 8   0 0     0   2   17 19                 36
1811489 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   pk_12_total 208 0 57   2 1     0   16   148 136                       284 208 0 57   2 1     0   16   148 136                 284
1811490 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten 9 0 3   0 0     0   2   4 10                       14 9 0 3   0 0     0   2   4 10                 14
1811491 CO     school 802040 3030   Akron R-1 80204000025 90 Akron High School   Regular School No High 09 12 2020   grade_10 22 0 3   0 2     0   0   14 13                       27 22 0 3   0 2     0   0   14 13                 27
1811492 CO     school 802040 3030   Akron R-1 80204000025 90 Akron High School   Regular School No High 09 12 2020   grade_11 16 0 5   0 0     0   0   12 9                       21 16 0 5   0 0     0   0   12 9                 21
1811493 CO     school 802040 3030   Akron R-1 80204000025 90 Akron High School   Regular School No High 09 12 2020   grade_12 15 0 3   0 0     0   2   10 10                       20 15 0 3   0 0     0   2   10 10                 20
1811494 CO     school 802040 3030   Akron R-1 80204000025 90 Akron High School   Regular School No High 09 12 2020   grade_9 14 1 3   0 0     0   1   12 7                       19 14 1 3   0 0     0   1   12 7                 19
1811495 CO     school 802040 3030   Akron R-1 80204000025 90 Akron High School   Regular School No High 09 12 2020   pk_12_total 67 1 14   0 2     0   3   48 39                       87 67 1 14   0 2     0   3   48 39                 87
1807214 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_10 15 2 142   1 10     1   1   93 79                       172 15 2 142   1 10     1   1   93 79                 172
1807215 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_11 27 1 154   2 10     0   8   111 91                       202 27 1 154   2 10     0   8   111 91                 202
1807216 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_12 16 2 112   0 5     0   3   67 71                       138 16 2 112   0 5     0   3   67 71                 138
1807217 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_7 33 1 178   1 14     0   6   124 109                       233 33 1 178   1 14     0   6   124 109                 233
1807218 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_8 27 2 145   3 8     0   7   99 93                       192 27 2 145   3 8     0   7   99 93                 192
1807219 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_9 25 1 140   2 10     0   2   99 81                       180 25 1 140   2 10     0   2   99 81                 180
1807220 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   pk_12_total 143 9 871   9 57     1   27   593 524                       1117 143 9 871   9 57     1   27   593 524                 1117
1800288 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   grade_1 48 1 109   3 0     2   5   85 83                       168 48 1 109   3 0     2   5   85 83                 168
1800289 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   grade_2 44 2 118   2 0     0   3   103 66                       169 44 2 118   2 0     0   3   103 66                 169
1800290 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   grade_3 47 3 136   4 0     2   5   106 91                       197 47 3 136   4 0     2   5   106 91                 197
1800291 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   grade_4 64 2 131   2 1     0   6   101 105                       206 64 2 131   2 1     0   6   101 105                 206
1800292 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   grade_5 59 2 141   1 1     0   8   108 104                       212 59 2 141   1 1     0   8   108 104                 212
1800293 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 66 4 115   2 0     1   2   100 90                       190 66 4 115   2 0     1   2   100 90                 190
1800294 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 328 14 750   14 2     5   29   603 539                       1142 328 14 750   14 2     5   29   603 539                 1142
1800295 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2020   grade_10 44 1 94   1 2     1   3   76 70                       146 44 1 94   1 2     1   3   76 70                 146
1800296 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2020   grade_11 36 2 85   4 0     0   0   66 61                       127 36 2 85   4 0     0   0   66 61                 127

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