Summary

Top 100 Canadian Credit Unions in CCUA by asset size, reported semi-annually since Q4 2014

Charts of Largest 100 Canadian Credit Unions in CCUA

Key Features

Updated semi-annually (by end of every Q1 and Q3)
12 reports from Q4'14 to Q2'20 and ongoing consolidated in one
Covering all Canadian Credit Unions (excluding Quebec) in CCUA providing provincial info
Current and previous ranks as per the asset size for the reported quarter
Number of locations and members are given in addition to consolidated assets
Additional notes provided for mergers, acquisitions and amalgamations
Credit Unions' names revised backwardly for compatibility and data continuity

Documentation

Applications

Benchmarking based on assets, members and locations
Competitive analysis over years (rank changes, growth)
Credit Union Segmentation and Trends

Overview

This data provides the listing of the largest 100 credit unions/caisses populaires of Canadian Credit Union Association in Canada (excluding Quebec).

A Credit Union is a member-owned financial cooperative, controlled by its members and operated on the principle of people helping people, providing its members credit at competitive rates as well as other financial services.

The dataset contains semi-annually reports and a comprehensive overview of changes and shifts in the ranking of the top 100 Credit Unions in CCUA from the previous listing.

Credit Union Coverage

As per the latest report (Q2'20) , Top-100 credit unions have consolidated assets of $270.2 billion, 94.3% of the total 236 credit unions. There have been more than 200 Credit Unions have been in the Top 100 lists so far.

Metric Coverage

In this data product, you will have all the semi-annual reports from Q4'14 to Q2'20 consolidated, with current and previous ranks of the credit union for the given quarter, number of locations, total number of the members and consolidated assets.

Current Rank
Previous Rank
Total Number of Members
Total Locations
Consolidated Assets ($)

Data Collection Methodology

Data is cleansed and organized to provide a ready for analysis dataset
Both historical and current reports of the Largest 100 Credit Unions are aggregated
Names of the credit unions are revised backwardly to provide the current official name for data compatibility and continuity.
Data updates from Canadian Credit Union Association

Subscribe Now

Canadian Credit Unions: Branch and ATM Locations and Features

Dictionary

Column	Title	Data Type	Description
reported_date	Reported Date	Date	The release date of the report
reported_quarter	Reported Quarter	Text	Indicates which quarter the report covers
rank	Rank	Int	Rank of the Credit Union as per the given Quarter
credit_union	Credit Union	Text	Name of the Credit Union
province	Province	Text	Abbreviation of the Canadian Province that the Credit Union's Head Office is located
consolidated_assets	Consolidates Assets	Float	CCUA-affiliated credit union data represent consolidated assets. Given values are in CAD.
members	Members	Float	Number of members that the Credit Union has
locations	Locations	Float	Number of locations that the Credit Union has
consolidated_assets_per_member	Consolidated Assets per Member	Float	Consolidated Assets per Member
consolidated_assets_per_location	Consolidated Assets per Location	Float	Consolidated Assets per Location
previous_rank	Previous Rank	Text	Rank of the Credit Union in the previous report
growth_consolidated_assets	Growth Consolidated Assets	Float	Growth compared to the previous report in terms of consolidated assets
growth_members	Members Growth	Float	Growth compared to the previous report in terms of members
growth_locations	Locations Growth	Float	Growth compared to the previous report in terms of locations
oldest_report_flag	Oldest Report Flag	Boolean	A True/False flag, indicating if the date of the given record is the the latest available for the selected credit union
newest_reported_flag	Newest Report Flag	Boolean	A True/False flag, indicating if the date of the given record is the the newest available for the selected credit union
notes	Notes	Text	Notes about the Credit Union, such as mergers, amalgamations, etc

Sample Data

API

ALTADATA provides a powerfull API, compatible with JSON, CSV formats. You can connect, update and analyze our data products with cURL, Python, R, Ruby, Java or Javascript

Authentication

Getting an API key

You need to subscribe to an ALTADATA data product to get an API key. Once you subscribe to the data product you can find your API key on your Account Dashboard.

Auhenticating your requests

`api_key` is your access token. This token must be included on each API call with either a HTTP Header Authorization, or a query parameter api_key.

Example: https://www.altadata.io/data/api/bn_05_altab_01?api_key=YOUR_API_KEY

ALTADATA API Reference Table

Parameter Type	Parameter	Explanation	Available Values	Default
General	`size`	The number of records will be returned for each page.	`5` - `100`	`20`
General	`page`	The page number. It starts at `1` and increments one by one. Each page returns records that row count equals to the `size` parameter	`1`- `...`	`1`
General	`format`	The data return format of API call	`json` , `csv`	`json`
General	`collapse`	The aggregation format of API call	Examples are `monthly`, `yearly`, `bystate`, `bycountry`, etc. Refer to the data product documentation to see available aggregations for it.	`null`
Select	`columns`	Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause.	More detail is in the following sections.	`*`
Order	`order_by`	Column order is how you specify the content of an SQL ORDER BY clause.	More detail is in the following sections.	`null`
Lookup	vary by column name	Column lookups are how you specify the content of an SQL WHERE clause.	More detail is in the following sections.	`*`

Select

Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names. If not given, the default value is *(asterisk).

Example 1 :

Query : ?columns=C1,C2,C3 SQL Equivalent : Select C1,C2,C3 from DATA_PRODUCT

Example 2 :

Query : Not Given | ?columns= | ?columns=* SQL Equivalent : Select * from DATA_PRODUCT

Order

Column order is how you specify the content of an SQL ORDER BY clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names where each column name has an appropriate suffix (asc,desc) after _(underscore) or no suffix (means ascending).

Example :

Query : ?order_by=C1_asc,C2,C3_desc,C4_asc SQL Equivalent : Select * from DATA_PRODUCT order by C1 asc, C2, C4 desc, C4 asc

Order Type	Suffix
Ascending	`null`
Ascending	`asc`
Descending	`desc`

Lookup

Column lookups are how you specify the content of an SQL WHERE clause. They’re specifies as keyword arguments to the query string of API Call URL. Basic usage is appending _(underscore) then lookup type as a suffix to name of the column that you want to filter. The query parameter for a column is built like the format {COLUMN_NAME}_{LOOKUP_TYPE}

As a convenience when no lookup type is provided

Lookup Type	Suffix	Value Type	Example	SQL Equivalent
Equal to	`null`	String \| Numeric \| Datetime	?COLUMN=VALUE	`Select * from DATA_PRODUCT where COLUMN=VALUE`
Equal to	`eq`	String \| Numeric \| Datetime	?COLUMN_eq=VALUE	`Select * from DATA_PRODUCT where COLUMN=VALUE`
Not Equal to	`neq`	String \| Numeric \| Datetime	?COLUMN_neq=VALUE	`Select * from DATA_PRODUCT where COLUMN<>VALUE`
Greater Than	`gt`	Numeric \| Datetime	?COLUMN_gt=VALUE	`Select * from DATA_PRODUCT where COLUMN>VALUE`
Greater Than or Equal to	`gte`	Numeric \| Datetime	?COLUMN_gte=VALUE	`Select * from DATA_PRODUCT where COLUMN>=VALUE`
Less Than	`lt`	Numeric \| Datetime	?COLUMN_lt=VALUE	`Select * from DATA_PRODUCT where COLUMN,VALUE`
Less Than or Equal to	`lte`	Numeric \| Datetime	?COLUMN_lte=VALUE	`Select * from DATA_PRODUCT where COLUMN<=VALUE`
In	`in`	String	?COLUMN_in=V1,V2,V3	`Select * from DATA_PRODUCT where COLUMN in ('V1','V2','V3')`
Not In	`notin`	String	?COLUMN_notin=V1,V2,V3	`Select * from DATA_PRODUCT where COLUMN not in ('V1','V2','V3')`

Data Access Examples

cURL

curl \ -H 'Authorization: api_key' \ 'https://www.altadata.io/data/api/bn_05_altab_01'

Python (requests)

response = requests.get( 'https://www.altadata.io/data/api/bn_05_altab_01', headers={'Authorization': 'api_key'} )

Ruby (open-uri)

require 'open-uri' response = URI.open('https://www.altadata.io/data/api/bn_05_altab_01', "Authorization" => "api_key" )

Java (OkHttp)

Request request = new Request.Builder() .url("https://www.altadata.io/data/api/bn_05_altab_01") .addHeader("Authorization", "api_key") .build(); Call call = client.newCall(request); Response response = call.execute();

Javascript (axios)

axios.request({ url: 'https://www.altadata.io/data/api/bn_05_altab_01', method: 'get', headers: { 'Authorization', 'api_key'} }) .then(response => { console.log(response.data) })

R ( jsonlite )

library(jsonlite) data <- fromJSON(`https://www.altadata.io/data/api/bn_05_altab_01`)

Frequently Asked Questions

HOW DO I SUBSCRIBE TO DATA PRODUCTS ON ALTADATA?

DO YOU PROVIDE CUSTOM DATASETS UPON REQUEST?

WHAT ARE THE DIFFERENT WAYS I CAN ACCESS MY SUBSCRIPTION DATA?

HOW CAN I QUICKLY LOOK AT WHAT IS IN THE DATA THAT I SUBSCRIBED TO?

HOW CAN I JOIN ALTADATA PARTNER NETWORK? DO YOU HAVE A LIST OF REQUIREMENTS?

Largest 100 Canadian Credit Unions in CCUA