CREATE TABLE `bigquery-public-data.noaa_gsod.gsod2000` (
  stn STRING OPTIONS(description="Station number (WMO/DATSAV3 number) for the location"),
  wban STRING OPTIONS(description="WBAN number where applicable—this is the historical 'Weather Bureau Air Force Navy' number, with WBAN being the acronym"),
  year STRING OPTIONS(description="The year"),
  mo STRING OPTIONS(description="The month"),
  da STRING OPTIONS(description="The day"),
  temp FLOAT64 OPTIONS(description="Mean temperature for the day in degrees Fahrenheit to the tenths. Missing = 9999.9"),
  count_temp INT64 OPTIONS(description="Number of observations used in calculating mean temperature"),
)
OPTIONS(
  description="Global summary of day data for 18 surface meteorological elements derived from synoptic/hourly observations"
);