NetSuite: Use SuiteQL to Get Lists of States and Countries

Published on July 1, 2021.

If you need lists of the countries and states that NetSuite supports, then these simple SuiteQL queries might help.

The State Table

States are maintained in a "States" table, and its columns include NetSuite's integer ID, the state's abbreviation ("shortname"), the state's full name, and the country that the state is in.

Here's a query that you can use to get data from the State table.

SELECT
	State.ID,
	State.ShortName,
	State.FullName,
	State.Country
FROM
	State
ORDER BY
	State.ShortName

The Country Table

Countries are stored in a "Country" table. Its columns include the country's code ("ID"), name, as well as the edition of NetSuite that's designed for the country, and the nationality of the country's citizens.

Here's a query that you can use on the Country table.

SELECT
	Country.ID,
	Country.Name,
	Country.Edition,
	Country.Nationality
FROM
	Country
ORDER BY
	Country.Name

If you run that query, you might notice that the IDs of the Country records are not integers, but are instead two characters. For example, Australia's ID is "AU." That's uncharacteristic of most NetSuite tables.

Joining the State and Country Tables

And of course, you can join the two tables using a query such as this.

SELECT
	Country.ID AS CountryID,
	Country.Name AS CountryName,
	Country.Edition,
	Country.Nationality,
	State.ID AS StateID,
	State.ShortName AS StateShortName,
	State.FullName AS StateFullName
FROM
	Country
	LEFT OUTER JOIN State ON
		( State.Country = Country.ID )
ORDER BY
	CountryName,
	StateShortName

Note that I've joined using a LEFT OUTER JOIN, because some of the countries do not have a state.

The results of the query are included below as a JSON-encoded array.

If you have any questions about these queries, or SuiteQL in general, please feel free to contact me.

NetSuite Countries and States

