This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55213 | 55213 | 1935-06-22 | 2 | d | Long Yun entertains Jiang Jieshi in Kunming. Sun Ke visits Xi'an. Japanese banking delegation visit Manchuria. Guizhou province under its new governor Wu Zhongxin. Nanjing authority to collect personal income tax. Cai E's mother dies. | China | http://trove.nla.gov.au/newspaper/page/24096473 | 24096473 | |
55217 | 55217 | 1935-06-22 | 3 | d | Number of opium addicts in Manchuria. | Other... | http://trove.nla.gov.au/newspaper/page/24096472 | 24096472 |
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]);