This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26266 | 26266 | 1912-06-08 | 7 | a | Current news of Tibet riots | Chinese government sent troops to Tibet to pacify the riots. | Other... | http://trove.nla.gov.au/newspaper/page/24092267 | 24092267 |
26267 | 26267 | 1912-06-08 | 7 | a-b | Australian news | Draught in New South Wales has led to widespread worries. A soldier was punished for his smoking at military exercise for celebrating British emperor's birthday. Two Indian criminals were sentenced to death for their killing a man in Fiji. The Japanese ship with its smallpox patient cured was released. A station warehouse in New South Wales was stolen. A printing company in Sydney was burned resulting in huge loss. A group of scandals fought with policemen with 6,000 people watching in a Sydney circus. A Melbourne woman was arrested for killing her child. Statistics of wine consumption in Victoria. An European couple in Sydney attempted to divorce due to misunderstanding. | Australia | http://trove.nla.gov.au/newspaper/page/24092267 | 24092267 |
26268 | 26268 | 1912-06-08 | 7 | b | Important overseas news | Chinese government is negotiating with Holland government on overseas Chinese killed in Singapore. Chinese new government is to take over all old treaties made by the previous government. | China | http://trove.nla.gov.au/newspaper/page/24092267 | 24092267 |
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]);