Foreign exchange rates, United States
Foreign exchange rates for the United States dollar. Statistics Canada table 10-10-0087-01.
forexexchange-ratesstatcangovernment-of-canada
Qualité
100
Attribution
Contains information licensed under the Open Government Licence – Canada
Schéma
| Colonne | Type | Description |
|---|---|---|
| ref_date | string | Reference date — the time period the observation refers to (Statistics Canada table field REF_DATE). |
| geo | string | Geography the observation covers (Statistics Canada table field GEO). |
| type_of_exchange_rate_united_states | string | |
| uom | string | Unit of measure for the estimate (Statistics Canada table field UOM). |
| uom_id | integer | Unit of measure identifier (Statistics Canada table field UOM_ID). |
| scalar_factor | string | Scalar factor applied to the value, e.g. units, thousands or millions (Statistics Canada table field SCALAR_FACTOR). |
| scalar_id | integer | Scalar factor identifier (Statistics Canada table field SCALAR_ID). |
| vector | string | Vector number — Statistics Canada's unique identifier for the time series (table field VECTOR). |
| coordinate | float | Table coordinate locating the estimate within the source table (Statistics Canada table field COORDINATE). |
| value | float | Estimate value as published in the Statistics Canada table. |
| decimals | integer | Number of decimals published for the estimate (Statistics Canada table field DECIMALS). |
Exemple de lignes
| ref_date | geo | type_of_exchange_rate_united_states | uom | uom_id | scalar_factor | scalar_id | vector | coordinate | value | decimals |
|---|---|---|---|---|---|---|---|---|---|---|
| 1952-01 | Canada | Canadian cents per United States dollar, spot rate adjusted, by working days | Cents | 55 | units | 0 | v37699 | 1.1 | 100.06 | 2 |
| 1952-04 | Canada | Canadian cents per United States dollar, spot rate adjusted, by working days | Cents | 55 | units | 0 | v37699 | 1.1 | 98.14 | 2 |
| 1952-07 | Canada | Canadian cents per United States dollar, spot rate adjusted, by working days | Cents | 55 | units | 0 | v37699 | 1.1 | 96.35 | 2 |
| 1952-10 | Canada | Canadian cents per United States dollar, spot rate adjusted, by working days | Cents | 55 | units | 0 | v37699 | 1.1 | 97.02 | 2 |
| 1953-01 | Canada | Canadian cents per United States dollar, spot rate adjusted, by working days | Cents | 55 | units | 0 | v37699 | 1.1 | 97.71 | 2 |
Utiliser avec un LLM
Dirigez n’importe quel LLM vers le point d’accès des métadonnées — la documentation ci-dessus est aussi lisible par machine (JSON-LD + Croissant).
cURL
curl "https://datazimuts.com/v1/datasets/ckan_canada/fx_rates_us" | jq '{title, rows, columns_count, license}'Python
import requests
ds = requests.get("https://datazimuts.com/v1/datasets/ckan_canada/fx_rates_us").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)Point d’accès API: https://datazimuts.com/v1/datasets/ckan_canada/fx_rates_us
Astuce : récupérez /llms.txt pour le catalogue complet lisible par machine.