Navigation

Counties

As an ICANN-accredited domain registrar, Go Daddy has more names under management than any other registrar, offers products at prices up to 70% less than the competition and supports them all with world-class 24/7 live customer service.

Associated Databases

Countries

Provinces

UK towns

To view the whole dump, ( rows) you will need to upgrade your account

-- Table structure for table `counties`
--

CREATE TABLE `counties` (
`id` int(11) NOT NULL auto_increment,
`county` varchar(200) NOT NULL,
`province` int(11) NOT NULL,
`country` int(11) NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=739 DEFAULT CHARSET=latin1 AUTO_INCREMENT=739 ;

--
-- Dumping data for table `counties`
--

INSERT INTO `counties` (`id`, `county`, `province`, `country`) VALUES (1, 'Alameda', 246, 222),
(2, 'Alpine', 246, 222),
(3, 'Amador', 246, 222),
(4, 'Butte', 246, 222),
(5, 'Calaveras', 246, 222),
(6, 'California State Universities', 246, 222),
(7, 'Colusa', 246, 222),
(8, 'Contra Costa', 246, 222),
(9, 'Del Norte', 246, 222),
(10, 'El Dorado', 246, 222),
(11, 'Fresno', 246, 222),
(12, 'Glenn', 246, 222),
(13, 'Humboldt', 246, 222),
(14, 'Imperial', 246, 222),
(15, 'Inyo', 246, 222),
(16, 'Kern', 246, 222),
(17, 'Kings', 246, 222),
(18, 'Lake', 246, 222),
(19, 'Lassen', 246, 222),
(20, 'Los Angeles', 246, 222),
(21, 'Los Angeles Unified ', 246, 222),
(22, 'Madera', 246, 222),
(23, 'Marin', 246, 222),
(24, 'Mariposa', 246, 222),
(25, 'Mendocino', 246, 222),
(26, 'Merced', 246, 222),
(27, 'Modoc', 246, 222),
(28, 'Mono', 246, 222),
(29, 'Monterey', 246, 222),
(30, 'Napa', 246, 222),
(31, 'Nevada', 246, 222),
(32, 'Orange', 246, 222),
(33, 'Placer', 246, 222),
(34, 'Plumas', 246, 222),
(35, 'Riverside', 246, 222),
(36, 'Sacramento', 246, 222),
(37, 'San Benito', 246, 222),
(38, 'San Bernardino', 246, 222),
(39, 'San Diego', 246, 222),
(40, 'San Francisco', 246, 222),
(41, 'San Joaquin', 246, 222),
(42, 'San Luis Obispo', 246, 222),
(43, 'San Mateo', 246, 222),
(44, 'Santa Barbara', 246, 222),
(45, 'Santa Clara', 246, 222),
(46, 'Santa Cruz', 246, 222),
(47, 'Shasta', 246, 222),
(48, 'Sierra', 246, 222),
(49, 'Siskiyou', 246, 222),
(50, 'Solano', 246, 222),
(51, 'Sonoma', 246, 222),
(52, 'Stanislaus', 246, 222),
(53, 'Statewide Ed. Orgs.', 246, 222),
(54, 'Sutter', 246, 222),
(55, 'Tehama', 246, 222),
(56, 'Trinity', 246, 222),
(57, 'Tulare', 246, 222),
(58, 'Tuolumne', 246, 222),
(59, 'Ventura', 246, 222),
(60, 'Yolo', 246, 222),
(61, 'Yuba ', 246, 222),
(62, 'Appling', 253, 222),
(63, 'Atkinson', 253, 222),
(64, 'Bacon', 253, 222),
(65, 'Baker', 253, 222),
(66, 'Baldwin', 253, 222),
(67, 'Banks', 253, 222),
(68, 'Barrow', 253, 222),
(69, 'Bartow', 253, 222),
(70, 'Ben Hill', 253, 222),
(71, 'Berrien', 253, 222),
(72, 'Bibb', 253, 222),
(73, 'Bleckley', 253, 222),
(74, 'Brantley', 253, 222),
(75, 'Brooks', 253, 222),
(76, 'Bryan', 253, 222),
(77, 'Bulloch', 253, 222),
(78, 'Burke', 253, 222),
(79, 'Butts', 253, 222),
(80, 'Calhoun', 253, 222),
(81, 'Camden', 253, 222),
(82, 'Candler', 253, 222),
(83, 'Carroll', 253, 222),
(84, 'Catoosa', 253, 222),
(85, 'Charlton', 253, 222),
(86, 'Chatham', 253, 222),
(87, 'Chattahoochee', 253, 222),
(88, 'Chattooga', 253, 222),
(89, 'Cherokee', 253, 222),
(90, 'Clarke', 253, 222),
(91, 'Clay', 253, 222),
(92, 'Clayton', 253, 222),
(93, 'Clinch', 253, 222),
(94, 'Cobb', 253, 222),
(95, 'Coffee', 253, 222),
(96, 'Colquitt', 253, 222),
(97, 'Columbia', 253, 222),
(98, 'Cook', 253, 222),
(99, 'Coweta', 253, 222),
(100, 'Crawford', 253, 222),
(101, 'Crisp', 253, 222),
(102, 'Dade', 253, 222),
(103, 'Dawson', 253, 222),
(104, 'Decatur', 253, 222),
(105, 'Dekalb', 253, 222),
(106, 'Dodge', 253, 222),
(107, 'Dooly', 253, 222),
(108, 'Dougherty', 253, 222),
(109, 'Douglas', 253, 222),
(110, 'Early', 253, 222),
(111, 'Echols', 253, 222),
(112, 'Effingham', 253, 222),
(113, 'Elbert', 253, 222),
(114, 'Emanuel', 253, 222),
(115, 'Evans', 253, 222),
(116, 'Fannin', 253, 222),
(117, 'Fayette', 253, 222),
(118, 'Floyd', 253, 222),
(119, 'Forsyth', 253, 222),
(120, 'Franklin', 253, 222),
(121, 'Fulton', 253, 222),
(122, 'Gilmer', 253, 222),
(123, 'Glascock', 253, 222),
(124, 'Glynn', 253, 222),
(125, 'Gordon', 253, 222),
(126, 'Grady', 253, 222),
(127, 'Greene', 253, 222),
(128, 'Gwinnett', 253, 222),
(129, 'Habersham', 253, 222),
(130, 'Hall', 253, 222),
(131, 'Hancock', 253, 222),
(132, 'Haralson', 253, 222),
(133, 'Harris', 253, 222),
(134, 'Hart', 253, 222),
(135, 'Heard', 253, 222),
(136, 'Henry', 253, 222),
(137, 'Houston', 253, 222),
(138, 'Irwin', 253, 222),
(139, 'Jackson', 253, 222),
(140, 'Jasper', 253, 222),
(141, 'Jeff Davis', 253, 222),
(142, 'Jefferson', 253, 222),
(143, 'Jenkins', 253, 222),
(144, 'Johnson', 253, 222),
(145, 'Jones', 253, 222),
(146, 'Lamar', 253, 222),
(147, 'Lanier', 253, 222),
(148, 'Laurens', 253, 222),
(149, 'Lee', 253, 222),
(150, 'Liberty', 253, 222),
(151, 'Lincoln', 253, 222),
(152, 'Long', 253, 222),
(153, 'Lowndes', 253, 222),
(154, 'Lumpkin', 253, 222),
(155, 'McDuffie', 253, 222),
(156, 'McIntosh', 253, 222),
(157, 'Macon', 253, 222),
(158, 'Madison', 253, 222),
(159, 'Marion', 253, 222),
(160, 'Meriwether', 253, 222),
(161, 'Miller', 253, 222),
(162, 'Mitchell', 253, 222),
(163, 'Monroe', 253, 222),
(164, 'Montgomery', 253, 222),
(165, 'Morgan', 253, 222),
(166, 'Murray', 253, 222),
(167, 'Muscogee', 253, 222),
(168, 'Newton', 253, 222),
(169, 'Oconee', 253, 222),
(170, 'Oglethorpe', 253, 222),
(171, 'Paulding', 253, 222),
(172, 'Peach', 253, 222),
(173, 'Pickens', 253, 222),
(174, 'Pierce', 253, 222),
(175, 'Pike', 253, 222),
(176, 'Polk', 253, 222),
(177, 'Pulaski', 253, 222),
(178, 'Putnam', 253, 222),
(179, 'Quitman', 253, 222),
(180, 'Rabun', 253, 222),
(181, 'Randolph', 253, 222),
(182, 'Richmond', 253, 222),
(183, 'Rockdale', 253, 222),
(184, 'Schley', 253, 222),
(185, 'Screven', 253, 222),
(186, 'Seminole', 253, 222),
(187, 'Spalding', 253, 222),
(188, 'Stephens', 253, 222),
(189, 'Stewart', 253, 222),
(190, 'Sumter', 253, 222),
(191, 'Talbot', 253, 222),
(192, 'Taliaferro', 253, 222),
(193, 'Tattnall', 253, 222),
(194, 'Taylor', 253, 222),
(195, 'Telfair', 253, 222),
(196, 'Terrell', 253, 222),
(197, 'Thomas', 253, 222),
(198, 'Tift', 253, 222),
(199, 'Toombs', 253, 222),
(200, 'Towns', 253, 222),
(201, 'Treutlen', 253, 222),
(202, 'Troup', 253, 222),
(203, 'Turner', 253, 222),
(204, 'Twiggs', 253, 222),
(205, 'Union', 253, 222),
(206, 'Upson', 253, 222),
(207, 'Walker', 253, 222),
(208, 'Walton', 253, 222),
(209, 'Ware', 253, 222),
(210, 'Warren', 253, 222),
(211, 'Washington', 253, 222),
(212, 'Wayne', 253, 222),
(213, 'Webster', 253, 222),
(214, 'Wheeler', 253, 222),
(215, 'White', 253, 222),
(216, 'Whitfield', 253, 222),
(217, 'Wilcox', 253, 222),
(218, 'Wilkes', 253, 222),
(219, 'Wilkinson', 253, 222),
(220, 'Worth', 253, 222),
(221, 'Bedfordshire', 300, 221),
(222, 'Berkshire', 300, 221),
(223, 'Buckinghamshire', 300, 221),
(224, 'Cambridgeshire', 300, 221),
(225, 'Cheshire', 300, 221),
(226, 'Cornwall', 300, 221),
(227, 'Cumberland', 300, 221),
(228, 'Derbyshire', 300, 221),
(229, 'Devon', 300, 221),
(230, 'Dorset', 300, 221),
(231, 'Durham', 300, 221),
(232, 'Essex', 300, 221),
(233, 'Gloucestershire', 300, 221),
(234, 'Hampshire', 300, 221),
(235, 'Herefordshire', 300, 221),
(236, 'Hertfordshire', 300, 221),
(237, 'Huntingdon', 300, 221),
(238, 'Kent', 300, 221),
(239, 'Lancashire', 300, 221),
(240, 'Leicestershire', 300, 221),
(241, 'Lincolnshire', 300, 221),
(242, 'London', 300, 221),
(243, 'Middlesex', 300, 221),
(244, 'Norfolk', 300, 221),
(245, 'Northamptonshire', 300, 221),
(246, 'Northumberland', 300, 221),
(247, 'Nottinghamshire', 300, 221),
(248, 'Oxfordshire', 300, 221),
(249, 'Rutland', 300, 221),
(250, 'Shropshire', 300, 221),
(251, 'Somerset', 300, 221),
(252, 'Staffordshire', 300, 221),
(253, 'Suffolk', 300, 221),
(254, 'Surrey', 300, 221),
(255, 'West Sussex', 300, 221),
(256, 'Warwickshire', 300, 221),
(257, 'Westmorland', 300, 221),
(258, 'Wiltshire', 300, 221),
(259, 'Worcester', 300, 221),
(260, 'Yorkshire', 300, 221),
(0, 'Unknown', 0, 0),
(738, 'West Glamorgan', 303, 221),
(737, 'South Glamorgan', 303, 221),
(736, 'Powys', 303, 221),
(735, 'Mid Glamorgan', 303, 221),
(734, 'Gwynedd', 303, 221),
(733, 'Gwent', 303, 221),
(732, 'Dyfed', 303, 221),
(731, 'Clwyd', 303, 221),
(730, 'County Tyrone', 301, 221),
(729, 'County Fermanagh', 301, 221),
(728, 'County Down', 301, 221),
(727, 'County Armagh', 301, 221),
(726, 'County Antrim', 301, 221),
(725, 'Co. Londonderry', 301, 221),
(724, 'Wigtownshire', 302, 221),
(723, 'West Lothian', 302, 221),
(722, 'Sutherland', 302, 221),
(721, 'Stirlingshire', 302, 221),
(720, 'Shetland', 302, 221),
(719, 'Selkirkshire', 302, 221),
(718, 'Roxburghshire', 302, 221),
(717, 'Ross-Shire', 302, 221),
(716, 'Renfrewshire', 302, 221),
(715, 'Perthshire', 302, 221),
(714, 'Peeblesshire', 302, 221),
(713, 'Orkney', 302, 221),
(712, 'Morayshire', 302, 221),
(711, 'Midlothian', 302, 221),
(710, 'Lanarkshire', 302, 221),
(709, 'Kirkcudbrightsh', 302, 221),
(708, 'Kincardineshire', 302, 221),
(707, 'Isle of Tiree', 302, 221),
(706, 'Isle of South Uist', 302, 221),
(705, 'Isle of Skye', 302, 221),
(704, 'Isle of Scalpay', 302, 221),
(703, 'Isle of Rum', 302, 221),
(702, 'Isle of North Uist', 302, 221),
(701, 'Isle of Mull', 302, 221),
(700, 'Isle of Lewis', 302, 221),
(699, 'Isle of Jura', 302, 221),
(698, 'Isle of Islay', 302, 221),
(697, 'Isle of Iona', 302, 221),
(696, 'Isle of Harris', 302, 221),
(695, 'Isle of Gigha', 302, 221),
(694, 'Isle of Eigg', 302, 221),
(693, 'Isle of Cumbrae', 302, 221),
(692, 'Isle of Colonsay', 302, 221),
(691, 'Isle of Coll', 302, 221),
(690, 'Isle of Canna', 302, 221),
(689, 'Isle of Bute', 302, 221),
(688, 'Isle of Benbecula', 302, 221),
(687, 'Isle of Barra', 302, 221),
(686, 'Isle of Arran', 302, 221),
(685, 'Inverness-Shire', 302, 221),
(684, 'Fife', 302, 221),
(683, 'East Lothian', 302, 221),
(682, 'Dunbartonshire', 302, 221),
(681, 'Dumfriesshire', 302, 221),
(680, 'Clackmannanshire', 302, 221),
(679, 'Caithness', 302, 221),
(678, 'Berwickshire', 302, 221),
(677, 'Banffshire', 302, 221),
(676, 'Ayrshire', 302, 221),
(675, 'Argyll', 302, 221),
(674, 'Angus', 302, 221),
(673, 'Aberdeenshire', 302, 221),
(672, 'East Sussex', 300, 221);

This work is licensed under a
Creative Commons Attribution 2.5 License.

Comments on this database

Posted by Anonymous on 2009-05-13 03:53:24

are these all in the uk?

Counties

Associated Databases

Comments on this database

Post a comment on this database