Socioeconomic indicators like the poverty rate, population change, unemployment rate, and education levels vary across the nation. ERS has compiled the latest data on these measures into a mapping and data display/download application that allows users to identify and compare States and counties on these indicators.

"""

County-Level Demographic: Population, Race, Gender

Overview

This dataset provides a detailed breakdown of demographic information for counties across the United States, derived from the U.S. Census Bureau's 2023 American Community Survey (ACS). The data includes population counts by gender, race, and ethnicity, alongside unique identifiers for each county using State and County FIPS codes.

Dataset Features

The dataset includes the following columns: - County: Name of the county. - State: Name of the state the county belongs to. - State FIPS Code: Federal Information Processing Standard (FIPS) code for the state. - County FIPS Code: FIPS code for the county. - FIPS: Combined State and County FIPS codes, a unique identifier for each county. - Total Population: Total population in the county. - Male Population: Number of males in the county. - Female Population: Number of females in the county. - Total Race Responses: Total race-related responses recorded in the survey. - White Alone: Number of individuals identifying as White alone. - Black or African American Alone: Number of individuals identifying as Black or African American alone. - Hispanic or Latino: Number of individuals identifying as Hispanic or Latino.

Processing Methodology

1. Source:
   • Data was retrieved using the U.S. Census Bureau ACS API.
2. County-Level Aggregation:
   • Each county is uniquely identified using State FIPS Code and County FIPS Code.
   • These codes were concatenated to form the unified FIPS column.
3. Data Cleaning:
   • All numeric columns were converted to appropriate data types.
   • County and state names were extracted from the raw NAME field for clarity.

Why Use This Dataset?

This dataset is highly versatile and suitable for: - Demographic Analysis: - Analyze population distribution by gender, race, and ethnicity. - Geographic Studies: - Use FIPS codes to map counties geographically. - Data Visualizations: - Create visual insights into demographic trends across counties.

File Format

• The dataset is available as a CSV file with 3,000+ rows (one for each county).

Licensing

• Source: Data is sourced from the U.S. Census Bureau's 2023 American Community Survey (ACS).
• License: This dataset is in the public domain and provided under the U.S. Census Bureau’s terms of use. Attribution to the Census Bureau is appreciated.

Acknowledgments

Special thanks to the U.S. Census Bureau for making this data publicly available and to the Kaggle community for fostering a collaborative space for data analysis and exploration. """

The China County-Level Data on Population (Census) and Agriculture, Keyed To 1:1M GIS Map consists of census, agricultural economic, and boundary data for the administrative regions of China for 1990. The census data includes urban and rural residency, age and sex distribution, educational attainment, illiteracy, marital status, childbirth, mortality, immigration (since 1985), industrial/economic activity, occupation, and ethnicity. The agricultural economic data encompasses rural population, labor force, forestry, livestock and fishery, commodities, equipment, utilities, irrigation, and output value. The boundary data are at a scale of one to one million (1:1M) at the county level. This data set is produced in collaboration with the University of Washington as part of the China in Time and Space (CITAS) project, University of California-Davis China in Time and Space (CITAS) project, and the Center for International Earth Science Information Network (CIESIN).

The Georeferenced U.S. County-Level Population Projections, Total and by Sex, Race and Age, Based on the SSPs, 2020-2100 consists of county-level population projection scenarios of total population, and by age, sex, and race in five-year intervals for all U.S. counties for the period 2020 - 2100. These data have numerous potential uses and can serve as inputs for addressing questions involving sub-national demographic change in the United States in the near, middle- and long-term.

