This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40122 | 40122 | 1923-07-21 | 3 | a | Members of the Chinese parliament demand payment of their overdue salary. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40133 | 40133 | 1923-07-21 | 6 | a | Poems by Miao Huili and Wu Elou (Xiuguang), editor of the Tung Wah Times, farewells Gao Ruilin on his return to China, and poems in reply by Gao Ruilin. Poems by Zhu Tingjia on the current situation in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40139 | 40139 | 1923-07-21 | 7 | a | Commonwealth government of Australia raises money to repay the internal bonds. | Australia | http://trove.nla.gov.au/newspaper/page/24094483 | 24094483 | |
40140 | 40140 | 1923-07-21 | 7 | a | An ex-service nurse dies in an abortion in Sydney and the investigation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094483 | 24094483 | |
40141 | 40141 | 1923-07-21 | 7 | a | Chinese football (soccer) team is coming to visit Sydney by Japanese liner from Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094483 | 24094483 | |
40149 | 40149 | 1923-07-21 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094486 | 24094486 |
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]);