This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40263 | 40263 | 1923-08-18 | 7 | a | Commonwealth government of Australia increases its military budget. | Australia | http://trove.nla.gov.au/newspaper/page/24094515 | 24094515 | |
40264 | 40264 | 1923-08-18 | 7 | a-c | Miscellaneous report on the visit and matches of Chinese football team in Sydney. Coordinators include Liu Guangfu, Zhou Yuanji, Zhu Hechou and Chen Yaoyuan. Comments written by Zhou Jialing on the match in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094515 | 24094515 | |
40265 | 40265 | 1923-08-18 | 7 | c | A white woman is arrested in Sydney for helping another young woman abortion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094515 | 24094515 | |
40266 | 40266 | 1923-08-18 | 7 | c | Two ships collide in the Sydney harbour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094515 | 24094515 | |
40267 | 40267 | 1923-08-18 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094515 | 24094515 |
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]);