-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathMyIkeaAPI.sql
More file actions
9163 lines (9085 loc) · 347 KB
/
MyIkeaAPI.sql
File metadata and controls
9163 lines (9085 loc) · 347 KB
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
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Base de datos: `MyIkeaAPI`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `customer`
--
CREATE TABLE `customer` (
`customer_id` smallint(5) UNSIGNED NOT NULL,
`first_name` varchar(45) NOT NULL,
`last_name` varchar(45) NOT NULL,
`telefono` varchar(9) NOT NULL DEFAULT '999666999',
`email` varchar(50) DEFAULT NULL,
`fecha_de_nacimiento` date NOT NULL DEFAULT '1990-01-04'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Volcado de datos para la tabla `customer`
--
INSERT INTO `customer` (`customer_id`, `first_name`, `last_name`, `telefono`, `email`, `fecha_de_nacimiento`) VALUES
(1, 'MARY', 'SMITH', '999666999', 'MARY.SMITH@sakilacustomer.org', '1990-01-04'),
(2, 'PATRICIA', 'JOHNSON', '999666999', 'PATRICIA.JOHNSON@sakilacustomer.org', '1990-01-04'),
(3, 'LINDA', 'WILLIAMS', '999666999', 'LINDA.WILLIAMS@sakilacustomer.org', '1990-01-04'),
(4, 'BARBARA', 'JONES', '999666999', 'BARBARA.JONES@sakilacustomer.org', '1990-01-04'),
(5, 'ELIZABETH', 'BROWN', '999666999', 'ELIZABETH.BROWN@sakilacustomer.org', '1990-01-04'),
(6, 'JENNIFER', 'DAVIS', '999666999', 'JENNIFER.DAVIS@sakilacustomer.org', '1990-01-04'),
(7, 'MARIA', 'MILLER', '999666999', 'MARIA.MILLER@sakilacustomer.org', '1990-01-04'),
(8, 'SUSAN', 'WILSON', '999666999', 'SUSAN.WILSON@sakilacustomer.org', '1990-01-04'),
(9, 'MARGARET', 'MOORE', '999666999', 'MARGARET.MOORE@sakilacustomer.org', '1990-01-04'),
(10, 'DOROTHY', 'TAYLOR', '999666999', 'DOROTHY.TAYLOR@sakilacustomer.org', '1990-01-04'),
(11, 'LISA', 'ANDERSON', '999666999', 'LISA.ANDERSON@sakilacustomer.org', '1990-01-04'),
(12, 'NANCY', 'THOMAS', '999666999', 'NANCY.THOMAS@sakilacustomer.org', '1990-01-04'),
(13, 'KAREN', 'JACKSON', '999666999', 'KAREN.JACKSON@sakilacustomer.org', '1990-01-04'),
(14, 'BETTY', 'WHITE', '999666999', 'BETTY.WHITE@sakilacustomer.org', '1990-01-04'),
(15, 'HELEN', 'HARRIS', '999666999', 'HELEN.HARRIS@sakilacustomer.org', '1990-01-04'),
(16, 'SANDRA', 'MARTIN', '999666999', 'SANDRA.MARTIN@sakilacustomer.org', '1990-01-04'),
(17, 'DONNA', 'THOMPSON', '999666999', 'DONNA.THOMPSON@sakilacustomer.org', '1990-01-04'),
(18, 'CAROL', 'GARCIA', '999666999', 'CAROL.GARCIA@sakilacustomer.org', '1990-01-04'),
(19, 'RUTH', 'MARTINEZ', '999666999', 'RUTH.MARTINEZ@sakilacustomer.org', '1990-01-04'),
(20, 'SHARON', 'ROBINSON', '999666999', 'SHARON.ROBINSON@sakilacustomer.org', '1990-01-04'),
(21, 'MICHELLE', 'CLARK', '999666999', 'MICHELLE.CLARK@sakilacustomer.org', '1990-01-04'),
(22, 'LAURA', 'RODRIGUEZ', '999666999', 'LAURA.RODRIGUEZ@sakilacustomer.org', '1990-01-04'),
(23, 'SARAH', 'LEWIS', '999666999', 'SARAH.LEWIS@sakilacustomer.org', '1990-01-04'),
(24, 'KIMBERLY', 'LEE', '999666999', 'KIMBERLY.LEE@sakilacustomer.org', '1990-01-04'),
(25, 'DEBORAH', 'WALKER', '999666999', 'DEBORAH.WALKER@sakilacustomer.org', '1990-01-04'),
(26, 'JESSICA', 'HALL', '999666999', 'JESSICA.HALL@sakilacustomer.org', '1990-01-04'),
(27, 'SHIRLEY', 'ALLEN', '999666999', 'SHIRLEY.ALLEN@sakilacustomer.org', '1990-01-04'),
(28, 'CYNTHIA', 'YOUNG', '999666999', 'CYNTHIA.YOUNG@sakilacustomer.org', '1990-01-04'),
(29, 'ANGELA', 'HERNANDEZ', '999666999', 'ANGELA.HERNANDEZ@sakilacustomer.org', '1990-01-04'),
(30, 'MELISSA', 'KING', '999666999', 'MELISSA.KING@sakilacustomer.org', '1990-01-04'),
(31, 'BRENDA', 'WRIGHT', '999666999', 'BRENDA.WRIGHT@sakilacustomer.org', '1990-01-04'),
(32, 'AMY', 'LOPEZ', '999666999', 'AMY.LOPEZ@sakilacustomer.org', '1990-01-04'),
(33, 'ANNA', 'HILL', '999666999', 'ANNA.HILL@sakilacustomer.org', '1990-01-04'),
(34, 'REBECCA', 'SCOTT', '999666999', 'REBECCA.SCOTT@sakilacustomer.org', '1990-01-04'),
(35, 'VIRGINIA', 'GREEN', '999666999', 'VIRGINIA.GREEN@sakilacustomer.org', '1990-01-04'),
(36, 'KATHLEEN', 'ADAMS', '999666999', 'KATHLEEN.ADAMS@sakilacustomer.org', '1990-01-04'),
(37, 'PAMELA', 'BAKER', '999666999', 'PAMELA.BAKER@sakilacustomer.org', '1990-01-04'),
(38, 'MARTHA', 'GONZALEZ', '999666999', 'MARTHA.GONZALEZ@sakilacustomer.org', '1990-01-04'),
(39, 'DEBRA', 'NELSON', '999666999', 'DEBRA.NELSON@sakilacustomer.org', '1990-01-04'),
(40, 'AMANDA', 'CARTER', '999666999', 'AMANDA.CARTER@sakilacustomer.org', '1990-01-04'),
(41, 'STEPHANIE', 'MITCHELL', '999666999', 'STEPHANIE.MITCHELL@sakilacustomer.org', '1990-01-04'),
(42, 'CAROLYN', 'PEREZ', '999666999', 'CAROLYN.PEREZ@sakilacustomer.org', '1990-01-04'),
(43, 'CHRISTINE', 'ROBERTS', '999666999', 'CHRISTINE.ROBERTS@sakilacustomer.org', '1990-01-04'),
(44, 'MARIE', 'TURNER', '999666999', 'MARIE.TURNER@sakilacustomer.org', '1990-01-04'),
(45, 'JANET', 'PHILLIPS', '999666999', 'JANET.PHILLIPS@sakilacustomer.org', '1990-01-04'),
(46, 'CATHERINE', 'CAMPBELL', '999666999', 'CATHERINE.CAMPBELL@sakilacustomer.org', '1990-01-04'),
(47, 'FRANCES', 'PARKER', '999666999', 'FRANCES.PARKER@sakilacustomer.org', '1990-01-04'),
(48, 'ANN', 'EVANS', '999666999', 'ANN.EVANS@sakilacustomer.org', '1990-01-04'),
(49, 'JOYCE', 'EDWARDS', '999666999', 'JOYCE.EDWARDS@sakilacustomer.org', '1990-01-04'),
(50, 'DIANE', 'COLLINS', '999666999', 'DIANE.COLLINS@sakilacustomer.org', '1990-01-04'),
(51, 'ALICE', 'STEWART', '999666999', 'ALICE.STEWART@sakilacustomer.org', '1990-01-04'),
(52, 'JULIE', 'SANCHEZ', '999666999', 'JULIE.SANCHEZ@sakilacustomer.org', '1990-01-04'),
(53, 'HEATHER', 'MORRIS', '999666999', 'HEATHER.MORRIS@sakilacustomer.org', '1990-01-04'),
(54, 'TERESA', 'ROGERS', '999666999', 'TERESA.ROGERS@sakilacustomer.org', '1990-01-04'),
(55, 'DORIS', 'REED', '999666999', 'DORIS.REED@sakilacustomer.org', '1990-01-04'),
(56, 'GLORIA', 'COOK', '999666999', 'GLORIA.COOK@sakilacustomer.org', '1990-01-04'),
(57, 'EVELYN', 'MORGAN', '999666999', 'EVELYN.MORGAN@sakilacustomer.org', '1990-01-04'),
(58, 'JEAN', 'BELL', '999666999', 'JEAN.BELL@sakilacustomer.org', '1990-01-04'),
(59, 'CHERYL', 'MURPHY', '999666999', 'CHERYL.MURPHY@sakilacustomer.org', '1990-01-04'),
(60, 'MILDRED', 'BAILEY', '999666999', 'MILDRED.BAILEY@sakilacustomer.org', '1990-01-04'),
(61, 'KATHERINE', 'RIVERA', '999666999', 'KATHERINE.RIVERA@sakilacustomer.org', '1990-01-04'),
(62, 'JOAN', 'COOPER', '999666999', 'JOAN.COOPER@sakilacustomer.org', '1990-01-04'),
(63, 'ASHLEY', 'RICHARDSON', '999666999', 'ASHLEY.RICHARDSON@sakilacustomer.org', '1990-01-04'),
(64, 'JUDITH', 'COX', '999666999', 'JUDITH.COX@sakilacustomer.org', '1990-01-04'),
(65, 'ROSE', 'HOWARD', '999666999', 'ROSE.HOWARD@sakilacustomer.org', '1990-01-04'),
(66, 'JANICE', 'WARD', '999666999', 'JANICE.WARD@sakilacustomer.org', '1990-01-04'),
(67, 'KELLY', 'TORRES', '999666999', 'KELLY.TORRES@sakilacustomer.org', '1990-01-04'),
(68, 'NICOLE', 'PETERSON', '999666999', 'NICOLE.PETERSON@sakilacustomer.org', '1990-01-04'),
(69, 'JUDY', 'GRAY', '999666999', 'JUDY.GRAY@sakilacustomer.org', '1990-01-04'),
(70, 'CHRISTINA', 'RAMIREZ', '999666999', 'CHRISTINA.RAMIREZ@sakilacustomer.org', '1990-01-04'),
(71, 'KATHY', 'JAMES', '999666999', 'KATHY.JAMES@sakilacustomer.org', '1990-01-04'),
(72, 'THERESA', 'WATSON', '999666999', 'THERESA.WATSON@sakilacustomer.org', '1990-01-04'),
(73, 'BEVERLY', 'BROOKS', '999666999', 'BEVERLY.BROOKS@sakilacustomer.org', '1990-01-04'),
(74, 'DENISE', 'KELLY', '999666999', 'DENISE.KELLY@sakilacustomer.org', '1990-01-04'),
(75, 'TAMMY', 'SANDERS', '999666999', 'TAMMY.SANDERS@sakilacustomer.org', '1990-01-04'),
(76, 'IRENE', 'PRICE', '999666999', 'IRENE.PRICE@sakilacustomer.org', '1990-01-04'),
(77, 'JANE', 'BENNETT', '999666999', 'JANE.BENNETT@sakilacustomer.org', '1990-01-04'),
(78, 'LORI', 'WOOD', '999666999', 'LORI.WOOD@sakilacustomer.org', '1990-01-04'),
(79, 'RACHEL', 'BARNES', '999666999', 'RACHEL.BARNES@sakilacustomer.org', '1990-01-04'),
(80, 'MARILYN', 'ROSS', '999666999', 'MARILYN.ROSS@sakilacustomer.org', '1990-01-04'),
(81, 'ANDREA', 'HENDERSON', '999666999', 'ANDREA.HENDERSON@sakilacustomer.org', '1990-01-04'),
(82, 'KATHRYN', 'COLEMAN', '999666999', 'KATHRYN.COLEMAN@sakilacustomer.org', '1990-01-04'),
(83, 'LOUISE', 'JENKINS', '999666999', 'LOUISE.JENKINS@sakilacustomer.org', '1990-01-04'),
(84, 'SARA', 'PERRY', '999666999', 'SARA.PERRY@sakilacustomer.org', '1990-01-04'),
(85, 'ANNE', 'POWELL', '999666999', 'ANNE.POWELL@sakilacustomer.org', '1990-01-04'),
(86, 'JACQUELINE', 'LONG', '999666999', 'JACQUELINE.LONG@sakilacustomer.org', '1990-01-04'),
(87, 'WANDA', 'PATTERSON', '999666999', 'WANDA.PATTERSON@sakilacustomer.org', '1990-01-04'),
(88, 'BONNIE', 'HUGHES', '999666999', 'BONNIE.HUGHES@sakilacustomer.org', '1990-01-04'),
(89, 'JULIA', 'FLORES', '999666999', 'JULIA.FLORES@sakilacustomer.org', '1990-01-04'),
(90, 'RUBY', 'WASHINGTON', '999666999', 'RUBY.WASHINGTON@sakilacustomer.org', '1990-01-04'),
(91, 'LOIS', 'BUTLER', '999666999', 'LOIS.BUTLER@sakilacustomer.org', '1990-01-04'),
(92, 'TINA', 'SIMMONS', '999666999', 'TINA.SIMMONS@sakilacustomer.org', '1990-01-04'),
(93, 'PHYLLIS', 'FOSTER', '999666999', 'PHYLLIS.FOSTER@sakilacustomer.org', '1990-01-04'),
(94, 'NORMA', 'GONZALES', '999666999', 'NORMA.GONZALES@sakilacustomer.org', '1990-01-04'),
(95, 'PAULA', 'BRYANT', '999666999', 'PAULA.BRYANT@sakilacustomer.org', '1990-01-04'),
(96, 'DIANA', 'ALEXANDER', '999666999', 'DIANA.ALEXANDER@sakilacustomer.org', '1990-01-04'),
(97, 'ANNIE', 'RUSSELL', '999666999', 'ANNIE.RUSSELL@sakilacustomer.org', '1990-01-04'),
(98, 'LILLIAN', 'GRIFFIN', '999666999', 'LILLIAN.GRIFFIN@sakilacustomer.org', '1990-01-04'),
(99, 'EMILY', 'DIAZ', '999666999', 'EMILY.DIAZ@sakilacustomer.org', '1990-01-04'),
(100, 'ROBIN', 'HAYES', '999666999', 'ROBIN.HAYES@sakilacustomer.org', '1990-01-04'),
(101, 'PEGGY', 'MYERS', '999666999', 'PEGGY.MYERS@sakilacustomer.org', '1990-01-04'),
(102, 'CRYSTAL', 'FORD', '999666999', 'CRYSTAL.FORD@sakilacustomer.org', '1990-01-04'),
(103, 'GLADYS', 'HAMILTON', '999666999', 'GLADYS.HAMILTON@sakilacustomer.org', '1990-01-04'),
(104, 'RITA', 'GRAHAM', '999666999', 'RITA.GRAHAM@sakilacustomer.org', '1990-01-04'),
(105, 'DAWN', 'SULLIVAN', '999666999', 'DAWN.SULLIVAN@sakilacustomer.org', '1990-01-04'),
(106, 'CONNIE', 'WALLACE', '999666999', 'CONNIE.WALLACE@sakilacustomer.org', '1990-01-04'),
(107, 'FLORENCE', 'WOODS', '999666999', 'FLORENCE.WOODS@sakilacustomer.org', '1990-01-04'),
(108, 'TRACY', 'COLE', '999666999', 'TRACY.COLE@sakilacustomer.org', '1990-01-04'),
(109, 'EDNA', 'WEST', '999666999', 'EDNA.WEST@sakilacustomer.org', '1990-01-04'),
(110, 'TIFFANY', 'JORDAN', '999666999', 'TIFFANY.JORDAN@sakilacustomer.org', '1990-01-04'),
(111, 'CARMEN', 'OWENS', '999666999', 'CARMEN.OWENS@sakilacustomer.org', '1990-01-04'),
(112, 'ROSA', 'REYNOLDS', '999666999', 'ROSA.REYNOLDS@sakilacustomer.org', '1990-01-04'),
(113, 'CINDY', 'FISHER', '999666999', 'CINDY.FISHER@sakilacustomer.org', '1990-01-04'),
(114, 'GRACE', 'ELLIS', '999666999', 'GRACE.ELLIS@sakilacustomer.org', '1990-01-04'),
(115, 'WENDY', 'HARRISON', '999666999', 'WENDY.HARRISON@sakilacustomer.org', '1990-01-04'),
(116, 'VICTORIA', 'GIBSON', '999666999', 'VICTORIA.GIBSON@sakilacustomer.org', '1990-01-04'),
(117, 'EDITH', 'MCDONALD', '999666999', 'EDITH.MCDONALD@sakilacustomer.org', '1990-01-04'),
(118, 'KIM', 'CRUZ', '999666999', 'KIM.CRUZ@sakilacustomer.org', '1990-01-04'),
(119, 'SHERRY', 'MARSHALL', '999666999', 'SHERRY.MARSHALL@sakilacustomer.org', '1990-01-04'),
(120, 'SYLVIA', 'ORTIZ', '999666999', 'SYLVIA.ORTIZ@sakilacustomer.org', '1990-01-04'),
(121, 'JOSEPHINE', 'GOMEZ', '999666999', 'JOSEPHINE.GOMEZ@sakilacustomer.org', '1990-01-04'),
(122, 'THELMA', 'MURRAY', '999666999', 'THELMA.MURRAY@sakilacustomer.org', '1990-01-04'),
(123, 'SHANNON', 'FREEMAN', '999666999', 'SHANNON.FREEMAN@sakilacustomer.org', '1990-01-04'),
(124, 'SHEILA', 'WELLS', '999666999', 'SHEILA.WELLS@sakilacustomer.org', '1990-01-04'),
(125, 'ETHEL', 'WEBB', '999666999', 'ETHEL.WEBB@sakilacustomer.org', '1990-01-04'),
(126, 'ELLEN', 'SIMPSON', '999666999', 'ELLEN.SIMPSON@sakilacustomer.org', '1990-01-04'),
(127, 'ELAINE', 'STEVENS', '999666999', 'ELAINE.STEVENS@sakilacustomer.org', '1990-01-04'),
(128, 'MARJORIE', 'TUCKER', '999666999', 'MARJORIE.TUCKER@sakilacustomer.org', '1990-01-04'),
(129, 'CARRIE', 'PORTER', '999666999', 'CARRIE.PORTER@sakilacustomer.org', '1990-01-04'),
(130, 'CHARLOTTE', 'HUNTER', '999666999', 'CHARLOTTE.HUNTER@sakilacustomer.org', '1990-01-04'),
(131, 'MONICA', 'HICKS', '999666999', 'MONICA.HICKS@sakilacustomer.org', '1990-01-04'),
(132, 'ESTHER', 'CRAWFORD', '999666999', 'ESTHER.CRAWFORD@sakilacustomer.org', '1990-01-04'),
(133, 'PAULINE', 'HENRY', '999666999', 'PAULINE.HENRY@sakilacustomer.org', '1990-01-04'),
(134, 'EMMA', 'BOYD', '999666999', 'EMMA.BOYD@sakilacustomer.org', '1990-01-04'),
(135, 'JUANITA', 'MASON', '999666999', 'JUANITA.MASON@sakilacustomer.org', '1990-01-04'),
(136, 'ANITA', 'MORALES', '999666999', 'ANITA.MORALES@sakilacustomer.org', '1990-01-04'),
(137, 'RHONDA', 'KENNEDY', '999666999', 'RHONDA.KENNEDY@sakilacustomer.org', '1990-01-04'),
(138, 'HAZEL', 'WARREN', '999666999', 'HAZEL.WARREN@sakilacustomer.org', '1990-01-04'),
(139, 'AMBER', 'DIXON', '999666999', 'AMBER.DIXON@sakilacustomer.org', '1990-01-04'),
(140, 'EVA', 'RAMOS', '999666999', 'EVA.RAMOS@sakilacustomer.org', '1990-01-04'),
(141, 'DEBBIE', 'REYES', '999666999', 'DEBBIE.REYES@sakilacustomer.org', '1990-01-04'),
(142, 'APRIL', 'BURNS', '999666999', 'APRIL.BURNS@sakilacustomer.org', '1990-01-04'),
(143, 'LESLIE', 'GORDON', '999666999', 'LESLIE.GORDON@sakilacustomer.org', '1990-01-04'),
(144, 'CLARA', 'SHAW', '999666999', 'CLARA.SHAW@sakilacustomer.org', '1990-01-04'),
(145, 'LUCILLE', 'HOLMES', '999666999', 'LUCILLE.HOLMES@sakilacustomer.org', '1990-01-04'),
(146, 'JAMIE', 'RICE', '999666999', 'JAMIE.RICE@sakilacustomer.org', '1990-01-04'),
(147, 'JOANNE', 'ROBERTSON', '999666999', 'JOANNE.ROBERTSON@sakilacustomer.org', '1990-01-04'),
(148, 'ELEANOR', 'HUNT', '999666999', 'ELEANOR.HUNT@sakilacustomer.org', '1990-01-04'),
(149, 'VALERIE', 'BLACK', '999666999', 'VALERIE.BLACK@sakilacustomer.org', '1990-01-04'),
(150, 'DANIELLE', 'DANIELS', '999666999', 'DANIELLE.DANIELS@sakilacustomer.org', '1990-01-04'),
(151, 'MEGAN', 'PALMER', '999666999', 'MEGAN.PALMER@sakilacustomer.org', '1990-01-04'),
(152, 'ALICIA', 'MILLS', '999666999', 'ALICIA.MILLS@sakilacustomer.org', '1990-01-04'),
(153, 'SUZANNE', 'NICHOLS', '999666999', 'SUZANNE.NICHOLS@sakilacustomer.org', '1990-01-04'),
(154, 'MICHELE', 'GRANT', '999666999', 'MICHELE.GRANT@sakilacustomer.org', '1990-01-04'),
(155, 'GAIL', 'KNIGHT', '999666999', 'GAIL.KNIGHT@sakilacustomer.org', '1990-01-04'),
(156, 'BERTHA', 'FERGUSON', '999666999', 'BERTHA.FERGUSON@sakilacustomer.org', '1990-01-04'),
(157, 'DARLENE', 'ROSE', '999666999', 'DARLENE.ROSE@sakilacustomer.org', '1990-01-04'),
(158, 'VERONICA', 'STONE', '999666999', 'VERONICA.STONE@sakilacustomer.org', '1990-01-04'),
(159, 'JILL', 'HAWKINS', '999666999', 'JILL.HAWKINS@sakilacustomer.org', '1990-01-04'),
(160, 'ERIN', 'DUNN', '999666999', 'ERIN.DUNN@sakilacustomer.org', '1990-01-04'),
(161, 'GERALDINE', 'PERKINS', '999666999', 'GERALDINE.PERKINS@sakilacustomer.org', '1990-01-04'),
(162, 'LAUREN', 'HUDSON', '999666999', 'LAUREN.HUDSON@sakilacustomer.org', '1990-01-04'),
(163, 'CATHY', 'SPENCER', '999666999', 'CATHY.SPENCER@sakilacustomer.org', '1990-01-04'),
(164, 'JOANN', 'GARDNER', '999666999', 'JOANN.GARDNER@sakilacustomer.org', '1990-01-04'),
(165, 'LORRAINE', 'STEPHENS', '999666999', 'LORRAINE.STEPHENS@sakilacustomer.org', '1990-01-04'),
(166, 'LYNN', 'PAYNE', '999666999', 'LYNN.PAYNE@sakilacustomer.org', '1990-01-04'),
(167, 'SALLY', 'PIERCE', '999666999', 'SALLY.PIERCE@sakilacustomer.org', '1990-01-04'),
(168, 'REGINA', 'BERRY', '999666999', 'REGINA.BERRY@sakilacustomer.org', '1990-01-04'),
(169, 'ERICA', 'MATTHEWS', '999666999', 'ERICA.MATTHEWS@sakilacustomer.org', '1990-01-04'),
(170, 'BEATRICE', 'ARNOLD', '999666999', 'BEATRICE.ARNOLD@sakilacustomer.org', '1990-01-04'),
(171, 'DOLORES', 'WAGNER', '999666999', 'DOLORES.WAGNER@sakilacustomer.org', '1990-01-04'),
(172, 'BERNICE', 'WILLIS', '999666999', 'BERNICE.WILLIS@sakilacustomer.org', '1990-01-04'),
(173, 'AUDREY', 'RAY', '999666999', 'AUDREY.RAY@sakilacustomer.org', '1990-01-04'),
(174, 'YVONNE', 'WATKINS', '999666999', 'YVONNE.WATKINS@sakilacustomer.org', '1990-01-04'),
(175, 'ANNETTE', 'OLSON', '999666999', 'ANNETTE.OLSON@sakilacustomer.org', '1990-01-04'),
(176, 'JUNE', 'CARROLL', '999666999', 'JUNE.CARROLL@sakilacustomer.org', '1990-01-04'),
(177, 'SAMANTHA', 'DUNCAN', '999666999', 'SAMANTHA.DUNCAN@sakilacustomer.org', '1990-01-04'),
(178, 'MARION', 'SNYDER', '999666999', 'MARION.SNYDER@sakilacustomer.org', '1990-01-04'),
(179, 'DANA', 'HART', '999666999', 'DANA.HART@sakilacustomer.org', '1990-01-04'),
(180, 'STACY', 'CUNNINGHAM', '999666999', 'STACY.CUNNINGHAM@sakilacustomer.org', '1990-01-04'),
(181, 'ANA', 'BRADLEY', '999666999', 'ANA.BRADLEY@sakilacustomer.org', '1990-01-04'),
(182, 'RENEE', 'LANE', '999666999', 'RENEE.LANE@sakilacustomer.org', '1990-01-04'),
(183, 'IDA', 'ANDREWS', '999666999', 'IDA.ANDREWS@sakilacustomer.org', '1990-01-04'),
(184, 'VIVIAN', 'RUIZ', '999666999', 'VIVIAN.RUIZ@sakilacustomer.org', '1990-01-04'),
(185, 'ROBERTA', 'HARPER', '999666999', 'ROBERTA.HARPER@sakilacustomer.org', '1990-01-04'),
(186, 'HOLLY', 'FOX', '999666999', 'HOLLY.FOX@sakilacustomer.org', '1990-01-04'),
(187, 'BRITTANY', 'RILEY', '999666999', 'BRITTANY.RILEY@sakilacustomer.org', '1990-01-04'),
(188, 'MELANIE', 'ARMSTRONG', '999666999', 'MELANIE.ARMSTRONG@sakilacustomer.org', '1990-01-04'),
(189, 'LORETTA', 'CARPENTER', '999666999', 'LORETTA.CARPENTER@sakilacustomer.org', '1990-01-04'),
(190, 'YOLANDA', 'WEAVER', '999666999', 'YOLANDA.WEAVER@sakilacustomer.org', '1990-01-04'),
(191, 'JEANETTE', 'GREENE', '999666999', 'JEANETTE.GREENE@sakilacustomer.org', '1990-01-04'),
(192, 'LAURIE', 'LAWRENCE', '999666999', 'LAURIE.LAWRENCE@sakilacustomer.org', '1990-01-04'),
(193, 'KATIE', 'ELLIOTT', '999666999', 'KATIE.ELLIOTT@sakilacustomer.org', '1990-01-04'),
(194, 'KRISTEN', 'CHAVEZ', '999666999', 'KRISTEN.CHAVEZ@sakilacustomer.org', '1990-01-04'),
(195, 'VANESSA', 'SIMS', '999666999', 'VANESSA.SIMS@sakilacustomer.org', '1990-01-04'),
(196, 'ALMA', 'AUSTIN', '999666999', 'ALMA.AUSTIN@sakilacustomer.org', '1990-01-04'),
(197, 'SUE', 'PETERS', '999666999', 'SUE.PETERS@sakilacustomer.org', '1990-01-04'),
(198, 'ELSIE', 'KELLEY', '999666999', 'ELSIE.KELLEY@sakilacustomer.org', '1990-01-04'),
(199, 'BETH', 'FRANKLIN', '999666999', 'BETH.FRANKLIN@sakilacustomer.org', '1990-01-04'),
(200, 'JEANNE', 'LAWSON', '999666999', 'JEANNE.LAWSON@sakilacustomer.org', '1990-01-04'),
(201, 'VICKI', 'FIELDS', '999666999', 'VICKI.FIELDS@sakilacustomer.org', '1990-01-04'),
(202, 'CARLA', 'GUTIERREZ', '999666999', 'CARLA.GUTIERREZ@sakilacustomer.org', '1990-01-04'),
(203, 'TARA', 'RYAN', '999666999', 'TARA.RYAN@sakilacustomer.org', '1990-01-04'),
(204, 'ROSEMARY', 'SCHMIDT', '999666999', 'ROSEMARY.SCHMIDT@sakilacustomer.org', '1990-01-04'),
(205, 'EILEEN', 'CARR', '999666999', 'EILEEN.CARR@sakilacustomer.org', '1990-01-04'),
(206, 'TERRI', 'VASQUEZ', '999666999', 'TERRI.VASQUEZ@sakilacustomer.org', '1990-01-04'),
(207, 'GERTRUDE', 'CASTILLO', '999666999', 'GERTRUDE.CASTILLO@sakilacustomer.org', '1990-01-04'),
(208, 'LUCY', 'WHEELER', '999666999', 'LUCY.WHEELER@sakilacustomer.org', '1990-01-04'),
(209, 'TONYA', 'CHAPMAN', '999666999', 'TONYA.CHAPMAN@sakilacustomer.org', '1990-01-04'),
(210, 'ELLA', 'OLIVER', '999666999', 'ELLA.OLIVER@sakilacustomer.org', '1990-01-04'),
(211, 'STACEY', 'MONTGOMERY', '999666999', 'STACEY.MONTGOMERY@sakilacustomer.org', '1990-01-04'),
(212, 'WILMA', 'RICHARDS', '999666999', 'WILMA.RICHARDS@sakilacustomer.org', '1990-01-04'),
(213, 'GINA', 'WILLIAMSON', '999666999', 'GINA.WILLIAMSON@sakilacustomer.org', '1990-01-04'),
(214, 'KRISTIN', 'JOHNSTON', '999666999', 'KRISTIN.JOHNSTON@sakilacustomer.org', '1990-01-04'),
(215, 'JESSIE', 'BANKS', '999666999', 'JESSIE.BANKS@sakilacustomer.org', '1990-01-04'),
(216, 'NATALIE', 'MEYER', '999666999', 'NATALIE.MEYER@sakilacustomer.org', '1990-01-04'),
(217, 'AGNES', 'BISHOP', '999666999', 'AGNES.BISHOP@sakilacustomer.org', '1990-01-04'),
(218, 'VERA', 'MCCOY', '999666999', 'VERA.MCCOY@sakilacustomer.org', '1990-01-04'),
(219, 'WILLIE', 'HOWELL', '999666999', 'WILLIE.HOWELL@sakilacustomer.org', '1990-01-04'),
(220, 'CHARLENE', 'ALVAREZ', '999666999', 'CHARLENE.ALVAREZ@sakilacustomer.org', '1990-01-04'),
(221, 'BESSIE', 'MORRISON', '999666999', 'BESSIE.MORRISON@sakilacustomer.org', '1990-01-04'),
(222, 'DELORES', 'HANSEN', '999666999', 'DELORES.HANSEN@sakilacustomer.org', '1990-01-04'),
(223, 'MELINDA', 'FERNANDEZ', '999666999', 'MELINDA.FERNANDEZ@sakilacustomer.org', '1990-01-04'),
(224, 'PEARL', 'GARZA', '999666999', 'PEARL.GARZA@sakilacustomer.org', '1990-01-04'),
(225, 'ARLENE', 'HARVEY', '999666999', 'ARLENE.HARVEY@sakilacustomer.org', '1990-01-04'),
(226, 'MAUREEN', 'LITTLE', '999666999', 'MAUREEN.LITTLE@sakilacustomer.org', '1990-01-04'),
(227, 'COLLEEN', 'BURTON', '999666999', 'COLLEEN.BURTON@sakilacustomer.org', '1990-01-04'),
(228, 'ALLISON', 'STANLEY', '999666999', 'ALLISON.STANLEY@sakilacustomer.org', '1990-01-04'),
(229, 'TAMARA', 'NGUYEN', '999666999', 'TAMARA.NGUYEN@sakilacustomer.org', '1990-01-04'),
(230, 'JOY', 'GEORGE', '999666999', 'JOY.GEORGE@sakilacustomer.org', '1990-01-04'),
(231, 'GEORGIA', 'JACOBS', '999666999', 'GEORGIA.JACOBS@sakilacustomer.org', '1990-01-04'),
(232, 'CONSTANCE', 'REID', '999666999', 'CONSTANCE.REID@sakilacustomer.org', '1990-01-04'),
(233, 'LILLIE', 'KIM', '999666999', 'LILLIE.KIM@sakilacustomer.org', '1990-01-04'),
(234, 'CLAUDIA', 'FULLER', '999666999', 'CLAUDIA.FULLER@sakilacustomer.org', '1990-01-04'),
(235, 'JACKIE', 'LYNCH', '999666999', 'JACKIE.LYNCH@sakilacustomer.org', '1990-01-04'),
(236, 'MARCIA', 'DEAN', '999666999', 'MARCIA.DEAN@sakilacustomer.org', '1990-01-04'),
(237, 'TANYA', 'GILBERT', '999666999', 'TANYA.GILBERT@sakilacustomer.org', '1990-01-04'),
(238, 'NELLIE', 'GARRETT', '999666999', 'NELLIE.GARRETT@sakilacustomer.org', '1990-01-04'),
(239, 'MINNIE', 'ROMERO', '999666999', 'MINNIE.ROMERO@sakilacustomer.org', '1990-01-04'),
(240, 'MARLENE', 'WELCH', '999666999', 'MARLENE.WELCH@sakilacustomer.org', '1990-01-04'),
(241, 'HEIDI', 'LARSON', '999666999', 'HEIDI.LARSON@sakilacustomer.org', '1990-01-04'),
(242, 'GLENDA', 'FRAZIER', '999666999', 'GLENDA.FRAZIER@sakilacustomer.org', '1990-01-04'),
(243, 'LYDIA', 'BURKE', '999666999', 'LYDIA.BURKE@sakilacustomer.org', '1990-01-04'),
(244, 'VIOLA', 'HANSON', '999666999', 'VIOLA.HANSON@sakilacustomer.org', '1990-01-04'),
(245, 'COURTNEY', 'DAY', '999666999', 'COURTNEY.DAY@sakilacustomer.org', '1990-01-04'),
(246, 'MARIAN', 'MENDOZA', '999666999', 'MARIAN.MENDOZA@sakilacustomer.org', '1990-01-04'),
(247, 'STELLA', 'MORENO', '999666999', 'STELLA.MORENO@sakilacustomer.org', '1990-01-04'),
(248, 'CAROLINE', 'BOWMAN', '999666999', 'CAROLINE.BOWMAN@sakilacustomer.org', '1990-01-04'),
(249, 'DORA', 'MEDINA', '999666999', 'DORA.MEDINA@sakilacustomer.org', '1990-01-04'),
(250, 'JO', 'FOWLER', '999666999', 'JO.FOWLER@sakilacustomer.org', '1990-01-04'),
(251, 'VICKIE', 'BREWER', '999666999', 'VICKIE.BREWER@sakilacustomer.org', '1990-01-04'),
(252, 'MATTIE', 'HOFFMAN', '999666999', 'MATTIE.HOFFMAN@sakilacustomer.org', '1990-01-04'),
(253, 'TERRY', 'CARLSON', '999666999', 'TERRY.CARLSON@sakilacustomer.org', '1990-01-04'),
(254, 'MAXINE', 'SILVA', '999666999', 'MAXINE.SILVA@sakilacustomer.org', '1990-01-04'),
(255, 'IRMA', 'PEARSON', '999666999', 'IRMA.PEARSON@sakilacustomer.org', '1990-01-04'),
(256, 'MABEL', 'HOLLAND', '999666999', 'MABEL.HOLLAND@sakilacustomer.org', '1990-01-04'),
(257, 'MARSHA', 'DOUGLAS', '999666999', 'MARSHA.DOUGLAS@sakilacustomer.org', '1990-01-04'),
(258, 'MYRTLE', 'FLEMING', '999666999', 'MYRTLE.FLEMING@sakilacustomer.org', '1990-01-04'),
(259, 'LENA', 'JENSEN', '999666999', 'LENA.JENSEN@sakilacustomer.org', '1990-01-04'),
(260, 'CHRISTY', 'VARGAS', '999666999', 'CHRISTY.VARGAS@sakilacustomer.org', '1990-01-04'),
(261, 'DEANNA', 'BYRD', '999666999', 'DEANNA.BYRD@sakilacustomer.org', '1990-01-04'),
(262, 'PATSY', 'DAVIDSON', '999666999', 'PATSY.DAVIDSON@sakilacustomer.org', '1990-01-04'),
(263, 'HILDA', 'HOPKINS', '999666999', 'HILDA.HOPKINS@sakilacustomer.org', '1990-01-04'),
(264, 'GWENDOLYN', 'MAY', '999666999', 'GWENDOLYN.MAY@sakilacustomer.org', '1990-01-04'),
(265, 'JENNIE', 'TERRY', '999666999', 'JENNIE.TERRY@sakilacustomer.org', '1990-01-04'),
(266, 'NORA', 'HERRERA', '999666999', 'NORA.HERRERA@sakilacustomer.org', '1990-01-04'),
(267, 'MARGIE', 'WADE', '999666999', 'MARGIE.WADE@sakilacustomer.org', '1990-01-04'),
(268, 'NINA', 'SOTO', '999666999', 'NINA.SOTO@sakilacustomer.org', '1990-01-04'),
(269, 'CASSANDRA', 'WALTERS', '999666999', 'CASSANDRA.WALTERS@sakilacustomer.org', '1990-01-04'),
(270, 'LEAH', 'CURTIS', '999666999', 'LEAH.CURTIS@sakilacustomer.org', '1990-01-04'),
(271, 'PENNY', 'NEAL', '999666999', 'PENNY.NEAL@sakilacustomer.org', '1990-01-04'),
(272, 'KAY', 'CALDWELL', '999666999', 'KAY.CALDWELL@sakilacustomer.org', '1990-01-04'),
(273, 'PRISCILLA', 'LOWE', '999666999', 'PRISCILLA.LOWE@sakilacustomer.org', '1990-01-04'),
(274, 'NAOMI', 'JENNINGS', '999666999', 'NAOMI.JENNINGS@sakilacustomer.org', '1990-01-04'),
(275, 'CAROLE', 'BARNETT', '999666999', 'CAROLE.BARNETT@sakilacustomer.org', '1990-01-04'),
(276, 'BRANDY', 'GRAVES', '999666999', 'BRANDY.GRAVES@sakilacustomer.org', '1990-01-04'),
(277, 'OLGA', 'JIMENEZ', '999666999', 'OLGA.JIMENEZ@sakilacustomer.org', '1990-01-04'),
(278, 'BILLIE', 'HORTON', '999666999', 'BILLIE.HORTON@sakilacustomer.org', '1990-01-04'),
(279, 'DIANNE', 'SHELTON', '999666999', 'DIANNE.SHELTON@sakilacustomer.org', '1990-01-04'),
(280, 'TRACEY', 'BARRETT', '999666999', 'TRACEY.BARRETT@sakilacustomer.org', '1990-01-04'),
(281, 'LEONA', 'OBRIEN', '999666999', 'LEONA.OBRIEN@sakilacustomer.org', '1990-01-04'),
(282, 'JENNY', 'CASTRO', '999666999', 'JENNY.CASTRO@sakilacustomer.org', '1990-01-04'),
(283, 'FELICIA', 'SUTTON', '999666999', 'FELICIA.SUTTON@sakilacustomer.org', '1990-01-04'),
(284, 'SONIA', 'GREGORY', '999666999', 'SONIA.GREGORY@sakilacustomer.org', '1990-01-04'),
(285, 'MIRIAM', 'MCKINNEY', '999666999', 'MIRIAM.MCKINNEY@sakilacustomer.org', '1990-01-04'),
(286, 'VELMA', 'LUCAS', '999666999', 'VELMA.LUCAS@sakilacustomer.org', '1990-01-04'),
(287, 'BECKY', 'MILES', '999666999', 'BECKY.MILES@sakilacustomer.org', '1990-01-04'),
(288, 'BOBBIE', 'CRAIG', '999666999', 'BOBBIE.CRAIG@sakilacustomer.org', '1990-01-04'),
(289, 'VIOLET', 'RODRIQUEZ', '999666999', 'VIOLET.RODRIQUEZ@sakilacustomer.org', '1990-01-04'),
(290, 'KRISTINA', 'CHAMBERS', '999666999', 'KRISTINA.CHAMBERS@sakilacustomer.org', '1990-01-04'),
(291, 'TONI', 'HOLT', '999666999', 'TONI.HOLT@sakilacustomer.org', '1990-01-04'),
(292, 'MISTY', 'LAMBERT', '999666999', 'MISTY.LAMBERT@sakilacustomer.org', '1990-01-04'),
(293, 'MAE', 'FLETCHER', '999666999', 'MAE.FLETCHER@sakilacustomer.org', '1990-01-04'),
(294, 'SHELLY', 'WATTS', '999666999', 'SHELLY.WATTS@sakilacustomer.org', '1990-01-04'),
(295, 'DAISY', 'BATES', '999666999', 'DAISY.BATES@sakilacustomer.org', '1990-01-04'),
(296, 'RAMONA', 'HALE', '999666999', 'RAMONA.HALE@sakilacustomer.org', '1990-01-04'),
(297, 'SHERRI', 'RHODES', '999666999', 'SHERRI.RHODES@sakilacustomer.org', '1990-01-04'),
(298, 'ERIKA', 'PENA', '999666999', 'ERIKA.PENA@sakilacustomer.org', '1990-01-04'),
(299, 'JAMES', 'GANNON', '999666999', 'JAMES.GANNON@sakilacustomer.org', '1990-01-04'),
(300, 'JOHN', 'FARNSWORTH', '999666999', 'JOHN.FARNSWORTH@sakilacustomer.org', '1990-01-04'),
(301, 'ROBERT', 'BAUGHMAN', '999666999', 'ROBERT.BAUGHMAN@sakilacustomer.org', '1990-01-04'),
(302, 'MICHAEL', 'SILVERMAN', '999666999', 'MICHAEL.SILVERMAN@sakilacustomer.org', '1990-01-04'),
(303, 'WILLIAM', 'SATTERFIELD', '999666999', 'WILLIAM.SATTERFIELD@sakilacustomer.org', '1990-01-04'),
(304, 'DAVID', 'ROYAL', '999666999', 'DAVID.ROYAL@sakilacustomer.org', '1990-01-04'),
(305, 'RICHARD', 'MCCRARY', '999666999', 'RICHARD.MCCRARY@sakilacustomer.org', '1990-01-04'),
(306, 'CHARLES', 'KOWALSKI', '999666999', 'CHARLES.KOWALSKI@sakilacustomer.org', '1990-01-04'),
(307, 'JOSEPH', 'JOY', '999666999', 'JOSEPH.JOY@sakilacustomer.org', '1990-01-04'),
(308, 'THOMAS', 'GRIGSBY', '999666999', 'THOMAS.GRIGSBY@sakilacustomer.org', '1990-01-04'),
(309, 'CHRISTOPHER', 'GRECO', '999666999', 'CHRISTOPHER.GRECO@sakilacustomer.org', '1990-01-04'),
(310, 'DANIEL', 'CABRAL', '999666999', 'DANIEL.CABRAL@sakilacustomer.org', '1990-01-04'),
(311, 'PAUL', 'TROUT', '999666999', 'PAUL.TROUT@sakilacustomer.org', '1990-01-04'),
(312, 'MARK', 'RINEHART', '999666999', 'MARK.RINEHART@sakilacustomer.org', '1990-01-04'),
(313, 'DONALD', 'MAHON', '999666999', 'DONALD.MAHON@sakilacustomer.org', '1990-01-04'),
(314, 'GEORGE', 'LINTON', '999666999', 'GEORGE.LINTON@sakilacustomer.org', '1990-01-04'),
(315, 'KENNETH', 'GOODEN', '999666999', 'KENNETH.GOODEN@sakilacustomer.org', '1990-01-04'),
(316, 'STEVEN', 'CURLEY', '999666999', 'STEVEN.CURLEY@sakilacustomer.org', '1990-01-04'),
(317, 'EDWARD', 'BAUGH', '999666999', 'EDWARD.BAUGH@sakilacustomer.org', '1990-01-04'),
(318, 'BRIAN', 'WYMAN', '999666999', 'BRIAN.WYMAN@sakilacustomer.org', '1990-01-04'),
(319, 'RONALD', 'WEINER', '999666999', 'RONALD.WEINER@sakilacustomer.org', '1990-01-04'),
(320, 'ANTHONY', 'SCHWAB', '999666999', 'ANTHONY.SCHWAB@sakilacustomer.org', '1990-01-04'),
(321, 'KEVIN', 'SCHULER', '999666999', 'KEVIN.SCHULER@sakilacustomer.org', '1990-01-04'),
(322, 'JASON', 'MORRISSEY', '999666999', 'JASON.MORRISSEY@sakilacustomer.org', '1990-01-04'),
(323, 'MATTHEW', 'MAHAN', '999666999', 'MATTHEW.MAHAN@sakilacustomer.org', '1990-01-04'),
(324, 'GARY', 'COY', '999666999', 'GARY.COY@sakilacustomer.org', '1990-01-04'),
(325, 'TIMOTHY', 'BUNN', '999666999', 'TIMOTHY.BUNN@sakilacustomer.org', '1990-01-04'),
(326, 'JOSE', 'ANDREW', '999666999', 'JOSE.ANDREW@sakilacustomer.org', '1990-01-04'),
(327, 'LARRY', 'THRASHER', '999666999', 'LARRY.THRASHER@sakilacustomer.org', '1990-01-04'),
(328, 'JEFFREY', 'SPEAR', '999666999', 'JEFFREY.SPEAR@sakilacustomer.org', '1990-01-04'),
(329, 'FRANK', 'WAGGONER', '999666999', 'FRANK.WAGGONER@sakilacustomer.org', '1990-01-04'),
(330, 'SCOTT', 'SHELLEY', '999666999', 'SCOTT.SHELLEY@sakilacustomer.org', '1990-01-04'),
(331, 'ERIC', 'ROBERT', '999666999', 'ERIC.ROBERT@sakilacustomer.org', '1990-01-04'),
(332, 'STEPHEN', 'QUALLS', '999666999', 'STEPHEN.QUALLS@sakilacustomer.org', '1990-01-04'),
(333, 'ANDREW', 'PURDY', '999666999', 'ANDREW.PURDY@sakilacustomer.org', '1990-01-04'),
(334, 'RAYMOND', 'MCWHORTER', '999666999', 'RAYMOND.MCWHORTER@sakilacustomer.org', '1990-01-04'),
(335, 'GREGORY', 'MAULDIN', '999666999', 'GREGORY.MAULDIN@sakilacustomer.org', '1990-01-04'),
(336, 'JOSHUA', 'MARK', '999666999', 'JOSHUA.MARK@sakilacustomer.org', '1990-01-04'),
(337, 'JERRY', 'JORDON', '999666999', 'JERRY.JORDON@sakilacustomer.org', '1990-01-04'),
(338, 'DENNIS', 'GILMAN', '999666999', 'DENNIS.GILMAN@sakilacustomer.org', '1990-01-04'),
(339, 'WALTER', 'PERRYMAN', '999666999', 'WALTER.PERRYMAN@sakilacustomer.org', '1990-01-04'),
(340, 'PATRICK', 'NEWSOM', '999666999', 'PATRICK.NEWSOM@sakilacustomer.org', '1990-01-04'),
(341, 'PETER', 'MENARD', '999666999', 'PETER.MENARD@sakilacustomer.org', '1990-01-04'),
(342, 'HAROLD', 'MARTINO', '999666999', 'HAROLD.MARTINO@sakilacustomer.org', '1990-01-04'),
(343, 'DOUGLAS', 'GRAF', '999666999', 'DOUGLAS.GRAF@sakilacustomer.org', '1990-01-04'),
(344, 'HENRY', 'BILLINGSLEY', '999666999', 'HENRY.BILLINGSLEY@sakilacustomer.org', '1990-01-04'),
(345, 'CARL', 'ARTIS', '999666999', 'CARL.ARTIS@sakilacustomer.org', '1990-01-04'),
(346, 'ARTHUR', 'SIMPKINS', '999666999', 'ARTHUR.SIMPKINS@sakilacustomer.org', '1990-01-04'),
(347, 'RYAN', 'SALISBURY', '999666999', 'RYAN.SALISBURY@sakilacustomer.org', '1990-01-04'),
(348, 'ROGER', 'QUINTANILLA', '999666999', 'ROGER.QUINTANILLA@sakilacustomer.org', '1990-01-04'),
(349, 'JOE', 'GILLILAND', '999666999', 'JOE.GILLILAND@sakilacustomer.org', '1990-01-04'),
(350, 'JUAN', 'FRALEY', '999666999', 'JUAN.FRALEY@sakilacustomer.org', '1990-01-04'),
(351, 'JACK', 'FOUST', '999666999', 'JACK.FOUST@sakilacustomer.org', '1990-01-04'),
(352, 'ALBERT', 'CROUSE', '999666999', 'ALBERT.CROUSE@sakilacustomer.org', '1990-01-04'),
(353, 'JONATHAN', 'SCARBOROUGH', '999666999', 'JONATHAN.SCARBOROUGH@sakilacustomer.org', '1990-01-04'),
(354, 'JUSTIN', 'NGO', '999666999', 'JUSTIN.NGO@sakilacustomer.org', '1990-01-04'),
(355, 'TERRY', 'GRISSOM', '999666999', 'TERRY.GRISSOM@sakilacustomer.org', '1990-01-04'),
(356, 'GERALD', 'FULTZ', '999666999', 'GERALD.FULTZ@sakilacustomer.org', '1990-01-04'),
(357, 'KEITH', 'RICO', '999666999', 'KEITH.RICO@sakilacustomer.org', '1990-01-04'),
(358, 'SAMUEL', 'MARLOW', '999666999', 'SAMUEL.MARLOW@sakilacustomer.org', '1990-01-04'),
(359, 'WILLIE', 'MARKHAM', '999666999', 'WILLIE.MARKHAM@sakilacustomer.org', '1990-01-04'),
(360, 'RALPH', 'MADRIGAL', '999666999', 'RALPH.MADRIGAL@sakilacustomer.org', '1990-01-04'),
(361, 'LAWRENCE', 'LAWTON', '999666999', 'LAWRENCE.LAWTON@sakilacustomer.org', '1990-01-04'),
(362, 'NICHOLAS', 'BARFIELD', '999666999', 'NICHOLAS.BARFIELD@sakilacustomer.org', '1990-01-04'),
(363, 'ROY', 'WHITING', '999666999', 'ROY.WHITING@sakilacustomer.org', '1990-01-04'),
(364, 'BENJAMIN', 'VARNEY', '999666999', 'BENJAMIN.VARNEY@sakilacustomer.org', '1990-01-04'),
(365, 'BRUCE', 'SCHWARZ', '999666999', 'BRUCE.SCHWARZ@sakilacustomer.org', '1990-01-04'),
(366, 'BRANDON', 'HUEY', '999666999', 'BRANDON.HUEY@sakilacustomer.org', '1990-01-04'),
(367, 'ADAM', 'GOOCH', '999666999', 'ADAM.GOOCH@sakilacustomer.org', '1990-01-04'),
(368, 'HARRY', 'ARCE', '999666999', 'HARRY.ARCE@sakilacustomer.org', '1990-01-04'),
(369, 'FRED', 'WHEAT', '999666999', 'FRED.WHEAT@sakilacustomer.org', '1990-01-04'),
(370, 'WAYNE', 'TRUONG', '999666999', 'WAYNE.TRUONG@sakilacustomer.org', '1990-01-04'),
(371, 'BILLY', 'POULIN', '999666999', 'BILLY.POULIN@sakilacustomer.org', '1990-01-04'),
(372, 'STEVE', 'MACKENZIE', '999666999', 'STEVE.MACKENZIE@sakilacustomer.org', '1990-01-04'),
(373, 'LOUIS', 'LEONE', '999666999', 'LOUIS.LEONE@sakilacustomer.org', '1990-01-04'),
(374, 'JEREMY', 'HURTADO', '999666999', 'JEREMY.HURTADO@sakilacustomer.org', '1990-01-04'),
(375, 'AARON', 'SELBY', '999666999', 'AARON.SELBY@sakilacustomer.org', '1990-01-04'),
(376, 'RANDY', 'GAITHER', '999666999', 'RANDY.GAITHER@sakilacustomer.org', '1990-01-04'),
(377, 'HOWARD', 'FORTNER', '999666999', 'HOWARD.FORTNER@sakilacustomer.org', '1990-01-04'),
(378, 'EUGENE', 'CULPEPPER', '999666999', 'EUGENE.CULPEPPER@sakilacustomer.org', '1990-01-04'),
(379, 'CARLOS', 'COUGHLIN', '999666999', 'CARLOS.COUGHLIN@sakilacustomer.org', '1990-01-04'),
(380, 'RUSSELL', 'BRINSON', '999666999', 'RUSSELL.BRINSON@sakilacustomer.org', '1990-01-04'),
(381, 'BOBBY', 'BOUDREAU', '999666999', 'BOBBY.BOUDREAU@sakilacustomer.org', '1990-01-04'),
(382, 'VICTOR', 'BARKLEY', '999666999', 'VICTOR.BARKLEY@sakilacustomer.org', '1990-01-04'),
(383, 'MARTIN', 'BALES', '999666999', 'MARTIN.BALES@sakilacustomer.org', '1990-01-04'),
(384, 'ERNEST', 'STEPP', '999666999', 'ERNEST.STEPP@sakilacustomer.org', '1990-01-04'),
(385, 'PHILLIP', 'HOLM', '999666999', 'PHILLIP.HOLM@sakilacustomer.org', '1990-01-04'),
(386, 'TODD', 'TAN', '999666999', 'TODD.TAN@sakilacustomer.org', '1990-01-04'),
(387, 'JESSE', 'SCHILLING', '999666999', 'JESSE.SCHILLING@sakilacustomer.org', '1990-01-04'),
(388, 'CRAIG', 'MORRELL', '999666999', 'CRAIG.MORRELL@sakilacustomer.org', '1990-01-04'),
(389, 'ALAN', 'KAHN', '999666999', 'ALAN.KAHN@sakilacustomer.org', '1990-01-04'),
(390, 'SHAWN', 'HEATON', '999666999', 'SHAWN.HEATON@sakilacustomer.org', '1990-01-04'),
(391, 'CLARENCE', 'GAMEZ', '999666999', 'CLARENCE.GAMEZ@sakilacustomer.org', '1990-01-04'),
(392, 'SEAN', 'DOUGLASS', '999666999', 'SEAN.DOUGLASS@sakilacustomer.org', '1990-01-04'),
(393, 'PHILIP', 'CAUSEY', '999666999', 'PHILIP.CAUSEY@sakilacustomer.org', '1990-01-04'),
(394, 'CHRIS', 'BROTHERS', '999666999', 'CHRIS.BROTHERS@sakilacustomer.org', '1990-01-04'),
(395, 'JOHNNY', 'TURPIN', '999666999', 'JOHNNY.TURPIN@sakilacustomer.org', '1990-01-04'),
(396, 'EARL', 'SHANKS', '999666999', 'EARL.SHANKS@sakilacustomer.org', '1990-01-04'),
(397, 'JIMMY', 'SCHRADER', '999666999', 'JIMMY.SCHRADER@sakilacustomer.org', '1990-01-04'),
(398, 'ANTONIO', 'MEEK', '999666999', 'ANTONIO.MEEK@sakilacustomer.org', '1990-01-04'),
(399, 'DANNY', 'ISOM', '999666999', 'DANNY.ISOM@sakilacustomer.org', '1990-01-04'),
(400, 'BRYAN', 'HARDISON', '999666999', 'BRYAN.HARDISON@sakilacustomer.org', '1990-01-04'),
(401, 'TONY', 'CARRANZA', '999666999', 'TONY.CARRANZA@sakilacustomer.org', '1990-01-04'),
(402, 'LUIS', 'YANEZ', '999666999', 'LUIS.YANEZ@sakilacustomer.org', '1990-01-04'),
(403, 'MIKE', 'WAY', '999666999', 'MIKE.WAY@sakilacustomer.org', '1990-01-04'),
(404, 'STANLEY', 'SCROGGINS', '999666999', 'STANLEY.SCROGGINS@sakilacustomer.org', '1990-01-04'),
(405, 'LEONARD', 'SCHOFIELD', '999666999', 'LEONARD.SCHOFIELD@sakilacustomer.org', '1990-01-04'),
(406, 'NATHAN', 'RUNYON', '999666999', 'NATHAN.RUNYON@sakilacustomer.org', '1990-01-04'),
(407, 'DALE', 'RATCLIFF', '999666999', 'DALE.RATCLIFF@sakilacustomer.org', '1990-01-04'),
(408, 'MANUEL', 'MURRELL', '999666999', 'MANUEL.MURRELL@sakilacustomer.org', '1990-01-04'),
(409, 'RODNEY', 'MOELLER', '999666999', 'RODNEY.MOELLER@sakilacustomer.org', '1990-01-04'),
(410, 'CURTIS', 'IRBY', '999666999', 'CURTIS.IRBY@sakilacustomer.org', '1990-01-04'),
(411, 'NORMAN', 'CURRIER', '999666999', 'NORMAN.CURRIER@sakilacustomer.org', '1990-01-04'),
(412, 'ALLEN', 'BUTTERFIELD', '999666999', 'ALLEN.BUTTERFIELD@sakilacustomer.org', '1990-01-04'),
(413, 'MARVIN', 'YEE', '999666999', 'MARVIN.YEE@sakilacustomer.org', '1990-01-04'),
(414, 'VINCENT', 'RALSTON', '999666999', 'VINCENT.RALSTON@sakilacustomer.org', '1990-01-04'),
(415, 'GLENN', 'PULLEN', '999666999', 'GLENN.PULLEN@sakilacustomer.org', '1990-01-04'),
(416, 'JEFFERY', 'PINSON', '999666999', 'JEFFERY.PINSON@sakilacustomer.org', '1990-01-04'),
(417, 'TRAVIS', 'ESTEP', '999666999', 'TRAVIS.ESTEP@sakilacustomer.org', '1990-01-04'),
(418, 'JEFF', 'EAST', '999666999', 'JEFF.EAST@sakilacustomer.org', '1990-01-04'),
(419, 'CHAD', 'CARBONE', '999666999', 'CHAD.CARBONE@sakilacustomer.org', '1990-01-04'),
(420, 'JACOB', 'LANCE', '999666999', 'JACOB.LANCE@sakilacustomer.org', '1990-01-04'),
(421, 'LEE', 'HAWKS', '999666999', 'LEE.HAWKS@sakilacustomer.org', '1990-01-04'),
(422, 'MELVIN', 'ELLINGTON', '999666999', 'MELVIN.ELLINGTON@sakilacustomer.org', '1990-01-04'),
(423, 'ALFRED', 'CASILLAS', '999666999', 'ALFRED.CASILLAS@sakilacustomer.org', '1990-01-04'),
(424, 'KYLE', 'SPURLOCK', '999666999', 'KYLE.SPURLOCK@sakilacustomer.org', '1990-01-04'),
(425, 'FRANCIS', 'SIKES', '999666999', 'FRANCIS.SIKES@sakilacustomer.org', '1990-01-04'),
(426, 'BRADLEY', 'MOTLEY', '999666999', 'BRADLEY.MOTLEY@sakilacustomer.org', '1990-01-04'),
(427, 'JESUS', 'MCCARTNEY', '999666999', 'JESUS.MCCARTNEY@sakilacustomer.org', '1990-01-04'),
(428, 'HERBERT', 'KRUGER', '999666999', 'HERBERT.KRUGER@sakilacustomer.org', '1990-01-04'),
(429, 'FREDERICK', 'ISBELL', '999666999', 'FREDERICK.ISBELL@sakilacustomer.org', '1990-01-04'),
(430, 'RAY', 'HOULE', '999666999', 'RAY.HOULE@sakilacustomer.org', '1990-01-04'),
(431, 'JOEL', 'FRANCISCO', '999666999', 'JOEL.FRANCISCO@sakilacustomer.org', '1990-01-04'),
(432, 'EDWIN', 'BURK', '999666999', 'EDWIN.BURK@sakilacustomer.org', '1990-01-04'),
(433, 'DON', 'BONE', '999666999', 'DON.BONE@sakilacustomer.org', '1990-01-04'),
(434, 'EDDIE', 'TOMLIN', '999666999', 'EDDIE.TOMLIN@sakilacustomer.org', '1990-01-04'),
(435, 'RICKY', 'SHELBY', '999666999', 'RICKY.SHELBY@sakilacustomer.org', '1990-01-04'),
(436, 'TROY', 'QUIGLEY', '999666999', 'TROY.QUIGLEY@sakilacustomer.org', '1990-01-04'),
(437, 'RANDALL', 'NEUMANN', '999666999', 'RANDALL.NEUMANN@sakilacustomer.org', '1990-01-04'),
(438, 'BARRY', 'LOVELACE', '999666999', 'BARRY.LOVELACE@sakilacustomer.org', '1990-01-04'),
(439, 'ALEXANDER', 'FENNELL', '999666999', 'ALEXANDER.FENNELL@sakilacustomer.org', '1990-01-04'),
(440, 'BERNARD', 'COLBY', '999666999', 'BERNARD.COLBY@sakilacustomer.org', '1990-01-04'),
(441, 'MARIO', 'CHEATHAM', '999666999', 'MARIO.CHEATHAM@sakilacustomer.org', '1990-01-04'),
(442, 'LEROY', 'BUSTAMANTE', '999666999', 'LEROY.BUSTAMANTE@sakilacustomer.org', '1990-01-04'),
(443, 'FRANCISCO', 'SKIDMORE', '999666999', 'FRANCISCO.SKIDMORE@sakilacustomer.org', '1990-01-04'),
(444, 'MARCUS', 'HIDALGO', '999666999', 'MARCUS.HIDALGO@sakilacustomer.org', '1990-01-04'),
(445, 'MICHEAL', 'FORMAN', '999666999', 'MICHEAL.FORMAN@sakilacustomer.org', '1990-01-04'),
(446, 'THEODORE', 'CULP', '999666999', 'THEODORE.CULP@sakilacustomer.org', '1990-01-04'),
(447, 'CLIFFORD', 'BOWENS', '999666999', 'CLIFFORD.BOWENS@sakilacustomer.org', '1990-01-04'),
(448, 'MIGUEL', 'BETANCOURT', '999666999', 'MIGUEL.BETANCOURT@sakilacustomer.org', '1990-01-04'),
(449, 'OSCAR', 'AQUINO', '999666999', 'OSCAR.AQUINO@sakilacustomer.org', '1990-01-04'),
(450, 'JAY', 'ROBB', '999666999', 'JAY.ROBB@sakilacustomer.org', '1990-01-04'),
(451, 'JIM', 'REA', '999666999', 'JIM.REA@sakilacustomer.org', '1990-01-04'),
(452, 'TOM', 'MILNER', '999666999', 'TOM.MILNER@sakilacustomer.org', '1990-01-04'),
(453, 'CALVIN', 'MARTEL', '999666999', 'CALVIN.MARTEL@sakilacustomer.org', '1990-01-04'),
(454, 'ALEX', 'GRESHAM', '999666999', 'ALEX.GRESHAM@sakilacustomer.org', '1990-01-04'),
(455, 'JON', 'WILES', '999666999', 'JON.WILES@sakilacustomer.org', '1990-01-04'),
(456, 'RONNIE', 'RICKETTS', '999666999', 'RONNIE.RICKETTS@sakilacustomer.org', '1990-01-04'),
(457, 'BILL', 'GAVIN', '999666999', 'BILL.GAVIN@sakilacustomer.org', '1990-01-04'),
(458, 'LLOYD', 'DOWD', '999666999', 'LLOYD.DOWD@sakilacustomer.org', '1990-01-04'),
(459, 'TOMMY', 'COLLAZO', '999666999', 'TOMMY.COLLAZO@sakilacustomer.org', '1990-01-04'),
(460, 'LEON', 'BOSTIC', '999666999', 'LEON.BOSTIC@sakilacustomer.org', '1990-01-04'),
(461, 'DEREK', 'BLAKELY', '999666999', 'DEREK.BLAKELY@sakilacustomer.org', '1990-01-04'),
(462, 'WARREN', 'SHERROD', '999666999', 'WARREN.SHERROD@sakilacustomer.org', '1990-01-04'),
(463, 'DARRELL', 'POWER', '999666999', 'DARRELL.POWER@sakilacustomer.org', '1990-01-04'),
(464, 'JEROME', 'KENYON', '999666999', 'JEROME.KENYON@sakilacustomer.org', '1990-01-04'),
(465, 'FLOYD', 'GANDY', '999666999', 'FLOYD.GANDY@sakilacustomer.org', '1990-01-04'),
(466, 'LEO', 'EBERT', '999666999', 'LEO.EBERT@sakilacustomer.org', '1990-01-04'),
(467, 'ALVIN', 'DELOACH', '999666999', 'ALVIN.DELOACH@sakilacustomer.org', '1990-01-04'),
(468, 'TIM', 'CARY', '999666999', 'TIM.CARY@sakilacustomer.org', '1990-01-04'),
(469, 'WESLEY', 'BULL', '999666999', 'WESLEY.BULL@sakilacustomer.org', '1990-01-04'),
(470, 'GORDON', 'ALLARD', '999666999', 'GORDON.ALLARD@sakilacustomer.org', '1990-01-04'),
(471, 'DEAN', 'SAUER', '999666999', 'DEAN.SAUER@sakilacustomer.org', '1990-01-04'),
(472, 'GREG', 'ROBINS', '999666999', 'GREG.ROBINS@sakilacustomer.org', '1990-01-04'),
(473, 'JORGE', 'OLIVARES', '999666999', 'JORGE.OLIVARES@sakilacustomer.org', '1990-01-04'),
(474, 'DUSTIN', 'GILLETTE', '999666999', 'DUSTIN.GILLETTE@sakilacustomer.org', '1990-01-04'),
(475, 'PEDRO', 'CHESTNUT', '999666999', 'PEDRO.CHESTNUT@sakilacustomer.org', '1990-01-04'),
(476, 'DERRICK', 'BOURQUE', '999666999', 'DERRICK.BOURQUE@sakilacustomer.org', '1990-01-04'),
(477, 'DAN', 'PAINE', '999666999', 'DAN.PAINE@sakilacustomer.org', '1990-01-04'),
(478, 'LEWIS', 'LYMAN', '999666999', 'LEWIS.LYMAN@sakilacustomer.org', '1990-01-04'),
(479, 'ZACHARY', 'HITE', '999666999', 'ZACHARY.HITE@sakilacustomer.org', '1990-01-04'),
(480, 'COREY', 'HAUSER', '999666999', 'COREY.HAUSER@sakilacustomer.org', '1990-01-04'),
(481, 'HERMAN', 'DEVORE', '999666999', 'HERMAN.DEVORE@sakilacustomer.org', '1990-01-04'),
(482, 'MAURICE', 'CRAWLEY', '999666999', 'MAURICE.CRAWLEY@sakilacustomer.org', '1990-01-04'),
(483, 'VERNON', 'CHAPA', '999666999', 'VERNON.CHAPA@sakilacustomer.org', '1990-01-04'),
(484, 'ROBERTO', 'VU', '999666999', 'ROBERTO.VU@sakilacustomer.org', '1990-01-04'),
(485, 'CLYDE', 'TOBIAS', '999666999', 'CLYDE.TOBIAS@sakilacustomer.org', '1990-01-04'),
(486, 'GLEN', 'TALBERT', '999666999', 'GLEN.TALBERT@sakilacustomer.org', '1990-01-04'),
(487, 'HECTOR', 'POINDEXTER', '999666999', 'HECTOR.POINDEXTER@sakilacustomer.org', '1990-01-04'),
(488, 'SHANE', 'MILLARD', '999666999', 'SHANE.MILLARD@sakilacustomer.org', '1990-01-04'),
(489, 'RICARDO', 'MEADOR', '999666999', 'RICARDO.MEADOR@sakilacustomer.org', '1990-01-04'),
(490, 'SAM', 'MCDUFFIE', '999666999', 'SAM.MCDUFFIE@sakilacustomer.org', '1990-01-04'),
(491, 'RICK', 'MATTOX', '999666999', 'RICK.MATTOX@sakilacustomer.org', '1990-01-04'),
(492, 'LESTER', 'KRAUS', '999666999', 'LESTER.KRAUS@sakilacustomer.org', '1990-01-04'),
(493, 'BRENT', 'HARKINS', '999666999', 'BRENT.HARKINS@sakilacustomer.org', '1990-01-04'),
(494, 'RAMON', 'CHOATE', '999666999', 'RAMON.CHOATE@sakilacustomer.org', '1990-01-04'),
(495, 'CHARLIE', 'BESS', '999666999', 'CHARLIE.BESS@sakilacustomer.org', '1990-01-04'),
(496, 'TYLER', 'WREN', '999666999', 'TYLER.WREN@sakilacustomer.org', '1990-01-04'),
(497, 'GILBERT', 'SLEDGE', '999666999', 'GILBERT.SLEDGE@sakilacustomer.org', '1990-01-04'),
(498, 'GENE', 'SANBORN', '999666999', 'GENE.SANBORN@sakilacustomer.org', '1990-01-04'),
(499, 'MARC', 'OUTLAW', '999666999', 'MARC.OUTLAW@sakilacustomer.org', '1990-01-04'),
(500, 'REGINALD', 'KINDER', '999666999', 'REGINALD.KINDER@sakilacustomer.org', '1990-01-04'),
(501, 'RUBEN', 'GEARY', '999666999', 'RUBEN.GEARY@sakilacustomer.org', '1990-01-04'),
(502, 'BRETT', 'CORNWELL', '999666999', 'BRETT.CORNWELL@sakilacustomer.org', '1990-01-04'),
(503, 'ANGEL', 'BARCLAY', '999666999', 'ANGEL.BARCLAY@sakilacustomer.org', '1990-01-04'),
(504, 'NATHANIEL', 'ADAM', '999666999', 'NATHANIEL.ADAM@sakilacustomer.org', '1990-01-04'),
(505, 'RAFAEL', 'ABNEY', '999666999', 'RAFAEL.ABNEY@sakilacustomer.org', '1990-01-04'),
(506, 'LESLIE', 'SEWARD', '999666999', 'LESLIE.SEWARD@sakilacustomer.org', '1990-01-04'),
(507, 'EDGAR', 'RHOADS', '999666999', 'EDGAR.RHOADS@sakilacustomer.org', '1990-01-04'),
(508, 'MILTON', 'HOWLAND', '999666999', 'MILTON.HOWLAND@sakilacustomer.org', '1990-01-04'),
(509, 'RAUL', 'FORTIER', '999666999', 'RAUL.FORTIER@sakilacustomer.org', '1990-01-04'),
(510, 'BEN', 'EASTER', '999666999', 'BEN.EASTER@sakilacustomer.org', '1990-01-04'),
(511, 'CHESTER', 'BENNER', '999666999', 'CHESTER.BENNER@sakilacustomer.org', '1990-01-04'),
(512, 'CECIL', 'VINES', '999666999', 'CECIL.VINES@sakilacustomer.org', '1990-01-04'),
(513, 'DUANE', 'TUBBS', '999666999', 'DUANE.TUBBS@sakilacustomer.org', '1990-01-04'),
(514, 'FRANKLIN', 'TROUTMAN', '999666999', 'FRANKLIN.TROUTMAN@sakilacustomer.org', '1990-01-04'),
(515, 'ANDRE', 'RAPP', '999666999', 'ANDRE.RAPP@sakilacustomer.org', '1990-01-04'),
(516, 'ELMER', 'NOE', '999666999', 'ELMER.NOE@sakilacustomer.org', '1990-01-04'),
(517, 'BRAD', 'MCCURDY', '999666999', 'BRAD.MCCURDY@sakilacustomer.org', '1990-01-04'),
(518, 'GABRIEL', 'HARDER', '999666999', 'GABRIEL.HARDER@sakilacustomer.org', '1990-01-04'),
(519, 'RON', 'DELUCA', '999666999', 'RON.DELUCA@sakilacustomer.org', '1990-01-04'),
(520, 'MITCHELL', 'WESTMORELAND', '999666999', 'MITCHELL.WESTMORELAND@sakilacustomer.org', '1990-01-04'),
(521, 'ROLAND', 'SOUTH', '999666999', 'ROLAND.SOUTH@sakilacustomer.org', '1990-01-04'),
(522, 'ARNOLD', 'HAVENS', '999666999', 'ARNOLD.HAVENS@sakilacustomer.org', '1990-01-04'),
(523, 'HARVEY', 'GUAJARDO', '999666999', 'HARVEY.GUAJARDO@sakilacustomer.org', '1990-01-04'),
(524, 'JARED', 'ELY', '999666999', 'JARED.ELY@sakilacustomer.org', '1990-01-04'),
(525, 'ADRIAN', 'CLARY', '999666999', 'ADRIAN.CLARY@sakilacustomer.org', '1990-01-04'),
(526, 'KARL', 'SEAL', '999666999', 'KARL.SEAL@sakilacustomer.org', '1990-01-04'),
(527, 'CORY', 'MEEHAN', '999666999', 'CORY.MEEHAN@sakilacustomer.org', '1990-01-04'),
(528, 'CLAUDE', 'HERZOG', '999666999', 'CLAUDE.HERZOG@sakilacustomer.org', '1990-01-04'),
(529, 'ERIK', 'GUILLEN', '999666999', 'ERIK.GUILLEN@sakilacustomer.org', '1990-01-04'),
(530, 'DARRYL', 'ASHCRAFT', '999666999', 'DARRYL.ASHCRAFT@sakilacustomer.org', '1990-01-04'),
(531, 'JAMIE', 'WAUGH', '999666999', 'JAMIE.WAUGH@sakilacustomer.org', '1990-01-04'),
(532, 'NEIL', 'RENNER', '999666999', 'NEIL.RENNER@sakilacustomer.org', '1990-01-04'),
(533, 'JESSIE', 'MILAM', '999666999', 'JESSIE.MILAM@sakilacustomer.org', '1990-01-04'),
(534, 'CHRISTIAN', 'JUNG', '999666999', 'CHRISTIAN.JUNG@sakilacustomer.org', '1990-01-04'),
(535, 'JAVIER', 'ELROD', '999666999', 'JAVIER.ELROD@sakilacustomer.org', '1990-01-04'),
(536, 'FERNANDO', 'CHURCHILL', '999666999', 'FERNANDO.CHURCHILL@sakilacustomer.org', '1990-01-04'),
(537, 'CLINTON', 'BUFORD', '999666999', 'CLINTON.BUFORD@sakilacustomer.org', '1990-01-04'),
(538, 'TED', 'BREAUX', '999666999', 'TED.BREAUX@sakilacustomer.org', '1990-01-04'),
(539, 'MATHEW', 'BOLIN', '999666999', 'MATHEW.BOLIN@sakilacustomer.org', '1990-01-04'),
(540, 'TYRONE', 'ASHER', '999666999', 'TYRONE.ASHER@sakilacustomer.org', '1990-01-04'),
(541, 'DARREN', 'WINDHAM', '999666999', 'DARREN.WINDHAM@sakilacustomer.org', '1990-01-04'),
(542, 'LONNIE', 'TIRADO', '999666999', 'LONNIE.TIRADO@sakilacustomer.org', '1990-01-04'),
(543, 'LANCE', 'PEMBERTON', '999666999', 'LANCE.PEMBERTON@sakilacustomer.org', '1990-01-04'),
(544, 'CODY', 'NOLEN', '999666999', 'CODY.NOLEN@sakilacustomer.org', '1990-01-04'),
(545, 'JULIO', 'NOLAND', '999666999', 'JULIO.NOLAND@sakilacustomer.org', '1990-01-04'),
(546, 'KELLY', 'KNOTT', '999666999', 'KELLY.KNOTT@sakilacustomer.org', '1990-01-04'),
(547, 'KURT', 'EMMONS', '999666999', 'KURT.EMMONS@sakilacustomer.org', '1990-01-04'),
(548, 'ALLAN', 'CORNISH', '999666999', 'ALLAN.CORNISH@sakilacustomer.org', '1990-01-04'),
(549, 'NELSON', 'CHRISTENSON', '999666999', 'NELSON.CHRISTENSON@sakilacustomer.org', '1990-01-04'),
(550, 'GUY', 'BROWNLEE', '999666999', 'GUY.BROWNLEE@sakilacustomer.org', '1990-01-04'),
(551, 'CLAYTON', 'BARBEE', '999666999', 'CLAYTON.BARBEE@sakilacustomer.org', '1990-01-04'),
(552, 'HUGH', 'WALDROP', '999666999', 'HUGH.WALDROP@sakilacustomer.org', '1990-01-04'),
(553, 'MAX', 'PITT', '999666999', 'MAX.PITT@sakilacustomer.org', '1990-01-04'),
(554, 'DWAYNE', 'OLVERA', '999666999', 'DWAYNE.OLVERA@sakilacustomer.org', '1990-01-04'),
(555, 'DWIGHT', 'LOMBARDI', '999666999', 'DWIGHT.LOMBARDI@sakilacustomer.org', '1990-01-04'),
(556, 'ARMANDO', 'GRUBER', '999666999', 'ARMANDO.GRUBER@sakilacustomer.org', '1990-01-04'),
(557, 'FELIX', 'GAFFNEY', '999666999', 'FELIX.GAFFNEY@sakilacustomer.org', '1990-01-04'),
(558, 'JIMMIE', 'EGGLESTON', '999666999', 'JIMMIE.EGGLESTON@sakilacustomer.org', '1990-01-04'),
(559, 'EVERETT', 'BANDA', '999666999', 'EVERETT.BANDA@sakilacustomer.org', '1990-01-04'),
(560, 'JORDAN', 'ARCHULETA', '999666999', 'JORDAN.ARCHULETA@sakilacustomer.org', '1990-01-04'),
(561, 'IAN', 'STILL', '999666999', 'IAN.STILL@sakilacustomer.org', '1990-01-04'),
(562, 'WALLACE', 'SLONE', '999666999', 'WALLACE.SLONE@sakilacustomer.org', '1990-01-04'),
(563, 'KEN', 'PREWITT', '999666999', 'KEN.PREWITT@sakilacustomer.org', '1990-01-04'),
(564, 'BOB', 'PFEIFFER', '999666999', 'BOB.PFEIFFER@sakilacustomer.org', '1990-01-04'),
(565, 'JAIME', 'NETTLES', '999666999', 'JAIME.NETTLES@sakilacustomer.org', '1990-01-04'),
(566, 'CASEY', 'MENA', '999666999', 'CASEY.MENA@sakilacustomer.org', '1990-01-04'),
(567, 'ALFREDO', 'MCADAMS', '999666999', 'ALFREDO.MCADAMS@sakilacustomer.org', '1990-01-04'),
(568, 'ALBERTO', 'HENNING', '999666999', 'ALBERTO.HENNING@sakilacustomer.org', '1990-01-04'),
(569, 'DAVE', 'GARDINER', '999666999', 'DAVE.GARDINER@sakilacustomer.org', '1990-01-04'),
(570, 'IVAN', 'CROMWELL', '999666999', 'IVAN.CROMWELL@sakilacustomer.org', '1990-01-04');
INSERT INTO `customer` (`customer_id`, `first_name`, `last_name`, `telefono`, `email`, `fecha_de_nacimiento`) VALUES
(571, 'JOHNNIE', 'CHISHOLM', '999666999', 'JOHNNIE.CHISHOLM@sakilacustomer.org', '1990-01-04'),
(572, 'SIDNEY', 'BURLESON', '999666999', 'SIDNEY.BURLESON@sakilacustomer.org', '1990-01-04'),
(573, 'BYRON', 'BOX', '999666999', 'BYRON.BOX@sakilacustomer.org', '1990-01-04'),
(574, 'JULIAN', 'VEST', '999666999', 'JULIAN.VEST@sakilacustomer.org', '1990-01-04'),
(575, 'ISAAC', 'OGLESBY', '999666999', 'ISAAC.OGLESBY@sakilacustomer.org', '1990-01-04'),
(576, 'MORRIS', 'MCCARTER', '999666999', 'MORRIS.MCCARTER@sakilacustomer.org', '1990-01-04'),
(577, 'CLIFTON', 'MALCOLM', '999666999', 'CLIFTON.MALCOLM@sakilacustomer.org', '1990-01-04'),
(578, 'WILLARD', 'LUMPKIN', '999666999', 'WILLARD.LUMPKIN@sakilacustomer.org', '1990-01-04'),
(579, 'DARYL', 'LARUE', '999666999', 'DARYL.LARUE@sakilacustomer.org', '1990-01-04'),
(580, 'ROSS', 'GREY', '999666999', 'ROSS.GREY@sakilacustomer.org', '1990-01-04'),
(581, 'VIRGIL', 'WOFFORD', '999666999', 'VIRGIL.WOFFORD@sakilacustomer.org', '1990-01-04'),
(582, 'ANDY', 'VANHORN', '999666999', 'ANDY.VANHORN@sakilacustomer.org', '1990-01-04'),
(583, 'MARSHALL', 'THORN', '999666999', 'MARSHALL.THORN@sakilacustomer.org', '1990-01-04'),
(584, 'SALVADOR', 'TEEL', '999666999', 'SALVADOR.TEEL@sakilacustomer.org', '1990-01-04'),
(585, 'PERRY', 'SWAFFORD', '999666999', 'PERRY.SWAFFORD@sakilacustomer.org', '1990-01-04'),
(586, 'KIRK', 'STCLAIR', '999666999', 'KIRK.STCLAIR@sakilacustomer.org', '1990-01-04'),
(587, 'SERGIO', 'STANFIELD', '999666999', 'SERGIO.STANFIELD@sakilacustomer.org', '1990-01-04'),
(588, 'MARION', 'OCAMPO', '999666999', 'MARION.OCAMPO@sakilacustomer.org', '1990-01-04'),
(589, 'TRACY', 'HERRMANN', '999666999', 'TRACY.HERRMANN@sakilacustomer.org', '1990-01-04'),
(590, 'SETH', 'HANNON', '999666999', 'SETH.HANNON@sakilacustomer.org', '1990-01-04'),
(591, 'KENT', 'ARSENAULT', '999666999', 'KENT.ARSENAULT@sakilacustomer.org', '1990-01-04'),
(592, 'TERRANCE', 'ROUSH', '999666999', 'TERRANCE.ROUSH@sakilacustomer.org', '1990-01-04'),
(593, 'RENE', 'MCALISTER', '999666999', 'RENE.MCALISTER@sakilacustomer.org', '1990-01-04'),
(594, 'EDUARDO', 'HIATT', '999666999', 'EDUARDO.HIATT@sakilacustomer.org', '1990-01-04'),
(595, 'TERRENCE', 'GUNDERSON', '999666999', 'TERRENCE.GUNDERSON@sakilacustomer.org', '1990-01-04'),
(596, 'ENRIQUE', 'FORSYTHE', '999666999', 'ENRIQUE.FORSYTHE@sakilacustomer.org', '1990-01-04'),
(597, 'FREDDIE', 'DUGGAN', '999666999', 'FREDDIE.DUGGAN@sakilacustomer.org', '1990-01-04'),
(598, 'WADE', 'DELVALLE', '999666999', 'WADE.DELVALLE@sakilacustomer.org', '1990-01-04'),
(599, 'AUSTIN', 'CINTRON', '999666999', 'AUSTIN.CINTRON@sakilacustomer.org', '1990-01-04'),
(600, 'Inma', 'Martinez', '999666999', 'ooo@aaa', '2018-02-19'),
(601, 'inma', 'marti', '787493747', 'deinrf@jir.mriw', '2018-02-01'),
(602, 'Prueba', 'MArti', '989898989', 'hijo', '1990-01-04'),
(603, 'MAria', 'Gonzalez', '123456789', 'fgtrhth', '2018-02-27'),
(604, 'prueba1', 'prueba1', '999999', 'prueba1', '2018-02-15'),
(605, 'prueba1', 'prueba1', '999999', 'prueba1', '2018-02-22'),
(606, 'inma3', 'inma3', '999999', 'inma3@inma3.com', '2018-02-13'),
(607, 'Carlos', 'Diaz', '999999999', 'carlos@yahoo.es', '2018-02-04'),
(608, 'eduardoooo', 'kjojoj', '999666999', 'j@l.l', '2018-03-04'),
(609, 'Eduardo', 'Eduardo', '999666999', 'eduardo@yahoo.es', '2018-03-04');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `municipios`
--
CREATE TABLE `municipios` (
`id_municipio` smallint(6) UNSIGNED NOT NULL,
`id_provincia` smallint(6) NOT NULL,
`cod_municipio` int(11) NOT NULL COMMENT 'Código de muncipio DENTRO de la provincia, campo no único',
`DC` int(11) NOT NULL COMMENT 'Digito Control. El INE no revela cómo se calcula, secreto nuclear.',
`nombre` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Volcado de datos para la tabla `municipios`
--
INSERT INTO `municipios` (`id_municipio`, `id_provincia`, `cod_municipio`, `DC`, `nombre`) VALUES
(1, 1, 1, 4, 'Alegría-Dulantzi'),
(2, 2, 1, 9, 'Abengibre'),
(3, 3, 1, 5, 'Adsubia'),
(4, 4, 1, 0, 'Abla'),
(5, 5, 1, 3, 'Adanero'),
(6, 6, 1, 6, 'Acedera'),
(7, 7, 1, 2, 'Alaró'),
(8, 8, 1, 8, 'Abrera'),
(9, 9, 1, 1, 'Abajas'),
(10, 10, 1, 5, 'Abadía'),
(11, 11, 1, 2, 'Alcalá de los Gazules'),
(12, 12, 1, 7, 'Atzeneta del Maestrat'),
(13, 13, 1, 3, 'Abenójar'),
(14, 14, 1, 8, 'Adamuz'),
(15, 15, 1, 1, 'Abegondo'),
(16, 16, 1, 4, 'Abia de la Obispalía'),
(17, 17, 1, 0, 'Agullana'),
(18, 18, 1, 6, 'Agrón'),
(19, 19, 1, 9, 'Abánades'),
(20, 20, 1, 3, 'Abaltzisketa'),
(21, 21, 1, 0, 'Alájar'),
(22, 22, 1, 5, 'Abiego'),
(23, 23, 1, 1, 'Albanchez de Mágina'),
(24, 24, 1, 6, 'Acebedo'),
(25, 25, 1, 9, 'Abella de la Conca'),
(26, 26, 1, 2, 'Ábalos'),
(27, 27, 1, 8, 'Abadín'),
(28, 28, 1, 4, 'Acebeda, La'),
(29, 29, 1, 7, 'Alameda'),
(30, 30, 1, 1, 'Abanilla'),
(31, 31, 1, 8, 'Abáigar'),
(32, 32, 1, 3, 'Allariz'),
(33, 33, 1, 9, 'Allande'),
(34, 34, 1, 4, 'Abarca de Campos'),
(35, 35, 1, 7, 'Agaete'),
(36, 36, 1, 0, 'Arbo'),
(37, 37, 1, 6, 'Abusejo'),
(38, 38, 1, 2, 'Adeje'),
(39, 39, 1, 5, 'Alfoz de Lloredo'),
(40, 40, 1, 9, 'Abades'),
(41, 41, 1, 6, 'Aguadulce'),
(42, 42, 1, 1, 'Abejar'),
(43, 43, 1, 7, 'Aiguamúrcia'),
(44, 44, 1, 2, 'Ababuj'),
(45, 45, 1, 5, 'Ajofrín'),
(46, 46, 1, 8, 'Ademuz'),
(47, 47, 1, 4, 'Adalia'),
(48, 48, 1, 0, 'Abadiño'),
(49, 50, 1, 6, 'Abanto'),
(50, 51, 1, 3, 'Ceuta'),
(51, 52, 1, 8, 'Melilla'),
(52, 1, 2, 9, 'Amurrio'),
(53, 2, 2, 4, 'Alatoz'),
(54, 3, 2, 0, 'Agost'),
(55, 4, 2, 5, 'Abrucena'),
(56, 5, 2, 8, 'Adrada, La'),
(57, 6, 2, 1, 'Aceuchal'),
(58, 7, 2, 7, 'Alaior'),
(59, 8, 2, 3, 'Aguilar de Segarra'),
(60, 10, 2, 0, 'Abertura'),
(61, 11, 2, 7, 'Alcalá del Valle'),
(62, 12, 2, 2, 'Aín'),
(63, 13, 2, 8, 'Agudo'),
(64, 14, 2, 3, 'Aguilar de la Frontera'),
(65, 15, 2, 6, 'Ames'),
(66, 16, 2, 9, 'Acebrón, El'),
(67, 17, 2, 5, 'Aiguaviva'),
(68, 18, 2, 1, 'Alamedilla'),
(69, 19, 2, 4, 'Ablanque'),
(70, 20, 2, 8, 'Aduna'),
(71, 21, 2, 5, 'Aljaraque'),
(72, 22, 2, 0, 'Abizanda'),
(73, 23, 2, 6, 'Alcalá la Real'),
(74, 24, 2, 1, 'Algadefe'),
(75, 25, 2, 4, 'Àger'),
(76, 26, 2, 7, 'Agoncillo'),
(77, 27, 2, 3, 'Alfoz'),
(78, 28, 2, 9, 'Ajalvir'),
(79, 29, 2, 2, 'Alcaucín'),
(80, 30, 2, 6, 'Abarán'),
(81, 31, 2, 3, 'Abárzuza/Abartzuza'),
(82, 32, 2, 8, 'Amoeiro'),
(83, 33, 2, 4, 'Aller'),
(84, 35, 2, 2, 'Agüimes'),
(85, 36, 2, 5, 'Barro'),
(86, 37, 2, 1, 'Agallas'),
(87, 38, 2, 7, 'Agulo'),
(88, 39, 2, 0, 'Ampuero'),
(89, 40, 2, 4, 'Adrada de Pirón'),
(90, 41, 2, 1, 'Alanís'),
(91, 43, 2, 2, 'Albinyana'),
(92, 44, 2, 7, 'Abejuela'),
(93, 45, 2, 0, 'Alameda de la Sagra'),
(94, 46, 2, 3, 'Ador'),
(95, 47, 2, 9, 'Aguasal'),
(96, 48, 2, 5, 'Abanto y Ciérvana-Abanto Zierbena'),
(97, 49, 2, 8, 'Abezames'),
(98, 50, 2, 1, 'Acered'),
(99, 1, 3, 5, 'Aramaio'),
(100, 2, 3, 0, 'Albacete'),
(101, 3, 3, 6, 'Agres'),
(102, 4, 3, 1, 'Adra'),
(103, 6, 3, 7, 'Ahillones'),
(104, 7, 3, 3, 'Alcúdia'),
(105, 8, 3, 9, 'Alella'),
(106, 9, 3, 2, 'Adrada de Haza'),
(107, 10, 3, 6, 'Acebo'),
(108, 11, 3, 3, 'Algar'),
(109, 12, 3, 8, 'Albocàsser'),
(110, 13, 3, 4, 'Alamillo'),
(111, 14, 3, 9, 'Alcaracejos'),
(112, 15, 3, 2, 'Aranga'),
(113, 16, 3, 5, 'Alarcón'),
(114, 17, 3, 1, 'Albanyà'),
(115, 18, 3, 7, 'Albolote'),
(116, 19, 3, 0, 'Adobes'),
(117, 20, 3, 4, 'Aizarnazabal'),
(118, 21, 3, 1, 'Almendro, El'),
(119, 22, 3, 6, 'Adahuesca'),
(120, 23, 3, 2, 'Alcaudete'),
(121, 24, 3, 7, 'Alija del Infantado'),
(122, 25, 3, 0, 'Agramunt'),
(123, 26, 3, 3, 'Aguilar del Río Alhama'),
(124, 27, 3, 9, 'Antas de Ulla'),
(125, 28, 3, 5, 'Alameda del Valle'),
(126, 29, 3, 8, 'Alfarnate'),
(127, 30, 3, 2, 'Águilas'),
(128, 31, 3, 9, 'Abaurregaina/Abaurrea Alta'),
(129, 32, 3, 4, 'Arnoia, A'),
(130, 33, 3, 0, 'Amieva'),
(131, 34, 3, 5, 'Abia de las Torres'),
(132, 35, 3, 8, 'Antigua'),
(133, 36, 3, 1, 'Baiona'),
(134, 37, 3, 7, 'Ahigal de los Aceiteros'),
(135, 38, 3, 3, 'Alajeró'),
(136, 39, 3, 6, 'Anievas'),
(137, 40, 3, 0, 'Adrados'),
(138, 41, 3, 7, 'Albaida del Aljarafe'),
(139, 42, 3, 2, 'Adradas'),
(140, 43, 3, 8, 'Albiol, L\''),
(141, 44, 3, 3, 'Aguatón'),
(142, 45, 3, 6, 'Albarreal de Tajo'),
(143, 46, 3, 9, 'Atzeneta d\'Albaida'),
(144, 47, 3, 5, 'Aguilar de Campos'),
(145, 48, 3, 1, 'Amorebieta-Etxano'),
(146, 49, 3, 4, 'Alcañices'),
(147, 50, 3, 7, 'Agón'),
(148, 1, 4, 0, 'Artziniega'),
(149, 2, 4, 5, 'Albatana'),
(150, 3, 4, 1, 'Aigües'),
(151, 4, 4, 6, 'Albánchez'),
(152, 6, 4, 2, 'Alange'),
(153, 7, 4, 8, 'Algaida'),
(154, 8, 4, 4, 'Alpens'),
(155, 10, 4, 1, 'Acehúche'),
(156, 11, 4, 8, 'Algeciras'),
(157, 12, 4, 3, 'Alcalà de Xivert'),
(158, 13, 4, 9, 'Albaladejo'),
(159, 14, 4, 4, 'Almedinilla'),
(160, 15, 4, 7, 'Ares'),
(161, 16, 4, 0, 'Albaladejo del Cuende'),
(162, 17, 4, 6, 'Albons'),
(163, 18, 4, 2, 'Albondón'),
(164, 19, 4, 5, 'Alaminos'),
(165, 20, 4, 9, 'Albiztur'),
(166, 21, 4, 6, 'Almonaster la Real'),
(167, 22, 4, 1, 'Agüero'),
(168, 23, 4, 7, 'Aldeaquemada'),
(169, 24, 4, 2, 'Almanza'),
(170, 25, 4, 5, 'Alamús, Els'),
(171, 26, 4, 8, 'Ajamil de Cameros'),
(172, 27, 4, 4, 'Baleira'),
(173, 28, 4, 0, 'Álamo, El'),
(174, 29, 4, 3, 'Alfarnatejo'),
(175, 30, 4, 7, 'Albudeite'),
(176, 31, 4, 4, 'Abaurrepea/Abaurrea Baja'),
(177, 32, 4, 9, 'Avión'),
(178, 33, 4, 5, 'Avilés'),
(179, 34, 4, 0, 'Aguilar de Campoo'),
(180, 35, 4, 3, 'Arrecife'),
(181, 36, 4, 6, 'Bueu'),
(182, 37, 4, 2, 'Ahigal de Villarino'),
(183, 38, 4, 8, 'Arafo'),
(184, 39, 4, 1, 'Arenas de Iguña'),
(185, 40, 4, 5, 'Aguilafuente'),
(186, 41, 4, 2, 'Alcalá de Guadaíra'),
(187, 42, 4, 7, 'Ágreda'),
(188, 43, 4, 3, 'Alcanar'),
(189, 44, 4, 8, 'Aguaviva'),
(190, 45, 4, 1, 'Alcabón'),
(191, 46, 4, 4, 'Agullent'),
(192, 47, 4, 0, 'Alaejos'),
(193, 48, 4, 6, 'Amoroto'),
(194, 49, 4, 9, 'Alcubilla de Nogales'),
(195, 50, 4, 2, 'Aguarón'),
(196, 2, 5, 8, 'Alborea'),
(197, 3, 5, 4, 'Albatera'),
(198, 4, 5, 9, 'Alboloduy'),
(199, 5, 5, 2, 'Albornos'),
(200, 6, 5, 5, 'Albuera, La'),
(201, 7, 5, 1, 'Andratx'),
(202, 8, 5, 7, 'Ametlla del Vallès, L\''),
(203, 10, 5, 4, 'Aceituna'),
(204, 11, 5, 1, 'Algodonales'),
(205, 12, 5, 6, 'Alcora, l\''),
(206, 13, 5, 2, 'Alcázar de San Juan'),
(207, 14, 5, 7, 'Almodóvar del Río'),
(208, 15, 5, 0, 'Arteixo'),
(209, 16, 5, 3, 'Albalate de las Nogueras'),
(210, 17, 5, 9, 'Far d\'Empordà, El'),
(211, 18, 5, 5, 'Albuñán'),
(212, 19, 5, 8, 'Alarilla'),
(213, 20, 5, 2, 'Alegia'),
(214, 21, 5, 9, 'Almonte'),
(215, 23, 5, 0, 'Andújar'),
(216, 24, 5, 5, 'Antigua, La'),
(217, 25, 5, 8, 'Alàs i Cerc'),
(218, 26, 5, 1, 'Albelda de Iregua'),
(219, 27, 5, 7, 'Barreiros'),
(220, 28, 5, 3, 'Alcalá de Henares'),
(221, 29, 5, 6, 'Algarrobo'),
(222, 30, 5, 0, 'Alcantarilla'),
(223, 31, 5, 7, 'Aberin'),
(224, 32, 5, 2, 'Baltar'),
(225, 33, 5, 8, 'Belmonte de Miranda'),
(226, 34, 5, 3, 'Alar del Rey'),
(227, 35, 5, 6, 'Artenara'),
(228, 36, 5, 9, 'Caldas de Reis'),
(229, 37, 5, 5, 'Alameda de Gardón, La'),
(230, 38, 5, 1, 'Arico'),
(231, 39, 5, 4, 'Argoños'),
(232, 40, 5, 8, 'Alconada de Maderuelo'),
(233, 41, 5, 5, 'Alcalá del Río'),
(234, 43, 5, 6, 'Alcover'),
(235, 44, 5, 1, 'Aguilar del Alfambra'),
(236, 45, 5, 4, 'Alcañizo'),
(237, 46, 5, 7, 'Alaquàs'),
(238, 47, 5, 3, 'Alcazarén'),
(239, 48, 5, 9, 'Arakaldo'),
(240, 49, 5, 2, 'Alfaraz de Sayago'),
(241, 50, 5, 5, 'Aguilón'),
(242, 1, 6, 6, 'Armiñón'),
(243, 2, 6, 1, 'Alcadozo'),
(244, 3, 6, 7, 'Alcalalí'),
(245, 4, 6, 2, 'Albox'),
(246, 6, 6, 8, 'Alburquerque'),
(247, 7, 6, 4, 'Artà'),
(248, 8, 6, 0, 'Arenys de Mar'),
(249, 9, 6, 3, 'Aguas Cándidas'),
(250, 10, 6, 7, 'Ahigal'),
(251, 11, 6, 4, 'Arcos de la Frontera'),
(252, 12, 6, 9, 'Alcudia de Veo'),
(253, 13, 6, 5, 'Alcoba'),
(254, 14, 6, 0, 'Añora'),
(255, 15, 6, 3, 'Arzúa'),
(256, 16, 6, 6, 'Albendea'),
(257, 17, 6, 2, 'Alp'),
(258, 18, 6, 8, 'Albuñol'),
(259, 19, 6, 1, 'Albalate de Zorita'),
(260, 20, 6, 5, 'Alkiza'),
(261, 21, 6, 2, 'Alosno'),
(262, 22, 6, 7, 'Aisa'),
(263, 23, 6, 3, 'Arjona'),
(264, 24, 6, 8, 'Ardón'),
(265, 25, 6, 1, 'Albagés, L\''),
(266, 26, 6, 4, 'Alberite'),
(267, 27, 6, 0, 'Becerreá'),
(268, 28, 6, 6, 'Alcobendas'),
(269, 29, 6, 9, 'Algatocín'),
(270, 30, 6, 3, 'Aledo'),
(271, 31, 6, 0, 'Ablitas'),
(272, 32, 6, 5, 'Bande'),
(273, 33, 6, 1, 'Bimenes'),
(274, 34, 6, 6, 'Alba de Cerrato'),
(275, 35, 6, 9, 'Arucas'),
(276, 36, 6, 2, 'Cambados'),
(277, 37, 6, 8, 'Alamedilla, La'),
(278, 38, 6, 4, 'Arona'),
(279, 39, 6, 7, 'Arnuero'),
(280, 40, 6, 1, 'Aldealcorvo'),
(281, 41, 6, 8, 'Alcolea del Río'),
(282, 42, 6, 3, 'Alconaba'),
(283, 43, 6, 9, 'Aldover'),
(284, 44, 6, 4, 'Alacón'),
(285, 45, 6, 7, 'Alcaudete de la Jara'),
(286, 46, 6, 0, 'Albaida'),
(287, 47, 6, 6, 'Aldea de San Miguel'),
(288, 48, 6, 2, 'Arantzazu'),
(289, 49, 6, 5, 'Algodre'),
(290, 50, 6, 8, 'Ainzón'),
(291, 2, 7, 7, 'Alcalá del Júcar'),
(292, 3, 7, 3, 'Alcocer de Planes'),
(293, 4, 7, 8, 'Alcolea'),
(294, 5, 7, 1, 'Aldeanueva de Santa Cruz'),
(295, 6, 7, 4, 'Alconchel'),
(296, 7, 7, 0, 'Banyalbufar'),
(297, 8, 7, 6, 'Arenys de Munt'),
(298, 9, 7, 9, 'Aguilar de Bureba'),
(299, 10, 7, 3, 'Albalá'),
(300, 11, 7, 0, 'Barbate'),
(301, 12, 7, 5, 'Alfondeguilla'),
(302, 13, 7, 1, 'Alcolea de Calatrava'),
(303, 14, 7, 6, 'Baena'),
(304, 15, 7, 9, 'Baña, A'),
(305, 16, 7, 2, 'Alberca de Záncara, La'),
(306, 17, 7, 8, 'Amer'),
(307, 18, 7, 4, 'Albuñuelas'),
(308, 19, 7, 7, 'Albares'),
(309, 20, 7, 1, 'Altzo'),
(310, 21, 7, 8, 'Aracena'),
(311, 22, 7, 3, 'Albalate de Cinca'),
(312, 23, 7, 9, 'Arjonilla'),
(313, 24, 7, 4, 'Arganza'),
(314, 25, 7, 7, 'Albatàrrec'),
(315, 26, 7, 0, 'Alcanadre'),
(316, 27, 7, 6, 'Begonte'),
(317, 28, 7, 2, 'Alcorcón'),
(318, 29, 7, 5, 'Alhaurín de la Torre'),
(319, 30, 7, 9, 'Alguazas'),
(320, 31, 7, 6, 'Adiós'),
(321, 32, 7, 1, 'Baños de Molgas'),
(322, 33, 7, 7, 'Boal'),
(323, 35, 7, 5, 'Betancuria'),
(324, 36, 7, 8, 'Campo Lameiro'),
(325, 37, 7, 4, 'Alaraz'),
(326, 38, 7, 0, 'Barlovento'),
(327, 39, 7, 3, 'Arredondo'),
(328, 40, 7, 7, 'Aldealengua de Pedraza'),
(329, 41, 7, 4, 'Algaba, La'),
(330, 42, 7, 9, 'Alcubilla de Avellaneda'),
(331, 43, 7, 5, 'Aleixar, L\''),
(332, 44, 7, 0, 'Alba'),
(333, 45, 7, 3, 'Alcolea de Tajo'),
(334, 46, 7, 6, 'Albal'),
(335, 47, 7, 2, 'Aldeamayor de San Martín'),