fred_fotch
fred_fotch OP t1_j1rk5vl wrote
Reply to comment by theftnssgrmpcrtst in [OC] State by State Housing Price Growth since 1975 by fred_fotch
True. I made a city one in response to a similar comment https://www.reddit.com/r/dataisbeautiful/comments/zvt54h/oc_us_city_housing_price_changes_since_1991/
The data only goes back to 1991 though.
Submitted by fred_fotch t3_zvt54h in dataisbeautiful
fred_fotch OP t1_j1qxltc wrote
Reply to comment by Think-Mountain1754 in [OC] State by State Housing Price Growth since 1975 by fred_fotch
Yes, the scale makes no sense haha. Arizona was 1065%.
fred_fotch OP t1_j1qwh27 wrote
Reply to comment by xBris18 in [OC] State by State Housing Price Growth since 1975 by fred_fotch
That does look better - thanks.
fred_fotch OP t1_j1qgnyd wrote
Reply to comment by [deleted] in [OC] Beer as a percentage of total calories by fred_fotch
You must work at the FAO. If you look at section VI of their methodology, they attempt to adjust for tourism: https://fenixservices.fao.org/faostat/static/documents/FBS/New%20FBS%20methodology.pdf
fred_fotch OP t1_j1qg6no wrote
Reply to comment by timeline-drifter in [OC] Beer as a percentage of total calories by fred_fotch
38th place at 2.1%
fred_fotch OP t1_j1qfqdv wrote
Reply to comment by DeTrotseTuinkabouter in [OC] Beer as a percentage of total calories by fred_fotch
That would have been smart. Here it is if you are interested:
Romania 3.38%
Namibia 3.45%
Bulgaria 3.46%
Germany 3.47%
Poland 3.48%
Croatia 3.54%
Austria 3.73%
Gabon 3.75%
Ireland 4.33%
Czech Republic 5.49%
fred_fotch OP t1_j1qfaxv wrote
Reply to comment by Norwester77 in [OC] Beer as a percentage of total calories by fred_fotch
I had no idea but your comment prompted me to find that article.
I couldn't find much about Gabon, but here is an article if you are interested: http://enoromi.com/index.php/enquetes/societe-des-brasseries-du-gabon-entreprise-citoyen-et-leader-de-la-production-de-boissons-au-gabon
fred_fotch OP t1_j1qecj8 wrote
Reply to comment by BastardChicken1 in [OC] State by State Housing Price Growth since 1975 by fred_fotch
I am not American if that makes you feel better.
fred_fotch OP t1_j1qe9m1 wrote
Reply to comment by ShinjukuAce in [OC] State by State Housing Price Growth since 1975 by fred_fotch
True, but the metro data only goes back to 1991: https://www.fhfa.gov/DataTools/Downloads/Pages/House-Price-Index-Datasets.aspx#qat
fred_fotch OP t1_j1qe7ws wrote
Reply to comment by CarpetbaggerForPeace in [OC] State by State Housing Price Growth since 1975 by fred_fotch
Very true - I thought about doing that, but there were too many other factors to consider (property taxes and insurance costs for example).
fred_fotch OP t1_j1qe28c wrote
Reply to comment by kaizerdouken in [OC] State by State Housing Price Growth since 1975 by fred_fotch
That would be tough because I don't think there is a good national property tax data set.
fred_fotch OP t1_j1qdyuu wrote
Reply to comment by CheerfulParadox in [OC] State by State Housing Price Growth since 1975 by fred_fotch
I was surprised too. They also publish data for the 50 biggest metropolitan areas (starting in 1991) and Austin has the biggest price increase since then. Houston and Dallas are near the middle though.
fred_fotch OP t1_j1qdnua wrote
Reply to comment by xBris18 in [OC] State by State Housing Price Growth since 1975 by fred_fotch
Graphic design is not my strong suit unfortunately. Do you have suggestions on different design options?
fred_fotch OP t1_j1p76lj wrote
Reply to comment by cartersa87 in [OC] State by State Housing Price Growth since 1975 by fred_fotch
I think it's mostly geography rather than political affiliation. Red states like Utah, Arizona, Montana and Florida are above average. The South and Midwest are below average. Overall, Blue States are higher but I think it's driven by geography.
fred_fotch OP t1_j1p64lx wrote
Reply to comment by Brewe in [OC] Beer as a percentage of total calories by fred_fotch
No, they are just colours from the flags of the countries.
Originally, I was going to fill in each bar with a picture of a beer from the country but I couldn't figure out a way to make it look good. Then I was going to do flags, but I had the same problem. So I settled on a colour from the flag.
fred_fotch OP t1_j1ovuhf wrote
Reply to comment by Veszerin in [OC] State by State Housing Price Growth since 1975 by fred_fotch
The whole point is to show the nominal price increase. The original data set had the 50 states and Washington DC.
fred_fotch OP t1_j1ot5wn wrote
Reply to comment by BigBobby2016 in [OC] State by State Housing Price Growth since 1975 by fred_fotch
I thought it was more to do with recreational homes (similar to what I assume is happening in Montana) but I don't know the area well.
fred_fotch OP t1_j1oswx4 wrote
Reply to comment by LanewayRat in [OC] Beer as a percentage of total calories by fred_fotch
Somehow I think more food is wasted than beer haha
fred_fotch OP t1_j1ojdjo wrote
Created using excel from FAO data: https://www.fao.org/faostat/en/#data/FBS
Submitted by fred_fotch t3_zvddm2 in dataisbeautiful
fred_fotch OP t1_j1ohkdr wrote
Reply to comment by skunkachunks in [OC] State by State Housing Price Growth since 1975 by fred_fotch
The median state is Connecticut at 814%. The simple average is 918%. I am not sure what the weighted average is, but I guess it's over 1000% because of California and New York.
fred_fotch OP t1_j1ohd57 wrote
Reply to comment by Matt_Candlewood in [OC] State by State Housing Price Growth since 1975 by fred_fotch
Yes, you are right haha. I should have started at 0% and gone up by 400% or 500%.
fred_fotch OP t1_j1o2726 wrote
Made using excel from the FHFA House Price Index https://www.fhfa.gov/DataTools/Downloads/Pages/House-Price-Index.aspx
fred_fotch t1_j1t82m5 wrote
Reply to comment by kliuch in [OC] Every High School Baseball Field Used in the State of West Virginia by dvd5671
It's the same for soccer. (Sizes not shapes.)