NyFrbAsDataframe
Up to date remote economic data access for ruby, using Polars dataframes.
This package will fetch economic and financial information from the Federal Reserve Bank of NY (specifically several time series from the FRB NY's Household Credit and Debt report), and return the results as a Polars dataframe.
Installation
Add this line to your application's Gemfile:
gem 'ny_frb_as_dataframe'
And then execute:
$ bundle install
Or install it yourself as:
$ gem install ny_frb_as_dataframe
Usage
3.1.2 :001 > NyFrbAsDataframe::Hhdc.new.fetch # Fetches all data
=>
shape: (102, 103)
┌────────────┬───────────────────┬────────────────────┬────────────────────────┬───┬────────────────────────┬────────────────────────┬────────────────────────┬───────────────────────┐
│ Timestamps ┆ Mort Debt Balance ┆ HELOC Debt Balance ┆ Car Loan Debt Balance ┆ … ┆ New Bankruptcies for ┆ New Bankruptcies for ┆ New Bankruptcies for ┆ New Bankruptcies for │
│ --- ┆ ($T) ┆ ($T) ┆ ($T) ┆ ┆ 40-49 yo … ┆ 50-59 yo … ┆ 60-69 yo … ┆ 70+ yo (0… │
│ str ┆ --- ┆ --- ┆ --- ┆ ┆ --- ┆ --- ┆ --- ┆ --- │
│ ┆ f64 ┆ f64 ┆ f64 ┆ ┆ f64 ┆ f64 ┆ f64 ┆ f64 │
╞════════════╪═══════════════════╪════════════════════╪════════════════════════╪═══╪════════════════════════╪════════════════════════╪════════════════════════╪═══════════════════════╡
│ 1999-01-01 ┆ null ┆ null ┆ null ┆ … ┆ null ┆ null ┆ null ┆ null │
│ 1999-04-01 ┆ null ┆ null ┆ null ┆ … ┆ null ┆ null ┆ null ┆ null │
│ 1999-07-01 ┆ null ┆ null ┆ null ┆ … ┆ null ┆ null ┆ null ┆ null │
│ 1999-10-01 ┆ null ┆ null ┆ null ┆ … ┆ null ┆ null ┆ null ┆ null │
│ 2000-01-01 ┆ null ┆ null ┆ null ┆ … ┆ 108.38 ┆ 63.04 ┆ 25.2 ┆ 17.84 │
│ 2000-04-01 ┆ null ┆ null ┆ null ┆ … ┆ 135.18 ┆ 79.94 ┆ 30.04 ┆ 19.56 │
│ 2000-07-01 ┆ null ┆ null ┆ null ┆ … ┆ 111.94 ┆ 66.2 ┆ 25.42 ┆ 16.16 │
│ 2000-10-01 ┆ null ┆ null ┆ null ┆ … ┆ 115.6 ┆ 66.34 ┆ 24.94 ┆ 15.56 │
│ 2001-01-01 ┆ null ┆ null ┆ null ┆ … ┆ 118.3 ┆ 70.46 ┆ 27.44 ┆ 18.04 │
│ 2001-04-01 ┆ null ┆ null ┆ null ┆ … ┆ 168.38 ┆ 104.18 ┆ 40.98 ┆ 25.0 │
│ 2001-07-01 ┆ null ┆ null ┆ null ┆ … ┆ 129.8 ┆ 77.82 ┆ 31.56 ┆ 20.02 │
│ 2001-10-01 ┆ null ┆ null ┆ null ┆ … ┆ 139.88 ┆ 82.96 ┆ 31.68 ┆ 21.02 │
│ 2002-01-01 ┆ null ┆ null ┆ null ┆ … ┆ 187.78 ┆ 123.64 ┆ 50.78 ┆ 29.8 │
│ 2002-04-01 ┆ null ┆ null ┆ null ┆ … ┆ 141.18 ┆ 89.02 ┆ 33.86 ┆ 18.96 │
│ 2002-07-01 ┆ null ┆ null ┆ null ┆ … ┆ 140.06 ┆ 88.94 ┆ 34.24 ┆ 18.08 │
│ 2002-10-01 ┆ null ┆ null ┆ null ┆ … ┆ 143.2 ┆ 88.26 ┆ 36.88 ┆ 18.76 │
│ 2003-01-01 ┆ 4.942 ┆ 0.242 ┆ 0.641 ┆ … ┆ 165.44 ┆ 108.78 ┆ 47.3 ┆ 28.52 │
│ 2003-04-01 ┆ 5.08 ┆ 0.26 ┆ 0.622 ┆ … ┆ 166.3 ┆ 106.36 ┆ 43.32 ┆ 24.1 │
│ 2003-07-01 ┆ 5.183 ┆ 0.269 ┆ 0.684 ┆ … ┆ 144.2 ┆ 90.44 ┆ 38.48 ┆ 22.24 │
│ 2003-10-01 ┆ 5.66 ┆ 0.302 ┆ 0.704 ┆ … ┆ 135.0 ┆ 89.42 ┆ 37.56 ┆ 20.26 │
│ 2004-01-01 ┆ 5.84 ┆ 0.328 ┆ 0.72 ┆ … ┆ 143.6 ┆ 93.12 ┆ 40.68 ┆ 22.66 │
│ 2004-04-01 ┆ 5.967 ┆ 0.367 ┆ 0.743 ┆ … ┆ 153.58 ┆ 99.18 ┆ 44.3 ┆ 22.1 │
│ 2004-07-01 ┆ 6.21 ┆ 0.426 ┆ 0.751 ┆ … ┆ 135.56 ┆ 92.74 ┆ 37.88 ┆ 21.58 │
│ 2004-10-01 ┆ 6.36 ┆ 0.468 ┆ 0.728 ┆ … ┆ 153.16 ┆ 102.98 ┆ 41.78 ┆ 22.5 │
│ 2005-01-01 ┆ 6.512 ┆ 0.502 ┆ 0.725 ┆ … ┆ 125.52 ┆ 87.14 ┆ 36.92 ┆ 21.4 │
│ 2005-04-01 ┆ 6.696 ┆ 0.528 ┆ 0.774 ┆ … ┆ 178.98 ┆ 127.16 ┆ 55.3 ┆ 29.22 │
│ 2005-07-01 ┆ 6.906 ┆ 0.541 ┆ 0.83 ┆ … ┆ 176.7 ┆ 126.84 ┆ 54.7 ┆ 30.64 │
│ 2005-10-01 ┆ 7.102 ┆ 0.565 ┆ 0.792 ┆ … ┆ 257.14 ┆ 173.72 ┆ 68.4 ┆ 33.26 │
│ 2006-01-01 ┆ 7.436 ┆ 0.582 ┆ 0.788 ┆ … ┆ 52.76 ┆ 37.24 ┆ 16.42 ┆ 10.14 │
│ 2006-04-01 ┆ 7.76 ┆ 0.59 ┆ 0.796 ┆ … ┆ 69.0 ┆ 49.48 ┆ 23.22 ┆ 13.54 │
│ 2006-07-01 ┆ 8.045 ┆ 0.603 ┆ 0.821 ┆ … ┆ 75.58 ┆ 56.16 ┆ 24.48 ┆ 13.28 │
│ 2006-10-01 ┆ 8.234 ┆ 0.604 ┆ 0.821 ┆ … ┆ 75.96 ┆ 53.72 ┆ 25.04 ┆ 14.46 │
│ 2007-01-01 ┆ 8.422 ┆ 0.605 ┆ 0.794 ┆ … ┆ 73.02 ┆ 51.82 ┆ 24.66 ┆ 12.14 │
│ 2007-04-01 ┆ 8.706 ┆ 0.619 ┆ 0.807 ┆ … ┆ 78.72 ┆ 60.14 ┆ 25.86 ┆ 13.74 │
│ 2007-07-01 ┆ 8.925 ┆ 0.631 ┆ 0.818 ┆ … ┆ 90.12 ┆ 64.7 ┆ 29.2 ┆ 14.26 │
│ 2007-10-01 ┆ 9.101 ┆ 0.647 ┆ 0.815 ┆ … ┆ 99.94 ┆ 72.18 ┆ 31.98 ┆ 15.38 │
│ 2008-01-01 ┆ 9.234 ┆ 0.663 ┆ 0.808 ┆ … ┆ 92.32 ┆ 66.94 ┆ 31.4 ┆ 15.2 │
│ 2008-04-01 ┆ 9.273 ┆ 0.679 ┆ 0.81 ┆ … ┆ 109.68 ┆ 79.1 ┆ 37.22 ┆ 16.8 │
│ 2008-07-01 ┆ 9.294 ┆ 0.692 ┆ 0.809 ┆ … ┆ 115.04 ┆ 83.9 ┆ 38.44 ┆ 16.36 │
│ 2008-10-01 ┆ 9.257 ┆ 0.705 ┆ 0.791 ┆ … ┆ 121.56 ┆ 91.02 ┆ 43.52 ┆ 19.3 │
│ 2009-01-01 ┆ 9.135 ┆ 0.714 ┆ 0.766 ┆ … ┆ 115.06 ┆ 89.94 ┆ 46.76 ┆ 19.96 │
│ 2009-04-01 ┆ 9.063 ┆ 0.713 ┆ 0.743 ┆ … ┆ 151.9 ┆ 113.08 ┆ 53.72 ┆ 22.94 │
│ 2009-07-01 ┆ 8.944 ┆ 0.708 ┆ 0.739 ┆ … ┆ 150.84 ┆ 115.84 ┆ 56.44 ┆ 22.8 │
│ 2009-10-01 ┆ 8.843 ┆ 0.7064 ┆ 0.7219 ┆ … ┆ 141.88 ┆ 110.3 ┆ 52.66 ┆ 20.72 │
│ 2010-01-01 ┆ 8.834 ┆ 0.6951 ┆ 0.7047 ┆ … ┆ 134.62 ┆ 107.18 ┆ 54.62 ┆ 22.56 │
│ 2010-04-01 ┆ 8.703 ┆ 0.6826 ┆ 0.7022 ┆ … ┆ 181.98 ┆ 144.74 ┆ 71.06 ┆ 29.56 │
│ 2010-07-01 ┆ 8.609 ┆ 0.6734 ┆ 0.71 ┆ … ┆ 153.62 ┆ 123.42 ┆ 62.66 ┆ 24.62 │
│ 2010-10-01 ┆ 8.452 ┆ 0.6678 ┆ 0.711 ┆ … ┆ 149.36 ┆ 116.0 ┆ 57.48 ┆ 23.6 │
│ 2011-01-01 ┆ 8.544 ┆ 0.6405 ┆ 0.7056 ┆ … ┆ 126.34 ┆ 101.66 ┆ 56.36 ┆ 23.16 │
│ 2011-04-01 ┆ 8.516 ┆ 0.6245 ┆ 0.713 ┆ … ┆ 142.22 ┆ 110.26 ┆ 56.06 ┆ 22.96 │
│ 2011-07-01 ┆ 8.402 ┆ 0.6387 ┆ 0.7304 ┆ … ┆ 124.38 ┆ 101.38 ┆ 50.7 ┆ 20.74 │
│ 2011-10-01 ┆ 8.268 ┆ 0.6271 ┆ 0.7341 ┆ … ┆ 129.6 ┆ 100.98 ┆ 50.18 ┆ 21.32 │
│ 2012-01-01 ┆ 8.187 ┆ 0.6118 ┆ 0.7365 ┆ … ┆ 109.8 ┆ 89.98 ┆ 46.86 ┆ 20.46 │
│ 2012-04-01 ┆ 8.147 ┆ 0.589 ┆ 0.75 ┆ … ┆ 115.9 ┆ 97.26 ┆ 47.18 ┆ 20.76 │
│ 2012-07-01 ┆ 8.028 ┆ 0.573 ┆ 0.768 ┆ … ┆ 101.54 ┆ 84.32 ┆ 43.78 ┆ 18.42 │
│ 2012-10-01 ┆ 8.033 ┆ 0.563 ┆ 0.783 ┆ … ┆ 98.58 ┆ 81.44 ┆ 41.32 ┆ 16.3 │
│ 2013-01-01 ┆ 7.932 ┆ 0.552 ┆ 0.794 ┆ … ┆ 88.8 ┆ 75.06 ┆ 40.26 ┆ 17.58 │
│ 2013-04-01 ┆ 7.841 ┆ 0.54 ┆ 0.814 ┆ … ┆ 108.58 ┆ 94.28 ┆ 48.34 ┆ 21.4 │
│ 2013-07-01 ┆ 7.897 ┆ 0.535 ┆ 0.845 ┆ … ┆ 102.08 ┆ 87.72 ┆ 46.56 ┆ 20.52 │
│ 2013-10-01 ┆ 8.049 ┆ 0.529 ┆ 0.863 ┆ … ┆ 95.44 ┆ 82.88 ┆ 41.68 ┆ 19.32 │
│ 2014-01-01 ┆ 8.165 ┆ 0.526 ┆ 0.875 ┆ … ┆ 74.66 ┆ 67.54 ┆ 37.04 ┆ 16.32 │
│ 2014-04-01 ┆ 8.096 ┆ 0.521 ┆ 0.905 ┆ … ┆ 88.74 ┆ 76.62 ┆ 39.94 ┆ 17.54 │
│ 2014-07-01 ┆ 8.131 ┆ 0.512 ┆ 0.934 ┆ … ┆ 74.48 ┆ 63.14 ┆ 34.98 ┆ 15.54 │
│ 2014-10-01 ┆ 8.17 ┆ 0.51 ┆ 0.955 ┆ … ┆ 76.98 ┆ 64.14 ┆ 35.84 ┆ 15.3 │
│ 2015-01-01 ┆ 8.171 ┆ 0.51 ┆ 0.968 ┆ … ┆ 70.1 ┆ 63.48 ┆ 35.98 ┆ 16.7 │
│ 2015-04-01 ┆ 8.116 ┆ 0.499 ┆ 1.006 ┆ … ┆ 72.94 ┆ 62.82 ┆ 35.04 ┆ 16.12 │
│ 2015-07-01 ┆ 8.26 ┆ 0.492 ┆ 1.045 ┆ … ┆ 60.52 ┆ 53.82 ┆ 30.06 ┆ 13.68 │
│ 2015-10-01 ┆ 8.249 ┆ 0.487 ┆ 1.064 ┆ … ┆ 56.66 ┆ 51.82 ┆ 28.06 ┆ 13.7 │
│ 2016-01-01 ┆ 8.369 ┆ 0.485 ┆ 1.071 ┆ … ┆ 54.02 ┆ 50.38 ┆ 28.08 ┆ 13.4 │
│ 2016-04-01 ┆ 8.362 ┆ 0.478 ┆ 1.103 ┆ … ┆ 58.4 ┆ 51.5 ┆ 30.74 ┆ 15.32 │
│ 2016-07-01 ┆ 8.35 ┆ 0.472 ┆ 1.135 ┆ … ┆ 56.24 ┆ 48.74 ┆ 28.8 ┆ 13.98 │
│ 2016-10-01 ┆ 8.48 ┆ 0.473 ┆ 1.157 ┆ … ┆ 53.78 ┆ 48.26 ┆ 27.24 ┆ 13.46 │
│ 2017-01-01 ┆ 8.627 ┆ 0.456 ┆ 1.167 ┆ … ┆ 53.64 ┆ 48.88 ┆ 29.96 ┆ 14.92 │
│ 2017-04-01 ┆ 8.691 ┆ 0.452 ┆ 1.19 ┆ … ┆ 59.96 ┆ 50.06 ┆ 30.78 ┆ 15.8 │
│ 2017-07-01 ┆ 8.743 ┆ 0.448 ┆ 1.213 ┆ … ┆ 54.44 ┆ 49.12 ┆ 28.04 ┆ 15.96 │
│ 2017-10-01 ┆ 8.882 ┆ 0.444 ┆ 1.221 ┆ … ┆ 51.74 ┆ 44.52 ┆ 29.44 ┆ 15.36 │
│ 2018-01-01 ┆ 8.939 ┆ 0.436 ┆ 1.229 ┆ … ┆ 50.26 ┆ 45.08 ┆ 27.0 ┆ 15.3 │
│ 2018-04-01 ┆ 8.999 ┆ 0.432 ┆ 1.238 ┆ … ┆ 58.82 ┆ 51.58 ┆ 32.12 ┆ 17.66 │
│ 2018-07-01 ┆ 9.14 ┆ 0.422 ┆ 1.265 ┆ … ┆ 54.26 ┆ 49.26 ┆ 31.66 ┆ 17.36 │
│ 2018-10-01 ┆ 9.124 ┆ 0.412 ┆ 1.274 ┆ … ┆ 51.24 ┆ 45.78 ┆ 26.62 ┆ 14.78 │
│ 2019-01-01 ┆ 9.244 ┆ 0.406 ┆ 1.28 ┆ … ┆ 48.74 ┆ 45.7 ┆ 28.46 ┆ 16.68 │
│ 2019-04-01 ┆ 9.406 ┆ 0.399 ┆ 1.297 ┆ … ┆ 59.26 ┆ 55.22 ┆ 31.54 ┆ 19.04 │
│ 2019-07-01 ┆ 9.437 ┆ 0.396 ┆ 1.315 ┆ … ┆ 47.52 ┆ 42.24 ┆ 25.66 ┆ 14.78 │
│ 2019-10-01 ┆ 9.557 ┆ 0.39 ┆ 1.331 ┆ … ┆ 52.28 ┆ 46.26 ┆ 28.26 ┆ 16.02 │
│ 2020-01-01 ┆ 9.713 ┆ 0.386 ┆ 1.346 ┆ … ┆ 48.28 ┆ 43.42 ┆ 27.82 ┆ 16.42 │
│ 2020-04-01 ┆ 9.776 ┆ 0.375 ┆ 1.343 ┆ … ┆ 33.38 ┆ 30.42 ┆ 19.54 ┆ 12.42 │
│ 2020-07-01 ┆ 9.861 ┆ 0.362 ┆ 1.36 ┆ … ┆ 33.1 ┆ 29.62 ┆ 19.02 ┆ 11.58 │
│ 2020-10-01 ┆ 10.043 ┆ 0.349 ┆ 1.374 ┆ … ┆ 29.8 ┆ 28.1 ┆ 17.38 ┆ 9.52 │
│ 2021-01-01 ┆ 10.16 ┆ 0.335 ┆ 1.382 ┆ … ┆ 27.64 ┆ 26.86 ┆ 16.94 ┆ 9.58 │
│ 2021-04-01 ┆ 10.442 ┆ 0.322 ┆ 1.415 ┆ … ┆ 29.26 ┆ 27.84 ┆ 17.52 ┆ 9.72 │
│ 2021-07-01 ┆ 10.672 ┆ 0.317 ┆ 1.443 ┆ … ┆ 24.68 ┆ 22.56 ┆ 14.94 ┆ 8.72 │
│ 2021-10-01 ┆ 10.93 ┆ 0.318 ┆ 1.458 ┆ … ┆ 22.28 ┆ 21.26 ┆ 15.72 ┆ 7.96 │
│ 2022-01-01 ┆ 11.18 ┆ 0.317 ┆ 1.469 ┆ … ┆ 21.98 ┆ 21.7 ┆ 14.5 ┆ 8.3 │
│ 2022-04-01 ┆ 11.387 ┆ 0.319 ┆ 1.502 ┆ … ┆ 22.02 ┆ 21.96 ┆ 14.62 ┆ 8.46 │
│ 2022-07-01 ┆ 11.669 ┆ 0.322 ┆ 1.524 ┆ … ┆ 24.62 ┆ 22.38 ┆ 16.18 ┆ 8.18 │
│ 2022-10-01 ┆ 11.923 ┆ 0.336 ┆ 1.552 ┆ … ┆ 24.58 ┆ 22.52 ┆ 14.6 ┆ 8.08 │
│ 2023-01-01 ┆ 12.044 ┆ 0.339 ┆ 1.562 ┆ … ┆ 24.06 ┆ 24.92 ┆ 15.44 ┆ 9.4 │
│ 2023-04-01 ┆ 12.014 ┆ 0.34 ┆ 1.582 ┆ … ┆ 28.5 ┆ 26.1 ┆ 15.74 ┆ 9.98 │
│ 2023-07-01 ┆ 12.14 ┆ 0.349 ┆ 1.595 ┆ … ┆ 28.54 ┆ 26.86 ┆ 16.34 ┆ 9.5 │
│ 2023-10-01 ┆ 12.252 ┆ 0.36 ┆ 1.607 ┆ … ┆ 28.44 ┆ 25.62 ┆ 16.68 ┆ 9.26 │
│ 2024-01-01 ┆ 12.442 ┆ 0.376 ┆ 1.616 ┆ … ┆ 30.2 ┆ 28.66 ┆ 18.3 ┆ 9.88 │
│ 2024-04-01 ┆ 12.519 ┆ 0.38 ┆ 1.626 ┆ … ┆ 34.26 ┆ 31.0 ┆ 18.92 ┆ 11.42 │
└────────────┴───────────────────┴────────────────────┴────────────────────────┴───┴────────────────────────┴────────────────────────┴────────────────────────┴───────────────────────┘
3.1.2 :002 > NyFrbAsDataframe::Hhdc.new('Mort Debt Balance ($T)').fetch
=>
shape: (102, 2)
┌────────────┬────────────────────────┐
│ Timestamps ┆ Mort Debt Balance ($T) │
│ --- ┆ --- │
│ str ┆ f64 │
╞════════════╪════════════════════════╡
│ 1999-01-01 ┆ null │
│ 1999-04-01 ┆ null │
│ 1999-07-01 ┆ null │
│ 1999-10-01 ┆ null │
│ 2000-01-01 ┆ null │
│ 2000-04-01 ┆ null │
│ 2000-07-01 ┆ null │
│ 2000-10-01 ┆ null │
│ 2001-01-01 ┆ null │
│ 2001-04-01 ┆ null │
│ 2001-07-01 ┆ null │
│ 2001-10-01 ┆ null │
│ 2002-01-01 ┆ null │
│ 2002-04-01 ┆ null │
│ 2002-07-01 ┆ null │
│ 2002-10-01 ┆ null │
│ 2003-01-01 ┆ 4.942 │
│ 2003-04-01 ┆ 5.08 │
│ 2003-07-01 ┆ 5.183 │
│ 2003-10-01 ┆ 5.66 │
│ 2004-01-01 ┆ 5.84 │
│ 2004-04-01 ┆ 5.967 │
│ 2004-07-01 ┆ 6.21 │
│ 2004-10-01 ┆ 6.36 │
│ 2005-01-01 ┆ 6.512 │
│ 2005-04-01 ┆ 6.696 │
│ 2005-07-01 ┆ 6.906 │
│ 2005-10-01 ┆ 7.102 │
│ 2006-01-01 ┆ 7.436 │
│ 2006-04-01 ┆ 7.76 │
│ 2006-07-01 ┆ 8.045 │
│ 2006-10-01 ┆ 8.234 │
│ 2007-01-01 ┆ 8.422 │
│ 2007-04-01 ┆ 8.706 │
│ 2007-07-01 ┆ 8.925 │
│ 2007-10-01 ┆ 9.101 │
│ 2008-01-01 ┆ 9.234 │
│ 2008-04-01 ┆ 9.273 │
│ 2008-07-01 ┆ 9.294 │
│ 2008-10-01 ┆ 9.257 │
│ 2009-01-01 ┆ 9.135 │
│ 2009-04-01 ┆ 9.063 │
│ 2009-07-01 ┆ 8.944 │
│ 2009-10-01 ┆ 8.843 │
│ 2010-01-01 ┆ 8.834 │
│ 2010-04-01 ┆ 8.703 │
│ 2010-07-01 ┆ 8.609 │
│ 2010-10-01 ┆ 8.452 │
│ 2011-01-01 ┆ 8.544 │
│ 2011-04-01 ┆ 8.516 │
│ 2011-07-01 ┆ 8.402 │
│ 2011-10-01 ┆ 8.268 │
│ 2012-01-01 ┆ 8.187 │
│ 2012-04-01 ┆ 8.147 │
│ 2012-07-01 ┆ 8.028 │
│ 2012-10-01 ┆ 8.033 │
│ 2013-01-01 ┆ 7.932 │
│ 2013-04-01 ┆ 7.841 │
│ 2013-07-01 ┆ 7.897 │
│ 2013-10-01 ┆ 8.049 │
│ 2014-01-01 ┆ 8.165 │
│ 2014-04-01 ┆ 8.096 │
│ 2014-07-01 ┆ 8.131 │
│ 2014-10-01 ┆ 8.17 │
│ 2015-01-01 ┆ 8.171 │
│ 2015-04-01 ┆ 8.116 │
│ 2015-07-01 ┆ 8.26 │
│ 2015-10-01 ┆ 8.249 │
│ 2016-01-01 ┆ 8.369 │
│ 2016-04-01 ┆ 8.362 │
│ 2016-07-01 ┆ 8.35 │
│ 2016-10-01 ┆ 8.48 │
│ 2017-01-01 ┆ 8.627 │
│ 2017-04-01 ┆ 8.691 │
│ 2017-07-01 ┆ 8.743 │
│ 2017-10-01 ┆ 8.882 │
│ 2018-01-01 ┆ 8.939 │
│ 2018-04-01 ┆ 8.999 │
│ 2018-07-01 ┆ 9.14 │
│ 2018-10-01 ┆ 9.124 │
│ 2019-01-01 ┆ 9.244 │
│ 2019-04-01 ┆ 9.406 │
│ 2019-07-01 ┆ 9.437 │
│ 2019-10-01 ┆ 9.557 │
│ 2020-01-01 ┆ 9.713 │
│ 2020-04-01 ┆ 9.776 │
│ 2020-07-01 ┆ 9.861 │
│ 2020-10-01 ┆ 10.043 │
│ 2021-01-01 ┆ 10.16 │
│ 2021-04-01 ┆ 10.442 │
│ 2021-07-01 ┆ 10.672 │
│ 2021-10-01 ┆ 10.93 │
│ 2022-01-01 ┆ 11.18 │
│ 2022-04-01 ┆ 11.387 │
│ 2022-07-01 ┆ 11.669 │
│ 2022-10-01 ┆ 11.923 │
│ 2023-01-01 ┆ 12.044 │
│ 2023-04-01 ┆ 12.014 │
│ 2023-07-01 ┆ 12.14 │
│ 2023-10-01 ┆ 12.252 │
│ 2024-01-01 ┆ 12.442 │
│ 2024-04-01 ┆ 12.519 │
└────────────┴────────────────────────┘
The attributes that can be queried at this time are
- "Mort Debt Balance ($T)"
- "HELOC Debt Balance ($T)"
- "Car Loan Debt Balance ($T)"
- "CC Debt Balance ($T)"
- "Student Debt Balance ($T)"
- "Other Debt Balance ($T)"
- "Total Debt Balance ($T)"
- "Num Car Loan Accts (M)"
- "Num CC Accts (M)"
- "Num Mort Accts (M)"
- "Num HELOC Accts (M)"
- "Num Credit Inquiries and New Accts"
- "Num New Credit Accts Closed in 12 mo"
- "Num New Credit Accts Open after 12 mo"
- "New Mort w Riskscore <620 ($B)"
- "New Mort w Riskscore 620-659 ($B)"
- "New Mort w Riskscore 660-719 ($B)"
- "New Mort w Riskscore 720-759 ($B)"
- "New Mort w Riskscore 760+ ($B)"
- "New Mort ($B)"
- "Median Riskscore for New Mort"
- "Bottom 25%ile Riskscore for New Mort"
- "Bottom 10%ile Riskscore for New Mort"
- "New Car Loans w Riskscore <620 ($B)"
- "New Car Loans w Riskscore 620-659 ($B)"
- "New Car Loans w Riskscore 660-719 ($B)"
- "New Car Loans w Riskscore 720-759 ($B)"
- "New Car Loans w Riskscore 760+ ($B)"
- "All New Car Loans ($B)"
- "Median Riskscore for New Car Loan"
- "Bottom 25%ile Riskscore for New Car Loan"
- "Bottom 10%ile Riskscore for New Car Loan"
- "% Balances Current"
- "% Balances 30d late"
- "% Balances 60d late"
- "% Balances 90d late"
- "% Balances 120+d late"
- "% Balances Severely Impair"
- "% Consumers w Collection"
- "Avg Collection Amt"
- "Avg Total Debt Bal for 18-29 yo ($T)"
- "Avg Total Debt Bal for 30-39 yo ($T)"
- "Avg Total Debt Bal for 40-49 yo ($T)"
- "Avg Total Debt Bal for 50-59 yo ($T)"
- "Avg Total Debt Bal for 60-69 yo ($T)"
- "Avg Total Debt Bal for 70+ yo ($T)"
- "New Car Loans for 18-29 yo ($B)"
- "New Car Loans for 30-39 yo ($B)"
- "New Car Loans for 40-49 yo ($B)"
- "New Car Loans for 50-59 yo ($B)"
- "New Car Loans for 60-69 yo ($B)"
- "New Car Loans for 70+ yo ($B)"
- "New Mort for 18-29 yo ($B)"
- "New Mort for 30-39 yo ($B)"
- "New Mort for 40-49 yo ($B)"
- "New Mort for 50-59 yo ($B)"
- "New Mort for 60-69 yo ($B)"
- "New Mort for 70+ yo ($B)"
- "Qtrly % ->90d+ late for 18-29 yo"
- "Qtrly % ->90d+ late for 30-39 yo"
- "Qtrly % ->90d+ late for 40-49 yo"
- "Qtrly % ->90d+ late for 50-59 yo"
- "Qtrly % ->90d+ late for 60-69 yo"
- "Qtrly % ->90d+ late for 70+ yo"
- "Qtrly % ->90d+ late"
- "Qtrly % Mort ->90d+ late for 18-29 yo"
- "Qtrly % Mort ->90d+ late for 30-39 yo"
- "Qtrly % Mort ->90d+ late for 40-49 yo"
- "Qtrly % Mort ->90d+ late for 50-59 yo"
- "Qtrly % Mort ->90d+ late for 60-69 yo"
- "Qtrly % Mort ->90d+ late for 70+ yo"
- "Qtrly % Mort ->90d+ late"
- "Qtrly % Car Loans ->90d+ late for 18-29 yo"
- "Qtrly % Car Loans ->90d+ late for 30-39 yo"
- "Qtrly % Car Loans ->90d+ late for 40-49 yo"
- "Qtrly % Car Loans ->90d+ late for 50-59 yo"
- "Qtrly % Car Loans ->90d+ late for 60-69 yo"
- "Qtrly % Car Loans ->90d+ late for 70+ yo"
- "Qtrly % Car Loans ->90d+ late"
- "Qtrly % CC ->90d+ late for 18-29 yo"
- "Qtrly % CC ->90d+ late for 30-39 yo"
- "Qtrly % CC ->90d+ late for 40-49 yo"
- "Qtrly % CC ->90d+ late for 50-59 yo"
- "Qtrly % CC ->90d+ late for 60-69 yo"
- "Qtrly % CC ->90d+ late for 70+ yo"
- "Qtrly % CC ->90d+ late"
- "Qtrly % Student Loan ->90d+ late for 18-29 yo"
- "Qtrly % Student Loan ->90d+ late for 30-39 yo"
- "Qtrly % Student Loan ->90d+ late for 40-49 yo"
- "Qtrly % Student Loan ->90d+ late"
- "New Foreclosures for 18-29 yo (000)"
- "New Foreclosures for 30-39 yo (000)"
- "New Foreclosures for 40-49 yo (000)"
- "New Foreclosures for 50-59 yo (000)"
- "New Foreclosures for 60-69 yo (000)"
- "New Foreclosures for 70+ yo (000)"
- "New Bankruptcies for 18-29 yo (000)"
- "New Bankruptcies for 30-39 yo (000)"
- "New Bankruptcies for 40-49 yo (000)"
- "New Bankruptcies for 50-59 yo (000)"
- "New Bankruptcies for 60-69 yo (000)"
- "New Bankruptcies for 70+ yo (000)"
Refer to https://www.newyorkfed.org/microeconomics/hhdc/background.html and https://www.newyorkfed.org/microeconomics/hhdc for additional information about available data.
Contributing
Bug reports and pull requests are welcome on GitHub at https://github.com/[USERNAME]/ny_frb_as_dataframe. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the code of conduct.
License
The gem is available as open source under the terms of the MIT License.
Code of Conduct
Everyone interacting in the NyFrbAsDataframe project's codebases, issue trackers, chat rooms and mailing lists is expected to follow the code of conduct.