5.7 KiB
loweslocations
This past week Lowe’s told their assemblers they were all out of a job. This decision impacts ~1-3 (sometimes more depending on the store) workers per Lowe’s store and Lowe’s assemblers used to make between ~$13.00 & $18.00 USD/hour.
The data
directory contains
lowes-stores-geo.csv.gz
which is
lovingly hand-crafted transcription of all the locations listed at
https://www.lowes.com/Lowes-Stores. The addresses have been geolocated
(using {rgeocodio}) and
contain:
- store name
- store published address
- store geocoded legit address
- store phone #
- county
- city
- state
- longitude
- latitude
which should be sufficient to enable data journalists to cross reference with census/economic data to facilitate potential regional impact reporting.
Some Summary Info
library(sf)
library(albersusa)
library(hrbrthemes)
library(tidyverse)
cols(
o_addr = col_character(),
fmt_addr = col_character(),
phone = col_character(),
city = col_character(),
county = col_character(),
state = col_character(),
lat = col_double(),
lng = col_double()
) -> lowes_cols
lowes <- read_csv(here::here("data/lowes-stores-geo.csv.gz"), col_types = lowes_cols)
head(lowes) %>%
knitr::kable("markdown")
o_addr | fmt_addr | phone | city | county | state | lat | lng |
---|---|---|---|---|---|---|---|
333 East Tudor Rd , AK 99503 | 333 E Tudor Rd, Anchorage, AK 99503 | (907) 563-0391 | Anchorage | Anchorage Municipality | AK | 61.18100 | -149.87856 |
1200 North Muldoon , AK 99504 | 1200 N Muldoon Rd, Anchorage, AK 99504 | (907) 269-2400 | Anchorage | Anchorage Municipality | AK | 61.22563 | -149.74607 |
10900 Old Seward Highway , AK 99515 | 10900 Old Seward Hwy, Anchorage, AK 99515 | (907) 349-8889 | Anchorage | Anchorage Municipality | AK | 61.12179 | -149.86645 |
425 Merhar Ave , AK 99701 | 425 Merhar Ave, Fairbanks, AK 99701 | (907) 451-4700 | Fairbanks | Fairbanks North Star Borough | AK | 64.85682 | -147.69653 |
2561 East Sun Mountain Ave , AK 99654 | 2561 E Sun Mountain Ave, Wasilla, AK 99654 | (907) 352-3100 | Wasilla | Matanuska-Susitna Borough | AK | 61.57333 | -149.38457 |
235 Colonial Promenade Pkwy , AL 35007 | 235 Colonial Promenade Pkwy, Alabaster, AL 35007 | (205) 685-4060 | Alabaster | Shelby County | AL | 33.23110 | -86.80503 |
filter(lowes, !(state %in% c("HI", "AK"))) %>%
select(lon=lng, lat) %>%
bind_rows(
filter(lowes, (state %in% c("HI", "AK"))) %>%
select(lng, lat) %>%
points_elided(.) %>%
select(lon=1, lat=2)
) %>%
st_as_sf(
coords = c("lon", "lat"),
crs = us_longlat_proj,
agr = "constant"
) -> pts
ggplot() +
geom_sf(data = usa_sf("longlat"), fill = ft_cols$gray) +
geom_sf(data = pts, size = 0.5, alpha = 1/2, color = ft_cols$yellow) +
coord_sf(crs = us_laea_proj, datum = NA) +
labs(
x = NULL, y = NULL,
title = "Lowe's Locations"
) +
theme_ft_rc(grid="") +
theme(axis.text = element_blank())
count(lowes, state, sort=TRUE) %>%
top_n(10) %>%
knitr::kable()
state | n |
---|---|
TX | 142 |
FL | 126 |
NC | 114 |
CA | 110 |
OH | 83 |
PA | 83 |
NY | 70 |
VA | 69 |
GA | 63 |
TN | 60 |
count(lowes, county, state, sort=TRUE) %>%
top_n(10) %>%
knitr::kable()
county | state | n |
---|---|---|
Maricopa County | AZ | 21 |
Los Angeles County | CA | 20 |
Harris County | TX | 18 |
Clark County | NV | 13 |
Riverside County | CA | 12 |
Tarrant County | TX | 11 |
Bexar County | TX | 10 |
San Bernardino County | CA | 10 |
Allegheny County | PA | 9 |
Dallas County | TX | 9 |
Franklin County | OH | 9 |
Hillsborough County | FL | 9 |
Mecklenburg County | NC | 9 |
Assuming $17/hr (~35K/yr) and no same-store re-hiring, ~$61,030,500 annual wages decrease across the whole list and for the top 10 counties:
count(lowes, county, state, sort=TRUE) %>%
mutate(wages_lost = scales::dollar(n * 35380)) %>%
top_n(10, wt = n) %>%
knitr::kable(align = "llrr")
county | state | n | wages_lost |
---|---|---|---|
Maricopa County | AZ | 21 | $742,980 |
Los Angeles County | CA | 20 | $707,600 |
Harris County | TX | 18 | $636,840 |
Clark County | NV | 13 | $459,940 |
Riverside County | CA | 12 | $424,560 |
Tarrant County | TX | 11 | $389,180 |
Bexar County | TX | 10 | $353,800 |
San Bernardino County | CA | 10 | $353,800 |
Allegheny County | PA | 9 | $318,420 |
Dallas County | TX | 9 | $318,420 |
Franklin County | OH | 9 | $318,420 |
Hillsborough County | FL | 9 | $318,420 |
Mecklenburg County | NC | 9 | $318,420 |