This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21359 | 21359 | 1909-07-24 | 3 | a | Correspondence from Beijing/ Magistrate of Shanghai under impeachment. Xu Shichang arrives Beijing to take his office of minister of communications. Xi Liang as new governor of Manchuria. More merchant societies are established among Chinese communities in Nanyang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
21379 | 21379 | 1909-07-24 | 7 | a | Number of Chinese and white carpenters in Sydney in 1897 and 1908. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 | |
21380 | 21380 | 1909-07-24 | 7 | a | A steamship company in Perth is penalised for the disappearance of six Chinese sailors. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 | |
21381 | 21381 | 1909-07-24 | 7 | a | Casualties on the railway in Australia in the past six years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 | |
21382 | 21382 | 1909-07-24 | 7 | a | Duke from Britain comes to visit Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 | |
21383 | 21383 | 1909-07-24 | 7 | a | State government of New South Wales issues rules on payment to child labourers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 | |
21384 | 21384 | 1909-07-24 | 7 | a | Premiers of the six Australian states to meet and discuss financial issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 |
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]);