This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29275 | 29275 | 1914-10-03 | 2 | a-b | A submission from Chen Mingjian to Chinese President Yuan Shikai to resume local legislature assemblies. | China | http://trove.nla.gov.au/newspaper/page/24093270 | 24093270 | |
29280 | 29280 | 1914-10-03 | 3 | a-b | The third international opium-ban conference in Hague. | Other... | http://trove.nla.gov.au/newspaper/page/24093269 | 24093269 | |
29283 | 29283 | 1914-10-03 | 6 | a-b | A notice issued by Gui Zhi, Chinese Consul-General in New Zealand, on the murder of Chinese businessman Huang Weijin. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093274 | 24093274 | |
29286 | 29286 | 1914-10-03 | 7 | a-b | Australia news/ Australian ship is detained by German in the south Pacific but another passenger liner has arrived Hong Kong safely. Chinese in the Southeast Asia (Singapore) after breakout of the World War I. More Chinese labourers are returning home from Noumea, of New Caledonia. Chinese carpentry in Sydney sees a decline since the World War I. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093273 | 24093273 | |
29289 | 29289 | 1914-10-03 | 8 | a-b | Chinese Masonic Society (hong men) in San Francisco refuses to cooperate with Sun Yatsen for his Third Revolution. American expert on the revolutionary movement in China. | America | http://trove.nla.gov.au/newspaper/page/24093276 | 24093276 |
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]);