-- -----------------------------------------------------
-- Schema sample
-- -----------------------------------------------------
DROP SCHEMA IF EXISTS sample ;

CREATE SCHEMA IF NOT EXISTS sample DEFAULT CHARACTER SET utf8mb4 ;
USE sample ;

-- -----------------------------------------------------
-- Table givenName
-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS givenName (
    id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(45) NOT NULL,
    gender CHAR(1) NOT NULL,
    PRIMARY KEY (id),
    UNIQUE INDEX name_UNIQUE (name ASC, gender ASC),
    INDEX idx_gender (gender ASC))
ENGINE = InnoDB ;

-- -----------------------------------------------------
-- Table familyName
-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS familyName (
    id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(45) NOT NULL,
    PRIMARY KEY (id),
    UNIQUE INDEX name_UNIQUE (name ASC))
ENGINE = InnoDB ;

-- -----------------------------------------------------
-- Table street
-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS street (
    id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(45) NOT NULL,
    PRIMARY KEY (id),
    UNIQUE INDEX name_UNIQUE (name ASC))
ENGINE = InnoDB ;

-- -----------------------------------------------------
-- Table state
-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS state (
    id INT NOT NULL AUTO_INCREMENT,
    abbrev CHAR(2) NOT NULL,
    name VARCHAR(45) NOT NULL,
    PRIMARY KEY (id),
    UNIQUE INDEX abbrev_UNIQUE (abbrev ASC))
ENGINE = InnoDB ;

-- -----------------------------------------------------
-- Table zipCode
-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS zipCode (
    id INT NOT NULL AUTO_INCREMENT,
    zipCode CHAR(5) NOT NULL,
    stateAbbrev CHAR(2) NOT NULL,
    city VARCHAR(45) NOT NULL,
    areaCode CHAR(3) NOT NULL,
    INDEX fk_zipcode_state_idx (stateAbbrev ASC),
    PRIMARY KEY (id),
    UNIQUE INDEX zipCode_UNIQUE (zipCode ASC),
    INDEX idx_stateAbbrev (stateAbbrev ASC),
    CONSTRAINT fk_zipcode_state
        FOREIGN KEY (stateAbbrev)
        REFERENCES state (abbrev)
        ON DELETE RESTRICT
        ON UPDATE CASCADE)
ENGINE = InnoDB ;

-- -----------------------------------------------------
-- Table emailProvider
-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS emailProvider (
    id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(45) NOT NULL,
    PRIMARY KEY (id),
    UNIQUE INDEX name_UNIQUE (name ASC))
ENGINE = InnoDB ;

-- -----------------------------------------------------
-- Table streetType
-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS streetType (
    id INT NOT NULL AUTO_INCREMENT,
    name CHAR(5) NOT NULL,
    PRIMARY KEY (id),
    UNIQUE INDEX name_UNIQUE (name ASC))
ENGINE = InnoDB ;


-- This list of names comes from the U.S. Social Security Administration.
INSERT INTO givenName (name, gender) VALUES
('Aaliyah', 'F'), ('Aaron', 'M'), ('Abby', 'F'),
('Abigail', 'F'), ('Adalyn', 'F'), ('Adam', 'M'),
('Addison', 'F'), ('Adrian', 'M'), ('Aidan', 'M'),
('Aiden', 'M'), ('Aimee', 'F'), ('Alan', 'M'),
('Albert', 'M'), ('Alec', 'M'), ('Alejandro', 'M'),
('Alex', 'M'), ('Alexa', 'F'), ('Alexander', 'M'),
('Alexandra', 'F'), ('Alexandria', 'F'), ('Alexis', 'F'),
('Alice', 'F'), ('Alicia', 'F'), ('Alisha', 'F'),
('Alison', 'F'), ('Allen', 'M'), ('Allie', 'F'),
('Allison', 'F'), ('Alvin', 'M'), ('Alyssa', 'F'),
('Amanda', 'F'), ('Amber', 'F'), ('Amelia', 'F'),
('Amy', 'F'), ('Anders', 'M'), ('Andrea', 'F'),
('Andres', 'M'), ('Andrew', 'M'), ('Angel', 'F'),
('Angel', 'M'), ('Angela', 'F'), ('Angelica', 'F'),
('Angelina', 'F'), ('Anita', 'F'), ('Ann', 'F'),
('Anna', 'F'), ('Annabelle', 'F'), ('Anne', 'F'),
('Annette', 'F'), ('Anthony', 'M'), ('Antonio', 'M'),
('April', 'F'), ('Ardith', 'F'), ('Aria', 'F'),
('Ariana', 'F'), ('Arianna', 'F'), ('Ariel', 'F'),
('Arlo', 'M'), ('Arthur', 'M'), ('Arturo', 'M'),
('Asher', 'M'), ('Ashlee', 'F'), ('Ashley', 'F'),
('Ashlyn', 'F'), ('Ashton', 'M'), ('Asia', 'F'),
('Aspen', 'F'), ('Aubree', 'F'), ('Aubrey', 'F'),
('Audrey', 'F'), ('Austin', 'M'), ('Autumn', 'F'),
('Ava', 'F'), ('Avery', 'F'), ('Axel', 'M'),
('Ayden', 'M'), ('Bailey', 'F'), ('Barbara', 'F'),
('Barry', 'M'), ('Bart', 'M'), ('Beau', 'M'),
('Becky', 'F'), ('Belinda', 'F'), ('Bella', 'F'),
('Benjamin', 'M'), ('Bentley', 'M'), ('Beth', 'F'),
('Bethany', 'F'), ('Betty', 'F'), ('Beverly', 'F'),
('Bill', 'M'), ('Billy', 'M'), ('Blake', 'M'),
('Bob', 'M'), ('Bobby', 'M'), ('Bonnie', 'F'),
('Boston', 'M'), ('Brad', 'M'), ('Bradley', 'M'),
('Brady', 'M'), ('Brandi', 'F'), ('Brandon', 'M'),
('Brandy', 'F'), ('Brantley', 'M'), ('Braxton', 'M'),
('Brayden', 'M'), ('Braylen', 'M'), ('Braylon', 'M'),
('Breanna', 'F'), ('Brenda', 'F'), ('Brennan', 'M'),
('Brent', 'M'), ('Bret', 'M'), ('Brett', 'M'),
('Brian', 'M'), ('Briana', 'F'), ('Brianna', 'F'),
('Bridger', 'M'), ('Bridget', 'F'), ('Brinley', 'F'),
('Brittany', 'F'), ('Brittney', 'F'), ('Brock', 'M'),
('Brody', 'M'), ('Bronson', 'M'), ('Brooke', 'F'),
('Brooklyn', 'F'), ('Brooklynn', 'F'), ('Bruce', 'M'),
('Bryan', 'M'), ('Bryant', 'M'), ('Bryce', 'M'),
('Brynlee', 'F'), ('Bryson', 'M'), ('Byron', 'M'),
('Cade', 'M'), ('Caden', 'M'), ('Caitlin', 'F'),
('Caitlyn', 'F'), ('Caleb', 'M'), ('Calvin', 'M'),
('Camden', 'M'), ('Cameron', 'M'), ('Camila', 'F'),
('Camille', 'F'), ('Camryn', 'F'), ('Candace', 'F'),
('Candice', 'F'), ('Carissa', 'F'), ('Carl', 'M'),
('Carla', 'F'), ('Carlos', 'M'), ('Carol', 'F'),
('Caroline', 'F'), ('Carolyn', 'F'), ('Carrie', 'F'),
('Carson', 'M'), ('Carter', 'M'), ('Casey', 'F'),
('Casey', 'M'), ('Cassandra', 'F'), ('Cassidy', 'F'),
('Catherine', 'F'), ('Cathy', 'F'), ('Cayden', 'M'),
('Cecelia', 'F'), ('Chad', 'M'), ('Chandler', 'M'),
('Chantel', 'F'), ('Charlene', 'F'), ('Charles', 'M'),
('Charlotte', 'F'), ('Chase', 'M'), ('Chelsea', 'F'),
('Chelsey', 'F'), ('Chelsie', 'F'), ('Cheryl', 'F'),
('Chester', 'M'), ('Cheyenne', 'F'), ('Chloe', 'F'),
('Chris', 'M'), ('Christian', 'M'), ('Christina', 'F'),
('Christine', 'F'), ('Christopher', 'M'), ('Christy', 'F'),
('Cindy', 'F'), ('Claire', 'F'), ('Clarence', 'M'),
('Clayton', 'M'), ('Clifford', 'M'), ('Clint', 'M'),
('Clinton', 'M'), ('Cody', 'M'), ('Cohen', 'M'),
('Colby', 'M'), ('Cole', 'M'), ('Colin', 'M'),
('Colleen', 'F'), ('Collin', 'M'), ('Colt', 'M'),
('Colton', 'M'), ('Conner', 'M'), ('Connie', 'F'),
('Connor', 'M'), ('Cooper', 'M'), ('Corey', 'M'),
('Cory', 'M'), ('Courtney', 'F'), ('Craig', 'M'),
('Crystal', 'F'), ('Curt', 'M'), ('Curtis', 'M'),
('Cynthia', 'F'), ('Daisy', 'F'), ('Dakota', 'M'),
('Dale', 'M'), ('Dallin', 'M'), ('Dalton', 'M'),
('Damian', 'M'), ('Damien', 'M'), ('Damon', 'M'),
('Dan', 'M'), ('Dana', 'F'), ('Daniel', 'M'),
('Daniela', 'F'), ('Danielle', 'F'), ('Danny', 'M'),
('Darel', 'M'), ('Darin', 'M'), ('Darlene', 'F'),
('Darrel', 'M'), ('Darrell', 'M'), ('Darren', 'M'),
('Darryl', 'M'), ('Daryl', 'M'), ('Dave', 'M'),
('David', 'M'), ('Dawn', 'F'), ('Dawson', 'M'),
('Dean', 'M'), ('Deanna', 'F'), ('Debbie', 'F'),
('Deborah', 'F'), ('Debra', 'F'), ('Delilah', 'F'),
('Denise', 'F'), ('Dennis', 'M'), ('Derek', 'M'),
('Derrick', 'M'), ('Desiree', 'F'), ('Destiny', 'F'),
('Devin', 'M'), ('Diamond', 'F'), ('Diana', 'F'),
('Diane', 'F'), ('Diego', 'M'), ('Dominic', 'M'),
('Don', 'M'), ('Donald', 'M'), ('Donna', 'F'),
('Dorothy', 'F'), ('Doug', 'M'), ('Douglas', 'M'),
('Dustin', 'M'), ('Dwayne', 'M'), ('Dylan', 'M'),
('Earl', 'M'), ('Easton', 'M'), ('Eddie', 'M'),
('Eduardo', 'M'), ('Edward', 'M'), ('Eholo', 'M'),
('Elaine', 'F'), ('Elena', 'F'), ('Eli', 'M'),
('Elias', 'M'), ('Elijah', 'M'), ('Eliza', 'F'),
('Elizabeth', 'F'), ('Ella', 'F'), ('Ellen', 'F'),
('Ellie', 'F'), ('Emily', 'F'), ('Emma', 'F'),
('Emmanuel', 'M'), ('Eric', 'M'), ('Erica', 'F'),
('Erik', 'M'), ('Erika', 'F'), ('Erin', 'F'),
('Ernest', 'M'), ('Ethan', 'M'), ('Eva', 'F'),
('Evan', 'M'), ('Evelyn', 'F'), ('Faith', 'F'),
('Felicia', 'F'), ('Felipe', 'M'), ('Fern', 'F'),
('Fernando', 'M'), ('Francisco', 'M'), ('Frank', 'M'),
('Frederick', 'M'), ('Gabriel', 'M'), ('Gabriella', 'F'),
('Gabrielle', 'F'), ('Gael', 'M'), ('Gage', 'M'),
('Gail', 'F'), ('Garrett', 'M'), ('Gary', 'M'),
('Gavin', 'M'), ('Gay', 'F'), ('Genesis', 'F'),
('George', 'M'), ('Georgia', 'F'), ('Gerald', 'M'),
('Gianna', 'F'), ('Gilbert', 'M'), ('Gina', 'F'),
('Giovanni', 'M'), ('Giselle', 'F'), ('Glen', 'M'),
('Glenda', 'F'), ('Glenn', 'M'), ('Gloria', 'F'),
('Gordon', 'M'), ('Grace', 'F'), ('Gracie', 'F'),
('Grant', 'M'), ('Grayson', 'M'), ('Greg', 'M'),
('Gregory', 'M'), ('Guy', 'M'), ('Gwendolyn', 'F'),
('Hailey', 'F'), ('Haley', 'F'), ('Halle', 'F'),
('Hallie', 'F'), ('Hannah', 'F'), ('Harmony', 'F'),
('Harold', 'M'), ('Harper', 'F'), ('Hayden', 'M'),
('Hayley', 'F'), ('Heather', 'F'), ('Heber', 'M'),
('Heidi', 'F'), ('Helen', 'F'), ('Henry', 'M'),
('Holly', 'F'), ('Howard', 'M'), ('Hudson', 'M'),
('Hunter', 'M'), ('Ian', 'M'), ('Ikaika', 'M'),
('Isaac', 'M'), ('Isabel', 'F'), ('Isabella', 'F'),
('Isabelle', 'F'), ('Isaiah', 'M'), ('Ivan', 'M'),
('Jace', 'M'), ('Jack', 'M'), ('Jackson', 'M'),
('Jacob', 'M'), ('Jacqueline', 'F'), ('Jada', 'F'),
('Jade', 'F'), ('Jaden', 'M'), ('Jake', 'M'),
('Jalen', 'M'), ('James', 'M'), ('Jami', 'F'),
('Jamie', 'F'), ('Jamie', 'M'), ('Jan', 'F'),
('Jana', 'F'), ('Janelle', 'F'), ('Janet', 'F'),
('Janice', 'F'), ('Jared', 'M'), ('Jase', 'M'),
('Jasmine', 'F'), ('Jason', 'M'), ('Jaxon', 'M'),
('Jaxson', 'M'), ('Jay', 'M'), ('Jayce', 'M'),
('Jayceon', 'M'), ('Jayden', 'M'), ('Jaydon', 'M'),
('Jeff', 'M'), ('Jeffery', 'M'), ('Jeffrey', 'M'),
('Jenica', 'F'), ('Jenna', 'F'), ('Jennifer', 'F'),
('Jenny', 'F'), ('Jeremiah', 'M'), ('Jeremy', 'M'),
('Jermaine', 'M'), ('Jerrick', 'M'), ('Jerry', 'M'),
('Jesse', 'M'), ('Jessica', 'F'), ('Jesus', 'M'),
('Jill', 'F'), ('Jim', 'M'), ('Jimmy', 'M'),
('Joan', 'F'), ('Joanne', 'F'), ('Jocelyn', 'F'),
('Jodi', 'F'), ('Jody', 'F'), ('Joe', 'M'),
('Joel', 'M'), ('Joey', 'M'), ('John', 'M'),
('Johnevan', 'M'), ('Johnny', 'M'), ('Jolene', 'F'),
('Jon', 'M'), ('Jonah', 'M'), ('Jonas', 'M'),
('Jonathan', 'M'), ('Jordan', 'F'), ('Jordan', 'M'),
('Jordyn', 'F'), ('Jorge', 'M'), ('Jose', 'M'),
('Joseph', 'M'), ('Joshua', 'M'), ('Josiah', 'M'),
('Joy', 'F'), ('Joyce', 'F'), ('Juan', 'M'),
('Jude', 'M'), ('Judy', 'F'), ('Julia', 'F'),
('Julian', 'M'), ('Juliana', 'F'), ('Julie', 'F'),
('Justin', 'M'), ('Kaden', 'M'), ('Kaiden', 'M'),
('Kaitlin', 'F'), ('Kaitlyn', 'F'), ('Kaleb', 'M'),
('Karen', 'F'), ('Karl', 'M'), ('Kate', 'F'),
('Katelyn', 'F'), ('Katherine', 'F'), ('Kathleen', 'F'),
('Kathryn', 'F'), ('Kathy', 'F'), ('Katie', 'F'),
('Katrina', 'F'), ('Kayden', 'M'), ('Kayla', 'F'),
('Kaylee', 'F'), ('Keith', 'M'), ('Kekoa', 'M'),
('Kelli', 'F'), ('Kellie', 'F'), ('Kelly', 'F'),
('Kelly', 'M'), ('Kelsey', 'F'), ('Kendra', 'F'),
('Kennedy', 'F'), ('Kenneth', 'M'), ('Kensley', 'F'),
('Kent', 'M'), ('Keoni', 'M'), ('Kerry', 'M'),
('Kevin', 'M'), ('Khloe', 'F'), ('Kim', 'F'),
('Kimberlee', 'F'), ('Kimberly', 'F'), ('King', 'M'),
('Kingston', 'M'), ('Kinsley', 'F'), ('Kirk', 'M'),
('Krista', 'F'), ('Kristen', 'F'), ('Kristi', 'F'),
('Kristin', 'F'), ('Kristina', 'F'), ('Kristine', 'F'),
('Kristy', 'F'), ('Krystal', 'F'), ('Kurt', 'M'),
('Kyle', 'M'), ('Kylee', 'F'), ('Kyleigh', 'F'),
('Kyler', 'M'), ('Kylie', 'F'), ('Lacey', 'F'),
('LaFonda', 'F'), ('Laila', 'F'), ('Lance', 'M'),
('Landon', 'M'), ('Lara', 'F'), ('Larry', 'M'),
('Latasha', 'F'), ('Latoya', 'F'), ('Laura', 'F'),
('Lauren', 'F'), ('Laurie', 'F'), ('Lawrence', 'M'),
('Layla', 'F'), ('Leah', 'F'), ('Lee', 'M'),
('Leilani', 'F'), ('Leon', 'M'), ('Leonard', 'M'),
('Leonardo', 'M'), ('Leslie', 'F'), ('Levi', 'M'),
('Liam', 'M'), ('Liliana', 'F'), ('Lillian', 'F'),
('Lily', 'F'), ('Linda', 'F'), ('Lindsay', 'F'),
('Lindsey', 'F'), ('Lisa', 'F'), ('Lloyd', 'M'),
('Logan', 'M'), ('London', 'F'), ('Londyn', 'F'),
('Loretta', 'F'), ('Lori', 'F'), ('Louis', 'M'),
('Lucas', 'M'), ('Lucy', 'F'), ('Luis', 'M'),
('Luke', 'M'), ('Lydia', 'F'), ('Lynette', 'F'),
('Lynn', 'F'), ('Lynn', 'M'), ('Lyric', 'F'),
('Maci', 'F'), ('Mackenzie', 'F'), ('Madeline', 'F'),
('Madelyn', 'F'), ('Madison', 'F'), ('Maile', 'F'),
('Makayla', 'F'), ('Makenzie', 'F'), ('Malaysia', 'F'),
('Malia', 'F'), ('Malik', 'M'), ('Mallory', 'F'),
('Mallory', 'M'), ('Mandy', 'F'), ('Manuel', 'M'),
('Marc', 'M'), ('Marci', 'F'), ('Marcus', 'M'),
('Margaret', 'F'), ('Maria', 'F'), ('Mariah', 'F'),
('Marie', 'F'), ('Marilyn', 'F'), ('Marin', 'F'),
('Marion', 'F'), ('Marion', 'M'), ('Marisa', 'F'),
('Marissa', 'F'), ('Mark', 'M'), ('Martha', 'F'),
('Martin', 'M'), ('Mary', 'F'), ('Mason', 'M'),
('Mateo', 'M'), ('Matisse', 'F'), ('Matthew', 'M'),
('Max', 'M'), ('Maxwell', 'M'), ('Maya', 'F'),
('Mckenna', 'F'), ('Mckenzie', 'F'), ('Megan', 'F'),
('Meghan', 'F'), ('Melanie', 'F'), ('Melinda', 'F'),
('Melissa', 'F'), ('Melvin', 'M'), ('Mia', 'F'),
('Micah', 'M'), ('Michael', 'M'), ('Micheal', 'M'),
('Michele', 'F'), ('Michelle', 'F'), ('Miguel', 'M'),
('Mikayla', 'F'), ('Mike', 'M'), ('Mildred', 'F'),
('Milton', 'M'), ('Mindy', 'F'), ('Miranda', 'F'),
('Misty', 'F'), ('Mitchell', 'M'), ('Molly', 'F'),
('Monica', 'F'), ('Monique', 'F'), ('Morgan', 'F'),
('Mya', 'F'), ('Nancy', 'F'), ('Naomi', 'F'),
('Natalia', 'F'), ('Natalie', 'F'), ('Natasha', 'F'),
('Nathan', 'M'), ('Nathaniel', 'M'), ('Nevaeh', 'F'),
('Nicholas', 'M'), ('Nichole', 'F'), ('Nicole', 'F'),
('Noah', 'M'), ('Nolan', 'M'), ('Oliver', 'M'),
('Olivia', 'F'), ('Omar', 'M'), ('Oscar', 'M'),
('Owen', 'M'), ('Paige', 'F'), ('Paisley', 'F'),
('Pam', 'F'), ('Pamela', 'F'), ('Paris', 'F'),
('Parker', 'M'), ('Patricia', 'F'), ('Patrick', 'M'),
('Paul', 'M'), ('Paula', 'F'), ('Payton', 'F'),
('Peggy', 'F'), ('Penny', 'F'), ('Peter', 'M'),
('Peyton', 'F'), ('Peyton', 'M'), ('Philip', 'M'),
('Phillip', 'M'), ('Phyllis', 'F'), ('Piper', 'F'),
('Porter', 'M'), ('Prem', 'M'), ('Preston', 'M'),
('Rachael', 'F'), ('Rachel', 'F'), ('Ralph', 'M'),
('Randall', 'M'), ('Randy', 'M'), ('Raven', 'F'),
('Raymond', 'M'), ('Reagan', 'F'), ('Rebecca', 'F'),
('Rebekah', 'F'), ('Regina', 'F'), ('Reginald', 'M'),
('Reid', 'M'), ('Renata', 'F'), ('Renee', 'F'),
('Rex', 'M'), ('Rhonda', 'F'), ('Richard', 'M'),
('Rick', 'M'), ('Rickey', 'M'), ('Ricky', 'M'),
('Riley', 'F'), ('Riley', 'M'), ('Robert', 'M'),
('Roberta', 'F'), ('Robin', 'F'), ('Robyn', 'F'),
('Rodney', 'M'), ('Roger', 'M'), ('Ron', 'M'),
('Ronald', 'M'), ('Ronnie', 'M'), ('Rose', 'F'),
('Roxanne', 'F'), ('Roy', 'M'), ('Ruby', 'F'),
('Russell', 'M'), ('Ruth', 'F'), ('Ryan', 'M'),
('Ryker', 'M'), ('Rylee', 'F'), ('Ryleigh', 'F'),
('Sabrina', 'F'), ('Sadie', 'F'), ('Samantha', 'F'),
('Samuel', 'M'), ('Sandra', 'F'), ('Sandy', 'F'),
('Santiago', 'M'), ('Sara', 'F'), ('Sarah', 'F'),
('Saryn', 'F'), ('Sasha', 'F'), ('Savannah', 'F'),
('Sawyer', 'M'), ('Scarlett', 'F'), ('Scott', 'M'),
('Sean', 'M'), ('Sebastian', 'M'), ('Serenity', 'F'),
('Sergio', 'M'), ('Seth', 'M'), ('Shane', 'M'),
('Shaniqua', 'F'), ('Shannon', 'F'), ('Shantel', 'F'),
('Sharon', 'F'), ('Shaun', 'M'), ('Shauna', 'F'),
('Shawn', 'F'), ('Shawn', 'M'), ('Shawna', 'F'),
('Sheena', 'F'), ('Sheila', 'F'), ('Shelby', 'F'),
('Sheldon', 'M'), ('Shelia', 'F'), ('Shelley', 'F'),
('Shelly', 'F'), ('Sheri', 'F'), ('Sherri', 'F'),
('Sherrie', 'F'), ('Sherry', 'F'), ('Shirley', 'F'),
('Sierra', 'F'), ('Silas', 'M'), ('Skylar', 'F'),
('Skyler', 'M'), ('Sobe', 'F'), ('Sofia', 'F'),
('Sonya', 'F'), ('Sophia', 'F'), ('Sophie', 'F'),
('Spencer', 'M'), ('Stacey', 'F'), ('Stacie', 'F'),
('Stacy', 'F'), ('Stella', 'F'), ('Stephanie', 'F'),
('Stephen', 'M'), ('Steve', 'M'), ('Steven', 'M'),
('Summer', 'F'), ('Susan', 'F'), ('Suzanne', 'F'),
('Sydney', 'F'), ('Sylvia', 'F'), ('Talon', 'M'),
('Tamara', 'F'), ('Tami', 'F'), ('Tammy', 'F'),
('Tanner', 'M'), ('Tanya', 'F'), ('Tara', 'F'),
('Tasha', 'F'), ('Taylor', 'F'), ('Taylor', 'M'),
('Teresa', 'F'), ('Teri', 'F'), ('Terri', 'F'),
('Terry', 'F'), ('Terry', 'M'), ('Theodore', 'M'),
('Theresa', 'F'), ('Thomas', 'M'), ('Tiana', 'F'),
('Tiare', 'F'), ('Tiffany', 'F'), ('Tim', 'M'),
('Timothy', 'M'), ('Tina', 'F'), ('Tobias', 'M'),
('Todd', 'M'), ('Tom', 'M'), ('Tommy', 'M'),
('Toni', 'F'), ('Tony', 'M'), ('Tonya', 'F'),
('Tracey', 'F'), ('Traci', 'F'), ('Tracy', 'F'),
('Tracy', 'M'), ('Travis', 'M'), ('Trent', 'M'),
('Trevin', 'M'), ('Trevor', 'M'), ('Trey', 'M'),
('Trinity', 'F'), ('Tristan', 'M'), ('Troy', 'M'),
('Tucker', 'M'), ('Tulula', 'F'), ('Twyla', 'F'),
('Ty', 'M'), ('Tyler', 'M'), ('Tyrone', 'M'),
('Tyson', 'M'), ('Valentina', 'F'), ('Valeria', 'F'),
('Valerie', 'F'), ('Vanessa', 'F'), ('Vicki', 'F'),
('Vickie', 'F'), ('Victor', 'M'), ('Victoria', 'F'),
('Vincent', 'M'), ('Virginia', 'F'), ('Wade', 'M'),
('Walter', 'M'), ('Wanda', 'F'), ('Wayne', 'M'),
('Wendy', 'F'), ('Wesley', 'M'), ('Weston', 'M'),
('Whitney', 'F'), ('William', 'M'), ('Willie', 'M'),
('Wyatt', 'M'), ('Xavier', 'M'), ('Ximena', 'F'),
('Yolanda', 'F'), ('Yvonne', 'F'), ('Zachary', 'M'),
('Zoe', 'F'), ('Zoey', 'F');

