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 |
---|---|---|---|---|---|---|---|---|---|
16399 | 16399 | 1906-11-03 | 2 | b | Welcome Commissioner Huang Benfu (Houcheng). Report on the welcome ceremony organised by Sydney Chinese Communities for Huang Benfu (Houcheng), envoy of Chinese government on his investigation tour in Australia and New Zealand. Huang arrives Sydney from Brisbane and will go to Melbourne, Tasmania and New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801125 | 26801125 | |
16407 | 16407 | 1906-11-03 | 3 | b | Fable. A Chinese official follows Japan in everything after his tour in Japan. Clouds and human beings. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801124 | 26801124 | |
16414 | 16414 | 1906-11-03 | 6 | b | Miscellaneous report. Story of Volcano Vesuvius in Italy. The most expensive book in America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801129 | 26801129 | |
16415 | 16415 | 1906-11-03 | 6 | b | Jokes. Zhang Zhidong tours Nanjing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801129 | 26801129 | |
16416 | 16416 | 1906-11-03 | 6 | b | Poems written by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801129 | 26801129 |
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]);