This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31794 | 31794 | 1916-12-09 | 3 | a-b | Tang Shaoyi resigns and his report. | China | http://trove.nla.gov.au/newspaper/page/24095506 | 24095506 | |
31798 | 31798 | 1916-12-09 | 6 | a-b | Second part of the diary written by Wu Guanyin on his service in the army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095511 | 24095511 | |
31801 | 31801 | 1916-12-09 | 7 | a-b | Australia news/ Result of the referendum on the compulsory enlistment in Australia. Trial on the union case. News on the strike of coal miners. Restrictions lifted on electricity usage. The man who murdered policeman is hanged. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095510 | 24095510 |
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]);