This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25581 | 25581 | 1912-01-13 | 7 | a | Book sale advertisement | Advertisement for sale of a series of history books. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092070 | 24092070 |
25582 | 25582 | 1912-01-13 | 7 | a-b | Australian news | Minority population in Australia. British navy staff sent to Australia for training Australian navy. Labour party holds its general meeting. Chinese shipmen arrested for brawling. Chinese restaurant in Sydney burned down. Variola found on a Hong Kong ship arrived in Australia recently. | Other... | http://trove.nla.gov.au/newspaper/page/24092070 | 24092070 |
25583 | 25583 | 1912-01-13 | 7 | b | Government in crisis | Russia urges China's reply for his request of Mongolia's independence. A general's house burned down in Xiangjiang. People of Man nationality killed near Turkey. Pukou Railway taken over by revolutionaries. Nanjing republic government decides the North Expeditionary Army march to the north. | Other... | http://trove.nla.gov.au/newspaper/page/24092070 | 24092070 |
25584 | 25584 | 1912-01-13 | 7 | b-c | The Regent asks for resign | The Regent asks for resign due to his disability to handle the current crisis. | Other... | http://trove.nla.gov.au/newspaper/page/24092070 | 24092070 |
25585 | 25585 | 1912-01-13 | 7 | c | Huang Shilong asks for resign | Huang Shilong, senior government official in Guangdong asks for resign. | http://trove.nla.gov.au/newspaper/page/24092070 | 24092070 |
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]);