Data source: Big Local News · About: Big Local

2,772 rows where grade = "grade_2" and state = "ID" sorted by ccd_school_low_grade

View and edit SQL

year

grade

  • grade_2 · 2,672
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
706259 ID     school 1601920 321   MADISON DISTRICT 160192000338 773 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 48 1 7   1 2     0   0   28 31             32         59 48 1 7   1 2     0   0   28 31         32       59
706265 ID     school 1601920 321   MADISON DISTRICT 160192000339 775 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 71 2 8   0 2     0   0   38 45             28         83 71 2 8   0 2     0   0   38 45         28       83
706271 ID     school 1601920 321   MADISON DISTRICT 160192000333 777 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 63 0 7   0 1     1   0   42 30             32         72 63 0 7   0 1     1   0   42 30         32       72
706283 ID     school 1601920 321   MADISON DISTRICT 160192000337 780 HIBBARD ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 44 0 2   0 0     1   0   22 25             11         47 44 0 2   0 0     1   0   22 25         11       47
706289 ID     school 1601920 321   MADISON DISTRICT 160192000974 1225 SOUTH FORK ELEMENTARY   Regular School No Elementary KG 04 2021   grade_2 48 0 6   0 0     0   0   28 26             20         54 48 0 6   0 0     0   0   28 26         20       54
706403 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000321 787 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 66 0 0   1 0     0   1   30 38             27         68 66 0 0   1 0     0   1   30 38         27       68
706410 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000320 788 CAMELOT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 44 0 1   0 0     0   2   23 24             *         47 44 0 1   0 0     0   2   23 24                 47
706417 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000324 789 MCGHEE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 35 0 0   1 0     0   6   17 25             20         42 35 0 0   1 0     0   6   17 25         20       42
706424 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000327 790 ORCHARDS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 39 0 1   0 0     0   6   24 22             18         46 39 0 1   0 0     0   6   24 22         18       46
706431 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000325 791 MCSORLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 41 1 0   0 0     0   4   16 30             *         46 41 1 0   0 0     0   4   16 30                 46
706445 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000329 793 WEBSTER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 38 0 0   0 0     1   5   27 17             21         44 38 0 0   0 0     1   5   27 17         21       44
706708 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 14 0 0   0 0     0   0   4 10             5         14 14 0 0   0 0     0   0   4 10         5       14
706718 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12 2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706744 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2021   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706768 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000545 822 TETONIA ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 14 0 0   0 0     0   0   8 6             *         14 14 0 0   0 0     0   0   8 6                 14
706773 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000547 823 VICTOR ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 28 0 5   0 0     0   1   15 19             *         34 28 0 5   0 0     0   1   15 19                 34
706873 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001076 1382 ROCK CREEK ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 76 0 16   2 3     0   3   49 51             25         100 76 0 16   2 3     0   3   49 51         25       100
706955 ID     school 1601710 414   KIMBERLY DISTRICT 160171001103 1408 STRICKER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 63 0 6   0 0     0   2   35 36             12         71 63 0 6   0 0     0   2   35 36         12       71
707124 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12 2021   grade_2 235 2 33   2 1     0   17   149 141             168         290 235 2 33   2 1     0   17   149 141         168       290
707153 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 08 2021   grade_2 20 0 4   0 0     0   0   16 8             12         24 20 0 4   0 0     0   0   16 8         12       24
707167 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 08 2021   grade_2 20 0 3   0 0     0   3   16 10             6         26 20 0 3   0 0     0   3   16 10         6       26
707180 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_2 89 1 7   0 5     1   1   48 56             16         104 89 1 7   0 5     1   1   48 56         16       104
707260 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_2 40 2 11   0 1     0   1   30 25             15         55 40 2 11   0 1     0   1   30 25         15       55
707274 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_2 42 0 8   0 1     0   3   25 29             19         54 42 0 8   0 1     0   3   25 29         19       54
707300 ID     school 1600143 465   NORTH VALLEY ACADEMY, INC. 160014300968 653 NORTH VALLEY ACADEMY   Regular School Yes Other KG 12 2021   grade_2 10 0 4   0 0     0   0   6 8             9         14 10 0 4   0 0     0   0   6 8         9       14
707320 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_2 23 1 5   0 1     1   1   21 11             11         32 23 1 5   0 1     1   1   21 11         11       32
707351 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_2 19 0 1   1 0     0   1   9 13             *         22 19 0 1   1 0     0   1   9 13                 22
707384 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_2 50 1 6   0 5     0   10   40 32             11         72 50 1 6   0 5     0   10   40 32         11       72
707419 ID     school 1600158 478   LEGACY PUBLIC CHARTER SCHOOL, INC. 160015801019 1340 LEGACY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_2 22 1 3   0 0     0   1   17 10             8         27 22 1 3   0 0     0   1   17 10         8       27
707442 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_2 41 0 3   0 0     0   5   24 25             12         49 41 0 3   0 0     0   5   24 25         12       49
707453 ID     school 1600161 481   HERITAGE COMMUNITY CHARTER SCHOOL, INC. 160016101021 1343 HERITAGE COMMUNITY CHARTER   Regular School Yes Elementary KG 08 2021   grade_2 14 0 45   0 0     0   1   22 38             28         60 14 0 45   0 0     0   1   22 38         28       60
707466 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_2 45 0 6   0 0     0   1   26 26             18         52 45 0 6   0 0     0   1   26 26         18       52
707477 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2021   grade_2 0 0 0   18 0     0   0   12 6             *         18 0 0 0   18 0     0   0   12 6                 18
707491 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary KG 03 2021   grade_2 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
707504 ID     school 1600166 488   SYRINGA MOUNTAIN SCHOOL, INC. 160016601066 1367 SYRINGA MOUNTAIN CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_2 16 0 3   0 0     0   0   8 11             11         19 16 0 3   0 0     0   0   8 11         11       19
707540 ID     school 1600174 493   NORTH STAR CHARTER SCHOOL, INC. 160017400803 1371 NORTH STAR CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_2 68 0 6   0 0     0   9   46 37             *         83 68 0 6   0 0     0   9   46 37                 83
707561 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Elementary KG 08 2021   grade_2 54 0 5   0 2     0   3   27 37             22         64 54 0 5   0 2     0   3   27 37         22       64
707572 ID     school 1600177 496   GEM PREP: POCATELLO, LLC 160017701073 1376 GEM PREP: POCATELLO SCHOOL   Regular School Yes Other KG 10 2021   grade_2 30 0 10   1 1     1   7   30 20             32         50 30 0 10   1 1     1   7   30 20         32       50
707589 ID     school 1600179 498   GEM PREP: MERIDIAN, LLC 160017901107 1409 GEM PREP: MERIDIAN   Regular School Yes Other KG 10 2021   grade_2 36 0 7   1 0     1   2   25 22             21         47 36 0 7   1 0     1   2   25 22         21       47
707600 ID     school 1600181 499   FUTURE PUBLIC SCHOOL, INC. 160018101100 1410 FUTURE PUBLIC SCHOOL   Regular School Yes Elementary KG 05 2021   grade_2 30 5 9   0 3     0   4   30 21             24         51 30 5 9   0 3     0   4   30 21         24       51
707607 ID     school 1600184 508   HAYDEN CANYON CHARTER SCHOOL, INC. 160018401096 1411 HAYDEN CANYON CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_2 23 1 1   0 0     0   1   15 11             9         26 23 1 1   0 0     0   1   15 11         9       26
707617 ID     school 1600178 511   PEACE VALLEY CHARTER SCHOOL, INC. 160017801101 1412 PEACE VALLEY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_2 25 0 5   0 0     0   5   14 21             18         35 25 0 5   0 0     0   5   14 21         18       35
707629 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 11 2021   grade_2 20 0 5   0 0     1   0   12 14             10         26 20 0 5   0 0     1   0   12 14         10       26
707652 ID     school 1600190 528   FORGE INTERNATIONAL, LLC 160019001109 1422 FORGE INTERNATIONAL SCHOOL   Regular School Yes Elementary KG 08 2021   grade_2 37 0 6   0 0     0   0   25 18             7         43 37 0 6   0 0     0   0   25 18         7       43
707668 ID     school 1600188 532   TREASURE VALLEY CLASSICAL ACADEMY, INC. 160018801110 1424 TREASURE VALLEY CLASSICAL ACADEMY   Regular School Yes Elementary KG 07 2021   grade_2 37 0 14   1 0     1   1   25 29             23         54 37 0 14   1 0     1   1   25 29         23       54
707691 ID     school 1600192 540   ISLAND PARK CHARTER SCHOOL, INC. 160019201125 1435 ISLAND PARK CHARTER SCHOOL   Regular School Yes Elementary KG 04 2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
707697 ID     school 1600191 544   MOSAICS PUBLIC SCHOOL, INC. 160019101124 1436 MOSAICS PUBLIC SCHOOL   Regular School Yes Elementary KG 04 2021   grade_2 37 0 23   0 1     1   0   43 19             21         62 37 0 23   0 1     1   0   43 19         21       62
707703 ID     school 1600197 550   DORAL ACADEMY OF IDAHO, INC. 160019701148 1443 DORAL ACADEMY OF IDAHO   Regular School Yes Elementary KG 05 2021   grade_2 16 0 3   0 0     0   2   8 13             *         21 16 0 3   0 0     0   2   8 13                 21
707710 ID     school 1600198 553   PINECREST ACADEMY OF IDAHO, INC. 160019801149 1444 PINECREST ACADEMY OF IDAHO   Regular School Yes Elementary KG 05 2021   grade_2 15 0 3   0 0     0   1   10 9             5         19 15 0 3   0 0     0   1   10 9         5       19
707727 ID     school 1600194 559   THOMAS JEFFERSON CHARTER SCHOOL, INC. 160019400839 559 THOMAS JEFFERSON CHARTER   Regular School Yes Other KG 12 2021   grade_2 21 0 6   0 0     0   1   10 18             10         28 21 0 6   0 0     0   1   10 18         10       28
707797 ID     school 1602340 796   GEM PREP: NAMPA, LLC 160234001080 1386 GEM PREP: NAMPA   Regular School Yes Other KG 10 2021   grade_2 28 0 12   0 0     0   1   24 17             28         41 28 0 12   0 0     0   1   24 17         28       41
707808 ID     school 1602220 813   MOSCOW CHARTER SCHOOL, INC. 160222000749 813 MOSCOW CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_2 19 0 1   0 0     0   2   7 15             *         22 19 0 1   0 0     0   2   7 15                 22
849036 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 05 2020   grade_2 59 2 7   1 2     0   3   38 36             21         74 59 2 7   1 2     0   3   38 36         21       74
849376 ID     school 1602640 25   POCATELLO DISTRICT 160264000467 353 EDAHOW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 32 0 4   1 2     1   1   24 17             16         41 32 0 4   1 2     1   1   24 17         16       41
849383 ID     school 1602640 25   POCATELLO DISTRICT 160264000470 354 GREENACRES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 38 1 9   0 0     0   2   28 22             30         50 38 1 9   0 0     0   2   28 22         30       50
849390 ID     school 1602640 25   POCATELLO DISTRICT 160264000473 355 INDIAN HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 82 1 11   1 0     0   0   46 49             40         95 82 1 11   1 0     0   0   46 49         40       95
849404 ID     school 1602640 25   POCATELLO DISTRICT 160264000642 357 GATE CITY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 68 0 6   0 2     1   4   43 38             17         81 68 0 6   0 2     1   4   43 38         17       81
849418 ID     school 1602640 25   POCATELLO DISTRICT 160264000484 359 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 30 0 7   0 0     0   0   20 17             24         37 30 0 7   0 0     0   0   20 17         24       37
849460 ID     school 1602640 25   POCATELLO DISTRICT 160264000476 368 LEWIS & CLARK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 53 0 28   0 0     0   3   39 45             61         84 53 0 28   0 0     0   3   39 45         61       84
849537 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 7 0 1   1 0     0   0   7 2             *         9 7 0 1   1 0     0   0   7 2                 9
849609 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000032 385 WAPELLO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 32 0 5   0 0     0   0   15 22             16         37 32 0 5   0 0     0   0   15 22         16       37
849683 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2 160 4 18   0 1     0   2   91 94             84         185 160 4 18   0 1     0   2   91 94         84       185
849849 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 46 0 7   1 0     0   2   26 30             28         56 46 0 7   1 0     0   2   26 30         28       56
850195 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001062 1360 SUMMIT HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 53 0 22   0 1     0   0   34 42             34         76 53 0 22   0 1     0   0   34 42         34       76
850233 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 14 0 1   0 0     0   0   4 11             *         15 14 0 1   0 0     0   0   4 11                 15
850240 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 19 0 1   1 0     0   1   14 8             *         22 19 0 1   1 0     0   1   14 8                 22
850261 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850469 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 35 0 69   2 0     0   1   52 55             63         107 35 0 69   2 0     0   1   52 55         63       107
850656 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001092 1397 SKYWAY ELEMENTARY   Regular School No Elementary KG 05 2020   grade_2 54 0 55   0 0     0   2   45 66             73         111 54 0 55   0 0     0   2   45 66         73       111
850763 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000387 216 WHITE PINE ELEMENTARY   Regular School No Elementary KG 06 2020   grade_2 60 0 28   0 1     0   0   43 46             41         89 60 0 28   0 1     0   0   43 46         41       89
850787 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary KG 06 2020   grade_2 36 1 29   0 0     0   0   34 32             43         66 36 1 29   0 0     0   0   34 32         43       66
850811 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 27 0 26   0 1     0   3   32 25             41         57 27 0 26   0 1     0   3   32 25         41       57
850833 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001088 1395 JOHN V EVANS ELEMENTARY   Regular School No Elementary KG 06 2020   grade_2 42 0 30   0 0     0   0   30 42             45         72 42 0 30   0 0     0   0   30 42         45       72
850913 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2020   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
851111 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000798 251 SHADOW BUTTE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 71 0 13   0 0     1   0   44 41             52         85 71 0 13   0 0     1   0   44 41         52       85
851118 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
851125 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
851248 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900961 1285 CLEARWATER VALLEY ELEMENTARY   Regular School No Elementary KG 05 2020   grade_2 30 0 0   2 0     0   2   17 17             21         34 30 0 0   2 0     0   2   17 17         21       34
851350 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_2 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
851367 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
851378 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 52 0 90   0 0     0   2   75 69             114         144 52 0 90   0 0     0   2   75 69         114       144
851443 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000208 514 FERNAN STEM ACADEMY   Regular School No Elementary KG 05 2020   grade_2 52 0 7   0 0     0   1   32 28             29         60 52 0 7   0 0     0   1   32 28         29       60
851450 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000146 735 BORAH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 38 0 7   1 0     0   3   21 28             36         49 38 0 7   1 0     0   3   21 28         36       49
851471 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 85 0 8   0 1     0   7   48 53             35         101 85 0 8   0 1     0   7   48 53         35       101
851676 ID     school 1602220 281   MOSCOW DISTRICT 160222000392 754 LENA WHITMORE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 35 0 2   1 0     0   2   22 18             16         40 35 0 2   1 0     0   2   22 18         16       40
851683 ID     school 1602220 281   MOSCOW DISTRICT 160222000395 755 WEST PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2 46 0 4   2 2     0   7   28 33             28         61 46 0 4   2 2     0   7   28 33         28       61
851800 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
851910 ID     school 1601920 321   MADISON DISTRICT 160192000338 773 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_2 59 0 8   0 1     0   0   32 36             30         68 59 0 8   0 1     0   0   32 36         30       68
851916 ID     school 1601920 321   MADISON DISTRICT 160192000339 775 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_2 75 0 9   0 0     1   1   37 49             30         86 75 0 9   0 0     1   1   37 49         30       86
851922 ID     school 1601920 321   MADISON DISTRICT 160192000333 777 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_2 49 0 6   0 0     0   0   30 25             25         55 49 0 6   0 0     0   0   30 25         25       55
851934 ID     school 1601920 321   MADISON DISTRICT 160192000337 780 HIBBARD ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_2 30 0 4   0 0     0   0   15 19             16         34 30 0 4   0 0     0   0   15 19         16       34
851940 ID     school 1601920 321   MADISON DISTRICT 160192000974 1225 SOUTH FORK ELEMENTARY   Regular School No Elementary KG 04 2020   grade_2 53 0 8   1 0     0   0   32 30             36         62 53 0 8   1 0     0   0   32 30         36       62
852052 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000321 787 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 59 0 2   1 0     0   5   28 39             32         67 59 0 2   1 0     0   5   28 39         32       67
852060 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000320 788 CAMELOT ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 61 0 0   0 0     0   5   36 30             9         66 61 0 0   0 0     0   5   36 30         9       66
852068 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000324 789 MCGHEE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 41 0 2   0 1     0   2   17 29             25         46 41 0 2   0 1     0   2   17 29         25       46
852076 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000327 790 ORCHARDS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 37 0 3   0 0     0   2   18 24             22         42 37 0 3   0 0     0   2   18 24         22       42
852084 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000325 791 MCSORLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 41 0 0   0 0     0   5   24 22             17         46 41 0 0   0 0     0   5   24 22         17       46
852100 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000329 793 WEBSTER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 43 0 2   0 0     0   3   22 26             20         48 43 0 2   0 0     0   3   22 26         20       48
852176 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249001094 1390 IDAHO HOME LEARNING ACADEMY   Regular School No Elementary KG 08 2020   grade_2 297 2 25   1 8     2   2   166 171             *         337 297 2 25   1 8     2   2   166 171                 337
852339 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 4 0 0   0 0     0   0   1 3             *         4 4 0 0   0 0     0   0   1 3                 4

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