-- This list of names comes from the U.S. Social Security Administration.
INSERT INTO familyName (name) VALUES
('Acosta'), ('Adams'), ('Adkins'),
('Aguilar'), ('Alexander'), ('Allen'),
('Alvarado'), ('Alvarez'), ('Anderson'),
('Andrews'), ('Armstrong'), ('Arnold'),
('Austin'), ('Avila'), ('Ayala'),
('Bailey'), ('Baker'), ('Baldwin'),
('Ball'), ('Banks'), ('Barber'),
('Barker'), ('Barnes'), ('Barnett'),
('Barrett'), ('Barton'), ('Bates'),
('Bauer'), ('Beck'), ('Becker'),
('Bell'), ('Bennett'), ('Benson'),
('Berry'), ('Bishop'), ('Black'),
('Blair'), ('Blake'), ('Bowen'),
('Bowers'), ('Bowman'), ('Boyd'),
('Bradley'), ('Brady'), ('Brewer'),
('Brooks'), ('Brown'), ('Bryant'),
('Buchanan'), ('Burgess'), ('Burke'),
('Burns'), ('Burton'), ('Bush'),
('Butler'), ('Byrd'), ('Caldwell'),
('Campbell'), ('Campos'), ('Cannon'),
('Carlson'), ('Carpenter'), ('Carr'),
('Carrillo'), ('Carroll'), ('Carter'),
('Casey'), ('Castillo'), ('Castro'),
('Chambers'), ('Chan'), ('Chandler'),
('Chang'), ('Chapman'), ('Chavez'),
('Chen'), ('Christensen'), ('Clark'),
('Clarke'), ('Cobb'), ('Cohen'),
('Cole'), ('Coleman'), ('Collins'),
('Conner'), ('Contreras'), ('Cook'),
('Cooper'), ('Cortez'), ('Cox'),
('Craig'), ('Crawford'), ('Cross'),
('Cruz'), ('Cummings'), ('Cunningham'),
('Curry'), ('Curtis'), ('Daniel'),
('Daniels'), ('Davidson'), ('Davis'),
('Dawson'), ('Day'), ('Dean'),
('Deleon'), ('Delgado'), ('Dennis'),
('Diaz'), ('Dixon'), ('Dominguez'),
('Douglas'), ('Doyle'), ('Duncan'),
('Dunn'), ('Duran'), ('Edwards'),
('Elliott'), ('Ellis'), ('Erickson'),
('Espinoza'), ('Estrada'), ('Evans'),
('Farmer'), ('Ferguson'), ('Fernandez'),
('Fields'), ('Figueroa'), ('Fischer'),
('Fisher'), ('Fitzgerald'), ('Fleming'),
('Fletcher'), ('Flores'), ('Floyd'),
('Flynn'), ('Ford'), ('Foster'),
('Fowler'), ('Fox'), ('Francis'),
('Frank'), ('Franklin'), ('Frazier'),
('Freeman'), ('French'), ('Fuller'),
('Gallagher'), ('Garcia'), ('Gardner'),
('Garner'), ('Garrett'), ('Garza'),
('George'), ('Gibbs'), ('Gibson'),
('Gilbert'), ('Gill'), ('Glover'),
('Gomez'), ('Gonzales'), ('Gonzalez'),
('Goodman'), ('Goodwin'), ('Gordon'),
('Graham'), ('Grant'), ('Graves'),
('Gray'), ('Green'), ('Greene'),
('Gregory'), ('Griffin'), ('griffith'),
('Gross'), ('Guerrero'), ('Gutierrez'),
('Guzman'), ('Hale'), ('Hall'),
('Hamilton'), ('Hammond'), ('Hampton'),
('Hansen'), ('Hanson'), ('Hardy'),
('Harmon'), ('Harper'), ('Harrington'),
('Harris'), ('Harrison'), ('Hart'),
('Hartman'), ('Harvey'), ('Hawkins'),
('Hayes'), ('Haynes'), ('Henderson'),
('Henry'), ('Hernandez'), ('Herrera'),
('Hicks'), ('Higgins'), ('Hill'),
('Hines'), ('Hodges'), ('Hoffman'),
('Hogan'), ('Holland'), ('Holmes'),
('Holt'), ('Hopkins'), ('Horton'),
('Howard'), ('Howell'), ('Hubbard'),
('Hudson'), ('Hughes'), ('Hunt'),
('Hunter'), ('Ingram'), ('Jackson'),
('Jacobs'), ('James'), ('Jenkins'),
('Jennings'), ('Jensen'), ('Jimenez'),
('Johnson'), ('Johnston'), ('Jones'),
('Jordan'), ('Joseph'), ('Juarez'),
('Keller'), ('Kelley'), ('Kelly'),
('Kennedy'), ('Kim'), ('King'),
('Klein'), ('Knight'), ('Kramer'),
('Lambert'), ('Lane'), ('Lang'),
('Larson'), ('Lawrence'), ('Lawson'),
('Le'), ('Lee'), ('Leon'),
('Leonard'), ('Lewis'), ('Lindsey'),
('Little'), ('Lloyd'), ('Logan'),
('Long'), ('Lopez'), ('Love'),
('Lowe'), ('Lucas'), ('Luna'),
('Lynch'), ('Lyons'), ('Mack'),
('Maldonado'), ('Malone'), ('Mann'),
('Manning'), ('Marquez'), ('Marsh'),
('Marshall'), ('Martin'), ('Martinez'),
('Mason'), ('Matthews'), ('Maxwell'),
('May'), ('McBride'), ('McCarthy'),
('McCormick'), ('McCoy'), ('McDaniel'),
('McDonald'), ('McGee'), ('McGuire'),
('McKinney'), ('McLaughlin'), ('Medina'),
('Mejia'), ('Mendez'), ('Mendoza'),
('Meyer'), ('Miles'), ('Miller'),
('Mills'), ('Miranda'), ('Mitchell'),
('Molina'), ('Montgomery'), ('Moody'),
('Moore'), ('Morales'), ('Moran'),
('Moreno'), ('Morgan'), ('Morris'),
('Morrison'), ('Moss'), ('Mueller'),
('Mullins'), ('Munoz'), ('Murphy'),
('Murray'), ('Myers'), ('Navarro'),
('Neal'), ('Nelson'), ('Newman'),
('Newton'), ('Nguyen'), ('Nichols'),
('Norman'), ('Norris'), ('Norton'),
('Nunez'), ('Obrien'), ('Oconnor'),
('Oliver'), ('Olson'), ('Ortega'),
('Ortiz'), ('Osborne'), ('Owen'),
('Owens'), ('Padilla'), ('Page'),
('Palmer'), ('Park'), ('Parker'),
('Parks'), ('Parsons'), ('Patel'),
('Patterson'), ('Patton'), ('Paul'),
('Payne'), ('Pearson'), ('Pena'),
('Perez'), ('Perkins'), ('Perry'),
('Peters'), ('Peterson'), ('Pham'),
('Phillips'), ('Pierce'), ('Pope'),
('Porter'), ('Potter'), ('Powell'),
('Powers'), ('Pratt'), ('Price'),
('Quinn'), ('Ramirez'), ('Ramos'),
('Ramsey'), ('Ray'), ('Reed'),
('Reese'), ('Reeves'), ('Reid'),
('Reyes'), ('Reynolds'), ('Rhodes'),
('Rice'), ('Richards'), ('Richardson'),
('Riley'), ('Rios'), ('Rivera'),
('Robbins'), ('Roberts'), ('Robertson'),
('Robinson'), ('Robles'), ('Rodgers'),
('Rodriguez'), ('Rogers'), ('Rojas'),
('Romero'), ('Rose'), ('Ross'),
('Rowe'), ('Ruiz'), ('Russell'),
('Ryan'), ('Salazar'), ('Salinas'),
('Sanchez'), ('Sanders'), ('Sandoval'),
('Santiago'), ('Santos'), ('Saunders'),
('Schmidt'), ('Schneider'), ('Schroeder'),
('Schultz'), ('Schwartz'), ('Scott'),
('Sharp'), ('Shaw'), ('Shelton'),
('Sherman'), ('Silva'), ('Simmons'),
('Simon'), ('Simpson'), ('Sims'),
('Singh'), ('Smith'), ('Snyder'),
('Solis'), ('Soto'), ('Sparks'),
('Spencer'), ('Stanley'), ('Steele'),
('Stephens'), ('Stevens'), ('Stevenson'),
('Stewart'), ('Stone'), ('Strickland'),
('Sullivan'), ('Sutton'), ('Swanson'),
('Tate'), ('Taylor'), ('Terry'),
('Thomas'), ('Thompson'), ('Thornton'),
('Todd'), ('Torres'), ('Townsend'),
('Tran'), ('Tucker'), ('Turner'),
('Tyler'), ('Valdez'), ('Vargas'),
('Vasquez'), ('Vaughn'), ('Vazquez'),
('Vega'), ('Wade'), ('Wagner'),
('Walker'), ('Wallace'), ('Walsh'),
('Walters'), ('Walton'), ('Wang'),
('Ward'), ('Warner'), ('Warren'),
('Washington'), ('Waters'), ('Watkins'),
('Watson'), ('Watts'), ('Weaver'),
('Webb'), ('Weber'), ('Webster'),
('Welch'), ('Wells'), ('West'),
('Wheeler'), ('White'), ('Williams'),
('Williamson'), ('Willis'), ('Wilson'),
('Wise'), ('Wolf'), ('Wolfe'),
('Wong'), ('Wood'), ('Woods'),
('Wright'), ('Yang'), ('Yates'),
('Young'), ('Zimmerman');

INSERT INTO street (name) VALUES
('Banana'), ('Oak'), ('Maple'),
('Apple'), ('Ash'), ('Spruce'),
('Pine'), ('Elm'), ('Hemlock'),
('Peach'), ('Pear'), ('Plum'),
('Cherry'), ('Magnolia'), ('Apricot'),
('Almond'), ('Peanut'), ('Cashew'),
('Chestnut'), ('Walnut'), ('Willow'),
('Aspen'), ('Oxford'), ('Penny'),
('Fox'), ('Bison'), ('Caribou'),
('Wapiti'), ('Lilac'), ('Mango'),
('Pinapple'), ('Watermelon'), ('Pumpkin'),
('Marigold'), ('Tulip'), ('Ridge'),
('Valley'), ('Plain'), ('Hill'),
('River'), ('Mozart'), ('Hadyn'),
('Beethoven'), ('Bach'), ('Poleline'),
('Washington'), ('Adams'), ('Jefferson'),
('Madison'), ('Monroe'), ('Jackson'),
('Van Buren'), ('Harrison'), ('Tyler'),
('Polk'), ('Taylor'), ('Fillmore'),
('Pierce'), ('Buchanan'), ('Lincoln'),
('Johnson'), ('Grant'), ('Hayes'),
('Garfield'), ('Arthur'), ('McKinley'),
('Roosevelt'), ('Taft'), ('Wilson'),
('Harding'), ('Coolidge'), ('Hoover'),
('Truman'), ('Eisenhower'), ('Kennedy'),
('Nixon'), ('Ford'), ('Carter'),
('Reagan'), ('Bush'), ('Clinton'),
('Obama'), ('Main'), ('First'),
('Second'), ('Third'), ('Fourth'),
('Fifth'), ('Sixth'), ('Seventh'),
('Eighth'), ('Ninth'), ('Tenth'),
('Blue'), ('Red'), ('Green'),
('Purple'), ('Orange'), ('Brown'),
('Black'), ('White'), ('Yellow');

INSERT INTO streetType (name) VALUES
('Ave'), ('Blvd'), ('Cir'), ('Ln'),
('Rd'), ('St'), ('Way');

INSERT INTO state (abbrev, name) VALUES
('AL', 'Alabama'),
('AK', 'Alaska'),
('AS', 'American Samoa'),
('AZ', 'Arizona'),
('AR', 'Arkansas'),
('CA', 'California'),
('CO', 'Colorado'),
('CT', 'Connecticut'),
('DE', 'Delaware'),
('DC', 'District of Columbia'),
('FM', 'Federated States of Micronesia'),
('FL', 'Florida'),
('GA', 'Georgia'),
('GU', 'Guam'),
('HI', 'Hawaii'),
('ID', 'Idaho'),
('IL', 'Illinois'),
('IN', 'Indiana'),
('IA', 'Iowa'),
('KS', 'Kansas'),
('KY', 'Kentucky'),
('LA', 'Louisiana'),
('ME', 'Maine'),
('MH', 'Marshall Islands'),
('MD', 'Maryland'),
('MA', 'Massachusetts'),
('MI', 'Michigan'),
('MN', 'Minnesota'),
('MS', 'Mississippi'),
('MO', 'Missouri'),
('MT', 'Montana'),
('NE', 'Nebraska'),
('NV', 'Nevada'),
('NH', 'New Hampshire'),
('NJ', 'New Jersey'),
('NM', 'New Mexico'),
('NY', 'New York'),
('NC', 'North Carolina'),
('ND', 'North Dakota'),
('MP', 'Northern Mariana Islands'),
('OH', 'Ohio'),
('OK', 'Oklahoma'),
('OR', 'Oregon'),
('PW', 'Palau'),
('PA', 'Pennsylvania'),
('PR', 'Puerto Rico'),
('RI', 'Rhode Island'),
('SC', 'South Carolina'),
('SD', 'South Dakota'),
('TN', 'Tennessee'),
('TX', 'Texas'),
('UT', 'Utah'),
('VT', 'Vermont'),
('VI', 'Virgin Islands'),
('VA', 'Virginia'),
('WA', 'Washington'),
('WV', 'West Virginia'),
('WI', 'Wisconsin'),
('WY', 'Wyoming'),
('AA', 'Armed Forces Americas'),
('AE', 'Armed Forces Europe'),
('AP', 'Armed Forces Pacific');

