Data source: Big Local News · About: Big Local

1,104 rows where grade = "grade_4", state = "CO" and year = 2019 sorted by school_state_id

View and edit SQL

year

  • 2019 · 1,104

grade

  • grade_4 · 1,104
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▼ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1932686 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_4 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1935936 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_4 67 2 9   1 1     0   3   39 44                       83 67 2 9   1 1     0   3   39 44                 83
1935947 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 33 0 17   0 12     0   8   36 34                       70 33 0 17   0 12     0   8   36 34                 70
1931109 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 34 1 33   1 8     0   4   47 34                       81 34 1 33   1 8     0   4   47 34                 81
1943946 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_4 84 1 37   0 10     0   13   85 60                       145 84 1 37   0 10     0   13   85 60                 145
1932077 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 73 9 16   2 13     0   2   56 59                       115 73 9 16   2 13     0   2   56 59                 115
1937767 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 46 1 7   0 3     0   12   34 35                       69 46 1 7   0 3     0   12   34 35                 69
1937775 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 56 3 7   0 15     1   10   43 49                       92 56 3 7   0 15     1   10   43 49                 92
1942628 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 38 1 33   0 0     0   3   37 38                       75 38 1 33   0 0     0   3   37 38                 75
1938859 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 27 1 10   0 3     0   4   24 21                       45 27 1 10   0 3     0   4   24 21                 45
1943959 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2019   grade_4 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
1936691 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 14 1 31   1 0     0   1   23 25                       48 14 1 31   1 0     0   1   23 25                 48
1936700 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 51 0 7   1 0     0   0   26 33                       59 51 0 7   1 0     0   0   26 33                 59
1942276 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_4 14 0 1   0 0     0   1   8 8                       16 14 0 1   0 0     0   1   8 8                 16
1936921 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1943524 CO     school 804410 3120   GREELEY 6 80441001988 52 HEIMAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 47 0 67   0 2     0   3   69 50                       119 47 0 67   0 2     0   3   69 50                 119
1943532 CO     school 804410 3120   GREELEY 6 80441001989 53 WINOGRAD K-8 ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2019   grade_4 27 0 58   0 0     0   1   46 40                       86 27 0 58   0 0     0   1   46 40                 86
1943542 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2019   grade_4 16 10 116   0 0     0   0   77 65                       142 16 10 116   0 0     0   0   77 65                 142
1943416 CO     school 807350 3100   WINDSOR RE-4 80735001987 55 GRANDVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 77 1 14   0 0     0   2   45 49                       94 77 1 14   0 0     0   2   45 49                 94
1942102 CO     school 804110 2540   FOWLER R-4J 80411001981 56 FOWLER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_4 24 0 10   0 0     0   1   16 19                       35 24 0 10   0 0     0   1   16 19                 35
1941132 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 0 0 4   0 0     0   0   3 1                       4 0 0 4   0 0     0   0   3 1                 4
1931121 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 81 2 18   1 10     0   6   72 46                       118 81 2 18   1 10     0   6   72 46                 118
1933382 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001830 60 LEGACY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 65 2 20   1 3     0   0   57 34                       91 65 2 20   1 3     0   0   57 34                 91
1933390 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001832 61 ALPINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 51 0 32   0 3     0   5   44 47                       91 51 0 32   0 3     0   5   44 47                 91
1938798 CO     school 807080 1390   HUERFANO RE-1 80708001845 63 PEAKVIEW SCHOOL   Regular School No Elementary PK 08 2019   grade_4 11 0 18   1 0     0   0   15 15                       30 11 0 18   1 0     0   0   15 15                 30
1933399 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006530 71 ASPEN RIDGE PREPARATORY SCHOOL   Regular School Yes Elementary KG 08 2019   grade_4 56 0 11   1 4     0   2   40 34                       74 56 0 11   1 4     0   2   40 34                 74
1935958 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006760 79 ASCENT CLASSICAL ACADEMY   Regular School Yes Other KG 10 2019   grade_4 26 0 2   0 1     0   1   12 18                       30 26 0 2   0 1     0   1   12 18                 30
1943231 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2019   grade_4 22 0 7   0 1     0   2   17 15                       32 22 0 7   0 1     0   2   17 15                 32
1934564 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   grade_4 5 4 8   0 0     0   1   13 5                       18 5 4 8   0 0     0   1   13 5                 18
1938162 CO     school 803870 1110   DISTRICT 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2019   grade_4 21 3 8   1 0     0   6   16 23                       39 21 3 8   1 0     0   6   16 23                 39
1932089 CO     school 802910 130   CHERRY CREEK 5 80291006750 102 ALTITUDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 67 6 14   0 7     1   6   50 51                       101 67 6 14   0 7     1   6   50 51                 101
1938880 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006489 109 ARVADA K-8   Regular School No Elementary KG 08 2019   grade_4 11 2 29   2 0     0   1   22 23                       45 11 2 29   2 0     0   1   22 23                 45
1931967 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 57 2 141   1 0     0   5   102 104                       206 57 2 141   1 0     0   5   102 104                 206
1933413 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2019   grade_4 66 1 7   1 2     0   6   54 29                       83 66 1 7   1 2     0   6   54 29                 83
1932696 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_4 6 27 53   0 0     0   9   52 43                       95 6 27 53   0 0     0   9   52 43                 95
1935970 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006492 135 BEN FRANKLIN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_4 84 0 10   0 4     0   6   54 50                       104 84 0 10   0 4     0   6   54 50                 104
1940395 CO     school 803990 1550   POUDRE R-1 80399001717 146 RIDGEVIEW CLASSICAL CHARTER SCHOOLS   Regular School Yes Other KG 12 2019   grade_4 46 0 8   0 2     0   5   27 34                       61 46 0 8   0 2     0   5   27 34                 61
1938890 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 18 0 12   1 0     0   4   18 17                       35 18 0 12   1 0     0   4   18 17                 35
1931531 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 14 2 64   0 0     1   1   47 35                       82 14 2 64   0 0     1   1   47 35                 82
1942320 CO     school 805220 2660   LAMAR RE-2 80522000860 200 ALTA VISTA CHARTER SCHOOL   Regular School Yes Elementary KG 06 2019   grade_4 14 0 5   1 0     0   0   8 12                       20 14 0 5   1 0     0   0   8 12                 20
1932708 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2019   grade_4 15 18 20   0 0     0   3   26 30                       56 15 18 20   0 0     0   3   26 30                 56
1932719 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 6 8 72   2 0     0   1   46 43                       89 6 8 72   2 0     0   1   46 43                 89
1935985 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_4 232 0 20   1 47     0   23   165 158                       323 232 0 20   1 47     0   23   165 158                 323
1934572 CO     school 803360 880   DENVER COUNTY 1 80336000306 220 JOHN H. AMESSE ELEMENTARY   Regular School No Elementary PK 05 2019   grade_4 1 9 53   0 1     0   0   27 37                       64 1 9 53   0 1     0   0   27 37                 64
1940247 CO     school 803480 1520   DURANGO 9-R 80348001066 225 ANIMAS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 18 0 9   3 0     0   2   20 12                       32 18 0 9   3 0     0   2   20 12                 32
1932101 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 76 8 21   0 3     0   4   56 56                       112 76 8 21   0 3     0   4   56 56                 112
1932108 CO     school 802910 130   CHERRY CREEK 5 80291002032 243 COYOTE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 65 6 9   0 12     0   11   51 52                       103 65 6 9   0 12     0   11   51 52                 103
1934349 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000033 248 GUADALUPE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_4 2 0 11   0 0     0   0   7 6                       13 2 0 11   0 0     0   0   7 6                 13
1937804 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 40 2 5   1 3     0   1   28 24                       52 40 2 5   1 3     0   1   28 24                 52
1941356 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000597 262 APPLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 55 0 17   0 2     0   3   41 36                       77 55 0 17   0 2     0   3   41 36                 77
1936000 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006392 265 CLEAR SKY ELEMENTARY   Regular School No Elementary PK 06 2019   grade_4 90 2 19   0 1     0   3   61 54                       115 90 2 19   0 1     0   3   61 54                 115
1936010 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006368 266 GOLD RUSH ELEMENTARY   Regular School No Elementary PK 05 2019   grade_4 76 1 11   0 1     0   4   47 46                       93 76 1 11   0 1     0   4   47 46                 93
1931138 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 51 2 46   0 4     0   3   55 51                       106 51 2 46   0 4     0   3   55 51                 106
1943247 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 3 0 6   0 0     0   0   6 3                       9 3 0 6   0 0     0   0   6 3                 9
1932727 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 14 14 32   0 4     2   6   39 33                       72 14 14 32   0 4     2   6   39 33                 72
1932115 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 36 14 29   1 5     1   8   43 51                       94 36 14 29   1 5     1   8   43 51                 94
1936022 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001757 354 ARROWWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 30 1 11   0 5     1   1   23 26                       49 30 1 11   0 5     1   1   23 26                 49
1941368 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435002030 362 RIM ROCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 103 0 11   0 1     0   3   62 56                       118 103 0 11   0 1     0   3   62 56                 118
1941377 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435001992 363 PEAR PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 58 0 27   0 0     0   3   43 45                       88 58 0 27   0 0     0   3   43 45                 88
1934580 CO     school 803360 880   DENVER COUNTY 1 80336000307 388 ASBURY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 33 2 15   0 0     0   2   27 25                       52 33 2 15   0 0     0   2   27 25                 52
1934587 CO     school 803360 880   DENVER COUNTY 1 80336000420 408 VALDEZ ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 10 0 35   0 0     0   0   22 23                       45 10 0 35   0 0     0   0   22 23                 45
1934595 CO     school 803360 880   DENVER COUNTY 1 80336000309 418 ASHLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 6 10 26   0 0     0   1   27 16                       43 6 10 26   0 0     0   1   27 16                 43
1942286 CO     school 802280 2640   ASPEN 1 80228000045 428 ASPEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_4 108 0 15   0 2     1   1   67 60                       127 108 0 15   0 2     1   1   67 60                 127
1938505 CO     school 804260 1180   ROARING FORK RE-1 80426001505 429 CARBONDALE COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_4 12 0 4   0 0     0   0   7 9                       16 12 0 4   0 0     0   0   7 9                 16
1933804 CO     school 802490 480   BOULDER VALLEY RE 2 80249001758 441 ASPEN CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_4 62 1 10   0 7     0   3   42 41                       83 62 1 10   0 7     0   3   42 41                 83
1932123 CO     school 802910 130   CHERRY CREEK 5 80291001879 442 ASPEN CROSSING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 58 12 13   0 8     0   7   45 53                       98 58 12 13   0 8     0   7   45 53                 98
1937301 CO     school 803060 1010   COLORADO SPRINGS 11 80306000222 452 AUDUBON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 32 2 14   0 0     0   1   22 27                       49 32 2 14   0 0     0   1   22 27                 49
1932735 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_4 17 25 33   0 0     0   3   45 33                       78 17 25 33   0 0     0   3   45 33                 78
1932749 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2019   grade_4 35 8 15   0 14     0   4   38 38                       76 35 8 15   0 14     0   4   38 38                 76
1936718 CO     school 803540 910   EAGLE COUNTY RE 50 80354001530 471 AVON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 5 1 42   1 0     0   1   27 23                       50 5 1 42   1 0     0   1   27 23                 50
1942636 CO     school 806150 2700   PUEBLO COUNTY 70 80615001069 472 AVONDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 15 0 13   0 0     0   3   16 15                       31 15 0 13   0 0     0   3   16 15                 31
1940406 CO     school 803990 1550   POUDRE R-1 80399001727 477 ZACH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 87 1 8   0 10     0   13   70 49                       119 87 1 8   0 10     0   13   70 49                 119
1940414 CO     school 803990 1550   POUDRE R-1 80399001973 490 BACON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 69 0 10   0 1     0   2   33 49                       82 69 0 10   0 1     0   2   33 49                 82
1938908 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006643 491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL   Regular School Yes Elementary PK 05 2019   grade_4 52 1 18   1 0     0   2   36 38                       74 52 1 18   1 0     0   2   36 38                 74
1940423 CO     school 803990 1550   POUDRE R-1 80399006380 498 BETHKE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 89 0 8   0 2     1   2   52 50                       102 89 0 8   0 2     1   2   52 50                 102
1930980 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_4 6 2 44   0 0     0   0   26 26                       52 6 2 44   0 0     0   0   26 26                 52
1930990 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_4 9 1 36   0 1     0   1   28 20                       48 9 1 36   0 1     0   1   28 20                 48
1931004 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_4 5 1 50   0 1     0   2   29 30                       59 5 1 50   0 1     0   2   29 30                 59
1931015 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 2 0 20   0 0     0   1   10 13                       23 2 0 20   0 0     0   1   10 13                 23
1931024 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_4 7 0 43   1 1     0   1   28 25                       53 7 0 43   1 1     0   1   28 25                 53
1931035 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_4 11 2 37   0 0     1   0   25 26                       51 11 2 37   0 0     1   0   25 26                 51
1931044 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_4 5 1 39   0 0     0   1   20 26                       46 5 1 39   0 0     0   1   20 26                 46
1931053 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_4 3 3 41   0 4     0   3   27 27                       54 3 3 41   0 4     0   3   27 27                 54
1937309 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_4 25 0 7   1 0     0   2   19 16                       35 25 0 7   1 0     0   2   19 16                 35
1934603 CO     school 803360 880   DENVER COUNTY 1 80336000311 520 BARNUM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 4 2 63   0 0     0   0   38 31                       69 4 2 63   0 0     0   0   38 31                 69
1938169 CO     school 803870 1110   DISTRICT 49 80387002027 555 BANNING LEWIS RANCH ACADEMY   Regular School Yes Other KG 10 2019   grade_4 78 2 27   0 2     2   24   73 62                       135 78 2 27   0 2     2   24   73 62                 135
1938515 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_4 46 0 65   0 0     0   1   55 57                       112 46 0 65   0 0     0   1   55 57                 112
1941740 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309001093 609 BATTLE ROCK CHARTER SCHOOL   Regular School Yes Elementary KG 06 2019   grade_4 6 1 1   2 0     0   1   5 6                       11 6 1 1   2 0     0   1   5 6                 11
1940431 CO     school 803990 1550   POUDRE R-1 80399000519 612 BAUDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 67 3 17   0 2     1   1   44 47                       91 67 3 17   0 2     1   1   44 47                 91
1940351 CO     school 802400 1530   BAYFIELD 10 JT-R 80240000088 632 BAYFIELD INTERMEDIATE SCHOOL   Regular School No Elementary 03 05 2019   grade_4 96 1 17   1 1     0   6   68 54                       122 96 1 17   1 1     0   6   68 54                 122
1934611 CO     school 803360 880   DENVER COUNTY 1 80336000313 650 BEACH COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 1 0 32   0 1     0   0   17 17                       34 1 0 32   0 1     0   0   17 17                 34
1936032 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006159 651 BEAR CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 56 0 9   0 4     0   3   45 27                       72 56 0 9   0 4     0   3   45 27                 72
1933815 CO     school 802490 480   BOULDER VALLEY RE 2 80249000099 652 BEAR CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 58 0 3   0 6     0   5   39 33                       72 58 0 3   0 6     0   5   39 33                 72
1943973 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002018 653 STONE CREEK SCHOOL   Regular School Yes Elementary KG 08 2019   grade_4 23 0 14   0 1     0   2   19 21                       40 23 0 14   0 1     0   2   19 21                 40
1943983 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002033 655 HIGH POINT ACADEMY   Regular School Yes Elementary PK 08 2019   grade_4 9 25 38   2 2     0   0   38 38                       76 9 25 38   2 2     0   0   38 38                 76
1943994 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_4 21 0 8   0 1     0   2   17 15                       32 21 0 8   0 1     0   2   17 15                 32
1938917 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000696 660 BEAR CREEK K-8 SCHOOL   Regular School No Elementary KG 08 2019   grade_4 55 3 62   0 11     0   4   82 53                       135 55 3 62   0 11     0   4   82 53                 135
1940440 CO     school 803990 1550   POUDRE R-1 80399000520 678 BEATTIE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 39 0 9   1 0     0   5   26 28                       54 39 0 9   1 0     0   5   26 28                 54
1938180 CO     school 803870 1110   DISTRICT 49 80387006766 696 BENNETT RANCH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 34 2 12   1 0     0   0   28 21                       49 34 2 12   1 0     0   0   28 21                 49
1931592 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_4 33 3 45   0 0     0   2   38 45                       83 33 3 45   0 0     0   2   38 45                 83

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