This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31864 | 31864 | 1917-01-06 | 2 | a-c | Editorial by Tung Wah Times on China in the coming year of 1917. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095539 | 24095539 | |
31868 | 31868 | 1917-01-06 | 3 | a-c | New regulations on the educational conferences in China. | China | http://trove.nla.gov.au/newspaper/page/24095538 | 24095538 | |
31873 | 31873 | 1917-01-06 | 6 | a-c | Sixth part of the diary written by Wu Guanyin on his service in the Chinese army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095543 | 24095543 | |
31878 | 31878 | 1917-01-06 | 7 | a-c | Australia news/ Hail in the west of New South Wales. Sydney police commissioner announces the murder case of last year. Summer (day-light saving) time started in Sydney. Sydney sees much less tourists this year. Flooding in Queensland. Flood relief in Rockhampton, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095542 | 24095542 | |
31881 | 31881 | 1917-01-06 | 8 | a-c | Beijing news/ President Li Yuanhong on the Cabinet. China to borrow more foreign loans. Model troops previously under Yuan Shikai and its current situations. Prefectural level administration to be abolished in China. National judicial conference in China. Chinese government to nationalise the land that once belongs to the army. | China | http://trove.nla.gov.au/newspaper/page/24095545 | 24095545 |
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]);