Mumbai weather reports and daily highs since 2020

Public

reports_vabb

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:37
Rows
116,265
across released Tables
Tables
1
released
Columns
37
reports_vabb
Version
reports_vabb

Data preview

reports_vabb
Preview rows for reports_vabb
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
VABB2020-01-01T00:00:00.000000ZMETAR2020-01-0168.0020.057.2068.3580.003.0029.880NSC
VABB2020-01-01T00:30:00.000000ZSPECI2020-01-0168.0020.057.2068.35130.003.0029.880NSC
VABB2020-01-01T01:00:00.000000ZMETAR2020-01-0168.0020.055.4064.04150.004.0029.880NSC
VABB2020-01-01T01:30:00.000000ZSPECI2020-01-0168.0020.055.4064.04100.003.0029.910NSC
VABB2020-01-01T02:00:00.000000ZMETAR2020-01-0166.2019.055.4068.1580.005.0029.940NSC
VABB2020-01-01T02:30:00.000000ZSPECI2020-01-0168.0020.055.4064.04100.004.0029.940NSC
VABB2020-01-01T03:00:00.000000ZMETAR2020-01-0169.8021.057.2064.26110.005.0029.970NSC
VABB2020-01-01T03:30:00.000000ZSPECI2020-01-0169.8021.057.2064.26130.005.0029.970NSC
VABB2020-01-01T04:00:00.000000ZMETAR2020-01-0173.4023.057.2056.88120.005.0030.000NSC
VABB2020-01-01T04:30:00.000000ZSPECI2020-01-0175.2024.055.4050.1790.006.0030.000NSC
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

37 columns
Verified column analytics for reports_vabb
ColumnTypeUnitMissingDistinctDistributionSummary
stationstring0.0%0 values1<0.1%
  • VABB100%

Top: VABB

event_time_utctimestamp_utc0.0%0 values116,265100.0%
  • 2020-01-01 00:00:00+000%
  • 2020-01-01 00:30:00+000%
  • 2020-01-01 01:00:00+000%
  • Other (116,253)

Top: 2020-01-01 00:00:00+00 · 116,253 more values

observation_typestring0.0%0 values2<0.1%
  • SPECI50%
  • METAR50%

Top: SPECI

local_standard_datedate0.0%0 values2,4412.1%
  • 2026-05-300%
  • 2026-05-290%
  • 2024-06-060%
  • Other (2,429)

Top: 2026-05-30 · 115,651 more values

temp_fdecimal<0.1%12 values25<0.1%
  • 82.4015%
  • 84.2014%
  • 80.6013%
  • Other (13)

Top: 82.40 · 4,308 more values

Median 84.20P25 80.60 · P75 86.00
temp_cdecimal<0.1%12 values25<0.1%
  • 28.015%
  • 29.014%
  • 27.013%
  • Other (13)

Top: 28.0 · 4,308 more values

Median 29.0P25 27.0 · P75 30.0
dewpoint_fdecimal<0.1%13 values33<0.1%
  • 77.0017%
  • 78.8017%
  • 75.2010%
  • Other (21)

Top: 77.00 · 20,059 more values

Median 75.20P25 64.40 · P75 77.00
relative_humidity_pctdecimal<0.1%13 values8470.7%
  • 88.903%
  • 100.003%
  • 83.883%
  • Other (835)

Top: 88.90 · 87,778 more values

Median 70.45P25 54.30 · P75 83.77
wind_direction_degreesdecimal0.5%549 values42<0.1%
  • 0.0011%
  • 250.006%
  • 240.006%
  • Other (30)

Top: 0.00 · 45,510 more values

Median 240.00P25 90.00 · P75 280.00
wind_speed_ktdecimal<0.1%13 values36<0.1%
  • 4.0012%
  • 5.0012%
  • 0.0011%
  • Other (24)

Top: 4.00 · 2,852 more values

Median 6.00P25 4.00 · P75 9.00
wind_gust_ktdecimal93.0%108,099 values330.4%
  • 17.0024%
  • 18.0018%
  • 20.0013%
  • Other (21)

Top: 17.00 · 167 more values

Median 19.00P25 18.00 · P75 21.00
altimeter_inhgdecimal<0.1%7 values34<0.1%
  • 29.8509%
  • 29.7709%
  • 29.7409%
  • Other (22)

Top: 29.850 · 13,856 more values

Median 29.800P25 29.710 · P75 29.880
sea_level_pressure_hpadecimal100.0%116,265 values00.0%

No distribution published

No distribution published

sky_cover_1string<0.1%40 values4<0.1%
  • FEW35%
  • NSC35%
  • SCT29%

Top: FEW

sky_base_1_ftdecimal34.9%40,527 values22<0.1%
  • 2000.0048%
  • 1800.0020%
  • 10000.0013%
  • Other (10)

