Wikidata:WikiProject Companies/Numbers/Assets
Jump to navigation
Jump to search
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT DISTINCT ?item ?revenue ?unit ?revenue_USD ?date WHERE { ?item wdt:P31/wdt:P279* wd:Q4830453; p:P2403 ?statement . OPTIONAL { ?item wdt:P159 ?hq } . FILTER( ?item not in (wd:Q334122)) ?statement wikibase:rank ?rank . FILTER( ?rank != wikibase:DeprecatedRank ) . OPTIONAL { FILTER( ?rank != wikibase:PreferredRank ) . ?item p:P2403 ?statement1 . ?statement1 wikibase:rank wikibase:PreferredRank . FILTER( ?statement1 != ?statement ) . } . FILTER( !BOUND( ?statement1 ) ) . OPTIONAL { ?statement pq:P585 ?date } . { ?statement psv:P2403 [ wikibase:quantityAmount ?revenue; wikibase:quantityUnit wd:Q4917 ] . BIND( wd:Q4917 AS ?unit ) . BIND( ?revenue AS ?revenue_USD ) . } UNION { ?statement psv:P2403 [ wikibase:quantityAmount ?revenue; wikibase:quantityUnit ?unit ] . FILTER( ?unit != wd:Q4917 ) . ?unit p:P2284 ?unit_statement . ?unit_statement wikibase:rank ?unit_rank; psv:P2284 [ wikibase:quantityUnit wd:Q4917; wikibase:quantityAmount ?usd ] . FILTER( ?unit_rank != wikibase:DeprecatedRank ) . OPTIONAL { FILTER( ?unit_rank != wikibase:PreferredRank ) . ?unit p:P2284 ?unit_statement1 . ?unit_statement1 psv:P2284/wikibase:quantityUnit wd:Q4917; wikibase:rank wikibase:PreferredRank . FILTER( ?unit_statement1 != ?unit_statement ) . } . FILTER( !BOUND( ?unit_statement1 ) ) . BIND( ?revenue * ?usd AS ?revenue_USD ) . } . } ORDER BY DESC(?revenue_USD) LIMIT 20| number | company | total assets | source currency | assets in USD | country | date of assets |
|---|---|---|---|---|---|---|
| 1 | Industrial and Commercial Bank of China | 33345058000000 | renminbi | 4948645357815.28 | People's Republic of China | 2020-12-31 |
| 2 | Fannie Mae | 3960490000000 | United States dollar | 3960490000000 | United States of America | 2020-12-31 |
| 3 | JPMorgan Chase | 3743567000000 | United States dollar | 3743567000000 | United States of America | 2021-12-31 |
| 4 | Bank of America | 3180151000000 | United States dollar | 3180151000000 | United States of America | 2023-01-01 |
| 5 | Japan Post Holdings | 293162545000000 | yen | 2755727923000 1978425992121.5985 |
Japan | 2017-03-31 |
| 6 | Mitsubishi UFJ Financial Group | 292570296000000 | yen | 2750160782400 1974429162255.7368 |
Japan | 2016-03-31 |
| 7 | China Construction Bank | 18349489000000 | renminbi | 2723195549941.24 | People's Republic of China | 2015-12-31 |
| 8 | Agricultural Bank of China | 17791393000000 | renminbi | 2640370107573.88 | People's Republic of China | 2015-12-31 |
| 9 | Bank of China | 16815597000000 | renminbi | 2495554994474.52 | People's Republic of China | 2015-01-01 |
| 10 | HSBC | 2374986000000 | United States dollar | 2374986000000 | United Kingdom | 2016-12-31 |
| 11 | Freddie Mac | 2049776000000 | United States dollar | 2049776000000 | United States of America | 2017-12-31 |
| 12 | Citigroup | 1792077000000 | United States dollar | 1792077000000 | United States of America | 2016-12-31 |
| 13 | Ping An Insurance | 9527870000000 | renminbi | 1414004127549.2 | People's Republic of China | 2020-12-31 |
| 14 | Santander Group | 1340000000001 | Euro | 1362780000001.017 | Spain | 2015-01-01 |
| 15 | Deutsche Bank | 1312331000000 | Euro | 1334640627000 | Germany | 2023-12-31 |
| 16 | China State Railway Group | 8314963000000 | renminbi | 1234000044335.08 | People's Republic of China | 2019-12-31 |
| 17 | Morgan Stanley | 1190000000000 | United States dollar | 1190000000000 | United States of America | 2023-01-01 |
| 18 | CITIC Limited | 8289924000000 | Hong Kong dollar | 1069460621256.036 | Hong Kong | 2019-12-31 |
End of automatically generated list.