Public sample Data files

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

Open File in Gigasheet

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.

Is Your Data Too Big for Excel? Why Choose Between Database vs Spreadsheet? With Gigasheet, You Get the Best of Both.

Explore Gigasheet.
Sign up and start right away. Experience the power of Gigasheet with our sample data. Dive into large-scale data analysis effortlessly—no download required. Try it right here 👇

More Sample Data Files

Previous Spreadsheet

No previous post!
Back to all sample data

Next Spreadsheet

No next post!
Back to all sample data

Thousands of individuals & teams use Gigasheet.

Join Them.
No Code
No Database
No Credit Card
Sign Up Today, Free Forever

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.