This data as json, CSV (advanced)
Suggested facets: date, column, title, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 10952 | 10952 | 1902-08-23 | 6 | b | A robbery in Alexandria, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100475 | 24100475 | |
| 11021 | 11021 | 1902-09-20 | 6 | b | An escaped convict in Deniliquin, New South Wales, has been captured. | Australia | http://trove.nla.gov.au/newspaper/page/24100491 | 24100491 | |
| 11038 | 11038 | 1902-09-27 | 6 | a | A lawsuit in Brisbane, Queensland, between Zheng Dingchen and his employee Ya Cai. | Australia | http://trove.nla.gov.au/newspaper/page/24100497 | 24100497 | |
| 15153 | 15153 | 1905-12-16 | 6 | a-b | An article, written by a White missionary and published in an English newspaper in Charters Towers of Queensland, supports White Australia policy. | Australia | http://trove.nla.gov.au/newspaper/page/26800854 | 26800854 | |
| 15834 | 15834 | 1906-06-23 | 6 | a | Some people in China sell American flour with Australian brand. Hong Kong governor is urged to protect Australian business interests. | Australia | http://trove.nla.gov.au/newspaper/page/26801015 | 26801015 | |
| 16168 | 16168 | 1906-09-08 | 6 | a | Number of British warships and troops in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/26801081 | 26801081 | |
| 16169 | 16169 | 1906-09-08 | 6 | a | Queensland government opposes the proposal of Australian federal government to reduce postage charges as it has been worse off since the federation. | Australia | http://trove.nla.gov.au/newspaper/page/26801081 | 26801081 | |
| 16170 | 16170 | 1906-09-08 | 6 | a | Australia feels the earthquake in Chile of South America. | Australia | http://trove.nla.gov.au/newspaper/page/26801081 | 26801081 | |
| 17769 | 17769 | 1907-07-13 | 6 | a-b | Translation of an article, published in Sydney Daily Telegraph, on the relationship between Australia and China, and possible benefit of Chinese immigration to Australian economy. | Australia | http://trove.nla.gov.au/newspaper/page/26801400 | 26801400 | |
| 18691 | 18691 | 1907-12-28 | 6 | b | German ministry of war purchases radios for communication. | Australia | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
| 18692 | 18692 | 1907-12-28 | 6 | b | A coal mine in Pittsburgh, USA, explodes and 250 miners are trapped underground. | Australia | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
| 19139 | 19139 | 1908-04-04 | 6 | c | The British-French exhibition in London will be postponed. | Australia | http://trove.nla.gov.au/newspaper/page/26801690 | 26801690 | |
| 20118 | 20118 | 1908-10-17 | 6 | b | Germany to build more warships. | Australia | http://trove.nla.gov.au/newspaper/page/26801919 | 26801919 | |
| 20844 | 20844 | 1909-03-27 | 6 | b | Former Japanese prime minister Katsura Taro comments on relations between China and Japan. | Australia | http://trove.nla.gov.au/newspaper/page/26802128 | 26802128 | |
| 20871 | 20871 | 1909-04-03 | 6 | b | Japanese naval fleet to visit Vancouver. | Australia | http://trove.nla.gov.au/newspaper/page/26802136 | 26802136 | |
| 21001 | 21001 | 1909-05-08 | 6 | b | New York gamblers send money to London for horse racing after gambling banned by New York authority. | Australia | http://trove.nla.gov.au/newspaper/page/26802178 | 26802178 | |
| 22807 | 22807 | 1910-05-14 | 6 | a | Photograph of King Edward VII of Britain. | Australia | http://trove.nla.gov.au/newspaper/page/26802627 | 26802627 | |
| 24344 | 24344 | 1911-02-18 | 6 | a | An announcement from the paper | This newspaper has been distributed to New Zealand, Singapore, Europe and America. | Australia | http://trove.nla.gov.au/newspaper/page/24091674 | 24091674 |
| 24522 | 24522 | 1911-05-13 | 6 | a | Thanks to Chinese doctor | Tang Liangnan is appreciated for his Chinese medicine techniques. | Australia | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
| 24635 | 24635 | 1911-06-10 | 6 | a | Notes of Sydney Empire Constitutional Association | Aims of the Association and the regulations on membership. | Australia | http://trove.nla.gov.au/newspaper/page/24091807 | 24091807 |
| 24636 | 24636 | 1911-06-10 | 6 | b | Indictment | Liang Chuang, Ma zhuxiang and Guo Kui send indictment to the court to protect innocent Pan Yongkong. | Australia | http://trove.nla.gov.au/newspaper/page/24091807 | 24091807 |
| 26131 | 26131 | 1912-05-11 | 6 | a-b | Counsellor Huang's diplomatic documentation | Counsellor Huang's negotiation with Australian premier and the foreign minister. The new regulations to Chinese businessmen, students and labourers are designated by Australian government, which treats Chinese equally with all European people. | Australia | http://trove.nla.gov.au/newspaper/page/24092236 | 24092236 |
| 26163 | 26163 | 1912-05-18 | 6 | a-b | Counsellor Huang's official documents | Counsellor Huang's first interview with Batchelor, Australian Foreign minister on issues of Chinese coming to Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24092244 | 24092244 |
| 29554 | 29554 | 1915-01-09 | 6 | a-b | Overseas Chinese in Da Xi Di (ppp), Australia, write to Chinese Counsellor in Australia for protecting Chinese interest there. Names listed. | Australia | http://trove.nla.gov.au/newspaper/page/24094684 | 24094684 | |
| 29965 | 29965 | 1915-04-24 | 6 | a-b | Zhen Shunyian, consul general's assistant, writes to Yi Biannan, chief of China's Business and Trade Association on public loans in China. | Australia | http://trove.nla.gov.au/newspaper/page/24094821 | 24094821 | |
| 30511 | 30511 | 1915-09-25 | 6 | b | Name list of Chinese in Ta Li Lie Hua(ppp) in Australia donating to Guangdong floods. | Australia | http://trove.nla.gov.au/newspaper/page/24094999 | 24094999 | |
| 30534 | 30534 | 1915-10-02 | 6 | a | Notice of China's Business and Trade Association in Sydney on donations to Guangdong floods, with names of donators listed. | Australia | http://trove.nla.gov.au/newspaper/page/24095007 | 24095007 | |
| 30643 | 30643 | 1915-10-30 | 6 | a-b | Australia news/An European man named Zhan Shi He Di Li (nnn) in Melbourne celebrates his 100-year birthday. The European man stealing a Chinese shop named Shenhe is charged. An European man named James is fined for his slanting a Chinese named Ya Shen having adultery with his wife. Rai (nnn) is to replace Fei Sa (nnn) as Australian premier and the latter is to be ambassador in Britain. Lin Yunzao, a Chinese ambassador to Sa Mo (ppp), goes to Sa Ma island through Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24095039 | 24095039 | |
| 52702 | 52702 | 1933-03-25 | 6 | a | Japan is likely to quit the League of Nations. | Australia | http://trove.nla.gov.au/newspaper/page/24091168 | 24091168 |
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]);