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 |
---|---|---|---|---|---|---|---|---|---|
18310 | 18310 | 1907-10-19 | 6 | a | Twelfth and final part of travel notes to Germany, written by Kang Youwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801512 | 26801512 | |
18313 | 18313 | 1907-10-19 | 7 | a | Name book published for donations to flood victim in north Jiangsu province and to rice market in Guangdong. All donators' names listed and the book is now available from Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801511 | 26801511 | |
18314 | 18314 | 1907-10-19 | 7 | a | Governor of New South Wales opens the state parliament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801511 | 26801511 | |
18315 | 18315 | 1907-10-19 | 7 | a | Journalists in New South Wales gather in Sydney and call for international cooperation with counterparts in Britain, America and Canada. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801511 | 26801511 | |
18316 | 18316 | 1907-10-19 | 7 | a | Japanese pry into military secrets in Perth, Western Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801511 | 26801511 | |
18317 | 18317 | 1907-10-19 | 7 | a | A Catholic missionary in Sydney talks about Aborigines in the Northern Territory. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801511 | 26801511 | |
18318 | 18318 | 1907-10-19 | 7 | a | Spanish immigrants refuse to work in Northern Territory and northern Queensland, and they are returning to their home country. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801511 | 26801511 |
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]);