Data source: Big Local News · About: Big Local

1,582 rows where grade = "grade_7" and state = "ID" sorted by black

View and edit SQL

year

grade

  • grade_7 · 1,482
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
706541 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 08 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706551 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000100 158 RIMROCK JR/SR HIGH SCHOOL   Regular School No High 06 12 2021   grade_7 13 0 11   1 0     0   0   14 11             13         25 13 0 11   1 0     0   0   14 11         13       25
706576 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 65 0 37   0 0     0   2   51 53             60         104 65 0 37   0 0     0   2   51 53         60       104
706586 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000455 161 MCCAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 59 0 40   1 0     0   6   55 51             34         106 59 0 40   1 0     0   6   55 51         34       106
706624 ID     school 1602370 372   NEW PLYMOUTH DISTRICT 160237000580 986 NEW PLYMOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 65 0 10   1 0     0   0   41 35             27         76 65 0 10   1 0     0   0   41 35         27       76
706680 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_7 14 0 0   0 0     0   0   8 6             *         14 14 0 0   0 0     0   0   8 6                 14
706723 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12 2021   grade_7 7 0 0   1 0     0   2   5 5             *         10 7 0 0   1 0     0   2   5 5                 10
706749 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2021   grade_7 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
706759 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000544 195 TETON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 82 0 48   0 0     0   2   72 60             43         132 82 0 48   0 0     0   2   72 60         43       132
706851 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 07 08 2021   grade_7 16 0 11   0 0     0   0   20 7             14         27 16 0 11   0 0     0   0   20 7         14       27
706862 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706889 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Not reported M M 2021   grade_7 8 0 4   0 0     0   2   6 8             *         14 8 0 4   0 0     0   2   6 8                 14
706894 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 52 0 31   0 0     0   0   47 36             44         83 52 0 31   0 0     0   0   47 36         44       83
706944 ID     school 1601710 414   KIMBERLY DISTRICT 160171000179 512 KIMBERLY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 134 0 35   0 0     0   2   91 80             47         171 134 0 35   0 0     0   2   91 80         47       171
706964 ID     school 1601410 415   HANSEN DISTRICT 160141000757 620 HANSEN JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 16 0 12   0 0     0   1   16 13             23         29 16 0 12   0 0     0   1   16 13         23       29
706978 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
706989 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2021   grade_7 13 0 8   1 0     0   0   12 10             12         22 13 0 8   1 0     0   0   12 10         12       22
707003 ID     school 1602310 418   MURTAUGH JOINT DISTRICT 160231001034 1344 MURTAUGH SCHOOLS   Regular School No Other PK 12 2021   grade_7 15 0 18   0 0     0   0   15 18             26         33 15 0 18   0 0     0   0   15 18         26       33
707014 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000584 236 PAYETTE LAKES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 104 0 11   1 0     0   1   62 55             14         117 104 0 11   1 0     0   1   62 55         14       117
707040 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 06 12 2021   grade_7 11 0 0   1 0     0   0   6 6             *         12 11 0 0   1 0     0   0   6 6                 12
707052 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 72 0 31   0 0     0   3   49 57             48         106 72 0 31   0 0     0   3   49 57         48       106
707076 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2021   grade_7 16 0 3   0 0     0   0   10 9             9         19 16 0 3   0 0     0   0   10 9         9       19
707096 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12 2021   grade_7 9 0 1   0 0     0   0   6 4             5         10 9 0 1   0 0     0   0   6 4         5       10
707138 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000401035 1302 INSIGHT SCHOOL OF IDAHO   Alternative School Yes High 06 12 2021   grade_7 14 0 6   0 1     0   1   16 6             *         22 14 0 6   0 1     0   1   16 6                 22
707157 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 08 2021   grade_7 9 0 4   0 0     0   2   5 10             *         15 9 0 4   0 0     0   2   5 10                 15
707172 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 08 2021   grade_7 27 0 2   0 0     0   3   17 15             *         32 27 0 2   0 0     0   3   17 15                 32
707238 ID     school 1600014 460   THE ACADEMY, INC. 160001400891 641 CONNOR ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7 54 0 6   4 0     2   0   33 33             6         66 54 0 6   4 0     2   0   33 33         6       66
707251 ID     school 1600015 461   TAYLOR'S CROSSING PUBLIC CHARTER SCHOOL, INC. 160001500892 642 TAYLORS CROSSING CHARTER SCHOOL   Regular School Yes Other PK 12 2021   grade_7 29 0 2   0 1     0   0   13 19             11         32 29 0 2   0 1     0   0   13 19         11       32
707265 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_7 49 0 7   0 3     0   1   31 29             12         60 49 0 7   0 3     0   1   31 29         12       60
707279 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_7 46 0 12   0 2     0   1   32 29             15         61 46 0 12   0 2     0   1   32 29         15       61
707291 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Other PK 10 2021   grade_7 48 0 9   0 1     0   7   41 24             27         65 48 0 9   0 1     0   7   41 24         27       65
707305 ID     school 1600143 465   NORTH VALLEY ACADEMY, INC. 160014300968 653 NORTH VALLEY ACADEMY   Regular School Yes Other KG 12 2021   grade_7 12 0 4   0 0     1   0   10 7             9         17 12 0 4   0 0     1   0   10 7         9       17
707325 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 09 2021   grade_7 32 0 5   1 1     1   0   22 18             20         40 32 0 5   1 1     1   0   22 18         20       40
707333 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014800993 1221 IDAHO CONNECTS ONLINE SCHOOL   Regular School Yes High 06 12 2021   grade_7 8 0 1   0 1     0   2   5 7             *         12 8 0 1   0 1     0   2   5 7                 12
707341 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014801023 1303 IDAHO CONNECTS ONLINE ALTERNATIVE SCHOOL   Alternative School Yes High 06 12 2021   grade_7 5 0 2   0 0     0   0   6 1             *         7 5 0 2   0 0     0   0   6 1                 7
707356 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_7 14 0 0   0 0     0   1   8 7             *         15 14 0 0   0 0     0   1   8 7                 15
707376 ID     school 1600154 474   MONTICELLO MONTESSORI CHARTER SCHOOL, INC. 160015401014 1246 MONTICELLO MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2021   grade_7 11 0 2   0 0     0   0   6 7             *         13 11 0 2   0 0     0   0   6 7                 13
707389 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 2021   grade_7 65 0 5   1 2     1   9   37 46             26         83 65 0 5   1 2     1   9   37 46         26       83
707403 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12 2021   grade_7 29 0 10   0 0     0   2   23 18             17         41 29 0 10   0 0     0   2   23 18         17       41
707414 ID     school 1600153 477   BLACKFOOT CHARTER COMMUNITY LEARNING CENTER, INC. 160015300796 1294 BLACKFOOT CHARTER COMMUNITY   Regular School Yes Elementary PK 08 2021   grade_7 33 0 7   1 0     0   1   20 22             19         42 33 0 7   1 0     0   1   20 22         19       42
707424 ID     school 1600158 478   LEGACY PUBLIC CHARTER SCHOOL, INC. 160015801019 1340 LEGACY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_7 36 0 1   0 0     0   0   20 17             *         37 36 0 1   0 0     0   0   20 17                 37
707434 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7 17 0 8   0 0     0   0   18 7             11         25 17 0 8   0 0     0   0   18 7         11       25
707447 ID     school 1600160 480   NORTH IDAHO STEM CHARTER ACADEMY, INC. 160016001020 1342 NORTH IDAHO STEM CHARTER ACADEMY   Regular School Yes Other KG 12 2021   grade_7 49 0 2   0 0     0   2   30 23             17         53 49 0 2   0 0     0   2   30 23         17       53
707458 ID     school 1600161 481   HERITAGE COMMUNITY CHARTER SCHOOL, INC. 160016101021 1343 HERITAGE COMMUNITY CHARTER   Regular School Yes Elementary KG 08 2021   grade_7 13 0 40   0 0     0   1   32 22             26         54 13 0 40   0 0     0   1   32 22         26       54
707471 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_7 21 0 1   1 0     0   1   10 14             10         24 21 0 1   1 0     0   1   10 14         10       24
707482 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2021   grade_7 0 0 0   7 0     0   0   5 2             *         7 0 0 0   7 0     0   0   5 2                 7
707499 ID     school 1600165 487   SANDPOINT CHARTER SCHOOL, INC. 160016500772 1365 FORREST M BIRD CHARTER SCHOOL   Regular School Yes High 06 12 2021   grade_7 38 0 4   1 0     0   0   20 23             29         43 38 0 4   1 0     0   0   20 23         29       43
707509 ID     school 1600166 488   SYRINGA MOUNTAIN SCHOOL, INC. 160016601066 1367 SYRINGA MOUNTAIN CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_7 8 0 1   0 0     0   0   4 5             *         9 8 0 1   0 0     0   0   4 5                 9
707522 ID     school 1600173 491   COEUR D'ALENE CHARTER ACADEMY, INC. 160017300765 1370 COEUR D'ALENE CHARTER ACADEMY SCHOOL   Regular School Yes High 06 12 2021   grade_7 112 0 4   1 3     0   7   59 68             12         127 112 0 4   1 3     0   7   59 68         12       127
707532 ID     school 1600195 492   ANSER OF IDAHO, INC. 160019500758 819 ANSER CHARTER SCHOOL   Regular School Yes Elementary PK 08 2021   grade_7 32 0 9   0 2     0   4   24 23             9         47 32 0 9   0 2     0   4   24 23         9       47
707566 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Elementary KG 08 2021   grade_7 62 0 5   0 0     0   2   42 27             23         69 62 0 5   0 0     0   2   42 27         23       69
707577 ID     school 1600177 496   GEM PREP: POCATELLO, LLC 160017701073 1376 GEM PREP: POCATELLO SCHOOL   Regular School Yes Other KG 10 2021   grade_7 29 0 0   1 0     0   1   18 13             15         31 29 0 0   1 0     0   1   18 13         15       31
707594 ID     school 1600179 498   GEM PREP: MERIDIAN, LLC 160017901107 1409 GEM PREP: MERIDIAN   Regular School Yes Other KG 10 2021   grade_7 43 0 5   0 0     0   4   31 21             17         52 43 0 5   0 0     0   4   31 21         17       52
707612 ID     school 1600184 508   HAYDEN CANYON CHARTER SCHOOL, INC. 160018401096 1411 HAYDEN CANYON CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_7 19 0 0   0 0     0   1   8 12             7         20 19 0 0   0 0     0   1   8 12         7       20
707622 ID     school 1600178 511   PEACE VALLEY CHARTER SCHOOL, INC. 160017801101 1412 PEACE VALLEY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_7 17 0 1   0 1     0   2   11 10             7         21 17 0 1   0 1     0   2   11 10         7       21
707634 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 11 2021   grade_7 17 0 3   0 0     0   1   11 10             11         21 17 0 3   0 0     0   1   11 10         11       21
707647 ID     school 1600189 523   ELEVATE ACADEMY INC. 160018901113 1420 ELEVATE ACADEMY   Alternative School Yes Secondary 06 11 2021   grade_7 24 0 39   0 0     0   3   44 22             32         66 24 0 39   0 0     0   3   44 22         32       66
707657 ID     school 1600190 528   FORGE INTERNATIONAL, LLC 160019001109 1422 FORGE INTERNATIONAL SCHOOL   Regular School Yes Elementary KG 08 2021   grade_7 20 0 4   0 0     0   0   13 11             6         24 20 0 4   0 0     0   0   13 11         6       24
707664 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   grade_7 12 0 0   0 0     0   1   5 8             7         13 12 0 0   0 0     0   1   5 8         7       13
707673 ID     school 1600188 532   TREASURE VALLEY CLASSICAL ACADEMY, INC. 160018801110 1424 TREASURE VALLEY CLASSICAL ACADEMY   Regular School Yes Elementary KG 07 2021   grade_7 43 0 6   1 0     0   3   24 29             11         53 43 0 6   1 0     0   3   24 29         11       53
707685 ID     school 1600172 534   GEM PREP: ONLINE LLC 160017200846 1426 GEM PREP: ONLINE SCHOOL   Regular School Yes Other PK 12 2021   grade_7 43 0 5   0 0     0   2   26 24             16         50 43 0 5   0 0     0   2   26 24         16       50
707719 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12 2021   grade_7 5 0 1   0 0     0   0   4 2             *         6 5 0 1   0 0     0   0   4 2                 6
707732 ID     school 1600194 559   THOMAS JEFFERSON CHARTER SCHOOL, INC. 160019400839 559 THOMAS JEFFERSON CHARTER   Regular School Yes Other KG 12 2021   grade_7 27 0 5   1 0     0   0   13 20             10         33 27 0 5   1 0     0   0   13 20         10       33
707746 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 2021   grade_7 8 0 2   0 0     0   1   3 8             *         11 8 0 2   0 0     0   1   3 8                 11
707790 ID     school 1602340 795   IDAHO ARTS CHARTER SCHOOL, INC. 160234000834 577 IDAHO ARTS CHARTER SCHOOL   Regular School Yes Other PK 12 2021   grade_7 74 0 38   2 1     1   3   43 76             38         119 74 0 38   2 1     1   3   43 76         38       119
707802 ID     school 1602340 796   GEM PREP: NAMPA, LLC 160234001080 1386 GEM PREP: NAMPA   Regular School Yes Other KG 10 2021   grade_7 36 0 12   0 0     0   3   27 24             36         51 36 0 12   0 0     0   3   27 24         36       51
707813 ID     school 1602220 813   MOSCOW CHARTER SCHOOL, INC. 160222000749 813 MOSCOW CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_7 17 0 1   0 0     0   1   10 9             *         19 17 0 1   0 0     0   1   10 9                 19
848824 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_7 8 0 1   1 4     0   0   9 5             *         14 8 0 1   1 4     0   0   9 5                 14
848863 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2020   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
848947 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 307 0 33   0 2     6   19   161 206             37         367 307 0 33   0 2     6   19   161 206         37       367
849158 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 08 2020   grade_7 40 0 5   0 0     0   3   30 18             28         48 40 0 5   0 0     0   3   30 18         28       48
849181 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No High 06 12 2020   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
849195 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No High 06 12 2020   grade_7 25 0 2   0 0     0   3   8 22             *         30 25 0 2   0 0     0   3   8 22                 30
849220 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 08 2020   grade_7 62 0 4   0 0     0   3   34 35             8         69 62 0 4   0 0     0   3   34 35         8       69
849289 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_7 16 0 1   0 0     0   1   10 8             10         18 16 0 1   0 0     0   1   10 8         10       18
849297 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 23 0 0   0 0     0   0   13 10             10         23 23 0 0   0 0     0   0   13 10         10       23
849358 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 183 0 45   5 1     1   3   124 114             122         238 183 0 45   5 1     1   3   124 114         122       238
849471 ID     school 1602640 25   POCATELLO DISTRICT 160264000686 1002 KINPORT MIDDLE SCHOOL   Alternative School No Middle 06 08 2020   grade_7 4 0 3   1 0     0   0   8 0             *         8 4 0 3   1 0     0   0   8 0                 8
849482 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
849487 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 89 0 3   0 0     0   0   47 45             49         92 89 0 3   0 0     0   0   47 45         49       92
849521 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 75 0 2   0 0     0   3   44 36             51         80 75 0 2   0 0     0   3   44 36         51       80
849553 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500647 128 LAKESIDE JR HIGH SCHOOL   Regular School No Middle 07 08 2020   grade_7 6 0 3   10 0     0   5   11 13             12         24 6 0 3   10 0     0   5   11 13         12       24
849665 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 62 0 9   2 0     0   0   38 35             29         73 62 0 9   2 0     0   0   38 35         29       73
849706 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2020   grade_7 15 0 7   0 0     0   1   13 10             12         23 15 0 7   0 0     0   1   13 10         12       23
849724 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000035 395 ERNEST HEMINGWAY STEAM SCHOOL   Regular School No Elementary PK 08 2020   grade_7 28 0 18   0 1     0   1   27 21             10         48 28 0 18   0 1     0   1   27 21         10       48
849760 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_7 23 0 1   0 0     0   0   14 10             *         24 23 0 1   0 0     0   0   14 10                 24
849782 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000350 183 IDAHO CITY HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 26 0 0   0 0     0   0   14 12             10         26 26 0 0   0 0     0   0   14 12         10       26
849797 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000831 278 HORSESHOE BEND MIDDLE/SR HIGH   Regular School No High 06 12 2020   grade_7 17 0 2   0 0     0   1   12 8             12         20 17 0 2   0 0     0   1   12 8         12       20
849801 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No Middle 07 08 2020   grade_7 74 0 3   0 0     0   5   46 36             51         82 74 0 3   0 0     0   5   46 36         51       82
849839 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 20 0 1   1 0     0   0   14 8             13         22 20 0 1   1 0     0   0   14 8         13       22
850050 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_7 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
850162 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 08 2020   grade_7 27 0 2   0 0     0   0   16 13             *         29 27 0 2   0 0     0   0   16 13                 29
850186 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001050 1319 BONNEVILLE ONLINE SCHOOL   Regular School No High 06 12 2020   grade_7 16 0 0   0 0     0   0   8 8             *         16 16 0 0   0 0     0   0   8 8                 16
850256 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 32 0 1   0 1     0   0   17 17             17         34 32 0 1   0 1     0   0   17 17         17       34
850284 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_7 19 0 0   0 0     0   0   7 12             8         19 19 0 0   0 0     0   0   7 12         8       19
850289 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 112 0 116   1 0     2   14   134 111             185         245 112 0 116   1 0     2   14   134 111         185       245
850428 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 79 0 147   1 1     0   4   118 114             *         232 79 0 147   1 1     0   4   118 114                 232
850490 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12 2020   grade_7 0 0 2   0 0     0   0   1 1             *         2 0 0 2   0 0     0   0   1 1                 2
850507 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 11 0 20   0 0     0   0   16 15             *         31 11 0 20   0 0     0   0   16 15                 31
850564 ID     school 1602070 136   MELBA JOINT DISTRICT 160207000836 70 MELBA HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 59 0 17   0 0     0   4   43 37             26         80 59 0 17   0 0     0   4   43 37         26       80

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