Data source: Big Local News · About: Big Local

221 rows where grade = "grade_7", state = "ID" and year = 2017 sorted by ccd_school_lvl

View and edit SQL

year

  • 2017 · 221

grade

  • grade_7 · 221
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
1727070 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727726 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_7 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
1729042 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726202 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_7 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
1726231 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 63 0 3   0 0     0   4   39 31             *         70 63 0 3   0 0     0   4   39 31                 70
1727066 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
1727174 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2017   grade_7 17 0 2   0 0     0   0   9 10             *         19 17 0 2   0 0     0   0   9 10                 19
1727291 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 9 0 1   0 0     0   1   4 7             5         11 9 0 1   0 0     0   1   4 7         5       11
1727820 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001072 1377 CASSIA COUNTY DAY TREATMENT CENTER   Special Education School No Elementary KG 8.0 2017   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1727897 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2017   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727930 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2017   grade_7 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1728251 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900946 1286 GRANGEVILLE ELEM/MIDDLE SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 47 0 2   0 0     0   1   25 25             *         50 47 0 2   0 0     0   1   25 25                 50
1728259 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728814 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Elementary 04 8.0 2017   grade_7 38 0 3   6 0     1   2   32 18             *         50 38 0 3   6 0     1   2   32 18                 50
1729171 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249001094 1390 IDAHO HOME LEARNING ACADEMY   Regular School No Elementary KG 8.0 2017   grade_7 15 0 1   0 0     0   0   7 9             *         16 15 0 1   0 0     0   0   7 9                 16
1729616 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1729798 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2017   grade_7 26 0 3   0 0     0   0   16 13             5         29 26 0 3   0 0     0   0   16 13         5       29
1729823 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_7 30 1 2   0 0     0   0   13 20             8         33 30 1 2   0 0     0   0   13 20         8       33
1729861 ID     school 1600014 460   THE ACADEMY, INC. 160001400891 641 CONNOR ACADEMY   Regular School Yes Elementary PK 8.0 2017   grade_7 55 0 4   0 3     0   1   29 34             16         63 55 0 4   0 3     0   1   29 34         16       63
1729913 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 24 0 2   0 1     0   3   19 11             9         30 24 0 2   0 1     0   3   19 11         9       30
1729939 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Elementary 04 8.0 2017   grade_7 45 0 2   0 0     0   3   26 24             12         50 45 0 2   0 0     0   3   26 24         12       50
1729969 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 14 1 2   1 0     0   0   12 6             5         18 14 1 2   1 0     0   0   12 6         5       18
1729979 ID     school 1600157 473   THE VILLAGE CHARTER SCHOOL, INC. 160015701018 1339 THE VILLAGE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 22 0 0   0 0     0   0   15 7             *         22 22 0 0   0 0     0   0   15 7                 22
1730025 ID     school 1600153 477   BLACKFOOT CHARTER COMMUNITY LEARNING CENTER, INC. 160015300796 1294 BLACKFOOT CHARTER COMMUNITY   Regular School Yes Elementary PK 8.0 2017   grade_7 31 0 6   1 0     0   1   23 16             28         39 31 0 6   1 0     0   1   23 16         28       39
1730035 ID     school 1600158 478   LEGACY PUBLIC CHARTER SCHOOL, INC. 160015801019 1340 LEGACY CHARTER SCHOOL   Regular School Yes Elementary KG 8.0 2017   grade_7 38 0 7   0 0     0   2   23 24             21         47 38 0 7   0 0     0   2   23 24         21       47
1730045 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 8.0 2017   grade_7 15 0 5   0 0     0   0   12 8             *         20 15 0 5   0 0     0   0   12 8                 20
1730068 ID     school 1600161 481   HERITAGE COMMUNITY CHARTER SCHOOL, INC. 160016101021 1343 HERITAGE COMMUNITY CHARTER   Regular School Yes Elementary KG 8.0 2017   grade_7 19 1 34   0 1     0   1   26 30             43         56 19 1 34   0 1     0   1   26 30         43       56
1730104 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1730167 ID     school 1600360 492   ANSER OF IDAHO, INC. 160036000758 819 ANSER CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 46 1 3   0 2     0   3   32 23             7         55 46 1 3   0 2     0   3   32 23         7       55
1730191 ID     school 1600176 494   THE POCATELLO COMMUNITY CHARTER SCHOOL, INC. 160017600760 623 POCATELLO COMMUNITY CHARTER   Regular School Yes Elementary PK 8.0 2017   grade_7 33 0 2   0 1     0   1   14 23             7         37 33 0 2   0 1     0   1   14 23         7       37
1730288 ID     school 1602220 813   MOSCOW CHARTER SCHOOL, INC. 160222000749 813 MOSCOW CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 12 0 1   0 0     0   2   10 5             10         15 12 0 1   0 0     0   2   10 5         10       15
1726311 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 13 0 0   0 0     0   3   7 9             10         16 13 0 0   0 0     0   3   7 9         10       16
1726790 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000350 183 IDAHO CITY HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 25 0 1   0 0     0   1   12 15             *         27 25 0 1   0 0     0   1   12 15                 27
1726852 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 24 0 0   0 0     0   0   11 13             *         24 24 0 0   0 0     0   0   11 13                 24
1727544 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12.0 2017   grade_7 10 0 2   0 0     0   0   5 7             *         12 10 0 2   0 0     0   0   5 7                 12
1727551 ID     school 1602460 135   NOTUS DISTRICT 160246000431 234 NOTUS JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 26 0 9   0 0     0   3   15 23             24         38 26 0 9   0 0     0   3   15 23         24       38
1727566 ID     school 1602070 136   MELBA JOINT DISTRICT 160207000836 70 MELBA HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 48 0 11   0 0     0   1   29 31             30         60 48 0 11   0 0     0   1   29 31         30       60
1727669 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000742 245 GRACE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 33 0 3   1 0     0   0   19 18             20         37 33 0 3   1 0     0   0   19 18         20       37
1727690 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 14 0 0   0 0     0   0   9 5             5         14 14 0 0   0 0     0   0   9 5         5       14
1727741 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000132 82 OAKLEY JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 28 0 12   0 0     0   0   19 21             16         40 28 0 12   0 0     0   0   19 21         16       40
1727748 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000134 83 RAFT RIVER JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 24 0 6   0 0     0   0   14 16             *         30 24 0 6   0 0     0   0   14 16                 30
1727813 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1727848 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000440 88 OROFINO HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 42 3 1   1 0     0   1   27 21             31         48 42 3 1   1 0     0   1   27 21         31       48
1727889 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000140 89 CHALLIS JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 17 0 3   0 0     1   0   11 10             *         21 17 0 3   0 0     1   0   11 10                 21
1727917 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000332 90 MACKAY JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 16 1 2   0 0     0   0   9 10             10         19 16 1 2   0 0     0   0   9 10         10       19
1728198 ID     school 1600810 242   COTTONWOOD JOINT DISTRICT 160081000161 111 PRAIRIE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 30 1 2   0 0     0   0   18 15             16         33 30 1 2   0 0     0   0   18 15         16       33
1728315 ID     school 1602790 252   RIRIE JOINT DISTRICT 160279000429 228 RIRIE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 51 1 4   3 0     0   5   31 33             29         64 51 1 4   3 0     0   5   31 33         29       64
1728695 ID     school 1601680 283   KENDRICK JOINT DISTRICT 160168000299 132 KENDRICK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 15 0 1   1 0     0   0   13 4             9         17 15 0 1   1 0     0   0   13 4         9       17
1728710 ID     school 1602700 285   POTLATCH DISTRICT 160270000495 135 POTLATCH JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 30 0 0   0 0     0   0   19 11             11         30 30 0 0   0 0     0   0   19 11         11       30
1728733 ID     school 1600009 287   TROY SCHOOL DISTRICT 160000900582 772 TROY JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 18 0 0   0 0     0   1   11 8             5         19 18 0 0   0 0     0   1   11 8         5       19
1729379 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No High 07 12.0 2017   grade_7 5 0 1   0 0     0   0   3 3             *         6 5 0 1   0 0     0   0   3 3                 6
1729402 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 41 1 1   0 0     0   1   21 23             18         44 41 1 1   0 0     0   1   21 23         18       44
1729598 ID     school 1601410 415   HANSEN DISTRICT 160141000757 620 HANSEN JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 8 0 9   0 0     0   0   10 7             12         17 8 0 9   0 0     0   0   10 7         12       17
1729678 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 18 0 1   1 0     0   0   10 10             10         20 18 0 1   1 0     0   0   10 10         10       20
1729742 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729813 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000701074 1379 COMPASS PUBLIC CHARTER SCHOOL JR/SR HIGH   Regular School Yes High 07 12.0 2017   grade_7 71 1 7   0 2     0   3   52 32             10         84 71 1 7   0 2     0   3   52 32         10       84
1730206 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12.0 2017   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1725897 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 283 7 36   3 7     2   14   173 179             108         352 283 7 36   3 7     2   14   173 179         108       352
1725901 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 245 5 57   3 9     1   8   167 161             152         328 245 5 57   3 9     1   8   167 161         152       328
1725915 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 329 4 35   3 5     0   20   195 201             81         396 329 4 35   3 5     0   20   195 201         81       396
1725924 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 233 6 47   2 9     1   21   157 162             116         319 233 6 47   2 9     1   21   157 162         116       319
1725928 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 288 8 56   3 14     1   16   193 193             127         386 288 8 56   3 14     1   16   193 193         127       386
1725953 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 297 2 23   2 3     0   12   152 187             68         339 297 2 23   2 3     0   12   152 187         68       339
1726137 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 07 8.0 2017   grade_7 40 1 6   2 0     0   0   32 17             22         49 40 1 6   2 0     0   0   32 17         22       49
1726163 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2017   grade_7 44 1 7   0 1     0   1   37 17             32         54 44 1 7   0 1     0   1   37 17         32       54
1726222 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 227 4 28   0 4     1   12   140 136             41         276 227 4 28   0 4     1   12   140 136         41       276
1726236 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 352 5 46   1 8     3   12   223 204             62         427 352 5 46   1 8     3   12   223 204         62       427
1726239 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 345 2 51   5 2     1   12   221 197             180         418 345 2 51   5 2     1   12   221 197         180       418
1726323 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 107 2 2   0 0     2   1   67 47             51         114 107 2 2   0 0     2   1   67 47         51       114
1726364 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 215 3 15   3 4     3   5   137 111             *         248 215 3 15   3 4     3   5   137 111                 248
1726368 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 180 3 18   27 0     3   8   127 112             120         239 180 3 18   27 0     3   8   127 112         120       239
1726372 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 162 5 22   1 2     0   4   94 102             115         196 162 5 22   1 2     0   4   94 102         115       196
1726376 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 177 1 33   6 0     3   6   112 114             125         226 177 1 33   6 0     3   6   112 114         125       226
1726486 ID     school 1602640 25   POCATELLO DISTRICT 160264000686 1002 KINPORT MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2017   grade_7 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
1726499 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 83 1 3   0 0     1   0   42 46             45         88 83 1 3   0 0     1   0   42 46         45       88
1726534 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 65 0 1   2 0     0   5   36 37             44         73 65 0 1   2 0     0   5   36 37         44       73
1726566 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500647 128 LAKESIDE JR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 13 0 1   13 0     0   8   18 17             *         35 13 0 1   13 0     0   8   18 17                 35
1726577 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000520 31 SNAKE RIVER JR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 121 0 16   3 0     0   5   86 59             62         145 121 0 16   3 0     0   5   86 59         62       145
1726597 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 148 0 79   42 2     0   8   118 161             161         279 148 0 79   42 2     0   8   118 161         161       279
1726668 ID     school 1600030 58   ABERDEEN DISTRICT 160003000829 299 ABERDEEN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 24 0 30   1 0     1   2   28 30             43         58 24 0 30   1 0     1   2   28 30         43       58
1726678 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_7 43 0 10   1 0     0   1   30 25             24         55 43 0 10   1 0     0   1   30 25         24       55
1726692 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000723 39 DONALD J HOBBS MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 151 2 23   1 1     0   1   92 87             75         179 151 2 23   1 1     0   1   92 87         75       179
1726753 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 133 0 98   1 0     0   2   128 106             96         234 133 0 98   1 0     0   2   128 106         96       234
1726809 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 86 0 3   1 0     0   1   58 33             57         91 86 0 3   1 0     0   1   58 33         57       91
1726846 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 204 0 8   2 0     1   9   116 108             *         224 204 0 8   2 0     1   9   116 108                 224
1727075 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000651 55 SANDCREEK MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 363 4 51   1 3     2   10   202 232             *         434 363 4 51   1 3     2   10   202 232                 434
1727088 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000168 219 ROCKY MOUNTAIN MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 384 1 111   3 1     1   8   265 244             272         509 384 1 111   3 1     1   8   265 244         272       509
1727233 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 83 2 4   1 3     1   4   44 54             45         98 83 2 4   1 3     1   4   44 54         45       98
1727258 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 32 1 3   3 0     0   0   20 19             22         39 32 1 3   3 0     0   0   20 19         22       39
1727296 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 120 1 99   2 0     1   7   123 107             *         230 120 1 99   2 0     1   7   123 107                 230
1727300 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 198 2 82   1 2     3   7   149 146             *         295 198 2 82   1 2     3   7   149 146                 295
1727386 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000969 648 LONE STAR MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 184 2 102   0 1     1   6   165 131             *         296 184 2 102   0 1     1   6   165 131                 296
1727414 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000811 1109 EAST VALLEY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 181 1 157   1 3     2   7   180 172             *         352 181 1 157   1 3     2   7   180 172                 352
1727430 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 78 0 144   1 1     0   6   119 111             *         230 78 0 144   1 1     0   6   119 111                 230
1727446 ID     school 1600510 132   CALDWELL DISTRICT 160051000109 281 SYRINGA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 74 0 153   0 0     1   7   116 119             *         235 74 0 153   0 0     1   7   116 119                 235
1727508 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 11 0 29   0 0     0   0   16 24             21         40 11 0 29   0 0     0   0   16 24         21       40
1727512 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 238 1 30   0 0     0   8   145 132             *         277 238 1 30   0 0     0   8   145 132                 277
1727585 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_7 60 0 22   0 0     0   3   43 42             55         85 60 0 22   0 0     0   3   43 42         55       85
1727628 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000838 582 SAGE VALLEY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 209 8 119   1 1     2   9   177 172             217         349 209 8 119   1 1     2   9   177 172         217       349
1727646 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000539 985 VALLIVUE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 160 2 126   1 4     1   5   123 176             192         299 160 2 126   1 4     1   5   123 176         192       299

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