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 |
|---|---|---|---|---|---|---|---|---|---|
| 36258 | 36258 | 1920-11-06 | 2 | a-b | Editorial by Tung Wah Times on the governance of Guangdong by Guangdong people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098369 | 24098369 | |
| 36259 | 36259 | 1920-11-06 | 2 | b | A meeting in Guangdong to elect new military governor and the report. Lin Baoyi and his effort to mediate the conflicts. Guangzhou people welcome the peaceful solution to the current crisis. | China | http://trove.nla.gov.au/newspaper/page/24098369 | 24098369 | |
| 36260 | 36260 | 1920-11-06 | 2 | d | Li Wei asks Lu Rongting to mediate and to force Mo Rongxin to quit. | China | http://trove.nla.gov.au/newspaper/page/24098369 | 24098369 | |
| 36261 | 36261 | 1920-11-06 | 3 | a | Tang Tingguang is elected new military governor of Guangdong and the after. | China | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36262 | 36262 | 1920-11-06 | 3 | a-b | Mo Rongxin refuses to leave the office for newly-elected military governor Tang Tingguang. | China | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36263 | 36263 | 1920-11-06 | 3 | b | A public notice issued by the new military governor of Guangdong Tang Tingguang. | China | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36264 | 36264 | 1920-11-06 | 3 | c | Tang Tingguang has replaced Mo Rongxin as the military governor of Guangdong and the process. | China | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36265 | 36265 | 1920-11-06 | 3 | c | Chen Jiongming is not involved in the fighting for the military governor of Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36266 | 36266 | 1920-11-06 | 3 | c | High alert at the provincial government office in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36267 | 36267 | 1920-11-06 | 3 | d | American and British consuls mediate the conflicts in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36268 | 36268 | 1920-11-06 | 3 | d | Tan Haoming and his troops are stationed in Wuzhou and the report. | China | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36269 | 36269 | 1920-11-06 | 3 | e | American authority may recognise the new government of Mexico. | America | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36270 | 36270 | 1920-11-06 | 3 | e | The new military government in Guangdong and the peace talks in China. | America | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
| 36271 | 36271 | 1920-11-06 | 6 | a-b | Second part of the revised immigration regulations recently issued by the New Zealand authority. | New Zealand | http://trove.nla.gov.au/newspaper/page/24098375 | 24098375 | |
| 36272 | 36272 | 1920-11-06 | 6 | b-c | Miscellaneous report from China. | China | http://trove.nla.gov.au/newspaper/page/24098375 | 24098375 | |
| 36273 | 36273 | 1920-11-06 | 7 | a | Australia news/ Drought in New South Wales. The Bank of London donates to the famine victims in north China. A man in Sydney changes cheque and withdraw money from bank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098374 | 24098374 | |
| 36274 | 36274 | 1920-11-06 | 7 | a-b | Sun Yatsen and Tang Shaoyi oppose to the peace plan proposed by the Beijing government. | America | http://trove.nla.gov.au/newspaper/page/24098374 | 24098374 | |
| 36275 | 36275 | 1920-11-06 | 7 | b | The li zhi hui (Young Chinese Association of Australia) in Sydney tries to raise some funds by shares for its hotel, and the advertisement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098374 | 24098374 | |
| 36276 | 36276 | 1920-11-06 | 7 | c | Peace returns to Guangzhou and the suburbs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098374 | 24098374 | |
| 36277 | 36277 | 1920-11-06 | 8 | a-c | Chinese Chamber of Commerce in Sydney calls for donations to the famine victims in north China, contact details, and all names listed for donations (Chinese and Western people), including donations from Tasmania. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098376 | 24098376 |
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]);