# Mostly Right

Mostly Right publishes open, machine-readable datasets as immutable Apache Parquet versions: time series, benchmarks and reference data for analysis and machine learning. Every dataset carries a documented column schema, column profiles, an explicit licence and a named publisher.

Reading metadata, schemas and sample rows needs no account. To query rows or download a full snapshot, a user signs up free and connects the dataset to one workspace.

- Dataset directory: /datasets
- Every public dataset and table, in one file: /llms-full.txt
- One dataset as Markdown: /datasets/{slug}/llms.txt
- Public Dataset API: https://mostlyright.md/docs/reference/public-dataset-api/
- Use a public dataset: https://mostlyright.md/docs/guides/use-public-datasets/
- Quickstart for agents: https://mostlyright.md/docs/guides/for-agents/
- Connect an AI tool with MCP: https://mostlyright.md/docs/guides/mcp/
- MCP server: /api/mcp (server card: /.well-known/mcp.json)
- OpenAPI: /api/v2/public/openapi.json

Use the traditional HTTP API for application code. GET /api/v2/public/datasets searches the catalogue and needs no key. GET /api/v2/public/tables/{tableId}/schema and GET /api/v2/public/tables/{tableId}/preview need no key. GET /api/v2/public/tables/{tableId}/current returns application/vnd.apache.parquet. POST /api/v2/public/tables/{tableId}/query returns bounded JSON. The last two take a workspace key as x-api-key: mr_use_…. Do not assume arbitrary SQL is available.

Agents can use the MCP server at /api/mcp instead: Streamable HTTP, protocol 2025-11-25 (2025-06-18, 2025-03-26 and 2024-11-05 also negotiate), stateless, no session id. Server card: /.well-known/mcp.json. search_datasets, get_dataset, list_tables, get_table_schema, sample_rows, get_download_instructions and get_access_instructions answer with NO credential. query_table and list_connected_datasets take a read-only mr_use_ workspace key as Authorization: Bearer, or an OAuth connection. connect_dataset changes the workspace and needs the OAuth connection.

Results should cite the dataset, table, immutable version, content digest, and query time.

## Datasets

1 public dataset, most recently published first.

### US Weather Reports and Daily Highs in 20 Cities

- Slug: us-weather-reports-and-daily-highs-in-20-cities
- Summary: Every METAR and SPECI weather report since January 1, 2020 for 20 US cities, one table per city, with each report's climate date and that date's official National Weather Service daily high and low on the same row. Reports come from the Io…
- Page: https://mostlyright.md/datasets/us-weather-reports-and-daily-highs-in-20-cities
- Publisher: mostlyrightmd
- Published: 2026-09-04T09:28:30.146Z
- Metadata: GET https://mostlyright.md/api/v2/public/datasets/us-weather-reports-and-daily-highs-in-20-cities
- This dataset as Markdown: https://mostlyright.md/datasets/us-weather-reports-and-daily-highs-in-20-cities/llms.txt

Tables (20):

- reports_kphl (reports-kphl)
  - tableId: f38ee271-11bc-4803-a2fc-37287440e519
  - version_id: 2a965033-154b-4d05-82ea-2e70bbd39667
  - Schema: GET https://mostlyright.md/api/v2/public/tables/f38ee271-11bc-4803-a2fc-37287440e519/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/f38ee271-11bc-4803-a2fc-37287440e519/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/f38ee271-11bc-4803-a2fc-37287440e519/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/f38ee271-11bc-4803-a2fc-37287440e519/current (x-api-key: mr_use_…, Parquet)
- reports_khou (reports-khou)
  - tableId: 9382176f-6ad8-47fe-b4b6-8c423a09ac1f
  - version_id: dbe696a8-9802-4302-ab2c-a03d5b9d92af
  - Schema: GET https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/current (x-api-key: mr_use_…, Parquet)
- reports_kdca (reports-kdca)
  - tableId: b13df66e-c104-4c12-8b18-71c5f30b775a
  - version_id: afc2c154-3d2a-4062-bfb0-e10f87a10d52
  - Schema: GET https://mostlyright.md/api/v2/public/tables/b13df66e-c104-4c12-8b18-71c5f30b775a/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/b13df66e-c104-4c12-8b18-71c5f30b775a/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/b13df66e-c104-4c12-8b18-71c5f30b775a/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/b13df66e-c104-4c12-8b18-71c5f30b775a/current (x-api-key: mr_use_…, Parquet)
