This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33478 | 33478 | 1918-08-03 | 2 | a-c | Editorial by Tung Wah Times on Li Yuanhong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097378 | 24097378 | |
33488 | 33488 | 1918-08-03 | 6 | a-c | Miscellaneous report on the floods in Guangdong (Huizhou, Dongguan, Gaoyao, Sanshui, and Wuhua). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097382 | 24097382 | |
33496 | 33496 | 1918-08-03 | 8 | a-c | Beijing news/ China and Switzerland sign treaty of friendship. Hope for the peace between the south and the north. Wang Zhanyuan advocates peace. Li Liugeng is against the secret treaty with Japan. The central government in Beijing and its expenditure in a day. Epidemic in Jilin province. Epidemic in Wuhu, capital of Anhui province. Epidemic in Zhenjiang, of Jiangsu province. Chinese businessmen in Kulun and their sufferings. | China | http://trove.nla.gov.au/newspaper/page/24097384 | 24097384 |
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]);