Covid-19 Daily metrics at the county level As of 6/1/2023, this data set is no longer being updated. The COVID-19 Data Report is posted on the Open Data Portal every day at 3pm. The report uses data from multiple sources, including external partners; if data from external partners are not received by 3pm, they are not available for inclusion in the report and will not be displayed. Data that are received after 3pm will still be incorporated and published in the next report update. The cumulative number of COVID-19 cases (cumulative_cases) includes all cases of COVID-19 that have ever been reported to DPH. The cumulative number of COVID_19 cases in the last 7 days (cases_7days) only includes cases where the specimen collection date is within the past 7 days. While most cases are reported to DPH within 48 hours of specimen collection, there are a small number of cases that routinely are delayed, and will have specimen collection dates that fall outside of the rolling 7 day reporting window. Additionally, reporting entities may submit correction files to contribute historic data during initial onboarding or to address data quality issues; while this is rare, these correction files may cause a large amount of data from outside of the current reporting window to be uploaded in a single day; this would result in the change in cumulative_cases being much larger than the value of cases_7days. On June 4, 2020, the US Department of Health and Human Services issued guidance requiring the reporting of positive and negative test results for SARS-CoV-2; this guidance expired with the end of the federal PHE on 5/11/2023, and negative SARS-CoV-2 results were removed from the List of Reportable Laboratory Findings. DPH will no longer be reporting metrics that were dependent on the collection of negative test results, specifically total tests performed or percent positivity. Positive antigen and PCR/NAAT results will continue to be reportable.

Two datasets provide geographic, land use and population data for US Counties within the contiguous US. Land area, water area, cropland area, farmland area, pastureland area and idle cropland area are given along with latitude and longitude of the county centroid and the county population. Variables in this dataset come from the US Dept. of Agriculture (USDA) Natural Resources Conservation Service (NRCS) and the US Census Bureau.

EOS-WEBSTER provides seven datasets which provide county-level data on agricultural management, crop production, livestock, soil properties, geography and population. These datasets were assembled during the mid-1990's to provide driving variables for an assessment of greenhouse gas production from US agriculture using the DNDC agro-ecosystem model [see, for example, Li et al. (1992), J. Geophys. Res., 97:9759-9776; Li et al. (1996) Global Biogeochem. Cycles, 10:297-306]. The data (except nitrogen fertilizer use) were all derived from publicly available, national databases. Each dataset has a separate DIF.

The US County data has been divided into seven datasets.

US County Data Datasets:

1) Agricultural Management 2) Crop Data (NASS Crop data) 3) Crop Summary (NASS Crop data) 4) Geography and Population 5) Land Use 6) Livestock Populations 7) Soil Properties

United States per capita personal income by county (2021) vs. level of education.

Data source for United States per capita personal income by county: https://www.bea.gov/data/income-saving/personal-income-county-metro-and-other-areas

Data source for education level: https://www.ers.usda.gov/data-products/county-level-data-sets/county-level-data-sets-download-data/

bea.gov is the U.S. Bureau of Economic Analysis

usda.gov is the U.S. Department of Agriculture

They are the most recent data available at the moment. Per capita personal income by county data was released in November 2022. Next release should be in Q4 2023.

I cleaned both tables and I merged them with BigQuery

You can find the data viz here: https://public.tableau.com/views/PerCapitaPersonalIncomebyCountyintheUnitedStates2021/Map?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link

*Note: BEA state per capita personal income statistics are calculated by dividing population into personal income. Check their methodology here https://www.bea.gov/note-capita-personal-income-and-population

US County & Zipcode Historical Demographics

Easily lookup US historical demographics by county FIPS or zipcode in seconds with this file containing over 5,901 different columns including:

*Lat/Long *Boundaries *State FIPS *Population from 2010-2019 *Death Rate from 2010-2019 *Unemployment from 2001-2020 *Education from 1970-2019 *Gender and Age Population

Provided by bitrook.com to help Data Scientists clean data faster.

Data Sources

All Data Combined Source:

https://www.ers.usda.gov/data-products/county-level-data-sets/download-data/

Population Source:

https://www.ers.usda.gov/data-products/county-level-data-sets/download-data/

Unemployment Source:

https://www.ers.usda.gov/data-products/county-level-data-sets/download-data/

Zip FIPS Crosswalk Source:

