This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27904 | 27904 | 1913-09-20 | 8 | a-b | A circular telegram issued by Sun Wu to condemn rebellions in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27905 | 27905 | 1913-09-20 | 8 | b | China and Russia may have clash on the Mongolian issues. | Germany | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27906 | 27906 | 1913-09-20 | 8 | b | Tang Caizhi writes to his nephew, son of Tang Caichang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27907 | 27907 | 1913-09-20 | 8 | b | Rebellions in Guangdong and Fujian province and their backgrounds. | China | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27908 | 27908 | 1913-09-20 | 8 | b-c | Miscellaneous comments, written by anonymous author, on emperor and great men. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27909 | 27909 | 1913-09-20 | 8 | c | Guangdong news/ Long Jiguang takes the office of military governorship. Loss caused by the clash between Long Jiguang and Chen Jiongming. Chen Jiongming injures his mother. Zhong Rongguang farewells Chen Jiongming. Long Jiguang is trapped by Chen Jinghua. | China | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27910 | 27910 | 1913-09-20 | 8 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 |
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]);