Variable Availability Explorer

Non-missing, non-zero observation counts by variable and year (1863–1941)

Interactive Heatmap

Each cell shows the number of banks with non-missing, non-zero data for a given variable in a given year. Use the slider or play button to animate through the years.

—
0 max

Loading heatmap data...

Full Availability Table

Complete matrix of observation counts. Rows are variables; columns are years. Scroll horizontally to see all years.

Variable 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941
assets 72 507 1,511 1,640 1,637 1,625 1,617 1,614 1,766 1,917 1,976 2,004 2,087 2,087 2,080 2,053 2,047 2,089 2,131 2,269 2,500 2,664 2,714 2,851 3,049 3,139 3,290 3,540 3,676 3,773 3,780 3,753 3,712 3,676 3,610 3,585 3,594 3,870 4,221 4,603 5,042 5,414 5,319 6,139 6,546 6,852 6,976 7,169 7,300 7,396 7,487 7,540 7,613 7,589 7,632 7,725 7,816 8,088 8,149 8,238 8,238 8,072 8,085 7,911 7,784 7,635 7,408 7,038 6,372 6,016 5,164 5,479 5,392 4,832 4,839 4,745 4,750 4,741 4,687
loans 56 491 1,492 1,636 1,637 1,625 1,617 1,614 1,766 1,917 1,976 2,004 2,087 2,087 2,080 2,053 2,047 2,089 2,131 2,269 2,500 2,664 2,714 2,851 3,048 3,139 3,288 3,540 3,676 3,773 3,780 3,752 3,712 3,676 3,610 3,585 3,593 3,868 4,220 4,601 5,041 5,410 5,753 6,138 6,545 6,852 6,973 7,168 7,300 7,394 7,485 7,539 7,613 7,588 7,631 7,726 7,818 8,086 8,143 8,239 8,238 8,072 8,085 7,911 7,784 7,635 7,406 7,038 6,372 6,016 5,157 5,449 5,167 4,828 4,835 4,741 4,735 4,732 4,684
odraft 597 773 891 920 1,059 1,073 1,203 1,314 1,371 1,436 1,501 1,536 1,524 1,530 1,516 1,540 1,631 1,762 1,931 2,101 2,173 2,353 2,547 2,700 2,892 3,160 3,313 3,447 3,445 3,462 3,452 3,405 3,341 3,321 3,331 3,558 3,860 4,213 4,611 4,983
acceptances_receivable 258
bonds_circ 66 1,508 1,640 1,637 1,625 1,617 1,614 1,766 1,917 1,976 2,004 2,087 2,087 2,080 2,053 2,047 2,089 2,131 2,269 2,500 2,664 2,714 2,851 3,049 3,139 3,289 3,540 3,676 3,771 3,780 3,753 3,712 3,676 3,610 3,585 3,594 3,869 4,220 4,602 5,041 5,411
bonds_dep 377 367 190 158 196 165 157 150 144 146 145 159 127 131 133 136 141 136 141 168 202 290 265 204 190 161 155 154 159 157 169 273 353 433 450 575 717 819
bonds_hand 30 507 1,364 1,245 1,089 966 836 720 621 513 382 400 329 458 565 879 1,087 763 790 642 494 470 428 394 321 235 225 153 197 226 184 265 319 375 375 1,135 865 619 550 509 424 509
bond_premiums 592 516 496 357 321 361 526 643 696 722 803 882 952 930 807 735 699 866 1,099 1,389 1,492 1,803 2,126 2,142 2,188 2,327 2,198 2,220 2,294 2,190 2,236 2,256 2,196 2,182 2,104 1,692 2,001 2,349 2,874 3,319
securities_and_mortgages 677 793 818 844 948 1,017 1,024 1,104 1,126 1,185 1,213 1,260 1,295 1,373 1,399 1,443 1,569 1,663 1,761 1,841 1,950 2,055
securities 2 1 2 6 4 1 2,120 2,221 2,342 2,576 2,684 2,911 2,982 2,994 3,011 2,995 3,005 3,114 3,281 3,492 3,717 3,793
securities_usgov 5,756 6,139 6,544 6,852 6,976 7,167 7,300 7,396 7,486 7,447 7,427 7,346 7,520 7,705 7,778 7,946 7,959 7,939 7,940 7,782 7,716 7,514 7,377 7,232 7,015 6,601 6,083 5,778 5,041 5,431 5,028 4,728 4,737 4,636 4,669 4,650 4,649
securities_other 4,089 6,097 6,497 6,818 6,939 7,141 7,258 7,362 7,448 7,519 7,592 7,587 7,623 7,720 7,816 8,079 8,144 8,238 8,238 8,072 8,085 7,911 7,783 7,635 7,404 7,036 6,369 6,016 5,161 5,450 5,166 4,830 4,837 4,743 4,732 4,735 4,683
due_from_nb 482 1,478 1,630 1,592 1,607
due_from_ra 1,499 1,515 1,667 1,827 1,894 1,853 1,924 1,939 1,914 1,917 1,923 1,966 2,010 2,123 2,336 2,512 2,574 2,709 2,880 2,995 3,150 3,396 3,549 3,641 3,649 3,630 3,594 3,560 3,512 3,488 3,510 3,769 4,128 4,508 4,946 5,294
due_from_other_nb 1,371 1,365 1,482 1,593 1,637 2,787 2,982 3,062 3,174 3,139 3,097 3,034 2,978 2,941 2,931 2,929 3,166 3,484 3,748 4,014 4,293
due_from_other_nb_and_sb 59 1,785 1,852 1,822 1,805 1,799 1,796 1,844 1,883 1,992 2,231 2,378 2,431 2,565 2,729 2,801
due_from_sb 411 863 874 968 916 912 951 1,081 1,216 1,205 1,990 2,153 2,208 2,273 2,300 2,246 2,308 2,306 2,271 2,209 2,233 2,394 2,581 2,796 3,027 3,208
real_estate 23 385 1,153 1,315 1,279 1,310 1,311 1,313 1,462 1,617 1,706 1,744 1,842 1,865 1,875 1,861 1,871 1,905 1,925 2,048 2,243 2,408 2,456 2,596 2,774 2,866 2,929 3,181 3,323 3,421 3,436 3,425 3,388 3,364 3,278 3,263 3,252 3,473 3,803 4,156 4,559 4,926
oreo_and_mortgages 1,077 1,101 1,205 1,313 1,400 1,614 1,760 1,856 1,903 1,930 1,883 1,742 1,605 1,553 1,521 1,600
current_expenses 63 457 1,217 1,320 1,355 1,331 1,432 1,432 1,526 1,720 1,818 1,783 1,817 1,809 1,818 1,786 1,814 1,822 1,861 2,020 2,250 2,299 2,440 2,646 2,839 2,912 2,879 3,281 3,464 3,319 3,514 6
internal_stamps 2,851 2,428 1,445 372 138
exchanges 190 207 208 207 212 213 221 214 212 248 249 264 278 320 320 323 343 393 461 539 593 629 647 679 700 679 693 690 681 682 710 760 786 835 918
bills_nb 1,586 1,577 1,565 1,555 1,710 1,873 1,922 1,963 2,057 2,055 2,041 2,015 2,011 2,044 2,096 2,234 2,468 2,616 2,655 2,790 2,971 3,064 3,185 3,398 3,461 3,540 3,501 3,494 3,410 3,406 3,335 3,325 3,316 3,566 3,850 4,151 4,516 4,768
bills_sb 599 323 216
checks_and_other 1,540 1,540 1,555 1,533 1,667 1,805 1,782 1,793 1,872 1,881 1,867 1,846 1,840 1,875 1,941 2,073 2,235 2,354 2,418 2,561 2,733 2,829 2,955 3,203 3,322 3,420 3,475 3,448 3,438 3,394 3,372 3,390 3,445 3,561 3,869 4,195 4,579 4,876
currency 1,485 1,566 1,566 1,579 1,730 1,881 1,928 1,977 2,060 1,992 1,892 1,819 1,826 1,860 1,910 2,056 2,299 2,458 2,525 2,678 2,876 2,991 3,158 3,422 3,571 3,662 3,692 3,696 3,648 3,614 3,560 3,540 3,552 3,820 4,156 4,531 4,958 5,340
legal_tender 1,632 1,604 1,570 1,604 1,758 1,898 1,963 1,946 2,013 2,030 2,036 2,016 1,991 2,009 1,992 2,120 2,380 2,522 2,632 2,741 2,949 3,027 3,174 3,442 3,542 3,643 3,641 3,602 3,568 3,560 3,458 3,440 3,440 3,683 4,025 4,374 4,771 5,116
specie 1,162 1,076 1,059 1,068 1,122 1,197 1,195 1,193 1,126 1,746 1,957 2,026 2,037 2,085 2,124 2,265 2,496 2,657 2,705 2,848 3,044 3,135 3,286 3,539 3,670 3,769 3,777 3,747 3,711 3,674 3,606 3,580 3,590 3,868 4,220 4,600 5,040 5,412
cash_and_exchange 6,139 6,546 6,851 6,974 7,168 7,296 7,390 7,485 7,537 7,613 7,589 7,632 7,718 7,817 8,080 8,141 8,238 8,236 8,068 8,083
lawful_money 59 501 1,501 5,755 6,138 6,546 6,851 6,970 7,167 7,298 7,394 7,486 7,538 7,612 7,589 7,632
cash_exchange_and_reserve 7,911 7,782 7,635 7,407 7,037 6,371 6,015 5,161 5,450 5,167 4,824 4,838 4,743 4,731 4,740 4,687
us_debt 1,461 1,018 414 342 211 113 223 237 245 242 242 203 203 113 132 128 139 141 162 123 105 108 106 91 138 175 98 148 149 152 149 110 106 27 92
redemption_fund 1,962 2,050 2,823 3,013 3,118 3,240 3,480 3,625 3,705 3,749 3,718 3,689 3,651 3,587 3,559 3,574 3,634 4,185 4,547 5,000 5,360
due_from_treasurer 2,068 2,059 2,032 2,032 2,077 2,110 2,248 2,471 2,642 2,689 460 381 339 322 355 367 389 317 423 445 428 440 573 399 444 469 455 479 516
defalcation 3 3 4 1 1 2 1 1 1 1 1 1 3 1 2
suspense_assets 4 1 4 6 4 1 1 1 15 11 20 27 30 14 8 1 1 12 91
trade_dollars 725 867 45 43
frb_reserve 7,663 7,776 8,040 8,101 8,216 8,215 8,053 8,067
other_assets 23 235 424 447 5 2 1 3 3 2 5 3 8 6 7 6 3 1 1 17 14 1 89 262 7,659 7,669 7,861 8,063 8,142 8,145 7,971 7,947 7,683 7,598 7,346 7,403 7,035 6,366 6,015 5,161 5,447 5,162 4,827 4,829 4,738 4,743 4,728 4,671
capital 66 507 1,511 1,640 1,637 1,625 1,617 1,614 1,766 1,917 1,976 2,004 2,087 2,087 2,080 2,053 2,047 2,089 2,131 2,269 2,500 2,664 2,714 2,851 3,049 3,139 3,290 3,540 3,676 3,773 3,780 3,753 3,712 3,676 3,610 3,585 3,594 3,870 4,221 4,603 5,042 5,414 5,756 6,139 6,546 6,852 6,976 7,169 7,300 7,396 7,487 7,540 7,613 7,589 7,632 7,725 7,819 8,086 8,148 8,240 8,238 8,072 8,085 7,911 7,784 7,635 7,408 7,038 6,372 6,016 5,161 5,450 5,166 4,832 4,839 4,743 4,748 4,741 4,686
capital_not_certif 75 35 30 31 8 17 7 12 8 12 76 53 48 42 25
surplus 158 1,008 1,562 1,603 1,585 1,583 1,583 1,654 1,796 1,891 1,937 2,003 2,035 2,030 1,991 1,993 2,024 2,067 2,119 2,305 2,487 2,588 2,703 2,849 3,000 3,110 3,293 3,484 3,603 3,603 3,600 3,571 3,544 3,476 3,458 3,455 3,533 3,826 4,173 4,529 4,902 6,456 6,652 6,892 7,069 7,218 7,347 7,396 7,468 7,459 7,486 7,242 6,874 6,194 5,796 4,954 5,227 4,946 4,651 4,674 4,592 4,634 4,646 4,620
undivided_profits 49 485 1,437 1,597 1,621 1,612 1,611 1,609 1,759 1,910 1,973 1,996 2,074 2,076 2,064 2,043 2,044 2,084 2,127 2,267 2,495 2,657 2,712 2,846 3,043 3,136 3,283 3,532 3,665 3,762 3,775 3,691 3,654 3,613 3,573 3,538 3,546 3,769 4,150 4,516 4,936 5,292 6,667 6,714 6,916 7,045 7,151 7,276 7,305 7,318 7,366 7,390 7,269 6,901 6,233 5,829 5,014 5,291 5,139 4,821 4,815 4,732 4,741 4,732 4,677
surplus_and_undivided_profits 5,658 6,057 6,480 7,710 7,808 8,070 8,130 8,207 8,187 8,021 8,025 7,878 7,746 7,623
notes_nb 478 1,229 1,616 1,622 1,610 1,602 1,605 1,760 1,905 1,971 1,998 2,070 2,081 2,076 2,046 2,039 2,082 2,119 2,248 2,471 2,644 2,685 2,826 3,024 3,120 3,248 3,495 3,647 3,746 3,767 3,735 3,695 3,663 3,590 3,563 3,571 3,670 4,191 4,551 5,008 5,378 5,706 6,106 6,498 6,817 6,944 7,156 7,284 7,376 7,473 7,438 7,424 7,333 7,254 7,259 7,252 7,316 7,351 7,326 7,302 7,130 6,780 6,540 6,381 6,173 5,996 5,687 5,165 5,123 4,413 4,591
notes_sb 680 702 693 608 541 491 452 372 274 212 168 148 122 106 91 81 72 65 57 54 40 37 33 28 27 25 24 46 26 23 23 21 20 17 17 16 16 13 15 43
deposits 56 492 1,491 1,637 1,637 1,625 1,617 1,612 1,762 1,914 1,975 2,003 2,087 2,086 2,080 2,052 2,047 2,089 2,131 2,269 2,500 2,663 2,714 2,850 3,048 3,139 3,290 3,539 3,674 3,772 3,780 3,750 3,712 3,674 3,607 3,584 3,593 3,868 4,221 4,603 5,040 5,414 5,756 7,404 7,036 6,369 6,013 5,160 5,450 5,168 4,832 4,838 4,745 4,746 4,739 4,685
us_deposits 3 348 383 375 362 167 147 190 158 155 147 141 142 143 156 125 129 130 134 138 134 139 165 200 287 261 201 185 154 149 152 151 155 165 258 348 420 439 573 714 830 1,067 1,260 1,431 1,397 1,398 1,685 3,772 3,942 3,973
usdo_deposits 86 119 118 105 100 111 120 122 112 108 106 102 97 98 101 98 103 99 97 101 108 120 135 134 141 130 128 122 121 122 115 120 125 139 155 152 170 187 191
individual_deposits 6,136 6,546 6,852 6,970 7,159 7,297 7,394 7,483 7,539
demand_deposits 7,613 7,580 7,625 7,716 7,812 8,079 8,138 8,229 8,229 8,067 8,073 7,911 7,781 7,633
time_deposits 5,609 5,949 6,683 6,824 6,984 7,366 7,484 7,651 7,723 7,592 7,609 7,488 7,391 7,287
due_to_nb 227 979 1,110 1,147 1,129 1,186 1,178 1,213 1,361 1,383 1,412 1,439 1,429 1,427 1,363 1,396 1,404 1,424 1,622 1,750 1,865 1,866 2,007 2,158 2,219 2,250 2,483 2,586 2,571 2,568 2,499 2,490 2,484 2,363 2,401 2,371
due_to_other_nb 2,385 2,496 2,625 2,844 2,882
due_to_ra 423 501 602 621 618
due_to_sb 278 669 726 725 759 830 860 871 1,044 1,063 1,020 1,006 986 989 935 988 978 1,008 1,086 1,191 1,270 1,284 1,456 1,582 1,632 1,692 1,926 1,993 2,005 2,030 2,021 2,047 2,016 1,984 2,046 2,069 1,877 1,926 1,996 2,154 2,255
due_to_tc_and_sb 869 1,001 1,110 1,247 1,296
due_to_banks 43 7,327 7,454 7,457 7,325 7,349 7,183 7,087 6,968
due_to_banks_and_other_liabs 4,536 4,884 5,142 5,218 5,444 5,649 5,674 5,763 5,943 5,891 5,837 5,814 6,496 7,611 7,927
bills_payable 2 57 71 91 147 137 143 165 175 168 123 111 104 104 139 131 158 80 71 105 137 167 223 289 223 831 443 573 650 346 338 223 280 380 488 759 790 2,684 2,369 2,987 2,655 875 153 87 55 175 125 62 57 52
rediscounts 95 121 130 180 170 175 192 214 202 152 103 91 88 178 251 428 336 396 523 554 557 641 738 488 910 457 517 589 270 247 153 199 258 305 408 365
certified_checks 49 48 44 43 44 717 777 854 250 254 264 266 262 259 260 274 289 284 305 305
suspense_liab 1 1 1 6 9 7 8 6 3 11 19 16 13 17 17 57 57 2 8
unpaid_dividends 104 776 906 932 970 1,020 1,023 1,053 1,129 1,128 1,134 1,130 1,160 1,221 1,203 1,249 1,262 1,282 1,332 1,369 1,411 1,407 1,472 1,462 1,529 1,587 1,553 1,532 1,538 1,574 1,583 1,640 1,664 1,631 1,671 1,746 1,789
us_bond_account 1 1 2 1 1 1 1 1 4 70 3 116
other_liabs 7 46 1 10 22 172 82 208 215 227 255 262 301 170 327 483 420 5,257 4,579 4,408 5,385 3,193 3,085 2,782 3,312 2,801 3,230 3,091 3,045 2,976 2,791 2,876 3,125 3,171

Source Documentation

The following documents describe the original balance sheet layouts and the mapping between printed labels and dataset variable names.

Balance Sheet Layouts

Variable Label Mappings (1867–1904)