This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26238 | 26238 | 1912-06-08 | 2 | a-b | Comment: Strategies for restoring social order | A lot of troops need to be dissolved and those rebellious troops should be wiped out. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092264 | 24092264 |
26251 | 26251 | 1912-06-08 | 3 | a-b | A 17-year old girl's third marriage | An American girl at age of 17-years marrys for the third time. | America | http://trove.nla.gov.au/newspaper/page/24092263 | 24092263 |
26261 | 26261 | 1912-06-08 | 6 | a-b | Establishing ceremony of Republic Construction Association | Republic Construction Association holds its establishing ceremony in Shanghai with members of 300 people. Names listed. | China | http://trove.nla.gov.au/newspaper/page/24092268 | 24092268 |
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 |
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]);