Data source: Big Local News · About: Big Local

1,072 rows where grade = "grade_2", state = "CO" and year = 2016 sorted by white_int

View and edit SQL

year

  • 2016 · 1,072

grade

  • grade_2 · 1,072
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
837132 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_2 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
837200 CO     school   180   ADAMS-ARAPAHOE 28J   914 BOSTON K-8 SCHOOL             2016   grade_2 0 8 31   0 7     0   0   28 18                       46 0 8 31   0 7     0   0   28 18                 46
837427 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000075 6728 PARIS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 0 20 46   0 4     3   4   42 35                       77 0 20 46   0 4     3   4   42 35                 77
837642 CO     school 802700 190   BYERS 32J 80270006630 6241 COLORADO DIGITAL ACADEMY - ELEMENTARY   Regular School Yes 1.0 KG 06 2016   grade_2 0 5 54   0 0     0   0   31 28                       59 0 5 54   0 0     0   0   31 28                 59
838780 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 0 0 19   0 0     0   0   6 13                       19 0 0 19   0 0     0   0   6 13                 19
839379 CO     school 803360 880   DENVER COUNTY 1 80336001834 2789 ESCUELA TLATELOLCO SCHOOL   Regular School No 4.0 KG 12 2016   grade_2 0 1 2   0 0     0   1   0 4                       4 0 1 2   0 0     0   1   0 4                 4
839487 CO     school 803360 880   DENVER COUNTY 1 80336001739 3647 MARIE L. GREENWOOD ACADEMY   Regular School No 1.0 01 08 2016   grade_2 0 9 65   0 1     0   1   39 37                       76 0 9 65   0 1     0   1   39 37                 76
839659 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No 1.0 PK 05 2016   grade_2 0 39 7   0 0     0   1   24 23                       47 0 39 7   0 0     0   1   24 23                 47
839908 CO     school 803360 880   DENVER COUNTY 1 80336001576 6957 PIONEER CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_2 0 4 34   0 0     0   0   23 15                       38 0 4 34   0 0     0   0   23 15                 38
837979 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000904 4278 INDIAN PEAKS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 1 0 58   0 0     0   0   31 28                       59 1 0 58   0 0     0   0   31 28                 59
838379 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
838411 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838736 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative Education School No 4.0 KG 12 2016   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
839014 CO     school   880   DENVER COUNTY 1   540 BARRETT ELEMENTARY SCHOOL             2016   grade_2 1 14 11   0 0     0   0   19 7                       26 1 14 11   0 0     0   0   19 7                 26
839411 CO     school 803360 880   DENVER COUNTY 1 80336000351 3296 GARDEN PLACE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 1 1 51   0 0     0   1   28 26                       54 1 1 51   0 0     0   1   28 26                 54
839448 CO     school 803360 880   DENVER COUNTY 1 80336000355 3512 GOLDRICK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 1 2 88   0 5     0   0   51 45                       96 1 2 88   0 5     0   0   51 45                 96
839524 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 HARRINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 1 7 49   0 0     0   1   30 28                       58 1 7 49   0 0     0   1   30 28                 58
839726 CO     school 803360 880   DENVER COUNTY 1 80336006445 5608 MATHEMATICS AND SCIENCE LEADERSHIP ACADEMY   Regular School No 1.0 KG 05 2016   grade_2 1 0 44   0 0     0   0   21 24                       45 1 0 44   0 0     0   0   21 24                 45
839812 CO     school 803360 880   DENVER COUNTY 1 80336000387 6188 MUNROE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 1 4 87   0 1     1   0   54 40                       94 1 4 87   0 1     1   0   54 40                 94
839828 CO     school 803360 880   DENVER COUNTY 1 80336000388 6254 NEWLON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 1 2 88   0 0     0   1   47 45                       92 1 2 88   0 0     0   1   47 45                 92
840000 CO     school 803360 880   DENVER COUNTY 1 80336000400 7694 CHARLES M. SCHENCK (CMS) COMMUNITY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 1 0 56   0 1     0   0   32 26                       58 1 0 56   0 1     0   0   32 26                 58
840029 CO     school 803360 880   DENVER COUNTY 1 80336000407 8006 SMITH RENAISSANCE SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 1 18 30   0 0     0   4   29 24                       53 1 18 30   0 0     0   4   29 24                 53
840122 CO     school 803360 880   DENVER COUNTY 1 80336000414 8422 SWANSEA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 1 4 73   0 0     0   1   36 43                       79 1 4 73   0 0     0   1   36 43                 79
840160 CO     school 803360 880   DENVER COUNTY 1 80336006389 8909 TREVISTA AT HORACE MANN   Regular School No 1.0 PK 05 2016   grade_2 1 7 41   0 0     0   0   24 25                       49 1 7 41   0 0     0   0   24 25                 49
841157 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
845728 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000611 3350 GATEWAY SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
846561 CO     school 804290 2650   GRANADA RE-1 80429000592 3542 GRANADA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 1 0 8   0 0     0   0   4 5                       9 1 0 8   0 0     0   0   4 5                 9
835522 CO     school   10   MAPLETON 1   501 MONTEREY COMMUNITY SCHOOL             2016   grade_2 2 0 42   0 1     0   1   21 25                       46 2 0 42   0 1     0   1   21 25                 46
836318 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001236 3144 FRANCIS M. DAY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 0 62   0 0     0   1   32 33                       65 2 0 62   0 0     0   1   32 33                 65
836411 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001252 9462 WESTMINSTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 1 36   0 1     0   0   20 20                       40 2 1 36   0 1     0   0   20 20                 40
837687 CO     school 806090 240   PRITCHETT RE-3 80609001026 7174 PRITCHETT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
837720 CO     school 806990 260   VILAS RE-5 80699001805 9085 V.I.L.A.S. ONLINE SCHOOL   Regular School No 1.0 KG 08 2016   grade_2 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
837730 CO     school 806990 260   VILAS RE-5 80699001206 9090 VILAS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 2 0 1   0 0     0   0   1 2                       3 2 0 1   0 0     0   0   1 2                 3
838967 CO     school   880   DENVER COUNTY 1   99 ACADEMY 360             2016   grade_2 2 12 14   0 2     0   3   14 19                       33 2 12 14   0 2     0   3   14 19                 33
839022 CO     school   880   DENVER COUNTY 1   650 BEACH COURT ELEMENTARY SCHOOL             2016   grade_2 2 0 42   0 0     0   1   24 21                       45 2 0 42   0 0     0   1   24 21                 45
839108 CO     school 803360 880   DENVER COUNTY 1 80336000325 1528 CHELTENHAM ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 9 59   0 0     0   5   36 39                       75 2 9 59   0 0     0   5   36 39                 75
839145 CO     school 803360 880   DENVER COUNTY 1 80336000329 1816 COLUMBIAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 0 44   0 0     0   1   25 22                       47 2 0 44   0 0     0   1   25 22                 47
839153 CO     school 803360 880   DENVER COUNTY 1 80336000330 1846 COLUMBINE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 16 12   0 0     0   1   14 17                       31 2 16 12   0 0     0   1   14 17                 31
839431 CO     school 803360 880   DENVER COUNTY 1 80336000353 3426 GILPIN MONTESSORI PUBLIC SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 2 10 11   0 0     0   1   14 10                       24 2 10 11   0 0     0   1   14 10                 24
839496 CO     school 803360 880   DENVER COUNTY 1 80336006477 3655 GREENLEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 17 26   1 1     0   1   20 28                       48 2 17 26   1 1     0   1   20 28                 48
839568 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 2 10 63   0 0     0   3   39 39                       78 2 10 63   0 0     0   3   39 39                 78
839740 CO     school 803360 880   DENVER COUNTY 1 80336001635 5644 MAXWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 9 62   0 1     0   2   43 33                       76 2 9 62   0 1     0   2   43 33                 76
840007 CO     school 803360 880   DENVER COUNTY 1 80336000401 7698 SCHMITT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 5 42   0 6     0   0   25 30                       55 2 5 42   0 6     0   0   25 30                 55
840191 CO     school 803360 880   DENVER COUNTY 1 80336000421 9050 VALVERDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 1 51   0 1     0   0   31 24                       55 2 1 51   0 1     0   0   31 24                 55
840224 CO     school 803360 880   DENVER COUNTY 1 80336000424 9496 CASTRO ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 2 2 96   1 2     0   0   49 54                       103 2 2 96   1 2     0   0   49 54                 103
840729 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No 4.0 KG 12 2016   grade_2 2 0 2   0 0     0   1   3 2                       5 2 0 2   0 0     0   1   3 2                 5
843074 CO     school 807080 1390   HUERFANO RE-1 80708001211 3306 GARDNER ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 2 0 5   0 0     0   0   5 2                       7 2 0 5   0 0     0   0   5 2                 7
843751 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes 4.0 PK 12 2016   grade_2 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
843803 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No 4.0 PK 12 2016   grade_2 2 0 1   0 0     0   0   1 2                       3 2 0 1   0 0     0   0   1 2                 3
845422 CO     school 804980 1760   KIM REORGANIZED 88 80498000822 4690 KIM ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
845751 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435006498 3604 GRAND RIVER ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
847281 CO     school 806570 2820   SILVERTON 1 80657001136 7900 SILVERTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
847973 CO     school 804410 3120   GREELEY 6 80441006638 8467 SALIDA DEL SOL ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_2 2 0 88   0 0     0   0   47 43                       90 2 0 88   0 0     0   0   47 43                 90
835505 CO     school   10   MAPLETON 1   263 GLOBAL LEADERSHIP ACADEMY             2016   grade_2 3 0 44   0 0     0   0   25 22                       47 3 0 44   0 0     0   0   25 22                 47
835567 CO     school   10   MAPLETON 1   505 ACHIEVE ACADEMY             2016   grade_2 3 0 42   1 1     0   0   23 24                       47 3 0 42   1 1     0   0   23 24                 47
835875 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001185 6376 NORTH STAR ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 3 3 57   0 2     0   2   37 30                       67 3 3 57   0 2     0   2   37 30                 67
836382 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001246 7860 SHERRELWOOD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 3 1 35   0 0     0   0   21 18                       39 3 1 35   0 0     0   0   21 18                 39
837386 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000072 6068 MONTVIEW MATH & HEALTH SCIENCES ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 13 60   0 0     0   3   43 36                       79 3 13 60   0 0     0   3   43 36                 79
837466 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000077 7558 SABLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 24 64   2 8     2   3   54 52                       106 3 24 64   2 8     2   3   54 52                 106
837631 CO     school 802700 190   BYERS 32J 80270006548 3362 GREAT PLAINS ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 3 0 0   0 0     0   1   2 2                       4 3 0 0   0 0     0   1   2 2                 4
837745 CO     school 802760 270   CAMPO RE-6 80276000169 1248 CAMPO ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
838214 CO     school   480   BOULDER VALLEY RE 2   866 BOULDER EXPLORE             2016   grade_2 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
839326 CO     school 803360 880   DENVER COUNTY 1 80336000337 2364 EAGLETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 7 55   0 0     0   0   31 34                       65 3 7 55   0 0     0   0   31 34                 65
839748 CO     school 803360 880   DENVER COUNTY 1 80336001276 5685 MCGLONE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 15 82   0 1     4   1   53 53                       106 3 15 82   0 1     4   1   53 53                 106
839962 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes 1.0 PK 02 2016   grade_2 3 1 4   0 2     0   0   5 5                       10 3 1 4   0 2     0   0   5 5                 10
840057 CO     school 803360 880   DENVER COUNTY 1 80336006525 8131 OAKLAND ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_2 3 21 44   0 3     0   3   38 36                       74 3 21 44   0 3     0   3   38 36                 74
840098 CO     school 803360 880   DENVER COUNTY 1 80336000411 8232 STEDMAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 22 17   0 0     0   0   16 26                       42 3 22 17   0 0     0   0   16 26                 42
840168 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREPARATORY SCHOOL   Regular School Yes 1.0 KG 05 2016   grade_2 3 25 33   0 0     0   0   34 27                       61 3 25 33   0 0     0   0   34 27                 61
840283 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_2 3 6 53   0 0     0   1   29 34                       63 3 6 53   0 0     0   1   29 34                 63
840293 CO     school   890   DOLORES COUNTY RE NO.2   50 RICO ELEMENTARY SCHOOL             2016   grade_2 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3
845302 CO     school 803810 1570   ESTES PARK R-3 80381006426 2788 ESTES PARK OPTIONS SCHOOL   Alternative Education School No 4.0 KG 12 2016   grade_2 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
846459 CO     school 803840 2610   PARK COUNTY RE-2 80384001695 3681 GUFFEY CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_2 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
847208 CO     school 806300 2790   MOUNTAIN VALLEY RE 1 80630001414 6142 MOUNTAIN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 1 1   0 0     0   0   4 1                       5 3 1 1   0 0     0   0   4 1                 5
847264 CO     school 802850 2810   CENTER 26 JT 80285000177 1412 HASKIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 0 48   0 0     0   1   29 23                       52 3 0 48   0 0     0   1   29 23                 52
847908 CO     school 804410 3120   GREELEY 6 80441000646 5412 MADISON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 3 0 71   1 1     0   1   43 34                       77 3 0 71   1 1     0   1   43 34                 77
848173 CO     school 800019 3230   LIBERTY J-4 80001901743 5119 LIBERTY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
848397 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006320 7278 RICARDO FLORES MAGON ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_2 3 0 40   0 0     0   0   22 21                       43 3 0 40   0 0     0   0   22 21                 43
835587 CO     school   10   MAPLETON 1   507 ADVENTURE ELEMENTARY             2016   grade_2 4 0 38   0 0     0   2   21 23                       44 4 0 38   0 0     0   2   21 23                 44
836069 CO     school 801950 30   ADAMS COUNTY 14 80195000018 6534 HANSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 1 37   0 0     0   0   24 18                       42 4 1 37   0 0     0   0   24 18                 42
836311 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001235 2876 FAIRVIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 45   0 3     0   0   19 33                       52 4 0 45   0 3     0   0   19 33                 52
837238 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000058 1948 CRAWFORD ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 15 60   2 29     0   0   58 52                       110 4 15 60   2 29     0   0   58 52                 110
837286 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 4 12 55   1 0     1   0   44 29                       73 4 12 55   1 0     1   0   44 29                 73
838761 CO     school   580   SOUTH CONEJOS RE-10   248 GUADALUPE ELEMENTARY SCHOOL             2016   grade_2 4 0 11   1 0     0   0   11 5                       16 4 0 11   1 0     0   0   11 5                 16
838974 CO     school   880   DENVER COUNTY 1   220 AMESSE ELEMENTARY SCHOOL             2016   grade_2 4 18 63   1 0     1   2   45 44                       89 4 18 63   1 0     1   2   45 44                 89
838997 CO     school   880   DENVER COUNTY 1   418 ASHLEY ELEMENTARY SCHOOL             2016   grade_2 4 15 37   0 2     0   0   31 27                       58 4 15 37   0 2     0   0   31 27                 58
839055 CO     school 803360 880   DENVER COUNTY 1 80336000320 1106 BRYANT WEBSTER DUAL LANGUAGE ECE-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 4 0 48   0 0     0   0   23 29                       52 4 0 48   0 0     0   0   23 29                 52
839084 CO     school 803360 880   DENVER COUNTY 1 80336006449 1345 CESAR CHAVEZ ACADEMY DENVER   Regular School Yes 1.0 KG 08 2016   grade_2 4 1 36   0 0     0   0   18 23                       41 4 1 36   0 0     0   0   18 23                 41
839171 CO     school 803360 880   DENVER COUNTY 1 80336000332 1928 COWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 45   0 1     0   0   27 23                       50 4 0 45   0 1     0   0   27 23                 50
839314 CO     school 803360 880   DENVER COUNTY 1 80336000336 2258 DOULL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 79   0 2     0   1   48 38                       86 4 0 79   0 2     0   1   48 38                 86
839440 CO     school 803360 880   DENVER COUNTY 1 80336000354 3478 GODSMAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 74   0 1     0   2   42 39                       81 4 0 74   0 1     0   2   42 39                 81
839605 CO     school 803360 880   DENVER COUNTY 1 80336000368 4450 JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 52   0 3     0   2   28 33                       61 4 0 52   0 3     0   2   28 33                 61
839651 CO     school 803360 880   DENVER COUNTY 1 80336000371 4762 KNAPP ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 1 104   2 0     0   0   48 63                       111 4 1 104   2 0     0   0   48 63                 111
839670 CO     school 803360 880   DENVER COUNTY 1 80336006442 4795 KUNSMILLER CREATIVE ARTS ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 4 0 52   0 3     0   1   27 33                       60 4 0 52   0 3     0   1   27 33                 60
839709 CO     school 803360 880   DENVER COUNTY 1 80336001380 5578 MARRAMA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 21 51   0 5     2   6   43 46                       89 4 21 51   0 5     2   6   43 46                 89
840231 CO     school 803360 880   DENVER COUNTY 1 80336000426 9548 WHITTIER K-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 4 19 14   0 1     0   6   30 14                       44 4 19 14   0 1     0   6   30 14                 44
841055 CO     school   910   EAGLE COUNTY RE 50   471 AVON ELEMENTARY SCHOOL             2016   grade_2 4 2 36   1 0     0   1   24 20                       44 4 2 36   1 0     0   1   24 20                 44
841109 CO     school 803540 910   EAGLE COUNTY RE 50 80354006222 3710 GYPSUM ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 40   0 0     0   1   23 22                       45 4 0 40   0 0     0   1   23 22                 45
841118 CO     school 803540 910   EAGLE COUNTY RE 50 80354006366 4838 JUNE CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 40   2 0     0   1   23 24                       47 4 0 40   2 0     0   1   23 24                 47
843038 CO     school 804470 1360   GUNNISON WATERSHED RE1J 80447001507 5577 MARBLE CHARTER SCHOOL   Regular School Yes 4.0 KG 10 2016   grade_2 4 0 1   0 0     0   0   3 2                       5 4 0 1   0 0     0   0   3 2                 5
844417 CO     school 806930 1440   PLAINVIEW RE-2 80693001198 6992 PLAINVIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 1   0 0     0   0   2 3                       5 4 0 1   0 0     0   0   2 3                 5

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