This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33405 | 33405 | 1918-07-06 | 2 | a-b | Kang Youwei on the Republic system in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097346 | 24097346 | |
33410 | 33410 | 1918-07-06 | 3 | a-b | Shanghai businessmen give their advice to save the tea industry in Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24097345 | 24097345 | |
33416 | 33416 | 1918-07-06 | 6 | a-b | Chinese Consul-General in Australia Wei Zijing writes to the New South Wales Chinese Chamber of Commerce and reports the new immigration regulations issued by Dutch authority in Surabaya. Chinese translation of the new immigration restrictions imposed by new Dutch authority in Surabaya. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097350 | 24097350 |
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]);