https://data.world/niccolley/us-zipcode-to-county-state

County Boundaries Source:

https://public.opendatasoft.com/explore/dataset/us-county-boundaries/table/?disjunctive.statefp&disjunctive.countyfp&disjunctive.name&disjunctive.namelsad&disjunctive.stusab&disjunctive.state_name

Age Sex Source:

https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/counties/asrh/cc-est2019-agesex-**.csv https://www2.census.gov/programs-surveys/popest/technical-documentation/file-layouts/2010-2019/cc-est2019-agesex.pdf

Races Source:

https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/counties/asrh/cc-est2019-alldata.csv https://www2.census.gov/programs-surveys/popest/technical-documentation/file-layouts/2010-2019/cc-est2019-alldata.pdf

The Georeferenced U.S. County-Level Population Projections, Total and by Sex, Race and Age, Based on the SSPs, 2020-2100 consists of county-level population projection scenarios of total population, and by age, sex, and race in five-year intervals for all U.S. counties for the period 2020 - 2100. These data have numerous potential uses and can serve as inputs for addressing questions involving sub-national demographic change in the United States in the near, middle- and long-term.

Announcement Beginning October 20, 2022, CDC will report and publish aggregate case and death data from jurisdictional and state partners on a weekly basis rather than daily. As a result, community transmission levels data reported on data.cdc.gov will be updated weekly on Thursdays, typically by 8 PM ET, instead of daily. This public use dataset has 7 data elements reflecting community transmission levels for all available counties. This dataset contains reported daily transmission level at the county level and contains the same values used to display transmission maps on the COVID Data Tracker. Each day, the dataset is appended to contain the most recent day's data. Transmission level is set to low, moderate, substantial, or high using the calculation rules below. Currently, CDC provides the public with two versions of COVID-19 county-level community transmission level data: this dataset with the levels as originally posted (Originally Posted dataset), updated daily with the most recent day’s data, and an historical dataset with the county-level transmission data from January 1, 2021 (Historical Changes dataset). Methods for calculating county level of community transmission indicator The County Level of Community Transmission indicator uses two metrics: (1) total new COVID-19 cases per 100,000 persons in the last 7 days and (2) percentage of positive SARS-CoV-2 diagnostic nucleic acid amplification tests (NAAT) in the last 7 days. For each of these metrics, CDC classifies transmission values as low, moderate, substantial, or high (below and here). If the values for each of these two metrics differ (e.g., one indicates moderate and the other low), then the higher of the two should be used for decision-making. CDC core metrics of and thresholds for community transmission levels of SARS-CoV-2 Total New Case Rate Metric: "New cases per 100,000 persons in the past 7 days" is calculated by adding the number of new cases in the county (or other administrative level) in the last 7 days divided by the population in the county (or other administrative level) and multiplying by 100,000. "New cases per 100,000 persons in the past 7 days" is considered to have a transmission level of Low (0-9.99); Moderate (10.00-49.99); Substantial (50.00-99.99); and High (greater than or equal to 100.00). Test Percent Positivity Metric: "Percentage of positive NAAT in the past 7 days" is calculated by dividing the number of positive tests in the county (or other administrative level) during the last 7 days by the total number of tests conducted over the last 7 days. "Percentage of positive NAAT in the past 7 days" is considered to have a transmission level of Low (less than 5.00); Moderate (5.00-7.99); Substantial (8.00-9.99); and High (greater than or equal to 10.00). If the two metrics suggest different transmission levels, the higher level is selected. Transmission categories include: Low Transmission Threshold: Counties with fewer than 10 total cases per 100,000 population in the past 7 days, and a NAAT percent test positivity in the past 7 days below 5%; Moderate Transmission Threshold: Counties with 10-49 total cases per 100,000 population in the past 7 days or a NAAT test percent positivity in the past 7 days of 5.0-7.99%; Substantial Transmission Threshold: Counties with 50-99 total cases per 100,000 population in the past 7 days or a NAAT test percent positivity in the past 7 days of 8.0-9.99%; High Transmission Threshold: Counties with 100 or more total cases per 100,000

