Know of a country-nationality list for DB lookup table?

Question

Hi, I'm looking for a list/table of countries/nationalities that I can use in my app. I would like to basically have a lookup table that would be like the following, but including all countries in the world:

ID     Name                        Nationality

1      United Kingdom              British
2      United Status of America    American
3      Ireland                     Irish

Anyone come across something like this before? If not, I've a pretty tedious hour or two ahead!

Thanks

Answer 1

Wikipedia seems to have what you need:

http://en.wikipedia.org/wiki/List_of_adjectival_forms_of_place_names

Answer 2

The generally accepted country code list is contained in the ISO 3166-1 standard. Wars have been / are being / will be fought over nationality so good luck with that.