This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21509 | 21509 | 1909-08-21 | 2 | b-c | News in brief/ Salary payment increased for county magistrates. Proposal to organise railway police. Lu Chuanlin and the ban on opium smoking. American president likes to help China in naval building. Liang Dunyan seeks to resign from the department of foreign affairs. Naval officer Li Zhun in Guangdong is found in collaboration with French. Tie Liang seeks to resign. Prince Regent and the border demarcation in Macao. Prince Su and naval building. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802296 | 26802296 | |
21518 | 21518 | 1909-08-21 | 3 | b-c | King Edward VII of Britain visit Austria. | Britain | http://trove.nla.gov.au/newspaper/page/26802295 | 26802295 |
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]);