Data source: Big Local News · About: Big Local

4,725 rows where state = "ID" and year = 2017 sorted by ccd_school_high_grade

View and edit SQL

grade

year

  • 2017 · 4,725
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
1726928 ID     school   84   LAKE PEND OREILLE SCHOOL DISTRICT   1391 LPOSD HOME SCHOOL ACADEMY             2017   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1726929 ID     school   84   LAKE PEND OREILLE SCHOOL DISTRICT   1391 LPOSD HOME SCHOOL ACADEMY             2017   k_12_total 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727070 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727071 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2017   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727072 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2017   grade_11 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727073 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2017   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1727074 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2017   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1727718 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_1 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727719 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727720 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_3 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1727721 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727722 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_6 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1727723 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   k_12_total 4 0 2   0 0     0   0   3 3             *         6 4 0 2   0 0     0   0   3 3                 6
1727724 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_10 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1727725 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727726 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_7 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
1727727 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_8 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727728 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727729 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   k_12_total 5 0 4   0 0     0   0   8 1             *         9 5 0 4   0 0     0   0   8 1                 9
1729035 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_10 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1729036 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_11 1 0 0   0 0     1   0   2 0             *         2 1 0 0   0 0     1   0   2 0                 2
1729037 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729038 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_2 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
1729039 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_3 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1729040 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_5 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
1729041 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1729042 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729043 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729044 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_9 2 0 0   1 0     0   0   2 1             *         3 2 0 0   1 0     0   0   2 1                 3
1729045 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   k_12_total 12 0 0   3 0     1   1   15 2             *         17 12 0 0   3 0     1   1   15 2                 17
1729199 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2017   grade_10 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1729200 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729201 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2017   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1726588 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000516 377 MORELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 1.0 2017   grade_1 112 1 19   2 0     0   1   65 70             68         135 112 1 19   2 0     0   1   65 70         68       135
1726589 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000516 377 MORELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 1.0 2017   k_12_total 202 1 43   3 0     0   4   133 120             131         253 202 1 43   3 0     0   4   133 120         131       253
1726590 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000516 377 MORELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 1.0 2017   kindergarten 90 0 24   1 0     0   3   68 50             63         118 90 0 24   1 0     0   3   68 50         63       118
1729789 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 1.0 2017   grade_1 21 0 3   0 0     0   0   12 12             *         24 21 0 3   0 0     0   0   12 12                 24
1729790 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 1.0 2017   k_12_total 41 2 5   0 0     0   0   28 20             *         48 41 2 5   0 0     0   0   28 20                 48
1729791 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 1.0 2017   kindergarten 20 2 2   0 0     0   0   16 8             *         24 20 2 2   0 0     0   0   16 8                 24
1730049 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_1 44 1 1   0 1     2   1   25 25             19         50 44 1 1   0 1     2   1   25 25         19       50
1730050 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_10 14 0 0   0 0     0   1   7 8             *         15 14 0 0   0 0     0   1   7 8                 15
1730051 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_11 7 0 0   0 0     0   0   4 3             *         7 7 0 0   0 0     0   0   4 3                 7
1730052 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_2 45 1 2   1 1     0   1   28 23             22         51 45 1 2   1 1     0   1   28 23         22       51
1730053 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_3 51 0 1   0 0     0   3   33 22             21         55 51 0 1   0 0     0   3   33 22         21       55
1730054 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_4 51 0 2   0 0     0   6   35 24             20         59 51 0 2   0 0     0   6   35 24         20       59
1730055 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_5 55 0 3   0 0     0   1   37 22             22         59 55 0 3   0 0     0   1   37 22         22       59
1730056 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_6 54 0 1   0 3     0   2   37 23             23         60 54 0 1   0 3     0   2   37 23         23       60
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
1730058 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_8 28 0 1   0 0     0   1   20 10             12         30 28 0 1   0 0     0   1   20 10         12       30
1730059 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_9 17 0 1   0 0     0   0   9 9             6         18 17 0 1   0 0     0   0   9 9         6       18
1730060 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   k_12_total 438 2 14   1 6     2   19   268 214             173         482 438 2 14   1 6     2   19   268 214         173       482
1730061 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   kindergarten 43 0 2   0 0     0   2   16 31             13         47 43 0 2   0 0     0   2   16 31         13       47
1730072 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_1 24 0 0   0 0     0   0   11 13             5         24 24 0 0   0 0     0   0   11 13         5       24
1730073 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_10 6 0 0   0 1     0   0   4 3             *         7 6 0 0   0 1     0   0   4 3                 7
1730074 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_11 6 0 0   1 0     0   0   3 4             *         7 6 0 0   1 0     0   0   3 4                 7
1730075 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_2 24 0 1   0 0     0   1   10 16             5         26 24 0 1   0 0     0   1   10 16         5       26
1730076 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_3 24 0 1   0 0     0   1   14 12             *         26 24 0 1   0 0     0   1   14 12                 26
1730077 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_4 27 0 1   0 0     0   0   13 15             5         28 27 0 1   0 0     0   0   13 15         5       28
1730078 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_5 25 0 2   0 0     0   1   13 15             5         28 25 0 2   0 0     0   1   13 15         5       28
1730079 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_6 27 0 2   0 0     0   0   12 17             5         29 27 0 2   0 0     0   0   12 17         5       29
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
1730081 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_8 26 0 1   0 0     0   0   14 13             6         27 26 0 1   0 0     0   0   14 13         6       27
1730082 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_9 15 0 0   0 0     0   1   8 8             *         16 15 0 0   0 0     0   1   8 8                 16
1730083 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   k_12_total 273 1 11   1 1     0   7   133 161             49         294 273 1 11   1 1     0   7   133 161         49       294
1730084 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   kindergarten 44 1 1   0 0     0   2   22 26             *         48 44 1 1   0 0     0   2   22 26                 48
1725583 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 406 18 28   4 18     6   13   230 263             89         493 406 18 28   4 18     6   13   230 263         89       493
1725584 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 458 19 32   0 32     1   15   282 275             92         557 458 19 32   0 32     1   15   282 275         92       557
1725585 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_12 402 11 42   0 22     2   7   230 256             86         486 402 11 42   0 22     2   7   230 256         86       486
1725586 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   k_12_total 1266 48 102   4 72     9   35   742 794             267         1536 1266 48 102   4 72     9   35   742 794         267       1536
1725824 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000817 563 DEHRYL A DENNIS PROF-TECH CENTER   Career and Technical School No High 07 12.0 2017   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1725825 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000817 563 DEHRYL A DENNIS PROF-TECH CENTER   Career and Technical School No High 07 12.0 2017   k_12_total 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1725826 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_10 4 0 1   0 2     0   0   3 4             *         7 4 0 1   0 2     0   0   3 4                 7
1725827 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_11 6 0 0   0 1     0   0   3 4             *         7 6 0 0   0 1     0   0   3 4                 7
1725828 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_12 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1725829 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_6 9 0 1   0 1     0   1   11 1             *         12 9 0 1   0 1     0   1   11 1                 12
1725830 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_7 18 2 2   0 6     0   0   15 13             *         28 18 2 2   0 6     0   0   15 13                 28
1725831 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_8 18 0 2   0 3     0   2   15 10             *         25 18 0 2   0 3     0   2   15 10                 25
1725832 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_9 15 0 0   0 0     0   0   10 5             *         15 15 0 0   0 0     0   0   10 5                 15
1725833 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   k_12_total 72 2 6   0 13     0   3   58 38             *         96 72 2 6   0 13     0   3   58 38                 96
1725866 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_10 81 7 28   2 0     1   2   60 61             *         121 81 7 28   2 0     1   2   60 61                 121
1725867 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_11 82 3 26   2 3     0   2   58 60             *         118 82 3 26   2 3     0   2   58 60                 118
1725868 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_12 124 8 37   3 4     1   2   90 89             *         179 124 8 37   3 4     1   2   90 89                 179
1725869 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_7 2 1 0   0 0     0   0   2 1             *         3 2 1 0   0 0     0   0   2 1                 3
1725870 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_8 2 0 1   0 0     0   1   4 0             *         4 2 0 1   0 0     0   1   4 0                 4
1725871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_9 68 5 30   0 1     1   1   66 40             *         106 68 5 30   0 1     1   1   66 40                 106
1725872 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   k_12_total 359 24 122   7 8     3   8   280 251             *         531 359 24 122   7 8     3   8   280 251                 531
1725889 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_10 7 0 0   1 0     0   0   6 2             *         8 7 0 0   1 0     0   0   6 2                 8
1725890 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_11 4 0 1   0 0     0   0   5 0             *         5 4 0 1   0 0     0   0   5 0                 5
1725891 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_12 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1725892 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1725893 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 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
1725894 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_9 5 0 0   1 0     0   0   6 0             *         6 5 0 0   1 0     0   0   6 0                 6
1725895 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   k_12_total 21 0 1   2 0     0   0   22 2             *         24 21 0 1   2 0     0   0   22 2                 24
1725904 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 298 6 54   3 3     0   11   183 192             137         375 298 6 54   3 3     0   11   183 192         137       375
1725905 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 324 4 75   3 5     2   14   217 210             124         427 324 4 75   3 5     2   14   217 210         124       427
1725906 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_12 303 5 41   4 3     1   12   203 166             104         369 303 5 41   4 3     1   12   203 166         104       369
1725907 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 361 7 77   2 3     1   18   242 227             179         469 361 7 77   2 3     1   18   242 227         179       469
1725908 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   k_12_total 1286 22 247   12 14     4   55   845 795             544         1640 1286 22 247   12 14     4   55   845 795         544       1640
1725909 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 351 17 51   1 26     1   15   231 231             152         462 351 17 51   1 26     1   15   231 231         152       462
1725910 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 341 8 44   2 19     3   14   226 205             103         431 341 8 44   2 19     3   14   226 205         103       431

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