INSERT INTO zipCode (zipCode, areaCode, stateAbbrev, city) VALUES
('59001', '406', 'MT', 'Absarokee'),
('59002', '406', 'MT', 'Acton'),
('59003', '406', 'MT', 'Ashland'),
('59006', '406', 'MT', 'Ballantine'),
('59007', '406', 'MT', 'Bearcreek'),
('59008', '406', 'MT', 'Belfry'),
('59010', '406', 'MT', 'Bighorn'),
('59011', '406', 'MT', 'Big Timber'),
('59012', '406', 'MT', 'Birney'),
('59014', '406', 'MT', 'Bridger'),
('59015', '406', 'MT', 'Broadview'),
('59016', '406', 'MT', 'Busby'),
('59019', '406', 'MT', 'Columbus'),
('59022', '406', 'MT', 'Crow Agency'),
('59024', '406', 'MT', 'Custer'),
('59025', '406', 'MT', 'Decker'),
('59026', '406', 'MT', 'Edgar'),
('59027', '406', 'MT', 'Emigrant'),
('59028', '406', 'MT', 'Fishtail'),
('59029', '406', 'MT', 'Fromberg'),
('59030', '406', 'MT', 'Gardiner'),
('59031', '406', 'MT', 'Garryowen'),
('59032', '406', 'MT', 'Grass Range'),
('59033', '406', 'MT', 'Greycliff'),
('59034', '406', 'MT', 'Hardin'),
('59037', '406', 'MT', 'Huntley'),
('59038', '406', 'MT', 'Hysham'),
('59039', '406', 'MT', 'Ingomar'),
('59041', '406', 'MT', 'Joliet'),
('59044', '406', 'MT', 'Laurel'),
('59046', '406', 'MT', 'Lavina'),
('59047', '406', 'MT', 'Livingston'),
('59050', '406', 'MT', 'Lodge Grass'),
('59052', '406', 'MT', 'Mc Leod'),
('59053', '406', 'MT', 'Martinsdale'),
('59055', '406', 'MT', 'Melville'),
('59057', '406', 'MT', 'Molt'),
('59058', '406', 'MT', 'Mosby'),
('59059', '406', 'MT', 'Musselshell'),
('59061', '406', 'MT', 'Nye'),
('59062', '406', 'MT', 'Otter'),
('59063', '406', 'MT', 'Park City'),
('59064', '406', 'MT', 'Pompeys Pillar'),
('59065', '406', 'MT', 'Pray'),
('59067', '406', 'MT', 'Rapelje'),
('59068', '406', 'MT', 'Red Lodge'),
('59069', '406', 'MT', 'Reed Point'),
('59070', '406', 'MT', 'Roberts'),
('59071', '406', 'MT', 'Roscoe'),
('59072', '406', 'MT', 'Roundup'),
('59074', '406', 'MT', 'Ryegate'),
('59075', '406', 'MT', 'Saint Xavier'),
('59076', '406', 'MT', 'Sanders'),
('59077', '406', 'MT', 'Sand Springs'),
('59078', '406', 'MT', 'Shawmut'),
('59079', '406', 'MT', 'Shepherd'),
('59081', '406', 'MT', 'Silver Gate'),
('59084', '406', 'MT', 'Teigen'),
('59085', '406', 'MT', 'Two Dot'),
('59086', '406', 'MT', 'Wilsall'),
('59087', '406', 'MT', 'Winnett'),
('59088', '406', 'MT', 'Worden'),
('59089', '406', 'MT', 'Wyola'),
('59101', '406', 'MT', 'Billings'),
('59102', '406', 'MT', 'Billings'),
('59105', '406', 'MT', 'Billings'),
('59106', '406', 'MT', 'Billings'),
('59201', '406', 'MT', 'Wolf Point'),
('59211', '406', 'MT', 'Antelope'),
('59212', '406', 'MT', 'Bainville'),
('59213', '406', 'MT', 'Brockton'),
('59214', '406', 'MT', 'Brockway'),
('59215', '406', 'MT', 'Circle'),
('59218', '406', 'MT', 'Culbertson'),
('59219', '406', 'MT', 'Dagmar'),
('59221', '406', 'MT', 'Fairview'),
('59222', '406', 'MT', 'Flaxville'),
('59223', '406', 'MT', 'Fort Peck'),
('59225', '406', 'MT', 'Frazer'),
('59226', '406', 'MT', 'Froid'),
('59230', '406', 'MT', 'Glasgow'),
('59240', '406', 'MT', 'Glentana'),
('59241', '406', 'MT', 'Hinsdale'),
('59242', '406', 'MT', 'Homestead'),
('59243', '406', 'MT', 'Lambert'),
('59244', '406', 'MT', 'Larslan'),
('59247', '406', 'MT', 'Medicine Lake'),
('59248', '406', 'MT', 'Nashua'),
('59250', '406', 'MT', 'Opheim'),
('59252', '406', 'MT', 'Outlook'),
('59253', '406', 'MT', 'Peerless'),
('59254', '406', 'MT', 'Plentywood'),
('59255', '406', 'MT', 'Poplar'),
('59257', '406', 'MT', 'Redstone'),
('59258', '406', 'MT', 'Reserve'),
('59259', '406', 'MT', 'Richey'),
('59260', '406', 'MT', 'Richland'),
('59261', '406', 'MT', 'Saco'),
('59262', '406', 'MT', 'Savage'),
('59263', '406', 'MT', 'Scobey'),
('59270', '406', 'MT', 'Sidney'),
('59273', '406', 'MT', 'Vandalia'),
('59274', '406', 'MT', 'Vida'),
('59275', '406', 'MT', 'Westby'),
('59276', '406', 'MT', 'Whitetail'),
('59301', '406', 'MT', 'Miles City'),
('59311', '307', 'MT', 'Alzada'),
('59312', '406', 'MT', 'Angela'),
('59313', '406', 'MT', 'Baker'),
('59314', '406', 'MT', 'Biddle'),
('59315', '406', 'MT', 'Bloomfield'),
('59316', '406', 'MT', 'Boyes'),
('59317', '406', 'MT', 'Broadus'),
('59318', '406', 'MT', 'Brusett'),
('59319', '406', 'MT', 'Capitol'),
('59322', '406', 'MT', 'Cohagen'),
('59324', '406', 'MT', 'Ekalaka'),
('59326', '406', 'MT', 'Fallon'),
('59327', '406', 'MT', 'Forsyth'),
('59330', '406', 'MT', 'Glendive'),
('59332', '406', 'MT', 'Hammond'),
('59333', '406', 'MT', 'Hathaway'),
('59336', '406', 'MT', 'Ismay'),
('59337', '406', 'MT', 'Jordan'),
('59338', '406', 'MT', 'Kinsey'),
('59339', '406', 'MT', 'Lindsay'),
('59341', '406', 'MT', 'Mildred'),
('59343', '406', 'MT', 'Olive'),
('59344', '406', 'MT', 'Plevna'),
('59345', '406', 'MT', 'Powderville'),
('59347', '406', 'MT', 'Rosebud'),
('59349', '406', 'MT', 'Terry'),
('59351', '406', 'MT', 'Volborg'),
('59353', '406', 'MT', 'Wibaux'),
('59401', '406', 'MT', 'Great Falls'),
('59402', '406', 'MT', 'Malmstrom A F B'),
('59404', '406', 'MT', 'Great Falls'),
('59405', '406', 'MT', 'Great Falls'),
('59412', '406', 'MT', 'Belt'),
('59414', '406', 'MT', 'Black Eagle'),
('59416', '406', 'MT', 'Brady'),
('59417', '406', 'MT', 'Browning'),
('59418', '406', 'MT', 'Buffalo'),
('59419', '406', 'MT', 'Bynum'),
('59420', '406', 'MT', 'Carter'),
('59421', '406', 'MT', 'Cascade'),
('59422', '406', 'MT', 'Choteau'),
('59424', '406', 'MT', 'Coffee Creek'),
('59425', '406', 'MT', 'Conrad'),
('59427', '406', 'MT', 'Cut Bank'),
('59430', '406', 'MT', 'Denton'),
('59433', '406', 'MT', 'Dutton'),
('59436', '406', 'MT', 'Fairfield'),
('59440', '406', 'MT', 'Floweree'),
('59441', '406', 'MT', 'Forest Grove'),
('59442', '406', 'MT', 'Fort Benton'),
('59443', '406', 'MT', 'Fort Shaw'),
('59444', '406', 'MT', 'Galata'),
('59446', '406', 'MT', 'Geraldine'),
('59447', '406', 'MT', 'Geyser'),
('59450', '406', 'MT', 'Highwood'),
('59451', '406', 'MT', 'Hilger'),
('59452', '406', 'MT', 'Hobson'),
('59453', '406', 'MT', 'Judith Gap'),
('59454', '406', 'MT', 'Kevin'),
('59456', '406', 'MT', 'Ledger'),
('59457', '406', 'MT', 'Lewistown'),
('59460', '406', 'MT', 'Loma'),
('59461', '406', 'MT', 'Lothair'),
('59462', '406', 'MT', 'Moccasin'),
('59463', '406', 'MT', 'Monarch'),
('59464', '406', 'MT', 'Moore'),
('59465', '406', 'MT', 'Neihart'),
('59466', '406', 'MT', 'Oilmont'),
('59467', '406', 'MT', 'Pendroy'),
('59468', '406', 'MT', 'Power'),
('59469', '406', 'MT', 'Raynesford'),
('59471', '406', 'MT', 'Roy'),
('59472', '406', 'MT', 'Sand Coulee'),
('59474', '406', 'MT', 'Shelby'),
('59479', '406', 'MT', 'Stanford'),
('59480', '406', 'MT', 'Stockett'),
('59482', '406', 'MT', 'Sunburst'),
('59483', '406', 'MT', 'Sun River'),
('59484', '406', 'MT', 'Sweet Grass'),
('59486', '406', 'MT', 'Valier'),
('59487', '406', 'MT', 'Vaughn'),
('59489', '406', 'MT', 'Winifred'),
('59501', '406', 'MT', 'Havre'),
('59520', '406', 'MT', 'Big Sandy'),
('59521', '406', 'MT', 'Box Elder'),
('59522', '406', 'MT', 'Chester'),
('59523', '406', 'MT', 'Chinook'),
('59524', '406', 'MT', 'Dodson'),
('59525', '406', 'MT', 'Gildford'),
('59526', '406', 'MT', 'Harlem'),
('59528', '406', 'MT', 'Hingham'),
('59529', '406', 'MT', 'Hogeland'),
('59530', '406', 'MT', 'Inverness'),
('59531', '406', 'MT', 'Joplin'),
('59532', '406', 'MT', 'Kremlin'),
('59535', '406', 'MT', 'Lloyd'),
('59537', '406', 'MT', 'Loring'),
('59538', '406', 'MT', 'Malta'),
('59540', '406', 'MT', 'Rudyard'),
('59542', '406', 'MT', 'Turner'),
('59544', '406', 'MT', 'Whitewater'),
('59545', '406', 'MT', 'Whitlash'),
('59546', '406', 'MT', 'Zortman'),
('59547', '406', 'MT', 'Zurich'),
('59601', '406', 'MT', 'Helena'),
('59602', '406', 'MT', 'Helena'),
('59626', '406', 'MT', 'Helena'),
('59632', '406', 'MT', 'Boulder'),
('59633', '406', 'MT', 'Canyon Creek'),
('59634', '406', 'MT', 'Clancy'),
('59635', '406', 'MT', 'East Helena'),
('59639', '406', 'MT', 'Lincoln'),
('59641', '406', 'MT', 'Radersburg'),
('59643', '406', 'MT', 'Toston'),
('59644', '406', 'MT', 'Townsend'),
('59645', '406', 'MT', 'White Sulphur Springs'),
('59648', '406', 'MT', 'Wolf Creek'),
('59701', '406', 'MT', 'Butte'),
('59711', '406', 'MT', 'Anaconda'),
('59714', '406', 'MT', 'Belgrade'),
('59715', '406', 'MT', 'Bozeman'),
('59718', '406', 'MT', 'Bozeman'),
('59720', '406', 'MT', 'Cameron'),
('59721', '406', 'MT', 'Cardwell'),
('59722', '406', 'MT', 'Deer Lodge'),
('59725', '406', 'MT', 'Dillon'),
('59727', '406', 'MT', 'Divide'),
('59729', '406', 'MT', 'Ennis'),
('59730', '406', 'MT', 'Gallatin Gateway'),
('59731', '406', 'MT', 'Garrison'),
('59733', '406', 'MT', 'Gold Creek'),
('59736', '406', 'MT', 'Jackson'),
('59739', '406', 'MT', 'Lima'),
('59741', '406', 'MT', 'Manhattan'),
('59745', '406', 'MT', 'Norris'),
('59746', '406', 'MT', 'Polaris'),
('59749', '406', 'MT', 'Sheridan'),
('59750', '406', 'MT', 'Butte'),
('59751', '406', 'MT', 'Silver Star'),
('59752', '406', 'MT', 'Three Forks'),
('59754', '406', 'MT', 'Twin Bridges'),
('59755', '406', 'MT', 'Virginia City'),
('59758', '406', 'MT', 'West Yellowstone'),
('59759', '406', 'MT', 'Whitehall'),
('59761', '406', 'MT', 'Wisdom'),
('59762', '406', 'MT', 'Wise River'),
('59773', '406', 'MT', 'Bozeman'),
('59801', '406', 'MT', 'Missoula'),
('59802', '406', 'MT', 'Missoula'),
('59803', '406', 'MT', 'Missoula'),
('59804', '406', 'MT', 'Missoula'),
('59808', '406', 'MT', 'Missoula'),
('59820', '406', 'MT', 'Alberton'),
('59821', '406', 'MT', 'Arlee'),
('59823', '406', 'MT', 'Bonner'),
('59824', '406', 'MT', 'Charlo'),
('59825', '406', 'MT', 'Clinton'),
('59826', '406', 'MT', 'Condon'),
('59827', '406', 'MT', 'Conner'),
('59828', '406', 'MT', 'Corvallis'),
('59829', '406', 'MT', 'Darby'),
('59831', '406', 'MT', 'Dixon'),
('59832', '406', 'MT', 'Drummond'),
('59833', '406', 'MT', 'Florence'),
('59834', '406', 'MT', 'Frenchtown'),
('59837', '406', 'MT', 'Hall'),
('59840', '406', 'MT', 'Hamilton'),
('59843', '406', 'MT', 'Helmville'),
('59844', '406', 'MT', 'Heron'),
('59845', '406', 'MT', 'Hot Springs'),
('59846', '406', 'MT', 'Huson'),
('59847', '208', 'MT', 'Lolo'),
('59848', '406', 'MT', 'Lonepine'),
('59853', '406', 'MT', 'Noxon'),
('59854', '406', 'MT', 'Ovando'),
('59858', '406', 'MT', 'Philipsburg'),
('59859', '406', 'MT', 'Plains'),
('59860', '406', 'MT', 'Polson'),
('59863', '406', 'MT', 'Ravalli'),
('59864', '406', 'MT', 'Ronan'),
('59865', '406', 'MT', 'Saint Ignatius'),
('59866', '406', 'MT', 'Saint Regis'),
('59867', '406', 'MT', 'Saltese'),
('59868', '406', 'MT', 'Seeley Lake'),
('59870', '406', 'MT', 'Stevensville'),
('59871', '406', 'MT', 'Sula'),
('59872', '406', 'MT', 'Superior'),
('59873', '406', 'MT', 'Thompson Falls'),
('59874', '406', 'MT', 'Trout Creek'),
('59875', '406', 'MT', 'Victor'),
('59901', '406', 'MT', 'Kalispell'),
('59910', '406', 'MT', 'Big Arm'),
('59911', '406', 'MT', 'Bigfork'),
('59912', '406', 'MT', 'Columbia Falls'),
('59914', '406', 'MT', 'Dayton'),
('59915', '406', 'MT', 'Elmo'),
('59916', '406', 'MT', 'Essex'),
('59917', '406', 'MT', 'Eureka'),
('59920', '406', 'MT', 'Kila'),
('59922', '406', 'MT', 'Lakeside'),
('59923', '406', 'MT', 'Libby'),
('59925', '406', 'MT', 'Marion'),
('59926', '406', 'MT', 'Martin City'),
('59928', '406', 'MT', 'Polebridge'),
('59929', '406', 'MT', 'Proctor'),
('59930', '406', 'MT', 'Rexford'),
('59931', '406', 'MT', 'Rollins'),
('59932', '406', 'MT', 'Somers'),
('59935', '406', 'MT', 'Troy'),
('59937', '406', 'MT', 'Whitefish'),
('80002', '303', 'CO', 'Arvada'),
('80003', '720', 'CO', 'Arvada'),
('80004', '720', 'CO', 'Arvada'),
('80005', '303', 'CO', 'Arvada'),
('80007', '720', 'CO', 'Arvada'),
('80010', '303', 'CO', 'Aurora'),
('80011', '303', 'CO', 'Aurora'),
('80012', '303', 'CO', 'Aurora'),
('80013', '303', 'CO', 'Aurora'),
('80014', '303', 'CO', 'Aurora'),
('80015', '303', 'CO', 'Aurora'),
('80016', '720', 'CO', 'Aurora'),
('80017', '720', 'CO', 'Aurora'),
('80018', '303', 'CO', 'Aurora'),
('80019', '303', 'CO', 'Aurora'),
('80020', '303', 'CO', 'Broomfield'),
('80021', '720', 'CO', 'Broomfield'),
('80022', '303', 'CO', 'Commerce City'),
('80023', '303', 'CO', 'Broomfield'),
('80026', '720', 'CO', 'Lafayette'),
('80027', '303', 'CO', 'Louisville'),
('80030', '303', 'CO', 'Westminster'),
('80031', '303', 'CO', 'Westminster'),
('80033', '303', 'CO', 'Wheat Ridge'),
('80045', '303', 'CO', 'Aurora'),
('80047', '720', 'CO', 'Aurora'),
('80101', '719', 'CO', 'Agate'),
('80102', '303', 'CO', 'Bennett'),
('80103', '303', 'CO', 'Byers'),
('80104', '303', 'CO', 'Castle Rock'),
('80105', '303', 'CO', 'Deer Trail'),
('80106', '303', 'CO', 'Elbert'),
('80107', '303', 'CO', 'Elizabeth'),
('80108', '303', 'CO', 'Castle Rock'),
('80109', '303', 'CO', 'Castle Rock'),
('80110', '720', 'CO', 'Englewood'),
('80111', '303', 'CO', 'Englewood'),
('80112', '303', 'CO', 'Englewood'),
('80113', '303', 'CO', 'Englewood'),
('80116', '303', 'CO', 'Franktown'),
('80117', '303', 'CO', 'Kiowa'),
('80118', '720', 'CO', 'Larkspur'),
('80120', '303', 'CO', 'Littleton'),
('80121', '303', 'CO', 'Littleton'),
('80122', '303', 'CO', 'Littleton'),
('80123', '303', 'CO', 'Littleton'),
('80124', '303', 'CO', 'Lone Tree'),
('80125', '720', 'CO', 'Littleton'),
('80126', '720', 'CO', 'Littleton'),
('80127', '303', 'CO', 'Littleton'),
('80128', '720', 'CO', 'Littleton'),
('80129', '303', 'CO', 'Littleton'),
('80130', '720', 'CO', 'Littleton'),
('80132', '719', 'CO', 'Monument'),
('80133', '719', 'CO', 'Palmer Lake'),
('80134', '303', 'CO', 'Parker'),
('80135', '303', 'CO', 'Sedalia'),
('80136', '303', 'CO', 'Strasburg'),
('80137', '303', 'CO', 'Watkins'),
('80138', '720', 'CO', 'Parker'),
('80202', '303', 'CO', 'Denver'),
('80203', '303', 'CO', 'Denver'),
('80204', '303', 'CO', 'Denver'),
('80205', '303', 'CO', 'Denver'),
('80206', '303', 'CO', 'Denver'),
('80207', '303', 'CO', 'Denver'),
('80209', '720', 'CO', 'Denver'),
('80210', '720', 'CO', 'Denver'),
('80211', '720', 'CO', 'Denver'),
('80212', '720', 'CO', 'Denver'),
('80214', '303', 'CO', 'Denver'),
('80215', '303', 'CO', 'Denver'),
('80216', '720', 'CO', 'Denver'),
('80218', '303', 'CO', 'Denver'),
('80219', '303', 'CO', 'Denver'),
('80220', '303', 'CO', 'Denver'),
('80221', '303', 'CO', 'Denver'),
('80222', '303', 'CO', 'Denver'),
('80223', '720', 'CO', 'Denver'),
('80224', '303', 'CO', 'Denver'),
('80225', '303', 'CO', 'Denver'),
('80226', '303', 'CO', 'Denver'),
('80227', '720', 'CO', 'Denver'),
('80228', '303', 'CO', 'Denver'),
('80229', '303', 'CO', 'Denver'),
('80230', '720', 'CO', 'Denver'),
('80231', '303', 'CO', 'Denver'),
('80232', '303', 'CO', 'Denver'),
('80233', '720', 'CO', 'Denver'),
('80234', '303', 'CO', 'Denver'),
('80235', '303', 'CO', 'Denver'),
('80236', '720', 'CO', 'Denver'),
('80237', '303', 'CO', 'Denver'),
('80238', '303', 'CO', 'Denver'),
('80239', '720', 'CO', 'Denver'),
('80241', '303', 'CO', 'Thornton'),
('80246', '720', 'CO', 'Denver'),
('80247', '303', 'CO', 'Denver'),
('80249', '303', 'CO', 'Denver'),
('80260', '720', 'CO', 'Denver'),
('80264', '303', 'CO', 'Denver'),
('80265', '303', 'CO', 'Denver'),
('80266', '303', 'CO', 'Denver'),
('80290', '303', 'CO', 'Denver'),
('80293', '303', 'CO', 'Denver'),
('80294', '303', 'CO', 'Denver'),
('80295', '720', 'CO', 'Denver'),
('80299', '303', 'CO', 'Denver'),
('80301', '303', 'CO', 'Boulder'),
('80302', '303', 'CO', 'Boulder'),
('80303', '303', 'CO', 'Boulder'),
('80304', '720', 'CO', 'Boulder'),
('80305', '303', 'CO', 'Boulder'),
('80401', '303', 'CO', 'Golden'),
('80403', '303', 'CO', 'Golden'),
('80421', '720', 'CO', 'Bailey'),
('80422', '303', 'CO', 'Black Hawk'),
('80423', '970', 'CO', 'Bond'),
('80424', '970', 'CO', 'Breckenridge'),
('80428', '970', 'CO', 'Clark'),
('80430', '970', 'CO', 'Coalmont'),
('80433', '303', 'CO', 'Conifer'),
('80435', '970', 'CO', 'Dillon'),
('80439', '303', 'CO', 'Evergreen'),
('80440', '719', 'CO', 'Fairplay'),
('80446', '970', 'CO', 'Granby'),
('80447', '970', 'CO', 'Grand Lake'),
('80449', '719', 'CO', 'Hartsel'),
('80452', '303', 'CO', 'Idaho Springs'),
('80455', '303', 'CO', 'Jamestown'),
('80456', '719', 'CO', 'Jefferson'),
('80459', '970', 'CO', 'Kremmling'),
('80461', '719', 'CO', 'Leadville'),
('80463', '970', 'CO', 'Mc Coy'),
('80465', '303', 'CO', 'Morrison'),
('80466', '303', 'CO', 'Nederland'),
('80467', '970', 'CO', 'Oak Creek'),
('80468', '970', 'CO', 'Parshall'),
('80470', '303', 'CO', 'Pine'),
('80474', '303', 'CO', 'Rollinsville'),
('80479', '970', 'CO', 'Toponas'),
('80480', '970', 'CO', 'Walden'),
('80481', '303', 'CO', 'Ward'),
('80487', '970', 'CO', 'Steamboat Springs'),
('80498', '970', 'CO', 'Silverthorne'),
('80501', '720', 'CO', 'Longmont'),
('80503', '720', 'CO', 'Longmont'),
('80504', '303', 'CO', 'Longmont'),
('80510', '303', 'CO', 'Allenspark'),
('80512', '970', 'CO', 'Bellvue'),
('80513', '970', 'CO', 'Berthoud'),
('80514', '303', 'CO', 'Dacono'),
('80515', '970', 'CO', 'Drake'),
('80516', '303', 'CO', 'Erie'),
('80517', '970', 'CO', 'Estes Park'),
('80521', '970', 'CO', 'Fort Collins'),
('80524', '970', 'CO', 'Fort Collins'),
('80525', '970', 'CO', 'Fort Collins'),
('80526', '970', 'CO', 'Fort Collins'),
('80528', '970', 'CO', 'Fort Collins'),
('80530', '303', 'CO', 'Frederick'),
('80534', '970', 'CO', 'Johnstown'),
('80535', '970', 'CO', 'Laporte'),
('80536', '970', 'CO', 'Livermore'),
('80537', '970', 'CO', 'Loveland'),
('80538', '970', 'CO', 'Loveland'),
('80540', '303', 'CO', 'Lyons'),
('80542', '970', 'CO', 'Mead'),
('80543', '970', 'CO', 'Milliken'),
('80545', '970', 'CO', 'Red Feather Lakes'),
('80549', '970', 'CO', 'Wellington'),
('80550', '970', 'CO', 'Windsor'),
('80601', '720', 'CO', 'Brighton'),
('80602', '303', 'CO', 'Brighton'),
('80603', '303', 'CO', 'Brighton'),
('80610', '970', 'CO', 'Ault'),
('80611', '970', 'CO', 'Briggsdale'),
('80612', '970', 'CO', 'Carr'),
('80615', '970', 'CO', 'Eaton'),
('80620', '970', 'CO', 'Evans'),
('80621', '303', 'CO', 'Fort Lupton'),
('80622', '970', 'CO', 'Galeton'),
('80631', '970', 'CO', 'Greeley'),
('80634', '970', 'CO', 'Greeley'),
('80640', '720', 'CO', 'Henderson'),
('80642', '303', 'CO', 'Hudson'),
('80643', '303', 'CO', 'Keenesburg'),
('80644', '970', 'CO', 'Kersey'),
('80645', '970', 'CO', 'La Salle'),
('80648', '970', 'CO', 'Nunn'),
('80649', '970', 'CO', 'Orchard'),
('80650', '970', 'CO', 'Pierce'),
('80651', '970', 'CO', 'Platteville'),
('80652', '303', 'CO', 'Roggen'),
('80653', '970', 'CO', 'Weldona'),
('80654', '970', 'CO', 'Wiggins'),
('80701', '970', 'CO', 'Fort Morgan'),
('80705', '970', 'CO', 'Log Lane Village'),
('80720', '970', 'CO', 'Akron'),
('80721', '970', 'CO', 'Amherst'),
('80722', '970', 'CO', 'Atwood'),
('80723', '970', 'CO', 'Brush'),
('80726', '970', 'CO', 'Crook'),
('80727', '970', 'CO', 'Eckley'),
('80728', '970', 'CO', 'Fleming'),
('80729', '970', 'CO', 'Grover'),
('80731', '970', 'CO', 'Haxtun'),
('80733', '970', 'CO', 'Hillrose'),
('80734', '970', 'CO', 'Holyoke'),
('80735', '970', 'CO', 'Idalia'),
('80736', '970', 'CO', 'Iliff'),
('80737', '308', 'CO', 'Julesburg'),
('80740', '970', 'CO', 'Lindon'),
('80741', '970', 'CO', 'Merino'),
('80742', '970', 'CO', 'New Raymer'),
('80743', '970', 'CO', 'Otis'),
('80744', '970', 'CO', 'Ovid'),
('80745', '970', 'CO', 'Padroni'),
('80747', '970', 'CO', 'Peetz'),
('80749', '970', 'CO', 'Sedgwick'),
('80750', '970', 'CO', 'Snyder'),
('80751', '970', 'CO', 'Sterling'),
('80754', '970', 'CO', 'Stoneham'),
('80755', '970', 'CO', 'Vernon'),
('80757', '970', 'CO', 'Woodrow'),
('80758', '970', 'CO', 'Wray'),
('80759', '970', 'CO', 'Yuma'),
('80801', '970', 'CO', 'Anton'),
('80802', '719', 'CO', 'Arapahoe'),
('80804', '719', 'CO', 'Arriba'),
('80805', '719', 'CO', 'Bethune'),
('80807', '719', 'CO', 'Burlington'),
('80808', '719', 'CO', 'Calhan'),
('80809', '719', 'CO', 'Cascade'),
('80810', '719', 'CO', 'Cheyenne Wells'),
('80812', '970', 'CO', 'Cope'),
('80813', '719', 'CO', 'Cripple Creek'),
('80814', '719', 'CO', 'Divide'),
('80815', '719', 'CO', 'Flagler'),
('80816', '719', 'CO', 'Florissant'),
('80817', '719', 'CO', 'Fountain'),
('80818', '719', 'CO', 'Genoa'),
('80820', '719', 'CO', 'Guffey'),
('80821', '719', 'CO', 'Hugo'),
('80822', '970', 'CO', 'Joes'),
('80823', '719', 'CO', 'Karval'),
('80824', '970', 'CO', 'Kirk'),
('80825', '719', 'CO', 'Kit Carson'),
('80827', '719', 'CO', 'Lake George'),
('80828', '719', 'CO', 'Limon'),
('80829', '719', 'CO', 'Manitou Springs'),
('80830', '719', 'CO', 'Matheson'),
('80831', '719', 'CO', 'Peyton'),
('80832', '719', 'CO', 'Ramah'),
('80833', '719', 'CO', 'Rush'),
('80834', '970', 'CO', 'Seibert'),
('80835', '719', 'CO', 'Simla'),
('80836', '719', 'CO', 'Stratton'),
('80840', '719', 'CO', 'U S A F Academy'),
('80861', '970', 'CO', 'Vona'),
('80863', '719', 'CO', 'Woodland Park'),
('80864', '719', 'CO', 'Yoder'),
('80902', '719', 'CO', 'Colorado Springs'),
('80903', '719', 'CO', 'Colorado Springs'),
('80904', '719', 'CO', 'Colorado Springs'),
('80905', '719', 'CO', 'Colorado Springs'),
('80906', '719', 'CO', 'Colorado Springs'),
('80907', '719', 'CO', 'Colorado Springs'),
('80908', '719', 'CO', 'Colorado Springs'),
('80909', '719', 'CO', 'Colorado Springs'),
('80910', '719', 'CO', 'Colorado Springs'),
('80911', '719', 'CO', 'Colorado Springs'),
('80912', '719', 'CO', 'Colorado Springs'),
('80913', '719', 'CO', 'Colorado Springs'),
('80915', '719', 'CO', 'Colorado Springs'),
('80916', '719', 'CO', 'Colorado Springs'),
('80917', '719', 'CO', 'Colorado Springs'),
('80918', '719', 'CO', 'Colorado Springs'),
('80919', '719', 'CO', 'Colorado Springs'),
('80920', '719', 'CO', 'Colorado Springs'),
('80921', '719', 'CO', 'Colorado Springs'),
('80922', '719', 'CO', 'Colorado Springs'),
('80923', '719', 'CO', 'Colorado Springs'),
('80924', '719', 'CO', 'Colorado Springs'),
('80925', '719', 'CO', 'Colorado Springs'),
('80926', '719', 'CO', 'Colorado Springs'),
('80927', '719', 'CO', 'Colorado Springs'),
('80928', '719', 'CO', 'Colorado Springs'),
('80929', '719', 'CO', 'Colorado Springs'),
('80930', '719', 'CO', 'Colorado Springs'),
('80938', '719', 'CO', 'Colorado Springs'),
('80939', '719', 'CO', 'Colorado Springs'),
('80951', '719', 'CO', 'Colorado Springs'),
('81001', '719', 'CO', 'Pueblo'),
('81003', '719', 'CO', 'Pueblo'),
('81004', '719', 'CO', 'Pueblo'),
('81005', '719', 'CO', 'Pueblo'),
('81006', '719', 'CO', 'Pueblo'),
('81007', '719', 'CO', 'Pueblo'),
('81008', '719', 'CO', 'Pueblo'),
('81020', '719', 'CO', 'Aguilar'),
('81021', '719', 'CO', 'Arlington'),
('81022', '719', 'CO', 'Avondale'),
('81023', '719', 'CO', 'Beulah'),
('81025', '719', 'CO', 'Boone'),
('81027', '719', 'CO', 'Branson'),
('81029', '719', 'CO', 'Campo'),
('81036', '719', 'CO', 'Eads'),
('81039', '719', 'CO', 'Fowler'),
('81040', '719', 'CO', 'Gardner'),
('81041', '719', 'CO', 'Granada'),
('81044', '719', 'CO', 'Hasty'),
('81045', '719', 'CO', 'Haswell'),
('81047', '719', 'CO', 'Holly'),
('81049', '719', 'CO', 'Kim'),
('81050', '719', 'CO', 'La Junta'),
('81052', '719', 'CO', 'Lamar'),
('81054', '719', 'CO', 'Las Animas'),
('81055', '719', 'CO', 'La Veta'),
('81057', '719', 'CO', 'Mc Clave'),
('81058', '719', 'CO', 'Manzanola'),
('81062', '719', 'CO', 'Olney Springs'),
('81063', '719', 'CO', 'Ordway'),
('81064', '719', 'CO', 'Pritchett'),
('81067', '719', 'CO', 'Rocky Ford'),
('81069', '719', 'CO', 'Rye'),
('81071', '719', 'CO', 'Sheridan Lake'),
('81073', '719', 'CO', 'Springfield'),
('81076', '719', 'CO', 'Sugar City'),
('81081', '719', 'CO', 'Trinchera'),
('81082', '719', 'CO', 'Trinidad'),
('81084', '719', 'CO', 'Two Buttes'),
('81089', '719', 'CO', 'Walsenburg'),
('81090', '719', 'CO', 'Walsh'),
('81091', '719', 'CO', 'Weston'),
('81092', '719', 'CO', 'Wiley'),
('81101', '719', 'CO', 'Alamosa'),
('81120', '719', 'CO', 'Antonito'),
('81122', '970', 'CO', 'Bayfield'),
('81123', '719', 'CO', 'Blanca'),
('81125', '719', 'CO', 'Center'),
('81127', '970', 'CO', 'Chimney Rock'),
('81130', '719', 'CO', 'Creede'),
('81132', '719', 'CO', 'Del Norte'),
('81133', '719', 'CO', 'Fort Garland'),
('81134', '719', 'CO', 'San Luis'),
('81136', '719', 'CO', 'Hooper'),
('81137', '970', 'CO', 'Ignacio'),
('81140', '719', 'CO', 'La Jara'),
('81143', '719', 'CO', 'Moffat'),
('81144', '719', 'CO', 'Monte Vista'),
('81146', '719', 'CO', 'Mosca'),
('81147', '970', 'CO', 'Pagosa Springs'),
('81149', '719', 'CO', 'Saguache'),
('81151', '719', 'CO', 'Sanford'),
('81152', '719', 'CO', 'San Luis'),
('81154', '719', 'CO', 'South Fork'),
('81155', '719', 'CO', 'Villa Grove'),
('81201', '719', 'CO', 'Salida'),
('81210', '970', 'CO', 'Almont'),
('81211', '719', 'CO', 'Buena Vista'),
('81212', '719', 'CO', 'Canon City'),
('81220', '970', 'CO', 'Cimarron'),
('81223', '719', 'CO', 'Cotopaxi'),
('81224', '970', 'CO', 'Crested Butte'),
('81226', '719', 'CO', 'Florence'),
('81230', '970', 'CO', 'Gunnison'),
('81233', '719', 'CO', 'Howard'),
('81235', '970', 'CO', 'Lake City'),
('81236', '719', 'CO', 'Nathrop'),
('81237', '970', 'CO', 'Ohio City'),
('81239', '970', 'CO', 'Parlin'),
('81240', '719', 'CO', 'Penrose'),
('81243', '970', 'CO', 'Powderhorn'),
('81247', '970', 'CO', 'Gunnison'),
('81251', '719', 'CO', 'Twin Lakes'),
('81252', '719', 'CO', 'Westcliffe'),
('81253', '719', 'CO', 'Wetmore'),
('81301', '970', 'CO', 'Durango'),
('81303', '970', 'CO', 'Durango'),
('81320', '970', 'CO', 'Cahone'),
('81321', '970', 'CO', 'Cortez'),
('81323', '970', 'CO', 'Dolores'),
('81324', '970', 'CO', 'Dove Creek'),
('81325', '970', 'CO', 'Egnar'),
('81326', '970', 'CO', 'Hesperus'),
('81327', '970', 'CO', 'Lewis'),
('81328', '970', 'CO', 'Mancos'),
('81331', '970', 'CO', 'Pleasant View'),
('81335', '970', 'CO', 'Yellow Jacket'),
('81401', '970', 'CO', 'Montrose'),
('81403', '970', 'CO', 'Montrose'),
('81410', '970', 'CO', 'Austin'),
('81411', '970', 'CO', 'Bedrock'),
('81413', '970', 'CO', 'Cedaredge'),
('81415', '970', 'CO', 'Crawford'),
('81416', '970', 'CO', 'Delta'),
('81418', '970', 'CO', 'Eckert'),
('81419', '970', 'CO', 'Hotchkiss'),
('81422', '970', 'CO', 'Naturita'),
('81424', '970', 'CO', 'Nucla'),
('81425', '970', 'CO', 'Olathe'),
('81428', '970', 'CO', 'Paonia'),
('81431', '970', 'CO', 'Redvale'),
('81432', '970', 'CO', 'Ridgway'),
('81434', '970', 'CO', 'Somerset'),
('81435', '970', 'CO', 'Telluride'),
('81501', '970', 'CO', 'Grand Junction'),
('81503', '970', 'CO', 'Grand Junction'),
('81504', '970', 'CO', 'Grand Junction'),
('81505', '970', 'CO', 'Grand Junction'),
('81506', '970', 'CO', 'Grand Junction'),
('81507', '970', 'CO', 'Grand Junction'),
('81520', '970', 'CO', 'Clifton'),
('81521', '970', 'CO', 'Fruita'),
('81522', '970', 'CO', 'Gateway'),
('81523', '970', 'CO', 'Glade Park'),
('81524', '970', 'CO', 'Loma'),
('81525', '970', 'CO', 'Mack'),
('81526', '970', 'CO', 'Palisade'),
('81527', '970', 'CO', 'Whitewater'),
('81601', '970', 'CO', 'Glenwood Springs'),
('81610', '970', 'CO', 'Dinosaur'),
('81611', '970', 'CO', 'Aspen'),
('81621', '970', 'CO', 'Basalt'),
('81623', '970', 'CO', 'Carbondale'),
('81624', '970', 'CO', 'Collbran'),
('81625', '970', 'CO', 'Craig'),
('81630', '970', 'CO', 'De Beque'),
('81632', '970', 'CO', 'Edwards'),
('81633', '970', 'CO', 'Dinosaur'),
('81635', '970', 'CO', 'Parachute'),
('81637', '970', 'CO', 'Gypsum'),
('81639', '970', 'CO', 'Hayden'),
('81640', '970', 'CO', 'Maybell'),
('81641', '970', 'CO', 'Meeker'),
('81642', '970', 'CO', 'Meredith'),
('81643', '970', 'CO', 'Mesa'),
('81647', '970', 'CO', 'New Castle'),
('81648', '970', 'CO', 'Rangely'),
('81650', '970', 'CO', 'Rifle'),
('81652', '970', 'CO', 'Silt'),
('81653', '970', 'CO', 'Slater'),
('81654', '970', 'CO', 'Snowmass'),
('81657', '970', 'CO', 'Vail'),
('82001', '307', 'WY', 'Cheyenne'),
('82005', '307', 'WY', 'Fe Warren Afb'),
('82007', '307', 'WY', 'Cheyenne'),
('82009', '307', 'WY', 'Cheyenne'),
('82050', '307', 'WY', 'Albin'),
('82051', '307', 'WY', 'Bosler'),
('82052', '307', 'WY', 'Buford'),
('82053', '307', 'WY', 'Burns'),
('82054', '307', 'WY', 'Carpenter'),
('82058', '307', 'WY', 'Garrett'),
('82063', '970', 'WY', 'Jelm'),
('82070', '307', 'WY', 'Laramie'),
('82072', '307', 'WY', 'Laramie'),
('82081', '307', 'WY', 'Meriden'),
('82082', '307', 'WY', 'Pine Bluffs'),
('82083', '307', 'WY', 'Rock River'),
('82190', '307', 'WY', 'Yellowstone National Park'),
('82201', '307', 'WY', 'Wheatland'),
('82210', '307', 'WY', 'Chugwater'),
('82212', '307', 'WY', 'Fort Laramie'),
('82213', '307', 'WY', 'Glendo'),
('82214', '307', 'WY', 'Guernsey'),
('82215', '307', 'WY', 'Hartville'),
('82217', '307', 'WY', 'Hawk Springs'),
('82219', '307', 'WY', 'Jay Em'),
('82221', '307', 'WY', 'Lagrange'),
('82222', '307', 'WY', 'Lance Creek'),
('82223', '307', 'WY', 'Lingle'),
('82224', '307', 'WY', 'Lost Springs'),
('82225', '307', 'WY', 'Lusk'),
('82227', '307', 'WY', 'Manville'),
('82229', '307', 'WY', 'Shawnee'),
('82240', '307', 'WY', 'Torrington'),
('82242', '307', 'WY', 'Van Tassell'),
('82243', '307', 'WY', 'Veteran'),
('82244', '307', 'WY', 'Yoder'),
('82301', '307', 'WY', 'Rawlins'),
('82310', '307', 'WY', 'Jeffrey City'),
('82321', '307', 'WY', 'Baggs'),
('82323', '307', 'WY', 'Dixon'),
('82325', '307', 'WY', 'Encampment'),
('82327', '307', 'WY', 'Hanna'),
('82329', '307', 'WY', 'Medicine Bow'),
('82331', '307', 'WY', 'Saratoga'),
('82332', '307', 'WY', 'Savery'),
('82334', '307', 'WY', 'Sinclair'),
('82401', '307', 'WY', 'Worland'),
('82410', '307', 'WY', 'Basin'),
('82411', '307', 'WY', 'Burlington'),
('82414', '307', 'WY', 'Cody'),
('82421', '307', 'WY', 'Deaver'),
('82426', '307', 'WY', 'Greybull'),
('82428', '307', 'WY', 'Hyattville'),
('82431', '307', 'WY', 'Lovell'),
('82432', '307', 'WY', 'Manderson'),
('82433', '307', 'WY', 'Meeteetse'),
('82434', '307', 'WY', 'Otto'),
('82435', '307', 'WY', 'Powell'),
('82441', '307', 'WY', 'Shell'),
('82442', '307', 'WY', 'Ten Sleep'),
('82443', '307', 'WY', 'Thermopolis'),
('82501', '307', 'WY', 'Riverton'),
('82510', '307', 'WY', 'Arapahoe'),
('82512', '307', 'WY', 'Crowheart'),
('82513', '307', 'WY', 'Dubois'),
('82514', '307', 'WY', 'Fort Washakie'),
('82516', '307', 'WY', 'Kinnear'),
('82520', '307', 'WY', 'Lander'),
('82523', '307', 'WY', 'Pavillion'),
('82601', '307', 'WY', 'Casper'),
('82604', '307', 'WY', 'Casper'),
('82609', '307', 'WY', 'Casper'),
('82615', '307', 'WY', 'Shirley Basin'),
('82620', '307', 'WY', 'Alcova'),
('82630', '307', 'WY', 'Arminto'),
('82633', '307', 'WY', 'Douglas'),
('82636', '307', 'WY', 'Evansville'),
('82637', '307', 'WY', 'Glenrock'),
('82638', '307', 'WY', 'Hiland'),
('82639', '307', 'WY', 'Kaycee'),
('82642', '307', 'WY', 'Lysite'),
('82643', '307', 'WY', 'Midwest'),
('82646', '307', 'WY', 'Natrona'),
('82649', '307', 'WY', 'Shoshoni'),
('82701', '307', 'WY', 'Newcastle'),
('82710', '307', 'WY', 'Aladdin'),
('82711', '307', 'WY', 'Alva'),
('82712', '307', 'WY', 'Beulah'),
('82714', '307', 'WY', 'Devils Tower'),
('82715', '307', 'WY', 'Four Corners'),
('82716', '307', 'WY', 'Gillette'),
('82718', '307', 'WY', 'Gillette'),
('82720', '307', 'WY', 'Hulett'),
('82721', '307', 'WY', 'Moorcroft'),
('82723', '307', 'WY', 'Osage'),
('82725', '307', 'WY', 'Recluse'),
('82727', '307', 'WY', 'Rozet'),
('82729', '307', 'WY', 'Sundance'),
('82730', '307', 'WY', 'Upton'),
('82731', '307', 'WY', 'Weston'),
('82801', '307', 'WY', 'Sheridan'),
('82831', '307', 'WY', 'Arvada'),
('82832', '307', 'WY', 'Banner'),
('82834', '307', 'WY', 'Buffalo'),
('82835', '307', 'WY', 'Clearmont'),
('82836', '307', 'WY', 'Dayton'),
('82838', '307', 'WY', 'Parkman'),
('82839', '307', 'WY', 'Ranchester'),
('82842', '307', 'WY', 'Story'),
('82844', '307', 'WY', 'Wolf'),
('82901', '307', 'WY', 'Rock Springs'),
('82922', '307', 'WY', 'Bondurant'),
('82923', '307', 'WY', 'Boulder'),
('82925', '307', 'WY', 'Cora'),
('82930', '307', 'WY', 'Evanston'),
('82932', '307', 'WY', 'Farson'),
('82933', '307', 'WY', 'Fort Bridger'),
('82935', '307', 'WY', 'Green River'),
('82936', '307', 'WY', 'Lonetree'),
('82937', '307', 'WY', 'Lyman'),
('82941', '307', 'WY', 'Pinedale'),
('83001', '307', 'WY', 'Jackson'),
('83011', '307', 'WY', 'Kelly'),
('83012', '307', 'WY', 'Moose'),
('83013', '307', 'WY', 'Moran'),
('83014', '307', 'WY', 'Wilson'),
('83101', '307', 'WY', 'Kemmerer'),
('83110', '307', 'WY', 'Afton'),
('83111', '208', 'WY', 'Auburn'),
('83112', '307', 'WY', 'Bedford'),
('83113', '307', 'WY', 'Big Piney'),
('83114', '307', 'WY', 'Cokeville'),
('83115', '307', 'WY', 'Daniel'),
('83118', '307', 'WY', 'Etna'),
('83120', '208', 'WY', 'Freedom'),
('83122', '307', 'WY', 'Grover'),
('83123', '307', 'WY', 'La Barge'),
('83126', '307', 'WY', 'Smoot'),
('83127', '307', 'WY', 'Thayne'),
('83128', '307', 'WY', 'Alpine'),
('83201', '208', 'ID', 'Pocatello'),
('83202', '208', 'ID', 'Pocatello'),
('83204', '208', 'ID', 'Pocatello'),
('83210', '208', 'ID', 'Aberdeen'),
('83211', '208', 'ID', 'American Falls'),
('83212', '208', 'ID', 'Arbon'),
('83213', '208', 'ID', 'Arco'),
('83214', '208', 'ID', 'Arimo'),
('83215', '208', 'ID', 'Atomic City'),
('83217', '208', 'ID', 'Bancroft'),
('83220', '208', 'ID', 'Bern'),
('83221', '208', 'ID', 'Blackfoot'),
('83226', '208', 'ID', 'Challis'),
('83227', '208', 'ID', 'Clayton'),
('83228', '208', 'ID', 'Clifton'),
('83229', '208', 'ID', 'Cobalt'),
('83230', '208', 'ID', 'Conda'),
('83232', '208', 'ID', 'Dayton'),
('83234', '208', 'ID', 'Downey'),
('83235', '208', 'ID', 'Ellis'),
('83236', '208', 'ID', 'Firth'),
('83237', '208', 'ID', 'Franklin'),
('83238', '208', 'ID', 'Geneva'),
('83241', '208', 'ID', 'Grace'),
('83243', '208', 'ID', 'Holbrook'),
('83244', '208', 'ID', 'Howe'),
('83245', '208', 'ID', 'Inkom'),
('83246', '208', 'ID', 'Lava Hot Springs'),
('83250', '208', 'ID', 'Mccammon'),
('83251', '208', 'ID', 'Mackay'),
('83252', '208', 'ID', 'Malad City'),
('83253', '208', 'ID', 'May'),
('83254', '208', 'ID', 'Montpelier'),
('83255', '208', 'ID', 'Moore'),
('83262', '208', 'ID', 'Pingree'),
('83263', '208', 'ID', 'Preston'),
('83271', '208', 'ID', 'Rockland'),
('83272', '208', 'ID', 'Saint Charles'),
('83274', '208', 'ID', 'Shelley'),
('83276', '208', 'ID', 'Soda Springs'),
('83277', '208', 'ID', 'Springfield'),
('83278', '208', 'ID', 'Stanley'),
('83283', '208', 'ID', 'Thatcher'),
('83285', '208', 'ID', 'Wayan'),
('83286', '208', 'ID', 'Weston'),
('83287', '208', 'ID', 'Fish Haven'),
('83301', '208', 'ID', 'Twin Falls'),
('83302', '208', 'ID', 'Rogerson'),
('83311', '208', 'ID', 'Albion'),
('83313', '208', 'ID', 'Bellevue'),
('83314', '208', 'ID', 'Bliss'),
('83316', '208', 'ID', 'Buhl'),
('83318', '208', 'ID', 'Burley'),
('83320', '208', 'ID', 'Carey'),
('83321', '208', 'ID', 'Castleford'),
('83322', '208', 'ID', 'Corral'),
('83323', '208', 'ID', 'Declo'),
('83324', '208', 'ID', 'Dietrich'),
('83325', '208', 'ID', 'Eden'),
('83327', '208', 'ID', 'Fairfield'),
('83328', '208', 'ID', 'Filer'),
('83330', '208', 'ID', 'Gooding'),
('83332', '208', 'ID', 'Hagerman'),
('83333', '208', 'ID', 'Hailey'),
('83334', '208', 'ID', 'Hansen'),
('83335', '208', 'ID', 'Hazelton'),
('83336', '208', 'ID', 'Heyburn'),
('83338', '208', 'ID', 'Jerome'),
('83340', '208', 'ID', 'Ketchum'),
('83341', '208', 'ID', 'Kimberly'),
('83342', '208', 'ID', 'Malta'),
('83344', '208', 'ID', 'Murtaugh'),
('83346', '208', 'ID', 'Oakley'),
('83347', '208', 'ID', 'Paul'),
('83348', '208', 'ID', 'Picabo'),
('83349', '208', 'ID', 'Richfield'),
('83350', '208', 'ID', 'Rupert'),
('83352', '208', 'ID', 'Shoshone'),
('83355', '208', 'ID', 'Wendell'),
('83401', '208', 'ID', 'Idaho Falls'),
('83402', '208', 'ID', 'Idaho Falls'),
('83404', '208', 'ID', 'Idaho Falls'),
('83406', '208', 'ID', 'Idaho Falls'),
('83414', '307', 'WY', 'Alta'),
('83420', '208', 'ID', 'Ashton'),
('83422', '307', 'ID', 'Driggs'),
('83423', '208', 'ID', 'Dubois'),
('83424', '208', 'ID', 'Felt'),
('83425', '208', 'ID', 'Hamer'),
('83427', '208', 'ID', 'Iona'),
('83428', '208', 'ID', 'Irwin'),
('83429', '208', 'ID', 'Island Park'),
('83431', '208', 'ID', 'Lewisville'),
('83434', '208', 'ID', 'Menan'),
('83435', '208', 'ID', 'Monteview'),
('83436', '208', 'ID', 'Newdale'),
('83440', '208', 'ID', 'Rexburg'),
('83442', '208', 'ID', 'Rigby'),
('83443', '208', 'ID', 'Ririe'),
('83444', '208', 'ID', 'Roberts'),
('83445', '208', 'ID', 'Saint Anthony'),
('83446', '208', 'ID', 'Spencer'),
('83448', '208', 'ID', 'Sugar City'),
('83449', '208', 'ID', 'Swan Valley'),
('83450', '208', 'ID', 'Terreton'),
('83451', '208', 'ID', 'Teton'),
('83452', '208', 'ID', 'Tetonia'),
('83455', '208', 'ID', 'Victor'),
('83462', '208', 'ID', 'Carmen'),
('83463', '208', 'ID', 'Gibbonsville'),
('83464', '208', 'ID', 'Leadore'),
('83466', '208', 'ID', 'North Fork'),
('83467', '208', 'ID', 'Salmon'),
('83469', '208', 'ID', 'Shoup'),
('83501', '208', 'ID', 'Lewiston'),
('83520', '208', 'ID', 'Ahsahka'),
('83522', '208', 'ID', 'Cottonwood'),
('83523', '208', 'ID', 'Craigmont'),
('83524', '208', 'ID', 'Culdesac'),
('83525', '208', 'ID', 'Elk City'),
('83526', '208', 'ID', 'Ferdinand'),
('83530', '208', 'ID', 'Grangeville'),
('83533', '208', 'ID', 'Greencreek'),
('83535', '208', 'ID', 'Juliaetta'),
('83536', '208', 'ID', 'Kamiah'),
('83537', '208', 'ID', 'Kendrick'),
('83539', '208', 'ID', 'Kooskia'),
('83540', '208', 'ID', 'Lapwai'),
('83541', '208', 'ID', 'Lenore'),
('83542', '208', 'ID', 'Lucile'),
('83543', '208', 'ID', 'Nezperce'),
('83544', '208', 'ID', 'Orofino'),
('83545', '208', 'ID', 'Peck'),
('83546', '208', 'ID', 'Pierce'),
('83547', '208', 'ID', 'Pollock'),
('83548', '208', 'ID', 'Reubens'),
('83549', '208', 'ID', 'Riggins'),
('83552', '208', 'ID', 'Stites'),
('83553', '208', 'ID', 'Weippe'),
('83554', '208', 'ID', 'White Bird'),
('83555', '208', 'ID', 'Winchester'),
('83602', '208', 'ID', 'Banks'),
('83604', '208', 'ID', 'Bruneau'),
('83605', '208', 'ID', 'Caldwell'),
('83607', '208', 'ID', 'Caldwell'),
('83610', '208', 'ID', 'Cambridge'),
('83611', '208', 'ID', 'Cascade'),
('83612', '208', 'ID', 'Council'),
('83615', '208', 'ID', 'Donnelly'),
('83616', '208', 'ID', 'Eagle'),
('83617', '208', 'ID', 'Emmett'),
('83619', '208', 'ID', 'Fruitland'),
('83622', '208', 'ID', 'Garden Valley'),
('83623', '208', 'ID', 'Glenns Ferry'),
('83624', '208', 'ID', 'Grand View'),
('83626', '208', 'ID', 'Greenleaf'),
('83627', '208', 'ID', 'Hammett'),
('83628', '208', 'ID', 'Homedale'),
('83629', '208', 'ID', 'Horseshoe Bend'),
('83631', '208', 'ID', 'Idaho City'),
('83632', '208', 'ID', 'Indian Valley'),
('83633', '208', 'ID', 'King Hill'),
('83634', '208', 'ID', 'Kuna'),
('83637', '208', 'ID', 'Lowman'),
('83638', '208', 'ID', 'Mccall'),
('83639', '208', 'ID', 'Marsing'),
('83641', '208', 'ID', 'Melba'),
('83642', '208', 'ID', 'Meridian'),
('83643', '208', 'ID', 'Mesa'),
('83644', '208', 'ID', 'Middleton'),
('83645', '208', 'ID', 'Midvale'),
('83646', '208', 'ID', 'Meridian'),
('83647', '208', 'ID', 'Mountain Home'),
('83648', '208', 'ID', 'Mountain Home A F B'),
('83650', '208', 'ID', 'Murphy'),
('83651', '208', 'ID', 'Nampa'),
('83654', '208', 'ID', 'New Meadows'),
('83655', '208', 'ID', 'New Plymouth'),
('83657', '208', 'ID', 'Ola'),
('83660', '208', 'ID', 'Parma'),
('83661', '208', 'ID', 'Payette'),
('83666', '208', 'ID', 'Placerville'),
('83669', '208', 'ID', 'Star'),
('83670', '208', 'ID', 'Sweet'),
('83672', '208', 'ID', 'Weiser'),
('83676', '208', 'ID', 'Wilder'),
('83677', '208', 'ID', 'Yellow Pine'),
('83686', '208', 'ID', 'Nampa'),
('83687', '208', 'ID', 'Nampa'),
('83702', '208', 'ID', 'Boise'),
('83703', '208', 'ID', 'Boise'),
('83704', '208', 'ID', 'Boise'),
('83705', '208', 'ID', 'Boise'),
('83706', '208', 'ID', 'Boise'),
('83708', '208', 'ID', 'Boise'),
('83709', '208', 'ID', 'Boise'),
('83712', '208', 'ID', 'Boise'),
('83713', '208', 'ID', 'Boise'),
('83714', '208', 'ID', 'Garden City'),
('83716', '208', 'ID', 'Boise'),
('83801', '208', 'ID', 'Athol'),
('83802', '208', 'ID', 'Avery'),
('83803', '208', 'ID', 'Bayview'),
('83804', '208', 'ID', 'Blanchard'),
('83805', '208', 'ID', 'Bonners Ferry'),
('83808', '208', 'ID', 'Calder'),
('83809', '208', 'ID', 'Careywood'),
('83810', '208', 'ID', 'Cataldo'),
('83811', '208', 'ID', 'Clark Fork'),
('83812', '208', 'ID', 'Clarkia'),
('83813', '208', 'ID', 'Cocolalla'),
('83814', '208', 'ID', 'Coeur D Alene'),
('83815', '208', 'ID', 'Coeur D Alene'),
('83821', '208', 'ID', 'Coolin'),
('83822', '208', 'ID', 'Oldtown'),
('83823', '208', 'ID', 'Deary'),
('83824', '208', 'ID', 'Desmet'),
('83830', '208', 'ID', 'Fernwood'),
('83832', '208', 'ID', 'Genesee'),
('83833', '208', 'ID', 'Harrison'),
('83834', '208', 'ID', 'Harvard'),
('83835', '208', 'ID', 'Hayden'),
('83836', '208', 'ID', 'Hope'),
('83837', '208', 'ID', 'Kellogg'),
('83839', '208', 'ID', 'Kingston'),
('83842', '208', 'ID', 'Medimont'),
('83843', '208', 'ID', 'Moscow'),
('83845', '208', 'ID', 'Moyie Springs'),
('83846', '208', 'ID', 'Mullan'),
('83847', '208', 'ID', 'Naples'),
('83848', '208', 'ID', 'Nordman'),
('83850', '208', 'ID', 'Pinehurst'),
('83851', '208', 'ID', 'Plummer'),
('83852', '208', 'ID', 'Ponderay'),
('83853', '208', 'ID', 'Porthill'),
('83854', '208', 'ID', 'Post Falls'),
('83855', '208', 'ID', 'Potlatch'),
('83856', '208', 'ID', 'Priest River'),
('83857', '208', 'ID', 'Princeton'),
('83858', '208', 'ID', 'Rathdrum'),
('83860', '208', 'ID', 'Sagle'),
('83861', '208', 'ID', 'Saint Maries'),
('83864', '208', 'ID', 'Sandpoint'),
('83868', '208', 'ID', 'Smelterville'),
('83869', '208', 'ID', 'Spirit Lake'),
('83870', '208', 'ID', 'Tensed'),
('83871', '208', 'ID', 'Troy'),
('83872', '208', 'ID', 'Viola'),
('83873', '208', 'ID', 'Wallace'),
('83876', '208', 'ID', 'Worley'),
('84001', '435', 'UT', 'Altamont'),
('84002', '435', 'UT', 'Altonah'),
('84003', '801', 'UT', 'American Fork'),
('84004', '801', 'UT', 'Alpine'),
('84005', '801', 'UT', 'Eagle Mountain'),
('84006', '801', 'UT', 'Bingham Canyon'),
('84007', '435', 'UT', 'Bluebell'),
('84008', '435', 'UT', 'Bonanza'),
('84010', '801', 'UT', 'Bountiful'),
('84013', '801', 'UT', 'Cedar Valley'),
('84014', '801', 'UT', 'Centerville'),
('84015', '801', 'UT', 'Clearfield'),
('84017', '435', 'UT', 'Coalville'),
('84018', '801', 'UT', 'Croydon'),
('84020', '801', 'UT', 'Draper'),
('84021', '435', 'UT', 'Duchesne'),
('84022', '435', 'UT', 'Dugway'),
('84023', '435', 'UT', 'Dutch John'),
('84025', '801', 'UT', 'Farmington'),
('84026', '435', 'UT', 'Fort Duchesne'),
('84028', '435', 'UT', 'Garden City'),
('84029', '435', 'UT', 'Grantsville'),
('84031', '435', 'UT', 'Hanna'),
('84032', '435', 'UT', 'Heber City'),
('84034', '435', 'UT', 'Ibapah'),
('84035', '435', 'UT', 'Jensen'),
('84036', '435', 'UT', 'Kamas'),
('84037', '801', 'UT', 'Kaysville'),
('84038', '435', 'UT', 'Laketown'),
('84039', '435', 'UT', 'Lapoint'),
('84040', '801', 'UT', 'Layton'),
('84041', '435', 'UT', 'Layton'),
('84042', '801', 'UT', 'Lindon'),
('84043', '801', 'UT', 'Lehi'),
('84044', '801', 'UT', 'Magna'),
('84045', '801', 'UT', 'Saratoga Springs'),
('84046', '435', 'UT', 'Manila'),
('84047', '801', 'UT', 'Midvale'),
('84049', '435', 'UT', 'Midway'),
('84050', '801', 'UT', 'Morgan'),
('84051', '435', 'UT', 'Mountain Home'),
('84052', '435', 'UT', 'Myton'),
('84053', '435', 'UT', 'Neola'),
('84054', '801', 'UT', 'North Salt Lake'),
('84055', '435', 'UT', 'Oakley'),
('84056', '801', 'UT', 'Hill Afb'),
('84057', '801', 'UT', 'Orem'),
('84058', '801', 'UT', 'Orem'),
('84060', '435', 'UT', 'Park City'),
('84061', '435', 'UT', 'Peoa'),
('84062', '801', 'UT', 'Pleasant Grove'),
('84063', '435', 'UT', 'Randlett'),
('84064', '435', 'UT', 'Randolph'),
('84065', '801', 'UT', 'Riverton'),
('84066', '435', 'UT', 'Roosevelt'),
('84067', '801', 'UT', 'Roy'),
('84069', '435', 'UT', 'Rush Valley'),
('84070', '801', 'UT', 'Sandy'),
('84071', '435', 'UT', 'Stockton'),
('84072', '435', 'UT', 'Tabiona'),
('84073', '435', 'UT', 'Talmage'),
('84074', '435', 'UT', 'Tooele'),
('84075', '801', 'UT', 'Syracuse'),
('84076', '435', 'UT', 'Tridell'),
('84078', '435', 'UT', 'Vernal'),
('84080', '435', 'UT', 'Vernon'),
('84081', '801', 'UT', 'West Jordan'),
('84082', '435', 'UT', 'Wallsburg'),
('84083', '435', 'UT', 'Wendover'),
('84084', '801', 'UT', 'West Jordan'),
('84085', '435', 'UT', 'Whiterocks'),
('84086', '435', 'UT', 'Woodruff'),
('84087', '801', 'UT', 'Woods Cross'),
('84088', '801', 'UT', 'West Jordan'),
('84092', '801', 'UT', 'Sandy'),
('84093', '801', 'UT', 'Sandy'),
('84094', '801', 'UT', 'Sandy'),
('84095', '801', 'UT', 'South Jordan'),
('84096', '801', 'UT', 'Herriman'),
('84097', '801', 'UT', 'Orem'),
('84098', '435', 'UT', 'Park City'),
('84101', '801', 'UT', 'Salt Lake City'),
('84102', '801', 'UT', 'Salt Lake City'),
('84103', '801', 'UT', 'Salt Lake City'),
('84104', '801', 'UT', 'Salt Lake City'),
('84105', '801', 'UT', 'Salt Lake City'),
('84106', '801', 'UT', 'Salt Lake City'),
('84107', '801', 'UT', 'Salt Lake City'),
('84108', '801', 'UT', 'Salt Lake City'),
('84109', '801', 'UT', 'Salt Lake City'),
('84111', '801', 'UT', 'Salt Lake City'),
('84112', '801', 'UT', 'Salt Lake City'),
('84113', '801', 'UT', 'Salt Lake City'),
('84114', '801', 'UT', 'Salt Lake City'),
('84115', '801', 'UT', 'Salt Lake City'),
('84116', '801', 'UT', 'Salt Lake City'),
('84117', '801', 'UT', 'Salt Lake City'),
('84118', '801', 'UT', 'Salt Lake City'),
('84119', '801', 'UT', 'Salt Lake City'),
('84120', '801', 'UT', 'Salt Lake City'),
('84121', '801', 'UT', 'Salt Lake City'),
('84123', '801', 'UT', 'Salt Lake City'),
('84124', '801', 'UT', 'Salt Lake City'),
('84128', '801', 'UT', 'Salt Lake City'),
('84133', '801', 'UT', 'Salt Lake City'),
('84138', '801', 'UT', 'Salt Lake City'),
('84144', '801', 'UT', 'Salt Lake City'),
('84180', '801', 'UT', 'Salt Lake City'),
('84302', '435', 'UT', 'Brigham City'),
('84304', '435', 'UT', 'Cache Junction'),
('84306', '435', 'UT', 'Collinston'),
('84307', '435', 'UT', 'Corinne'),
('84308', '435', 'UT', 'Cornish'),
('84309', '435', 'UT', 'Deweyville'),
('84310', '801', 'UT', 'Eden'),
('84311', '435', 'UT', 'Fielding'),
('84312', '435', 'UT', 'Garland'),
('84313', '435', 'UT', 'Grouse Creek'),
('84314', '435', 'UT', 'Honeyville'),
('84315', '801', 'UT', 'Hooper'),
('84317', '801', 'UT', 'Huntsville'),
('84318', '435', 'UT', 'Hyde Park'),
('84319', '435', 'UT', 'Hyrum'),
('84320', '435', 'UT', 'Lewiston'),
('84321', '435', 'UT', 'Logan'),
('84324', '435', 'UT', 'Mantua'),
('84325', '435', 'UT', 'Mendon'),
('84328', '435', 'UT', 'Paradise'),
('84329', '435', 'UT', 'Park Valley'),
('84331', '435', 'UT', 'Portage'),
('84332', '435', 'UT', 'Providence'),
('84333', '435', 'UT', 'Richmond'),
('84335', '435', 'UT', 'Smithfield'),
('84336', '435', 'UT', 'Snowville'),
('84337', '435', 'UT', 'Tremonton'),
('84338', '435', 'UT', 'Trenton'),
('84339', '435', 'UT', 'Wellsville'),
('84340', '435', 'UT', 'Willard'),
('84341', '435', 'UT', 'Logan'),
('84401', '801', 'UT', 'Ogden'),
('84403', '801', 'UT', 'Ogden'),
('84404', '801', 'UT', 'Ogden'),
('84405', '801', 'UT', 'Ogden'),
('84414', '801', 'UT', 'Ogden'),
('84501', '435', 'UT', 'Price'),
('84511', '435', 'UT', 'Blanding'),
('84513', '435', 'UT', 'Castle Dale'),
('84515', '435', 'UT', 'Cisco'),
('84520', '435', 'UT', 'East Carbon'),
('84521', '435', 'UT', 'Elmo'),
('84525', '435', 'UT', 'Green River'),
('84526', '435', 'UT', 'Helper'),
('84528', '435', 'UT', 'Huntington'),
('84529', '435', 'UT', 'Kenilworth'),
('84532', '435', 'UT', 'Moab'),
('84533', '435', 'UT', 'Lake Powell'),
('84535', '435', 'UT', 'Monticello'),
('84540', '435', 'UT', 'Thompson'),
('84542', '435', 'UT', 'Wellington'),
('84601', '801', 'UT', 'Provo'),
('84602', '801', 'UT', 'Provo'),
('84604', '801', 'UT', 'Provo'),
('84606', '801', 'UT', 'Provo'),
('84621', '435', 'UT', 'Axtell'),
('84623', '435', 'UT', 'Chester'),
('84624', '435', 'UT', 'Delta'),
('84627', '435', 'UT', 'Ephraim'),
('84629', '435', 'UT', 'Fairview'),
('84630', '435', 'UT', 'Fayette'),
('84631', '435', 'UT', 'Fillmore'),
('84635', '435', 'UT', 'Hinckley'),
('84642', '435', 'UT', 'Manti'),
('84645', '435', 'UT', 'Mona'),
('84647', '435', 'UT', 'Mount Pleasant'),
('84648', '435', 'UT', 'Nephi'),
('84651', '801', 'UT', 'Payson'),
('84653', '801', 'UT', 'Salem'),
('84654', '435', 'UT', 'Salina'),
('84655', '801', 'UT', 'Santaquin'),
('84660', '801', 'UT', 'Spanish Fork'),
('84663', '801', 'UT', 'Springville'),
('84664', '801', 'UT', 'Mapleton'),
('84667', '435', 'UT', 'Wales'),
('84701', '435', 'UT', 'Richfield'),
('84712', '435', 'UT', 'Antimony'),
('84713', '435', 'UT', 'Beaver'),
('84714', '435', 'UT', 'Beryl'),
('84717', '435', 'UT', 'Bryce Canyon'),
('84720', '435', 'UT', 'Cedar City'),
('84721', '435', 'UT', 'Cedar City'),
('84722', '435', 'UT', 'Central'),
('84724', '435', 'UT', 'Elsinore'),
('84728', '435', 'UT', 'Garrison'),
('84731', '435', 'UT', 'Greenville'),
('84732', '435', 'UT', 'Greenwich'),
('84733', '435', 'UT', 'Gunlock'),
('84737', '435', 'UT', 'Hurricane'),
('84738', '435', 'UT', 'Ivins'),
('84739', '435', 'UT', 'Joseph'),
('84741', '435', 'UT', 'Kanab'),
('84745', '435', 'UT', 'La Verkin'),
('84747', '435', 'UT', 'Loa'),
('84751', '435', 'UT', 'Milford'),
('84753', '435', 'UT', 'Modena'),
('84754', '435', 'UT', 'Monroe'),
('84757', '435', 'UT', 'New Harmony'),
('84759', '435', 'UT', 'Panguitch'),
('84765', '435', 'UT', 'Santa Clara'),
('84766', '435', 'UT', 'Sevier'),
('84770', '435', 'UT', 'Saint George'),
('84773', '435', 'UT', 'Teasdale'),
('84774', '435', 'UT', 'Toquerville'),
('84775', '435', 'UT', 'Torrey'),
('84779', '435', 'UT', 'Virgin'),
('84780', '435', 'UT', 'Washington'),
('84781', '435', 'UT', 'Pine Valley'),
('84782', '435', 'UT', 'Veyo'),
('84783', '435', 'UT', 'Dammeron Valley'),
('84790', '435', 'UT', 'Saint George'),
('89001', '775', 'NV', 'Alamo'),
('89002', '702', 'NV', 'Henderson'),
('89005', '702', 'NV', 'Boulder City'),
('89008', '775', 'NV', 'Caliente'),
('89010', '775', 'NV', 'Dyer'),
('89011', '702', 'NV', 'Henderson'),
('89012', '702', 'NV', 'Henderson'),
('89013', '775', 'NV', 'Goldfield'),
('89014', '702', 'NV', 'Henderson'),
('89015', '702', 'NV', 'Henderson'),
('89017', '775', 'NV', 'Hiko'),
('89019', '702', 'NV', 'Jean'),
('89020', '775', 'NV', 'Amargosa Valley'),
('89027', '702', 'NV', 'Mesquite'),
('89029', '702', 'NV', 'Laughlin'),
('89030', '702', 'NV', 'North Las Vegas'),
('89031', '702', 'NV', 'North Las Vegas'),
('89032', '702', 'NV', 'North Las Vegas'),
('89033', '702', 'NV', 'North Las Vegas'),
('89034', '702', 'NV', 'Mesquite'),
('89037', '702', 'NV', 'Coyote Springs'),
('89039', '702', 'NV', 'Cal Nev Ari'),
('89040', '702', 'NV', 'Overton'),
('89043', '775', 'NV', 'Pioche'),
('89044', '702', 'NV', 'Henderson'),
('89045', '775', 'NV', 'Round Mountain'),
('89046', '702', 'NV', 'Searchlight'),
('89048', '775', 'NV', 'Pahrump'),
('89049', '775', 'NV', 'Tonopah'),
('89052', '702', 'NV', 'Henderson'),
('89054', '702', 'NV', 'Sloan'),
('89060', '775', 'NV', 'Pahrump'),
('89061', '702', 'NV', 'Pahrump'),
('89067', '702', 'NV', 'Coyote Springs'),
('89074', '702', 'NV', 'Henderson'),
('89081', '702', 'NV', 'North Las Vegas'),
('89084', '702', 'NV', 'North Las Vegas'),
('89085', '702', 'NV', 'North Las Vegas'),
('89086', '702', 'NV', 'North Las Vegas'),
('89087', '702', 'NV', 'North Las Vegas'),
('89101', '702', 'NV', 'Las Vegas'),
('89102', '702', 'NV', 'Las Vegas'),
('89103', '702', 'NV', 'Las Vegas'),
('89104', '702', 'NV', 'Las Vegas'),
('89106', '702', 'NV', 'Las Vegas'),
('89107', '702', 'NV', 'Las Vegas'),
('89108', '702', 'NV', 'Las Vegas'),
('89109', '702', 'NV', 'Las Vegas'),
('89110', '702', 'NV', 'Las Vegas'),
('89113', '702', 'NV', 'Las Vegas'),
('89115', '702', 'NV', 'Las Vegas'),
('89117', '702', 'NV', 'Las Vegas'),
('89118', '702', 'NV', 'Las Vegas'),
('89119', '702', 'NV', 'Las Vegas'),
('89120', '702', 'NV', 'Las Vegas'),
('89121', '702', 'NV', 'Las Vegas'),
('89122', '702', 'NV', 'Las Vegas'),
('89123', '702', 'NV', 'Las Vegas'),
('89124', '702', 'NV', 'Las Vegas'),
('89128', '702', 'NV', 'Las Vegas'),
('89129', '702', 'NV', 'Las Vegas'),
('89130', '702', 'NV', 'Las Vegas'),
('89131', '702', 'NV', 'Las Vegas'),
('89134', '702', 'NV', 'Las Vegas'),
('89135', '702', 'NV', 'Las Vegas'),
('89138', '702', 'NV', 'Las Vegas'),
('89139', '702', 'NV', 'Las Vegas'),
('89141', '702', 'NV', 'Las Vegas'),
('89142', '702', 'NV', 'Las Vegas'),
('89143', '702', 'NV', 'Las Vegas'),
('89144', '702', 'NV', 'Las Vegas'),
('89145', '702', 'NV', 'Las Vegas'),
('89146', '702', 'NV', 'Las Vegas'),
('89147', '702', 'NV', 'Las Vegas'),
('89148', '702', 'NV', 'Las Vegas'),
('89149', '702', 'NV', 'Las Vegas'),
('89156', '702', 'NV', 'Las Vegas'),
('89158', '702', 'NV', 'Las Vegas'),
('89161', '702', 'NV', 'Las Vegas'),
('89165', '702', 'NV', 'Las Vegas'),
('89166', '702', 'NV', 'Las Vegas'),
('89169', '702', 'NV', 'Las Vegas'),
('89178', '702', 'NV', 'Las Vegas'),
('89179', '702', 'NV', 'Las Vegas'),
('89183', '702', 'NV', 'Las Vegas'),
('89199', '702', 'NV', 'Las Vegas'),
('89301', '775', 'NV', 'Ely'),
('89310', '775', 'NV', 'Austin'),
('89311', '775', 'NV', 'Baker'),
('89314', '775', 'NV', 'Duckwater'),
('89316', '775', 'NV', 'Eureka'),
('89403', '775', 'NV', 'Dayton'),
('89406', '775', 'NV', 'Fallon'),
('89408', '775', 'NV', 'Fernley'),
('89410', '702', 'NV', 'Gardnerville'),
('89413', '775', 'NV', 'Glenbrook'),
('89414', '775', 'NV', 'Golconda'),
('89415', '775', 'NV', 'Hawthorne'),
('89418', '775', 'NV', 'Imlay'),
('89419', '775', 'NV', 'Lovelock'),
('89420', '775', 'NV', 'Luning'),
('89423', '775', 'NV', 'Minden'),
('89425', '775', 'NV', 'Orovada'),
('89429', '775', 'NV', 'Silver Springs'),
('89430', '775', 'NV', 'Smith'),
('89431', '775', 'NV', 'Sparks'),
('89433', '775', 'NV', 'Sun Valley'),
('89434', '775', 'NV', 'Sparks'),
('89436', '775', 'NV', 'Sparks'),
('89441', '775', 'NV', 'Sparks'),
('89444', '775', 'NV', 'Wellington'),
('89445', '775', 'NV', 'Winnemucca'),
('89447', '775', 'NV', 'Yerington'),
('89451', '775', 'NV', 'Incline Village'),
('89460', '775', 'NV', 'Gardnerville'),
('89501', '775', 'NV', 'Reno'),
('89502', '702', 'NV', 'Reno'),
('89503', '775', 'NV', 'Reno'),
('89506', '775', 'NV', 'Reno'),
('89508', '775', 'NV', 'Reno'),
('89509', '775', 'NV', 'Reno'),
('89510', '775', 'NV', 'Reno'),
('89511', '775', 'NV', 'Reno'),
('89512', '775', 'NV', 'Reno'),
('89519', '775', 'NV', 'Reno'),
('89521', '775', 'NV', 'Reno'),
('89523', '775', 'NV', 'Reno'),
('89701', '775', 'NV', 'Carson City'),
('89703', '775', 'NV', 'Carson City'),
('89704', '775', 'NV', 'Washoe Valley'),
('89705', '775', 'NV', 'Carson City'),
('89706', '775', 'NV', 'Carson City'),
('89801', '775', 'NV', 'Elko'),
('89815', '775', 'NV', 'Spring Creek'),
('89820', '775', 'NV', 'Battle Mountain'),
('89821', '775', 'NV', 'Crescent Valley'),
('89822', '775', 'NV', 'Carlin'),
('89823', '775', 'NV', 'Deeth'),
('89825', '775', 'NV', 'Jackpot'),
('89828', '775', 'NV', 'Lamoille'),
('89831', '775', 'NV', 'Mountain City'),
('89833', '775', 'NV', 'Ruby Valley'),
('89834', '775', 'NV', 'Tuscarora'),
('89835', '775', 'NV', 'Wells'),
('97001', '541', 'OR', 'Antelope'),
('97002', '503', 'OR', 'Aurora'),
('97004', '503', 'OR', 'Beavercreek'),
('97005', '503', 'OR', 'Beaverton'),
('97006', '503', 'OR', 'Beaverton'),
('97007', '503', 'OR', 'Beaverton'),
('97008', '503', 'OR', 'Beaverton'),
('97009', '503', 'OR', 'Boring'),
('97011', '503', 'OR', 'Brightwood'),
('97013', '503', 'OR', 'Canby'),
('97014', '541', 'OR', 'Cascade Locks'),
('97015', '503', 'OR', 'Clackamas'),
('97016', '503', 'OR', 'Clatskanie'),
('97017', '503', 'OR', 'Colton'),
('97018', '503', 'OR', 'Columbia City'),
('97019', '503', 'OR', 'Corbett'),
('97020', '503', 'OR', 'Donald'),
('97021', '541', 'OR', 'Dufur'),
('97022', '503', 'OR', 'Eagle Creek'),
('97023', '503', 'OR', 'Estacada'),
('97024', '503', 'OR', 'Fairview'),
('97026', '503', 'OR', 'Gervais'),
('97027', '503', 'OR', 'Gladstone'),
('97028', '503', 'OR', 'Government Camp'),
('97029', '541', 'OR', 'Grass Valley'),
('97030', '503', 'OR', 'Gresham'),
('97031', '541', 'OR', 'Hood River'),
('97032', '503', 'OR', 'Hubbard'),
('97034', '503', 'OR', 'Lake Oswego'),
('97035', '503', 'OR', 'Lake Oswego'),
('97037', '541', 'OR', 'Maupin'),
('97038', '503', 'OR', 'Molalla'),
('97039', '541', 'OR', 'Moro'),
('97040', '541', 'OR', 'Mosier'),
('97041', '541', 'OR', 'Mount Hood Parkdale'),
('97042', '503', 'OR', 'Mulino'),
('97045', '503', 'OR', 'Oregon City'),
('97048', '503', 'OR', 'Rainier'),
('97049', '503', 'OR', 'Rhododendron'),
('97051', '503', 'OR', 'Saint Helens'),
('97053', '503', 'OR', 'Warren'),
('97054', '503', 'OR', 'Deer Island'),
('97055', '503', 'OR', 'Sandy'),
('97056', '503', 'OR', 'Scappoose'),
('97058', '541', 'OR', 'The Dalles'),
('97060', '503', 'OR', 'Troutdale'),
('97062', '503', 'OR', 'Tualatin'),
('97063', '541', 'OR', 'Tygh Valley'),
('97064', '503', 'OR', 'Vernonia'),
('97065', '541', 'OR', 'Wasco'),
('97067', '503', 'OR', 'Welches'),
('97068', '503', 'OR', 'West Linn'),
('97070', '503', 'OR', 'Wilsonville'),
('97071', '503', 'OR', 'Woodburn'),
('97080', '503', 'OR', 'Gresham'),
('97086', '971', 'OR', 'Happy Valley'),
('97101', '503', 'OR', 'Amity'),
('97102', '503', 'OR', 'Arch Cape'),
('97103', '503', 'OR', 'Astoria'),
('97106', '503', 'OR', 'Banks'),
('97107', '503', 'OR', 'Bay City'),
('97108', '503', 'OR', 'Beaver'),
('97109', '503', 'OR', 'Buxton'),
('97111', '503', 'OR', 'Carlton'),
('97112', '503', 'OR', 'Cloverdale'),
('97113', '503', 'OR', 'Cornelius'),
('97114', '503', 'OR', 'Dayton'),
('97115', '503', 'OR', 'Dundee'),
('97116', '503', 'OR', 'Forest Grove'),
('97117', '503', 'OR', 'Gales Creek'),
('97119', '503', 'OR', 'Gaston'),
('97121', '503', 'OR', 'Hammond'),
('97122', '503', 'OR', 'Hebo'),
('97123', '503', 'OR', 'Hillsboro'),
('97124', '503', 'OR', 'Hillsboro'),
('97125', '503', 'OR', 'Manning'),
('97127', '503', 'OR', 'Lafayette'),
('97128', '503', 'OR', 'Mcminnville'),
('97131', '503', 'OR', 'Nehalem'),
('97132', '503', 'OR', 'Newberg'),
('97133', '503', 'OR', 'North Plains'),
('97136', '503', 'OR', 'Rockaway Beach'),
('97137', '503', 'OR', 'Saint Paul'),
('97138', '503', 'OR', 'Seaside'),
('97140', '503', 'OR', 'Sherwood'),
('97141', '503', 'OR', 'Tillamook'),
('97144', '971', 'OR', 'Timber'),
('97146', '503', 'OR', 'Warrenton'),
('97148', '503', 'OR', 'Yamhill'),
('97149', '503', 'OR', 'Neskowin'),
('97201', '503', 'OR', 'Portland'),
('97202', '503', 'OR', 'Portland'),
('97203', '503', 'OR', 'Portland'),
('97204', '503', 'OR', 'Portland'),
('97205', '503', 'OR', 'Portland'),
('97206', '503', 'OR', 'Portland'),
('97209', '503', 'OR', 'Portland'),
('97210', '503', 'OR', 'Portland'),
('97211', '208', 'OR', 'Portland'),
('97212', '503', 'OR', 'Portland'),
('97213', '503', 'OR', 'Portland'),
('97214', '503', 'OR', 'Portland'),
('97215', '503', 'OR', 'Portland'),
('97216', '503', 'OR', 'Portland'),
('97217', '503', 'OR', 'Portland'),
('97218', '503', 'OR', 'Portland'),
('97219', '503', 'OR', 'Portland'),
('97220', '503', 'OR', 'Portland'),
('97221', '503', 'OR', 'Portland'),
('97222', '503', 'OR', 'Portland'),
('97223', '503', 'OR', 'Portland'),
('97224', '503', 'OR', 'Portland'),
('97225', '503', 'OR', 'Portland'),
('97227', '503', 'OR', 'Portland'),
('97229', '503', 'OR', 'Portland'),
('97230', '503', 'OR', 'Portland'),
('97231', '503', 'OR', 'Portland'),
('97232', '503', 'OR', 'Portland'),
('97233', '503', 'OR', 'Portland'),
('97236', '503', 'OR', 'Portland'),
('97239', '971', 'OR', 'Portland'),
('97258', '503', 'OR', 'Portland'),
('97266', '503', 'OR', 'Portland'),
('97267', '503', 'OR', 'Portland'),
('97299', '971', 'OR', 'Portland'),
('97301', '503', 'OR', 'Salem'),
('97302', '503', 'OR', 'Salem'),
('97303', '503', 'OR', 'Salem'),
('97304', '541', 'OR', 'Salem'),
('97305', '503', 'OR', 'Salem'),
('97306', '503', 'OR', 'Salem'),
('97317', '971', 'OR', 'Salem'),
('97321', '541', 'OR', 'Albany'),
('97322', '541', 'OR', 'Albany'),
('97324', '541', 'OR', 'Alsea'),
('97325', '503', 'OR', 'Aumsville'),
('97326', '541', 'OR', 'Blodgett'),
('97327', '541', 'OR', 'Brownsville'),
('97329', '541', 'OR', 'Cascadia'),
('97330', '541', 'OR', 'Corvallis'),
('97331', '541', 'OR', 'Corvallis'),
('97333', '541', 'OR', 'Corvallis'),
('97338', '503', 'OR', 'Dallas'),
('97341', '541', 'OR', 'Depoe Bay'),
('97342', '503', 'OR', 'Detroit'),
('97343', '541', 'OR', 'Eddyville'),
('97344', '503', 'OR', 'Falls City'),
('97345', '541', 'OR', 'Foster'),
('97346', '503', 'OR', 'Gates'),
('97347', '503', 'OR', 'Grand Ronde'),
('97348', '541', 'OR', 'Halsey'),
('97350', '503', 'OR', 'Idanha'),
('97351', '503', 'OR', 'Independence'),
('97352', '541', 'OR', 'Jefferson'),
('97355', '541', 'OR', 'Lebanon'),
('97357', '541', 'OR', 'Logsden'),
('97358', '503', 'OR', 'Lyons'),
('97360', '503', 'OR', 'Mill City'),
('97361', '503', 'OR', 'Monmouth'),
('97362', '503', 'OR', 'Mount Angel'),
('97364', '541', 'OR', 'Neotsu'),
('97365', '541', 'OR', 'Newport'),
('97366', '541', 'OR', 'South Beach'),
('97367', '541', 'OR', 'Lincoln City'),
('97368', '541', 'OR', 'Otis'),
('97369', '541', 'OR', 'Otter Rock'),
('97370', '541', 'OR', 'Philomath'),
('97371', '503', 'OR', 'Rickreall'),
('97372', '541', 'OR', 'Rose Lodge'),
('97374', '503', 'OR', 'Scio'),
('97375', '503', 'OR', 'Scotts Mills'),
('97376', '541', 'OR', 'Seal Rock'),
('97377', '541', 'OR', 'Shedd'),
('97378', '503', 'OR', 'Sheridan'),
('97380', '541', 'OR', 'Siletz'),
('97381', '503', 'OR', 'Silverton'),
('97383', '503', 'OR', 'Stayton'),
('97385', '503', 'OR', 'Sublimity'),
('97386', '541', 'OR', 'Sweet Home'),
('97389', '541', 'OR', 'Tangent'),
('97390', '541', 'OR', 'Tidewater'),
('97391', '541', 'OR', 'Toledo'),
('97392', '503', 'OR', 'Turner'),
('97394', '541', 'OR', 'Waldport'),
('97396', '503', 'OR', 'Willamina'),
('97401', '541', 'OR', 'Eugene'),
('97402', '541', 'OR', 'Eugene'),
('97403', '541', 'OR', 'Eugene'),
('97404', '541', 'OR', 'Eugene'),
('97405', '541', 'OR', 'Eugene'),
('97406', '541', 'OR', 'Agness'),
('97408', '541', 'OR', 'Eugene'),
('97410', '541', 'OR', 'Azalea'),
('97411', '541', 'OR', 'Bandon'),
('97412', '541', 'OR', 'Blachly'),
('97413', '541', 'OR', 'Blue River'),
('97414', '541', 'OR', 'Broadbent'),
('97415', '541', 'OR', 'Brookings'),
('97416', '541', 'OR', 'Camas Valley'),
('97417', '541', 'OR', 'Canyonville'),
('97419', '541', 'OR', 'Cheshire'),
('97420', '541', 'OR', 'Coos Bay'),
('97423', '541', 'OR', 'Coquille'),
('97424', '541', 'OR', 'Cottage Grove'),
('97426', '541', 'OR', 'Creswell'),
('97427', '541', 'OR', 'Culp Creek'),
('97429', '541', 'OR', 'Days Creek'),
('97430', '541', 'OR', 'Deadwood'),
('97431', '541', 'OR', 'Dexter'),
('97434', '541', 'OR', 'Dorena'),
('97435', '541', 'OR', 'Drain'),
('97436', '541', 'OR', 'Elkton'),
('97437', '541', 'OR', 'Elmira'),
('97438', '541', 'OR', 'Fall Creek'),
('97439', '541', 'OR', 'Florence'),
('97441', '541', 'OR', 'Gardiner'),
('97442', '541', 'OR', 'Glendale'),
('97443', '541', 'OR', 'Glide'),
('97444', '541', 'OR', 'Gold Beach'),
('97446', '541', 'OR', 'Harrisburg'),
('97447', '541', 'OR', 'Idleyld Park'),
('97448', '541', 'OR', 'Junction City'),
('97449', '541', 'OR', 'Lakeside'),
('97450', '541', 'OR', 'Langlois'),
('97451', '503', 'OR', 'Lorane'),
('97452', '541', 'OR', 'Lowell'),
('97453', '541', 'OR', 'Mapleton'),
('97454', '541', 'OR', 'Marcola'),
('97455', '541', 'OR', 'Pleasant Hill'),
('97456', '541', 'OR', 'Monroe'),
('97457', '541', 'OR', 'Myrtle Creek'),
('97458', '541', 'OR', 'Myrtle Point'),
('97459', '541', 'OR', 'North Bend'),
('97461', '541', 'OR', 'Noti'),
('97462', '541', 'OR', 'Oakland'),
('97463', '541', 'OR', 'Oakridge'),
('97465', '541', 'OR', 'Port Orford'),
('97466', '541', 'OR', 'Powers'),
('97467', '541', 'OR', 'Reedsport'),
('97469', '541', 'OR', 'Riddle'),
('97470', '541', 'OR', 'Roseburg'),
('97471', '541', 'OR', 'Roseburg'),
('97472', '541', 'OR', 'Cottage Grove'),
('97473', '541', 'OR', 'Scottsburg'),
('97476', '541', 'OR', 'Sixes'),
('97477', '541', 'OR', 'Springfield'),
('97478', '541', 'OR', 'Springfield'),
('97479', '541', 'OR', 'Sutherlin'),
('97480', '541', 'OR', 'Swisshome'),
('97481', '541', 'OR', 'Tenmile'),
('97482', '541', 'OR', 'Thurston'),
('97484', '541', 'OR', 'Tiller'),
('97486', '541', 'OR', 'Umpqua'),
('97487', '541', 'OR', 'Veneta'),
('97488', '541', 'OR', 'Vida'),
('97489', '541', 'OR', 'Walterville'),
('97490', '541', 'OR', 'Walton'),
('97492', '541', 'OR', 'Westfir'),
('97493', '541', 'OR', 'Westlake'),
('97495', '541', 'OR', 'Winchester'),
('97496', '541', 'OR', 'Winston'),
('97497', '541', 'OR', 'Wolf Creek'),
('97498', '541', 'OR', 'Yachats'),
('97499', '541', 'OR', 'Yoncalla'),
('97501', '541', 'OR', 'Medford'),
('97502', '541', 'OR', 'Central Point'),
('97503', '541', 'OR', 'White City'),
('97504', '541', 'OR', 'Medford'),
('97520', '541', 'OR', 'Ashland'),
('97522', '541', 'OR', 'Butte Falls'),
('97523', '541', 'OR', 'Cave Junction'),
('97524', '541', 'OR', 'Eagle Point'),
('97525', '541', 'OR', 'Gold Hill'),
('97526', '541', 'OR', 'Grants Pass'),
('97527', '541', 'OR', 'Grants Pass'),
('97530', '541', 'OR', 'Jacksonville'),
('97531', '541', 'OR', 'Kerby'),
('97532', '541', 'OR', 'Merlin'),
('97534', '541', 'OR', 'O Brien'),
('97535', '541', 'OR', 'Phoenix'),
('97536', '541', 'OR', 'Prospect'),
('97537', '541', 'OR', 'Rogue River'),
('97538', '541', 'OR', 'Selma'),
('97539', '541', 'OR', 'Shady Cove'),
('97540', '541', 'OR', 'Talent'),
('97541', '541', 'OR', 'Trail'),
('97543', '541', 'OR', 'Wilderville'),
('97544', '541', 'OR', 'Williams'),
('97601', '541', 'OR', 'Klamath Falls'),
('97603', '541', 'OR', 'Klamath Falls'),
('97621', '541', 'OR', 'Beatty'),
('97623', '541', 'OR', 'Bonanza'),
('97624', '541', 'OR', 'Chiloquin'),
('97625', '541', 'OR', 'Dairy'),
('97627', '541', 'OR', 'Keno'),
('97630', '541', 'OR', 'Lakeview'),
('97632', '541', 'OR', 'Malin'),
('97633', '541', 'OR', 'Merrill'),
('97635', '530', 'OR', 'New Pine Creek'),
('97636', '541', 'OR', 'Paisley'),
('97637', '541', 'OR', 'Plush'),
('97638', '541', 'OR', 'Silver Lake'),
('97639', '541', 'OR', 'Sprague River'),
('97640', '541', 'OR', 'Summer Lake'),
('97701', '541', 'OR', 'Bend'),
('97702', '541', 'OR', 'Bend'),
('97707', '541', 'OR', 'Bend'),
('97710', '541', 'OR', 'Fields'),
('97711', '541', 'OR', 'Ashwood'),
('97720', '541', 'OR', 'Burns'),
('97721', '541', 'OR', 'Princeton'),
('97722', '541', 'OR', 'Diamond'),
('97730', '541', 'OR', 'Camp Sherman'),
('97731', '541', 'OR', 'Chemult'),
('97733', '541', 'OR', 'Crescent'),
('97734', '541', 'OR', 'Culver'),
('97736', '541', 'OR', 'Frenchglen'),
('97737', '541', 'OR', 'Gilchrist'),
('97738', '541', 'OR', 'Hines'),
('97739', '541', 'OR', 'La Pine'),
('97741', '541', 'OR', 'Madras'),
('97750', '541', 'OR', 'Mitchell'),
('97751', '541', 'OR', 'Paulina'),
('97752', '541', 'OR', 'Post'),
('97753', '541', 'OR', 'Powell Butte'),
('97754', '541', 'OR', 'Prineville'),
('97756', '541', 'OR', 'Redmond'),
('97758', '541', 'OR', 'Riley'),
('97759', '541', 'OR', 'Sisters'),
('97760', '541', 'OR', 'Terrebonne'),
('97801', '541', 'OR', 'Pendleton'),
('97810', '541', 'OR', 'Adams'),
('97812', '541', 'OR', 'Arlington'),
('97813', '541', 'OR', 'Athena'),
('97814', '541', 'OR', 'Baker City'),
('97817', '541', 'OR', 'Bates'),
('97818', '541', 'OR', 'Boardman'),
('97819', '541', 'OR', 'Bridgeport'),
('97820', '541', 'OR', 'Canyon City'),
('97823', '541', 'OR', 'Condon'),
('97824', '541', 'OR', 'Cove'),
('97825', '541', 'OR', 'Dayville'),
('97826', '541', 'OR', 'Echo'),
('97827', '541', 'OR', 'Elgin'),
('97828', '541', 'OR', 'Enterprise'),
('97830', '541', 'OR', 'Fossil'),
('97833', '541', 'OR', 'Haines'),
('97834', '541', 'OR', 'Halfway'),
('97835', '541', 'OR', 'Helix'),
('97836', '541', 'OR', 'Heppner'),
('97837', '541', 'OR', 'Hereford'),
('97838', '509', 'OR', 'Hermiston'),
('97839', '541', 'OR', 'Lexington'),
('97840', '541', 'OR', 'Oxbow'),
('97841', '541', 'OR', 'Imbler'),
('97842', '541', 'OR', 'Imnaha'),
('97843', '541', 'OR', 'Ione'),
('97844', '541', 'OR', 'Irrigon'),
('97845', '541', 'OR', 'John Day'),
('97846', '541', 'OR', 'Joseph'),
('97848', '541', 'OR', 'Kimberly'),
('97850', '541', 'OR', 'La Grande'),
('97856', '541', 'OR', 'Long Creek'),
('97857', '541', 'OR', 'Lostine'),
('97861', '541', 'OR', 'Mikkalo'),
('97862', '541', 'OR', 'Milton Freewater'),
('97864', '541', 'OR', 'Monument'),
('97865', '541', 'OR', 'Mount Vernon'),
('97867', '541', 'OR', 'North Powder'),
('97868', '541', 'OR', 'Pilot Rock'),
('97869', '541', 'OR', 'Prairie City'),
('97870', '541', 'OR', 'Richland'),
('97873', '541', 'OR', 'Seneca'),
('97874', '541', 'OR', 'Spray'),
('97875', '541', 'OR', 'Stanfield'),
('97876', '541', 'OR', 'Summerville'),
('97877', '541', 'OR', 'Sumpter'),
('97882', '541', 'OR', 'Umatilla'),
('97883', '541', 'OR', 'Union'),
('97884', '541', 'OR', 'Unity'),
('97885', '541', 'OR', 'Wallowa'),
('97886', '541', 'OR', 'Weston'),
('97901', '541', 'OR', 'Adrian'),
('97903', '541', 'OR', 'Brogan'),
('97904', '541', 'OR', 'Drewsey'),
('97906', '541', 'OR', 'Harper'),
('97907', '541', 'OR', 'Huntington'),
('97908', '541', 'OR', 'Ironside'),
('97909', '541', 'OR', 'Jamieson'),
('97910', '541', 'OR', 'Jordan Valley'),
('97911', '541', 'OR', 'Juntura'),
('97913', '541', 'OR', 'Nyssa'),
('97914', '541', 'OR', 'Ontario'),
('97917', '541', 'OR', 'Riverside'),
('97918', '541', 'OR', 'Vale'),
('98001', '206', 'WA', 'Auburn'),
('98002', '253', 'WA', 'Auburn'),
('98003', '206', 'WA', 'Federal Way'),
('98004', '425', 'WA', 'Bellevue'),
('98005', '425', 'WA', 'Bellevue'),
('98006', '360', 'WA', 'Bellevue'),
('98007', '425', 'WA', 'Bellevue'),
('98008', '206', 'WA', 'Bellevue'),
('98010', '360', 'WA', 'Black Diamond'),
('98011', '206', 'WA', 'Bothell'),
('98012', '425', 'WA', 'Bothell'),
('98014', '425', 'WA', 'Carnation'),
('98019', '425', 'WA', 'Duvall'),
('98020', '206', 'WA', 'Edmonds'),
('98021', '425', 'WA', 'Bothell'),
('98022', '253', 'WA', 'Enumclaw'),
('98023', '253', 'WA', 'Federal Way'),
('98024', '425', 'WA', 'Fall City'),
('98026', '425', 'WA', 'Edmonds'),
('98027', '425', 'WA', 'Issaquah'),
('98028', '206', 'WA', 'Kenmore'),
('98029', '425', 'WA', 'Issaquah'),
('98030', '253', 'WA', 'Kent'),
('98031', '206', 'WA', 'Kent'),
('98032', '253', 'WA', 'Kent'),
('98033', '206', 'WA', 'Kirkland'),
('98034', '425', 'WA', 'Kirkland'),
('98036', '425', 'WA', 'Lynnwood'),
('98037', '425', 'WA', 'Lynnwood'),
('98038', '253', 'WA', 'Maple Valley'),
('98039', '425', 'WA', 'Medina'),
('98040', '425', 'WA', 'Mercer Island'),
('98042', '253', 'WA', 'Kent'),
('98043', '206', 'WA', 'Mountlake Terrace'),
('98045', '425', 'WA', 'North Bend'),
('98047', '253', 'WA', 'Pacific'),
('98051', '360', 'WA', 'Ravensdale'),
('98052', '425', 'WA', 'Redmond'),
('98053', '425', 'WA', 'Redmond'),
('98055', '206', 'WA', 'Renton'),
('98056', '425', 'WA', 'Renton'),
('98057', '206', 'WA', 'Renton'),
('98058', '425', 'WA', 'Renton'),
('98059', '425', 'WA', 'Renton'),
('98065', '425', 'WA', 'Snoqualmie'),
('98070', '206', 'WA', 'Vashon'),
('98072', '425', 'WA', 'Woodinville'),
('98074', '425', 'WA', 'Sammamish'),
('98075', '425', 'WA', 'Sammamish'),
('98077', '425', 'WA', 'Woodinville'),
('98087', '425', 'WA', 'Lynnwood'),
('98092', '206', 'WA', 'Auburn'),
('98101', '206', 'WA', 'Seattle'),
('98102', '206', 'WA', 'Seattle'),
('98103', '206', 'WA', 'Seattle'),
('98104', '206', 'WA', 'Seattle'),
('98105', '206', 'WA', 'Seattle'),
('98106', '206', 'WA', 'Seattle'),
('98107', '206', 'WA', 'Seattle'),
('98108', '206', 'WA', 'Seattle'),
('98109', '206', 'WA', 'Seattle'),
('98110', '206', 'WA', 'Bainbridge Island'),
('98112', '206', 'WA', 'Seattle'),
('98115', '206', 'WA', 'Seattle'),
('98116', '425', 'WA', 'Seattle'),
('98117', '206', 'WA', 'Seattle'),
('98118', '206', 'WA', 'Seattle'),
('98119', '206', 'WA', 'Seattle'),
('98121', '206', 'WA', 'Seattle'),
('98122', '206', 'WA', 'Seattle'),
('98125', '206', 'WA', 'Seattle'),
('98126', '206', 'WA', 'Seattle'),
('98131', '206', 'WA', 'Seattle'),
('98132', '206', 'WA', 'Seattle'),
('98133', '206', 'WA', 'Seattle'),
('98134', '206', 'WA', 'Seattle'),
('98136', '206', 'WA', 'Seattle'),
('98144', '206', 'WA', 'Seattle'),
('98146', '206', 'WA', 'Seattle'),
('98148', '206', 'WA', 'Seattle'),
('98154', '206', 'WA', 'Seattle'),
('98155', '206', 'WA', 'Seattle'),
('98158', '425', 'WA', 'Seattle'),
('98161', '206', 'WA', 'Seattle'),
('98164', '206', 'WA', 'Seattle'),
('98166', '206', 'WA', 'Seattle'),
('98168', '425', 'WA', 'Seattle'),
('98171', '206', 'WA', 'Seattle'),
('98174', '206', 'WA', 'Seattle'),
('98177', '206', 'WA', 'Seattle'),
('98178', '206', 'WA', 'Seattle'),
('98188', '206', 'WA', 'Seattle'),
('98198', '206', 'WA', 'Seattle'),
('98199', '206', 'WA', 'Seattle'),
('98201', '425', 'WA', 'Everett'),
('98203', '425', 'WA', 'Everett'),
('98204', '425', 'WA', 'Everett'),
('98205', '425', 'WA', 'Everett'),
('98208', '425', 'WA', 'Everett'),
('98220', '360', 'WA', 'Acme'),
('98221', '360', 'WA', 'Anacortes'),
('98222', '360', 'WA', 'Blakely Island'),
('98223', '425', 'WA', 'Arlington'),
('98225', '360', 'WA', 'Bellingham'),
('98226', '360', 'WA', 'Bellingham'),
('98229', '360', 'WA', 'Bellingham'),
('98230', '360', 'WA', 'Blaine'),
('98232', '360', 'WA', 'Bow'),
('98233', '360', 'WA', 'Burlington'),
('98236', '360', 'WA', 'Clinton'),
('98237', '360', 'WA', 'Concrete'),
('98239', '360', 'WA', 'Coupeville'),
('98240', '360', 'WA', 'Custer'),
('98241', '360', 'WA', 'Darrington'),
('98244', '360', 'WA', 'Deming'),
('98245', '360', 'WA', 'Eastsound'),
('98247', '360', 'WA', 'Everson'),
('98248', '360', 'WA', 'Ferndale'),
('98249', '360', 'WA', 'Freeland'),
('98250', '360', 'WA', 'Friday Harbor'),
('98251', '360', 'WA', 'Gold Bar'),
('98252', '360', 'WA', 'Granite Falls'),
('98253', '360', 'WA', 'Greenbank'),
('98257', '360', 'WA', 'La Conner'),
('98258', '425', 'WA', 'Lake Stevens'),
('98260', '425', 'WA', 'Langley'),
('98261', '360', 'WA', 'Lopez Island'),
('98262', '360', 'WA', 'Lummi Island'),
('98264', '360', 'WA', 'Lynden'),
('98266', '360', 'WA', 'Maple Falls'),
('98267', '360', 'WA', 'Marblemount'),
('98270', '360', 'WA', 'Marysville'),
('98271', '360', 'WA', 'Marysville'),
('98272', '360', 'WA', 'Monroe'),
('98273', '360', 'WA', 'Mount Vernon'),
('98274', '360', 'WA', 'Mount Vernon'),
('98275', '425', 'WA', 'Mukilteo'),
('98277', '360', 'WA', 'Oak Harbor'),
('98279', '360', 'WA', 'Olga'),
('98281', '360', 'WA', 'Point Roberts'),
('98282', '360', 'WA', 'Camano Island'),
('98283', '360', 'WA', 'Rockport'),
('98284', '360', 'WA', 'Sedro Woolley'),
('98290', '360', 'WA', 'Snohomish'),
('98292', '425', 'WA', 'Stanwood'),
('98294', '360', 'WA', 'Sultan'),
('98295', '360', 'WA', 'Sumas'),
('98296', '360', 'WA', 'Snohomish'),
('98303', '253', 'WA', 'Anderson Island'),
('98304', '360', 'WA', 'Ashford'),
('98305', '360', 'WA', 'Beaver'),
('98310', '360', 'WA', 'Bremerton'),
('98311', '360', 'WA', 'Bremerton'),
('98312', '360', 'WA', 'Bremerton'),
('98315', '360', 'WA', 'Silverdale'),
('98320', '360', 'WA', 'Brinnon'),
('98321', '360', 'WA', 'Buckley'),
('98323', '360', 'WA', 'Carbonado'),
('98325', '360', 'WA', 'Chimacum'),
('98326', '360', 'WA', 'Clallam Bay'),
('98327', '253', 'WA', 'Dupont'),
('98328', '360', 'WA', 'Eatonville'),
('98329', '253', 'WA', 'Gig Harbor'),
('98330', '360', 'WA', 'Elbe'),
('98331', '360', 'WA', 'Forks'),
('98332', '253', 'WA', 'Gig Harbor'),
('98333', '253', 'WA', 'Fox Island'),
('98335', '253', 'WA', 'Gig Harbor'),
('98336', '360', 'WA', 'Glenoma'),
('98337', '360', 'WA', 'Bremerton'),
('98338', '253', 'WA', 'Graham'),
('98339', '360', 'WA', 'Port Hadlock'),
('98340', '360', 'WA', 'Hansville'),
('98342', '360', 'WA', 'Indianola'),
('98346', '360', 'WA', 'Kingston'),
('98349', '253', 'WA', 'Lakebay'),
('98351', '253', 'WA', 'Longbranch'),
('98354', '253', 'WA', 'Milton'),
('98355', '360', 'WA', 'Mineral'),
('98356', '360', 'WA', 'Morton'),
('98358', '360', 'WA', 'Nordland'),
('98359', '253', 'WA', 'Olalla'),
('98360', '253', 'WA', 'Orting'),
('98361', '360', 'WA', 'Packwood'),
('98362', '360', 'WA', 'Port Angeles'),
('98363', '360', 'WA', 'Port Angeles'),
('98365', '360', 'WA', 'Port Ludlow'),
('98366', '360', 'WA', 'Port Orchard'),
('98367', '360', 'WA', 'Port Orchard'),
('98368', '360', 'WA', 'Port Townsend'),
('98370', '360', 'WA', 'Poulsbo'),
('98371', '253', 'WA', 'Puyallup'),
('98372', '253', 'WA', 'Puyallup'),
('98373', '253', 'WA', 'Puyallup'),
('98374', '253', 'WA', 'Puyallup'),
('98375', '253', 'WA', 'Puyallup'),
('98376', '360', 'WA', 'Quilcene'),
('98377', '360', 'WA', 'Randle'),
('98380', '360', 'WA', 'Seabeck'),
('98381', '360', 'WA', 'Sekiu'),
('98382', '360', 'WA', 'Sequim'),
('98383', '360', 'WA', 'Silverdale'),
('98387', '206', 'WA', 'Spanaway'),
('98388', '253', 'WA', 'Steilacoom'),
('98390', '253', 'WA', 'Sumner'),
('98392', '206', 'WA', 'Suquamish'),
('98394', '253', 'WA', 'Vaughn'),
('98402', '253', 'WA', 'Tacoma'),
('98403', '253', 'WA', 'Tacoma'),
('98404', '253', 'WA', 'Tacoma'),
('98405', '253', 'WA', 'Tacoma'),
('98406', '253', 'WA', 'Tacoma'),
('98407', '253', 'WA', 'Tacoma'),
('98408', '253', 'WA', 'Tacoma'),
('98409', '253', 'WA', 'Tacoma'),
('98413', '253', 'WA', 'Tacoma'),
('98418', '253', 'WA', 'Tacoma'),
('98421', '253', 'WA', 'Tacoma'),
('98422', '253', 'WA', 'Tacoma'),
('98424', '253', 'WA', 'Tacoma'),
('98433', '253', 'WA', 'Tacoma'),
('98439', '253', 'WA', 'Lakewood'),
('98442', '253', 'WA', 'Tacoma'),
('98443', '253', 'WA', 'Tacoma'),
('98444', '253', 'WA', 'Tacoma'),
('98445', '253', 'WA', 'Tacoma'),
('98446', '253', 'WA', 'Tacoma'),
('98465', '253', 'WA', 'Tacoma'),
('98466', '253', 'WA', 'Tacoma'),
('98467', '253', 'WA', 'University Place'),
('98492', '253', 'WA', 'Tacoma'),
('98498', '253', 'WA', 'Lakewood'),
('98499', '253', 'WA', 'Lakewood'),
('98501', '360', 'WA', 'Olympia'),
('98502', '360', 'WA', 'Olympia'),
('98503', '206', 'WA', 'Lacey'),
('98506', '360', 'WA', 'Olympia'),
('98512', '360', 'WA', 'Olympia'),
('98513', '360', 'WA', 'Olympia'),
('98516', '360', 'WA', 'Olympia'),
('98520', '360', 'WA', 'Aberdeen'),
('98524', '360', 'WA', 'Allyn'),
('98526', '360', 'WA', 'Amanda Park'),
('98528', '360', 'WA', 'Belfair'),
('98531', '360', 'WA', 'Centralia'),
('98532', '360', 'WA', 'Chehalis'),
('98533', '360', 'WA', 'Cinebar'),
('98535', '360', 'WA', 'Copalis Beach'),
('98536', '360', 'WA', 'Copalis Crossing'),
('98537', '360', 'WA', 'Cosmopolis'),
('98538', '360', 'WA', 'Curtis'),
('98541', '360', 'WA', 'Elma'),
('98542', '360', 'WA', 'Ethel'),
('98546', '360', 'WA', 'Grapeview'),
('98547', '360', 'WA', 'Grayland'),
('98548', '360', 'WA', 'Hoodsport'),
('98550', '360', 'WA', 'Hoquiam'),
('98552', '360', 'WA', 'Humptulips'),
('98555', '360', 'WA', 'Lilliwaup'),
('98557', '360', 'WA', 'Mccleary'),
('98563', '360', 'WA', 'Montesano'),
('98564', '360', 'WA', 'Mossyrock'),
('98568', '360', 'WA', 'Oakville'),
('98569', '360', 'WA', 'Ocean Shores'),
('98570', '360', 'WA', 'Onalaska'),
('98572', '360', 'WA', 'Pe Ell'),
('98575', '360', 'WA', 'Quinault'),
('98576', '360', 'WA', 'Rainier'),
('98577', '360', 'WA', 'Raymond'),
('98579', '360', 'WA', 'Rochester'),
('98580', '253', 'WA', 'Roy'),
('98581', '360', 'WA', 'Ryderwood'),
('98582', '360', 'WA', 'Salkum'),
('98584', '360', 'WA', 'Shelton'),
('98585', '360', 'WA', 'Silver Creek'),
('98586', '360', 'WA', 'South Bend'),
('98588', '360', 'WA', 'Tahuya'),
('98589', '360', 'WA', 'Tenino'),
('98590', '360', 'WA', 'Tokeland'),
('98591', '360', 'WA', 'Toledo'),
('98592', '360', 'WA', 'Union'),
('98593', '360', 'WA', 'Vader'),
('98595', '360', 'WA', 'Westport'),
('98596', '360', 'WA', 'Winlock'),
('98597', '360', 'WA', 'Yelm'),
('98601', '360', 'WA', 'Amboy'),
('98602', '509', 'WA', 'Appleton'),
('98603', '360', 'WA', 'Ariel'),
('98604', '360', 'WA', 'Battle Ground'),
('98605', '509', 'WA', 'Bingen'),
('98606', '360', 'WA', 'Brush Prairie'),
('98607', '360', 'WA', 'Camas'),
('98609', '360', 'WA', 'Carrolls'),
('98610', '509', 'WA', 'Carson'),
('98611', '360', 'WA', 'Castle Rock'),
('98612', '360', 'WA', 'Cathlamet'),
('98613', '509', 'WA', 'Centerville'),
('98616', '360', 'WA', 'Cougar'),
('98619', '509', 'WA', 'Glenwood'),
('98620', '509', 'WA', 'Goldendale'),
('98621', '360', 'WA', 'Grays River'),
('98624', '360', 'WA', 'Ilwaco'),
('98625', '360', 'WA', 'Kalama'),
('98626', '360', 'WA', 'Kelso'),
('98628', '509', 'WA', 'Klickitat'),
('98629', '360', 'WA', 'La Center'),
('98631', '360', 'WA', 'Long Beach'),
('98632', '360', 'WA', 'Longview'),
('98635', '509', 'WA', 'Lyle'),
('98638', '360', 'WA', 'Naselle'),
('98640', '360', 'WA', 'Ocean Park'),
('98642', '360', 'WA', 'Ridgefield'),
('98643', '360', 'WA', 'Rosburg'),
('98645', '360', 'WA', 'Silverlake'),
('98647', '360', 'WA', 'Skamokawa'),
('98648', '509', 'WA', 'Stevenson'),
('98649', '360', 'WA', 'Toutle'),
('98650', '509', 'WA', 'Trout Lake'),
('98651', '509', 'WA', 'Underwood'),
('98660', '360', 'WA', 'Vancouver'),
('98661', '360', 'WA', 'Vancouver'),
('98662', '360', 'WA', 'Vancouver'),
('98663', '360', 'WA', 'Vancouver'),
('98664', '360', 'WA', 'Vancouver'),
('98665', '360', 'WA', 'Vancouver'),
('98670', '509', 'WA', 'Wahkiacus'),
('98671', '360', 'WA', 'Washougal'),
('98672', '509', 'WA', 'White Salmon'),
('98674', '360', 'WA', 'Woodland'),
('98675', '360', 'WA', 'Yacolt'),
('98682', '360', 'WA', 'Vancouver'),
('98683', '360', 'WA', 'Vancouver'),
('98684', '360', 'WA', 'Vancouver'),
('98685', '360', 'WA', 'Vancouver'),
('98686', '360', 'WA', 'Vancouver'),
('98801', '509', 'WA', 'Wenatchee'),
('98802', '509', 'WA', 'East Wenatchee'),
('98812', '509', 'WA', 'Brewster'),
('98813', '509', 'WA', 'Bridgeport'),
('98814', '509', 'WA', 'Carlton'),
('98815', '509', 'WA', 'Cashmere'),
('98816', '509', 'WA', 'Chelan'),
('98822', '509', 'WA', 'Entiat'),
('98823', '509', 'WA', 'Ephrata'),
('98826', '509', 'WA', 'Leavenworth'),
('98827', '509', 'WA', 'Loomis'),
('98828', '509', 'WA', 'Malaga'),
('98830', '509', 'WA', 'Mansfield'),
('98831', '509', 'WA', 'Manson'),
('98832', '509', 'WA', 'Marlin'),
('98833', '509', 'WA', 'Mazama'),
('98834', '509', 'WA', 'Methow'),
('98837', '509', 'WA', 'Moses Lake'),
('98840', '509', 'WA', 'Okanogan'),
('98841', '509', 'WA', 'Omak'),
('98843', '509', 'WA', 'Orondo'),
('98844', '509', 'WA', 'Oroville'),
('98845', '509', 'WA', 'Palisades'),
('98846', '509', 'WA', 'Pateros'),
('98847', '509', 'WA', 'Peshastin'),
('98848', '509', 'WA', 'Quincy'),
('98849', '509', 'WA', 'Riverside'),
('98850', '509', 'WA', 'Rock Island'),
('98851', '509', 'WA', 'Soap Lake'),
('98855', '509', 'WA', 'Tonasket'),
('98856', '509', 'WA', 'Twisp'),
('98857', '509', 'WA', 'Warden'),
('98858', '509', 'WA', 'Waterville'),
('98859', '509', 'WA', 'Wauconda'),
('98862', '509', 'WA', 'Winthrop'),
('98901', '509', 'WA', 'Yakima'),
('98902', '509', 'WA', 'Yakima'),
('98903', '509', 'WA', 'Yakima'),
('98908', '509', 'WA', 'Yakima'),
('98922', '509', 'WA', 'Cle Elum'),
('98923', '509', 'WA', 'Cowiche'),
('98926', '509', 'WA', 'Ellensburg'),
('98929', '509', 'WA', 'Naches'),
('98930', '509', 'WA', 'Grandview'),
('98932', '509', 'WA', 'Granger'),
('98933', '509', 'WA', 'Harrah'),
('98935', '509', 'WA', 'Mabton'),
('98936', '509', 'WA', 'Moxee'),
('98937', '509', 'WA', 'Naches'),
('98938', '509', 'WA', 'Outlook'),
('98942', '509', 'WA', 'Selah'),
('98944', '509', 'WA', 'Sunnyside'),
('98946', '509', 'WA', 'Thorp'),
('98947', '509', 'WA', 'Tieton'),
('98948', '509', 'WA', 'Toppenish'),
('98951', '509', 'WA', 'Wapato'),
('98952', '509', 'WA', 'White Swan'),
('98953', '509', 'WA', 'Zillah'),
('99001', '509', 'WA', 'Airway Heights'),
('99003', '509', 'WA', 'Chattaroy'),
('99004', '509', 'WA', 'Cheney'),
('99005', '509', 'WA', 'Colbert'),
('99006', '509', 'WA', 'Deer Park'),
('99008', '509', 'WA', 'Edwall'),
('99009', '509', 'WA', 'Elk'),
('99011', '509', 'WA', 'Fairchild Air Force Base'),
('99012', '509', 'WA', 'Fairfield'),
('99013', '509', 'WA', 'Ford'),
('99016', '509', 'WA', 'Greenacres'),
('99017', '509', 'WA', 'Lamont'),
('99018', '509', 'WA', 'Latah'),
('99019', '509', 'WA', 'Liberty Lake'),
('99021', '509', 'WA', 'Mead'),
('99022', '509', 'WA', 'Medical Lake'),
('99023', '509', 'WA', 'Mica'),
('99025', '509', 'WA', 'Newman Lake'),
('99026', '509', 'WA', 'Nine Mile Falls'),
('99027', '509', 'WA', 'Otis Orchards'),
('99029', '509', 'WA', 'Reardan'),
('99030', '509', 'WA', 'Rockford'),
('99031', '509', 'WA', 'Spangle'),
('99032', '509', 'WA', 'Sprague'),
('99033', '509', 'WA', 'Tekoa'),
('99034', '509', 'WA', 'Tumtum'),
('99036', '509', 'WA', 'Valleyford'),
('99037', '509', 'WA', 'Veradale'),
('99040', '509', 'WA', 'Wellpinit'),
('99101', '509', 'WA', 'Addy'),
('99103', '509', 'WA', 'Almira'),
('99104', '509', 'WA', 'Belmont'),
('99105', '509', 'WA', 'Benge'),
('99107', '509', 'WA', 'Boyds'),
('99109', '509', 'WA', 'Chewelah'),
('99110', '509', 'WA', 'Clayton'),
('99111', '509', 'WA', 'Colfax'),
('99113', '509', 'WA', 'Colton'),
('99114', '509', 'WA', 'Colville'),
('99115', '509', 'WA', 'Coulee City'),
('99116', '509', 'WA', 'Coulee Dam'),
('99117', '509', 'WA', 'Creston'),
('99118', '509', 'WA', 'Curlew'),
('99119', '509', 'WA', 'Cusick'),
('99121', '509', 'WA', 'Danville'),
('99122', '509', 'WA', 'Davenport'),
('99123', '509', 'WA', 'Electric City'),
('99125', '509', 'WA', 'Endicott'),
('99126', '509', 'WA', 'Evans'),
('99128', '509', 'WA', 'Farmington'),
('99129', '509', 'WA', 'Fruitland'),
('99130', '509', 'WA', 'Garfield'),
('99131', '509', 'WA', 'Gifford'),
('99133', '509', 'WA', 'Grand Coulee'),
('99134', '509', 'WA', 'Harrington'),
('99135', '509', 'WA', 'Hartline'),
('99136', '509', 'WA', 'Hay'),
('99137', '509', 'WA', 'Hunters'),
('99138', '509', 'WA', 'Inchelium'),
('99139', '509', 'WA', 'Ione'),
('99140', '509', 'WA', 'Keller'),
('99141', '509', 'WA', 'Kettle Falls'),
('99143', '509', 'WA', 'Lacrosse'),
('99144', '509', 'WA', 'Lamona'),
('99147', '509', 'WA', 'Lincoln'),
('99148', '509', 'WA', 'Loon Lake'),
('99150', '509', 'WA', 'Malo'),
('99153', '509', 'WA', 'Metaline Falls'),
('99154', '509', 'WA', 'Mohler'),
('99156', '509', 'WA', 'Newport'),
('99157', '509', 'WA', 'Northport'),
('99158', '509', 'WA', 'Oakesdale'),
('99159', '509', 'WA', 'Odessa'),
('99160', '509', 'WA', 'Orient'),
('99161', '509', 'WA', 'Palouse'),
('99163', '509', 'WA', 'Pullman'),
('99165', '509', 'WA', 'Pullman'),
('99166', '509', 'WA', 'Republic'),
('99167', '509', 'WA', 'Rice'),
('99169', '509', 'WA', 'Ritzville'),
('99170', '509', 'WA', 'Rosalia'),
('99171', '509', 'WA', 'Saint John'),
('99173', '509', 'WA', 'Springdale'),
('99176', '509', 'WA', 'Thornton'),
('99179', '509', 'WA', 'Uniontown'),
('99180', '509', 'WA', 'Usk'),
('99181', '509', 'WA', 'Valley'),
('99185', '509', 'WA', 'Wilbur'),
('99201', '509', 'WA', 'Spokane'),
('99202', '509', 'WA', 'Spokane'),
('99203', '509', 'WA', 'Spokane'),
('99204', '509', 'WA', 'Spokane'),
('99205', '509', 'WA', 'Spokane'),
('99206', '509', 'WA', 'Spokane'),
('99207', '509', 'WA', 'Spokane'),
('99208', '509', 'WA', 'Spokane'),
('99212', '509', 'WA', 'Spokane'),
('99216', '509', 'WA', 'Spokane'),
('99217', '509', 'WA', 'Spokane'),
('99218', '509', 'WA', 'Spokane'),
('99223', '509', 'WA', 'Spokane'),
('99224', '509', 'WA', 'Spokane'),
('99301', '509', 'WA', 'Pasco'),
('99320', '509', 'WA', 'Benton City'),
('99321', '509', 'WA', 'Beverly'),
('99322', '509', 'WA', 'Bickleton'),
('99323', '509', 'WA', 'Burbank'),
('99324', '509', 'WA', 'College Place'),
('99326', '509', 'WA', 'Connell'),
('99328', '509', 'WA', 'Dayton'),
('99329', '509', 'WA', 'Dixie'),
('99330', '509', 'WA', 'Eltopia'),
('99336', '509', 'WA', 'Kennewick'),
('99337', '509', 'WA', 'Kennewick'),
('99338', '509', 'WA', 'Kennewick'),
('99341', '509', 'WA', 'Lind'),
('99343', '509', 'WA', 'Mesa'),
('99344', '509', 'WA', 'Othello'),
('99347', '509', 'WA', 'Pomeroy'),
('99348', '509', 'WA', 'Prescott'),
('99349', '509', 'WA', 'Mattawa'),
('99350', '509', 'WA', 'Prosser'),
('99352', '509', 'WA', 'Richland'),
('99353', '509', 'WA', 'West Richland'),
('99354', '509', 'WA', 'Richland'),
('99356', '509', 'WA', 'Roosevelt'),
('99357', '509', 'WA', 'Royal City'),
('99360', '509', 'WA', 'Touchet'),
('99361', '509', 'WA', 'Waitsburg'),
('99362', '509', 'WA', 'Walla Walla'),
('99371', '509', 'WA', 'Washtucna'),
('99401', '509', 'WA', 'Anatone'),
('99402', '509', 'WA', 'Asotin'),
('99403', '509', 'WA', 'Clarkston');

