This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27927 | 27927 | 1913-09-27 | 3 | c | The new Chinese cabinet and its good performance. | Britain | http://trove.nla.gov.au/newspaper/page/24092832 | 24092832 | |
27935 | 27935 | 1913-09-27 | 7 | c | Fire in Ningguta, Manchuria. | Russia | http://trove.nla.gov.au/newspaper/page/24092836 | 24092836 | |
27936 | 27936 | 1913-09-27 | 7 | c | Former Japanese prime minister Katsura Taro is ill. | Japan | http://trove.nla.gov.au/newspaper/page/24092836 | 24092836 | |
27937 | 27937 | 1913-09-27 | 7 | c | Zhang Xun's troops and their looting in Nanjing. | Britain | http://trove.nla.gov.au/newspaper/page/24092836 | 24092836 | |
27938 | 27938 | 1913-09-27 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092836 | 24092836 | |
27942 | 27942 | 1913-09-27 | 8 | c | Guangdong news/ Long Jiguang orders to arrest leaders of rebellions. Huang Shilong is seeking to resign. Long Jiguang dispatches troops to suppress bandits in Enping and Kaiping. Bandits in Heshan county and the plea for help. River dyke breaks in Zhaoqing and Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24092839 | 24092839 |
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]);