enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,236 ✖
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
719353 719353 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No Other KG 12 2017   grade_7 8 0 5   0 0     0   0   7 6                       13 8 0 5   0 0     0   0   7 6                 13
846921 846921 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No 4.0 KG 12 2016   grade_7 5 0 2   0 0     0   0   3 4                       7 5 0 2   0 0     0   0   3 4                 7
1144494 1144494 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No 4.0 KG 12 2015   grade_7 5.0 0.0 3.0   0.0 0.0     0.0   0.0   3.0 5.0                       8.0 5 0 3   0 0     0   0   3 5                 8
1905310 1905310 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2018   grade_7 3 0 3   0 0     0   2   4 4                       8 3 0 3   0 0     0   2   4 4                 8
1942668 1942668 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_7 2 0 11   0 0     0   1   6 8                       14 2 0 11   0 0     0   1   6 8                 14
1749783 1749783 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2021   grade_7 8 0 6   0 0     0   2   9 7                       16 8 0 6   0 0     0   2   9 7                 16
1810912 1810912 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_7 14 0 6   0 0     0   2   16 6                       22 14 0 6   0 0     0   2   16 6                 22
714550 714550 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2017   grade_7 13 1 0   0 0     0   1   5 10                       15 13 1 0   0 0     0   1   5 10                 15
842165 842165 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 10 0 4   0 0     0   1   9 6                       15 10 0 4   0 0     0   1   9 6                 15
1900463 1900463 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2018   grade_7 15 0 3   0 1     0   1   11 9                       20 15 0 3   0 1     0   1   11 9                 20
712690 712690 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 63 0 10   0 0     0   2   37 38                       75 63 0 10   0 0     0   2   37 38                 75
840322 840322 CO     school   900   DOUGLAS COUNTY RE 1   11 ACADEMY CHARTER SCHOOL             2016   grade_7 58 0 9   0 1     0   4   34 38                       72 58 0 9   0 1     0   4   34 38                 72
1137956 1137956 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_7 67.0 0.0 11.0   1.0 1.0     0.0   1.0   37.0 44.0                       81.0 67 0 11   1 1     0   1   37 44                 81
1898602 1898602 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_7 63 2 7   1 6     0   1   35 45                       80 63 2 7   1 6     0   1   35 45                 80
1935939 1935939 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_7 61 0 5   0 1     0   3   28 42                       70 61 0 5   0 1     0   3   28 42                 70
714023 714023 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2017   grade_7 24 0 2   2 0     0   1   13 16                       29 24 0 2   2 0     0   1   13 16                 29
841638 841638 CO     school   1010   COLORADO SPRINGS 11   517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING             2016   grade_7 23 0 0   1 3     0   1   19 9                       28 23 0 0   1 3     0   1   19 9                 28
1139245 1139245 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes 1.0 KG 08 2015   grade_7 30.0 0.0 2.0   0.0 0.0     0.0   1.0   20.0 13.0                       33.0 30 0 2   0 0     0   1   20 13                 33
1899935 1899935 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2018   grade_7 25 0 4   0 0     0   4   20 13                       33 25 0 4   0 0     0   4   20 13                 33
1937312 1937312 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_7 23 0 3   0 0     0   4   15 15                       30 23 0 3   0 0     0   4   15 15                 30
1932699 1932699 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_7 8 13 44   0 0     0   5   39 31                       70 8 13 44   0 0     0   5   39 31                 70
720629 720629 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_7 89 0 40   1 12     0   6   66 82                       148 89 0 40   1 12     0   6   66 82                 148
848197 848197 CO     school   8001   CHARTER SCHOOL INSTITUTE   15 ACADEMY OF CHARTER SCHOOLS             2016   grade_7 77 2 48   0 14     0   3   69 75                       144 77 2 48   0 14     0   3   69 75                 144
1145765 1145765 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes 4.0 PK 12 2015   grade_7 86.0 2.0 41.0   0.0 12.0     0.0   4.0   66.0 79.0                       145.0 86 2 41   0 12     0   4   66 79                 145
1906577 1906577 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2018   grade_7 84 1 40   1 17     0   2   78 67                       145 84 1 40   1 17     0   2   78 67                 145
1943949 1943949 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_7 87 1 42   1 10     0   3   66 78                       144 87 1 42   1 10     0   3   66 78                 144
707892 707892 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_7 8 1 44   0 1     0   1   31 24                       55 8 1 44   0 1     0   1   31 24                 55
835572 835572 CO     school   10   MAPLETON 1   505 ACHIEVE ACADEMY             2016   grade_7 8 0 46   0 1     0   1   28 28                       56 8 0 46   0 1     0   1   28 28                 56
1133295 1133295 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No 1.0 PK 08 2015   grade_7 5.0 1.0 48.0   0.0 3.0     1.0   0.0   28.0 30.0                       58.0 5 1 48   0 3     1   0   28 30                 58
1893755 1893755 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2018   grade_7 3 1 45   0 5     0   1   26 29                       55 3 1 45   0 5     0   1   26 29                 55
1931027 1931027 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_7 5 3 44   0 2     0   2   25 31                       56 5 3 44   0 2     0   2   25 31                 56
1897097 1897097 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No High 06 12 2018   grade_7 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
714005 714005 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Regular School No Other 06 12 2017   grade_7 10 0 4   0 0     0   2   8 8                       16 10 0 4   0 0     0   2   8 8                 16
841620 841620 CO     school   1010   COLORADO SPRINGS 11   269 ACHIEVE ONLINE             2016   grade_7 9 0 4   0 0     0   0   9 4                       13 9 0 4   0 0     0   0   9 4                 13
1139227 1139227 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Regular School No 4.0 06 12 2015   grade_7 14.0 0.0 4.0   0.0 0.0     0.0   1.0   11.0 8.0                       19.0 14 0 4   0 0     0   1   11 8                 19
1899917 1899917 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Regular School No High 06 12 2018   grade_7 14 0 8   0 0     0   1   13 10                       23 14 0 8   0 0     0   1   13 10                 23
1937294 1937294 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   grade_7 10 1 2   0 0     0   1   11 3                       14 10 1 2   0 0     0   1   11 3                 14
708352 708352 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 36 6 224   1 3     1   5   150 126                       276 36 6 224   1 3     1   5   150 126                 276
836010 836010 CO     school   30   ADAMS COUNTY 14   20 ADAMS CITY MIDDLE SCHOOL             2016   grade_7 38 6 212   3 1     0   3   149 114                       263 38 6 212   3 1     0   3   149 114                 263
1133726 1133726 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 29.0 7.0 215.0   2.0 2.0     0.0   5.0   135.0 125.0                       260.0 29 7 215   2 2     0   5   135 125                 260
1894223 1894223 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 25 7 231   3 0     0   6   153 119                       272 25 7 231   3 0     0   6   153 119                 272
1931513 1931513 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 29 2 234   5 2     0   3   140 135                       275 29 2 234   5 2     0   3   140 135                 275
715660 715660 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes Other 06 12 2017   grade_7 39 0 16   0 2     1   1   24 35                       59 39 0 16   0 2     1   1   24 35                 59
843263 843263 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes 4.0 06 12 2016   grade_7 25 0 12   0 0     0   1   21 17                       38 25 0 12   0 0     0   1   21 17                 38
1140862 1140862 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes 4.0 KG 12 2015   grade_7 13.0 0.0 10.0   0.0 0.0     0.0   0.0   7.0 16.0                       23.0 13 0 10   0 0     0   0   7 16                 23
1901578 1901578 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes High 06 12 2018   grade_7 46 0 10   0 0     0   2   27 31                       58 46 0 10   0 0     0   2   27 31                 58
1938994 1938994 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes High 06 12 2019   grade_7 52 2 22   0 3     0   4   39 44                       83 52 2 22   0 3     0   4   39 44                 83
1936928 1936928 CO     school 801980 960   AGATE 300 80198000021 48 AGATE JUNIOR SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
717816 717816 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 3 0 4   0 0     0   0   3 4                       7 3 0 4   0 0     0   0   3 4                 7
845388 845388 CO     school   1620   AGUILAR REORGANIZED 6   66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL             2016   grade_7 1 0 9   0 0     0   0   5 5                       10 1 0 9   0 0     0   0   5 5                 10
1142966 1142966 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 6.0 0.0 6.0   0.0 0.0     0.0   0.0   5.0 7.0                       12.0 6 0 6   0 0     0   0   5 7                 12
1903761 1903761 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2018   grade_7 3 0 7   0 0     0   0   7 3                       10 3 0 7   0 0     0   0   7 3                 10
1941141 1941141 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 8 0 6   0 0     0   0   7 7                       14 8 0 6   0 0     0   0   7 7                 14
710109 710109 CO     school 805250 290   LAS ANIMAS RE-1 80525006678 443 AIM GLOBAL   Regular School No Other 06 12 2017   grade_7 12 0 12   0 0     0   0   13 11                       24 12 0 12   0 0     0   0   13 11                 24
1896020 1896020 CO     school 805250 290   LAS ANIMAS RE-1 80525006678 443 AIM GLOBAL   Regular School No High 06 12 2018   grade_7 19 4 49   0 0     0   1   39 34                       73 19 4 49   0 0     0   1   39 34                 73
1933333 1933333 CO     school 805250 290   LAS ANIMAS RE-1 80525006678 443 AIM GLOBAL   Alternative School No High 06 12 2019   grade_7 43 3 79   0 1     0   1   64 63                       127 43 3 79   0 1     0   1   64 63                 127
1740639 1740639 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   grade_7 39 4 77   2 0     0   2   74 50                       124 39 4 77   2 0     0   2   74 50                 124
1801669 1801669 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_7 27 4 76   0 0     0   2   48 61                       109 27 4 76   0 0     0   2   48 61                 109
719914 719914 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 26 0 4   0 3     0   0   18 15                       33 26 0 4   0 3     0   0   18 15                 33
847484 847484 CO     school   3030   AKRON R-1   86 AKRON ELEMENTARY SCHOOL             2016   grade_7 20 0 5   0 0     0   1   15 11                       26 20 0 5   0 0     0   1   15 11                 26
1145055 1145055 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 15.0 0.0 3.0   0.0 0.0     0.0   2.0   10.0 10.0                       20.0 15 0 3   0 0     0   2   10 10                 20
1905859 1905859 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2018   grade_7 12 1 3   0 0     0   1   11 6                       17 12 1 3   0 0     0   1   11 6                 17
1943234 1943234 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2019   grade_7 23 0 3   0 0     0   3   15 14                       29 23 0 3   0 0     0   3   15 14                 29
715539 715539 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000691 108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 20 3 167   2 3     1   1   104 93                       197 20 3 167   2 3     1   1   104 93                 197
843144 843144 CO     school   1420   JEFFERSON COUNTY R-1   108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL             2016   grade_7 49 4 198   3 5     0   6   131 134                       265 49 4 198   3 5     0   6   131 134                 265
1901457 1901457 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000691 108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2018   grade_7 27 2 162   7 9     0   4   116 95                       211 27 2 162   7 9     0   4   116 95                 211
1938873 1938873 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000691 108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2019   grade_7 33 2 151   6 7     0   7   106 100                       206 33 2 151   6 7     0   7   106 100                 206
708796 708796 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_7 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
836442 836442 CO     school   100   ALAMOSA RE-11J   368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE             2016   grade_7 2 0 2   0 0     0   0   2 2                       4 2 0 2   0 0     0   0   2 2                 4
1134167 1134167 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative Education School No 4.0 06 12 2015   grade_7 0.0 0.0 4.0   0.0 0.0     0.0   0.0   0.0 4.0                       4.0 0 0 4   0 0     0   0   0 4                 4
1894684 1894684 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2018   grade_7 1 0 2   0 0     0   0   2 1                       3 1 0 2   0 0     0   0   2 1                 3
1931980 1931980 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
710197 710197 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 213 8 26   0 25     1   9   133 149                       282 213 8 26   0 25     1   9   133 149                 282
837834 837834 CO     school   470   ST VRAIN VALLEY RE 1J   226 ALTONA MIDDLE SCHOOL             2016   grade_7 193 2 30   0 21     0   7   127 126                       253 193 2 30   0 21     0   7   127 126                 253
1135529 1135529 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 188.0 2.0 36.0   1.0 24.0     0.0   5.0   129.0 127.0                       256.0 188 2 36   1 24     0   5   129 127                 256
1896109 1896109 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 203 2 31   1 30     1   8   150 126                       276 203 2 31   1 30     1   8   150 126                 276
1933422 1933422 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 179 7 41   1 29     0   14   140 131                       271 179 7 41   1 29     0   14   140 131                 271
712726 712726 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 125 2 16   0 17     0   8   83 85                       168 125 2 16   0 17     0   8   83 85                 168
840358 840358 CO     school   900   DOUGLAS COUNTY RE 1   215 AMERICAN ACADEMY             2016   grade_7 130 1 12   0 16     0   10   84 85                       169 130 1 12   0 16     0   10   84 85                 169
1137992 1137992 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes 1.0 PK 08 2015   grade_7 132.0 0.0 7.0   1.0 14.0     0.0   7.0   89.0 72.0                       161.0 132 0 7   1 14     0   7   89 72                 161
1898638 1898638 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2018   grade_7 127 1 13   1 22     0   6   70 100                       170 127 1 13   1 22     0   6   70 100                 170
1935988 1935988 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_7 180 3 16   1 26     0   15   112 129                       241 180 3 16   1 26     0   15   112 129                 241
710804 710804 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 118 5 92   1 8     0   10   133 101                       234 118 5 92   1 8     0   10   133 101                 234
838440 838440 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 145 2 92   0 11     0   3   144 109                       253 145 2 92   0 11     0   3   144 109                 253
1136132 1136132 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 111.0 2.0 96.0   1.0 6.0     0.0   9.0   123.0 102.0                       225.0 111 2 96   1 6     0   9   123 102                 225
1896701 1896701 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 92 1 101   1 4     0   10   116 93                       209 92 1 101   1 4     0   10   116 93                 209
1934033 1934033 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 118 1 81   3 8     0   10   116 105                       221 118 1 81   3 8     0   10   116 105                 221
711133 711133 CO     school 802130 580   SOUTH CONEJOS RE-10 80213001464 250 ANTONITO MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 1 0 17   0 0     0   1   6 13                       19 1 0 17   0 0     0   1   6 13                 19
838768 838768 CO     school   580   SOUTH CONEJOS RE-10   250 ANTONITO MIDDLE SCHOOL             2016   grade_7 1 0 9   1 0     0   0   5 6                       11 1 0 9   1 0     0   0   5 6                 11
1136459 1136459 CO     school 802130 580   SOUTH CONEJOS RE-10 80213001464 250 ANTONITO MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 1.0 0.0 17.0   0.0 0.0     0.0   0.0   5.0 13.0                       18.0 1 0 17   0 0     0   0   5 13                 18
1897023 1897023 CO     school 802130 580   SOUTH CONEJOS RE-10 80213001464 250 ANTONITO MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 0 0 11   0 0     0   0   5 6                       11 0 0 11   0 0     0   0   5 6                 11
1934355 1934355 CO     school 802130 580   SOUTH CONEJOS RE-10 80213001464 250 ANTONITO MIDDLE SCHOOL   Regular School No Middle 07 08 2019   grade_7 1 0 11   0 0     0   0   6 6                       12 1 0 11   0 0     0   0   6 6                 12
710191 710191 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2017   grade_7 40 0 7   0 2     0   2   29 22                       51 40 0 7   0 2     0   2   29 22                 51
837828 837828 CO     school   470   ST VRAIN VALLEY RE 1J   120 APEX HOME SCHOOL ENRICHMENT PROGRAM             2016   grade_7 63 1 5   1 1     0   2   36 37                       73 63 1 5   1 1     0   2   36 37                 73
1135523 1135523 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No 4.0 KG 12 2015   grade_7 37.0 0.0 4.0   0.0 1.0     0.0   1.0   18.0 25.0                       43.0 37 0 4   0 1     0   1   18 25                 43
1896103 1896103 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2018   grade_7 64 0 15   0 2     0   2   47 36                       83 64 0 15   0 2     0   2   47 36                 83
1933416 1933416 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2019   grade_7 43 0 6   0 0     0   1   29 21                       50 43 0 6   0 0     0   1   29 21                 50
719936 719936 CO     school 802220 3040   ARICKAREE R-2 80222000042 308 ARICKAREE UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 7 0 1   0 0     0   0   5 3                       8 7 0 1   0 0     0   0   5 3                 8
847506 847506 CO     school   3040   ARICKAREE R-2   308 ARICKAREE UNDIVIDED HIGH SCHOOL             2016   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1145077 1145077 CO     school 802220 3040   ARICKAREE R-2 80222000042 308 ARICKAREE UNDIVIDED HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 9.0 0.0 3.0   0.0 0.0     0.0   0.0   8.0 4.0                       12.0 9 0 3   0 0     0   0   8 4                 12

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