Data source: Big Local News · About: Big Local

4,737 rows where state = "ID" and year = 2018 sorted by black_int

View and edit SQL

year

  • 2018 · 1,735
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
1276161 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_4 74 1 7   0 6     2   7   48 49             7         97 74 1 7   0 6     2   7   48 49         7       97
1276163 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_6 93 1 13   0 9     1   1   68 50             15         118 93 1 13   0 9     1   1   68 50         15       118
1276165 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 6.0 2018   kindergarten 51 1 6   0 18     1   4   47 34             7         81 51 1 6   0 18     1   4   47 34         7       81
1276171 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_6 75 1 7   0 1     0   9   54 39             20         93 75 1 7   0 1     0   9   54 39         20       93
1276173 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2018   kindergarten 74 1 6   0 2     0   1   55 29             34         84 74 1 6   0 2     0   1   55 29         34       84
1276174 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_1 64 1 7   1 1     0   2   42 34             13         76 64 1 7   1 1     0   2   42 34         13       76
1276175 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 57 1 7   0 1     0   3   41 28             24         69 57 1 7   0 1     0   3   41 28         24       69
1276179 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 80 1 3   0 2     1   1   44 44             18         88 80 1 3   0 2     1   1   44 44         18       88
1276186 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 70 1 5   1 3     0   2   45 37             30         82 70 1 5   1 3     0   2   45 37         30       82
1276190 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_1 37 1 0   0 0     0   0   25 13             *         38 37 1 0   0 0     0   0   25 13                 38
1276203 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 41 1 12   2 4     1   2   38 25             *         63 41 1 12   2 4     1   2   38 25                 63
1276213 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   kindergarten 34 1 0   0 1     0   1   19 18             *         37 34 1 0   0 1     0   1   19 18                 37
1276223 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000056 307 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 33 1 0   0 3     0   2   25 14             *         39 33 1 0   0 3     0   2   25 14                 39
1276230 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_1 34 1 6   0 2     0   2   22 23             *         45 34 1 6   0 2     0   2   22 23                 45
1276231 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 31 1 10   0 5     0   1   26 22             *         48 31 1 10   0 5     0   1   26 22                 48
1276233 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_4 29 1 6   2 2     0   0   17 23             *         40 29 1 6   2 2     0   0   17 23                 40
1276234 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 23 1 4   0 4     0   2   13 21             *         34 23 1 4   0 4     0   2   13 21                 34
1276237 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   kindergarten 31 1 6   0 0     0   1   23 16             *         39 31 1 6   0 0     0   1   23 16                 39
1276238 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_1 31 1 2   1 2     0   1   19 19             7         38 31 1 2   1 2     0   1   19 19         7       38
1276243 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 39 1 1   1 2     0   3   24 23             *         47 39 1 1   1 2     0   3   24 23                 47
1276249 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_4 44 1 5   1 1     1   1   31 23             *         54 44 1 5   1 1     1   1   31 23                 54
1276251 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 38 1 2   1 0     0   1   19 24             *         43 38 1 2   1 0     0   1   19 24                 43
1276253 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   kindergarten 35 1 3   0 2     0   0   18 23             *         41 35 1 3   0 2     0   0   18 23                 41
1276258 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 25 1 7   0 2     0   3   19 19             *         38 25 1 7   0 2     0   3   19 19                 38
1276261 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   kindergarten 23 1 11   0 1     0   3   19 20             *         39 23 1 11   0 1     0   3   19 20                 39
1276298 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000075 320 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 50 1 11   0 2     0   3   33 34             *         67 50 1 11   0 2     0   3   33 34                 67
1276299 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000075 320 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 48 1 8   1 5     0   5   41 27             *         68 48 1 8   1 5     0   5   41 27                 68
1276314 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000068 322 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 43 1 7   0 0     0   4   29 26             *         55 43 1 7   0 0     0   4   29 26                 55
1276315 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000068 322 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 37 1 12   0 2     0   3   27 28             *         55 37 1 12   0 2     0   3   27 28                 55
1276319 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 49 1 3   0 0     0   1   21 33             7         54 49 1 3   0 0     0   1   21 33         7       54
1276322 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 50 1 2   0 0     0   2   24 31             7         55 50 1 2   0 0     0   2   24 31         7       55
1276323 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 38 1 2   0 1     0   3   21 24             6         45 38 1 2   0 1     0   3   21 24         6       45
1276338 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000060 325 KOELSCH ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 36 1 13   0 1     1   4   28 28             *         56 36 1 13   0 1     1   4   28 28                 56
1276348 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   k_12_total 201 1 9   0 25     0   8   121 123             36         244 201 1 9   0 25     0   8   121 123         36       244
1276349 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   kindergarten 18 1 1   0 1     0   0   11 10             *         21 18 1 1   0 1     0   0   11 10                 21
1276351 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000079 327 WHITTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 39 1 30   0 2     1   6   42 37             *         79 39 1 30   0 2     1   6   42 37                 79
1276355 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000079 327 WHITTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 25 1 22   0 3     0   2   29 24             *         53 25 1 22   0 3     0   2   29 24                 53
1276360 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_3 81 1 4   0 4     1   9   54 46             8         100 81 1 4   0 4     1   9   54 46         8       100
1276362 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 96 1 3   1 8     1   2   58 54             8         112 96 1 3   1 8     1   2   58 54         8       112
1276379 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2018   grade_8 23 1 1   0 6     0   1   18 14             *         32 23 1 1   0 6     0   1   18 14                 32
1276381 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2018   k_12_total 80 1 4   0 17     0   5   68 39             *         107 80 1 4   0 17     0   5   68 39                 107
1276385 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_4 44 1 7   0 2     1   4   32 27             *         59 44 1 7   0 2     1   4   32 27                 59
1276387 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 53 1 8   0 0     0   5   39 28             *         67 53 1 8   0 0     0   5   39 28                 67
1276395 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000706 666 WHITE PINE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 55 1 7   0 9     0   2   36 38             19         74 55 1 7   0 9     0   2   36 38         19       74
1276408 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000982 674 GRACE JORDAN ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_3 52 1 14   0 5     1   2   27 48             *         75 52 1 14   0 5     1   2   27 48                 75
1276410 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000982 674 GRACE JORDAN ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_5 50 1 24   2 2     1   1   33 48             *         81 50 1 24   2 2     1   1   33 48                 81
1276418 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12.0 2018   grade_8 5 1 1   0 0     0   0   5 2             *         7 5 1 1   0 0     0   0   5 2                 7
1276430 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 41 1 1   0 1     0   4   24 24             *         48 41 1 1   0 1     0   4   24 24                 48
1276436 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   kindergarten 36 1 2   0 0     0   2   20 21             *         41 36 1 2   0 0     0   2   20 21                 41
1276437 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2018   grade_10 3 1 1   0 0     0   1   4 2             *         6 3 1 1   0 0     0   1   4 2                 6
1276443 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2018   k_12_total 11 1 5   0 0     0   2   14 5             *         19 11 1 5   0 0     0   2   14 5                 19
1276462 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 341 1 34   3 4     4   8   210 185             68         395 341 1 34   3 4     4   8   210 185         68       395
1276464 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 365 1 34   4 5     0   23   223 209             65         432 365 1 34   4 5     0   23   223 209         65       432
1276479 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_1 72 1 16   1 0     0   7   48 49             40         97 72 1 16   1 0     0   7   48 49         40       97
1276482 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 82 1 21   2 1     0   2   63 46             49         109 82 1 21   2 1     0   2   63 46         49       109
1276483 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 62 1 20   1 2     0   2   52 36             45         88 62 1 20   1 2     0   2   52 36         45       88
1276485 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   kindergarten 55 1 9   0 0     0   9   35 39             28         74 55 1 9   0 0     0   9   35 39         28       74
1276488 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_3 52 1 15   1 2     1   6   45 33             19         78 52 1 15   1 2     1   6   45 33         19       78
1276490 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 78 1 12   1 2     1   6   57 44             33         101 78 1 12   1 2     1   6   57 44         33       101
1276495 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_3 74 1 11   0 0     0   2   45 43             22         88 74 1 11   0 0     0   2   45 43         22       88
1276496 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_4 94 1 9   0 0     0   5   50 59             20         109 94 1 9   0 0     0   5   50 59         20       109
1276499 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2018   kindergarten 73 1 13   2 1     0   4   53 41             24         94 73 1 13   2 1     0   4   53 41         24       94
1276500 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 295 1 27   0 5     1   10   184 155             77         339 295 1 27   0 5     1   10   184 155         77       339
1276501 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 304 1 35   1 1     1   10   197 156             71         353 304 1 35   1 1     1   10   197 156         71       353
1276505 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 109 1 12   0 2     0   4   66 62             13         128 109 1 12   0 2     0   4   66 62         13       128
1276508 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 148 1 16   0 0     2   5   82 90             17         172 148 1 16   0 0     2   5   82 90         17       172
1276518 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2018   grade_1 63 1 16   0 1     0   3   38 46             36         84 63 1 16   0 1     0   3   38 46         36       84
1276519 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2018   grade_2 61 1 15   0 1     0   2   35 45             39         80 61 1 15   0 1     0   2   35 45         39       80
1276527 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_3 42 1 7   1 0     0   1   18 34             14         52 42 1 7   1 0     0   1   18 34         14       52
1276531 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   kindergarten 41 1 0   0 1     1   3   22 25             9         47 41 1 0   0 1     1   3   22 25         9       47
1276532 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_1 60 1 9   0 0     0   6   38 38             18         76 60 1 9   0 0     0   6   38 38         18       76
1276533 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 52 1 10   0 3     2   4   38 34             25         72 52 1 10   0 3     2   4   38 34         25       72
1276534 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_3 67 1 7   0 1     0   6   48 34             24         82 67 1 7   0 1     0   6   48 34         24       82
1276535 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 60 1 9   0 3     0   4   31 46             21         77 60 1 9   0 3     0   4   31 46         21       77
1276536 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 62 1 7   2 2     1   2   39 38             26         77 62 1 7   2 2     1   2   39 38         26       77
1276543 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2018   grade_5 75 1 6   0 0     0   3   33 52             8         85 75 1 6   0 0     0   3   33 52         8       85
1276544 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2018   k_12_total 385 1 28   2 1     0   24   177 264             71         441 385 1 28   2 1     0   24   177 264         71       441
1276549 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No Elementary PK 5.0 2018   grade_4 46 1 10   1 1     1   4   32 32             25         64 46 1 10   1 1     1   4   32 32         25       64
1276563 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000374 335 USTICK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 42 1 19   1 7     0   5   40 35             49         75 42 1 19   1 7     0   5   40 35         49       75
1276566 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000374 335 USTICK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   kindergarten 53 1 7   2 6     1   3   44 29             27         73 53 1 7   2 6     1   3   44 29         27       73
1276570 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000371 336 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 45 1 9   1 0     0   2   29 29             24         58 45 1 9   1 0     0   2   29 29         24       58
1276589 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2018   grade_1 60 1 13   0 0     0   1   38 37             20         75 60 1 13   0 0     0   1   38 37         20       75
1276590 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2018   grade_2 56 1 10   0 1     0   3   31 40             16         71 56 1 10   0 1     0   3   31 40         16       71
1276591 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2018   grade_3 50 1 19   1 0     0   3   35 39             25         74 50 1 19   1 0     0   3   35 39         25       74
1276593 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2018   grade_5 58 1 17   1 1     0   4   49 33             33         82 58 1 17   1 1     0   4   49 33         33       82
1276598 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_3 80 1 13   0 0     0   5   50 49             23         99 80 1 13   0 0     0   5   50 49         23       99
1276600 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 107 1 8   0 2     0   6   61 63             24         124 107 1 8   0 2     0   6   61 63         24       124
1276605 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_3 66 1 9   0 3     1   4   47 37             15         84 66 1 9   0 3     1   4   47 37         15       84
1276606 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_4 60 1 11   0 1     0   5   38 40             *         78 60 1 11   0 1     0   5   38 40                 78
1276607 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_5 71 1 8   0 1     0   2   47 36             13         83 71 1 8   0 1     0   2   47 36         13       83
1276611 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 47 1 3   0 1     0   1   25 28             17         53 47 1 3   0 1     0   1   25 28         17       53
1276612 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_3 51 1 10   0 1     0   3   39 27             13         66 51 1 10   0 1     0   3   39 27         13       66
1276616 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   kindergarten 37 1 6   0 1     0   4   24 25             14         49 37 1 6   0 1     0   4   24 25         14       49
1276617 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_1 83 1 11   1 1     0   4   45 56             27         101 83 1 11   1 1     0   4   45 56         27       101
1276619 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_3 97 1 18   0 0     0   1   62 55             39         117 97 1 18   0 0     0   1   62 55         39       117
1276620 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 92 1 9   0 0     0   5   51 56             27         107 92 1 9   0 0     0   5   51 56         27       107
1276621 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 85 1 8   0 0     1   9   52 52             27         104 85 1 8   0 0     1   9   52 52         27       104
1276625 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2018   grade_2 102 1 10   0 2     0   6   51 70             23         121 102 1 10   0 2     0   6   51 70         23       121
1276628 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2018   grade_5 100 1 5   0 1     0   8   45 70             23         115 100 1 5   0 1     0   8   45 70         23       115
1276630 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2018   kindergarten 96 1 3   0 2     0   9   57 54             18         111 96 1 3   0 2     0   9   57 54         18       111

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