-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathbackup.sql
6087 lines (5754 loc) · 347 KB
/
backup.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: affiliate; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE affiliate (
affiliate_id bigint NOT NULL,
created timestamp with time zone,
creator character varying(255),
application_id bigint,
type character varying(255),
affiliate_details_id bigint,
home_member_id bigint NOT NULL,
import_key character varying(255)
);
ALTER TABLE public.affiliate OWNER TO mlds;
--
-- Name: affiliate_details; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE affiliate_details (
affiliate_details_id bigint NOT NULL,
first_name character varying(50),
last_name character varying(50),
email character varying(100),
alternate_email character varying(100),
third_email character varying(100),
street character varying(255),
city character varying(255),
post character varying(50),
billing_street character varying(255),
billing_city character varying(255),
billing_post character varying(50),
country_iso_code_2 character varying(255),
billing_country_iso_code_2 character varying(255),
organization_name character varying(255),
landline_number character varying(255),
landline_extension character varying(255),
mobile_number character varying(255),
organization_type character varying(255),
organization_type_other character varying(255)
);
ALTER TABLE public.affiliate_details OWNER TO mlds;
--
-- Name: application; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE application (
application_id numeric NOT NULL,
username character varying(255),
street character varying(255),
city character varying(255),
country character varying(255),
landline_extension character varying(255),
full_name character varying(255),
landline_number character varying(255),
snomedlicense boolean DEFAULT false NOT NULL,
type character varying(255),
subtype character varying(255),
email character varying(255),
alternate_email character varying(255),
third_email character varying(255),
mobile_number character varying(255),
organization_name character varying(255),
organization_type character varying(255),
billing_street character varying(255),
billing_city character varying(255),
billing_country character varying(255),
other_text character varying(255),
billing_post_code character varying(255),
post_code character varying(255),
organization_type_other character varying(255),
submitted_at timestamp with time zone,
notes_internal text,
completed_at timestamp with time zone,
approval_state character varying(255) DEFAULT 'NOT_SUBMITTED'::character varying NOT NULL,
commercial_usage_id bigint,
affiliate_details_id bigint,
member_id bigint NOT NULL,
application_type character varying(255) NOT NULL,
reason text,
affiliate_id bigint
);
ALTER TABLE public.application OWNER TO mlds;
--
-- Name: commercial_usage; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE commercial_usage (
commercial_usage_id bigint NOT NULL,
created timestamp with time zone,
key character varying(255),
start_date date,
end_date date,
note text,
approval_state character varying(255) DEFAULT 'NOT_SUBMITTED'::character varying,
submitted timestamp with time zone,
affiliate_id bigint,
current_usage text,
planned_usage text,
purpose text,
agreement_type character varying(255),
type character varying(255),
implementation_status character varying(255)
);
ALTER TABLE public.commercial_usage OWNER TO mlds;
--
-- Name: commercial_usage_count; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE commercial_usage_count (
commercial_usage_count_id bigint NOT NULL,
commercial_usage_id bigint,
created timestamp with time zone,
practices integer DEFAULT 0,
country_iso_code_2 character varying(255)
);
ALTER TABLE public.commercial_usage_count OWNER TO mlds;
--
-- Name: commercial_usage_entry; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE commercial_usage_entry (
commercial_usage_entry_id bigint NOT NULL,
created timestamp with time zone,
name character varying(255),
start_date date NOT NULL,
end_date date,
country_iso_code_2 character varying(255),
commercial_usage_id bigint,
note text
);
ALTER TABLE public.commercial_usage_entry OWNER TO mlds;
--
-- Name: country; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE country (
iso_code_2 character varying(2) NOT NULL,
iso_code_3 character varying(3),
common_name character varying(255),
exclude_registration boolean DEFAULT false NOT NULL,
alternate_registration_url character varying(255),
member_id bigint
);
ALTER TABLE public.country OWNER TO mlds;
--
-- Name: databasechangelog; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE databasechangelog (
id character varying(255) NOT NULL,
author character varying(255) NOT NULL,
filename character varying(255) NOT NULL,
dateexecuted timestamp with time zone NOT NULL,
orderexecuted integer NOT NULL,
exectype character varying(10) NOT NULL,
md5sum character varying(35),
description character varying(255),
comments character varying(255),
tag character varying(255),
liquibase character varying(20)
);
ALTER TABLE public.databasechangelog OWNER TO mlds;
--
-- Name: databasechangeloglock; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE databasechangeloglock (
id integer NOT NULL,
locked boolean NOT NULL,
lockgranted timestamp with time zone,
lockedby character varying(255)
);
ALTER TABLE public.databasechangeloglock OWNER TO mlds;
--
-- Name: email_domain_blacklist; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE email_domain_blacklist (
domain_id numeric NOT NULL,
domainname character varying(255)
);
ALTER TABLE public.email_domain_blacklist OWNER TO mlds;
--
-- Name: event; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE event (
event_id bigint NOT NULL,
type character varying(31) NOT NULL,
description character varying(4096) NOT NULL,
"timestamp" timestamp with time zone NOT NULL,
event_sub_type character varying(255),
principal character varying(255),
browser_type character varying(32),
browser_version character varying(32),
ip_address character varying(32),
locale character varying(5),
session_id character varying(255),
user_agent character varying(1024)
);
ALTER TABLE public.event OWNER TO mlds;
--
-- Name: hibernate_sequence; Type: SEQUENCE; Schema: public; Owner: mlds
--
CREATE SEQUENCE hibernate_sequence
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.hibernate_sequence OWNER TO mlds;
--
-- Name: member; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE member (
member_id bigint NOT NULL,
key character varying(255) NOT NULL,
created_at timestamp with time zone
);
ALTER TABLE public.member OWNER TO mlds;
--
-- Name: password_reset_token; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE password_reset_token (
password_reset_token_id character varying(255) NOT NULL,
user_login character varying(255),
created timestamp with time zone
);
ALTER TABLE public.password_reset_token OWNER TO mlds;
--
-- Name: release_file; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE release_file (
release_file_id bigint NOT NULL,
release_version_id bigint,
created_at timestamp with time zone,
label character varying(255),
download_url text
);
ALTER TABLE public.release_file OWNER TO mlds;
--
-- Name: release_package; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE release_package (
release_package_id bigint NOT NULL,
created_by character varying(255),
created_at timestamp with time zone,
name character varying(255),
description text,
inactive_at timestamp with time zone,
member_id bigint NOT NULL
);
ALTER TABLE public.release_package OWNER TO mlds;
--
-- Name: release_version; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE release_version (
release_version_id bigint NOT NULL,
release_package_id bigint,
created_by character varying(255),
created_at timestamp with time zone,
name character varying(255),
description text,
published_at timestamp with time zone,
online boolean DEFAULT false NOT NULL,
inactive_at timestamp with time zone
);
ALTER TABLE public.release_version OWNER TO mlds;
--
-- Name: t_authority; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE t_authority (
name character varying(255) NOT NULL
);
ALTER TABLE public.t_authority OWNER TO mlds;
--
-- Name: t_persistent_audit_event; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE t_persistent_audit_event (
event_id bigint NOT NULL,
principal character varying(50),
event_date timestamp with time zone,
event_type character varying(50),
application_id bigint,
affiliate_id bigint,
release_package_id bigint,
release_version_id bigint,
release_file_id bigint
);
ALTER TABLE public.t_persistent_audit_event OWNER TO mlds;
--
-- Name: t_persistent_audit_event_data; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE t_persistent_audit_event_data (
event_id bigint NOT NULL,
name character varying(50) NOT NULL,
value character varying(255)
);
ALTER TABLE public.t_persistent_audit_event_data OWNER TO mlds;
--
-- Name: t_persistent_token; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE t_persistent_token (
series character varying(255) NOT NULL,
user_login character varying(50),
token_value character varying(255),
token_date date,
ip_address character varying(39),
user_agent character varying(255)
);
ALTER TABLE public.t_persistent_token OWNER TO mlds;
--
-- Name: t_user; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE t_user (
login character varying(50) NOT NULL,
password character varying(100),
first_name character varying(50),
last_name character varying(50),
email character varying(100),
activated boolean DEFAULT true NOT NULL,
lang_key character varying(5),
activation_key character varying(20),
created_by character varying(50) DEFAULT 'system'::character varying NOT NULL,
created_date timestamp with time zone DEFAULT now() NOT NULL,
last_modified_by character varying(50),
last_modified_date timestamp with time zone
);
ALTER TABLE public.t_user OWNER TO mlds;
--
-- Name: t_user_authority; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE t_user_authority (
login character varying(50) NOT NULL,
name character varying(255) NOT NULL
);
ALTER TABLE public.t_user_authority OWNER TO mlds;
--
-- Name: user_registration; Type: TABLE; Schema: public; Owner: mlds; Tablespace:
--
CREATE TABLE user_registration (
user_registration_id numeric NOT NULL,
email character varying(255)
);
ALTER TABLE public.user_registration OWNER TO mlds;
--
-- Data for Name: affiliate; Type: TABLE DATA; Schema: public; Owner: mlds
--
COPY affiliate (affiliate_id, created, creator, application_id, type, affiliate_details_id, home_member_id, import_key) FROM stdin;
2053 2014-08-05 14:43:46.587-04 [email protected] 2055 COMMERCIAL \N 1437 \N
2120 2014-08-05 16:18:05.815-04 [email protected] 2122 COMMERCIAL \N 1438 \N
2130 2014-08-05 17:11:50.247-04 [email protected] 2132 COMMERCIAL 2146 1438 \N
2169 2014-08-06 10:01:10.829-04 [email protected] 2171 ACADEMIC 2207 1438 \N
2654 2014-08-12 15:19:04.822-04 [email protected] 2656 INDIVIDUAL 2669 1438 \N
2218 2014-08-06 10:36:52.523-04 [email protected] 2220 INDIVIDUAL 2249 1438 \N
111 2014-06-26 15:34:50.634-04 admin \N COMMERCIAL \N 1437 \N
119 2014-06-26 15:39:46.22-04 [email protected] \N COMMERCIAL \N 1437 \N
139 2014-06-26 16:23:42.319-04 [email protected] 137 COMMERCIAL \N 1437 \N
704 2014-07-07 13:42:10.134-04 [email protected] 703 COMMERCIAL \N 1437 \N
733 2014-07-07 14:25:05.977-04 [email protected] 732 COMMERCIAL \N 1437 \N
306 2014-07-03 11:48:44.884-04 [email protected] 305 COMMERCIAL \N 1437 \N
1019 2014-07-09 12:25:57.078-04 [email protected] 1018 COMMERCIAL \N 1437 \N
1164 2014-07-18 13:13:25.494-04 [email protected] 1163 COMMERCIAL \N 1437 \N
1201 2014-07-18 15:40:44.168-04 [email protected] 1200 COMMERCIAL \N 1437 \N
1209 2014-07-18 15:51:36.255-04 [email protected] 1208 COMMERCIAL \N 1437 \N
1255 2014-07-21 11:45:46.9-04 [email protected] 1254 COMMERCIAL \N 1437 \N
1264 2014-07-21 11:53:24.342-04 [email protected] 1263 COMMERCIAL \N 1437 \N
1270 2014-07-21 12:10:21.18-04 [email protected] 1269 COMMERCIAL \N 1437 \N
1278 2014-07-21 12:24:24.074-04 [email protected] 1277 COMMERCIAL \N 1437 \N
1305 2014-07-21 16:22:38.001-04 [email protected] 1304 COMMERCIAL \N 1437 \N
1338 2014-07-21 17:02:11.676-04 [email protected] 1337 COMMERCIAL \N 1437 \N
1384 2014-07-23 12:28:34.344-04 [email protected] 1383 COMMERCIAL \N 1437 \N
1426 2014-07-23 16:30:44.461-04 [email protected] 1425 COMMERCIAL \N 1437 \N
1441 2014-07-25 10:39:07.048-04 [email protected] 1440 COMMERCIAL \N 1437 \N
1514 2014-07-28 16:21:45.746-04 [email protected] 1513 COMMERCIAL 1522 1437 \N
1571 2014-07-29 15:48:40.718-04 [email protected] 1570 COMMERCIAL \N 1438 \N
1495 2014-07-28 11:26:29.962-04 [email protected] 1494 COMMERCIAL 1704 1437 \N
2296 2014-08-06 13:19:32.028-04 [email protected] 2298 COMMERCIAL 2358 1438 \N
1733 2014-07-31 12:03:47.357-04 [email protected] 1732 COMMERCIAL 1810 1437 \N
2367 2014-08-08 10:22:38.586-04 [email protected] 2369 INDIVIDUAL \N 1437 \N
1820 2014-07-31 15:16:42.433-04 [email protected] 1819 INDIVIDUAL 1829 1438 \N
1840 2014-07-31 15:32:51.346-04 [email protected] 1839 ACADEMIC 1852 1438 \N
1860 2014-07-31 15:35:39.92-04 [email protected] 1859 COMMERCIAL 1869 1438 \N
2008 2014-08-05 13:57:02.251-04 [email protected] 2010 COMMERCIAL \N 1437 \N
2033 2014-08-05 14:32:03.159-04 [email protected] 2035 COMMERCIAL \N 1437 \N
2758 2014-08-13 16:24:32.152-04 \N 2754 COMMERCIAL 2757 1438 9
2695 2014-08-13 12:29:11.446-04 \N 2691 COMMERCIAL 2694 1438 91
2706 2014-08-13 12:30:05.017-04 \N 2702 COMMERCIAL 2705 1438 92
2427 2014-08-11 10:16:00.245-04 \N 2425 COMMERCIAL 2426 1438 93
2450 2014-08-11 12:45:20.098-04 \N 2448 \N 2449 1438 94
2458 2014-08-11 12:50:54.74-04 \N 2456 COMMERCIAL 2457 1438 95
2466 2014-08-11 13:43:40.964-04 \N 2464 COMMERCIAL 2465 1438 96
2501 2014-08-11 15:53:07.75-04 \N 2498 COMMERCIAL 2500 1438 97
2519 2014-08-11 16:06:40.493-04 \N 2515 COMMERCIAL 2518 1438 98
2531 2014-08-11 16:24:09.564-04 \N 2527 COMMERCIAL 2530 1438 99
2543 2014-08-11 16:30:11.376-04 \N 2539 COMMERCIAL 2542 1438 100
2555 2014-08-11 16:51:53.093-04 \N 2551 COMMERCIAL 2554 1438 101
2570 2014-08-12 11:13:55.233-04 \N 2566 COMMERCIAL 2569 1438 102
2575 2014-08-12 11:13:57.556-04 \N 2571 COMMERCIAL 2574 1438 103
2592 2014-08-12 11:14:16.675-04 \N 2588 COMMERCIAL 2591 1438 104
2718 2014-08-13 12:36:40.363-04 \N 2714 COMMERCIAL 2717 1438 105
2730 2014-08-13 12:38:46.016-04 \N 2726 COMMERCIAL 2729 1438 106
2746 2014-08-13 15:05:29.191-04 \N 2742 COMMERCIAL 2745 1438 107
2763 2014-08-13 16:24:32.164-04 \N 2759 ACADEMIC 2762 1438 201
2700 2014-08-13 12:29:11.46-04 \N 2696 ACADEMIC 2699 1438 202
2430 2014-08-11 10:16:00.251-04 \N 2428 ACADEMIC 2429 1438 203
2453 2014-08-11 12:45:25.686-04 \N 2451 \N 2452 1438 204
2461 2014-08-11 12:50:54.748-04 \N 2459 ACADEMIC 2460 1438 205
2469 2014-08-11 13:43:40.974-04 \N 2467 ACADEMIC 2468 1438 206
2505 2014-08-11 15:53:34.198-04 \N 2502 ACADEMIC 2504 1438 207
2524 2014-08-11 16:07:21.981-04 \N 2520 ACADEMIC 2523 1438 208
2536 2014-08-11 16:24:10.466-04 \N 2532 ACADEMIC 2535 1438 209
2548 2014-08-11 16:30:11.392-04 \N 2544 ACADEMIC 2547 1438 210
2560 2014-08-11 16:51:53.106-04 \N 2556 ACADEMIC 2559 1438 211
2580 2014-08-12 11:13:59.263-04 \N 2576 ACADEMIC 2579 1438 212
2597 2014-08-12 11:14:17.413-04 \N 2593 ACADEMIC 2596 1438 213
2711 2014-08-13 12:30:05.026-04 \N 2707 ACADEMIC 2710 1438 214
2723 2014-08-13 12:36:40.377-04 \N 2719 ACADEMIC 2722 1438 215
2735 2014-08-13 12:38:46.031-04 \N 2731 ACADEMIC 2734 1438 216
2751 2014-08-13 15:05:29.205-04 \N 2747 ACADEMIC 2750 1438 217
2586 2014-08-12 11:14:00.757-04 \N 2582 ACADEMIC 2585 1438 218
2787 2014-08-14 11:04:47.727-04 \N 2783 COMMERCIAL 2786 1438 1
2792 2014-08-14 11:04:47.753-04 \N 2788 ACADEMIC 2791 1438 2
\.
--
-- Data for Name: affiliate_details; Type: TABLE DATA; Schema: public; Owner: mlds
--
COPY affiliate_details (affiliate_details_id, first_name, last_name, email, alternate_email, third_email, street, city, post, billing_street, billing_city, billing_post, country_iso_code_2, billing_country_iso_code_2, organization_name, landline_number, landline_extension, mobile_number, organization_type, organization_type_other) FROM stdin;
2249 able222 948 [email protected] address city post SE \N +1 (555) +1 (666) 77 \N
1838 able 941 [email protected] [email protected] address city post SE \N 941 org acad +1 (33 +1 (333) PUBLIC_HEALTH_ORGANIZATION
1493 able 936 [email protected] [email protected] [email protected] some address some city some post some address some city some post CA CA 936 org +1 (33 +1 (434) PRIVATE_HEALTH_ORGANIZATION
1852 able 941 [email protected] [email protected] address 2 city post SE \N 941 org acad +1 (33 +1 (333) PUBLIC_HEALTH_ORGANIZATION
2429 \N \N \N \N \N \N \N \N \N
2449 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US Imported Organization +1 416 762 0032 123 +1 416 762 0033 \N Other
2452 \N \N \N
2131 able 946 [email protected] [email protected] [email protected] address city post address b city b post b SE SE 946 Org +1 (555) +1 (555) 5 PRIVATE_HEALTH_ORGANIZATION
1569 able 938 [email protected] [email protected] [email protected] street city post street b city b post b SE BW 938 Org +1 (333) +1 (333) RESEARCH_AND_DEVELOPMENT_ORGANIZATION
2457 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
1704 AAA ZZZ [email protected] [email protected] [email protected] some address some city some post some address some city some post CA CA \N +1 (33 +1 (434) PRIVATE_HEALTH_ORGANIZATION
1512 able 937 [email protected] [email protected] [email protected] street city post street b city b post b CA AC 937 Org +1 (22 +1 (222) RESEARCH_AND_DEVELOPMENT_ORGANIZATION
2146 able2 946 [email protected] [email protected] [email protected] address city post address b2 city b post b SE SE 946 Org +1 (555) +1 (555) 5 PRIVATE_HEALTH_ORGANIZATION
1731 able 939a [email protected] [email protected] [email protected] address city post address city post CM GB 939 Org +1 (555) +1 (555) 5 PRIVATE_HEALTH_ORGANIZATION
2460 \N \N \N
2465 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2468 \N \N \N
2499 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2500 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
1522 able 937a [email protected] [email protected] [email protected] street 212ab city 212 hello street b city b post b CA AC 937 Org +1 (224) +1 (222) RESEARCH_AND_DEVELOPMENT_ORGANIZATION
2297 able 949 [email protected] [email protected] [email protected] address city post address city post SE SE 949 Org +1 (444) +1 (444) 4 RESEARCH_AND_DEVELOPMENT_ORGANIZATION
1858 able 942 [email protected] [email protected] [email protected] address city post address b city b post b SE GB 942 org commercial +1 (444) +1 (444) PRIVATE_HEALTH_ORGANIZATION
1818 able 940 [email protected] address city post SE \N +1 (444) +1 (444) 4 \N
1829 able 940 [email protected] address 1 city 1 post 1 SE \N +1 (444) +1 (444) 4 \N
1869 able 942 [email protected] [email protected] [email protected] address city post address b city b post b SE CA 942 org commercial +1 (444) +1 (444) PRIVATE_HEALTH_ORGANIZATION
1810 able 939a [email protected] [email protected] [email protected] address 2 city post address b city b post b CM US 939 Org +1 (555) +1 (555) 5 PRIVATE_HEALTH_ORGANIZATION
2009 able 943 [email protected] \N \N \N \N \N \N \N \N CA \N \N \N \N \N \N \N
2034 able 944 [email protected] \N \N \N \N \N \N \N \N AS \N \N \N \N \N \N \N
2054 bad bad [email protected] \N \N \N \N \N \N \N \N CA \N \N \N \N \N \N \N
2121 able 945 [email protected] SE \N \N
2358 able 949 [email protected] [email protected] [email protected] address city post address city post SE SE 949 Org +1 (444) +1 (444) 4 RESEARCH_AND_DEVELOPMENT_ORGANIZATION
2503 \N \N \N
2170 able 947 [email protected] [email protected] address city post SE \N 947 Org +1 (333) +1 (555) 5 RESEARCH_AND_DEVELOPMENT_ORGANIZATION
2207 able 947 [email protected] [email protected] address city post SE \N 947 Org +1 (333) +1 (555) 5 RESEARCH_AND_DEVELOPMENT_ORGANIZATION
2504 \N \N \N
2516 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2518 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2521 \N \N \N
2523 \N \N \N
2219 able 948 [email protected] address city post SE \N +1 (555) +1 (666) 77 \N
2368 able 950 [email protected] address city post CA \N +1 (111) +1 (111) 1 \N
2390 able 949 [email protected] [email protected] [email protected] address city post address city post SE SE 949 Org +1 (444) +1 (444) 4 RESEARCH_AND_DEVELOPMENT_ORGANIZATION
2426 John Smith [email protected] [email protected] [email protected] \N \N \N \N \N \N \N \N Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2528 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2530 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2533 \N \N \N
2535 \N \N \N
2540 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2542 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2545 \N \N \N
2547 \N \N \N
2552 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2554 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2557 \N \N \N
2559 \N \N \N
2567 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2569 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2577 \N \N \N
2579 \N \N \N
2572 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2574 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2583 \N \N \N
2585 \N \N \N
2589 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2591 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2594 \N \N \N
2596 \N \N \N
2732 \N \N \N
2734 \N \N \N
2743 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2745 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2748 \N \N \N
2750 \N \N \N
2655 able 951 [email protected] address city post SE \N +1 (222) +1 (222) 2 \N
2669 able 951 [email protected] address city post SE \N +1 (222) +1 (222) 2 \N
2692 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2694 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2697 \N \N \N
2699 \N \N \N
2703 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2705 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2708 \N \N \N
2710 \N \N \N
2715 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2717 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2720 \N \N \N
2722 \N \N \N
2727 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2729 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2755 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2757 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2760 \N \N \N
2762 \N \N \N
2784 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2786 John Smith [email protected] [email protected] [email protected] 200 Adelaide Street West, Suite 100 Toronto M5H 1W7 200 Bloor Street West Toronto M5R 2T1 CA US #1 Imported Organization +1 416 762 0032 123 +1 416 762 0033 PUBLIC_HEALTH_ORGANIZATION Other
2789 \N \N \N
2791 \N \N \N
\.
--
-- Data for Name: application; Type: TABLE DATA; Schema: public; Owner: mlds
--
COPY application (application_id, username, street, city, country, landline_extension, full_name, landline_number, snomedlicense, type, subtype, email, alternate_email, third_email, mobile_number, organization_name, organization_type, billing_street, billing_city, billing_country, other_text, billing_post_code, post_code, organization_type_other, submitted_at, notes_internal, completed_at, approval_state, commercial_usage_id, affiliate_details_id, member_id, application_type, reason, affiliate_id) FROM stdin;
2714 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2716 2715 1438 PRIMARY \N 2718
2719 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2721 2720 1438 PRIMARY \N 2723
2132 [email protected] \N \N \N \N \N \N t COMMERCIAL VENDOR \N \N \N \N \N \N \N \N \N \N \N \N 2014-08-05 17:13:48.961-04 2014-08-05 17:14:17.999-04 APPROVED 2133 2131 1438 PRIMARY \N 2130
2754 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2756 2755 1438 PRIMARY \N 2758
2759 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2761 2760 1438 PRIMARY \N 2763
2298 [email protected] \N \N \N \N \N \N t COMMERCIAL VENDOR \N \N \N \N \N \N \N \N \N \N \N \N 2014-08-06 14:46:05.077-04 2014-08-08 09:33:25.767-04 APPROVED 2299 2297 1438 PRIMARY \N 2296
703 [email protected] \N \N Canada \N able 921 \N f COMMERCIAL \N [email protected] \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-15 16:51:22.326259-04 \N \N NOT_SUBMITTED 1021 \N 1437 PRIMARY \N 704
118 [email protected] \N \N \N \N able 918 +1 417 762 0032 t COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-15 16:51:22.326259-04 \N 2014-07-15 16:51:22.326259-04 APPROVED 1021 \N 1437 PRIMARY \N 119
137 [email protected] \N \N \N \N able 919 +1 416 762 0032 t COMMERCIAL DEVELOPER \N \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-15 16:51:22.326259-04 \N 2014-07-15 16:51:22.326259-04 APPROVED 1021 \N 1437 PRIMARY \N 139
1200 [email protected] 12123 city Canada able 926 +1 23 t COMMERCIAL VENDOR [email protected] [email protected] [email protected] +2 able 926 ORG HEALTHERCARE_APPLICATION_DEVELOPER 12123 city Canada postal postal 2014-07-18 16:27:02.611-04 greate notes! 2014-07-18 16:30:23.169-04 APPROVED 1202 \N 1437 PRIMARY \N 1201
1425 [email protected] 111 111 Canada able 934 +1 (111) t COMMERCIAL VENDOR [email protected] [email protected] [email protected] +1 (111) 111 HEALTHERCARE_APPLICATION_DEVELOPER 111 111 Canada 111 111 2014-07-23 16:31:30.443-04 ouoeuou 2014-07-23 16:31:58.952-04 APPROVED 1427 \N 1437 PRIMARY \N 1426
732 [email protected] \N \N Anguilla \N \N \N f COMMERCIAL \N [email protected] \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-15 16:51:22.326259-04 \N \N NOT_SUBMITTED 1021 \N 1437 PRIMARY \N 733
1304 [email protected] \N \N Canada \N able 931 \N f COMMERCIAL \N [email protected] \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 1306 \N 1437 PRIMARY \N 1305
2456 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED \N 2457 1438 PRIMARY \N 2458
2459 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED \N 2460 1438 PRIMARY \N 2461
2515 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2517 2516 1438 PRIMARY \N 2519
2520 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2522 2521 1438 PRIMARY \N 2524
2551 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2553 2552 1438 PRIMARY \N 2555
2556 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2558 2557 1438 PRIMARY \N 2560
2656 [email protected] \N \N \N \N \N \N t INDIVIDUAL PERSONAL \N \N \N \N \N \N \N \N \N \N \N \N 2014-08-12 15:20:01.563-04 2014-08-12 15:20:36.419-04 APPROVED 2657 2655 1438 PRIMARY \N 2654
2161 [email protected] \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED \N \N 1438 EXTENSION \N \N
305 [email protected] 200 adelaide Toronto Canada able 920 +1 416 762 0032 t COMMERCIAL DEVELOPER [email protected] [email protected] [email protected] +1 2389239082903 My Organization RESEARCH_AND_DEVELOPMENT_ORGANIZATION 200 adelaide Toronto Canada 123456 123456 2014-07-16 15:18:06.599-04 hello there 2014-07-16 17:21:13.637-04 CHANGE_REQUESTED 1021 \N 1437 PRIMARY \N 306
1277 [email protected] 1 1 Ascension able 931 +1 t COMMERCIAL DEVELOPER [email protected] [email protected] [email protected] +1 931 Organization five again more2 PRIVATE_HEALTH_ORGANIZATION 1 1 Ascension 1 1 2014-07-21 17:01:19.054-04 STAFF NOTES! Again... 2 2014-07-21 17:04:21.384-04 APPROVED 1279 \N 1437 PRIMARY \N 1278
1383 [email protected] ou oeu Canada able 933 +1 (278) t COMMERCIAL DEVELOPER [email protected] [email protected] [email protected] +1 (898) 9 933 org PUBLIC_HEALTH_ORGANIZATION ou oeu Canada oeu oeu 2014-07-23 12:30:03.905-04 staff notes\nFrom admin... \N CHANGE_REQUESTED 1385 \N 1437 PRIMARY \N 1384
1208 [email protected] \N \N Canada \N able 927 \N f COMMERCIAL \N [email protected] \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 1210 \N 1437 PRIMARY \N 1209
1254 [email protected] \N \N Canada \N able 928 \N f COMMERCIAL \N [email protected] \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 1256 \N 1437 PRIMARY \N 1255
1263 [email protected] \N \N Canada \N able 929 \N f COMMERCIAL \N [email protected] \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 1265 \N 1437 PRIMARY \N 1264
1269 [email protected] \N \N Comoros \N able 930 \N f COMMERCIAL \N [email protected] \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 1271 \N 1437 PRIMARY \N 1270
1337 [email protected] 1 1 Canada able 932 +1 (1 t COMMERCIAL DEVELOPER [email protected] [email protected] [email protected] +1 (1 932 Organization 2222 requested ILLEGAL RESEARCH_AND_DEVELOPMENT_ORGANIZATION 1 1 1 1 1 2014-07-21 17:27:21.718-04 notes 1 2014-07-21 17:06:12.863-04 CHANGE_REQUESTED 1339 \N 1437 PRIMARY \N 1338
1163 [email protected] 123213 number 2 213123213 123123123 able 925 +1 234 t COMMERCIAL DEVELOPER [email protected] [email protected] [email protected] +1 234 able925 org PUBLIC_HEALTH_ORGANIZATION 123213 213123213 123123123 12312123 12312123 2014-07-18 15:07:38.183-04 some note 2 234 ou again more again and much more again ....oeee more moo134 2014-07-18 15:07:01.315-04 NOT_SUBMITTED 1165 \N 1437 PRIMARY \N 1164
1839 [email protected] \N \N \N \N \N \N t ACADEMIC DEVELOPMENT \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-31 15:33:52.305-04 2014-07-31 15:34:44.306-04 APPROVED 1841 1838 1438 PRIMARY \N 1840
2467 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED \N 2468 1438 PRIMARY \N 2469
2527 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2529 2528 1438 PRIMARY \N 2531
2532 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2534 2533 1438 PRIMARY \N 2536
2566 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2568 2567 1438 PRIMARY \N 2570
1859 [email protected] \N \N \N \N \N \N t COMMERCIAL VENDOR \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-31 15:36:54.192-04 sweden 2014-07-31 15:37:22.043-04 APPROVED 1861 1858 1438 PRIMARY \N 1860
1570 [email protected] \N \N \N \N \N \N f COMMERCIAL DEVELOPER \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-29 16:24:31.085-04 blah\nFrom admin non-ihtsdo... \N CHANGE_REQUESTED 1572 1569 1438 PRIMARY \N 1571
1440 [email protected] street city Congo, (Congo Brazzaville) able 935 +1 (111) 1 t COMMERCIAL DEVELOPER [email protected] [email protected] [email protected] +1 (111) 935 Organization PUBLIC_HEALTH_ORGANIZATION billingstreet billing city France billing postalcode postalcode 2014-07-25 11:16:10.321-04 some staff notes 2014-07-25 11:16:32.631-04 APPROVED 1442 \N 1437 PRIMARY \N 1441
1018 [email protected] 1 1 Canada ableyy 923 +1 213 4545 t COMMERCIAL DEVELOPER [email protected] 923@com 2@com +1 222 923 organazitaion PUBLIC_HEALTH_ORGANIZATION 1 1 Canada 1 1 2014-07-23 12:18:34.17-04 new set of staff notes hello more 2014-07-23 12:19:38.355-04 APPROVED 1021 \N 1437 PRIMARY \N 1019
2576 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2578 2577 1438 PRIMARY \N 2580
2171 [email protected] \N \N \N \N \N \N t ACADEMIC HEALTHCAREPROVIDER \N \N \N \N \N \N \N \N \N \N \N \N 2014-08-06 10:03:08.41-04 super note! 2014-08-06 10:03:24.179-04 APPROVED 2172 2170 1438 PRIMARY \N 2169
2588 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2590 2589 1438 PRIMARY \N 2592
2593 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2595 2594 1438 PRIMARY \N 2597
2369 [email protected] \N \N \N \N \N \N t INDIVIDUAL PERSONAL \N \N \N \N \N \N \N \N \N \N \N \N 2014-08-08 10:25:22.963-04 2014-08-08 10:41:30.125-04 REJECTED 2370 2368 1437 PRIMARY \N 2367
2425 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED \N 2426 1438 PRIMARY \N 2427
2428 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED \N 2429 1438 PRIMARY \N 2430
2464 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED \N 2465 1438 PRIMARY \N 2466
2691 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2693 2692 1438 PRIMARY \N 2695
2696 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2698 2697 1438 PRIMARY \N 2700
2702 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2704 2703 1438 PRIMARY \N 2706
2707 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2709 2708 1438 PRIMARY \N 2711
2726 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2728 2727 1438 PRIMARY \N 2730
2731 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2733 2732 1438 PRIMARY \N 2735
2783 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2785 2784 1438 PRIMARY \N 2787
2788 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2790 2789 1438 PRIMARY \N 2792
2122 [email protected] \N \N \N \N \N \N f COMMERCIAL \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 2123 2121 1438 PRIMARY \N 2120
2742 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2744 2743 1438 PRIMARY \N 2746
2747 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2749 2748 1438 PRIMARY \N 2751
2220 [email protected] \N \N \N \N \N \N t INDIVIDUAL PERSONAL \N \N \N \N \N \N \N \N \N \N \N \N 2014-08-06 10:40:32.089-04 sweden note 2014-08-06 10:41:09.811-04 APPROVED 2221 2219 1438 PRIMARY \N 2218
1732 [email protected] \N \N \N \N \N \N t COMMERCIAL VENDOR \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-31 14:58:41.329-04 sweden note\nihtsdo note 2014-07-31 15:02:14.808-04 APPROVED 1734 1731 1437 PRIMARY \N 1733
1494 [email protected] \N \N \N \N \N \N t COMMERCIAL DEVELOPER \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-28 11:29:32.995-04 my notes 2014-07-31 10:25:51.231-04 APPROVED 1496 1493 1437 PRIMARY \N 1495
1819 [email protected] \N \N \N \N \N \N t INDIVIDUAL RESEARCH \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-31 15:18:27.63-04 2014-07-31 15:18:59.973-04 APPROVED 1821 1818 1438 PRIMARY \N 1820
1513 [email protected] \N \N \N \N \N \N t COMMERCIAL DEVELOPER \N \N \N \N \N \N \N \N \N \N \N \N 2014-07-28 16:23:54.875-04 my notes 2014-07-28 16:24:39.435-04 CHANGE_REQUESTED 1515 1512 1437 PRIMARY \N 1514
2010 [email protected] \N \N \N \N \N \N f COMMERCIAL \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 2011 2009 1437 PRIMARY \N 2008
2035 [email protected] \N \N \N \N \N \N f COMMERCIAL \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 2036 2034 1437 PRIMARY \N 2033
2448 \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED \N 2449 1438 PRIMARY \N 2450
2055 [email protected] \N \N \N \N \N \N f COMMERCIAL \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N NOT_SUBMITTED 2056 2054 1437 PRIMARY \N 2053
2451 \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED \N 2452 1438 PRIMARY \N 2453
2498 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED \N 2499 1438 PRIMARY \N 2501
2502 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED \N 2503 1438 PRIMARY \N 2505
2539 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2541 2540 1438 PRIMARY \N 2543
2544 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2546 2545 1438 PRIMARY \N 2548
2571 \N \N \N \N \N \N \N f COMMERCIAL RESEARCH \N \N \N \N \N \N \N \N \N Other Text \N \N \N \N \N \N APPROVED 2573 2572 1438 PRIMARY \N 2575
2582 \N \N \N \N \N \N \N f ACADEMIC \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N APPROVED 2584 2583 1438 PRIMARY \N 2586
2389 [email protected] \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2014-08-12 15:12:11.038-04 \N RESUBMITTED \N 2390 2308 EXTENSION hello! 2296
\.
--
-- Data for Name: commercial_usage; Type: TABLE DATA; Schema: public; Owner: mlds
--
COPY commercial_usage (commercial_usage_id, created, key, start_date, end_date, note, approval_state, submitted, affiliate_id, current_usage, planned_usage, purpose, agreement_type, type, implementation_status) FROM stdin;
1339 2014-07-21 17:02:11.708-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1338 current 2 planned purpose AFFILIATE_RESEARCH COMMERCIAL DEVELOPMENT
1572 2014-07-29 15:48:40.834-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1571 current planned purpose AFFILIATE_PUBLIC_GOOD COMMERCIAL DEVELOPMENT
1021 2014-07-09 12:25:57.131-04 \N 2014-01-01 2014-06-30 \N NOT_SUBMITTED \N 1019 current planned puprose AFFILIATE_NORMAL COMMERCIAL DEVELOPMENT
1210 2014-07-18 15:51:36.287-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1209 \N \N \N \N COMMERCIAL \N
1202 2014-07-18 15:40:44.201-04 \N 2014-07-01 2014-12-31 \N SUBMITTED 2014-07-18 16:28:13.789-04 1201 current planned purpose AFFILIATE_RESEARCH COMMERCIAL IMPLEMENTED
289 2014-07-03 10:58:48.604-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 139 u ou ou AFFILIATE_NORMAL COMMERCIAL \N
705 2014-07-07 13:42:10.168-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 704 \N \N \N \N COMMERCIAL \N
734 2014-07-07 14:25:06.064-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 733 \N \N \N \N COMMERCIAL \N
20 2014-06-24 14:26:33.851-04 \N 2014-01-09 2014-01-20 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
21 2014-06-24 14:39:37.332-04 \N 2014-06-30 2014-12-30 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
33 2014-06-24 16:02:30.932-04 \N 2012-12-31 2013-07-29 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
37 2014-06-24 16:04:31.191-04 \N 2014-06-30 2014-12-30 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
42 2014-06-24 17:03:25.973-04 \N 2014-01-01 2014-06-29 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
43 2014-06-24 17:05:23.119-04 \N 2014-06-30 2014-12-30 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
1256 2014-07-21 11:45:46.933-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1255 \N \N \N \N COMMERCIAL \N
44 2014-06-25 14:32:21.203-04 \N 2013-06-30 2013-12-31 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
45 2014-06-25 14:41:33.789-04 \N 2012-01-01 2012-06-30 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
47 2014-06-25 14:49:33.929-04 \N 2012-07-01 2012-12-31 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
1265 2014-07-21 11:53:24.372-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1264 \N \N \N \N COMMERCIAL \N
76 2014-06-26 10:42:02.388-04 \N 2013-07-01 2013-12-31 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
1271 2014-07-21 12:10:21.215-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1270 \N \N \N \N COMMERCIAL \N
310 2014-07-03 11:50:14.249-04 \N 2014-01-01 2014-06-30 \N NOT_SUBMITTED \N 306 current usage 2 ou hallp AFFILIATE_NORMAL COMMERCIAL \N
329 2014-07-03 11:50:14.249-04 \N 2013-07-01 2013-12-31 \N NOT_SUBMITTED \N 306 current usage planned usage purpose AFFILIATE_NORMAL ACADEMIC \N
340 2014-07-03 11:50:14.249-04 \N 2013-01-01 2013-06-30 \N NOT_SUBMITTED \N 306 current usage 2planned usage purpose AFFILIATE_NORMAL COMMERCIAL \N
1292 2014-07-18 15:40:44.201-04 \N 2014-01-01 2014-06-30 \N NOT_SUBMITTED \N 1201 current planned purpose AFFILIATE_RESEARCH COMMERCIAL IMPLEMENTED
1010 2014-07-03 11:50:14.249-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 306 current usage 2 ououoeuoeu 222 hallp AFFILIATE_NORMAL COMMERCIAL \N
1020 2014-07-09 12:25:57.131-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1019 current 923 planned puprose AFFILIATE_NORMAL COMMERCIAL \N
1841 2014-07-31 15:32:51.384-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1840 current planned purpose AFFILIATE_RESEARCH ACADEMIC DEVELOPMENT
1496 2014-07-28 11:26:30.003-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1495 current usage planned usage purpose AFFILIATE_NORMAL COMMERCIAL IMPLEMENTED
1385 2014-07-23 12:28:34.381-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1384 ou ou ou AFFILIATE_RESEARCH COMMERCIAL DEVELOPMENT
1306 2014-07-21 16:22:38.04-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1305 \N \N \N \N COMMERCIAL \N
79 2014-06-26 11:38:56.671-04 \N 2014-01-01 2014-06-30 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
31 2014-06-24 16:00:31.865-04 \N 2014-06-30 2014-12-30 \N SUBMITTED 2014-06-26 13:30:20.101-04 \N \N \N \N \N COMMERCIAL \N
125 2014-06-26 16:04:40.936-04 \N 2014-01-01 2014-06-30 \N SUBMITTED 2014-06-26 16:09:22.205-04 119 \N \N \N \N COMMERCIAL \N
127 2014-06-26 16:09:32.175-04 \N 2013-07-01 2013-12-31 \N NOT_SUBMITTED \N 119 \N \N \N \N COMMERCIAL \N
144 2014-06-26 16:41:25.144-04 \N 2013-07-01 2013-12-31 \N SUBMITTED 2014-06-26 17:02:30.514-04 \N \N \N \N \N COMMERCIAL \N
1165 2014-07-18 13:13:25.533-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1164 current usage MORE 99 planned usage purpose AFFILIATE_NORMAL COMMERCIAL \N
153 2014-06-26 16:27:17.158-04 \N 2013-01-01 2013-06-30 \N NOT_SUBMITTED \N \N \N \N \N \N COMMERCIAL \N
140 2014-06-26 16:27:17.158-04 \N 2014-01-01 2014-06-30 \N SUBMITTED 2014-06-27 11:30:53.38-04 \N \N \N \N \N COMMERCIAL \N
158 2014-06-26 16:27:17.158-04 \N 2012-07-01 2012-12-31 \N NOT_SUBMITTED 2014-06-27 11:30:53.38-04 \N \N \N \N \N COMMERCIAL \N
2056 2014-08-05 14:43:46.634-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 2053 \N \N \N \N COMMERCIAL \N
1279 2014-07-21 12:24:24.146-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1278 current five planned five purpose five AFFILIATE_NORMAL COMMERCIAL DEVELOPMENT
2123 2014-08-05 16:18:05.854-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 2120 \N \N \N \N COMMERCIAL \N
1427 2014-07-23 16:30:44.491-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1426 ou ou ou AFFILIATE_NORMAL COMMERCIAL IMPLEMENTED
1821 2014-07-31 15:16:42.467-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1820 usage planned purpsoe AFFILIATE_NORMAL INDIVIDUAL IMPLEMENTED
1515 2014-07-28 16:21:45.789-04 \N 2014-07-01 2014-12-31 \N SUBMITTED 2014-07-29 14:37:24.463-04 1514 current planned purpose AFFILIATE_RESEARCH COMMERCIAL DEVELOPMENT
2133 2014-08-05 17:11:50.296-04 \N 2014-07-01 2014-12-31 \N SUBMITTED 2014-08-06 09:59:20.093-04 2130 current planned purpose AFFILIATE_NORMAL COMMERCIAL IMPLEMENTED
1861 2014-07-31 15:35:39.955-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1860 current planned purpose AFFILIATE_RESEARCH COMMERCIAL DEVELOPMENT
1442 2014-07-25 10:39:07.073-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 1441 current planned purpose AFFILIATE_NORMAL COMMERCIAL DEVELOPMENT
1734 2014-07-31 12:03:47.396-04 \N 2014-07-01 2014-12-31 \N SUBMITTED 2014-08-01 16:13:56.77-04 1733 current planned purpose AFFILIATE_RESEARCH COMMERCIAL DEVELOPMENT
2155 2014-08-05 17:11:50.296-04 \N 2014-01-01 2014-06-30 \N NOT_SUBMITTED \N 2130 current planned purpose AFFILIATE_NORMAL COMMERCIAL IMPLEMENTED
2011 2014-08-05 13:57:02.339-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 2008 \N \N \N \N COMMERCIAL \N
2036 2014-08-05 14:32:03.208-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 2033 \N \N \N \N COMMERCIAL \N
2299 2014-08-06 13:19:32.078-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 2296 current planned purpose AFFILIATE_NORMAL COMMERCIAL DEVELOPMENT
2172 2014-08-06 10:01:10.87-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 2169 current new planned purpose AFFILIATE_NORMAL ACADEMIC IMPLEMENTED
2370 2014-08-08 10:22:38.638-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 2367 current planned purpose AFFILIATE_NORMAL INDIVIDUAL DEVELOPMENT
2221 2014-08-06 10:36:52.564-04 \N 2014-07-01 2014-12-31 \N SUBMITTED 2014-08-06 10:55:01.266-04 2218 current CHANGED planned purpose AFFILIATE_PUBLIC_GOOD INDIVIDUAL DEVELOPMENT
2517 2014-08-11 16:06:25.278-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2519 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2522 2014-08-11 16:07:21.956-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2524 \N ACADEMIC
2529 2014-08-11 16:24:09.555-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2531 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2534 2014-08-11 16:24:10.463-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2536 \N ACADEMIC
2541 2014-08-11 16:30:11.366-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2543 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2546 2014-08-11 16:30:11.387-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2548 \N ACADEMIC
2553 2014-08-11 16:51:53.084-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2555 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2558 2014-08-11 16:51:53.102-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2560 \N ACADEMIC
2568 2014-08-12 11:13:55.223-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2570 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2578 2014-08-12 11:13:59.26-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2580 \N ACADEMIC
2573 2014-08-12 11:13:57.553-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2575 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2584 2014-08-12 11:14:00.754-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2586 \N ACADEMIC
2590 2014-08-12 11:14:16.673-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2592 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2595 2014-08-12 11:14:17.41-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2597 \N ACADEMIC
2657 2014-08-12 15:19:04.859-04 \N 2014-07-01 2014-12-31 \N NOT_SUBMITTED \N 2654 current planned purpose AFFILIATE_RESEARCH INDIVIDUAL PLANNING
2693 2014-08-13 12:29:11.437-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2695 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2698 2014-08-13 12:29:11.456-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2700 \N ACADEMIC
2704 2014-08-13 12:30:05.015-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2706 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2709 2014-08-13 12:30:05.023-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2711 \N ACADEMIC
2716 2014-08-13 12:36:40.353-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2718 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2721 2014-08-13 12:36:40.373-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2723 \N ACADEMIC
2728 2014-08-13 12:38:46.005-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2730 My current usage My planned usage My purpose AFFILIATE_NORMAL COMMERCIAL Implementation Status
2733 2014-08-13 12:38:46.027-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2735 \N ACADEMIC
2744 2014-08-13 15:05:29.182-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2746 \N \N \N \N COMMERCIAL \N
2749 2014-08-13 15:05:29.201-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2751 \N \N \N \N ACADEMIC \N
2756 2014-08-13 16:24:32.145-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2758 \N \N \N \N COMMERCIAL \N
2761 2014-08-13 16:24:32.161-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2763 \N \N \N \N ACADEMIC \N
2785 2014-08-14 11:04:47.72-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2787 \N \N \N \N COMMERCIAL \N
2790 2014-08-14 11:04:47.75-04 \N 2014-07-01 2014-12-31 \N APPROVED \N 2792 \N \N \N \N ACADEMIC \N
\.
--
-- Data for Name: commercial_usage_count; Type: TABLE DATA; Schema: public; Owner: mlds
--
COPY commercial_usage_count (commercial_usage_count_id, commercial_usage_id, created, practices, country_iso_code_2) FROM stdin;
1011 1010 2014-07-08 13:35:11.354-04 0 AL
341 340 2014-07-04 13:38:45.682-04 0 WF
998 310 2014-07-08 13:35:11.352-04 0 AX
344 340 2014-07-04 13:51:11.132-04 3 CC
1012 1010 2014-07-08 13:35:11.352-04 0 AX
1013 1010 2014-07-04 11:10:07.779-04 0 VN
1014 1010 2014-07-04 11:10:23.363-04 0 UM
2176 2172 2014-08-06 10:02:15.153-04 0 AX
1098 1021 2014-07-15 13:49:52.895-04 1 AL
1095 1020 2014-07-15 17:03:26.629-04 20 DZ
1205 1202 2014-07-18 15:49:13.024-04 0 AL
1446 1442 2014-07-25 10:40:21.217-04 0 AL
2183 2172 2014-08-06 10:02:15.203-04 0 AI
1556 1515 2014-07-29 14:36:22.071-04 2 AC
1749 1734 2014-07-31 13:22:53.657-04 0 AX
2137 2133 2014-08-05 17:13:22.121-04 3 AX
2189 2172 2014-08-06 10:02:15.239-04 0 AU
2225 2221 2014-08-06 10:38:29.215-04 0 AF
2663 2657 2014-08-12 15:19:56.731-04 0 AL
333 329 2014-07-03 12:35:03.42-04 0 AF
334 329 2014-07-03 12:59:19.718-04 0 ZW
342 340 2014-07-03 12:59:19.718-04 0 ZW
346 340 2014-07-03 13:02:25.108-04 0 BB
290 289 2014-07-03 10:59:08.466-04 7 AF
393 340 2014-07-04 10:48:53.696-04 0 AS
395 340 2014-07-04 10:49:55.985-04 0 AO
397 340 2014-07-04 10:50:27.848-04 0 AD
398 340 2014-07-04 11:08:32.854-04 0 DZ
999 310 2014-07-08 13:35:11.354-04 0 AL
2177 2172 2014-08-06 10:02:15.152-04 0 AF
1094 1020 2014-07-15 13:43:09.276-04 1 AX
1293 1292 2014-07-18 15:49:13.024-04 0 AL
1447 1442 2014-07-25 10:40:21.233-04 0 DZ
1557 1515 2014-07-29 14:36:16.972-04 0 AU
2182 2172 2014-08-06 10:02:15.191-04 0 AO
1750 1734 2014-08-01 16:13:40.624-04 5 AF
2188 2172 2014-08-06 10:02:15.227-04 0 AC
2138 2133 2014-08-06 09:59:11.914-04 7888 AL
2241 2221 2014-08-06 10:40:29.194-04 0 AX
644 310 2014-07-04 11:10:23.363-04 0 UM
664 340 2014-07-04 13:07:00.099-04 0 AW
666 340 2014-07-04 13:09:46.802-04 0 AG
665 340 2014-07-07 13:01:02.924-04 5 AX
1026 329 2014-07-09 16:52:43.872-04 0 AL
1096 1020 2014-07-15 13:43:05.355-04 4 AF
2178 2172 2014-08-06 10:02:15.156-04 0 AL
1323 1279 2014-07-21 16:56:23.305-04 2 FR
1500 1496 2014-07-28 11:29:01.24-04 0 DZ
1584 1572 2014-07-29 16:21:42.687-04 1 AF
2153 2133 2014-08-06 09:58:50.004-04 0 AD
2156 2155 2014-08-06 09:58:50.004-04 0 AD
2157 2155 2014-08-06 09:59:11.914-04 7888 AL
2158 2155 2014-08-05 17:13:22.121-04 3 AX
2185 2172 2014-08-06 10:02:15.203-04 0 AR
2375 2370 2014-08-08 10:25:16.959-04 0 AF
668 340 2014-07-04 13:17:45.422-04 0 AR
1097 1020 2014-07-15 13:42:59.165-04 0 AL
1342 1339 2014-07-21 17:03:31.95-04 1 AL
1353 1339 2014-07-21 17:05:22.251-04 0 AF
2179 2172 2014-08-06 10:02:15.159-04 0 AS
1501 1496 2014-07-28 11:29:05.693-04 3 AX
1585 1572 2014-07-29 16:21:49.872-04 3 AL
2184 2172 2014-08-06 10:02:15.203-04 0 AG
2190 2172 2014-08-06 10:02:15.243-04 0 AQ
2374 2370 2014-08-08 10:25:16.959-04 0 AX
670 340 2014-07-04 13:51:17.064-04 0 AL
671 340 2014-07-07 15:06:10.358-04 2 AF
2180 2172 2014-08-06 10:02:15.158-04 0 DZ
1169 1165 2014-07-18 13:16:27.707-04 4 AF
2186 2172 2014-08-06 10:02:15.203-04 0 AM
1168 1165 2014-07-18 15:01:47.394-04 3234 AL
1445 1442 2014-07-25 10:40:21.213-04 0 AX
2661 2657 2014-08-12 15:19:56.729-04 0 AF
1502 1496 2014-07-28 11:29:09.073-04 1 AL
1586 1572 2014-07-29 16:21:45.97-04 2 AX
1170 1165 2014-07-18 13:16:32.119-04 99 AX
1444 1442 2014-07-25 10:40:21.211-04 0 AF
1555 1515 2014-07-29 14:36:16.972-04 0 AQ
2181 2172 2014-08-06 10:02:15.164-04 0 AD
1587 1572 2014-07-29 16:21:54.354-04 4 DZ
2187 2172 2014-08-06 10:02:15.21-04 0 AW
2662 2657 2014-08-12 15:19:56.729-04 0 AX
638 310 2014-07-04 11:10:07.779-04 0 VN
649 340 2014-07-04 11:17:27.07-04 0 AI
\.
--
-- Data for Name: commercial_usage_entry; Type: TABLE DATA; Schema: public; Owner: mlds
--
COPY commercial_usage_entry (commercial_usage_entry_id, created, name, start_date, end_date, country_iso_code_2, commercial_usage_id, note) FROM stdin;
1005 2014-07-09 10:34:37.886-04 afgan 1 2014-07-09 \N AF 329 \N
700 2014-07-07 12:43:38.211-04 uei 2012-07-07 2012-08-01 AF 340 \N
1099 2014-07-15 14:06:56.861-04 ou 2014-07-17 \N AF 1020 \N
1115 2014-07-16 14:37:27.325-04 able 2014-07-01 \N AF 1020 \N
1116 2014-07-16 14:37:39.576-04 later 2014-05-22 \N AF 1020 \N
1117 2014-07-16 14:37:52.089-04 ZZZZ 2014-05-14 \N AF 1020 \N
1118 2014-07-16 14:47:14.994-04 Babel 2014-03-05 \N AF 1020 \N
1171 2014-07-18 13:16:21.175-04 ouoeu 2014-07-02 \N AF 1165 \N
1324 2014-07-21 16:56:42.856-04 france hosp 1 2014-06-30 \N FR 1279 a hospital
1352 2014-07-21 17:05:20.106-04 alb host 2014-07-09 \N AL 1339 \N
1558 2014-07-29 14:36:32.695-04 ascen 2014-06-03 \N AC 1515 \N
1797 2014-07-31 14:30:04.526-04 hopital 2 2014-02-26 2014-07-25 AF 1734 \N
699 2014-07-07 12:24:28.516-04 alg 1 2014-07-07 2014-07-01 DZ 340 \N
1796 2014-07-31 14:29:51.73-04 hopital 1 2014-02-18 \N AF 1734 some notes
701 2014-07-07 13:39:42.522-04 afg 1 2014-04-08 2015-01-16 AF 340 \N
2139 2014-08-05 17:13:32.433-04 hos 2014-01-17 \N AX 2133 \N
2154 2014-08-06 09:59:01.253-04 andorra hos 2014-08-11 \N AD 2133 \N
2159 2014-08-06 09:59:01.253-04 andorra hos 2014-08-11 \N AD 2155 \N
2160 2014-08-05 17:13:32.433-04 hos 2014-01-17 \N AX 2155 \N
\.
--
-- Data for Name: country; Type: TABLE DATA; Schema: public; Owner: mlds
--
COPY country (iso_code_2, iso_code_3, common_name, exclude_registration, alternate_registration_url, member_id) FROM stdin;
ZZ ZZZ Z Land f \N 1438
ZW ZWE Zimbabwe f \N 2310
AF AFG Afghanistan f \N 2308
FR FRA France f \N 2309
AU AUS Australia t https://nehta.org.au/aht/ 1437
BE BEL Belgium t http://www.health.belgium.be/eportal 1437
BN BRN Brunei t http://www.moh.gov.bn/ 1437
CA CAN Canada t http://sl.infoway-inforoute.ca/content/disppage.asp?cw_page=secure_snomedct_standards_e 1437
CL CHL Chile t http://www.ocis.cl/ 1437
CZ CZE Czech Republic t http://www.ksrzis.cz/ 1437
DK DNK Denmark t http://www.ssi.dk/snomedct 1437
EE EST Estonia t http://www.e-tervis.ee/index.php/en/ 1437
US USA United States t http://www.nlm.nih.gov/ \N
GB GBR United Kingdom t http://systems.hscic.gov.uk/data/uktc \N
AL ALB Albania f \N 1437
DZ DZA Algeria f \N 1437
AD AND Andorra f \N 1437
AO AGO Angola f \N 1437
AG ATG Antigua and Barbuda f \N 1437
AR ARG Argentina f \N 1437
AM ARM Armenia f \N 1437
AT AUT Austria f \N 1437
AZ AZE Azerbaijan f \N 1437
BS BHS Bahamas, The f \N 1437
BH BHR Bahrain f \N 1437
BD BGD Bangladesh f \N 1437
BB BRB Barbados f \N 1437
BY BLR Belarus f \N 1437
BZ BLZ Belize f \N 1437
BJ BEN Benin f \N 1437
BT BTN Bhutan f \N 1437
BO BOL Bolivia f \N 1437
BA BIH Bosnia and Herzegovina f \N 1437
BW BWA Botswana f \N 1437
BR BRA Brazil f \N 1437
BG BGR Bulgaria f \N 1437
BF BFA Burkina Faso f \N 1437
BI BDI Burundi f \N 1437
KH KHM Cambodia f \N 1437
CM CMR Cameroon f \N 1437
CV CPV Cape Verde f \N 1437
CF CAF Central African Republic f \N 1437
TD TCD Chad f \N 1437
CN CHN China, People's Republic of f \N 1437
CO COL Colombia f \N 1437
KM COM Comoros f \N 1437
CD COD Congo, (Congo Kinshasa) f \N 1437
CG COG Congo, (Congo Brazzaville) f \N 1437
CR CRI Costa Rica f \N 1437
CI CIV Cote d'Ivoire (Ivory Coast) f \N 1437