- reports_knyc (reports-knyc)
  - tableId: cdc8c2aa-4ccd-43da-ac53-90b2850121cb
  - version_id: 4ba96ca1-3359-449d-b69e-2722fc91670e
  - Schema: GET https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/current (x-api-key: mr_use_…, Parquet)
- reports_katl (reports-katl)
  - tableId: 6509f331-30e7-4593-bae6-a1f7aaba0159
  - version_id: 289d33b3-c77d-4f64-9cef-0750b0c13282
  - Schema: GET https://mostlyright.md/api/v2/public/tables/6509f331-30e7-4593-bae6-a1f7aaba0159/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/6509f331-30e7-4593-bae6-a1f7aaba0159/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/6509f331-30e7-4593-bae6-a1f7aaba0159/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/6509f331-30e7-4593-bae6-a1f7aaba0159/current (x-api-key: mr_use_…, Parquet)
- reports_kphx (reports-kphx)
  - tableId: 77031a86-8bbb-4217-a7a0-2758ac77d561
  - version_id: 12afb44d-ee0e-4ad4-ab63-78bd406c2cb9
  - Schema: GET https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/current (x-api-key: mr_use_…, Parquet)
- reports_ksea (reports-ksea)
  - tableId: da9c5982-e772-414c-bcc5-e35e816420fc
  - version_id: b0e8f4d5-d015-4cf0-bcf9-78afff32005b
  - Schema: GET https://mostlyright.md/api/v2/public/tables/da9c5982-e772-414c-bcc5-e35e816420fc/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/da9c5982-e772-414c-bcc5-e35e816420fc/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/da9c5982-e772-414c-bcc5-e35e816420fc/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/da9c5982-e772-414c-bcc5-e35e816420fc/current (x-api-key: mr_use_…, Parquet)
- reports_ksfo (reports-ksfo)
  - tableId: f290a279-c39c-4bc7-8e04-974e0bcd480a
  - version_id: 159336ad-dfa6-4f48-b4bf-956a62fb4f3a
  - Schema: GET https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/current (x-api-key: mr_use_…, Parquet)
- reports_kdfw (reports-kdfw)
  - tableId: ed9260f8-0253-423f-9ba1-ce58a8632702
  - version_id: 4d9611a8-8a20-4db4-a2c6-dfd156241018
  - Schema: GET https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/current (x-api-key: mr_use_…, Parquet)
- reports_kmsp (reports-kmsp)
  - tableId: aea40995-a418-4eee-a004-bd0b23ced5cd
  - version_id: 65b13f1d-864f-4a8a-a005-65c702db79bd
  - Schema: GET https://mostlyright.md/api/v2/public/tables/aea40995-a418-4eee-a004-bd0b23ced5cd/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/aea40995-a418-4eee-a004-bd0b23ced5cd/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/aea40995-a418-4eee-a004-bd0b23ced5cd/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/aea40995-a418-4eee-a004-bd0b23ced5cd/current (x-api-key: mr_use_…, Parquet)
- reports_ksat (reports-ksat)
  - tableId: bd6885b8-9935-4cd2-bcc7-620fc83d9ff0
  - version_id: 3bd92144-e0d3-490c-bea8-f05828e64051
  - Schema: GET https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/current (x-api-key: mr_use_…, Parquet)
- reports_kden (reports-kden)
  - tableId: 779b3250-90d2-4d72-9d90-e7275da1c2c0
  - version_id: 9ae3a8cf-42e9-4710-b01b-7d92d5a0b2bc
  - Schema: GET https://mostlyright.md/api/v2/public/tables/779b3250-90d2-4d72-9d90-e7275da1c2c0/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/779b3250-90d2-4d72-9d90-e7275da1c2c0/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/779b3250-90d2-4d72-9d90-e7275da1c2c0/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/779b3250-90d2-4d72-9d90-e7275da1c2c0/current (x-api-key: mr_use_…, Parquet)
- reports_klax (reports-klax)
  - tableId: 1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20
  - version_id: 37973fbc-32fe-4a78-821e-60d0fa101d9b
  - Schema: GET https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/current (x-api-key: mr_use_…, Parquet)
