Baselight

Temperature Over Time By State (Starts: 1895)

State and County Temperature Changes

@kaggle.thedevastator_analyzing_u_s_warming_rates_insights_into_climat

Loading...
Loading...

About this Dataset

Temperature Over Time By State (Starts: 1895)


Temperature Over Time by State (Starts: 1895)

State and County Temperature Changes

By Environmental Data [source]


About this dataset

Do you want to know how rising temperatures are changing the contiguous United States? The Washington Post has used National Oceanic and Atmospheric Administration's Climate Divisional Database (nClimDiv) and Gridded 5km GHCN-Daily Temperature and Precipitation Dataset (nClimGrid) data sets to help analyze warming temperatures in all of the Lower 48 states from 1895-2019. To provide this analysis, we calculated annual mean temperature trends in each state and county in the Lower 48 states. Our results can be found within several datasets now available on this repository.

We are offering: Annual average temperatures for counties and states, temperature change estimates for each of the Lower 48-states, temperature change estimates for counties in the contiguous U.S., county temperature change data joined to a shapefile in GeoJSON format, gridded temperature change data for the contiguous U.S. in GeoTiff format - all contained with our dataset! We invite those curious about climate change to explore these data sets based on our analysis over multiple stories published by The Washington Post such as Extreme climate change has arrived in America, Fires, floods and free parking: California’s unending fight against climate change, In fast-warming Minnesota, scientists are trying to plant the forests of the future, This giant climate hot spot is robbing West of its water ,and more!

By accessing our dataset containing columns such as fips code, year range from 1895-2019, three season temperatures (Fall/Spring/Summer/Winter), max warming season temps plus temp recorded total yearly - you can become an active citizen scientist! If publishing a story or graphic work based off this data set please credit The Washington Post with a link back to this repository while sending us an email so that we can track its usage as well - 2cdatawashpost.com.

More Datasets

For more datasets, click here.

Featured Notebooks

  • 🚨 Your notebook can be here! 🚨!

How to use the dataset

The main files provided by this dataset are climdiv_state_year, climdiv_county_year, model_state, model_county , climdiv_national_year ,and model county .geojson . Each file contains different information capturing climate change across different geographies of the United States over time spans from 1895.

Research Ideas

  • Investigating and mapping the temperatures for all US states over the past 120 years, to observe long-term changes in temperature patterns.
  • Examining regional biases in warming trends across different US counties and states to help inform resource allocation decisions for climate change mitigation and adaption initiatives.
  • Utilizing the ClimDiv National Dataset to understand continental-level average annual temperature changes, allowing comparison of global average temperatures with US averages over a long period of time

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: climdiv_state_year.csv

Column name Description
fips Federal Information Processing Standard code for each county. (Integer)
year Year of the temperature data. (Integer)
tempc Temperature change from the previous year. (Float)

File: climdiv_county_year.csv

Column name Description
fips Federal Information Processing Standard code for each county. (Integer)
year Year of the temperature data. (Integer)
tempc Temperature change from the previous year. (Float)

File: model_state.csv

Column name Description
fips Federal Information Processing Standard code for each county. (Integer)
Fall Average temperature for the fall season (September, October, November). (Float)
Spring Average temperature for the spring season (March, April, May). (Float)
Summer Average temperature for the summer season (June, July, August). (Float)
Winter Average temperature for the winter season (December, January, February). (Float)
max_warming_season Maximum temperature change for the season. (Float)
Annual Average temperature for the year. (Float)
STUSAB Two-letter abbreviation for the state. (String)
STATE_NAME Full name of the state. (String)
STATENS National Standard code for the state. (Integer)

File: model_county.csv

Column name Description
fips Federal Information Processing Standard code for each county. (Integer)
Fall Average temperature for the fall season (September, October, November). (Float)
Spring Average temperature for the spring season (March, April, May). (Float)
Summer Average temperature for the summer season (June, July, August). (Float)
Winter Average temperature for the winter season (December, January, February). (Float)
max_warming_season Maximum temperature change for the season. (Float)
Annual Average temperature for the year. (Float)
CTYNAME County name. (String)
STNAME State name. (String)

File: climdiv_national_year.csv

Column name Description
year Year of the temperature data. (Integer)
tempc Temperature change from the previous year. (Float)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Environmental Data.

Tables

Climdiv County Year

@kaggle.thedevastator_analyzing_u_s_warming_rates_insights_into_climat.climdiv_county_year
  • 3.07 MB
  • 388375 rows
  • 5 columns
Loading...

CREATE TABLE climdiv_county_year (
  "index" BIGINT,
  "fips" BIGINT,
  "year" BIGINT,
  "temp" DOUBLE,
  "tempc" DOUBLE
);

Climdiv National Year

@kaggle.thedevastator_analyzing_u_s_warming_rates_insights_into_climat.climdiv_national_year
  • 6.41 KB
  • 125 rows
  • 4 columns
Loading...

CREATE TABLE climdiv_national_year (
  "index" BIGINT,
  "year" BIGINT,
  "temp" DOUBLE,
  "tempc" DOUBLE
);

Climdiv State Year

@kaggle.thedevastator_analyzing_u_s_warming_rates_insights_into_climat.climdiv_state_year
  • 84.55 KB
  • 6000 rows
  • 5 columns
Loading...

CREATE TABLE climdiv_state_year (
  "index" BIGINT,
  "fips" BIGINT,
  "year" BIGINT,
  "temp" DOUBLE,
  "tempc" DOUBLE
);

Model County

@kaggle.thedevastator_analyzing_u_s_warming_rates_insights_into_climat.model_county
  • 206.7 KB
  • 3107 rows
  • 10 columns
Loading...

CREATE TABLE model_county (
  "index" BIGINT,
  "fips" BIGINT,
  "fall" DOUBLE,
  "spring" DOUBLE,
  "summer" DOUBLE,
  "winter" DOUBLE,
  "max_warming_season" VARCHAR,
  "annual" DOUBLE,
  "ctyname" VARCHAR,
  "stname" VARCHAR
);

Model State

@kaggle.thedevastator_analyzing_u_s_warming_rates_insights_into_climat.model_state
  • 11.1 KB
  • 48 rows
  • 11 columns
Loading...

CREATE TABLE model_state (
  "index" BIGINT,
  "fips" BIGINT,
  "fall" DOUBLE,
  "spring" DOUBLE,
  "summer" DOUBLE,
  "winter" DOUBLE,
  "max_warming_season" VARCHAR,
  "annual" DOUBLE,
  "stusab" VARCHAR,
  "state_name" VARCHAR,
  "statens" BIGINT
);

Share link

Anyone who has the link will be able to view this.