FIPS table for Georgia Secretary of State data

fips.sql

-- MySQL dump 10.13  Distrib 5.1.47, for redhat-linux-gnu (i386)
--
-- Host: localhost    Database: editorial
-- ------------------------------------------------------
-- Server version	5.1.47

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `fips`
--

DROP TABLE IF EXISTS `fips`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fips` (
  `StateAbbr` varchar(255) DEFAULT NULL,
  `StateCode` varchar(255) DEFAULT NULL,
  `CountyCode` varchar(255) DEFAULT NULL,
  `CountyName` varchar(255) DEFAULT NULL,
  `ANSI_C1` varchar(255) DEFAULT NULL,
  `shortname` varchar(50) DEFAULT NULL,
  `caps` varchar(50) DEFAULT NULL,
  `SOS` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fips`
--

LOCK TABLES `fips` WRITE;
/*!40000 ALTER TABLE `fips` DISABLE KEYS */;
INSERT INTO `fips` VALUES ('GA','13','001','Appling County','H1','Appling','APPLING','001'),('GA','13','003','Atkinson County','H1','Atkinson','ATKINSON','002'),('GA','13','005','Bacon County','H1','Bacon','BACON','003'),('GA','13','007','Baker County','H1','Baker','BAKER','004'),('GA','13','009','Baldwin County','H1','Baldwin','BALDWIN','005'),('GA','13','011','Banks County','H1','Banks','BANKS','006'),('GA','13','013','Barrow County','H1','Barrow','BARROW','007'),('GA','13','015','Bartow County','H1','Bartow','BARTOW','008'),('GA','13','017','Ben Hill County','H1','Ben Hill','BEN HILL','009'),('GA','13','019','Berrien County','H1','Berrien','BERRIEN','010'),('GA','13','021','Bibb County','H1','Bibb','BIBB','011'),('GA','13','023','Bleckley County','H1','Bleckley','BLECKLEY','012'),('GA','13','025','Brantley County','H1','Brantley','BRANTLEY','013'),('GA','13','027','Brooks County','H1','Brooks','BROOKS','014'),('GA','13','029','Bryan County','H1','Bryan','BRYAN','015'),('GA','13','031','Bulloch County','H1','Bulloch','BULLOCH','016'),('GA','13','033','Burke County','H1','Burke','BURKE','017'),('GA','13','035','Butts County','H1','Butts','BUTTS','018'),('GA','13','037','Calhoun County','H1','Calhoun','CALHOUN','019'),('GA','13','039','Camden County','H1','Camden','CAMDEN','020'),('GA','13','043','Candler County','H1','Candler','CANDLER','021'),('GA','13','045','Carroll County','H1','Carroll','CARROLL','022'),('GA','13','047','Catoosa County','H1','Catoosa','CATOOSA','023'),('GA','13','049','Charlton County','H1','Charlton','CHARLTON','024'),('GA','13','051','Chatham County','H1','Chatham','CHATHAM','025'),('GA','13','053','Chattahoochee County','H1','Chattahoochee','CHATTAHOOCHEE','026'),('GA','13','055','Chattooga County','H1','Chattooga','CHATTOOGA','027'),('GA','13','057','Cherokee County','H1','Cherokee','CHEROKEE','028'),('GA','13','059','Clarke County','H6','Clarke','CLARKE','029'),('GA','13','061','Clay County','H1','Clay','CLAY','030'),('GA','13','063','Clayton County','H1','Clayton','CLAYTON','031'),('GA','13','065','Clinch County','H1','Clinch','CLINCH','032'),('GA','13','067','Cobb County','H1','Cobb','COBB','033'),('GA','13','069','Coffee County','H1','Coffee','COFFEE','034'),('GA','13','071','Colquitt County','H1','Colquitt','COLQUITT','035'),('GA','13','073','Columbia County','H1','Columbia','COLUMBIA','036'),('GA','13','075','Cook County','H1','Cook','COOK','037'),('GA','13','077','Coweta County','H1','Coweta','COWETA','038'),('GA','13','079','Crawford County','H1','Crawford','CRAWFORD','039'),('GA','13','081','Crisp County','H1','Crisp','CRISP','040'),('GA','13','083','Dade County','H1','Dade','DADE','041'),('GA','13','085','Dawson County','H1','Dawson','DAWSON','042'),('GA','13','087','Decatur County','H1','Decatur','DECATUR','043'),('GA','13','089','DeKalb County','H1','DeKalb','DEKALB','044'),('GA','13','091','Dodge County','H1','Dodge','DODGE','045'),('GA','13','093','Dooly County','H1','Dooly','DOOLY','046'),('GA','13','095','Dougherty County','H1','Dougherty','DOUGHERTY','047'),('GA','13','097','Douglas County','H1','Douglas','DOUGLAS','048'),('GA','13','099','Early County','H1','Early','EARLY','049'),('GA','13','101','Echols County','H1','Echols','ECHOLS','050'),('GA','13','103','Effingham County','H1','Effingham','EFFINGHAM','051'),('GA','13','105','Elbert County','H1','Elbert','ELBERT','052'),('GA','13','107','Emanuel County','H1','Emanuel','EMANUEL','053'),('GA','13','109','Evans County','H1','Evans','EVANS','054'),('GA','13','111','Fannin County','H1','Fannin','FANNIN','055'),('GA','13','113','Fayette County','H1','Fayette','FAYETTE','056'),('GA','13','115','Floyd County','H1','Floyd','FLOYD','057'),('GA','13','117','Forsyth County','H1','Forsyth','FORSYTH','058'),('GA','13','119','Franklin County','H1','Franklin','FRANKLIN','059'),('GA','13','121','Fulton County','H1','Fulton','FULTON','060'),('GA','13','123','Gilmer County','H1','Gilmer','GILMER','061'),('GA','13','125','Glascock County','H1','Glascock','GLASCOCK','062'),('GA','13','127','Glynn County','H1','Glynn','GLYNN','063'),('GA','13','129','Gordon County','H1','Gordon','GORDON','064'),('GA','13','131','Grady County','H1','Grady','GRADY','065'),('GA','13','133','Greene County','H1','Greene','GREENE','066'),('GA','13','135','Gwinnett County','H1','Gwinnett','GWINNETT','067'),('GA','13','137','Habersham County','H1','Habersham','HABERSHAM','068'),('GA','13','139','Hall County','H1','Hall','HALL','069'),('GA','13','141','Hancock County','H1','Hancock','HANCOCK','070'),('GA','13','143','Haralson County','H1','Haralson','HARALSON','071'),('GA','13','145','Harris County','H1','Harris','HARRIS','072'),('GA','13','147','Hart County','H1','Hart','HART','073'),('GA','13','149','Heard County','H1','Heard','HEARD','074'),('GA','13','151','Henry County','H1','Henry','HENRY','075'),('GA','13','153','Houston County','H1','Houston','HOUSTON','076'),('GA','13','155','Irwin County','H1','Irwin','IRWIN','077'),('GA','13','157','Jackson County','H1','Jackson','JACKSON','078'),('GA','13','159','Jasper County','H1','Jasper','JASPER','079'),('GA','13','161','Jeff Davis County','H1','Jeff Davis','JEFF DAVIS','080'),('GA','13','163','Jefferson County','H1','Jefferson','JEFFERSON','081'),('GA','13','165','Jenkins County','H1','Jenkins','JENKINS','082'),('GA','13','167','Johnson County','H1','Johnson','JOHNSON','083'),('GA','13','169','Jones County','H1','Jones','JONES','084'),('GA','13','171','Lamar County','H1','Lamar','LAMAR','085'),('GA','13','173','Lanier County','H1','Lanier','LANIER','086'),('GA','13','175','Laurens County','H1','Laurens','LAURENS','087'),('GA','13','177','Lee County','H1','Lee','LEE','088'),('GA','13','179','Liberty County','H1','Liberty','LIBERTY','089'),('GA','13','181','Lincoln County','H1','Lincoln','LINCOLN','090'),('GA','13','183','Long County','H1','Long','LONG','091'),('GA','13','185','Lowndes County','H1','Lowndes','LOWNDES','092'),('GA','13','187','Lumpkin County','H1','Lumpkin','LUMPKIN','093'),('GA','13','189','McDuffie County','H1','McDuffie','MCDUFFIE','097'),('GA','13','191','McIntosh County','H1','McIntosh','MCINTOSH','098'),('GA','13','193','Macon County','H1','Macon','MACON','094'),('GA','13','195','Madison County','H1','Madison','MADISON','095'),('GA','13','197','Marion County','H1','Marion','MARION','096'),('GA','13','199','Meriwether County','H1','Meriwether','MERIWETHER','099'),('GA','13','201','Miller County','H1','Miller','MILLER','100'),('GA','13','205','Mitchell County','H1','Mitchell','MITCHELL','101'),('GA','13','207','Monroe County','H1','Monroe','MONROE','102'),('GA','13','209','Montgomery County','H1','Montgomery','MONTGOMERY','103'),('GA','13','211','Morgan County','H1','Morgan','MORGAN','104'),('GA','13','213','Murray County','H1','Murray','MURRAY','105'),('GA','13','215','Muscogee County','H6','Muscogee','MUSCOGEE','106'),('GA','13','217','Newton County','H1','Newton','NEWTON','107'),('GA','13','219','Oconee County','H1','Oconee','OCONEE','108'),('GA','13','221','Oglethorpe County','H1','Oglethorpe','OGLETHORPE','109'),('GA','13','223','Paulding County','H1','Paulding','PAULDING','110'),('GA','13','225','Peach County','H1','Peach','PEACH','111'),('GA','13','227','Pickens County','H1','Pickens','PICKENS','112'),('GA','13','229','Pierce County','H1','Pierce','PIERCE','113'),('GA','13','231','Pike County','H1','Pike','PIKE','114'),('GA','13','233','Polk County','H1','Polk','POLK','115'),('GA','13','235','Pulaski County','H1','Pulaski','PULASKI','116'),('GA','13','237','Putnam County','H1','Putnam','PUTNAM','117'),('GA','13','239','Quitman County','H1','Quitman','QUITMAN','118'),('GA','13','241','Rabun County','H1','Rabun','RABUN','119'),('GA','13','243','Randolph County','H1','Randolph','RANDOLPH','120'),('GA','13','245','Richmond County','H6','Richmond','RICHMOND','121'),('GA','13','247','Rockdale County','H1','Rockdale','ROCKDALE','122'),('GA','13','249','Schley County','H1','Schley','SCHLEY','123'),('GA','13','251','Screven County','H1','Screven','SCREVEN','124'),('GA','13','253','Seminole County','H1','Seminole','SEMINOLE','125'),('GA','13','255','Spalding County','H1','Spalding','SPALDING','126'),('GA','13','257','Stephens County','H1','Stephens','STEPHENS','127'),('GA','13','259','Stewart County','H1','Stewart','STEWART','128'),('GA','13','261','Sumter County','H1','Sumter','SUMTER','129'),('GA','13','263','Talbot County','H1','Talbot','TALBOT','130'),('GA','13','265','Taliaferro County','H1','Taliaferro','TALIAFERRO','131'),('GA','13','267','Tattnall County','H1','Tattnall','TATTNALL','132'),('GA','13','269','Taylor County','H1','Taylor','TAYLOR','133'),('GA','13','271','Telfair County','H1','Telfair','TELFAIR','134'),('GA','13','273','Terrell County','H1','Terrell','TERRELL','135'),('GA','13','275','Thomas County','H1','Thomas','THOMAS','136'),('GA','13','277','Tift County','H1','Tift','TIFT','137'),('GA','13','279','Toombs County','H1','Toombs','TOOMBS','138'),('GA','13','281','Towns County','H1','Towns','TOWNS','139'),('GA','13','283','Treutlen County','H1','Treutlen','TREUTLEN','140'),('GA','13','285','Troup County','H1','Troup','TROUP','141'),('GA','13','287','Turner County','H1','Turner','TURNER','142'),('GA','13','289','Twiggs County','H1','Twiggs','TWIGGS','143'),('GA','13','291','Union County','H1','Union','UNION','144'),('GA','13','293','Upson County','H1','Upson','UPSON','145'),('GA','13','295','Walker County','H1','Walker','WALKER','146'),('GA','13','297','Walton County','H1','Walton','WALTON','147'),('GA','13','299','Ware County','H1','Ware','WARE','148'),('GA','13','301','Warren County','H1','Warren','WARREN','149'),('GA','13','303','Washington County','H1','Washington','WASHINGTON','150'),('GA','13','305','Wayne County','H1','Wayne','WAYNE','151'),('GA','13','307','Webster County','H1','Webster','WEBSTER','152'),('GA','13','309','Wheeler County','H1','Wheeler','WHEELER','153'),('GA','13','311','White County','H1','White','WHITE','154'),('GA','13','313','Whitfield County','H1','Whitfield','WHITFIELD','155'),('GA','13','315','Wilcox County','H1','Wilcox','WILCOX','156'),('GA','13','317','Wilkes County','H1','Wilkes','WILKES','157'),('GA','13','319','Wilkinson County','H1','Wilkinson','WILKINSON','158'),('GA','13','321','Worth County','H1','Worth','WORTH','159');
/*!40000 ALTER TABLE `fips` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2015-03-07 15:09:56