São Paulo weather reports and daily highs since 2020

Public

reports_sbgr

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:37
Rows
62,219
across released Tables
Tables
1
released
Columns
37
reports_sbgr
Version
reports_sbgr

Data preview

reports_sbgr
Preview rows for reports_sbgr
stationevent_time_utcobservation_typelocal_standard_datetemp_ftemp_cdewpoint_frelative_humidity_pctwind_direction_degreeswind_speed_ktwind_gust_ktaltimeter_inhgsea_level_pressure_hpasky_cover_1sky_base_1_ftsky_cover_2sky_base_2_ftsky_cover_3sky_base_3_ftsky_cover_4
SBGR2020-01-01T03:00:00.000000ZMETAR2020-01-0169.8021.068.0094.01110.002.0029.910NSC
SBGR2020-01-01T04:00:00.000000ZMETAR2020-01-0168.0020.068.00100.0060.003.0029.880SCT1500.00SCT18000.00
SBGR2020-01-01T05:00:00.000000ZMETAR2020-01-0168.0020.068.00100.0090.001.0029.880NSC
SBGR2020-01-01T06:00:00.000000ZMETAR2020-01-0166.2019.066.20100.000.000.0029.880NSC
SBGR2020-01-01T07:00:00.000000ZMETAR2020-01-0168.0020.068.00100.0080.003.0029.880NSC
SBGR2020-01-01T08:00:00.000000ZMETAR2020-01-0168.0020.066.2093.9760.005.0029.880
SBGR2020-01-01T09:00:00.000000ZMETAR2020-01-0168.0020.066.2093.970.000.0029.880
SBGR2020-01-01T10:00:00.000000ZMETAR2020-01-0175.2024.066.2073.6120.005.0029.880
SBGR2020-01-01T11:00:00.000000ZMETAR2020-01-0177.0025.068.0073.7810.008.0029.910
SBGR2020-01-01T12:00:00.000000ZMETAR2020-01-0180.6027.069.8069.71340.006.0029.910FEW3000.00
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

37 columns
Verified column analytics for reports_sbgr
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • SBGR100%

Top: SBGR

event_time_utctimestamp_utc0.0%0 values62,219100.0%
  • 2020-01-01 03:00:00+000%
  • 2020-01-01 04:00:00+000%
  • 2020-01-01 05:00:00+000%
  • Other (62,207)

Top: 2020-01-01 03:00:00+00 · 62,207 more values

observation_typestring0.0%0 values2<0.1%
  • METAR94%
  • SPECI6%

Top: METAR

local_standard_datedate0.0%0 values2,4443.9%
  • 2020-12-160%
  • 2026-09-010%
  • 2020-10-090%
  • Other (2,432)

Top: 2020-12-16 · 61,805 more values

temp_fdecimal<0.1%7 values37<0.1%
  • 68.009%
  • 69.809%
  • 66.209%
  • Other (25)

Top: 68.00 · 13,549 more values

Median 68.00P25 62.60 · P75 73.40
temp_cdecimal<0.1%7 values37<0.1%
  • 20.09%
  • 21.09%
  • 19.09%
  • Other (25)

Top: 20.0 · 13,549 more values

Median 20.0P25 17.0 · P75 23.0
dewpoint_fdecimal<0.1%8 values33<0.1%
  • 66.2011%
  • 64.4010%
  • 59.0010%
  • Other (21)

Top: 66.20 · 4,529 more values

Median 60.80P25 55.40 · P75 66.20
relative_humidity_pctdecimal<0.1%8 values8541.4%
  • 100.0010%
  • 93.972%
  • 93.792%
  • Other (842)

Top: 100.00 · 45,017 more values

Median 82.98P25 68.35 · P75 93.69
wind_direction_degreesdecimal0.1%91 values37<0.1%
  • 70.0010%
  • 80.009%
  • 60.006%
  • Other (25)

Top: 70.00 · 21,112 more values

Median 120.00P25 70.00 · P75 170.00
wind_speed_ktdecimal<0.1%5 values31<0.1%
  • 5.0014%
  • 4.0013%
  • 6.0012%
  • Other (19)

Top: 5.00 · 2,553 more values

Median 5.00P25 3.00 · P75 7.00
wind_gust_ktdecimal98.9%61,543 values355.2%
  • 22.009%
  • 25.008%
  • 23.008%
  • Other (23)

Top: 22.00 · 171 more values

Median 24.00P25 21.00 · P75 28.00
altimeter_inhgdecimal<0.1%7 values32<0.1%
  • 30.06010%
  • 30.03010%
  • 30.0909%
  • Other (20)

Top: 30.060 · 8,665 more values

Median 30.060P25 30.000 · P75 30.150
sea_level_pressure_hpadecimal100.0%62,219 values00.0%

No distribution published

No distribution published

sky_cover_1string29.4%18,318 values6<0.1%
  • BKN37%
  • SCT21%
  • OVC19%

Top: BKN

sky_base_1_ftdecimal35.1%21,860 values520.1%
  • 1300.0011%
  • 900.009%
  • 1100.009%
  • Other (40)

