This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40814 | 40814 | 1923-12-22 | 2 | a-b | An observation on the new cabinet organised in Beijing, editorial by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094656 | 24094656 | |
40821 | 40821 | 1923-12-22 | 3 | a-b | Students in Anqing, capital of Anhui province, besiege the residence of national parliamentarian. | China | http://trove.nla.gov.au/newspaper/page/24094655 | 24094655 | |
40828 | 40828 | 1923-12-22 | 6 | a-b | An article written by Wu Xiufeng claims that Chinese government should not monopolise the industry. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094660 | 24094660 | |
40833 | 40833 | 1923-12-22 | 7 | a-b | The fundraising concert/ party in the Sydney city town hall organised by the Chinese Chamber of Commerce Sydney hospital, and those who are involved include Ye Tonggui and his wife, actor Lang Deshan, Zhang Maokuan, Zhu Hechou, Liu Guangfu, and Ma Zanfen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 |
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]);