This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36464 | 36464 | 1921-01-01 | 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/24093384 | 24093384 | |
36465 | 36465 | 1921-01-01 | 8 | b-c | Guangdong news/ Tang Jiyao's motives in Guangdong. Sun Yatsen's plan to unify China by force. Wei Bangping's troops and their garrison. Guangxi troops (gui jun) retreat to Wuzhou from Zhaoqing. Guangdong people oppose the return of military government to Guangzhou. Bandits pretend to be government troops and the robbery. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093384 | 24093384 | |
36466 | 36466 | 1921-01-01 | 8 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093384 | 24093384 | |
36467 | 36467 | 1921-01-01 | 8 | c | Advertisement for the Government Savings Bank of New South Wales and the State Savings Institutes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093384 | 24093384 |
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]);