Data source: Big Local News · About: Big Local

4,126 rows where grade = "grade_9" and state = "WA" sorted by district_state_id descending

View and edit SQL

year

grade

  • grade_9 · 4,126
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
474746 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No 4.0 06 12 2015   grade_9 18 0 13   0 0     0   1   17 15 0   5   1   17       2.0 32 18 0 13   0 0     0   1   17 15 0   5 1 17     2 32
534701 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No 4 06 12 2016   grade_9 21 0 6   0 0     0   2   16 13 0   2   2   18       0.0 29 21 0 6   0 0     0   2   16 13 0   2 2 18     0 29
632037 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No Other 06 12 2017   grade_9 9 0 10   0 0     0   2   11 10 0   5   1   17       0.0 21 9 0 10   0 0     0   2   11 10 0   5 1 17     0 21
2427724 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No High 06 12 2019   grade_9 12 0 8   2 1     0   0   9 14 0   0   0   13       0.0 23 12 0 8   2 1     0   0   9 14 0   0 0 13     0 23
2472239 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No High 06 12 2018   grade_9 21 0 5   0 0     0   0   7 19 0   2   0   12       0.0 26 21 0 5   0 0     0   0   7 19 0   2 0 12     0 26
2585154 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No High 06 12 2020   grade_9 15 0 11   1 0     0   0   11 16 0   1   0   16       0.0 27 15 0 11   1 0     0   0   11 16 0   1 0 16     0 27
2946197 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No High 06 12 2021   grade_9 14 0 10   0 0     0   1   15 9 1   1   0   11       0.0 25 14 0 10   0 0     0   1   15 9 1   1 0 11     0 25
466680 WA Douglas   school 5304710 9207   Mansfield School District 530471000726 2233 Mansfield Elem and High School   Regular School No 4.0 PK 12 2015   grade_9 6 0 1   0 0     0   0   2 5 0   0   0   5       0.0 7 6 0 1   0 0     0   0   2 5 0   0 0 5     0 7
526629 WA Douglas   school 5304710 9207   Mansfield School District 530471000726 2233 Mansfield Elem and High School   Regular School No 4 PK 12 2016   grade_9 5 0 3   1 0     0   1   5 5 0   2   1   7       0.0 10 5 0 3   1 0     0   1   5 5 0   2 1 7     0 10
624005 WA Douglas   school 5304710 9207   Mansfield School District 530471000726 2233 Mansfield Elem and High School   Regular School No Other PK 12 2017   grade_9 8 0 0   0 1     0   0   6 3 0   0   1   6       0.0 9 8 0 0   0 1     0   0   6 3 0   0 1 6     0 9
2419885 WA Douglas   school 5304710 9207   Mansfield School District 530471000726 2233 Mansfield Elem and High School   Regular School No Other PK 12 2019   grade_9 3 1 2   1 0     0   0   3 4 0   1   0   4       0.0 7 3 1 2   1 0     0   0   3 4 0   1 0 4     0 7
2464343 WA Douglas   school 5304710 9207   Mansfield School District 530471000726 2233 Mansfield Elem and High School   Regular School No Other PK 12 2018   grade_9 3 0 1   1 0     0   0   4 1 0   1   0   4       0.0 5 3 0 1   1 0     0   0   4 1 0   1 0 4     0 5
2577233 WA Douglas   school 5304710 9207   Mansfield School District 530471000726 2233 Mansfield Elem and High School   Regular School No Other PK 12 2020   grade_9 5 0 2   0 0     0   0   3 4 0   0   0   7       0.0 7 5 0 2   0 0     0   0   3 4 0   0 0 7     0 7
2938109 WA Douglas   school 5304710 9207   Mansfield School District 530471000726 2233 Mansfield Elem and High School   Regular School No Other PK 12 2021   grade_9 5 0 7   0 0     0   0   5 7 0   0   0   9       0.0 12 5 0 7   0 0     0   0   5 7 0   0 0 9     0 12
462665 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No 4.0 08 09 2015   grade_9 219 2 186   1 3     0   16   212 215 0   52   13   241       18.0 427 219 2 186   1 3     0   16   212 215 0   52 13 241     18 427
462672 WA Douglas   school 5302310 9206   Eastmont School District 530231000318 2727 Eastmont Senior High   Regular School No 3.0 10 12 2015   grade_9 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
522648 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No 4 06 12 2016   grade_9 234 3 194   2 10     2   11   240 216 0   33   9   240       13.0 456 234 3 194   2 10     2   11   240 216 0   33 9 240     13 456
620022 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2017   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
620028 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No Other 08 09 2017   grade_9 241 1 202   1 1     0   11   226 231 0   58   12   261       16.0 457 241 1 202   1 1     0   11   226 231 0   58 12 261     16 457
620035 WA Douglas   school 5302310 9206   Eastmont School District 530231000318 2727 Eastmont Senior High   Regular School No High 10 12 2017   grade_9 6 0 0   0 0     0   0   1 5 0   0   0   3       1.0 6 6 0 0   0 0     0   0   1 5 0   0 0 3     1 6
2415969 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No Secondary 08 09 2019   grade_9 212 4 220   0 3     0   16   232 223 0   77   21   278       27.0 455 212 4 220   0 3     0   16   232 223 0   77 21 278     27 455
2460472 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No Secondary 08 09 2018   grade_9 226 1 227   3 5     1   17   237 243 0   59   2   281       18.0 480 226 1 227   3 5     1   17   237 243 0   59 2 281     18 480
2460479 WA Douglas   school 5302310 9206   Eastmont School District 530231000318 2727 Eastmont Senior High   Regular School No High 10 12 2018   grade_9 2 0 2   0 0     0   1   2 3 0   0   0   3       2.0 5 2 0 2   0 0     0   1   2 3 0   0 0 3     2 5
2460514 WA Douglas   school 5302310 9206   Eastmont School District 530231001762 4095 Sterling School   Regular School No Elementary KG 07 2018   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2573304 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No Secondary 08 09 2020   grade_9 221 1 233   2 1     1   7   244 222 0   73   19   282       26.0 466 221 1 233   2 1     1   7   244 222 0   73 19 282     26 466
2934188 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No Secondary 08 09 2021   grade_9 247 2 245   2 5     1   22   264 259 1   55   15   287       39.0 524 247 2 245   2 5     1   22   264 259 1   55 15 287     39 524
2934197 WA Douglas   school 5302310 9206   Eastmont School District 530231000318 2727 Eastmont Senior High   Regular School No High 10 12 2021   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
461040 WA Douglas   school 5300720 9075   Bridgeport School District 530072002890 1900 Bridgeport Aurora High School   Alternative Education School No 3.0 09 12 2015   grade_9 0 0 1   0 0     0   0   1 0 0   0   0   1       1.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     1 1
461054 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No 3.0 09 12 2015   grade_9 10 0 49   0 0     0   1   32 28 0   13   2   59       1.0 60 10 0 49   0 0     0   1   32 28 0   13 2 59     1 60
521017 WA Douglas   school 5300720 9075   Bridgeport School District 530072002890 1900 Bridgeport Aurora High School   Alternative Education School No 3 09 12 2016   grade_9 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
521030 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No 3 09 12 2016   grade_9 5 0 69   0 0     0   0   51 23 0   27   3   72       5.0 74 5 0 69   0 0     0   0   51 23 0   27 3 72     5 74
618387 WA Douglas   school 5300720 9075   Bridgeport School District 530072002890 1900 Bridgeport Aurora High School   Alternative School No High 09 12 2017   grade_9 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
618400 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No High 09 12 2017   grade_9 3 0 64   1 0     0   1   38 31 0   24   4   67       3.0 69 3 0 64   1 0     0   1   38 31 0   24 4 67     3 69
2414334 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No High 09 12 2019   grade_9 5 0 56   0 0     0   0   34 27 0   24   5   57       1.0 61 5 0 56   0 0     0   0   34 27 0   24 5 57     1 61
2458884 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No High 09 12 2018   grade_9 0 0 62   1 0     0   0   33 30 0   27   5   61       2.0 63 0 0 62   1 0     0   0   33 30 0   27 5 61     2 63
2571647 WA Douglas   school 5300720 9075   Bridgeport School District 530072002890 1900 Bridgeport Aurora High School   Alternative School No High 09 12 2020   grade_9 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
2571662 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No High 09 12 2020   grade_9 5 0 47   0 0     0   0   18 34 0   19   0   49       3.0 52 5 0 47   0 0     0   0   18 34 0   19 0 49     3 52
2932558 WA Douglas   school 5300720 9075   Bridgeport School District 530072000151 2788 Bridgeport High School   Regular School No High 09 12 2021   grade_9 1 0 54   0 0     0   0   27 28 0   25   4   53       6.0 55 1 0 54   0 0     0   0   27 28 0   25 4 53     6 55
465195 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No 3.0 09 12 2015   grade_9 315 3 49   8 5     1   27   200 208 0   13   4   213       16.0 408 315 3 49   8 5     1   27   200 208 0   13 4 213     16 408
465204 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative Education School No 3.0 08 12 2015   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
525155 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No 3 09 12 2016   grade_9 276 1 68   8 5     3   35   208 188 0   17   10   219       14.0 396 276 1 68   8 5     3   35   208 188 0   17 10 219     14 396
525160 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No 3 08 12 2016   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
525165 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative Education School No 3 09 12 2016   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
622524 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2017   grade_9 258 1 59   10 2     4   26   167 193 0   12   5   182       14.0 360 258 1 59   10 2     4   26   167 193 0   12 5 182     14 360
622529 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2017   grade_9 3 0 0   0 0     0   0   2 1 0   0   0   2       1.0 3 3 0 0   0 0     0   0   2 1 0   0 0 2     1 3
622534 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2017   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   1       2.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     2 2
2418403 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2019   grade_9 259 0 76   4 4     2   22   188 179 0   18   11   210       17.0 367 259 0 76   4 4     2   22   188 179 0   18 11 210     17 367
2418408 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2019   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2418413 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2019   grade_9 3 0 0   0 0     0   0   1 2 0   0   0   1       1.0 3 3 0 0   0 0     0   0   1 2 0   0 0 1     1 3
2462889 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2018   grade_9 291 1 62   8 4     6   23   203 192 0   18   7   217       15.0 395 291 1 62   8 4     6   23   203 192 0   18 7 217     15 395
2462895 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2018   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2575750 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2020   grade_9 277 2 89   3 6     7   27   220 191 0   28   10   234       18.0 411 277 2 89   3 6     7   27   220 191 0   28 10 234     18 411
2575755 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No High 08 12 2020   grade_9 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
2575760 WA Cowlitz   school 5300003 8458   Kelso School District 530000303109 1934 Loowit High School   Alternative School No High 09 12 2020   grade_9 3 0 0   0 0     0   1   2 2 0   0   0   2       0.0 4 3 0 0   0 0     0   1   2 2 0   0 0 2     0 4
2936620 WA Cowlitz   school 5300003 8458   Kelso School District 530000300593 2266 Kelso High School   Regular School No High 09 12 2021   grade_9 196 1 74   5 3     3   22   156 148 0   12   5   188       13.0 304 196 1 74   5 3     3   22   156 148 0   12 5 188     13 304
2936633 WA Cowlitz   school 5300003 8458   Kelso School District 530000303314 5194 Kelso Virtual Academy   Regular School No Other KG 12 2021   grade_9 52 2 4   1 0     0   1   27 33 0   0   1   24       3.0 60 52 2 4   1 0     0   1   27 33 0   0 1 24     3 60
475213 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative Education School No 4.0 KG 12 2015   grade_9 4 0 0   0 0     0   0   1 3 0   0   0   2       0.0 4 4 0 0   0 0     0   0   1 3 0   0 0 2     0 4
475219 WA Cowlitz   school 5310050 8404   Woodland School District 531005002713 1795 Woodland Alternative School   Alternative Education School No 3.0 09 12 2015   grade_9 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
475224 WA Cowlitz   school 5310050 8404   Woodland School District 531005001682 3546 Woodland High School   Regular School No 3.0 09 12 2015   grade_9 126 3 22   3 1     0   7   86 76 0   6   2   85       7.0 162 126 3 22   3 1     0   7   86 76 0   6 2 85     7 162
535151 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative Education School No 4 KG 12 2016   grade_9 0 0 2   0 0     0   0   2 0 0   0   0   2       0.0 2 0 0 2   0 0     0   0   2 0 0   0 0 2     0 2
535157 WA Cowlitz   school 5310050 8404   Woodland School District 531005002713 1795 Woodland Alternative School   Alternative Education School No 3 09 12 2016   grade_9 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
535162 WA Cowlitz   school 5310050 8404   Woodland School District 531005001682 3546 Woodland High School   Regular School No 3 09 12 2016   grade_9 152 1 32   0 0     0   3   108 80 0   3   3   89       6.0 188 152 1 32   0 0     0   3   108 80 0   3 3 89     6 188
632500 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   grade_9 2 0 1   0 0     0   0   2 1 0   0   0   2       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 2     0 3
632506 WA Cowlitz   school 5310050 8404   Woodland School District 531005002713 1795 Woodland Alternative School   Alternative School No High 09 12 2017   grade_9 3 0 0   1 0     0   0   2 2 0   0   0   2       0.0 4 3 0 0   1 0     0   0   2 2 0   0 0 2     0 4
632511 WA Cowlitz   school 5310050 8404   Woodland School District 531005001682 3546 Woodland High School   Regular School No High 09 12 2017   grade_9 128 0 36   0 2     0   6   86 86 0   4   5   93       5.0 172 128 0 36   0 2     0   6   86 86 0   4 5 93     5 172
2428180 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2019   grade_9 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2428186 WA Cowlitz   school 5310050 8404   Woodland School District 531005002713 1795 Woodland Alternative School   Alternative School No High 09 12 2019   grade_9 3 0 0   0 0     0   0   0 3 0   0   0   2       0.0 3 3 0 0   0 0     0   0   0 3 0   0 0 2     0 3
2428191 WA Cowlitz   school 5310050 8404   Woodland School District 531005001682 3546 Woodland High School   Regular School No High 09 12 2019   grade_9 143 2 38   0 0     0   9   115 77 0   10   8   93       4.0 192 143 2 38   0 0     0   9   115 77 0   10 8 93     4 192
2472714 WA Cowlitz   school 5310050 8404   Woodland School District 531005001682 3546 Woodland High School   Regular School No High 09 12 2018   grade_9 158 2 31   0 1     0   2   103 91 0   3   6   98       10.0 194 158 2 31   0 1     0   2   103 91 0   3 6 98     10 194
2585632 WA Cowlitz   school 5310050 8404   Woodland School District 531005002713 1795 Woodland Alternative School   Alternative School No High 09 12 2020   grade_9 3 0 0   0 0     0   0   1 2 0   0   0   3       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 3     0 3
2585637 WA Cowlitz   school 5310050 8404   Woodland School District 531005001682 3546 Woodland High School   Regular School No High 09 12 2020   grade_9 157 2 44   0 0     1   6   111 99 0   16   11   106       5.0 210 157 2 44   0 0     1   6   111 99 0   16 11 106     5 210
2946667 WA Cowlitz   school 5310050 8404   Woodland School District 531005002713 1795 Woodland Alternative School   Alternative School No High 09 12 2021   grade_9 14 1 0   0 0     0   0   8 7 0   0   0   6       0.0 15 14 1 0   0 0     0   0   8 7 0   0 0 6     0 15
2946672 WA Cowlitz   school 5310050 8404   Woodland School District 531005001682 3546 Woodland High School   Regular School No High 09 12 2021   grade_9 104 0 36   1 2     0   8   72 79 0   5   6   68       7.0 151 104 0 36   1 2     0   8   72 79 0   5 6 68     7 151
465138 WA Cowlitz   school 5303810 8402   Kalama School District 530381000585 2561 Kalama Middle School   Regular School No 4.0 06 12 2015   grade_9 70 1 6   0 1     0   3   46 35 0   0   1   26       9.0 81 70 1 6   0 1     0   3   46 35 0   0 1 26     9 81
525097 WA Cowlitz   school 5303810 8402   Kalama School District 530381000585 2561 Kalama Middle School   Regular School No 4 06 12 2016   grade_9 62 2 5   1 0     0   2   42 30 0   0   3   26       6.0 72 62 2 5   1 0     0   2   42 30 0   0 3 26     6 72
622464 WA Cowlitz   school 5303810 8402   Kalama School District 530381000585 2561 Kalama Middle School   Regular School No Other 06 12 2017   grade_9 67 3 3   0 0     0   1   44 30 0   1   2   33       5.0 74 67 3 3   0 0     0   1   44 30 0   1 2 33     5 74
2418338 WA Cowlitz   school 5303810 8402   Kalama School District 530381003659 5545 Kalama High School   Regular School No High 09 12 2019   grade_9 66 0 8   2 0     2   3   46 35 0   0   2   32       7.0 81 66 0 8   2 0     2   3   46 35 0   0 2 32     7 81
2462833 WA Cowlitz   school   8402   Kalama School District   5545 Kalama High School             2018   grade_9 63 0 5   0 0     0   0   47 21 0   0   1   13       7.0 68 63 0 5   0 0     0   0   47 21 0   0 1 13     7 68
2575685 WA Cowlitz   school 5303810 8402   Kalama School District 530381003659 5545 Kalama High School   Regular School No High 09 12 2020   grade_9 66 1 13   1 1     0   2   43 41 0   2   3   35       8.0 84 66 1 13   1 1     0   2   43 41 0   2 3 35     8 84
2936555 WA Cowlitz   school 5303810 8402   Kalama School District 530381003659 5545 Kalama High School   Regular School No High 09 12 2021   grade_9 73 0 12   1 0     0   2   42 46 0   6   2   23       6.0 88 73 0 12   1 0     0   2   42 46 0   6 2 23     6 88
461292 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000172 2281 Castle Rock High School   Regular School No 3.0 09 12 2015   grade_9 74 0 13   3 0     1   6   48 49 0   2   2   48       11.0 97 74 0 13   3 0     1   6   48 49 0   2 2 48     11 97
521285 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000172 2281 Castle Rock High School   Regular School No 3 09 12 2016   grade_9 73 0 12   0 1     0   4   52 38 0   3   1   48       5.0 90 73 0 12   0 1     0   4   52 38 0   3 1 48     5 90
618655 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000172 2281 Castle Rock High School   Regular School No High 09 12 2017   grade_9 75 0 11   4 0     0   8   51 47 0   1   0   50       9.0 98 75 0 11   4 0     0   8   51 47 0   1 0 50     9 98
2414585 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000172 2281 Castle Rock High School   Regular School No High 09 12 2019   grade_9 86 0 7   0 0     0   4   52 45 0   2   0   51       9.0 97 86 0 7   0 0     0   4   52 45 0   2 0 51     9 97
2459126 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000172 2281 Castle Rock High School   Regular School No High 09 12 2018   grade_9 75 1 6   0 0     1   3   41 45 0   3   2   47       11.0 86 75 1 6   0 0     1   3   41 45 0   3 2 47     11 86
2571922 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000172 2281 Castle Rock High School   Regular School No High 09 12 2020   grade_9 100 0 12   2 0     1   6   59 62 0   2   3   64       19.0 121 100 0 12   2 0     1   6   59 62 0   2 3 64     19 121
2932820 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000172 2281 Castle Rock High School   Regular School No High 09 12 2021   grade_9 103 0 12   1 2     1   2   56 65 0   5   0   69       8.0 121 103 0 12   1 2     1   2   56 65 0   5 0 69     8 121
473892 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No 3.0 07 12 2015   grade_9 43 0 4   0 1     0   0   28 20 0   0   0   19       3.0 48 43 0 4   0 1     0   0   28 20 0   0 0 19     3 48
533875 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No 3 07 12 2016   grade_9 33 0 3   0 1     0   1   19 19 0   0   1   16       0.0 38 33 0 3   0 1     0   1   19 19 0   0 1 16     0 38
631209 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2017   grade_9 45 0 3   0 0     0   3   26 25 0   0   0   17       3.0 51 45 0 3   0 0     0   3   26 25 0   0 0 17     3 51
2426916 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2019   grade_9 40 0 1   1 0     1   1   26 18 0   1   0   15       2.0 44 40 0 1   1 0     1   1   26 18 0   1 0 15     2 44
2471424 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2018   grade_9 56 1 3   0 0     0   1   31 30 0   0   1   23       2.0 61 56 1 3   0 0     0   1   31 30 0   0 1 23     2 61
2584343 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2020   grade_9 47 0 4   3 0     0   1   25 30 0   0   2   23       3.0 55 47 0 4   3 0     0   1   25 30 0   0 2 23     3 55
2945359 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2021   grade_9 51 0 6   0 2     0   4   30 33 0   0   2   28       4.0 63 51 0 6   0 2     0   4   30 33 0   0 2 28     4 63
466447 WA Cowlitz   school 5304470 8122   Longview School District 530447003454 5312 Discovery High School   Alternative Education School No 3.0 09 12 2015   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   2       1.0 2 2 0 0   0 0     0   0   2 0 0   0 0 2     1 2
466461 WA Cowlitz   school 5304470 8122   Longview School District 530447000703 3151 Mark Morris High School   Regular School No 3.0 09 12 2015   grade_9 175 3 45   3 5     2   18   132 119 0   9   3   140       3.0 251 175 3 45   3 5     2   18   132 119 0   9 3 140     3 251
466497 WA Cowlitz   school 5304470 8122   Longview School District 530447000709 2416 R A Long High School   Regular School No 3.0 09 12 2015   grade_9 186 6 49   0 8     1   16   133 133 0   9   10   173       2.0 266 186 6 49   0 8     1   16   133 133 0   9 10 173     2 266
526411 WA Cowlitz   school 5304470 8122   Longview School District 530447003454 5312 Discovery High School   Alternative Education School No 3 09 12 2016   grade_9 1 0 1   0 0     0   0   1 1 0   0   0   2       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 2     0 2
526425 WA Cowlitz   school 5304470 8122   Longview School District 530447000703 3151 Mark Morris High School   Regular School No 3 09 12 2016   grade_9 178 0 39   3 7     2   23   121 131 0   9   3   109       7.0 252 178 0 39   3 7     2   23   121 131 0   9 3 109     7 252
526460 WA Cowlitz   school 5304470 8122   Longview School District 530447000709 2416 R A Long High School   Regular School No 3 09 12 2016   grade_9 171 2 47   3 8     3   13   132 115 0   10   9   158       6.0 247 171 2 47   3 8     3   13   132 115 0   10 9 158     6 247

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