Name: Locations Of Home Improvement Stores
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Locations Of Home Improvement Stores

This repository collects a cross-section of data of Lowe's and Home Depot's store locations across the United States. The following data files are included:

CBSA.csv - A list of census based statistical areas with selected characteristics.
census.csv - Selected CDP characteristics
entry.csv - The actual locations for Lowe's and Home Depot.
warehouse_loc.csv - Geolocated distribution centers.
entry_locv2.csv - Warehouse locations merged with entry locations. Also merged with distance from HQ.
entry_loc3_w_filter.csv - Tries to change geography of the dataset from CDPs to CBSAs

Store locations are often modeled by economists as an "entry game". For more information about this dataset, see the corresponding github repo:
https://github.com/ericschulman/entry_games

Tables

Cbsa

@kaggle.erichschulman_home_improvement_stores.cbsa

46.82 kB
945 rows
6 columns

CREATE TABLE cbsa (
  "n_0" BIGINT  -- 0,
  "name" VARCHAR,
  "cbsa" BIGINT,
  "b19301_001e" DOUBLE,
  "b01003_001e" BIGINT,
  "metropolitan_statistical_area_micropolitan_statistical_area" BIGINT
);

Census

@kaggle.erichschulman_home_improvement_stores.census

1.1 MB
29,573 rows
15 columns

CREATE TABLE census (
  "name" VARCHAR,
  "population" BIGINT,
  "under44_1" DOUBLE,
  "under44_2" DOUBLE,
  "under44_3" DOUBLE,
  "older65_1" DOUBLE,
  "older_65_2" DOUBLE,
  "income_per_capita" DOUBLE,
  "industrial_managers" VARCHAR,
  "construction_managers" VARCHAR,
  "farmers" VARCHAR,
  "realestate" VARCHAR,
  "construction_workers" VARCHAR,
  "state" BIGINT,
  "place" BIGINT
);

Entry

@kaggle.erichschulman_home_improvement_stores.entry

128.09 kB
3,672 rows
7 columns

CREATE TABLE entry (
  "store" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "url" VARCHAR,
  "time" DOUBLE
);

Entry Loc2

@kaggle.erichschulman_home_improvement_stores.entry_loc2

9.55 MB
17,313 rows
70 columns

CREATE TABLE entry_loc2 (
  "unnamed_0_1" BIGINT  -- Unnamed: 0.1,
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "city" VARCHAR,
  "state" BIGINT,
  "hd" BIGINT,
  "low" BIGINT,
  "population" BIGINT,
  "income_per_capita" BIGINT,
  "under44_1" DOUBLE,
  "under44_2" DOUBLE,
  "under44_3" DOUBLE,
  "older65_1" DOUBLE,
  "older_65_2" DOUBLE,
  "stusab" VARCHAR,
  "state_name" VARCHAR,
  "statens" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "low_dist" DOUBLE,
  "hd_dist" DOUBLE,
  "lat_long" VARCHAR,
  "low_mount_vernon" DOUBLE  -- LOW - Mount Vernon,
  "low_valdosta" DOUBLE  -- LOW - Valdosta,
  "low_rockford" DOUBLE  -- LOW - Rockford,
  "low_garysburg" DOUBLE  -- LOW - Garysburg,
  "low_findlay" DOUBLE  -- LOW - Findlay,
  "low_cheyenne" DOUBLE  -- LOW - Cheyenne,
  "low_plainfield" DOUBLE  -- LOW - Plainfield,
  "low_statesville" DOUBLE  -- LOW - Statesville,
  "low_north_vernon" DOUBLE  -- LOW - North Vernon,
  "low_minersville" DOUBLE  -- LOW - Minersville,
  "low_perris" DOUBLE  -- LOW - Perris,
  "low_kissimmee" DOUBLE  -- LOW - Kissimmee,
  "hd_hardeeville" DOUBLE  -- HD - Hardeeville,
  "hd_tucson" DOUBLE  -- HD - Tucson,
  "hd_lacey" DOUBLE  -- HD - Lacey,
  "hd_hialeah" DOUBLE  -- HD - Hialeah,
  "hd_elk_grove_village" DOUBLE  -- HD - Elk Grove Village,
  "hd_hiawatha" DOUBLE  -- HD - Hiawatha,
  "hd_south_windsor" DOUBLE  -- HD - South Windsor,
  "hd_frederick" DOUBLE  -- HD - Frederick,
  "hd_fresno" DOUBLE  -- HD - Fresno,
  "hd_grove_city" DOUBLE  -- HD - Grove City,
  "hd_north_las_vegas" DOUBLE  -- HD - North Las Vegas,
  "hd_houston" DOUBLE  -- HD - Houston,
  "hd_alpharetta" DOUBLE  -- HD - Alpharetta,
  "hd_whitestown" DOUBLE  -- HD - Whitestown,
  "hd_cherry_hill" DOUBLE  -- HD - Cherry Hill,
  "hd_loveland" DOUBLE  -- HD - Loveland,
  "hd_tulsa" DOUBLE  -- HD - Tulsa,
  "hd_jenkins_township" DOUBLE  -- HD - Jenkins Township,
  "hd_louisville" DOUBLE  -- HD - Louisville,
  "hd_waukesha" DOUBLE  -- HD - Waukesha,
  "hd_hawthorne" DOUBLE  -- HD - Hawthorne,
  "hd_greensboro" DOUBLE  -- HD - Greensboro,
  "hd_portland" DOUBLE  -- HD - Portland,
  "hd_la_vergne" DOUBLE  -- HD - La Vergne,
  "hd_suffolk" DOUBLE  -- HD - Suffolk,
  "hd_huntington" DOUBLE  -- HD - Huntington,
  "hd_omaha" DOUBLE  -- HD - Omaha,
  "hd_saint_louis" DOUBLE  -- HD - Saint Louis,
  "hd_alabaster" DOUBLE  -- HD - Alabaster,
  "hd_farmington_hills" DOUBLE  -- HD - Farmington Hills,
  "hd_shawnee" DOUBLE  -- HD - Shawnee,
  "hd_harahan" DOUBLE  -- HD - Harahan,
  "hd_saint_paul" DOUBLE  -- HD - Saint Paul,
  "hd_draper" DOUBLE  -- HD - Draper,
  "hd_auburn" DOUBLE  -- HD - Auburn,
  "low_warehouse_distance" DOUBLE,
  "hd_warehouse_distance" DOUBLE
);

Entry Loc3 W Filter

@kaggle.erichschulman_home_improvement_stores.entry_loc3_w_filter

67.2 kB
896 rows
15 columns

CREATE TABLE entry_loc3_w_filter (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "name" VARCHAR,
  "city" VARCHAR,
  "state" BIGINT,
  "hd" BIGINT,
  "low" BIGINT,
  "population" BIGINT,
  "income_per_capita" BIGINT,
  "stusab" VARCHAR,
  "low_warehouse_distance" DOUBLE,
  "hd_warehouse_distance" DOUBLE,
  "northeast_x" BIGINT,
  "midwest_x" BIGINT,
  "south_x" BIGINT,
  "west_x" BIGINT
);

States

@kaggle.erichschulman_home_improvement_stores.states

4.88 kB
57 rows
4 columns

CREATE TABLE states (
  "state" BIGINT,
  "stusab" VARCHAR,
  "state_name" VARCHAR,
  "statens" BIGINT
);

Warehouse Loc

@kaggle.erichschulman_home_improvement_stores.warehouse_loc

6.24 kB
47 rows
6 columns

CREATE TABLE warehouse_loc (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "city" VARCHAR,
  "state" VARCHAR,
  "store" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE
);