This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31061 | 31061 | 1916-03-25 | 3 | a-b | Political situation in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 | |
31067 | 31067 | 1916-03-25 | 6 | a-b | Further report on the Funds Raising Organisation in Yunnan Province/Notice calling for donations and regulations of the organisation. | China | http://trove.nla.gov.au/newspaper/page/24095207 | 24095207 | |
31071 | 31071 | 1916-03-25 | 7 | a-b | Australia news/ A bank robbery in Victoria. Bagasse used to manufacture papers in Melbourne. A white man is beaten to death while playing snake in Sydney. Chinese communities in Australia distrust the Chinese government for their lies. Number of Australian troops. Penalties for illegal wines in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31076 | 31076 | 1916-03-25 | 8 | a-b | Beijing news/ Yuan Shikai helps the poor. Li Yuanhong refuses to congratulate Yuan Shikai. Another method to change the Chinese calendar by force. Li Liejun and Cai E to lead armies out of Yunnan province and on their way to the north. Volunteer army in Yunnan province after its independence. Chinese government to mediate the Yunnan disputes. | China | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 |
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]);