This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25566 | 25566 | 1912-01-13 | 3 | b | Murders and suicides in France | Many murders and suicides in France recently. | France | http://trove.nla.gov.au/newspaper/page/24092066 | 24092066 |
25567 | 25567 | 1912-01-13 | 3 | b | World largest warship | America is to build world largest warship. | America | http://trove.nla.gov.au/newspaper/page/24092066 | 24092066 |
25568 | 25568 | 1912-01-13 | 3 | b | Tea and tea flower | French scientist finds tea flower is better than tea. | Other... | http://trove.nla.gov.au/newspaper/page/24092066 | 24092066 |
25569 | 25569 | 1912-01-13 | 3 | b | Two small islands sold | Two small islands near Honolulu sold to Britishman. | Other... | http://trove.nla.gov.au/newspaper/page/24092066 | 24092066 |
25570 | 25570 | 1912-01-13 | 3 | b | Former governor refuses strong support | Former Guangdong governor refuses strong support to his countymen for their provincial independent activities. | China | http://trove.nla.gov.au/newspaper/page/24092066 | 24092066 |
25575 | 25575 | 1912-01-13 | 6 | b | Revolutionary army chief arrives in Shanghai | Revoultionary army chief Sa Zhenbin secretly visits Shanghai and predicts Qing Government is soon to be cracked down. | Other... | http://trove.nla.gov.au/newspaper/page/24092071 | 24092071 |
25576 | 25576 | 1912-01-13 | 6 | b | Aristocrats lost their attraction | Former powerful aristocrat Xun Tao lost his attraction. Shanxi governor sighs for his lacking the ability to do what he would like to do due to his getting older. | Other... | http://trove.nla.gov.au/newspaper/page/24092071 | 24092071 |
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 |
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]);