This data as json, CSV (advanced)
Suggested facets: date, column, title, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 20574 | 20574 | 1909-01-23 | 12 | a | Photograph of Wu E'lou (Xiuguang), editor of The Tung Wah Times, and his Chinese New Year greetings. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802040 | 26802040 | |
| 20575 | 20575 | 1909-01-23 | 12 | b | Rich countries around the world (United States of America, Germany, France, Russia and Britain) | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802040 | 26802040 | |
| 22371 | 22371 | 1910-02-12 | 12 | a | The city of New York. Photograph of New York city government building and the post office building. | Tung Wah | https://trove.nla.gov.au/newspaper/page/26802504 | 26802504 | |
| 24258 | 24258 | 1911-02-04 | 12 | a-b | An editorial note on world progress of deaf-mute education | The progress of deaf-mute education in the world. | Australia | http://trove.nla.gov.au/newspaper/page/24091633 | 24091633 |
| 24259 | 24259 | 1911-02-04 | 12 | b | The characteristics of Korean people | It is about the characteristics of Korean people. | Other... | http://trove.nla.gov.au/newspaper/page/24091633 | 24091633 |
| 24260 | 24260 | 1911-02-04 | 12 | b | Art relics found in South America | Some art relics of 7000 years old were found in South America. | Other... | http://trove.nla.gov.au/newspaper/page/24091633 | 24091633 |
| 25784 | 25784 | 1912-02-24 | 12 | a | Business organisation treaty between Russia and Japan | Both Russia and Japan recognise business organisations set up in their places. | Other... | http://trove.nla.gov.au/newspaper/page/24092128 | 24092128 |
| 25785 | 25785 | 1912-02-24 | 12 | a | Case of ban on binding waist | Queen of Yugoslavia advises ban on women's binding waists and the movement is followed by Russia,Germany and France. | Other... | http://trove.nla.gov.au/newspaper/page/24092128 | 24092128 |
| 31958 | 31958 | 1917-01-27 | 12 | a | Photographs of Tang Jiyao, military governor of Yunnan province, and the late Cai E, military governor of Sichuan province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095575 | 24095575 | |
| 31959 | 31959 | 1917-01-27 | 12 | a | Article written by Ding Yihua on the world peace in the future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095575 | 24095575 | |
| 31960 | 31960 | 1917-01-27 | 12 | a-b | Local provinces in China to set up offices for internal affairs, finance, education and industrial development, and the explanation. | China | http://trove.nla.gov.au/newspaper/page/24095575 | 24095575 | |
| 31961 | 31961 | 1917-01-27 | 12 | c | Advertisement for Brunton's flour, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095575 | 24095575 | |
| 31962 | 31962 | 1917-01-27 | 12 | c | Advertisement for Anderson & Co Ltd, seedsmen in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095575 | 24095575 | |
| 32984 | 32984 | 1918-02-16 | 12 | a | Photograph of the Mekong River and the streets in Bangkon, Thailand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097189 | 24097189 | |
| 32985 | 32985 | 1918-02-16 | 12 | c | Advertisement for Mick Simmons Ltd, the leading tobacco warehouse in the Commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097189 | 24097189 | |
| 34105 | 34105 | 1919-02-08 | 12 | a | Australia news/ A gathering of the Chinese communities in Brisbane (to organise the Australian Chinese Association against Discrimination) and speakers include Liu Jing, Chen Limei, Ruan Li, Li Kuang, Huang Pusheng, Lin Dang, Chen He and others. Liu Jing represents the Chinese communities in Queensland at the Melbourne Chinese conference for the wei chi jin li hui. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 34106 | 34106 | 1919-02-08 | 12 | a | Advertisement for Thos. Pan Kee, storekeeper in Narrabri, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 34107 | 34107 | 1919-02-08 | 12 | a | A notice by the Church of England Chinese Mission in Sydney (for the Sunday services and the night English school). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 34108 | 34108 | 1919-02-08 | 12 | b | A holiday notice from the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 34109 | 34109 | 1919-02-08 | 12 | b | A notice by the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 34110 | 34110 | 1919-02-08 | 12 | b | Advertisement for D. S. Ford, printers in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 34111 | 34111 | 1919-02-08 | 12 | b | Vegetable garden for sale by Xin He. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 34112 | 34112 | 1919-02-08 | 12 | c | Advertisement for Arnott's biscuits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 34113 | 34113 | 1919-02-08 | 12 | d | Advertisement for Mick Simmons Ltd, the leading tobacco warehouse in the Commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
| 35360 | 35360 | 1920-02-21 | 12 | a | Seventh part of the disgraceful history of China, written by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098060 | 24098060 | |
| 35361 | 35361 | 1920-02-21 | 12 | a | Photograph of Zeng Yan, envoy from the south for peace talks in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098060 | 24098060 | |
| 35362 | 35362 | 1920-02-21 | 12 | a-b | Population of Australia and the distribution in each of the six states. Education in Australia (primary, secondary and tertiary education in each state, tuition fee, special schools, etc). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098060 | 24098060 | |
| 35363 | 35363 | 1920-02-21 | 12 | b | Photograph of imperial palace in Burma. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098060 | 24098060 | |
| 36620 | 36620 | 1921-02-12 | 12 | a | Photograph of Chinese Prime Minister (premier) Jin Yunpeng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093437 | 24093437 | |
| 36621 | 36621 | 1921-02-12 | 12 | a-b | American consul in China has another view on the Chinese future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093437 | 24093437 | |
| 38225 | 38225 | 1922-01-28 | 12 | a | Photograph of the Liuhe Pagoda near the West Lake, Hangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093849 | 24093849 | |
| 38226 | 38226 | 1922-01-28 | 12 | a-b | Progress of the Washington Conference. | China | http://trove.nla.gov.au/newspaper/page/24093849 | 24093849 | |
| 39478 | 39478 | 1923-02-17 | 12 | a | Photograph of Moo Yeung Gateway of the Peiking City. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094305 | 24094305 | |
| 39480 | 39480 | 1923-02-17 | 12 | c | Advertisement for the Bank of New South Wales, George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094305 | 24094305 | |
| 41099 | 41099 | 1924-02-09 | 12 | a | Photograph of the wharf in the Pearl River (Zhujiang), in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100610 | 24100610 | |
| 41100 | 41100 | 1924-02-09 | 12 | c | Advertisement for the Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100610 | 24100610 | |
| 44439 | 44439 | 1926-02-13 | 12 | a | Photograph of a Chinese wedding banquet in Sydney (bridegroom Miu Huili, manager of the Tung Wah Times, and bride Sun Jinrong). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101465 | 24101465 | |
| 44440 | 44440 | 1926-02-13 | 12 | a | Japanese are keen to control the navigation on the Chinese coast and a survey. | China | http://trove.nla.gov.au/newspaper/page/24101465 | 24101465 | |
| 44441 | 44441 | 1926-02-13 | 12 | a | A navigation school in Shanghai and the admission. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101465 | 24101465 | |
| 44442 | 44442 | 1926-02-13 | 12 | a-b | A recent survey on the number of foreigners in Shanghai and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101465 | 24101465 | |
| 44443 | 44443 | 1926-02-13 | 12 | b | First part of a survey on the forestry in Shanxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101465 | 24101465 | |
| 44444 | 44444 | 1926-02-13 | 12 | c | Fourth part of report on cotton production in Shaanxi province, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101465 | 24101465 | |
| 44445 | 44445 | 1926-02-13 | 12 | c | Advertisement for the Eastern and Australian Steamship Company Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101465 | 24101465 | |
| 45477 | 45477 | 1927-02-05 | 12 | a | Industrial development and prosperity in Germany after the World War I. | Germany | http://trove.nla.gov.au/newspaper/page/24101881 | 24101881 | |
| 45478 | 45478 | 1927-02-05 | 12 | a | Photograph of the committee of the picnic in commemoration of Confucius' birthday on October 3, 1926. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101881 | 24101881 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] (
[date] TEXT,
[page] TEXT,
[column] TEXT,
[title] TEXT,
[description] TEXT,
[source] TEXT,
[page_url] TEXT,
[trove_id] TEXT
);
CREATE INDEX [idx_article_index_date]
ON [article_index] ([date]);