This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30896 | 30896 | 1916-01-15 | 8 | a-b | Public views/ The hope of rescuing China depends on the enlightened spirit of Chinese people. | Other... | http://trove.nla.gov.au/newspaper/page/24095116 | 24095116 | |
30897 | 30897 | 1916-01-15 | 8 | b-c | Guangdong news/Kong Saoyian comes to rule Guangdong custom. Opium smuggling in Guangdong is to be fined heavily. Guangdong Investigating Bureau notifies that people protecting opium smuggling are to be punished too. A detective in Guangdong is killed by bandits. Dong Wan, Guangdong, is suffering bandits' robberies and lootings. Bandits are active in Gaoyao, Guangdong. Shanghai occurs riots and Guangdong is strictly watching on social stabilities. Long Jiguang's building is heavily guarded. A man cheating money in Guangdong is arrested. | China | http://trove.nla.gov.au/newspaper/page/24095116 | 24095116 | |
30898 | 30898 | 1916-01-15 | 8 | c | Poems of Zhen Panchang and Zhou Yufang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095116 | 24095116 |
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]);