6,238,896 rows

View and edit SQL

Suggested facets: effectivedate (date)

Link crno effectivedate name namelang
0000001 1865-10-12 BRITISH TRADERS' INSURANCE COMPANY LIMITED -THE- English
0000002 1865-10-20 HONGKONG CANTON & MACAO STEAMBOAT CO. LTD. -THE- English
0000003 1866-03-02 HONGKONG HOTEL COMPANY LIMITED -THE- English
0000003 1923-11-17 HONGKONG AND SHANGHAI HOTELS, LIMITED -THE- English
0000003 1993-06-10 HONGKONG AND SHANGHAI HOTELS, LIMITED -THE- English
0000003 1993-06-10 香港上海大酒店有限公司 Chinese
0000004 1866-10-11 HONG KONG AND WHAMPOA DOCK COMPANY LIMITED -THE- English
0000005 1868-12-23 HONG KONG FIRE INSURANCE COMPANY LIMITED -THE- English
0000006 1870-02-22 CHINA FIRE INSURANCE COMPANY LIMITED -THE- English
0000007 1878-02-01 CHINA SUGAR REFINING COMPANY, LIMITED English
0000008 1880-12-31 HONGKONG ICE COMPANY LIMITED -THE- English
0000009 1881-03-14 MAN ON INSURANCE COMPANY LTD. -THE- English
0000010 1881-12-15 CANTON INSURANCE OFFICE LIMITED -THE- English
0000010 1953-11-01 LOMBARD INSURANCE COMPANY LIMITED English
0000010 1996-01-25 (滙豐保險(國際)有限公司) Chinese
0000010 1996-01-25 HSBC INSURANCE (INTERNATIONAL) LIMITED English
0000011 1882-10-24 UNION INSURANCE SOCIETY OF CANTON, LIMITED English
0000011 2002-09-16 UNION SOCIETY OF CANTON, LIMITED English
0000012 1883-07-28 DOUGLAS STEAMSHIP COMPANY LIMITED -THE- English
0000013 1883-10-08 HONGKONG ROPE MANUFACTURING CO LTD -THE- English
0000013 1964-04-30 REALTY DEVELOPMENT CORPORATION LIMITED English
0000013 1964-04-30 聯邦地產有限公司 Chinese
0000014 1885-12-31 HONG KONG CLUB -THE- English
0000015 1886-01-19 A. S. WATSON & COMPANY, LIMITED English
0000015 2006-06-15 A. S. WATSON & COMPANY, LIMITED English
0000015 2006-06-15 屈臣氏有限公司 Chinese
0000016 1886-07-02 CAMPBELL MOORE & COMPANY LIMITED English
0000017 1886-11-15 HONGKONG & KOWLOON WHARF & GODOWN CO LTD English
0000017 1986-10-06 WHARF (HOLDINGS) LIMITED -THE- English
0000017 2014-06-13 (九龍倉集團有限公司) Chinese
0000017 2014-06-13 Wharf (Holdings) Limited -The- English
0000018 1887-01-03 GREEN ISLAND CEMENT COMPANY, LIMITED English
0000018 2002-11-20 GREEN ISLAND CEMENT COMPANY, LIMITED English
0000018 2002-11-20 青洲英坭有限公司 Chinese
0000019 1888-02-14 NORTH & RAE LIMITED English
0000020 1888-05-26 YOKOHAMA ENGINE & IRON WORKS LTD -THE- English
0000021 1889-01-24 HONG KONG ELECTRIC COMPANY, LIMITED -THE- English
0000021 1994-05-31 HONGKONG ELECTRIC COMPANY, LIMITED -THE- English
0000021 1994-05-31 香港電燈有限公司 Chinese
0000022 1889-02-15 GRAND HOTEL COMPANY LIMITED -THE- English
0000023 1889-03-02 HONGKONG LAND INVESTMENT AND AGENCY COMPANY, LIMITED -THE- English
0000023 1972-04-19 HONGKONG LAND COMPANY, LIMITED -THE- English
0000023 1972-04-19 香港置地有限公司 Chinese
0000024 1889-03-19 WEST POINT BUILDING COMPANY LIMITED -THE- English
0000025 1889-04-06 CLUB HOTEL LIMITED -THE- English
0000026 1889-06-20 KOWLOON LAND & BUILDING CO. LTD. -THE- English
0000027 1891-03-13 HONGKONG STOCK EXCHANGE -THE- English
0000028 1891-04-15 INSTITUTION OF ENGINEERS & SHIPBUILDERS OF HONGKONG -THE- English
0000029 1891-08-28 ORIENTAL HOTEL LIMITED -THE- English
0000030 1891-10-07 HUMPHREYS ESTATE & FINANCE COMPANY, LIMITED English
0000031 1892-08-20 BRETT AND COMPANY LIMITED English
0000033 1895-03-02 CHUN ON FIRE INSURANCE COMPANY LIMITED -THE- English
0000033 1982-05-21 (全安投資有限公司) Chinese
0000033 1982-05-21 CHUN ON INVESTMENT COMPANY LIMITED English
0000034 1895-06-20 PO ON MARINE & FIRE INSURANCE AND GODOWN COMPANY LIMITED -THE- English
0000035 1896-05-29 UNITED ASBESTO ORIENTAL AGENCY LTD -THE- English
0000036 1896-08-04 DAIRY FARM COMPANY, LIMITED -THE- English
0000036 1918-04-15 DAIRY FARM, ICE & COLD STORAGE COMPANY, LIMITED -THE- English
0000036 1983-01-07 DAIRY FARM COMPANY, LIMITED -THE- English
0000036 1994-09-08 DAIRY FARM COMPANY, LIMITED -THE- English
0000036 1994-09-08 牛奶有限公司 Chinese
0000037 1896-09-18 TAI SHING PAPER MANUFACTURING CO. LTD -THE- English
0000038 1898-02-19 CHINA PROVIDENT LOAN & MORTGAGE CO. LTD. English
0000038 1958-12-17 CHINA PROVIDENT COMPANY, LIMITED English
0000039 1898-04-23 "STAR" FERRY COMPANY LIMITED -THE- English
0000040 1899-03-23 HELM BROTHERS LIMITED English
0000041 1899-03-28 TUNG ON FIRE INSURANCE COMPANY LTD English
0000041 1899-03-28 同安火燭保險有限公司 Chinese
0000041 1954-06-08 TUNG ON INVESTMENT COMPANY, LIMITED English
0000041 1954-06-08 同安置業有限公司 Chinese
0000042 1899-05-06 I ON MARINE & FIRE INSURANCE COMPANY LIMITED -THE- English
0000043 1899-06-23 HONG KONG & KOWLOON LAND & LOAN COMPANY LIMITED English
0000044 1900-03-07 ROBINSON PIANO COMPANY LIMITED -THE- English
0000045 1900-11-01 CHINESE PRINTING & PUBLISHING CO. LTD -THE- English
0000046 1901-01-08 FOOK ON ASSURANCE & GODOWN CO. LTD -THE- English
0000047 1901-01-25 CHINA LIGHT & POWER COMPANY LIMITED English
0000048 1901-03-27 FUMIGATING & DISINFECTING BUREAU LIMITED -THE- English
0000049 1901-06-17 YAN ON MARINE & FIRE INSURANCE COMPANY LIMITED -THE- English
0000050 1901-06-24 WILLIAM POWELL LIMITED English
0000051 1901-11-22 SHIU ON STEAMSHIP COMPANY LTD. -THE- English
0000052 1902-04-16 HONGKONG LAND RECLAMATION CO. LTD -THE- English
0000053 1902-04-23 PEAK CLUB -THE- English
0000054 1902-05-30 STEAM LAUNDRY COMPANY LTD. -THE- English
0000055 1903-02-07 CHINA BORNEO COMPANY LIMITED -THE- English
0000056 1903-02-24 SIU YIK LOAN & GODOWN CO. LTD -THE- English
0000057 1903-03-18 SOUTH CHINA MORNING POST LIMITED English
0000057 1990-07-27 NEWS PRINTING LIMITED English
0000057 2013-07-03 21st Century Fox Printing Limited English
0000058 1903-06-25 LUN YICK MUTUAL FIRE & MARINE INSURANCE COMPANY LIMITED -THE- English
0000058 1974-06-28 LUN YICK INSURANCE COMPANY LIMITED English
0000058 1974-06-28 聯益保險有限公司 Chinese
0000058 2005-12-15 LUN YICK INVESTMENT (1903) COMPANY LIMITED English
0000058 2005-12-15 聯益投資(1903)有限公司 Chinese
0000059 1903-07-23 YUEN ON STEAMSHIP COMPANY LTD -THE- English
0000060 1904-01-27 PHILIPPINE COMPANY LIMITED English
0000061 1904-05-17 ANGLO CHINESE EDUCATION TRUST CO. LTD English
0000062 1904-07-11 YOKOHAMA UNITED CLUB -THE- English
0000063 1904-10-08 CLIFFORD WILKINSON TANSAN MINERAL WATER CO. LIMITED -THE- English
0000064 1904-11-01 WISEMAN LIMITED English
0000065 1904-12-31 HIRANO MINERAL WATER COMPANY LTD -THE- English

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [companiesnames] (
   [crno] TEXT REFERENCES [companies]([crno]),
   [effectivedate] TEXT,
   [name] TEXT,
   [namelang] TEXT,
   PRIMARY KEY ([crno], [effectivedate], [name])
);
CREATE INDEX [idx_companiesnames_crno_effectivedate]
    ON [companiesnames] ([crno], [effectivedate]);
CREATE INDEX [idx_companiesnames_crno]
    ON [companiesnames] ([crno]);