This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39211 | 39211 | 1922-12-30 | 7 | a | Blue Mountain has a fire during the Christmas holiday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094239 | 24094239 | |
39212 | 39212 | 1922-12-30 | 7 | a | A Chinese vegetable peddler in Sydney fights with a white man on the street. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094239 | 24094239 | |
39213 | 39213 | 1922-12-30 | 7 | a-b | A jewellery shop in Sydney is burglarised. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094239 | 24094239 | |
39214 | 39214 | 1922-12-30 | 7 | b | Fijian authority to ban Chinese immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094239 | 24094239 | |
39215 | 39215 | 1922-12-30 | 7 | b-c | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094239 | 24094239 | |
39216 | 39216 | 1922-12-30 | 7 | c | News in brief/ Wang Yongquan sends telegram to Wu Peifu. Liu Guanxiong asks President Li Yuanhong to withdraw troops from Fujian. Shandong authority questions Wang Zhengting. Ding Shiyuan arrives Tianjin. Banker Guo Zeshou is detained in Fuzhou for his refusal to withhold salt tax. Wu Jinglian and Wang Chonghui conflict over dinner table. Wang Yongquan, Xu Chongzhi and Lin Sen are jointly trying to withhold salt tax. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094239 | 24094239 | |
39217 | 39217 | 1922-12-30 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094239 | 24094239 |
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]);