This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37109 | 37109 | 1921-06-18 | 2 | a-b | A study on disarmament (in China and the world), editorial by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093581 | 24093581 | |
37113 | 37113 | 1921-06-18 | 3 | a-b | Henan provincial authority suppresses rebellion army led by Cheng Shenye in Zhangde. | China | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
37139 | 37139 | 1921-06-18 | 8 | a-b | Guangdong news/ Inaugural ceremony of President Sun Yatsen in Guangzhou. Chen Bingkun and the national defence in Guangxi province. Huang Dawei and his troops on the way to defend the border. Xiong Lue and Li Fulin and the national defence. Xijiang River may have floods. Cost for the inaugural ceremony of President Sun Yatsen in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093587 | 24093587 |
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]);