This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43536 | 43536 | 1925-07-25 | 6 | a | Chinese consulate-general in Melbourne receives a telegram from Shanghai which calls for donations to the unemployed workers in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101220 | 24101220 | |
43537 | 43537 | 1925-07-25 | 6 | a | Heavy rain in Hong Kong and many houses collapse. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101220 | 24101220 | |
43538 | 43538 | 1925-07-25 | 6 | a | Further report on the aftermath of the May 30 Demonstration in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101220 | 24101220 | |
43539 | 43539 | 1925-07-25 | 6 | a-d | Prominent figures in Beijing comments on the May 30 demonstration in Shanghai and the solutions. They are Liang Qichao, Zhu Qiqin, Li Shiwei, Gu Weijun, Fan Yuanlian, Zhang Guojin, Dong Xianguang, and Ding Wenjiang. | China | http://trove.nla.gov.au/newspaper/page/24101220 | 24101220 | |
43540 | 43540 | 1925-07-25 | 6 | e | A notice issued by the Chinese Chamber of Commerce in Sydney calls for donations to the unemployed workers in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101220 | 24101220 |
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]);