The Public Health Emergency (PHE) declaration for COVID-19 expired on May 11, 2023. As a result, the Aggregate Case and Death Surveillance System will be discontinued. Although these data will continue to be publicly available, this dataset will no longer be updated.

On October 20, 2022, CDC began retrieving aggregate case and death data from jurisdictional and state partners weekly instead of daily.

This dataset includes the URLs that were used by the aggregate county data collection process that compiled aggregate case and death counts by county. Within this file, each of the states (plus select jurisdictions and territories) are listed along with the county web sources which were used for pulling these numbers. Some states had a single statewide source for collecting the county data, while other states and local health jurisdictions may have had standalone sources for individual counties. In the cases where both local and state web sources were listed, a composite approach was taken so that the maximum value reported for a location from either source was used. The initial raw data were sourced from these links and ingested into the CDC aggregate county dataset before being published on the COVID Data Tracker.

This dataset contains model-based county-level estimates in GIS-friendly format. PLACES covers the entire United States—50 states and the District of Columbia—at county, place, census tract, and ZIP Code Tabulation Area levels. It provides information uniformly on this large scale for local areas at four geographic levels. Estimates were provided by the Centers for Disease Control and Prevention (CDC), Division of Population Health, Epidemiology and Surveillance Branch. Project was funded by the Robert Wood Johnson Foundation in conjunction with the CDC Foundation. Data sources used to generate these model-based estimates are Behavioral Risk Factor Surveillance System (BRFSS) 2022 or 2021 data, Census Bureau 2022 county population estimates, and American Community Survey (ACS) 2018–2022 estimates. The 2024 release uses 2022 BRFSS data for 36 measures and 2021 BRFSS data for 4 measures (high blood pressure, high cholesterol, cholesterol screening, and taking medicine for high blood pressure control among those with high blood pressure) that the survey collects data on every other year. These data can be joined with the census 2022 county boundary file in a GIS system to produce maps for 40 measures at the county level. An ArcGIS Online feature service is also available for users to make maps online or to add data to desktop GIS software. https://cdcarcgis.maps.arcgis.com/home/item.html?id=3b7221d4e47740cab9235b839fa55cd7

Dataset

This dataset was created by glozab

Released under CC0: Public Domain

Contents

BackgroundTimely linkage to care (LTC) is key in the HIV care continuum, as it enables people newly diagnosed with HIV (PNWH) to benefit from HIV treatment at the earliest stage. Previous studies have found LTC disparities by individual factors, but data are limited beyond the individual level, especially at the county level. This study examined the temporal and geographic variations of county-level LTC status across 46 counties in South Carolina (SC) from 2010 to 2018 and the association of county-level characteristics with LTC status.MethodsAll adults newly diagnosed with HIV from 2010 to 2018 in SC were included in this study. County-level LTC status was defined as 1 = “high LTC (≥ yearly national LTC percentage)” and 0 = “low LTC (< yearly national LTC percentage)”. A generalized estimating equation model with stepwise selection was employed to examine the relationship between 29 county-level characteristics and LTC status.ResultsThe number of counties with high LTC in SC decreased from 34 to 21 from 2010 to 2018. In the generalized estimating equation model, six out of 29 factors were significantly associated with LTC status. Counties with a higher percentage of males (OR = 0.07, 95%CI: 0.02~0.29) and persons with at least four years of college (OR = 0.07, 95%CI: 0.02~0.34) were less likely to have high LTC. However, counties with more mental health centers per PNWH (OR = 45.09, 95%CI: 6.81~298.55) were more likely to have high LTC.ConclusionsFactors associated with demographic characteristics and healthcare resources contributed to the variations of LTC status at the county level. Interventions targeting increasing the accessibility to mental health facilities could help improve LTC.

