forked from ArielleRamgoolie/MyBnB
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Schema.txt
1903 lines (1877 loc) · 262 KB
/
Schema.txt
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
Drop all tables:
DROP TABLE ListingAmenities;
DROP TABLE Amenities;
DROP TABLE Bookings;
DROP TABLE ListingComment;
DROP TABLE RenterComment;
DROP TABLE Listings;
DROP TABLE Users;
-- Tables
CREATE TABLE Users(
id INT NOT NULL AUTO_INCREMENT,
username VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
first_name VARCHAR(255) NOT NULL,
last_name VARCHAR(255) NOT NULL,
address VARCHAR(255) NOT NULL,
dob DATE NOT NULL,
occupation VARCHAR(255) NOT NULL,
SIN INT NOT NULL,
type CHAR NOT NULL,
payment_info VARCHAR(255),
PRIMARY KEY (id)
);
CREATE TABLE Listings (
id INT NOT NULL AUTO_INCREMENT,
host_id INT NOT NULL,
type VARCHAR(255) NOT NULL,
longitude FLOAT NOT NULL,
latitude FLOAT NOT NULL,
address VARCHAR(255) NOT NULL,
city VARCHAR(255) NOT NULL,
country VARCHAR(255) NOT NULL,
postal_code VARCHAR(255) NOT NULL,
price FLOAT NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (host_id) REFERENCES Users(id)
);
CREATE TABLE Amenities (
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`type` VARCHAR(45) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE);
CREATE TABLE ListingAmenities (
amenity_id INT NOT NULL,
listing_id INT NOT NULL,
FOREIGN KEY (amenity_id) REFERENCES Amenities(id),
FOREIGN KEY (listing_id) REFERENCES Listings(id)
);
CREATE TABLE Bookings (
id INT NOT NULL AUTO_INCREMENT,
listing_id INT NOT NULL,
renter_id INT NOT NULL,
start_date DATE NOT NULL,
end_date DATE NOT NULL,
price_per_night FLOAT NOT NULL,
num_nights INT NOT NULL,
total_cost FLOAT NOT NULL,
status VARCHAR(255) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (listing_id) REFERENCES Listings(id)
);
CREATE TABLE ListingComment (
`CommentID` INT NOT NULL AUTO_INCREMENT,
`FromUser` INT NOT NULL,
`ListingID` INT NOT NULL,
`Rating` INT NOT NULL,
`Comment` VARCHAR(255) NOT NULL,
PRIMARY KEY (`CommentID`)
);
CREATE TABLE RenterComment (
`CommentID` INT NOT NULL AUTO_INCREMENT,
`FromUser` INT NOT NULL,
`ToUser` INT NOT NULL,
`Rating` INT NOT NULL,
`Comment` VARCHAR(255) NOT NULL,
PRIMARY KEY (`CommentID`)
);
-- Main Users
INSERT INTO Users (`id`, `username`, `password`, `first_name`, `last_name`, `address`, `dob`, `occupation`, `SIN`, `type`, `payment_info`)
VALUES (null, 'ShadmanT', 'shad', 'Shadman', 'Tajwar', 'BFFLane', '2002-01-04', 'student', '1423', 'r', '12345678');
INSERT INTO Users (`id`, `username`, `password`, `first_name`, `last_name`, `address`, `dob`, `occupation`, `SIN`, `type`, `payment_info`)
VALUES (null, 'Maanoboy', 'arielle', 'Maaneth', 'DeSilva', 'HollandVista', '2002-12-25', 'student', '123', 'h', null);
INSERT INTO Users (`id`, `username`, `password`, `first_name`, `last_name`, `address`, `dob`, `occupation`, `SIN`, `type`, `payment_info`)
VALUES (null, 'Rajeev', 'raj', 'Rajeev', 'Ramgoolie', 'Trinidad', '2003-08-07', 'student', '123', 'r', 1234556);
INSERT INTO Users (`id`, `username`, `password`, `first_name`, `last_name`, `address`, `dob`, `occupation`, `SIN`, `type`, `payment_info`)
VALUES (null, 'Arielle', 'maano', 'Arielle', 'Ramgoolie', 'Scarborough', '2000-09-27', 'student', '123', 'h', null);
-- Hosts
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (6, 'aloxley2', 'pw', 'Andris', 'Loxley', '49288 Lake View Parkway', '1992-01-12', 'Project Manager', 100000006, 'h', '5002355825474401');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (8, 'hcondict3', 'pw', 'Hesther', 'Condict', '54 Green Ridge Hill', '1988-08-28', 'Help Desk Technician', 100000008, 'h', '502010028887720179');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (10, 'lsakins4', 'pw', 'Lory', 'Sakins', '56048 Dayton Park', '1981-01-10', 'Help Desk Operator', 100000010, 'h', '6763666726203112');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (12, 'mfairbanks5', 'pw', 'Mara', 'Fairbanks', '169 Warbler Circle', '1966-03-08', 'Information Systems Manager', 100000012, 'h', '3531492169781326');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (14, 'gborleace6', 'pw', 'Guthrie', 'Borleace', '44 Division Street', '1979-01-17', 'Payment Adjustment Coordinator', 100000014, 'h', '30451929545324');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (16, 'fvina7', 'pw', 'Farris', 'Vina', '5 Becker Trail', '2002-02-01', 'Editor', 100000016, 'h', '6709889664279167562');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (18, 'jespinet8', 'pw', 'Julina', 'Espinet', '8 Sachs Pass', '1986-09-24', 'Pharmacist', 100000018, 'h', '5602225393981679');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (20, 'checkner9', 'pw', 'Cart', 'Heckner', '484 Hermina Center', '1991-05-24', 'GIS Technical Architect', 100000020, 'h', '5048373210010603');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (22, 'dgribbona', 'pw', 'Delmor', 'Gribbon', '98 Susan Trail', '1964-09-05', 'Professor', 100000022, 'h', '561092083968673463');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (24, 'fmccorleyb', 'pw', 'Faustine', 'McCorley', '6 Fairview Avenue', '1965-12-31', 'Senior Financial Analyst', 100000024, 'h', '490561980535472556');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (26, 'cvaladezc', 'pw', 'Consolata', 'Valadez', '21137 5th Parkway', '1992-08-31', 'Speech Pathologist', 100000026, 'h', '5100144939292649');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (28, 'aleroyd', 'pw', 'Abbe', 'Leroy', '72 Stoughton Terrace', '1959-04-17', 'Tax Accountant', 100000028, 'h', '3587885849878235');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (30, 'iminguete', 'pw', 'Inigo', 'Minguet', '49823 Schiller Street', '1996-05-10', 'Environmental Specialist', 100000030, 'h', '6763966149099331');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (32, 'tbottingf', 'pw', 'Tami', 'Botting', '2 Amoth Circle', '1989-08-29', 'Project Manager', 100000032, 'h', '4539760833650');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (34, 'dbarmadierg', 'pw', 'Dean', 'Barmadier', '042 Monica Plaza', '1958-02-23', 'Software Consultant', 100000034, 'h', '3554040583657754');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (36, 'seddisonh', 'pw', 'Swen', 'Eddison', '356 Talisman Drive', '1957-05-06', 'Senior Quality Engineer', 100000036, 'h', '6384778227281437');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (38, 'msilverstoni', 'pw', 'Maryjane', 'Silverston', '94371 Dorton Drive', '1989-02-09', 'Librarian', 100000038, 'h', '3549138579963299');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (40, 'rmccaigj', 'pw', 'Randie', 'McCaig', '628 Golf View Road', '1982-07-14', 'Structural Engineer', 100000040, 'h', '3559868499884731');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (42, 'mdwanek', 'pw', 'Mortimer', 'Dwane', '29012 Burning Wood Avenue', '1956-03-15', 'Geologist IV', 100000042, 'h', '3554384469368361');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (44, 'lpedrozzil', 'pw', 'Lorianna', 'Pedrozzi', '970 Mandrake Trail', '1967-05-08', 'Occupational Therapist', 100000044, 'h', '3573644407534680');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (46, 'asemarkem', 'pw', 'Arley', 'Semarke', '8301 Old Shore Lane', '1993-05-15', 'Structural Analysis Engineer', 100000046, 'h', '374622692172306');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (48, 'kpoweleen', 'pw', 'Karrie', 'Powelee', '9869 Clemons Parkway', '1965-09-08', 'Web Developer III', 100000048, 'h', '3564827061101851');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (50, 'dkeslakeo', 'pw', 'Dory', 'Keslake', '4 3rd Trail', '1959-07-21', 'Professor', 100000050, 'h', '3535409971409249');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (52, 'gbucklanp', 'pw', 'Greta', 'Bucklan', '5703 Anniversary Drive', '1965-07-31', 'General Manager', 100000052, 'h', '4903149147291762708');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (54, 'jcarnsonq', 'pw', 'Jennine', 'Carnson', '0 Waxwing Place', '1995-03-26', 'Information Systems Manager', 100000054, 'h', '6759472914886362');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (56, 'lmcallisterr', 'pw', 'Lorry', 'McAllister', '1684 Kinsman Lane', '1974-08-08', 'Assistant Media Planner', 100000056, 'h', '3573309779061767');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (58, 'athechams', 'pw', 'Aleta', 'Thecham', '97 Trailsway Point', '1988-10-23', 'Chief Design Engineer', 100000058, 'h', '3554392620086434');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (60, 'hcarndufft', 'pw', 'Hattie', 'Carnduff', '653 Clarendon Way', '1968-10-11', 'Account Executive', 100000060, 'h', '5038347749324114627');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (62, 'akiddeyu', 'pw', 'Ali', 'Kiddey', '158 Novick Pass', '1961-10-30', 'Account Executive', 100000062, 'h', '6763108639701095492');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (64, 'rorrv', 'pw', 'Roxine', 'Orr', '50 Larry Terrace', '1966-07-01', 'Operator', 100000064, 'h', '564182659489183382');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (66, 'amactrustyw', 'pw', 'Avery', 'MacTrusty', '35116 Florence Parkway', '1984-10-25', 'Programmer IV', 100000066, 'h', '3587614554660947');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (68, 'tjedrzejczakx', 'pw', 'Talia', 'Jedrzejczak', '7371 Emmet Road', '1979-03-25', 'Physical Therapy Assistant', 100000068, 'h', '5602243137967730');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (70, 'dcolombiery', 'pw', 'Dido', 'Colombier', '512 Glendale Terrace', '1970-01-16', 'Structural Engineer', 100000070, 'h', '3560406236640889');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (72, 'atavinorz', 'pw', 'Abramo', 'Tavinor', '96 Gateway Way', '1981-11-04', 'Assistant Media Planner', 100000072, 'h', '3588458762696684');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (74, 'dpiatek10', 'pw', 'Dagny', 'Piatek', '65500 Kennedy Terrace', '1967-03-09', 'Compensation Analyst', 100000074, 'h', '3547671765156635');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (76, 'erookes11', 'pw', 'Emmott', 'Rookes', '65 Lakewood Gardens Park', '1973-10-27', 'Internal Auditor', 100000076, 'h', '3586843796005311');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (78, 'dedmund12', 'pw', 'Donnie', 'Edmund', '99 Huxley Circle', '2001-03-17', 'Registered Nurse', 100000078, 'h', '5416229172142772');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (80, 'jmalec13', 'pw', 'Jaye', 'Malec', '9 Chive Crossing', '1971-08-15', 'Product Engineer', 100000080, 'h', '30182085320505');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (82, 'mbutrimovich14', 'pw', 'Meyer', 'Butrimovich', '648 Red Cloud Plaza', '1959-04-13', 'Internal Auditor', 100000082, 'h', '560221654028208536');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (84, 'hmanders15', 'pw', 'Hester', 'Manders', '913 Moulton Road', '1972-10-08', 'Editor', 100000084, 'h', '3535762707557768');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (86, 'rfaers16', 'pw', 'Rosene', 'Faers', '1 Annamark Way', '1961-12-03', 'Clinical Specialist', 100000086, 'h', '3551370348326335');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (88, 'jseif17', 'pw', 'Jobi', 'Seif', '5 Mesta Hill', '1984-06-23', 'Financial Analyst', 100000088, 'h', '3582548626394058');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (90, 'hfelgate18', 'pw', 'Herman', 'Felgate', '535 Beilfuss Pass', '1957-08-15', 'Executive Secretary', 100000090, 'h', '3562550526796444');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (92, 'ugrigorio19', 'pw', 'Ulrich', 'Grigorio', '644 Erie Point', '1996-02-04', 'Chief Design Engineer', 100000092, 'h', '6396439571234235');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (94, 'dradborne1a', 'pw', 'Diane-marie', 'Radborne', '6 Jackson Road', '1981-07-20', 'Media Manager II', 100000094, 'h', '3561126455991370');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (96, 'gfellgate1b', 'pw', 'Glynnis', 'Fellgate', '6907 Eagan Parkway', '1997-10-19', 'Systems Administrator II', 100000096, 'h', '3571013712503123');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (98, 'rgarrard1c', 'pw', 'Reade', 'Garrard', '616 Heath Park', '1997-11-08', 'GIS Technical Architect', 100000098, 'h', '6761370638614225');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (100, 'dquiddinton1d', 'pw', 'Drusi', 'Quiddinton', '6 Packers Circle', '2000-04-07', 'Registered Nurse', 100000100, 'h', '376680459656315');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (102, 'kgutcher1e', 'pw', 'Keslie', 'Gutcher', '53700 Chive Circle', '1978-11-12', 'Help Desk Operator', 100000102, 'h', '5100175586425801');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (104, 'rbarniss1f', 'pw', 'Randie', 'Barniss', '6376 Superior Pass', '1983-07-18', 'Actuary', 100000104, 'h', '3564948725735569');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (106, 'emcginnis1g', 'pw', 'Eugene', 'McGinnis', '576 Birchwood Hill', '1998-07-13', 'Account Coordinator', 100000106, 'h', '3577169217947316');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (108, 'rbohl1h', 'pw', 'Rodolphe', 'Bohl', '4219 Muir Court', '1969-06-17', 'Actuary', 100000108, 'h', '374283533861779');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (110, 'atradewell1i', 'pw', 'Andra', 'Tradewell', '70610 Randy Alley', '1959-03-04', 'Food Chemist', 100000110, 'h', '30190322765077');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (112, 'dprendergrass1j', 'pw', 'Demetria', 'Prendergrass', '4 Sloan Road', '1978-10-07', 'Automation Specialist IV', 100000112, 'h', '3565875377903667');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (114, 'rmatterson1k', 'pw', 'Rosco', 'Matterson', '40129 Maple Wood Place', '1984-01-19', 'Clinical Specialist', 100000114, 'h', '3562650268929995');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (116, 'aprudham1l', 'pw', 'Arlana', 'Prudham', '75139 Little Fleur Parkway', '1973-09-19', 'Occupational Therapist', 100000116, 'h', '3537988593809504');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (118, 'jgeorgiev1m', 'pw', 'Jeremias', 'Georgiev', '85 Coleman Plaza', '1966-06-11', 'Civil Engineer', 100000118, 'h', '30207236206293');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (120, 'rdunstall1n', 'pw', 'Reeba', 'Dunstall', '77725 Bay Drive', '1997-07-12', 'Community Outreach Specialist', 100000120, 'h', '503878708472843051');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (122, 'gsoftley1o', 'pw', 'Gaylor', 'Softley', '10 Blaine Avenue', '1997-07-20', 'Senior Developer', 100000122, 'h', '3546328004508339');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (124, 'ealfonsini1p', 'pw', 'Eugene', 'Alfonsini', '2425 Jackson Junction', '1991-10-23', 'Senior Financial Analyst', 100000124, 'h', '3562746999970850');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (126, 'pchessor1q', 'pw', 'Phaidra', 'Chessor', '3 Twin Pines Circle', '1967-11-04', 'Assistant Manager', 100000126, 'h', '5496748232248744');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (128, 'bsokell1r', 'pw', 'Berrie', 'Sokell', '65 Derek Alley', '1963-08-23', 'Staff Accountant III', 100000128, 'h', '5454101518185075');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (130, 'kjiri1s', 'pw', 'Kristan', 'Jiri', '7 Charing Cross Hill', '1961-01-09', 'Help Desk Operator', 100000130, 'h', '6709719192999635');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (132, 'lmacskeaghan1t', 'pw', 'Linette', 'MacSkeaghan', '12 Northwestern Terrace', '1974-07-05', 'Geological Engineer', 100000132, 'h', '4917412932775092');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (134, 'mwellings1u', 'pw', 'Margeaux', 'Wellings', '7442 Stang Park', '1977-01-18', 'Developer III', 100000134, 'h', '491189760384015544');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (136, 'garnault1v', 'pw', 'Gusti', 'Arnault', '37 Nobel Center', '1982-07-09', 'Mechanical Systems Engineer', 100000136, 'h', '3579301999884221');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (138, 'hglasser1w', 'pw', 'Haydon', 'Glasser', '54182 Manley Alley', '1974-12-31', 'Assistant Media Planner', 100000138, 'h', '3571786791602961');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (140, 'cnowell1x', 'pw', 'Carmine', 'Nowell', '84723 Lerdahl Lane', '1990-01-10', 'Geological Engineer', 100000140, 'h', '3549276035652666');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (142, 'jzukerman1y', 'pw', 'Jenna', 'Zukerman', '02198 Clarendon Trail', '1982-04-14', 'Administrative Assistant I', 100000142, 'h', '3548154898393986');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (144, 'apirkis1z', 'pw', 'Andie', 'Pirkis', '791 Debra Alley', '1968-01-13', 'VP Product Management', 100000144, 'h', '5610922050492350');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (146, 'bschonfelder20', 'pw', 'Burton', 'Schonfelder', '1298 Dawn Drive', '1977-02-04', 'Product Engineer', 100000146, 'h', '5010125561157563');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (148, 'blakenton21', 'pw', 'Bonni', 'Lakenton', '4 Melrose Junction', '1986-11-03', 'Senior Quality Engineer', 100000148, 'h', '3548199294289379');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (150, 'gboyles22', 'pw', 'Griffie', 'Boyles', '667 Boyd Alley', '1980-01-24', 'Account Coordinator', 100000150, 'h', '374288302292064');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (152, 'mstannis23', 'pw', 'Maryellen', 'Stannis', '1 Hagan Road', '1956-08-03', 'Environmental Specialist', 100000152, 'h', '560223411600875689');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (154, 'dmaskill24', 'pw', 'Den', 'Maskill', '77532 Autumn Leaf Plaza', '1967-03-23', 'Social Worker', 100000154, 'h', '3577245465978284');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (156, 'cmcvicker25', 'pw', 'Cristin', 'McVicker', '641 Lerdahl Center', '1960-08-31', 'Quality Engineer', 100000156, 'h', '3547952520256666');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (158, 'dmole26', 'pw', 'Deana', 'Mole', '5192 Sundown Park', '1961-04-27', 'Research Associate', 100000158, 'h', '3578149638528860');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (160, 'prisebrow27', 'pw', 'Pascale', 'Risebrow', '94080 Stuart Street', '1978-03-30', 'Senior Developer', 100000160, 'h', '5010124511759958');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (162, 'lgrindell28', 'pw', 'Lizbeth', 'Grindell', '01 Garrison Park', '1972-11-29', 'Help Desk Technician', 100000162, 'h', '201753194782620');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (164, 'criediger29', 'pw', 'Curcio', 'Riediger', '1 8th Drive', '1994-01-26', 'Research Assistant I', 100000164, 'h', '3565206204550481');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (166, 'cbissex2a', 'pw', 'Corilla', 'Bissex', '4819 Fisk Crossing', '1977-07-01', 'Software Test Engineer I', 100000166, 'h', '5256209444244765');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (168, 'zmangenet2b', 'pw', 'Zilvia', 'Mangenet', '02427 Sunbrook Lane', '2002-01-23', 'Project Manager', 100000168, 'h', '5602232040186744');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (170, 'taizic2c', 'pw', 'Thorstein', 'Aizic', '20 Carioca Road', '1985-06-03', 'Nurse Practicioner', 100000170, 'h', '3564065494304426');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (172, 'lfourcade2d', 'pw', 'Lorine', 'Fourcade', '87 Walton Parkway', '1957-06-14', 'Software Consultant', 100000172, 'h', '4913654631819010');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (174, 'dmcpartling2e', 'pw', 'Duffie', 'McPartling', '2253 Paget Plaza', '1989-02-17', 'Software Test Engineer I', 100000174, 'h', '6331101091848690');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (176, 'lwakenshaw2f', 'pw', 'Leonora', 'Wakenshaw', '2402 Blaine Parkway', '1989-03-10', 'Help Desk Operator', 100000176, 'h', '344238307888637');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (178, 'lcranage2g', 'pw', 'Lanna', 'Cranage', '06171 Oakridge Lane', '1962-09-29', 'Web Designer I', 100000178, 'h', '6759149256482907');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (180, 'gbushell2h', 'pw', 'Germain', 'Bushell', '32114 Kingsford Lane', '1988-03-03', 'Recruiter', 100000180, 'h', '3575123558876115');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (182, 'eleask2i', 'pw', 'Essie', 'Leask', '1945 Mandrake Plaza', '2000-01-14', 'Pharmacist', 100000182, 'h', '6761452629112946579');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (184, 'zsharpless2j', 'pw', 'Zena', 'Sharpless', '109 Rutledge Drive', '1988-01-24', 'Web Designer I', 100000184, 'h', '3555508424169535');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (186, 'astellino2k', 'pw', 'Alfy', 'Stellino', '2 Oneill Center', '1986-05-28', 'Speech Pathologist', 100000186, 'h', '5100142343704928');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (188, 'gbursnall2l', 'pw', 'Gene', 'Bursnall', '19388 Coolidge Alley', '1991-05-18', 'Engineer II', 100000188, 'h', '372301266305103');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (190, 'olydford2m', 'pw', 'Ollie', 'Lydford', '81670 Merrick Hill', '1959-03-08', 'Account Coordinator', 100000190, 'h', '5020695077359950');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (192, 'mfilipson2n', 'pw', 'Moselle', 'Filipson', '63167 Mosinee Plaza', '1990-04-14', 'Nurse', 100000192, 'h', '3553588726743080');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (194, 'kcurbishley2o', 'pw', 'Kalila', 'Curbishley', '2645 Portage Plaza', '1963-06-02', 'Biostatistician IV', 100000194, 'h', '502067965388753211');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (196, 'aairy2p', 'pw', 'Arvie', 'Airy', '3477 Moland Alley', '1977-07-07', 'Media Manager IV', 100000196, 'h', '30378086587676');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (198, 'dbasili2q', 'pw', 'Darya', 'Basili', '249 Arkansas Drive', '1971-10-08', 'Desktop Support Technician', 100000198, 'h', '5602237355726190');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (200, 'wferrand2r', 'pw', 'Wiley', 'Ferrand', '57331 Butterfield Plaza', '1993-07-15', 'VP Marketing', 100000200, 'h', '201978030225035');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (202, 'lcroneen2s', 'pw', 'Lizzy', 'Croneen', '220 Thackeray Street', '1970-12-22', 'Speech Pathologist', 100000202, 'h', '3540021955238511');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (204, 'lroffe2t', 'pw', 'Lauree', 'Roffe', '2 Clyde Gallagher Parkway', '1994-11-07', 'Quality Control Specialist', 100000204, 'h', '3589056980470491');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (206, 'sgilbart2u', 'pw', 'Spike', 'Gilbart', '5 Gulseth Junction', '1966-06-26', 'Quality Control Specialist', 100000206, 'h', '3538034145355248');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (208, 'flarkin2v', 'pw', 'Ferdinand', 'Larkin', '6 Twin Pines Way', '1987-12-31', 'Desktop Support Technician', 100000208, 'h', '4017950551257180');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (210, 'mmounsey2w', 'pw', 'Marc', 'Mounsey', '11 Summer Ridge Pass', '1957-12-08', 'Chief Design Engineer', 100000210, 'h', '63043228924239076');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (212, 'rbratten2x', 'pw', 'Renee', 'Bratten', '2750 3rd Parkway', '1976-09-21', 'Environmental Tech', 100000212, 'h', '3528809320031025');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (214, 'afoffano2y', 'pw', 'Agneta', 'Foffano', '940 Heffernan Trail', '1974-10-08', 'Computer Systems Analyst I', 100000214, 'h', '4903769792878086119');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (216, 'tpennini2z', 'pw', 'Tucky', 'Pennini', '942 Delladonna Road', '1958-04-28', 'Office Assistant I', 100000216, 'h', '4017957187917');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (218, 'lsheehy30', 'pw', 'Lee', 'Sheehy', '04929 Packers Place', '1981-06-12', 'Internal Auditor', 100000218, 'h', '3569963056243195');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (220, 'wscoterbosh31', 'pw', 'Winfred', 'Scoterbosh', '9 Harper Court', '1970-11-03', 'VP Accounting', 100000220, 'h', '374288666351423');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (222, 'odowker32', 'pw', 'Othelia', 'Dowker', '60 Dorton Park', '1994-08-27', 'Structural Analysis Engineer', 100000222, 'h', '63047250040395174');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (224, 'gdinis33', 'pw', 'Gael', 'Dinis', '734 Trailsway Road', '1962-03-31', 'Junior Executive', 100000224, 'h', '374288659464274');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (226, 'tweavill34', 'pw', 'Tobiah', 'Weavill', '74 Duke Drive', '1984-04-10', 'Administrative Assistant IV', 100000226, 'h', '3531316582766509');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (228, 'scalfe35', 'pw', 'Shirleen', 'Calfe', '74504 Bobwhite Trail', '1969-02-01', 'Clinical Specialist', 100000228, 'h', '3560926685111330');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (230, 'ecarillo36', 'pw', 'Elinor', 'Carillo', '3531 Morrow Crossing', '1968-10-03', 'Software Consultant', 100000230, 'h', '201467988456420');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (232, 'benion37', 'pw', 'Bambie', 'Enion', '485 Fulton Center', '1969-12-06', 'Accountant III', 100000232, 'h', '30052670469571');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (234, 'dmcgonigle38', 'pw', 'Daria', 'McGonigle', '27060 Autumn Leaf Circle', '1969-02-27', 'Marketing Assistant', 100000234, 'h', '5602228632899751');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (236, 'gheffron39', 'pw', 'Glen', 'Heffron', '928 Talmadge Pass', '1989-08-24', 'Marketing Assistant', 100000236, 'h', '3537193240937697');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (238, 'rselcraig3a', 'pw', 'Rice', 'Selcraig', '05 Sachs Alley', '1984-04-19', 'Nuclear Power Engineer', 100000238, 'h', '374288941460643');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (240, 'ngoodchild3b', 'pw', 'Natalee', 'Goodchild', '8 John Wall Pass', '1980-05-24', 'Technical Writer', 100000240, 'h', '3587032604679587');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (242, 'rboller3c', 'pw', 'Reeba', 'Boller', '83 Hermina Circle', '1980-06-16', 'Payment Adjustment Coordinator', 100000242, 'h', '30520818621105');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (244, 'dgreally3d', 'pw', 'Darcie', 'Greally', '07 Sachtjen Trail', '1993-08-05', 'Electrical Engineer', 100000244, 'h', '3581376578205887');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (246, 'lsabey3e', 'pw', 'Laure', 'Sabey', '5056 Judy Drive', '1990-01-02', 'Help Desk Technician', 100000246, 'h', '561018866980812510');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (248, 'whewertson3f', 'pw', 'Waldo', 'Hewertson', '575 New Castle Park', '1999-12-03', 'Tax Accountant', 100000248, 'h', '5592508465814585');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (250, 'hkegg3g', 'pw', 'Hamel', 'Kegg', '2 8th Road', '1971-06-02', 'Staff Accountant II', 100000250, 'h', '3567284563949980');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (252, 'mbullent3h', 'pw', 'Marcelia', 'Bullent', '494 Fremont Crossing', '1963-10-12', 'Systems Administrator III', 100000252, 'h', '30365902199596');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (254, 'avaen3i', 'pw', 'Aurelie', 'Vaen', '975 Crownhardt Hill', '1984-07-31', 'Legal Assistant', 100000254, 'h', '633404979349582515');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (256, 'greyner3j', 'pw', 'George', 'Reyner', '76 Mifflin Street', '1986-03-04', 'Programmer Analyst III', 100000256, 'h', '5100139271963807');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (258, 'mtrematick3k', 'pw', 'Meggie', 'Trematick', '92 International Trail', '1984-05-25', 'Account Coordinator', 100000258, 'h', '201929655329644');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (260, 'rhanny3l', 'pw', 'Riki', 'Hanny', '16 Village Green Hill', '1964-01-27', 'Food Chemist', 100000260, 'h', '3579543913891879');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (262, 'bmuselli3m', 'pw', 'Barry', 'Muselli', '741 Washington Lane', '1989-02-10', 'Operator', 100000262, 'h', '3534969870421042');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (264, 'djosofovitz3n', 'pw', 'Demetria', 'Josofovitz', '521 Ludington Terrace', '2002-07-23', 'VP Marketing', 100000264, 'h', '3589607744698858');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (266, 'csebert3o', 'pw', 'Caspar', 'Sebert', '73795 Anhalt Way', '1959-02-20', 'Geologist II', 100000266, 'h', '630454464961217216');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (268, 'bgiacometti3p', 'pw', 'Britta', 'Giacometti', '34971 Pierstorff Place', '1990-03-09', 'Media Manager II', 100000268, 'h', '3531884111176128');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (270, 'fnys3q', 'pw', 'Fields', 'Nys', '5 Gateway Way', '1977-06-03', 'Media Manager I', 100000270, 'h', '3546763883409607');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (272, 'aiiannoni3r', 'pw', 'Ashleigh', 'Iiannoni', '0 Ridgeview Street', '1977-02-24', 'Librarian', 100000272, 'h', '4041598869921664');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (274, 'kaccombe3s', 'pw', 'Kaitlin', 'Accombe', '3 Ronald Regan Alley', '1999-06-25', 'Account Representative II', 100000274, 'h', '5100174437103584');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (276, 'jborland3t', 'pw', 'Jordon', 'Borland', '66 Anniversary Drive', '1998-11-24', 'Food Chemist', 100000276, 'h', '3575150099677843');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (278, 'credd3u', 'pw', 'Carol-jean', 'Redd', '9968 Jenifer Street', '1959-03-08', 'Chemical Engineer', 100000278, 'h', '201785084814147');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (280, 'bhydes3v', 'pw', 'Barrett', 'Hydes', '92 Dakota Place', '1986-09-15', 'Senior Financial Analyst', 100000280, 'h', '3542858882186224');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (282, 'awinpenny3w', 'pw', 'Aldis', 'Winpenny', '37179 Daystar Road', '1990-09-26', 'Project Manager', 100000282, 'h', '201656513830931');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (284, 'kbeavan3x', 'pw', 'Kale', 'Beavan', '61317 South Hill', '1994-03-30', 'Financial Analyst', 100000284, 'h', '372578400955600');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (286, 'whancorn3y', 'pw', 'Wayland', 'Hancorn', '126 Carey Junction', '1972-04-02', 'Research Nurse', 100000286, 'h', '3588231822881863');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (288, 'achaytor3z', 'pw', 'Alta', 'Chaytor', '8 Dixon Terrace', '1971-10-19', 'Administrative Assistant II', 100000288, 'h', '5238801647624042');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (290, 'cbowater40', 'pw', 'Cirstoforo', 'Bowater', '2860 5th Road', '1972-07-25', 'Quality Control Specialist', 100000290, 'h', '67636140723863978');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (292, 'sblondin41', 'pw', 'Suellen', 'Blondin', '65 Lawn Pass', '1985-08-22', 'Payment Adjustment Coordinator', 100000292, 'h', '5108759346078265');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (294, 'tburdikin42', 'pw', 'Thebault', 'Burdikin', '08 Myrtle Junction', '1964-08-26', 'Senior Cost Accountant', 100000294, 'h', '36971110727062');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (296, 'mgrammer43', 'pw', 'Mireille', 'Grammer', '17871 Grayhawk Court', '1961-07-27', 'Software Engineer III', 100000296, 'h', '4913129302045021');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (298, 'dokeefe44', 'pw', 'Doria', 'O''Keefe', '70 Red Cloud Plaza', '1966-04-21', 'Financial Advisor', 100000298, 'h', '3542829781336962');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (300, 'sredding45', 'pw', 'Sally', 'Redding', '031 Hanover Alley', '1964-11-12', 'Electrical Engineer', 100000300, 'h', '3559854988285465');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (302, 'ebernaldo46', 'pw', 'Elie', 'Bernaldo', '496 Green Place', '1985-02-22', 'Accountant III', 100000302, 'h', '3542012188607232');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (304, 'emoroney47', 'pw', 'Elna', 'Moroney', '42171 Kedzie Parkway', '1988-03-06', 'Analog Circuit Design manager', 100000304, 'h', '3582198646084790');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (306, 'rcarless48', 'pw', 'Russ', 'Carless', '01250 Gale Road', '1995-01-18', 'Editor', 100000306, 'h', '30511493058564');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (308, 'ckupker49', 'pw', 'Carmina', 'Kupker', '949 Old Shore Way', '1967-01-27', 'Nurse', 100000308, 'h', '3560456670459528');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (310, 'dtierny4a', 'pw', 'Drucie', 'Tierny', '21391 Sunbrook Avenue', '1966-01-31', 'Accountant III', 100000310, 'h', '6333013048882356218');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (312, 'aleggat4b', 'pw', 'Ava', 'Leggat', '136 Westerfield Drive', '1972-02-06', 'General Manager', 100000312, 'h', '201468508017973');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (314, 'wwearne4c', 'pw', 'Wylma', 'Wearne', '56 Sloan Park', '1961-01-01', 'Pharmacist', 100000314, 'h', '5100179690917539');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (316, 'lcornehl4d', 'pw', 'Lorita', 'Cornehl', '1352 David Crossing', '1970-09-11', 'Assistant Manager', 100000316, 'h', '3551595918273612');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (318, 'lsmaling4e', 'pw', 'Lurleen', 'Smaling', '13 Barnett Trail', '1998-01-01', 'Programmer III', 100000318, 'h', '4405233764425542');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (320, 'mabthorpe4f', 'pw', 'Myrtice', 'Abthorpe', '0542 Artisan Alley', '2002-04-18', 'Associate Professor', 100000320, 'h', '5641829753203724884');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (322, 'dwanek4g', 'pw', 'Devondra', 'Wanek', '658 2nd Street', '1964-02-04', 'Biostatistician III', 100000322, 'h', '6334714338974495655');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (324, 'ahigginbottam4h', 'pw', 'Asa', 'Higginbottam', '01 Almo Park', '1967-05-18', 'Senior Sales Associate', 100000324, 'h', '371118026280637');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (326, 'cgaytor4i', 'pw', 'Callie', 'Gaytor', '17 Dixon Plaza', '1995-11-17', 'Paralegal', 100000326, 'h', '3531786624523722');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (328, 'gwynrahame4j', 'pw', 'Gav', 'Wynrahame', '3 Summit Point', '1978-05-30', 'VP Accounting', 100000328, 'h', '372301722294107');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (330, 'flilywhite4k', 'pw', 'Faythe', 'Lilywhite', '10 Morrow Court', '1975-08-25', 'Product Engineer', 100000330, 'h', '3573471728062153');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (332, 'rcrump4l', 'pw', 'Rena', 'Crump', '43564 Eastlawn Plaza', '1973-10-02', 'Human Resources Manager', 100000332, 'h', '4917516242418712');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (334, 'bpedden4m', 'pw', 'Beale', 'Pedden', '9 Florence Point', '1994-04-26', 'Compensation Analyst', 100000334, 'h', '3580229721846241');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (336, 'rheddan4n', 'pw', 'Rudolph', 'Heddan', '60 Charing Cross Park', '1971-08-08', 'Occupational Therapist', 100000336, 'h', '3574197551891447');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (338, 'jleachman4o', 'pw', 'Jeralee', 'Leachman', '2 Mifflin Park', '1989-02-10', 'VP Quality Control', 100000338, 'h', '3560704052919613');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (340, 'cjohantges4p', 'pw', 'Corbet', 'Johantges', '05608 Sunbrook Circle', '1983-03-11', 'Community Outreach Specialist', 100000340, 'h', '560223990461468304');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (342, 'handrick4q', 'pw', 'Heidi', 'Andrick', '5974 Del Sol Junction', '1975-01-08', 'Web Developer III', 100000342, 'h', '67063345466944230');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (344, 'bhitcham4r', 'pw', 'Brynna', 'Hitcham', '307 Oakridge Avenue', '1986-05-26', 'Engineer III', 100000344, 'h', '676756631663167562');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (346, 'cduffy4s', 'pw', 'Cassandra', 'Duffy', '738 Crownhardt Point', '1989-02-17', 'Teacher', 100000346, 'h', '4917007471672567');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (348, 'mjanny4t', 'pw', 'Merill', 'Janny', '9237 Fuller Avenue', '1959-03-12', 'VP Marketing', 100000348, 'h', '4903287215277461');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (350, 'kgreig4u', 'pw', 'Keefe', 'Greig', '1113 Maywood Court', '1980-01-31', 'Geologist II', 100000350, 'h', '5341265076254412');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (352, 'amitkin4v', 'pw', 'Ariana', 'Mitkin', '03463 Service Lane', '1990-10-29', 'Help Desk Operator', 100000352, 'h', '3539588045281423');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (354, 'dbrockett4w', 'pw', 'Donelle', 'Brockett', '640 Reinke Junction', '1992-03-17', 'Engineer IV', 100000354, 'h', '3540494142369681');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (356, 'jmanley4x', 'pw', 'Julina', 'Manley', '37921 Dawn Pass', '1997-10-18', 'Clinical Specialist', 100000356, 'h', '30338326075825');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (358, 'scastiglioni4y', 'pw', 'Steve', 'Castiglioni', '19 Browning Road', '1968-06-29', 'Information Systems Manager', 100000358, 'h', '3548148459202800');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (360, 'vdemalchar4z', 'pw', 'Vania', 'De Malchar', '9288 Memorial Alley', '2000-05-09', 'Chemical Engineer', 100000360, 'h', '633386288149695564');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (362, 'ckloisner50', 'pw', 'Cirstoforo', 'Kloisner', '3908 Gina Terrace', '1961-09-22', 'Paralegal', 100000362, 'h', '3532351108102441');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (364, 'dgirling51', 'pw', 'Darren', 'Girling', '6333 Oxford Court', '1990-03-17', 'Desktop Support Technician', 100000364, 'h', '3563556022215143');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (366, 'jvondrasek52', 'pw', 'Jackie', 'Vondrasek', '170 Prentice Junction', '2001-01-01', 'Senior Developer', 100000366, 'h', '3561619676954656');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (368, 'alangmuir53', 'pw', 'Anitra', 'Langmuir', '7 Center Street', '2002-06-21', 'Office Assistant I', 100000368, 'h', '4041595816075');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (370, 'mgyorffy54', 'pw', 'Marice', 'Gyorffy', '7379 Morningstar Junction', '1974-12-25', 'Nuclear Power Engineer', 100000370, 'h', '3569472786102267');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (372, 'sgillitt55', 'pw', 'Stephanie', 'Gillitt', '1 1st Circle', '2002-02-03', 'Graphic Designer', 100000372, 'h', '4905800904670685');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (374, 'lpedican56', 'pw', 'Levi', 'Pedican', '53 Mesta Court', '1965-11-11', 'VP Accounting', 100000374, 'h', '3556951496889292');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (376, 'awrathmell57', 'pw', 'Adella', 'Wrathmell', '74 Northwestern Center', '1971-05-24', 'Programmer Analyst IV', 100000376, 'h', '3584382539410977');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (378, 'eguislin58', 'pw', 'Emmalynne', 'Guislin', '915 Ruskin Center', '1962-10-08', 'Nurse Practicioner', 100000378, 'h', '6759269471067067');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (380, 'gharniman59', 'pw', 'Giles', 'Harniman', '80 Lawn Alley', '1972-03-04', 'Geological Engineer', 100000380, 'h', '3540087250504246');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (382, 'kwolverson5a', 'pw', 'Ky', 'Wolverson', '64467 Twin Pines Lane', '1973-12-05', 'Quality Control Specialist', 100000382, 'h', '6706924442148211686');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (384, 'emcgowing5b', 'pw', 'Elnora', 'McGowing', '8270 American Trail', '2002-08-04', 'Information Systems Manager', 100000384, 'h', '5493663915680902');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (386, 'dandriesse5c', 'pw', 'Daune', 'Andriesse', '989 Bartelt Avenue', '1960-02-02', 'Product Engineer', 100000386, 'h', '337941440765856');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (388, 'bstonman5d', 'pw', 'Bernardina', 'Stonman', '4902 Magdeline Hill', '1962-09-16', 'Marketing Assistant', 100000388, 'h', '3572080420572475');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (390, 'pfinan5e', 'pw', 'Pamela', 'Finan', '4 Bay Court', '1969-10-11', 'Junior Executive', 100000390, 'h', '5602210704964580');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (392, 'rdumbrall5f', 'pw', 'Raychel', 'Dumbrall', '257 Alpine Trail', '1976-08-24', 'Media Manager I', 100000392, 'h', '3539267189673139');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (394, 'gsikorsky5g', 'pw', 'Gianna', 'Sikorsky', '54179 Eliot Avenue', '1997-10-04', 'Programmer III', 100000394, 'h', '670645924472698291');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (396, 'fgrand5h', 'pw', 'Foss', 'Grand', '454 Anthes Street', '1966-01-08', 'Assistant Media Planner', 100000396, 'h', '6759897637943472');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (398, 'kbrome5i', 'pw', 'Kort', 'Brome', '348 Bunker Hill Pass', '2001-11-14', 'Electrical Engineer', 100000398, 'h', '5108755363045864');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (400, 'gleader5j', 'pw', 'Ginny', 'Leader', '6 Alpine Hill', '1956-04-27', 'Research Nurse', 100000400, 'h', '3562400244601189');
-- Renters
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (5, 'kcraigs1', 'pw', 'Karen', 'Craigs', '93993 Corscot Park', '1988-05-04', 'Occupational Therapist', 100000004, 'r', '6375853926075413');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (7, 'ekermath2', 'pw', 'Erwin', 'Kermath', '3 Anderson Junction', '1957-12-15', 'Statistician I', 100000006, 'r', '5602256998578238432');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (9, 'thattiff3', 'pw', 'Tomaso', 'Hattiff', '3606 5th Junction', '1997-10-23', 'Operator', 100000008, 'r', '3542817436328021');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (11, 'mmassot4', 'pw', 'Maxwell', 'Massot', '9649 Jackson Trail', '1975-02-08', 'Office Assistant III', 100000010, 'r', '4026442882063700');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (13, 'istuddeard5', 'pw', 'Izzy', 'Studdeard', '51 Swallow Park', '1975-06-14', 'Environmental Specialist', 100000012, 'r', '3555266269859633');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (15, 'bberry6', 'pw', 'Berke', 'Berry', '0655 Browning Point', '1982-09-04', 'Information Systems Manager', 100000014, 'r', '6304867341023028');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (17, 'czarfati7', 'pw', 'Colet', 'Zarfati', '1307 Bartillon Street', '1965-05-21', 'Sales Representative', 100000016, 'r', '4905474240909687100');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (19, 'bivanchin8', 'pw', 'Boycie', 'Ivanchin', '303 Blaine Lane', '1959-08-27', 'Tax Accountant', 100000018, 'r', '5602252263726158');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (21, 'scoytes9', 'pw', 'Sharona', 'Coytes', '63 Tennessee Plaza', '1957-11-02', 'Sales Representative', 100000020, 'r', '060451842005716314');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (23, 'pwadmorea', 'pw', 'Patti', 'Wadmore', '68 Service Drive', '1983-11-03', 'Dental Hygienist', 100000022, 'r', '3570205471180793');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (25, 'bcrepinb', 'pw', 'Barclay', 'Crepin', '89 Forest Run Way', '2001-03-26', 'Environmental Specialist', 100000024, 'r', '3589917580945887');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (27, 'thuffc', 'pw', 'Tait', 'Huff', '17 Northfield Hill', '1959-08-16', 'Human Resources Manager', 100000026, 'r', '5602216283568437');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (29, 'rfilppettid', 'pw', 'Rancell', 'Filppetti', '826 School Park', '1995-05-05', 'Sales Associate', 100000028, 'r', '6333671680857300251');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (31, 'cglasscooe', 'pw', 'Crawford', 'Glasscoo', '07 Southridge Trail', '1996-05-19', 'Account Representative IV', 100000030, 'r', '4911590840505630');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (33, 'gbowdlerf', 'pw', 'Garrard', 'Bowdler', '023 Barby Drive', '1976-03-02', 'Account Representative IV', 100000032, 'r', '3580193775266286');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (35, 'sproschg', 'pw', 'Shandeigh', 'Prosch', '4240 Elka Alley', '1960-02-04', 'Administrative Officer', 100000034, 'r', '3552785684909221');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (37, 'ykrzyzanowskih', 'pw', 'Yurik', 'Krzyzanowski', '7623 Sunbrook Point', '1977-09-15', 'Associate Professor', 100000036, 'r', '201880868343858');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (39, 'bhofi', 'pw', 'Bartram', 'Hof', '8148 Katie Pass', '1968-10-22', 'Software Engineer IV', 100000038, 'r', '3554461737706976');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (41, 'owanstallj', 'pw', 'Orelee', 'Wanstall', '150 Milwaukee Parkway', '1981-09-09', 'Information Systems Manager', 100000040, 'r', '490586683783311002');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (43, 'mvinckk', 'pw', 'Marsh', 'Vinck', '8961 North Point', '1971-12-04', 'Electrical Engineer', 100000042, 'r', '67631812592740207');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (45, 'lcahanil', 'pw', 'Lesli', 'Cahani', '2937 Alpine Place', '1978-06-07', 'Human Resources Assistant II', 100000044, 'r', '3531089276798340');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (47, 'gseintm', 'pw', 'Gerardo', 'Seint', '66622 Warbler Place', '1975-09-14', 'Business Systems Development Analyst', 100000046, 'r', '3586478501192516');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (49, 'gpullann', 'pw', 'Guntar', 'Pullan', '9735 Helena Junction', '1979-08-31', 'Assistant Media Planner', 100000048, 'r', '3547758889690498');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (51, 'jdortono', 'pw', 'Janessa', 'Dorton', '672 Springview Road', '1989-12-17', 'Quality Control Specialist', 100000050, 'r', '5010127810789584');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (53, 'eheinzlerp', 'pw', 'Elora', 'Heinzler', '38020 Calypso Lane', '1987-11-01', 'Quality Engineer', 100000052, 'r', '3531485075847801');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (55, 'mgreatlandq', 'pw', 'Marie-jeanne', 'Greatland', '47369 Buena Vista Parkway', '1972-03-21', 'Account Executive', 100000054, 'r', '3567652533991334');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (57, 'jhowelsr', 'pw', 'Jacky', 'Howels', '5 Scofield Pass', '1977-05-22', 'Structural Engineer', 100000056, 'r', '3542670224003987');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (59, 'jburretts', 'pw', 'Jillian', 'Burrett', '35 Hintze Hill', '1977-08-05', 'Software Consultant', 100000058, 'r', '201794757260067');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (61, 'predfearnt', 'pw', 'Pia', 'Redfearn', '07 Macpherson Road', '1956-10-03', 'Geological Engineer', 100000060, 'r', '4913695560853413');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (63, 'ckleinzweigu', 'pw', 'Carita', 'Kleinzweig', '71 Ridgeway Point', '1982-05-07', 'Automation Specialist III', 100000062, 'r', '3586582656165597');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (65, 'lstreetingv', 'pw', 'Lia', 'Streeting', '90537 Monterey Court', '1985-05-28', 'Sales Associate', 100000064, 'r', '3543195595297322');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (67, 'astellinw', 'pw', 'Aimee', 'Stellin', '7 Towne Center', '1974-03-10', 'Cost Accountant', 100000066, 'r', '3578659338528515');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (69, 'cvinsonx', 'pw', 'Calhoun', 'Vinson', '180 Maryland Alley', '1991-08-21', 'Senior Sales Associate', 100000068, 'r', '3565736049474562');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (71, 'lannakiny', 'pw', 'Loree', 'Annakin', '686 Independence Hill', '1980-03-02', 'Accounting Assistant II', 100000070, 'r', '3576111194966670');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (73, 'fcornewz', 'pw', 'Florida', 'Cornew', '22478 Drewry Park', '1955-10-12', 'Environmental Tech', 100000072, 'r', '5100146745448794');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (75, 'csearl10', 'pw', 'Clement', 'Searl', '3820 David Plaza', '2002-04-16', 'Social Worker', 100000074, 'r', '4917151060201758');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (77, 'amerwede11', 'pw', 'Arvy', 'Merwede', '18039 Scoville Center', '1978-01-21', 'Web Developer II', 100000076, 'r', '201689586649375');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (79, 'khallas12', 'pw', 'Kerr', 'Hallas', '7751 Sunfield Place', '1993-06-13', 'Chief Design Engineer', 100000078, 'r', '4913269539054519');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (81, 'rdevons13', 'pw', 'Rowena', 'Devons', '0 Eagan Avenue', '1992-04-21', 'Senior Editor', 100000080, 'r', '6771930144504863516');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (83, 'cpetrashov14', 'pw', 'Carlota', 'Petrashov', '83531 American Crossing', '1974-08-26', 'Senior Quality Engineer', 100000082, 'r', '343817070545325');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (85, 'aauld15', 'pw', 'Antonie', 'Auld', '0619 Hauk Hill', '1969-12-31', 'Accountant II', 100000084, 'r', '30013217560678');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (87, 'emccomb16', 'pw', 'Essie', 'McComb', '3 Glacier Hill Parkway', '1983-02-17', 'Business Systems Development Analyst', 100000086, 'r', '3545256728589882');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (89, 'nstennings17', 'pw', 'Noel', 'Stennings', '215 Mcguire Terrace', '1957-11-04', 'Nurse', 100000088, 'r', '6761032009228494');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (91, 'lluckcock18', 'pw', 'Leonora', 'Luckcock', '616 North Drive', '1980-08-21', 'Financial Advisor', 100000090, 'r', '3550945397959788');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (93, 'wpiggott19', 'pw', 'Worden', 'Piggott', '8 Northport Lane', '1980-06-08', 'VP Sales', 100000092, 'r', '3576074944611436');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (95, 'jsherbourne1a', 'pw', 'Jemie', 'Sherbourne', '4999 Kennedy Circle', '1962-05-26', 'VP Quality Control', 100000094, 'r', '5602252922049323');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (97, 'csprowles1b', 'pw', 'Carolynn', 'Sprowles', '15268 Hazelcrest Place', '1984-11-08', 'Office Assistant III', 100000096, 'r', '5602247417146774');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (99, 'bgilbertson1c', 'pw', 'Bunny', 'Gilbertson', '43 Springs Parkway', '1960-04-21', 'Occupational Therapist', 100000098, 'r', '5508247624463603');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (101, 'lville1d', 'pw', 'Lynnett', 'Ville', '97 Nevada Point', '1961-09-22', 'Data Coordinator', 100000100, 'r', '5602227954391298');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (103, 'danderton1e', 'pw', 'Demetris', 'Anderton', '62954 Golf Course Court', '1964-12-03', 'VP Sales', 100000102, 'r', '4041377443395');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (105, 'ehatcliffe1f', 'pw', 'Errol', 'Hatcliffe', '49 Beilfuss Drive', '2001-09-21', 'Teacher', 100000104, 'r', '5602217985920349957');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (107, 'mlandsbury1g', 'pw', 'Manolo', 'Landsbury', '495 Reindahl Circle', '1988-10-30', 'Business Systems Development Analyst', 100000106, 'r', '337941268743191');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (109, 'awoollhead1h', 'pw', 'Alysia', 'Woollhead', '55034 Towne Circle', '1966-03-27', 'Staff Scientist', 100000108, 'r', '560222856642283253');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (111, 'bocrowley1i', 'pw', 'Bridget', 'O''Crowley', '91698 Dennis Road', '1969-02-12', 'Administrative Assistant I', 100000110, 'r', '3582364459911418');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (113, 'ctripony1j', 'pw', 'Chaunce', 'Tripony', '80236 Corscot Terrace', '1995-01-12', 'Senior Quality Engineer', 100000112, 'r', '633319928142800701');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (115, 'dshipsey1k', 'pw', 'Doris', 'Shipsey', '08957 Prairie Rose Pass', '1969-06-18', 'Administrative Officer', 100000114, 'r', '3579956567263742');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (117, 'ldewar1l', 'pw', 'Lindsay', 'Dewar', '035 Ridgeway Trail', '1967-06-26', 'Dental Hygienist', 100000116, 'r', '0604368751272287312');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (119, 'myitzhak1m', 'pw', 'Marshal', 'Yitzhak', '153 Stang Way', '1969-05-12', 'Analyst Programmer', 100000118, 'r', '337941393010664');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (121, 'dkaine1n', 'pw', 'Darb', 'Kaine', '250 Bonner Trail', '1987-11-08', 'Media Manager II', 100000120, 'r', '6706676814078132894');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (123, 'pziemke1o', 'pw', 'Peri', 'Ziemke', '3301 Calypso Crossing', '1977-05-05', 'Sales Associate', 100000122, 'r', '670619084215118909');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (125, 'mhoopper1p', 'pw', 'Myrle', 'Hoopper', '1260 Tennessee Plaza', '2002-01-25', 'Occupational Therapist', 100000124, 'r', '5331433517651065');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (127, 'mpirrone1q', 'pw', 'Maren', 'Pirrone', '8580 Hazelcrest Plaza', '1964-09-07', 'Quality Control Specialist', 100000126, 'r', '3549551221998507');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (129, 'bsimonnot1r', 'pw', 'Brittani', 'Simonnot', '0110 Amoth Court', '1968-11-19', 'Media Manager II', 100000128, 'r', '30488716583506');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (131, 'dkebell1s', 'pw', 'Dannye', 'Kebell', '7428 Reinke Junction', '1992-04-24', 'Software Consultant', 100000130, 'r', '3539883987768333');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (133, 'dgodart1t', 'pw', 'Duky', 'Godart', '427 Dakota Place', '1955-10-06', 'Health Coach III', 100000132, 'r', '3560512799078571');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (135, 'gtollmache1u', 'pw', 'Gale', 'Tollmache', '2 Donald Parkway', '1992-09-08', 'Quality Engineer', 100000134, 'r', '376109311649144');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (137, 'rlomax1v', 'pw', 'Ruttger', 'Lomax', '8429 Logan Street', '1975-04-23', 'Senior Cost Accountant', 100000136, 'r', '4513307089636683');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (139, 'gdalinder1w', 'pw', 'Gilbert', 'Dalinder', '9279 Mockingbird Court', '1969-08-07', 'Sales Representative', 100000138, 'r', '3587385942562844');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (141, 'ocraske1x', 'pw', 'Opalina', 'Craske', '99269 Lien Crossing', '1991-12-23', 'Design Engineer', 100000140, 'r', '5602235447241129244');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (143, 'rmacallen1y', 'pw', 'Rakel', 'MacAllen', '313 Marcy Junction', '1960-03-19', 'Geological Engineer', 100000142, 'r', '5602257305277190824');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (145, 'edroghan1z', 'pw', 'Emilio', 'Droghan', '098 Prentice Hill', '1993-02-18', 'Structural Engineer', 100000144, 'r', '3538272268021953');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (147, 'scopp20', 'pw', 'Shawna', 'Copp', '8014 American Ash Alley', '1998-05-05', 'Systems Administrator III', 100000146, 'r', '5405210139343631');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (149, 'kkennford21', 'pw', 'Kim', 'Kennford', '9 Jenifer Way', '1975-10-03', 'Nurse', 100000148, 'r', '0604562110031923051');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (151, 'jspriggen22', 'pw', 'Janel', 'Spriggen', '20254 Ruskin Center', '1993-07-16', 'Payment Adjustment Coordinator', 100000150, 'r', '3555728222005992');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (153, 'alyddon23', 'pw', 'Anica', 'Lyddon', '0839 West Hill', '1992-08-27', 'Database Administrator IV', 100000152, 'r', '3582032410914231');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (155, 'jteenan24', 'pw', 'Joelynn', 'Teenan', '5128 Clarendon Alley', '1973-07-01', 'Recruiter', 100000154, 'r', '3589433591385147');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (157, 'aremon25', 'pw', 'Angelia', 'Remon', '55010 Basil Crossing', '1964-03-31', 'Tax Accountant', 100000156, 'r', '5133955553965769');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (159, 'bdanshin26', 'pw', 'Betteanne', 'Danshin', '23 Fallview Alley', '1994-07-07', 'Administrative Officer', 100000158, 'r', '3580602747195779');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (161, 'jsabie27', 'pw', 'Jerad', 'Sabie', '259 Bultman Center', '2000-07-27', 'Information Systems Manager', 100000160, 'r', '3538987276275461');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (163, 'ecazin28', 'pw', 'Emily', 'Cazin', '956 Vahlen Street', '1961-07-25', 'Assistant Manager', 100000162, 'r', '6759102536400245150');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (165, 'aconkling29', 'pw', 'Amble', 'Conkling', '48 Vernon Street', '1971-03-04', 'Analyst Programmer', 100000164, 'r', '3542332499747430');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (167, 'mjudson2a', 'pw', 'Mala', 'Judson', '8007 Kensington Place', '1965-09-15', 'Mechanical Systems Engineer', 100000166, 'r', '3537656022777564');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (169, 'egreber2b', 'pw', 'Elvira', 'Greber', '46597 Scoville Junction', '1963-11-16', 'Human Resources Manager', 100000168, 'r', '5198315900346704');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (171, 'rdumbare2c', 'pw', 'Ringo', 'Dumbare', '78946 Sherman Trail', '1982-02-13', 'Statistician III', 100000170, 'r', '3563954290974980');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (173, 'bdelhanty2d', 'pw', 'Binky', 'Delhanty', '68 Butterfield Circle', '1956-02-04', 'Mechanical Systems Engineer', 100000172, 'r', '4026473264561656');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (175, 'jstorms2e', 'pw', 'Jorry', 'Storms', '8913 Nevada Plaza', '1964-10-12', 'Senior Quality Engineer', 100000174, 'r', '30286806210612');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (177, 'ameakes2f', 'pw', 'Aliza', 'Meakes', '21595 Superior Trail', '1959-03-14', 'Office Assistant III', 100000176, 'r', '5602210906572348');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (179, 'rsharma2g', 'pw', 'Reinwald', 'Sharma', '01 Morningstar Crossing', '1975-10-26', 'Product Engineer', 100000178, 'r', '337941945845567');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (181, 'eolivet2h', 'pw', 'Enrico', 'Olivet', '91 Dottie Crossing', '1963-06-19', 'Environmental Tech', 100000180, 'r', '3553353849589021');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (183, 'lgunny2i', 'pw', 'Lavina', 'Gunny', '81 Namekagon Point', '1966-05-01', 'Data Coordinator', 100000182, 'r', '3550020526831314');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (185, 'zstorton2j', 'pw', 'Zaneta', 'Storton', '4884 Mosinee Lane', '2002-01-31', 'Staff Accountant III', 100000184, 'r', '4917813259168185');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (187, 'zhagyard2k', 'pw', 'Zacharia', 'Hagyard', '39 Myrtle Plaza', '1957-09-02', 'Project Manager', 100000186, 'r', '5445966618471852');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (189, 'rjelley2l', 'pw', 'Ree', 'Jelley', '025 Weeping Birch Circle', '1971-07-27', 'Programmer II', 100000188, 'r', '5610583092395363');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (191, 'gesslemont2m', 'pw', 'Graham', 'Esslemont', '5 Ridgeway Way', '1958-12-16', 'Automation Specialist III', 100000190, 'r', '6767508092022518');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (193, 'sstodart2n', 'pw', 'Sergeant', 'Stodart', '86491 Pearson Trail', '1969-10-29', 'Geological Engineer', 100000192, 'r', '30171864777183');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (195, 'esheehy2o', 'pw', 'Earle', 'Sheehy', '63648 Southridge Street', '1992-03-03', 'Computer Systems Analyst III', 100000194, 'r', '3561407312068630');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (197, 'nbownd2p', 'pw', 'Nessi', 'Bownd', '01038 Parkside Court', '1974-09-22', 'Assistant Manager', 100000196, 'r', '4913816845301321');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (199, 'jschenkel2q', 'pw', 'Jourdan', 'Schenkel', '8618 Welch Junction', '1995-06-04', 'Web Designer III', 100000198, 'r', '201887997033862');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (201, 'sverrall2r', 'pw', 'Sibylla', 'Verrall', '32 Banding Terrace', '1960-12-24', 'Help Desk Technician', 100000200, 'r', '5515044121874734');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (203, 'cdurdle2s', 'pw', 'Cristiano', 'Durdle', '60058 Knutson Pass', '2000-03-05', 'Assistant Media Planner', 100000202, 'r', '6304044825548593035');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (205, 'aelsegood2t', 'pw', 'Audrie', 'Elsegood', '480 Sullivan Parkway', '1992-07-04', 'Social Worker', 100000204, 'r', '3574806453650509');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (207, 'mhalle2u', 'pw', 'Mariya', 'Halle', '06 Prairieview Center', '1973-12-22', 'Associate Professor', 100000206, 'r', '3531329847687915');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (209, 'hbernini2v', 'pw', 'Heath', 'Bernini', '4 Prairie Rose Pass', '1963-08-27', 'Information Systems Manager', 100000208, 'r', '0604917715273776512');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (211, 'jcawthra2w', 'pw', 'Judy', 'Cawthra', '715 Eastwood Avenue', '1991-05-26', 'Chemical Engineer', 100000210, 'r', '3586211852925030');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (213, 'cbrame2x', 'pw', 'Carri', 'Brame', '75 Anderson Crossing', '1990-01-12', 'Software Consultant', 100000212, 'r', '201838336285259');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (215, 'tshilvock2y', 'pw', 'Toddie', 'Shilvock', '86 Onsgard Pass', '1973-09-10', 'Automation Specialist I', 100000214, 'r', '3550640097104310');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (217, 'gjacquet2z', 'pw', 'Gan', 'Jacquet', '32 Duke Pass', '1996-05-18', 'Help Desk Technician', 100000216, 'r', '6333115276127868');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (219, 'vpulfer30', 'pw', 'Vyky', 'Pulfer', '5 Brickson Park Drive', '2001-08-04', 'Research Assistant III', 100000218, 'r', '3536119232171244');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (221, 'hhunday31', 'pw', 'Hailey', 'Hunday', '3307 Delladonna Circle', '1964-12-15', 'Engineer II', 100000220, 'r', '633110290127196816');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (223, 'nduchart32', 'pw', 'Nona', 'Duchart', '05 Blue Bill Park Junction', '1971-04-27', 'Analyst Programmer', 100000222, 'r', '6771398203436664');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (225, 'emelvin33', 'pw', 'Eugine', 'Melvin', '72184 Gale Court', '1981-07-28', 'Database Administrator IV', 100000224, 'r', '3556400656488727');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (227, 'ayankov34', 'pw', 'Avis', 'Yankov', '88 Oak Valley Place', '1955-10-20', 'Legal Assistant', 100000226, 'r', '5435643359041911');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (229, 'fpenman35', 'pw', 'Farris', 'Penman', '704 Morning Terrace', '1958-08-24', 'Tax Accountant', 100000228, 'r', '5100147911570494');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (231, 'bmaleck36', 'pw', 'Ben', 'Maleck', '695 Meadow Ridge Hill', '1998-03-03', 'Editor', 100000230, 'r', '3559605764180480');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (233, 'jricardon37', 'pw', 'Jelene', 'Ricardon', '249 Surrey Parkway', '1978-08-17', 'Accountant III', 100000232, 'r', '6771038900928000519');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (235, 'blyall38', 'pw', 'Britt', 'Lyall', '992 Sachtjen Center', '1997-08-07', 'Senior Editor', 100000234, 'r', '5519046803763982');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (237, 'lwright39', 'pw', 'Linoel', 'Wright', '763 East Road', '2001-07-17', 'Web Developer IV', 100000236, 'r', '6385001116082348');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (239, 'ssellars3a', 'pw', 'Shanon', 'Sellars', '1 Hoard Plaza', '1972-03-25', 'Product Engineer', 100000238, 'r', '5610815964946810');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (241, 'bakenhead3b', 'pw', 'Bryn', 'Akenhead', '934 Melody Avenue', '1983-09-29', 'Geological Engineer', 100000240, 'r', '490395303826900627');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (243, 'uvassar3c', 'pw', 'Ulises', 'Vassar', '5416 Saint Paul Pass', '1992-08-17', 'Accounting Assistant III', 100000242, 'r', '3576930562804571');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (245, 'jniblock3d', 'pw', 'Jessee', 'Niblock', '38 Fieldstone Avenue', '1978-01-30', 'VP Quality Control', 100000244, 'r', '67098817179612923');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (247, 'yemps3e', 'pw', 'Yoshi', 'Emps', '6104 Commercial Center', '1965-02-09', 'VP Quality Control', 100000246, 'r', '3570827027956895');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (249, 'ijoseff3f', 'pw', 'Isidro', 'Joseff', '089 Union Alley', '1989-12-17', 'VP Accounting', 100000248, 'r', '3558205029631673');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (251, 'hkoenen3g', 'pw', 'Herbie', 'Koenen', '43277 Lawn Alley', '1997-03-04', 'Web Designer I', 100000250, 'r', '3540392568776795');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (253, 'mcorps3h', 'pw', 'Margaret', 'Corps', '75 Petterle Way', '1994-12-31', 'Software Consultant', 100000252, 'r', '3543019822507768');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (255, 'rbanishevitz3i', 'pw', 'Ravi', 'Banishevitz', '6178 Jay Junction', '1973-10-07', 'Product Engineer', 100000254, 'r', '560222433492198815');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (257, 'lraddish3j', 'pw', 'Levey', 'Raddish', '43 Reinke Plaza', '1982-07-19', 'Accounting Assistant II', 100000256, 'r', '3543727930765777');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (259, 'atayt3k', 'pw', 'Andrea', 'Tayt', '6 Westport Alley', '1991-03-25', 'Executive Secretary', 100000258, 'r', '3544337465964370');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (261, 'mhayball3l', 'pw', 'Minetta', 'Hayball', '9473 Merrick Court', '1995-03-22', 'Electrical Engineer', 100000260, 'r', '3546181225039018');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (263, 'mologan3m', 'pw', 'Marietta', 'O''Logan', '3 Eggendart Junction', '1993-06-10', 'Desktop Support Technician', 100000262, 'r', '3535858535981020');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (265, 'asybbe3n', 'pw', 'Albina', 'Sybbe', '6639 3rd Terrace', '1960-01-20', 'Director of Sales', 100000264, 'r', '3541506690011073');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (267, 'mcuschieri3o', 'pw', 'Margery', 'Cuschieri', '0 Shopko Lane', '1960-08-12', 'Structural Analysis Engineer', 100000266, 'r', '5108758538349385');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (269, 'cpires3p', 'pw', 'Christoph', 'Pires', '393 Manley Hill', '1995-11-15', 'Programmer Analyst IV', 100000268, 'r', '5553830819704610');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (271, 'wcampaigne3q', 'pw', 'Wyndham', 'Campaigne', '83016 Dexter Crossing', '1962-06-16', 'Cost Accountant', 100000270, 'r', '6379833427375617');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (273, 'kelverstone3r', 'pw', 'Kerr', 'Elverstone', '426 Donald Pass', '1974-09-13', 'Community Outreach Specialist', 100000272, 'r', '3567874265115169');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (275, 'etooke3s', 'pw', 'Emmalyn', 'Tooke', '24 Maywood Place', '1970-11-18', 'Information Systems Manager', 100000274, 'r', '3586361562601833');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (277, 'dbibb3t', 'pw', 'Dayle', 'Bibb', '79 South Park', '1996-02-05', 'Design Engineer', 100000276, 'r', '3564295732114465');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (279, 'krosettini3u', 'pw', 'Kerwin', 'Rosettini', '4610 Russell Court', '1972-09-20', 'Budget/Accounting Analyst I', 100000278, 'r', '4903441110752165');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (281, 'ddammarell3v', 'pw', 'Danette', 'Dammarell', '070 Michigan Terrace', '1975-10-25', 'Compensation Analyst', 100000280, 'r', '5010122091671569');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (283, 'acompford3w', 'pw', 'Aron', 'Compford', '1054 Esker Trail', '1970-01-13', 'Senior Financial Analyst', 100000282, 'r', '3571300894585634');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (285, 'klambshine3x', 'pw', 'Kareem', 'Lambshine', '3694 Karstens Point', '1983-03-28', 'Occupational Therapist', 100000284, 'r', '4844931167288537');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (287, 'dghirardi3y', 'pw', 'Darya', 'Ghirardi', '45087 2nd Circle', '1960-05-25', 'Financial Advisor', 100000286, 'r', '30044381787854');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (289, 'ealldis3z', 'pw', 'Edy', 'Alldis', '227 Annamark Drive', '1962-10-07', 'Information Systems Manager', 100000288, 'r', '560221360246115970');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (291, 'khuyghe40', 'pw', 'Kelila', 'Huyghe', '7 Katie Drive', '1979-03-09', 'Computer Systems Analyst IV', 100000290, 'r', '4017953224818172');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (293, 'kpontain41', 'pw', 'Kaleb', 'Pontain', '0 Vahlen Trail', '1990-04-11', 'Junior Executive', 100000292, 'r', '3561119926320899');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (295, 'ebraidford42', 'pw', 'Esdras', 'Braidford', '30 Moose Crossing', '1968-01-15', 'Software Engineer I', 100000294, 'r', '337941688330819');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (297, 'dsawdon43', 'pw', 'Dane', 'Sawdon', '274 Little Fleur Park', '1997-03-29', 'Analyst Programmer', 100000296, 'r', '3544780503337937');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (299, 'kcostell44', 'pw', 'Kay', 'Costell', '22 Acker Drive', '1987-11-16', 'Human Resources Manager', 100000298, 'r', '5602236529534506');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (301, 'jmadison45', 'pw', 'Jillian', 'Madison', '8 Esch Court', '1993-05-04', 'Civil Engineer', 100000300, 'r', '3588246722355941');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (303, 'pdriffill46', 'pw', 'Priscella', 'Driffill', '8845 Golf View Lane', '1969-11-04', 'Developer I', 100000302, 'r', '3536538014650606');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (305, 'afarebrother47', 'pw', 'Amberly', 'Farebrother', '50465 Fordem Crossing', '1971-12-15', 'Payment Adjustment Coordinator', 100000304, 'r', '30501408594811');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (307, 'dcarme48', 'pw', 'Dickie', 'Carme', '64 Crest Line Avenue', '2002-02-10', 'Budget/Accounting Analyst II', 100000306, 'r', '3564712673573814');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (309, 'wcockle49', 'pw', 'Winthrop', 'Cockle', '663 Saint Paul Hill', '1998-10-13', 'Occupational Therapist', 100000308, 'r', '3578567538217823');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (311, 'kmcdougle4a', 'pw', 'Kat', 'McDougle', '50 Trailsway Drive', '2001-03-10', 'Geological Engineer', 100000310, 'r', '4508382633842621');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (313, 'vdohmann4b', 'pw', 'Vinny', 'Dohmann', '5421 Superior Hill', '1958-03-23', 'Operator', 100000312, 'r', '5100173827471577');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (315, 'apetyanin4c', 'pw', 'Andie', 'Petyanin', '82822 Moose Court', '1975-03-22', 'General Manager', 100000314, 'r', '337941455621416');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (317, 'nnekrews4d', 'pw', 'Neile', 'Nekrews', '74175 Kipling Park', '1961-12-22', 'Software Test Engineer IV', 100000316, 'r', '491161900630886684');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (319, 'tmaccafferky4e', 'pw', 'Tillie', 'MacCafferky', '35 Del Mar Park', '1981-01-12', 'VP Sales', 100000318, 'r', '06040601236779801');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (321, 'totter4f', 'pw', 'Tessie', 'Otter', '6140 Annamark Place', '1963-01-13', 'Senior Quality Engineer', 100000320, 'r', '5002356574477397');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (323, 'mianilli4g', 'pw', 'Matthus', 'Ianilli', '08259 Raven Pass', '1993-10-29', 'Data Coordinator', 100000322, 'r', '3587764735441210');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (325, 'estrettell4h', 'pw', 'Elyssa', 'Strettell', '62 Golden Leaf Pass', '1961-11-25', 'Physical Therapy Assistant', 100000324, 'r', '3577390256058969');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (327, 'gsarton4i', 'pw', 'Guinna', 'Sarton', '59083 Green Ridge Terrace', '1985-06-15', 'Internal Auditor', 100000326, 'r', '201825458411094');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (329, 'kiscowitz4j', 'pw', 'Kare', 'Iscowitz', '4657 Washington Avenue', '1993-01-04', 'Chief Design Engineer', 100000328, 'r', '3548481356420146');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (331, 'msapir4k', 'pw', 'Merrielle', 'Sapir', '44 Charing Cross Place', '1993-08-13', 'Help Desk Technician', 100000330, 'r', '6763464669560932');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (333, 'tdoneld4l', 'pw', 'Truman', 'Doneld', '63808 Talisman Street', '2002-04-22', 'Senior Cost Accountant', 100000332, 'r', '56022265429839736');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (335, 'bgreder4m', 'pw', 'Brock', 'Greder', '22989 Mcguire Circle', '1987-05-29', 'Nurse', 100000334, 'r', '633371173940995842');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (337, 'rgowers4n', 'pw', 'Ryann', 'Gowers', '42325 Dennis Center', '1955-11-07', 'Data Coordinator', 100000336, 'r', '3554739680736938');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (339, 'sscougal4o', 'pw', 'Sebastien', 'Scougal', '77993 Emmet Crossing', '1968-06-11', 'Account Coordinator', 100000338, 'r', '3542193381243429');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (341, 'btemple4p', 'pw', 'Bibbye', 'Temple', '61016 Portage Center', '1986-06-21', 'Web Designer IV', 100000340, 'r', '201487288210459');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (343, 'clambrick4q', 'pw', 'Coriss', 'Lambrick', '0 Valley Edge Crossing', '1995-11-27', 'VP Marketing', 100000342, 'r', '3540175089627039');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (345, 'tyosifov4r', 'pw', 'Tabbi', 'Yosifov', '77 Gulseth Plaza', '1978-11-13', 'Librarian', 100000344, 'r', '67061774674296665');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (347, 'apellett4s', 'pw', 'Arden', 'Pellett', '66 Hermina Place', '1977-10-12', 'Cost Accountant', 100000346, 'r', '3533490591672624');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (349, 'nfeatherstone4t', 'pw', 'Nathalia', 'Featherstone', '58412 Alpine Terrace', '1981-03-13', 'Programmer IV', 100000348, 'r', '675976268891482426');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (351, 'tberthot4u', 'pw', 'Tobe', 'Berthot', '2383 Ramsey Plaza', '1985-03-29', 'Automation Specialist I', 100000350, 'r', '5275112398290841');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (353, 'fpinchen4v', 'pw', 'Fina', 'Pinchen', '88906 Bobwhite Plaza', '1992-12-27', 'Recruiter', 100000352, 'r', '30488009183998');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (355, 'ajilkes4w', 'pw', 'Amabelle', 'Jilkes', '181 Menomonie Terrace', '1974-01-08', 'Senior Editor', 100000354, 'r', '3543557787513420');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (357, 'mdowley4x', 'pw', 'Marnia', 'Dowley', '4870 Hoepker Crossing', '1963-02-06', 'Nurse Practicioner', 100000356, 'r', '3550098987102920');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (359, 'ksangar4y', 'pw', 'Karla', 'Sangar', '544 Tony Point', '1973-12-14', 'Structural Analysis Engineer', 100000358, 'r', '56022107817883209');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (361, 'kwintle4z', 'pw', 'Karilynn', 'Wintle', '80897 Delladonna Trail', '1967-10-21', 'Programmer Analyst IV', 100000360, 'r', '3577836123463105');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (363, 'hstores50', 'pw', 'Hasheem', 'Stores', '404 Manitowish Court', '1959-09-28', 'Quality Control Specialist', 100000362, 'r', '633332597301216463');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (365, 'kbrandts51', 'pw', 'Kira', 'Brandts', '18084 Golf Drive', '1987-12-06', 'Assistant Professor', 100000364, 'r', '5007661627195184');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (367, 'cponder52', 'pw', 'Carly', 'Ponder', '42978 Vera Parkway', '1963-03-19', 'Geologist III', 100000366, 'r', '201709994500422');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (369, 'iphilpotts53', 'pw', 'Isadore', 'Philpotts', '39773 Linden Crossing', '1998-06-08', 'Engineer IV', 100000368, 'r', '374914446166480');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (371, 'aolechnowicz54', 'pw', 'Annabal', 'Olechnowicz', '0953 Arizona Way', '1958-02-18', 'Environmental Specialist', 100000370, 'r', '30509356012454');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (373, 'lschanke55', 'pw', 'Lurline', 'Schanke', '52 Carpenter Terrace', '1977-10-01', 'Paralegal', 100000372, 'r', '6331102650335178');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (375, 'astooders56', 'pw', 'Arabela', 'Stooders', '8 Linden Center', '1969-05-26', 'Health Coach I', 100000374, 'r', '4041597920843164');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (377, 'deakin57', 'pw', 'Dudley', 'Eakin', '396 Garrison Way', '1981-07-23', 'Clinical Specialist', 100000376, 'r', '3578036841822802');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (379, 'krouff58', 'pw', 'Kaleena', 'Rouff', '7627 Miller Point', '1967-11-24', 'Software Engineer III', 100000378, 'r', '676373995873849407');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (381, 'aarckoll59', 'pw', 'Abbye', 'Arckoll', '50 Lunder Circle', '1989-10-28', 'Database Administrator I', 100000380, 'r', '5641826650008441453');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (383, 'kjohananov5a', 'pw', 'Kerry', 'Johananov', '99716 Prairie Rose Street', '1996-12-18', 'Compensation Analyst', 100000382, 'r', '376950455785636');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (385, 'cduckit5b', 'pw', 'Carr', 'Duckit', '37326 Talmadge Road', '2001-03-08', 'Data Coordinator', 100000384, 'r', '3582312291013000');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (387, 'mgrinikhin5c', 'pw', 'Muriel', 'Grinikhin', '65 Twin Pines Parkway', '1991-10-11', 'VP Product Management', 100000386, 'r', '4017951185590046');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (389, 'ogeeves5d', 'pw', 'Oran', 'Geeves', '2 Claremont Way', '1998-02-01', 'Data Coordinator', 100000388, 'r', '5010129648533465');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (391, 'ocosens5e', 'pw', 'Ozzy', 'Cosens', '2365 American Ash Alley', '1971-06-26', 'Web Designer I', 100000390, 'r', '3560616546070201');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (393, 'ejonsson5f', 'pw', 'Eleanor', 'Jonsson', '977 Talisman Way', '1998-11-09', 'Senior Sales Associate', 100000392, 'r', '4913998065778444');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (395, 'iommanney5g', 'pw', 'Ivie', 'Ommanney', '191 Northfield Drive', '2001-07-04', 'Information Systems Manager', 100000394, 'r', '3561817440441279');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (397, 'chail5h', 'pw', 'Correy', 'Hail', '90631 Veith Way', '1958-03-10', 'General Manager', 100000396, 'r', '30495838345243');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (399, 'cschaumann5i', 'pw', 'Cad', 'Schaumann', '56286 Oak Plaza', '1974-09-13', 'Pharmacist', 100000398, 'r', '5602233574296735');
insert into Users (id, username, password, first_name, last_name, address, dob, occupation, SIN, type, payment_info) values (401, 'adakin5j', 'pw', 'Alberik', 'Dakin', '56 Warbler Parkway', '1974-06-05', 'Information Systems Manager', 100000400, 'r', '3551263874554125');
-- Amenities
INSERT INTO Amenities (`name`, `type`) VALUES ('Wifi', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Washer', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Dryer', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Kitchen', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Air conditioning', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Heating', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Dedicated workspace', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('TV', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Hair dryer', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Iron', 'Essential');
INSERT INTO Amenities (`name`, `type`) VALUES ('Pool', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('Hot tub', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('Free parking', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('EV charger', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('Crib', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('Gym', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('BBQ grill', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('Breakfast', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('Indoor fireplace', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('Smoking allowed', 'Features');
INSERT INTO Amenities (`name`, `type`) VALUES ('Beachfront', 'Location');
INSERT INTO Amenities (`name`, `type`) VALUES ('Waterfront', 'Location');
INSERT INTO Amenities (`name`, `type`) VALUES ('Smoke alarm', 'Safety');
INSERT INTO Amenities (`name`, `type`) VALUES ('Carbon monoxide alarm', 'Safety');
-- Listings
insert into Listings (host_id, type, longitude, latitude, address, price, city, postal_code, country) values (2, 'house', 6.5, 6.5, 'markham road', 45, 'Markham', 'L6A 0T4', 'Canada');
insert into Listings (host_id, type, longitude, latitude, address, price, city, postal_code, country) values (2, 'apartment', 44.5, 232.4, 'north york', 65, 'North York', 'L6A 0T4', 'Canada');
insert into Listings (host_id, type, longitude, latitude, address, price, city, postal_code, country) values (4, 'hotel', 77.7, 43.4, 'scarborough gulf club', 100, 'Scarborough', 'L6A 0T4', 'Canada');
insert into Listings (host_id, type, longitude, latitude, address, price, city, postal_code, country) values (4, 'apartment', 66.7, 44.4, 'military trail', 50, 'Scarborough', 'L6A 0T4', 'Canada');
insert into Listings (host_id, type, longitude, latitude, address, price, city, postal_code, country) values (4, 'hotel', 55, 50, 'casabel drive', 125, 'North York', 'L9N 0T6', 'Canada');
insert into Listings (host_id, type, longitude, latitude, address, price, city, postal_code, country) values (2, 'hotel', 100, 100, 'colombo road', 300, 'Colombo', 'L9N B3L', 'Sri Lanka');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (7, 116, 'house', 55.4543246, 57.2840834, '4 Oneill Terrace', 55.95, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (8, 92, 'apartment', 111.6556388, -7.5450262, '5 Manufacturers Junction', 68.62, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (9, 8, 'house', 4.718821, 45.991471, '40 Kingsford Circle', 28.67, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (10, 372, 'apartment', 123.3766669, -8.4963229, '392 2nd Way', 27.26, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (11, 370, 'house', -85.3162066, 35.0010118, '62979 Westport Lane', 47.56, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (12, 170, 'hotel', 22.5927946, 38.6390583, '4 Nancy Avenue', 60.26, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (13, 110, 'apartment', 109.924347, 21.48227, '241 Moulton Hill', 74.62, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (14, 76, 'hotel', 84.8672171, 27.0449005, '87 Crownhardt Place', 14.49, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (15, 130, 'hotel', 25.3912281, 37.4475393, '56856 Brentwood Hill', 25.21, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (16, 244, 'apartment', 109.361864, 32.388854, '2648 Clyde Gallagher Parkway', 26.0, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (17, 240, 'house', 44.5593439, 40.025532, '442 Straubel Crossing', 81.53, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (18, 44, 'hotel', 7.3129299, 11.5184818, '2 Michigan Crossing', 77.47, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (19, 174, 'apartment', 85.9779314, 52.5277159, '687 Annamark Parkway', 84.3, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (20, 168, 'hotel', -111.8628205, 40.7345053, '122 Marquette Court', 7.93, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (21, 178, 'house', 121.8385996, 13.4485234, '2 Erie Pass', 41.21, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (22, 200, 'house', 36.7307641, 34.8422936, '3 Heath Street', 40.47, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (23, 378, 'apartment', -8.5995773, 42.4385891, '453 Magdeline Hill', 37.65, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (24, 182, 'house', 120.8898149, 15.6432256, '2 Florence Plaza', 74.28, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (25, 2, 'apartment', 121.0059518, 14.4693883, '42 Coolidge Center', 57.42, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (26, 344, 'hotel', 119.8815203, -3.4590744, '3104 Swallow Park', 35.8, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (27, 80, 'hotel', 121.1472247, 15.5700166, '66 Bluestem Lane', 75.06, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (28, 398, 'house', 20.7644305, 48.081286, '5 Lotheville Avenue', 49.62, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (29, 254, 'house', -89.362656, 15.113515, '8764 Lunder Circle', 94.94, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (30, 40, 'hotel', 95.775494, 29.849977, '713 Susan Place', 53.32, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (31, 268, 'hotel', 110.5215459, -1.5697615, '60 Forster Hill', 80.61, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (32, 102, 'hotel', -14.935965, 11.3410027, '242 Pawling Lane', 32.14, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (33, 208, 'house', 14.5139265, 35.8659607, '8597 Grasskamp Hill', 27.21, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (34, 164, 'hotel', -72.5293562, 18.5382815, '25 Lakewood Gardens Center', 63.63, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (35, 152, 'hotel', 12.3260336, 58.284686, '45 East Court', 38.64, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (36, 370, 'house', 122.4656415, 9.6026645, '534 Reindahl Hill', 70.94, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (37, 24, 'hotel', 106.8329412, -6.3007596, '5 Petterle Center', 5.75, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (38, 72, 'apartment', -75.282299, 6.724917, '53937 Rutledge Court', 20.53, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (39, 196, 'hotel', 17.8434702, 59.4205168, '4 High Crossing Park', 51.97, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (40, 308, 'house', 115.148803, -8.496803, '09 Pierstorff Park', 44.45, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (41, 236, 'hotel', 103.8923786, 52.53255, '7285 Pond Crossing', 79.33, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (42, 24, 'hotel', 108.5144791, -6.7597964, '250 Norway Maple Street', 60.91, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (43, 380, 'apartment', -127.17428, 54.78036, '31734 Lukken Alley', 87.5, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (44, 356, 'apartment', -84.3436881, 33.723039, '29789 Sachs Court', 48.58, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (45, 308, 'apartment', 25.5831031, 60.6458731, '54686 Southridge Parkway', 21.38, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (46, 304, 'house', 20.1143155, 51.30568, '5 Valley Edge Terrace', 26.15, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (47, 208, 'apartment', 117.130129, 25.732824, '9 Paget Terrace', 71.46, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (48, 136, 'hotel', -8.5359207, 41.0394198, '7258 Sunbrook Plaza', 55.41, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (49, 240, 'apartment', 22.7120308, 37.6883607, '520 Dovetail Circle', 1.12, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (50, 104, 'apartment', 103.035694, 11.5466458, '048 Walton Park', 17.52, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (51, 286, 'house', 3.8626074, 43.6121586, '6 Clove Lane', 65.2, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (52, 88, 'hotel', 44.0177989, 13.5775886, '6 Monterey Place', 46.95, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (53, 274, 'house', 33.8723511, 46.4566661, '485 Kipling Avenue', 52.03, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (54, 282, 'hotel', -49.6879727, -21.0482479, '3 Paget Road', 21.07, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (55, 270, 'hotel', -1.4703339, 43.4968733, '5 Thierer Plaza', 67.06, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (56, 86, 'house', 52.0111855, 55.3605576, '78 Oakridge Trail', 77.22, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (57, 88, 'apartment', 121.0004951, 6.0536421, '35022 Lien Hill', 57.37, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (58, 2, 'hotel', 117.970699, 37.38198, '654 Hansons Crossing', 74.24, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (59, 120, 'house', 31.4697, 49.751033, '205 Crescent Oaks Circle', 85.49, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (60, 330, 'apartment', -9.1570572, 38.6052584, '1 Lillian Junction', 64.61, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (61, 370, 'hotel', 17.4879349, 59.5782797, '64586 Moose Parkway', 1.66, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (62, 282, 'hotel', -73.268611, -14.1325, '3 Gulseth Circle', 79.8, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (63, 330, 'apartment', -97.4996835, 35.4674683, '2 Novick Center', 37.03, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (64, 188, 'apartment', -8.949136, 38.6491541, '9243 David Point', 32.39, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (65, 2, 'house', 108.6351043, -7.4977546, '6531 Moulton Terrace', 17.29, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (66, 90, 'hotel', 21.9055846, 40.4339379, '46 Anniversary Park', 44.16, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (67, 338, 'house', 31.1990697, 58.4981562, '89125 Longview Place', 25.88, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (68, 186, 'hotel', 114.938684, 24.44218, '1836 Linden Drive', 93.68, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (69, 292, 'house', -48.7162067, -25.4328356, '7595 Onsgard Plaza', 74.02, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (70, 180, 'hotel', 118.169798, 30.113962, '0430 Dennis Park', 22.89, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (71, 368, 'apartment', 114.497908, 31.28855, '7345 Pond Junction', 26.97, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (72, 18, 'house', 119.783935, 31.912048, '9 Linden Point', 95.84, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (73, 118, 'house', 16.0850004, 50.0521348, '051 Maple Wood Pass', 29.59, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (74, 80, 'house', 24.9412435, 60.1932037, '836 Becker Trail', 1.84, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (75, 326, 'apartment', -94.5521274, 39.0345609, '43 Lunder Street', 57.14, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (76, 224, 'house', -106.78, 32.31, '7 Tony Street', 83.45, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (77, 134, 'apartment', 22.7948195, 63.1454739, '98699 Brickson Park Parkway', 67.34, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (78, 388, 'hotel', -77.6534904, 0.9452075, '138 Arapahoe Street', 97.1, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (79, 320, 'hotel', -58.0352133, -34.9001596, '3354 Everett Pass', 24.63, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (80, 130, 'apartment', 121.266579, 30.169665, '48 Oriole Way', 80.52, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (81, 206, 'apartment', 111.982232, 21.857958, '58554 Westerfield Parkway', 65.53, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (82, 92, 'hotel', 109.752583, 18.400092, '0922 Mcbride Park', 3.41, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (83, 394, 'hotel', 14.5320278, 35.8914242, '17731 School Avenue', 99.37, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (84, 242, 'apartment', 122.5270677, 11.1946369, '21 Havey Trail', 29.52, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (85, 384, 'house', 114.033247, 28.008237, '89 Anthes Hill', 9.46, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (86, 176, 'house', 107.8346924, 21.1062206, '1 Logan Avenue', 44.93, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (87, 338, 'hotel', 44.99309, 12.87678, '728 Bartelt Pass', 93.75, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (88, 40, 'hotel', -110.7200371, 54.2681766, '01083 Northport Alley', 95.9, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (89, 152, 'house', 14.3013689, 49.9293234, '231 Armistice Lane', 10.24, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (90, 128, 'hotel', 3.7139045, 51.0003903, '882 Erie Hill', 10.17, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (91, 124, 'hotel', 13.553217, 58.175029, '64 Dwight Hill', 19.47, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (92, 304, 'apartment', -46.5282973, -22.5905906, '73 Moland Drive', 56.61, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (93, 386, 'house', 99.5096031, 16.4739491, '7127 Helena Way', 96.29, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (94, 262, 'hotel', 34.34085, 31.37389, '9 Bowman Way', 21.54, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (95, 40, 'house', 121.990929, 12.261245, '34407 Vernon Hill', 35.71, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (96, 204, 'hotel', 81.280527, 40.547653, '2 Hooker Lane', 73.18, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (97, 282, 'apartment', 24.9584208, 60.1946148, '6988 Oak Park', 63.74, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (98, 328, 'house', 113.366904, 22.948016, '586 Hagan Junction', 11.1, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (99, 308, 'house', -56.1494143, -21.4803962, '1 Hermina Alley', 83.99, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (100, 126, 'house', 17.592739, 43.3831419, '5 South Circle', 99.44, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (101, 316, 'house', 34.5830034, 58.5083791, '06585 Fisk Hill', 85.93, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (102, 88, 'house', 111.013556, 21.514163, '5 3rd Hill', 81.55, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (103, 190, 'hotel', -78.0682254, 18.2712491, '79910 Granby Terrace', 69.09, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (104, 74, 'house', 147.3271949, -42.8821377, '1 Mosinee Hill', 19.39, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (105, 358, 'apartment', 1.5948224, 50.7308185, '22859 2nd Drive', 35.73, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (106, 190, 'apartment', -49.5076392, -25.1169056, '03 Marcy Pass', 12.89, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (107, 126, 'house', -84.3857442, 30.4649282, '24701 Steensland Park', 92.25, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (108, 140, 'apartment', 122.615819, 10.829771, '42624 Beilfuss Crossing', 81.56, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (109, 8, 'hotel', 100.5577407, 14.4612646, '218 Eastlawn Way', 22.1, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (110, 122, 'hotel', 72.3382061, 53.6362335, '27 Westport Plaza', 7.21, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (111, 60, 'house', 44.1463438, 54.8583596, '56 Sachtjen Alley', 61.36, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (112, 108, 'apartment', 26.7198789, 56.8999269, '400 Mandrake Road', 69.57, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (113, 320, 'hotel', 16.1653052, 58.5706557, '65476 Amoth Center', 23.21, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (114, 288, 'hotel', -7.2170293, 41.0672146, '81136 Ramsey Trail', 72.24, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (115, 240, 'house', 113.9725126, 22.3908295, '3 Birchwood Crossing', 68.61, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (116, 68, 'house', 42.7491668, 44.0227778, '13510 Debs Avenue', 23.68, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (117, 132, 'house', -74.886835, 5.199505, '8 Pepper Wood Street', 71.78, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (118, 148, 'hotel', 111.144319, 37.518314, '2 High Crossing Circle', 60.95, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (119, 244, 'house', 6.0187806, 51.1806274, '60 Brentwood Parkway', 3.26, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (120, 184, 'hotel', 69.1809574, 41.4636032, '28285 Summit Lane', 51.86, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (121, 266, 'house', -8.942153, 39.7433445, '1604 Springview Plaza', 29.99, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (122, 378, 'apartment', 112.0267712, -7.9062121, '8515 Northland Terrace', 47.44, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (123, 354, 'house', 106.69511, -6.150443, '79643 Kenwood Circle', 98.15, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (124, 348, 'apartment', 104.158705, 30.823499, '35 Forest Run Junction', 28.91, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (125, 342, 'house', 96.0891032, 21.9588282, '5865 Fairview Terrace', 44.48, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (126, 242, 'apartment', 120.9869405, 14.7008738, '1 5th Place', 82.77, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (127, 136, 'hotel', 120.649341, 31.463475, '5 Laurel Place', 1.68, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (128, 354, 'house', 112.432825, 39.331595, '07520 Monterey Avenue', 71.55, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (129, 268, 'hotel', 19.8335496, 45.2671352, '6 Mendota Alley', 90.31, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (130, 284, 'hotel', 109.412626, 19.233277, '2426 Gina Drive', 10.05, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (131, 86, 'hotel', 100.309489, -0.679873, '7 Jay Drive', 87.81, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (132, 136, 'hotel', 35.254768, 31.896059, '6 Rieder Road', 34.18, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (133, 340, 'hotel', 112.999502, 28.1905018, '091 Haas Park', 47.28, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (134, 182, 'hotel', 119.7020606, -2.9755226, '60 Victoria Street', 54.64, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (135, 156, 'house', 117.3437409, 31.7304839, '95115 Karstens Court', 26.05, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (136, 194, 'apartment', 127.48889, 36.10306, '86 Old Gate Point', 97.18, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (137, 306, 'house', 15.3775245, 10.2748807, '915 Milwaukee Hill', 40.63, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (138, 12, 'hotel', 121.42076, 28.65638, '713 Swallow Parkway', 18.93, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (139, 382, 'apartment', 1.5994581, 42.5666535, '504 Kenwood Terrace', 53.56, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (140, 16, 'apartment', 35.9510395, 56.0349544, '161 Swallow Lane', 41.2, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (141, 132, 'hotel', 108.117456, 34.326903, '15020 Tennyson Hill', 80.08, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (142, 378, 'apartment', 18.4033, 49.94912, '5383 Green Ridge Park', 35.49, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (143, 300, 'hotel', 119.382381, 31.717564, '516 Trailsway Place', 95.14, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (144, 72, 'hotel', 127.5098827, 37.8315403, '5 Dakota Street', 70.82, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (145, 280, 'apartment', 17.5331351, 58.8946515, '94773 Moland Hill', 53.6, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (146, 278, 'house', 109.026675, 23.48193, '395 Corscot Pass', 81.64, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (147, 278, 'hotel', -8.5310302, 41.0394733, '78 Hoepker Court', 81.34, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (148, 10, 'house', 130.7788921, 45.730664, '56 Northview Point', 79.17, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (149, 278, 'hotel', 108.5196028, -6.7827104, '2142 Heath Drive', 4.07, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (150, 148, 'apartment', -77.5404459, 18.4691383, '7 Jay Parkway', 23.89, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (151, 274, 'apartment', 100.7323332, 14.2524816, '4 Thackeray Lane', 89.58, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (152, 18, 'hotel', 48.2667279, -13.3970988, '92016 Toban Point', 37.65, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (153, 312, 'house', 19.1490758, 51.718833, '845 Macpherson Drive', 91.65, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (154, 184, 'hotel', 102.664376, 25.038296, '43 Melby Lane', 30.67, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (155, 194, 'hotel', 117.694969, 27.027081, '19 Walton Street', 60.34, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (156, 84, 'house', 108.4691492, -7.4869186, '16309 Graedel Circle', 93.78, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (157, 198, 'hotel', 120.9888316, 14.657758, '48209 Prentice Point', 66.52, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (158, 116, 'house', 114.18077, 22.279379, '24 Iowa Alley', 29.97, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (159, 84, 'house', 3.1244315, 50.6140977, '51926 Main Drive', 29.94, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (160, 290, 'apartment', 18.7082571, 50.4072694, '9307 Pearson Circle', 35.18, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (161, 304, 'hotel', 71.9355029, 34.0078256, '07 Ludington Place', 54.99, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (162, 112, 'apartment', 18.946898, 53.3800563, '2 Pond Parkway', 71.17, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (163, 160, 'house', -149.4260421, -17.6509195, '089 Killdeer Circle', 33.23, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (164, 184, 'hotel', 118.674614, 37.433963, '55 Spenser Crossing', 43.07, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (165, 206, 'hotel', 12.7264154, 57.4715317, '91 Merchant Terrace', 79.3, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (166, 76, 'apartment', 47.3773853, 42.3728288, '277 Ramsey Point', 76.25, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (167, 188, 'apartment', 32.4715312, 26.1218315, '1931 Jay Trail', 4.04, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (168, 108, 'apartment', 27.5126688, 65.2674812, '2658 Pepper Wood Pass', 35.52, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (169, 108, 'hotel', 121.0299006, 14.4932929, '66 Susan Plaza', 98.66, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (170, 310, 'hotel', 25.33483, 57.5225959, '2 Oxford Circle', 35.62, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (171, 82, 'apartment', -1.5401497, 47.2550409, '1031 Fremont Center', 41.36, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (172, 18, 'apartment', 56.3724781, 57.7297471, '4119 Hermina Hill', 13.57, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (173, 254, 'house', 100.3617345, -0.9342008, '012 Roxbury Court', 65.68, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (174, 284, 'hotel', 108.28245, 45.23223, '25 Northwestern Hill', 55.4, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (175, 318, 'apartment', 109.482752, 28.178059, '1 Sycamore Hill', 13.3, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (176, 388, 'house', -49.4600885, -18.9745738, '8557 Goodland Junction', 84.57, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (177, 154, 'hotel', 120.266622, 30.30791, '3321 Crest Line Street', 91.93, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (178, 280, 'apartment', 33.9686556, 68.0986274, '21 Emmet Way', 10.18, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (179, 102, 'hotel', 32.3008149, 60.1163207, '00 Drewry Crossing', 33.17, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (180, 388, 'apartment', 19.6650593, 46.1005467, '15 Cascade Way', 82.99, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (181, 154, 'hotel', -86.2869507, 39.8911731, '9 Lien Hill', 85.18, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (182, 94, 'apartment', 103.8280655, 30.7998721, '55 Fulton Junction', 90.99, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (183, 58, 'apartment', 35.149421, 31.574996, '1159 Waywood Street', 67.33, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (184, 50, 'hotel', 102.267712, 27.88157, '378 Bluestem Center', 94.47, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (185, 152, 'hotel', 45.2217972, 54.147514, '4329 Sachtjen Park', 42.83, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (186, 328, 'house', 124.3754414, 6.7640051, '95960 Shasta Plaza', 54.65, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (187, 248, 'house', 110.643305, 24.633362, '89904 Moulton Trail', 39.34, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (188, 296, 'apartment', 32.3919624, 66.870387, '7 Main Junction', 14.72, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (189, 78, 'apartment', 72.5051389, 32.2298219, '5115 Pearson Parkway', 82.54, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (190, 230, 'apartment', 109.599191, 27.948308, '966 Bartelt Circle', 36.32, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (191, 322, 'house', 113.4895468, 23.3854292, '0063 Brickson Park Crossing', 29.56, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (192, 96, 'house', 123.5770012, -10.1790674, '3 Superior Crossing', 83.26, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (193, 50, 'hotel', 120.6359, -8.4539, '0260 Melrose Place', 96.35, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (194, 260, 'house', 71.6276159, 34.2211097, '88052 Karstens Junction', 67.42, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (195, 10, 'house', -4.031512, 57.961476, '226 Artisan Point', 94.43, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (196, 264, 'apartment', -74.7, -12.4, '13219 Gale Avenue', 97.74, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (197, 148, 'hotel', -46.5648481, -23.6898429, '48573 Graceland Circle', 77.58, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (198, 350, 'house', 6.7625867, 51.3305246, '943 Ludington Plaza', 98.59, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (199, 28, 'apartment', 37.4416961, 55.632969, '240 Quincy Center', 78.77, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (200, 320, 'house', -50.2475804, -20.2810232, '70 Arrowood Trail', 31.14, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (201, 210, 'house', -6.2554371, 53.2767301, '771 Bluestem Avenue', 35.46, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (202, 396, 'house', 68.4065979, 25.8056887, '6 Pepper Wood Terrace', 33.7, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (203, 232, 'apartment', 15.508083, 60.429728, '6 Melody Court', 99.26, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (204, 196, 'hotel', -7.8123805, 41.0953745, '75 Donald Way', 47.3, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (205, 350, 'hotel', 113.625328, 34.746611, '56 Bluejay Way', 41.55, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (206, 320, 'hotel', -80.1791368, 8.5974312, '32829 Erie Place', 13.01, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (207, 344, 'house', 123.6010244, -10.1573402, '77905 Donald Place', 19.08, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (208, 208, 'house', -46.4124616, -24.0088421, '85 Columbus Terrace', 78.04, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (209, 224, 'house', 110.332814, 31.052914, '4 Elka Parkway', 32.64, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (210, 214, 'house', 2.323941, 48.759003, '457 Crowley Point', 24.29, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (211, 394, 'house', -5.5781378, 32.6797904, '11279 Debra Drive', 51.05, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (212, 284, 'hotel', 73.9309807, 45.2068153, '5722 Sycamore Parkway', 93.89, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (213, 136, 'hotel', 94.928484, 36.406404, '5816 Shasta Parkway', 61.13, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (214, 328, 'house', 118.43196, 24.705643, '87 Esker Pass', 12.8, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (215, 368, 'house', 4.3520438, 43.8447278, '652 Gateway Circle', 53.9, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (216, 216, 'house', 116.854021, 29.519664, '0891 Kenwood Street', 89.58, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (217, 34, 'apartment', 122.3066411, 10.7179292, '819 Steensland Road', 87.46, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (218, 354, 'apartment', 115.5233, -8.7183, '5 Graceland Plaza', 55.2, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (219, 96, 'hotel', 5.8978018, 43.4945737, '418 Bayside Avenue', 41.98, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (220, 212, 'apartment', 126.7366293, 35.9676772, '13456 Spaight Crossing', 3.34, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (221, 388, 'hotel', 47.1156092, 36.4051945, '89 Arapahoe Trail', 11.75, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (222, 314, 'house', -92.08, 32.53, '5 Alpine Drive', 99.66, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (223, 138, 'house', 17.5142121, 47.5202786, '86536 Buell Drive', 20.42, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (224, 346, 'hotel', 102.746704, 23.156538, '935 Walton Park', 63.51, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (225, 248, 'house', 86.2093804, 54.2407853, '6073 Talmadge Point', 46.96, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (226, 160, 'house', 14.4161297, 48.6514469, '699 Butternut Circle', 27.49, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (227, 320, 'apartment', 129.7283548, 62.0587526, '60343 Oriole Road', 92.58, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (228, 278, 'house', 105.390592, 27.685255, '6 Sloan Hill', 20.64, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (229, 328, 'apartment', 123.309328, -8.2764084, '62933 Mariners Cove Circle', 2.51, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (230, 58, 'house', 26.8529432, 37.1321706, '6019 Warbler Alley', 36.14, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (231, 292, 'hotel', 120.6784858, 27.9937685, '1 Heffernan Place', 37.59, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (232, 234, 'hotel', 112.989854, 28.112525, '4045 Mesta Plaza', 49.5, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (233, 340, 'house', 17.3189958, 49.2277083, '5228 Sutherland Court', 78.35, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (234, 20, 'house', -73.616667, -14.116667, '5663 Hanson Center', 39.3, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (235, 164, 'house', 48.01667, 15.01667, '7 Dwight Court', 73.34, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (236, 286, 'hotel', 20.2835741, 49.4562624, '261 Bartillon Court', 11.51, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (237, 20, 'apartment', 121.5221244, 31.2367474, '0 Vahlen Center', 53.36, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (238, 16, 'apartment', -8.3542102, 39.4635996, '359 Express Lane', 58.06, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (239, 324, 'apartment', 50.3334447, 40.4746848, '49 Delladonna Plaza', 98.66, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (240, 72, 'hotel', -99.1829833, 23.7322067, '9677 Golf View Avenue', 54.8, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (241, 316, 'apartment', 4.810107, 44.1372925, '97609 2nd Terrace', 39.31, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (242, 210, 'hotel', 112.341117, 27.33699, '97 Forster Drive', 15.96, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (243, 192, 'hotel', 2.6780176, 48.5129473, '0930 East Park', 32.24, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (244, 136, 'hotel', -78.7348674, -6.5588437, '4 Dexter Circle', 1.11, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (245, 258, 'apartment', 48.079379, 29.2964866, '22 Katie Road', 35.03, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (246, 146, 'house', 111.244529, 21.955472, '75 Goodland Circle', 88.59, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (247, 112, 'house', 99.262763, 35.001453, '15 Alpine Crossing', 6.12, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (248, 22, 'hotel', 67.8812063, 55.0449125, '94 Fremont Alley', 22.88, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (249, 200, 'hotel', -57.2000138, -24.085215, '6 Service Way', 76.02, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (250, 156, 'hotel', 19.9262381, 50.133176, '8 Hoffman Drive', 60.34, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (251, 328, 'hotel', 44.2289441, 17.5656036, '5 Sommers Court', 32.64, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (252, 290, 'hotel', 131.0436289, 30.6509359, '62286 Bluestem Court', 9.76, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (253, 262, 'apartment', 120.6569721, 28.0093247, '551 New Castle Point', 39.91, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (254, 242, 'hotel', -58.5613439, -34.6504677, '48471 Sauthoff Street', 94.92, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (255, 74, 'house', 34.82621, 62.8487, '6220 Oriole Place', 61.86, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (256, 68, 'apartment', 138.9099913, 37.6533531, '304 Charing Cross Plaza', 78.46, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (257, 284, 'house', 122.6157793, 13.4734999, '2404 Hoffman Alley', 51.28, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (258, 210, 'hotel', 103.757315, 31.026394, '096 Logan Street', 34.38, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (259, 238, 'house', 21.6426843, 47.5962342, '06001 Jana Terrace', 50.5, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (260, 280, 'apartment', -75.508016, -11.8532073, '76 Donald Circle', 36.03, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (261, 364, 'apartment', 134.041335, 35.0780152, '70 Kensington Place', 98.12, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (262, 264, 'apartment', 101.6716295, 3.2093353, '87 Mosinee Place', 6.56, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (263, 326, 'apartment', -86.8722146, 36.1030036, '8 Sheridan Circle', 89.34, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (264, 300, 'apartment', 14.0921466, 50.287503, '5917 Dixon Way', 35.94, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (265, 248, 'hotel', 24.7371099, -34.007765, '19749 Almo Parkway', 25.34, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (266, 356, 'house', 120.9905117, 14.295795, '88094 Hollow Ridge Trail', 86.12, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (267, 120, 'house', 55.1706992, 37.083896, '43 Forest Run Street', 75.69, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (268, 172, 'house', 46.0897124, -25.1720132, '985 5th Road', 36.59, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (269, 126, 'apartment', 100.8564355, -0.6000092, '62965 Mesta Park', 72.07, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (270, 60, 'hotel', -8.7261408, 41.5237953, '81 Express Lane', 64.39, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (271, 172, 'hotel', 114.021538, 33.387684, '3895 Fairview Hill', 68.38, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (272, 272, 'hotel', -8.5246084, 39.6812698, '35372 Spohn Crossing', 37.18, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (273, 266, 'hotel', 117.3028803, -8.9670697, '665 Memorial Lane', 78.37, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (274, 138, 'apartment', 109.715304, 32.318255, '73784 Northland Alley', 64.89, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (275, 280, 'apartment', -77.0296868, 38.8974442, '499 Atwood Place', 77.62, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (276, 230, 'hotel', 104.1019324, 1.1963019, '45651 Dwight Circle', 5.5, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (277, 206, 'house', 20.0136604, 51.3830331, '4 Vidon Place', 61.76, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (278, 232, 'apartment', 32.4242426, 54.4185233, '5 Heath Drive', 11.84, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (279, 352, 'house', 102.652483, 29.344616, '43 Clove Park', 50.29, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (280, 158, 'house', 110.6129124, -7.6966822, '952 Coleman Alley', 83.73, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (281, 268, 'house', -79.929616, -6.8324793, '27754 Lake View Crossing', 21.73, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (282, 26, 'hotel', 41.45968, 52.63744, '59201 Northview Way', 49.66, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (283, 34, 'hotel', 17.2842162, 62.3946271, '976 Bowman Court', 85.15, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (284, 100, 'house', 116.4559849, 39.9317949, '44614 Morning Street', 23.24, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (285, 388, 'hotel', -64.1959217, -31.4603741, '770 Fremont Alley', 12.44, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (286, 94, 'house', -77.1463593, -10.1239403, '51 Sage Hill', 94.8, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (287, 324, 'hotel', -68.693687, -16.20274, '607 Eastlawn Pass', 54.66, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (288, 116, 'house', 35.065202, 31.869937, '927 Melby Avenue', 35.95, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (289, 224, 'apartment', 37.690366, 55.874056, '8 8th Road', 50.44, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (290, 354, 'hotel', 5.2893597, 47.9318074, '86 Talisman Court', 69.3, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (291, 328, 'house', 126.5151395, 39.8286394, '3386 Brentwood Crossing', 62.78, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (292, 64, 'house', 87.2598304, 53.5484776, '00440 Elgar Junction', 61.04, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (293, 254, 'apartment', 135.8074728, 35.5267333, '4889 Swallow Terrace', 23.17, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (294, 362, 'house', -43.8273373, -22.4720256, '40734 Merry Alley', 51.93, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (295, 324, 'hotel', -8.5893138, 41.4472964, '34 Steensland Lane', 99.89, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (296, 68, 'apartment', 23.8954385, 50.6507001, '96 Drewry Street', 96.83, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (297, 370, 'apartment', 37.5833061, 0.355636, '20 Southridge Avenue', 81.45, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (298, 64, 'house', 108.298731, -6.460817, '87177 Hovde Point', 61.45, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (299, 196, 'house', 24.7069091, 40.9063009, '4652 Washington Junction', 31.93, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (300, 208, 'hotel', -3.95453, 35.23619, '6479 Glendale Place', 15.06, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (301, 64, 'hotel', 113.0126011, 22.9550072, '47486 Sauthoff Parkway', 4.04, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (302, 362, 'apartment', -39.3621196, -3.3072032, '9050 Garrison Trail', 32.8, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (303, 238, 'hotel', 31.9594674, 53.6091856, '1 Harper Avenue', 21.02, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (304, 40, 'apartment', 121.0303692, 14.4332941, '12 Maple Wood Drive', 39.32, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (305, 106, 'apartment', 15.1025075, 32.3196827, '077 Laurel Drive', 22.15, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (306, 258, 'house', 124.6616, -8.3884, '5 Towne Avenue', 65.26, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (307, 124, 'house', 111.6556388, -7.5450262, '239 Pawling Trail', 36.02, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (308, 296, 'house', 14.3592112, 46.0082081, '2409 Northwestern Pass', 66.11, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (309, 302, 'apartment', 20.2147861, 63.8135855, '614 Jay Lane', 35.7, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (310, 166, 'house', 106.6352362, 10.7480929, '48573 Southridge Crossing', 14.95, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (311, 212, 'hotel', 115.104389, 35.88518, '89 Stephen Circle', 66.51, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (312, 286, 'house', 46.0479668, 50.7720302, '3993 Monica Pass', 75.15, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (313, 30, 'hotel', 18.6917922, 12.1862546, '3032 Hansons Street', 35.94, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (314, 248, 'apartment', -99.2577715, 19.3608203, '245 Graedel Avenue', 89.61, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (315, 212, 'apartment', 100.176498, 26.560231, '07 Sachs Drive', 59.87, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (316, 310, 'apartment', 18.1227285, 52.8886634, '03240 Toban Circle', 14.61, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (317, 74, 'apartment', 118.479654, 36.684789, '354 Charing Cross Pass', 43.65, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (318, 112, 'apartment', 30.245977, 59.85299, '7 Florence Plaza', 11.56, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (319, 186, 'house', 22.9223719, 40.6536074, '3 Vera Junction', 43.43, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (320, 282, 'apartment', -73.2230401, -39.8084258, '6 Burning Wood Trail', 3.25, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (321, 320, 'apartment', 12.571637, 55.6790868, '55 South Alley', 29.02, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (322, 152, 'house', 21.053265, 52.1012559, '62 Vahlen Pass', 53.57, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (323, 242, 'apartment', 88.5278663, 56.1263981, '8 Vera Hill', 61.21, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (324, 60, 'hotel', 52.190142, 58.6772898, '5 Twin Pines Place', 62.28, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (325, 366, 'apartment', 111.528999, 1.411517, '088 Clemons Crossing', 13.58, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (326, 58, 'house', 112.4962138, 34.6914551, '8786 Pine View Lane', 43.47, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (327, 280, 'house', 100.3573891, 5.3523231, '68 Crowley Place', 50.26, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (328, 88, 'hotel', -87.8660235, 13.3050684, '6 Montana Road', 78.38, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (329, 154, 'apartment', -0.1550173, 51.4986953, '9950 Saint Paul Junction', 52.59, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (330, 144, 'hotel', 120.5622121, 37.0237497, '80786 Ruskin Hill', 54.71, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (331, 22, 'apartment', 34.950506, 32.235466, '77 Badeau Street', 28.31, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (332, 116, 'apartment', 106.7567589, -6.2649072, '998 Fordem Junction', 33.45, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (333, 98, 'house', -45.5313666, -20.0292302, '649 Hazelcrest Parkway', 82.87, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (334, 48, 'hotel', 20.8378422, 49.9579835, '2 Rigney Drive', 55.25, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (335, 170, 'apartment', 80.3038321, 41.1846097, '08 Mallard Way', 5.34, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (336, 114, 'apartment', 130.3267278, 31.2840967, '77 International Place', 37.24, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (337, 314, 'house', 119.831625, 31.880273, '45916 Eggendart Road', 16.32, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (338, 206, 'house', 57.5265289, -20.3170872, '1 Drewry Circle', 3.25, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (339, 378, 'apartment', 100.1255164, 17.2702191, '808 Morningstar Place', 17.64, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (340, 58, 'apartment', 102.7364962, -3.3552972, '28850 Myrtle Place', 74.45, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (341, 206, 'apartment', -68.1346594, -16.5030766, '32 Delaware Road', 27.44, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (342, 174, 'hotel', 120.4674034, 15.9769657, '55882 Superior Street', 82.51, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (343, 162, 'hotel', 105.6691136, 20.1276773, '53 Little Fleur Crossing', 66.45, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (344, 250, 'apartment', 31.3198491, -17.3013059, '1810 Corben Way', 78.73, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (345, 124, 'hotel', 109.326383, 28.138525, '88882 Loeprich Place', 43.51, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (346, 390, 'house', 2.0928189, 44.2641474, '17882 Golf Lane', 36.09, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (347, 94, 'house', 4.6999899, 51.792865, '2 Golden Leaf Street', 69.34, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (348, 24, 'apartment', 15.2255472, 46.614358, '144 Heath Lane', 92.16, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (349, 398, 'apartment', 117.323725, 34.810487, '8 Arkansas Park', 8.85, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (350, 20, 'house', 100.980225, 18.601533, '5525 Glendale Avenue', 60.86, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (351, 372, 'house', 6.1553498, 9.8097475, '2 Dottie Point', 47.85, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (352, 250, 'apartment', 63.0632053, 57.6680135, '63 Warrior Alley', 58.9, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (353, 122, 'apartment', 174.9939663, -40.9026164, '34 Russell Terrace', 23.34, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (354, 178, 'apartment', 17.6300093, 59.8509005, '86 Dwight Point', 10.58, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (355, 190, 'hotel', 112.896606, 23.156045, '40613 Kedzie Alley', 7.92, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (356, 308, 'house', 91.5523435, 27.3325014, '674 Truax Plaza', 60.44, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (357, 300, 'house', 18.4538421, 44.6254349, '5082 Duke Avenue', 7.21, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (358, 390, 'apartment', 118.5155901, -8.4589273, '407 Pearson Avenue', 67.27, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (359, 190, 'hotel', 106.8502879, -6.3621916, '089 Barnett Avenue', 74.64, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (360, 292, 'apartment', 21.888524, 50.643436, '50 Westport Plaza', 42.33, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (361, 340, 'hotel', 112.305145, 22.183206, '93 Sycamore Plaza', 5.96, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (362, 102, 'hotel', 49.0631743, 33.4955028, '78628 Novick Center', 22.79, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (363, 340, 'house', 110.846846, -6.808273, '73 7th Pass', 26.81, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (364, 306, 'house', 133.5697428, 34.0055653, '01844 Troy Lane', 20.88, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (365, 292, 'apartment', -71.5036905, 18.8782625, '4270 Prentice Point', 12.94, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (366, 242, 'apartment', 39.4372601, 10.5914216, '62911 Atwood Alley', 11.25, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (367, 238, 'house', 104.1698463, 15.8515169, '607 Arizona Alley', 69.99, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (368, 352, 'hotel', -96, 36.15, '264 Aberg Parkway', 23.33, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (369, 320, 'hotel', -43.9551381, -19.8446577, '5 Pond Plaza', 82.68, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (370, 234, 'house', 108.9383377, 11.9913493, '8506 Loftsgordon Center', 65.62, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (371, 28, 'house', 119.3081149, 26.0977366, '7355 Northridge Place', 67.02, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (372, 206, 'apartment', -11.4779299, 7.5048177, '8 Lakeland Hill', 93.84, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (373, 346, 'hotel', 6.1549499, 45.9120061, '7 Sachtjen Plaza', 46.21, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (374, 172, 'house', 131.158416, 46.64635, '759 Union Street', 31.4, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (375, 300, 'hotel', 35.8080537, 58.5931974, '0 North Park', 86.32, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (376, 350, 'house', 39.6526462, -5.3629365, '98233 Crownhardt Place', 73.68, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (377, 124, 'apartment', 113.447431, 28.94074, '4 Hoffman Center', 43.46, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (378, 24, 'house', 16.826031, 52.4368772, '185 Barby Trail', 47.65, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (379, 132, 'apartment', 120.6428123, 15.1248652, '7 Ramsey Lane', 79.04, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (380, 94, 'house', -70.582502, -33.459409, '2 Fallview Circle', 40.18, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (381, 34, 'hotel', 107.0096844, -6.2057339, '8 Marquette Pass', 57.43, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (382, 180, 'hotel', 104.063889, 34.392963, '2238 Clemons Point', 21.93, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (383, 192, 'house', 119.5281714, -3.8506762, '2116 Pine View Alley', 82.86, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (384, 298, 'house', 72.8160976, 40.5139985, '04956 Warbler Lane', 98.27, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (385, 398, 'house', -57.5872528, -25.3823822, '27 Prairie Rose Road', 23.93, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (386, 128, 'apartment', 113.1650014, -6.9216971, '8 Pankratz Court', 62.67, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (387, 164, 'hotel', 123.380874, 12.481536, '2 Cottonwood Center', 74.08, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (388, 70, 'hotel', 16.1378776, 58.6144923, '834 Steensland Alley', 79.19, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (389, 386, 'house', 119.659553, 31.031933, '8 Jay Terrace', 71.46, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (390, 164, 'house', 16.9388118, 8.2659713, '1797 Thierer Place', 40.82, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (391, 120, 'apartment', 16.1084808, 48.7974858, '83 Brickson Park Lane', 11.62, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (392, 92, 'hotel', 114.397004, 38.135288, '3717 Brown Trail', 98.27, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (393, 136, 'house', 48.329762, 54.0282094, '6530 Fulton Place', 59.58, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (394, 2, 'apartment', 22.4510542, 40.946869, '5806 Elmside Lane', 76.0, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (395, 148, 'hotel', 19.3967698, 45.2497275, '0967 Thierer Terrace', 51.03, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (396, 274, 'hotel', -58.5845016, -34.4584447, '27 Monterey Park', 12.38, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (397, 278, 'hotel', 47.0875045, -21.4546147, '9 Merrick Park', 71.1, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (398, 72, 'apartment', 48.26675, 54.42789, '40460 Trailsway Way', 37.91, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (399, 132, 'house', 5.7218985, 45.1934857, '95 Myrtle Circle', 16.98, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (400, 392, 'apartment', 107.04219, 24.546876, '2959 Pawling Trail', 29.5, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (401, 202, 'apartment', 19.4369847, 50.3879871, '350 Florence Trail', 70.71, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (402, 202, 'apartment', -7.6302454, 40.7003439, '8 Hoard Place', 24.16, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (403, 156, 'house', 77.0852258, 42.6503176, '160 Moland Drive', 13.62, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (404, 14, 'apartment', 109.23577, -7.62385, '00423 Chive Junction', 96.68, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (405, 256, 'house', -2.2298164, 34.9344195, '3 Welch Park', 31.7, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (406, 176, 'house', -48.7862736, -22.3463487, '833 Anhalt Terrace', 96.44, 'Kitchener', 'I9I 9I9', 'Canada');
-- Bookings
INSERT INTO Bookings (`listing_id`, `renter_id`, `start_date`, `end_date`, `price_per_night`, `num_nights`, `total_cost`, `status`) VALUES ('1', '3', '2023-08-01', '2023-08-15', '200', '9', '1200', '1');
INSERT INTO Bookings (`listing_id`, `renter_id`, `start_date`, `end_date`, `price_per_night`, `num_nights`, `total_cost`, `status`) VALUES ('1', '3', '2023-08-20', '2023-09-1', '200', '9', '1200', '1');
INSERT INTO Bookings (`listing_id`, `renter_id`, `start_date`, `end_date`, `price_per_night`, `num_nights`, `total_cost`, `status`) VALUES ('1', '3', '2023-09-03', '2023-09-15', '200', '9', '1200', '1');
INSERT INTO Bookings (`listing_id`, `renter_id`, `start_date`, `end_date`, `price_per_night`, `num_nights`, `total_cost`, `status`) VALUES ('1', '3', '2023-09-20', '2023-10-1', '200', '9', '1200', '1');
-- ListingAmenities
INSERT INTO listingamenities (listing_id, amenity_id) values (330, 15);
INSERT INTO listingamenities (listing_id, amenity_id) values (17, 22);
INSERT INTO listingamenities (listing_id, amenity_id) values (75, 8);
INSERT INTO listingamenities (listing_id, amenity_id) values (294, 7);
INSERT INTO listingamenities (listing_id, amenity_id) values (214, 11);
INSERT INTO listingamenities (listing_id, amenity_id) values (83, 11);
INSERT INTO listingamenities (listing_id, amenity_id) values (232, 12);
INSERT INTO listingamenities (listing_id, amenity_id) values (394, 14);
INSERT INTO listingamenities (listing_id, amenity_id) values (25, 19);
INSERT INTO listingamenities (listing_id, amenity_id) values (206, 21);
INSERT INTO listingamenities (listing_id, amenity_id) values (287, 2);
INSERT INTO listingamenities (listing_id, amenity_id) values (138, 9);
INSERT INTO listingamenities (listing_id, amenity_id) values (68, 20);
INSERT INTO listingamenities (listing_id, amenity_id) values (318, 7);
INSERT INTO listingamenities (listing_id, amenity_id) values (105, 8);
INSERT INTO listingamenities (listing_id, amenity_id) values (235, 14);
INSERT INTO listingamenities (listing_id, amenity_id) values (92, 11);
INSERT INTO listingamenities (listing_id, amenity_id) values (263, 8);
INSERT INTO listingamenities (listing_id, amenity_id) values (268, 16);
INSERT INTO listingamenities (listing_id, amenity_id) values (299, 22);
INSERT INTO listingamenities (listing_id, amenity_id) values (179, 24);
INSERT INTO listingamenities (listing_id, amenity_id) values (102, 3);
INSERT INTO listingamenities (listing_id, amenity_id) values (359, 5);
INSERT INTO listingamenities (listing_id, amenity_id) values (396, 17);
INSERT INTO listingamenities (listing_id, amenity_id) values (154, 16);
INSERT INTO listingamenities (listing_id, amenity_id) values (114, 8);
INSERT INTO listingamenities (listing_id, amenity_id) values (114, 1);
INSERT INTO listingamenities (listing_id, amenity_id) values (226, 12);
INSERT INTO listingamenities (listing_id, amenity_id) values (21, 23);
INSERT INTO listingamenities (listing_id, amenity_id) values (271, 13);
INSERT INTO listingamenities (listing_id, amenity_id) values (211, 12);
INSERT INTO listingamenities (listing_id, amenity_id) values (100, 22);
INSERT INTO listingamenities (listing_id, amenity_id) values (2, 8);
INSERT INTO listingamenities (listing_id, amenity_id) values (26, 16);
INSERT INTO listingamenities (listing_id, amenity_id) values (25, 24);
INSERT INTO listingamenities (listing_id, amenity_id) values (6, 7);
INSERT INTO listingamenities (listing_id, amenity_id) values (390, 13);
INSERT INTO listingamenities (listing_id, amenity_id) values (254, 13);
INSERT INTO listingamenities (listing_id, amenity_id) values (337, 12);
INSERT INTO listingamenities (listing_id, amenity_id) values (133, 10);
INSERT INTO listingamenities (listing_id, amenity_id) values (261, 3);
INSERT INTO listingamenities (listing_id, amenity_id) values (98, 23);
INSERT INTO listingamenities (listing_id, amenity_id) values (94, 12);
INSERT INTO listingamenities (listing_id, amenity_id) values (52, 14);
INSERT INTO listingamenities (listing_id, amenity_id) values (106, 6);
INSERT INTO listingamenities (listing_id, amenity_id) values (71, 3);
INSERT INTO listingamenities (listing_id, amenity_id) values (336, 2);
INSERT INTO listingamenities (listing_id, amenity_id) values (195, 22);
INSERT INTO listingamenities (listing_id, amenity_id) values (391, 22);
INSERT INTO listingamenities (listing_id, amenity_id) values (396, 12);
INSERT INTO listingamenities (listing_id, amenity_id) values (210, 19);