This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28612 | 28612 | 1914-03-21 | 7 | a-b | Australia news/ Tragedy of train accident in Sydney. State governor of New South Wales visits victims of the train accident. An old white man in Sydney is detained for opium smuggling. Poster in Sydney railway station advises people not to eat meat. A mail bomb explodes in Melbourne. Two Chinese sailors fight on their way from Melbourne to New Castle and one is injured seriously. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093049 | 24093049 | |
28613 | 28613 | 1914-03-21 | 7 | b | Sun Yatsen and Huang Xing provide ammunitions to bandits in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24093049 | 24093049 | |
28614 | 28614 | 1914-03-21 | 7 | c | Disaster of bandits in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24093049 | 24093049 | |
28615 | 28615 | 1914-03-21 | 7 | c | Pirates hijack a Norwegian passenger liner. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093049 | 24093049 | |
28616 | 28616 | 1914-03-21 | 7 | c | The Times in London comments on Yuan Shikai's worship ceremony to the Heaven. | China | http://trove.nla.gov.au/newspaper/page/24093049 | 24093049 | |
28617 | 28617 | 1914-03-21 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093049 | 24093049 |
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]);