This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26818 | 26818 | 1912-10-05 | 2 | a | Sydney Nationalist Association's notice about change of its name. | Other... | http://trove.nla.gov.au/newspaper/page/24092400 | 24092400 | |
26819 | 26819 | 1912-10-05 | 2 | a-c | Comments on Yunnan governor's invitation of Liang Qichao back to China. (second part) | Other... | http://trove.nla.gov.au/newspaper/page/24092400 | 24092400 | |
26820 | 26820 | 1912-10-05 | 2 | c-d | Li Yuanhong's telegram to president, state council and senate about Zhang Zhenwu's crimes. (second part) | Other... | http://trove.nla.gov.au/newspaper/page/24092400 | 24092400 | |
26821 | 26821 | 1912-10-05 | 2 | d | Detalis about how powerful nations at London meeting intending to divide China into their colonies. | Other... | http://trove.nla.gov.au/newspaper/page/24092400 | 24092400 | |
26822 | 26822 | 1912-10-05 | 2 | d | Premier Lu makes several proposals to his cabinet members over protection of China remote areas. | Other... | http://trove.nla.gov.au/newspaper/page/24092400 | 24092400 | |
26823 | 26823 | 1912-10-05 | 2 | d | Mongolians invade Xinanling in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24092400 | 24092400 | |
26824 | 26824 | 1912-10-05 | 2 | d | China bank is to open door soon. | Other... | http://trove.nla.gov.au/newspaper/page/24092400 | 24092400 |
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]);