This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19341 | 19341 | 1908-05-16 | 2 | b-c | Imperial edict on opium ban. | China | http://trove.nla.gov.au/newspaper/page/26801734 | 26801734 | |
19345 | 19345 | 1908-05-16 | 3 | b-c | Guangdong news. The embarrassed governor Zhang Renjun seeks to resign. Journalism association set up in Guangzhou. Railway income in Guangdong in 1907. Guangdong army to purchase weapons from Hong Kong. China and Portugal in negotiation on the boarder issue with Macao. All revolutionary and bandit groups to be disbanded. Governor Zhang Renjun meets in Guangzhou British ambassador who is on his tour to Hong Kong for opium ban. British ambassador to China surveys the border with Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801733 | 26801733 | |
19372 | 19372 | 1908-05-16 | 8 | b-c | Chinese trade statistics. Statistics of imports and exports of China from 1865 to 1906. | Britain | http://trove.nla.gov.au/newspaper/page/26801735 | 26801735 |
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]);