Top: 2000.00 · 41 more values

Median 2000.00P25 1800.00 · P75 2000.00
sky_cover_2string54.4%63,221 values4<0.1%
  • SCT72%
  • FEW23%
  • BKN5%

Top: SCT

sky_base_2_ftdecimal54.4%63,221 values16<0.1%
  • 2500.0053%
  • 1800.0018%
  • 10000.0014%
  • Other (4)

Top: 2500.00 · 4 more values

Median 2500.00P25 2500.00 · P75 2500.00
sky_cover_3string69.4%80,745 values4<0.1%
  • BKN52%
  • FEW41%
  • OVC4%

Top: BKN

sky_base_3_ftdecimal69.4%80,745 values8<0.1%
  • 9000.0030%
  • 3000.0028%
  • 10000.0026%

Top: 9000.00

Median 9000.00P25 3000.00 · P75 10000.00
sky_cover_4string88.0%102,349 values4<0.1%
  • OVC61%
  • BKN38%
  • FEW0%

Top: OVC

Show 17 more columns
Verified column analytics for reports_vabb
sky_base_4_ftdecimal88.0%102,349 values8<0.1%
  • 8000.0050%
  • 9000.0044%
  • 10000.005%

Top: 8000.00

Median 8000.00P25 8000.00 · P75 9000.00
visibility_milesdecimal<0.1%7 values45<0.1%
  • 1.8630%
  • 1.5525%
  • 2.4913%
  • Other (33)

Top: 1.86 · 3,334 more values

Median 1.86P25 1.55 · P75 2.17
weather_codesstring2.0%2,298 values37<0.1%
  • HZ48%
  • FU33%
  • BR9%
  • Other (25)

Top: HZ · 826 more values

precipitation_in_1hdecimal0.0%0 values2<0.1%
  • 0.000100%
  • 0.9600%

Top: 0.000

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_ktdecimal100.0%116,264 values1100.0%
  • 29.00100%

Top: 29.00

Median 29.00P25 29.00 · P75 29.00
peak_wind_direction_degreesdecimal100.0%116,264 values1100.0%
  • 10.00100%

Top: 10.00

Median 10.00P25 10.00 · P75 10.00
peak_wind_timestring100.0%116,264 values1100.0%
  • 2020-08-10 23:11100%

Top: 2020-08-10 23:11

snow_depth_inchesdecimal100.0%116,265 values00.0%

No distribution published

No distribution published

raw_metarstring0.0%0 values116,254100.0%
  • VABB 041900Z 00000KT 2500 HZ FEW100 28/20 Q1011 NOSIG0%
  • VABB 101800Z 00000KT 2500 FU NSC 26/16 Q1012 NOSIG0%
  • VABB 151930Z 00000KT 3000 FU NSC 23/14 Q1010 NOSIG0%
  • Other (116,242)

Top: VABB 041900Z 00000KT 2500 HZ FEW100 28/20 Q1011 NOSIG · 116,242 more values

cli_productstring100.0%116,265 values00.0%

No distribution published

No distribution published

cli_high_finteger100.0%116,265 values00.0%

No distribution published

All-row histogram

cli_low_finteger100.0%116,265 values00.0%

No distribution published

All-row histogram

cli_report_typestring100.0%116,265 values00.0%

No distribution published

No distribution published

metar_high_fdecimal0.0%0 values19<0.1%
  • 91.4016%
  • 89.6015%
  • 87.8015%
  • Other (7)

Top: 91.40 · 1,481 more values

Median 89.60P25 86.00 · P75 93.20
metar_low_fdecimal0.0%0 values16<0.1%
  • 78.8020%
  • 80.6016%
  • 77.0015%
  • Other (4)

Top: 78.80 · 1,238 more values

Median 78.80P25 75.20 · P75 80.60
metar_high_cdecimal0.0%0 values19<0.1%
  • 33.016%
  • 32.015%
  • 31.015%
  • Other (7)

Top: 33.0 · 1,481 more values

Median 32.0P25 30.0 · P75 34.0
metar_low_cdecimal0.0%0 values16<0.1%
  • 26.020%
  • 27.016%
  • 25.015%
  • Other (4)

Top: 26.0 · 1,238 more values

Median 26.0P25 24.0 · P75 27.0

Release status

Facts from the current passing release

Release
Passing
Rows
116,265
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_vabb
reports_vabb
# Current release — the complete Parquet file
curl -sS -o reports-vabb.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/963abb05-64d0-4725-aa35-2d5c46dc2eb1/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/963abb05-64d0-4725-aa35-2d5c46dc2eb1/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/963abb05-64d0-4725-aa35-2d5c46dc2eb1/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