Skip to contents

Household month as unit of observation, "white-townsend" asset file with household monthly aggregated loan data.

Usage

tstm_asset_loan

Format

Household monthly asset and loans.

id

Household ID

month

Survey month

agg_BS_xx

Original asset variables

agg_BS_10xx

Agricultural and business joint asset variables, HFID generated

agg_BS_20xx

Agricultural asset variables, HFID generated

agg_BS_30xx

Business asset variables, HFID generated

agg_IS_10xx

Agricultural and business joint revenue variables, HFID generated

agg_IS_20xx

Agricultural revenue variables, HFID generated

agg_IS_30xx

Business revenue variables, HFID generated

agg_loan*

Househld month aggregate loan variables, HFID generated

Examples

data(tstm_asset_loan)
summary(tstm_asset_loan)
#>        id             month          agg_BS_01          agg_BS_03      
#>  Min.   : 70201   Min.   :  0.00   Min.   :       0   Min.   :      0  
#>  1st Qu.:270203   1st Qu.: 40.00   1st Qu.:   55692   1st Qu.:    850  
#>  Median :271446   Median : 81.00   Median :  169327   Median :   5799  
#>  Mean   :339318   Mean   : 80.39   Mean   :  454578   Mean   :  71070  
#>  3rd Qu.:490638   3rd Qu.:121.00   3rd Qu.:  452470   3rd Qu.:  34520  
#>  Max.   :531049   Max.   :160.00   Max.   :42502796   Max.   :7507694  
#>    agg_BS_17        agg_BS_1011         agg_BS_1012         agg_BS_1021     
#>  Min.   : -56500   Min.   :        0   Min.   :        0   Min.   :      0  
#>  1st Qu.:   2804   1st Qu.:   126741   1st Qu.:    81617   1st Qu.:      2  
#>  Median :  33300   Median :   413004   Median :   355000   Median :   2929  
#>  Mean   :  99570   Mean   :  1358594   Mean   :  1276199   Mean   :  34729  
#>  3rd Qu.:  89006   3rd Qu.:   989596   3rd Qu.:   918272   3rd Qu.:  24146  
#>  Max.   :7000000   Max.   :141635206   Max.   :141319628   Max.   :7685192  
#>   agg_BS_2011         agg_BS_2021       agg_BS_3011       agg_BS_3021     
#>  Min.   :        0   Min.   :      0   Min.   :      0   Min.   :      0  
#>  1st Qu.:    78825   1st Qu.:      0   1st Qu.:  13081   1st Qu.:      0  
#>  Median :   350700   Median :   1719   Median :  34717   Median :      0  
#>  Mean   :  1264813   Mean   :  23343   Mean   :  93781   Mean   :  11387  
#>  3rd Qu.:   904500   3rd Qu.:  17235   3rd Qu.:  91705   3rd Qu.:      0  
#>  Max.   :141319628   Max.   :4564772   Max.   :7492854   Max.   :7397000  
#>   agg_IS_1011       agg_IS_1012       agg_IS_1013       agg_IS_1021     
#>  Min.   :-837762   Min.   : -32820   Min.   : -36000   Min.   :      0  
#>  1st Qu.:    330   1st Qu.:     40   1st Qu.:      0   1st Qu.:      0  
#>  Median :   4440   Median :    380   Median :    140   Median :      0  
#>  Mean   :  24714   Mean   :  19487   Mean   :  18871   Mean   :  12940  
#>  3rd Qu.:  17340   3rd Qu.:   7062   3rd Qu.:   5900   3rd Qu.:   2000  
#>  Max.   :6625000   Max.   :6625000   Max.   :6625000   Max.   :4050000  
#>   agg_IS_2011       agg_IS_2021       agg_IS_3011       agg_IS_3021     
#>  Min.   : -36000   Min.   :      0   Min.   :-837962   Min.   :      0  
#>  1st Qu.:      0   1st Qu.:      0   1st Qu.:      0   1st Qu.:      0  
#>  Median :     35   Median :      0   Median :   1000   Median :      0  
#>  Mean   :  11613   Mean   :   5682   Mean   :  12485   Mean   :   7258  
#>  3rd Qu.:    790   3rd Qu.:      0   3rd Qu.:   8201   3rd Qu.:      0  
#>  Max.   :6625000   Max.   :3900000   Max.   :4050750   Max.   :4050000  
#>  agg_loanflow_all  agg_loanflow_inf  agg_loanflow_for 
#>  Min.   :      0   Min.   :      0   Min.   :      0  
#>  1st Qu.:      0   1st Qu.:      0   1st Qu.:      0  
#>  Median :      0   Median :      0   Median :      0  
#>  Mean   :   5200   Mean   :   1306   Mean   :   3894  
#>  3rd Qu.:      0   3rd Qu.:      0   3rd Qu.:      0  
#>  Max.   :7000000   Max.   :1130000   Max.   :7000000  
print(tstm_asset_loan)
#> # A tibble: 114,328 × 23
#>       id month agg_BS_01 agg_BS_03 agg_BS_17 agg_BS_1011 agg_BS_1012 agg_BS_1021
#>    <dbl> <dbl>     <dbl>     <dbl>     <dbl>       <dbl>       <dbl>       <dbl>
#>  1 70201     0       283         0         0     152226.      151000           0
#>  2 70201     1      1186         0         0     152205.      151000           0
#>  3 70201     2      1953         0         0     152183.      151000           0
#>  4 70201     3        31         0         0     152162.      151000           0
#>  5 70201     4         0         0         0     152141.      151000           0
#>  6 70201     5       834         0         0     152121.      151000           0
#>  7 70201     6      1960         0         0     152101.      151000           0
#>  8 70201     7      2517         0         0     152081.      151000           0
#>  9 70201     8      3188         0         0     152062.      151000           0
#> 10 70201     9      3418         0         0     152043.      151000           0
#> # ℹ 114,318 more rows
#> # ℹ 15 more variables: agg_BS_2011 <dbl>, agg_BS_2021 <dbl>, agg_BS_3011 <dbl>,
#> #   agg_BS_3021 <dbl>, agg_IS_1011 <dbl>, agg_IS_1012 <dbl>, agg_IS_1013 <dbl>,
#> #   agg_IS_1021 <dbl>, agg_IS_2011 <dbl>, agg_IS_2021 <dbl>, agg_IS_3011 <dbl>,
#> #   agg_IS_3021 <dbl>, agg_loanflow_all <dbl>, agg_loanflow_inf <dbl>,
#> #   agg_loanflow_for <dbl>