This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25565 | 25565 | 1912-01-13 | 3 | a-b | Crisis in Persia | Rioters arrested by Russians but Russia disputes Britain over who should be puppet king of Persia. | Other... | http://trove.nla.gov.au/newspaper/page/24092066 | 24092066 |
25574 | 25574 | 1912-01-13 | 6 | a-b | Fujian correspondence | Fujian republic governor starts his office. Memorial ceremony for former Fujian governor who did not resist revolutionary uprising there. Gulangyu becomes a public area for both Chhinse and foreigners. Robbery is popular in Xiamen. | Other... | http://trove.nla.gov.au/newspaper/page/24092071 | 24092071 |
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 |
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]);