INSERT INTO emailProvider (name) VALUES
('yahoo.com'),
('gmail.com'),
('email.com'),
('hotmail.com'),
('mail.com'),
('outlook.com'),
('aol.com'),
('comcast.net'),
('att.net'),
('msn.com'),
('live.com'),
('roadrunner.com'),
('verizon.net'),
('me.com');


-- Returns either TRUE or FALSE.
DROP FUNCTION IF EXISTS randBool;
DELIMITER //
CREATE FUNCTION randBool()
    RETURNS BOOLEAN
    NOT DETERMINISTIC
    NO SQL
BEGIN
    RETURN RAND() < 0.5;
END//
DELIMITER ;


-- Returns a pseudo random integer between low and high inclusive.
DROP FUNCTION IF EXISTS randInt;
DELIMITER //
CREATE FUNCTION randInt(low INT, high INT)
    RETURNS INT
    NOT DETERMINISTIC
    NO SQL
BEGIN
    RETURN low + FLOOR(RAND() * (high - low + 1));
END//
DELIMITER ;


-- Returns a value rounded to a fractional value.
-- For example roundToFrac(12.167, 0.25) returns 12.25
DROP FUNCTION IF EXISTS roundToFrac;
DELIMITER //
CREATE FUNCTION roundToFrac(value DOUBLE, frac DOUBLE)
    RETURNS DOUBLE
    DETERMINISTIC
    NO SQL
