This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26752 | 26752 | 1912-09-21 | 2 | a-b | Editorial on Sun Yat-sen's plan to set up bank in Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24092384 | 24092384 | |
26767 | 26767 | 1912-09-21 | 3 | a-b | Britain, Russia and France establish military alliance. | France | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26778 | 26778 | 1912-09-21 | 6 | a-b | Guangdong Tongmen Hui not allow Xu Baoshan's intervention of Tiantong's affair. | Other... | http://trove.nla.gov.au/newspaper/page/24092388 | 24092388 | |
26781 | 26781 | 1912-09-21 | 7 | a-b | Australian news/ Survey shows just over half of the land developed in Australia. Two train drivers go to court for train accident. Sydney Chinese vegetable garden and house robbed. Raiway starts construction in West Australia. Sydney Chinese gambling house caught by police. | Other... | http://trove.nla.gov.au/newspaper/page/24092387 | 24092387 | |
26785 | 26785 | 1912-09-21 | 8 | a-b | Republic government issues its national policies for discussion. | Other... | http://trove.nla.gov.au/newspaper/page/24092390 | 24092390 |
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]);