This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32225 | 32225 | 1917-04-14 | 3 | b-c | Japanese cabinet and its China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24095656 | 24095656 | |
32231 | 32231 | 1917-04-14 | 6 | b-c | Beijing news/ Salt tax paid to the Ministry of Finance. Chinese government urges to the parliamentarians who are involved in the fighting attend court hearing. New plan for railway construction in Sichuan province. Gambling in the residence of parliamentarians and previous government officials. | China | http://trove.nla.gov.au/newspaper/page/24095661 | 24095661 | |
32234 | 32234 | 1917-04-14 | 7 | b-c | China breaks off its diplomatic relations with Germany and a report on the process. | China | http://trove.nla.gov.au/newspaper/page/24095660 | 24095660 |
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]);