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 |
---|---|---|---|---|---|---|---|---|---|
40561 | 40561 | 1923-10-20 | 3 | c | Cao Kun talks to Japanese journalist in Baoding. | China | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 | |
40575 | 40575 | 1923-10-20 | 7 | c | Smuggled weapons found in a Dutch ship while docking in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40576 | 40576 | 1923-10-20 | 7 | c | Workers of the gas factory are in strike in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40577 | 40577 | 1923-10-20 | 7 | c | A convict on the run is captured again in Geelong, Victoria. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40578 | 40578 | 1923-10-20 | 7 | c | An American tourist reports to Sydney police that he was stolen by a woman. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40579 | 40579 | 1923-10-20 | 7 | c | Two trams collide in Sydney that causes injury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40580 | 40580 | 1923-10-20 | 7 | c | Sun Junchen, owner of the Chinese Australian Herald in Sydney, goes bankrupt and the Chinese newspaper is closed down. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40581 | 40581 | 1923-10-20 | 7 | c | Sun Yatsen opposes to Cao Kun as the Chinese president. | America | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 |
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]);