Summary Financial Data For Credit Unions

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 5hvp-6496
Name Summary Financial Data For Credit Unions
Attribution National Credit Union Call Report Database
Category Economy
Tags financial institutions, financial reporting, credit unions
Created 2014-12-01T21:10:22Z
Publication Date 2017-03-28T18:39:56Z

Description

This dataset provides annual summary financial data for Iowa state-chartered credit unions starting with year ending 12/31/2005.

Columns

| Included | Schema Type    | Field Name       | Name             | Data Type     | Render Type   |
| ======== | ============== | ================ | ================ | ============= | ============= |
| Yes      | series tag     | name             | Name             | text          | text          |
| Yes      | series tag     | insurance_number | Insurance Number | text          | number        |
| Yes      | time           | cycle_date       | Reporting Date   | calendar_date | calendar_date |
| Yes      | numeric metric | assets           | Assets           | money         | money         |
| Yes      | numeric metric | shares           | Shares           | money         | money         |
| Yes      | numeric metric | liabilities      | Liabilities      | money         | money         |
| Yes      | numeric metric | net_worth        | Net Worth        | money         | money         |
| Yes      | numeric metric | revenue          | Revenue          | money         | money         |
| Yes      | numeric metric | dividends        | Dividends        | money         | money         |
| Yes      | numeric metric | expenses         | Expenses         | money         | money         |
| Yes      | numeric metric | net_income       | Net Income       | money         | money         |

Time Field

Value = cycle_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Data Commands

series e:5hvp-6496 d:2005-12-31T00:00:00.000Z t:name=Metco t:insurance_number=60013 m:shares=14062168 m:assets=16150483 m:liabilities=99432 m:dividends=148419 m:net_worth=1988883 m:net_income=115779 m:revenue=1231217 m:expenses=967019

series e:5hvp-6496 d:2006-12-31T00:00:00.000Z t:name=Metco t:insurance_number=60013 m:shares=15382094 m:assets=17764458 m:liabilities=163659 m:dividends=234330 m:net_worth=2218705 m:net_income=229822 m:revenue=1366795 m:expenses=902643

series e:5hvp-6496 d:2007-12-31T00:00:00.000Z t:name=Metco t:insurance_number=60013 m:shares=15826539 m:assets=18505158 m:liabilities=222083 m:dividends=319584 m:net_worth=2456536 m:net_income=237831 m:revenue=1548274 m:expenses=990859

Meta Commands

metric m:assets p:long l:Assets d:"Total credit union assets as of the reporting period" t:dataTypeName=money

metric m:shares p:long l:Shares d:"Total member account and deposit balances as of the reporting date" t:dataTypeName=money

metric m:liabilities p:integer l:Liabilities d:"Total credit union liabilities as of the reporting date" t:dataTypeName=money

metric m:net_worth p:integer l:"Net Worth" d:"Total equity of the credit unions as of the reporting date" t:dataTypeName=money

metric m:revenue p:integer l:Revenue d:"Total income recorded for the reporting year" t:dataTypeName=money

metric m:dividends p:integer l:Dividends d:"Total interest paid to depositors in the reporting year" t:dataTypeName=money

metric m:expenses p:integer l:Expenses d:"Total other expenses paid in the reporting year" t:dataTypeName=money

metric m:net_income p:integer l:"Net Income" d:"Income produced in the reporting year" t:dataTypeName=money

entity e:5hvp-6496 l:"Summary Financial Data For Credit Unions" t:attribution="National Credit Union Call Report Database" t:url=https://data.iowa.gov/api/views/5hvp-6496

property e:5hvp-6496 t:meta.view v:id=5hvp-6496 v:category=Economy v:averageRating=0 v:name="Summary Financial Data For Credit Unions" v:attribution="National Credit Union Call Report Database"

property e:5hvp-6496 t:meta.view.license v:name="Public Domain"

property e:5hvp-6496 t:meta.view.owner v:id=fsuj-s3yk v:screenName="Iowa Division of Credit Unions (Commerce)" v:displayName="Iowa Division of Credit Unions (Commerce)"

property e:5hvp-6496 t:meta.view.tableauthor v:id=fsuj-s3yk v:screenName="Iowa Division of Credit Unions (Commerce)" v:roleName=editor v:displayName="Iowa Division of Credit Unions (Commerce)"

Top Records

| name  | insurance_number | cycle_date          | assets   | shares   | liabilities | net_worth | revenue | dividends | expenses | net_income | 
| ===== | ================ | =================== | ======== | ======== | =========== | ========= | ======= | ========= | ======== | ========== | 
| Metco | 60013            | 2005-12-31T00:00:00 | 16150483 | 14062168 | 99432       | 1988883   | 1231217 | 148419    | 967019   | 115779     | 
| Metco | 60013            | 2006-12-31T00:00:00 | 17764458 | 15382094 | 163659      | 2218705   | 1366795 | 234330    | 902643   | 229822     | 
| Metco | 60013            | 2007-12-31T00:00:00 | 18505158 | 15826539 | 222083      | 2456536   | 1548274 | 319584    | 990859   | 237831     | 
| Metco | 60013            | 2008-12-31T00:00:00 | 19840973 | 17184501 | 144665      | 2511807   | 1488331 | 316498    | 1116562  | 55271      | 
| Metco | 60013            | 2009-12-31T00:00:00 | 21285338 | 18511364 | 123176      | 2650798   | 1529490 | 241763    | 1085089  | 138991     | 
| Metco | 60013            | 2010-12-31T00:00:00 | 21039132 | 18092571 | 175874      | 2770687   | 1420567 | 173998    | 1126681  | 119888     | 
| Metco | 60013            | 2011-12-31T00:00:00 | 22653308 | 19346053 | 450449      | 2856806   | 1401317 | 145631    | 1169567  | 86119      | 
| Metco | 60013            | 2012-12-31T00:00:00 | 24134888 | 20975979 | 178573      | 2980336   | 1417855 | 125307    | 1169019  | 123529     | 
| Metco | 60013            | 2013-12-31T00:00:00 | 27570674 | 24326004 | 173745      | 3070925   | 1366358 | 120181    | 1155587  | 90590      | 
| Metco | 60013            | 2014-12-31T00:00:00 | 26993503 | 23672426 | 137604      | 3183473   | 1380761 | 99502     | 1168712  | 112547     |