US Embassies database listing all US Embassies along with the Country and city each are in as well as the URL to the US government Embassy website.
US Embassies database table structure:
CountryRegion | City | Url
Actual MYSQL UUS Embassies sample:
INSERT INTO `usembassyurls` (`ID`, `CountryRegion`, `City`, `Url`) VALUES
(1, ´ CountryRegion´, ´City´, ´url´),
(2, ´ Albania´, ´Tirana´, ´http://tirana.usembassy.gov/´),
(3, ´ Algeria´, ´Algiers´, ´http://algiers.usembassy.gov/´),
(4, ´ Angola´, ´Luanda´, ´http://luanda.usembassy.gov/´),
(5, ´ Argentina´, ´Buenos Aires´, ´http://buenosaires.usembassy.gov/´),
(6, ´ Armenia´, ´Yerevan´, ´http://yerevan.usembassy.gov/´),
(7, ´ Australia´, ´Adelaide´, ´http://adelaide.usvpp.gov/Adelaide/´),
(8, ´ Australia´, ´Brisbane´, ´http://brisbane.usvpp.gov/Brisbane/´),
(9, ´ Australia´, ´Canberra´, ´http://canberra.usembassy.gov/´),
(10, ´ Australia´, ´Melbourne´, ´http://melbourne.usconsulate.gov/melbourne/index.html´),
File Types: MYSQL (.sql) - CSV (.csv) |