Published on July 1, 2021.
If you need lists of the countries and states that NetSuite supports, then these simple SuiteQL queries might help.
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
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.
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 } ]
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.