This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47664 | 47664 | 1928-12-15 | 2 | b | Second and final part of comments by Tung Wah Times on the current situations in Manchuria and Mongolia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
47665 | 47665 | 1928-12-15 | 2 | c | Chinese Consul-General in Canada resign. | Canada | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
47666 | 47666 | 1928-12-15 | 2 | c | Japan and the issues of Manchuria and Mongolia. | Japan | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
47667 | 47667 | 1928-12-15 | 2 | d | Oppositions to Hu Hanmin in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
47668 | 47668 | 1928-12-15 | 2 | e | Ye Qi reports from Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
47669 | 47669 | 1928-12-15 | 2 | e | Conflicts within the Nationalist Party in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
47670 | 47670 | 1928-12-15 | 2 | f | Hebei province after the disasters of war. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 |
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]);