BEGIN
    RETURN ROUND(value / frac) * frac;
END//
DELIMITER ;


-- Returns either 'M' or 'F'.
DROP FUNCTION IF EXISTS gender;
DELIMITER //
CREATE FUNCTION gender()
    RETURNS CHAR(1)
    NOT DETERMINISTIC
    NO SQL
BEGIN
    DECLARE g CHAR(1);
    IF RAND() < 0.5 THEN
        SET g = 'M';
    ELSE
        SET g = 'F';
    END IF;
    RETURN g;
END//
DELIMITER ;


-- Returns a person's given name, often called the first name.
DROP FUNCTION IF EXISTS givenName;
DELIMITER //
CREATE FUNCTION givenName()
    RETURNS TEXT
    NOT DETERMINISTIC
    READS SQL DATA
BEGIN
    -- This query to pseudo randomly choose a row from a table
    -- came from the excellent article written by Jan Kneschke at
    -- http://jan.kneschke.de/projects/mysql/order-by-rand/
    RETURN
        (SELECT name
         FROM givenName AS t
         INNER JOIN
             (SELECT 1 + FLOOR(RAND() * (SELECT MAX(id) FROM givenName)) AS id)
                AS r
         WHERE t.id >= r.id
         ORDER BY t.id
         LIMIT 1);
