This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24269 | 24269 | 1911-02-04 | 17 | a-b | Parliament petition representatives appealed to Regent | Parliament petition representatives appealed to Regent for saving China from poverty and risk of foreign invasion. These representatives include Sun Hongyi, Li Changsheng, Qiao Zhaner, Wen Yao, Yao Wenxu, Shen Maozhao, Yu Dehang, Lu Naixiang, Wu Xianzi, Tang Juetun etc. | Other... | http://trove.nla.gov.au/newspaper/page/24091636 | 24091636 |
25793 | 25793 | 1912-02-24 | 17 | a-b | Record of Russia's expanding its navy | Russia realises that its navy is more backward than other big powers and decides to strengthen it. | Other... | http://trove.nla.gov.au/newspaper/page/24092131 | 24092131 |
25820 | 25820 | 1912-02-24 | 17 | a | Photo of deputy chief of Chinese navy | Photo of Chen Biguang, deputy chief of Chinese navy. | Other... | http://trove.nla.gov.au/newspaper/page/24092131 | 24092131 |
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]);