This data as json, CSV (advanced)
Suggested facets: page, title, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 11202 | 11202 | 1902-11-22 | 3 | a-c | A detailed report on the liner accident near New Zealand. | Australia | http://trove.nla.gov.au/newspaper/page/24100535 | 24100535 | |
| 24424 | 24424 | 1911-03-11 | 7 | a-c | Australian news | The Chinese Consulate in Melbourne proposed to establish a Chinese society in Melbourne due to a large number of Chinese in Melbourne; a proposal of establishing a similar Chinese society in Sydney; Dingmeng (nnn) was appointed new governor of Australia; a western foreigner expressed his view on China after his trip to China; new regulations were issued to restrict Chinese in Brisbane; police's wrong suspicion of Chinese over opium; a German ship illeagally had ten Chinese boat people; a complicated murder case in West Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24091697 | 24091697 |
| 24596 | 24596 | 1911-05-29 | 7 | a-c | Australian news | New South Wales opens its parliament congress. Chinese thief in Melbourne. A survey reveals the average age of marriage in Australia. New governor to Australia will take his office. More migrants from Europe arrived in Australia. A long-life lady of 103 years old is in Melbourne. Australian prime minister arrived in London for the coronation ceremony. Chinese gamblers were caught by police. Two suicides happened in New South Wales. Chinese patriots in Australia wrote to China. Acting Chinese consul general wrote to the newspaper. | Australia | ||
| 29529 | 29529 | 1915-01-02 | 7 | a-c | Australia news/ Sydney China's School have made a great progress these years. Statistics of qualified soldiers in various states in Australia. Statistics show that Sydney business is declining due to the affects of European War. House of Yuan Mei, a Chinese in Sydney is stolen. Bat Hurst is flooding due to heavy rain there. | Australia | http://trove.nla.gov.au/newspaper/page/24094675 | 24094675 | |
| 29557 | 29557 | 1915-01-09 | 7 | a-c | Australia news/Chinese counsellor in Australia notifies that Chinese businessmen must provide sufficient official documents to come to Australia. Some 10 dollar bad money are found in Melbourne. A Chinese in Buthurst is found illegally dealing cigarettes. Australia government apologises for soldiers disturbing China Town in Melbourne. Some details of soldiers disturbing China Town in Melbourne. All income must be taxed in New South Wales. Chinese are using the new calender but most of them are still following the old calender. | Australia | http://trove.nla.gov.au/newspaper/page/24094683 | 24094683 | |
| 29968 | 29968 | 1915-04-24 | 7 | a-c | Notice of consul general in Australia for selling public loans of China. Chinese people in Sydney are buying China's public loans. A train from Melbourne to Sydney crashed into a post-bus resulting many injuries. Unknown reasons for a Chinese woman and an European man's death in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094820 | 24094820 | |
| 30028 | 30028 | 1915-05-08 | 7 | a-c | Australia news/ Details of China's Business and Trade Association in Sydney dealing with issues of public loans selling in Australia. Letter of Foreign Affairs Ministry and Finance Ministry to Council General in Australia on public loans issue. Provisions of four-year plan of public loans by China's Business and Trade Association. Name list of Melbourne Chinese buying public loans. Sydney imports are decreasing this year. A Chinese doctor Li Shiwei commits suicide and his money is found by the police. Case of the Chinese Ding Sheng injuring a police in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094836 | 24094836 | |
| 30222 | 30222 | 1915-06-26 | 8 | a-c | The notice of consul general in Australia/ Name list of people awarded by Chinese government for their donations to China ( to be continued). | Australia | http://trove.nla.gov.au/newspaper/page/24094895 | 24094895 | |
| 30953 | 30953 | 1916-01-29 | 7 | a-c | Australia news/Zhen Sunyin, a Chinese consul under training in Melbourne, comes to Sydney for business. Ye Bingnan, an influential Chinese businessman, is to return to China. Chinese Constitution Party holds a farewell party for Ye Bingnan. China's Business and Trade Association holds a farewell party for Ye Bingnan. A Chinese named Di Qun is robbed in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24095129 | 24095129 | |
| 31243 | 31243 | 1916-05-20 | 7 | a-c | Australia news/ Gold price in Hong Kong and its influence upon overseas Chinese business. A bit department store in Sydney is burglarised. Chinese market gardener is extorted. American man in Sydney is charged with murder of Chinese businessman. Chinese man Huang Qiu, a native of Zengcheng county, is injured seriously by Xiao Ji, a native of Dongguan county, on Sussex Street, Sydney. A Chinese man is penalised by Sydney customs for carrying too much gold back to Hong Kong. | Australia | http://trove.nla.gov.au/newspaper/page/24095272 | 24095272 |
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]);