This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38650 | 38650 | 1922-04-29 | 7 | a | Sydney show and the agricultural exhibition. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38651 | 38651 | 1922-04-29 | 7 | a | A bandit is on trial in Sydney for bank robbery. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38652 | 38652 | 1922-04-29 | 7 | a | A man is hanged in Melbourne for raping a young girl. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38653 | 38653 | 1922-04-29 | 7 | a-b | A waitress is detained in Sydney for theft suspect. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38654 | 38654 | 1922-04-29 | 7 | b | A fishing man in Sydney catches shark. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38655 | 38655 | 1922-04-29 | 7 | b | An old man of Darling Harbour is found infected the plague. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38656 | 38656 | 1922-04-29 | 7 | b | Chinese Chamber of Commerce in New South Wales gathers and farewells Chen Zhuchen, deputy chairman of the chamber who is returning to China. Speakers include Wu Zhaoquan, Ma Qi, He Youwen, Ye Puru, Ye Tonggui, Zheng Fanchang, Ye Bingnan, Wu Elou, Peng Lichuan, Wu Dingming, Zhang Fu and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38657 | 38657 | 1922-04-29 | 7 | c | War clouds in China. | China | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38658 | 38658 | 1922-04-29 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38659 | 38659 | 1922-04-29 | 7 | c | Farewell message by Chen Zhuchen on his returning to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 | |
38660 | 38660 | 1922-04-29 | 7 | c | Farewell message by Ma Qi on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093955 | 24093955 |
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]);