1, TitleA dataset of district/county-level population distribution of China's six national censuses2, Data corresponding authorGao Liang (lianggao@bjtu.edu.cn)3, Data author(s)WU Haoran, GAO Liang, SONG Dongdong, YANG Yitao, XU Changxing, YANG Xiaobao4, Time range1953, 1964, 1982, 1990, 2000, 20105, Geographical scopeChinese mainland6, Data volume67.6MB7, Data format（*.shp, *.cpg, *.dbf, *.prj, *.sbn, *.sbx, *.shx）8, Source(s) of fundingNational Natural Science Foundation of China (71571017, 91646124, 71621001, 91746201)9, Dataset/Database compositionThe data set consists of one part: Dataset Map.zip contains the coded and attributed links to form a district/county level GIS population database of 31 provinces (municipalities, autonomous regions) (excluding Hong Kong, Macao, and Taiwan). The amount of data is 67.6MB.

China Number of Region at County Level: City at County Level data was reported at 388.000 Unit in 2020. This records an increase from the previous number of 387.000 Unit for 2019. China Number of Region at County Level: City at County Level data is updated yearly, averaging 368.000 Unit from Dec 1978 (Median) to 2020, with 43 observations. The data reached an all-time high of 445.000 Unit in 1996 and a record low of 92.000 Unit in 1978. China Number of Region at County Level: City at County Level data remains active status in CEIC and is reported by National Bureau of Statistics. The data is categorized under China Premium Database’s Socio-Demographic – Table CN.GJ: No of Region at County Level.

This dataset provides modeled predictions of PM2.5 levels from the EPA's Downscaler model. Data are at the county level for 2001-2019. These data are used by the CDC's National Environmental Public Health Tracking Network to generate air quality measures. Census tract-level datasets contain estimates of the mean predicted concentration and associated standard error. Please refer to the metadata attachment for more information.

Learn more about outdoor air quality on the Tracking Network's website: https://ephtracking.cdc.gov/showAirLanding.action.

By using these data, you signify your agreement to comply with the following requirements: 1. Use the data for statistical reporting and analysis only. 2. Do not attempt to learn the identity of any person included in the data and do not combine these data with other data for the purpose of matching records to identify individuals. 3. Do not disclose of or make use of the identity of any person or establishment discovered inadvertently and report the discovery to: trackingsupport@cdc.gov. 4. Do not imply or state, either in written or oral form, that interpretations based on the data are those of the original data sources and CDC unless the data user and data source are formally collaborating. 5. Acknowledge, in all reports or presentations based on these data, the original source of the data and CDC. 6. Suggested citation: Centers for Disease Control and Prevention. National Environmental Public Health Tracking Network. Web. Accessed: insert date. www.cdc.gov/ephtracking.

This dataset contains hourly capacity factors for each renewable resource class and region (in this case, county). Technologies like large-scale utility PV (UPV), onshore wind, offshore wind, and concentrating solar power (CSP) are included. The dataset contains 7 years of hourly weather data (2007-2013) for different sites across the US and is used as one of the inputs to the ReEDS-2.0 model (see the "ReEDS 2.0 GitHub Repository" resource link below), developed by NREL. The weather profiles apply to any capacity that exists or is built in each region and class. This helps calculate the generation that can be provided using these resources. Open, reference, and limited are 3 scenarios based on land-use allowance, derived from the Renewable Energy Potential (reV) model developed by NREL, which helps generate supply curves for renewable technologies and assess the maximum potential of renewable resources in a designated area. Each zipped file in this dataset corresponds to a technology and contains the respective land-use scenario files required to run that technology in ReEDS. To use this dataset, download and place the extracted files in the locally cloned ReEDS repository inside one of the folders (inputs/variability/multi_year). After completing this copy, upon running the ReEDS model at the county-level spatial resolution for respective analysis purposes, the program will detect the presence of these files and will not fail.

