-- phpMyAdmin SQL Dump
-- version 4.9.5deb2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 20, 2023 at 07:44 PM
-- Server version: 10.3.34-MariaDB-0ubuntu0.20.04.1
-- PHP Version: 7.4.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ideal_business`
--

-- --------------------------------------------------------

--
-- Table structure for table `agpapi_orders`
--

CREATE TABLE `agpapi_orders` (
  `id` bigint(20) NOT NULL,
  `vendor_order_id` varchar(10) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `agent_email` varchar(250) DEFAULT NULL,
  `agent_name` varchar(150) DEFAULT NULL,
  `agent_upn` varchar(12) DEFAULT NULL,
  `agent_aor` varchar(12) DEFAULT NULL,
  `grand_total` double DEFAULT 0,
  `amt_paid_by_credit` double DEFAULT 0,
  `amt_paid_by_folio` double DEFAULT 0,
  `apply_cost_share` double DEFAULT 0,
  `amt_refunded_to_credit` double DEFAULT 0,
  `amt_refunded_to_folio` double DEFAULT 0,
  `subscription_id` bigint(12) DEFAULT NULL,
  `cancelled_date` date DEFAULT NULL,
  `sku` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `phone_no` varchar(12) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `state_code` varchar(7) DEFAULT NULL,
  `city` varchar(15) DEFAULT NULL,
  `address` varchar(150) DEFAULT NULL,
  `cost` double DEFAULT 0,
  `fee` double DEFAULT 0,
  `tax` double DEFAULT 0,
  `cost_share_total` double DEFAULT 0,
  `folio_total` double DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agpapi_orders`
--