END//
DELIMITER ;


-- Returns a male person's given name, often called the first name.
-- The list of names came from the U.S. Social Security Administration.
DROP FUNCTION IF EXISTS givenMaleName;
DELIMITER //
CREATE FUNCTION givenMaleName()
    RETURNS TEXT
    NOT DETERMINISTIC
    READS SQL DATA
BEGIN
    -- Pseudo randomly choose a row number.
    DECLARE size, rowNum INT;
    SET size = (SELECT COUNT(*) FROM givenName WHERE gender = 'M');
    SET rowNum = 1 + FLOOR(RAND() * size);

    -- Select one male name from the givenName table.
    RETURN
        (SELECT name
        FROM givenName
        WHERE gender = 'M'
        ORDER BY id
        LIMIT rowNum, 1);
END//
DELIMITER ;


-- Returns a female person's given name, often called the first name.
-- The list of names came from the U.S. Social Security Administration.
DROP FUNCTION IF EXISTS givenFemaleName;
DELIMITER //
CREATE FUNCTION givenFemaleName()
    RETURNS TEXT
    NOT DETERMINISTIC
    READS SQL DATA
BEGIN
    -- Pseudo randomly choose a row number.
    DECLARE size, rowNum INT;
    SET size = (SELECT COUNT(*) FROM givenName WHERE gender = 'F');
    SET rowNum = 1 + FLOOR(RAND() * size);

    -- Select one female name from the givenName table.
    RETURN
        (SELECT name
        FROM givenName
        WHERE gender = 'F'
        ORDER BY id
        LIMIT rowNum, 1);