The China County-Level Data on Provincial Economic Yearbooks, Keyed To 1:1M GIS Map consists of socioeconomic and boundary data for the administrative regions of China for 1990 and 1991. The socioeconomic data includes natural resources, population, employment, investment, wage, public finance, price, people's livelihood, agriculture, industry, energy, production, transportation, telecommunication, construction, trade, tourism, environmental protection, education, science, patents, culture, sports, health care, and social welfare. The boundary data are at a scale of one to one million (1:1M) at the county level. This data set is produced in collaboration with the University of Washington as part of the China in Time and Space (CITAS) project, University of Michigan Center of China Studies (CCS), and the Center for International Earth Science Information Network (CIESIN).

Exploring County-Level Correlations in Cancer Rates and Trends

A Multivariate Ordinary Least Squares Regression Model

By Noah Rippner [source]

About this dataset

This dataset offers a unique opportunity to examine the pattern and trends of county-level cancer rates in the United States at the individual county level. Using data from cancer.gov and the US Census American Community Survey, this dataset allows us to gain insight into how age-adjusted death rate, average deaths per year, and recent trends vary between counties – along with other key metrics like average annual counts, met objectives of 45.5?, recent trends (2) in death rates, etc., captured within our deep multi-dimensional dataset. We are able to build linear regression models based on our data to determine correlations between variables that can help us better understand cancers prevalence levels across different counties over time - making it easier to target health initiatives and resources accurately when necessary or desired

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This kaggle dataset provides county-level datasets from the US Census American Community Survey and cancer.gov for exploring correlations between county-level cancer rates, trends, and mortality statistics. This dataset contains records from all U.S counties concerning the age-adjusted death rate, average deaths per year, recent trend (2) in death rates, average annual count of cases detected within 5 years, and whether or not an objective of 45.5 (1) was met in the county associated with each row in the table.

To use this dataset to its fullest potential you need to understand how to perform simple descriptive analytics which includes calculating summary statistics such as mean, median or other numerical values; summarizing categorical variables using frequency tables; creating data visualizations such as charts and histograms; applying linear regression or other machine learning techniques such as support vector machines (SVMs), random forests or neural networks etc.; differentiating between supervised vs unsupervised learning techniques etc.; reviewing diagnostics tests to evaluate your models; interpreting your findings; hypothesizing possible reasons and patterns discovered during exploration made through data visualizations ; Communicating and conveying results found via effective presentation slides/documents etc.. Having this understanding will enable you apply different methods of analysis on this data set accurately ad effectively.

Once these concepts are understood you are ready start exploring this data set by first importing it into your visualization software either tableau public/ desktop version/Qlikview / SAS Analytical suite/Python notebooks for building predictive models by loading specified packages based on usage like Scikit Learn if Python is used among others depending on what tool is used . Secondly a brief description of the entire table's column structure has been provided above . Statistical operations can be carried out with simple queries after proper knowledge of basic SQL commands is attained just like queries using sub sets can also be performed with good command over selecting columns while specifying conditions applicable along with sorting operations being done based on specific attributes as required leading up towards writing python codes needed when parsing specific portion of data desired grouping / aggregating different categories before performing any kind of predictions / models can also activated create post joining few tables possible , when ever necessary once again varying across tools being used Thereby diving deep into analyzing available features determined randomly thus creating correlation matrices figures showing distribution relationships using correlation & covariance matrixes , thus making evaluations deducing informative facts since revealing trends identified through corresponding scatter plots from a given metric gathered from appropriate fields!

Research Ideas

• Building a predictive cancer incidence model based on county-level demographic data to identify high-risk areas and target public health interventions.
• Analyzing correlations between age-adjusted death rate, average annual count, and recent trends in order to develop more effective policy initiatives for cancer prevention and healthcare access.
• Utilizing the dataset to construct a machine learning algorithm that can predict county-level mortality rates based on socio-economic factors such as poverty levels and educational attainment rates

Acknowledgements

If you use this dataset i...