-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathssdp.sql
More file actions
2030 lines (2002 loc) · 251 KB
/
ssdp.sql
File metadata and controls
2030 lines (2002 loc) · 251 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- Adminer 4.7.6 PostgreSQL dump
DROP TABLE IF EXISTS "hotels";
DROP SEQUENCE IF EXISTS hotels_id_seq;
CREATE SEQUENCE hotels_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."hotels" (
"id" integer DEFAULT nextval('hotels_id_seq') NOT NULL,
"name" character varying(128) NOT NULL,
"address" character varying(128) NOT NULL,
"zip_code" integer NOT NULL,
"city" character varying(128) NOT NULL,
"room_count" integer DEFAULT '0' NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
"sector_id" integer,
CONSTRAINT "hotels_pkey" PRIMARY KEY ("id"),
CONSTRAINT "hotels_sector_id_fkey" FOREIGN KEY (sector_id) REFERENCES sectors(id) ON UPDATE CASCADE ON DELETE SET NULL NOT DEFERRABLE
) WITH (oids = false);
INSERT INTO "hotels" ("id", "name", "address", "zip_code", "city", "room_count", "created_at", "updated_at", "sector_id") VALUES
(23541506, 'Hôtel du Grand Aboukir', '134 rue d''Aboukir', 75002, 'PARIS', 19, '2020-02-29 08:31:46.066+00', '2020-02-29 08:31:46.066+00', 1),
(108, 'des Arts et Métiers', '4 rue Borda', 75003, 'PARIS', 2, '2020-02-29 08:31:46.066+00', '2020-02-29 08:31:46.066+00', 1),
(148, 'Turbigo', '19 rue du Vertbois', 75003, 'PARIS', 13, '2020-02-29 08:31:46.066+00', '2020-02-29 08:31:46.066+00', 1),
(7180332, 'Chaussée d''Antin', '46 rue de la Chaussée d''Antin', 75009, 'PARIS', 9, '2020-02-29 08:31:46.067+00', '2020-02-29 08:31:46.067+00', 1),
(48342, 'Clauzel', '33 rue des Martyrs', 75009, 'PARIS', 0, '2020-02-29 08:31:46.067+00', '2020-02-29 08:31:46.067+00', 1),
(15659494, 'Riviera', '6 rue Turgot', 75009, 'PARIS', 8, '2020-02-29 08:31:46.067+00', '2020-02-29 08:31:46.067+00', 1),
(16118746, '66 Château d''Eau SOGESTHO', '66 rue du château d''eau', 75010, 'PARIS', 30, '2020-02-29 08:31:46.067+00', '2020-02-29 08:31:46.067+00', 1),
(7380005, 'du Canal Saint Martin', '20 rue louis blanc', 75010, 'PARIS', 16, '2020-02-29 08:31:46.068+00', '2020-02-29 08:31:46.068+00', 1),
(11649833, 'Du Printemps - Paris 10', '81 rue du Faubourg du Temple', 75010, 'PARIS', 12, '2020-02-29 08:31:46.068+00', '2020-02-29 08:31:46.068+00', 1),
(61, 'Excelsior', '25 rue Eugène Varlin', 75010, 'PARIS', 0, '2020-02-29 08:31:46.068+00', '2020-02-29 08:31:46.068+00', 1),
(27382978, 'Excelsior - Varlin', '25 rue Eugène Varlin', 75010, 'PARIS', 40, '2020-02-29 08:31:46.069+00', '2020-02-29 08:31:46.069+00', 1),
(15723170, 'Faubourg 216', '216 rue du faubourg Saint Denis', 75010, 'PARIS', 0, '2020-02-29 08:31:46.069+00', '2020-02-29 08:31:46.069+00', 1),
(15507073, 'Garden Opéra', '65 Rue du Château d''Eau', 75010, 'PARIS', 8, '2020-02-29 08:31:46.069+00', '2020-02-29 08:31:46.069+00', 1),
(7392500, 'Grand Hôtel du Prince Eugene', '12 Rue du Chateau d''eau', 75010, 'PARIS', 0, '2020-02-29 08:31:46.069+00', '2020-02-29 08:31:46.069+00', 1),
(4703221, 'Lafayette', '198 rue Lafayette', 75010, 'PARIS', 0, '2020-02-29 08:31:46.07+00', '2020-02-29 08:31:46.07+00', 1),
(123, 'le Prado', '12 rue du faubourg Saint-Denis', 75010, 'PARIS', 8, '2020-02-29 08:31:46.07+00', '2020-02-29 08:31:46.07+00', 1),
(1254785, 'Magenta - 10', '129 boulevard Magenta', 75010, 'PARIS', 0, '2020-02-29 08:31:46.07+00', '2020-02-29 08:31:46.07+00', 1),
(13254995, 'Marclau', '78 rue du Faubourg Poissonnière', 75010, 'PARIS', 0, '2020-02-29 08:31:46.071+00', '2020-02-29 08:31:46.071+00', 1),
(9240593, 'Métropole Lafayette', '204 rue de La Fayette', 75010, 'PARIS', 24, '2020-02-29 08:31:46.071+00', '2020-02-29 08:31:46.071+00', 1),
(66, 'Paris Magenta', '48 boulevard Magenta', 75010, 'PARIS', 39, '2020-02-29 08:31:46.071+00', '2020-02-29 08:31:46.071+00', 1),
(3142715, 'Résidence Parmentier', '3 rue Arthur Groussier', 75010, 'PARIS', 0, '2020-02-29 08:31:46.072+00', '2020-02-29 08:31:46.072+00', 1),
(149, 'Royal de France', '57 rue des petites écuries', 75010, 'PARIS', 35, '2020-02-29 08:31:46.072+00', '2020-02-29 08:31:46.072+00', 1),
(1247638, 'Royal Hôtel', '198 rue Saint Maur', 75010, 'PARIS', 51, '2020-02-29 08:31:46.072+00', '2020-02-29 08:31:46.072+00', 1),
(6271035, 'Anya', '5 passage Viallet', 75011, 'PARIS', 12, '2020-02-29 08:31:46.072+00', '2020-02-29 08:31:46.072+00', 1),
(5934555, 'Beauséjour 11', '8 rue de l''Orillon', 75011, 'PARIS', 37, '2020-02-29 08:31:46.073+00', '2020-02-29 08:31:46.073+00', 1),
(22694598, 'Cocon Hôtel', '57 rue Saint Sébastien', 75011, 'PARIS', 0, '2020-02-29 08:31:46.073+00', '2020-02-29 08:31:46.073+00', 1),
(159, 'Couronnes Paris', '6-8 impasse Questre', 75011, 'PARIS', 25, '2020-02-29 08:31:46.073+00', '2020-02-29 08:31:46.073+00', 1),
(48387, 'Cyrano-Voltaire', '66 rue Sedaine', 75011, 'PARIS', 17, '2020-02-29 08:31:46.073+00', '2020-02-29 08:31:46.073+00', 1),
(3824053, 'de Franche Comté', '8 rue Moret', 75011, 'PARIS', 39, '2020-02-29 08:31:46.074+00', '2020-02-29 08:31:46.074+00', 1),
(5932172, 'de L''Europe Bonnet', '10 Rue Louis Bonnet', 75011, 'PARIS', 0, '2020-02-29 08:31:46.074+00', '2020-02-29 08:31:46.074+00', 1),
(5933028, 'de l''Europe Sedaine', '74 rue Sedaine', 75011, 'PARIS', 21, '2020-02-29 08:31:46.074+00', '2020-02-29 08:31:46.074+00', 1),
(5930278, 'Du Monde', '15 rue Pasteur', 75011, 'PARIS', 35, '2020-02-29 08:31:46.075+00', '2020-02-29 08:31:46.075+00', 1),
(20089477, 'Florence', '23 rue Neuve des Boulets', 75011, 'PARIS', 32, '2020-02-29 08:31:46.075+00', '2020-02-29 08:31:46.075+00', 1),
(5938942, 'Grand Hôtel du Progrès', '195 rue du Faubourg Saint Antoine', 75011, 'PARIS', 28, '2020-02-29 08:31:46.075+00', '2020-02-29 08:31:46.075+00', 1),
(13957346, 'Grand Hôtel Voltaire', '150 Boulevard Voltaire', 75011, 'PARIS', 3, '2020-02-29 08:31:46.076+00', '2020-02-29 08:31:46.076+00', 1),
(22831574, 'Hôtel Parmentier', '23 rue Saint-Ambroise', 75011, 'PARIS', 48, '2020-02-29 08:31:46.076+00', '2020-02-29 08:31:46.076+00', 1),
(92, 'Le Grillon Lamier', '3 impasse Lamier', 75011, 'PARIS', 11, '2020-02-29 08:31:46.076+00', '2020-02-29 08:31:46.076+00', 1),
(48398, 'le Grillon Sedaine', '60 rue Sedaine', 75011, 'PARIS', 18, '2020-02-29 08:31:46.076+00', '2020-02-29 08:31:46.076+00', 1),
(3029096, 'Métropolitain', '158 rue Oberkampf', 75011, 'PARIS', 15, '2020-02-29 08:31:46.077+00', '2020-02-29 08:31:46.077+00', 1),
(460385, 'Montlouis', '5 rue de Belfort', 75011, 'PARIS', 2, '2020-02-29 08:31:46.077+00', '2020-02-29 08:31:46.077+00', 1),
(12749144, 'Morand', '11 rue Morand', 75011, 'PARIS', 22, '2020-02-29 08:31:46.078+00', '2020-02-29 08:31:46.078+00', 1),
(62815, 'Oberkampf', '152 rue Oberkampf', 75011, 'PARIS', 25, '2020-02-29 08:31:46.078+00', '2020-02-29 08:31:46.078+00', 1),
(161231, 'Résidence Moret', '14 rue Moret', 75011, 'PARIS', 32, '2020-02-29 08:31:46.078+00', '2020-02-29 08:31:46.078+00', 1),
(5930078, 'RESIDSOCIAL Belleville', '7 impasse Questre', 75011, 'PARIS', 20, '2020-02-29 08:31:46.078+00', '2020-02-29 08:31:46.078+00', 1),
(7246925, 'RHETIA', '3 rue du Général Blaise', 75011, 'PARIS', 23, '2020-02-29 08:31:46.079+00', '2020-02-29 08:31:46.079+00', 1),
(104, 'Saint Ambroise', '5 rue de l''Asile Popincourt', 75011, 'PARIS', 15, '2020-02-29 08:31:46.079+00', '2020-02-29 08:31:46.079+00', 1),
(5935010, 'Touraine', '6 rue Louis Bonnet', 75011, 'PARIS', 28, '2020-02-29 08:31:46.08+00', '2020-02-29 08:31:46.08+00', 1),
(98, 'Vix', '19 rue de Charonne', 75011, 'PARIS', 6, '2020-02-29 08:31:46.08+00', '2020-02-29 08:31:46.08+00', 1),
(16661021, 'Belle Aire', '6 rue de la Voûte', 75012, 'PARIS', 0, '2020-02-29 08:31:46.08+00', '2020-02-29 08:31:46.08+00', 1),
(23374761, 'De La Porte de Vincennes', '3 Passage de la Voûte', 75012, 'PARIS', 18, '2020-02-29 08:31:46.081+00', '2020-02-29 08:31:46.081+00', 1),
(47906, 'des Alliés', '90 rue du faubourg Saint-Antoine', 75012, 'PARIS', 28, '2020-02-29 08:31:46.081+00', '2020-02-29 08:31:46.081+00', 1),
(6903988, 'Des Pyrénées - 12', '204 rue du Faubourg Saint Antoine', 75012, 'PARIS', 6, '2020-02-29 08:31:46.081+00', '2020-02-29 08:31:46.081+00', 1),
(7194217, 'Du Centre', '112 rue de Charenton', 75012, 'PARIS', 18, '2020-02-29 08:31:46.082+00', '2020-02-29 08:31:46.082+00', 1),
(9742620, 'L''Aigle ex de la Meuse', '7 rue de reuilly', 75012, 'PARIS', 19, '2020-02-29 08:31:46.082+00', '2020-02-29 08:31:46.082+00', 1),
(6392783, 'Netter', '89 avenue du Docteur Arnold Netter', 75012, 'PARIS', 21, '2020-02-29 08:31:46.082+00', '2020-02-29 08:31:46.082+00', 1),
(640004, 'Paris 12', '93 rue de Charenton', 75012, 'PARIS', 1, '2020-02-29 08:31:46.083+00', '2020-02-29 08:31:46.083+00', 1),
(120, 'Printania 12', '91 avenue du Docteur Arnold Netter', 75012, 'PARIS', 25, '2020-02-29 08:31:46.083+00', '2020-02-29 08:31:46.083+00', 1),
(22528257, 'Renaissance', '7 rue Claude Tillier', 75012, 'PARIS', 10, '2020-02-29 08:31:46.083+00', '2020-02-29 08:31:46.083+00', 1),
(48266, 'RESIDSOCIAL Chaligny', '5 rue de Chaligny', 75012, 'PARIS', 22, '2020-02-29 08:31:46.083+00', '2020-02-29 08:31:46.083+00', 1),
(125, 'Wattignies', '6 rue de Wattignies', 75012, 'PARIS', 15, '2020-02-29 08:31:46.084+00', '2020-02-29 08:31:46.084+00', 1),
(5929927, 'de Choisy', '135 Avenue de Choisy', 75013, 'PARIS', 0, '2020-02-29 08:31:46.084+00', '2020-02-29 08:31:46.084+00', 1),
(5934885, 'Formio', '104 boulevard de l''hôpital', 75013, 'PARIS', 0, '2020-02-29 08:31:46.084+00', '2020-02-29 08:31:46.084+00', 1),
(6099004, 'Le Capitole', '10 rue Fulton', 75013, 'PARIS', 3, '2020-02-29 08:31:46.084+00', '2020-02-29 08:31:46.084+00', 1),
(11921905, 'Le Chiquito', '96 boulevard de l''hôpital', 75013, 'PARIS', 4, '2020-02-29 08:31:46.085+00', '2020-02-29 08:31:46.085+00', 1),
(16180428, 'Lodge In', '1 rue Maryse Bastié', 75013, 'PARIS', 2, '2020-02-29 08:31:46.085+00', '2020-02-29 08:31:46.085+00', 1),
(5928342, 'Maison Blanche', '107 Bis Avenue d''Italie', 75013, 'PARIS', 12, '2020-02-29 08:31:46.085+00', '2020-02-29 08:31:46.085+00', 1),
(13992602, 'Résidence Le Palatino', '20-36 Allée Eric Chabeur - Hall A', 75013, 'PARIS', 108, '2020-02-29 08:31:46.085+00', '2020-02-29 08:31:46.085+00', 1),
(7880796, 'Assirem', '53 rue de Plaisance', 75014, 'PARIS', 6, '2020-02-29 08:31:46.086+00', '2020-02-29 08:31:46.086+00', 1),
(7926193, 'De la Place', '58 rue de la sabliere', 75014, 'PARIS', 0, '2020-02-29 08:31:46.086+00', '2020-02-29 08:31:46.086+00', 1),
(7786549, 'Sport', '68 rue Beaunier', 75014, 'PARIS', 10, '2020-02-29 08:31:46.086+00', '2020-02-29 08:31:46.086+00', 1),
(7229807, 'Studélites Maréchal et Consul', '119-121 Boulevard Brune', 75014, 'PARIS', 7, '2020-02-29 08:31:46.087+00', '2020-02-29 08:31:46.087+00', 1),
(7887791, 'Ribera', '66 rue Jean de la fontaine', 75016, 'PARIS', 12, '2020-02-29 08:31:46.088+00', '2020-02-29 08:31:46.088+00', 1),
(907168, 'Azur Hôtel', '14 rue Lemercier', 75017, 'PARIS', 8, '2020-02-29 08:31:46.091+00', '2020-02-29 08:31:46.091+00', 1),
(9828363, 'de la Paix - 17', '150 Avenue de Clichy', 75017, 'PARIS', 3, '2020-02-29 08:31:46.094+00', '2020-02-29 08:31:46.094+00', 1),
(4928487, 'du Poitou', '12 rue Guy Môquet', 75017, 'PARIS', 10, '2020-02-29 08:31:46.097+00', '2020-02-29 08:31:46.097+00', 1),
(115, 'Le Grillon', '121 Bd Bessières', 75017, 'PARIS', 27, '2020-02-29 08:31:46.099+00', '2020-02-29 08:31:46.099+00', 1),
(8330577, 'Résidence des 2 Squares', '9 rue lacaille', 75017, 'PARIS', 36, '2020-02-29 08:31:46.106+00', '2020-02-29 08:31:46.106+00', 1),
(52913, 'Studio des Batignolles', '36 rue des Batignolles', 75017, 'PARIS', 28, '2020-02-29 08:31:46.108+00', '2020-02-29 08:31:46.108+00', 1),
(7391662, 'Confort', '3 rue Lagille', 75018, 'PARIS', 19, '2020-02-29 08:31:46.11+00', '2020-02-29 08:31:46.11+00', 1),
(48532, 'de la Paix - Paris', '44 rue des Poissonniers', 75018, 'PARIS', 17, '2020-02-29 08:31:46.112+00', '2020-02-29 08:31:46.112+00', 1),
(9697125, 'Du Parc - Paris', '32 rue Cavé', 75018, 'PARIS', 21, '2020-02-29 08:31:46.114+00', '2020-02-29 08:31:46.114+00', 1),
(6555369, 'Hipotel Sacré Coeur', '22 square Clignancourt', 75018, 'PARIS', 25, '2020-02-29 08:31:46.116+00', '2020-02-29 08:31:46.116+00', 1),
(2785717, 'Le Bruant', '2 rue Aristide Bruant', 75018, 'PARIS', 23, '2020-02-29 08:31:46.117+00', '2020-02-29 08:31:46.117+00', 1),
(299, 'Mont Blanc', '3 rue Baudelique', 75018, 'PARIS', 0, '2020-02-29 08:31:46.119+00', '2020-02-29 08:31:46.119+00', 1),
(3252998, 'Paris Letort', '49 rue Letort', 75018, 'PARIS', 22, '2020-02-29 08:31:46.123+00', '2020-02-29 08:31:46.123+00', 1),
(50560, 'Régence', '2 Villa Guelma', 75018, 'PARIS', 27, '2020-02-29 08:31:46.125+00', '2020-02-29 08:31:46.125+00', 1),
(152, 'Rhin et Danube 18ème', '40 bd de Clichy', 75018, 'PARIS', 25, '2020-02-29 08:31:46.126+00', '2020-02-29 08:31:46.126+00', 1),
(4831458, 'Versigny', '31 rue Letort', 75018, 'PARIS', 28, '2020-02-29 08:31:46.128+00', '2020-02-29 08:31:46.128+00', 1),
(6356755, 'AKBOU', '72 rue Curial', 75019, 'PARIS', 0, '2020-02-29 08:31:46.132+00', '2020-02-29 08:31:46.132+00', 1),
(7781899, 'des Amandiers', '11 rue Bouret', 75019, 'PARIS', 12, '2020-02-29 08:31:46.155+00', '2020-02-29 08:31:46.155+00', 1),
(6384873, 'La Fontaine', '9 rue de l''Escaut', 75019, 'PARIS', 16, '2020-02-29 08:31:46.156+00', '2020-02-29 08:31:46.156+00', 1),
(161211, 'Résidence Jean Jaurès', '117 avenue Jean Jaurès', 75019, 'PARIS', 25, '2020-02-29 08:31:46.165+00', '2020-02-29 08:31:46.165+00', 1),
(2420298, 'Aéronaval', '23 rue du soleil', 75020, 'PARIS', 30, '2020-02-29 08:31:46.178+00', '2020-02-29 08:31:46.178+00', 1),
(75, 'des Pyrénées - 20', '399 bis rue des Pyrénées', 75020, 'PARIS', 15, '2020-02-29 08:31:46.179+00', '2020-02-29 08:31:46.179+00', 1),
(7760496, 'Moderne - 20', '13 rue d''Avron', 75020, 'PARIS', 10, '2020-02-29 08:31:46.181+00', '2020-02-29 08:31:46.181+00', 1),
(20399099, 'Pratic Hôtel', '65 rue Planchat', 75020, 'PARIS', 5, '2020-02-29 08:31:46.185+00', '2020-02-29 08:31:46.185+00', 1),
(4882372, 'Acostel', '336 avenue de la victoire', 77100, 'MEAUX', 27, '2020-02-29 08:31:46.186+00', '2020-02-29 08:31:46.186+00', 4),
(4562673, '1ère classe Mouroux', '1100 rue de Liéton', 77120, 'MOUROUX', 29, '2020-02-29 08:31:46.187+00', '2020-02-29 08:31:46.187+00', 4),
(421836, 'F1 Brie Comte Robert - H2536', 'Rue Gustave Eiffel/ZAC de la Haye Passart', 77170, 'BRIE-COMTE-ROBERT', 27, '2020-02-29 08:31:46.189+00', '2020-02-29 08:31:46.189+00', 4),
(4832192, 'Europarc', 'Boulevard Courcerin', 77185, 'LOGNES', 56, '2020-02-29 08:31:46.191+00', '2020-02-29 08:31:46.191+00', 4),
(5882742, 'Escale 77', '7 avenue du Marechal Leclerc', 77230, 'DAMMARTIN-EN-GOELE', 13, '2020-02-29 08:31:46.192+00', '2020-02-29 08:31:46.192+00', 4),
(6088952, 'du Faubourg', '39 rue du Faubourg', 77260, 'LA FERTE-SOUS-JOUARRE', 11, '2020-02-29 08:31:46.194+00', '2020-02-29 08:31:46.194+00', 4),
(1158151, 'Relais du Pavé', '9 Route Nationale 4', 77340, 'PONTAULT-COMBAULT', 0, '2020-02-29 08:31:46.195+00', '2020-02-29 08:31:46.195+00', 4),
(80441, '1ère Classe MLV - Saint Thibault des Vignes', 'Rue de l''étang de la Loy', 77400, 'ST-THIBAULT-DES-VIGNES', 0, '2020-02-29 08:31:46.196+00', '2020-02-29 08:31:46.196+00', 4),
(23, 'Mot''hôtel', '17 rue Victor Baltard', 77410, 'CLAYE-SOUILLY', 49, '2020-02-29 08:31:46.197+00', '2020-02-29 08:31:46.197+00', 4),
(21561328, 'JADE HOTELS Ibis Budget Chelles', 'EAE La Tuilerie - 9 rue de Derrière la Montagne', 77500, 'CHELLES', 58, '2020-02-29 08:31:46.199+00', '2020-02-29 08:31:46.199+00', 4),
(4804062, 'Motélia Moissy Cramayel', '1 Rue Claude Bernard', 77550, 'MOISSY-CRAMAYEL', 4, '2020-02-29 08:31:46.2+00', '2020-02-29 08:31:46.2+00', 4),
(4804009, 'Fast Hôtel Montereau ancien PC', 'RN 105 Le Petit Fossard', 77940, 'ESMANS', 12, '2020-02-29 08:31:46.202+00', '2020-02-29 08:31:46.202+00', 4),
(3455880, 'Appart''City Magny-Les-Hameaux', 'RD 195 - La Mare Mazarin', 78114, 'MAGNY-LES-HAMEAUX', 13, '2020-02-29 08:31:46.204+00', '2020-02-29 08:31:46.204+00', 5),
(5979051, 'De la Gare Mureaux', 'Place du 11 novembre 1918', 78130, 'LES MUREAUX', 33, '2020-02-29 08:31:46.216+00', '2020-02-29 08:31:46.216+00', 5),
(5542688, 'Le Pavillon Bleu - Trappes', '1 route de Dreux', 78190, 'TRAPPES', 74, '2020-02-29 08:31:46.218+00', '2020-02-29 08:31:46.218+00', 5),
(24777633, 'Le Saint Louis - Meulan en Yvelines', '13 Avenue du Maréchal Joffre', 78250, 'MEULAN EN YVELINES', 10, '2020-02-29 08:31:46.219+00', '2020-02-29 08:31:46.219+00', 5),
(19935177, 'Le Gambetta - Poissy', '27 boulevard Gambetta', 78300, 'POISSY', 17, '2020-02-29 08:31:46.222+00', '2020-02-29 08:31:46.222+00', 5),
(24666836, 'Welcomotel Coignières', '7 Rue Joseph Marie Jacquard', 78310, 'COIGNIERES', 3, '2020-02-29 08:31:46.223+00', '2020-02-29 08:31:46.223+00', 5),
(11062680, 'Résidence FLINS', '106 rue du Maréchal Foch', 78410, 'FLINS-SUR-SEINE', 15, '2020-02-29 08:31:46.224+00', '2020-02-29 08:31:46.224+00', 5),
(25214173, 'Le Paris Vernouillet', '6 place Albert Schweitzer', 78540, 'VERNOUILLET', 10, '2020-02-29 08:31:46.225+00', '2020-02-29 08:31:46.225+00', 5),
(26500133, '1ère Classe Conflans - ESPERER', '11 rue des Belles Hâtes', 78700, 'CONFLANS-SAINTE-HONORINE', 9, '2020-02-29 08:31:46.227+00', '2020-02-29 08:31:46.227+00', 5),
(21930736, 'Première classe Conflans', '11 rue des Belles Hâtes', 78700, 'CONFLANS-SAINTE-HONORINE', 6, '2020-02-29 08:31:46.228+00', '2020-02-29 08:31:46.228+00', 5),
(1257247, 'Hôtel Class''Eco Evry - Ex balladins', 'Impasse Alexis Trinquet', 91000, 'EVRY', 38, '2020-02-29 08:31:46.229+00', '2020-02-29 08:31:46.229+00', 4),
(26462211, 'Du Musée Saint Jean - PTS', '28 rue widmer', 91100, 'CORBEIL ESSONNES', 1, '2020-02-29 08:31:46.232+00', '2020-02-29 08:31:46.232+00', 4),
(6094875, 'Le Chalet des Marais', '10 chemin du bas des brettes', 91100, 'VILLABE', 13, '2020-02-29 08:31:46.233+00', '2020-02-29 08:31:46.233+00', 4),
(25091750, 'Sasotel - appartement', '23 rue widmer', 91100, 'CORBEIL ESSONNES', 7, '2020-02-29 08:31:46.234+00', '2020-02-29 08:31:46.234+00', 4),
(25218457, 'Du Lac', '2 rue du Pont Neuf', 91160, 'SAULX-LES-CHARTREUX', 0, '2020-02-29 08:31:46.235+00', '2020-02-29 08:31:46.235+00', 4),
(5887743, 'Le Rendez-vous des Pêcheurs', '4 Quai Alexandre Bouton', 91170, 'VIRY-CHATILLON', 15, '2020-02-29 08:31:46.236+00', '2020-02-29 08:31:46.236+00', 4),
(26385437, 'Au Pêcheur tranquille', '65 Quai de l''Orge', 91200, 'ATHIS-MONS', 10, '2020-02-29 08:31:46.25+00', '2020-02-29 08:31:46.25+00', 4),
(20890889, 'Auberge de la Mairie BTM', '27-29 rue de la mairie', 91220, 'BRETIGNY-SUR-ORGE', 8, '2020-02-29 08:31:46.252+00', '2020-02-29 08:31:46.252+00', 4),
(26384134, 'Confort Hôtel Montgeron RESAO', 'Centre commercial Valdol RN 6y', 91230, 'MONTGERON', 7, '2020-02-29 08:31:46.253+00', '2020-02-29 08:31:46.253+00', 4),
(1260702, 'du Commerce', '9 rue Pierre Semard', 91260, 'JUVISY-SUR-ORGE', 20, '2020-02-29 08:31:46.255+00', '2020-02-29 08:31:46.255+00', 4),
(1853843, 'Lemon Vigneux', '12 rue de la Fosse Montalbot', 91270, 'VIGNEUX-SUR-SEINE', 54, '2020-02-29 08:31:46.256+00', '2020-02-29 08:31:46.256+00', 4),
(392974, 'F1 Epinay sur Orge - H2387', '1 rue Charaintru/Lotissement de Petit Vaux', 91360, 'EPINAY-SUR-ORGE', 23, '2020-02-29 08:31:46.258+00', '2020-02-29 08:31:46.258+00', 4),
(24988383, 'Les Bords De L''Orge - hôtel', '7 rue de savigny', 91390, 'MORSANG-SUR-ORGE', 12, '2020-02-29 08:31:46.259+00', '2020-02-29 08:31:46.259+00', 4),
(2404088, 'Pierre Loti', '110 avenue de la République', 91420, 'MORANGIS', 28, '2020-02-29 08:31:46.26+00', '2020-02-29 08:31:46.26+00', 4),
(21499566, 'RESIDIS Le Hall', '3 avenue du Maréchal Devaux', 91550, 'PARAY-VIEILLE-POSTE', 44, '2020-02-29 08:31:46.261+00', '2020-02-29 08:31:46.261+00', 4),
(393009, 'F1 Savigny Villemoisson - H2230', 'Prairie de Savigny', 91600, 'SAVIGNY SUR ORGE', 23, '2020-02-29 08:31:46.262+00', '2020-02-29 08:31:46.262+00', 4),
(5583984, 'La Belle étape', '2 rue de Milly', 91720, 'MAISSE', 9, '2020-02-29 08:31:46.264+00', '2020-02-29 08:31:46.264+00', 4),
(1245162, '1ère Classe Les Ulis', '13 Avenue des Tropiques', 91940, 'LES ULIS', 4, '2020-02-29 08:31:46.265+00', '2020-02-29 08:31:46.265+00', 4),
(7867613, 'Télémaque', '64 rue Daguerre', 75014, 'PARIS', 9, '2020-02-29 08:31:46.087+00', '2020-02-29 08:31:46.087+00', 1),
(7981043, 'Vélodrome', '215 avenue de Versailles', 75016, 'PARIS', 6, '2020-02-29 08:31:46.09+00', '2020-02-29 08:31:46.09+00', 1),
(69, 'Cristal', '64 rue de la Jonquière', 75017, 'PARIS', 35, '2020-02-29 08:31:46.092+00', '2020-02-29 08:31:46.092+00', 1),
(166, 'de Nice', '90 rue Truffaut', 75017, 'PARIS', 9, '2020-02-29 08:31:46.095+00', '2020-02-29 08:31:46.095+00', 1),
(85, 'Grillon Sauffroy', '30 rue Sauffroy', 75017, 'PARIS', 23, '2020-02-29 08:31:46.097+00', '2020-02-29 08:31:46.097+00', 1),
(1352395, 'Mirific', '119 avenue de Clichy', 75017, 'PARIS', 0, '2020-02-29 08:31:46.099+00', '2020-02-29 08:31:46.099+00', 1),
(259377, 'Royal Résidence', '188 avenue de Clichy', 75017, 'PARIS', 0, '2020-02-29 08:31:46.106+00', '2020-02-29 08:31:46.106+00', 1),
(140, '29 Poissonniers', '29 rue des Poissonniers', 75018, 'PARIS', 30, '2020-02-29 08:31:46.108+00', '2020-02-29 08:31:46.108+00', 1),
(10173809, 'De Belfort', '40 rue Marc Seguin', 75018, 'PARIS', 1, '2020-02-29 08:31:46.11+00', '2020-02-29 08:31:46.11+00', 1),
(7358996, 'De l''Avenue', '1 passage Lathuille', 75018, 'PARIS', 0, '2020-02-29 08:31:46.113+00', '2020-02-29 08:31:46.113+00', 1),
(20129616, 'Du Printemps - Paris 18ème', '72 rue des Poissonniers', 75018, 'PARIS', 3, '2020-02-29 08:31:46.114+00', '2020-02-29 08:31:46.114+00', 1),
(49517, 'Home Labat', '30 rue Labat', 75018, 'PARIS', 15, '2020-02-29 08:31:46.116+00', '2020-02-29 08:31:46.116+00', 1),
(4217525, 'le Grillon Doudeauville', '85 Rue Doudeauville', 75018, 'PARIS', 24, '2020-02-29 08:31:46.118+00', '2020-02-29 08:31:46.118+00', 1),
(200, 'Montmartrois', '6 bis rue du Chevalier de la Barre', 75018, 'PARIS', 72, '2020-02-29 08:31:46.119+00', '2020-02-29 08:31:46.119+00', 1),
(90, 'Paris Montmartre', '87 rue Myrha', 75018, 'PARIS', 4, '2020-02-29 08:31:46.123+00', '2020-02-29 08:31:46.123+00', 1),
(25495936, 'Résidence Hibiscus', '21 rue doudeville', 75018, 'PARIS', 0, '2020-02-29 08:31:46.125+00', '2020-02-29 08:31:46.125+00', 1),
(73, 'Riquet', '92 rue Riquet', 75018, 'PARIS', 7, '2020-02-29 08:31:46.126+00', '2020-02-29 08:31:46.126+00', 1),
(24388772, 'Victoire Paris', '1 Boulevard Ornano', 75018, 'PARIS', 14, '2020-02-29 08:31:46.128+00', '2020-02-29 08:31:46.128+00', 1),
(96, 'Antinéa', '26 avenue Mathurin Moreau', 75019, 'PARIS', 22, '2020-02-29 08:31:46.133+00', '2020-02-29 08:31:46.133+00', 1),
(7786499, 'des Buttes Chaumont', '4 avenue Secrétan', 75019, 'PARIS', 0, '2020-02-29 08:31:46.155+00', '2020-02-29 08:31:46.155+00', 1),
(69139, 'Le Bienvenu', '8 rue de Meaux', 75019, 'PARIS', 17, '2020-02-29 08:31:46.157+00', '2020-02-29 08:31:46.157+00', 1),
(81459, 'Résidhome La Villette', '10 rue Emile Reynaud', 75019, 'PARIS', 75, '2020-02-29 08:31:46.166+00', '2020-02-29 08:31:46.166+00', 1),
(1020954, 'Avenue 20ème', '94 rue de la Réunion', 75020, 'PARIS', 34, '2020-02-29 08:31:46.178+00', '2020-02-29 08:31:46.178+00', 1),
(52, 'Fleuri', '128 rue Villiers de l''Isle Adam', 75020, 'PARIS', 19, '2020-02-29 08:31:46.179+00', '2020-02-29 08:31:46.179+00', 1),
(14664544, 'Moderne - Paris 20ème', '57 rue de la Réunion', 75020, 'PARIS', 16, '2020-02-29 08:31:46.181+00', '2020-02-29 08:31:46.181+00', 1),
(1261006, 'Relais des douches', '65 rue de Buzenval', 75020, 'PARIS', 16, '2020-02-29 08:31:46.185+00', '2020-02-29 08:31:46.185+00', 1),
(11416173, 'Balladins Mareuil les Meaux', '88-106 rue Jean Serva', 77100, 'MAREUIL-LES-MEAUX', 0, '2020-02-29 08:31:46.186+00', '2020-02-29 08:31:46.186+00', 4),
(1920619, 'Class''éco', '31 Rue du Grand Morin', 77120, 'COULOMMIERS', 57, '2020-02-29 08:31:46.187+00', '2020-02-29 08:31:46.187+00', 4),
(4804048, 'Fast Hôtel Brie Comte Robert', '11 allée du Commandant Guesnet', 77170, 'BRIE-COMTE-ROBERT', 3, '2020-02-29 08:31:46.189+00', '2020-02-29 08:31:46.189+00', 4),
(1234503, 'Hipotel Noisiel', '3 Place Gaston Defferre', 77186, 'NOISIEL', 18, '2020-02-29 08:31:46.191+00', '2020-02-29 08:31:46.191+00', 4),
(25441334, 'Escale - Longperrier - Audit régio', 'Rue de la belle étoile', 77230, 'LONPERRIER', 0, '2020-02-29 08:31:46.193+00', '2020-02-29 08:31:46.193+00', 4),
(5890205, 'F1 Villeparisis - H2503', 'ZAC de l''Ambresis rue Alfred Nobel', 77270, 'VILLEPARISIS', 70, '2020-02-29 08:31:46.194+00', '2020-02-29 08:31:46.194+00', 4),
(1258237, 'Auberge du Rallye', '47 Boulevard De La Marne', 77360, 'VAIRES-SUR-MARNE', 15, '2020-02-29 08:31:46.195+00', '2020-02-29 08:31:46.195+00', 4),
(4804002, 'AL Hôtel Lagny Marne', '61 rue Jacquard', 77400, 'LAGNY-SUR-MARNE', 16, '2020-02-29 08:31:46.196+00', '2020-02-29 08:31:46.196+00', 4),
(23736534, 'Hôtel et Résidence Esbly', '4 route de Vignely', 77450, 'ISLES-LES-VILLENOY', 80, '2020-02-29 08:31:46.198+00', '2020-02-29 08:31:46.198+00', 4),
(11139821, 'Mondhotel Garden', '1 rue du Château Gaillard', 77500, 'CHELLES', 82, '2020-02-29 08:31:46.199+00', '2020-02-29 08:31:46.199+00', 4),
(24289505, 'RESIDIS Bussy - Bellagio', '39 boulevard de Lagny', 77600, 'BUSSY ST GEORGES', 62, '2020-02-29 08:31:46.2+00', '2020-02-29 08:31:46.2+00', 4),
(2545981, 'Confotel Rubelles', '1 rue du Perré', 77950, 'RUBELLES', 42, '2020-02-29 08:31:46.203+00', '2020-02-29 08:31:46.203+00', 4),
(22994708, 'Ecotel', '10 Rue Joseph Jacquard', 78120, 'RAMBOUILLET', 42, '2020-02-29 08:31:46.215+00', '2020-02-29 08:31:46.215+00', 5),
(7274439, 'Résidence de la gare - les Mureaux', 'Place du 11 novembre 1918', 78130, 'LES MUREAUX', 42, '2020-02-29 08:31:46.217+00', '2020-02-29 08:31:46.217+00', 5),
(3454388, 'Formule 1 de Trappes', 'Rue Gaston Monmousseau', 78195, 'TRAPPES', 25, '2020-02-29 08:31:46.218+00', '2020-02-29 08:31:46.218+00', 5),
(5044762, 'Appart''City Poissy', '12 rue Jacob Courant', 78300, 'POISSY', 138, '2020-02-29 08:31:46.219+00', '2020-02-29 08:31:46.219+00', 5),
(24817638, 'Le Mouton Blanc', '112 Rue du Général de Gaulle', 78300, 'POISSY', 9, '2020-02-29 08:31:46.222+00', '2020-02-29 08:31:46.222+00', 5),
(161263, 'Montesson', '23 Place Berthelot', 78360, 'MONTESSON', 19, '2020-02-29 08:31:46.223+00', '2020-02-29 08:31:46.223+00', 5),
(1254903, 'Résidence Louveciennes', '9 bis quai Conti', 78430, 'LOUVECIENNES', 69, '2020-02-29 08:31:46.225+00', '2020-02-29 08:31:46.225+00', 5),
(1435108, 'Comfort Suites Le Port-Marly', '3 avenue Simon Vouet', 78560, 'LE PORT-MARLY', 54, '2020-02-29 08:31:46.226+00', '2020-02-29 08:31:46.226+00', 5),
(4851079, 'Campanile Conflans Sainte-Honorine', '91 rue de Cergy', 78700, 'CONFLANS-SAINTE-HONORINE', 3, '2020-02-29 08:31:46.227+00', '2020-02-29 08:31:46.227+00', 5),
(24907346, 'Arpège', '41 route de paris', 78760, 'JOUARS PONTCHARTRAIN', 7, '2020-02-29 08:31:46.229+00', '2020-02-29 08:31:46.229+00', 5),
(1261124, 'Stars Evry', 'avenue de lOrme à Martin', 91000, 'EVRY', 21, '2020-02-29 08:31:46.23+00', '2020-02-29 08:31:46.23+00', 4),
(26462251, 'Du Musée Saint Jean', '28 rue widmer', 91100, 'CORBEIL ESSONNES', 1, '2020-02-29 08:31:46.231+00', '2020-02-29 08:31:46.231+00', 4),
(4224503, 'le Bellevue', '1 Rue Ferdinand Buisson', 91100, 'CORBEIL-ESSONNES', 10, '2020-02-29 08:31:46.233+00', '2020-02-29 08:31:46.233+00', 4),
(1206831, 'Saraga', '7 avenue Strathkelvin', 91100, 'CORBEIL-ESSONNES', 75, '2020-02-29 08:31:46.234+00', '2020-02-29 08:31:46.234+00', 4),
(24977397, 'Hôtel ESSONNE ex Gare Etampes', '3 rue du château', 91150, 'ETAMPES', 6, '2020-02-29 08:31:46.235+00', '2020-02-29 08:31:46.235+00', 4),
(19935135, 'Domance Hotel', '1 rue de Savigny', 91170, 'VIRY-CHATILLON', 5, '2020-02-29 08:31:46.236+00', '2020-02-29 08:31:46.236+00', 4),
(26385181, 'Résidence la forêt', '70 avenue de la forêt', 91170, 'VIRY-CHATILLON', 3, '2020-02-29 08:31:46.25+00', '2020-02-29 08:31:46.25+00', 4),
(19935230, 'Le Pile ou Face Café', '116 rue de la voie verte', 91200, 'ATHIS-MONS', 5, '2020-02-29 08:31:46.252+00', '2020-02-29 08:31:46.252+00', 4),
(26383787, 'Confort Hôtel Montgeron RESADOTEL', 'Centre commercial Valdoly RN 6', 91230, 'MONTGERON', 8, '2020-02-29 08:31:46.253+00', '2020-02-29 08:31:46.253+00', 4),
(4108457, 'KENZ - Juvisy', '3 avenue de la Cour de France', 91260, 'JUVISY-SUR-ORGE', 0, '2020-02-29 08:31:46.255+00', '2020-02-29 08:31:46.255+00', 4),
(2428909, 'LOC MEUBLE MASSY', '1, avenue du Maréchal Juin.', 91300, 'MASSY', 51, '2020-02-29 08:31:46.257+00', '2020-02-29 08:31:46.257+00', 4),
(19935136, 'Escale Akena - Chilly', '1 rue Ampère', 91380, 'CHILLY-MAZARIN', 10, '2020-02-29 08:31:46.258+00', '2020-02-29 08:31:46.258+00', 4),
(24988313, 'Lion d''Or Ex les Rives de l''orge', '24 avenue des Erables', 91390, 'MORSANG-SUR-ORGE', 14, '2020-02-29 08:31:46.259+00', '2020-02-29 08:31:46.259+00', 4),
(25036991, 'La Tourelle', '7 place du Général Leclerc', 91450, 'SOISY SUR SEINE', 13, '2020-02-29 08:31:46.26+00', '2020-02-29 08:31:46.26+00', 4),
(26402569, 'Le Petit Crosne - RESADOTEL', '55 bis avenue de la république', 91560, 'CROSNES', 5, '2020-02-29 08:31:46.261+00', '2020-02-29 08:31:46.261+00', 4),
(5566414, 'Du Grand Panorama', '5 rue du Mont Blanc', 91600, 'SAVIGNY-SUR-ORGE', 29, '2020-02-29 08:31:46.262+00', '2020-02-29 08:31:46.262+00', 4),
(26384724, 'Green hôtel - 91', '19 rue de L''Hurepoix', 91700, 'SAINTE GENEVIEVE DES BOIS', 20, '2020-02-29 08:31:46.263+00', '2020-02-29 08:31:46.263+00', 4),
(1253389, 'Grill Coudray', '2 rue Panhard', 91830, 'LE COUDRAY-MONTCEAUX', 52, '2020-02-29 08:31:46.265+00', '2020-02-29 08:31:46.265+00', 4),
(34, 'L''Acacias', '121 avenue Georges Clemenceau', 92000, 'NANTERRE', 0, '2020-02-29 08:31:46.266+00', '2020-02-29 08:31:46.266+00', 3),
(23406821, 'De La Reine', '156 route De La Reine', 92100, 'BOULOGNE-BILLANCOURT', 11, '2020-02-29 08:31:46.267+00', '2020-02-29 08:31:46.267+00', 3),
(13255226, 'Villa du Maine', '20 rue Ledion', 75014, 'PARIS', 25, '2020-02-29 08:31:46.087+00', '2020-02-29 08:31:46.087+00', 1),
(47855, 'Abc', '4 Rue Abel Truchet', 75017, 'PARIS', 33, '2020-02-29 08:31:46.09+00', '2020-02-29 08:31:46.09+00', 1),
(57932, 'd''Aveyron', '3 rue Lacroix', 75017, 'PARIS', 14, '2020-02-29 08:31:46.093+00', '2020-02-29 08:31:46.093+00', 1),
(2081023, 'des Bains 17', '125 avenue de Clichy', 75017, 'PARIS', 18, '2020-02-29 08:31:46.096+00', '2020-02-29 08:31:46.096+00', 1),
(49420, 'Kim Hôtel', '46 rue de la Jonquière', 75017, 'PARIS', 27, '2020-02-29 08:31:46.098+00', '2020-02-29 08:31:46.098+00', 1),
(1262186, 'Nollet', '33 rue Nollet', 75017, 'PARIS', 11, '2020-02-29 08:31:46.1+00', '2020-02-29 08:31:46.1+00', 1),
(6934917, 'Santana', '109 rue Legendre', 75017, 'PARIS', 18, '2020-02-29 08:31:46.107+00', '2020-02-29 08:31:46.107+00', 1),
(16884156, 'Amarys', '7 rue Simart', 75018, 'PARIS', 30, '2020-02-29 08:31:46.109+00', '2020-02-29 08:31:46.109+00', 1),
(223, 'de la Fourche', '6 avenue de Saint-Ouen', 75018, 'PARIS', 23, '2020-02-29 08:31:46.111+00', '2020-02-29 08:31:46.111+00', 1),
(160, 'des Beaux-Arts', '4 rue André Antoine', 75018, 'PARIS', 14, '2020-02-29 08:31:46.114+00', '2020-02-29 08:31:46.114+00', 1),
(47968, 'F1 Paris Porte de Montmartre - H2539', '29 rue du Docteur Babinsky', 75018, 'PARIS', 0, '2020-02-29 08:31:46.115+00', '2020-02-29 08:31:46.115+00', 1),
(25479256, 'Hôtel Saint pierre', '3 rue Sevest', 75018, 'PARIS', 0, '2020-02-29 08:31:46.117+00', '2020-02-29 08:31:46.117+00', 1),
(867941, 'Le Paris Saint-Ouen', '154 Avenue de saint Ouen', 75018, 'PARIS', 13, '2020-02-29 08:31:46.118+00', '2020-02-29 08:31:46.118+00', 1),
(7395654, 'Myrat Beaux', '41 rue Myrha', 75018, 'PARIS', 17, '2020-02-29 08:31:46.123+00', '2020-02-29 08:31:46.123+00', 1),
(23673526, 'PAX HOTEL', '5 rue des poissonniers', 75018, 'PARIS', 3, '2020-02-29 08:31:46.124+00', '2020-02-29 08:31:46.124+00', 1),
(5305027, 'Résidence Studéa Clignancourt', '50-58 avenue de la Porte des Poissonniers', 75018, 'PARIS', 18, '2020-02-29 08:31:46.125+00', '2020-02-29 08:31:46.125+00', 1),
(1078575, 'Style', '8 Rue Ganneron', 75018, 'PARIS', 26, '2020-02-29 08:31:46.127+00', '2020-02-29 08:31:46.127+00', 1),
(14842593, 'Abricotel', '15 Rue Lally-Tollendal', 75019, 'PARIS', 16, '2020-02-29 08:31:46.131+00', '2020-02-29 08:31:46.131+00', 1),
(27560457, 'De la Gare - Paris', '114 rue de Crimée', 75019, 'PARIS', 2, '2020-02-29 08:31:46.135+00', '2020-02-29 08:31:46.135+00', 1),
(1447904, 'Gresset', '4 rue Gresset', 75019, 'PARIS', 7, '2020-02-29 08:31:46.156+00', '2020-02-29 08:31:46.156+00', 1),
(167, 'New Paris', '231 rue de Crimée', 75019, 'PARIS', 17, '2020-02-29 08:31:46.165+00', '2020-02-29 08:31:46.165+00', 1),
(5060386, 'Studéa Buttes Chaumont', '50 Rue Petit', 75019, 'PARIS', 0, '2020-02-29 08:31:46.177+00', '2020-02-29 08:31:46.177+00', 1),
(51243, 'de la Source', '44 rue du Borrego', 75020, 'PARIS', 13, '2020-02-29 08:31:46.179+00', '2020-02-29 08:31:46.179+00', 1),
(7392374, 'Levert', '37 rue Levert', 75020, 'PARIS', 50, '2020-02-29 08:31:46.18+00', '2020-02-29 08:31:46.18+00', 1),
(14912195, 'OBODODO', '28 boulevard de Ménilmontant', 75020, 'PARIS', 9, '2020-02-29 08:31:46.184+00', '2020-02-29 08:31:46.184+00', 1),
(14605715, 'LEMON ROUEN', 'ZAC du Champ Cornu', 76240, 'LE MESNIL ESNARD', 0, '2020-02-29 08:31:46.185+00', '2020-02-29 08:31:46.185+00', 5),
(9270245, 'Résidence Mareuil', '115 rue Jean Serva', 77100, 'MAREUIL-LES-MEAUX', 33, '2020-02-29 08:31:46.187+00', '2020-02-29 08:31:46.187+00', 4),
(5907295, 'le Flamboyant', '98 rue de Paris', 77127, 'LIEUSAINT', 69, '2020-02-29 08:31:46.188+00', '2020-02-29 08:31:46.188+00', 4),
(23829183, 'Hôtel et Résidence Savigny', '159 rue de L''industrie', 77176, 'SAVIGNY-LE-TEMPLE', 106, '2020-02-29 08:31:46.19+00', '2020-02-29 08:31:46.19+00', 4),
(910062, 'Mister Bed City Torcy', 'Centre Commercial Bay 4 Rue Charlie Chaplin', 77200, 'TORCY', 74, '2020-02-29 08:31:46.191+00', '2020-02-29 08:31:46.191+00', 4),
(3604084, 'Confort Hôtel Vert Saint Denis', 'Avenue du Bois Vert', 77240, 'VERT-SAINT-DENIS', 27, '2020-02-29 08:31:46.193+00', '2020-02-29 08:31:46.193+00', 4),
(20584007, 'Fast Hôtel Saint Fargeau', 'rue de Strasbourg ZAC de l''Europe', 77310, 'SAINT FARGEAU PONTHIERRY', 38, '2020-02-29 08:31:46.194+00', '2020-02-29 08:31:46.194+00', 4),
(6093123, 'la Maison du bien être', '25 rue des Fusillés', 77360, 'VAIRES-SUR-MARNE', 22, '2020-02-29 08:31:46.196+00', '2020-02-29 08:31:46.196+00', 4),
(19096763, 'AKENA Crystal Hôtel', '2 bis rue Ernest Sarron', 77410, 'CLAYE-SOUILLY', 22, '2020-02-29 08:31:46.197+00', '2020-02-29 08:31:46.197+00', 4),
(15449414, 'L''auberge du Chemin de Fer', '40 rue aveline', 77470, 'TRILPORT', 5, '2020-02-29 08:31:46.198+00', '2020-02-29 08:31:46.198+00', 4),
(15952434, 'Hôtel et Résidence Moissy', '612 avenue Ampère', 77550, 'MOISSY-CRAMAYEL', 49, '2020-02-29 08:31:46.199+00', '2020-02-29 08:31:46.199+00', 4),
(4332555, 'Résidence Studéa Val d''Europe', '7 cours de la Garonne', 77700, 'SERRIS', 29, '2020-02-29 08:31:46.202+00', '2020-02-29 08:31:46.202+00', 4),
(5566388, 'Auberge du Coq', '45 Boulevard de la Paix', 78100, 'SAINT-GERMAIN-EN-LAYE', 70, '2020-02-29 08:31:46.203+00', '2020-02-29 08:31:46.203+00', 5),
(3030771, 'Aladin Les Mureaux - VSP', '2 rue Levassor', 78130, 'LES MUREAUX', 21, '2020-02-29 08:31:46.216+00', '2020-02-29 08:31:46.216+00', 5),
(4851240, '1ère classe Trappes - SB GROUP', '65B Avenue Georges Politzer', 78190, 'TRAPPES', 29, '2020-02-29 08:31:46.217+00', '2020-02-29 08:31:46.217+00', 5),
(9246012, 'Appart''City Saint Versailles Saint Cyr', '68 rue Gabriel Péri', 78210, 'SAINT-CYR-LECOLE', 13, '2020-02-29 08:31:46.219+00', '2020-02-29 08:31:46.219+00', 5),
(14378783, 'de la Gare - Poissy', '18 rue de la Gare', 78300, 'POISSY', 0, '2020-02-29 08:31:46.221+00', '2020-02-29 08:31:46.221+00', 5),
(11301318, 'Technoparc Hôtel', '8 rue Gustave Eiffel', 78300, 'POISSY', 59, '2020-02-29 08:31:46.223+00', '2020-02-29 08:31:46.223+00', 5),
(20086001, 'F1 Plaisir - H2218', '36 rue Pierre Curie', 78370, 'PLAISIR', 16, '2020-02-29 08:31:46.224+00', '2020-02-29 08:31:46.224+00', 5),
(10236439, 'L''Escapade', '14 rue du Maréchal Foch', 78520, 'LIMAY', 11, '2020-02-29 08:31:46.225+00', '2020-02-29 08:31:46.225+00', 5),
(6418202, 'F1 Epône - H2391', '204 avenue de la Mauldre', 78680, 'EPONE', 28, '2020-02-29 08:31:46.226+00', '2020-02-29 08:31:46.226+00', 5),
(4351223, 'Le Paris', '36 rue Maurice Berteaux', 78700, 'CONFLANS-SAINTE-HONORINE', 9, '2020-02-29 08:31:46.228+00', '2020-02-29 08:31:46.228+00', 5),
(26379581, 'Aladin Evry- RESADOTEL', 'Place Gaston Crémieux', 91000, 'EVRY', 29, '2020-02-29 08:31:46.229+00', '2020-02-29 08:31:46.229+00', 4),
(26385370, 'BHNV', '107 rue Feray', 91100, 'CORBEIL ESSONNES', 7, '2020-02-29 08:31:46.23+00', '2020-02-29 08:31:46.23+00', 4),
(4224502, 'Grand Pignon', '8 Rue du Grand Pignon', 91100, 'CORBEIL-ESSONNES', 15, '2020-02-29 08:31:46.232+00', '2020-02-29 08:31:46.232+00', 4),
(24861234, 'L''Ermitage Hôtel', '137 boulevard Fontainebleau', 91100, 'CORBEIL-ESSONNES', 11, '2020-02-29 08:31:46.233+00', '2020-02-29 08:31:46.233+00', 4),
(21514076, 'Auberge de l''Eléphant SARL My Place', '7 Rue de Paris', 91120, 'PALAISEAU', 9, '2020-02-29 08:31:46.234+00', '2020-02-29 08:31:46.234+00', 4),
(26379451, 'Du Lac - RESADOTEL', '2 rue du Pont Neuf', 91160, 'SAULX-LES-CHARTREUX', 30, '2020-02-29 08:31:46.236+00', '2020-02-29 08:31:46.236+00', 4),
(1859533, 'Le Sporting - hôtel', '51 Rue Pierre et Marie Curie', 91170, 'VIRY-CHATILLON', 13, '2020-02-29 08:31:46.237+00', '2020-02-29 08:31:46.237+00', 4),
(6203778, 'De la Gare - Athis Mons', '1 place Rothenburg', 91200, 'ATHIS-MONS', 13, '2020-02-29 08:31:46.251+00', '2020-02-29 08:31:46.251+00', 4),
(25170110, 'Au Réveil Matin', '22 avenue Jean Jaurès', 91230, 'MONTGERON', 12, '2020-02-29 08:31:46.252+00', '2020-02-29 08:31:46.252+00', 4),
(2616997, 'Le Rond Point', '40 route de Corbeil', 91230, 'MONTGERON', 0, '2020-02-29 08:31:46.254+00', '2020-02-29 08:31:46.254+00', 4),
(4352843, 'Orphéon', '10 rue de Draveil', 91260, 'JUVISY-SUR-ORGE', 11, '2020-02-29 08:31:46.256+00', '2020-02-29 08:31:46.256+00', 4),
(1853928, 'Sologne', '65 Route d''Orleans', 91310, 'MONTLHERY', 2, '2020-02-29 08:31:46.257+00', '2020-02-29 08:31:46.257+00', 4),
(1614943, 'Parthénon', '3 route de Longjumeau', 91380, 'CHILLY-MAZARIN', 85, '2020-02-29 08:31:46.258+00', '2020-02-29 08:31:46.258+00', 4),
(26379322, 'Rond Point Service - PTS', '3 avenue de valois', 91390, 'MORSANG-SUR-ORGE', 12, '2020-02-29 08:31:46.259+00', '2020-02-29 08:31:46.259+00', 4),
(19725423, 'IBIS PARIS ORLY AEROPORT', '19 promenade d''Orly', 91550, 'PARAY VIEILLE POSTE', 0, '2020-02-29 08:31:46.261+00', '2020-02-29 08:31:46.261+00', 4),
(24955275, 'Alliance Hôtelière', '96 rue pierre curie', 91600, 'SAVIGNY-SUR-ORGE', 8, '2020-02-29 08:31:46.262+00', '2020-02-29 08:31:46.262+00', 4),
(24956001, 'Savigny - RESAO', '35 boulevard aristide briand', 91600, 'SAVIGNY-SUR-ORGE', 20, '2020-02-29 08:31:46.263+00', '2020-02-29 08:31:46.263+00', 4),
(3293094, 'KENZ', '15 Rue Marcel Pagnol', 91800, 'BOUSSY-SAINT-ANTOINE', 44, '2020-02-29 08:31:46.264+00', '2020-02-29 08:31:46.264+00', 4),
(5234164, '1ère Classe Nanterre', 'ZI du Petit Nanterre Rue des Haras', 92000, 'NANTERRE', 0, '2020-02-29 08:31:46.265+00', '2020-02-29 08:31:46.265+00', 3),
(4954710, 'Moderne - Nanterre', '4 rue Béranger', 92000, 'NANTERRE', 16, '2020-02-29 08:31:46.267+00', '2020-02-29 08:31:46.267+00', 3),
(25559052, 'Parc - Boulognes Billancourt', '78 rue Thiers', 92100, 'BOULOGNE BILLANCOURT', 0, '2020-02-29 08:31:46.268+00', '2020-02-29 08:31:46.268+00', 3),
(13959961, 'L''Atelier 54 ex Le Baraka', '54 rue de Vouillé', 75015, 'PARIS', 0, '2020-02-29 08:31:46.088+00', '2020-02-29 08:31:46.088+00', 1),
(2555168, 'Alizea', '31 rue Sauffroy', 75017, 'PARIS', 25, '2020-02-29 08:31:46.091+00', '2020-02-29 08:31:46.091+00', 1),
(197, 'de la Condamine', '62 rue de la Condamine', 75017, 'PARIS', 15, '2020-02-29 08:31:46.093+00', '2020-02-29 08:31:46.093+00', 1),
(14417351, 'du Centre - 17ème', '70 rue de la Jonquière', 75017, 'PARIS', 16, '2020-02-29 08:31:46.096+00', '2020-02-29 08:31:46.096+00', 1),
(9151571, 'Le Calvados', '38 rue Pouchet', 75017, 'PARIS', 11, '2020-02-29 08:31:46.098+00', '2020-02-29 08:31:46.098+00', 1),
(25495864, 'Résidence Auberge Service', '72 avenue de Clichy', 75017, 'PARIS', 0, '2020-02-29 08:31:46.1+00', '2020-02-29 08:31:46.1+00', 1),
(173, 'Splendid', '1 rue Lacroix', 75017, 'PARIS', 19, '2020-02-29 08:31:46.108+00', '2020-02-29 08:31:46.108+00', 1),
(48225, 'Best Montmartre Hôtel Ex Carthage', '10 rue Poulet', 75018, 'PARIS', 18, '2020-02-29 08:31:46.11+00', '2020-02-29 08:31:46.11+00', 1),
(20121036, 'De la Paix - Myrha', '58 rue Myrha', 75018, 'PARIS', 2, '2020-02-29 08:31:46.112+00', '2020-02-29 08:31:46.112+00', 1),
(16, 'du Nord Résidence Marcadet', '43 bis rue Marcadet', 75018, 'PARIS', 15, '2020-02-29 08:31:46.114+00', '2020-02-29 08:31:46.114+00', 1),
(6555360, 'Hipotel Paris Montmartre', '19 rue du Roi d''Alger', 75018, 'PARIS', 19, '2020-02-29 08:31:46.115+00', '2020-02-29 08:31:46.115+00', 1),
(24086531, 'Ibis Paris Montmartre 18ème', '5 rue Caulaincourt', 75018, 'PARIS', 1, '2020-02-29 08:31:46.117+00', '2020-02-29 08:31:46.117+00', 1),
(212, 'Le Surcouf 18', '18 rue Houdon', 75018, 'PARIS', 1, '2020-02-29 08:31:46.119+00', '2020-02-29 08:31:46.119+00', 1),
(1264487, 'Pajol', '26 rue Pajol', 75018, 'PARIS', 11, '2020-02-29 08:31:46.123+00', '2020-02-29 08:31:46.123+00', 1),
(4738937, 'Puy de Dôme', '180 rue Ordener', 75018, 'PARIS', 0, '2020-02-29 08:31:46.124+00', '2020-02-29 08:31:46.124+00', 1),
(26664256, 'ResidSocial Championnet Ex Midi', '43 rue Championnet', 75018, 'PARIS', 36, '2020-02-29 08:31:46.126+00', '2020-02-29 08:31:46.126+00', 1),
(25488210, 'Torcy', '58 rue de Torcy', 75018, 'PARIS', 0, '2020-02-29 08:31:46.127+00', '2020-02-29 08:31:46.127+00', 1),
(7397613, 'Agorno', '190 avenue Jean Jaures', 75019, 'PARIS', 0, '2020-02-29 08:31:46.132+00', '2020-02-29 08:31:46.132+00', 1),
(7397687, 'de la Villette', '2 rue de Kabylie', 75019, 'PARIS', 22, '2020-02-29 08:31:46.136+00', '2020-02-29 08:31:46.136+00', 1),
(7786422, 'Hôtel Tilde ex Le Canal', '48 avenue de Flandre', 75019, 'PARIS', 1, '2020-02-29 08:31:46.156+00', '2020-02-29 08:31:46.156+00', 1),
(216, 'Résidence Flandre Crimée', '208 rue de Crimée', 75019, 'PARIS', 2, '2020-02-29 08:31:46.165+00', '2020-02-29 08:31:46.165+00', 1),
(5935970, 'Studélites Le Rembrandt', '153 avenue de Flandres', 75019, 'PARIS', 2, '2020-02-29 08:31:46.177+00', '2020-02-29 08:31:46.177+00', 1),
(1253239, 'de l''étoile', '18 rue Auger', 75020, 'PARIS', 25, '2020-02-29 08:31:46.179+00', '2020-02-29 08:31:46.179+00', 1),
(243, 'Maraîchers', '59 rue des Maraîchers', 75020, 'PARIS', 15, '2020-02-29 08:31:46.18+00', '2020-02-29 08:31:46.18+00', 1),
(103, 'Paris Printania 20', '150 rue d''Avron', 75020, 'PARIS', 1, '2020-02-29 08:31:46.184+00', '2020-02-29 08:31:46.184+00', 1),
(21128495, 'de la Croix Blanche', '2 Avenue Thiers', 77000, 'MELUN', 11, '2020-02-29 08:31:46.186+00', '2020-02-29 08:31:46.186+00', 4),
(25501101, 'Welcomotel Mareuil', '88-106 rue Jean Serva', 77100, 'MAREUIL-LES-MEAUX', 72, '2020-02-29 08:31:46.187+00', '2020-02-29 08:31:46.187+00', 4),
(3901982, 'Village de Montévrain', '12 Avenue de la Societé des Nations', 77144, 'MONTEVRAIN', 29, '2020-02-29 08:31:46.189+00', '2020-02-29 08:31:46.189+00', 4),
(20247612, 'SKY Hôtel', '1 Rue d''Emery', 77184, 'EMERAINVILLE', 49, '2020-02-29 08:31:46.19+00', '2020-02-29 08:31:46.19+00', 4),
(4808908, 'le Terminus Avon', '93 BIS Avenue Franklin Roosevelt', 77210, 'AVON', 18, '2020-02-29 08:31:46.192+00', '2020-02-29 08:31:46.192+00', 4),
(4376525, 'F1 Moret Fontainebleau - H2487', 'Zone artisanale-lieu ditSt Lazare', 77250, 'ECUELLES', 0, '2020-02-29 08:31:46.193+00', '2020-02-29 08:31:46.193+00', 4),
(5566418, 'Le Pavillon Bleu - Ozoir', '108 avenue Général Leclerc', 77330, 'OZOIR-LA-FERRIERE', 38, '2020-02-29 08:31:46.195+00', '2020-02-29 08:31:46.195+00', 4),
(24290502, 'De La Gare NANGIS SASU Balmot', 'Place de la gare-45 Avenue Foch', 77370, 'NANGIS', 10, '2020-02-29 08:31:46.196+00', '2020-02-29 08:31:46.196+00', 4),
(4804052, 'Fast Hôtel Claye Souilly', '2 rue Ernest Sarron', 77410, 'CLAYE-SOUILLY', 8, '2020-02-29 08:31:46.197+00', '2020-02-29 08:31:46.197+00', 4),
(290, '1ère Classe Chelles', '4 rue de l''Ormeteau', 77500, 'CHELLES', 10, '2020-02-29 08:31:46.198+00', '2020-02-29 08:31:46.198+00', 4),
(1226392, 'Le Carré', '525 Rue André Ampère', 77550, 'MOISSY-CRAMAYEL', 70, '2020-02-29 08:31:46.2+00', '2020-02-29 08:31:46.2+00', 4),
(9966721, 'Séjours et Affaires Serris', '20 cours du Danube', 77700, 'SERRIS', 6, '2020-02-29 08:31:46.202+00', '2020-02-29 08:31:46.202+00', 4),
(1057429, 'Havre Hôtel', '92 rue Léon Désoyer', 78100, 'SAINT-GERMAIN-EN-LAYE', 10, '2020-02-29 08:31:46.204+00', '2020-02-29 08:31:46.204+00', 5),
(2555609, 'Confotel Les Mureaux', '4 rue des Pléiades', 78130, 'LES MUREAUX', 44, '2020-02-29 08:31:46.216+00', '2020-02-29 08:31:46.216+00', 5),
(24651949, 'ENZO Trappes', 'rue Eugène Hénaff', 78190, 'TRAPPES', 30, '2020-02-29 08:31:46.218+00', '2020-02-29 08:31:46.218+00', 5),
(4020501, 'Le Rustique', '56 rue du Maréchal Foch', 78250, 'MEULAN-EN-YVELINES', 10, '2020-02-29 08:31:46.219+00', '2020-02-29 08:31:46.219+00', 5),
(25567696, 'Hôtel Poissy - Audit Régio', '2 rue Jacob Courant', 78300, 'POISSY', 0, '2020-02-29 08:31:46.222+00', '2020-02-29 08:31:46.222+00', 5),
(8550719, 'Le PariWest', '6 Rue Ampère', 78310, 'COIGNIERES', 23, '2020-02-29 08:31:46.223+00', '2020-02-29 08:31:46.223+00', 5),
(4353758, 'Appart''City Village Bois d''Arcy', '2A rue Georges Méliès', 78390, 'BOIS-D''ARCY', 16, '2020-02-29 08:31:46.224+00', '2020-02-29 08:31:46.224+00', 5),
(9102433, 'Le Wilson', '1 Avenue Du Président Wilson', 78520, 'LIMAY', 12, '2020-02-29 08:31:46.225+00', '2020-02-29 08:31:46.225+00', 5),
(5234143, '1ère Classe Conflans', '11 rue des Belles Hâtes', 78700, 'CONFLANS-SAINTE-HONORINE', 12, '2020-02-29 08:31:46.226+00', '2020-02-29 08:31:46.226+00', 5),
(260, 'Montjoie', '126 avenue du Maréchal Foch', 78700, 'CONFLANS-SAINTE-HONORINE', 29, '2020-02-29 08:31:46.228+00', '2020-02-29 08:31:46.228+00', 5),
(1859537, 'Aladin Evry - VSP', 'Place Gaston Crémieux', 91000, 'EVRY', 5, '2020-02-29 08:31:46.229+00', '2020-02-29 08:31:46.229+00', 4),
(24955741, 'Brasserie de La Place', '14 place du compté Haymon', 91100, 'CORBEIL ESSONNES', 9, '2020-02-29 08:31:46.231+00', '2020-02-29 08:31:46.231+00', 4),
(24955911, 'La Belle Etoile Corbeil Essonne', '42 rue de paris', 91100, 'CORBEIL ESSONNES', 4, '2020-02-29 08:31:46.232+00', '2020-02-29 08:31:46.232+00', 4),
(26379164, 'L''Ermitage - PTS', '137 boulevard Fontainebleau', 91100, 'CORBEIL-ESSONNES', 6, '2020-02-29 08:31:46.234+00', '2020-02-29 08:31:46.234+00', 4),
(20583435, 'La Ferronnière', '23 avenue Général de Gaulle', 91140, 'VILLEBON SUR YVETTE', 23, '2020-02-29 08:31:46.235+00', '2020-02-29 08:31:46.235+00', 4),
(157, '1ère Classe Viry Chatillon', '80 avenue du Général De Gaulle', 91170, 'VIRY-CHATILLON', 5, '2020-02-29 08:31:46.236+00', '2020-02-29 08:31:46.236+00', 4),
(26384925, 'Première Classe Viry Chatillon RESAO', '80 avenue du Général De Gaulle', 91170, 'VIRY-CHATILLON', 22, '2020-02-29 08:31:46.25+00', '2020-02-29 08:31:46.25+00', 4),
(25218497, 'Le Gaulois', '17 rue Juvisy', 91200, 'ATHIS-MONS', 4, '2020-02-29 08:31:46.251+00', '2020-02-29 08:31:46.251+00', 4),
(322790, 'Confort Hôtel Montgeron', 'Centre commercial Valdoly RN 6', 91230, 'MONTGERON', 6, '2020-02-29 08:31:46.252+00', '2020-02-29 08:31:46.252+00', 4),
(4367703, 'FARAM', 'rue du Lac', 91250, 'TIGERY', 40, '2020-02-29 08:31:46.254+00', '2020-02-29 08:31:46.254+00', 4),
(5928723, 'Résidence Juvisy', '4 avenue d''Estienne d''Orves', 91260, 'JUVISY-SUR-ORGE', 13, '2020-02-29 08:31:46.256+00', '2020-02-29 08:31:46.256+00', 4),
(19935137, 'Best Hôtel Grigny - RESADOTEL', '8 avenue des Tuileries', 91350, 'GRIGNY', 46, '2020-02-29 08:31:46.257+00', '2020-02-29 08:31:46.257+00', 4),
(24628074, 'Welcomotel Chilly', '4 rue Denis Papin', 91380, 'CHILLY-MAZARIN', 81, '2020-02-29 08:31:46.258+00', '2020-02-29 08:31:46.258+00', 4),
(25173125, 'Rond Point Service - RESADOTEL', '3 avenue de valois', 91390, 'MORSANG-SUR-ORGE', 8, '2020-02-29 08:31:46.259+00', '2020-02-29 08:31:46.259+00', 4),
(27626092, 'F1 Mennecy', '30 rue des Moques Tonneaux', 91540, 'ORMOY', 28, '2020-02-29 08:31:46.26+00', '2020-02-29 08:31:46.26+00', 4),
(4025471, 'RESIDCO Le Moulin de Vaux', '34 Chemin de Vaux', 91580, 'AUVERS-SAINT-GEORGES', 11, '2020-02-29 08:31:46.261+00', '2020-02-29 08:31:46.261+00', 4),
(3442279, 'Le Golf de Savigny', '9 Avenue du Garigliano ZAC des Gâtines', 91600, 'SAVIGNY-SUR-ORGE', 49, '2020-02-29 08:31:46.263+00', '2020-02-29 08:31:46.263+00', 4),
(26384869, 'Jaihka Boussy', '173 rue du Gord', 91800, 'BOUSSY SAINT ANTOINE', 14, '2020-02-29 08:31:46.264+00', '2020-02-29 08:31:46.264+00', 4),
(3986001, 'Appart''City Les Ulis', '1 rue des Causses', 91940, 'LES ULIS', 113, '2020-02-29 08:31:46.265+00', '2020-02-29 08:31:46.265+00', 4),
(8303143, 'Les Oliviers', '17 rue du Bois', 92000, 'NANTERRE', 10, '2020-02-29 08:31:46.266+00', '2020-02-29 08:31:46.266+00', 3),
(129, 'Le Coin Tranquille', '10 rue du docteur Foucault', 92000, 'NANTERRE', 16, '2020-02-29 08:31:46.266+00', '2020-02-29 08:31:46.266+00', 3),
(5453124, 'du Dôme', '53 rue du Dôme', 92100, 'BOULOGNE-BILLANCOURT', 14, '2020-02-29 08:31:46.267+00', '2020-02-29 08:31:46.267+00', 3),
(11649774, 'Du Parc - Clichy', '22 Rue du Général Roguet', 92110, 'CLICHY', 12, '2020-02-29 08:31:46.269+00', '2020-02-29 08:31:46.269+00', 3),
(11520329, 'Le Rétro', '52 rue de Paris', 92110, 'CLICHY', 7, '2020-02-29 08:31:46.27+00', '2020-02-29 08:31:46.27+00', 3),
(1264648, 'Oksar', '47 rue de Paris', 92110, 'CLICHY', 4, '2020-02-29 08:31:46.271+00', '2020-02-29 08:31:46.271+00', 3),
(728948, 'LE RIAD', '77 boulevard Galliéni', 92130, 'ISSY-LES-MOULINEAUX', 6, '2020-02-29 08:31:46.307+00', '2020-02-29 08:31:46.307+00', 3),
(215, 'Jaurès café - réactivé pour audit régio', '22 avenue Jean Jaurès', 92150, 'SURESNES', 0, '2020-02-29 08:31:46.31+00', '2020-02-29 08:31:46.31+00', 3),
(25558943, 'Avenue - Gennevilliers', '99 Avenue Marcel Paul', 92230, 'GENNEVILLIERS', 0, '2020-02-29 08:31:46.328+00', '2020-02-29 08:31:46.328+00', 3),
(26384941, 'Moderne Chandon Gennevilliers', '8 bis avenue Chandon', 92230, 'GENNEVILLIERS', 0, '2020-02-29 08:31:46.329+00', '2020-02-29 08:31:46.329+00', 3),
(767386, 'Modern Hôtel', '98 avenue du 12 février 1934', 92240, 'MALAKOFF', 8, '2020-02-29 08:31:46.332+00', '2020-02-29 08:31:46.332+00', 3),
(4584998, 'Villa Renaissance', '3-5 avenue René Isidore', 92260, 'FONTENAY-AUX-ROSES', 45, '2020-02-29 08:31:46.333+00', '2020-02-29 08:31:46.333+00', 3),
(25456597, 'Kyriad Villeneuve la Garenne', '80 boulevard de charles de gaulle', 92390, 'VILLENEUVE LA GARENNE', 0, '2020-02-29 08:31:46.334+00', '2020-02-29 08:31:46.334+00', 3),
(1300095, 'Timgad de l''Alma', '37 rue de l''alma', 92400, 'COURBEVOIE', 0, '2020-02-29 08:31:46.336+00', '2020-02-29 08:31:46.336+00', 3),
(51131, 'l''Espoir', '9 boulevard Voltaire', 92600, 'ASNIERES-SUR-SEINE', 0, '2020-02-29 08:31:46.337+00', '2020-02-29 08:31:46.337+00', 3),
(3280288, 'Le Havane -réactivé audit régio', '79 rue du Maréchal Joffre', 92700, 'COLOMBES', 0, '2020-02-29 08:31:46.338+00', '2020-02-29 08:31:46.338+00', 3),
(52916, 'Malibu', '12-14 rue Francis de Pressencé', 92800, 'PUTEAUX', 0, '2020-02-29 08:31:46.34+00', '2020-02-29 08:31:46.34+00', 3),
(20336889, 'IBIS Budget Bobigny', '60 Avenue Henri Barbusse', 93000, 'BOBIGNY', 60, '2020-02-29 08:31:46.341+00', '2020-02-29 08:31:46.341+00', 2),
(27256149, 'de Paris société Houram', '243 rue de Paris', 93100, 'MONTREUIL', 0, '2020-02-29 08:31:46.342+00', '2020-02-29 08:31:46.342+00', 2),
(8790785, 'Montreau', '42 rue Maurice Bouchor', 93100, 'MONTREUIL', 18, '2020-02-29 08:31:46.343+00', '2020-02-29 08:31:46.343+00', 2),
(7033289, 'Appart''City - Rosny sous Bois', '7 rue d''Aurion', 93110, 'ROSNY-SOUS-BOIS', 105, '2020-02-29 08:31:46.345+00', '2020-02-29 08:31:46.345+00', 2),
(23563260, 'Prim''s La Courneuve', '80 rue de le Convention', 93120, 'LA COURNEUVE', 83, '2020-02-29 08:31:46.346+00', '2020-02-29 08:31:46.346+00', 2),
(14287604, 'Acostair', '184 avenue du 8 Mai 1945', 93150, 'LE BLANC-MESNIL', 17, '2020-02-29 08:31:46.354+00', '2020-02-29 08:31:46.354+00', 2),
(20660124, 'ParisNord', 'ZAC Garonor rue Anatole Sigonneau', 93150, 'LE BLANC-MESNIL', 72, '2020-02-29 08:31:46.355+00', '2020-02-29 08:31:46.355+00', 2),
(9407695, 'De la Liberté', '173 rue Robespierre', 93170, 'BAGNOLET', 22, '2020-02-29 08:31:46.356+00', '2020-02-29 08:31:46.356+00', 2),
(3607667, 'Europe', '2 rue du Docteur Marbais', 93190, 'LIVRY-GARGAN', 22, '2020-02-29 08:31:46.358+00', '2020-02-29 08:31:46.358+00', 2),
(5296791, 'Au MaryLand', '34 rue Gabriel Peri', 93200, 'SAINT-DENIS', 9, '2020-02-29 08:31:46.359+00', '2020-02-29 08:31:46.359+00', 2),
(251, 'du Parc', '122 rue Danielle Casanova', 93200, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.361+00', '2020-02-29 08:31:46.361+00', 2),
(885126, 'Nouvel Hôtel Saint Denis', '29 rue Ernest Renan', 93200, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.362+00', '2020-02-29 08:31:46.362+00', 2),
(13956672, 'F1 Saint-Denis Stade - H3072', 'Rue de la cokerie - Avenue Francis de Pressencé', 93210, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.363+00', '2020-02-29 08:31:46.363+00', 2),
(4710253, 'le Bon Coin', '1 rue Carnot', 93230, 'ROMAINVILLE', 4, '2020-02-29 08:31:46.365+00', '2020-02-29 08:31:46.365+00', 2),
(91, 'Merylis', '13 boulevard du Général Leclerc', 93260, 'LES LILAS', 20, '2020-02-29 08:31:46.367+00', '2020-02-29 08:31:46.367+00', 2),
(9230021, 'Comfort Inn Sevran', '3 rue Alexei Leonov', 93270, 'SEVRAN', 38, '2020-02-29 08:31:46.368+00', '2020-02-29 08:31:46.368+00', 2),
(1853457, 'du Centre - Aubervilliers', '134 rue des Cités', 93300, 'AUBERVILLIERS', 22, '2020-02-29 08:31:46.369+00', '2020-02-29 08:31:46.369+00', 2),
(5550287, 'Le Triomphe', '53 avenue Jean Jaurès', 93300, 'AUBERVILLIERS', 11, '2020-02-29 08:31:46.377+00', '2020-02-29 08:31:46.377+00', 2),
(20368332, 'Résidence Hoche', '49 rue Charles Nodier', 93310, 'LE PRE-SAINT-GERVAIS', 2, '2020-02-29 08:31:46.379+00', '2020-02-29 08:31:46.379+00', 2),
(24362544, 'Touareg', '52 Avenue de la Division Leclerc', 93350, 'LE BOURGET', 0, '2020-02-29 08:31:46.386+00', '2020-02-29 08:31:46.386+00', 2),
(64481, 'Bel Air Saint-Ouen', '23 rue Palouzier', 93400, 'SAINT-OUEN', 30, '2020-02-29 08:31:46.388+00', '2020-02-29 08:31:46.388+00', 2),
(4561374, 'le Moderne - Saint Ouen', '97 Rue du Docteur Bauer', 93400, 'SAINT-OUEN', 35, '2020-02-29 08:31:46.395+00', '2020-02-29 08:31:46.395+00', 2),
(812726, 'Séoul', '70 rue du Dr Bauer', 93400, 'SAINT-OUEN', 0, '2020-02-29 08:31:46.397+00', '2020-02-29 08:31:46.397+00', 2),
(1867110, 'Zia', '48 avenue Michelet', 93400, 'SAINT-OUEN', 23, '2020-02-29 08:31:46.401+00', '2020-02-29 08:31:46.401+00', 2),
(4793035, 'Le Vert Galand', '7 Avenue de la Gare', 93420, 'VILLEPINTE', 4, '2020-02-29 08:31:46.41+00', '2020-02-29 08:31:46.41+00', 2),
(3583280, 'de Paris - La renaissance', '67 Avenue Jean Lolive', 93500, 'PANTIN', 29, '2020-02-29 08:31:46.411+00', '2020-02-29 08:31:46.411+00', 2),
(4002347, 'Résidence BEAUMARCHAIS', '06 rue des grilles', 93500, 'PANTIN', 100, '2020-02-29 08:31:46.413+00', '2020-02-29 08:31:46.413+00', 2),
(51055, 'Villa 27', '164 avenue Jean Jaurès', 93500, 'PANTIN', 12, '2020-02-29 08:31:46.414+00', '2020-02-29 08:31:46.414+00', 2),
(4327687, 'F1 Aulnay Garonor A1 - H2376', '1 rue Robert Brémond', 93600, 'AULNAY-SOUS-BOIS', 71, '2020-02-29 08:31:46.415+00', '2020-02-29 08:31:46.415+00', 2),
(6949403, 'Le Banco', '84 avenue Henri Barbusse', 93700, 'DRANCY', 0, '2020-02-29 08:31:46.433+00', '2020-02-29 08:31:46.433+00', 2),
(5428639, 'Ilyass', '2 Rue Maurice', 93800, 'EPINAY-SUR-SEINE', 10, '2020-02-29 08:31:46.435+00', '2020-02-29 08:31:46.435+00', 2),
(133, 'Star Arcueil', '110 rue Camille Desmoulins', 94110, 'ARCUEIL', 0, '2020-02-29 08:31:46.436+00', '2020-02-29 08:31:46.436+00', 3),
(4585075, 'LAEZIV Moderne', '10 rue des Carrières', 94120, 'FONTENAY-SOUS-BOIS', 8, '2020-02-29 08:31:46.437+00', '2020-02-29 08:31:46.437+00', 3),
(3917540, 'Ang Houes - réactivé pour audit régio', '42 rue des Ecoles', 94140, 'ALFORTVILLE', 0, '2020-02-29 08:31:46.438+00', '2020-02-29 08:31:46.438+00', 3),
(183, '1ère Classe Villeneuve Saint Georges', '17 rue Louis Armand', 94190, 'VILLENEUVE-SAINT-GEORGES', 0, '2020-02-29 08:31:46.439+00', '2020-02-29 08:31:46.439+00', 3),
(24821600, 'La Lambra - hôtel', '81 Avenue de Choisy', 94190, 'VILLENEUVE SAINT GEORGES', 8, '2020-02-29 08:31:46.44+00', '2020-02-29 08:31:46.44+00', 3),
(7789760, 'Le Melyani', '40 avenue de Verdun', 94200, 'IVRY-SUR-SEINE', 9, '2020-02-29 08:31:46.442+00', '2020-02-29 08:31:46.442+00', 3),
(156, 'Gravel''s', '43 avenue du Maréchal de Lattre de Tassigny', 94220, 'CHARENTON-LE-PONT', 24, '2020-02-29 08:31:46.443+00', '2020-02-29 08:31:46.443+00', 3),
(23527373, 'Le Renouveau (ex Blason)', '30 Avenue de Paris', 94300, 'VINCENNES', 4, '2020-02-29 08:31:46.446+00', '2020-02-29 08:31:46.446+00', 3),
(297, 'Hipotel - Joinville', '1 allée Edmée L''HeureuxZAC des Canadiens', 94340, 'JOINVILLE-LE-PONT', 33, '2020-02-29 08:31:46.447+00', '2020-02-29 08:31:46.447+00', 3),
(21659062, 'SlimHôtel', '42 rue Pierre Semard', 94400, 'VITRY-SUR-SEINE', 0, '2020-02-29 08:31:46.448+00', '2020-02-29 08:31:46.448+00', 3),
(13775404, 'Café de la Gare - Ablon sur Seine', '37 rue du Bac', 94480, 'ABLON SUR SEINE', 2, '2020-02-29 08:31:46.449+00', '2020-02-29 08:31:46.449+00', 3),
(219, 'Relais de Pincevent', '13 Avenue de l''Hippodrome', 94510, 'LA QUEUE-EN-BRIE', 16, '2020-02-29 08:31:46.451+00', '2020-02-29 08:31:46.451+00', 3),
(135, 'Select - Maison Alfort', '12 Bis rue Pierre Sémard', 94700, 'MAISONS-ALFORT', 26, '2020-02-29 08:31:46.452+00', '2020-02-29 08:31:46.452+00', 3),
(25218361, 'Ibis Cergy Pontoise Le Port', '28 avenue des Grouettes', 95000, 'CERGY', 0, '2020-02-29 08:31:46.457+00', '2020-02-29 08:31:46.457+00', 5),
(25495810, 'Hôtel du Stade', '153 bd Général Delambre', 95100, 'ARGENTEUIL', 0, '2020-02-29 08:31:46.458+00', '2020-02-29 08:31:46.458+00', 5),
(25161986, 'SHDI', '148 route de Pontoise', 95100, 'ARGENTEUIL', 44, '2020-02-29 08:31:46.459+00', '2020-02-29 08:31:46.459+00', 5),
(3044806, 'Résidence Garges Stalingrad', '57 Avenue Stalingrad', 95140, 'GARGES-LES-GONESSE', 67, '2020-02-29 08:31:46.46+00', '2020-02-29 08:31:46.46+00', 5),
(14374110, 'Enzo Hôtel', '19 Rue le Corbusier', 95190, 'GOUSSAINVILLE', 85, '2020-02-29 08:31:46.462+00', '2020-02-29 08:31:46.462+00', 5),
(9840352, 'De La Sous Préfecture', '14 Boulevard François Mittérrand', 95200, 'SARCELLES', 12, '2020-02-29 08:31:46.463+00', '2020-02-29 08:31:46.463+00', 5),
(23675865, 'NIRMALA''S', '58BIS rue Carnot', 92100, 'BOULOGNE-BILLANCOURT', 6, '2020-02-29 08:31:46.267+00', '2020-02-29 08:31:46.267+00', 3),
(2218473, 'du Port - audit régio - réactivé', '8 rue du Port', 92110, 'CLICHY', 0, '2020-02-29 08:31:46.269+00', '2020-02-29 08:31:46.269+00', 3),
(106, 'les Andalouses', '22 rue Dagobert', 92110, 'CLICHY', 5, '2020-02-29 08:31:46.27+00', '2020-02-29 08:31:46.27+00', 3),
(51022, 'Le Verdun', '16 avenue de Verdun', 92120, 'MONTROUGE', 0, '2020-02-29 08:31:46.272+00', '2020-02-29 08:31:46.272+00', 3),
(5528804, 'MADO', '80 avenue Victor Cresson', 92130, 'ISSY-LES-MOULINEAUX', 0, '2020-02-29 08:31:46.307+00', '2020-02-29 08:31:46.307+00', 3),
(19935134, 'De la Gare - Meudon', '19 rue Banès', 92190, 'MEUDON', 19, '2020-02-29 08:31:46.31+00', '2020-02-29 08:31:46.31+00', 3),
(25534391, 'Café hôtel de la Cité', '93 avenue des grésillons', 92230, 'GENNEVILLIERS', 0, '2020-02-29 08:31:46.329+00', '2020-02-29 08:31:46.329+00', 3),
(2187408, 'Atlantide', '88 avenue Pierre Brossolette', 92240, 'MALAKOFF', 22, '2020-02-29 08:31:46.33+00', '2020-02-29 08:31:46.33+00', 3),
(6372765, 'Musset', '10 Rue Alfred Musset', 92240, 'MALAKOFF', 0, '2020-02-29 08:31:46.332+00', '2020-02-29 08:31:46.332+00', 3),
(16168803, 'Alexandra', '3 rue Rivay', 92300, 'LEVALLOIS-PERRET', 28, '2020-02-29 08:31:46.333+00', '2020-02-29 08:31:46.333+00', 3),
(20888697, 'des Genêts 2', '117 Bd Saint Denis', 92400, 'COURBEVOIE', 14, '2020-02-29 08:31:46.335+00', '2020-02-29 08:31:46.335+00', 3),
(19935130, 'Bellevue - Rueil-Malmaison', '34 rue Diderot', 92500, 'RUEIL-MALMAISON', 7, '2020-02-29 08:31:46.336+00', '2020-02-29 08:31:46.336+00', 3),
(80086, 'de la Poste - Asnières', '39 rue Gallieni', 92600, 'ASNIERES-SUR-SEINE', 0, '2020-02-29 08:31:46.337+00', '2020-02-29 08:31:46.337+00', 3),
(25535039, 'Hôtel Béranger Colombes', '34 rue Béranger', 92700, 'COLOMBES', 0, '2020-02-29 08:31:46.338+00', '2020-02-29 08:31:46.338+00', 3),
(25534853, 'L''Aviation - audit régio', '90 Rue de Verdun', 92800, 'PUTEAUX', 0, '2020-02-29 08:31:46.339+00', '2020-02-29 08:31:46.339+00', 3),
(13986834, 'Comfort Inn Bobigny', '60 Avenue Henri Barbusse', 93000, 'BOBIGNY', 0, '2020-02-29 08:31:46.34+00', '2020-02-29 08:31:46.34+00', 2),
(1138275, 'd''Anjou', '9 rue de la solidarité', 93100, 'MONTREUIL', 15, '2020-02-29 08:31:46.342+00', '2020-02-29 08:31:46.342+00', 2),
(556560, 'Marceau - Montreuil', '31 rue Garibaldi', 93100, 'MONTREUIL', 0, '2020-02-29 08:31:46.343+00', '2020-02-29 08:31:46.343+00', 2),
(22847186, 'RESIDSOCIAL Arago', '117 rue de Paris', 93100, 'MONTREUIL', 16, '2020-02-29 08:31:46.344+00', '2020-02-29 08:31:46.344+00', 2),
(2420329, 'Le Campus', '23 avenue Victor Hugo', 93120, 'LA COURNEUVE', 4, '2020-02-29 08:31:46.345+00', '2020-02-29 08:31:46.345+00', 2),
(14223260, 'BB Bondy', '90 Avenue Gallieni', 93140, 'BONDY', 26, '2020-02-29 08:31:46.346+00', '2020-02-29 08:31:46.346+00', 2),
(7432846, 'Appart''City - Le Bourget', '158-164, avenue du 8 mai 1945', 93150, 'LE BLANC-MESNIL', 0, '2020-02-29 08:31:46.355+00', '2020-02-29 08:31:46.355+00', 2),
(176, 'Noisy Résidence', 'Esplanade de la commune de Paris', 93160, 'NOISY-LE-GRAND', 164, '2020-02-29 08:31:46.356+00', '2020-02-29 08:31:46.356+00', 2),
(1265157, 'Pixi', '82 avenue de la République', 93170, 'BAGNOLET', 10, '2020-02-29 08:31:46.357+00', '2020-02-29 08:31:46.357+00', 2),
(5566387, 'Royal de Livry Gargan', '85 Boulevard Roger Salengro', 93190, 'LIVRY-GARGAN', 0, '2020-02-29 08:31:46.358+00', '2020-02-29 08:31:46.358+00', 2),
(6891109, 'Carnot', '23 boulevard Carnot', 93200, 'SAINT-DENIS', 5, '2020-02-29 08:31:46.36+00', '2020-02-29 08:31:46.36+00', 2),
(81514, 'Le Relax', '15 avenue Roger Sémat', 93200, 'SAINT-DENIS', 16, '2020-02-29 08:31:46.361+00', '2020-02-29 08:31:46.361+00', 2),
(1960235, 'Suger', '3 rue Suger', 93200, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.363+00', '2020-02-29 08:31:46.363+00', 2),
(4651930, 'ResiStade', '4 rue Jesse Owens', 93210, 'SAINT-DENIS', 116, '2020-02-29 08:31:46.364+00', '2020-02-29 08:31:46.364+00', 2),
(1172382, 'Le Cyrano', '142 avenue de Stalingrad', 93240, 'STAINS', 4, '2020-02-29 08:31:46.366+00', '2020-02-29 08:31:46.366+00', 2),
(7847674, 'Rev Hôtel', '2 bis rue de la République', 93260, 'LES LILAS', 31, '2020-02-29 08:31:46.367+00', '2020-02-29 08:31:46.367+00', 2),
(23541896, 'ALGER''S HOTEL', '24 rue Gaetan Lamy', 93300, 'AUBERVILLIERS', 29, '2020-02-29 08:31:46.368+00', '2020-02-29 08:31:46.368+00', 2),
(4562985, 'Le Couto', '79 Avenue Jean Jaurès', 93300, 'AUBERVILLIERS', 32, '2020-02-29 08:31:46.377+00', '2020-02-29 08:31:46.377+00', 2),
(10479331, 'Strategy Hotels Canal hôtel', '2 rue Heurtault', 93300, 'AUBERVILLIERS', 10, '2020-02-29 08:31:46.378+00', '2020-02-29 08:31:46.378+00', 2),
(4116549, 'LE PETIT PARIS', '178 Avenue Aristide Briand', 93320, 'LES PAVILLONS-SOUS-BOIS', 10, '2020-02-29 08:31:46.384+00', '2020-02-29 08:31:46.384+00', 2),
(14286816, 'Résidence Magister', '1 avenue Lenine', 93380, 'PIERREFITE', 0, '2020-02-29 08:31:46.387+00', '2020-02-29 08:31:46.387+00', 2),
(14287706, 'De La Mairie - Saint Ouen', '3 place de la République', 93400, 'SAINT-OUEN', 15, '2020-02-29 08:31:46.389+00', '2020-02-29 08:31:46.389+00', 2),
(84305, 'Olympic', '105 rue du docteur Bauer', 93400, 'SAINT-OUEN', 17, '2020-02-29 08:31:46.397+00', '2020-02-29 08:31:46.397+00', 2),
(23525950, 'Valcan Ex Trianon', '15 Boulevard Victor Hugo', 93400, 'SAINT-OUEN', 17, '2020-02-29 08:31:46.401+00', '2020-02-29 08:31:46.401+00', 2),
(20921562, 'IJBEL Ex Brit', '25 Allée Louis Bréguet', 93420, 'VILLEPINTE', 51, '2020-02-29 08:31:46.405+00', '2020-02-29 08:31:46.405+00', 2),
(4653198, 'de la Marquise', '4 avenue Edouard Vaillant', 93500, 'PANTIN', 9, '2020-02-29 08:31:46.411+00', '2020-02-29 08:31:46.411+00', 2),
(1535883, 'Lakanal', '5 rue Lakanal', 93500, 'PANTIN', 8, '2020-02-29 08:31:46.412+00', '2020-02-29 08:31:46.412+00', 2),
(52699, 'Résidence Eden', '2 rue François Arago', 93500, 'PANTIN', 5, '2020-02-29 08:31:46.413+00', '2020-02-29 08:31:46.413+00', 2),
(161235, 'Confotel Aulnay', '6 rond point Henri Dunant', 93600, 'AULNAY-SOUS-BOIS', 29, '2020-02-29 08:31:46.415+00', '2020-02-29 08:31:46.415+00', 2),
(286, '1ère Classe Drancy', '10 Rue de Stalingrad', 93700, 'DRANCY', 38, '2020-02-29 08:31:46.433+00', '2020-02-29 08:31:46.433+00', 2),
(7392307, 'Le Repère', '5 avenue Marceau', 93700, 'DRANCY', 8, '2020-02-29 08:31:46.434+00', '2020-02-29 08:31:46.434+00', 2),
(21164695, 'RESIDSOCIAL Foch Le Palmier', '120 avenue Foch angle rue des 2 Boulevards', 94100, 'SAINT-MAUR-DES-FOSSÉS', 26, '2020-02-29 08:31:46.435+00', '2020-02-29 08:31:46.435+00', 3),
(25495893, 'Sympa', '4 avenue François Vincent', 94110, 'ARCUEIL', 0, '2020-02-29 08:31:46.436+00', '2020-02-29 08:31:46.436+00', 3),
(1180885, 'Royal Nogent', '175 grande rue Charles de Gaulle', 94130, 'NOGENT-SUR-MARNE', 14, '2020-02-29 08:31:46.438+00', '2020-02-29 08:31:46.438+00', 3),
(7625607, 'Atlas - Rungis', '12 Avenue de Fontainebleau', 94150, 'RUNGIS', 9, '2020-02-29 08:31:46.439+00', '2020-02-29 08:31:46.439+00', 3),
(1571414, 'KB exOasis', '27 rue Emile Zola', 94190, 'VILLENEUVE-SAINT-GEORGES', 4, '2020-02-29 08:31:46.44+00', '2020-02-29 08:31:46.44+00', 3),
(1353727, 'Gambetta', '9 place Léon Gambetta', 94200, 'IVRY-SUR-SEINE', 26, '2020-02-29 08:31:46.441+00', '2020-02-29 08:31:46.441+00', 3),
(80345, 'Tontonville', '73 avenue Georges Gosnat', 94200, 'IVRY-SUR-SEINE', 23, '2020-02-29 08:31:46.442+00', '2020-02-29 08:31:46.442+00', 3),
(26384587, 'DESIGN BOOKING', '5 rue des Carrières Morillon - ZAC des Vœux St Georges', 94290, 'VILLENEUVE LE ROI', 1, '2020-02-29 08:31:46.444+00', '2020-02-29 08:31:46.444+00', 3),
(24502367, 'De La Gare - Orly', '1 Avenue Aérodrome', 94310, 'ORLY', 2, '2020-02-29 08:31:46.447+00', '2020-02-29 08:31:46.447+00', 3),
(7038525, 'de la Gare - Vitry', '42 rue Pierre Semard', 94400, 'VITRY-SUR-SEINE', 0, '2020-02-29 08:31:46.448+00', '2020-02-29 08:31:46.448+00', 3),
(38, 'Balladins Valenton', '1 rue de la Sablonnière', 94460, 'VALENTON', 55, '2020-02-29 08:31:46.449+00', '2020-02-29 08:31:46.449+00', 3),
(2921538, 'Résidence Tremblay', '99 Avenue du Général de Gaulle', 94500, 'CHAMPIGNY-SUR-MARNE', 31, '2020-02-29 08:31:46.45+00', '2020-02-29 08:31:46.45+00', 3),
(4866879, 'Victor Hugo - Choisy le Roi', '40 avenue Victor Hugo', 94600, 'CHOISY-LE-ROI', 8, '2020-02-29 08:31:46.451+00', '2020-02-29 08:31:46.451+00', 3),
(446500, '1ère Classe Cergy Pontoise', '3 avenue des 3 fontaines', 95000, 'CERGY', 0, '2020-02-29 08:31:46.453+00', '2020-02-29 08:31:46.453+00', 5),
(51197, 'de l''Europe - Argenteuil', '5 place Pierre Sémard', 95100, 'ARGENTEUIL', 49, '2020-02-29 08:31:46.458+00', '2020-02-29 08:31:46.458+00', 5),
(3684549, 'Résidence Argenteuil', '52 avenue de Stalingrad', 95100, 'ARGENTEUIL', 19, '2020-02-29 08:31:46.459+00', '2020-02-29 08:31:46.459+00', 5),
(4311879, 'Résidence Garges Cerdan', '9 rue Marcel Cerdan', 95140, 'GARGES-LES-GONESSE', 76, '2020-02-29 08:31:46.46+00', '2020-02-29 08:31:46.46+00', 5),
(4722656, 'EggHôtel Goussainville', '2 avenue de la Vierge', 95190, 'GOUSSAINVILLE', 0, '2020-02-29 08:31:46.461+00', '2020-02-29 08:31:46.461+00', 5),
(26485985, 'Résidence Le Marceau', '2 Avenue Marceau', 95190, 'GOUSSAINVILLE', 16, '2020-02-29 08:31:46.462+00', '2020-02-29 08:31:46.462+00', 5),
(24855051, 'Ibis Sarcelles Hôtel', '12 avenue Auguste Perret', 95200, 'SARCELLES', 41, '2020-02-29 08:31:46.472+00', '2020-02-29 08:31:46.472+00', 5),
(22519230, 'Ibis Budget Saint Ouen L''Aumône', '4 Allée des 3 Caravelles', 95310, 'SAINT-OUEN L''AUMONE', 18, '2020-02-29 08:31:46.473+00', '2020-02-29 08:31:46.473+00', 5),
(1254053, 'Chez Amar', '10 rue de l Ancienne Mairie', 92110, 'CLICHY', 7, '2020-02-29 08:31:46.268+00', '2020-02-29 08:31:46.268+00', 3),
(25535074, 'Le Morillon', '1 rue de morillon', 92110, 'CLICHY', 0, '2020-02-29 08:31:46.27+00', '2020-02-29 08:31:46.27+00', 3),
(6612425, 'Moderne Clichy - 62', '62 rue de Paris', 92110, 'CLICHY', 15, '2020-02-29 08:31:46.271+00', '2020-02-29 08:31:46.271+00', 3),
(7224252, 'Studélites Gouverneur', '2 rue theophile Gautier', 92120, 'MONTROUGE', 0, '2020-02-29 08:31:46.299+00', '2020-02-29 08:31:46.299+00', 3),
(554069, 'Victor Hugo - Clamart', '166 avenue Victor Hugo', 92140, 'CLAMART', 32, '2020-02-29 08:31:46.309+00', '2020-02-29 08:31:46.309+00', 3),
(1354504, 'Andalouse', '55 Boulevard Camélinat', 92230, 'GENNEVILLIERS', 10, '2020-02-29 08:31:46.324+00', '2020-02-29 08:31:46.324+00', 3),
(4736031, 'Ibis Budget Gennevilliers', '4 rue Georges Corète', 92230, 'GENNEVILLIERS', 8, '2020-02-29 08:31:46.329+00', '2020-02-29 08:31:46.329+00', 3),
(25534473, 'Le Carillon', '38 avenue Pierre Larousse', 92240, 'MALAKOFF', 0, '2020-02-29 08:31:46.331+00', '2020-02-29 08:31:46.331+00', 3),
(25096188, 'Les Jardins de Voltaire', '28 rue Voltaire', 92250, 'GARENNE COLOMBES', 0, '2020-02-29 08:31:46.333+00', '2020-02-29 08:31:46.333+00', 3),
(12425680, 'Béranger', '41 rue Béranger', 92320, 'CHATILLON', 8, '2020-02-29 08:31:46.334+00', '2020-02-29 08:31:46.334+00', 3),
(14378798, 'Saint-Augustin', '94 boulevard de Verdun', 92400, 'COURBEVOIE', 0, '2020-02-29 08:31:46.336+00', '2020-02-29 08:31:46.336+00', 3),
(1763138, 'Résidence Asnières', '50 avenue des Grésillons', 92600, 'ASNIERES-SUR-SEINE', 0, '2020-02-29 08:31:46.337+00', '2020-02-29 08:31:46.337+00', 3),
(5981053, 'Résidence Colombes - chez Gaston', '48 rue Maurice Berteaux', 92700, 'COLOMBES', 14, '2020-02-29 08:31:46.339+00', '2020-02-29 08:31:46.339+00', 3),
(14303523, 'Appart''City Paris Bobigny', '19 Rue Honoré d''Estienne d''Orves', 93000, 'BOBIGNY', 179, '2020-02-29 08:31:46.34+00', '2020-02-29 08:31:46.34+00', 2),
(800748, 'Le Renouveau', '22 avenue Louis Aragon', 93000, 'BOBIGNY', 19, '2020-02-29 08:31:46.341+00', '2020-02-29 08:31:46.341+00', 2),
(2137579, 'du Soleil', '2 rue des Sorins', 93100, 'MONTREUIL', 25, '2020-02-29 08:31:46.342+00', '2020-02-29 08:31:46.342+00', 2),
(980748, 'Résidence de Montreuil', '12 rue du Sergent Godefroy', 93100, 'MONTREUIL', 21, '2020-02-29 08:31:46.344+00', '2020-02-29 08:31:46.344+00', 2),
(14605069, 'BB Le Bourget', '211 avenue Paul Vaillant Couturier', 93120, 'LA COURNEUVE', 0, '2020-02-29 08:31:46.345+00', '2020-02-29 08:31:46.345+00', 2),
(954053, 'Le Petit Noisy', '47 avenue Galliéni', 93130, 'NOISY-LE-SEC', 11, '2020-02-29 08:31:46.346+00', '2020-02-29 08:31:46.346+00', 2),
(801551, 'Air Hôtel', '90 avenue du 8 mai 1945', 93150, 'LE BLANC-MESNIL', 25, '2020-02-29 08:31:46.354+00', '2020-02-29 08:31:46.354+00', 2),
(16267959, 'Résidence Facilia', '18 rue Eugène Varlin', 93150, 'LE BLANC-MESNIL', 11, '2020-02-29 08:31:46.355+00', '2020-02-29 08:31:46.355+00', 2),
(418798, 'F1 Paris Porte de Montreuil - H3488', '290-302 rue Etienne Marcel', 93170, 'BAGNOLET', 0, '2020-02-29 08:31:46.357+00', '2020-02-29 08:31:46.357+00', 2),
(24358186, 'L''Alsace', '5 Boulevard de la République', 93190, 'LIVRY-GARGAN', 0, '2020-02-29 08:31:46.358+00', '2020-02-29 08:31:46.358+00', 2),
(3057762, 'AZEM', '7 Rue Jules Genovesi', 93200, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.359+00', '2020-02-29 08:31:46.359+00', 2),
(284, 'du Square', '28 boulevard Marcel Sembat', 93200, 'SAINT-DENIS', 21, '2020-02-29 08:31:46.361+00', '2020-02-29 08:31:46.361+00', 2),
(5138450, 'Oriental', '49 Boulevard de la Libération', 93200, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.362+00', '2020-02-29 08:31:46.362+00', 2),
(12225371, 'Olympe - 3', '26-28 avenue de la Métallurgie', 93210, 'SAINT-DENIS', 93, '2020-02-29 08:31:46.364+00', '2020-02-29 08:31:46.364+00', 2),
(24365976, 'L''horloge', '28 Rue de Metz', 93230, 'ROMAINVILLE', 2, '2020-02-29 08:31:46.366+00', '2020-02-29 08:31:46.366+00', 2),
(23875242, 'Ile de France Pain d''Or ex Charma', '23 boulevard MAL Leclerc de Hautecloque', 93260, 'LES LILAS', 24, '2020-02-29 08:31:46.366+00', '2020-02-29 08:31:46.366+00', 2),
(6890857, 'Balladins Sevran', '5 rue Alexei Leonov', 93270, 'SEVRAN', 60, '2020-02-29 08:31:46.368+00', '2020-02-29 08:31:46.368+00', 2),
(1264509, 'Clef Monceau', '16 Rue des Ecoles', 93300, 'AUBERVILLIERS', 0, '2020-02-29 08:31:46.369+00', '2020-02-29 08:31:46.369+00', 2),
(2330359, 'Le Rendez vous des Camionneurs', '17 rue de la Haie Coq', 93300, 'AUBERVILLIERS', 15, '2020-02-29 08:31:46.377+00', '2020-02-29 08:31:46.377+00', 2),
(22, 'PRIM''S Ex - Le Bonheur', '5 passage de la Mairie', 93310, 'LE PRE-SAINT-GERVAIS', 31, '2020-02-29 08:31:46.378+00', '2020-02-29 08:31:46.378+00', 2),
(1532368, 'Select - Le Bourget', '39 Rue Anizan Cavillon', 93350, 'LE BOURGET', 11, '2020-02-29 08:31:46.385+00', '2020-02-29 08:31:46.385+00', 2),
(21832132, 'Aux Bons Enfants', '24 rue de la Gaité', 93400, 'SAINT-OUEN', 9, '2020-02-29 08:31:46.388+00', '2020-02-29 08:31:46.388+00', 2),
(151274, 'La Perle Bleue - audit régio réactivé', '39 rue Charles Schmitt', 93400, 'SAINT-OUEN', 0, '2020-02-29 08:31:46.39+00', '2020-02-29 08:31:46.39+00', 2),
(27243042, 'Parisian Hôtels Ex Séoul', '70 rue du Dr Bauer', 93400, 'SAINT-OUEN', 19, '2020-02-29 08:31:46.397+00', '2020-02-29 08:31:46.397+00', 2),
(9967463, 'Victor Hugo - Saint Ouen', '112 Boulevard Victor Hugo', 93400, 'SAINT-OUEN', 16, '2020-02-29 08:31:46.401+00', '2020-02-29 08:31:46.401+00', 2),
(25488192, 'Jardins de Villepinte', '118 bd Robert Ballanger', 93420, 'VILLEPINTE', 0, '2020-02-29 08:31:46.406+00', '2020-02-29 08:31:46.406+00', 2),
(1253617, 'Géode Bleue', '15 rue Magenta', 93500, 'PANTIN', 22, '2020-02-29 08:31:46.412+00', '2020-02-29 08:31:46.412+00', 2),
(8303060, 'Résidence de Pantin', '19 Rue Toffier Decaux', 93500, 'PANTIN', 14, '2020-02-29 08:31:46.413+00', '2020-02-29 08:31:46.413+00', 2),
(25487773, 'Bienvenue', '15 avenue de Nonneville', 93600, 'AULNAY SOUS BOIS', 0, '2020-02-29 08:31:46.414+00', '2020-02-29 08:31:46.414+00', 2),
(20369466, 'Saint Joseph', '56 Avenue de la Croix Blanche', 93600, 'AULNAY-SOUS-BOIS', 11, '2020-02-29 08:31:46.415+00', '2020-02-29 08:31:46.415+00', 2),
(50983, 'Le Marceau - Drancy', '91 avenue Marceau', 93700, 'DRANCY', 14, '2020-02-29 08:31:46.434+00', '2020-02-29 08:31:46.434+00', 2),
(8734005, 'Studélites La Source', '9 avenue François Mitterrand', 94000, 'CRETEIL', 3, '2020-02-29 08:31:46.435+00', '2020-02-29 08:31:46.435+00', 3),
(27143721, 'Star Arcueil - RESADOTEL', '110 rue Camille Desmoulins', 94110, 'ARCUEIL', 33, '2020-02-29 08:31:46.436+00', '2020-02-29 08:31:46.436+00', 3),
(25319044, 'Le Panier Fleuri', '2 avenue de bry', 94130, 'NOGENT SUR MARNE', 0, '2020-02-29 08:31:46.437+00', '2020-02-29 08:31:46.437+00', 3),
(372196, 'Nag-Won', '63 rue Véron', 94140, 'ALFORTVILLE', 8, '2020-02-29 08:31:46.439+00', '2020-02-29 08:31:46.439+00', 3),
(1364834, 'de l''Europe Villeneuve', '104 avenue de Paris', 94190, 'VILLENEUVE-SAINT-GEORGES', 0, '2020-02-29 08:31:46.44+00', '2020-02-29 08:31:46.44+00', 3),
(108463, 'Auberge de l''Europe', '16 rue Saint Just', 94200, 'IVRY-SUR-SEINE', 0, '2020-02-29 08:31:46.441+00', '2020-02-29 08:31:46.441+00', 3),
(11058360, 'SOTEL d''Ivry', '3 rue Maurice Couderchet', 94200, 'IVRY-SUR-SEINE', 15, '2020-02-29 08:31:46.442+00', '2020-02-29 08:31:46.442+00', 3),
(25253582, 'Kyriad Fresnes', '32 avenue de la Division Leclerc', 94260, 'FRESNES', 0, '2020-02-29 08:31:46.443+00', '2020-02-29 08:31:46.443+00', 3),
(6463814, 'Air Plus', '58 Voie Nouvelle', 94310, 'ORLY', 0, '2020-02-29 08:31:46.446+00', '2020-02-29 08:31:46.446+00', 3),
(19935132, 'Confort Hôtel - Jean Jaurès', '89 avenue Jean Jaurès', 94400, 'VITRY-SUR-SEINE', 13, '2020-02-29 08:31:46.448+00', '2020-02-29 08:31:46.448+00', 3),
(249, 'Motélia', '54 avenue Grosbois', 94440, 'MAROLLES-EN-BRIE', 0, '2020-02-29 08:31:46.449+00', '2020-02-29 08:31:46.449+00', 3),
(12526351, 'Résidence Champigny', '201 rue Marcel Paul', 94500, 'CHAMPIGNY-SUR-MARNE', 55, '2020-02-29 08:31:46.45+00', '2020-02-29 08:31:46.45+00', 3),
(959483, 'Nor', '26 rue Auguste Blanqui', 94600, 'CHOISY-LE-ROI', 15, '2020-02-29 08:31:46.451+00', '2020-02-29 08:31:46.451+00', 3),
(25486928, 'Villa Liberté', '5 rue de la Liberté', 94800, 'VILLEJUIF', 0, '2020-02-29 08:31:46.453+00', '2020-02-29 08:31:46.453+00', 3),
(7880928, 'Résidence les Estudines Cergy', '31 rue de l''Aven', 95000, 'CERGY', 7, '2020-02-29 08:31:46.457+00', '2020-02-29 08:31:46.457+00', 5),
(26200411, 'Régina - Argenteuil', '53 rue Henri Barbusse', 95100, 'ARGENTEUIL', 6, '2020-02-29 08:31:46.458+00', '2020-02-29 08:31:46.458+00', 5),
(83974, 'Bonfortel Franconville', 'Chemin de l''ErmitageRue du Capitaine Dreyfus', 95130, 'FRANCONVILLE', 49, '2020-02-29 08:31:46.46+00', '2020-02-29 08:31:46.46+00', 5),
(19935129, 'Bel Hôtel - Le Corbusier', '6-8 rue Le Corbusier', 95190, 'GOUSSAINVILLE', 107, '2020-02-29 08:31:46.461+00', '2020-02-29 08:31:46.461+00', 5),
(19935171, 'Inter-Hôtel Bagatelle', '2 rue Jean Monnet', 95190, 'GOUSSAINVILLE', 6, '2020-02-29 08:31:46.462+00', '2020-02-29 08:31:46.462+00', 5),
(27626182, 'F1 Sarcelles', '1 rue du Vignolle Zone d''Activité', 95200, 'SARCELLES', 56, '2020-02-29 08:31:46.471+00', '2020-02-29 08:31:46.471+00', 5),
(742467, 'Aurore', '1 rue Alexandre Prachay', 95300, 'PONTOISE', 25, '2020-02-29 08:31:46.473+00', '2020-02-29 08:31:46.473+00', 5),
(25439759, 'Bar de La Poste - Persan', '25 rue Pierre brossolette', 95340, 'PERSAN', 0, '2020-02-29 08:31:46.474+00', '2020-02-29 08:31:46.474+00', 5),
(25441385, 'Florence - Clichy', '29 bis rue Cailloux', 92110, 'CLICHY', 0, '2020-02-29 08:31:46.269+00', '2020-02-29 08:31:46.269+00', 3),
(11153116, 'Les Estudines Clichy Victor Hugo', '171 Bd Victor Hugo', 92110, 'CLICHY', 10, '2020-02-29 08:31:46.27+00', '2020-02-29 08:31:46.27+00', 3),
(2030211, 'Paris Orléans', '132 avenue Aristide Briand', 92120, 'MONTROUGE', 24, '2020-02-29 08:31:46.272+00', '2020-02-29 08:31:46.272+00', 3),
(9414797, 'Résidence Studéa Clamart', '360 avenue du général de Gaulle', 92140, 'CLAMART', 10, '2020-02-29 08:31:46.308+00', '2020-02-29 08:31:46.308+00', 3),
(823450, 'Magenta - Saint Cloud', '1 place Magenta', 92210, 'SAINT-CLOUD', 7, '2020-02-29 08:31:46.324+00', '2020-02-29 08:31:46.324+00', 3),
(23876013, 'Gallieni', '18 bis boulevard Gallieni', 92230, 'GENNEVILLIERS', 118, '2020-02-29 08:31:46.329+00', '2020-02-29 08:31:46.329+00', 3),
(25534486, 'De l''Etoile - Malakoff', '45 rue Victor Hugo', 92240, 'MALAKOFF', 0, '2020-02-29 08:31:46.33+00', '2020-02-29 08:31:46.33+00', 3),
(4213640, 'VILLA Hôtel', '14 rue François Coppée', 92240, 'MALAKOFF', 2, '2020-02-29 08:31:46.332+00', '2020-02-29 08:31:46.332+00', 3),
(25534426, 'Somnus', '158 rue Jules Guesde', 92300, 'LEVALLOIS PERRET', 0, '2020-02-29 08:31:46.334+00', '2020-02-29 08:31:46.334+00', 3),
(25533960, 'Mido', '113 boulevard de verdun', 92400, 'COURBEVOIE', 0, '2020-02-29 08:31:46.335+00', '2020-02-29 08:31:46.335+00', 3),
(5711944, 'Victor Hugo - Rueil Malmaison', '41 rue Estienne d''Orves', 92500, 'RUEIL-MALMAISON', 0, '2020-02-29 08:31:46.337+00', '2020-02-29 08:31:46.337+00', 3),
(1648178, 'Confotel Colombes', '17 avenue Henri Barbusse', 92700, 'COLOMBES', 9, '2020-02-29 08:31:46.338+00', '2020-02-29 08:31:46.338+00', 3),
(193, 'Godefroy', '27 rue Godefroy', 92800, 'PUTEAUX', 31, '2020-02-29 08:31:46.339+00', '2020-02-29 08:31:46.339+00', 3),
(800469, 'de Bobigny', '26 Avenue Louis Aragon', 93000, 'BOBIGNY', 30, '2020-02-29 08:31:46.341+00', '2020-02-29 08:31:46.341+00', 2),
(731174, 'de Paris', '243 rue de Paris', 93100, 'MONTREUIL', 2, '2020-02-29 08:31:46.342+00', '2020-02-29 08:31:46.342+00', 2),
(27397286, 'Marceau - Montreuil - Accer IMMO', '31 rue Garibaldi', 93100, 'MONTREUIL', 11, '2020-02-29 08:31:46.343+00', '2020-02-29 08:31:46.343+00', 2),
(2173005, 'Royal Montreuil', '59 rue de Paris', 93100, 'MONTREUIL', 8, '2020-02-29 08:31:46.344+00', '2020-02-29 08:31:46.344+00', 2),
(19846365, 'Le Renouveau - La Courneuve', '58 rue Emile Zola', 93120, 'LA COURNEUVE', 18, '2020-02-29 08:31:46.345+00', '2020-02-29 08:31:46.345+00', 2),
(14004961, '1ère Classe Blanc Mesnil', '219 Avenue Descartes', 93150, 'LE BLANC-MESNIL', 0, '2020-02-29 08:31:46.35+00', '2020-02-29 08:31:46.35+00', 2),
(24357923, 'Le Normandie Niemen', '10 Avenue Normandie Niemen', 93150, 'LE BLANC-MESNIL', 0, '2020-02-29 08:31:46.355+00', '2020-02-29 08:31:46.355+00', 2),
(453885, 'Central - Bagnolet', '215 rue Sadi Carnot', 93170, 'BAGNOLET', 17, '2020-02-29 08:31:46.356+00', '2020-02-29 08:31:46.356+00', 2),
(4998743, 'Campanile LIVRY GARGAN', '119 boulevard Robert Schuman', 93190, 'LIVRY-GARGAN', 20, '2020-02-29 08:31:46.358+00', '2020-02-29 08:31:46.358+00', 2),
(25455193, 'Auberge St Denis', '15 rue de la charronerie', 93200, 'SAINT DENIS', 0, '2020-02-29 08:31:46.359+00', '2020-02-29 08:31:46.359+00', 2),
(5527698, 'De Paris- ST-DENIS', '9 rue Danielle Casanova', 93200, 'SAINT-DENIS', 23, '2020-02-29 08:31:46.36+00', '2020-02-29 08:31:46.36+00', 2),
(207, 'Moderne Caron', '88 rue Landy', 93200, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.362+00', '2020-02-29 08:31:46.362+00', 2),
(5978907, 'Suit''études à Saint Denis', '84 Boulevard Marcel Sembat', 93200, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.363+00', '2020-02-29 08:31:46.363+00', 2),
(241, 'Du Progrès-93', '16 rue de la République', 93230, 'ROMAINVILLE', 17, '2020-02-29 08:31:46.365+00', '2020-02-29 08:31:46.365+00', 2),
(19885581, 'Le Pichet D''Etain', '158 Grande Rue', 93250, 'VILLEMOMBLE', 17, '2020-02-29 08:31:46.366+00', '2020-02-29 08:31:46.366+00', 2),
(24, 'Stars Les Lilas', '17 bis rue Jules David', 93260, 'LES LILAS', 22, '2020-02-29 08:31:46.367+00', '2020-02-29 08:31:46.367+00', 2),
(713205, 'Café du Marché', '22 Rue Ferragus', 93300, 'AUBERVILLIERS', 20, '2020-02-29 08:31:46.369+00', '2020-02-29 08:31:46.369+00', 2),
(2338121, 'le Pilier', '5 rue du pilier', 93300, 'AUBERVILLIERS', 27, '2020-02-29 08:31:46.377+00', '2020-02-29 08:31:46.377+00', 2),
(244, 'Le Surcouf - Le Pré Saint Gervais', '40 rue d''Estienne d''Orves', 93310, 'LE PRE-SAINT-GERVAIS', 11, '2020-02-29 08:31:46.378+00', '2020-02-29 08:31:46.378+00', 2),
(95, 'du Nord', '7 rue du commandant Baroche', 93350, 'LE BOURGET', 56, '2020-02-29 08:31:46.385+00', '2020-02-29 08:31:46.385+00', 2),
(23806744, 'Auberge Yacine', '29 rue Godillot', 93400, 'SAINT-OUEN', 4, '2020-02-29 08:31:46.387+00', '2020-02-29 08:31:46.387+00', 2),
(8813408, 'La Mascotte', '138 avenue Gabriel Péri', 93400, 'SAINT-OUEN', 12, '2020-02-29 08:31:46.39+00', '2020-02-29 08:31:46.39+00', 2),
(5858055, 'Le Séverine', '9 rue Séverine', 93400, 'SAINT-OUEN', 13, '2020-02-29 08:31:46.396+00', '2020-02-29 08:31:46.396+00', 2),
(6206151, 'Tam Hôtel', '20 rue Voltaire', 93400, 'SAINT-OUEN', 28, '2020-02-29 08:31:46.4+00', '2020-02-29 08:31:46.4+00', 2),
(1134590, 'Les Escales de Vaujours', '23, rue de Meaux', 93410, 'VAUJOURS', 0, '2020-02-29 08:31:46.405+00', '2020-02-29 08:31:46.405+00', 2),
(420974, 'Chez Michel', '9 rue Mechin', 93450, 'L''ILE-SAINT-DENIS', 0, '2020-02-29 08:31:46.411+00', '2020-02-29 08:31:46.411+00', 2),
(22527084, 'Le Saint Georges', '11 rue Jules Auffret', 93500, 'PANTIN', 8, '2020-02-29 08:31:46.412+00', '2020-02-29 08:31:46.412+00', 2),
(5941551, 'Royal Pantin', '29 Avenue du général Leclerc', 93500, 'PANTIN', 8, '2020-02-29 08:31:46.414+00', '2020-02-29 08:31:46.414+00', 2),
(25, 'Le 1001 nuits', '12 avenue de la Division Leclerc', 93700, 'DRANCY', 29, '2020-02-29 08:31:46.433+00', '2020-02-29 08:31:46.433+00', 2),
(2354691, 'Des Oiseaux', '1 rue de l''Yser', 93800, 'EPINAY-SUR-SEINE', 0, '2020-02-29 08:31:46.434+00', '2020-02-29 08:31:46.434+00', 2),
(420980, 'Des Pyrénées', '131 Avenue Aristide Briand', 94110, 'ARCUEIL', 2, '2020-02-29 08:31:46.436+00', '2020-02-29 08:31:46.436+00', 3),
(248, 'Green Hôtel - 94', '18 avenue Rabelais', 94120, 'FONTENAY-SOUS-BOIS', 9, '2020-02-29 08:31:46.437+00', '2020-02-29 08:31:46.437+00', 3),
(22851999, 'ZZZPoudlard', '2 avenue kleber', 94130, 'NOGENT-SUR-MARNE', 1, '2020-02-29 08:31:46.438+00', '2020-02-29 08:31:46.438+00', 3),
(25253563, 'Grillardin', '175 boulevard Alsace Lorraine', 94170, 'LE PERREUX SUR MARNE', 0, '2020-02-29 08:31:46.439+00', '2020-02-29 08:31:46.439+00', 3),
(27551876, 'La Lambra - Appartement', '81 Avenue de Choisy', 94190, 'VILLENEUVE SAINT GEORGES', 7, '2020-02-29 08:31:46.44+00', '2020-02-29 08:31:46.44+00', 3),
(6098993, 'Le Kleber', '44 Rue Raspail', 94200, 'IVRY-SUR-SEINE', 10, '2020-02-29 08:31:46.441+00', '2020-02-29 08:31:46.441+00', 3),
(2163605, 'zzzaurelie', '59, rue ledru rollin', 94200, 'PARIS', 0, '2020-02-29 08:31:46.443+00', '2020-02-29 08:31:46.443+00', 3),
(12030089, 'De La Prévoyance', '31 rue de la Prévoyance', 94300, 'VINCENNES', 10, '2020-02-29 08:31:46.446+00', '2020-02-29 08:31:46.446+00', 3),
(19935133, 'ConfortHôtel - Constant Coquelin', '110 rue Constant Coquelin', 94400, 'VITRY-SUR-SEINE', 10, '2020-02-29 08:31:46.447+00', '2020-02-29 08:31:46.447+00', 3),
(1377154, 'Appart''City Saint Maurice', '18 Rue Du Marechal Leclerc', 94410, 'SAINT-MAURICE', 0, '2020-02-29 08:31:46.449+00', '2020-02-29 08:31:46.449+00', 3),
(25488096, 'Lyess', '69 rue du Plessis Trévise', 94500, 'CHAMPIGNY SUR MARNE', 0, '2020-02-29 08:31:46.45+00', '2020-02-29 08:31:46.45+00', 3),
(24586199, 'LES GONDOLES', '36 rue Jean Bouin', 94600, 'CHOISY LE ROI', 1, '2020-02-29 08:31:46.451+00', '2020-02-29 08:31:46.451+00', 3),
(161, 'GRAND PARIS Ex France 2', '33 avenue Louis Aragon', 94800, 'VILLEJUIF', 15, '2020-02-29 08:31:46.452+00', '2020-02-29 08:31:46.452+00', 3),
(23542903, 'Berbère Hôtel Argenteuil', '225 rue Henri Barbusse', 95100, 'ARGENTEUIL', 20, '2020-02-29 08:31:46.457+00', '2020-02-29 08:31:46.457+00', 5),
(25531755, 'Rehana', '160 avenue Jean Jaurès', 95100, 'ARGENTEUIL', 0, '2020-02-29 08:31:46.459+00', '2020-02-29 08:31:46.459+00', 5),
(25253412, 'Néo Hôtel', '1 avenue Ambroise Croizat', 95140, 'GARGES-LES-GONESSE', 43, '2020-02-29 08:31:46.46+00', '2020-02-29 08:31:46.46+00', 5),
(1743995, 'de France', '1 bis rue Ferdinand Buisson', 95190, 'GOUSSAINVILLE', 38, '2020-02-29 08:31:46.461+00', '2020-02-29 08:31:46.461+00', 5),
(5546429, 'Le Médian', '2 rue Ferdinand de Lesseps', 95190, 'GOUSSAINVILLE', 55, '2020-02-29 08:31:46.462+00', '2020-02-29 08:31:46.462+00', 5),
(3496104, 'Hôtel et Résidence Sarcelles', '1 Rue du père Heude', 95200, 'SARCELLES', 18, '2020-02-29 08:31:46.472+00', '2020-02-29 08:31:46.472+00', 5),
(5234210, '1ère Classe Saint Ouen l''Aumône', 'Cité de l''Auto - rue Louise Weiss', 95310, 'SAINT-OUEN-L''AUMONE', 57, '2020-02-29 08:31:46.473+00', '2020-02-29 08:31:46.473+00', 5),
(418050, 'Chemin de l''espoir ex Les Doublets d''Or', '1 rue Hadancourt', 95340, 'PERSAN', 9, '2020-02-29 08:31:46.474+00', '2020-02-29 08:31:46.474+00', 5),
(193469, 'de Louvres', '94 rue de Paris', 95380, 'LOUVRES', 42, '2020-02-29 08:31:46.477+00', '2020-02-29 08:31:46.477+00', 5),
(1260465, 'Bonfortel Pierrelaye - PTS', '20 rue Fernand Léger ZA Les Primevères', 95480, 'PIERRELAYE', 34, '2020-02-29 08:31:46.478+00', '2020-02-29 08:31:46.478+00', 5),
(1285486, 'Fasthome', '1 avenue Georges Pompidou', 95500, 'GONESSE', 54, '2020-02-29 08:31:46.48+00', '2020-02-29 08:31:46.48+00', 5),
(25534491, 'Jaihka Clichy', '8 rue du 19 mars 1962', 92110, 'CLICHY', 0, '2020-02-29 08:31:46.269+00', '2020-02-29 08:31:46.269+00', 3),
(253, 'Moderne Clichy', '28 rue de Paris', 92110, 'CLICHY', 18, '2020-02-29 08:31:46.271+00', '2020-02-29 08:31:46.271+00', 3),
(3075068, 'Régina', '15 place des Etats Unis', 92120, 'MONTROUGE', 15, '2020-02-29 08:31:46.272+00', '2020-02-29 08:31:46.272+00', 3),
(151, 'Paris Porte de Versailles', '22 villa Marguerite', 92130, 'ISSY-LES-MOULINEAUX', 27, '2020-02-29 08:31:46.308+00', '2020-02-29 08:31:46.308+00', 3),
(25241551, 'Coq Hardi', '91 avenue Pierre Brossolette', 92210, 'MONTROUGE', 0, '2020-02-29 08:31:46.315+00', '2020-02-29 08:31:46.315+00', 3),
(4566388, 'du Parc ex Union - réactivé pour audit régio', '30 rue Julien Masselier', 92230, 'GENNEVILLIERS', 0, '2020-02-29 08:31:46.329+00', '2020-02-29 08:31:46.329+00', 3),
(245, 'de la Gare - Malakoff', '13 avenue Arblade', 92240, 'MALAKOFF', 10, '2020-02-29 08:31:46.33+00', '2020-02-29 08:31:46.33+00', 3),
(608975, 'Parc Even', '14 rue Laforest', 92240, 'MALAKOFF', 6, '2020-02-29 08:31:46.332+00', '2020-02-29 08:31:46.332+00', 3),
(25501632, 'Le 421', '18 rue Pierre Brossolette', 92300, 'LEVALLOIS PERRET', 0, '2020-02-29 08:31:46.334+00', '2020-02-29 08:31:46.334+00', 3),
(5110666, 'L''Auberge Berbère', '121 Boulevard de Verdun', 92400, 'COURBEVOIE', 0, '2020-02-29 08:31:46.335+00', '2020-02-29 08:31:46.335+00', 3),
(3058270, 'Les Coquelicots', '145 avenue du 18 juin 1940', 92500, 'RUEIL-MALMAISON', 0, '2020-02-29 08:31:46.336+00', '2020-02-29 08:31:46.336+00', 3),
(1858005, 'Voltaire - Asnières', '81 boulevard Voltaire', 92600, 'ASNIERES-SUR-SEINE', 0, '2020-02-29 08:31:46.338+00', '2020-02-29 08:31:46.338+00', 3),
(37, 'Cartault', '21 rue Cartault', 92800, 'PUTEAUX', 0, '2020-02-29 08:31:46.339+00', '2020-02-29 08:31:46.339+00', 3),
(24860232, 'Arim Hôtel', '5-13 avenue Henri Barbusse', 93000, 'BOBIGNY', 69, '2020-02-29 08:31:46.34+00', '2020-02-29 08:31:46.34+00', 2),
(14005934, '1ère Classe Montreuil', '64 rue Jean Lolive', 93100, 'MONTREUIL', 5, '2020-02-29 08:31:46.341+00', '2020-02-29 08:31:46.341+00', 2),
(216066, 'Le Grilladin', '66 avenue du Président Wilson', 93100, 'MONTREUIL', 21, '2020-02-29 08:31:46.343+00', '2020-02-29 08:31:46.343+00', 2),
(50996, 'RESIDSERVICE (Montreuil Mge) (Hôtel du Centre)', '117 rue de Paris', 93100, 'MONTREUIL', 0, '2020-02-29 08:31:46.344+00', '2020-02-29 08:31:46.344+00', 2),
(1294430, 'la Perle', '03 boulevard Pasteur', 93120, 'LA COURNEUVE', 0, '2020-02-29 08:31:46.345+00', '2020-02-29 08:31:46.345+00', 2),
(800523, 'les Voyageurs', '2 boulevard de la République', 93130, 'NOISY-LE-SEC', 28, '2020-02-29 08:31:46.346+00', '2020-02-29 08:31:46.346+00', 2),
(1267729, 'Appart''City Blanc Mesnil', '219 avenue Descartes', 93150, 'LE BLANC-MESNIL', 152, '2020-02-29 08:31:46.354+00', '2020-02-29 08:31:46.354+00', 2),
(25488473, 'Le Relais de Noisy', '19 bd du Maréchal Foch', 93160, 'NOISY LE GRAND', 7, '2020-02-29 08:31:46.355+00', '2020-02-29 08:31:46.355+00', 2),
(800619, 'Les Pernelles', '35 rue des Pernelles', 93170, 'BAGNOLET', 6, '2020-02-29 08:31:46.357+00', '2020-02-29 08:31:46.357+00', 2),
(20368560, 'Le Rousseau', '37 rue Eugène Mass', 93190, 'LIVRY-GARGAN', 17, '2020-02-29 08:31:46.358+00', '2020-02-29 08:31:46.358+00', 2),
(1171954, 'Campanile Saint-Denis', '14 rue Jean Jaurès', 93200, 'SAINT-DENIS', 113, '2020-02-29 08:31:46.36+00', '2020-02-29 08:31:46.36+00', 2),
(4256549, 'Euro Sovereign Saint-Denis', '100102 rue Gabriel Péri', 93200, 'SAINT-DENIS', 24, '2020-02-29 08:31:46.361+00', '2020-02-29 08:31:46.361+00', 2),
(230, 'Renan', '27 rue Ernest Renan', 93200, 'SAINT-DENIS', 9, '2020-02-29 08:31:46.362+00', '2020-02-29 08:31:46.362+00', 2),
(51668, 'Président Wilson', '67 avenue du Président Wilson', 93210, 'SAINT-DENIS', 0, '2020-02-29 08:31:46.364+00', '2020-02-29 08:31:46.364+00', 2),
(155, 'Paladin', '10 rue de la Fraternité', 93230, 'ROMAINVILLE', 120, '2020-02-29 08:31:46.366+00', '2020-02-29 08:31:46.366+00', 2),
(4858329, 'Moderne Les Lilas', '111 avenue Pasteur', 93260, 'LES LILAS', 27, '2020-02-29 08:31:46.367+00', '2020-02-29 08:31:46.367+00', 2),
(23322079, 'SGS HOTELS - Egg Hôtel Sevran', '1 rue Alexis Leonov', 93270, 'SEVRAN', 40, '2020-02-29 08:31:46.368+00', '2020-02-29 08:31:46.368+00', 2),
(740087, 'La Planète Bleue', '126 avenue de la République', 93300, 'AUBERVILLIERS', 13, '2020-02-29 08:31:46.371+00', '2020-02-29 08:31:46.371+00', 2),
(252, 'Moderne Aubervilliers', '111 rue Léopold Réchossière', 93300, 'AUBERVILLIERS', 22, '2020-02-29 08:31:46.378+00', '2020-02-29 08:31:46.378+00', 2),
(25445312, 'Chevalier de la barre', '75 allée du chevalier de la barre', 93320, 'PAVILLONS SOUS BOIS', 1, '2020-02-29 08:31:46.379+00', '2020-02-29 08:31:46.379+00', 2),
(19884838, 'Le Gouraya', '84 avenue Victor Hugo', 93360, 'NEUILLY-PLAISANCE', 11, '2020-02-29 08:31:46.386+00', '2020-02-29 08:31:46.386+00', 2),
(1077433, 'Belle Etoile', '23 rue Emile Zola', 93400, 'SAINT-OUEN', 28, '2020-02-29 08:31:46.389+00', '2020-02-29 08:31:46.389+00', 2),
(1084602, 'Le Prestige', '15 rue Lecuyer', 93400, 'SAINT-OUEN', 23, '2020-02-29 08:31:46.396+00', '2020-02-29 08:31:46.396+00', 2),
(9415502, 'Studéa Saint Ouen', '3-4 rue Aimé Césaire', 93400, 'SAINT-OUEN', 0, '2020-02-29 08:31:46.4+00', '2020-02-29 08:31:46.4+00', 2),
(3057757, 'Le Marrakech Awal', '260 Rue de Meaux', 93410, 'VAUJOURS', 8, '2020-02-29 08:31:46.404+00', '2020-02-29 08:31:46.404+00', 2),
(7880901, 'Résidence Les Estudines André Désilles', '21 rue Marguerite Yourcenar', 93430, 'VILLETANEUSE', 11, '2020-02-29 08:31:46.41+00', '2020-02-29 08:31:46.41+00', 2),
(1260407, 'Le Magistral', '17 Rue Magenta', 93500, 'PANTIN', 18, '2020-02-29 08:31:46.412+00', '2020-02-29 08:31:46.412+00', 2),
(8359032, 'Résidence les 3 Pantin', '146 avenue Jean Jaurès', 93500, 'PANTIN', 27, '2020-02-29 08:31:46.413+00', '2020-02-29 08:31:46.413+00', 2),
(23889821, 'De Strasbourg ex Citotel de Strasbourg', '43 rue de Strasbourg', 93600, 'AULNAY-SOUS-BOIS', 8, '2020-02-29 08:31:46.415+00', '2020-02-29 08:31:46.415+00', 2),
(4895265, 'du Globe Drancy', '69 rue de la République', 93700, 'DRANCY', 13, '2020-02-29 08:31:46.433+00', '2020-02-29 08:31:46.433+00', 2),
(416059, 'Le Soleil Levant - audit régio - réactivé', '6 avenue Henri Barbusse', 93700, 'DRANCY', 0, '2020-02-29 08:31:46.434+00', '2020-02-29 08:31:46.434+00', 2),
(80087, 'Central Park', '94 avenue Paul Vaillant Couturier', 94110, 'ARCUEIL', 59, '2020-02-29 08:31:46.435+00', '2020-02-29 08:31:46.435+00', 3),
(181035, 'Le Mont Saint Michel', '25 rue Paul Bert', 94130, 'NOGENT-SUR-MARNE', 4, '2020-02-29 08:31:46.437+00', '2020-02-29 08:31:46.437+00', 3),
(3173231, 'Appart''City Alfortville', '2 rue du capitaine Alfred Dreyfus', 94140, 'ALFORTVILLE', 104, '2020-02-29 08:31:46.438+00', '2020-02-29 08:31:46.438+00', 3),
(238, 'de la Gare - Villeneuve Saint Georges', '24 place Pierre Semard', 94190, 'VILLENEUVE-SAINT-GEORGES', 0, '2020-02-29 08:31:46.439+00', '2020-02-29 08:31:46.439+00', 3),
(15797187, 'RevHotel Villeneuve st Georges', '288 rue de Paris', 94190, 'VILLENEUVE-SAINT-GEORGES', 9, '2020-02-29 08:31:46.441+00', '2020-02-29 08:31:46.441+00', 3),
(24593631, 'Mr AOUAT Salim', '92 boulevard Paul Vaillant Couturier', 94200, 'IVRY-SUR-SEINE', 0, '2020-02-29 08:31:46.442+00', '2020-02-29 08:31:46.442+00', 3),
(13992521, 'Les Académies du Val de Bièvre', '4 Mail des Tilleuls', 94250, 'GENTILLY', 7, '2020-02-29 08:31:46.443+00', '2020-02-29 08:31:46.443+00', 3),
(24480015, 'La Source', '34 rue Paul Vaillant Couturier', 94310, 'ORLY', 0, '2020-02-29 08:31:46.447+00', '2020-02-29 08:31:46.447+00', 3),
(4417689, 'F1 Vitry - H2500', '132 rue Julian Grimau', 94400, 'VITRY-SUR-SEINE', 41, '2020-02-29 08:31:46.448+00', '2020-02-29 08:31:46.448+00', 3),
(234, '1ère Classe Boissy Saint Léger', '4 rue Pompadour', 94470, 'BOISSY-SAINT-LEGER', 0, '2020-02-29 08:31:46.449+00', '2020-02-29 08:31:46.449+00', 3),
(22551388, 'Ambiance Hôtel', '8 rue André Citroën', 94510, 'LA QUEUE-EN-BRIE', 38, '2020-02-29 08:31:46.45+00', '2020-02-29 08:31:46.45+00', 3),
(259, 'RESIDSOCIAL Jean Jaurès', '164 rue Jean Jaurès', 94700, 'MAISONS-ALFORT', 17, '2020-02-29 08:31:46.452+00', '2020-02-29 08:31:46.452+00', 3),
(24988906, 'Hôtel Résidence Divarius', '46bis-48 rue Nationale', 95000, 'CERGY', 14, '2020-02-29 08:31:46.453+00', '2020-02-29 08:31:46.453+00', 5),
(25095967, 'Kyriad Argenteuil', '35 boulevard du général Leclerc', 95100, 'ARGENTEUIL', 1, '2020-02-29 08:31:46.458+00', '2020-02-29 08:31:46.458+00', 5),
(4997664, 'des deux Gares', '86 bis rue Raoul Dautry', 95120, 'ERMONT', 14, '2020-02-29 08:31:46.459+00', '2020-02-29 08:31:46.459+00', 5),
(22512102, 'Brasserie de la Mairie HBM Associés', '209 rue de Paris', 95150, 'TAVERNY', 15, '2020-02-29 08:31:46.461+00', '2020-02-29 08:31:46.461+00', 5),
(14038432, 'Ibis Budget Goussainville', '19 Rue le Corbusier', 95190, 'GOUSSAINVILLE', 24, '2020-02-29 08:31:46.462+00', '2020-02-29 08:31:46.462+00', 5),
(1359742, 'EggHôtel Sarcelles', 'Avenue de La Division Leclerc', 95200, 'SARCELLES', 42, '2020-02-29 08:31:46.471+00', '2020-02-29 08:31:46.471+00', 5),
(981874, 'Du Village ex de la Paix - Beaumont', '29 Rue Albert 1er', 95260, 'BEAUMONT-SUR-OISE', 5, '2020-02-29 08:31:46.472+00', '2020-02-29 08:31:46.472+00', 5),
(6407680, 'Le Saint Louis - Saint Ouen L''Aumône', '4 avenue du général De Gaulle', 95310, 'SAINT-OUEN-L''AUMONE', 12, '2020-02-29 08:31:46.474+00', '2020-02-29 08:31:46.474+00', 5),
(237103, '1ère Classe Herblay', '4 rue René Cotty', 95220, 'HERBLAY', 10, '2020-02-29 08:31:46.472+00', '2020-02-29 08:31:46.472+00', 5),
(23777747, 'Ile de France Hôtel', '70 rue du Général Leclerc', 95310, 'SAINT OUEN L''AUMÔNE', 0, '2020-02-29 08:31:46.473+00', '2020-02-29 08:31:46.473+00', 5),
(25359096, 'Le Bel Air - St-Brice-sous-Forêt', '67 Avenue Du Général De Gaulle', 95350, 'SAINT BRICE SOUS FORET', 21, '2020-02-29 08:31:46.475+00', '2020-02-29 08:31:46.475+00', 5),
(3663576, 'FE', '8 avenue des Erables', 95400, 'VILLIERS-LE-BEL', 29, '2020-02-29 08:31:46.477+00', '2020-02-29 08:31:46.477+00', 5),
(52823, 'IBIS budget - Pierrelaye', 'RN 14 - ZA La Porte Ouest', 95480, 'PIERRELAYE', 14, '2020-02-29 08:31:46.479+00', '2020-02-29 08:31:46.479+00', 5),
(25170031, 'Les Marronniers', '2 rue Gabriel Péri', 95500, 'GONESSE', 18, '2020-02-29 08:31:46.48+00', '2020-02-29 08:31:46.48+00', 5),
(80532, 'Résidhôtel Andilly', '5 Route de la Berchère', 95580, 'ANDILLY', 74, '2020-02-29 08:31:46.481+00', '2020-02-29 08:31:46.481+00', 5),
(3999238, 'Hôtel et Résidence Cergy Saint Christophe', '45 Avenue de Genottes', 95800, 'CERGY', 48, '2020-02-29 08:31:46.483+00', '2020-02-29 08:31:46.483+00', 5),
(25253598, 'Le Continental', '92 rue Jean Jaurès', 95870, 'BEZONS', 22, '2020-02-29 08:31:46.484+00', '2020-02-29 08:31:46.484+00', 5),
(25218532, 'Le Refuge', '4 avenue Jean Jaurès', 95340, 'PERSAN', 22, '2020-02-29 08:31:46.474+00', '2020-02-29 08:31:46.474+00', 5),
(194218, 'Comfort Villiers', '5 avenue des érables', 95400, 'VILLIERS-LE-BEL', 38, '2020-02-29 08:31:46.477+00', '2020-02-29 08:31:46.477+00', 5),
(25441226, 'Café de la mairie', '2 rue bessancourt', 95480, 'PIERRELAYE', 0, '2020-02-29 08:31:46.479+00', '2020-02-29 08:31:46.479+00', 5),
(8092364, 'Le Pont Chinois', '107 rue de Paris', 95500, 'LE THILLAY', 11, '2020-02-29 08:31:46.48+00', '2020-02-29 08:31:46.48+00', 5),
(3663412, 'Best Hôtel', 'ZAC LES PONTS DE BAILLET', 95560, 'BAILLET-EN-FRANCE', 6, '2020-02-29 08:31:46.481+00', '2020-02-29 08:31:46.481+00', 5),
(3512689, 'Hôtel et Résidence Cergy Préfecture', '6 rue des Linandes Pourpres', 95800, 'CERGY', 51, '2020-02-29 08:31:46.482+00', '2020-02-29 08:31:46.482+00', 5),
(25253406, 'Ibis budget - Bezons Rives De Seine', '219 rue Michel Carré', 95870, 'BEZONS', 0, '2020-02-29 08:31:46.484+00', '2020-02-29 08:31:46.484+00', 5),
(1032808, 'l''Express', '62 boulevard de la Gare', 95350, 'SAINT-BRICE-SOUS-FORET', 14, '2020-02-29 08:31:46.476+00', '2020-02-29 08:31:46.476+00', 5),
(15096915, 'Le Babylone Hôtel ex Eurhôtel', '10 avenue Jean Laugère', 95400, 'ARNOUVILLE', 32, '2020-02-29 08:31:46.477+00', '2020-02-29 08:31:46.477+00', 5),
(669128, 'Quick Palace Akena', '14 Route de Conflans', 95480, 'PIERRELAYE', 8, '2020-02-29 08:31:46.479+00', '2020-02-29 08:31:46.479+00', 5),
(1644672, 'les Relais Bleus', '7 route de l''Europe D902', 95500, 'GONESSE', 57, '2020-02-29 08:31:46.481+00', '2020-02-29 08:31:46.481+00', 5),
(1257403, 'Bonfortel Eaubonne ex Balladin', '16 Bis Avenue de Paris', 95600, 'EAUBONNE', 2, '2020-02-29 08:31:46.482+00', '2020-02-29 08:31:46.482+00', 5),
(3604140, 'Résidence Le Chat Perché', '34 Boulevard de l''oise', 95800, 'CERGY', 67, '2020-02-29 08:31:46.483+00', '2020-02-29 08:31:46.483+00', 5),
(25488045, 'Le RELAXE', '31 RUE CASIMIR PERIER', 95870, 'BEZONS', 0, '2020-02-29 08:31:46.484+00', '2020-02-29 08:31:46.484+00', 5),
(291, 'Première Classe Saint-Brice-sous-Forêt', 'Rue Du Champ Gallois', 95350, 'SAINT-BRICE-SOUS-FORET', 34, '2020-02-29 08:31:46.476+00', '2020-02-29 08:31:46.476+00', 5),
(26479516, 'Bonfortel Pierrelaye - Direct', '20 rue Fernand Léger ZA Les Primevères', 95480, 'PIERRELAYE', 8, '2020-02-29 08:31:46.478+00', '2020-02-29 08:31:46.478+00', 5),
(5009917, 'EggHôtel Gonesse', 'RN 17 La Patte d''oie', 95500, 'GONESSE', 0, '2020-02-29 08:31:46.48+00', '2020-02-29 08:31:46.48+00', 5),
(3785389, 'Les Beaux Soleils', '9 Chaussée Jules César', 95520, 'OSNY', 0, '2020-02-29 08:31:46.481+00', '2020-02-29 08:31:46.481+00', 5),
(1377047, 'Appart''City Cergy', '52 boulevard de l''évasion', 95800, 'CERGY', 107, '2020-02-29 08:31:46.482+00', '2020-02-29 08:31:46.482+00', 5),
(4128055, 'STUDEA CERGY GENOTTES', '42 AVENUE DES GENOTTES', 95800, 'CERGY', 24, '2020-02-29 08:31:46.483+00', '2020-02-29 08:31:46.483+00', 5),
(27153271, 'Zola 45', '39 rue Emile Zola', 95871, 'BEZONS', 50, '2020-02-29 08:31:46.484+00', '2020-02-29 08:31:46.484+00', 5),
(3153240, 'Lemon Mery sur Oise', 'ZA Les bosquets 2 et 4', 95540, 'MERY-SUR-OISE', 55, '2020-02-29 08:31:46.481+00', '2020-02-29 08:31:46.481+00', 5),
(1101162, 'Cergy Hôtel', '3 allée du Promenoir BP8344', 95800, 'CERGY', 22, '2020-02-29 08:31:46.482+00', '2020-02-29 08:31:46.482+00', 5),
(805214, 'Bellevues - Bezons', '57 rue de Sartrouville', 95870, 'BEZONS', 3, '2020-02-29 08:31:46.483+00', '2020-02-29 08:31:46.483+00', 5),
(65878, 'zzzhotelniko', '324 rue lecourbe', 75015, 'PARIS', 0, '2020-02-29 08:31:46.088+00', '2020-02-29 08:31:46.088+00', 1),
(6953001, 'Cyrano Nollet', '58 Rue Nollet', 75017, 'PARIS', 7, '2020-02-29 08:31:46.092+00', '2020-02-29 08:31:46.092+00', 1),
(164, 'de Savoy - 17', '21 rue des Dames', 75017, 'PARIS', 0, '2020-02-29 08:31:46.095+00', '2020-02-29 08:31:46.095+00', 1),
(19815767, 'IBIS Paris 17 Clichy-Batignolles', '10 Rue Bernard Buffet', 75017, 'PARIS', 0, '2020-02-29 08:31:46.097+00', '2020-02-29 08:31:46.097+00', 1),
(15506958, 'Nini', '31 rue de l''écluse', 75017, 'PARIS', 6, '2020-02-29 08:31:46.099+00', '2020-02-29 08:31:46.099+00', 1),
(256, 'Sahel Le Relais', '159 avenue de Clichy', 75017, 'PARIS', 6, '2020-02-29 08:31:46.107+00', '2020-02-29 08:31:46.107+00', 1),
(47869, 'Alliance', '52 rue des Cloys', 75018, 'PARIS', 26, '2020-02-29 08:31:46.109+00', '2020-02-29 08:31:46.109+00', 1),
(48460, 'de France 18', '51-53 boulevard Barbès', 75018, 'PARIS', 0, '2020-02-29 08:31:46.111+00', '2020-02-29 08:31:46.111+00', 1),
(117, 'de Rohan', '90 rue Myrha', 75018, 'PARIS', 12, '2020-02-29 08:31:46.113+00', '2020-02-29 08:31:46.113+00', 1),
(49158, 'du Trône', '9 rue Houdon', 75018, 'PARIS', 20, '2020-02-29 08:31:46.115+00', '2020-02-29 08:31:46.115+00', 1),
(25486992, 'Hôtel Azur', '20 rue ramey', 75018, 'PARIS', 0, '2020-02-29 08:31:46.117+00', '2020-02-29 08:31:46.117+00', 1),
(52251, 'le Hameau Montmartrois', '6 rue du Chevalier de la Barre', 75018, 'PARIS', 0, '2020-02-29 08:31:46.118+00', '2020-02-29 08:31:46.118+00', 1),
(5430438, 'Muller', '11 rue Feutrier', 75018, 'PARIS', 0, '2020-02-29 08:31:46.12+00', '2020-02-29 08:31:46.12+00', 1),
(7392316, 'Paris Résidence - 18', '20 rue du Pôle Nord', 75018, 'PARIS', 9, '2020-02-29 08:31:46.124+00', '2020-02-29 08:31:46.124+00', 1),
(1260377, 'Résidence Saint-Bernard', '12 rue Myrha', 75018, 'PARIS', 19, '2020-02-29 08:31:46.125+00', '2020-02-29 08:31:46.125+00', 1),
(23373334, 'Sogestho 7 Poteau', '7 Rue du Poteau', 75018, 'PARIS', 22, '2020-02-29 08:31:46.127+00', '2020-02-29 08:31:46.127+00', 1),
(7044882, 'Villa Hôtel Beaulieu', '7-9 Rue du Capitaine Madon', 75018, 'PARIS', 24, '2020-02-29 08:31:46.128+00', '2020-02-29 08:31:46.128+00', 1),
(4815821, 'BB Porte de la Villette', '4 rue Emile Reynaud', 75019, 'PARIS', 0, '2020-02-29 08:31:46.134+00', '2020-02-29 08:31:46.134+00', 1),
(48909, 'du 32', '32 rue du docteur Potain', 75019, 'PARIS', 38, '2020-02-29 08:31:46.155+00', '2020-02-29 08:31:46.155+00', 1),
(52696, 'Le Cristal', '245 rue Crimée', 75019, 'PARIS', 0, '2020-02-29 08:31:46.157+00', '2020-02-29 08:31:46.157+00', 1),
(153, 'Rhin et Danube 19ème', '3 place Rhin et Danube', 75019, 'PARIS', 16, '2020-02-29 08:31:46.166+00', '2020-02-29 08:31:46.166+00', 1),
(15929464, 'de la Mare', '20 rue de la Mare', 75020, 'PARIS', 25, '2020-02-29 08:31:46.178+00', '2020-02-29 08:31:46.178+00', 1),
(19263394, 'Le Paris Vingt', '6 Rue Dupont de l''Eure', 75020, 'PARIS', 22, '2020-02-29 08:31:46.18+00', '2020-02-29 08:31:46.18+00', 1),
(3697019, 'Montana', '81 rue des Pyrénées', 75020, 'PARIS', 3, '2020-02-29 08:31:46.181+00', '2020-02-29 08:31:46.181+00', 1),
(7923060, 'Sofiane', '66 boulevard de Charonne', 75020, 'PARIS', 5, '2020-02-29 08:31:46.185+00', '2020-02-29 08:31:46.185+00', 1),
(3563954, 'Confort-Meaux', '33 boulevard du Chevalier Bayard', 77100, 'MEAUX', 36, '2020-02-29 08:31:46.186+00', '2020-02-29 08:31:46.186+00', 4),
(24507866, 'RHVS - Charles PEGUY - LRDV - Penchard', '4 chemin de la Mare Lorin', 77124, 'PENCHARD', 65, '2020-02-29 08:31:46.188+00', '2020-02-29 08:31:46.188+00', 4),
(3664276, 'Balladins Savigny Le Temple', '159 rue de L''industrie', 77176, 'SAVIGNY-LE-TEMPLE', 0, '2020-02-29 08:31:46.19+00', '2020-02-29 08:31:46.19+00', 4),
(25861542, 'Budget Hôtel Dammarie Les Lys', '32 avenue André Ampère', 77190, 'DAMMARIE LES LYS', 67, '2020-02-29 08:31:46.191+00', '2020-02-29 08:31:46.191+00', 4),
(930549, 'Lemon Longperrier', 'ZA du Pré de la Noue', 77230, 'LONGPERRIER', 0, '2020-02-29 08:31:46.193+00', '2020-02-29 08:31:46.193+00', 4),
(5125410, 'Comfort Hôtel Apollonia', '27 rue de la Saussaie', 77310, 'SAINT-FARGEAU-PONTHIERRY', 8, '2020-02-29 08:31:46.194+00', '2020-02-29 08:31:46.194+00', 4),
(8781311, 'Hayttun', '1, Avenue du Général Leclerc', 77360, 'VAIRES-SUR-MARNE', 13, '2020-02-29 08:31:46.195+00', '2020-02-29 08:31:46.195+00', 4),
(19072072, 'Espérance', '5-7 rue Saint Furcy', 77400, 'LAGNY-SUR-MARNE', 13, '2020-02-29 08:31:46.197+00', '2020-02-29 08:31:46.197+00', 4),
(7481499, 'La Vieille Halle', '1 rue Voltaire', 77460, 'SOUPPES SUR LOING', 18, '2020-02-29 08:31:46.198+00', '2020-02-29 08:31:46.198+00', 4),
(24561448, 'Welcomotel Chelles', '2 rue de l''Ormeteau', 77500, 'CHELLES', 41, '2020-02-29 08:31:46.199+00', '2020-02-29 08:31:46.199+00', 4),
(1206832, 'Pol Hôtel', '105 rue Bertaux', 77610, 'FONTENAY-TRESIGNY', 38, '2020-02-29 08:31:46.202+00', '2020-02-29 08:31:46.202+00', 4),
(19935240, 'Airport Hôtel', '15 rue du Bois', 77990, 'MAUREGARD', 0, '2020-02-29 08:31:46.203+00', '2020-02-29 08:31:46.203+00', 4),
(26428801, 'Aladin Les Mureaux - Direct', '2 rue Levassor', 78130, 'LES MUREAUX', 24, '2020-02-29 08:31:46.216+00', '2020-02-29 08:31:46.216+00', 5),
(4343658, 'Welcomotel Les Mureaux', '11 rue Levassor', 78130, 'LES MUREAUX', 40, '2020-02-29 08:31:46.217+00', '2020-02-29 08:31:46.217+00', 5),
(25170249, 'Hôtel Le Strasbourg', '36 rue de Strasbourg', 78200, 'MANTES LA JOLIE', 4, '2020-02-29 08:31:46.218+00', '2020-02-29 08:31:46.218+00', 5),
(20527602, 'Comfort Hôtel Poissy', '6 Rue Gustave Eiffel', 78300, 'POISSY', 48, '2020-02-29 08:31:46.221+00', '2020-02-29 08:31:46.221+00', 5),
(2972733, 'L''Ermitage - Poissy', '93 boulevard Robespierre', 78300, 'POISSY', 20, '2020-02-29 08:31:46.222+00', '2020-02-29 08:31:46.222+00', 5),
(14959327, '1ère Classe Plaisir', 'Rue des Poiriers - Zac De Sainte Apolline', 78370, 'PLAISIR', 0, '2020-02-29 08:31:46.224+00', '2020-02-29 08:31:46.224+00', 5),
(5033615, 'Confotel Limay', 'Rue Jean-Pierre Timbaud', 78520, 'LIMAY', 43, '2020-02-29 08:31:46.225+00', '2020-02-29 08:31:46.225+00', 5),
(949480, 'Chanteloup Andrésy', '42 bis rue d''Andrésy', 78570, 'CHANTELOUP-LES-VIGNES', 62, '2020-02-29 08:31:46.226+00', '2020-02-29 08:31:46.226+00', 5),
(19935176, 'La Rose des Sables', '33 boulevard Armand Leprince', 78700, 'CONFLANS-SAINTE-HONORINE', 10, '2020-02-29 08:31:46.227+00', '2020-02-29 08:31:46.227+00', 5),
(14373893, 'La Passerelle', '60 rue Robespierre', 78800, 'HOUILLES', 12, '2020-02-29 08:31:46.229+00', '2020-02-29 08:31:46.229+00', 5),
(24654178, 'Aux Petits Ponts', '1 Avenue Darblay', 91100, 'CORBEIL ESSONNES', 5, '2020-02-29 08:31:46.23+00', '2020-02-29 08:31:46.23+00', 4),
(24902477, 'Du Musée Saint Jean - RESAO', '28 rue widmer', 91100, 'CORBEIL ESSONNES', 10, '2020-02-29 08:31:46.232+00', '2020-02-29 08:31:46.232+00', 4),
(1262936, 'Le Louisiane', '63 boulevard Henri Dunant', 91100, 'CORBEIL-ESSONNES', 59, '2020-02-29 08:31:46.233+00', '2020-02-29 08:31:46.233+00', 4),
(27551923, 'Sasotel - hôtel', '23 rue widmer', 91100, 'CORBEIL ESSONNES', 2, '2020-02-29 08:31:46.234+00', '2020-02-29 08:31:46.234+00', 4),
(26379349, 'Du lac - PTS', '2 rue du Pont Neuf', 91160, 'SAULX-LES-CHARTREUX', 6, '2020-02-29 08:31:46.235+00', '2020-02-29 08:31:46.235+00', 4),
(27551838, 'Le Sporting - Appartement', '51 Rue Pierre et Marie Curie', 91170, 'VIRY-CHATILLON', 5, '2020-02-29 08:31:46.237+00', '2020-02-29 08:31:46.237+00', 4),
(3354561, 'Citotel La Rotonde', '25 bis rue Henri Pinson', 91200, 'ATHIS-MONS', 6, '2020-02-29 08:31:46.251+00', '2020-02-29 08:31:46.251+00', 4),
(8805065, 'La bulle d''or', '54 rue du docteur Babin', 91220, 'BRETIGNY-SUR-ORGE', 5, '2020-02-29 08:31:46.252+00', '2020-02-29 08:31:46.252+00', 4),
(24985547, 'Copacabana', '36 avenue Jean Jaurès', 91230, 'MONTGERON', 1, '2020-02-29 08:31:46.254+00', '2020-02-29 08:31:46.254+00', 4),
(803397, 'Mondhôtel Tigery', '2 Boulevard des Pays Bas', 91250, 'TIGERY', 58, '2020-02-29 08:31:46.255+00', '2020-02-29 08:31:46.255+00', 4),
(15590051, 'Balladins Vigneux', '2 rue de la porte de l''écluse', 91270, 'VIGNEUX-SUR-SEINE', 46, '2020-02-29 08:31:46.256+00', '2020-02-29 08:31:46.256+00', 4),
(3456916, 'Ibis Budget Grigny', '10 Avenue des Tuileries', 91350, 'GRIGNY', 34, '2020-02-29 08:31:46.257+00', '2020-02-29 08:31:46.257+00', 4),
(27834307, 'Les Bords De L''Orge - appartement', '7 rue de savigny', 91390, 'MORSANG-SUR-ORGE', 0, '2020-02-29 08:31:46.258+00', '2020-02-29 08:31:46.258+00', 4),
(1704948, 'LOGIGNY', '80 rue Gabriel Péri', 91430, 'IGNY', 43, '2020-02-29 08:31:46.26+00', '2020-02-29 08:31:46.26+00', 4),
(6573888, 'F1 Crosne Créteil Villeneuve Saint Georges - H2498', '1 rue des investisseurs', 91560, 'CROSNE', 0, '2020-02-29 08:31:46.261+00', '2020-02-29 08:31:46.261+00', 4),
(25253390, 'Au Coin d''Or', '2 rue du Mail', 91600, 'SAVIGNY-SUR-ORGE', 4, '2020-02-29 08:31:46.262+00', '2020-02-29 08:31:46.262+00', 4),
(138, '1ère Classe Fleury Merogis', 'Lotissement la Greffière', 91700, 'FLEURY-MEROGIS', 0, '2020-02-29 08:31:46.263+00', '2020-02-29 08:31:46.263+00', 4),
(27216425, 'L''Auberge du Canotier', '96 route nationale', 91800, 'BRUNOY', 4, '2020-02-29 08:31:46.264+00', '2020-02-29 08:31:46.264+00', 4),
(4473784, 'Itinéraires', '19 rue Salvator Allende', 92000, 'NANTERRE', 0, '2020-02-29 08:31:46.266+00', '2020-02-29 08:31:46.266+00', 3),
(14378772, 'Aguesseau', '86 rue d''Aguesseau', 92100, 'BOULOGNE-BILLANCOURT', 0, '2020-02-29 08:31:46.267+00', '2020-02-29 08:31:46.267+00', 3),
(25229294, 'Abdouche', '102 rue de Paris', 92110, 'CLICHY', 0, '2020-02-29 08:31:46.268+00', '2020-02-29 08:31:46.268+00', 3);
DROP TABLE IF EXISTS "parkings";
DROP SEQUENCE IF EXISTS parkings_id_seq;
CREATE SEQUENCE parkings_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."parkings" (
"id" integer DEFAULT nextval('parkings_id_seq') NOT NULL,
"address" character varying(128) NOT NULL,
"zip_code" integer NOT NULL,
"city" character varying(128) NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
CONSTRAINT "parkings_address_key" UNIQUE ("address"),
CONSTRAINT "parkings_pkey" PRIMARY KEY ("id")
) WITH (oids = false);
INSERT INTO "parkings" ("id", "address", "zip_code", "city", "created_at", "updated_at") VALUES
(1, '59 rue ledru Rollin', 94200, 'Ivry sur seine', '2020-02-29 08:31:46.056+00', '2020-02-29 08:31:46.056+00');
DROP TABLE IF EXISTS "roles";
DROP SEQUENCE IF EXISTS roles_id_seq;
CREATE SEQUENCE roles_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."roles" (
"id" integer DEFAULT nextval('roles_id_seq') NOT NULL,
"name" character varying(128) NOT NULL,
"level" integer NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
CONSTRAINT "roles_name_key" UNIQUE ("name"),
CONSTRAINT "roles_pkey" PRIMARY KEY ("id")
) WITH (oids = false);
INSERT INTO "roles" ("id", "name", "level", "created_at", "updated_at") VALUES
(2, 'Médiateur', 2, '2020-02-29 08:31:46.054+00', '2020-02-29 08:31:46.054+00'),
(1, 'admin', 1, '2020-02-29 08:31:46.053+00', '2020-02-29 08:31:46.053+00'),
(3, 'Médiateur SAS', 2, '2020-02-29 08:31:46.055+00', '2020-02-29 08:31:46.055+00'),
(4, 'Intervenant Terrain', 2, '2020-02-29 08:31:46.055+00', '2020-02-29 08:31:46.055+00');
DROP TABLE IF EXISTS "sectors";
DROP SEQUENCE IF EXISTS sectors_id_seq;
CREATE SEQUENCE sectors_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."sectors" (
"id" integer DEFAULT nextval('sectors_id_seq') NOT NULL,
"name" character varying(128) NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
CONSTRAINT "sectors_name_key" UNIQUE ("name"),
CONSTRAINT "sectors_pkey" PRIMARY KEY ("id")
) WITH (oids = false);
INSERT INTO "sectors" ("id", "name", "created_at", "updated_at") VALUES
(1, '75', '2020-02-29 08:31:46.056+00', '2020-02-29 08:31:46.056+00'),
(2, '93', '2020-02-29 08:31:46.057+00', '2020-02-29 08:31:46.057+00'),
(3, '92-94', '2020-02-29 08:31:46.058+00', '2020-02-29 08:31:46.058+00'),
(4, '77-91', '2020-02-29 08:31:46.058+00', '2020-02-29 08:31:46.058+00'),
(5, '78-95', '2020-02-29 08:31:46.059+00', '2020-02-29 08:31:46.059+00');
DROP TABLE IF EXISTS "team_compositions";
DROP SEQUENCE IF EXISTS team_compositions_id_seq;
CREATE SEQUENCE team_compositions_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."team_compositions" (
"id" integer DEFAULT nextval('team_compositions_id_seq') NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
"user_id" integer,
"team_id" integer,
CONSTRAINT "team_compositions_pkey" PRIMARY KEY ("id"),
CONSTRAINT "team_compositions_user_id_team_id_key" UNIQUE ("user_id", "team_id"),
CONSTRAINT "team_compositions_team_id_fkey" FOREIGN KEY (team_id) REFERENCES teams(id) ON UPDATE CASCADE ON DELETE CASCADE NOT DEFERRABLE,
CONSTRAINT "team_compositions_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE NOT DEFERRABLE
) WITH (oids = false);
DROP TABLE IF EXISTS "teams";
DROP SEQUENCE IF EXISTS teams_id_seq;
CREATE SEQUENCE teams_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."teams" (
"id" integer DEFAULT nextval('teams_id_seq') NOT NULL,
"name" character varying(128) NOT NULL,
"date" timestamptz NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
"sector_id" integer,
CONSTRAINT "teams_pkey" PRIMARY KEY ("id"),
CONSTRAINT "teams_sector_id_fkey" FOREIGN KEY (sector_id) REFERENCES sectors(id) ON UPDATE CASCADE ON DELETE SET NULL NOT DEFERRABLE
) WITH (oids = false);
DROP TABLE IF EXISTS "users";
DROP SEQUENCE IF EXISTS users_id_seq;
CREATE SEQUENCE users_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."users" (
"id" integer DEFAULT nextval('users_id_seq') NOT NULL,
"name" character varying(128) NOT NULL,
"lastname" character varying(128) NOT NULL,
"address" character varying(128) NOT NULL,
"email" character varying(128) NOT NULL,
"password" character varying(128) NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
"role_id" integer,
"sector_id" integer,
CONSTRAINT "users_email_key" UNIQUE ("email"),
CONSTRAINT "users_pkey" PRIMARY KEY ("id"),
CONSTRAINT "users_role_id_fkey" FOREIGN KEY (role_id) REFERENCES roles(id) ON UPDATE CASCADE ON DELETE SET NULL NOT DEFERRABLE,
CONSTRAINT "users_sector_id_fkey" FOREIGN KEY (sector_id) REFERENCES sectors(id) ON UPDATE CASCADE ON DELETE SET NULL NOT DEFERRABLE
) WITH (oids = false);
INSERT INTO "users" ("id", "name", "lastname", "address", "email", "password", "created_at", "updated_at", "role_id", "sector_id") VALUES
(1, 'Anouck', 'Salarié 2', '8 RUE AUGUSTE BLANQUI, 93170 BAGNOLET', 'anouck.salarie-2@ssdp.net', '$2b$10$cSq.W4EbKDuX3Yow9U9CTee3UNNEBUNAVw6H2BcSJukeyuLDxyQOy', '2020-02-29 08:31:52.851+00', '2020-02-29 08:31:52.851+00', 4, 2),
(2, 'Eric', 'Salarié 1', '11 AVENUE MINERVE, 91170 VIRY CHATILLON', 'eric.salarie-1@ssdp.net', '$2b$10$dTxQoHlkA2.ednc4lyUhDeMv5trm75Jp3pXjei5y.XJufWKJ.FupC', '2020-02-29 08:31:52.868+00', '2020-02-29 08:31:52.868+00', 2, 1),
(3, 'Patricia', 'Salarié 3', '23 RUE DE UNNA, 91120 PALAISEAU', 'patricia.salarie-3@ssdp.net', '$2b$10$y65DFUWZXD0ILmjdC32tG.UjBzuGlAsjcjZ0erauPA05WH1Ws2/.u', '2020-02-29 08:31:52.869+00', '2020-02-29 08:31:52.869+00', 2, 3),
(4, 'Quebuathe', 'Salarié 4', '126 BOULEVARD Jean Jaures, 92110 CLICHY', 'quebuathe.salarie-4@ssdp.net', '$2b$10$VUEF2O4fxzlHi5.WFnXqSeblRM9kGfytK2T4NWXxiHX42pG1bWIu2', '2020-02-29 08:31:52.869+00', '2020-02-29 08:31:52.869+00', 4, 3),
(5, 'Vanessa', 'Salarié 5', '15 ALLÉE LEO FERRE, 94450 LIMEIL BREVANNES', 'vanessa.salarie-5@ssdp.net', '$2b$10$m/Li05GtPG/i8MhG49XwO.zZNPImxIPQfnGvEgHPmIhSnLW6d1x9K', '2020-02-29 08:31:53.157+00', '2020-02-29 08:31:53.157+00', 4, 4),
(6, 'Cécile', 'Salarié 6', '35 RUE DU CYCLE, 93140 BONDY', 'cecile.salarie-6@ssdp.net', '$2b$10$Hj0Fpdb3.ZBNJQTdUtWe4.YkLGYIoNF28Y/WgGJeL9W/WKfChYYMy', '2020-02-29 08:31:53.17+00', '2020-02-29 08:31:53.17+00', 2, 2),
(7, 'Youssouf', 'Salarié 9', '146 RUE RAYMOND LOSSERAND, 75014 PARIS', 'youssouf.salarie-9@ssdp.net', '$2b$10$5ykSNX1Gx/ZJ/Z3UZaCT3uP9qITuQ8p947DRjQQrsIkPzpYf9ENWS', '2020-02-29 08:31:53.201+00', '2020-02-29 08:31:53.201+00', 4, 1),
(8, 'Stéphane', 'Salarié 11', '26 RUE LA FAYETTE, 91100 CORBEIL ESSONNES', 'stephane.salarie-11@ssdp.net', '$2b$10$YakJ25MXoqXeP1rtZ95UUOBS49sPj7ufPwK2zyyQIFIxx8DzsE3Bm', '2020-02-29 08:31:53.509+00', '2020-02-29 08:31:53.509+00', 4, 1),
(9, 'Mokrane', 'Salarié 8', '7 RUE CHARLES PEGUY, 94460 VALENTON', 'mokrane.salarie-8@ssdp.net', '$2b$10$lSQe18tZwhRnL.AOTRF3L.YUmvkvxEslEesaal5.BSKFGYcQqoSvq', '2020-02-29 08:31:53.228+00', '2020-02-29 08:31:53.228+00', 4, 2),
(10, 'Cathie', 'Salarié 12', '2 RUE RAOUL DELATRE, 94290 VILLENEUVE LE ROI', 'cathie.salarie-12@ssdp.net', '$2b$10$vGPRHTCwfQtqAG8dHyCHKunsDpQh/oWf05qT631ws2Oc.TcrpgN86', '2020-02-29 08:31:53.509+00', '2020-02-29 08:31:53.509+00', 3, 2),
(11, 'Léo', 'Salarié 17', '6 RUE MORNAY, 75004 PARIS', 'leo.salarie-17@ssdp.net', '$2b$10$UoTe1G1Nw6iwkZhEX.5bm.MeFxahTGgo0nWHPUI4GFbgQAhCbgzW2', '2020-02-29 08:31:53.87+00', '2020-02-29 08:31:53.87+00', 4, 3),
(12, 'Aminata', 'Salarié 16', '10 RUE LOUISE AGLAE CRETTE , 94400 VITRY-SUR-SEINE', 'aminata.salarie-16@ssdp.net', '$2b$10$zPjDGIQu1s9SPAJNf48Orum1WELYwTpalAIZStx1sRZeS0FJ4zq06', '2020-02-29 08:31:53.87+00', '2020-02-29 08:31:53.87+00', 2, 3),
(13, 'Scharazed', 'Salarié 15', '16 RUE GEORGES BIZET, 78000 VERSAILLES', 'scharazed.salarie-15@ssdp.net', '$2b$10$g9NAPRXY494FuivwVK2.Ju6Xu4Igc4JaJpKqOEc0DSxS0K10X73F2', '2020-02-29 08:31:53.566+00', '2020-02-29 08:31:53.566+00', 3, 5),
(14, 'Camila', 'Salarié 13', '19 BOULEVARD DE NOISY LE GRAND, 93460 GOURNAY-SUR-MARNE', 'camila.salarie-13@ssdp.net', '$2b$10$zPQM0nZ.6CRmWTChYKI9vuzYE5lYEoYd1WxCfkr2rPfAvhdFqWPIG', '2020-02-29 08:31:53.534+00', '2020-02-29 08:31:53.534+00', 3, 3),
(15, 'Audrey', 'Salarié 14', '93 RUE CHARLES INFROIT, 94400 VITRY SUR SEINE', 'audrey.salarie-14@ssdp.net', '$2b$10$Cq/4XtEy/VNFo8R/ynwsce9qTNsAvdv9J6Kh3Ter7vOxOIP5NE79C', '2020-02-29 08:31:53.883+00', '2020-02-29 08:31:53.883+00', 2, 3),
(16, 'Sarah', 'Salarié 19', '23 RUE DES COURONNES, 75020 PARIS', 'sarah.salarie-19@ssdp.net', '$2b$10$LsSE3D/KUVLKlid2.e/i6e9pENiJUcEfno/b2Kx9GRhqQJDX58zje', '2020-02-29 08:31:54.043+00', '2020-02-29 08:31:54.043+00', 2, 1),
(17, 'Sarah', 'Salarié 21', '9 RUE DEMANIEUX, 94600 CHOISY LE ROI', 'sarah.salarie-21@ssdp.net', '$2b$10$59.Nb/wVVRRcpY2cI59AvO/pJKdY7DnkfPVtHnALOKz9KwLbdYXa.', '2020-02-29 08:31:54.864+00', '2020-02-29 08:31:54.864+00', 4, 3),
(18, 'Patricia', 'Salarié 22', '14 BIS AVENUE DE BRY, 94170 PERREUX-SUR-MARNE', 'patricia.salarie-22@ssdp.net', '$2b$10$oz470HmPoaNSDyBZV6I.CuFyGiCxmDrBNT5R1RtXZFeCQ/P8TIqI.', '2020-02-29 08:31:54.841+00', '2020-02-29 08:31:54.841+00', 4, 5),
(19, 'Sonise', 'Salarié 20', '41 RUE DES PINSONS, 94000 CRETEIL', 'sonise.salarie-20@ssdp.net', '$2b$10$vw.kqNeLdUs419Po5.AcfOGu6b0.e9byUPA5XfN8Y9nC4wNciDvd6', '2020-02-29 08:31:55.121+00', '2020-02-29 08:31:55.121+00', 2, 2),
(20, 'Rhani', 'Salarié 23', '144 RUE DU FAUBOURG BANNIER, 45000 ORLEANS', 'rhani.salarie-23@ssdp.net', '$2b$10$dxRXXX5HkvLbZWzinilL.uFsDNPkDuKgwTuA7LbZkqRonjGQV57FG', '2020-02-29 08:31:55.128+00', '2020-02-29 08:31:55.128+00', 2, 1),
(21, 'Oumar', 'Salarié 26', '31 RUE DES JUMELAGES, 10000 TROYES', 'oumar.salarie-26@ssdp.net', '$2b$10$BIYDrRd2z54N6eewx9WEYuUZA.rw5ggQ4ZJE41NHf1ktLPrwFYX1m', '2020-02-29 08:31:55.385+00', '2020-02-29 08:31:55.385+00', 4, 5),
(22, 'Grzegorz', 'Salarié 25', '74 RUE PELLEPORT , 75020 PARIS', 'grzegorz.salarie-25@ssdp.net', '$2b$10$xtPteNmXpmybu33oep8oc.24t6t.71edGloTMOmfqYkW.V7mkFpPu', '2020-02-29 08:31:55.385+00', '2020-02-29 08:31:55.385+00', 2, 5),
(23, 'Ludovic', 'Salarié 24', '130 AVENUE DANIELLE CASANOVA, 94200 IVRY-SUR-SEINE', 'ludovic.salarie-24@ssdp.net', '$2b$10$0eM8uPHh4BXInmAzFQvV5OG7goCwRsA6UNuC1j7m1sUGvhGtMVnhG', '2020-02-29 08:31:55.385+00', '2020-02-29 08:31:55.385+00', 2, 1),
(24, 'Clément', 'Salarié 27', '5 RUE DU CLOS SAINT-VINCENT, 93460 GOURNAY-SUR-MARNE', 'clement.salarie-27@ssdp.net', '$2b$10$8dmIu.vq3dSfGsHQuA2USuj4fa4W32skKgsOYquUO8VOWZ9grGFxG', '2020-02-29 08:31:55.461+00', '2020-02-29 08:31:55.461+00', 4, 2),
(25, 'Sophie', 'Salarié 30', '20 RUE DE L''UNION, 94140 ALFORTVILLE', 'sophie.salarie-30@ssdp.net', '$2b$10$FoC9UqxZwa0sGLii4IApm.XBFdZdFgYbL/Jtn96BcSKRCnha9l0Xm', '2020-02-29 08:31:55.461+00', '2020-02-29 08:31:55.461+00', 2, 4),
(26, 'Béchir', 'Salarié 33', '5 BIS RUE DE NEUVILLE, 94500 CHAMPIGNY-SUR-MARNE', 'bechir.salarie-33@ssdp.net', '$2b$10$urE05gS0CYE6vpWfMysrWujPitc5cDMLMAkmXWg2stJbjb1stnBRC', '2020-02-29 08:31:55.725+00', '2020-02-29 08:31:55.725+00', 2, 1),
(27, 'Thierry', 'Salarié 32', '7 CHEMIN DES FAUVETTES, 93470 COUBRON', 'thierry.salarie-32@ssdp.net', '$2b$10$ElQCYnCn0ZIuxy2iHZto/u.jVcEfcBPsM5XFuWalp3i0gE81AciZK', '2020-02-29 08:31:55.773+00', '2020-02-29 08:31:55.773+00', 2, 2),
(28, 'Jeannette', 'Salarié 28', '168 RUE DE CHARENTON, 75012 PARIS', 'jeannette.salarie-28@ssdp.net', '$2b$10$Rlt8vF8k3JEV9a9JBmrO8uwJnjkJZ6QLYFNi6U8UW0SfVVTaae3pu', '2020-02-29 08:31:55.773+00', '2020-02-29 08:31:55.773+00', 4, 1),
(29, 'Jonathan', 'Salarié 31', '7 AVENUE MALLERET JOINVILLE, 94140 ALFORTVILLE', 'jonathan.salarie-31@ssdp.net', '$2b$10$oL8SpHlGiMTDXJ0I4FIxEuLWclJbywx9W.yXPekDsg00.plaClo0W', '2020-02-29 08:31:56.011+00', '2020-02-29 08:31:56.011+00', 4, 4),
(30, 'Anna', 'Salarié 29', '11 RUE DU PRÉSIDENT KENNEDY, 94220 CHARENTON-LE-PONT', 'anna.salarie-29@ssdp.net', '$2b$10$TlAuKVLWzVuZVRydqPqo3OavcoZDoZIwCW3KMnXVgrRlXyTWs6Ony', '2020-02-29 08:31:55.805+00', '2020-02-29 08:31:55.805+00', 3, 1),
(31, 'Leila', 'Salarié 35', '8 AVENUE HENRI BARBUSSE, 94400 VITRY-SUR-SEINE', 'leila.salarie-35@ssdp.net', '$2b$10$zSIMdKfQnfEzgisXkfafxOEWc99Edk3A3aWYGwmOrx2FDXyahTjRa', '2020-02-29 08:31:56.079+00', '2020-02-29 08:31:56.079+00', 2, 2),
(32, 'Flora', 'Salarié 37', '9 QUATER PLACE DU GÉNÉRAL DE GAULLE, 93100 MONTREUIL', 'flora.salarie-37@ssdp.net', '$2b$10$xYtfw42LkXBrMukMQfqyIOAsa9VtdErN8UqzsLprnm3NpoYWhoS3.', '2020-02-29 08:31:56.105+00', '2020-02-29 08:31:56.105+00', 4, 1),
(33, 'Alain', 'Salarié 34', '5 RUE JULES HARDOUIN MANSART, 92600 ASNIERES SUR SEINE', 'alain.salarie-34@ssdp.net', '$2b$10$t0blQ.lLJt9Ne2JrqsjKZ.60stAI1pIkrNOaXCWuNa0rL/rq5Qw.O', '2020-02-29 08:31:56.106+00', '2020-02-29 08:31:56.106+00', 4, 2),
(34, 'Nora', 'Salarié 36', '44 RUE DE BERCY, 75012 PARIS', 'nora.salarie-36@ssdp.net', '$2b$10$I17k4Ez9X1TMoIpRMezX5eL0jC0SNaUIRPkXmSx9VvlJ6E/TbGH6a', '2020-02-29 08:31:56.301+00', '2020-02-29 08:31:56.301+00', 2, 4),
(35, 'Morgane', 'Salarié 38', '13 RUE DU GRAND PRE, 78690 ESSARTS-LE-ROI', 'morgane.salarie-38@ssdp.net', '$2b$10$Ye1t5Otm/WCDj6tJeSv07ucX7b3Pqnt5AtXNVVFVMTJpewnh2xxvq', '2020-02-29 08:31:56.355+00', '2020-02-29 08:31:56.355+00', 2, 3),
(36, 'Dominique', 'Salarié 39', '16 RUE RASPAIL, 94200 IVRY-SUR-SEINE', 'dominique.salarie-39@ssdp.net', '$2b$10$n7ARr9SwCJo1EdwcC2BxBOklUAcIOkFGGm/bYWetLuqkWGxR2eMJG', '2020-02-29 08:31:56.394+00', '2020-02-29 08:31:56.394+00', 4, 5),
(38, 'Rehan', 'Salarié 40', '112 AVENUE DU GENERAL LECLERC, 75014 PARIS', 'rehan.salarie-40@ssdp.net', '$2b$10$g2QltXAX/FV/HLNkUWRyEO7Y0yefvmi/oPg0v/hUv/VJKjZthc9by', '2020-02-29 08:31:56.507+00', '2020-02-29 08:31:56.507+00', 4, 2),
(37, 'Ramdane', 'Salarié 42', '1 RUE DE L HOTEL DE VILLE, 92400 COURBEVOIE', 'ramdane.salarie-42@ssdp.net', '$2b$10$eLcITlG8JCesywkvJXmonuItQ29D5WOYidwH2txl52dahxFCfEqLa', '2020-02-29 08:31:56.675+00', '2020-02-29 08:31:56.675+00', 4, 1),
(39, 'Jacques-Philippe', 'Salarié 41', '16 BIS RUE HENRI ROL TANGUY, 91350 GRIGNY', 'jacques-philippe.salarie-41@ssdp.net', '$2b$10$cYYbv.zJUytGVGLGFiiI5OBasBr8EVqAusDZL..Knr83yQ0jC3UAO', '2020-02-29 08:31:56.738+00', '2020-02-29 08:31:56.738+00', 4, 4),
(41, 'Georgio Angelo', 'Salarié 43', '62 BOULEVARD Massena, 75013 PARIS', 'georgio-angelo.salarie-43@ssdp.net', '$2b$10$g4yMCee37Omv9w89nuezuOMi5s6rudmpNoxfotrpvgKGuOMniR1a2', '2020-02-29 08:31:56.824+00', '2020-02-29 08:31:56.824+00', 4, 4),
(40, 'Maria', 'Salarié 44', '10 RUE PIERRE DUPONT , 75010 PARIS', 'maria.salarie-44@ssdp.net', '$2b$10$xJw6tIJr3.1TMDOtThEe9OHTc8hq8I6ZVEmQoTj3GYhs2HdtLDEVW', '2020-02-29 08:31:56.815+00', '2020-02-29 08:31:56.815+00', 2, 5);
DROP TABLE IF EXISTS "vehicles";
DROP SEQUENCE IF EXISTS vehicles_id_seq;
CREATE SEQUENCE vehicles_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."vehicles" (
"id" integer DEFAULT nextval('vehicles_id_seq') NOT NULL,
"number_plate" character varying(128) NOT NULL,
"type" character varying(128) NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
"parking_id" integer,
"team_id" integer,
CONSTRAINT "vehicles_number_plate_key" UNIQUE ("number_plate"),
CONSTRAINT "vehicles_pkey" PRIMARY KEY ("id"),
CONSTRAINT "vehicles_parking_id_fkey" FOREIGN KEY (parking_id) REFERENCES parkings(id) ON UPDATE CASCADE ON DELETE SET NULL NOT DEFERRABLE,
CONSTRAINT "vehicles_team_id_fkey" FOREIGN KEY (team_id) REFERENCES teams(id) ON UPDATE CASCADE ON DELETE SET NULL NOT DEFERRABLE
) WITH (oids = false);
INSERT INTO "vehicles" ("id", "number_plate", "type", "created_at", "updated_at", "parking_id", "team_id") VALUES
(2, 'EL-672-SG', 'C3', '2020-02-29 08:31:47.155+00', '2020-02-29 08:31:47.155+00', 1, NULL),
(6, 'FA-205-YK', 'C3', '2020-02-29 08:31:47.156+00', '2020-02-29 08:31:47.156+00', 1, NULL),
(8, 'FC-592-KX', 'C3', '2020-02-29 08:31:47.156+00', '2020-02-29 08:31:47.156+00', 1, NULL),
(4, 'EM-335-MH', 'C3', '2020-02-29 08:31:47.156+00', '2020-02-29 08:31:47.156+00', 1, NULL),
(7, 'FA-606-YK', 'C3', '2020-02-29 08:31:47.156+00', '2020-02-29 08:31:47.156+00', 1, NULL),
(9, 'FK-698-YY', 'C3', '2020-02-29 08:31:47.157+00', '2020-02-29 08:31:47.157+00', 1, NULL),
(1, 'EB-500-NA', 'C3', '2020-02-29 08:31:47.155+00', '2020-02-29 08:31:47.155+00', 1, NULL),
(5, 'EL-696-SG', 'C3', '2020-02-29 08:31:47.155+00', '2020-02-29 08:31:47.155+00', 1, NULL),
(3, 'EL-451-SG', 'C3', '2020-02-29 08:31:47.155+00', '2020-02-29 08:31:47.155+00', 1, NULL);
DROP TABLE IF EXISTS "visits";
DROP SEQUENCE IF EXISTS visits_id_seq;
CREATE SEQUENCE visits_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."visits" (
"id" integer DEFAULT nextval('visits_id_seq') NOT NULL,
"rate" double precision DEFAULT '0' NOT NULL,
"date" timestamptz NOT NULL,
"status" integer DEFAULT '0' NOT NULL,
"created_at" timestamptz NOT NULL,
"updated_at" timestamptz NOT NULL,
"team_id" integer,
"hotel_id" integer,
CONSTRAINT "visits_pkey" PRIMARY KEY ("id"),
CONSTRAINT "visits_hotel_id_fkey" FOREIGN KEY (hotel_id) REFERENCES hotels(id) ON UPDATE CASCADE ON DELETE SET NULL NOT DEFERRABLE,
CONSTRAINT "visits_team_id_fkey" FOREIGN KEY (team_id) REFERENCES teams(id) ON UPDATE CASCADE ON DELETE SET NULL NOT DEFERRABLE
) WITH (oids = false);
INSERT INTO "visits" ("id", "rate", "date", "status", "created_at", "updated_at", "team_id", "hotel_id") VALUES
(25014813, 29.1, '2019-05-22 00:00:00+00', 1, '2020-02-29 08:31:46.49+00', '2020-02-29 08:31:46.49+00', NULL, 14004961),
(24667936, 29.1, '2019-04-08 00:00:00+00', 1, '2020-02-29 08:31:46.491+00', '2020-02-29 08:31:46.491+00', NULL, 290),
(25945105, 29.1, '2019-08-22 00:00:00+00', 1, '2020-02-29 08:31:46.491+00', '2020-02-29 08:31:46.491+00', NULL, 290),
(24618293, 32.73, '2019-03-29 00:00:00+00', 1, '2020-02-29 08:31:46.492+00', '2020-02-29 08:31:46.492+00', NULL, 26500133),
(26246857, 32.33, '2019-09-23 00:00:00+00', 1, '2020-02-29 08:31:46.494+00', '2020-02-29 08:31:46.494+00', NULL, 26500133),