[ashantewarrier]

Originally Posted by Biggio509

This is far from finished but it may be interesting to you. I am compiling a spread sheet for birth places of US players to determine foreign percentage and what level of play countries should have. The data is taken from baseball almanac's page listing players by birth place. I am only through the 1880's but the sheet breaks down foreign players by birth place calculating a percentage of foreign players than a percentage of foreign players by nationality. I assigned baseball level based on the number of players from that country/foreign players.

Country 1876 1877 1878 1879 1870's level
US 108 86 72 102 368
Canada 1 1 1 3
England 5 3 1 1 10
Germany 1 1
Ireland 4 5 4 13
Scotland 1 1 2
Czech 1 1
Foreign % 6.09% 8.51% 8.86% 7.27% 7.27%
% CAN 16.67% 12.50% 0.00% 12.50% 10.00% 4
% UK 71.43% 37.50% 14.29% 12.50% 33.33% 5
%D 14.29% 3.33% 3
%IRE 57.14% 71.43% 57.14% 43.33% 5
%Scot 14.29% 12.50% 6.67% 3
%czech 12.50% 3.33% 3


Country 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1880's LEVEL
Foreign% 8.09% 10.00% 5.81% 7.91% 8.65% 10.43% 5.19% 7.25% 5.73% 6.14% 7.48%
%AUSSIE 0.00% 0.00% 0.00% 0.00% 1.52% 2.78% 5.56% 0.00% 0.00% 4.76% 1.64% 2
%AUST 0.00% 0.00% 0.00% 0.00% 0.00% 2.78% 5.56% 4.17% 5.00% 0.00% 1.64% 2
%CAN 36.36% 46.15% 64.29% 45.45% 56.06% 38.89% ##### 37.50% 40.00% 47.62% 47.13% 5
%ENG 18.18% 0.00% 28.57% 0.00% 6.06% 11.11% 5.56% 8.33% 5.00% 4.76% 7.79% 4
%GER 9.09% 0.00% 7.14% 9.09% 7.58% 11.11% ##### 8.33% 10.00% 9.52% 8.61% 3
%IRE 27.27% 38.46% 0.00% 36.36% 22.73% 22.22% ##### 33.33% 35.00% 28.57% 26.64% 5
%Scot 9.09% 15.38% 0.00% 9.09% 6.06% 8.33% 0.00% 8.33% 5.00% 4.76% 6.56% 4
%Swe 0.00% 0.00% 0.00% 0.00% 0.00% 2.78% 0.00% 0.00% 0.00% 0.00% 0.00% 1

The last number by the country is the baseball level I assigned so you get approximately the right percentage of foreigners. You have to manually adjust these every decade or so because they is no way to reload the nations file like you can ethnicities.

Thanks Bigs for this. I usually set my overall foreign percentages to 3% during 19th century play. But this will definitely a goof point of reference!