INSERT INTO `agpapi_orders` (`id`, `vendor_order_id`, `order_date`, `agent_email`, `agent_name`, `agent_upn`, `agent_aor`, `grand_total`, `amt_paid_by_credit`, `amt_paid_by_folio`, `apply_cost_share`, `amt_refunded_to_credit`, `amt_refunded_to_folio`, `subscription_id`, `cancelled_date`, `sku`, `created_at`, `phone_no`, `zip`, `state_code`, `city`, `address`, `cost`, `fee`, `tax`, `cost_share_total`, `folio_total`) VALUES
(76, 'F28037', '2023-01-11', 'cpineda@farmersagent.com', 'Cesar Pineda', '1059142', '82193K', 999, 0, 999, 1, 0, 0, 468, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:34', '2038032153', '06854', 'CT', 'NORWALK', '8 N MAIN ST', 999, 0, 0, 499.5, 999),
(77, 'F28465', '2023-01-11', 'cbattle@farmersagent.com', 'Cristina Battle', '15187', '1964L1', 999, 0, 999, 1, 0, 0, 469, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:36', '7132787878', '77057', 'TX', 'HOUSTON', '2909 HILLCROFT ST STE 100', 999, 0, 0, 499.5, 999),
(78, 'F29294', '2023-01-11', 'cmclaurin@farmersagent.com', 'Clarence A Mclaurin', '1100120', '4419EW', 999, 0, 999, 0, 0, 0, 473, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:39', '6784895974', '30214', 'GA', 'FAYETTEVILLE', '500 LANIER AVE W STE 912A', 999, 0, 0, 0, 999),
(79, 'F29472', '2023-01-11', 'tlake@farmersagent.com', 'Tammy S Lake', '1347105', '2255GW', 548.9, 0, 548.9, 1, 0, 0, 474, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:07:41', '7088546283', '60513', 'IL', 'BROOKFIELD', '9140 BROADWAY AVE', 499, 0, 49.9, 500, 548.9),
(80, 'F29548', '2023-01-11', 'ghenderson1@farmersagent.com', 'Genia Anne Henderson', '1144736', '95317R', 999, 999, 0, 0, 0, 0, 476, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:42', '5303459035', '95973', 'CA', 'CHICO', '2535 CEANOTHUS AVE STE 120', 999, 0, 0, 0, 0),
(81, 'F29572', '2023-01-11', 'dnelms@farmersagent.com', 'Don E Nelms', '30798', '88283R', 999, 0, 999, 0, 0, 0, 478, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:45', '9282826052', '86336', 'AZ', 'SEDONA', '70 TORTILLA DR', 999, 0, 0, 0, 999),
(82, 'F31215', '2023-01-12', 'cporschien@farmersagent.com', 'Carl Porschien', '1384169', '08105W', 999, 0, 999, 1, 0, 0, 485, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:46', '9189946111', '74133', 'OK', 'TULSA', '8282 S MEMORIAL DR STE 303', 999, 0, 0, 499.5, 999),
(83, 'F31453', '2023-01-12', 'kholdman@farmersagent.com', 'Kyle Dillard Holdman', '1329190', '0810XX', 999, 0, 999, 1, 0, 0, 486, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:47', '9187141404', '74133', 'OK', 'TULSA', '6536 E 91ST ST', 999, 0, 0, 499.5, 999),
(84, 'F32140', '2023-01-12', 'btobin@farmersagent.com', 'William B Tobin', '17782', '160676', 499, 0, 499, 1, 0, 0, 489, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:07:49', '5058998081', '87120', 'NM', 'ALBUQUERQUE', '6200 COORS BLVD NW STE K2', 499, 0, 0, 249.5, 499),
(85, 'F32435', '2023-01-13', 'jhaddad@farmersagent.com', 'Joseph Hussam Haddad', '869029', '97443G', 499, 0, 499, 0, 0, 0, 493, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:07:51', '5628063700', '90240', 'CA', 'DOWNEY', '8054 TELEGRAPH RD', 499, 0, 0, 0, 499),
(86, 'F32450', '2023-01-13', 'ythompson@farmersagent.com', 'Marshall Yogi Thompson', '18704', '36176T', 999, 0, 999, 1, 0, 0, 494, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:53', '8122323129', '47802', 'IN', 'TERRE HAUTE', 'PO BOX 2129', 999, 0, 0, 499.5, 999),
(87, 'F33261', '2023-01-13', 'khartley@farmersagent.com', 'Kristine Michele Hartley', '1119635', '7111EL', 999, 0, 999, 0, 0, 0, 496, NULL, '176-Farmers Store Annual', '2023-02-12 23:07:55', '2488473167', '48301', 'MI', 'BLOOMFIELD HILL', '6421 INKSTER RD STE 108', 999, 0, 0, 0, 0),
(88, 'F35594', '2023-01-13', 'aanderson5@farmersagent.com', 'Ambrose D Anderson', '1377398', '1212C8', 499, 0, 499, 1, 0, 0, 500, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:07:56', '4022583775', '68137', 'NE', 'OMAHA', '4138 S 144TH ST', 499, 0, 0, 0, 0),
(89, 'F35859', '2023-01-13', 'dwood1@farmersagent.com', 'David Robert Wood', '1072798', '30265L', 499, 0, 499, 0, 0, 0, 502, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:07:58', '4242743154', '90069', 'CA', 'WEST HOLLYWOOD', '616 1/2 N DOHENY DR', 499, 0, 0, 0, 0),
(90, 'F39348', '2023-01-16', 'jguerrero1@farmersagent.com', 'Jasmine Janson Corona', '82459', '996566', 999, 499.5, 499.5, 1, 0, 0, 508, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:00', '6195016400', '92103', 'CA', 'SAN DIEGO', '2900 4TH AVE STE 202', 999, 0, 0, 0, 0),
(91, 'F39587', '2023-01-16', 'rmartinez1@farmersagent.com', 'Rafael Martinez', '1182985', '35763W', 999, 0, 999, 1, 0, 0, 509, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:01', '9152097689', '79912', 'TX', 'EL PASO', '7211 N MESA ST STE 2W', 999, 0, 0, 0, 0),
(92, 'F42880', '2023-01-17', 'mfranco2@farmersagent.com', 'Marcos Franco', '1402265', '35049J', 999, 0, 999, 1, 0, 0, 516, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:03', '9722273183', '75218', 'TX', 'DALLAS', '9540 GARLAND RD STE 294F', 999, 0, 0, 0, 0),
(93, 'F43069', '2023-01-17', 'aambartsumyan@farmersagent.com', 'Armine Ambartsumyan', '1307125', '304801', 899, 0, 899, 1, 0, 0, 520, NULL, '179-Farmers DM Store Quarterly', '2023-02-12 23:08:05', '8188045106', '91316', 'CA', 'ENCINO', '6345 BALBOA BLVD STE 272', 899, 0, 0, 0, 0),
(94, 'F47112', '2023-01-12', 'jdubose@farmersagent.com', 'Jennifer A DuBose', '1165452', '411909', 499, 0, 499, 1, 0, 0, 1824, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:08:07', '3522040007', '32606', 'FL', 'GAINESVILLE', '4400 NW 23RD AVE STE B', 499, 0, 0, 249.5, 499),
(95, 'F47113', '2023-01-12', 'fflores@farmersagent.com', 'Frankie Flores', '885776', '960101', 899, 0, 899, 1, 0, 0, 1825, NULL, '179-Farmers DM Store Quarterly', '2023-02-12 23:08:08', '5106544949', '94608', 'CA', 'EMERYVILLE', '1250 45TH ST STE 350', 899, 0, 0, 449.5, 899),
(96, 'F47114', '2023-01-12', 'gbrown3@farmersagent.com', 'Gregory Lynn Brown', '1187355', '0875GN', 999, 0, 999, 1, 0, 0, 1826, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:10', '4057519453', '73120', 'OK', 'OKLAHOMA CITY', '12304 N MAY AVE', 999, 0, 0, 499.5, 999),
(97, 'F47115', '2023-01-12', 'jcline@farmersagent.com', 'Jim D Cline II', '22482', '66252C', 999, 0, 999, 1, 0, 0, 1827, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:12', '4232475400', '37664', 'TN', 'KINGSPORT', '1309 E CENTER ST', 999, 0, 0, 499.5, 999),
(98, 'F47116', '2023-01-12', 'bmiller10@farmersagent.com', 'Brian Miller Miller', '1092985', '0706AC', 999, 0, 999, 0, 0, 0, 1828, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:14', '7193598681', '80920', 'CO', 'COLORADO SPRING', '5410 POWERS CTR PT STE 120', 999, 0, 0, 0, 999),
(99, 'F47117', '2023-01-12', 'fmoreno2@farmersagent.com', 'Frank Casillas Moreno', '1027490', '160983', 999, 0, 999, 1, 0, 0, 1829, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:15', '5755413963', '88005', 'NM', 'LAS CRUCES', '3301 S MAIN ST STE A', 999, 0, 0, 499.5, 999),
(100, 'F47118', '2023-01-12', 'jmccowan@farmersagent.com', 'Joseph E McCowan', '1266968', '36216K', 999, 0, 999, 0, 0, 0, 1830, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:16', '2192141400', '46307', 'IN', 'CROWN POINT', '1302 N MAIN ST STE 8', 999, 0, 0, 0, 999),
(101, 'F47119', '2023-01-12', 'jstoops@farmersagent.com', 'Jenny Stoops', '1139772', '36508N', 999, 0, 999, 1, 0, 0, 1831, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:18', '3178880001', '46237', 'IN', 'INDIANAPOLIS', '7855 S EMERSON AVE STE A', 999, 0, 0, 499.5, 999),
(102, 'F47120', '2023-01-12', 'afoose@farmersagent.com', 'Aimee Skul', '30129', '07278E', 999, 0, 999, 1, 0, 0, 1832, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:19', '7209749320', '80004', 'CO', 'ARVADA', '5900 WARD RD', 999, 0, 0, 499.5, 999),
(103, 'F47121', '2023-01-12', 'jfitzpatrick@farmersagent.com', 'Joshua Lucas Fitzpatrick', '972280', '913941', 999, 0, 999, 1, 0, 0, 1833, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:21', '3019878878', '20877', 'MD', 'GAITHERSBURG', '12 S SUMMIT AVE STE 100-A31', 999, 0, 0, 499.5, 999),
(104, 'F47122', '2023-01-12', 'lleahy@farmersagent.com', 'Laura Winifred Leahy', '1274565', '411993', 999, 0, 999, 1, 0, 0, 1834, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:22', '3529002740', '32726', 'FL', 'EUSTIS', '441 PLAZA DR', 999, 0, 0, 999, 999),
(105, 'F47123', '2023-01-12', 'srigetta@farmersagent.com', 'Steffanie Lyn Rigetta', '1167615', '411922', 999, 0, 999, 1, 0, 0, 1835, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:24', '4077753001', '32701', 'FL', 'ALTAMONTE SPRIN', '622 MAITLAND AVE', 999, 0, 0, 499.5, 999),
(106, 'F47124', '2023-01-12', 'mnimetz@farmersagent.com', 'Marc Nimetz', '794593', '99366J', 999, 0, 999, 1, 0, 0, 1836, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:26', '8588668147', '92064', 'CA', 'POWAY', '15644 POMERADO RD STE 104', 999, 0, 0, 499.5, 999),
(107, 'F47125', '2023-01-12', 'swilson3@farmersagent.com', 'Steven Michael Wilson', '110744', '99847T', 999, 0, 999, 1, 0, 0, 1837, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:27', '8583760333', '92127', 'CA', 'SAN DIEGO', '11245 W BERNARDO CT STE 102', 999, 0, 0, 499.5, 999),
(108, 'F47126', '2023-01-12', 'akhan@farmersagent.com', 'Arif Khan', '1131146', '134432', 999, 0, 999, 1, 0, 0, 1838, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:28', '9524326000', '55347', 'MN', 'EDEN PRAIRIE', '8929 AZTEC DR STE E115', 999, 0, 0, 499.5, 999),
(109, 'F47127', '2023-01-12', 'amontez@farmersagent.com', 'Amanda Leigh Montez', '98669', '3520AW', 999, 0, 999, 1, 0, 0, 1839, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:30', '6823342225', '76117', 'TX', 'HALTOM CITY', '6209 AIRPORT FWY', 999, 0, 0, 499.5, 999),
(110, 'F47128', '2023-01-12', 'dtunstall@farmersagent.com', 'DuShawn Tunstall', '1071379', '36954A', 999, 0, 999, 1, 0, 0, 1840, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:31', '3177624012', '46250', 'IN', 'INDIANAPOLIS', '8413 CASTLETON CORNER DR', 999, 0, 0, 499.5, 999),
(111, 'F47129', '2023-01-12', 'djones7@farmersagent.com', 'Daniel Beaman Jones', '15709', '35906V', 999, 0, 999, 1, 0, 0, 1841, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:33', '9723510042', '75165', 'TX', 'WAXAHACHIE', '114 PARK PLACE CT STE 202', 999, 0, 0, 499.5, 999),
(112, 'F47130', '2023-01-12', 'rmartin12@farmersagent.com', 'Richard Samuel Martin', '1126332', '686179', 999, 0, 999, 0, 0, 0, 1842, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:34', '4343282524', '22901', 'VA', 'CHARLOTTESVILLE', '2340 COMMONWEALTH DR STE 102', 999, 0, 0, 0, 999),
(113, 'F47131', '2023-01-12', 'vstewart@farmersagent.com', 'Veronica Elizabeth Stewart', '1185810', '91397F', 999, 0, 999, 1, 0, 0, 1843, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:35', '3016373386', '20601', 'MD', 'WALDORF', '3050 CRAIN HWY STE 301', 999, 0, 0, 499.5, 999),
(114, 'F47132', '2023-01-12', 'kanthony@farmersagent.com', 'Keith Edward Anthony', '1127063', '95346T', 999, 0, 999, 1, 0, 0, 1844, NULL, '176-Farmers Store Annual', '2023-02-12 23:08:37', '5309234363', '95991', 'CA', 'YUBA CITY', '472 CENTURY PARK DR # 200', 999, 0, 0, 499.5, 999),
(115, 'F47133', '2023-01-12', 'estimmel@farmersagent.com', 'Eric T Stimmel', '51364', '35959T', 999, 0, 999, 1, 0, 0, 1845, NULL, '176-Farmers Store Annual', '2023-02-12 23:10:49', '5123821241', '78756', 'TX', 'AUSTIN', '3810 MEDICAL PKWY STE 214', 999, 0, 0, 499.5, 999),
(116, 'F47134', '2023-01-12', 'kbora@farmersagent.com', 'Kiran Kumar Bora', '1093487', '47293N', 999, 0, 999, 1, 0, 0, 1846, NULL, '176-Farmers Store Annual', '2023-02-12 23:10:52', '5183067110', '12866', 'NY', 'SARATOGA SPRING', '178 ELM ST STE 1', 999, 0, 0, 499.5, 999),
(117, 'F47135', '2023-01-12', 'rblack@farmersagent.com', 'Robert Brian Black', '1276136', '35324T', 999, 0, 999, 1, 0, 0, 1847, NULL, '176-Farmers Store Annual', '2023-02-12 23:10:53', '2547721444', '76712', 'TX', 'WACO', '1201 HEWITT DR STE 106A', 999, 0, 0, 999, 999),
(118, 'F47136', '2023-01-12', 'avillarreal@farmersagent.com', 'Annalisa Villarreal', '1162891', '35753M', 999, 0, 999, 1, 0, 0, 1848, NULL, '176-Farmers Store Annual', '2023-02-12 23:10:56', '4322426007', '79761', 'TX', 'ODESSA', '420 N TEXAS AVE', 999, 0, 0, 499.5, 999),
(119, 'F47137', '2023-01-12', 'dmelton@farmersagent.com', 'Dale Alan Melton', '1079357', '44199L', 999, 0, 999, 1, 0, 0, 1849, NULL, '176-Farmers Store Annual', '2023-02-12 23:10:57', '4785514412', '31088', 'GA', 'WARNER ROBINS', '133A CARL VINSON PKWY', 999, 0, 0, 499.5, 999),
(120, 'F47138', '2023-01-12', 'sreece@farmersagent.com', 'Shaine R Reece', '28872', '70141R', 999, 0, 999, 1, 0, 0, 1850, NULL, '176-Farmers Store Annual', '2023-02-12 23:10:59', '4067529100', '59901', 'MT', 'KALISPELL', '575 SUNSET BLVD STE 102', 999, 0, 0, 499.5, 999),
(121, 'F47139', '2023-01-12', 'lluce@farmersagent.com', 'Larissa Lidia Luce', '1159588', '16138P', 999, 0, 999, 1, 0, 0, 1851, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:00', '5058995500', '87120', 'NM', 'ALBUQUERQUE', '2641 COORS BLVD NW STE C', 999, 0, 0, 999, 999),
(122, 'F47140', '2023-01-12', 'mesfahani@farmersagent.com', 'Michael Heidarian Esfahani', '1283088', '3590HL', 999, 0, 999, 1, 0, 0, 1852, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:02', '9724922711', '75024', 'TX', 'PLANO', '7000 PRESTON RD STE 900', 999, 0, 0, 999, 999),
(123, 'F47141', '2023-01-12', 'rtrevino@farmersagent.com', 'Rene Trevino', '984012', '19408G', 999, 0, 999, 1, 0, 0, 1853, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:04', '9562050338', '78542', 'TX', 'EDINBURG', '2326 E FREDDY GONZALEZ DR', 999, 0, 0, 499.5, 999),
(124, 'F47142', '2023-01-12', 'tbailey@farmersagent.com', 'Tonzaino Bailey', '1137697', '19257A', 999, 0, 999, 1, 0, 0, 1854, '2023-01-01', '176-Farmers Store Annual', '2023-02-12 23:11:05', '8327271968', '77073', 'TX', 'HOUSTON', '324 FM 1960 RD STE 109', 999, 0, 0, 499.5, 999),
(125, 'F47143', '2023-01-12', 'teddie@farmersagent.com', 'Torrence A Eddie', '1259583', '66022H', 999, 0, 999, 1, 0, 0, 1855, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:07', '9015092475', '38115', 'TN', 'MEMPHIS', '3317 KIRBY PKWY', 999, 0, 0, 999, 999),
(126, 'F47144', '2023-01-12', 'bgrebin@farmersagent.com', 'Bruce Grebin', '1055629', '88109G', 499, 0, 499, 1, 0, 0, 1856, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:11:11', '4805981110', '85250', 'AZ', 'SCOTTSDALE', '6609 N SCOTTSDALE RD STE 105A&B', 499, 0, 0, 249.5, 499),
(127, 'F47145', '2023-01-12', 'mstecher@farmersagent.com', 'Michelle Denise Wilson-Stecher', '84038', '160905', 499, 0, 499, 1, 0, 0, 1857, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:11:13', '5755251499', '88001', 'NM', 'LAS CRUCES', '2990 N MAIN ST STE 3A', 499, 0, 0, 249.5, 499),
(128, 'F47146', '2023-01-12', 'gwalton@farmersagent.com', 'Gilbert Lionel Walton', '1132289', '47192L', 999, 0, 999, 1, 0, 0, 1858, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:14', '9147404800', '10801', 'NY', 'NEW ROCHELLE', '365 NORTH AVE', 999, 0, 0, 499.5, 999),
(129, 'F47147', '2023-01-12', 'lha@farmersagent.com', 'Leslie Lan Ha', '41629', '304165', 999, 0, 999, 1, 0, 0, 1859, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:16', '6263504166', '91790', 'CA', 'WEST COVINA', '1730 W CAMERON AVE STE 100', 999, 0, 0, 499.5, 999),
(130, 'F47148', '2023-01-12', 'mnacht@farmersagent.com', 'Mark D Nacht', '1161839', '2502AW', 999, 0, 999, 1, 0, 0, 1860, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:18', '2164551687', '44124', 'OH', 'PEPPER PIKE', '30559 PINETREE RD STE 218', 999, 0, 0, 499.5, 999),
(131, 'F47149', '2023-01-12', 'tjimenez1@farmersagent.com', 'Talia Jimenez Ramiro Castelan', '1284685', '07235L', 999, 0, 999, 1, 0, 0, 1861, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:20', '7207408454', '80033', 'CO', 'WHEAT RIDGE', '6279 W 38TH AVE STE 9', 999, 0, 0, 999, 999),
(132, 'F47150', '2023-01-12', 'wchandler@farmersagent.com', 'William D Chandler', '1353119', '41193W', 999, 0, 999, 1, 0, 0, 1862, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:21', '3526095166', '32778', 'FL', 'TAVARES', '2026 STATE ROAD 19', 999, 0, 0, 999, 999),
(133, 'F47151', '2023-01-12', 'zgulko@farmersagent.com', 'Zeva Gulko', '1165456', '0609JK', 999, 0, 999, 1, 0, 0, 1863, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:23', '2675189109', '18954', 'PA', 'RICHBORO', '1077 2ND STREET PIKE', 999, 0, 0, 999, 999),
(134, 'F47152', '2023-01-12', 'chart2@farmersagent.com', 'Cheryl D Hart-Munoz', '35969', '976608', 999, 0, 999, 1, 0, 0, 1864, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:25', '9516000500', '92562', 'CA', 'MURRIETA', '26413 JEFFERSON AVE STE H', 999, 0, 0, 499.5, 999),
(135, 'F47153', '2023-01-12', 'vsood@farmersagent.com', 'Vimal Kumar Sood', '77888', '309192', 999, 0, 999, 1, 0, 0, 1865, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:27', '8183441784', '91335', 'CA', 'RESEDA', '18625 SHERMAN WAY STE 108', 999, 0, 0, 499.5, 999),
(136, 'F47154', '2023-01-12', 'aritchie@farmersagent.com', 'Andrew David Ritchie', '869852', '084910', 999, 0, 999, 1, 0, 0, 1866, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:28', '5802336640', '73701', 'OK', 'ENID', '220 W BROADWAY AVE', 999, 0, 0, 499.5, 999),
(137, 'F47155', '2023-01-12', 'ncovington@farmersagent.com', 'Nicole Starr Glass', '992368', '2548AA', 999, 0, 999, 1, 0, 0, 1867, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:29', '6146016016', '43085', 'OH', 'WORTHINGTON', '660 HIGH ST STE 201', 999, 0, 0, 499.5, 999),
(138, 'F47156', '2023-01-12', 'tguerrero1@farmersagent.com', 'Tony Paul Guerrero', '1049917', '96659P', 999, 0, 999, 1, 0, 0, 1868, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:31', '9252420684', '94583', 'CA', 'SAN RAMON', '3180 CROW CANYON PL STE 220', 999, 0, 0, 499.5, 999),
(139, 'F47157', '2023-01-12', 'vghookassian@farmersagent.com', 'Vahe Ghookassian', '774332', '309101', 2697, 0, 2697, 1, 0, 0, 1869, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:11:32', '8185217894', '91210', 'CA', 'GLENDALE', '100 W BROADWAY STE 510', 2697, 0, 0, 1348.5, 2697),
(140, 'F47158', '2023-01-12', 'mnewmankuzel@farmersagent.com', 'Mark Thomas Newman-Kuzel', '1001360', '30441V', 999, 0, 999, 0, 0, 0, 1870, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:34', '3236600076', '90014', 'CA', 'LOS ANGELES', '742 S HILL ST STE 703', 999, 0, 0, 0, 999),
(141, 'F47159', '2023-01-12', 'dpulieri@farmersagent.com', 'David A Pulieri', '1155025', '0609C1', 999, 0, 999, 1, 0, 0, 1871, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:36', '6104198430', '18017', 'PA', 'BETHLEHEM', '2005 STEFKO BLVD UNIT E', 999, 0, 0, 499.5, 999),
(142, 'F47160', '2023-01-12', 'lwilson@farmersagent.com', 'Lorna Michel Wilson', '1250287', '411972', 999, 0, 999, 1, 0, 0, 1872, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:38', '8638668990', '33844', 'FL', 'HAINES CITY', '535 US HWY 17 92 W', 999, 0, 0, 999, 999),
(143, 'F47161', '2023-01-12', 'ahuante@farmersagent.com', 'Ann Marie Huante', '1094449', '9715GK', 999, 0, 999, 1, 0, 0, 1873, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:40', '9492728845', '92846', 'CA', 'GARDEN GROVE', 'PO BOX 5551', 999, 0, 0, 999, 999),
(144, 'F47162', '2023-01-12', 'bmills@farmersagent.com', 'Bradley Scott Mills', '42039', '3002AC', 999, 0, 999, 1, 0, 0, 1874, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:41', '2133825000', '91505', 'CA', 'BURBANK', '2550 N HOLLYWOOD WAY STE 105', 999, 0, 0, 499.5, 999),
(145, 'F47163', '2023-01-12', 'dbramlette@farmersagent.com', 'Darcee Noel Bramlette', '1228358', '95336X', 999, 0, 999, 1, 0, 0, 1875, NULL, '176-Farmers Store Annual', '2023-02-12 23:11:46', '5307581000', '95616', 'CA', 'DAVIS', '508 2ND ST STE 106', 999, 0, 0, 499.5, 999),
(146, 'F47164', '2023-01-12', 'mlillo@farmersagent.com', 'Mike Lillo', '25974', '71244V', 999, 0, 999, 1, 0, 0, 1877, NULL, '176-Farmers Store Annual', '2023-02-12 23:12:05', '6162812888', '49508', 'MI', 'KENTWOOD', '1714 44TH ST SE', 999, 0, 0, 499.5, 999),
(147, 'F47165', '2023-01-12', 'laucoin@farmersagent.com', 'Luke Jacob Aucoin', '1049997', '97615W', 499, 0, 499, 1, 0, 0, 1878, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:06', '9492738047', '92630', 'CA', 'LAKE FOREST', '21991 EL TORO RD STE 4', 499, 0, 0, 249.5, 499),
(148, 'F47166', '2023-01-12', 'tcarter2@farmersagent.com', 'Tasialiana Carter', '1202158', '1964JL', 499, 0, 499, 1, 0, 0, 1879, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:11', '2812978467', '77084', 'TX', 'HOUSTON', '3880 GREENHOUSE RD STE 213', 499, 0, 0, 499, 499),
(149, 'F47167', '2023-01-12', 'vguzman@farmersagent.com', 'Valentin Guzman', '62255', '880417', 499, 0, 499, 1, 0, 0, 1880, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:13', '9287831000', '85364', 'AZ', 'YUMA', '449 W 20TH PL', 499, 0, 0, 249.5, 499),
(150, 'F47168', '2023-01-12', 'cstover1@farmersagent.com', 'Christina Elaine Stover', '977930', '160601', 899, 0, 899, 1, 0, 0, 1881, NULL, '179-Farmers DM Store Quarterly', '2023-02-12 23:12:15', '5052639317', '87114', 'NM', 'ALBUQUERQUE', '3740 ELLISON RD NW STE 102', 899, 0, 0, 449.5, 899),
(151, 'F47169', '2023-01-12', 'jgutierrez@farmersagent.com', 'Jay Gutierrez', '11959', '194153', 499, 0, 499, 1, 0, 0, 1882, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:16', '3618554000', '78415', 'TX', 'CORPUS CHRISTI', '8401 WEBER RD', 499, 0, 0, 249.5, 499),
(152, 'F47170', '2023-01-12', 'jguffey@farmersagent.com', 'Jeff C Guffey', '1365912', '6602AE', 499, 0, 499, 1, 0, 0, 1883, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:18', '4235215117', '37421', 'TN', 'CHATTANOOGA', '7550 E BRAINERD RD STE 113', 499, 0, 0, 499, 499),
(153, 'F47171', '2023-01-12', 'rwells1@farmersagent.com', 'Ronald Louis Wells', '39390', '95455E', 499, 0, 499, 1, 0, 0, 1884, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:20', '5594381818', '93704', 'CA', 'FRESNO', '5151 N PALM AVE STE 960', 499, 0, 0, 249.5, 499),
(154, 'F47172', '2023-01-12', 'jhill5@farmersagent.com', 'Jason Hill', '1374474', '0875LT', 499, 0, 499, 1, 0, 0, 1885, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:21', '4056539533', '73069', 'OK', 'NORMAN', '6401 N INTERSTATE DR STE 136', 499, 0, 0, 499, 499),
(155, 'F47173', '2023-01-12', 'lmcleod@farmersagent.com', 'Lee Lincoln McLeod', '11230', '1967K1', 499, 0, 499, 1, 0, 0, 1886, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:23', '2813202977', '77379', 'TX', 'SPRING', '16000 STUEBNER AIRLINE RD STE 350', 499, 0, 0, 249.5, 499),
(156, 'F47174', '2023-01-12', 'jbell@farmersagent.com', 'Jennifer Lynn Bell', '1247894', '730701', 2697, 0, 2697, 1, 0, 0, 1887, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:12:24', '5034333911', '97302', 'OR', 'SALEM', '4985 BATTLE CREEK RD SE STE 106', 2697, 0, 0, 1348.5, 2697),
(157, 'F47175', '2023-01-12', 'asharma@farmersagent.com', 'Archana Sharma', '1247555', '9665A1', 999, 0, 999, 1, 0, 0, 1888, NULL, '176-Farmers Store Annual', '2023-02-12 23:12:26', '5108339858', '94583', 'CA', 'SAN RAMON', '2355 SAN RAMON VALLEY BLVD STE 208', 999, 0, 0, 999, 999),
(158, 'F47176', '2023-01-12', 'dmcintosh@farmersagent.com', 'Dawn Marie McIntosh', '1281687', '41191E', 999, 0, 999, 1, 0, 0, 1889, NULL, '176-Farmers Store Annual', '2023-02-12 23:12:28', '3869516462', '32720', 'FL', 'DELAND', '505 S SPG GDN AVE STE 103', 999, 0, 0, 999, 999),
(159, 'F47177', '2023-01-12', 'cwalker1@farmersagent.com', 'Christopher N Walker', '988127', '672401', 2697, 0, 2697, 1, 0, 0, 1890, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:12:30', '7029409738', '89014', 'NV', 'HENDERSON', '375 N STEPHANIE ST STE 1514', 2697, 0, 0, 1348.5, 2697),
(160, 'F47178', '2023-01-12', 'elizabeth.jegly@farmersagency.com', 'Elizabeth Anne Yarbrough', '1197188', '66294L', 999, 0, 999, 1, 0, 0, 1891, NULL, '176-Farmers Store Annual', '2023-02-12 23:12:31', '6152502723', '37211', 'TN', 'NASHVILLE', '176 THOMPSON LN STE 107', 999, 0, 0, 499.5, 999),
(161, 'F47179', '2023-01-12', 'inance@farmersagent.com', 'Iris C Nance', '22517', '68212W', 499, 0, 499, 1, 0, 0, 1892, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:32', '7575784737', '23464', 'VA', 'VIRGINIA BEACH', '6052 PROVIDENCE RD STE 104', 499, 0, 0, 249.5, 499),
(162, 'F47180', '2023-01-12', 'jsmitherman@farmersagent.com', 'James P Smitherman', '11776', '350743', 499, 0, 499, 1, 0, 0, 1893, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:34', '9039889944', '75662', 'TX', 'KILGORE', '740 US HIGHWAY 259 N', 499, 0, 0, 249.5, 499),
(163, 'F47181', '2023-01-12', 'aaram@farmersagent.com', 'Arash Aram', '984596', '29503H', 999, 0, 999, 1, 0, 0, 1894, NULL, '176-Farmers Store Annual', '2023-02-12 23:12:35', '3103626138', '90403', 'CA', 'SANTA MONICA', '2444 WILSHIRE BLVD STE 285', 999, 0, 0, 499.5, 999),
(164, 'F47182', '2023-01-12', 'ghaupt@farmersagent.com', 'Gregory Michael Haupt', '36575', '961201', 2697, 0, 2697, 1, 0, 0, 1895, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:12:37', '4085568888', '95051', 'CA', 'SANTA CLARA', '4675 STEVENS CREEK BLVD STE 245', 2697, 0, 0, 1348.5, 2697),
(165, 'F47183', '2023-01-12', 'rbair@farmersagent.com', 'Roderick Allen Bair', '1208148', '756560', 499, 0, 499, 1, 0, 0, 1896, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:12:38', '2087725947', '83835', 'ID', 'HAYDEN', '8827 N GOVERNMENT WAY UNIT 105', 499, 0, 0, 249.5, 499),
(166, 'F47184', '2023-01-12', 'dmashburn@farmersagent.com', 'Deborah Whaley Mashburn', '1120704', '4419LR', 999, 0, 999, 0, 0, 0, 1897, NULL, '176-Farmers Store Annual', '2023-02-12 23:12:39', '7707279826', '30276', 'GA', 'SENOIA', '10 VLG WEST DR STE F', 999, 0, 0, 0, 999),
(167, 'F47185', '2023-01-12', 'gnees@farmersagent.com', 'Garrett Michael Nees', '1145879', '3590FP', 999, 0, 999, 1, 0, 0, 1898, NULL, '176-Farmers Store Annual', '2023-02-12 23:12:41', '8176258088', '76118', 'TX', 'FORT WORTH', '2977 S PRECINCT LINE RD STE 217', 999, 0, 0, 499.5, 999),
(168, 'F47186', '2023-01-12', 'jharing@farmersagent.com', 'Jennifer Anne Haring', '11785', '350477', 999, 0, 999, 1, 0, 0, 1899, NULL, '176-Farmers Store Annual', '2023-02-12 23:12:43', '8172824666', '76244', 'TX', 'FORT WORTH', '10340 ALTA VISTA RD # 100', 999, 0, 0, 496, 999),
(169, 'F47187', '2023-01-12', 'kbrandyberry@farmersagent.com', 'Kimberly Mashon Brandyberry Jones', '1293999', '358001', 2697, 0, 2697, 1, 0, 0, 1900, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:12:44', '8063502699', '79101', 'TX', 'AMARILLO', '600 S TYLER ST STE 1904', 2697, 0, 0, 1348.5, 2697),
(170, 'F47188', '2023-01-12', 'efera@farmersagent.com', 'Eugene Fera', '1282755', '8833GJ', 999, 0, 999, 1, 0, 0, 1901, NULL, '176-Farmers Store Annual', '2023-02-12 23:13:54', '5205751667', '85741', 'AZ', 'TUCSON', '3275 W INA RD STE 200', 999, 0, 0, 999, 999),
(171, 'F47189', '2023-01-12', 'gmirchandani1@farmersagent.com', 'Gail Ruth Mirchandani', '36668', '96779G', 999, 0, 999, 1, 0, 0, 1902, NULL, '176-Farmers Store Annual', '2023-02-12 23:13:56', '9252441300', '94583', 'CA', 'SAN RAMON', '3150 CROW CANYON PL STE 100', 999, 0, 0, 499.5, 999),
(172, 'F47190', '2023-01-12', 'rdonalson@farmersagent.com', 'Rachel Leigh Donalson', '978447', '19566A', 999, 0, 999, 1, 0, 0, 1903, NULL, '176-Farmers Store Annual', '2023-02-12 23:13:59', '4093862833', '77656', 'TX', 'SILSBEE', '1350B HIGHWAY 327 E', 999, 0, 0, 499.5, 999),
(173, 'F47191', '2023-01-12', 'mbennett1@farmersagent.com', 'Matthew Bennett', '20609', '222501', 2973.44, 0, 2973.44, 1, 0, 0, 1904, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:14:01', '8476969904', '60018', 'IL', 'ROSEMONT', '10275 W HIGGINS RD STE 380', 2697, 0, 276.44, 1486.72, 2973.44),
(174, 'F47192', '2023-01-12', 'aojong@farmersagent.com', 'Ayuk Ojong', '1294652', '9139AT', 999, 0, 999, 1, 0, 0, 1905, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:02', '3015934897', '20901', 'MD', 'SILVER SPRING', '11207A LOCKWOOD DR', 999, 0, 0, 999, 999),
(175, 'F47193', '2023-01-12', 'rhyre@farmersagent.com', 'Ronald E Hyre', '881721', '25301A', 999, 0, 999, 1, 0, 0, 1906, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:03', '3308187599', '44223', 'OH', 'CUYAHOGA FALLS', '1612 PORTAGE TRL', 999, 0, 0, 499.5, 999),
(176, 'F47194', '2023-01-12', 'ataylor@farmersagent.com', 'Ashley Dianne Taylor', '1201686', '08415M', 999, 0, 999, 1, 0, 0, 1907, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:08', '4054009898', '73116', 'OK', 'OKLAHOMA CITY', '6801 BROADWAY EXT STE 316', 999, 0, 0, 499.5, 999),
(177, 'F47195', '2023-01-12', 'havila@farmersagent.com', 'Hilda Yvette Avila', '1078767', '35527G', 999, 0, 999, 1, 0, 0, 1908, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:10', '4693201440', '75244', 'TX', 'DALLAS', '4100 SPRING VALLEY STE 904', 999, 0, 0, 499.5, 999),
(178, 'F47196', '2023-01-12', 'kchau@farmersagent.com', 'Khiet Tan Chau', '1225690', '19473C', 999, 0, 999, 1, 0, 0, 1909, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:12', '2106371178', '78233', 'TX', 'LIVE OAK', '11901 TOEPPERWEIN RD STE 903', 999, 0, 0, 499.5, 999),
(179, 'F47197', '2023-01-12', 'tstuber@farmersagent.com', 'Tim Stuber', '61226', '07178G', 999, 0, 999, 1, 0, 0, 1910, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:14', '3034101060', '80020', 'CO', 'BROOMFIELD', '12995 SHERIDAN BLVD STE 102', 999, 0, 0, 499.5, 999),
(180, 'F47198', '2023-01-12', 'kkeefer@farmersagent.com', 'Kristi R Keefer', '28341', '04038V', 999, 0, 999, 1, 0, 0, 1911, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:15', '7858437511', '66049', 'KS', 'LAWRENCE', '3300 MESA WAY STE C', 999, 0, 0, 847.5, 999),
(181, 'F47199', '2023-01-12', 'lduclos@farmersagent.com', 'Linett Alexandra Duclos', '1258340', '411995', 999, 0, 999, 1, 0, 0, 1912, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:17', '4077237301', '32828', 'FL', 'ORLANDO', '1525 S ALAFAYA TRL STE 101', 999, 0, 0, 999, 999),
(182, 'F47200', '2023-01-12', 'pjohnson@farmersagent.com', 'Pam Johnson', '1174168', '4419MR', 999, 0, 999, 1, 0, 0, 1913, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:19', '4702750777', '30062', 'GA', 'MARIETTA', '3225 SHALLOWFORD RD STE 120', 999, 0, 0, 499.5, 999),
(183, 'F47201', '2023-01-12', 'dbiscocho@farmersagent.com', 'Dennis Aniceto Biscocho', '35605', '968298', 499, 0, 499, 1, 0, 0, 1914, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:14:21', '6508774955', '94080', 'CA', 'SOUTH SAN FRANC', '90 S SPRUCE AVE STE L', 499, 0, 0, 249.5, 499),
(184, 'F47202', '2023-01-12', 'rlehr1@farmersagent.com', 'Robert P Lehr', '1045221', '353701', 2697, 0, 2697, 1, 0, 0, 1915, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:14:23', '5123820858', '78759', 'TX', 'AUSTIN', '11940 JOLLYVILLE RD STE 330S', 2697, 0, 0, 1348.5, 2697),
(185, 'F47203', '2023-01-12', 'kjohnson3@farmersagent.com', 'Kenneth Lashawn Johnson', '69756', '3529FP', 999, 0, 999, 1, 0, 0, 1916, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:24', '9722598534', '75061', 'TX', 'IRVING', '133 N MACARTHUR BLVD', 999, 0, 0, 999, 999),
(186, 'F47204', '2023-01-12', 'rherzog@farmersagent.com', 'Robert Charles Herzog', '33733', '96984H', 999, 0, 999, 1, 0, 0, 1917, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:25', '9257340530', '94566', 'CA', 'PLEASANTON', '235 MAIN ST', 999, 0, 0, 499.5, 999),
(187, 'F47205', '2023-01-12', 'mvenne@farmersagent.com', 'Michael A Venne', '1002479', '996801', 2697, 0, 2697, 1, 0, 0, 1918, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:14:27', '7607663866', '92211', 'CA', 'PALM DESERT', '74836 TECHNOLOGY DR STE 104', 2697, 0, 0, 1348.5, 2697),
(188, 'F47206', '2023-01-12', 'nhansel@farmersagent.com', 'Nicholas Troy Hansel', '105676', '130201', 2697, 0, 2697, 1, 0, 0, 1919, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:14:29', '6513832899', '55125', 'MN', 'WOODBURY', '700 COMMERCE DR STE 140', 2697, 0, 0, 1348.5, 2697),
(189, 'F47207', '2023-01-12', 'aholder@farmersagent.com', 'Alexandra Holder', '1063222', '08601G', 999, 0, 999, 1, 0, 0, 1920, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:30', '9184949795', '74104', 'OK', 'TULSA', '1449 S FLORENCE AVE', 999, 0, 0, 499.5, 999),
(190, 'F47208', '2023-01-12', 'aviles@farmersagent.com', 'Amanda Erin Viles', '1267368', '08604C', 999, 0, 999, 1, 0, 0, 1921, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:32', '9188059873', '74120', 'OK', 'TULSA', '815 E 3RD ST STE A', 999, 0, 0, 999, 999),
(191, 'F47209', '2023-01-12', 'bveach@farmersagent.com', 'Brett A Veach', '1082627', '88476G', 999, 0, 999, 1, 0, 0, 1922, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:34', '4804428260', '85259', 'AZ', 'SCOTTSDALE', '10855 N 116TH ST STE 135', 999, 0, 0, 499.5, 999),
(192, 'F47210', '2023-01-12', 'jlewis5@farmersagent.com', 'Jason Aaron Lewis', '1267200', '08497X', 999, 0, 999, 1, 0, 0, 1923, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:35', '4056971967', '73044', 'OK', 'GUTHRIE', '124 W OKLAHOMA AVE', 999, 0, 0, 858.5, 999),
(193, 'F47211', '2023-01-12', 'mvaswani@farmersagent.com', 'Mahendar Vaswani', '874503', '304495', 999, 0, 999, 1, 0, 0, 1924, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:37', '3109541514', '90034', 'CA', 'LOS ANGELES', '9854 NATIONAL BLVD # 567', 999, 0, 0, 499.5, 999),
(194, 'F47212', '2023-01-12', 'nchen@farmersagent.com', 'Natalie Xiong Chen', '1157896', '97187V', 999, 0, 999, 1, 0, 0, 1925, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:39', '7143886021', '92870', 'CA', 'PLACENTIA', '1150 E ORANGETHORPE AVE STE 102', 999, 0, 0, 999, 999),
(195, 'F47213', '2023-01-12', 'michael.rhuschen@farmersagency.com', 'Michael Hucal', '1326836', '223001', 2879.05, 0, 2879.05, 1, 0, 0, 1926, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:14:41', '3092630099', '61550', 'IL', 'MORTON', '104 E QUEENWOOD RD', 2697, 0, 182.05, 1439.53, 2879.05),
(196, 'F47214', '2023-01-12', 'csauders@farmersagent.com', 'Christopher Sauders', '1264438', '4419XG', 999, 0, 999, 1, 0, 0, 1927, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:42', '9123482233', '31322', 'GA', 'POOLER', '138 CANAL ST STE 408', 999, 0, 0, 999, 999),
(197, 'F47215', '2023-01-12', 'rnelson4@farmersagent.com', 'Robert Nelson', '13126', '35034J', 999, 0, 999, 1, 0, 0, 1928, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:44', '8177011462', '76017', 'TX', 'ARLINGTON', '2340 W INTERSTATE 20 STE 202', 999, 0, 0, 499.5, 999),
(198, 'F47216', '2023-01-12', 'kcarpenter@farmersagent.com', 'Kriss Carpenter', '32104', '756501', 2697, 0, 2697, 1, 0, 0, 1929, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:14:46', '2086515220', '83804', 'ID', 'BLANCHARD', 'PO BOX 545', 2697, 0, 0, 1348.5, 2697),
(199, 'F47217', '2023-01-12', 'ylong@farmersagent.com', 'Yale William Long', '37770', '993001', 899, 0, 899, 1, 0, 0, 1930, NULL, '179-Farmers DM Store Quarterly', '2023-02-12 23:14:47', '9092540318', '92507', 'CA', 'RIVERSIDE', '1700 IOWA AVE STE 230', 899, 0, 0, 449.5, 899),
(200, 'F47218', '2023-01-12', 'abooth@farmersagent.com', 'Andrea M Booth', '1301797', '22307R', 1066.44, 0, 1066.44, 1, 0, 0, 1931, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:48', '3099815350', '61554', 'IL', 'MARQUETTE HTS', '150 JOLIET RD STE A', 999, 0, 67.44, 1025.74, 1066.44),
(201, 'F47219', '2023-01-12', 'kjames2@farmersagent.com', 'Kelli J James', '1221616', '08456E', 999, 0, 999, 1, 0, 0, 1932, NULL, '176-Farmers Store Annual', '2023-02-12 23:14:50', '4055852944', '74802', 'OK', 'SHAWNEE', 'PO BOX 516', 999, 0, 0, 499.5, 999),
(202, 'F47220', '2023-01-12', 'mkobaissi@farmersagent.com', 'Mike Kobaissi', '742611', '300202', 999, 0, 999, 1, 0, 0, 1933, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:05', '8182876338', '91506', 'CA', 'BURBANK', '1312 W BURBANK BLVD # A', 999, 0, 0, 499.5, 999),
(203, 'F47221', '2023-01-12', 'mrodriguez5@farmersagent.com', 'Maria Del Carmen Rodriguez', '782814', '994812', 999, 0, 999, 1, 0, 0, 1934, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:07', '9095741451', '92335', 'CA', 'FONTANA', '16235 FOOTHILL BLVD', 999, 0, 0, 499.5, 999),
(204, 'F47222', '2023-01-12', 'pcacho@farmersagent.com', 'Sebastian Cacho', '1122034', '3590FA', 999, 0, 999, 1, 0, 0, 1935, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:09', '4695571800', '75006', 'TX', 'CARROLLTON', '2833 TRINITY SQ DR STE 135', 999, 0, 0, 499.5, 999),
(205, 'F47223', '2023-01-12', 'pgariepy@farmersagent.com', 'Patrick Glavin Gariepy', '1315366', '41192X', 999, 0, 999, 1, 0, 0, 1936, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:12', '8134028141', '33568', 'FL', 'RIVERVIEW', 'PO BOX 916', 999, 0, 0, 999, 999),
(206, 'F47224', '2023-01-12', 'smooney@farmersagent.com', 'Stephen A Mooney', '1041186', '06093N', 999, 0, 999, 1, 0, 0, 1937, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:13', '2157818500', '19007', 'PA', 'BRISTOL', '10 CANAL ST STE 236', 999, 0, 0, 499.5, 999),
(207, 'F47225', '2023-01-12', 'dfraser2@farmersagent.com', 'Daniel Adam Fraser', '98844', '951701', 2697, 0, 2697, 1, 0, 0, 1938, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:16:15', '7074744477', '95688', 'CA', 'VACAVILLE', '555 MASON ST STE 120', 2697, 0, 0, 1348.5, 2697),
(208, 'F47226', '2023-01-12', 'eperez2@farmersagent.com', 'Elizabeth Perez', '1082896', '35792E', 999, 0, 999, 1, 0, 0, 1939, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:17', '9152194897', '79907', 'TX', 'EL PASO', '1237 LOMALAND DR STE F', 999, 0, 0, 499.5, 999),
(209, 'F47227', '2023-01-12', 'esapir@farmersagent.com', 'Philip Eric Sapir', '17145', '07254L', 999, 0, 999, 1, 0, 0, 1940, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:19', '3037793632', '80127', 'CO', 'LITTLETON', '8341 SANGRE DE CRISTO RD STE 109', 999, 0, 0, 499.5, 999),
(210, 'F47228', '2023-01-12', 'mgoldie@farmersagent.com', 'Marc Goldie', '1347103', '2225MG', 1098.9, 0, 1098.9, 1, 0, 0, 1941, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:21', '8474879003', '60090', 'IL', 'WHEELING', '18 SCHOENBECK RD STE 204', 999, 0, 99.9, 1049.45, 1098.9),
(211, 'F47229', '2023-01-12', 'owingood@farmersagent.com', 'Olga Vitalia Wingood', '40851', '976116', 999, 0, 999, 1, 0, 0, 1942, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:22', '7149639703', '92647', 'CA', 'HUNTINGTON BEAC', '8907 WARNER AVE STE 168', 999, 0, 0, 499.5, 999),
(212, 'F47230', '2023-01-12', 'lcarroll1@farmersagent.com', 'Lance Carroll', '17123', '753301', 2697, 0, 2697, 1, 0, 0, 1943, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:16:24', '2089556844', '83706', 'ID', 'BOISE', '250 W BOBWHITE CT STE 350', 2697, 0, 0, 1348.5, 2697),
(213, 'F47231', '2023-01-12', 'nholmes@farmersagent.com', 'Nicholas Holmes', '1080403', '072001', 2697, 0, 2697, 1, 0, 0, 1944, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:16:26', '7204465410', '80226', 'CO', 'LAKEWOOD', '550 S WADSWORTH BLVD UNIT 575', 2697, 0, 0, 1348.5, 2697),
(214, 'F47232', '2023-01-12', 'pgonzalez1@farmersagent.com', 'Pedro Gonzalez', '1287253', '968601', 2697, 0, 2697, 1, 0, 0, 1945, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:16:27', '8312160031', '95060', 'CA', 'SANTA CRUZ', '1521 1/2 PACIFIC AVE', 2697, 0, 0, 1348.5, 2697),
(215, 'F47233', '2023-01-12', 'ccopas@farmersagent.com', 'Clint Jack Copas', '814943', '97463C', 999, 0, 999, 1, 0, 0, 1946, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:29', '9512510903', '92860', 'CA', 'NORCO', '1640 2ND ST STE 101', 999, 0, 0, 499.5, 999),
(216, 'F47234', '2023-01-12', 'landelson@farmersagent.com', 'Lori Llena Andelson Freilich', '731049', '305627', 999, 0, 999, 1, 0, 0, 1947, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:30', '8186164209', '91343', 'CA', 'NORTHRIDGE', '16909 PARTHENIA ST STE 303', 999, 0, 0, 499.5, 999),
(217, 'F47235', '2023-01-12', 'pfinder@farmersagent.com', 'Phillip Louis Finder', '93533', '353743', 999, 0, 999, 1, 0, 0, 1948, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:32', '5122607330', '78641', 'TX', 'LEANDER', '2501 S BAGDAD RD STE A', 999, 0, 0, 499.5, 999),
(218, 'F47236', '2023-01-12', 'rgarris@farmersagent.com', 'Robert Earl Garris', '1358053', '441818', 999, 0, 999, 1, 0, 0, 1949, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:33', '7705590116', '30062', 'GA', 'MARIETTA', '4343 SHALLOWFORD RD STE 540', 999, 0, 0, 999, 999),
(219, 'F47237', '2023-01-12', 'jwebster@farmersagent.com', 'Jodi Elizabeth Webster', '37912', '967201', 2697, 0, 2697, 1, 0, 0, 1950, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:16:35', '9255832080', '94551', 'CA', 'LIVERMORE', '2600 KITTY HAWK RD STE 109', 2697, 0, 0, 1348.5, 2697),
(220, 'F47238', '2023-01-12', 'dstrickland@farmersagent.com', 'Derick Montrele Strickland', '1277292', '1964HG', 999, 0, 999, 1, 0, 0, 1951, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:37', '8328439899', '77007', 'TX', 'HOUSTON', '5225 KATY FWY # 505A', 999, 0, 0, 999, 999),
(221, 'F47239', '2023-01-12', 'jpradel@farmersagent.com', 'Justin Pradel', '804109', '060932', 999, 0, 999, 1, 0, 0, 1952, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:39', '4843620900', '19010', 'PA', 'BRYN MAWR', '831 CONESTOGA RD', 999, 0, 0, 499.5, 999),
(222, 'F47240', '2023-01-12', 'nmorales1@farmersagent.com', 'Nestor Morales', '1206410', '47196V', 999, 0, 999, 1, 0, 0, 1953, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:41', '5168819099', '11570', 'NY', 'ROCKVILLE CENTR', '268 MERRICK RD', 999, 0, 0, 499.5, 999),
(223, 'F47241', '2023-01-12', 'pjones6@farmersagent.com', 'Pamela E Byng-Jones', '1308731', '441822', 999, 0, 999, 1, 0, 0, 1954, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:42', '7708818180', '30004', 'GA', 'ALPHARETTA', '5925 ATLANTA HWY STE 200', 999, 0, 0, 999, 999),
(224, 'F47242', '2023-01-12', 'smorrow1@farmersagent.com', 'Stephen Andrew Morrow', '787568', '084113', 999, 0, 999, 1, 0, 0, 1955, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:43', '4056081160', '73116', 'OK', 'OKC', '6801 BROADWAY EXT STE 112', 999, 0, 0, 499.5, 999),
(225, 'F47243', '2023-01-12', 'ydouglas@farmersagent.com', 'Young LaMonte Douglas', '1287569', '9740CA', 999, 0, 999, 1, 0, 0, 1956, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:44', '9093033722', '91764', 'CA', 'ONTARIO', '3602 INLAND EMPIRE BLVD # C330', 999, 0, 0, 999, 999),
(226, 'F47244', '2023-01-12', 'amann1@farmersagent.com', 'Anthony Ray Mann', '1347072', '441806', 999, 0, 999, 1, 0, 0, 1957, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:49', '7704028095', '30046', 'GA', 'LAWRENCEVILLE', '760 LONGLEAF BLVD STE D', 999, 0, 0, 999, 999),
(227, 'F47245', '2023-01-12', 'kkirwan@farmersagent.com', 'Kevin J Kirwan', '20723', '222381', 1068.93, 0, 1068.93, 1, 0, 0, 1958, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:50', '8475265020', '60084', 'IL', 'WAUCONDA', '316 S MAIN ST', 999, 0, 69.93, 534.47, 1068.93),
(228, 'F47246', '2023-01-12', 'lagosta@farmersagent.com', 'Leonard Anthony Agosta', '1143917', '99367P', 999, 0, 999, 1, 0, 0, 1959, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:52', '6195838500', '92120', 'CA', 'SAN DIEGO', '7569 MISSION GORGE RD', 999, 0, 0, 499.5, 999),
(229, 'F47247', '2023-01-12', 'mlantz@farmersagent.com', 'Melissa Beth Lantz', '984994', '47296P', 999, 0, 999, 1, 0, 0, 1960, NULL, '176-Farmers Store Annual', '2023-02-12 23:16:54', '6077232386', '13850', 'NY', 'VESTAL', '3321 VESTAL PKWY E', 999, 0, 0, 499.5, 999),
(230, 'F47248', '2023-01-12', 'laura.bratkovich@farmersagency.com', 'Laura Laine Mountain', '1021397', '880601', 2697, 0, 2697, 1, 0, 0, 1961, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:16:56', '4809988181', '85053', 'AZ', 'PHOENIX', '16001 N 28TH AVE', 2697, 0, 0, 1348.5, 2697),
(231, 'F47249', '2023-01-12', 'nfox1@farmersagent.com', 'Nathan Troydon Fox', '1327627', '08467V', 499, 0, 499, 1, 0, 0, 1962, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:25', '9188405273', '74401', 'OK', 'MUSKOGEE', '319 COURT ST', 499, 0, 0, 499, 499),
(232, 'F47250', '2023-01-12', 'ymedina@farmersagent.com', 'Yanira Medina-Velasquez', '970760', '30072E', 499, 0, 499, 1, 0, 0, 1963, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:26', '6614022700', '93550', 'CA', 'PALMDALE', '2501 E PALMDALE BLVD STE B', 499, 0, 0, 249.5, 499),
(233, 'F47251', '2023-01-12', 'smacdonald@farmersagent.com', 'Sandra Sue MacDonald', '18823', '304497', 499, 0, 499, 1, 0, 0, 1964, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:28', '8189061042', '91316', 'CA', 'ENCINO', '17141 VENTURA BLVD STE 202', 499, 0, 0, 249.5, 499),
(234, 'F47252', '2023-01-12', 'jgutierrez4@farmersagent.com', 'Jose M Gutierrez', '89521', '0420C4', 499, 0, 499, 1, 0, 0, 1965, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:30', '3165227757', '67217', 'KS', 'WICHITA', '1307 W 31ST ST S', 499, 0, 0, 499, 499),
(235, 'F47253', '2023-01-12', 'aduquette@farmersagent.com', 'Alexander L Duquette', '49968', '883301', 899, 0, 899, 1, 0, 0, 1966, NULL, '179-Farmers DM Store Quarterly', '2023-02-12 23:19:32', '5207710670', '85712', 'AZ', 'TUCSON', '2959 N SWAN RD STE 101', 899, 0, 0, 449.5, 899),
(236, 'F47254', '2023-01-12', 'rcraycraft@farmersagent.com', 'Rebecca Lynn Craycraft', '1230546', '35773T', 499, 0, 499, 1, 0, 0, 1967, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:34', '8067939766', '79424', 'TX', 'LUBBOCK', '4411 71ST ST', 499, 0, 0, 249.5, 499),
(237, 'F47255', '2023-01-12', 'pguerrero@farmersagent.com', 'Pamela Guerrero', '967641', '19603T', 499, 0, 499, 1, 0, 0, 1968, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:36', '2817249864', '77573', 'TX', 'LEAGUE CITY', '319 E GALVESTON ST STE B', 499, 0, 0, 249.5, 499),
(238, 'F47256', '2023-01-12', 'amaci@farmersagent.com', 'Arand Maci', '1394469', '7115JR', 499, 0, 499, 1, 0, 0, 1969, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:37', '5862074500', '48094', 'MI', 'WASHINGTON', '58047 VAN DYKE RD', 499, 0, 0, 499, 499),
(239, 'F47257', '2023-01-12', 'rsampson@farmersagent.com', 'Richard W Sampson', '32240', '79095G', 499, 0, 499, 1, 0, 0, 1970, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:39', '3609435742', '98501', 'WA', 'TUMWATER', '207 WEST LEE ST', 499, 0, 0, 249.5, 499),
(240, 'F47258', '2023-01-12', 'mwilusz@farmersagent.com', 'Michael T Wilusz', '1293489', '71409P', 499, 0, 499, 1, 0, 0, 1971, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:41', '5866844935', '48307', 'MI', 'ROCHESTER HILLS', '1070 E AVON RD', 499, 0, 0, 499, 499),
(241, 'F47259', '2023-01-12', 'belms@farmersagent.com', 'Blake Monroe Elms', '1264987', '35089G', 499, 0, 499, 1, 0, 0, 1972, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:43', '8174150909', '76009', 'TX', 'ALVARADO', 'PO BOX 365', 499, 0, 0, 499, 499),
(242, 'F47260', '2023-01-12', 'hnguyen4@farmersagent.com', 'Hai Minh Nguyen', '1126907', '4419HA', 499, 0, 499, 0, 0, 0, 1973, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:45', '4703592122', '30071', 'GA', 'NORCROSS', '2764 LANGFORD RD STE 101', 499, 0, 0, 0, 499),
(243, 'F47261', '2023-01-12', 'swilson@farmersagent.com', 'Sheri Ann Wilson', '1069390', '35208R', 499, 0, 499, 1, 0, 0, 1974, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:46', '4699987494', '75072', 'TX', 'MCKINNEY', '1402 S CUSTER RD STE 802', 499, 0, 0, 249.5, 499),
(244, 'F47262', '2023-01-12', 'amallari@farmersagent.com', 'Audrey Mae Maglonzo Mallari', '1158215', '97188L', 499, 0, 499, 1, 0, 0, 1975, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:48', '9497539557', '92653', 'CA', 'LAGUNA HILLS', '23151 VERDUGO DR STE 105', 499, 0, 0, 499, 499),
(245, 'F54606', '2023-01-23', 'cfisher3@farmersagent.com', 'Cornelius Jermaine Fisher', '725219', '4419RH', 1158.91, 0, 1158.91, 1, 0, 0, 3256, NULL, '176-Farmers Store Annual', '2023-02-12 23:19:49', '4043826388', '30040', 'GA', 'CUMMING', '110 SAMARITAN DR STE 204', 999, 0, 0, 499.5, 0),
(246, 'F58982', '2023-01-25', 'mminor@farmersagent.com', 'Mike H Minor', '22391', '500504', 499, 0, 499, 1, 0, 0, 3264, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:19:50', '3342911923', '36877', 'AL', 'SMITHS STA', 'PO BOX 951', 499, 0, 0, 249.5, 0),
(247, 'F60625', '2023-01-26', 'bmckinney2@farmersagent.com', 'Bradley McKinney', '723340', '081006', 999, 999, 0, 0, 0, 0, 3283, NULL, '176-Farmers Store Annual', '2023-02-12 23:19:52', '9189944477', '74145', 'OK', 'TULSA', '8301 E 51ST ST STE 100', 999, 0, 0, 0, 0),
(248, 'F62405', '2023-01-26', 'aeefting@farmersagent.com', 'Alexa Dawn Eefting', '1295835', '3590KC', 999, 0, 999, 1, 0, 0, 3287, NULL, '176-Farmers Store Annual', '2023-02-12 23:19:53', '8176173000', '76013', 'TX', 'DALWORTHNGTON G', '2214 MICHIGAN AVE E', 999, 0, 0, 999, 0),
(249, 'F62410', '2023-01-26', 'pgunter@farmersagent.com', 'Phillip W Gunter', '138290', '35952W', 999, 499.5, 499.5, 1, 0, 0, 3288, NULL, '176-Farmers Store Annual', '2023-02-12 23:19:55', '5125654446', '78664', 'TX', 'ROUND ROCK', '2201 DOUBLE CREEK DR STE 2004', 999, 0, 0, 499.5, 0),
(250, 'F62899', '2023-01-27', 'mwoodbury@farmersagent.com', 'Matthew David Woodbury', '1177569', '7115HE', 999, 0, 999, 1, 0, 0, 3291, NULL, '176-Farmers Store Annual', '2023-02-12 23:19:56', '7345259450', '48150', 'MI', 'LIVONIA', '39293 PLYMOUTH RD STE 105', 999, 0, 0, 999, 0),
(251, 'F65370', '2023-01-28', 'ealvarez@farmersagent.com', 'Esmeralda Guadalupe Alvarez', '95928', '300752', 999, 0, 999, 0, 0, 0, 3824, NULL, '176-Farmers Store Annual', '2023-02-12 23:19:58', '6615389026', '93550', 'CA', 'PALMDALE', '801 E PALMDALE BLVD', 999, 0, 0, 0, 0),
(252, 'F65576', '2023-01-28', 'afischer3@farmersagent.com', 'Anthony Bernard Fischer', '1420479', '7115JV', 999, 0, 999, 0, 0, 0, 3829, NULL, '176-Farmers Store Annual', '2023-02-12 23:19:59', '7348384832', '48161', 'MI', 'MONROE', '8 E FRONT ST', 999, 0, 0, 0, 0),
(253, 'F71980', '2023-01-31', 'adavis6@farmersagent.com', 'Andrew Tod Davis', '1326025', '0875KN', 499, 0, 499, 1, 0, 0, 4326, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:20:01', '4053107881', '73012', 'OK', 'EDMOND', '18001 N WESTERN AVE STE 101', 499, 0, 0, 499, 0),
(254, 'F78832', '2023-02-01', 'bpietzsch@farmersagent.com', 'Bradley A Pietzsch', '1243151', '1115AM', 999, 0, 999, 1, 0, 0, 4550, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:03', '5159642042', '50023', 'IA', 'ANKENY', '1810 SW WHITE BIRCH CIR STE 114', 999, 0, 0, 999, 0);
INSERT INTO `agpapi_orders` (`id`, `vendor_order_id`, `order_date`, `agent_email`, `agent_name`, `agent_upn`, `agent_aor`, `grand_total`, `amt_paid_by_credit`, `amt_paid_by_folio`, `apply_cost_share`, `amt_refunded_to_credit`, `amt_refunded_to_folio`, `subscription_id`, `cancelled_date`, `sku`, `created_at`, `phone_no`, `zip`, `state_code`, `city`, `address`, `cost`, `fee`, `tax`, `cost_share_total`, `folio_total`) VALUES
(255, 'F79919', '2023-02-01', 'jramirez1@farmersagent.com', 'Joe Ramirez', '14302', '196581', 999, 499.5, 499.5, 1, 0, 0, 4554, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:05', '2813556283', '77373', 'TX', 'SPRING', '23315 ALDINE WESTFIELD RD STE B', 999, 0, 0, 499.5, 0),
(256, 'F88299', '2023-02-02', 'dwilliams4@farmersagent.com', 'David Clarence Williams', '884793', '161387', 999, 0, 999, 1, 0, 0, 4564, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:06', '5059036286', '87124', 'NM', 'RIO RANCHO', '661 QUANTUM RD NE STE 7', 999, 0, 0, 499.5, 0),
(257, 'F88346', '2023-02-02', 'ccastanza@farmersagent.com', 'Chris Castanza', '1043010', '14383T', 499, 249.5, 249.5, 1, 0, 0, 4565, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:20:07', '9137177340', '64012', 'MO', 'BELTON', '139 CHERRY HILL DR', 499, 0, 0, 249.5, 0),
(258, 'F89346', '2023-02-02', 'bwhinery@farmersagent.com', 'Brandon Whinery', '730219', '080558', 999, 0, 999, 1, 0, 0, 4569, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:09', '9184380600', '74146', 'OK', 'TULSA', '4717 S MINGO RD STE A', 999, 0, 0, 499.5, 0),
(259, 'F89483', '2023-02-02', 'npitterle@farmersagent.com', 'Nicholas C Pitterle', '122778', '34023A', 999, 999, 0, 0, 0, 0, 4571, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:11', '2622933765', '53051', 'WI', 'MENOMONEE FALLS', 'N88W15125 MAIN ST STE 102', 999, 0, 0, 0, 0),
(260, 'F89556', '2023-02-02', 'bkennedy@farmersagent.com', 'Brian D Kennedy', '15970', '08456W', 999, 0, 999, 0, 0, 0, 4572, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:12', '9183365544', '74003', 'OK', 'BARTLESVILLE', 'PO DRAWER S', 999, 0, 0, 0, 0),
(261, 'F89580', '2023-02-02', 'jblanz@farmersagent.com', 'Jason John Blanz', '1267224', '99367K', 999, 0, 999, 1, 0, 0, 4573, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:13', '6194702613', '91902', 'CA', 'BONITA', '5120 ROBINWOOD RD STE B22', 999, 0, 0, 999, 0),
(262, 'F89908', '2023-02-03', 'dbrist@farmersagent.com', 'Damon Brist', '1239059', '411963', 999, 0, 999, 1, 0, 0, 4577, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:15', '2392022933', '33966', 'FL', 'FORT MYERS', '9861 BERNWOOD PLACE DR STE 165', 999, 0, 0, 499.5, 0),
(263, 'F93649', '2023-02-03', 'mporter@farmersagent.com', 'Mark Porter', '1236846', '12215L', 499, 0, 499, 1, 0, 0, 4579, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:20:16', '3083828787', '68803', 'NE', 'GRAND ISLAND', '1004 N DIERS AVE STE 206', 499, 0, 0, 249.5, 0),
(264, 'F95284', '2023-02-04', 'rrojas1@farmersagent.com', 'Rodolfo Rojas', '1092701', '4419A3', 999, 0, 999, 1, 0, 0, 4582, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:18', '6782392522', '30080', 'GA', 'SMYRNA', '300 VILLAGE GREEN CIR SE STE 106', 999, 0, 0, 499.5, 0),
(265, 'F97740', '2023-02-06', 'njordan@farmersagent.com', 'Nicholas Jordan', '1428719', '134401', 2697, 1348.5, 1348.5, 1, 0, 0, 4588, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:20:19', '3202417394', '55439', 'MN', 'EDINA', '8000 W 78TH ST STE 170', 2697, 0, 0, 1348.5, 0),
(266, 'F97776', '2023-02-06', 'nsparrow2@farmersagent.com', 'Nathan Sparrow', '869486', '228001', 2881.74, 0, 2881.74, 1, 0, 0, 4589, NULL, '178-Farmers DM Store Annual', '2023-02-12 23:20:20', '2172572209', '62062', 'IL', 'MARYVILLE', '2118B VADALABENE DR', 2697, 0, 184.74, 1440.87, 0),
(267, 'F98862', '2023-02-06', 'aberman@farmersagent.com', 'Ari Charles Berman', '39752', '306142', 999, 499.5, 499.5, 1, 0, 0, 4592, NULL, '176-Farmers Store Annual', '2023-02-12 23:20:22', '8054847470', '93010', 'CA', 'CAMARILLO', '333 N LANTANA ST STE 102', 999, 0, 0, 499.5, 0),
(268, 'F103696', '2023-02-07', 'rgarcia@farmersagent.com', 'Robert Ordunez Garcia', '1207420', '3551A4', 999, 0, 999, 1, 0, 0, 5424, NULL, '176-Farmers Store Annual', '2023-02-12 23:22:09', '9726451844', '75002', 'TX', 'LUCAS', '571 S ANGEL PKWY STE 100', 999, 0, 0, 499.5, 0),
(269, 'F108878', '2023-02-07', 'alind@farmersagent.com', 'Alma Delia Lind', '1274053', '1960CE', 999, 499.5, 499.5, 1, 0, 0, 5969, NULL, '176-Farmers Store Annual', '2023-02-12 23:22:10', '8327568550', '77055', 'TX', 'HOUSTON', '7522 SHADYVILLA LN', 999, 0, 0, 499.5, 0),
(270, 'F109260', '2023-02-07', 'sho1@farmersagent.com', 'Sebastian Ho', '1078527', '29215W', 999, 499.5, 499.5, 1, 0, 0, 6031, NULL, '176-Farmers Store Annual', '2023-02-12 23:22:12', '8338883088', '91789', 'CA', 'WALNUT', '680 BREA CYN RD STE 100', 999, 0, 0, 499.5, 0),
(271, 'F112255', '2023-02-08', 'djensen1@farmersagent.com', 'DJ Jensen', '963044', '441968', 999, 0, 999, 1, 0, 0, 6040, NULL, '176-Farmers Store Annual', '2023-02-12 23:22:14', '6785408676', '30141', 'GA', 'HIRAM', '488 HIRAM DOUGLASVILLE HWY', 999, 0, 0, 499.5, 0),
(272, 'F121093', '2023-02-10', 'tnaylor@farmersagent.com', 'Tanner Jeffery Naylor', '1161395', '76069A', 499, 0, 499, 1, 0, 0, 6059, NULL, '177-Farmers Store Quarterly', '2023-02-12 23:22:16', '8014478742', '84025', 'UT', 'FARMINGTON', '352 S 200 W STE 4', 499, 0, 0, 249.5, 0),
(273, 'F131931', '2023-02-13', 'ktodd@farmersagent.com', 'Kari Louise Todd', '1182368', '29097K', 999, 499.5, 499.5, 1, 0, 0, 6072, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:33', '9096281500', '91710', 'CA', 'CHINO', '3811 SCHAEFER AVE STE I', 999, 0, 0, 499.5, 0),
(274, 'F156949', '2023-02-15', 'jbinyon@farmersagent.com', 'Jason Lane Binyon', '1317031', '3553F5', 999, 0, 999, 1, 0, 0, 6080, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:35', '4692020123', '75035', 'TX', 'FRISCO', '9300 JOHN HICKMAN PKWY STE 404', 999, 0, 0, 637.43, 0),
(275, 'F159341', '2023-02-15', 'erayas@farmersagent.com', 'Elizabeth Correa', '138465', '357928', 999, 499.5, 499.5, 1, 0, 0, 6082, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:38', '9155005140', '79928', 'TX', 'HORIZON CITY', '14200 ASHFORD ST STE A1', 999, 0, 0, 499.5, 0),
(276, 'F181554', '2023-02-16', 'rscholz@farmersagent.com', 'Ryan F Scholz', '137444', '731501', 899, 449.5, 449.5, 1, 0, 0, 6094, NULL, '179-Farmers DM Store Quarterly', '2023-02-20 03:43:41', '5414349720', '97401', 'OR', 'EUGENE', '1400 EXECUTIVE PKWY STE 250', 899, 0, 0, 449.5, 0),
(277, 'F191145', '2023-02-17', 'jjones10@farmersagent.com', 'John Alton Jones', '969659', '441946', 999, 499.5, 499.5, 1, 0, 0, 6099, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:43', '9122642232', '31520', 'GA', 'BRUNSWICK', '4420 ALTAMA AVE STE 52', 999, 0, 0, 499.5, 0),
(278, 'F192441', '2023-02-17', 'dmoris@farmersagent.com', 'Daniel H Moris', '1398939', '490207', 999, 0, 999, 1, 0, 0, 6108, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:44', '6032613444', '03054', 'NH', 'MERRIMACK', '2 CROSSWOODS PATH BLVD STE A', 999, 0, 0, 862, 0),
(279, 'F192745', '2023-02-17', 'kford2@farmersagent.com', 'Kristen Ford', '1326295', '0609XX', 999, 0, 999, 1, 0, 0, 6109, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:47', '7173664154', '17022', 'PA', 'ELIZABETHTOWN', '106 N MARKET ST STE 101', 999, 0, 0, 807.75, 0),
(280, 'F193340', '2023-02-17', 'estrollo@farmersagent.com', 'Eric Lee Strollo', '1380259', '7140AP', 999, 0, 999, 1, 0, 0, 6110, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:49', '5178580135', '48895', 'MI', 'WILLIAMSTON', '425 W GRAND RIVER AVE', 999, 0, 0, 584.45, 0),
(281, 'F193946', '2023-02-17', 'aflowers1@farmersagent.com', 'Andrea Lynn Flowers', '1410339', '450208', 999, 41.25, 957.75, 1, 0, 0, 6112, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:50', '6013911975', '39301', 'MS', 'MERIDIAN', '2011 35TH AVE', 999, 0, 0, 957.75, 0),
(282, 'F194130', '2023-02-17', 'pbranyon@farmersagent.com', 'Patt Branyon', '22618', '500621', 499, 0, 499, 1, 0, 0, 6113, NULL, '177-Farmers Store Quarterly', '2023-02-20 03:43:52', '2516335800', '36695', 'AL', 'MOBILE', '1024 HILLCREST RD', 499, 0, 0, 249.5, 0),
(283, 'F195754', '2023-02-17', 'bhawkins@farmersagent.com', 'Blair C Hawkins', '1318407', '66027T', 999, 0, 999, 1, 0, 0, 6116, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:53', '9016795518', '38017', 'TN', 'COLLIERVILLE', '155 N MAIN ST STE 101C', 999, 0, 0, 652.23, 0),
(284, 'F196070', '2023-02-17', 'rosborne@farmersagent.com', 'Ronald H Osborne', '31948', '79106E', 999, 0, 999, 1, 0, 0, 6117, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:54', '4252919176', '98032', 'WA', 'KENT', '8009 S 180TH ST STE 102', 999, 0, 0, 499.5, 0),
(285, 'F205198', '2023-02-18', 'athobhani@farmersagent.com', 'Ashraf A Thobhani', '1426040', '44181C', 999, 0, 999, 1, 0, 0, 6119, NULL, '176-Farmers Store Annual', '2023-02-20 03:43:56', '7708070298', '30039', 'GA', 'SNELLVILLE', '3416 CENTERVILLE HWY STE E', 999, 0, 0, 957.75, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `agpapi_orders`
--
ALTER TABLE `agpapi_orders`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `agpapi_orders`
--
ALTER TABLE `agpapi_orders`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=286;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
