This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54388 | 54388 | 1934-08-04 | 2 | c | The Nanjing government orders to cancel all exorbitant taxes and levies. | China | http://trove.nla.gov.au/newspaper/page/24096108 | 24096108 | |
54398 | 54398 | 1934-08-04 | 3 | c | Envoys of the central government He Jian and Xue Yue in Guangdong. Fang Shengtao dies in Shanghai. Ms Li Xiaqing and her story. Yellow River is flooding. Cai Tingkai meets Italian Prime Minister Mussolini. | China | http://trove.nla.gov.au/newspaper/page/24096107 | 24096107 | |
54402 | 54402 | 1934-08-04 | 5 | c | Traitor Zheng Xiaoxu in Japan. | China | http://trove.nla.gov.au/newspaper/page/24096109 | 24096109 |
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]);