- reports_kmdw (reports-kmdw)
  - tableId: 1933e0be-5f4a-47e9-9085-f95a898a64fa
  - version_id: 071809e0-4af8-421c-a8c0-4be279b19863
  - Schema: GET https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/current (x-api-key: mr_use_…, Parquet)
- reports_kokc (reports-kokc)
  - tableId: fdfd9aee-c524-409e-b387-23a11aae653d
  - version_id: 56fa3bf1-e1f2-42dd-a07d-79516aa563f6
  - Schema: GET https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/current (x-api-key: mr_use_…, Parquet)
- reports_kbos (reports-kbos)
  - tableId: d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c
  - version_id: 54225b39-c833-4b79-8b63-c71e94767ddc
  - Schema: GET https://mostlyright.md/api/v2/public/tables/d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c/current (x-api-key: mr_use_…, Parquet)
- reports_kmsy (reports-kmsy)
  - tableId: b7e704f9-a128-4ff0-bded-52d062d2406e
  - version_id: a945b2a2-bbdf-4fd3-91e7-92b60c9ffaed
  - Schema: GET https://mostlyright.md/api/v2/public/tables/b7e704f9-a128-4ff0-bded-52d062d2406e/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/b7e704f9-a128-4ff0-bded-52d062d2406e/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/b7e704f9-a128-4ff0-bded-52d062d2406e/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/b7e704f9-a128-4ff0-bded-52d062d2406e/current (x-api-key: mr_use_…, Parquet)
- reports_klas (reports-klas)
  - tableId: 4b712d4d-ca7c-41f4-a79b-1450b638cdca
  - version_id: 5ff979d8-8d15-404d-8345-e880e8837624
  - Schema: GET https://mostlyright.md/api/v2/public/tables/4b712d4d-ca7c-41f4-a79b-1450b638cdca/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/4b712d4d-ca7c-41f4-a79b-1450b638cdca/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/4b712d4d-ca7c-41f4-a79b-1450b638cdca/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/4b712d4d-ca7c-41f4-a79b-1450b638cdca/current (x-api-key: mr_use_…, Parquet)
- reports_kmia (reports-kmia)
  - tableId: 7e9551c7-f632-4c12-ada9-c261299ba53f
  - version_id: 77b83637-4d01-4ae7-9392-6b1c1867626b
  - Schema: GET https://mostlyright.md/api/v2/public/tables/7e9551c7-f632-4c12-ada9-c261299ba53f/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/7e9551c7-f632-4c12-ada9-c261299ba53f/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/7e9551c7-f632-4c12-ada9-c261299ba53f/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/7e9551c7-f632-4c12-ada9-c261299ba53f/current (x-api-key: mr_use_…, Parquet)
- reports_kaus (reports-kaus)
  - tableId: 60849d5a-6ac3-410a-8be5-36286f8590d7
  - version_id: 3292e42a-cd13-426e-bfd0-312ae30b3b9a
  - Schema: GET https://mostlyright.md/api/v2/public/tables/60849d5a-6ac3-410a-8be5-36286f8590d7/schema
  - Preview: GET https://mostlyright.md/api/v2/public/tables/60849d5a-6ac3-410a-8be5-36286f8590d7/preview
  - Query: POST https://mostlyright.md/api/v2/public/tables/60849d5a-6ac3-410a-8be5-36286f8590d7/query (x-api-key: mr_use_…)
  - Current: GET https://mostlyright.md/api/v2/public/tables/60849d5a-6ac3-410a-8be5-36286f8590d7/current (x-api-key: mr_use_…, Parquet)

## Limits

POST .../query returns 25 rows when no limit is given and at most 100. A result is capped at 64 KiB of JSON and 15 s of execution, and at most 20 columns, 8 filters, and 2 sort keys.

The response reports returned_rows, scanned_bytes, elapsed_ms, and whether the result was truncated. Do not page a whole table through this endpoint: download GET .../current once and query the Parquet file locally instead.

## Citing a result

Cite five things: the dataset (name and page URL), the table, the immutable version_id the result came from, the content digest, and the time you ran the query.

A query response carries table.version_id, table.content_digest, and citation.dataset_url. A Current download carries a strong ETag and a Content-Digest header. Any version_id printed in this file is the version that was current when the file was generated; always cite the one your own response returned.