This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45992 | 45992 | 1927-08-06 | 2 | b | Names listed for donations to the transfer of remains of the deceased Chinese fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098480 | 24098480 | |
45993 | 45993 | 1927-08-06 | 2 | c | Editorial by Tung Wah Times on the war in China and the possibility to avoid war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098480 | 24098480 | |
46019 | 46019 | 1927-08-06 | 7 | a | Poems by Zhong Jiayi in response to Wu Elou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098483 | 24098483 | |
46020 | 46020 | 1927-08-06 | 7 | a | Australia news/ Drought in Queensland reduces the trade. Gas price going up in Sydney. A train derails in Tamworth. The case of a Chinese life in Townsville. A football match in Sydney. Thieves in Sydney and their knives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098483 | 24098483 | |
46025 | 46025 | 1927-08-06 | 7 | c | A prophet and his talks. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098483 | 24098483 | |
46026 | 46026 | 1927-08-06 | 7 | c | Folk song in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098483 | 24098483 | |
46027 | 46027 | 1927-08-06 | 9 | a-d | Guangdong news/ People in Chaozhou and Shantou oppose to the price increase of railway. Rice riots in Boluo county. Railway workers prepares for strike. Liang Yaozong and his troops are armed. Some communists flee to Nanyang. Li Jishen proposes to re-organise local civil corps. Qian Dajun is going to Nanjing secretly. Bandits in Heshan county. Jiang Jieshi and Hu Hanmin award overseas comrades. Newspaper in Taishan county under siege. | Tung Wah |
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]);