This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28589 | 28589 | 1914-03-21 | 2 | a-b | Editorial on the relations between taxation and finance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093046 | 24093046 | |
28608 | 28608 | 1914-03-21 | 6 | a-b | Comments written by anonymous author on the necessity to set Confucianism the state religion of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093050 | 24093050 | |
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 | |
28618 | 28618 | 1914-03-21 | 8 | a-b | Fourth and final part of the regulations issued by Chinese government on merchants and their business activities. | China | http://trove.nla.gov.au/newspaper/page/24093052 | 24093052 |
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]);