-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert_opid.sql
186 lines (185 loc) · 6.8 KB
/
insert_opid.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
use org_uni_ids;
insert into opid (company_id, organization) values
("00009A","SpeedConnect, LLC"),
("00009D","Macheen, Inc."),
("000030","Comcast Cable"),
("000037","Imagine Group Limited"),
("000031","Comcast Cable"),
("00002E","I-Pac Communications Limited"),
("00002F","Sprint"),
("00002D","e-Via S.p.A."),
("000027","Intel Corporation"),
("000024","CTY Co., Ltd."),
("000025","DigitalBridge Communications"),
("000026","Intel Corporation"),
("000023","Asiaspace WiMAX Sdn. Bhd."),
("00001B","Globe Telecom"),
("00001C","“MMDS-Ukraine†LLC"),
("00001D","DBD Deutsche Breitband Dienste GmbH"),
("000019","Etihad Atheeb Telecommunications"),
("00001A","VTR Banda Ancha (Chile) S.A."),
("000001","NextWave Broadband, Inc."),
("000005","HDRR"),
("00005F","CaribeServe.net"),
("000064","NGI SPA"),
("000058","Obihiro City Cable, Inc."),
("000070","mada commnications"),
("000055","Rincon Research Corporation"),
("000056","First International Telecom Corporation (FITEL)"),
("00004F","Aksoran LLC"),
("00004D","Wimax Forum"),
("00004E","Scarlet B.V."),
("00004B","Etihad Etisalat Company"),
("00004C","Wimax Forum"),
("000082","Sprint Nextel"),
("00008A","Umniah Mobile Company"),
("00007E","CosmoAir, LTD"),
("00007C","CommSpeed, LLC"),
("000059","Digicel Jamaica"),
("000060","Fujikura Ltd."),
("00006C","Valley Technologies (Pvt) Ltd"),
("000073","Alpha Communication Networks, SA (ACN)"),
("000061","Bolloré Telecom"),
("000062","NuevaTel PCS De Bolivia"),
("000057","Sky Network Private Limited"),
("000063","Omani Qatari Telecommunication Co. SAOC (NAWRAS)"),
("000045","Adam Internet Pty Ltd"),
("000041","Vermont Telephone Company"),
("000042","Intellectual Communication LLC"),
("000043","N1 Communications"),
("000044","Alpha Tel S.A."),
("00003A","Open Range Communications"),
("00003B","Northern Michigan University"),
("000038","Liberty Technologies"),
("000039","Wisper Wireless Solutions, LLC"),
("000091","Ariana Network Service"),
("00008E","Areeba Guinea"),
("000106","SIS Sat Internet Services GmbH"),
("0000AF","LLC TTK-Svyaz"),
("0000AC","RC Technologies"),
("0000A8","Gardonville Cooperative Telephone Association"),
("000102","Redwood County Telephone, d.b.a. Arvig"),
("0000A7","Breitbandnetz Sachsen GmbH"),
("0000A4","Locus Telecommunications, Inc."),
("00009B","Bangladesh Internet Exchange Limited"),
("000094","Regional Telecom"),
("00006A","Gulfsat Madagascar"),
("000076","PT Berca Global Access"),
("000085","DGM(BBNW), Bangalore, O/o GM(BBNW) Bharat Sanchar Nigam Limited (BSNL)"),
("000088","Haiti Networking Group S.A."),
("000081","Datame Oy"),
("00007A","Intercom S.R.L."),
("000067","Callplus Services Limited"),
("00006E","Azqtel Ltd"),
("000098","Reinan Cable Network Co. Ltd."),
("00008C","Swift Networks LTD"),
("000013","Menatelecom"),
("000011","MIRS Communications Ltd"),
("000012","Packet One Networks (M) Sdn Bhd"),
("00000F","Wi-Tribe Limited"),
("000010","Axtel S.A.B. de C.V."),
("000002","Clearwire Corporation"),
("000006","Clearwire Corporation"),
("000104","EarthLink, Inc."),
("0000AA","FreedomPop"),
("0000A5","NetZero Wireless, Inc."),
("0000A1","Government of Guyana"),
("00009E","BroadBreeze LLC"),
("000054","U-Konekt Technologies LTD"),
("000052","Direct on PC Limited"),
("000053","NTT Communications Corporation"),
("000050","Vee Telecom Multimedia Co. Ltd."),
("000051","Â 7netlayers"),
("000049","Clearwire Espana"),
("00004A","UMD Maxwell Lab"),
("000046","AugereWireless Broadband Bangladesh, LTD"),
("000047","Craig Wireless"),
("000048","Main Street Broadband"),
("00003F","Kyocera Communication Systems"),
("000040","YTL Communications SDN BHD"),
("00003D","Yota de Nicaragua, S.A."),
("000078","Nokia Siemens Networks."),
("000071","Alcatel-Lucent"),
("00005E","MTN Côte d'Ivoire"),
("000065","Smart Communications"),
("00006D","Digicel Cayman"),
("00005A","Wind Telecom"),
("000074","Zain Bahrain"),
("00005B","Banglalion Communications Ltd."),
("00005C","Altitude Infrastructure"),
("00005D","Yota Bel LLC"),
("00002A","Axione"),
("00002B","Connecteo Cameroun"),
("000028","Aria S.p.A."),
("000029","JSC COMSTAR - United TeleSystems"),
("00003E","Sioux Valley Wireless"),
("00003C","KDDI Corporation"),
("000033","Time Warner Cable, LLC"),
("000034","Time Warner Cable, LLC"),
("000035","Burco Electronic Systems Ltd"),
("000036","Soma Networks"),
("000032","InterProekt"),
("00002C","SC Lithuanian Radio & TV Center"),
("000096","Núcleo Operacional para a Sociedade de Informação"),
("000092","ZAPP.pt (registered as mobiZAPP -Com. Electronics SA)"),
("00008F","Spectranet Ltd."),
("00008B","Access Telecom (BD) LTD"),
("000083","Barrett Xplore, Inc."),
("00007F","Full Stream, LLC."),
("000020","Linkem Spa"),
("000021","Grid Net"),
("000022","Mandarin WiMax Sicilia SpA"),
("00001F","Freedom4 Ltd"),
("00001E","DBD Deutsche Breitband Dienste GmbH"),
("000007","Clearwire Corporation"),
("000003","Société du Haut Débit (SHD)"),
("000107","Wisper ISP"),
("000103","Siportal srl"),
("0000AD","Jolt Mobile"),
("0000A9","Telefonica Celular del Paragua S.A."),
("00009C","New Generation Graphics Limited"),
("000099","Heartnetwork Co., Ltd."),
("000095","SkyOnline de Argentina S.A."),
("00008D","Cablevision S.A."),
("000086","4G Africa AG"),
("000089","Al Sard Trading Agencies Co. Limited"),
("00007D","Rocky Mountain Broadband, LLC"),
("00007B","Mobitel Limited, Nigeria"),
("000068","Open Joint Stock Company Soyuz-Telecom"),
("00006F","2K Telecom"),
("00006B","Itochu Techno-Solution Corporation"),
("000077","MultiLink S.A."),
("00000E","Wi-Tribe Limited"),
("00000B","Solectek Corporation"),
("000008","Moline Dispatch Publishing Company"),
("00000A","UK Broadband"),
("000004","Clearwire Corporation"),
("000018","WorldMax Operations B.V."),
("000014","UQ Communications Inc."),
("000015","SCARTEL Ltd."),
("000016","Monzoon Networks AG"),
("000017","WorldMax Operations B.V."),
("00000C","WiMax Telecom AG"),
("00000D","Wi-Tribe Limited"),
("000105","Global Broadband Solution SPRL"),
("000101","Multinet Mozambique"),
("0000AB","Simplexity"),
("0000AE","Karma Mobility"),
("0000A6","Nu Informationssysteme Gmbh"),
("0000A0","XSTREAM SRL"),
("00009F","Malawi Telecommunications Limited"),
("0000A2","Bryan Independent School District"),
("0000A3","COTE D IVOIRE TELECOM"),
("000093","BVCNET"),
("000097","Intercellular Nigeria PLC"),
("000100","Manitoba NetSet Ltd."),
("000087","Best Buy Connect"),
("000080","OLO DEL PERU S.A.C"),
("000084","Viti SAS"),
("000079","PT First Media, TBK"),
("000090","Horizon Broadcasting & Telecommunications Limited"),
("000066","Open Wireless Platform, LLC"),
("000072","GSM Kazakhstan OJSC Kazakhtelecom LLP"),
("000069","Choice Communications, LLC"),
("000075","QMAX Communications Pte, Ltd."),
("000009","Pine Telephone Company Inc.");