This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50193 | 50193 | 1931-04-18 | 2 | b | First part of editorial by Tung Wah Times on the policy of protection of the Chinese government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090349 | 24090349 | |
50202 | 50202 | 1931-04-18 | 5 | b | Divorce in Guangzhou last year and an analysis. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090350 | 24090350 | |
50203 | 50203 | 1931-04-18 | 5 | c | Lechers harass women in the Sincere Theatre, Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090350 | 24090350 | |
50204 | 50204 | 1931-04-18 | 5 | d | A case of adultery in Zengcheng county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090350 | 24090350 | |
50205 | 50205 | 1931-04-18 | 5 | e | On friendship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090350 | 24090350 | |
50206 | 50206 | 1931-04-18 | 5 | e | A notice by the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090350 | 24090350 | |
50216 | 50216 | 1931-04-18 | 8 | c | Australia news/ A lawyer in Sydney is charged. Income of the Royal Agricultural Show decreases in Sydney. Ling Su'an, chief editor of Gong Bao, is returning to China and a farewell party at the zhi gong tang in Sydney. Result of the board election of the Chinese Chamber of Commerce in Sydney. Jockey injured during a horse racing in Sydney. Two people die in a plane accident in Sydney. Chinese Consul-General in Australia Gui Zhi entertains Lin Sen, Chairman of the Chinese Legislative Council, and Chen Yanyuan, chairman of the Overseas Chinese Commission. Opium smuggler detained in Sydney. Federal government sues the NSW state government for debt repudiation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50217 | 50217 | 1931-04-18 | 8 | e | Notice issued by Gui Zhi, Chinese Consul-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 |
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]);