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 |
---|---|---|---|---|---|---|---|---|---|
31317 | 31317 | 1916-06-17 | 2 | a-c | Political situation in China after the death of Yuan Shikai, an editorial. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095300 | 24095300 | |
31325 | 31325 | 1916-06-17 | 6 | a | Letter from a reader in Victoria comments on the death of Yuan Shikai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095304 | 24095304 | |
31328 | 31328 | 1916-06-17 | 6 | c | Poems by Zhou Yufan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095304 | 24095304 | |
31329 | 31329 | 1916-06-17 | 7 | a-b | Australia news/ Chinese Consul-General declares the death of Yuan Shikai. Liquor shops in Sydney are required to close by 6:00pm every day. Rumours in the Sydney Chinese community about the Gibbs & Bright Co. A British captain is penalised for the escape of Chinese sailor. Sea lion found in the Manly beach. A Chinese boy is shot and injured in Sydney. A Chinese in Melbourne is penalised for illegal landing. No foreign languages are allowed to use for telephone communications. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095303 | 24095303 | |
31330 | 31330 | 1916-06-17 | 7 | b-c | A telegram from Tang Mang to Yuan Shikai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095303 | 24095303 | |
31331 | 31331 | 1916-06-17 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095303 | 24095303 | |
31332 | 31332 | 1916-06-17 | 7 | c | A Mandarin Chinese teacher is wanted by E. Zieman, Queenscliff, Manly (advertisement). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095303 | 24095303 |
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]);