This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 45513 | 45513 | 1927-03-05 | 2 | c-d | Editorial on the hope of peace in China between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101900 | 24101900 | |
| 45514 | 45514 | 1927-03-05 | 2 | d | Belgium return the concession in Tianjin to China, and China's preparation for the take-over. | China | http://trove.nla.gov.au/newspaper/page/24101900 | 24101900 | |
| 45515 | 45515 | 1927-03-05 | 2 | f | The draft outline issued by Wu Peifu for the nation building in China. | China | http://trove.nla.gov.au/newspaper/page/24101900 | 24101900 | |
| 45516 | 45516 | 1927-03-05 | 3 | e | Investigation on the loss of treasuries from the Forbidden City in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101899 | 24101899 | |
| 45517 | 45517 | 1927-03-05 | 3 | f | Chen Youren talks to Western journalist on the revolutionary movement in China. | China | http://trove.nla.gov.au/newspaper/page/24101899 | 24101899 | |
| 45518 | 45518 | 1927-03-05 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101901 | 24101901 | |
| 45519 | 45519 | 1927-03-05 | 7 | a-b | Australia news/ Rubber factory explodes in Drummoyne, Sydney. An old Chinese gardener dies in an accident. Wale caught in Sydney beach. Chinese gamblers are penalised in Sydney. White women and Chinese men are questioned in Sydney. Election of the New South Wales Chinese Chamber of Commerce and the attendance by Chinese Consul-General Wei Zijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45520 | 45520 | 1927-03-05 | 7 | b | Shanghai commercial chamber seeks to host the exhibition of Chinese Republic. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45521 | 45521 | 1927-03-05 | 7 | b | Foreign banks in Guangzhou and their profit. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45522 | 45522 | 1927-03-05 | 7 | b | Zhang Xueliang on the case of Hankou and Jiujiang. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45523 | 45523 | 1927-03-05 | 7 | c | The International Air Safety Committee. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45524 | 45524 | 1927-03-05 | 7 | c | Soviet Russian authority collect heavy tax on imported leather. | Russia | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45525 | 45525 | 1927-03-05 | 7 | c | Chinese National Chamber of Commerce on the future of Korea and its governor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45526 | 45526 | 1927-03-05 | 7 | e | Advertisement for Kwong Sing War Troupe in the Tivoli Theatre, Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45527 | 45527 | 1927-03-05 | 7 | d | Advertisement for the Government Savings Bank of New South Wales and rural bank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 45528 | 45528 | 1927-03-05 | 6 | a | Advertisement for Fosseys, the shop with the "real" sale, Sydney, Newcastle and Cessnock. | http://trove.nla.gov.au/newspaper/page/24101904 | 24101904 | ||
| 45529 | 45529 | 1927-03-05 | 8 | a-d | Guangdong news/ Li Fulin personally leads his troops to attack Yunnan province. Saint Heart School in Guangzhou is required to teach the Three People's Principles (Nationalism, Democracy and the People's Livelihood) and resistance. University of Hong Kong to teach Chinese literature. People are frozen to death in Guangzhou. The kidnap of Liang Peiji and the investigation. Racing course to be built in Guangzhou. Peasants' association in Dongguan county detains the government officials. Kidnap in Xiangshan county. Land Bureau on the amount of tax to be collected. Bandits in the Beijiang area. | China | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
| 45530 | 45530 | 1927-03-05 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
| 45531 | 45531 | 1927-03-05 | 8 | e | Advertisement for the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
| 45532 | 45532 | 1927-03-05 | 8 | f | Advertisement for Shanghai Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
| 45533 | 45533 | 1927-03-05 | 8 | f | Advertisement for Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 |
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]);