Household month as unit of observation, "white-townsend" asset file with household monthly aggregated loan data.
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>