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 |
|---|---|---|---|---|---|---|---|---|---|
| 47217 | 47217 | 1928-07-14 | 2 | b | Confucian temple is preserved and the comments by He Peiyu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098874 | 24098874 | |
| 47218 | 47218 | 1928-07-14 | 2 | c | The death of Zhang Zuolin is related to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24098874 | 24098874 | |
| 47219 | 47219 | 1928-07-14 | 2 | d | Former Chinese president Li Yuanhong dies of illness in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24098874 | 24098874 | |
| 47220 | 47220 | 1928-07-14 | 2 | f | Qi Xieyuan has replaced Sun Chuanfang to command his army. | China | http://trove.nla.gov.au/newspaper/page/24098874 | 24098874 | |
| 47221 | 47221 | 1928-07-14 | 2 | f | Territorial disputes after the collapse of the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24098874 | 24098874 | |
| 47222 | 47222 | 1928-07-14 | 3 | b | Zhu Zhaoxin to be foreign minister of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47223 | 47223 | 1928-07-14 | 3 | b | Feng Yuxiang confesses that he accepted financial aid from Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47224 | 47224 | 1928-07-14 | 3 | b | Zang Zhengyi is now managing the Fengtian offices after the death of Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47225 | 47225 | 1928-07-14 | 3 | c | Tax deduction for the Chinese products, new regulations issued by the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47226 | 47226 | 1928-07-14 | 3 | d | Newspaper in Geneva comments on the Chinese situation. | Other... | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47227 | 47227 | 1928-07-14 | 3 | d | Japanese prime minister narrowly escapes an assassination. | Japan | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47228 | 47228 | 1928-07-14 | 3 | f | True report on Japanese invasion in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47229 | 47229 | 1928-07-14 | 3 | f | Two newspapers in Beijing stop publication. | China | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47230 | 47230 | 1928-07-14 | 3 | f | Women allowed to inherit assets as men, says the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24098873 | 24098873 | |
| 47231 | 47231 | 1928-07-14 | 5 | a | Hong Kong news/ Three big companies are closed in Tokyo. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098875 | 24098875 | |
| 47232 | 47232 | 1928-07-14 | 5 | b | Second part of the survey in the apiculture in Zhili (Hebei) province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098875 | 24098875 | |
| 47233 | 47233 | 1928-07-14 | 6 | a-d | Guangdong news/ Plan for civil aviation development in Guangdong and Guangxi. Government employees are arrested for gambling or opium smoking. The civil service system in Guangdong under the control of the Party. Government employees are arrested for visiting prostitutes. Plague of locusts in Chaoyang county. | China | http://trove.nla.gov.au/newspaper/page/24098878 | 24098878 | |
| 47234 | 47234 | 1928-07-14 | 7 | a-d | Guangdong news/ Orders issued by the provincial government to protect the Confucian temples. Leader of the Communist Youth league Zhang Qihui is executed in Guangzhou. Strange beggar kills his son. Policeman turns to thief in Guangzhou. Execution of bandits and the Communists. Theatre collapses in Taishan county. A woman kidnapped in Taishan county. Execution of bandit chieftain in Shunde county. Ferry hijacked in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24098877 | 24098877 | |
| 47235 | 47235 | 1928-07-14 | 8 | a | The Nanjing government delivers ultimate to foreign missions for the treaty and others. | China | http://trove.nla.gov.au/newspaper/page/24098880 | 24098880 | |
| 47236 | 47236 | 1928-07-14 | 8 | a | British businessman is detained for interrogation. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098880 | 24098880 | |
| 47237 | 47237 | 1928-07-14 | 8 | a | Japanese government and its China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24098880 | 24098880 | |
| 47238 | 47238 | 1928-07-14 | 8 | b | British foreign secretary is questioned in the House of Commons on China's debt. | Britain | http://trove.nla.gov.au/newspaper/page/24098880 | 24098880 | |
| 47239 | 47239 | 1928-07-14 | 8 | b | Japan to withdraw troops from Shandong. | Japan | http://trove.nla.gov.au/newspaper/page/24098880 | 24098880 | |
| 47240 | 47240 | 1928-07-14 | 8 | b | Prison explodes in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24098880 | 24098880 | |
| 47241 | 47241 | 1928-07-14 | 8 | b | Australia news/ A farmer in New South Wales is sentenced for making marriage proposal by force. A plane crashes in Sydney. Baptism ceremony at the Chinese Presbyterian Church in Sydney and the attendance. Birth rate in New South Wales in the past year. Land price in Sydney: now and the past. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098880 | 24098880 |
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]);