Data source: Big Local News · About: Big Local

92,494 rows where state = "CO"

View and edit SQL

grade

year

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
710362 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006388 4333 IMAGINE CHARTER   Regular School Yes Elementary PK 08 2017   pk_12_total 472 4 83   0 11     4   9   285 298                       583 472 4 83   0 11     4   9   285 298                 583
710363 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006388 4333 IMAGINE CHARTER   Regular School Yes Elementary PK 08 2017   pre_kindergarten 18 0 0   0 1     0   1   13 7                       20 18 0 0   0 1     0   1   13 7                 20
710364 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_1 116 2 12   0 4     0   1   73 62                       135 116 2 12   0 4     0   1   73 62                 135
710365 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 79 0 10   0 7     0   5   57 44                       101 79 0 10   0 7     0   5   57 44                 101
710366 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_3 109 1 13   0 5     0   4   80 52                       132 109 1 13   0 5     0   4   80 52                 132
710367 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_4 96 1 17   0 2     0   2   66 52                       118 96 1 17   0 2     0   2   66 52                 118
710368 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_5 111 0 19   0 7     0   2   76 63                       139 111 0 19   0 7     0   2   76 63                 139
710369 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   kindergarten_full_day 53 1 7   0 6     0   4   35 36                       71 53 1 7   0 6     0   4   35 36                 71
710370 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   kindergarten_half_day 26 0 3   0 1     0   2   15 17                       32 26 0 3   0 1     0   2   15 17                 32
710371 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   pk_12_total 663 5 85   0 39     0   22   447 367                       814 663 5 85   0 39     0   22   447 367                 814
710372 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   pre_kindergarten 73 0 4   0 7     0   2   45 41                       86 73 0 4   0 7     0   2   45 41                 86
710373 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000909 5282 LONGMONT HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 200 4 125   2 8     1   7   174 173                       347 200 4 125   2 8     1   7   174 173                 347
710374 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000909 5282 LONGMONT HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 169 5 113   1 5     0   7   136 164                       300 169 5 113   1 5     0   7   136 164                 300
710375 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000909 5282 LONGMONT HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 184 6 74   5 4     0   3   137 139                       276 184 6 74   5 4     0   3   137 139                 276
710376 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000909 5282 LONGMONT HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 219 2 138   3 5     0   4   187 184                       371 219 2 138   3 5     0   4   187 184                 371
710377 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000909 5282 LONGMONT HIGH SCHOOL   Regular School No High 09 12 2017   pk_12_total 772 17 450   11 22     1   21   634 660                       1294 772 17 450   11 22     1   21   634 660                 1294
710378 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 41 0 14   0 0     0   1   36 20                       56 41 0 14   0 0     0   1   36 20                 56
710379 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 30 0 14   0 0     0   2   24 22                       46 30 0 14   0 0     0   2   24 22                 46
710380 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 44 1 9   0 2     0   6   30 32                       62 44 1 9   0 2     0   6   30 32                 62
710381 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 48 0 11   0 0     0   4   32 31                       63 48 0 11   0 0     0   4   32 31                 63
710382 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 49 1 15   0 3     0   1   33 36                       69 49 1 15   0 3     0   1   33 36                 69
710383 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 26 1 7   1 1     0   1   18 19                       37 26 1 7   1 1     0   1   18 19                 37
710384 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 6 0 0   0 0     0   0   5 1                       6 6 0 0   0 0     0   0   5 1                 6
710385 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 258 4 74   1 6     0   16   189 170                       359 258 4 74   1 6     0   16   189 170                 359
710386 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 14 1 4   0 0     0   1   11 9                       20 14 1 4   0 0     0   1   11 9                 20
710387 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 88 1 70   0 4     1   1   77 88                       165 88 1 70   0 4     1   1   77 88                 165
710388 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 104 0 81   0 1     0   5   97 94                       191 104 0 81   0 1     0   5   97 94                 191
710389 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 96 1 79   2 8     1   4   107 84                       191 96 1 79   2 8     1   4   107 84                 191
710390 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 288 2 230   2 13     2   10   281 266                       547 288 2 230   2 13     2   10   281 266                 547
710391 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000910 5288 LONGS PEAK MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_5 20 1 44   0 2     0   3   29 41                       70 20 1 44   0 2     0   3   29 41                 70
710392 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000910 5288 LONGS PEAK MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_6 37 2 71   1 0     0   0   52 59                       111 37 2 71   1 0     0   0   52 59                 111
710393 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000910 5288 LONGS PEAK MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 44 2 74   1 1     0   0   70 52                       122 44 2 74   1 1     0   0   70 52                 122
710394 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000910 5288 LONGS PEAK MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_8 38 4 70   1 0     0   3   54 62                       116 38 4 70   1 0     0   3   54 62                 116
710395 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000910 5288 LONGS PEAK MIDDLE SCHOOL   Regular School No Middle 05 08 2017   pk_12_total 139 9 259   3 3     0   6   205 214                       419 139 9 259   3 3     0   6   205 214                 419
710396 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 42 0 6   0 0     0   2   31 19                       50 42 0 6   0 0     0   2   31 19                 50
710397 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 50 0 4   0 0     0   1   28 27                       55 50 0 4   0 0     0   1   28 27                 55
710398 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 49 1 3   0 0     0   1   33 21                       54 49 1 3   0 0     0   1   33 21                 54
710399 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 52 1 3   0 0     0   0   25 31                       56 52 1 3   0 0     0   0   25 31                 56
710400 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 53 3 7   0 3     0   1   32 35                       67 53 3 7   0 3     0   1   32 35                 67
710401 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 30 0 3   0 1     0   2   15 21                       36 30 0 3   0 1     0   2   15 21                 36
710402 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
710403 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 302 5 28   0 4     0   7   179 167                       346 302 5 28   0 4     0   7   179 167                 346
710404 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000911 5364 LYONS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 21 0 2   0 0     0   0   12 11                       23 21 0 2   0 0     0   0   12 11                 23
710405 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_10 47 0 3   1 0     0   1   27 25                       52 47 0 3   1 0     0   1   27 25                 52
710406 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_11 64 0 4   1 5     1   4   32 47                       79 64 0 4   1 5     1   4   32 47                 79
710407 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_12 29 0 5   0 0     0   2   21 15                       36 29 0 5   0 0     0   2   21 15                 36
710408 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_6 59 0 5   0 0     0   0   33 31                       64 59 0 5   0 0     0   0   33 31                 64
710409 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 51 0 9   0 0     0   2   26 36                       62 51 0 9   0 0     0   2   26 36                 62
710410 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_8 60 0 7   0 0     0   3   40 30                       70 60 0 7   0 0     0   3   40 30                 70
710411 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_9 40 1 3   0 4     0   0   22 26                       48 40 1 3   0 4     0   0   22 26                 48
710412 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   pk_12_total 350 1 36   2 9     1   12   201 210                       411 350 1 36   2 9     1   12   201 210                 411
710413 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006423 5722 MEAD HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 211 1 47   0 9     2   1   138 133                       271 211 1 47   0 9     2   1   138 133                 271
710414 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006423 5722 MEAD HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 216 1 52   1 10     0   1   147 134                       281 216 1 52   1 10     0   1   147 134                 281
710415 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006423 5722 MEAD HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 158 0 47   0 6     2   0   112 101                       213 158 0 47   0 6     2   0   112 101                 213
710416 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006423 5722 MEAD HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 219 2 62   2 4     1   3   155 138                       293 219 2 62   2 4     1   3   155 138                 293
710417 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006423 5722 MEAD HIGH SCHOOL   Regular School No High 09 12 2017   pk_12_total 804 4 208   3 29     5   5   552 506                       1058 804 4 208   3 29     5   5   552 506                 1058
710418 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 78 0 12   0 0     0   0   45 45                       90 78 0 12   0 0     0   0   45 45                 90
710419 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 67 0 12   0 0     0   3   33 49                       82 67 0 12   0 0     0   3   33 49                 82
710420 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 66 0 9   0 0     0   3   29 49                       78 66 0 9   0 0     0   3   29 49                 78
710421 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 75 0 17   1 0     0   1   50 44                       94 75 0 17   1 0     0   1   50 44                 94
710422 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 65 0 13   0 0     0   2   34 46                       80 65 0 13   0 0     0   2   34 46                 80
710423 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 29 0 7   0 0     0   4   18 22                       40 29 0 7   0 0     0   4   18 22                 40
710424 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 28 0 4   1 1     0   2   19 17                       36 28 0 4   1 1     0   2   19 17                 36
710425 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 443 0 85   2 1     0   15   250 296                       546 443 0 85   2 1     0   15   250 296                 546
710426 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000914 5726 MEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 35 0 11   0 0     0   0   22 24                       46 35 0 11   0 0     0   0   22 24                 46
710427 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 132 0 15   0 0     0   2   70 79                       149 132 0 15   0 0     0   2   70 79                 149
710428 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 131 1 29   1 2     0   2   93 73                       166 131 1 29   1 2     0   2   93 73                 166
710429 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 145 1 29   1 4     0   0   87 93                       180 145 1 29   1 4     0   0   87 93                 180
710430 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 408 2 73   2 6     0   4   250 245                       495 408 2 73   2 6     0   4   250 245                 495
710431 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_1 8 2 70   0 0     0   0   42 38                       80 8 2 70   0 0     0   0   42 38                 80
710432 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_2 15 0 70   1 0     0   0   43 43                       86 15 0 70   1 0     0   0   43 43                 86
710433 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_3 8 0 81   1 1     0   1   48 44                       92 8 0 81   1 1     0   1   48 44                 92
710434 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_4 6 1 75   2 2     1   0   41 46                       87 6 1 75   2 2     1   0   41 46                 87
710435 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_5 15 2 95   2 0     1   1   64 52                       116 15 2 95   2 0     1   1   64 52                 116
710436 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_6 17 0 102   0 0     2   0   61 60                       121 17 0 102   0 0     2   0   61 60                 121
710437 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_7 9 1 106   1 4     0   2   70 53                       123 9 1 106   1 4     0   2   70 53                 123
710438 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_8 21 1 104   0 0     1   0   65 62                       127 21 1 104   0 0     1   0   65 62                 127
710439 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   kindergarten_full_day 14 1 79   1 1     0   1   48 49                       97 14 1 79   1 1     0   1   48 49                 97
710440 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   pk_12_total 116 8 831   9 8     5   7   514 470                       984 116 8 831   9 8     5   7   514 470                 984
710441 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   pre_kindergarten 3 0 49   1 0     0   2   32 23                       55 3 0 49   1 0     0   2   32 23                 55
710442 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_1 15 1 34   0 0     0   4   25 29                       54 15 1 34   0 0     0   4   25 29                 54
710443 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 21 1 28   0 0     0   2   24 28                       52 21 1 28   0 0     0   2   24 28                 52
710444 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_3 18 0 32   0 0     0   0   24 26                       50 18 0 32   0 0     0   0   24 26                 50
710445 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_4 19 0 40   0 1     0   2   27 35                       62 19 0 40   0 1     0   2   27 35                 62
710446 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   kindergarten_full_day 28 0 33   1 0     0   2   35 29                       64 28 0 33   1 0     0   2   35 29                 64
710447 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   pk_12_total 133 2 200   2 3     0   14   172 182                       354 133 2 200   2 3     0   14   172 182                 354
710448 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   pre_kindergarten 32 0 33   1 2     0   4   37 35                       72 32 0 33   1 2     0   4   37 35                 72
710449 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 50 1 3   0 1     0   3   31 27                       58 50 1 3   0 1     0   3   31 27                 58
710450 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 63 0 8   0 2     0   3   46 30                       76 63 0 8   0 2     0   3   46 30                 76
710451 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 57 3 6   1 3     0   1   35 36                       71 57 3 6   1 3     0   1   35 36                 71
710452 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 66 1 4   0 1     0   3   43 32                       75 66 1 4   0 1     0   3   43 32                 75
710453 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 75 3 5   1 2     0   2   47 41                       88 75 3 5   1 2     0   2   47 41                 88
710454 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 66 2 1   0 3     0   1   38 35                       73 66 2 1   0 3     0   1   38 35                 73
710455 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
710456 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 411 11 30   3 12     0   13   258 222                       480 411 11 30   3 12     0   13   258 222                 480
710457 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000917 6274 NIWOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 33 1 3   1 0     0   0   18 20                       38 33 1 3   1 0     0   0   18 20                 38
710458 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000918 6276 NIWOT HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 171 9 78   2 30     2   11   141 162                       303 171 9 78   2 30     2   11   141 162                 303
710459 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000918 6276 NIWOT HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 171 3 98   2 38     1   9   160 162                       322 171 3 98   2 38     1   9   160 162                 322
710460 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000918 6276 NIWOT HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 216 3 62   2 20     2   9   152 162                       314 216 3 62   2 20     2   9   152 162                 314
710461 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000918 6276 NIWOT HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 202 2 102   0 31     3   7   166 181                       347 202 2 102   0 31     3   7   166 181                 347

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