This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33182 | 33182 | 1918-04-13 | 2 | a-c | Third part of Kang Youwei's article on the Chinese Republic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097248 | 24097248 | |
33191 | 33191 | 1918-04-13 | 6 | a-b | Comments by Tung Wah Times claim that the Chinese central government has lost its capability to unify China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097252 | 24097252 | |
33193 | 33193 | 1918-04-13 | 7 | b-c | Australia news/ Federal government takes over all inland navigation. A Chinese tram driver is brought to trial in Sydney for opium smuggling. Huge income of tram tickets in the past two weeks. Chinese communities in New South Wales donate to the Red Cross and their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097251 | 24097251 | |
33195 | 33195 | 1918-04-13 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097251 | 24097251 |
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]);