This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26751 | 26751 | 1912-09-21 | 2 | a | Sydney's Nationalist Association's notice about change of its name. | Other... | http://trove.nla.gov.au/newspaper/page/24092384 | 24092384 | |
26759 | 26759 | 1912-09-21 | 3 | a | Sun Yat-sen tells all Beijing political parties to favour foreign loans to develop China's economy. | China | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26760 | 26760 | 1912-09-21 | 3 | a | Yunnan army has coup and governor disappears. | Other... | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26761 | 26761 | 1912-09-21 | 3 | a | Russian ambassador to China defends Russia-China treaty on Xinjiang signed in 1881. | Other... | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26762 | 26762 | 1912-09-21 | 3 | a | Wenzhou, Zhejiang flood disaster killing over 40,000 livies. | China | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26763 | 26763 | 1912-09-21 | 3 | a | Six-nation bank group angry of China's decision to borrow Britain 100 million pounds. | China | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26764 | 26764 | 1912-09-21 | 3 | a | Italy soon reaches peace agreement with Turkey. | Germany | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26765 | 26765 | 1912-09-21 | 3 | a | Priest fined for not allowing women wearing narrow shirts. | Other... | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26766 | 26766 | 1912-09-21 | 3 | a | China uses other way to borrow foreign loans from Britain. | China | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26777 | 26777 | 1912-09-21 | 6 | a | Russian plan exposed for its intention to occupy China's Manchu. | Other... | http://trove.nla.gov.au/newspaper/page/24092388 | 24092388 | |
26780 | 26780 | 1912-09-21 | 7 | a | China's consul general's letters about donations to saving Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092387 | 24092387 | |
26784 | 26784 | 1912-09-21 | 8 | a | Notice for donations to floods in Guangdong. | Tung Wah | 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]);