This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32109 | 32109 | 1917-02-24 | 3 | a-b | First part of Liang Qichao's speech at the memorial meeting for Cai E. | China | http://trove.nla.gov.au/newspaper/page/24095608 | 24095608 | |
32114 | 32114 | 1917-02-24 | 6 | a-b | Elegiac article written by Liang Qichao on the death of Cai E. | China | http://trove.nla.gov.au/newspaper/page/24095613 | 24095613 | |
32119 | 32119 | 1917-02-24 | 7 | a-b | Australia news/ An Australian coalition government, known as the Nationalist War Government, is sworn in with William Hughes as the Prime Minister and Joseph Cook the deputy, and other members of the cabinet. Number of tram passengers in Sydney reduces significantly. Baby found abandoned in Spencer Street Station in Melbourne. Preparation in Sydney for Victory Day parade on Friday this week. | China | http://trove.nla.gov.au/newspaper/page/24095612 | 24095612 |
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]);