Data source: Big Local News · About: Big Local

4,856 rows where state = "ID" and year = 2020 sorted by black

View and edit SQL

grade

year

  • 2020 · 4,756
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
848880 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6 53 0 2   0 1     0   2   30 28             *         58 53 0 2   0 1     0   2   30 28                 58
848882 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten 30 0 1   0 0     0   1   15 17             *         32 30 0 1   0 0     0   1   15 17                 32
848883 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_10 5 0 0   0 0     0   0   5 0             *         5 5 0 0   0 0     0   0   5 0                 5
848884 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_11 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
848885 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_12 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
848886 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
848887 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
848888 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_9 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
848889 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   k_12_total 20 0 1   0 0     0   0   19 2             *         21 20 0 1   0 0     0   0   19 2                 21
848910 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 278 0 25   1 3     2   8   166 151             32         317 278 0 25   1 3     2   8   166 151         32       317
848914 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000318 112 EAGLE HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 468 0 28   2 9     0   11   261 257             32         518 468 0 28   2 9     0   11   261 257         32       518
848928 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 56 0 19   0 1     1   2   38 41             42         79 56 0 19   0 1     1   2   38 41         42       79
848932 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1 61 0 11   0 1     0   3   38 38             22         76 61 0 11   0 1     0   3   38 38         22       76
848933 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 60 0 8   1 3     0   2   35 39             22         74 60 0 8   1 3     0   2   35 39         22       74
848938 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten 50 0 15   1 2     0   4   38 34             22         72 50 0 15   1 2     0   4   38 34         22       72
848939 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 05 2020   grade_1 91 0 6   0 2     0   1   54 46             17         100 91 0 6   0 2     0   1   54 46         17       100
848940 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 76 0 9   0 1     0   3   47 42             24         89 76 0 9   0 1     0   3   47 42         24       89
848945 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 05 2020   kindergarten 81 0 7   2 3     0   4   48 49             22         97 81 0 7   2 3     0   4   48 49         22       97
848946 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 277 0 29   4 4     0   10   177 147             65         324 277 0 29   4 4     0   10   177 147         65       324
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
848965 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_2 74 0 14   0 2     0   4   47 47             44         94 74 0 14   0 2     0   4   47 47         44       94
848966 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_3 63 0 17   0 2     0   3   38 47             37         85 63 0 17   0 2     0   3   38 47         37       85
848968 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_5 59 0 16   0 2     0   4   44 37             32         81 59 0 16   0 2     0   4   44 37         32       81
848970 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   kindergarten 71 0 15   1 1     0   6   45 49             31         94 71 0 15   1 1     0   6   45 49         31       94
848974 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 35 0 12   0 2     0   5   28 26             26         54 35 0 12   0 2     0   5   28 26         26       54
848975 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 28 0 7   0 0     2   2   14 25             11         39 28 0 7   0 0     2   2   14 25         11       39
848977 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten 26 0 5   0 1     0   2   19 15             9         34 26 0 5   0 1     0   2   19 15         9       34
848978 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1 56 0 6   0 2     0   7   26 45             18         71 56 0 6   0 2     0   7   26 45         18       71
848979 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 81 0 10   0 3     2   5   46 55             22         101 81 0 10   0 3     2   5   46 55         22       101
848984 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten 56 0 7   0 2     0   7   41 31             14         72 56 0 7   0 2     0   7   41 31         14       72
848985 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_1 53 0 4   1 0     0   1   20 39             10         59 53 0 4   1 0     0   1   20 39         10       59
848986 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_2 61 0 3   2 0     0   1   31 36             13         67 61 0 3   2 0     0   1   31 36         13       67
848987 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_3 63 0 11   1 0     0   3   29 49             14         78 63 0 11   1 0     0   3   29 49         14       78
848988 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_4 58 0 4   1 0     0   4   22 45             12         67 58 0 4   1 0     0   4   22 45         12       67
848989 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_5 72 0 10   0 0     0   2   39 45             13         84 72 0 10   0 0     0   2   39 45         13       84
848990 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   k_12_total 351 0 34   5 0     0   13   167 236             70         403 351 0 34   5 0     0   13   167 236         70       403
848991 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   kindergarten 44 0 2   0 0     0   2   26 22             8         48 44 0 2   0 0     0   2   26 22         8       48
848999 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1 70 0 13   0 0     0   4   47 40             27         87 70 0 13   0 0     0   4   47 40         27       87
849000 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 92 0 8   1 0     0   5   54 52             19         106 92 0 8   1 0     0   5   54 52         19       106
849001 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3 96 0 6   3 1     0   0   55 51             16         106 96 0 6   3 1     0   0   55 51         16       106
849002 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 77 0 12   1 1     1   4   53 43             19         96 77 0 12   1 1     1   4   53 43         19       96
849003 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 101 0 9   0 1     0   4   59 56             21         115 101 0 9   0 1     0   4   59 56         21       115
849004 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   k_12_total 509 0 56   6 3     1   20   302 293             123         595 509 0 56   6 3     1   20   302 293         123       595
849005 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten 73 0 8   1 0     0   3   34 51             21         85 73 0 8   1 0     0   3   34 51         21       85
849016 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000371 336 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 56 0 18   0 0     0   1   39 36             *         75 56 0 18   0 0     0   1   39 36                 75
849019 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000371 336 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten 63 0 20   0 2     0   3   51 37             *         88 63 0 20   0 2     0   3   51 37                 88
849023 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000363 337 McMillan Elementary   Regular School No Elementary PK 05 2020   grade_4 22 0 13   1 3     0   1   22 18             24         40 22 0 13   1 3     0   1   22 18         24       40
849027 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 06 2020   grade_1 63 0 4   0 0     1   3   33 38             16         71 63 0 4   0 0     1   3   33 38         16       71
849028 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 06 2020   grade_2 72 0 3   0 1     0   8   31 53             11         84 72 0 3   0 1     0   8   31 53         11       84
849030 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 06 2020   grade_4 75 0 7   2 3     1   3   34 57             16         91 75 0 7   2 3     1   3   34 57         16       91
849031 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 06 2020   grade_5 68 0 7   1 1     0   9   38 48             20         86 68 0 7   1 1     0   9   38 48         20       86
849032 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 06 2020   grade_6 43 0 6   1 0     0   4   18 36             18         54 43 0 6   1 0     0   4   18 36         18       54
849034 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 06 2020   kindergarten 54 0 3   0 2     0   6   30 35             9         65 54 0 3   0 2     0   6   30 35         9       65
849037 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 05 2020   grade_3 60 0 15   0 0     0   1   43 33             23         76 60 0 15   0 0     0   1   43 33         23       76
849039 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 05 2020   grade_5 64 0 19   1 1     0   4   46 43             26         89 64 0 19   1 1     0   4   46 43         26       89
849042 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1 85 0 8   0 1     0   2   46 50             14         96 85 0 8   0 1     0   2   46 50         14       96
849043 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 91 0 4   0 1     0   5   48 53             12         101 91 0 4   0 1     0   5   48 53         12       101
849046 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 108 0 9   0 0     0   3   68 52             18         120 108 0 9   0 0     0   3   68 52         18       120
849048 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten 66 0 7   0 0     0   1   42 32             9         74 66 0 7   0 0     0   1   42 32         9       74
849050 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 69 0 6   0 2     0   6   46 37             14         83 69 0 6   0 2     0   6   46 37         14       83
849051 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 05 2020   grade_3 75 0 11   0 1     0   6   46 47             14         93 75 0 11   0 1     0   6   46 47         14       93
849052 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 05 2020   grade_4 84 0 7   0 2     1   4   53 45             17         98 84 0 7   0 2     1   4   53 45         17       98
849058 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3 51 0 2   0 3     0   3   32 27             14         59 51 0 2   0 3     0   3   32 27         14       59
849060 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 56 0 9   0 0     0   3   35 33             9         68 56 0 9   0 0     0   3   35 33         9       68
849063 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1 104 0 13   0 1     0   7   58 67             24         125 104 0 13   0 1     0   7   58 67         24       125
849064 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 92 0 14   0 1     1   5   68 45             38         113 92 0 14   0 1     1   5   68 45         38       113
849066 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 95 0 16   0 3     0   4   63 55             33         118 95 0 16   0 3     0   4   63 55         33       118
849067 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 105 0 22   1 0     0   2   68 62             35         130 105 0 22   1 0     0   2   68 62         35       130
849070 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_1 104 0 10   0 0     0   7   50 71             22         121 104 0 10   0 0     0   7   50 71         22       121
849074 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_5 106 0 8   0 0     1   3   52 66             14         118 106 0 8   0 0     1   3   52 66         14       118
849080 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 81 0 8   1 2     0   2   46 48             11         94 81 0 8   1 2     0   2   46 48         11       94
849084 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 05 2020   grade_1 65 0 5   0 5     0   4   41 38             *         79 65 0 5   0 5     0   4   41 38                 79
849085 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 57 0 4   0 3     1   5   41 29             21         70 57 0 4   0 3     1   5   41 29         21       70
849088 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 05 2020   grade_5 93 0 6   1 1     1   4   57 49             19         106 93 0 6   1 1     1   4   57 49         19       106
849090 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 05 2020   kindergarten 62 0 7   0 3     0   2   33 41             *         74 62 0 7   0 3     0   2   33 41                 74
849091 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 05 2020   grade_1 76 0 9   0 0     1   2   46 42             16         88 76 0 9   0 0     1   2   46 42         16       88
849092 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 62 0 2   0 1     0   4   29 40             20         69 62 0 2   0 1     0   4   29 40         20       69
849093 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 05 2020   grade_3 63 0 7   1 0     1   1   32 41             13         73 63 0 7   1 0     1   1   32 41         13       73
849094 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 05 2020   grade_4 41 0 12   0 0     1   3   24 33             16         57 41 0 12   0 0     1   3   24 33         16       57
849097 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 05 2020   kindergarten 50 0 6   2 1     0   5   28 36             13         64 50 0 6   2 1     0   5   28 36         13       64
849102 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 05 2020   grade_5 101 0 13   2 1     0   6   68 55             24         123 101 0 13   2 1     0   6   68 55         24       123
849104 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 05 2020   kindergarten 110 0 7   0 1     1   6   70 55             21         125 110 0 7   0 1     1   6   70 55         21       125
849105 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 05 2020   grade_1 41 0 3   0 2     0   4   30 20             9         50 41 0 3   0 2     0   4   30 20         9       50
849111 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 05 2020   kindergarten 50 0 6   0 3     0   0   37 22             9         59 50 0 6   0 3     0   0   37 22         9       59
849133 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 06 08 2020   grade_8 49 0 2   0 0     0   0   33 18             22         51 49 0 2   0 0     0   0   33 18         22       51
849138 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000903 597 CENTRAL ACADEMY HIGH SCHOOL   Alternative School No High 09 12 2020   grade_9 22 0 2   2 0     0   2   16 12             10         28 22 0 2   2 0     0   2   16 12         10       28
849148 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 05 2020   grade_4 101 0 14   1 4     0   3   66 57             16         123 101 0 14   1 4     0   3   66 57         16       123
849149 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 05 2020   grade_5 115 0 7   1 3     0   9   80 55             15         135 115 0 7   1 3     0   9   80 55         15       135
849153 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative School No High 09 12 2020   grade_11 51 0 6   0 0     0   4   39 22             18         61 51 0 6   0 0     0   4   39 22         18       61
849155 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative School No High 09 12 2020   grade_9 11 0 0   0 0     0   1   6 6             *         12 11 0 0   0 0     0   1   6 6                 12
849157 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 08 2020   grade_6 41 0 4   0 0     0   4   29 20             23         49 41 0 4   0 0     0   4   29 20         23       49
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
849159 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 08 2020   grade_8 44 0 5   0 0     0   1   26 24             25         50 44 0 5   0 0     0   1   26 24         25       50
849160 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 08 2020   k_12_total 125 0 14   0 0     0   8   85 62             76         147 125 0 14   0 0     0   8   85 62         76       147
849161 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000714 1228 MERIDIAN ACADEMY   Alternative School No High 09 12 2020   grade_10 42 0 4   1 1     0   0   32 16             24         48 42 0 4   1 1     0   0   32 16         24       48
849162 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000714 1228 MERIDIAN ACADEMY   Alternative School No High 09 12 2020   grade_11 43 0 2   0 1     0   0   21 25             18         46 43 0 2   0 1     0   0   21 25         18       46
849163 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000714 1228 MERIDIAN ACADEMY   Alternative School No High 09 12 2020   grade_12 44 0 6   0 0     0   2   32 20             *         52 44 0 6   0 0     0   2   32 20                 52
849166 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001000 1235 RENAISSANCE HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 142 0 19   0 14     0   8   68 115             20         183 142 0 19   0 14     0   8   68 115         20       183
849167 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001000 1235 RENAISSANCE HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 148 0 17   1 19     0   10   99 96             25         195 148 0 17   1 19     0   10   99 96         25       195
849168 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001000 1235 RENAISSANCE HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 109 0 13   0 11     0   5   69 69             13         138 109 0 13   0 11     0   5   69 69         13       138

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