Public sample Data files

Climate Chronicles: Analyzing 22.9 Million Data Points in Temperature Weather Data 2023

This spreadsheet contains all daily and station elements found in GHCN daily for the given year.  Files are updated daily for the entire period of record.  The following information serves as a definition of each field in one line of data covering one station-day.   Each field described below is separated by a comma ( , ) and follows the order below:  ID = 11 character station identification code YEAR/MONTH/DAY = 8 character date in YYYYMMDD format (e.g. 19860529 = May 29, 1986) ELEMENT = 4 character indicator of element type  DATA VALUE = 5 character data value for ELEMENT  M-FLAG = 1 character Measurement Flag  Q-FLAG = 1 character Quality Flag  S-FLAG = 1 character Source Flag  OBS-TIME = 4-character time of observation in hour-minute format (i.e. 0700 =7:00 am)  See section III of the GHCN-Daily readme.txt file (ftp://ftp.ncdc.noaa.gov/pub/data/ghcn/daily/readme.txt) for an explanation of ELEMENT codes and their units as well as the M-FLAG, Q-FLAG and S-FLAG.  The OBS-TIME field is populated with the observation times contained in NOAA/NCEI's HOMR station history database.

Data Source:
View in Gigasheet ↗

Unlock the full potential of your large-scale data with Gigasheet's self-service analytics, offering a real-time, spreadsheet-like interface for enterprise databases, warehouses, and lakes. Empower teams to securely analyze, manage, and visualize massive datasets—no SQL expertise, steep learning curves, or extra infrastructure required. Facilitate governed access, streamline collaboration, and maintain compliance effortlessly across your organization.

Discover why over 100,000 users trust Gigasheet for data analytics. Learn more about our Enterprise Solutions or sign up to try it today with the data above.

More Sample Data Files

Previous Spreadsheet

No previous post!
Back to all sample data

Next Spreadsheet

No next post!
Back to all sample data

130,000+ people use Gigasheet.

Self-service analytics for huge files, databases, warehouses and more.
No Code
No Training
No Install
See it in action

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.