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 |
---|---|---|---|---|---|---|---|---|---|
51145 | 51145 | 1932-02-06 | 2 | a | First part of an essay on the war between China and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090686 | 24090686 | |
51163 | 51163 | 1932-02-06 | 5 | d | Australia news/ Chinese societies & associations in Sydney jointly call for donations to the war of resistance to Japanese invasion (Chinese Chamber of Commerce in New South Wales, the zhi gong tang in Sydney, the Zengcheng lian yi tang, the Gaoyao and Gaoming hong fu tang, Si Yi Society and the Young Chinese Association of Australia or li zhi hui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51164 | 51164 | 1932-02-06 | 6 | a | A notice issued by the Dongguan gong yi tang in Sydney on the transfer of remains of deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090692 | 24090692 | |
51165 | 51165 | 1932-02-06 | 6 | b | Advertisement of The Sun Company in Hong Kong for its proposed set-up of a branch company in Shanghai and the shares. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090692 | 24090692 | |
51166 | 51166 | 1932-02-06 | 6 | b | A notice by the Zengcheng lian yi tang in Sydney to lease a shop. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090692 | 24090692 | |
51167 | 51167 | 1932-02-06 | 6 | b | The Chinese School in Melbourne calls for enrolment of students, its subject courses and the principal Jiang Jiadong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090692 | 24090692 | |
51170 | 51170 | 1932-02-06 | 7 | d | Chinese communities in Melbourne donate to the Military Funds for Saving China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090691 | 24090691 |
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]);