• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Remember the HS nerd who inventoried his music collection into a database?

IronWing

IronWing

No Lifer
That was me. Here's a summary by country of origin. Note that some countries no longer exist, boundaries have changed and populations have drifted and also sometimes the folks who recorded the music didn't provide liner notes so some music gets lumped by region.

Country Count %
Total Songs 8204 100.00%
USA 3872 47.20%
Britain 585 7.13%
Mali 325 3.96%
Spain 230 2.80%
Mongolia 200 2.44%
Europe 190 2.32%
Turkey 171 2.08%
Germany 166 2.02%
Tuva 163 1.99%
Armenia 115 1.40%
France 111 1.35%
Ireland 111 1.35%
China 109 1.33%
Iran 97 1.18%
Sweden 81 0.99%
Italy 79 0.96%
Morocco 76 0.93%
Estonia 67 0.82%
Canada 60 0.73%
Norway 56 0.68%
Peru 49 0.60%
Byzantium 45 0.55%
Greece 43 0.52%
Mexico 43 0.52%
Peru/Equador/Bolivia/Chile 43 0.52%
Bulgaria 41 0.50%
Australia 40 0.49%
Cuba 38 0.46%
Finland 38 0.46%
Ghana 37 0.45%
Japan 37 0.45%
Scotland 36 0.44%
India/USA/UK 32 0.39%
Algeria 31 0.38%
Ethiopia 31 0.38%
Uzbekistan 31 0.38%
Hungary 30 0.37%
Wales 29 0.35%
Egypt 27 0.33%
Tibet 26 0.32%
Europe / USA 24 0.29%
Senegal 23 0.28%
Africa 22 0.27%
Pakistan 22 0.27%
Cameroon 21 0.26%
France / Spain 21 0.26%
Iceland 21 0.26%
Nigeria 20 0.24%
Vietnam 20 0.24%
Benin 19 0.23%
Niger 19 0.23%
India 18 0.22%
Kazakhstan 18 0.22%
USA / Mexico 18 0.22%
Bolivia 17 0.21%
Spain / Israel 16 0.20%
Tanzania 16 0.20%
Tunisia 16 0.20%
Belize 15 0.18%
Portugal 15 0.18%
Turkey/Greece/Israel 14 0.17%
USA/South Africa 14 0.17%
Turkmenistan 13 0.16%
Tuva / Senegal 13 0.16%
Belize, Guatamala, Nicaragua, Honduras 12 0.15%
Indonesia 12 0.15%
Iran/Turkey 12 0.15%
Mali / USA 12 0.15%
Thailand 12 0.15%
Papua New Guinea 11 0.13%
France/Italy 9 0.11%
Italy/Sardinia 9 0.11%
USA / Iran 9 0.11%
Iran/Armenia 7 0.09%
Azerbaijan 6 0.07%
Korea 6 0.07%
Romania 4 0.05%
Tajikistan 4 0.05%
Albania 3 0.04%
India/Iran 3 0.04%
Kirghistan 3 0.04%
Lebanon 3 0.04%
Trinidad 3 0.04%
Croatia, Yugoslavia 2 0.02%
Israel 2 0.02%
Macedonia 2 0.02%
Russia 2 0.02%
Sardinia 2 0.02%
Ukraine / Russia 2 0.02%
Yugoslavia 2 0.02%
Andalusia 1 0.01%
Argentina 1 0.01%
Brittany / Ireland 1 0.01%
Burundi 1 0.01%
Central Asia 1 0.01%
Crimea 1 0.01%
Croatia 1 0.01%
Czechoslovakia 1 0.01%
Daghestan 1 0.01%
Dalmatia, Yugoslavia 1 0.01%
England 1 0.01%
Grenada 1 0.01%
Hebrides Islands 1 0.01%
Libya 1 0.01%
Macedonia, Yugoslavia 1 0.01%
Rumania 1 0.01%
Serbia 1 0.01%
Sinkiang 1 0.01%
St. Lucia 1 0.01%
Sudan 1 0.01%
The Hebrides, Island of Eigg 1 0.01%
The Hebrides, Scotland, South Uist, Lewis 1 0.01%
Turkestan 1 0.01%
Upper Volta 1 0.01%
 
Why by country, just for your curiosity of the ratios? Was this for a school project or something? I did a movie DB for my DVD's to self learn mysql, but it had useful info and a search ui so I could search by title/genre/duration/actors/etc. I couldn't imagine doing it for useless info, my attention span would be very short populating those fields.
 
care-o-meter.jpg
 
Eclectic taste to say the least... what kind of music do you get from some of those odd ones, like Daghestan ?
 
a buddy of mine has his contacts in a database....he has a query for christmas cards that he runs after thanksgiving

poor, poor guy...
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top