This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27867 | 27867 | 1913-09-13 | 7 | a | Chinese Chamber of Commerce in Sydney calls for donations to the flood victims in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 | |
27868 | 27868 | 1913-09-13 | 7 | a-b | Australia news/ Queensland authority issues new restriction on Chinese sugarcane growers. Sydney customs seize smuggled opium. Chinese opium smoker is penalised in Sydney. Local parliamentarian in New South Wales oppose to the bail out of a Chinese convict. Australia has new merchant ship. New South Wales authority inspects Chinese gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 | |
27869 | 27869 | 1913-09-13 | 7 | b | Diplomatic tensions between Japan and China caused by internal chaos in China. | Japan | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 | |
27870 | 27870 | 1913-09-13 | 7 | b-c | Britain dispatches more warships to China. | Britain | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 | |
27871 | 27871 | 1913-09-13 | 7 | c | China to have a cabinet soon. | China | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 | |
27872 | 27872 | 1913-09-13 | 7 | c | Anti-Chinese sentiment in Tokyo. Negotiations between China and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 | |
27873 | 27873 | 1913-09-13 | 7 | c | Chen Jiongming flees to Singapore and the report. | Singapore | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 | |
27874 | 27874 | 1913-09-13 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 |
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]);