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]);