OSFI · Schema

OSFI FINDAT regulatory-return data point (fiscal-quarter return series)

Derived from the live CKAN datastore field list returned by GET https://open.canada.ca/data/en/api/3/action/datastore_search?resource_id=f3ddcfbc-a852-4dee-be3c-5b08864c9afe&limit=1 on 2026-07-25. Every column OSFI publishes is bilingual (English/French pairs) and typed `text` by the datastore, including the measure value — consumers must cast numerics themselves.

InsuranceCanadaRegulatorLife InsuranceProperty and CasualtyFinancial RegulationPrudential SupervisionOpen DataRisk DataMarket InfrastructureBankingBasel IIICapital AdequacyRegulatory ReportingPensions

Properties

Name Type Description
_id integer CKAN datastore surrogate row id; not an OSFI identifier.
Fiscal Year/Annee fiscale string
Fiscal Quarter string
Trimestre fiscal string
Id string
Total Life Insurance Companies/FIs string
Total Societes d'assurance-vie/IFFs string
Industry Group string
Groupe Sectoriel string
Return/Releve string
Return Title string
Titre du releve string
Data Point Address/Adresse de point de donnee string
Data Point Address Label string
Libelle de l'adresse du point de donnees string
FI Inactive Date/Date d'inactivite IFF string
Measure Value/Valeur de mesure string
View JSON Schema on GitHub

JSON Schema

osfi-financial-return-datapoint.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/osfi/refs/heads/main/json-schema/osfi-financial-return-datapoint.json",
  "title": "OSFI FINDAT regulatory-return data point (fiscal-quarter return series)",
  "description": "Derived from the live CKAN datastore field list returned by GET https://open.canada.ca/data/en/api/3/action/datastore_search?resource_id=f3ddcfbc-a852-4dee-be3c-5b08864c9afe&limit=1 on 2026-07-25. Every column OSFI publishes is bilingual (English/French pairs) and typed `text` by the datastore, including the measure value \u2014 consumers must cast numerics themselves.",
  "x-source": {
    "resource_id": "f3ddcfbc-a852-4dee-be3c-5b08864c9afe",
    "records": 531347,
    "probed": "2026-07-25",
    "method": "derived"
  },
  "type": "object",
  "properties": {
    "_id": {
      "type": "integer",
      "x-ckan-type": "int",
      "description": "CKAN datastore surrogate row id; not an OSFI identifier."
    },
    "Fiscal Year/Annee fiscale": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Fiscal Quarter": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Trimestre fiscal": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Id": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Total Life Insurance Companies/FIs": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Total Societes d'assurance-vie/IFFs": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Industry Group": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Groupe Sectoriel": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Return/Releve": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Return Title": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Titre du releve": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Data Point Address/Adresse de point de donnee": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Data Point Address Label": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Libelle de l'adresse du point de donnees": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "FI Inactive Date/Date d'inactivite IFF": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Measure Value/Valeur de mesure": {
      "type": "string",
      "x-ckan-type": "text"
    }
  },
  "additionalProperties": true
}