This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26944 | 26944 | 1913-02-01 | 7 | a | The Chinese Commercial Association of New South Wale's notice about having tea party to celebrate its establishment. | Other... | http://trove.nla.gov.au/newspaper/page/24092564 | 24092564 | |
26945 | 26945 | 1913-02-01 | 7 | a-b | Australian news/ Establishment of the Chinese Commercial Association of New South Wales. Chinese kills Chinese in Brisbane. Suspected opium found in laundry is false. Four foreigners fined off ship for possession of opium. Australian prisoned for fruit theft. Australia decides to build warships itself. Japanese buys battle horses from Australia. Chinese secret society member blackmails Chinese shop owner. Chinese house burns down. | Other... | http://trove.nla.gov.au/newspaper/page/24092564 | 24092564 | |
26946 | 26946 | 1913-02-01 | 7 | b | Chinese restaurant owner arrested for intention to kill Australian waitress. Ghi Zhi promoted Chinese consul general to New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092564 | 24092564 | |
26947 | 26947 | 1913-02-01 | 7 | b-c | Huang Zhiguan asks Huang Xin to investigate Huang Keqiang's death. Fujian provincial parliament asks Chen Xilin to control Fujian situation. | Other... | http://trove.nla.gov.au/newspaper/page/24092564 | 24092564 | |
26948 | 26948 | 1913-02-01 | 7 | c | Thieves active in Yangchun, Xiangshan and Dongguan, Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092564 | 24092564 | |
26949 | 26949 | 1913-02-01 | 7 | c | Kaiping, Guangdong is place of talents. | Other... | http://trove.nla.gov.au/newspaper/page/24092564 | 24092564 |
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]);