This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47527 | 47527 | 1928-10-27 | 2 | c | A case of kidnap in Hawaii and the ransom. | America | http://trove.nla.gov.au/newspaper/page/24098994 | 24098994 | |
47537 | 47537 | 1928-10-27 | 8 | a | Amount of indemnity paid by Germany after the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24099000 | 24099000 | |
47539 | 47539 | 1928-10-27 | 8 | a-c | Australia news/ A man found dead in Sydney suburb. Illegal wines in Sydney. The half-breed woman is found no guilty for the death of her Chinese husband. Chinese man is detained in Sydney for opium smoking. Mother and son are nearly drowned in Sydney. A letter from the Tung Wah Hospital in Hong Kong to the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099000 | 24099000 | |
47536 | 47536 | 1928-10-27 | 8 | a | British parliamentarians are not happy with American's China policy. | Britain | http://trove.nla.gov.au/newspaper/page/24099000 | 24099000 | |
47526 | 47526 | 1928-10-27 | 2 | b | Editorial by Tung Wah Times claims that China should learn from Japanese experience for the review of treaties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098994 | 24098994 | |
47535 | 47535 | 1928-10-27 | 6-7 | a-d | Guangdong news/ Government to monopolise the sale of saltpetre imported from Chile. Road construction in Dongguan. Citizenship issues of the inter-country marriage. Magistrate of Huaaxian county appeals for abolition of some levies. Policeman is sacked for sexual harassment. Agreement signed to take back old French concession in Guangzhou. The Communist Party in Huangpu Military Academy and other army schools. The assassination of Shen Dingyi and his anti-Communist attitude. Inland navigation in Chaozhou and Shantou. Bandit chieftain is killed in Dongguan. Road widened in Shilong town. Tap water project in Xinhui county. Bandit chieftain Liu Yao is executed. Clash between defence troops and local residents in Zengcheng county. Bandits from Zengcheng are looting in Dongguan. Levy for drama performance in Kaiping county. Operation of the Ningyang railway in Taishan. | China | http://trove.nla.gov.au/newspaper/page/24098998 | 24098998 | |
47533 | 47533 | 1928-10-27 | 5 | a | Hong Kong news/ Women association in Hong Kong against their husbands. A hotel customer commits suicide but fails. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098995 | 24098995 | |
47528 | 47528 | 1928-10-27 | 2 | d | Japanese ambassador in China talks to the chief of staff of Bai Chongxi. | China | http://trove.nla.gov.au/newspaper/page/24098994 | 24098994 | |
47534 | 47534 | 1928-10-27 | 5 | c | Japanese bathrooms in Dalian, of Fengtian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098995 | 24098995 | |
47531 | 47531 | 1928-10-27 | 3 | d | Jinan of Shandong province in the extreme panic. | China | http://trove.nla.gov.au/newspaper/page/24098993 | 24098993 | |
47530 | 47530 | 1928-10-27 | 3 | b | Manchuria prepares to deal with harassment by Mongolian troops. | China | http://trove.nla.gov.au/newspaper/page/24098993 | 24098993 | |
47538 | 47538 | 1928-10-27 | 8 | a | Many people are seeking a position in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099000 | 24099000 | |
47532 | 47532 | 1928-10-27 | 3 | e | The Nationalist troops are still trying to suppress the Communist forces under Zhu De and Mao Zedong, and the report. | China | http://trove.nla.gov.au/newspaper/page/24098993 | 24098993 | |
47529 | 47529 | 1928-10-27 | 2 | f | Zhang Zongchang attempts to topple Yang Yuting and Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24098994 | 24098994 |
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]);