Data source: Big Local News · About: Big Local

391 rows where grade = "grade_2", state = "ID" and year = 2017 sorted by school

View and edit SQL

year

  • 2017 · 391

grade

  • grade_2 · 391
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
1728672 ID     school 1602220 281   MOSCOW DISTRICT 160222000390 756 A B MCDONALD ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 56 0 3   0 1     0   1   30 31             24         61 56 0 3   0 1     0   1   30 31         24       61
1726971 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000252 415 A H BUSH ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 33 1 20   1 0     0   0   24 31             47         55 33 1 20   1 0     0   0   24 31         47       55
1726508 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 45 0 1   1 0     0   0   25 22             30         47 45 0 1   1 0     0   0   25 22         30       47
1726682 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 47 1 7   1 0     0   0   26 30             29         56 47 1 7   1 0     0   0   26 30         29       56
1726661 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 21 0 36   1 0     0   1   34 25             46         59 21 0 36   1 0     0   1   34 25         46       59
1728990 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000380 786 ACEQUIA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 32 0 18   0 0     0   1   25 26             *         51 32 0 18   0 0     0   1   25 26                 51
1725713 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 47 0 3   0 0     0   1   23 28             6         51 47 0 3   0 0     0   1   23 28         6       51
1728909 ID     school 1601920 321   MADISON DISTRICT 160192000333 777 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2017   grade_2 61 0 6   0 0     0   1   31 37             30         68 61 0 6   0 0     0   1   31 37         30       68
1727804 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1727766 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1726746 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000908 636 ALTURAS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 12 0 61   0 1     0   0   41 33             44         74 12 0 61   0 1     0   0   41 33         44       74
1730196 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Elementary KG 6.0 2017   grade_2 34 0 4   1 0     0   2   16 25             *         41 34 0 4   1 0     0   2   16 25                 41
1730075 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_2 24 0 1   0 0     0   1   10 16             5         26 24 0 1   0 0     0   1   10 16         5       26
1725625 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 64 0 8   0 0     1   2   33 42             27         75 64 0 8   0 0     1   2   33 42         27       75
1727100 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000167 426 AMMON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 38 0 7   0 1     0   1   23 24             24         47 38 0 7   0 1     0   1   23 24         24       47
1730009 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12.0 2017   grade_2 9 0 1   0 0     0   1   7 4             6         11 9 0 1   0 0     0   1   7 4         6       11
1730162 ID     school 1600360 492   ANSER OF IDAHO, INC. 160036000758 819 ANSER CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_2 34 0 3   0 0     0   0   15 22             5         37 34 0 3   0 0     0   0   15 22         5       37
1729346 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1727274 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000007 439 ARCO ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 26 0 3   0 0     1   3   20 13             *         33 26 0 3   0 0     1   3   20 13                 33
1728065 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000200 701 ASHTON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 34 0 4   0 0     0   0   20 18             21         38 34 0 4   0 0     0   0   20 18         21       38
1728543 ID     school 1601800 272   LAKELAND DISTRICT 160180000309 747 ATHOL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 37 0 0   0 0     1   2   25 15             24         40 37 0 0   0 0     1   2   25 15         24       40
1728463 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 119 0 8   0 1     0   3   60 71             55         131 119 0 8   0 1     0   3   60 71         55       131
1726042 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2017   grade_2 48 1 18   1 0     0   3   30 41             28         71 48 1 18   1 0     0   3   30 41         28       71
1729657 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000356 837 BARBARA R MORGAN ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 55 0 11   0 0     0   0   35 31             30         66 55 0 11   0 0     0   0   35 31         30       66
1726780 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 19 0 0   0 0     0   0   11 8             *         19 19 0 0   0 0     0   0   11 8                 19
1726725 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000033 394 BELLEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 27 0 11   0 0     0   4   20 22             18         42 27 0 11   0 0     0   4   20 22         18       42
1728511 ID     school 1601800 272   LAKELAND DISTRICT 160180000295 513 BETTY KIEFER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 46 0 2   0 0     0   4   27 25             18         52 46 0 2   0 0     0   4   27 25         18       52
1729493 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000548 828 BICKEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 23 1 15   1 5     0   1   24 22             *         46 23 1 15   1 5     0   1   24 22                 46
1727621 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000778 519 BIRCH ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 74 0 27   0 0     0   4   57 48             56         105 74 0 27   0 0     0   4   57 48         56       105
1730020 ID     school 1600153 477   BLACKFOOT CHARTER COMMUNITY LEARNING CENTER, INC. 160015300796 1294 BLACKFOOT CHARTER COMMUNITY   Regular School Yes Elementary PK 8.0 2017   grade_2 61 2 12   3 0     0   2   43 37             41         80 61 2 12   3 0     0   2   43 37         41       80
1728185 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2017   grade_2 4 0 4   0 0     0   0   4 4             *         8 4 0 4   0 0     0   0   4 4                 8
1727169 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2017   grade_2 10 0 0   0 0     0   0   6 4             *         10 10 0 0   0 0     0   0   6 4                 10
1728442 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000146 735 BORAH ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 45 0 3   1 0     0   4   23 30             *         53 45 0 3   1 0     0   4   23 30                 53
1727719 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1728738 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000578 771 BOVILL ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 13 0 0   0 0     0   0   8 5             7         13 13 0 0   0 0     0   0   8 5         7       13
1727212 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 43 0 27   0 0     0   2   42 30             43         72 43 0 27   0 0     0   2   42 30         43       72
1729211 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 6 0 5   0 0     0   0   7 4             *         11 6 0 5   0 0     0   0   7 4                 11
1728470 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000147 741 BRYAN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 45 0 6   1 0     0   2   27 27             33         54 45 0 6   1 0     0   2   27 27         33       54
1728915 ID     school 1601920 321   MADISON DISTRICT 160192000336 779 BURTON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 58 1 4   0 0     2   0   39 26             27         65 58 1 4   0 0     2   0   39 26         27       65
1729406 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Other KG 12.0 2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727286 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 10 0 2   0 0     0   0   6 6             7         12 10 0 2   0 0     0   0   6 6         7       12
1729719 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000112 841 CAMBRIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 12 0 0   0 0     0   0   9 3             *         12 12 0 0   0 0     0   0   9 3                 12
1729055 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000320 788 CAMELOT ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 38 1 2   1 0     0   5   26 21             *         47 38 1 2   1 0     0   5   26 21                 47
1729370 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 9 0 0   1 0     0   0   8 2             *         10 9 0 0   1 0     0   0   8 2                 10
1726714 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_2 7 0 3   0 0     0   1   5 6             *         11 7 0 3   0 0     0   1   5 6                 11
1729683 ID     school 1600630 422   CASCADE DISTRICT 160063000120 838 CASCADE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 15 0 1   0 0     0   1   6 11             11         17 15 0 1   0 0     0   1   6 11         11       17
1729623 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2017   grade_2 13 0 7   2 0     0   0   13 9             12         22 13 0 7   2 0     0   0   13 9         12       22
1727861 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1726091 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 90 0 6   2 2     1   1   52 50             21         102 90 0 6   2 2     1   1   52 50         21       102
1727325 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000409 444 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 50 0 26   0 0     1   1   43 35             *         78 50 0 26   0 0     1   1   43 35                 78
1729047 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000321 787 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 55 1 2   1 0     0   3   33 29             23         62 55 1 2   1 0     0   3   33 29         23       62
1727614 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000083 505 CENTRAL CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 64 0 58   0 0     0   2   56 68             89         124 64 0 58   0 0     0   2   56 68         89       124
1727332 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000410 447 CENTRAL ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 27 0 25   0 0     0   3   32 23             *         55 27 0 25   0 0     0   3   32 23                 55
1728953 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 122 1 6   2 0     0   0   63 68             62         131 122 1 6   2 0     0   0   63 68         62       131
1727907 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000139 489 CHALLIS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 23 0 0   0 0     0   0   10 13             *         23 23 0 0   0 0     0   0   10 13                 23
1726098 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 52 1 5   2 1     0   3   34 30             24         64 52 1 5   2 1     0   3   34 30         24       64
1725971 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2017   grade_2 60 0 15   0 2     1   7   39 46             39         85 60 0 15   0 2     1   7   39 46         39       85
1730086 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2017   grade_2 0 0 0   14 0     0   0   8 6             *         14 0 0 0   14 0     0   0   8 6                 14
1726034 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2017   grade_2 70 0 7   1 0     0   8   41 45             14         86 70 0 7   1 0     0   8   41 45         14       86
1726411 ID     school 1602640 25   POCATELLO DISTRICT 160264000464 356 CHUBBUCK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 79 0 11   3 2     0   4   51 48             48         99 79 0 11   3 2     0   4   51 48         48       99
1726453 ID     school 1602640 25   POCATELLO DISTRICT 160264000465 362 CLAUDE A WILCOX ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 61 1 15   5 0     0   2   36 48             63         84 61 1 15   5 0     0   2   36 48         63       84
1728239 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900961 1285 CLEARWATER VALLEY ELEMENTARY   Regular School No Elementary KG 5.0 2017   grade_2 24 0 3   1 0     0   1   16 13             20         29 24 0 3   1 0     0   1   16 13         20       29
1727132 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000630 431 CLOVERDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 71 1 23   1 0     0   3   49 50             50         99 71 1 23   1 0     0   3   49 50         50       99
1725793 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 29 0 2   0 2     0   1   19 15             10         34 29 0 2   0 2     0   1   19 15         10       34
1729803 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Elementary PK 6.0 2017   grade_2 63 1 9   0 1     1   3   32 46             13         78 63 1 9   0 1     1   3   32 46         13       78
1729856 ID     school 1600014 460   THE ACADEMY, INC. 160001400891 641 CONNOR ACADEMY   Regular School Yes Elementary PK 8.0 2017   grade_2 56 2 0   0 2     0   0   28 32             20         60 56 2 0   0 2     0   0   28 32         20       60
1726316 ID     school 1600840 13   COUNCIL DISTRICT 160084000162 348 COUNCIL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 20 1 0   0 0     0   0   12 9             10         21 20 1 0   0 0     0   0   12 9         10       21
1726274 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000951 887 CRIMSON POINT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 65 0 7   0 1     0   2   30 45             38         75 65 0 7   0 1     0   2   30 45         38       75
1729130 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2017   grade_2 9 0 1   0 0     0   0   8 2             *         10 9 0 1   0 0     0   0   8 2                 10
1725835 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 36 0 5   0 1     0   2   25 19             *         44 36 0 5   0 1     0   2   25 19                 44
1728456 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000150 739 DALTON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 72 1 4   0 1     0   1   41 38             *         79 72 1 4   0 1     0   1   41 38                 79
1729017 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No Elementary KG 6.0 2017   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727771 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000126 469 DECLO ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 57 0 15   0 1     0   1   38 36             31         74 57 0 15   0 1     0   1   38 36         31       74
1726124 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000901 592 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 73 5 16   0 5     5   3   59 48             *         107 73 5 16   0 5     5   3   59 48                 107
1727639 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000935 892 DESERT SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 63 0 53   2 0     0   5   74 49             79         123 63 0 53   2 0     0   5   74 49         79       123
1728861 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2017   grade_2 12 0 7   0 0     0   0   10 9             *         19 12 0 7   0 0     0   0   10 9                 19
1726084 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 69 0 9   2 2     1   3   51 35             16         86 69 0 9   2 2     1   3   51 35         16       86
1727220 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 104 0 16   1 0     0   1   70 52             53         122 104 0 16   1 0     0   1   70 52         53       122
1726608 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000031 382 DONALD D STALKER ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 24 0 15   10 0     0   5   20 34             31         54 24 0 15   10 0     0   5   20 34         31       54
1729664 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000583 988 DONNELLY ELEMENTARY   Regular School No Elementary KG 5.0 2017   grade_2 22 0 2   0 0     0   0   12 12             14         24 22 0 2   0 0     0   0   12 12         14       24
1727011 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000256 422 DORA ERICKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 37 1 32   0 0     1   1   48 24             65         72 37 1 32   0 0     1   1   48 24         65       72
1726340 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 17 0 1   0 0     0   1   12 7             *         19 17 0 1   0 0     0   1   12 7                 19
1729423 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000754 249 DRIGGS ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 46 0 30   0 0     0   1   39 38             38         77 46 0 30   0 0     0   1   39 38         38       77
1727799 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 61 1 70   2 0     1   1   73 63             104         136 61 1 70   2 0     1   1   73 63         104       136
1725992 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2017   grade_2 66 0 2   0 1     0   4   28 45             14         73 66 0 2   0 1     0   4   28 45         14       73
1726049 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 79 1 12   0 0     0   5   48 49             23         97 79 1 12   0 0     0   5   48 49         23       97
1727600 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000115 460 EAST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 60 0 40   1 0     0   1   53 49             65         102 60 0 40   1 0     0   1   53 49         65       102
1727965 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000396 494 EAST ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 60 1 16   0 2     0   7   48 38             57         86 60 1 16   0 2     0   7   48 38         57       86
1726390 ID     school 1602640 25   POCATELLO DISTRICT 160264000467 353 EDAHOW ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 38 0 6   1 0     0   1   23 23             22         46 38 0 6   1 0     0   1   23 23         22       46
1726979 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000258 416 EDGEMONT GARDENS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 59 0 17   0 1     0   3   42 38             45         80 59 0 17   0 1     0   3   42 38         45       80
1726105 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 5.0 2017   grade_2 102 0 12   2 2     0   7   68 57             29         125 102 0 12   2 2     0   7   68 57         29       125
1727390 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000947 890 ENDEAVOR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 34 1 42   0 0     0   1   43 35             *         78 34 1 42   0 0     0   1   43 35                 78
1726732 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000035 395 ERNEST HEMINGWAY STEAM SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 40 0 19   0 0     0   1   28 32             *         60 40 0 19   0 0     0   1   28 32                 60
1726995 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000260 420 ETHEL BOYES ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 29 0 18   0 0     0   1   21 27             35         48 29 0 18   0 0     0   1   21 27         35       48
1727140 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000172 432 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 31 1 5   0 0     0   0   21 16             19         37 31 1 5   0 0     0   0   21 16         19       37
1729818 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2017   grade_2 29 0 0   0 0     0   0   14 15             *         29 29 0 0   0 0     0   0   14 15                 29
1727092 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000173 425 FALLS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 48 0 14   0 0     0   3   28 37             *         65 48 0 14   0 0     0   3   28 37                 65
1726886 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 61 0 8   0 2     0   5   34 42             52         76 61 0 8   0 2     0   5   34 42         52       76
1728435 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000208 514 FERNAN STEM ACADEMY   Regular School No Elementary KG 5.0 2017   grade_2 69 0 6   0 0     0   4   43 36             50         79 69 0 6   0 0     0   4   43 36         50       79
1729564 ID     school 1601050 413   FILER DISTRICT 160105000193 831 FILER ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 88 0 16   0 0     0   0   62 42             *         104 88 0 16   0 0     0   0   62 42                 104

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