Dataset: Business Density

About this Dataset

Business Density

Dataset contains micro-business activity across the United States, measured by the density of micro-businesses in US counties. Microbusinesses are often too small or too new to show up in traditional economic data sources, but microbusiness activity may be correlated with other economic indicators of general interest.

Feature Description

cfips - A unique identifier for each county using the Federal Information Processing System. The first two digits correspond to the state FIPS code, while the following 3 represent the county.
county - The written name of the county.
state - The name of the state.
first_day_of_month - The date of the first day of the month.
microbusiness_density - Microbusinesses per 100 people over the age of 18 in the given county. This is the target variable. The population figures used to calculate the density are on a two-year lag due to the pace of update provided by the U.S. Census Bureau, which provides the underlying population data annually. 2021 density figures are calculated using 2019 population figures, etc.
active - The raw count of micro-businesses in the county.
year - Year in which the record is published (YYYY)
month - Month in which the record is published (MM)
pct_broadband - The percentage of households in the county with access to broadband of any type. Derived from ACS table B28002: PRESENCE AND TYPES OF INTERNET SUBSCRIPTIONS IN HOUSEHOLD.
pct_college - The percent of the population in the county over age 25 with a 4-year college degree. Derived from ACS table S1501: EDUCATIONAL ATTAINMENT.
pct_foreign_born - The percent of the population in the county born outside of the United States. Derived from ACS table DP02: SELECTED SOCIAL CHARACTERISTICS IN THE UNITED STATES.
pct_IT_workers - The percent of the workforce in the county employed in information related industries. Derived from ACS table S2405: INDUSTRY BY OCCUPATION FOR THE CIVILIAN EMPLOYED POPULATION 16 YEARS AND OVER.
median_income - The median household income in the county. Derived from ACS table S1901: INCOME IN THE PAST 12 MONTHS (IN 2021 INFLATION-ADJUSTED DOLLARS).

Tables

Microbusiness Density

@kaggle.jjithin_business_density.microbusiness_density

1.66 MB
128535 rows
13 columns


CREATE TABLE microbusiness_density (
  "cfips" BIGINT,
  "county" VARCHAR,
  "state" VARCHAR,
  "first_day_of_month" TIMESTAMP,
  "microbusiness_density" DOUBLE,
  "active" DOUBLE,
  "year" BIGINT,
  "month" BIGINT,
  "pct_broadband" DOUBLE,
  "pct_college" DOUBLE,
  "pct_foreign_born" DOUBLE,
  "pct_it_workers" DOUBLE,
  "median_income" DOUBLE
);