This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26060 | 26060 | 1912-04-27 | 2 | c-d | President Yuan's inaugural speech | President Yuan has made inaugural speech. | Other... | http://trove.nla.gov.au/newspaper/page/24092216 | 24092216 |
26073 | 26073 | 1912-04-27 | 3 | c-d | Guangdong news | Guangdong government discusses haddling of soldier rebels' aftermath. Foreigners in Guangdong have meeting about how to cope with chaos development in Guangdong. Nanjing garrison commander said to be appointed governor of Guangdong and Guangxi. Huang Xing said to come to Guangdong. Guangdong-Wuhan railway is to start construction soon. Soldier is robbed on street. Gangsters active in Deqing county. | Other... | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
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]);