Data source: Big Local News · About: Big Local

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

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
704483 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 39 0 24   0 1     0   1   30 35             31         65 39 0 24   0 1     0   1   30 35         31       65
704491 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 62 0 11   0 0     0   5   43 35             31         78 62 0 11   0 0     0   5   43 35         31       78
704508 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 22 0 0   0 0     1   0   13 10             10         23 22 0 0   0 0     1   0   13 10         10       23
704515 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 24 0 1   1 0     0   0   18 8             11         26 24 0 1   1 0     0   0   18 8         11       26
704522 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000094 437 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 53 0 4   2 0     0   1   30 30             33         60 53 0 4   2 0     0   1   30 30         33       60
704551 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_2 10 0 1   0 0     0   0   5 6             6         11 10 0 1   0 0     0   0   5 6         6       11
704569 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000375 213 IOWA ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 42 0 29   0 0     1   0   38 34             41         72 42 0 29   0 0     1   0   38 34         41       72
704583 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000383 215 PARK RIDGE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 17 0 11   0 0     0   2   17 13             17         30 17 0 11   0 0     0   2   17 13         17       30
704590 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000409 444 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 30 0 24   0 1     0   1   32 24             27         56 30 0 24   0 1     0   1   32 24         27       56
704597 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000410 447 CENTRAL ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 22 0 24   0 0     1   2   33 16             *         49 22 0 24   0 0     1   2   33 16                 49
704604 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000677 450 GREENHURST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 31 0 13   0 0     0   0   24 20             23         44 31 0 13   0 0     0   0   24 20         23       44
704611 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000774 527 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 42 0 13   0 0     0   1   30 26             18         56 42 0 13   0 0     0   1   30 26         18       56
704618 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000775 528 REAGAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 37 0 17   0 0     2   5   22 39             23         61 37 0 17   0 0     2   5   22 39         23       61
704644 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000986 647 LAKE RIDGE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 61 0 13   0 0     0   3   44 33             31         77 61 0 13   0 0     0   3   44 33         31       77
704655 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000947 890 ENDEAVOR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 22 0 42   0 0     0   3   26 41             40         67 22 0 42   0 0     0   3   26 41         40       67
704697 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234001130 1448 NAMPA ONLINE VIRTUAL ACADEMY   Regular School No Other PK 12 2021   grade_2 45 0 24   0 1     1   4   41 34             32         75 45 0 24   0 1     1   4   41 34         32       75
704708 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary KG 07 2021   grade_2 13 0 76   0 0     0   0   44 45             41         89 13 0 76   0 0     0   0   44 45         41       89
704737 ID     school 1600510 132   CALDWELL DISTRICT 160051000609 289 WILSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 32 0 47   2 0     1   1   45 38             45         83 32 0 47   2 0     1   1   45 38         45       83
704744 ID     school 1600510 132   CALDWELL DISTRICT 160051000108 448 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 18 0 63   0 0     0   1   42 40             48         82 18 0 63   0 0     0   1   42 40         48       82
704751 ID     school 1600510 132   CALDWELL DISTRICT 160051000106 449 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 35 0 28   0 0     1   2   33 33             49         66 35 0 28   0 0     1   2   33 33         49       66
704758 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 29 0 54   2 1     0   2   48 40             51         88 29 0 54   2 1     0   2   48 40         51       88
704789 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 9 0 27   0 0     0   2   19 19             *         38 9 0 27   0 0     0   2   19 19                 38
704809 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 96 0 8   1 3     1   3   60 52             21         112 96 0 8   1 3     1   3   60 52         21       112
704823 ID     school 1602130 134   MIDDLETON DISTRICT 160213000812 546 PURPLE SAGE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 47 0 12   0 0     0   1   31 29             18         60 47 0 12   0 0     0   1   31 29         18       60
704842 ID     school 1602460 135   NOTUS DISTRICT 160246000430 520 NOTUS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 13 0 7   0 0     0   0   11 9             11         20 13 0 7   0 0     0   0   11 9         11       20
704875 ID     school 1602550 137   PARMA DISTRICT 160255000449 456 MAXINE JOHNSON ELEMENTARY   Regular School No Elementary PK 04 2021   grade_2 50 0 21   1 0     0   4   36 40             43         76 50 0 21   1 0     0   4   36 40         43       76
704893 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000119 461 WEST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 38 0 20   0 0     0   3   38 23             33         61 38 0 20   0 0     0   3   38 23         33       61
704900 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000083 505 CENTRAL CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 37 0 44   0 0     0   0   39 42             27         81 37 0 44   0 0     0   0   39 42         27       81
704944 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001092 1397 SKYWAY ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 50 0 50   1 0     0   2   55 48             44         103 50 0 50   1 0     0   2   55 48         44       103
704963 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_2 17 0 0   0 0     0   0   8 9             *         17 17 0 0   0 0     0   0   8 9                 17
704968 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000225 463 GRACE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 15 0 0   0 0     0   1   5 11             *         16 15 0 0   0 0     0   1   5 11                 16
704981 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 06 2021   grade_2 10 0 0   0 0     0   0   5 5             5         10 10 0 0   0 0     0   0   5 5         5       10
705008 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
705061 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000126 469 DECLO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 49 0 12   0 0     0   0   28 33             26         61 49 0 12   0 0     0   0   28 33         26       61
705068 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary PK 06 2021   grade_2 26 0 27   0 1     0   1   32 23             24         55 26 0 27   0 1     0   1   32 23         24       55
705076 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000129 471 RAFT RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 17 0 3   0 0     0   0   11 9             15         20 17 0 3   0 0     0   0   11 9         15       20
705084 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000131 473 OAKLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 18 0 5   0 0     0   0   15 8             *         23 18 0 5   0 0     0   0   15 8                 23
705092 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 22 0 21   0 0     0   0   19 24             22         43 22 0 21   0 0     0   0   19 24         22       43
705100 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 9 0 0   0 0     0   0   6 3             *         9 9 0 0   0 0     0   0   6 3                 9
705114 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001088 1395 JOHN V EVANS ELEMENTARY   Regular School No Elementary KG 06 2021   grade_2 37 0 31   0 0     0   1   43 26             36         69 37 0 31   0 0     0   1   43 26         36       69
705125 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001141 1441 MINI-CASSIA ONLINE LEARNING ACADEMY   Regular School No Other KG 12 2021   grade_2 9 0 4   0 0     0   1   6 8             *         14 9 0 4   0 0     0   1   6 8                 14
705144 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_2 4 0 6   0 0     0   0   5 5             *         10 4 0 6   0 0     0   0   5 5                 10
705166 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000439 479 OROFINO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 51 0 0   1 0     0   0   31 21             21         52 51 0 0   1 0     0   0   31 21         21       52
705174 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
705182 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
705195 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 11 0 0   0 0     0   0   5 6             *         11 11 0 0   0 0     0   0   5 6                 11
705218 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000139 489 CHALLIS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 21 0 2   0 0     0   1   14 10             14         24 21 0 2   0 0     0   1   14 10         14       24
705233 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 18 0 1   0 0     0   0   9 10             *         19 18 0 1   0 0     0   0   9 10                 19
705255 ID     school 1601230 192   GLENNS FERRY JOINT DISTRICT 160123000219 492 GLENNS FERRY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 26 0 5   0 0     0   1   21 11             25         32 26 0 5   0 0     0   1   21 11         25       32
705339 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 59 0 1   0 0     1   2   37 26             24         63 59 0 1   0 0     1   2   37 26         24       63
705363 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000622 290 HENRYS FORK ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 59 0 16   0 0     0   3   43 35             51         78 59 0 16   0 0     0   3   43 35         51       78
705370 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000204 700 PARKER-EGIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 11 0 1   0 0     0   0   5 7             7         12 11 0 1   0 0     0   0   5 7         7       12
705377 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000200 701 ASHTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 30 0 7   0 0     0   3   21 19             20         40 30 0 7   0 0     0   3   21 19         20       40
705384 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000207 703 TETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 17 0 1   0 0     0   0   12 6             10         18 17 0 1   0 0     0   0   12 6         10       18
705406 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000797 230 KENNETH J CARBERRY ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 80 0 12   1 0     0   11   55 49             49         104 80 0 12   1 0     0   11   55 49         49       104
705413 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000798 251 SHADOW BUTTE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 71 0 7   0 1     0   4   40 43             *         83 71 0 7   0 1     0   4   40 43                 83
705420 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
705430 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
705479 ID     school 1603360 232   WENDELL DISTRICT 160336000570 712 WENDELL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 37 0 57   0 0     0   0   35 59             73         94 37 0 57   0 0     0   0   35 59         73       94
705488 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12 2021   grade_2 11 0 4   0 0     0   0   7 8             *         15 11 0 4   0 0     0   0   7 8                 15
705499 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138001143 1456 HAGERMAN VIRTUAL SCHOOL   Regular School No Elementary KG 08 2021   grade_2 13 0 1   0 0     0   0   8 6             *         14 13 0 1   0 0     0   0   8 6                 14
705512 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12 2021   grade_2 5 0 5   0 0     0   0   8 2             *         10 5 0 5   0 0     0   0   8 2                 10
705530 ID     school 1600810 242   COTTONWOOD JOINT DISTRICT 160081000160 722 PRAIRIE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 23 0 0   0 0     0   1   15 9             8         24 23 0 0   0 0     0   1   15 9         8       24
705538 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 9 0 1   0 0     0   0   6 4             5         10 9 0 1   0 0     0   0   6 4         5       10
705566 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900961 1285 CLEARWATER VALLEY ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 18 0 1   1 0     0   1   11 10             *         21 18 0 1   1 0     0   1   11 10                 21
705573 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900946 1286 GRANGEVILLE ELEM/MIDDLE SCHOOL   Regular School No Elementary PK 08 2021   grade_2 50 0 2   0 0     0   1   32 21             22         53 50 0 2   0 0     0   1   32 21         22       53
705583 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2021   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
705596 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000634 723 HARWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 45 0 14   0 0     0   5   31 33             24         64 45 0 14   0 0     0   5   31 33         24       64
705603 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000274 724 MIDWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 43 0 14   0 0     0   1   33 25             26         58 43 0 14   0 0     0   1   33 25         26       58
705610 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000276 725 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 81 0 7   0 0     0   1   46 43             18         89 81 0 7   0 0     0   1   46 43         18       89
705617 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000278 726 ROBERTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 13 0 11   0 0     0   0   15 9             *         24 13 0 11   0 0     0   0   15 9                 24
705624 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001001 1110 SOUTH FORK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 115 0 5   0 1     0   4   62 63             26         125 115 0 5   0 1     0   4   62 63         26       125
705640 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001128 1437 COTTONWOOD ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 83 0 16   0 1     0   2   56 46             29         102 83 0 16   0 1     0   2   56 46         29       102
705651 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001132 1447 RIGBY VIRTUAL ACADEMY   Regular School No Elementary KG 08 2021   grade_2 20 0 5   0 0     0   2   6 21             *         27 20 0 5   0 0     0   2   6 21                 27
705668 ID     school 1602790 252   RIRIE JOINT DISTRICT 160279000435 229 RIRIE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 42 0 1   0 0     0   1   23 21             11         44 42 0 1   0 0     0   1   23 21         11       44
705681 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 29 0 9   0 0     0   0   26 12             *         38 29 0 9   0 0     0   0   26 12                 38
705689 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 6 0 1   0 0     0   0   4 3             *         7 6 0 1   0 0     0   0   4 3                 7
705712 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 55 0 94   0 0     0   1   78 72             80         150 55 0 94   0 0     0   1   78 72         80       150
705717 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 66 0 90   0 0     0   0   76 80             *         156 66 0 90   0 0     0   0   76 80                 156
705727 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_2 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
705736 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12 2021   grade_2 18 0 20   0 0     0   0   11 27             25         38 18 0 20   0 0     0   0   11 27         25       38
705760 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000799 217 SKYWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 88 0 9   0 0     1   2   57 43             23         100 88 0 9   0 0     1   2   57 43         23       100
705790 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000146 735 BORAH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 51 0 8   1 0     0   3   45 18             43         63 51 0 8   1 0     0   3   45 18         43       63
705811 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 65 0 3   1 2     0   4   43 32             18         75 65 0 3   1 2     0   4   43 32         18       75
705818 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000147 741 BRYAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 56 0 4   0 0     0   2   39 23             29         62 56 0 4   0 0     0   2   39 23         29       62
705825 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000156 742 SORENSEN MAGNET SCHOOL OF THE ARTS AND HUMANITIES   Regular School No Elementary PK 05 2021   grade_2 48 0 1   0 0     0   2   23 28             *         51 48 0 1   0 0     0   2   23 28                 51
705832 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000157 743 WINTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 41 0 5   0 0     0   4   26 24             31         50 41 0 5   0 0     0   4   26 24         31       50
705883 ID     school 1601800 272   LAKELAND DISTRICT 160180000313 745 SPIRIT LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 53 0 0   0 0     0   1   24 30             12         54 53 0 0   0 0     0   1   24 30         12       54
705890 ID     school 1601800 272   LAKELAND DISTRICT 160180000310 746 JOHN BROWN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 39 0 2   0 0     0   2   24 19             14         43 39 0 2   0 0     0   2   24 19         14       43
705897 ID     school 1601800 272   LAKELAND DISTRICT 160180000309 747 ATHOL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 36 0 4   1 0     0   4   17 28             16         45 36 0 4   1 0     0   4   17 28         16       45
705905 ID     school 1601800 272   LAKELAND DISTRICT 160180000734 761 GARWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 56 0 4   0 0     0   5   36 29             17         65 56 0 4   0 0     0   5   36 29         17       65
705912 ID     school 1601800 272   LAKELAND DISTRICT 160180000956 891 TWIN LAKES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 40 0 2   0 0     0   3   28 17             8         45 40 0 2   0 0     0   3   28 17         8       45
705952 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 58 0 6   1 0     0   1   40 26             21         66 58 0 6   1 0     0   1   40 26         21       66
705959 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 46 0 7   0 1     0   1   35 20             25         55 46 0 7   0 1     0   1   35 20         25       55
705971 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 43 0 3   0 1     0   3   25 25             9         50 43 0 3   0 1     0   3   25 25         9       50
705978 ID     school 1602670 273   POST FALLS DISTRICT 160267001129 1445 TREATY ROCK ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 57 0 7   1 1     0   1   26 41             30         67 57 0 7   1 1     0   1   26 41         30       67
705985 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 53 0 2   0 1     0   1   23 34             17         57 53 0 2   0 1     0   1   23 34         17       57
706000 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 13 0 1   0 0     0   0   4 10             *         14 13 0 1   0 0     0   0   4 10                 14
706024 ID     school 1602220 281   MOSCOW DISTRICT 160222000392 754 LENA WHITMORE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 27 0 3   1 0     0   0   16 15             *         31 27 0 3   1 0     0   0   16 15                 31
706045 ID     school 1601200 282   GENESEE JOINT DISTRICT 160120000845 269 GENESEE SCHOOL   Regular School No Other PK 12 2021   grade_2 16 0 2   0 0     0   0   9 9             *         18 16 0 2   0 0     0   0   9 9                 18

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