[
     {
          "rownumber": 1,
          "countryid": "AF",
          "countryname": "Afghanistan",
          "edition": "XX",
          "nationality": "Afghan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 2,
          "countryid": "AX",
          "countryname": "Aland Islands",
          "edition": "XX",
          "nationality": "Åland Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 3,
          "countryid": "AL",
          "countryname": "Albania",
          "edition": "XX",
          "nationality": "Albanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 4,
          "countryid": "DZ",
          "countryname": "Algeria",
          "edition": "XX",
          "nationality": "Algerian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 5,
          "countryid": "AS",
          "countryname": "American Samoa",
          "edition": "XX",
          "nationality": "American Samoan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 6,
          "countryid": "AD",
          "countryname": "Andorra",
          "edition": "XX",
          "nationality": "Andorran",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 7,
          "countryid": "AO",
          "countryname": "Angola",
          "edition": "XX",
          "nationality": "Angolan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 8,
          "countryid": "AI",
          "countryname": "Anguilla",
          "edition": "XX",
          "nationality": "Anguillan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 9,
          "countryid": "AQ",
          "countryname": "Antarctica",
          "edition": "XX",
          "nationality": "Antarctican",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 10,
          "countryid": "AG",
          "countryname": "Antigua and Barbuda",
          "edition": "XX",
          "nationality": "Antigua and Barbuda national",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 11,
          "countryid": "AR",
          "countryname": "Argentina",
          "edition": "XX",
          "nationality": "Argentinian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 12,
          "countryid": "AM",
          "countryname": "Armenia",
          "edition": "XX",
          "nationality": "Armenian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 13,
          "countryid": "AW",
          "countryname": "Aruba",
          "edition": "XX",
          "nationality": "Aruban",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 14,
          "countryid": "AU",
          "countryname": "Australia",
          "edition": "AU",
          "nationality": "Australian",
          "stateid": 400,
          "stateshortname": "ACT",
          "statefullname": "Australian Capital Territory"
     },
     {
          "rownumber": 15,
          "countryid": "AU",
          "countryname": "Australia",
          "edition": "AU",
          "nationality": "Australian",
          "stateid": 401,
          "stateshortname": "NSW",
          "statefullname": "New South Wales"
     },
     {
          "rownumber": 16,
          "countryid": "AU",
          "countryname": "Australia",
          "edition": "AU",
          "nationality": "Australian",
          "stateid": 402,
          "stateshortname": "NT",
          "statefullname": "Northern Territory"
     },
     {
          "rownumber": 17,
          "countryid": "AU",
          "countryname": "Australia",
          "edition": "AU",
          "nationality": "Australian",
          "stateid": 403,
          "stateshortname": "QLD",
          "statefullname": "Queensland"
     },
     {
          "rownumber": 18,
          "countryid": "AU",
          "countryname": "Australia",
          "edition": "AU",
          "nationality": "Australian",
          "stateid": 404,
          "stateshortname": "SA",
          "statefullname": "South Australia"
     },
     {
          "rownumber": 19,
          "countryid": "AU",
          "countryname": "Australia",
          "edition": "AU",
          "nationality": "Australian",
          "stateid": 405,
          "stateshortname": "TAS",
          "statefullname": "Tasmania"
     },
     {
          "rownumber": 20,
          "countryid": "AU",
          "countryname": "Australia",
          "edition": "AU",
          "nationality": "Australian",
          "stateid": 406,
          "stateshortname": "VIC",
          "statefullname": "Victoria"
     },
     {
          "rownumber": 21,
          "countryid": "AU",
          "countryname": "Australia",
          "edition": "AU",
          "nationality": "Australian",
          "stateid": 407,
          "stateshortname": "WA",
          "statefullname": "Western Australia"
     },
     {
          "rownumber": 22,
          "countryid": "AT",
          "countryname": "Austria",
          "edition": "XX",
          "nationality": "Austrian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 23,
          "countryid": "AZ",
          "countryname": "Azerbaijan",
          "edition": "XX",
          "nationality": "Azerbaijani",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 24,
          "countryid": "BS",
          "countryname": "Bahamas",
          "edition": "XX",
          "nationality": "Bahamian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 25,
          "countryid": "BH",
          "countryname": "Bahrain",
          "edition": "XX",
          "nationality": "Bahraini",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 26,
          "countryid": "BD",
          "countryname": "Bangladesh",
          "edition": "XX",
          "nationality": "Bangladeshi",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 27,
          "countryid": "BB",
          "countryname": "Barbados",
          "edition": "XX",
          "nationality": "Barbadian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 28,
          "countryid": "BY",
          "countryname": "Belarus",
          "edition": "XX",
          "nationality": "Belarusian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 29,
          "countryid": "BE",
          "countryname": "Belgium",
          "edition": "XX",
          "nationality": "Belgian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 30,
          "countryid": "BZ",
          "countryname": "Belize",
          "edition": "XX",
          "nationality": "Belizean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 31,
          "countryid": "BJ",
          "countryname": "Benin",
          "edition": "XX",
          "nationality": "Beninese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 32,
          "countryid": "BM",
          "countryname": "Bermuda",
          "edition": "XX",
          "nationality": "Bermudian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 33,
          "countryid": "BT",
          "countryname": "Bhutan",
          "edition": "XX",
          "nationality": "Bhutanese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 34,
          "countryid": "BO",
          "countryname": "Bolivia",
          "edition": "XX",
          "nationality": "Bolivian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 35,
          "countryid": "BQ",
          "countryname": "Bonaire, Saint Eustatius and Saba",
          "edition": "XX",
          "nationality": "Dutch (Bonaire, Saint Eustatius and Saba)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 36,
          "countryid": "BA",
          "countryname": "Bosnia and Herzegovina",
          "edition": "XX",
          "nationality": "Bosnia and Herzegovina national",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 37,
          "countryid": "BW",
          "countryname": "Botswana",
          "edition": "XX",
          "nationality": "Botswanan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 38,
          "countryid": "BV",
          "countryname": "Bouvet Island",
          "edition": "XX",
          "nationality": "Bouvet Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 39,
          "countryid": "BR",
          "countryname": "Brazil",
          "edition": "XX",
          "nationality": "Brazilian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 40,
          "countryid": "IO",
          "countryname": "British Indian Ocean Territory",
          "edition": "UK",
          "nationality": "British (British Indian Ocean Territory )",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 41,
          "countryid": "BN",
          "countryname": "Brunei Darussalam",
          "edition": "XX",
          "nationality": "Bruneian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 42,
          "countryid": "BG",
          "countryname": "Bulgaria",
          "edition": "XX",
          "nationality": "Bulgarian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 43,
          "countryid": "BF",
          "countryname": "Burkina Faso",
          "edition": "XX",
          "nationality": "Burkinabe",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 44,
          "countryid": "BI",
          "countryname": "Burundi",
          "edition": "XX",
          "nationality": "Burundian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 45,
          "countryid": "KH",
          "countryname": "Cambodia",
          "edition": "XX",
          "nationality": "Cambodian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 46,
          "countryid": "CM",
          "countryname": "Cameroon",
          "edition": "XX",
          "nationality": "Cameroonian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 47,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 101,
          "stateshortname": "AB",
          "statefullname": "Alberta"
     },
     {
          "rownumber": 48,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 102,
          "stateshortname": "BC",
          "statefullname": "British Columbia"
     },
     {
          "rownumber": 49,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 103,
          "stateshortname": "MB",
          "statefullname": "Manitoba"
     },
     {
          "rownumber": 50,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 104,
          "stateshortname": "NB",
          "statefullname": "New Brunswick"
     },
     {
          "rownumber": 51,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 105,
          "stateshortname": "NL",
          "statefullname": "Newfoundland"
     },
     {
          "rownumber": 52,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 106,
          "stateshortname": "NS",
          "statefullname": "Nova Scotia"
     },
     {
          "rownumber": 53,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 107,
          "stateshortname": "NT",
          "statefullname": "Northwest Territories"
     },
     {
          "rownumber": 54,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 108,
          "stateshortname": "NU",
          "statefullname": "Nunavut"
     },
     {
          "rownumber": 55,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 109,
          "stateshortname": "ON",
          "statefullname": "Ontario"
     },
     {
          "rownumber": 56,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 110,
          "stateshortname": "PE",
          "statefullname": "Prince Edward Island"
     },
     {
          "rownumber": 57,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 111,
          "stateshortname": "QC",
          "statefullname": "Quebec"
     },
     {
          "rownumber": 58,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 112,
          "stateshortname": "SK",
          "statefullname": "Saskatchewan"
     },
     {
          "rownumber": 59,
          "countryid": "CA",
          "countryname": "Canada",
          "edition": "CA",
          "nationality": "Canadian",
          "stateid": 113,
          "stateshortname": "YT",
          "statefullname": "Yukon"
     },
     {
          "rownumber": 60,
          "countryid": "IC",
          "countryname": "Canary Islands",
          "edition": "XX",
          "nationality": "Canarian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 61,
          "countryid": "CV",
          "countryname": "Cape Verde",
          "edition": "XX",
          "nationality": "Cape Verdean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 62,
          "countryid": "KY",
          "countryname": "Cayman Islands",
          "edition": "XX",
          "nationality": "Caymanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 63,
          "countryid": "CF",
          "countryname": "Central African Republic",
          "edition": "XX",
          "nationality": "Central African",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 64,
          "countryid": "EA",
          "countryname": "Ceuta and Melilla",
          "edition": "XX",
          "nationality": "Spanish (Ceuta and Melilla)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 65,
          "countryid": "TD",
          "countryname": "Chad",
          "edition": "XX",
          "nationality": "Chadian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 66,
          "countryid": "CL",
          "countryname": "Chile",
          "edition": "XX",
          "nationality": "Chilean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 67,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 628,
          "stateshortname": "上海市",
          "statefullname": "Shanghai"
     },
     {
          "rownumber": 68,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 624,
          "stateshortname": "云南省",
          "statefullname": "Yunnan Province"
     },
     {
          "rownumber": 69,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 604,
          "stateshortname": "内蒙古",
          "statefullname": "Neimenggu A. R."
     },
     {
          "rownumber": 70,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 627,
          "stateshortname": "北京市",
          "statefullname": "Beijing"
     },
     {
          "rownumber": 71,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 602,
          "stateshortname": "吉林省",
          "statefullname": "Jilin Province"
     },
     {
          "rownumber": 72,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 619,
          "stateshortname": "四川省",
          "statefullname": "Sichuan Province"
     },
     {
          "rownumber": 73,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 629,
          "stateshortname": "天津市",
          "statefullname": "Tianjin"
     },
     {
          "rownumber": 74,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 606,
          "stateshortname": "宁夏回族自治区",
          "statefullname": "Ningxia A. R."
     },
     {
          "rownumber": 75,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 616,
          "stateshortname": "安徽省",
          "statefullname": "Anhui Province"
     },
     {
          "rownumber": 76,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 611,
          "stateshortname": "山东省",
          "statefullname": "Shandong Province"
     },
     {
          "rownumber": 77,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 612,
          "stateshortname": "山西省",
          "statefullname": "Shanxi Province"
     },
     {
          "rownumber": 78,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 622,
          "stateshortname": "广东省",
          "statefullname": "Guangdong Province"
     },
     {
          "rownumber": 79,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 623,
          "stateshortname": "广西壮族自治区",
          "statefullname": "Guangxi A. R."
     },
     {
          "rownumber": 80,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 607,
          "stateshortname": "新疆维吾尔族自治区",
          "statefullname": "Xinjiang A. R."
     },
     {
          "rownumber": 81,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 614,
          "stateshortname": "江苏省",
          "statefullname": "Jiangsu Province"
     },
     {
          "rownumber": 82,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 621,
          "stateshortname": "江西省",
          "statefullname": "Jiangxi Province"
     },
     {
          "rownumber": 83,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 609,
          "stateshortname": "河北省",
          "statefullname": "Hebei Province"
     },
     {
          "rownumber": 84,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 610,
          "stateshortname": "河南省",
          "statefullname": "Henan Province"
     },
     {
          "rownumber": 85,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 615,
          "stateshortname": "浙江省",
          "statefullname": "Zhejiang Province"
     },
     {
          "rownumber": 86,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 625,
          "stateshortname": "海南省",
          "statefullname": "Hainan Province"
     },
     {
          "rownumber": 87,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 617,
          "stateshortname": "湖北省",
          "statefullname": "Hubei Province"
     },
     {
          "rownumber": 88,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 618,
          "stateshortname": "湖南省",
          "statefullname": "Hunan Province"
     },
     {
          "rownumber": 89,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 605,
          "stateshortname": "甘肃省",
          "statefullname": "Gansu Province"
     },
     {
          "rownumber": 90,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 631,
          "stateshortname": "福建省",
          "statefullname": "Fujian Province"
     },
     {
          "rownumber": 91,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 626,
          "stateshortname": "西藏藏族自治区",
          "statefullname": "Xizang A. R."
     },
     {
          "rownumber": 92,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 620,
          "stateshortname": "贵州省",
          "statefullname": "Guizhou Province"
     },
     {
          "rownumber": 93,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 603,
          "stateshortname": "辽宁省",
          "statefullname": "Liaoning Province"
     },
     {
          "rownumber": 94,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 630,
          "stateshortname": "重庆市",
          "statefullname": "Chongqing"
     },
     {
          "rownumber": 95,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 613,
          "stateshortname": "陕西省",
          "statefullname": "Shaanxi Province"
     },
     {
          "rownumber": 96,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 608,
          "stateshortname": "青海省",
          "statefullname": "Qinghai Province"
     },
     {
          "rownumber": 97,
          "countryid": "CN",
          "countryname": "China",
          "edition": "XX",
          "nationality": "Chinese",
          "stateid": 601,
          "stateshortname": "黑龙江省",
          "statefullname": "Heilongjiang Province"
     },
     {
          "rownumber": 98,
          "countryid": "CX",
          "countryname": "Christmas Island",
          "edition": "XX",
          "nationality": "Christmas Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 99,
          "countryid": "CC",
          "countryname": "Cocos (Keeling) Islands",
          "edition": "XX",
          "nationality": "Cocos Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 100,
          "countryid": "CO",
          "countryname": "Colombia",
          "edition": "XX",
          "nationality": "Colombian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 101,
          "countryid": "KM",
          "countryname": "Comoros",
          "edition": "XX",
          "nationality": "Comorian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 102,
          "countryid": "CD",
          "countryname": "Congo, Democratic Republic of",
          "edition": "XX",
          "nationality": "Congolese (Congo, Democratic Republic of)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 103,
          "countryid": "CG",
          "countryname": "Congo, Republic of",
          "edition": "XX",
          "nationality": "Congolese (Congo, Republic of)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 104,
          "countryid": "CK",
          "countryname": "Cook Islands",
          "edition": "XX",
          "nationality": "Cook Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 105,
          "countryid": "CR",
          "countryname": "Costa Rica",
          "edition": "XX",
          "nationality": "Costa Rican",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 106,
          "countryid": "CI",
          "countryname": "Cote d'Ivoire",
          "edition": "XX",
          "nationality": "Cote d'Ivoire",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 107,
          "countryid": "HR",
          "countryname": "Croatia/Hrvatska",
          "edition": "XX",
          "nationality": "Croat",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 108,
          "countryid": "CU",
          "countryname": "Cuba",
          "edition": "XX",
          "nationality": "Cuban",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 109,
          "countryid": "CW",
          "countryname": "Curaçao",
          "edition": "XX",
          "nationality": "Dutch (Curaçao)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 110,
          "countryid": "CY",
          "countryname": "Cyprus",
          "edition": "XX",
          "nationality": "Cypriot",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 111,
          "countryid": "CZ",
          "countryname": "Czech Republic",
          "edition": "XX",
          "nationality": "Czech",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 112,
          "countryid": "DK",
          "countryname": "Denmark",
          "edition": "XX",
          "nationality": "Dane (Danish)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 113,
          "countryid": "DJ",
          "countryname": "Djibouti",
          "edition": "XX",
          "nationality": "Djiboutian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 114,
          "countryid": "DM",
          "countryname": "Dominica",
          "edition": "XX",
          "nationality": "Dominican (Dominica)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 115,
          "countryid": "DO",
          "countryname": "Dominican Republic",
          "edition": "XX",
          "nationality": "Dominican (Dominican Republic)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 116,
          "countryid": "TL",
          "countryname": "East Timor",
          "edition": "XX",
          "nationality": "East Timorese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 117,
          "countryid": "EC",
          "countryname": "Ecuador",
          "edition": "XX",
          "nationality": "Ecuadorian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 118,
          "countryid": "EG",
          "countryname": "Egypt",
          "edition": "XX",
          "nationality": "Egyptian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 119,
          "countryid": "SV",
          "countryname": "El Salvador",
          "edition": "XX",
          "nationality": "Salvadorian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 120,
          "countryid": "GQ",
          "countryname": "Equatorial Guinea",
          "edition": "XX",
          "nationality": "Equatorial Guinean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 121,
          "countryid": "ER",
          "countryname": "Eritrea",
          "edition": "XX",
          "nationality": "Eritrean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 122,
          "countryid": "EE",
          "countryname": "Estonia",
          "edition": "XX",
          "nationality": "Estonian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 123,
          "countryid": "ET",
          "countryname": "Ethiopia",
          "edition": "XX",
          "nationality": "Ethiopian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 124,
          "countryid": "FK",
          "countryname": "Falkland Islands",
          "edition": "XX",
          "nationality": "Falkland Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 125,
          "countryid": "FO",
          "countryname": "Faroe Islands",
          "edition": "XX",
          "nationality": "Faroese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 126,
          "countryid": "FJ",
          "countryname": "Fiji",
          "edition": "XX",
          "nationality": "Fijian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 127,
          "countryid": "FI",
          "countryname": "Finland",
          "edition": "XX",
          "nationality": "Finnish",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 128,
          "countryid": "FR",
          "countryname": "France",
          "edition": "XX",
          "nationality": "French",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 129,
          "countryid": "GF",
          "countryname": "French Guiana",
          "edition": "XX",
          "nationality": "Guianese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 130,
          "countryid": "PF",
          "countryname": "French Polynesia",
          "edition": "XX",
          "nationality": "Polynesian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 131,
          "countryid": "TF",
          "countryname": "French Southern Territories",
          "edition": "XX",
          "nationality": "French (French Southern Territories)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 132,
          "countryid": "GA",
          "countryname": "Gabon",
          "edition": "XX",
          "nationality": "Gabonese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 133,
          "countryid": "GM",
          "countryname": "Gambia",
          "edition": "XX",
          "nationality": "Gambian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 134,
          "countryid": "GE",
          "countryname": "Georgia",
          "edition": "XX",
          "nationality": "Georgian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 135,
          "countryid": "DE",
          "countryname": "Germany",
          "edition": "XX",
          "nationality": "German",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 136,
          "countryid": "GH",
          "countryname": "Ghana",
          "edition": "XX",
          "nationality": "Ghanaian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 137,
          "countryid": "GI",
          "countryname": "Gibraltar",
          "edition": "UK",
          "nationality": "Gibraltarian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 138,
          "countryid": "GR",
          "countryname": "Greece",
          "edition": "XX",
          "nationality": "Greek",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 139,
          "countryid": "GL",
          "countryname": "Greenland",
          "edition": "XX",
          "nationality": "Greenlander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 140,
          "countryid": "GD",
          "countryname": "Grenada",
          "edition": "XX",
          "nationality": "Grenadian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 141,
          "countryid": "GP",
          "countryname": "Guadeloupe",
          "edition": "XX",
          "nationality": "Guadeloupean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 142,
          "countryid": "GU",
          "countryname": "Guam",
          "edition": "XX",
          "nationality": "Guamanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 143,
          "countryid": "GT",
          "countryname": "Guatemala",
          "edition": "XX",
          "nationality": "Guatemalan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 144,
          "countryid": "GG",
          "countryname": "Guernsey",
          "edition": "XX",
          "nationality": "British (Guernsey)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 145,
          "countryid": "GN",
          "countryname": "Guinea",
          "edition": "XX",
          "nationality": "Guinean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 146,
          "countryid": "GW",
          "countryname": "Guinea-Bissau",
          "edition": "XX",
          "nationality": "Guinea-Bissau national",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 147,
          "countryid": "GY",
          "countryname": "Guyana",
          "edition": "XX",
          "nationality": "Guyanese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 148,
          "countryid": "HT",
          "countryname": "Haiti",
          "edition": "XX",
          "nationality": "Haitian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 149,
          "countryid": "HM",
          "countryname": "Heard and McDonald Islands",
          "edition": "XX",
          "nationality": "Australian (Heard and McDonald Islands)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 150,
          "countryid": "VA",
          "countryname": "Holy See (City Vatican State)",
          "edition": "XX",
          "nationality": "Vatican",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 151,
          "countryid": "HN",
          "countryname": "Honduras",
          "edition": "XX",
          "nationality": "Honduran",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 152,
          "countryid": "HK",
          "countryname": "Hong Kong",
          "edition": "XX",
          "nationality": "Hong Kong Chinese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 153,
          "countryid": "HU",
          "countryname": "Hungary",
          "edition": "XX",
          "nationality": "Hungarian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 154,
          "countryid": "IS",
          "countryname": "Iceland",
          "edition": "XX",
          "nationality": "Icelander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 155,
          "countryid": "IN",
          "countryname": "India",
          "edition": "XX",
          "nationality": "Indian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 156,
          "countryid": "ID",
          "countryname": "Indonesia",
          "edition": "XX",
          "nationality": "Indonesian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 157,
          "countryid": "IR",
          "countryname": "Iran (Islamic Republic of)",
          "edition": "XX",
          "nationality": "Iranian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 158,
          "countryid": "IQ",
          "countryname": "Iraq",
          "edition": "XX",
          "nationality": "Iraqi",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 159,
          "countryid": "IE",
          "countryname": "Ireland",
          "edition": "XX",
          "nationality": "Irish",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 160,
          "countryid": "IM",
          "countryname": "Isle of Man",
          "edition": "XX",
          "nationality": "British (Isle of Man)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 161,
          "countryid": "IL",
          "countryname": "Israel",
          "edition": "XX",
          "nationality": "Israeli",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 162,
          "countryid": "IT",
          "countryname": "Italy",
          "edition": "XX",
          "nationality": "Italian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 163,
          "countryid": "JM",
          "countryname": "Jamaica",
          "edition": "XX",
          "nationality": "Jamaican",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 164,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 723,
          "stateshortname": "三重県",
          "statefullname": "Mie"
     },
     {
          "rownumber": 165,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 725,
          "stateshortname": "京都府",
          "statefullname": "Kyoto"
     },
     {
          "rownumber": 166,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 740,
          "stateshortname": "佐賀県",
          "statefullname": "Saga"
     },
     {
          "rownumber": 167,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 727,
          "stateshortname": "兵庫県",
          "statefullname": "Hyōgo"
     },
     {
          "rownumber": 168,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 700,
          "stateshortname": "北海道",
          "statefullname": "Hokkaidō"
     },
     {
          "rownumber": 169,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 711,
          "stateshortname": "千葉県",
          "statefullname": "Chiba"
     },
     {
          "rownumber": 170,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 729,
          "stateshortname": "和歌山県",
          "statefullname": "Wakayama"
     },
     {
          "rownumber": 171,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 710,
          "stateshortname": "埼玉県",
          "statefullname": "Saitama"
     },
     {
          "rownumber": 172,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 743,
          "stateshortname": "大分県",
          "statefullname": "Ōita"
     },
     {
          "rownumber": 173,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 726,
          "stateshortname": "大阪府",
          "statefullname": "Osaka"
     },
     {
          "rownumber": 174,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 728,
          "stateshortname": "奈良県",
          "statefullname": "Nara"
     },
     {
          "rownumber": 175,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 703,
          "stateshortname": "宮城県",
          "statefullname": "Miyagi"
     },
     {
          "rownumber": 176,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 744,
          "stateshortname": "宮崎県",
          "statefullname": "Miyazaki"
     },
     {
          "rownumber": 177,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 715,
          "stateshortname": "富山県",
          "statefullname": "Toyama"
     },
     {
          "rownumber": 178,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 734,
          "stateshortname": "山口県",
          "statefullname": "Yamaguchi"
     },
     {
          "rownumber": 179,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 705,
          "stateshortname": "山形県",
          "statefullname": "Yamagata"
     },
     {
          "rownumber": 180,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 718,
          "stateshortname": "山梨県",
          "statefullname": "Yamanashi"
     },
     {
          "rownumber": 181,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 720,
          "stateshortname": "岐阜県",
          "statefullname": "Gifu"
     },
     {
          "rownumber": 182,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 732,
          "stateshortname": "岡山県",
          "statefullname": "Okayama"
     },
     {
          "rownumber": 183,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 702,
          "stateshortname": "岩手県",
          "statefullname": "Iwate"
     },
     {
          "rownumber": 184,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 731,
          "stateshortname": "島根県",
          "statefullname": "Shimane"
     },
     {
          "rownumber": 185,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 733,
          "stateshortname": "広島県",
          "statefullname": "Hiroshima"
     },
     {
          "rownumber": 186,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 735,
          "stateshortname": "徳島県",
          "statefullname": "Tokushima"
     },
     {
          "rownumber": 187,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 737,
          "stateshortname": "愛媛県",
          "statefullname": "Ehime"
     },
     {
          "rownumber": 188,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 722,
          "stateshortname": "愛知県",
          "statefullname": "Aichi"
     },
     {
          "rownumber": 189,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 714,
          "stateshortname": "新潟県",
          "statefullname": "Niigata"
     },
     {
          "rownumber": 190,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 712,
          "stateshortname": "東京都",
          "statefullname": "Tokyo"
     },
     {
          "rownumber": 191,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 708,
          "stateshortname": "栃木県",
          "statefullname": "Tochigi"
     },
     {
          "rownumber": 192,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 746,
          "stateshortname": "沖縄県",
          "statefullname": "Okinawa"
     },
     {
          "rownumber": 193,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 724,
          "stateshortname": "滋賀県",
          "statefullname": "Shiga"
     },
     {
          "rownumber": 194,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 742,
          "stateshortname": "熊本県",
          "statefullname": "Kumamoto"
     },
     {
          "rownumber": 195,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 716,
          "stateshortname": "石川県",
          "statefullname": "Ishikawa"
     },
     {
          "rownumber": 196,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 713,
          "stateshortname": "神奈川県",
          "statefullname": "Kanagawa"
     },
     {
          "rownumber": 197,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 717,
          "stateshortname": "福井県",
          "statefullname": "Fukui"
     },
     {
          "rownumber": 198,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 739,
          "stateshortname": "福岡県",
          "statefullname": "Fukuoka"
     },
     {
          "rownumber": 199,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 706,
          "stateshortname": "福島県",
          "statefullname": "Fukushima"
     },
     {
          "rownumber": 200,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 704,
          "stateshortname": "秋田県",
          "statefullname": "Akita"
     },
     {
          "rownumber": 201,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 709,
          "stateshortname": "群馬県",
          "statefullname": "Gunma"
     },
     {
          "rownumber": 202,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 707,
          "stateshortname": "茨城県",
          "statefullname": "Ibaraki"
     },
     {
          "rownumber": 203,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 741,
          "stateshortname": "長崎県",
          "statefullname": "Nagasaki"
     },
     {
          "rownumber": 204,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 719,
          "stateshortname": "長野県",
          "statefullname": "Nagano"
     },
     {
          "rownumber": 205,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 701,
          "stateshortname": "青森県",
          "statefullname": "Aomori"
     },
     {
          "rownumber": 206,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 721,
          "stateshortname": "静岡県",
          "statefullname": "Shizuoka"
     },
     {
          "rownumber": 207,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 736,
          "stateshortname": "香川県",
          "statefullname": "Kagawa"
     },
     {
          "rownumber": 208,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 738,
          "stateshortname": "高知県",
          "statefullname": "Kochi"
     },
     {
          "rownumber": 209,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 730,
          "stateshortname": "鳥取県",
          "statefullname": "Tottori"
     },
     {
          "rownumber": 210,
          "countryid": "JP",
          "countryname": "Japan",
          "edition": "JP",
          "nationality": "Japanese",
          "stateid": 745,
          "stateshortname": "鹿児島県",
          "statefullname": "Kagoshima"
     },
     {
          "rownumber": 211,
          "countryid": "JE",
          "countryname": "Jersey",
          "edition": "XX",
          "nationality": "British (Jersey)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 212,
          "countryid": "JO",
          "countryname": "Jordan",
          "edition": "XX",
          "nationality": "Jordanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 213,
          "countryid": "KZ",
          "countryname": "Kazakhstan",
          "edition": "XX",
          "nationality": "Kazakh",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 214,
          "countryid": "KE",
          "countryname": "Kenya",
          "edition": "XX",
          "nationality": "Kenyan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 215,
          "countryid": "KI",
          "countryname": "Kiribati",
          "edition": "XX",
          "nationality": "Kiribatian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 216,
          "countryid": "KP",
          "countryname": "Korea, Democratic People's Republic",
          "edition": "XX",
          "nationality": "North Korean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 217,
          "countryid": "KR",
          "countryname": "Korea, Republic of",
          "edition": "XX",
          "nationality": "South Korean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 218,
          "countryid": "XK",
          "countryname": "Kosovo",
          "edition": "XX",
          "nationality": "Kosovar",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 219,
          "countryid": "KW",
          "countryname": "Kuwait",
          "edition": "XX",
          "nationality": "Kuwaiti",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 220,
          "countryid": "KG",
          "countryname": "Kyrgyzstan",
          "edition": "XX",
          "nationality": "Kyrgyz",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 221,
          "countryid": "LA",
          "countryname": "Lao People's Democratic Republic",
          "edition": "XX",
          "nationality": "Laotian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 222,
          "countryid": "LV",
          "countryname": "Latvia",
          "edition": "XX",
          "nationality": "Latvian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 223,
          "countryid": "LB",
          "countryname": "Lebanon",
          "edition": "XX",
          "nationality": "Lebanese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 224,
          "countryid": "LS",
          "countryname": "Lesotho",
          "edition": "XX",
          "nationality": "Basotho",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 225,
          "countryid": "LR",
          "countryname": "Liberia",
          "edition": "XX",
          "nationality": "Liberian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 226,
          "countryid": "LY",
          "countryname": "Libya",
          "edition": "XX",
          "nationality": "Libyan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 227,
          "countryid": "LI",
          "countryname": "Liechtenstein",
          "edition": "XX",
          "nationality": "Liechtensteiner",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 228,
          "countryid": "LT",
          "countryname": "Lithuania",
          "edition": "XX",
          "nationality": "Lithuanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 229,
          "countryid": "LU",
          "countryname": "Luxembourg",
          "edition": "XX",
          "nationality": "Luxembourger",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 230,
          "countryid": "MO",
          "countryname": "Macau",
          "edition": "XX",
          "nationality": "Macanese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 231,
          "countryid": "MK",
          "countryname": "Macedonia",
          "edition": "XX",
          "nationality": "Macedonian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 232,
          "countryid": "MG",
          "countryname": "Madagascar",
          "edition": "XX",
          "nationality": "Malagasy",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 233,
          "countryid": "MW",
          "countryname": "Malawi",
          "edition": "XX",
          "nationality": "Malawian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 234,
          "countryid": "MY",
          "countryname": "Malaysia",
          "edition": "XX",
          "nationality": "Malaysian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 235,
          "countryid": "MV",
          "countryname": "Maldives",
          "edition": "XX",
          "nationality": "Maldivian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 236,
          "countryid": "ML",
          "countryname": "Mali",
          "edition": "XX",
          "nationality": "Malian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 237,
          "countryid": "MT",
          "countryname": "Malta",
          "edition": "XX",
          "nationality": "Maltese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 238,
          "countryid": "MH",
          "countryname": "Marshall Islands",
          "edition": "XX",
          "nationality": "Marshallese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 239,
          "countryid": "MQ",
          "countryname": "Martinique",
          "edition": "XX",
          "nationality": "Martinican",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 240,
          "countryid": "MR",
          "countryname": "Mauritania",
          "edition": "XX",
          "nationality": "Mauritanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 241,
          "countryid": "MU",
          "countryname": "Mauritius",
          "edition": "XX",
          "nationality": "Mauritian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 242,
          "countryid": "YT",
          "countryname": "Mayotte",
          "edition": "XX",
          "nationality": "Mahorais",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 243,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 500,
          "stateshortname": "AGS",
          "statefullname": "Aguascalientes"
     },
     {
          "rownumber": 244,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 532,
          "stateshortname": "BC",
          "statefullname": "Baja California"
     },
     {
          "rownumber": 245,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 501,
          "stateshortname": "BCN",
          "statefullname": "Baja California Norte (obsolete)"
     },
     {
          "rownumber": 246,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 502,
          "stateshortname": "BCS",
          "statefullname": "Baja California Sur"
     },
     {
          "rownumber": 247,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 503,
          "stateshortname": "CAM",
          "statefullname": "Campeche"
     },
     {
          "rownumber": 248,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 533,
          "stateshortname": "CDMX",
          "statefullname": "Mexico City"
     },
     {
          "rownumber": 249,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 505,
          "stateshortname": "CHIH",
          "statefullname": "Chihuahua"
     },
     {
          "rownumber": 250,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 504,
          "stateshortname": "CHIS",
          "statefullname": "Chiapas"
     },
     {
          "rownumber": 251,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 506,
          "stateshortname": "COAH",
          "statefullname": "Coahuila"
     },
     {
          "rownumber": 252,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 507,
          "stateshortname": "COL",
          "statefullname": "Colima"
     },
     {
          "rownumber": 253,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 508,
          "stateshortname": "DF",
          "statefullname": "Distrito Federal (obsolete)"
     },
     {
          "rownumber": 254,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 509,
          "stateshortname": "DGO",
          "statefullname": "Durango"
     },
     {
          "rownumber": 255,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 511,
          "stateshortname": "GRO",
          "statefullname": "Guerrero"
     },
     {
          "rownumber": 256,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 510,
          "stateshortname": "GTO",
          "statefullname": "Guanajuato"
     },
     {
          "rownumber": 257,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 512,
          "stateshortname": "HGO",
          "statefullname": "Hidalgo"
     },
     {
          "rownumber": 258,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 513,
          "stateshortname": "JAL",
          "statefullname": "Jalisco"
     },
     {
          "rownumber": 259,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 514,
          "stateshortname": "MEX",
          "statefullname": "México (Estado de)"
     },
     {
          "rownumber": 260,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 515,
          "stateshortname": "MICH",
          "statefullname": "Michoacán"
     },
     {
          "rownumber": 261,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 516,
          "stateshortname": "MOR",
          "statefullname": "Morelos"
     },
     {
          "rownumber": 262,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 517,
          "stateshortname": "NAY",
          "statefullname": "Nayarit"
     },
     {
          "rownumber": 263,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 518,
          "stateshortname": "NL",
          "statefullname": "Nuevo León"
     },
     {
          "rownumber": 264,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 519,
          "stateshortname": "OAX",
          "statefullname": "Oaxaca"
     },
     {
          "rownumber": 265,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 520,
          "stateshortname": "PUE",
          "statefullname": "Puebla"
     },
     {
          "rownumber": 266,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 521,
          "stateshortname": "QRO",
          "statefullname": "Querétaro"
     },
     {
          "rownumber": 267,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 522,
          "stateshortname": "QROO",
          "statefullname": "Quintana Roo"
     },
     {
          "rownumber": 268,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 524,
          "stateshortname": "SIN",
          "statefullname": "Sinaloa"
     },
     {
          "rownumber": 269,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 523,
          "stateshortname": "SLP",
          "statefullname": "San Luis Potosí"
     },
     {
          "rownumber": 270,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 525,
          "stateshortname": "SON",
          "statefullname": "Sonora"
     },
     {
          "rownumber": 271,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 526,
          "stateshortname": "TAB",
          "statefullname": "Tabasco"
     },
     {
          "rownumber": 272,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 527,
          "stateshortname": "TAMPS",
          "statefullname": "Tamaulipas"
     },
     {
          "rownumber": 273,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 528,
          "stateshortname": "TLAX",
          "statefullname": "Tlaxcala"
     },
     {
          "rownumber": 274,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 529,
          "stateshortname": "VER",
          "statefullname": "Veracruz"
     },
     {
          "rownumber": 275,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 530,
          "stateshortname": "YUC",
          "statefullname": "Yucatán"
     },
     {
          "rownumber": 276,
          "countryid": "MX",
          "countryname": "Mexico",
          "edition": "XX",
          "nationality": "Mexican",
          "stateid": 531,
          "stateshortname": "ZAC",
          "statefullname": "Zacatecas"
     },
     {
          "rownumber": 277,
          "countryid": "FM",
          "countryname": "Micronesia, Federal State of",
          "edition": "XX",
          "nationality": "Micronesian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 278,
          "countryid": "MD",
          "countryname": "Moldova, Republic of",
          "edition": "XX",
          "nationality": "Moldovan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 279,
          "countryid": "MC",
          "countryname": "Monaco",
          "edition": "XX",
          "nationality": "Monegasque",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 280,
          "countryid": "MN",
          "countryname": "Mongolia",
          "edition": "XX",
          "nationality": "Mongolian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 281,
          "countryid": "ME",
          "countryname": "Montenegro",
          "edition": "XX",
          "nationality": "Montenegrian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 282,
          "countryid": "MS",
          "countryname": "Montserrat",
          "edition": "XX",
          "nationality": "Montserratian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 283,
          "countryid": "MA",
          "countryname": "Morocco",
          "edition": "XX",
          "nationality": "Moroccan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 284,
          "countryid": "MZ",
          "countryname": "Mozambique",
          "edition": "XX",
          "nationality": "Mozambican",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 285,
          "countryid": "MM",
          "countryname": "Myanmar (Burma)",
          "edition": "XX",
          "nationality": "Myanmarese (Burmese)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 286,
          "countryid": "NA",
          "countryname": "Namibia",
          "edition": "XX",
          "nationality": "Namibian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 287,
          "countryid": "NR",
          "countryname": "Nauru",
          "edition": "XX",
          "nationality": "Nauruan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 288,
          "countryid": "NP",
          "countryname": "Nepal",
          "edition": "XX",
          "nationality": "Nepalese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 289,
          "countryid": "NL",
          "countryname": "Netherlands",
          "edition": "XX",
          "nationality": "Dutch",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 290,
          "countryid": "AN",
          "countryname": "Netherlands Antilles (Deprecated)",
          "edition": "XX",
          "nationality": "Antillean (Deprecated)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 291,
          "countryid": "NC",
          "countryname": "New Caledonia",
          "edition": "XX",
          "nationality": "New Caledonian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 292,
          "countryid": "NZ",
          "countryname": "New Zealand",
          "edition": "XX",
          "nationality": "New Zealander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 293,
          "countryid": "NI",
          "countryname": "Nicaragua",
          "edition": "XX",
          "nationality": "Nicaraguan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 294,
          "countryid": "NE",
          "countryname": "Niger",
          "edition": "XX",
          "nationality": "Nigerien",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 295,
          "countryid": "NG",
          "countryname": "Nigeria",
          "edition": "XX",
          "nationality": "Nigerian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 296,
          "countryid": "NU",
          "countryname": "Niue",
          "edition": "XX",
          "nationality": "Niuean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 297,
          "countryid": "NF",
          "countryname": "Norfolk Island",
          "edition": "XX",
          "nationality": "Norfolk Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 298,
          "countryid": "MP",
          "countryname": "Northern Mariana Islands",
          "edition": "XX",
          "nationality": "Northern Mariana Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 299,
          "countryid": "NO",
          "countryname": "Norway",
          "edition": "XX",
          "nationality": "Norwegian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 300,
          "countryid": "OM",
          "countryname": "Oman",
          "edition": "XX",
          "nationality": "Omani",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 301,
          "countryid": "PK",
          "countryname": "Pakistan",
          "edition": "XX",
          "nationality": "Pakistani",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 302,
          "countryid": "PW",
          "countryname": "Palau",
          "edition": "XX",
          "nationality": "Palauan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 303,
          "countryid": "PA",
          "countryname": "Panama",
          "edition": "XX",
          "nationality": "Panamanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 304,
          "countryid": "PG",
          "countryname": "Papua New Guinea",
          "edition": "XX",
          "nationality": "Papua New Guinean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 305,
          "countryid": "PY",
          "countryname": "Paraguay",
          "edition": "XX",
          "nationality": "Paraguayan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 306,
          "countryid": "PE",
          "countryname": "Peru",
          "edition": "XX",
          "nationality": "Peruvian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 307,
          "countryid": "PH",
          "countryname": "Philippines",
          "edition": "XX",
          "nationality": "Filipino",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 308,
          "countryid": "PN",
          "countryname": "Pitcairn Island",
          "edition": "XX",
          "nationality": "Pitcairner",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 309,
          "countryid": "PL",
          "countryname": "Poland",
          "edition": "XX",
          "nationality": "Polish",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 310,
          "countryid": "PT",
          "countryname": "Portugal",
          "edition": "XX",
          "nationality": "Portuguese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 311,
          "countryid": "PR",
          "countryname": "Puerto Rico",
          "edition": "XX",
          "nationality": "Puerto Rican",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 312,
          "countryid": "QA",
          "countryname": "Qatar",
          "edition": "XX",
          "nationality": "Qatari",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 313,
          "countryid": "RE",
          "countryname": "Reunion Island",
          "edition": "XX",
          "nationality": "French (Reunion Island)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 314,
          "countryid": "RO",
          "countryname": "Romania",
          "edition": "XX",
          "nationality": "Romanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 315,
          "countryid": "RU",
          "countryname": "Russian Federation",
          "edition": "XX",
          "nationality": "Russian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 316,
          "countryid": "RW",
          "countryname": "Rwanda",
          "edition": "XX",
          "nationality": "Rwandan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 317,
          "countryid": "BL",
          "countryname": "Saint Barthélemy",
          "edition": "XX",
          "nationality": "French (Saint Barthélemy)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 318,
          "countryid": "SH",
          "countryname": "Saint Helena",
          "edition": "XX",
          "nationality": "Saint Helenian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 319,
          "countryid": "KN",
          "countryname": "Saint Kitts and Nevis",
          "edition": "XX",
          "nationality": "Saint Kitts and Nevis national",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 320,
          "countryid": "LC",
          "countryname": "Saint Lucia",
          "edition": "XX",
          "nationality": "Saint Lucian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 321,
          "countryid": "MF",
          "countryname": "Saint Martin",
          "edition": "XX",
          "nationality": "French (Saint Martin)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 322,
          "countryid": "VC",
          "countryname": "Saint Vincent and the Grenadines",
          "edition": "XX",
          "nationality": "Vincentian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 323,
          "countryid": "WS",
          "countryname": "Samoa",
          "edition": "XX",
          "nationality": "Samoan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 324,
          "countryid": "SM",
          "countryname": "San Marino",
          "edition": "XX",
          "nationality": "San Marinese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 325,
          "countryid": "ST",
          "countryname": "Sao Tome and Principe",
          "edition": "XX",
          "nationality": "São Toméan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 326,
          "countryid": "SA",
          "countryname": "Saudi Arabia",
          "edition": "XX",
          "nationality": "Saudi Arabian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 327,
          "countryid": "SN",
          "countryname": "Senegal",
          "edition": "XX",
          "nationality": "Senegalese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 328,
          "countryid": "RS",
          "countryname": "Serbia",
          "edition": "XX",
          "nationality": "Serbian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 329,
          "countryid": "CS",
          "countryname": "Serbia and Montenegro (Deprecated)",
          "edition": "XX",
          "nationality": "Yugoslav (Deprecated)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 330,
          "countryid": "SC",
          "countryname": "Seychelles",
          "edition": "XX",
          "nationality": "Seychellois",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 331,
          "countryid": "SL",
          "countryname": "Sierra Leone",
          "edition": "XX",
          "nationality": "Sierra Leonean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 332,
          "countryid": "SG",
          "countryname": "Singapore",
          "edition": "XX",
          "nationality": "Singaporean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 333,
          "countryid": "SX",
          "countryname": "Sint Maarten",
          "edition": "XX",
          "nationality": "Dutch (Sint Maarten)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 334,
          "countryid": "SK",
          "countryname": "Slovak Republic",
          "edition": "XX",
          "nationality": "Slovak",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 335,
          "countryid": "SI",
          "countryname": "Slovenia",
          "edition": "XX",
          "nationality": "Slovene",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 336,
          "countryid": "SB",
          "countryname": "Solomon Islands",
          "edition": "XX",
          "nationality": "Solomon Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 337,
          "countryid": "SO",
          "countryname": "Somalia",
          "edition": "XX",
          "nationality": "Somali",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 338,
          "countryid": "ZA",
          "countryname": "South Africa",
          "edition": "XX",
          "nationality": "South African",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 339,
          "countryid": "GS",
          "countryname": "South Georgia",
          "edition": "XX",
          "nationality": "British (South Georgia)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 340,
          "countryid": "SS",
          "countryname": "South Sudan",
          "edition": "XX",
          "nationality": "South Sudanese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 341,
          "countryid": "ES",
          "countryname": "Spain",
          "edition": "XX",
          "nationality": "Spanish",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 342,
          "countryid": "LK",
          "countryname": "Sri Lanka",
          "edition": "XX",
          "nationality": "Sri Lankan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 343,
          "countryid": "PM",
          "countryname": "St. Pierre and Miquelon",
          "edition": "XX",
          "nationality": "Saint Pierre and Miquelon national",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 344,
          "countryid": "PS",
          "countryname": "State of Palestine",
          "edition": "XX",
          "nationality": "Palestinian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 345,
          "countryid": "SD",
          "countryname": "Sudan",
          "edition": "XX",
          "nationality": "Sudanese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 346,
          "countryid": "SR",
          "countryname": "Suriname",
          "edition": "XX",
          "nationality": "Surinamer",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 347,
          "countryid": "SJ",
          "countryname": "Svalbard and Jan Mayen Islands",
          "edition": "XX",
          "nationality": "Norwegian (Svalbard and Jan Mayen Islands)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 348,
          "countryid": "SZ",
          "countryname": "Swaziland",
          "edition": "XX",
          "nationality": "Swazi",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 349,
          "countryid": "SE",
          "countryname": "Sweden",
          "edition": "XX",
          "nationality": "Swedish",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 350,
          "countryid": "CH",
          "countryname": "Switzerland",
          "edition": "XX",
          "nationality": "Swiss",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 351,
          "countryid": "SY",
          "countryname": "Syrian Arab Republic",
          "edition": "XX",
          "nationality": "Syrian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 352,
          "countryid": "TW",
          "countryname": "Taiwan",
          "edition": "XX",
          "nationality": "Taiwanese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 353,
          "countryid": "TJ",
          "countryname": "Tajikistan",
          "edition": "XX",
          "nationality": "Tajik",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 354,
          "countryid": "TZ",
          "countryname": "Tanzania",
          "edition": "XX",
          "nationality": "Tanzanian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 355,
          "countryid": "TH",
          "countryname": "Thailand",
          "edition": "XX",
          "nationality": "Thai",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 356,
          "countryid": "TG",
          "countryname": "Togo",
          "edition": "XX",
          "nationality": "Togolese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 357,
          "countryid": "TK",
          "countryname": "Tokelau",
          "edition": "XX",
          "nationality": "Tokelauan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 358,
          "countryid": "TO",
          "countryname": "Tonga",
          "edition": "XX",
          "nationality": "Tongan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 359,
          "countryid": "TT",
          "countryname": "Trinidad and Tobago",
          "edition": "XX",
          "nationality": "Trinidad and Tobago national",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 360,
          "countryid": "TN",
          "countryname": "Tunisia",
          "edition": "XX",
          "nationality": "Tunisian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 361,
          "countryid": "TR",
          "countryname": "Turkey",
          "edition": "XX",
          "nationality": "Turkish",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 362,
          "countryid": "TM",
          "countryname": "Turkmenistan",
          "edition": "XX",
          "nationality": "Turkmen",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 363,
          "countryid": "TC",
          "countryname": "Turks and Caicos Islands",
          "edition": "XX",
          "nationality": "Turks and Caicos Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 364,
          "countryid": "TV",
          "countryname": "Tuvalu",
          "edition": "XX",
          "nationality": "Tuvaluan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 365,
          "countryid": "UM",
          "countryname": "US Minor Outlying Islands",
          "edition": "XX",
          "nationality": "American (US Minor Outlying Islands)",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 366,
          "countryid": "UG",
          "countryname": "Uganda",
          "edition": "XX",
          "nationality": "Ugandan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 367,
          "countryid": "UA",
          "countryname": "Ukraine",
          "edition": "XX",
          "nationality": "Ukrainian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 368,
          "countryid": "AE",
          "countryname": "United Arab Emirates",
          "edition": "XX",
          "nationality": "Emirian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 369,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 201,
          "stateshortname": "Aberdeenshire",
          "statefullname": "Aberdeenshire"
     },
     {
          "rownumber": 370,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 202,
          "stateshortname": "Angus",
          "statefullname": "Angus"
     },
     {
          "rownumber": 371,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 203,
          "stateshortname": "Argyll",
          "statefullname": "Argyll"
     },
     {
          "rownumber": 372,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 204,
          "stateshortname": "Avon",
          "statefullname": "Avon"
     },
     {
          "rownumber": 373,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 205,
          "stateshortname": "Ayrshire",
          "statefullname": "Ayrshire"
     },
     {
          "rownumber": 374,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 206,
          "stateshortname": "Banffshire",
          "statefullname": "Banffshire"
     },
     {
          "rownumber": 375,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 207,
          "stateshortname": "Beds.",
          "statefullname": "Bedfordshire"
     },
     {
          "rownumber": 376,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 208,
          "stateshortname": "Berks.",
          "statefullname": "Berkshire"
     },
     {
          "rownumber": 377,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 209,
          "stateshortname": "Berwickshire",
          "statefullname": "Berwickshire"
     },
     {
          "rownumber": 378,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 210,
          "stateshortname": "Bucks.",
          "statefullname": "Buckinghamshire"
     },
     {
          "rownumber": 379,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 211,
          "stateshortname": "Caithness",
          "statefullname": "Caithness"
     },
     {
          "rownumber": 380,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 212,
          "stateshortname": "Cambs.",
          "statefullname": "Cambridgeshire"
     },
     {
          "rownumber": 381,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 213,
          "stateshortname": "Ches.",
          "statefullname": "Cheshire"
     },
     {
          "rownumber": 382,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 214,
          "stateshortname": "Clackmannanshire",
          "statefullname": "Clackmannanshire"
     },
     {
          "rownumber": 383,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 215,
          "stateshortname": "Cleveland",
          "statefullname": "Cleveland"
     },
     {
          "rownumber": 384,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 216,
          "stateshortname": "Clwyd",
          "statefullname": "Clwyd"
     },
     {
          "rownumber": 385,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 218,
          "stateshortname": "Co Antrim",
          "statefullname": "County Antrim"
     },
     {
          "rownumber": 386,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 219,
          "stateshortname": "Co Armagh",
          "statefullname": "County Armagh"
     },
     {
          "rownumber": 387,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 220,
          "stateshortname": "Co Down",
          "statefullname": "County Down"
     },
     {
          "rownumber": 388,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 221,
          "stateshortname": "Co Fermanagh",
          "statefullname": "County Fermanagh"
     },
     {
          "rownumber": 389,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 222,
          "stateshortname": "Co Londonderry",
          "statefullname": "County Londonderry"
     },
     {
          "rownumber": 390,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 223,
          "stateshortname": "Co Tyrone",
          "statefullname": "County Tyrone"
     },
     {
          "rownumber": 391,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 217,
          "stateshortname": "Cornwall",
          "statefullname": "Cornwall"
     },
     {
          "rownumber": 392,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 225,
          "stateshortname": "Cumbria",
          "statefullname": "Cumbria"
     },
     {
          "rownumber": 393,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 226,
          "stateshortname": "Derbys.",
          "statefullname": "Derbyshire"
     },
     {
          "rownumber": 394,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 227,
          "stateshortname": "Devon",
          "statefullname": "Devon"
     },
     {
          "rownumber": 395,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 228,
          "stateshortname": "Dorset",
          "statefullname": "Dorset"
     },
     {
          "rownumber": 396,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 229,
          "stateshortname": "Dumfriesshire",
          "statefullname": "Dumfriesshire"
     },
     {
          "rownumber": 397,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 230,
          "stateshortname": "Dunbartonshire",
          "statefullname": "Dunbartonshire"
     },
     {
          "rownumber": 398,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 231,
          "stateshortname": "Durham",
          "statefullname": "County Durham"
     },
     {
          "rownumber": 399,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 232,
          "stateshortname": "Dyfed",
          "statefullname": "Dyfed"
     },
     {
          "rownumber": 400,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 234,
          "stateshortname": "E Lothian",
          "statefullname": "East Lothian"
     },
     {
          "rownumber": 401,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 233,
          "stateshortname": "E Sussex",
          "statefullname": "East Sussex"
     },
     {
          "rownumber": 402,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 235,
          "stateshortname": "Essex",
          "statefullname": "Essex"
     },
     {
          "rownumber": 403,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 236,
          "stateshortname": "Fife",
          "statefullname": "Fife"
     },
     {
          "rownumber": 404,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 237,
          "stateshortname": "Gloucs.",
          "statefullname": "Gloucestershire"
     },
     {
          "rownumber": 405,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 239,
          "stateshortname": "Gwent",
          "statefullname": "Gwent"
     },
     {
          "rownumber": 406,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 240,
          "stateshortname": "Gwynedd",
          "statefullname": "Gwynedd"
     },
     {
          "rownumber": 407,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 241,
          "stateshortname": "Hants.",
          "statefullname": "Hampshire"
     },
     {
          "rownumber": 408,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 242,
          "stateshortname": "Hereford",
          "statefullname": "Herefordshire"
     },
     {
          "rownumber": 409,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 243,
          "stateshortname": "Herts.",
          "statefullname": "Hertfordshire"
     },
     {
          "rownumber": 410,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 245,
          "stateshortname": "Inverness-shire",
          "statefullname": "Inverness-shire"
     },
     {
          "rownumber": 411,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 246,
          "stateshortname": "Isle of Arran",
          "statefullname": "Isle of Arran"
     },
     {
          "rownumber": 412,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 247,
          "stateshortname": "Isle of Barra",
          "statefullname": "Isle of Barra"
     },
     {
          "rownumber": 413,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 248,
          "stateshortname": "Isle of Benbecula",
          "statefullname": "Isle of Benbecula"
     },
     {
          "rownumber": 414,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 249,
          "stateshortname": "Isle of Bute",
          "statefullname": "Isle of Bute"
     },
     {
          "rownumber": 415,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 250,
          "stateshortname": "Isle of Canna",
          "statefullname": "Isle of Canna"
     },
     {
          "rownumber": 416,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 251,
          "stateshortname": "Isle of Coll",
          "statefullname": "Isle of Coll"
     },
     {
          "rownumber": 417,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 252,
          "stateshortname": "Isle of Colonsay",
          "statefullname": "Isle of Colonsay"
     },
     {
          "rownumber": 418,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 253,
          "stateshortname": "Isle of Cumbrae",
          "statefullname": "Isle of Cumbrae"
     },
     {
          "rownumber": 419,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 254,
          "stateshortname": "Isle of Eigg",
          "statefullname": "Isle of Eigg"
     },
     {
          "rownumber": 420,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 255,
          "stateshortname": "Isle of Gigha",
          "statefullname": "Isle of Gigha"
     },
     {
          "rownumber": 421,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 256,
          "stateshortname": "Isle of Harris",
          "statefullname": "Isle of Harris"
     },
     {
          "rownumber": 422,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 258,
          "stateshortname": "Isle of Iona",
          "statefullname": "Isle of Iona"
     },
     {
          "rownumber": 423,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 257,
          "stateshortname": "Isle of Islay",
          "statefullname": "Isle of Islay"
     },
     {
          "rownumber": 424,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 259,
          "stateshortname": "Isle of Jura",
          "statefullname": "Isle of Jura"
     },
     {
          "rownumber": 425,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 260,
          "stateshortname": "Isle of Lewis",
          "statefullname": "Isle of Lewis"
     },
     {
          "rownumber": 426,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 261,
          "stateshortname": "Isle of Mull",
          "statefullname": "Isle of Mull"
     },
     {
          "rownumber": 427,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 262,
          "stateshortname": "Isle of North Uist",
          "statefullname": "Isle of North Uist"
     },
     {
          "rownumber": 428,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 263,
          "stateshortname": "Isle of Rum",
          "statefullname": "Isle of Rum"
     },
     {
          "rownumber": 429,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 264,
          "stateshortname": "Isle of Scalpay",
          "statefullname": "Isle of Scalpay"
     },
     {
          "rownumber": 430,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 265,
          "stateshortname": "Isle of Skye",
          "statefullname": "Isle of Skye"
     },
     {
          "rownumber": 431,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 266,
          "stateshortname": "Isle of South Uist",
          "statefullname": "Isle of South Uist"
     },
     {
          "rownumber": 432,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 267,
          "stateshortname": "Isle of Tiree",
          "statefullname": "Isle of Tiree"
     },
     {
          "rownumber": 433,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 268,
          "stateshortname": "Isle of Wight",
          "statefullname": "Isle of Wight"
     },
     {
          "rownumber": 434,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 269,
          "stateshortname": "Kent",
          "statefullname": "Kent"
     },
     {
          "rownumber": 435,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 270,
          "stateshortname": "Kincardineshire",
          "statefullname": "Kincardineshire"
     },
     {
          "rownumber": 436,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 271,
          "stateshortname": "Kinross-shire",
          "statefullname": "Kinross-shire"
     },
     {
          "rownumber": 437,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 272,
          "stateshortname": "Kirkcudbrightshire",
          "statefullname": "Kirkcudbrightshire"
     },
     {
          "rownumber": 438,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 273,
          "stateshortname": "Lanarkshire",
          "statefullname": "Lanarkshire"
     },
     {
          "rownumber": 439,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 274,
          "stateshortname": "Lancs.",
          "statefullname": "Lancashire"
     },
     {
          "rownumber": 440,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 275,
          "stateshortname": "Leics.",
          "statefullname": "Leicestershire"
     },
     {
          "rownumber": 441,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 276,
          "stateshortname": "Lincs.",
          "statefullname": "Lincolnshire"
     },
     {
          "rownumber": 442,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 238,
          "stateshortname": "London",
          "statefullname": "Greater London"
     },
     {
          "rownumber": 443,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 278,
          "stateshortname": "M Glam",
          "statefullname": "Mid Glamorgan"
     },
     {
          "rownumber": 444,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 277,
          "stateshortname": "Merseyside",
          "statefullname": "Merseyside"
     },
     {
          "rownumber": 445,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 279,
          "stateshortname": "Mid Lothian",
          "statefullname": "Mid Lothian"
     },
     {
          "rownumber": 446,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 280,
          "stateshortname": "Middx.",
          "statefullname": "Middlesex"
     },
     {
          "rownumber": 447,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 281,
          "stateshortname": "Morayshire",
          "statefullname": "Morayshire"
     },
     {
          "rownumber": 448,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 284,
          "stateshortname": "N Humberside",
          "statefullname": "North Humberside"
     },
     {
          "rownumber": 449,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 285,
          "stateshortname": "N Yorkshire",
          "statefullname": "North Yorkshire"
     },
     {
          "rownumber": 450,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 282,
          "stateshortname": "Nairnshire",
          "statefullname": "Nairnshire"
     },
     {
          "rownumber": 451,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 283,
          "stateshortname": "Norfolk",
          "statefullname": "Norfolk"
     },
     {
          "rownumber": 452,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 286,
          "stateshortname": "Northants.",
          "statefullname": "Northamptonshire"
     },
     {
          "rownumber": 453,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 287,
          "stateshortname": "Northumberland",
          "statefullname": "Northumberland"
     },
     {
          "rownumber": 454,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 288,
          "stateshortname": "Notts.",
          "statefullname": "Nottinghamshire"
     },
     {
          "rownumber": 455,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 289,
          "stateshortname": "Oxon.",
          "statefullname": "Oxfordshire"
     },
     {
          "rownumber": 456,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 290,
          "stateshortname": "Peeblesshire",
          "statefullname": "Peeblesshire"
     },
     {
          "rownumber": 457,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 291,
          "stateshortname": "Perthshire",
          "statefullname": "Perthshire"
     },
     {
          "rownumber": 458,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 292,
          "stateshortname": "Powys",
          "statefullname": "Powys"
     },
     {
          "rownumber": 459,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 293,
          "stateshortname": "Renfrewshire",
          "statefullname": "Renfrewshire"
     },
     {
          "rownumber": 460,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 294,
          "stateshortname": "Ross-shire",
          "statefullname": "Ross-shire"
     },
     {
          "rownumber": 461,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 295,
          "stateshortname": "Roxburghshire",
          "statefullname": "Roxburghshire"
     },
     {
          "rownumber": 462,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 300,
          "stateshortname": "S Glam",
          "statefullname": "South Glamorgan"
     },
     {
          "rownumber": 463,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 301,
          "stateshortname": "S Humberside",
          "statefullname": "South Humberside"
     },
     {
          "rownumber": 464,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 302,
          "stateshortname": "S Yorkshire",
          "statefullname": "South Yorkshire"
     },
     {
          "rownumber": 465,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 298,
          "stateshortname": "Selkirkshire",
          "statefullname": "Selkirkshire"
     },
     {
          "rownumber": 466,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 297,
          "stateshortname": "Shrops",
          "statefullname": "Shropshire"
     },
     {
          "rownumber": 467,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 299,
          "stateshortname": "Somt.",
          "statefullname": "Somerset"
     },
     {
          "rownumber": 468,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 303,
          "stateshortname": "Staffs.",
          "statefullname": "Staffordshire"
     },
     {
          "rownumber": 469,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 304,
          "stateshortname": "Stirlingshire",
          "statefullname": "Stirlingshire"
     },
     {
          "rownumber": 470,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 305,
          "stateshortname": "Suffolk",
          "statefullname": "Suffolk"
     },
     {
          "rownumber": 471,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 306,
          "stateshortname": "Surrey",
          "statefullname": "Surrey"
     },
     {
          "rownumber": 472,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 307,
          "stateshortname": "Sutherland",
          "statefullname": "Sutherland"
     },
     {
          "rownumber": 473,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 308,
          "stateshortname": "Tyne & Wear",
          "statefullname": "Tyne and Wear"
     },
     {
          "rownumber": 474,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 310,
          "stateshortname": "W Glam",
          "statefullname": "West Glamorgan"
     },
     {
          "rownumber": 475,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 311,
          "stateshortname": "W Lothian",
          "statefullname": "West Lothian"
     },
     {
          "rownumber": 476,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 312,
          "stateshortname": "W Midlands",
          "statefullname": "West Midlands"
     },
     {
          "rownumber": 477,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 313,
          "stateshortname": "W Sussex",
          "statefullname": "West Sussex"
     },
     {
          "rownumber": 478,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 314,
          "stateshortname": "W Yorkshire",
          "statefullname": "West Yorkshire"
     },
     {
          "rownumber": 479,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 309,
          "stateshortname": "Warks",
          "statefullname": "Warwickshire"
     },
     {
          "rownumber": 480,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 315,
          "stateshortname": "Wigtownshire",
          "statefullname": "Wigtownshire"
     },
     {
          "rownumber": 481,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 316,
          "stateshortname": "Wilts",
          "statefullname": "Wiltshire"
     },
     {
          "rownumber": 482,
          "countryid": "GB",
          "countryname": "United Kingdom",
          "edition": "UK",
          "nationality": "British",
          "stateid": 317,
          "stateshortname": "Worcs",
          "statefullname": "Worcestershire"
     },
     {
          "rownumber": 483,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 53,
          "stateshortname": "AA",
          "statefullname": "Armed Forces Americas"
     },
     {
          "rownumber": 484,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 52,
          "stateshortname": "AE",
          "statefullname": "Armed Forces Europe"
     },
     {
          "rownumber": 485,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 1,
          "stateshortname": "AK",
          "statefullname": "Alaska"
     },
     {
          "rownumber": 486,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 0,
          "stateshortname": "AL",
          "statefullname": "Alabama"
     },
     {
          "rownumber": 487,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 54,
          "stateshortname": "AP",
          "statefullname": "Armed Forces Pacific"
     },
     {
          "rownumber": 488,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 3,
          "stateshortname": "AR",
          "statefullname": "Arkansas"
     },
     {
          "rownumber": 489,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 2,
          "stateshortname": "AZ",
          "statefullname": "Arizona"
     },
     {
          "rownumber": 490,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 4,
          "stateshortname": "CA",
          "statefullname": "California"
     },
     {
          "rownumber": 491,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 5,
          "stateshortname": "CO",
          "statefullname": "Colorado"
     },
     {
          "rownumber": 492,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 6,
          "stateshortname": "CT",
          "statefullname": "Connecticut"
     },
     {
          "rownumber": 493,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 8,
          "stateshortname": "DC",
          "statefullname": "District of Columbia"
     },
     {
          "rownumber": 494,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 7,
          "stateshortname": "DE",
          "statefullname": "Delaware"
     },
     {
          "rownumber": 495,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 9,
          "stateshortname": "FL",
          "statefullname": "Florida"
     },
     {
          "rownumber": 496,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 10,
          "stateshortname": "GA",
          "statefullname": "Georgia"
     },
     {
          "rownumber": 497,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 11,
          "stateshortname": "HI",
          "statefullname": "Hawaii"
     },
     {
          "rownumber": 498,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 15,
          "stateshortname": "IA",
          "statefullname": "Iowa"
     },
     {
          "rownumber": 499,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 12,
          "stateshortname": "ID",
          "statefullname": "Idaho"
     },
     {
          "rownumber": 500,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 13,
          "stateshortname": "IL",
          "statefullname": "Illinois"
     },
     {
          "rownumber": 501,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 14,
          "stateshortname": "IN",
          "statefullname": "Indiana"
     },
     {
          "rownumber": 502,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 16,
          "stateshortname": "KS",
          "statefullname": "Kansas"
     },
     {
          "rownumber": 503,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 17,
          "stateshortname": "KY",
          "statefullname": "Kentucky"
     },
     {
          "rownumber": 504,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 18,
          "stateshortname": "LA",
          "statefullname": "Louisiana"
     },
     {
          "rownumber": 505,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 21,
          "stateshortname": "MA",
          "statefullname": "Massachusetts"
     },
     {
          "rownumber": 506,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 20,
          "stateshortname": "MD",
          "statefullname": "Maryland"
     },
     {
          "rownumber": 507,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 19,
          "stateshortname": "ME",
          "statefullname": "Maine"
     },
     {
          "rownumber": 508,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 22,
          "stateshortname": "MI",
          "statefullname": "Michigan"
     },
     {
          "rownumber": 509,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 23,
          "stateshortname": "MN",
          "statefullname": "Minnesota"
     },
     {
          "rownumber": 510,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 25,
          "stateshortname": "MO",
          "statefullname": "Missouri"
     },
     {
          "rownumber": 511,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 24,
          "stateshortname": "MS",
          "statefullname": "Mississippi"
     },
     {
          "rownumber": 512,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 26,
          "stateshortname": "MT",
          "statefullname": "Montana"
     },
     {
          "rownumber": 513,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 33,
          "stateshortname": "NC",
          "statefullname": "North Carolina"
     },
     {
          "rownumber": 514,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 34,
          "stateshortname": "ND",
          "statefullname": "North Dakota"
     },
     {
          "rownumber": 515,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 27,
          "stateshortname": "NE",
          "statefullname": "Nebraska"
     },
     {
          "rownumber": 516,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 29,
          "stateshortname": "NH",
          "statefullname": "New Hampshire"
     },
     {
          "rownumber": 517,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 30,
          "stateshortname": "NJ",
          "statefullname": "New Jersey"
     },
     {
          "rownumber": 518,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 31,
          "stateshortname": "NM",
          "statefullname": "New Mexico"
     },
     {
          "rownumber": 519,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 28,
          "stateshortname": "NV",
          "statefullname": "Nevada"
     },
     {
          "rownumber": 520,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 32,
          "stateshortname": "NY",
          "statefullname": "New York"
     },
     {
          "rownumber": 521,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 35,
          "stateshortname": "OH",
          "statefullname": "Ohio"
     },
     {
          "rownumber": 522,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 36,
          "stateshortname": "OK",
          "statefullname": "Oklahoma"
     },
     {
          "rownumber": 523,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 37,
          "stateshortname": "OR",
          "statefullname": "Oregon"
     },
     {
          "rownumber": 524,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 38,
          "stateshortname": "PA",
          "statefullname": "Pennsylvania"
     },
     {
          "rownumber": 525,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 39,
          "stateshortname": "PR",
          "statefullname": "Puerto Rico"
     },
     {
          "rownumber": 526,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 40,
          "stateshortname": "RI",
          "statefullname": "Rhode Island"
     },
     {
          "rownumber": 527,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 41,
          "stateshortname": "SC",
          "statefullname": "South Carolina"
     },
     {
          "rownumber": 528,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 42,
          "stateshortname": "SD",
          "statefullname": "South Dakota"
     },
     {
          "rownumber": 529,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 43,
          "stateshortname": "TN",
          "statefullname": "Tennessee"
     },
     {
          "rownumber": 530,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 44,
          "stateshortname": "TX",
          "statefullname": "Texas"
     },
     {
          "rownumber": 531,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 45,
          "stateshortname": "UT",
          "statefullname": "Utah"
     },
     {
          "rownumber": 532,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 47,
          "stateshortname": "VA",
          "statefullname": "Virginia"
     },
     {
          "rownumber": 533,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 46,
          "stateshortname": "VT",
          "statefullname": "Vermont"
     },
     {
          "rownumber": 534,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 48,
          "stateshortname": "WA",
          "statefullname": "Washington"
     },
     {
          "rownumber": 535,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 50,
          "stateshortname": "WI",
          "statefullname": "Wisconsin"
     },
     {
          "rownumber": 536,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 49,
          "stateshortname": "WV",
          "statefullname": "West Virginia"
     },
     {
          "rownumber": 537,
          "countryid": "US",
          "countryname": "United States",
          "edition": "US",
          "nationality": "American",
          "stateid": 51,
          "stateshortname": "WY",
          "statefullname": "Wyoming"
     },
     {
          "rownumber": 538,
          "countryid": "UY",
          "countryname": "Uruguay",
          "edition": "XX",
          "nationality": "Uruguayan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 539,
          "countryid": "UZ",
          "countryname": "Uzbekistan",
          "edition": "XX",
          "nationality": "Uzbek",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 540,
          "countryid": "VU",
          "countryname": "Vanuatu",
          "edition": "XX",
          "nationality": "Vanuatuan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 541,
          "countryid": "VE",
          "countryname": "Venezuela",
          "edition": "XX",
          "nationality": "Venezuelan",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 542,
          "countryid": "VN",
          "countryname": "Vietnam",
          "edition": "XX",
          "nationality": "Vietnamese",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 543,
          "countryid": "VG",
          "countryname": "Virgin Islands (British)",
          "edition": "XX",
          "nationality": "British Virgin Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 544,
          "countryid": "VI",
          "countryname": "Virgin Islands (USA)",
          "edition": "XX",
          "nationality": "US Virgin Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 545,
          "countryid": "WF",
          "countryname": "Wallis and Futuna",
          "edition": "XX",
          "nationality": "Wallis and Futuna Islander",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 546,
          "countryid": "EH",
          "countryname": "Western Sahara",
          "edition": "XX",
          "nationality": "Sahrawi",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 547,
          "countryid": "YE",
          "countryname": "Yemen",
          "edition": "XX",
          "nationality": "Yemeni",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 548,
          "countryid": "ZM",
          "countryname": "Zambia",
          "edition": "XX",
          "nationality": "Zambian",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     },
     {
          "rownumber": 549,
          "countryid": "ZW",
          "countryname": "Zimbabwe",
          "edition": "XX",
          "nationality": "Zimbabwean",
          "stateid": null,
          "stateshortname": null,
          "statefullname": null
     }
]
About Me

Hello, I’m Tim Dietrich. I design and build custom software for businesses running on NetSuite — from mobile apps and Web portals to Web APIs and integrations.

I’ve created several widely used open-source solutions for the NetSuite community, including the SuiteQL Query Tool and SuiteAPI, which help developers and businesses get more out of their systems.

I’m also the founder of SuiteStep, a NetSuite development studio focused on pushing the boundaries of what’s possible on the platform. Through SuiteStep, I deliver custom software and AI-driven solutions that make NetSuite more powerful, accessible, and future-ready.

Copyright © 2025 Tim Dietrich.