END//
DELIMITER ;


-- Returns a person's family name, often called the surname or last name.
-- The list of names came from the U.S. Social Security Administration.
DROP FUNCTION IF EXISTS familyName;
DELIMITER //
CREATE FUNCTION familyName()
    RETURNS TEXT
    NOT DETERMINISTIC
    READS SQL DATA
BEGIN
    RETURN
        (SELECT name
         FROM familyName AS t
         INNER JOIN
             (SELECT 1 + FLOOR(RAND() * (SELECT MAX(id) FROM familyName)) AS id)
                AS r
         WHERE t.id >= r.id
         ORDER BY t.id
         LIMIT 1);
END//
DELIMITER ;


-- Returns a pseudo random email address.
DROP FUNCTION IF EXISTS email;
DELIMITER //
CREATE FUNCTION email(givenName TEXT, familyName TEXT)
    RETURNS TEXT
    NOT DETERMINISTIC
    READS SQL DATA
BEGIN
    DECLARE len INT;
    DECLARE email, sep, provider TEXT;

    IF RAND() < 0.5 THEN
        IF RAND() < 0.5 THEN
            SET givenName = SUBSTR(givenName, 1, 1);
        END IF;
    ELSE
        IF RAND() < 0.5 THEN
            SET familyName = SUBSTR(familyName, 1, 1);
        END IF;
    END IF;

    CASE randInt(1, 4)
        WHEN 1 THEN SET sep = '';
        WHEN 2 THEN SET sep = '.';
        WHEN 3 THEN SET sep = '-';
        WHEN 4 THEN SET sep = '_';
    END CASE;

    IF RAND() < 0.5 THEN
        SET email = CONCAT(givenName, sep, familyName);
    ELSE
        SET email = CONCAT(familyName, sep, givenName);
    END IF;
    SET email = LCASE(email);

    SET provider =
        (SELECT name
         FROM emailProvider AS t
         INNER JOIN
         (SELECT 1 + FLOOR(RAND() * (SELECT MAX(id) FROM emailProvider)) AS id)
             AS r
         WHERE t.id >= r.id
         ORDER BY t.id
         LIMIT 1);

    RETURN CONCAT(email, '@', provider);
