This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39183 | 39183 | 1922-12-23 | 7 | a | Prime Minister Billy Hughes sues Sydney Daily Mail for defamation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39184 | 39184 | 1922-12-23 | 7 | a | A case of manslaughter in Goulburn, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39185 | 39185 | 1922-12-23 | 7 | a | A shoe factory in Redfern, Sydney, is on fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39186 | 39186 | 1922-12-23 | 7 | a | Former secretary of the Sydney zhi gong tang Yang Du is sentenced to two years' imprisonment for embezzlement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39187 | 39187 | 1922-12-23 | 7 | a | A ban robber in America. | America | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39188 | 39188 | 1922-12-23 | 7 | b-c | News in brief/ Lin Junting becomes Guangxi governor. Beijing cabinet agrees to ban the New Culture. Bandits in Henan. Sun Yatsen sends Kong Geng to Sichuan. Increase of postal service charges and the social response. Chen Jiongming and Chen Xiru reach agreement on the gambling in Guangdong. Zhong Rongguang escapes an assassination. Hong Zhaolin reports battles in Zhangzhou, Fujian. Li Yuanhong orders to catch Fu Zongyao and Zheng Hongnian. Bandits in Enping. Troops in Guangzhou protect gambling. Chen Jiongming seeks help from Tang Jiyao. Chinese ambassador in Beijing reports communist and other radical movement in China. | Other... | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39189 | 39189 | 1922-12-23 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 |
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]);