Data source: Big Local News · About: Big Local

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

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
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
1730271 ID     school 1602340 795   IDAHO ARTS CHARTER SCHOOL, INC. 160234000834 577 IDAHO ARTS CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 42 1 16   0 0     1   1   22 39             26         61 42 1 16   0 0     1   1   22 39         26       61
1730233 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12.0 2017   grade_7 2 0 2   0 0     0   0   2 2             *         4 2 0 2   0 0     0   0   2 2                 4
1730219 ID     school 1600600 559   THOMAS JEFFERSON CHARTER SCHOOL, INC. 160060000839 559 THOMAS JEFFERSON CHARTER   Regular School Yes Other PK 12.0 2017   grade_7 27 0 4   0 0     0   1   16 16             12         32 27 0 4   0 0     0   1   16 16         12       32
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
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
1730180 ID     school 1600174 493   NORTH STAR CHARTER SCHOOL, INC. 160017400803 1371 NORTH STAR CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 87 0 6   0 3     0   6   54 48             *         102 87 0 6   0 3     0   6   54 48                 102
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
1730157 ID     school 1600173 491   COEUR D'ALENE CHARTER ACADEMY, INC. 160017300765 1370 COEUR D'ALENE CHARTER ACADEMY SCHOOL   Regular School Yes Other 06 12.0 2017   grade_7 123 0 16   0 5     0   8   65 87             *         152 123 0 16   0 5     0   8   65 87                 152
1730142 ID     school 1600172 490   IDAHO DISTANCE EDUCATION ACADEMY, INC. 160017200846 1369 IDAHO DISTANCE EDUCATION ACADEMY   Regular School Yes Other PK 12.0 2017   grade_7 31 2 4   1 0     0   2   20 20             15         40 31 2 4   1 0     0   2   20 20         15       40
1730116 ID     school 1600165 487   SANDPOINT CHARTER SCHOOL, INC. 160016500772 1365 FORREST M BIRD CHARTER SCHOOL   Regular School Yes Other 06 12.0 2017   grade_7 46 0 2   1 1     0   2   30 22             *         52 46 0 2   1 1     0   2   30 22                 52
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
1730080 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_7 25 0 2   0 0     0   1   9 19             5         28 25 0 2   0 0     0   1   9 19         5       28
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
1730057 ID     school 1600160 480   NORTH IDAHO STEM CHARTER ACADEMY, INC. 160016001020 1342 NORTH IDAHO STEM CHARTER ACADEMY   Regular School Yes Other KG 11.0 2017   grade_7 29 0 0   0 1     0   1   17 14             8         31 29 0 0   0 1     0   1   17 14         8       31
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
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
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
1730014 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_7 33 0 8   0 0     0   0   19 22             9         41 33 0 8   0 0     0   0   19 22         9       41
1730000 ID     school 1600156 475   THE SAGE INTERNATIONAL SCHOOL OF BOISE, A PUBLIC CHARTER SCHOOL, INC. 160015601007 1248 SAGE INTERNATIONAL SCHOOL OF BOISE   Regular School Yes Other KG 12.0 2017   grade_7 74 2 5   0 2     1   6   39 51             21         90 74 2 5   0 2     1   6   39 51         21       90
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
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
1729954 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014801023 1303 IDAHO CONNECTS ONLINE ALTERNATIVE SCHOOL   Alternative School Yes Other 06 12.0 2017   grade_7 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
1729946 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014800993 1221 IDAHO CONNECTS ONLINE SCHOOL   Regular School Yes Other 06 12.0 2017   grade_7 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
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
1729926 ID     school 1600143 465   NORTH VALLEY ACADEMY, INC. 160014300968 653 NORTH VALLEY ACADEMY   Regular School Yes Other PK 12.0 2017   grade_7 11 0 5   0 0     0   0   5 11             10         16 11 0 5   0 0     0   0   5 11         10       16
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
1729902 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes Other KG 13.0 2017   grade_7 46 0 11   0 0     1   1   35 24             27         59 46 0 11   0 0     1   1   35 24         27       59
1729888 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 53 0 10   0 2     0   2   30 37             22         67 53 0 10   0 2     0   2   30 37         22       67
1729874 ID     school 1600015 461   TAYLOR'S CROSSING PUBLIC CHARTER SCHOOL, INC. 160001500892 642 TAYLORS CROSSING CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 29 0 5   0 0     0   0   15 19             15         34 29 0 5   0 0     0   0   15 19         15       34
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
1729850 ID     school 1600012 458   LIBERTY CHARTER SCHOOL, INC. 160001200867 587 LIBERTY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 26 1 5   0 0     0   1   13 20             10         33 26 1 5   0 0     0   1   13 20         10       33
1729836 ID     school 1600011 457   INSPIRE ACADEMICS, INC. 160001100866 578 INSPIRE VIRTUAL CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 63 1 10   0 0     1   4   39 40             41         79 63 1 10   0 0     1   4   39 40         41       79
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
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
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
1729769 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other PK 12.0 2017   grade_7 138 2 13   4 0     0   5   78 84             85         162 138 2 13   4 0     0   5   78 84         85       162
1729755 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 28 1 1   0 2     0   3   17 18             16         35 28 1 1   0 2     0   3   17 18         16       35
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
1729734 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   0 0     0   0   3 6             *         9 9 0 0   0 0     0   0   3 6                 9
1729691 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 79 0 38   1 0     0   1   54 65             70         119 79 0 38   1 0     0   1   54 65         70       119
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
1729653 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000584 236 PAYETTE LAKES MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 78 1 3   0 1     0   1   43 41             29         84 78 1 3   0 1     0   1   43 41         29       84
1729642 ID     school 1602310 418   MURTAUGH JOINT DISTRICT 160231001034 1344 MURTAUGH SCHOOLS   Regular School No Other PK 12.0 2017   grade_7 10 0 17   0 0     0   0   7 20             *         27 10 0 17   0 0     0   0   7 20                 27
1729628 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2017   grade_7 18 0 6   0 0     0   0   13 11             12         24 18 0 6   0 0     0   0   13 11         12       24
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
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
1729585 ID     school 1601710 414   KIMBERLY DISTRICT 160171000179 512 KIMBERLY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 132 0 21   0 0     0   0   82 71             53         153 132 0 21   0 0     0   0   82 71         53       153
1729560 ID     school 1601050 413   FILER DISTRICT 160105000631 196 FILER MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 102 1 21   1 0     0   1   72 54             56         126 102 1 21   1 0     0   1   72 54         56       126
1729540 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 58 0 39   0 0     0   2   47 52             38         99 58 0 39   0 0     0   2   47 52         38       99
1729512 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2017   grade_7 18 3 10   1 0     0   0   24 8             *         32 18 3 10   1 0     0   0   24 8                 32
1729449 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 264 3 57   2 5     4   4   166 173             *         339 264 3 57   2 5     4   4   166 173                 339
1729445 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 240 9 87   1 11     2   3   173 180             222         353 240 9 87   1 11     2   3   173 180         222       353
1729419 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000544 195 TETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 78 0 40   1 1     0   2   75 47             45         122 78 0 40   1 1     0   2   75 47         45       122
1729410 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Other KG 12.0 2017   grade_7 0 0 0   0 0     0   1   0 1             *         1 0 0 0   0 0     0   1   0 1                 1
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
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
1729354 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000292 170 KELLOGG MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 80 0 3   2 2     0   0   48 39             45         87 80 0 3   2 2     0   0   48 39         45       87
1729340 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_7 14 0 0   0 0     0   0   8 6             7         14 14 0 0   0 0     0   0   8 6         7       14
1729320 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No Other 06 12.0 2017   grade_7 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1729308 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 41 0 52   3 0     1   1   51 47             *         98 41 0 52   3 0     1   1   51 47                 98
1729288 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_7 113 0 34   0 2     0   3   73 79             *         152 113 0 34   0 2     0   3   73 79                 152
1729283 ID     school 1602370 372   NEW PLYMOUTH DISTRICT 160237000580 986 NEW PLYMOUTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 69 1 10   0 0     0   1   46 35             33         81 69 1 10   0 0     0   1   46 35         33       81
1729268 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258001051 1318 PAYETTE ALTERNATIVE CENTER   Special Education School No Other PK 12.0 2017   grade_7 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1729241 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000455 161 MCCAIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 78 0 32   0 0     0   1   54 57             *         111 78 0 32   0 0     0   1   54 57                 111
1729231 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_7 56 0 34   1 0     0   1   47 45             59         92 56 0 34   1 0     0   1   47 45         59       92
1729206 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000100 158 RIMROCK JR/SR HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_7 18 0 10   0 0     0   0   15 13             23         28 18 0 10   0 0     0   0   15 13         23       28
1729181 ID     school 1601980 363   MARSING JOINT DISTRICT 160198000636 530 MARSING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 41 0 24   0 0     0   3   35 33             45         68 41 0 24   0 0     0   3   35 33         45       68
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
1729151 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000629 618 MALAD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 64 1 2   1 1     0   0   37 32             *         69 64 1 2   1 1     0   0   37 32                 69
1729135 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   2 0     0   0   9 2             *         11 9 0 0   2 0     0   0   9 2                 11
1729115 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_7 4 0 0   36 0     0   3   29 14             *         43 4 0 0   36 0     0   3   29 14                 43
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
1729026 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_7 176 0 9   2 3     0   18   94 114             79         208 176 0 9   2 3     0   18   94 114         79       208
1729022 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_7 173 2 7   6 2     1   15   118 88             *         206 173 2 7   6 2     1   15   118 88                 206
1729007 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000158 1046 MT HARRISON JR/SR HIGH   Alternative School No Other 06 12.0 2017   grade_7 3 0 9   0 0     0   0   8 4             *         12 3 0 9   0 0     0   0   8 4                 12
1728967 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 98 0 76   1 0     0   1   92 84             *         176 98 0 76   1 0     0   1   92 84                 176
1728963 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000381 148 EAST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 59 0 78   2 0     0   1   73 67             *         140 59 0 78   2 0     0   1   73 67                 140
1728949 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000702 226 SUGAR-SALEM JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 120 1 6   1 2     0   1   66 65             49         131 120 1 6   1 2     0   1   66 65         49       131
1728936 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_7 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1728885 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 369 3 27   2 4     2   0   210 197             *         407 369 3 27   2 4     2   0   210 197                 407
1728880 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2017   grade_7 11 0 4   0 0     0   1   9 7             11         16 11 0 4   0 0     0   1   9 7         11       16
1728866 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2017   grade_7 11 0 5   0 0     0   0   7 9             9         16 11 0 5   0 0     0   0   7 9         9       16
1728837 ID     school 1602940 312   SHOSHONE JOINT DISTRICT 160294000850 294 SHOSHONE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 13 0 29   0 0     1   0   27 16             33         43 13 0 29   0 0     1   0   27 16         33       43
1728831 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12.0 2017   grade_7 14 0 1   1 0     0   0   6 10             9         16 14 0 1   1 0     0   0   6 10         9       16
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
1728801 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   0 0     0   1   5 5             *         10 9 0 0   0 0     0   1   5 5                 10
1728779 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1728756 ID     school 1602850 291   SALMON DISTRICT 160285000504 136 SALMON JR/SR HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_7 53 1 1   2 0     0   1   39 19             25         58 53 1 1   2 0     0   1   39 19         25       58
1728748 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12.0 2017   grade_7 15 0 1   0 0     0   0   12 4             11         16 15 0 1   0 0     0   0   12 4         11       16
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
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
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
1728687 ID     school 1601200 282   GENESEE JOINT DISTRICT 160120000845 269 GENESEE SCHOOL   Regular School No Other PK 12.0 2017   grade_7 25 0 1   0 0     0   0   12 14             *         26 25 0 1   0 0     0   0   12 14                 26
1728644 ID     school 1602220 281   MOSCOW DISTRICT 160222000393 129 MOSCOW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 138 0 9   2 5     0   5   97 62             51         159 138 0 9   2 5     0   5   97 62         51       159
1728632 ID     school 1601740 274   KOOTENAI DISTRICT 160174000303 127 KOOTENAI JR/SR HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_7 12 0 1   0 1     0   0   8 6             5         14 12 0 1   0 1     0   0   8 6         5       14
1728588 ID     school 1602670 273   POST FALLS DISTRICT 160267000844 268 RIVER CITY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 183 1 11   2 3     0   6   88 118             101         206 183 1 11   2 3     0   6   88 118         101       206
1728572 ID     school 1602670 273   POST FALLS DISTRICT 160267000489 125 POST FALLS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 221 1 19   1 1     1   8   131 121             110         252 221 1 19   1 1     1   8   131 121         110       252
1728518 ID     school 1601800 272   LAKELAND DISTRICT 160180000842 585 TIMBERLAKE JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 133 0 6   1 1     0   6   85 62             62         147 133 0 6   1 1     0   6   85 62         62       147
1728502 ID     school 1601800 272   LAKELAND DISTRICT 160180000312 123 LAKELAND JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 188 2 10   1 0     0   16   111 106             102         217 188 2 10   1 0     0   16   111 106         102       217

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