END//
DELIMITER ;


-- Returns a pseudo random phone number with the given area code.
DROP FUNCTION IF EXISTS phone;
DELIMITER //
CREATE FUNCTION phone(area TEXT)
    RETURNS TEXT
    NOT DETERMINISTIC
    NO SQL
BEGIN
    DECLARE prefix, four TEXT;
    SET prefix = CAST(randInt(100, 999) AS CHAR);
    SET four = CAST(randInt(1, 9999) AS CHAR);
    SET four = CONCAT(SUBSTR('000', 1, 4 - CHAR_LENGTH(four)), four);
    RETURN CONCAT(area, prefix, four);
END//
DELIMITER ;


-- Returns the first part of a street address such as '4708 Ridge Way'.
DROP FUNCTION IF EXISTS street1;
DELIMITER //
CREATE FUNCTION street1()
    RETURNS TEXT
    NOT DETERMINISTIC
    READS SQL DATA
BEGIN
    DECLARE low, number INT;
    DECLARE street, type TEXT;

    SET low = POW(10, randInt(1, 3));
    SET number = randInt(low, low * 10 - 1);

    SET street =
        (SELECT name
         FROM street AS t
         INNER JOIN
             (SELECT 1 + FLOOR(RAND() * (SELECT MAX(id) FROM street)) AS id)
                 AS r
         WHERE t.id >= r.id
         ORDER BY t.id
         LIMIT 1);

    SET type =
        (SELECT name
         FROM streetType AS t
         INNER JOIN
             (SELECT 1 + FLOOR(RAND() * (SELECT MAX(id) FROM streetType)) AS id)
                 AS r
         WHERE t.id >= r.id
         ORDER BY t.id
         LIMIT 1);

    RETURN CONCAT(number, ' ', street, ' ', type);
END//
DELIMITER ;


-- Returns the optional second part of a street address such as 'Apt 25'.
DROP FUNCTION IF EXISTS street2;
DELIMITER //
CREATE FUNCTION street2()
    RETURNS TEXT
    NOT DETERMINISTIC
    NO SQL
BEGIN
    DECLARE addr, type TEXT;
    DECLARE low, number INT;

    IF RAND() < 0.25 THEN
        IF RAND() < 0.25 THEN
            SET type = 'Ste';
        ELSE
            SET type = 'Apt';
        END IF;
        SET low = POW(10, randInt(1, 3));
        SET number = randInt(low, low * 10 - 1);
        SET addr = CONCAT(type, ' ', number);
    END IF;
    RETURN addr;
END//
DELIMITER ;


-- Returns a zip code chosen pseudo randomly.
DROP FUNCTION IF EXISTS zipCode;
DELIMITER //
CREATE FUNCTION zipCode()
    RETURNS TEXT
    NOT DETERMINISTIC
    READS SQL DATA
BEGIN
    RETURN
        (SELECT zipCode
         FROM zipCode AS t
         INNER JOIN
             (SELECT 1 + FLOOR(RAND() * (SELECT MAX(id) FROM zipCode)) AS id)
                 AS r
         WHERE t.id >= r.id
         ORDER BY t.id
         LIMIT 1);
END//
DELIMITER ;


-- Returns a zip code picked pseudo randomly from the given state.
DROP FUNCTION IF EXISTS zipCodeFromState;
DELIMITER //
CREATE FUNCTION zipCodeFromState(abbrev TEXT)
    RETURNS TEXT
    NOT DETERMINISTIC
    READS SQL DATA
BEGIN
    -- Pseudo randomly choose a row number.
    DECLARE size, rowNum INT;
    SET size = (SELECT COUNT(*) FROM zipCode WHERE stateAbbrev = abbrev);
    SET rowNum = 1 + FLOOR(RAND() * size);

    -- Select one ZIP code name from the zipCode table.
    RETURN
        (SELECT zipCode
        FROM zipCode
        WHERE stateAbbrev = abbrev
        ORDER BY id
        LIMIT rowNum, 1);

END//
DELIMITER ;


-- Returns a city for the given zip code.
DROP FUNCTION IF EXISTS city;
DELIMITER //
CREATE FUNCTION city(zip TEXT)
    RETURNS TEXT
    DETERMINISTIC
    READS SQL DATA
BEGIN
    RETURN (SELECT city FROM zipCode WHERE zipCode = zip);
END//
DELIMITER ;


-- Returns the state for the given zip code.
DROP FUNCTION IF EXISTS state;
DELIMITER //
CREATE FUNCTION state(zip TEXT)
    RETURNS TEXT
    DETERMINISTIC
    READS SQL DATA
BEGIN
    RETURN (SELECT stateAbbrev FROM zipCode WHERE zipCode = zip);
END//
DELIMITER ;


-- Returns a telephone area code for the given zip code.
DROP FUNCTION IF EXISTS areaCode;
DELIMITER //
CREATE FUNCTION areaCode(zip TEXT)
    RETURNS TEXT
    DETERMINISTIC
    READS SQL DATA
BEGIN
    RETURN (SELECT areaCode FROM zipCode WHERE zipCode = zip);
END//
DELIMITER ;


-- Returns a psuedo random password. This is
-- NOT a secure way to generate a password.
DROP FUNCTION IF EXISTS password;
DELIMITER //
CREATE FUNCTION password()
    RETURNS TEXT
    NOT DETERMINISTIC
    NO SQL
BEGIN
    DECLARE n INT;
    DECLARE pw TEXT DEFAULT '';
    SET n = randInt(8, 12);
    WHILE n != 0 DO
        SET pw = CONCAT(pw, CHAR(randInt(32, 127)));
        SET n = n - 1;
    END WHILE;
    RETURN pw;
END//
DELIMITER ;
