-
Notifications
You must be signed in to change notification settings - Fork 15
/
prod_rz_slim.sql
1126 lines (1079 loc) · 165 KB
/
prod_rz_slim.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 09, 2016 at 10:28 AM
-- Server version: 5.5.45-cll-lve
-- PHP Version: 5.4.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
--
-- Database: `prod_rz`
--
-- --------------------------------------------------------
--
-- Table structure for table `company`
--
CREATE TABLE IF NOT EXISTS `company` (
`company_id` int(11) NOT NULL AUTO_INCREMENT,
`company_email` varchar(100) NOT NULL,
`company_name` varchar(100) NOT NULL,
`company_password` text NOT NULL,
`company_address` varchar(15) NOT NULL,
`company_phone` varchar(15) NOT NULL,
`price_plan_OTS_ID` int(11) DEFAULT NULL,
`curr_OTS_expiration` date DEFAULT NULL,
`revenue_OTS` int(11) DEFAULT NULL,
`price_plan_SCH_ID` int(11) DEFAULT NULL,
`cur_SCH_expiration` date DEFAULT NULL,
`revenue_SCH` int(11) DEFAULT NULL,
`trial_limit_user` int(11) NOT NULL DEFAULT '5',
`trial_limit_sup` int(11) NOT NULL DEFAULT '1',
`trial_limit_task` int(11) NOT NULL DEFAULT '2500',
`trial_expiration` date DEFAULT NULL,
`total_scheduling_today` int(11) NOT NULL DEFAULT '0',
`total_task_loaded_today` int(11) NOT NULL DEFAULT '0',
`verifyemail` int(11) DEFAULT '0',
`verifytoken` varchar(100) DEFAULT NULL,
`regdate` datetime DEFAULT NULL,
`profileimage` varchar(256) DEFAULT NULL,
`timezone` float NOT NULL DEFAULT '0',
PRIMARY KEY (`company_id`),
UNIQUE KEY `company_name` (`company_name`),
UNIQUE KEY `company_email` (`company_email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `company`
--
INSERT INTO `company` (`company_id`, `company_email`, `company_name`, `company_password`, `company_address`, `company_phone`, `price_plan_OTS_ID`, `curr_OTS_expiration`, `revenue_OTS`, `price_plan_SCH_ID`, `cur_SCH_expiration`, `revenue_SCH`, `trial_limit_user`, `trial_limit_sup`, `trial_limit_task`, `trial_expiration`, `total_scheduling_today`, `total_task_loaded_today`, `verifyemail`, `verifytoken`, `regdate`, `profileimage`, `timezone`) VALUES
(1, '[email protected]', 'Test Company', '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2', '123455390', '123456789', NULL, NULL, NULL, NULL, NULL, NULL, 10, 10, 2500, NULL, 0, 0, 1, '7e303e80101d3708b23fcdd5193550f0', '2015-11-28 02:39:09', 'geoclarity_favico.jpg', -6),
(2, '[email protected]', 'Testla', 'f13511789db235e334f3248d790f93f12e9266c5c104b51cdd97611912f89495e5ed78e5979607787b00e82a354063f7b053a9fbbb9243bf005fabd3c28a8c48', 'TestlaLand, NW ', '0173054727', NULL, NULL, NULL, NULL, NULL, NULL, 5, 2, 2500, NULL, 0, 0, 1, 'fa38077f83847e9fee1091ae8482de44', '2015-12-04 01:04:08', '', -8),
(5, '[email protected]', 'Geoclarity', 'f13511789db235e334f3248d790f93f12e9266c5c104b51cdd97611912f89495e5ed78e5979607787b00e82a354063f7b053a9fbbb9243bf005fabd3c28a8c48', 'H-483, dfdfd,sd', '1073054727', NULL, NULL, NULL, NULL, NULL, NULL, 5, 1, 2500, NULL, 0, 0, 0, 'c64789b1cb6ecc9ce4588aa0fb402897', '2015-12-09 21:15:23', '', 0),
(6, '[email protected]', 'texmaco Cement', 'f13511789db235e334f3248d790f93f12e9266c5c104b51cdd97611912f89495e5ed78e5979607787b00e82a354063f7b053a9fbbb9243bf005fabd3c28a8c48', 'Awadhpuri Bhopa', '91 9407500319', NULL, NULL, NULL, NULL, NULL, NULL, 400, 20, 2500, NULL, 0, 0, 1, '8b5be3f5003602c3b497f5b6c430fd70', '2015-12-26 00:40:35', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `contact`
--
CREATE TABLE IF NOT EXISTS `contact` (
`contact_id` int(11) NOT NULL AUTO_INCREMENT,
`contact_name` varchar(40) NOT NULL,
`contact_phone` varchar(15) NOT NULL,
`contact_address` text NOT NULL,
`contact_city` varchar(100) DEFAULT NULL,
`contact_lat` decimal(10,8) NOT NULL,
`contact_lng` decimal(11,8) NOT NULL,
`company_id` int(11) NOT NULL,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=425 ;
--
-- Dumping data for table `contact`
--
INSERT INTO `contact` (`contact_id`, `contact_name`, `contact_phone`, `contact_address`, `contact_city`, `contact_lat`, `contact_lng`, `company_id`) VALUES
(1, 'Karima Mcanally ', '(899) 698-6067', '3526 HIGH ST', 'SACRAMENTO', '38.63242200', '-121.43455000', 1),
(2, 'Jennette Baugh ', '(855) 709-1190', '3729 BAINBRIDGE DR', 'NORTH HIGHLANDS', '38.70174600', '-121.37642200', 1),
(3, 'Li Sowards ', '(844) 456-3323', '7420 ALIX PKWY', 'SACRAMENTO', '38.48912300', '-121.45282700', 1),
(4, 'Mana Salamone ', '(855) 164-7855', '8708 MESA BROOK WAY', 'ELK GROVE', '38.44061700', '-121.38599500', 1),
(5, 'Marin Shealy ', '(899) 018-0734', '18 OLLIE CT', 'ELK GROVE', '38.44516500', '-121.41288400', 1),
(6, 'Cheri Ohern ', '(811) 862-9670', '2010 PROMONTORY POINT LN', 'GOLD RIVER', '38.62850790', '-121.26149400', 1),
(7, 'Vergie Goodnight ', '(899) 692-6645', '7837 ABBINGTON WAY', 'ANTELOPE', '38.71054800', '-121.33972800', 1),
(8, 'Meridith Huggins ', '(899) 486-6855', '5221 38TH AVE', 'SACRAMENTO', '38.51822900', '-121.44361300', 1),
(9, 'Harmony Cahill ', '(855) 165-9597', '604 MORRISON AVE', 'SACRAMENTO', '38.63740600', '-121.45223000', 1),
(10, 'Haley Hayworth ', '(844) 056-1575', '3228 BAGGAN CT', 'ANTELOPE', '38.71513300', '-121.38835400', 1),
(11, 'Judie Hauck ', '(811) 661-9853', '1889 COLD SPRINGS RD', 'PLACERVILLE', '38.74040600', '-120.86072400', 1),
(12, 'Brigida Beauchemin ', '(811) 306-2513', '5706 GREENACRES WAY', 'ORANGEVALE', '38.67012400', '-121.21321600', 1),
(13, 'Georgiann Blick ', '(833) 407-1403', '405 MARLIN SPIKE WAY', 'SACRAMENTO', '38.65799490', '-121.45641860', 1),
(14, 'Armando Pfannenstiel ', '(899) 698-6077', '1620 BASLER ST', 'SACRAMENTO', '38.59121900', '-121.47730300', 1),
(15, 'Coralie Corter ', '(822) 964-6067', '2901 PINTAIL WAY', 'ELK GROVE', '38.39868500', '-121.47321700', 1),
(16, 'Macie Leach ', '(844) 481-2328', '3908 17TH AVE', 'SACRAMENTO', '38.53705600', '-121.46344700', 1),
(17, 'Coleman Godfrey ', '(844) 633-2361', '4621 COUNTRY SCENE WAY', 'SACRAMENTO', '38.47041280', '-121.44854030', 1),
(18, 'Donette Watley ', '(855) 194-9209', '6045 EHRHARDT AVE', 'SACRAMENTO', '38.45745300', '-121.43327900', 1),
(19, 'Deloris Edman ', '(822) 526-4639', '1786 PIEDMONT WAY', 'ROSEVILLE', '38.72727100', '-121.25686500', 1),
(20, 'Romeo Teamer ', '(822) 399-8973', '3318 DAVIDSON DR', 'ANTELOPE', '38.70551500', '-121.38909800', 1),
(21, 'Dianne Tyler ', '(855) 504-9111', '6943 WOLFGRAM WAY', 'SACRAMENTO', '38.48915000', '-121.41890000', 1),
(22, 'Odessa Plumlee ', '(844) 438-3894', '51 OMAHA CT', 'SACRAMENTO', '38.47997010', '-121.43112500', 1),
(23, 'Starr Overly ', '(822) 526-4626', '3828 BLACKFOOT WAY', 'ANTELOPE', '38.70940700', '-121.37364500', 1),
(24, 'Carmelina Borja ', '(822) 399-8960', '3820 NATOMA WAY', 'SACRAMENTO', '38.63736800', '-121.42184500', 1),
(25, 'Ernestina Tamashiro ', '(855) 504-9098', '120 GRANT LN', 'FOLSOM', '38.68819700', '-121.17125800', 1),
(26, 'Bret Sheth ', '(844) 309-4681', '4010 ALEX LN', 'CARMICHAEL', '38.63708590', '-121.31259900', 1),
(27, 'Rossie Gillogly ', '(822) 313-3709', '4727 SAVOIE WAY', 'SACRAMENTO', '38.65830100', '-121.54977400', 1),
(28, 'Luci Dallman ', '(899) 223-6313', '1300 F ST', 'SACRAMENTO', '38.58333300', '-121.48717500', 1),
(29, 'Nikia Gang ', '(844) 937-3881', '6112 HERMOSA ST', 'SACRAMENTO', '38.51475090', '-121.48076300', 1),
(30, 'Nan Looby ', '(822) 966-0527', '648 SANTA ANA AVE', 'SACRAMENTO', '38.65818100', '-121.45038500', 1),
(31, 'Bella Brenton ', '(899) 954-5811', '8515 DARTFORD DR', 'SACRAMENTO', '38.44843300', '-121.42044300', 1),
(32, 'Cassaundra Miah ', '(855) 350-2110', '5805 HIMALAYA WAY', 'CITRUS HEIGHTS', '38.69668300', '-121.32810600', 1),
(33, 'Charissa Glaspie ', '(899) 100-1069', '6900 LONICERA DR', 'ORANGEVALE', '38.69151200', '-121.25075800', 1),
(34, 'Floy Homan ', '(822) 941-6307', '1102 CHESLEY LN', 'LINCOLN', '38.86474000', '-121.31424900', 1),
(35, 'Walter Savory ', '(844) 438-3904', '9688 NATURE TRAIL WAY', 'ELK GROVE', '38.40549690', '-121.47922200', 1),
(36, 'Leandro Juntunen ', '(855) 709-1200', '201 FIRESTONE DR', 'ROSEVILLE', '38.77024690', '-121.29993040', 1),
(37, 'Raylene Ziemer ', '(844) 456-3333', '7109 CHANDLER DR', 'SACRAMENTO', '38.49683300', '-121.42373000', 1),
(38, 'Lurlene Melby ', '(855) 164-7865', '5380 VILLAGE WOOD DR', 'SACRAMENTO', '38.45472100', '-121.44008000', 1),
(39, 'Alisa Horton ', '(899) 018-0744', '1223 LAMBERTON CIR', 'SACRAMENTO', '38.64688000', '-121.43723400', 1),
(40, 'Erika Loso ', '(811) 862-9680', '1347 HIDALGO CIR', 'ROSEVILLE', '38.74764800', '-121.31218000', 1),
(41, 'Emerita Freer ', '(899) 692-6655', '913 COBDEN CT', 'GALT', '38.28235800', '-121.29566400', 1),
(42, 'Laura Tagle ', '(899) 486-6865', '77 RINETTI WAY', 'RIO LINDA', '38.68720500', '-121.46287800', 1),
(43, 'Sharita Manna ', '(855) 194-9196', '2796 BRANCH ST', 'SACRAMENTO', '38.61820800', '-121.44357900', 1),
(44, 'Lula Parm ', '(811) 862-9667', '4108 NORTON WAY', 'SACRAMENTO', '38.53725300', '-121.47857500', 1),
(45, 'Stevie Leathers ', '(899) 692-6642', '4431 GREEN TREE DR', 'SACRAMENTO', '38.50014300', '-121.45418100', 1),
(46, 'Karly Pavelka ', '(899) 486-6852', '5907 ELLERSLEE DR', 'CARMICHAEL', '38.66467400', '-121.32664900', 1),
(47, 'Kylie Wieck ', '(855) 165-9594', '4901 MILLNER WAY', 'ELK GROVE', '38.38710800', '-121.44784300', 1),
(48, 'Lisa Gallimore ', '(844) 056-1572', '8664 MAGNOLIA HILL WAY', 'ELK GROVE', '38.44275400', '-121.38992100', 1),
(49, 'Dagmar Andrew ', '(811) 661-9850', '6801 RAWLEY WAY', 'ELK GROVE', '38.40856600', '-121.42418700', 1),
(50, 'Clayton Kravetz ', '(811) 306-2510', '483 ARCADE BLVD', 'SACRAMENTO', '38.62373400', '-121.45509000', 1),
(51, 'Armida Petitt ', '(833) 407-1400', '14 ASHLEY OAKS CT', 'SACRAMENTO', '38.61758700', '-121.43625300', 1),
(52, 'Lorine Cutshall ', '(899) 698-6074', '4500 TIPPWOOD WAY', 'SACRAMENTO', '38.69931400', '-121.35979600', 1),
(53, 'Dahlia Balliet ', '(822) 964-6064', '7944 SYLVAN OAK WAY', 'CITRUS HEIGHTS', '38.71120700', '-121.26088300', 1),
(54, 'Charlesetta Rocha ', '(844) 481-2325', '419 DAWNRIDGE RD', 'ROSEVILLE', '38.72504100', '-121.29834600', 1),
(55, 'Tiffanie Ayers ', '(844) 633-2358', '11281 STANFORD COURT LN Unit 604', 'GOLD RIVER', '38.62531000', '-121.26106000', 1),
(56, 'Kimberlie Dudney ', '(855) 194-9206', '5924 TANUS CIR', 'ROCKLIN', '38.77842290', '-121.20449200', 1),
(57, 'Gertrud Winzer ', '(822) 526-4636', '1740 HIGH ST', 'AUBURN', '38.89242800', '-121.08336400', 1),
(58, 'Fae Homan ', '(822) 399-8970', '7541 SKELTON WAY', 'SACRAMENTO', '38.48467200', '-121.48859000', 1),
(59, 'Louanne Luton ', '(855) 504-9108', '2621 EVERGREEN ST', 'SACRAMENTO', '38.61324100', '-121.44467300', 1),
(60, 'Trinh Picklesimer ', '(844) 309-4691', '1223 LAMBERTON CIR', 'SACRAMENTO', '38.64688000', '-121.43723400', 1),
(61, 'Maile Holloway ', '(822) 313-3719', '212 CAPPUCINO WAY', 'SACRAMENTO', '38.65758500', '-121.46533400', 1),
(62, 'Natividad Preuss ', '(899) 223-6323', '4419 79TH ST', 'SACRAMENTO', '38.53499600', '-121.41230000', 1),
(63, 'Laurie Halderman ', '(844) 937-3891', '1316 I ST', 'RIO LINDA', '38.68337600', '-121.43532700', 1),
(64, 'Kassandra Wedel ', '(899) 018-0731', '2805 JANETTE WAY', 'SACRAMENTO', '38.61710900', '-121.43922900', 1),
(65, 'Sina Ballou ', '(822) 313-3706', '1469 JANRICK AVE', 'SACRAMENTO', '38.47596100', '-121.50190100', 1),
(66, 'Earlean Peck ', '(899) 223-6310', '9417 SARA ST', 'ELK GROVE', '38.41549800', '-121.37031500', 1),
(67, 'Noella Blodgett ', '(844) 937-3878', '17 SERASPI CT', 'SACRAMENTO', '38.63149090', '-121.50236800', 1),
(68, 'Veta Sanor ', '(822) 966-0524', '4818 BRITTNEY LEE CT', 'SACRAMENTO', '38.65411900', '-121.34207700', 1),
(69, 'Jerica Rocco ', '(899) 954-5808', '9570 HARVEST ROSE WAY', 'SACRAMENTO', '38.55575500', '-121.34062800', 1),
(70, 'Delinda Groat ', '(855) 350-2107', '1693 SHELTER COVE DR', 'GREENWOOD', '38.94581400', '-120.90717100', 1),
(71, 'Shanae Stanbery ', '(899) 100-1066', '671 SONOMA AVE', 'SACRAMENTO', '38.62321300', '-121.44990500', 1),
(72, 'Shayne Stagner ', '(822) 941-6304', '3174 NORTHVIEW DR', 'SACRAMENTO', '38.62371600', '-121.47754400', 1),
(73, 'Alisha Anger ', '(844) 438-3901', '2460 EL ROCCO WAY', 'RANCHO CORDOVA', '38.59115500', '-121.31603500', 1),
(74, 'Chelsie Grandstaff ', '(855) 709-1197', '3139 SPOONWOOD WAY Unit 1', 'SACRAMENTO', '38.62673800', '-121.52167400', 1),
(75, 'So Scianna ', '(844) 456-3330', '5312 MARBURY WAY', 'ANTELOPE', '38.71001800', '-121.34076400', 1),
(76, 'Cuc Lichtenberger ', '(855) 164-7862', '7320 6TH ST', 'RIO LINDA', '38.70073900', '-121.45158500', 1),
(77, 'Graig Cassel ', '(899) 018-0741', '9629 CEDAR OAK WAY', 'ELK GROVE', '38.40534490', '-121.43139400', 1),
(78, 'Zula Vierling ', '(811) 862-9677', '2733 DANA LOOP', 'EL DORADO HILLS', '38.62838000', '-121.05462800', 1),
(79, 'Jeremiah Wilczynski ', '(899) 692-6652', '9058 MONTOYA ST', 'SACRAMENTO', '38.55893720', '-121.36793390', 1),
(80, 'Tandra Johnstone ', '(899) 486-6862', '201 CARLO CT', 'GALT', '38.24252500', '-121.31053600', 1),
(81, 'Natalia Hollingworth ', '(855) 165-9604', '6000 BIRCHGLADE WAY', 'CITRUS HEIGHTS', '38.70151400', '-121.32266500', 1),
(82, 'Tiffiny Ulibarri ', '(844) 056-1582', '5938 WOODBRIAR WAY', 'CITRUS HEIGHTS', '38.70587800', '-121.32459300', 1),
(83, 'Sona Laforest ', '(811) 661-9860', '3012 SPOONWOOD WAY', 'SACRAMENTO', '38.62465500', '-121.52331700', 1),
(84, 'Marsha Cochrane ', '(811) 306-2520', '2130 CATHERWOOD WAY', 'SACRAMENTO', '38.67529400', '-121.51124600', 1),
(85, 'Felicidad Atwater ', '(844) 309-4678', '6001 MCMAHON DR', 'SACRAMENTO', '38.51969900', '-121.43559900', 1),
(86, 'Leopoldo Laramie ', '(844) 056-1569', '9861 CULP WAY', 'SACRAMENTO', '38.55864900', '-121.32752700', 1),
(87, 'Jenette Rudd ', '(811) 661-9847', '8299 HALBRITE WAY', 'SACRAMENTO', '38.47403300', '-121.40022800', 1),
(88, 'Angeles Englehart ', '(811) 306-2507', '170 PENHOW CIR', 'SACRAMENTO', '38.65345900', '-121.53536000', 1),
(89, 'Florence Kulp ', '(833) 407-1397', '5529 LAGUNA PARK DR', 'ELK GROVE', '38.42597900', '-121.43777900', 1),
(90, 'Taisha Alldredge ', '(899) 698-6071', '4359 CREGAN CT', 'RANCHO CORDOVA', '38.54540700', '-121.22462100', 1),
(91, 'Karolyn Hartwick ', '(822) 964-6061', '9361 WADDELL LN', 'ELK GROVE', '38.45102700', '-121.34980300', 1),
(92, 'Christene Lofland ', '(844) 481-2322', '5980 79TH ST', 'SACRAMENTO', '38.51833900', '-121.41207200', 1),
(93, 'Margene Damore ', '(844) 633-2355', '840 TRANQUIL LN', 'GALT', '38.27051400', '-121.29927900', 1),
(94, 'Shantelle Cornforth ', '(855) 194-9203', '8244 SUNBIRD WAY', 'SACRAMENTO', '38.45816500', '-121.43161300', 1),
(95, 'Basil Hilburn ', '(822) 526-4633', '6217 LEOLA WAY', 'SACRAMENTO', '38.51241460', '-121.45168760', 1),
(96, 'Elidia Hogg ', '(822) 399-8967', '6344 BONHAM CIR', 'CITRUS HEIGHTS', '38.68219700', '-121.27288600', 1),
(97, 'Phillis Richie ', '(855) 504-9105', '993 MANTON CT', 'GALT', '38.27306900', '-121.28948600', 1),
(98, 'Kari Mccarville ', '(844) 309-4688', '3429 FERNBROOK CT', 'CAMERON PARK', '38.66433390', '-121.00762900', 1),
(99, 'Britt Digiacomo ', '(822) 313-3716', '9741 SADDLEBRED CT', 'WILTON', '38.40771800', '-121.19804200', 1),
(100, 'Ernestine Lafollette ', '(899) 223-6320', '1016 CONGRESS AVE', 'SACRAMENTO', '38.62998600', '-121.44270710', 1),
(101, 'Fawn Peavler ', '(844) 937-3888', '6743 21ST ST', 'SACRAMENTO', '38.50398700', '-121.49040900', 1),
(102, 'Kyla Forsgren ', '(822) 966-0534', '7204 THOMAS DR', 'NORTH HIGHLANDS', '38.69806000', '-121.37732200', 1),
(103, 'Sueann Gigliotti ', '(899) 954-5818', '3801 WILDROSE WAY', 'SACRAMENTO', '38.54422400', '-121.36968500', 1),
(104, 'Nelda Rothstein ', '(855) 350-2117', '8728 CRYSTAL RIVER WAY', 'SACRAMENTO', '38.47529700', '-121.37954000', 1),
(105, 'Tula Hallum ', '(899) 100-1076', '8304 JUGLANS DR', 'ORANGEVALE', '38.69169100', '-121.24864800', 1),
(106, 'Marti Fines ', '(855) 165-9591', '5828 PEPPERMILL CT', 'SACRAMENTO', '38.66206900', '-121.32838300', 1),
(107, 'Nelida Lippard ', '(899) 954-5805', '7825 CREEK VALLEY CIR', 'SACRAMENTO', '38.47247300', '-121.40393100', 1),
(108, 'Jaimee Lenox ', '(855) 350-2104', '7223 KALLIE KAY LN', 'SACRAMENTO', '38.47784800', '-121.41918600', 1),
(109, 'Austin Lebaron ', '(899) 100-1063', '8345 STAR THISTLE WAY', 'SACRAMENTO', '38.45476690', '-121.43899200', 1),
(110, 'Kasandra Moler ', '(822) 941-6301', '230 CANDELA CIR', 'SACRAMENTO', '38.65592800', '-121.54755400', 1),
(111, 'Suellen Privette ', '(844) 438-3898', '5337 DUSTY ROSE WAY', 'RANCHO CORDOVA', '38.52879000', '-121.22946500', 1),
(112, 'Wilbur Keenan ', '(855) 709-1194', '10 SEA FOAM CT', 'SACRAMENTO', '38.48719300', '-121.54575500', 1),
(113, 'Delcie Everly ', '(844) 456-3327', '7607 ELDER CREEK RD', 'SACRAMENTO', '38.51086200', '-121.41471000', 1),
(114, 'Larraine Heiss ', '(855) 164-7859', '5333 PRIMROSE DR Unit 19A', 'FAIR OAKS', '38.66300500', '-121.27739500', 1),
(115, 'Elden Spero ', '(899) 018-0738', '5841 VALLEY VALE WAY', 'SACRAMENTO', '38.46175400', '-121.43426800', 1),
(116, 'Claris Luc ', '(811) 862-9674', '2340 HURLEY WAY', 'SACRAMENTO', '38.58768560', '-121.40888520', 1),
(117, 'Carylon Heisey ', '(899) 692-6649', '8207 YORKTON WAY', 'SACRAMENTO', '38.45957860', '-121.36027140', 1),
(118, 'Kyle Popek ', '(899) 486-6859', '4487 PANORAMA DR', 'PLACERVILLE', '38.69503900', '-120.84830000', 1),
(119, 'Jeraldine Lamarca ', '(855) 165-9601', '2121 HANNAH WAY', 'ROCKLIN', '38.80583300', '-121.28058200', 1),
(120, 'Christian Sobol ', '(844) 056-1579', '7756 TIGERWOODS DR', 'SACRAMENTO', '38.47658100', '-121.30841700', 1),
(121, 'Alisa Lloyd ', '(811) 661-9857', '540 MORRISON AVE', 'SACRAMENTO', '38.63742700', '-121.45402400', 1),
(122, 'Vincenza Mcgowen ', '(811) 306-2517', '3128 VIA GRANDE', 'SACRAMENTO', '38.59795100', '-121.39119800', 1),
(123, 'Katia Mcclay ', '(833) 407-1407', '8363 LANGTREE WAY', 'SACRAMENTO', '38.45361590', '-121.43570200', 1),
(124, 'Tilda Mcquillen ', '(899) 698-6081', '508 SAMUEL WAY', 'SACRAMENTO', '38.64528300', '-121.45418800', 1),
(125, 'Lyndon Chancy ', '(822) 964-6071', '4709 AMBER LN Unit 1', 'SACRAMENTO', '38.65839500', '-121.35361600', 1),
(126, 'Delores Hoff ', '(844) 481-2332', '5308 MARBURY WAY', 'ANTELOPE', '38.70997600', '-121.34093900', 1),
(127, 'Yee Ridenour ', '(822) 966-0521', '6048 OGDEN NASH WAY', 'SACRAMENTO', '38.68120100', '-121.35155800', 1),
(128, 'Dick Milledge ', '(899) 698-6068', '5201 LAGUNA OAKS DR Unit 140', 'ELK GROVE', '38.42227100', '-121.44313400', 1),
(129, 'Elane Rafael ', '(822) 964-6058', '8156 STEINBECK WAY', 'SACRAMENTO', '38.47463500', '-121.40650800', 1),
(130, 'Glady Viernes ', '(844) 481-2319', '9080 FRESCA WAY', 'ELK GROVE', '38.42808700', '-121.42444100', 1),
(131, 'Jacki Saiki ', '(844) 633-2352', '4900 71ST ST', 'SACRAMENTO', '38.53130900', '-121.42123900', 1),
(132, 'Kathrin Neidig ', '(855) 194-9200', '8929 SUTTERS GOLD DR', 'SACRAMENTO', '38.55109600', '-121.37022700', 1),
(133, 'Trudi Sherry ', '(822) 526-4630', '6945 RIO TEJO WAY', 'ELK GROVE', '38.38660200', '-121.42254600', 1),
(134, 'Sherry Nester ', '(822) 399-8964', '5028 14TH AVE', 'SACRAMENTO', '38.53916490', '-121.44700300', 1),
(135, 'Breanne Dingman ', '(855) 504-9102', '1035 MILLET WAY', 'SACRAMENTO', '38.63048500', '-121.48483300', 1),
(136, 'Brian Drapeau ', '(844) 309-4685', '7863 CRESTLEIGH CT', 'ANTELOPE', '38.71110900', '-121.35881300', 1),
(137, 'Lekisha Shryock ', '(822) 313-3713', '3035 BRUNNET LN', 'SACRAMENTO', '38.62461880', '-121.52261780', 1),
(138, 'Ulysses Gottfried ', '(899) 223-6317', '7922 MANSELL WAY', 'ELK GROVE', '38.40943900', '-121.40985900', 1),
(139, 'Riva Harryman ', '(844) 937-3885', '5651 OVERLEAF WAY', 'SACRAMENTO', '38.67785390', '-121.49505920', 1),
(140, 'Latonia Crepeau ', '(822) 966-0531', '10104 ANNIE ST', 'ELK GROVE', '38.39081500', '-121.44372000', 1),
(141, 'Natalia Salvatore ', '(899) 954-5815', '5709 RIVER OAK WAY', 'CARMICHAEL', '38.60300900', '-121.33118700', 1),
(142, 'Kory Esh ', '(855) 350-2114', '5303 JERRETT WAY', 'SACRAMENTO', '38.66346400', '-121.35946760', 1),
(143, 'Hassie Swift ', '(899) 100-1073', '2847 BELGRADE WAY', 'SACRAMENTO', '38.61735580', '-121.48281360', 1),
(144, 'Tabetha Catchings ', '(822) 941-6311', '1675 VERNON ST Unit 8', 'ROSEVILLE', '38.73336900', '-121.29731800', 1),
(145, 'Shaunte Runyan ', '(844) 438-3908', '6128 CARL SANDBURG CIR', 'SACRAMENTO', '38.68177300', '-121.35579500', 1),
(146, 'Shawanna Darrow ', '(855) 709-1204', '4508 OLD DAIRY DR', 'ANTELOPE', '38.72258900', '-121.35883200', 1),
(147, 'Deshawn Easton ', '(844) 456-3337', '9182 LAKEMONT DR', 'ELK GROVE', '38.45118600', '-121.35864900', 1),
(148, 'Reita Pizana ', '(833) 407-1394', '2561 19TH AVE', 'SACRAMENTO', '38.53549300', '-121.48022800', 1),
(149, 'Delmy Charney ', '(844) 438-3895', '6768 MEDORA DR', 'NORTH HIGHLANDS', '38.69133990', '-121.37218700', 1),
(150, 'Nakia Colligan ', '(855) 709-1191', '7957 VALLEY GREEN DR', 'SACRAMENTO', '38.46528720', '-121.43465900', 1),
(151, 'Damon Lavallie ', '(844) 456-3324', '391 NATALINO CIR', 'SACRAMENTO', '38.67338400', '-121.50629900', 1),
(152, 'Lynnette Abdulla ', '(855) 164-7856', '12209 CONSERVANCY WAY', 'RANCHO CORDOVA', '38.55462500', '-121.21912600', 1),
(153, 'Gertrudis Higley ', '(899) 018-0735', '8025 PEERLESS AVE', 'ORANGEVALE', '38.71179800', '-121.21649400', 1),
(154, 'Jenee Luna ', '(811) 862-9671', '4186 TULIP PARK WAY', 'RANCHO CORDOVA', '38.55052400', '-121.23551600', 1),
(155, 'Zenia Kerlin ', '(899) 692-6646', '14788 NATCHEZ CT', 'RANCHO MURIETA', '38.49215000', '-121.10016000', 1),
(156, 'Keli Asberry ', '(899) 486-6856', '5201 LAGUNA OAKS DR Unit 126', 'ELK GROVE', '38.42227100', '-121.44313400', 1),
(157, 'James Segura ', '(855) 165-9598', '7129 SPRINGMONT DR', 'ELK GROVE', '38.41769200', '-121.42058700', 1),
(158, 'Yaeko Doyel ', '(844) 056-1576', '3025 EL PRADO WAY', 'SACRAMENTO', '38.60673800', '-121.39304000', 1),
(159, 'Marshall Ochoa ', '(811) 661-9854', '5712 MELBURY CIR', 'ANTELOPE', '38.70592000', '-121.33443000', 1),
(160, 'Micheal Lengyel ', '(811) 306-2514', '2015 PROMONTORY POINT LN', 'GOLD RIVER', '38.62883200', '-121.26090100', 1),
(161, 'Tarah Aldape ', '(833) 407-1404', '1092 MAUGHAM CT', 'GALT', '38.27142400', '-121.28737400', 1),
(162, 'Kari Kaster ', '(899) 698-6078', '2981 WRINGER DR', 'ROSEVILLE', '38.73558600', '-121.22715300', 1),
(163, 'Gregg Camargo ', '(822) 964-6068', '2820 DEL PASO BLVD', 'SACRAMENTO', '38.61756200', '-121.43949400', 1),
(164, 'Margie Huggett ', '(844) 481-2329', '7741 MILLDALE CIR', 'ELVERTA', '38.70537000', '-121.43910300', 1),
(165, 'Leisha Krug ', '(844) 633-2362', '6632 IBEX WOODS CT', 'CITRUS HEIGHTS', '38.72043800', '-121.30959400', 1),
(166, 'Jocelyn Miguel ', '(855) 194-9210', '1 KENNELFORD CIR', 'SACRAMENTO', '38.46453200', '-121.42727900', 1),
(167, 'Michaele Karam ', '(822) 526-4640', '312 RIVER ISLE WAY', 'SACRAMENTO', '38.48985700', '-121.55083200', 1),
(168, 'Deb Shugart ', '(822) 399-8974', '2231 COUNTRY VILLA CT', 'AUBURN', '38.93181600', '-121.09813200', 1),
(169, 'Monserrate Benge ', '(822) 941-6298', '11150 TRINITY RIVER DR Unit 114', 'RANCHO CORDOVA', '38.62192100', '-121.26953400', 1),
(170, 'Hayden Corney ', '(855) 194-9197', '3100 EXPLORER DR', 'SACRAMENTO', '38.56645800', '-121.33255900', 1),
(171, 'Angelo Shaner ', '(822) 526-4627', '1122 WILD POPPY CT', 'GALT', '38.28778100', '-121.29506400', 1),
(172, 'Cesar Forgione ', '(822) 399-8961', '8373 BLACKMAN WAY', 'ELK GROVE', '38.43512000', '-121.39473500', 1),
(173, 'Leesa Furst ', '(855) 504-9099', '4236 NATOMAS CENTRAL DR', 'SACRAMENTO', '38.64810090', '-121.54376840', 1),
(174, 'Walter Painter ', '(844) 309-4682', '4620 WELERA WAY', 'ELK GROVE', '38.39842800', '-121.44942200', 1),
(175, 'Alicia Mort ', '(822) 313-3710', '9278 DAIRY CT', 'ELK GROVE', '38.41999900', '-121.36414300', 1),
(176, 'Renna Newbury ', '(899) 223-6314', '1069 ACACIA AVE', 'SACRAMENTO', '38.62248200', '-121.44231700', 1),
(177, 'Kelly Shatley ', '(844) 937-3882', '3328 22ND AVE', 'SACRAMENTO', '38.53249700', '-121.47097800', 1),
(178, 'Angelyn Kerby ', '(822) 966-0528', '8284 RED FOX WAY', 'ELK GROVE', '38.41763100', '-121.39692000', 1),
(179, 'Janie Shima ', '(899) 954-5812', '9387 GRANITE FALLS CT', 'ELK GROVE', '38.41943890', '-121.34902000', 1),
(180, 'Corinne Hesse ', '(855) 350-2111', '632 NEWBRIDGE LN', 'LINCOLN', '38.87909400', '-121.29863000', 1),
(181, 'Donovan Wilkison ', '(899) 100-1070', '3224 PARKHAM DR', 'ROSEVILLE', '38.77284300', '-121.36439400', 1),
(182, 'Thelma Gilland ', '(822) 941-6308', '5404 ALMOND FALLS WAY', 'RANCHO CORDOVA', '38.52761600', '-121.23374400', 1),
(183, 'Ezra Musgrave ', '(844) 438-3905', '8616 ROCKPORTE CT', 'ROSEVILLE', '38.74245100', '-121.35925400', 1),
(184, 'Enrique Lheureux ', '(855) 709-1201', '3715 TALLYHO DR Unit 78HIGH', 'SACRAMENTO', '38.54516200', '-121.35599300', 1),
(185, 'Melisa Willey ', '(844) 456-3334', '9013 CASALS ST', 'SACRAMENTO', '38.55747100', '-121.37007700', 1),
(186, 'Lannie Jablonski ', '(855) 164-7866', '117 EVCAR WAY', 'RIO LINDA', '38.68774600', '-121.46366700', 1),
(187, 'Kecia Kentner ', '(899) 018-0745', '909 SINGINGWOOD RD', 'SACRAMENTO', '38.58183800', '-121.38865600', 1),
(188, 'Tracy Rasmus ', '(811) 862-9681', '301 OLIVADI WAY', 'SACRAMENTO', '38.64438500', '-121.54920700', 1),
(189, 'Kris Mele ', '(899) 692-6656', '8491 CRYSTAL WALK CIR', 'ELK GROVE', '38.41744200', '-121.40769300', 1),
(190, 'Garrett Mantle ', '(844) 633-2349', '7325 10TH ST', 'RIO LINDA', '38.70067300', '-121.44324500', 1),
(191, 'Malika Dejonge ', '(899) 018-0732', '7944 DOMINION WAY', 'ELVERTA', '38.71295400', '-121.41146600', 1),
(192, 'Sherri Mcgarr ', '(811) 862-9668', '4520 BOMARK WAY', 'SACRAMENTO', '38.66549500', '-121.35840400', 1),
(193, 'Augusta Mulhern ', '(899) 692-6643', '9837 CORTE DORADO CT', 'ELK GROVE', '38.40007600', '-121.38168100', 1),
(194, 'Marcela Happel ', '(899) 486-6853', '5615 LUPIN LN', 'POLLOCK PINES', '38.70694400', '-120.60245300', 1),
(195, 'Oneida Snelling ', '(855) 165-9595', '9723 TERRAPIN CT', 'ELK GROVE', '38.40316390', '-121.43024400', 1),
(196, 'Alphonso Griffeth ', '(844) 056-1573', '207 ORANGE BLOSSOM CIR Unit C', 'FOLSOM', '38.64666100', '-121.17555800', 1),
(197, 'Shea Nickels ', '(811) 661-9851', '5201 LAGUNA OAKS DR Unit 199', 'ELK GROVE', '38.42227100', '-121.44313400', 1),
(198, 'Ellsworth Muldrow ', '(811) 306-2511', '8001 HARTWICK WAY', 'SACRAMENTO', '38.48882600', '-121.41052500', 1),
(199, 'Jesusa Strum ', '(833) 407-1401', '2219 EL CANTO CIR', 'RANCHO CORDOVA', '38.59185700', '-121.31874800', 1),
(200, 'Landon Schell ', '(899) 698-6075', '9257 CALDERA WAY', 'SACRAMENTO', '38.55841000', '-121.35499300', 1),
(201, 'Tomas Jewell ', '(822) 964-6065', '1570 GLIDDEN AVE', 'SACRAMENTO', '38.48250000', '-121.50014300', 1),
(202, 'Dagny Moss ', '(844) 481-2326', '15 VANESSA PL', 'SACRAMENTO', '38.66828200', '-121.54548200', 1),
(203, 'Helen Clendening ', '(844) 633-2359', '6306 CONEJO', 'RANCHO MURIETA', '38.51275900', '-121.08738600', 1),
(204, 'Stormy Naab ', '(855) 194-9207', '4128 HILL ST', 'FAIR OAKS', '38.64219000', '-121.26167800', 1),
(205, 'Lilian Fultz ', '(822) 526-4637', '6013 ROWAN WAY', 'CITRUS HEIGHTS', '38.67494300', '-121.29512700', 1),
(206, 'Judie Lyttle ', '(822) 399-8971', '227 MAHAN CT Unit 1', 'ROSEVILLE', '38.74996700', '-121.27053300', 1),
(207, 'Lonny Breitenstein ', '(855) 504-9109', '6485 LAGUNA MIRAGE LN', 'ELK GROVE', '38.42444900', '-121.42992500', 1),
(208, 'Isabella Fusaro ', '(844) 309-4692', '6671 FOXWOOD CT', 'SACRAMENTO', '38.68811900', '-121.32924300', 1),
(209, 'Wilbert Jost ', '(822) 313-3720', '5636 25TH ST', 'SACRAMENTO', '38.52339300', '-121.48139200', 1),
(210, 'Berry Mcmurry ', '(899) 223-6324', '361 MAHONIA CIR', 'SACRAMENTO', '38.67598200', '-121.50961700', 1),
(211, 'Stephane Lindblom ', '(855) 164-7853', '645 MORRISON AVE', 'SACRAMENTO', '38.63790300', '-121.45047200', 1),
(212, 'Jena Omalley ', '(844) 309-4679', '5201 LAGUNA OAKS DR Unit 162', 'ELK GROVE', '38.42227100', '-121.44313400', 1),
(213, 'Kera Lawlor ', '(822) 313-3707', '9012 KIEFER BLVD', 'SACRAMENTO', '38.54679700', '-121.36595600', 1),
(214, 'Nathanial Haddad ', '(899) 223-6311', '5037 J PKWY', 'SACRAMENTO', '38.49188300', '-121.44464700', 1),
(215, 'Un Carraway ', '(844) 937-3879', '5625 JAMES WAY', 'SACRAMENTO', '38.52373600', '-121.48471100', 1),
(216, 'Rosie Garlock ', '(822) 966-0525', '2115 SMOKESTACK WAY', 'SACRAMENTO', '38.60249300', '-121.54329360', 1),
(217, 'Lolita Marlatt ', '(899) 954-5809', '6507 RIO DE ONAR WAY', 'ELK GROVE', '38.38274400', '-121.42788200', 1),
(218, 'Nydia Pantano ', '(855) 350-2108', '3847 LAS PASAS WAY', 'SACRAMENTO', '38.58908200', '-121.37385300', 1),
(219, 'Eryn Linke ', '(899) 100-1067', '7812 HARTWICK WAY', 'SACRAMENTO', '38.48840200', '-121.41218200', 1),
(220, 'Jesusa Beckerman ', '(822) 941-6305', '8907 GEMWOOD WAY', 'ELK GROVE', '38.43589300', '-121.44080600', 1),
(221, 'Jeana Hanrahan ', '(844) 438-3902', '441 ARLINGDALE CIR', 'RIO LINDA', '38.70359500', '-121.45516900', 1),
(222, 'Gregorio Fennel ', '(855) 709-1198', '8108 FILIFERA WAY', 'ANTELOPE', '38.71685100', '-121.35429500', 1),
(223, 'Maris Ledoux ', '(844) 456-3331', '1312 RENISON LN', 'LINCOLN', '38.86622000', '-121.30796600', 1),
(224, 'Elinore Pfister ', '(855) 164-7863', '14 CASA VATONI PL', 'SACRAMENTO', '38.64996000', '-121.55216200', 1),
(225, 'Milda Folkes ', '(899) 018-0742', '1409 47TH ST', 'SACRAMENTO', '38.56305600', '-121.44661300', 1),
(226, 'Lesha Mascia ', '(811) 862-9678', '2987 PONDEROSA LN', 'SACRAMENTO', '38.62236990', '-121.45811900', 1),
(227, 'Nannette Espey ', '(899) 692-6653', '7349 FLETCHER FARM DR', 'SACRAMENTO', '38.49083000', '-121.38239000', 1),
(228, 'Mariela Escamilla ', '(899) 486-6863', '746 MOOSE CREEK WAY', 'GALT', '38.28289190', '-121.30263600', 1),
(229, 'Jenee Holstein ', '(855) 165-9605', '8165 AYN RAND CT', 'SACRAMENTO', '38.46847100', '-121.40445300', 1),
(230, 'Selena Czapla ', '(844) 056-1583', '8721 SPRUCE RIDGE WAY', 'ANTELOPE', '38.72792800', '-121.39131800', 1),
(231, 'Jamal Loth ', '(811) 661-9861', '3427 LA CADENA WAY', 'SACRAMENTO', '38.68138500', '-121.53787300', 1),
(232, 'Lan Arwood ', '(855) 504-9096', '4085 FAWN CIR', 'SACRAMENTO', '38.47094600', '-121.45853000', 1),
(233, 'Shona Appleby ', '(855) 165-9592', '3920 SHINING STAR DR', 'SACRAMENTO', '38.48718490', '-121.46224800', 1),
(234, 'Soraya Kiser ', '(844) 056-1570', '5332 SANDSTONE ST', 'CARMICHAEL', '38.66278700', '-121.31368600', 1),
(235, 'Hanh Antley ', '(811) 661-9848', '10245 LOS PALOS DR', 'RANCHO CORDOVA', '38.59402600', '-121.31078900', 1),
(236, 'Naoma Brazier ', '(811) 306-2508', '7842 LAHONTAN CT', 'SACRAMENTO', '38.47295600', '-121.31893800', 1),
(237, 'Shea Scotti ', '(833) 407-1398', '100 REBECCA WAY', 'FOLSOM', '38.68450300', '-121.14913300', 1),
(238, 'Yuonne Benefiel ', '(899) 698-6072', '7004 RAWLEY WAY', 'ELK GROVE', '38.40611100', '-121.42231700', 1),
(239, 'Keren Alberts ', '(822) 964-6062', '5201 LAGUNA OAKS DR Unit 172', 'ELK GROVE', '38.42227100', '-121.44313400', 1),
(240, 'Taryn Freeborn ', '(844) 481-2323', '4207 PAINTER WAY', 'NORTH HIGHLANDS', '38.69311500', '-121.36726000', 1),
(241, 'Owen Huntoon ', '(844) 633-2356', '5925 MALEVILLE AVE', 'CARMICHAEL', '38.66674100', '-121.32539600', 1),
(242, 'Ester Carballo ', '(855) 194-9204', '2284 LOS ROBLES RD', 'MEADOW VISTA', '39.00908200', '-121.03562400', 1),
(243, 'Ying Wiedemann ', '(822) 526-4634', '230 BANKSIDE WAY', 'SACRAMENTO', '38.67692980', '-121.52904900', 1),
(244, 'Maia Robichaud ', '(822) 399-8968', '8 RIVER RAFT CT', 'SACRAMENTO', '38.44803000', '-121.43471200', 1),
(245, 'Catherine Mintz ', '(855) 504-9106', '1456 EAGLESFIELD LN', 'LINCOLN', '38.85771600', '-121.31161100', 1),
(246, 'Abigail Teston ', '(844) 309-4689', '3935 EL MONTE DR', 'LOOMIS', '38.81392400', '-121.13343900', 1),
(247, 'Erik Majka ', '(822) 313-3717', '3732 LANKERSHIM WAY', 'NORTH HIGHLANDS', '38.68982590', '-121.37729400', 1),
(248, 'Princess Bridgett ', '(899) 223-6321', '7226 LARCHMONT DR', 'NORTH HIGHLANDS', '38.69939800', '-121.37608100', 1),
(249, 'Leanna Cichon ', '(844) 937-3889', '8306 CURLEW CT', 'CITRUS HEIGHTS', '38.71617400', '-121.29896400', 1),
(250, 'Broderick Lapine ', '(822) 966-0535', '9474 VILLAGE TREE DR', 'ELK GROVE', '38.41384600', '-121.40863900', 1),
(251, 'Shena Wishart ', '(899) 954-5819', '7461 WINDBRIDGE DR', 'SACRAMENTO', '38.48768900', '-121.53025100', 1),
(252, 'Deandrea Bhatti ', '(855) 350-2118', '955 BIG SUR CT', 'EL DORADO HILLS', '38.66459700', '-121.07631800', 1),
(253, 'Stephen Uribe ', '(899) 486-6850', '2930 LA ROSA RD', 'SACRAMENTO', '38.61855860', '-121.43592700', 1),
(254, 'Lonnie Hallman ', '(822) 966-0522', '5031 CORVAIR ST', 'NORTH HIGHLANDS', '38.65866380', '-121.37572790', 1),
(255, 'Jovita Barren ', '(899) 954-5806', '5993 SAWYER CIR', 'SACRAMENTO', '38.44710100', '-121.43504900', 1),
(256, 'Hosea Archambault ', '(855) 350-2105', '6613 NAVION DR', 'CITRUS HEIGHTS', '38.70271600', '-121.31371600', 1),
(257, 'Chara Cevallos ', '(899) 100-1064', '6850 21ST ST', 'SACRAMENTO', '38.50169100', '-121.49110600', 1),
(258, 'Fletcher Nembhard ', '(822) 941-6302', '9488 OAK VILLAGE WAY', 'ELK GROVE', '38.41320300', '-121.40530700', 1),
(259, 'Irene Hilyard ', '(844) 438-3899', '6503 RIO DE ONAR WAY', 'ELK GROVE', '38.38274400', '-121.42807400', 1),
(260, 'Kerrie Rumbaugh ', '(855) 709-1195', '1121 CREEKSIDE WAY', 'GALT', '38.24132190', '-121.31193600', 1),
(261, 'Tatum Coughlan ', '(844) 456-3328', '7458 WINKLEY WAY', 'SACRAMENTO', '38.48765200', '-121.49069500', 1),
(262, 'Otto Karp ', '(855) 164-7860', '7031 CANEVALLEY CIR', 'CITRUS HEIGHTS', '38.71887600', '-121.30353500', 1),
(263, 'Christopher Papa ', '(899) 018-0739', '8164 CHENIN BLANC LN', 'FAIR OAKS', '38.66547400', '-121.25982200', 1),
(264, 'Teresa Moors ', '(811) 862-9675', '5342 CALABRIA WAY', 'SACRAMENTO', '38.67176090', '-121.49795900', 1),
(265, 'Crysta Wier ', '(899) 692-6650', '2251 LAMPLIGHT LN', 'LINCOLN', '38.85012900', '-121.27559800', 1),
(266, 'Karrie Sereno ', '(899) 486-6860', '4100 BOTHWELL CIR', 'EL DORADO HILLS', '38.67876500', '-121.03521800', 1),
(267, 'Jay Mancilla ', '(855) 165-9602', '5840 WALERGA RD', 'SACRAMENTO', '38.67420500', '-121.35731100', 1),
(268, 'Vanita Lewicki ', '(844) 056-1580', '2216 DUNLAP DR', 'SACRAMENTO', '38.62352400', '-121.41308600', 1),
(269, 'Lessie Jung ', '(811) 661-9858', '4114 35TH AVE', 'SACRAMENTO', '38.52070590', '-121.45887100', 1),
(270, 'Deon Prichett ', '(811) 306-2518', '8306 CURLEW CT', 'CITRUS HEIGHTS', '38.71617400', '-121.29896400', 1),
(271, 'Fumiko Furtado ', '(833) 407-1408', '7213 CALVIN DR', 'CITRUS HEIGHTS', '38.69896900', '-121.29915900', 1),
(272, 'Thelma Meagher ', '(899) 698-6082', '8101 LEMON COVE CT', 'SACRAMENTO', '38.46323700', '-121.40842200', 1),
(273, 'Inell Sliva ', '(822) 964-6072', '11826 DIONYSUS WAY', 'RANCHO CORDOVA', '38.55088000', '-121.23885800', 1),
(274, 'Carrie Gulick ', '(844) 937-3876', '2113 KIRK WAY', 'SACRAMENTO', '38.48240700', '-121.49248600', 1),
(275, 'Crissy Cabell ', '(833) 407-1395', '7661 NIXOS WAY', 'SACRAMENTO', '38.47922100', '-121.46293600', 1),
(276, 'Adaline Ruiz ', '(899) 698-6069', '4844 CLYDEBANK WAY', 'ANTELOPE', '38.71480600', '-121.34792900', 1),
(277, 'Zana Condict ', '(822) 964-6059', '2887 AZEVEDO DR', 'SACRAMENTO', '38.61835900', '-121.50977200', 1),
(278, 'Dagny Reiff ', '(844) 481-2320', '2900 BLAIR RD', 'POLLOCK PINES', '38.75474400', '-120.60515400', 1),
(279, 'Christal Baty ', '(844) 633-2353', '8495 DARTFORD DR', 'SACRAMENTO', '38.44872190', '-121.42128500', 1),
(280, 'Gilberto Wismer ', '(855) 194-9201', '2217 APPALOOSA CT', 'FOLSOM', '38.65501000', '-121.08962800', 1),
(281, 'Ngan Girton ', '(822) 526-4631', '5307 CABRILLO WAY', 'SACRAMENTO', '38.52666600', '-121.43511300', 1),
(282, 'Cordell Keese ', '(822) 399-8965', '8354 SUNRISE WOODS WAY', 'SACRAMENTO', '38.47310490', '-121.39671500', 1),
(283, 'Mana Quillin ', '(855) 504-9103', '3949 WILDROSE WAY', 'SACRAMENTO', '38.54391600', '-121.36705100', 1),
(284, 'Dorothea Opitz ', '(844) 309-4686', '4620 CHAMBERLIN CIR', 'ELK GROVE', '38.39057100', '-121.45003800', 1),
(285, 'Lola Constantine ', '(822) 313-3714', '47 NAPONEE CT', 'SACRAMENTO', '38.66615100', '-121.52958700', 1),
(286, 'Lashay Mondor ', '(899) 223-6318', '106 FARHAM DR', 'FOLSOM', '38.66742500', '-121.16879600', 1),
(287, 'Philip Barner ', '(844) 937-3886', '427 21ST ST', 'SACRAMENTO', '38.58199000', '-121.47579500', 1),
(288, 'Darius Fitz ', '(822) 966-0532', '923 FULTON AVE', 'SACRAMENTO', '38.58205540', '-121.40217840', 1),
(289, 'Chuck Broyles ', '(899) 954-5816', '3503 21ST AVE', 'SACRAMENTO', '38.53386200', '-121.46923300', 1),
(290, 'Carlo Sheldon ', '(855) 350-2115', '617 M ST', 'RIO LINDA', '38.69138700', '-121.45153900', 1),
(291, 'Reva Geisler ', '(899) 100-1074', '5217 ARGO WAY', 'SACRAMENTO', '38.52718200', '-121.43344800', 1),
(292, 'Summer Sampley ', '(822) 941-6312', '8167 DERBY PARK CT', 'SACRAMENTO', '38.46073100', '-121.37313400', 1),
(293, 'Marybelle Bowling ', '(844) 438-3909', '10949 SCOTSMAN WAY', 'RANCHO CORDOVA', '38.60430700', '-121.27736800', 1),
(294, 'Wan Walcott ', '(855) 709-1205', '5847 DEL CAMPO LN', 'CARMICHAEL', '38.67239500', '-121.32483200', 1),
(295, 'Ta Brookover ', '(811) 306-2505', '4533 LOCH HAVEN WAY', 'SACRAMENTO', '38.67306300', '-121.35948400', 1),
(296, 'Waldo Hand ', '(822) 941-6299', '7044 CARTHY WAY', 'SACRAMENTO', '38.49832100', '-121.42104800', 1),
(297, 'Joette Kuehne ', '(844) 438-3896', '306 CAMELLIA WAY', 'GALT', '38.26067900', '-121.29833500', 1),
(298, 'Nolan Atwell ', '(855) 709-1192', '9186 KINBRACE CT', 'SACRAMENTO', '38.46304600', '-121.35886300', 1),
(299, 'Bettye Mcguffie ', '(844) 456-3325', '2064 EXPEDITION WAY', 'SACRAMENTO', '38.47381800', '-121.49079300', 1),
(300, 'Lillie Pray ', '(855) 164-7857', '6708 PONTA DO SOL WAY', 'ELK GROVE', '38.38042600', '-121.42501000', 1),
(301, 'Brandie Farah ', '(899) 018-0736', '868 HILDEBRAND CIR', 'FOLSOM', '38.67117900', '-121.09792600', 1),
(302, 'Song Otte ', '(811) 862-9672', '3725 DON JULIO BLVD', 'NORTH HIGHLANDS', '38.67913700', '-121.37904900', 1),
(303, 'Siobhan Faye ', '(899) 692-6647', '8116 COTTONMILL CIR', 'SACRAMENTO', '38.48305800', '-121.40630600', 1),
(304, 'Lucinda Honig ', '(899) 486-6857', '4437 MITCHUM CT', 'ANTELOPE', '38.70459100', '-121.36072400', 1),
(305, 'Edwin Ching ', '(855) 165-9599', '5340 BIRK WAY', 'SACRAMENTO', '38.67240280', '-121.51518810', 1),
(306, 'Valencia Latshaw ', '(844) 056-1577', '4236 ADRIATIC SEA WAY', 'SACRAMENTO', '38.64832800', '-121.54301700', 1),
(307, 'Marisol Shane ', '(811) 661-9855', '5405 NECTAR CIR', 'ELK GROVE', '38.38681700', '-121.44127500', 1),
(308, 'Odis Orme ', '(811) 306-2515', '1044 GALSTON DR', 'FOLSOM', '38.67603400', '-121.09914300', 1),
(309, 'Linwood Berry ', '(833) 407-1405', '261 REDONDO AVE', 'SACRAMENTO', '38.62084100', '-121.46075800', 1),
(310, 'Robin Mason ', '(899) 698-6079', '523 EXCHANGE ST', 'SACRAMENTO', '38.65966700', '-121.45377500', 1),
(311, 'Katina Kealey ', '(822) 964-6069', '7032 FAIR OAKS BLVD', 'CARMICHAEL', '38.62892900', '-121.32731600', 1),
(312, 'Annmarie Vigil ', '(844) 481-2330', '7108 HEATHER TREE DR', 'SACRAMENTO', '38.69548000', '-121.35981000', 1),
(313, 'Ward Bromley ', '(844) 633-2363', '6344 LAGUNA MIRAGE LN', 'ELK GROVE', '38.42382200', '-121.42855900', 1),
(314, 'Sid Capito ', '(855) 194-9211', '617 WILLOW CREEK DR', 'FOLSOM', '38.68015300', '-121.14091200', 1),
(315, 'Candance Bowlin ', '(822) 526-4641', '5635 FOXVIEW WAY', 'ELK GROVE', '38.39594300', '-121.43832400', 1),
(316, 'Avelina Ota ', '(899) 100-1061', '7340 HAMDEN PL', 'SACRAMENTO', '38.69992600', '-121.35101800', 1),
(317, 'Edgar Clouser ', '(844) 633-2350', '2442 LARKSPUR LN', 'SACRAMENTO', '38.58460190', '-121.40526600', 1),
(318, 'Lena Velazco ', '(855) 194-9198', '9021 MADISON AVE', 'ORANGEVALE', '38.66444300', '-121.21756100', 1),
(319, 'Shira Lukes ', '(822) 526-4628', '4243 MIDDLEBURY WAY', 'MATHER', '38.54789490', '-121.28028800', 1),
(320, 'Deedee Clancy ', '(822) 399-8962', '2912 NORCADE CIR', 'SACRAMENTO', '38.55986600', '-121.36424800', 1),
(321, 'Hayden Louder ', '(855) 504-9100', '4143 SEA MEADOW WAY', 'SACRAMENTO', '38.46570100', '-121.45730900', 1),
(322, 'Alvera Heckstall ', '(844) 309-4683', '6030 PALERMO WAY', 'EL DORADO HILLS', '38.67296900', '-121.05019900', 1),
(323, 'Byron Beverley ', '(822) 313-3711', '4803 MCCLOUD DR', 'SACRAMENTO', '38.68233600', '-121.35271700', 1),
(324, 'Regina Costas ', '(899) 223-6315', '4660 CEDARWOOD WAY', 'SACRAMENTO', '38.48462900', '-121.44822000', 1),
(325, 'Lavone Shifflett ', '(844) 937-3883', '2778 KAWEAH CT', 'CAMERON PARK', '38.69420100', '-120.99605900', 1),
(326, 'Clara Ammann ', '(822) 966-0529', '51 ANJOU CIR', 'SACRAMENTO', '38.66191900', '-121.54017800', 1),
(327, 'Genna Larimer ', '(899) 954-5813', '8864 REMBRANT CT', 'ELK GROVE', '38.43576700', '-121.37559600', 1),
(328, 'Petronila Mcmurtrie ', '(855) 350-2112', '5411 10TH AVE', 'SACRAMENTO', '38.54292700', '-121.44230400', 1),
(329, 'See Phair ', '(899) 100-1071', '4440 SYCAMORE AVE', 'SACRAMENTO', '38.64596800', '-121.35321700', 1),
(330, 'Kimberlee Loo ', '(822) 941-6309', '4030 BROADWAY', 'SACRAMENTO', '38.54657500', '-121.45978500', 1),
(331, 'Maye Kildow ', '(844) 438-3906', '8101 PORT ROYALE WAY', 'SACRAMENTO', '38.46375260', '-121.43854090', 1),
(332, 'Lizbeth Kono ', '(855) 709-1202', '2421 SANTINA WAY', 'ELVERTA', '38.71887200', '-121.40676800', 1),
(333, 'Vivien Mullenax ', '(844) 456-3335', '2956 DAVENPORT WAY', 'SACRAMENTO', '38.62075400', '-121.48239400', 1),
(334, 'Emmaline Tippett ', '(855) 164-7867', '2945 RED HAWK WAY', 'SACRAMENTO', '38.61993100', '-121.49717100', 1),
(335, 'Roxanna Schneck ', '(899) 018-0746', '3301 PARK DR Unit 1914', 'SACRAMENTO', '38.66418600', '-121.52984200', 1),
(336, 'Dwight Risser ', '(811) 862-9682', '10372 VIA CINTA CT', 'ELK GROVE', '38.38020300', '-121.42843200', 1),
(337, 'Yolonda Grissett ', '(844) 481-2317', '6715 6TH ST', 'RIO LINDA', '38.68989800', '-121.45257900', 1),
(338, 'Shawnta Ohern ', '(855) 164-7854', '4800 WESTLAKE PKWY Unit 2109', 'SACRAMENTO', '38.65858800', '-121.54210370', 1),
(339, 'Fletcher Tunnell ', '(899) 018-0733', '404 6TH ST', 'GALT', '38.25153400', '-121.30278900', 1),
(340, 'Dotty Wurtz ', '(811) 862-9669', '1028 FALLON PLACE CT', 'RIO LINDA', '38.69361800', '-121.44138000', 1),
(341, 'Karena Pepe ', '(899) 692-6644', '9507 SEA CLIFF WAY', 'ELK GROVE', '38.41079500', '-121.47918800', 1),
(342, 'Soila Pancoast ', '(899) 486-6854', '3020 RICHARDSON CIR', 'EL DORADO HILLS', '38.69093190', '-121.08192700', 1),
(343, 'Tami Monroe ', '(855) 165-9596', '4070 REDONDO DR', 'EL DORADO HILLS', '38.66636100', '-121.06499100', 1),
(344, 'David Cella ', '(844) 056-1574', '10542 SILVERWOOD WAY', 'RANCHO CORDOVA', '38.58709700', '-121.29486800', 1),
(345, 'Donnetta Larrabee ', '(811) 661-9852', '9254 HARROGATE WAY', 'ELK GROVE', '38.41975400', '-121.41187900', 1),
(346, 'Johanna Edenfield ', '(811) 306-2512', '1636 ALLENWOOD CIR', 'LINCOLN', '38.87987800', '-121.30916500', 1),
(347, 'Kaylene Collelo ', '(833) 407-1402', '2125 22ND AVE', 'SACRAMENTO', '38.53473100', '-121.49259000', 1),
(348, 'Janett Brandi ', '(899) 698-6076', '9455 SEA CLIFF WAY', 'ELK GROVE', '38.41140100', '-121.48161900', 1),
(349, 'Charis Bodden ', '(822) 964-6066', '3512 RAINSONG CIR', 'RANCHO CORDOVA', '38.57371890', '-121.28273900', 1),
(350, 'Maurita Schaner ', '(844) 481-2327', '1032 SOUZA DR', 'EL DORADO HILLS', '38.66866600', '-121.06435300', 1),
(351, 'Delphia Zellars ', '(844) 633-2360', '3660 22ND AVE', 'SACRAMENTO', '38.53248100', '-121.46704200', 1),
(352, 'Catherin Lafuente ', '(855) 194-9208', '8020 WALERGA RD', 'ANTELOPE', '38.71433800', '-121.36340100', 1),
(353, 'Eufemia Luppino ', '(822) 526-4638', '2368 CRAIG AVE', 'SACRAMENTO', '38.47784500', '-121.48108400', 1),
(354, 'Nettie Mani ', '(822) 399-8972', '10062 LINCOLN VILLAGE DR', 'SACRAMENTO', '38.56380500', '-121.31987700', 1),
(355, 'Pok Rhoda ', '(855) 504-9110', '3228 I ST', 'SACRAMENTO', '38.57373150', '-121.46245770', 1),
(356, 'Layla Engelking ', '(844) 309-4693', '709 CIMMARON CT', 'GALT', '38.27740900', '-121.30416100', 1),
(357, 'Ivette Rushin ', '(822) 313-3721', '6286 LONETREE BLVD', 'ROCKLIN', '38.80761330', '-121.29465520', 1),
(358, 'Marna Storch ', '(844) 456-3322', '6236 LONGFORD DR Unit 1', 'CITRUS HEIGHTS', '38.67996400', '-121.31378600', 1),
(359, 'Latisha Probst ', '(855) 504-9097', '2178 63RD AVE', 'SACRAMENTO', '38.49376400', '-121.48859200', 1),
(360, 'Avril Crow ', '(844) 309-4680', '8317 SUNNY CREEK WAY', 'SACRAMENTO', '38.45860800', '-121.42441300', 1),
(361, 'Shay Hullett ', '(822) 313-3708', '4804 NORIKER DR', 'ELK GROVE', '38.40077800', '-121.44817200', 1),
(362, 'Leatrice Haston ', '(899) 223-6312', '8882 AUTUMN GOLD CT', 'ELK GROVE', '38.44368800', '-121.37270400', 1),
(363, 'Tamisha Hackbarth ', '(844) 937-3880', '8082 LINDA ISLE LN', 'SACRAMENTO', '38.47823390', '-121.52172370', 1),
(364, 'Enrique Straus ', '(822) 966-0526', '4004 CRESTA WAY', 'SACRAMENTO', '38.59147700', '-121.37015700', 1),
(365, 'Kaye Sweatt ', '(899) 954-5810', '6318 39TH AVE', 'SACRAMENTO', '38.51873800', '-121.42954700', 1),
(366, 'Beulah Nolf ', '(855) 350-2109', '6716 TAREYTON WAY', 'CITRUS HEIGHTS', '38.69376900', '-121.30781400', 1),
(367, 'Trevor Hollingshead ', '(899) 100-1068', '8151 QUAIL RIDGE CT', 'SACRAMENTO', '38.46201800', '-121.39072300', 1),
(368, 'Gladys Wellborn ', '(822) 941-6306', '611 BLOSSOM ROCK LN', 'FOLSOM', '38.64428300', '-121.15240100', 1),
(369, 'Mercedes Ihle ', '(844) 438-3903', '9720 LITTLE HARBOR WAY', 'ELK GROVE', '38.40388300', '-121.35262900', 1),
(370, 'Sterling Lambdin ', '(855) 709-1199', '1106 55TH ST', 'SACRAMENTO', '38.56369200', '-121.43686700', 1),
(371, 'Teresa Pate ', '(844) 456-3332', '9760 LAZULITE CT', 'ELK GROVE', '38.40343100', '-121.33588700', 1),
(372, 'Randell Holleman ', '(855) 164-7864', '3924 HIGH ST', 'SACRAMENTO', '38.63932400', '-121.43475100', 1),
(373, 'Von Fleischmann ', '(899) 018-0743', '167 VALLEY OAK DR', 'ROSEVILLE', '38.73201300', '-121.28791100', 1),
(374, 'Patria Winger ', '(811) 862-9679', '2123 AMANDA WAY', 'SACRAMENTO', '38.48544400', '-121.48662700', 1),
(375, 'Darren Eddy ', '(899) 692-6654', '332 PALIN AVE', 'GALT', '38.26112500', '-121.30295000', 1),
(376, 'Denna Mayer ', '(899) 486-6864', '308 ATKINSON ST', 'ROSEVILLE', '38.74765690', '-121.29998800', 1),
(377, 'Walton Mcneese ', '(855) 165-9606', '3305 RIO ROCA CT', 'ANTELOPE', '38.72526900', '-121.38737700', 1),
(378, 'Everette Hubbert ', '(844) 056-1584', '7744 SOUTHBREEZE DR', 'SACRAMENTO', '38.47701900', '-121.37865100', 1),
(379, 'Tonia Noel ', '(822) 399-8959', '250 PERALTA AVE', 'SACRAMENTO', '38.61185300', '-121.46954400', 1),
(380, 'Debroah Mcclintic ', '(899) 486-6851', '8718 ELK WAY', 'ELK GROVE', '38.41634700', '-121.37981000', 1),
(381, 'Siobhan Knobel ', '(855) 165-9593', '2617 BASS CT', 'SACRAMENTO', '38.56005700', '-121.37733300', 1),
(382, 'Raeann Imhoff ', '(844) 056-1571', '7713 HARVEST WOODS DR', 'SACRAMENTO', '38.47779300', '-121.41267100', 1),
(383, 'Kristle Vogl ', '(811) 661-9849', '5322 WHITE LOTUS WAY', 'ELK GROVE', '38.39068300', '-121.44284800', 1),
(384, 'Aileen Cipriani ', '(811) 306-2509', '15300 MURIETA SOUTH PKWY', 'RANCHO MURIETA', '38.48724700', '-121.07481300', 1),
(385, 'Myra Mansir ', '(833) 407-1399', '315 JUMEL CT', 'EL DORADO HILLS', '38.67028400', '-121.05923900', 1),
(386, 'Trish Goyette ', '(899) 698-6073', '211 MCDANIEL CIR', 'SACRAMENTO', '38.63636500', '-121.46034400', 1),
(387, 'Lanny Degennaro ', '(822) 964-6063', '2028 ROBERT WAY', 'SACRAMENTO', '38.60973500', '-121.41841900', 1),
(388, 'Rodger Dunbar ', '(844) 481-2324', '4899 WIND CREEK DR', 'SACRAMENTO', '38.65566590', '-121.44619500', 1),
(389, 'Kandi Puentes ', '(844) 633-2357', '8830 ADUR RD', 'ELK GROVE', '38.43733200', '-121.37292500', 1),
(390, 'Tran Godard ', '(855) 194-9205', '8806 PHOENIX AVE', 'FAIR OAKS', '38.66005500', '-121.22982700', 1),
(391, 'Mallory Calhoon ', '(822) 526-4635', '411 ILLSLEY WAY', 'FOLSOM', '38.65311000', '-121.12991100', 1),
(392, 'Tony Yip ', '(822) 399-8969', '241 LANFRANCO CIR', 'SACRAMENTO', '38.66597000', '-121.54917500', 1),
(393, 'Miriam Mazzariello ', '(855) 504-9107', '4734 14TH AVE', 'SACRAMENTO', '38.53918500', '-121.45100000', 1),
(394, 'Soraya Crowder ', '(844) 309-4690', '7876 BURLINGTON WAY', 'SACRAMENTO', '38.47039100', '-121.46762600', 1),
(395, 'Ester Villines ', '(822) 313-3718', '7620 DARLA WAY', 'SACRAMENTO', '38.47868200', '-121.40349600', 1),
(396, 'Morris Regnier ', '(899) 223-6322', '4649 FREEWAY CIR', 'SACRAMENTO', '38.65847100', '-121.35666400', 1),
(397, 'Zelma Lang ', '(844) 937-3890', '624 HOVEY WAY', 'ROSEVILLE', '38.75635700', '-121.30666300', 1),
(398, 'Rocky Keesee ', '(822) 966-0536', '9080 BEDROCK CT', 'SACRAMENTO', '38.45675500', '-121.36328300', 1),
(399, 'Telma Belmonte ', '(899) 954-5820', '2242 ABLE WAY', 'SACRAMENTO', '38.66588500', '-121.50980600', 1),
(400, 'Haley Hayworth ', '(844) 056-1575', '3228 BAGGAN CT', 'ANTELOPE', '38.71513300', '-121.38835400', 1),
(401, 'TESLA DUKE', '(916) 278-3625', '6000 J Street ;Sacramento', 'CA', '38.56349010', '-121.42816920', 1),
(402, 'Vinay Tablet', '(916) 278-3625', 'H-483, Adharshila East Block Extension, Avinash Nagar', 'Madhya Pradesh', '23.21879160', '77.48835880', 1),
(403, 'Registrar', '(916) 278-3625', '6000 J Street, Sacramento', 'California', '38.56349010', '-121.42816920', 1),
(404, 'Jennette Baugh ', '(855) 709-1190', '3729 BAINBRIDGE DR', 'NORTH HIGHLANDS', '38.70174600', '-121.37642200', 1);
-- --------------------------------------------------------
--
-- Table structure for table `sosmain`
--
CREATE TABLE IF NOT EXISTS `sosmain` (
`sosmain_id` int(11) NOT NULL AUTO_INCREMENT,
`task_id` int(11) DEFAULT NULL,
`original_user` int(11) DEFAULT NULL,
`starttime` datetime DEFAULT NULL,
`status` tinyint(4) DEFAULT '0' COMMENT '0: in process, 1: process finished ',
`endtime` datetime DEFAULT NULL,
`process_user` int(11) DEFAULT NULL,
PRIMARY KEY (`sosmain_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
--
-- Dumping data for table `sosmain`
--
INSERT INTO `sosmain` (`sosmain_id`, `task_id`, `original_user`, `starttime`, `status`, `endtime`, `process_user`) VALUES
(11, 358, 25, '2016-01-11 12:03:36', 1, '2016-01-14 09:31:01', 26),
(12, 783, 26, '2016-01-14 08:31:03', 2, '2016-01-14 09:31:01', NULL),
(13, 805, 30, '2016-01-15 07:42:12', 2, '2016-01-15 07:48:04', NULL),
(14, 807, 30, '2016-01-15 08:35:47', 2, '2016-01-15 08:41:01', NULL),
(15, 808, 32, '2016-01-15 08:50:55', 1, '2016-01-15 08:51:58', 30),
(16, 810, 30, '2016-01-28 17:42:59', 2, '2016-01-28 17:48:01', NULL),
(17, 826, 8, '2016-03-26 08:23:10', 2, '2016-03-26 08:23:39', NULL),
(18, 829, 8, '2016-03-30 02:34:00', 2, '2016-03-30 02:35:28', NULL),
(19, 830, 8, '2016-04-04 02:22:19', 2, '2016-04-04 02:28:01', NULL),
(20, 831, 8, '2016-04-04 02:36:12', 2, '2016-04-04 02:42:01', NULL),
(21, 148, 15, '2016-04-04 19:01:02', 2, '2016-04-04 19:07:01', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `sosresponse`
--
CREATE TABLE IF NOT EXISTS `sosresponse` (
`sosresponse_id` int(11) NOT NULL AUTO_INCREMENT,
`sosmain_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`response` tinyint(4) DEFAULT '0' COMMENT '0: No, 1: Yes',
`responsetime` datetime DEFAULT NULL,
`userlocation` varchar(256) DEFAULT NULL,
PRIMARY KEY (`sosresponse_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `sosresponse`
--
INSERT INTO `sosresponse` (`sosresponse_id`, `sosmain_id`, `user_id`, `response`, `responsetime`, `userlocation`) VALUES
(5, 11, 26, 1, NULL, 'Unnamed Road, Adharshila East Block Extension, Avinash Nagar, Bhopal, Madhya Pradesh 462022, India'),
(6, 15, 30, 1, '2016-01-15 08:51:10', 'Unnamed Road, Adharshila East Block Extension, Avinash Nagar, Bhopal, Madhya Pradesh 462022, India');
-- --------------------------------------------------------
--
-- Table structure for table `supervisor`
--
CREATE TABLE IF NOT EXISTS `supervisor` (
`supervisor_id` int(11) NOT NULL AUTO_INCREMENT,
`supervisor_name` varchar(100) NOT NULL,
`supervisor_password` text NOT NULL,
`department` varchar(40) NOT NULL,
`teamsize` varchar(20) NOT NULL,
`email` varchar(100) DEFAULT NULL,
`home_phone` varchar(15) DEFAULT NULL,
`office_phone` varchar(15) DEFAULT NULL,
`mobile_phone` varchar(15) NOT NULL,
`address` text NOT NULL,
`region` varchar(40) NOT NULL,
`company_id` int(11) NOT NULL,
`regdate` datetime DEFAULT NULL,
`verifyemail` int(11) NOT NULL DEFAULT '0',
`verifytoken` varchar(100) NOT NULL,
`profileimage` varchar(200) DEFAULT NULL,
PRIMARY KEY (`supervisor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `supervisor`
--
INSERT INTO `supervisor` (`supervisor_id`, `supervisor_name`, `supervisor_password`, `department`, `teamsize`, `email`, `home_phone`, `office_phone`, `mobile_phone`, `address`, `region`, `company_id`, `regdate`, `verifyemail`, `verifytoken`, `profileimage`) VALUES
(4, 'Test supervisor1', 'fa585d89c851dd338a70dcf535aa2a92fee7836dd6aff1226583e88e0996293f16bc009c652826e0fc5c706695a03cddce372f139eff4d13959da6f1f5d3eabe', 'Test dep', '10', '[email protected]', '123456789', '123456789', '123', 'address 1', '', 1, '2015-11-28 04:35:25', 1, '', ''),
(5, 'Test supervisor2', '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2', 'Test dep 1', '20', '[email protected]', '123456789', '123456789', '123', 'address 2', '', 1, '2015-11-28 04:35:25', 1, '', ''),
(6, 'Test supervisor3', '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2', 'Test dep 2', '30', '[email protected]', '123456789', '123456789', '213', 'address 3', '', 1, '2015-11-28 04:35:25', 1, '', ''),
(7, 'Satyajeet Pradhaan', 'f13511789db235e334f3248d790f93f12e9266c5c104b51cdd97611912f89495e5ed78e5979607787b00e82a354063f7b053a9fbbb9243bf005fabd3c28a8c48', 'Delivery', '20', '[email protected]', '9407523773', '9407523773', '9407523773', 'H-557, Aadharshila East Block, Awadhpuri, Bhopal', '', 0, '2015-12-26 01:22:36', 1, 'f492ee8b93cadcadd6a1cb2e57b1aead', '');
-- --------------------------------------------------------
--
-- Table structure for table `supervisor_user_rel`
--
CREATE TABLE IF NOT EXISTS `supervisor_user_rel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`supervisor_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
--
-- Dumping data for table `supervisor_user_rel`
--
INSERT INTO `supervisor_user_rel` (`id`, `supervisor_id`, `user_id`) VALUES
(1, 4, 8),
(2, 4, 9),
(3, 4, 10),
(4, 4, 11),
(5, 4, 12),
(6, 4, 13),
(7, 4, 14),
(8, 5, 15),
(9, 5, 16),
(10, 5, 17),
(11, 5, 18),
(12, 5, 19),
(13, 5, 20),
(14, 5, 21),
(15, 6, 22),
(16, 6, 23),
(17, 6, 24),
(18, 6, 25),
(19, 6, 26),
(20, 6, 27),
(21, 6, 28),
(22, 7, 28),
(24, 4, 30),
(25, 7, 31),
(26, 4, 32);
-- --------------------------------------------------------
--
-- Table structure for table `task`
--
CREATE TABLE IF NOT EXISTS `task` (
`SOS_STATUS` enum('Yes','No') NOT NULL DEFAULT 'No',
`task_id` int(11) NOT NULL AUTO_INCREMENT,
`TasktypeCategory` enum('INSTALL','DELIVERY','REPAIR','COLLECT','CONSTRUCT','SALES') NOT NULL,
`creation_date` datetime NOT NULL,
`update_date` datetime DEFAULT NULL,
`contact_name` varchar(40) NOT NULL,
`contact_address` varchar(100) NOT NULL,
`contact_phone` varchar(15) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`scheduled_Start` datetime DEFAULT NULL,
`scheduled_End` datetime DEFAULT NULL,
`actual_Start` datetime DEFAULT NULL,
`actual_end` datetime DEFAULT NULL,
`task_Status` enum('CREATED','PENDSCHEDULE','INPROGRESS','DELAYED','RESCHEDULED','COMPLETED','CANCELLED') DEFAULT 'CREATED',
`task_lat` decimal(10,8) DEFAULT NULL,
`task_long` decimal(11,8) DEFAULT NULL,
`Region` varchar(40) DEFAULT NULL,
`postcode` varchar(10) NOT NULL,
`country` varchar(20) NOT NULL,
`is_rescheduled` enum('Yes','No') NOT NULL DEFAULT 'Yes',
`company_id` int(11) NOT NULL,
`notes` text,
PRIMARY KEY (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=841 ;
--
-- Dumping data for table `task`
--
INSERT INTO `task` (`SOS_STATUS`, `task_id`, `TasktypeCategory`, `creation_date`, `update_date`, `contact_name`, `contact_address`, `contact_phone`, `user_id`, `scheduled_Start`, `scheduled_End`, `actual_Start`, `actual_end`, `task_Status`, `task_lat`, `task_long`, `Region`, `postcode`, `country`, `is_rescheduled`, `company_id`, `notes`) VALUES
('No', 22, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Odessa Plumlee ', '51 OMAHA CT', '(844) 438-3894', 9, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, '2015-12-23 08:34:19', 'COMPLETED', '38.47997010', '-121.43112500', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 23, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Starr Overly ', '3828 BLACKFOOT WAY', '(822) 526-4626', 9, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, '2015-12-23 08:34:54', 'COMPLETED', '38.70940700', '-121.37364500', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 24, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Carmelina Borja ', '3820 NATOMA WAY', '(822) 399-8960', 9, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, '2015-12-23 08:35:10', 'COMPLETED', '38.63736800', '-121.42184500', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 25, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Ernestina Tamashiro ', '120 GRANT LN', '(855) 504-9098', 9, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, '2015-12-23 08:35:29', 'COMPLETED', '38.68819700', '-121.17125800', 'FOLSOM', '95630', 'US', 'Yes', 1, NULL),
('No', 26, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Bret Sheth ', '4010 ALEX LN', '(844) 309-4681', 9, '2015-12-02 06:00:00', '2015-12-02 09:00:00', '2015-12-23 09:33:37', '2015-12-23 09:33:43', 'COMPLETED', '38.63708590', '-121.31259900', 'CARMICHAEL', '95608', 'US', 'Yes', 1, NULL),
('No', 27, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Rossie Gillogly ', '4727 SAVOIE WAY', '(822) 313-3709', 9, '2015-12-02 09:00:00', '2015-12-02 12:00:00', '2015-12-23 09:33:54', '2015-12-23 10:47:27', 'COMPLETED', '38.65830100', '-121.54977400', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 28, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Luci Dallman ', '1300 F ST', '(899) 223-6313', 9, '2015-12-02 12:00:00', '2015-12-02 15:00:00', '2015-12-23 10:47:54', '2015-12-27 23:18:44', 'CANCELLED', '38.58333300', '-121.48717500', 'SACRAMENTO', '95814', 'US', 'Yes', 1, NULL),
('No', 29, 'COLLECT', '2015-11-29 18:04:44', NULL, 'Nikia Gang ', '6112 HERMOSA ST', '(844) 937-3881', 9, '2015-12-03 03:00:00', '2015-12-02 07:00:00', '2016-02-01 12:25:25', NULL, 'RESCHEDULED', '38.51475090', '-121.48076300', 'SACRAMENTO', '95822', 'US', 'Yes', 1, ''),
('No', 30, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Nan Looby ', '648 SANTA ANA AVE', '(822) 966-0527', 9, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.65818100', '-121.45038500', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 31, 'COLLECT', '2015-11-29 18:04:44', NULL, 'Bella Brenton ', '8515 DARTFORD DR', '(899) 954-5811', 9, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.44843300', '-121.42044300', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 32, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Cassaundra Miah ', '5805 HIMALAYA WAY', '(855) 350-2110', 9, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.69668300', '-121.32810600', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 33, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Charissa Glaspie ', '6900 LONICERA DR', '(899) 100-1069', 9, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.69151200', '-121.25075800', 'ORANGEVALE', '95662', 'US', 'Yes', 1, NULL),
('No', 34, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Floy Homan ', '1102 CHESLEY LN', '(822) 941-6307', 9, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.86474000', '-121.31424900', 'LINCOLN', '95648', 'US', 'Yes', 1, NULL),
('No', 35, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Walter Savory ', '9688 NATURE TRAIL WAY', '(844) 438-3904', 9, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.40549690', '-121.47922200', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 36, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Leandro Juntunen ', '201 FIRESTONE DR', '(855) 709-1200', 9, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.77024690', '-121.29993040', 'ROSEVILLE', '95678', 'US', 'Yes', 1, NULL),
('No', 37, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Raylene Ziemer ', '7109 CHANDLER DR', '(844) 456-3333', 9, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.49683300', '-121.42373000', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 38, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Lurlene Melby ', '5380 VILLAGE WOOD DR', '(855) 164-7865', 9, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.45472100', '-121.44008000', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 39, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Alisa Horton ', '1223 LAMBERTON CIR', '(899) 018-0744', 9, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.64688000', '-121.43723400', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 40, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Erika Loso ', '1347 HIDALGO CIR', '(811) 862-9680', 9, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.74764800', '-121.31218000', 'ROSEVILLE', '95747', 'US', 'Yes', 1, NULL),
('No', 41, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Emerita Freer ', '913 COBDEN CT', '(899) 692-6655', 9, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.28235800', '-121.29566400', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 42, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Laura Tagle ', '77 RINETTI WAY', '(899) 486-6865', 9, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.68720500', '-121.46287800', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 43, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Sharita Manna ', '2796 BRANCH ST', '(855) 194-9196', 10, '2015-12-01 06:00:00', '2015-12-01 09:00:00', '2015-12-27 23:43:10', '2015-12-27 23:43:16', 'COMPLETED', '38.61820800', '-121.44357900', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 44, 'INSTALL', '2015-11-29 18:04:44', NULL, 'Lula Parm ', '4108 NORTON WAY', '(811) 862-9667', 10, '2015-12-01 09:00:00', '2015-12-01 12:00:00', '2015-12-27 23:43:22', NULL, 'DELAYED', '38.53725300', '-121.47857500', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 45, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Stevie Leathers ', '4431 GREEN TREE DR', '(899) 692-6642', 10, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.50014300', '-121.45418100', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 46, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Karly Pavelka ', '5907 ELLERSLEE DR', '(899) 486-6852', 10, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.66467400', '-121.32664900', 'CARMICHAEL', '95608', 'US', 'Yes', 1, NULL),
('No', 47, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Kylie Wieck ', '4901 MILLNER WAY', '(855) 165-9594', 10, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.38710800', '-121.44784300', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 48, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Lisa Gallimore ', '8664 MAGNOLIA HILL WAY', '(844) 056-1572', 10, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.44275400', '-121.38992100', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('No', 49, 'COLLECT', '2015-11-29 18:04:45', NULL, 'Dagmar Andrew ', '6801 RAWLEY WAY', '(811) 661-9850', 10, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.40856600', '-121.42418700', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 50, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Clayton Kravetz ', '483 ARCADE BLVD', '(811) 306-2510', 10, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.62373400', '-121.45509000', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 51, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Armida Petitt ', '14 ASHLEY OAKS CT', '(833) 407-1400', 10, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.61758700', '-121.43625300', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 52, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Lorine Cutshall ', '4500 TIPPWOOD WAY', '(899) 698-6074', 10, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.69931400', '-121.35979600', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 53, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Dahlia Balliet ', '7944 SYLVAN OAK WAY', '(822) 964-6064', 10, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.71120700', '-121.26088300', 'CITRUS HEIGHTS', '95610', 'US', 'Yes', 1, NULL),
('No', 54, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Charlesetta Rocha ', '419 DAWNRIDGE RD', '(844) 481-2325', 10, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.72504100', '-121.29834600', 'ROSEVILLE', '95678', 'US', 'Yes', 1, NULL),
('No', 55, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Tiffanie Ayers ', '11281 STANFORD COURT LN Unit 604', '(844) 633-2358', 10, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.62531000', '-121.26106000', 'GOLD RIVER', '95670', 'US', 'Yes', 1, NULL),
('No', 56, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Kimberlie Dudney ', '5924 TANUS CIR', '(855) 194-9206', 10, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.77842290', '-121.20449200', 'ROCKLIN', '95677', 'US', 'Yes', 1, NULL),
('No', 57, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Gertrud Winzer ', '1740 HIGH ST', '(822) 526-4636', 10, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.89242800', '-121.08336400', 'AUBURN', '95603', 'US', 'Yes', 1, NULL),
('No', 58, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Fae Homan ', '7541 SKELTON WAY', '(822) 399-8970', 10, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.48467200', '-121.48859000', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 59, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Louanne Luton ', '2621 EVERGREEN ST', '(855) 504-9108', 10, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.61324100', '-121.44467300', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 60, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Trinh Picklesimer ', '1223 LAMBERTON CIR', '(844) 309-4691', 10, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.64688000', '-121.43723400', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 61, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Maile Holloway ', '212 CAPPUCINO WAY', '(822) 313-3719', 10, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.65758500', '-121.46533400', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 62, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Natividad Preuss ', '4419 79TH ST', '(899) 223-6323', 10, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.53499600', '-121.41230000', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 63, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Laurie Halderman ', '1316 I ST', '(844) 937-3891', 10, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.68337600', '-121.43532700', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 64, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Kassandra Wedel ', '2805 JANETTE WAY', '(899) 018-0731', 11, '2015-12-01 06:00:00', '2015-12-01 09:00:00', '2016-01-28 12:40:39', '2016-01-29 02:45:30', 'CANCELLED', '38.61710900', '-121.43922900', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 65, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Sina Ballou ', '1469 JANRICK AVE', '(822) 313-3706', 11, '2015-12-01 09:00:00', '2015-12-01 12:00:00', '2016-01-29 04:45:13', NULL, 'DELAYED', '38.47596100', '-121.50190100', 'SACRAMENTO', '95832', 'US', 'Yes', 1, NULL),
('No', 66, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Earlean Peck ', '9417 SARA ST', '(899) 223-6310', 11, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.41549800', '-121.37031500', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('No', 67, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Noella Blodgett ', '17 SERASPI CT', '(844) 937-3878', 11, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.63149090', '-121.50236800', 'SACRAMENTO', '95834', 'US', 'Yes', 1, NULL),
('No', 68, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Veta Sanor ', '4818 BRITTNEY LEE CT', '(822) 966-0524', 11, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.65411900', '-121.34207700', 'SACRAMENTO', '95841', 'US', 'Yes', 1, NULL),
('No', 69, 'INSTALL', '2015-11-29 18:04:45', NULL, 'Jerica Rocco ', '9570 HARVEST ROSE WAY', '(899) 954-5808', 11, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.55575500', '-121.34062800', 'SACRAMENTO', '95827', 'US', 'Yes', 1, NULL),
('No', 70, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Delinda Groat ', '1693 SHELTER COVE DR', '(855) 350-2107', 11, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.94581400', '-120.90717100', 'GREENWOOD', '95635', 'US', 'Yes', 1, NULL),
('No', 71, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Shanae Stanbery ', '671 SONOMA AVE', '(899) 100-1066', 11, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.62321300', '-121.44990500', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 72, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Shayne Stagner ', '3174 NORTHVIEW DR', '(822) 941-6304', 11, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.62371600', '-121.47754400', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 73, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Alisha Anger ', '2460 EL ROCCO WAY', '(844) 438-3901', 11, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.59115500', '-121.31603500', 'RANCHO CORDOVA', '95670', 'US', 'Yes', 1, NULL),
('No', 74, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Chelsie Grandstaff ', '3139 SPOONWOOD WAY Unit 1', '(855) 709-1197', 11, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.62673800', '-121.52167400', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 75, 'INSTALL', '2015-11-29 18:04:46', NULL, 'So Scianna ', '5312 MARBURY WAY', '(844) 456-3330', 11, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.71001800', '-121.34076400', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 76, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Cuc Lichtenberger ', '7320 6TH ST', '(855) 164-7862', 11, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.70073900', '-121.45158500', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 77, 'COLLECT', '2015-11-29 18:04:46', NULL, 'Graig Cassel ', '9629 CEDAR OAK WAY', '(899) 018-0741', 11, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.40534490', '-121.43139400', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 78, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Zula Vierling ', '2733 DANA LOOP', '(811) 862-9677', 11, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.62838000', '-121.05462800', 'EL DORADO HILLS', '95762', 'US', 'Yes', 1, NULL),
('No', 79, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Jeremiah Wilczynski ', '9058 MONTOYA ST', '(899) 692-6652', 11, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.55893720', '-121.36793390', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 80, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Tandra Johnstone ', '201 CARLO CT', '(899) 486-6862', 11, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.24252500', '-121.31053600', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 81, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Natalia Hollingworth ', '6000 BIRCHGLADE WAY', '(855) 165-9604', 11, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.70151400', '-121.32266500', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 82, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Tiffiny Ulibarri ', '5938 WOODBRIAR WAY', '(844) 056-1582', 11, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.70587800', '-121.32459300', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 83, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Sona Laforest ', '3012 SPOONWOOD WAY', '(811) 661-9860', 11, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.62465500', '-121.52331700', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 84, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Marsha Cochrane ', '2130 CATHERWOOD WAY', '(811) 306-2520', 11, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.67529400', '-121.51124600', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 85, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Felicidad Atwater ', '6001 MCMAHON DR', '(844) 309-4678', 12, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.51969900', '-121.43559900', 'SACRAMENTO', '95824', 'US', 'Yes', 1, NULL),
('No', 86, 'DELIVERY', '2015-11-29 18:04:46', NULL, 'Leopoldo Laramie ', '9861 CULP WAY', '(844) 056-1569', 12, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.55864900', '-121.32752700', 'SACRAMENTO', '95827', 'US', 'Yes', 1, NULL),
('No', 87, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Jenette Rudd ', '8299 HALBRITE WAY', '(811) 661-9847', 12, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.47403300', '-121.40022800', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 88, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Angeles Englehart ', '170 PENHOW CIR', '(811) 306-2507', 12, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.65345900', '-121.53536000', 'SACRAMENTO', '95834', 'US', 'Yes', 1, NULL),
('No', 89, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Florence Kulp ', '5529 LAGUNA PARK DR', '(833) 407-1397', 12, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.42597900', '-121.43777900', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 90, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Taisha Alldredge ', '4359 CREGAN CT', '(899) 698-6071', 12, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.54540700', '-121.22462100', 'RANCHO CORDOVA', '95742', 'US', 'Yes', 1, NULL),
('No', 91, 'REPAIR', '2015-11-29 18:04:46', NULL, 'Karolyn Hartwick ', '9361 WADDELL LN', '(822) 964-6061', 12, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.45102700', '-121.34980300', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('No', 92, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Christene Lofland ', '5980 79TH ST', '(844) 481-2322', 12, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.51833900', '-121.41207200', 'SACRAMENTO', '95824', 'US', 'Yes', 1, NULL),
('No', 93, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Margene Damore ', '840 TRANQUIL LN', '(844) 633-2355', 12, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.27051400', '-121.29927900', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 94, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Shantelle Cornforth ', '8244 SUNBIRD WAY', '(855) 194-9203', 12, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.45816500', '-121.43161300', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 95, 'COLLECT', '2015-11-29 18:04:46', NULL, 'Basil Hilburn ', '6217 LEOLA WAY', '(822) 526-4633', 12, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.51241460', '-121.45168760', 'SACRAMENTO', '95824', 'US', 'Yes', 1, NULL),
('No', 96, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Elidia Hogg ', '6344 BONHAM CIR', '(822) 399-8967', 12, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.68219700', '-121.27288600', 'CITRUS HEIGHTS', '95610', 'US', 'Yes', 1, NULL),
('No', 97, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Phillis Richie ', '993 MANTON CT', '(855) 504-9105', 12, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.27306900', '-121.28948600', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 98, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Kari Mccarville ', '3429 FERNBROOK CT', '(844) 309-4688', 12, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.66433390', '-121.00762900', 'CAMERON PARK', '95682', 'US', 'Yes', 1, NULL),
('No', 99, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Britt Digiacomo ', '9741 SADDLEBRED CT', '(822) 313-3716', 12, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.40771800', '-121.19804200', 'WILTON', '95693', 'US', 'Yes', 1, NULL),
('No', 100, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Ernestine Lafollette ', '1016 CONGRESS AVE', '(899) 223-6320', 12, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.62998600', '-121.44270710', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 101, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Fawn Peavler ', '6743 21ST ST', '(844) 937-3888', 12, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.50398700', '-121.49040900', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 102, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Kyla Forsgren ', '7204 THOMAS DR', '(822) 966-0534', 12, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.69806000', '-121.37732200', 'NORTH HIGHLANDS', '95660', 'US', 'Yes', 1, NULL),
('No', 103, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Sueann Gigliotti ', '3801 WILDROSE WAY', '(899) 954-5818', 12, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.54422400', '-121.36968500', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 104, 'COLLECT', '2015-11-29 18:04:46', NULL, 'Nelda Rothstein ', '8728 CRYSTAL RIVER WAY', '(855) 350-2117', 12, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.47529700', '-121.37954000', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 105, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Tula Hallum ', '8304 JUGLANS DR', '(899) 100-1076', 12, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.69169100', '-121.24864800', 'ORANGEVALE', '95662', 'US', 'Yes', 1, NULL),
('No', 106, '', '2015-11-29 18:04:46', NULL, 'Marti Fines ', '5828 PEPPERMILL CT', '(855) 165-9591', 13, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.66206900', '-121.32838300', 'SACRAMENTO', '95841', 'US', 'Yes', 1, NULL),
('No', 107, 'INSTALL', '2015-11-29 18:04:46', NULL, 'Nelida Lippard ', '7825 CREEK VALLEY CIR', '(899) 954-5805', 13, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.47247300', '-121.40393100', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 108, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Jaimee Lenox ', '7223 KALLIE KAY LN', '(855) 350-2104', 13, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.47784800', '-121.41918600', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 109, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Austin Lebaron ', '8345 STAR THISTLE WAY', '(899) 100-1063', 13, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.45476690', '-121.43899200', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 110, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Kasandra Moler ', '230 CANDELA CIR', '(822) 941-6301', 13, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.65592800', '-121.54755400', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 111, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Suellen Privette ', '5337 DUSTY ROSE WAY', '(844) 438-3898', 13, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.52879000', '-121.22946500', 'RANCHO CORDOVA', '95742', 'US', 'Yes', 1, NULL),
('No', 112, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Wilbur Keenan ', '10 SEA FOAM CT', '(855) 709-1194', 13, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.48719300', '-121.54575500', 'SACRAMENTO', '95831', 'US', 'Yes', 1, NULL),
('No', 113, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Delcie Everly ', '7607 ELDER CREEK RD', '(844) 456-3327', 13, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.51086200', '-121.41471000', 'SACRAMENTO', '95824', 'US', 'Yes', 1, NULL),
('No', 114, 'REPAIR', '2015-11-29 18:04:47', NULL, 'Larraine Heiss ', '5333 PRIMROSE DR Unit 19A', '(855) 164-7859', 13, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.66300500', '-121.27739500', 'FAIR OAKS', '95628', 'US', 'Yes', 1, NULL),
('No', 115, 'COLLECT', '2015-11-29 18:04:47', NULL, 'Elden Spero ', '5841 VALLEY VALE WAY', '(899) 018-0738', 13, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.46175400', '-121.43426800', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 116, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Claris Luc ', '2340 HURLEY WAY', '(811) 862-9674', 13, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.58768560', '-121.40888520', 'SACRAMENTO', '95825', 'US', 'Yes', 1, NULL),
('No', 117, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Carylon Heisey ', '8207 YORKTON WAY', '(899) 692-6649', 13, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.45957860', '-121.36027140', 'SACRAMENTO', '95829', 'US', 'Yes', 1, NULL),
('No', 118, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Kyle Popek ', '4487 PANORAMA DR', '(899) 486-6859', 13, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.69503900', '-120.84830000', 'PLACERVILLE', '95667', 'US', 'Yes', 1, NULL),
('No', 119, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Jeraldine Lamarca ', '2121 HANNAH WAY', '(855) 165-9601', 13, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.80583300', '-121.28058200', 'ROCKLIN', '95765', 'US', 'Yes', 1, NULL),
('No', 120, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Christian Sobol ', '7756 TIGERWOODS DR', '(844) 056-1579', 13, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.47658100', '-121.30841700', 'SACRAMENTO', '95829', 'US', 'Yes', 1, NULL),
('No', 121, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Alisa Lloyd ', '540 MORRISON AVE', '(811) 661-9857', 13, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.63742700', '-121.45402400', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 122, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Vincenza Mcgowen ', '3128 VIA GRANDE', '(811) 306-2517', 13, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.59795100', '-121.39119800', 'SACRAMENTO', '95825', 'US', 'Yes', 1, NULL),
('No', 123, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Katia Mcclay ', '8363 LANGTREE WAY', '(833) 407-1407', 13, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.45361590', '-121.43570200', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 124, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Tilda Mcquillen ', '508 SAMUEL WAY', '(899) 698-6081', 13, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.64528300', '-121.45418800', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 125, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Lyndon Chancy ', '4709 AMBER LN Unit 1', '(822) 964-6071', 13, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.65839500', '-121.35361600', 'SACRAMENTO', '95841', 'US', 'Yes', 1, NULL),
('No', 126, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Delores Hoff ', '5308 MARBURY WAY', '(844) 481-2332', 13, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.70997600', '-121.34093900', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 127, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Yee Ridenour ', '6048 OGDEN NASH WAY', '(822) 966-0521', 14, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.68120100', '-121.35155800', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 128, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Dick Milledge ', '5201 LAGUNA OAKS DR Unit 140', '(899) 698-6068', 14, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.42227100', '-121.44313400', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 129, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Elane Rafael ', '8156 STEINBECK WAY', '(822) 964-6058', 14, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.47463500', '-121.40650800', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 130, 'REPAIR', '2015-11-29 18:04:47', NULL, 'Glady Viernes ', '9080 FRESCA WAY', '(844) 481-2319', 14, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.42808700', '-121.42444100', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 131, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Jacki Saiki ', '4900 71ST ST', '(844) 633-2352', 14, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.53130900', '-121.42123900', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 132, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Kathrin Neidig ', '8929 SUTTERS GOLD DR', '(855) 194-9200', 14, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.55109600', '-121.37022700', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 133, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Trudi Sherry ', '6945 RIO TEJO WAY', '(822) 526-4630', 14, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.38660200', '-121.42254600', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 134, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Sherry Nester ', '5028 14TH AVE', '(822) 399-8964', 14, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.53916490', '-121.44700300', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 135, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Breanne Dingman ', '1035 MILLET WAY', '(855) 504-9102', 14, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.63048500', '-121.48483300', 'SACRAMENTO', '95834', 'US', 'Yes', 1, NULL),
('No', 136, 'INSTALL', '2015-11-29 18:04:47', NULL, 'Brian Drapeau ', '7863 CRESTLEIGH CT', '(844) 309-4685', 14, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.71110900', '-121.35881300', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 137, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Lekisha Shryock ', '3035 BRUNNET LN', '(822) 313-3713', 14, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.62461880', '-121.52261780', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 138, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Ulysses Gottfried ', '7922 MANSELL WAY', '(899) 223-6317', 14, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.40943900', '-121.40985900', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 139, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Riva Harryman ', '5651 OVERLEAF WAY', '(844) 937-3885', 14, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.67785390', '-121.49505920', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 140, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Latonia Crepeau ', '10104 ANNIE ST', '(822) 966-0531', 14, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.39081500', '-121.44372000', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 141, 'COLLECT', '2015-11-29 18:04:48', NULL, 'Natalia Salvatore ', '5709 RIVER OAK WAY', '(899) 954-5815', 14, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.60300900', '-121.33118700', 'CARMICHAEL', '95608', 'US', 'Yes', 1, NULL),
('No', 142, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Kory Esh ', '5303 JERRETT WAY', '(855) 350-2114', 14, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.66346400', '-121.35946760', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 143, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Hassie Swift ', '2847 BELGRADE WAY', '(899) 100-1073', 14, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.61735580', '-121.48281360', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 144, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Tabetha Catchings ', '1675 VERNON ST Unit 8', '(822) 941-6311', 14, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.73336900', '-121.29731800', 'ROSEVILLE', '95678', 'US', 'Yes', 1, NULL),
('No', 145, 'REPAIR', '2015-11-29 18:04:48', NULL, 'Shaunte Runyan ', '6128 CARL SANDBURG CIR', '(844) 438-3908', 14, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.68177300', '-121.35579500', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 146, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Shawanna Darrow ', '4508 OLD DAIRY DR', '(855) 709-1204', 14, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.72258900', '-121.35883200', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 147, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Deshawn Easton ', '9182 LAKEMONT DR', '(844) 456-3337', 14, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.45118600', '-121.35864900', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('Yes', 148, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Reita Pizana ', '2561 19TH AVE', '(833) 407-1394', 15, '2015-04-06 07:00:00', '2015-04-06 09:00:00', '2016-04-04 18:58:46', NULL, 'CANCELLED', '38.53549300', '-121.48022800', 'SACRAMENTO', '95820', 'US', 'Yes', 1, ''),
('No', 149, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Delmy Charney ', '6768 MEDORA DR', '(844) 438-3895', 15, '2015-12-01 09:00:00', '2015-12-01 12:00:00', '2016-04-04 19:09:10', NULL, 'RESCHEDULED', '38.69133990', '-121.37218700', 'NORTH HIGHLANDS', '95660', 'US', 'Yes', 1, ''),
('No', 150, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Nakia Colligan ', '7957 VALLEY GREEN DR', '(855) 709-1191', 15, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'RESCHEDULED', '38.46528720', '-121.43465900', 'SACRAMENTO', '95823', 'US', 'Yes', 1, ''),
('No', 151, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Damon Lavallie ', '391 NATALINO CIR', '(844) 456-3324', 15, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'RESCHEDULED', '38.67338400', '-121.50629900', 'SACRAMENTO', '95835', 'US', 'Yes', 1, ''),
('No', 152, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Lynnette Abdulla ', '12209 CONSERVANCY WAY', '(855) 164-7856', 15, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'RESCHEDULED', '38.55462500', '-121.21912600', 'RANCHO CORDOVA', '95742', 'US', 'Yes', 1, ''),
('No', 153, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Gertrudis Higley ', '8025 PEERLESS AVE', '(899) 018-0735', 15, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.71179800', '-121.21649400', 'ORANGEVALE', '95662', 'US', 'Yes', 1, NULL),
('No', 154, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Jenee Luna ', '4186 TULIP PARK WAY', '(811) 862-9671', 15, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.55052400', '-121.23551600', 'RANCHO CORDOVA', '95742', 'US', 'Yes', 1, NULL),
('No', 155, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Zenia Kerlin ', '14788 NATCHEZ CT', '(899) 692-6646', 15, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.49215000', '-121.10016000', 'RANCHO MURIETA', '95683', 'US', 'Yes', 1, NULL),
('No', 156, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Keli Asberry ', '5201 LAGUNA OAKS DR Unit 126', '(899) 486-6856', 15, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.42227100', '-121.44313400', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 157, 'INSTALL', '2015-11-29 18:04:48', NULL, 'James Segura ', '7129 SPRINGMONT DR', '(855) 165-9598', 15, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.41769200', '-121.42058700', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 158, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Yaeko Doyel ', '3025 EL PRADO WAY', '(844) 056-1576', 15, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.60673800', '-121.39304000', 'SACRAMENTO', '95825', 'US', 'Yes', 1, NULL),
('No', 159, 'COLLECT', '2015-11-29 18:04:48', NULL, 'Marshall Ochoa ', '5712 MELBURY CIR', '(811) 661-9854', 15, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.70592000', '-121.33443000', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 160, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Micheal Lengyel ', '2015 PROMONTORY POINT LN', '(811) 306-2514', 15, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.62883200', '-121.26090100', 'GOLD RIVER', '95670', 'US', 'Yes', 1, NULL),
('No', 161, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Tarah Aldape ', '1092 MAUGHAM CT', '(833) 407-1404', 15, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.27142400', '-121.28737400', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 162, 'INSTALL', '2015-11-29 18:04:48', NULL, 'Kari Kaster ', '2981 WRINGER DR', '(899) 698-6078', 15, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.73558600', '-121.22715300', 'ROSEVILLE', '95661', 'US', 'Yes', 1, NULL),
('No', 163, 'REPAIR', '2015-11-29 18:04:48', NULL, 'Gregg Camargo ', '2820 DEL PASO BLVD', '(822) 964-6068', 15, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.61756200', '-121.43949400', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 164, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Margie Huggett ', '7741 MILLDALE CIR', '(844) 481-2329', 15, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.70537000', '-121.43910300', 'ELVERTA', '95626', 'US', 'Yes', 1, NULL),
('No', 165, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Leisha Krug ', '6632 IBEX WOODS CT', '(844) 633-2362', 15, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.72043800', '-121.30959400', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 166, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Jocelyn Miguel ', '1 KENNELFORD CIR', '(855) 194-9210', 15, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.46453200', '-121.42727900', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 167, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Michaele Karam ', '312 RIVER ISLE WAY', '(822) 526-4640', 15, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.48985700', '-121.55083200', 'SACRAMENTO', '95831', 'US', 'Yes', 1, NULL),
('No', 168, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Deb Shugart ', '2231 COUNTRY VILLA CT', '(822) 399-8974', 15, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.93181600', '-121.09813200', 'AUBURN', '95603', 'US', 'Yes', 1, NULL),
('No', 169, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Monserrate Benge ', '11150 TRINITY RIVER DR Unit 114', '(822) 941-6298', 16, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.62192100', '-121.26953400', 'RANCHO CORDOVA', '95670', 'US', 'Yes', 1, NULL),
('No', 170, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Hayden Corney ', '3100 EXPLORER DR', '(855) 194-9197', 16, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.56645800', '-121.33255900', 'SACRAMENTO', '95827', 'US', 'Yes', 1, NULL),
('No', 171, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Angelo Shaner ', '1122 WILD POPPY CT', '(822) 526-4627', 16, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.28778100', '-121.29506400', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 172, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Cesar Forgione ', '8373 BLACKMAN WAY', '(822) 399-8961', 16, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.43512000', '-121.39473500', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('No', 173, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Leesa Furst ', '4236 NATOMAS CENTRAL DR', '(855) 504-9099', 16, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.64810090', '-121.54376840', 'SACRAMENTO', '95834', 'US', 'Yes', 1, NULL),
('No', 174, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Walter Painter ', '4620 WELERA WAY', '(844) 309-4682', 16, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.39842800', '-121.44942200', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 175, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Alicia Mort ', '9278 DAIRY CT', '(822) 313-3710', 16, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.41999900', '-121.36414300', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('No', 176, 'INSTALL', '2015-11-29 18:04:49', NULL, 'Renna Newbury ', '1069 ACACIA AVE', '(899) 223-6314', 16, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.62248200', '-121.44231700', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 177, 'REPAIR', '2015-11-29 18:04:49', NULL, 'Kelly Shatley ', '3328 22ND AVE', '(844) 937-3882', 16, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.53249700', '-121.47097800', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 178, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Angelyn Kerby ', '8284 RED FOX WAY', '(822) 966-0528', 16, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.41763100', '-121.39692000', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 179, 'COLLECT', '2015-11-29 18:04:50', NULL, 'Janie Shima ', '9387 GRANITE FALLS CT', '(899) 954-5812', 16, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.41943890', '-121.34902000', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('No', 180, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Corinne Hesse ', '632 NEWBRIDGE LN', '(855) 350-2111', 16, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.87909400', '-121.29863000', 'LINCOLN', '95648', 'US', 'Yes', 1, NULL),
('No', 181, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Donovan Wilkison ', '3224 PARKHAM DR', '(899) 100-1070', 16, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.77284300', '-121.36439400', 'ROSEVILLE', '95747', 'US', 'Yes', 1, NULL),
('No', 182, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Thelma Gilland ', '5404 ALMOND FALLS WAY', '(822) 941-6308', 16, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.52761600', '-121.23374400', 'RANCHO CORDOVA', '95742', 'US', 'Yes', 1, NULL),
('No', 183, 'COLLECT', '2015-11-29 18:04:50', NULL, 'Ezra Musgrave ', '8616 ROCKPORTE CT', '(844) 438-3905', 16, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.74245100', '-121.35925400', 'ROSEVILLE', '95747', 'US', 'Yes', 1, NULL),
('No', 184, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Enrique Lheureux ', '3715 TALLYHO DR Unit 78HIGH', '(855) 709-1201', 16, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.54516200', '-121.35599300', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 185, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Melisa Willey ', '9013 CASALS ST', '(844) 456-3334', 16, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.55747100', '-121.37007700', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 186, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Lannie Jablonski ', '117 EVCAR WAY', '(855) 164-7866', 16, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.68774600', '-121.46366700', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 187, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Kecia Kentner ', '909 SINGINGWOOD RD', '(899) 018-0745', 16, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.58183800', '-121.38865600', 'SACRAMENTO', '95864', 'US', 'Yes', 1, NULL),
('No', 188, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Tracy Rasmus ', '301 OLIVADI WAY', '(811) 862-9681', 16, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.64438500', '-121.54920700', 'SACRAMENTO', '95834', 'US', 'Yes', 1, NULL),
('No', 189, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Kris Mele ', '8491 CRYSTAL WALK CIR', '(899) 692-6656', 16, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.41744200', '-121.40769300', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 190, 'REPAIR', '2015-11-29 18:04:50', NULL, 'Garrett Mantle ', '7325 10TH ST', '(844) 633-2349', 17, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.70067300', '-121.44324500', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 191, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Malika Dejonge ', '7944 DOMINION WAY', '(899) 018-0732', 17, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.71295400', '-121.41146600', 'ELVERTA', '95626', 'US', 'Yes', 1, NULL),
('No', 192, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Sherri Mcgarr ', '4520 BOMARK WAY', '(811) 862-9668', 17, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.66549500', '-121.35840400', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 193, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Augusta Mulhern ', '9837 CORTE DORADO CT', '(899) 692-6643', 17, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.40007600', '-121.38168100', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('No', 194, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Marcela Happel ', '5615 LUPIN LN', '(899) 486-6853', 17, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.70694400', '-120.60245300', 'POLLOCK PINES', '95726', 'US', 'Yes', 1, NULL),
('No', 195, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Oneida Snelling ', '9723 TERRAPIN CT', '(855) 165-9595', 17, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.40316390', '-121.43024400', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 196, 'COLLECT', '2015-11-29 18:04:50', NULL, 'Alphonso Griffeth ', '207 ORANGE BLOSSOM CIR Unit C', '(844) 056-1573', 17, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.64666100', '-121.17555800', 'FOLSOM', '95630', 'US', 'Yes', 1, NULL),
('No', 197, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Shea Nickels ', '5201 LAGUNA OAKS DR Unit 199', '(811) 661-9851', 17, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.42227100', '-121.44313400', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 198, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Ellsworth Muldrow ', '8001 HARTWICK WAY', '(811) 306-2511', 17, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.48882600', '-121.41052500', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 199, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Jesusa Strum ', '2219 EL CANTO CIR', '(833) 407-1401', 17, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.59185700', '-121.31874800', 'RANCHO CORDOVA', '95670', 'US', 'Yes', 1, NULL),
('No', 200, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Landon Schell ', '9257 CALDERA WAY', '(899) 698-6075', 17, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.55841000', '-121.35499300', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 201, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Tomas Jewell ', '1570 GLIDDEN AVE', '(822) 964-6065', 17, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.48250000', '-121.50014300', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 202, 'REPAIR', '2015-11-29 18:04:50', NULL, 'Dagny Moss ', '15 VANESSA PL', '(844) 481-2326', 17, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.66828200', '-121.54548200', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 203, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Helen Clendening ', '6306 CONEJO', '(844) 633-2359', 17, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.51275900', '-121.08738600', 'RANCHO MURIETA', '95683', 'US', 'Yes', 1, NULL),
('No', 204, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Stormy Naab ', '4128 HILL ST', '(855) 194-9207', 17, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.64219000', '-121.26167800', 'FAIR OAKS', '95628', 'US', 'Yes', 1, NULL),
('No', 205, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Lilian Fultz ', '6013 ROWAN WAY', '(822) 526-4637', 17, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.67494300', '-121.29512700', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 206, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Judie Lyttle ', '227 MAHAN CT Unit 1', '(822) 399-8971', 17, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.74996700', '-121.27053300', 'ROSEVILLE', '95678', 'US', 'Yes', 1, NULL),
('No', 207, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Lonny Breitenstein ', '6485 LAGUNA MIRAGE LN', '(855) 504-9109', 17, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.42444900', '-121.42992500', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 208, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Isabella Fusaro ', '6671 FOXWOOD CT', '(844) 309-4692', 17, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.68811900', '-121.32924300', 'SACRAMENTO', '95841', 'US', 'Yes', 1, NULL),
('No', 209, 'COLLECT', '2015-11-29 18:04:50', NULL, 'Wilbert Jost ', '5636 25TH ST', '(822) 313-3720', 17, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.52339300', '-121.48139200', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 210, 'REPAIR', '2015-11-29 18:04:50', NULL, 'Berry Mcmurry ', '361 MAHONIA CIR', '(899) 223-6324', 17, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.67598200', '-121.50961700', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 211, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Stephane Lindblom ', '645 MORRISON AVE', '(855) 164-7853', 18, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.63790300', '-121.45047200', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL);
INSERT INTO `task` (`SOS_STATUS`, `task_id`, `TasktypeCategory`, `creation_date`, `update_date`, `contact_name`, `contact_address`, `contact_phone`, `user_id`, `scheduled_Start`, `scheduled_End`, `actual_Start`, `actual_end`, `task_Status`, `task_lat`, `task_long`, `Region`, `postcode`, `country`, `is_rescheduled`, `company_id`, `notes`) VALUES
('No', 212, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Jena Omalley ', '5201 LAGUNA OAKS DR Unit 162', '(844) 309-4679', 18, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.42227100', '-121.44313400', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 213, 'INSTALL', '2015-11-29 18:04:50', NULL, 'Kera Lawlor ', '9012 KIEFER BLVD', '(822) 313-3707', 18, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.54679700', '-121.36595600', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 214, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Nathanial Haddad ', '5037 J PKWY', '(899) 223-6311', 18, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.49188300', '-121.44464700', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 215, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Un Carraway ', '5625 JAMES WAY', '(844) 937-3879', 18, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.52373600', '-121.48471100', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 216, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Rosie Garlock ', '2115 SMOKESTACK WAY', '(822) 966-0525', 18, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.60249300', '-121.54329360', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 217, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Lolita Marlatt ', '6507 RIO DE ONAR WAY', '(899) 954-5809', 18, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.38274400', '-121.42788200', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 218, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Nydia Pantano ', '3847 LAS PASAS WAY', '(855) 350-2108', 18, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.58908200', '-121.37385300', 'SACRAMENTO', '95864', 'US', 'Yes', 1, NULL),
('No', 219, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Eryn Linke ', '7812 HARTWICK WAY', '(899) 100-1067', 18, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.48840200', '-121.41218200', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 220, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Jesusa Beckerman ', '8907 GEMWOOD WAY', '(822) 941-6305', 18, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.43589300', '-121.44080600', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 221, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Jeana Hanrahan ', '441 ARLINGDALE CIR', '(844) 438-3902', 18, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.70359500', '-121.45516900', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 222, 'REPAIR', '2015-11-29 18:04:51', NULL, 'Gregorio Fennel ', '8108 FILIFERA WAY', '(855) 709-1198', 18, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.71685100', '-121.35429500', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 223, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Maris Ledoux ', '1312 RENISON LN', '(844) 456-3331', 18, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.86622000', '-121.30796600', 'LINCOLN', '95648', 'US', 'Yes', 1, NULL),
('No', 224, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Elinore Pfister ', '14 CASA VATONI PL', '(855) 164-7863', 18, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.64996000', '-121.55216200', 'SACRAMENTO', '95834', 'US', 'Yes', 1, NULL),
('No', 225, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Milda Folkes ', '1409 47TH ST', '(899) 018-0742', 18, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.56305600', '-121.44661300', 'SACRAMENTO', '95819', 'US', 'Yes', 1, NULL),
('No', 226, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Lesha Mascia ', '2987 PONDEROSA LN', '(811) 862-9678', 18, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.62236990', '-121.45811900', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 227, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Nannette Espey ', '7349 FLETCHER FARM DR', '(899) 692-6653', 18, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.49083000', '-121.38239000', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 228, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Mariela Escamilla ', '746 MOOSE CREEK WAY', '(899) 486-6863', 18, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.28289190', '-121.30263600', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 229, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Jenee Holstein ', '8165 AYN RAND CT', '(855) 165-9605', 18, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.46847100', '-121.40445300', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 230, 'COLLECT', '2015-11-29 18:04:51', NULL, 'Selena Czapla ', '8721 SPRUCE RIDGE WAY', '(844) 056-1583', 18, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.72792800', '-121.39131800', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 231, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Jamal Loth ', '3427 LA CADENA WAY', '(811) 661-9861', 18, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.68138500', '-121.53787300', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 232, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Lan Arwood ', '4085 FAWN CIR', '(855) 504-9096', 19, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.47094600', '-121.45853000', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 233, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Shona Appleby ', '3920 SHINING STAR DR', '(855) 165-9592', 19, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.48718490', '-121.46224800', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 234, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Soraya Kiser ', '5332 SANDSTONE ST', '(844) 056-1570', 19, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.66278700', '-121.31368600', 'CARMICHAEL', '95608', 'US', 'Yes', 1, NULL),
('No', 235, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Hanh Antley ', '10245 LOS PALOS DR', '(811) 661-9848', 19, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.59402600', '-121.31078900', 'RANCHO CORDOVA', '95670', 'US', 'Yes', 1, NULL),
('No', 236, 'REPAIR', '2015-11-29 18:04:51', NULL, 'Naoma Brazier ', '7842 LAHONTAN CT', '(811) 306-2508', 19, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.47295600', '-121.31893800', 'SACRAMENTO', '95829', 'US', 'Yes', 1, NULL),
('No', 237, 'COLLECT', '2015-11-29 18:04:51', NULL, 'Shea Scotti ', '100 REBECCA WAY', '(833) 407-1398', 19, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.68450300', '-121.14913300', 'FOLSOM', '95630', 'US', 'Yes', 1, NULL),
('No', 238, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Yuonne Benefiel ', '7004 RAWLEY WAY', '(899) 698-6072', 19, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.40611100', '-121.42231700', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 239, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Keren Alberts ', '5201 LAGUNA OAKS DR Unit 172', '(822) 964-6062', 19, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.42227100', '-121.44313400', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 240, 'INSTALL', '2015-11-29 18:04:51', NULL, 'Taryn Freeborn ', '4207 PAINTER WAY', '(844) 481-2323', 19, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.69311500', '-121.36726000', 'NORTH HIGHLANDS', '95660', 'US', 'Yes', 1, NULL),
('No', 241, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Owen Huntoon ', '5925 MALEVILLE AVE', '(844) 633-2356', 19, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.66674100', '-121.32539600', 'CARMICHAEL', '95608', 'US', 'Yes', 1, NULL),
('No', 242, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Ester Carballo ', '2284 LOS ROBLES RD', '(855) 194-9204', 19, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '39.00908200', '-121.03562400', 'MEADOW VISTA', '95722', 'US', 'Yes', 1, NULL),
('No', 243, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Ying Wiedemann ', '230 BANKSIDE WAY', '(822) 526-4634', 19, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.67692980', '-121.52904900', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 244, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Maia Robichaud ', '8 RIVER RAFT CT', '(822) 399-8968', 19, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.44803000', '-121.43471200', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 245, 'COLLECT', '2015-11-29 18:04:52', NULL, 'Catherine Mintz ', '1456 EAGLESFIELD LN', '(855) 504-9106', 19, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.85771600', '-121.31161100', 'LINCOLN', '95648', 'US', 'Yes', 1, NULL),
('No', 246, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Abigail Teston ', '3935 EL MONTE DR', '(844) 309-4689', 19, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.81392400', '-121.13343900', 'LOOMIS', '95650', 'US', 'Yes', 1, NULL),
('No', 247, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Erik Majka ', '3732 LANKERSHIM WAY', '(822) 313-3717', 19, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.68982590', '-121.37729400', 'NORTH HIGHLANDS', '95660', 'US', 'Yes', 1, NULL),
('No', 248, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Princess Bridgett ', '7226 LARCHMONT DR', '(899) 223-6321', 19, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.69939800', '-121.37608100', 'NORTH HIGHLANDS', '95660', 'US', 'Yes', 1, NULL),
('No', 249, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Leanna Cichon ', '8306 CURLEW CT', '(844) 937-3889', 19, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.71617400', '-121.29896400', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 250, 'REPAIR', '2015-11-29 18:04:52', NULL, 'Broderick Lapine ', '9474 VILLAGE TREE DR', '(822) 966-0535', 19, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.41384600', '-121.40863900', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 251, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Shena Wishart ', '7461 WINDBRIDGE DR', '(899) 954-5819', 19, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.48768900', '-121.53025100', 'SACRAMENTO', '95831', 'US', 'Yes', 1, NULL),
('No', 252, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Deandrea Bhatti ', '955 BIG SUR CT', '(855) 350-2118', 19, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.66459700', '-121.07631800', 'EL DORADO HILLS', '95762', 'US', 'Yes', 1, NULL),
('No', 253, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Stephen Uribe ', '2930 LA ROSA RD', '(899) 486-6850', 20, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.61855860', '-121.43592700', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 254, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Lonnie Hallman ', '5031 CORVAIR ST', '(822) 966-0522', 20, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.65866380', '-121.37572790', 'NORTH HIGHLANDS', '95660', 'US', 'Yes', 1, NULL),
('No', 255, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Jovita Barren ', '5993 SAWYER CIR', '(899) 954-5806', 20, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.44710100', '-121.43504900', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 256, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Hosea Archambault ', '6613 NAVION DR', '(855) 350-2105', 20, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.70271600', '-121.31371600', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 257, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Chara Cevallos ', '6850 21ST ST', '(899) 100-1064', 20, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.50169100', '-121.49110600', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 258, 'COLLECT', '2015-11-29 18:04:52', NULL, 'Fletcher Nembhard ', '9488 OAK VILLAGE WAY', '(822) 941-6302', 20, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.41320300', '-121.40530700', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 259, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Irene Hilyard ', '6503 RIO DE ONAR WAY', '(844) 438-3899', 20, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.38274400', '-121.42807400', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 260, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Kerrie Rumbaugh ', '1121 CREEKSIDE WAY', '(855) 709-1195', 20, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.24132190', '-121.31193600', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 261, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Tatum Coughlan ', '7458 WINKLEY WAY', '(844) 456-3328', 20, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.48765200', '-121.49069500', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 262, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Otto Karp ', '7031 CANEVALLEY CIR', '(855) 164-7860', 20, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.71887600', '-121.30353500', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 263, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Christopher Papa ', '8164 CHENIN BLANC LN', '(899) 018-0739', 20, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.66547400', '-121.25982200', 'FAIR OAKS', '95628', 'US', 'Yes', 1, NULL),
('No', 264, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Teresa Moors ', '5342 CALABRIA WAY', '(811) 862-9675', 20, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.67176090', '-121.49795900', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 265, 'DELIVERY', '2015-11-29 18:04:52', NULL, 'Crysta Wier ', '2251 LAMPLIGHT LN', '(899) 692-6650', 20, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.85012900', '-121.27559800', 'LINCOLN', '95648', 'US', 'Yes', 1, NULL),
('No', 266, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Karrie Sereno ', '4100 BOTHWELL CIR', '(899) 486-6860', 20, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.67876500', '-121.03521800', 'EL DORADO HILLS', '95762', 'US', 'Yes', 1, NULL),
('No', 267, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Jay Mancilla ', '5840 WALERGA RD', '(855) 165-9602', 20, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.67420500', '-121.35731100', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 268, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Vanita Lewicki ', '2216 DUNLAP DR', '(844) 056-1580', 20, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.62352400', '-121.41308600', 'SACRAMENTO', '95821', 'US', 'Yes', 1, NULL),
('No', 269, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Lessie Jung ', '4114 35TH AVE', '(811) 661-9858', 20, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.52070590', '-121.45887100', 'SACRAMENTO', '95824', 'US', 'Yes', 1, NULL),
('No', 270, 'COLLECT', '2015-11-29 18:04:52', NULL, 'Deon Prichett ', '8306 CURLEW CT', '(811) 306-2518', 20, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.71617400', '-121.29896400', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 271, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Fumiko Furtado ', '7213 CALVIN DR', '(833) 407-1408', 20, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.69896900', '-121.29915900', 'CITRUS HEIGHTS', '95621', 'US', 'Yes', 1, NULL),
('No', 272, 'REPAIR', '2015-11-29 18:04:52', NULL, 'Thelma Meagher ', '8101 LEMON COVE CT', '(899) 698-6082', 20, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.46323700', '-121.40842200', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 273, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Inell Sliva ', '11826 DIONYSUS WAY', '(822) 964-6072', 20, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.55088000', '-121.23885800', 'RANCHO CORDOVA', '95742', 'US', 'Yes', 1, NULL),
('No', 274, 'DELIVERY', '2015-11-29 18:04:52', NULL, 'Carrie Gulick ', '2113 KIRK WAY', '(844) 937-3876', 21, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.48240700', '-121.49248600', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 275, 'INSTALL', '2015-11-29 18:04:52', NULL, 'Crissy Cabell ', '7661 NIXOS WAY', '(833) 407-1395', 21, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.47922100', '-121.46293600', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 276, 'INSTALL', '2015-11-29 18:04:53', NULL, 'Adaline Ruiz ', '4844 CLYDEBANK WAY', '(899) 698-6069', 21, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.71480600', '-121.34792900', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 277, 'INSTALL', '2015-11-29 18:04:53', NULL, 'Zana Condict ', '2887 AZEVEDO DR', '(822) 964-6059', 21, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.61835900', '-121.50977200', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 278, 'INSTALL', '2015-11-29 18:04:53', NULL, 'Dagny Reiff ', '2900 BLAIR RD', '(844) 481-2320', 21, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.75474400', '-120.60515400', 'POLLOCK PINES', '95726', 'US', 'Yes', 1, NULL),
('No', 279, 'INSTALL', '2015-11-29 18:04:53', NULL, 'Christal Baty ', '8495 DARTFORD DR', '(844) 633-2353', 21, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.44872190', '-121.42128500', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 280, 'DELIVERY', '2015-11-29 18:04:54', NULL, 'Gilberto Wismer ', '2217 APPALOOSA CT', '(855) 194-9201', 21, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.65501000', '-121.08962800', 'FOLSOM', '95630', 'US', 'Yes', 1, NULL),
('No', 281, 'REPAIR', '2015-11-29 18:04:54', NULL, 'Ngan Girton ', '5307 CABRILLO WAY', '(822) 526-4631', 21, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.52666600', '-121.43511300', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 282, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Cordell Keese ', '8354 SUNRISE WOODS WAY', '(822) 399-8965', 21, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.47310490', '-121.39671500', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 283, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Mana Quillin ', '3949 WILDROSE WAY', '(855) 504-9103', 21, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.54391600', '-121.36705100', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 284, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Dorothea Opitz ', '4620 CHAMBERLIN CIR', '(844) 309-4686', 21, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.39057100', '-121.45003800', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 285, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Lola Constantine ', '47 NAPONEE CT', '(822) 313-3714', 21, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.66615100', '-121.52958700', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 286, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Lashay Mondor ', '106 FARHAM DR', '(899) 223-6318', 21, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.66742500', '-121.16879600', 'FOLSOM', '95630', 'US', 'Yes', 1, NULL),
('No', 287, 'DELIVERY', '2015-11-29 18:04:54', NULL, 'Philip Barner ', '427 21ST ST', '(844) 937-3886', 21, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.58199000', '-121.47579500', 'SACRAMENTO', '95811', 'US', 'Yes', 1, NULL),
('No', 288, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Darius Fitz ', '923 FULTON AVE', '(822) 966-0532', 21, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.58205540', '-121.40217840', 'SACRAMENTO', '95825', 'US', 'Yes', 1, NULL),
('No', 289, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Chuck Broyles ', '3503 21ST AVE', '(899) 954-5816', 21, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.53386200', '-121.46923300', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 290, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Carlo Sheldon ', '617 M ST', '(855) 350-2115', 21, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.69138700', '-121.45153900', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 291, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Reva Geisler ', '5217 ARGO WAY', '(899) 100-1074', 21, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.52718200', '-121.43344800', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 292, 'COLLECT', '2015-11-29 18:04:54', NULL, 'Summer Sampley ', '8167 DERBY PARK CT', '(822) 941-6312', 21, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.46073100', '-121.37313400', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 293, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Marybelle Bowling ', '10949 SCOTSMAN WAY', '(844) 438-3909', 21, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.60430700', '-121.27736800', 'RANCHO CORDOVA', '95670', 'US', 'Yes', 1, NULL),
('No', 294, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Wan Walcott ', '5847 DEL CAMPO LN', '(855) 709-1205', 21, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.67239500', '-121.32483200', 'CARMICHAEL', '95608', 'US', 'Yes', 1, NULL),
('No', 295, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Ta Brookover ', '4533 LOCH HAVEN WAY', '(811) 306-2505', 22, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.67306300', '-121.35948400', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 296, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Waldo Hand ', '7044 CARTHY WAY', '(822) 941-6299', 22, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.49832100', '-121.42104800', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 297, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Joette Kuehne ', '306 CAMELLIA WAY', '(844) 438-3896', 22, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.26067900', '-121.29833500', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 298, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Nolan Atwell ', '9186 KINBRACE CT', '(855) 709-1192', 22, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.46304600', '-121.35886300', 'SACRAMENTO', '95829', 'US', 'Yes', 1, NULL),
('No', 299, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Bettye Mcguffie ', '2064 EXPEDITION WAY', '(844) 456-3325', 22, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.47381800', '-121.49079300', 'SACRAMENTO', '95832', 'US', 'Yes', 1, NULL),
('No', 300, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Lillie Pray ', '6708 PONTA DO SOL WAY', '(855) 164-7857', 22, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.38042600', '-121.42501000', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 301, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Brandie Farah ', '868 HILDEBRAND CIR', '(899) 018-0736', 22, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.67117900', '-121.09792600', 'FOLSOM', '95630', 'US', 'Yes', 1, NULL),
('No', 302, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Song Otte ', '3725 DON JULIO BLVD', '(811) 862-9672', 22, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.67913700', '-121.37904900', 'NORTH HIGHLANDS', '95660', 'US', 'Yes', 1, NULL),
('No', 303, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Siobhan Faye ', '8116 COTTONMILL CIR', '(899) 692-6647', 22, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.48305800', '-121.40630600', 'SACRAMENTO', '95828', 'US', 'Yes', 1, NULL),
('No', 304, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Lucinda Honig ', '4437 MITCHUM CT', '(899) 486-6857', 22, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.70459100', '-121.36072400', 'ANTELOPE', '95843', 'US', 'Yes', 1, NULL),
('No', 305, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Edwin Ching ', '5340 BIRK WAY', '(855) 165-9599', 22, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.67240280', '-121.51518810', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 306, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Valencia Latshaw ', '4236 ADRIATIC SEA WAY', '(844) 056-1577', 22, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.64832800', '-121.54301700', 'SACRAMENTO', '95834', 'US', 'Yes', 1, NULL),
('No', 307, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Marisol Shane ', '5405 NECTAR CIR', '(811) 661-9855', 22, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.38681700', '-121.44127500', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 308, 'DELIVERY', '2015-11-29 18:04:54', NULL, 'Odis Orme ', '1044 GALSTON DR', '(811) 306-2515', 22, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.67603400', '-121.09914300', 'FOLSOM', '95630', 'US', 'Yes', 1, NULL),
('No', 309, 'INSTALL', '2015-11-29 18:04:54', NULL, 'Linwood Berry ', '261 REDONDO AVE', '(833) 407-1405', 22, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.62084100', '-121.46075800', 'SACRAMENTO', '95815', 'US', 'Yes', 1, NULL),
('No', 310, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Robin Mason ', '523 EXCHANGE ST', '(899) 698-6079', 22, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.65966700', '-121.45377500', 'SACRAMENTO', '95838', 'US', 'Yes', 1, NULL),
('No', 311, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Katina Kealey ', '7032 FAIR OAKS BLVD', '(822) 964-6069', 22, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.62892900', '-121.32731600', 'CARMICHAEL', '95608', 'US', 'Yes', 1, NULL),
('No', 312, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Annmarie Vigil ', '7108 HEATHER TREE DR', '(844) 481-2330', 22, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.69548000', '-121.35981000', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 313, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Ward Bromley ', '6344 LAGUNA MIRAGE LN', '(844) 633-2363', 22, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.42382200', '-121.42855900', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 314, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Sid Capito ', '617 WILLOW CREEK DR', '(855) 194-9211', 22, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.68015300', '-121.14091200', 'FOLSOM', '95630', 'US', 'Yes', 1, NULL),
('No', 315, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Candance Bowlin ', '5635 FOXVIEW WAY', '(822) 526-4641', 22, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.39594300', '-121.43832400', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 316, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Avelina Ota ', '7340 HAMDEN PL', '(899) 100-1061', 23, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.69992600', '-121.35101800', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 317, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Edgar Clouser ', '2442 LARKSPUR LN', '(844) 633-2350', 23, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.58460190', '-121.40526600', 'SACRAMENTO', '95825', 'US', 'Yes', 1, NULL),
('No', 318, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Lena Velazco ', '9021 MADISON AVE', '(855) 194-9198', 23, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.66444300', '-121.21756100', 'ORANGEVALE', '95662', 'US', 'Yes', 1, NULL),
('No', 319, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Shira Lukes ', '4243 MIDDLEBURY WAY', '(822) 526-4628', 23, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.54789490', '-121.28028800', 'MATHER', '95655', 'US', 'Yes', 1, NULL),
('No', 320, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Deedee Clancy ', '2912 NORCADE CIR', '(822) 399-8962', 23, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.55986600', '-121.36424800', 'SACRAMENTO', '95826', 'US', 'Yes', 1, NULL),
('No', 321, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Hayden Louder ', '4143 SEA MEADOW WAY', '(855) 504-9100', 23, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.46570100', '-121.45730900', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 322, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Alvera Heckstall ', '6030 PALERMO WAY', '(844) 309-4683', 23, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.67296900', '-121.05019900', 'EL DORADO HILLS', '95762', 'US', 'Yes', 1, NULL),
('No', 323, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Byron Beverley ', '4803 MCCLOUD DR', '(822) 313-3711', 23, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.68233600', '-121.35271700', 'SACRAMENTO', '95842', 'US', 'Yes', 1, NULL),
('No', 324, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Regina Costas ', '4660 CEDARWOOD WAY', '(899) 223-6315', 23, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.48462900', '-121.44822000', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 325, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Lavone Shifflett ', '2778 KAWEAH CT', '(844) 937-3883', 23, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.69420100', '-120.99605900', 'CAMERON PARK', '95682', 'US', 'Yes', 1, NULL),
('No', 326, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Clara Ammann ', '51 ANJOU CIR', '(822) 966-0529', 23, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.66191900', '-121.54017800', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 327, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Genna Larimer ', '8864 REMBRANT CT', '(899) 954-5813', 23, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.43576700', '-121.37559600', 'ELK GROVE', '95624', 'US', 'Yes', 1, NULL),
('No', 328, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Petronila Mcmurtrie ', '5411 10TH AVE', '(855) 350-2112', 23, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.54292700', '-121.44230400', 'SACRAMENTO', '95820', 'US', 'Yes', 1, NULL),
('No', 329, 'INSTALL', '2015-11-29 18:04:55', NULL, 'See Phair ', '4440 SYCAMORE AVE', '(899) 100-1071', 23, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.64596800', '-121.35321700', 'SACRAMENTO', '95841', 'US', 'Yes', 1, NULL),
('No', 330, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Kimberlee Loo ', '4030 BROADWAY', '(822) 941-6309', 23, '2015-12-04 12:00:00', '2015-12-04 15:00:00', NULL, NULL, 'DELAYED', '38.54657500', '-121.45978500', 'SACRAMENTO', '95817', 'US', 'Yes', 1, NULL),
('No', 331, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Maye Kildow ', '8101 PORT ROYALE WAY', '(844) 438-3906', 23, '2015-12-04 15:00:00', '2015-12-04 18:00:00', NULL, NULL, 'DELAYED', '38.46375260', '-121.43854090', 'SACRAMENTO', '95823', 'US', 'Yes', 1, NULL),
('No', 332, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Lizbeth Kono ', '2421 SANTINA WAY', '(855) 709-1202', 23, '2015-12-05 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.71887200', '-121.40676800', 'ELVERTA', '95626', 'US', 'Yes', 1, NULL),
('No', 333, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Vivien Mullenax ', '2956 DAVENPORT WAY', '(844) 456-3335', 23, '2015-12-05 09:00:00', '2015-12-05 12:00:00', NULL, NULL, 'DELAYED', '38.62075400', '-121.48239400', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 334, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Emmaline Tippett ', '2945 RED HAWK WAY', '(855) 164-7867', 23, '2015-12-05 12:00:00', '2015-12-05 15:00:00', NULL, NULL, 'DELAYED', '38.61993100', '-121.49717100', 'SACRAMENTO', '95833', 'US', 'Yes', 1, NULL),
('No', 335, 'COLLECT', '2015-11-29 18:04:55', NULL, 'Roxanna Schneck ', '3301 PARK DR Unit 1914', '(899) 018-0746', 23, '2015-12-05 15:00:00', '2015-12-05 18:00:00', NULL, NULL, 'DELAYED', '38.66418600', '-121.52984200', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 336, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Dwight Risser ', '10372 VIA CINTA CT', '(811) 862-9682', 23, '2015-12-06 06:00:00', '2015-12-05 09:00:00', NULL, NULL, 'DELAYED', '38.38020300', '-121.42843200', 'ELK GROVE', '95757', 'US', 'Yes', 1, NULL),
('No', 337, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Yolonda Grissett ', '6715 6TH ST', '(844) 481-2317', 24, '2015-12-01 06:00:00', '2015-12-01 09:00:00', NULL, NULL, 'DELAYED', '38.68989800', '-121.45257900', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 338, 'INSTALL', '2015-11-29 18:04:55', NULL, 'Shawnta Ohern ', '4800 WESTLAKE PKWY Unit 2109', '(855) 164-7854', 24, '2015-12-01 09:00:00', '2015-12-01 12:00:00', NULL, NULL, 'DELAYED', '38.65858800', '-121.54210370', 'SACRAMENTO', '95835', 'US', 'Yes', 1, NULL),
('No', 339, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Fletcher Tunnell ', '404 6TH ST', '(899) 018-0733', 24, '2015-12-01 12:00:00', '2015-12-01 15:00:00', NULL, NULL, 'DELAYED', '38.25153400', '-121.30278900', 'GALT', '95632', 'US', 'Yes', 1, NULL),
('No', 340, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Dotty Wurtz ', '1028 FALLON PLACE CT', '(811) 862-9669', 24, '2015-12-01 15:00:00', '2015-12-01 18:00:00', NULL, NULL, 'DELAYED', '38.69361800', '-121.44138000', 'RIO LINDA', '95673', 'US', 'Yes', 1, NULL),
('No', 341, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Karena Pepe ', '9507 SEA CLIFF WAY', '(899) 692-6644', 24, '2015-12-02 06:00:00', '2015-12-02 09:00:00', NULL, NULL, 'DELAYED', '38.41079500', '-121.47918800', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 342, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Soila Pancoast ', '3020 RICHARDSON CIR', '(899) 486-6854', 24, '2015-12-02 09:00:00', '2015-12-02 12:00:00', NULL, NULL, 'DELAYED', '38.69093190', '-121.08192700', 'EL DORADO HILLS', '95762', 'US', 'Yes', 1, NULL),
('No', 343, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Tami Monroe ', '4070 REDONDO DR', '(855) 165-9596', 24, '2015-12-02 12:00:00', '2015-12-02 15:00:00', NULL, NULL, 'DELAYED', '38.66636100', '-121.06499100', 'EL DORADO HILLS', '95762', 'US', 'Yes', 1, NULL),
('No', 344, 'INSTALL', '2015-11-29 18:04:56', NULL, 'David Cella ', '10542 SILVERWOOD WAY', '(844) 056-1574', 24, '2015-12-02 15:00:00', '2015-12-02 18:00:00', NULL, NULL, 'DELAYED', '38.58709700', '-121.29486800', 'RANCHO CORDOVA', '95670', 'US', 'Yes', 1, NULL),
('No', 345, 'DELIVERY', '2015-11-29 18:04:56', NULL, 'Donnetta Larrabee ', '9254 HARROGATE WAY', '(811) 661-9852', 24, '2015-12-03 06:00:00', '2015-12-03 09:00:00', NULL, NULL, 'DELAYED', '38.41975400', '-121.41187900', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 346, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Johanna Edenfield ', '1636 ALLENWOOD CIR', '(811) 306-2512', 24, '2015-12-03 09:00:00', '2015-12-03 12:00:00', NULL, NULL, 'DELAYED', '38.87987800', '-121.30916500', 'LINCOLN', '95648', 'US', 'Yes', 1, NULL),
('No', 347, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Kaylene Collelo ', '2125 22ND AVE', '(833) 407-1402', 24, '2015-12-03 12:00:00', '2015-12-03 15:00:00', NULL, NULL, 'DELAYED', '38.53473100', '-121.49259000', 'SACRAMENTO', '95822', 'US', 'Yes', 1, NULL),
('No', 348, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Janett Brandi ', '9455 SEA CLIFF WAY', '(899) 698-6076', 24, '2015-12-03 15:00:00', '2015-12-03 18:00:00', NULL, NULL, 'DELAYED', '38.41140100', '-121.48161900', 'ELK GROVE', '95758', 'US', 'Yes', 1, NULL),
('No', 349, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Charis Bodden ', '3512 RAINSONG CIR', '(822) 964-6066', 24, '2015-12-04 06:00:00', '2015-12-04 09:00:00', NULL, NULL, 'DELAYED', '38.57371890', '-121.28273900', 'RANCHO CORDOVA', '95670', 'US', 'Yes', 1, NULL),
('No', 350, 'INSTALL', '2015-11-29 18:04:56', NULL, 'Maurita Schaner ', '1032 SOUZA DR', '(844) 481-2327', 24, '2015-12-04 09:00:00', '2015-12-04 12:00:00', NULL, NULL, 'DELAYED', '38.66866600', '-121.06435300', 'EL DORADO HILLS', '95762', 'US', 'Yes', 1, NULL),