This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31170 | 31170 | 1916-04-29 | 2 | d-f | Tung Wah Times comments on Yuan Shikai's intentions and strategies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095244 | 24095244 | |
31180 | 31180 | 1916-04-29 | 6 | c | Poems by Tang Jiyao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095248 | 24095248 | |
31181 | 31181 | 1916-04-29 | 7 | a-b | Australia news/ Four Chinese gardeners (Li Hong, Zhou Wenhao, You Su and Charlie Li) in Sydney are injured by bandits and the report. The ANZAC Day parade in Sydney. More paper notes issued by the Commonwealth government. Many people visit the Royal Easter Show in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 | |
31184 | 31184 | 1916-04-29 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 | |
31185 | 31185 | 1916-04-29 | 7 | d | Wing On Fruit Shop in Sydney offers a reward to the capture of Li Kunquan, an illegal arrival in Sydney, and Li's photograph attached. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 | |
31188 | 31188 | 1916-04-29 | 8 | d | Story of shepherd Hans in German, translated by Peng Nian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095250 | 24095250 |
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]);