Top: 1300.00 · 10,834 more values

Median 1300.00P25 900.00 · P75 2500.00
sky_cover_2string75.6%47,066 values5<0.1%
  • BKN45%
  • OVC30%
  • FEW14%

Top: BKN

sky_base_2_ftdecimal75.7%47,100 values660.4%
  • 10000.0011%
  • 4000.009%
  • 5000.009%
  • Other (54)

Top: 10000.00 · 3,863 more values

Median 3500.00P25 2000.00 · P75 6000.00
sky_cover_3string96.1%59,788 values50.2%
  • BKN44%
  • OVC38%
  • FEW13%

Top: BKN

sky_base_3_ftdecimal96.1%59,792 values502.1%
  • 10000.0023%
  • 8000.0018%
  • 7000.0012%
  • Other (38)

Top: 10000.00 · 331 more values

Median 7000.00P25 4000.00 · P75 9000.00
sky_cover_4string99.8%62,095 values32.4%
  • OVC48%
  • BKN48%
  • FEW4%

Top: OVC

Show 17 more columns
Verified column analytics for reports_sbgr
sky_base_4_ftdecimal99.8%62,095 values129.7%
  • 8000.0037%
  • 10000.0030%
  • 7000.0010%

Top: 8000.00

Median 8000.00P25 8000.00 · P75 10000.00
visibility_milesdecimal<0.1%7 values38<0.1%
  • 6.2176%
  • 4.975%
  • 5.594%
  • Other (26)

Top: 6.21 · 769 more values

Median 6.21P25 6.21 · P75 6.21
weather_codesstring84.3%52,446 values680.7%
  • -RA29%
  • BR20%
  • -RA BR6%
  • Other (56)

Top: -RA · 1,264 more values

precipitation_in_1hdecimal0.0%0 values1<0.1%
  • 0.000100%

Top: 0.000

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_ktdecimal100.0%62,219 values00.0%

No distribution published

No distribution published

peak_wind_direction_degreesdecimal100.0%62,219 values00.0%

No distribution published

No distribution published

peak_wind_timestring100.0%62,219 values00.0%

No distribution published

No distribution published

snow_depth_inchesdecimal100.0%62,219 values00.0%

No distribution published

No distribution published

raw_metarstring0.0%0 values62,208100.0%
  • SBGR 020200Z 07006KT CAVOK 21/19 Q10170%
  • SBGR 040700Z 07006KT CAVOK 20/18 Q10190%
  • SBGR 041900Z 18006KT 9999 FEW050TCU BKN070 23/18 Q1020 RETS0%
  • Other (62,196)

Top: SBGR 020200Z 07006KT CAVOK 21/19 Q1017 · 62,196 more values

cli_productstring100.0%62,219 values00.0%

No distribution published

No distribution published

cli_high_finteger100.0%62,219 values00.0%

No distribution published

All-row histogram

cli_low_finteger100.0%62,219 values00.0%

No distribution published

All-row histogram

cli_report_typestring100.0%62,219 values00.0%

No distribution published

No distribution published

metar_high_fdecimal0.0%0 values25<0.1%
  • 80.609%
  • 78.809%
  • 82.408%
  • Other (13)

Top: 80.60 · 11,407 more values

Median 80.60P25 73.40 · P75 84.20
metar_low_fdecimal0.0%0 values24<0.1%
  • 66.2012%
  • 64.4012%
  • 60.8011%
  • Other (12)

Top: 66.20 · 3,782 more values

Median 60.80P25 57.20 · P75 66.20
metar_high_cdecimal0.0%0 values25<0.1%
  • 27.09%
  • 26.09%
  • 28.08%
  • Other (13)

Top: 27.0 · 11,407 more values

Median 27.0P25 23.0 · P75 29.0
metar_low_cdecimal0.0%0 values24<0.1%
  • 19.012%
  • 18.012%
  • 16.011%
  • Other (12)

Top: 19.0 · 3,782 more values

Median 16.0P25 14.0 · P75 19.0

Release status

Facts from the current passing release

Release
Passing
Rows
62,219
Columns
37
Published
9 Sept 2026, 06:37
Analytics
Verified across all rows

Use dataset

Query this dataset with the API, connect an AI tool with MCP, or download a Parquet file.

cURL · reports_sbgr
reports_sbgr
# Current release — the complete Parquet file
curl -sS -o reports-sbgr.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/1b1ee9aa-05ff-4c4d-ba76-9169766cfd8a/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/1b1ee9aa-05ff-4c4d-ba76-9169766cfd8a/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/1b1ee9aa-05ff-4c4d-ba76-9169766cfd8a/query" \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  -H "content-type: application/json" \
  --data '{"columns": ["station","event_time_utc"], "limit": 100}'

MOSTLYRIGHT_API_KEY requires an mr_use_ API key from a workspace that has added this dataset. An mr_live_ key will not work here. Reference: OpenAPI · guide.

Report this Table

Build your own datasets

Create a free workspace to build and maintain data your team keeps private.

Create a free workspace

Already have an account? Log in

DocsPricingTermsPrivacyStatus