This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36488 | 36488 | 1921-01-08 | 8 | a | Chinese communities in Australia call for donations to the drought, flooding and famine areas in China. Donation collectors are: Wing On Co, Lee Sang & Co, On Chong & Co, Tiy Loy & Co, Tung Wah Times, Chinese Chamber of Commerce, Kwong War Chong & Co, and Sun Suiy Wah Store. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093392 | 24093392 | |
36489 | 36489 | 1921-01-08 | 8 | a-b | Chinese communities in Australia donate to the war disaster area in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093392 | 24093392 | |
36490 | 36490 | 1921-01-08 | 8 | b-c | Guangdong news/ Sun Yatsen, Tang Shaoyi and Wu Tingfang discuss formation of new military government in Guangzhou. Sun Yatsen proposes to incorporate local troops. Chen Jiongming to punish secret gambling in Guangdong. Zhang Binglin writes to Chen Jiongming and opposes to organise a new military government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093392 | 24093392 | |
36491 | 36491 | 1921-01-08 | 8 | c | Liner timetable (between Australia and Hong Kong). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093392 | 24093392 | |
36492 | 36492 | 1921-01-08 | 8 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093392 | 24093392 |
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]);