This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40570 | 40570 | 1923-10-20 | 7 | a | Chinese community in Adelaide welcomes the Chinese football team and speakers include Zhu He, Xie Zhenkuan, Mo Qing, Lin You and other guests. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40571 | 40571 | 1923-10-20 | 7 | a-b | Chinese community in Tamworth, New South Wales, celebrates the birthday of Confucius and the National Day, and a detailed report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40572 | 40572 | 1923-10-20 | 7 | b | Queensland government issues new regulation on sugar sales. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40573 | 40573 | 1923-10-20 | 7 | b | An Italian immigrant in Sydney sues Italian consul for adultery with his wife. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40574 | 40574 | 1923-10-20 | 7 | b | Thief hurts a white man in Manly, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40575 | 40575 | 1923-10-20 | 7 | c | Smuggled weapons found in a Dutch ship while docking in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40576 | 40576 | 1923-10-20 | 7 | c | Workers of the gas factory are in strike in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40577 | 40577 | 1923-10-20 | 7 | c | A convict on the run is captured again in Geelong, Victoria. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40578 | 40578 | 1923-10-20 | 7 | c | An American tourist reports to Sydney police that he was stolen by a woman. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40579 | 40579 | 1923-10-20 | 7 | c | Two trams collide in Sydney that causes injury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40580 | 40580 | 1923-10-20 | 7 | c | Sun Junchen, owner of the Chinese Australian Herald in Sydney, goes bankrupt and the Chinese newspaper is closed down. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40581 | 40581 | 1923-10-20 | 7 | c | Sun Yatsen opposes to Cao Kun as the Chinese president. | America | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40582 | 40582 | 1923-10-20 | 7 | d | Ammunition depot explodes in Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40583 | 40583 | 1923-10-20 | 7 | d | Foreign missions in Beijing congratulate Cao Kun as the new Chinese president. | China | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40584 | 40584 | 1923-10-20 | 7 | d | A peanut shop owner in Beijing sees a ghost in broad daylight. | China | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40585 | 40585 | 1923-10-20 | 7 | e | Gong yi tang (The Dong Guan Goon Yee Tong) in Sydney calls for donations to the flood victims in their home county. Contact details are: Lee Sang & Co, Hay and Harbour Streets, Sydney; Yuen Tiy Tong Kee, 54 Campbell Street, Sydney; Chung Lung, 120 Gloucester Street, Sydney; and King Young, 51 Dixon Street, Sydney. Chinese community in Sydney donates to the victims and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 |
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]);