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 |
---|---|---|---|---|---|---|---|---|---|
47713 | 47713 | 1928-12-29 | 8 | b | Australia news/ Thieves in Sydney. Train accident in Melbourne. A traffic accident on Christmas Day in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099071 | 24099071 | |
47709 | 47709 | 1928-12-29 | 8 | a | Britain, France, Holland and Portugal to renew treaties with China. | China | http://trove.nla.gov.au/newspaper/page/24099071 | 24099071 | |
47710 | 47710 | 1928-12-29 | 8 | a | China and Britain sign a new treaty. | Britain | http://trove.nla.gov.au/newspaper/page/24099071 | 24099071 | |
47700 | 47700 | 1928-12-29 | 2 | c | Chinese envoy to Japan Wang Dazheng is returning. | Japan | http://trove.nla.gov.au/newspaper/page/24099066 | 24099066 | |
47711 | 47711 | 1928-12-29 | 8 | a | Coal mine explodes in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24099071 | 24099071 | |
47699 | 47699 | 1928-12-29 | 2 | b-c | Delegation from Shandong province presents their appeal to the Nanjing government. New staff for the Central Training Committee. A national conference of military commanders but Zhang Xueliang is not appearing. | China | http://trove.nla.gov.au/newspaper/page/24099066 | 24099066 | |
47708 | 47708 | 1928-12-29 | 6-7 | a-d | Guangdong news/ Commercial chambers and their request for abolition of some stamp duties. Li Jishen returns and the plan for military restructure. Police force in Guangzhou. Municipal government to take control over the water company. Guangdong, Hunan and Jiangxi to jointly suppress bandits on their borders. Government on the regulations for bank loans. China Aviation Association purchases parts from Germany. New report on the West Mountain (xi shan) faction and their activities. Road projects in Nanhai. The Communists are still active in Haifeng and Lufeng county. Road construction in Dongguan. Ferry sinks near Guangzhou. People in Taishan county fight for their rights of road projects. Management of sand land in Taishan county. Natural disasters in north Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24099070 | 24099070 | |
47703 | 47703 | 1928-12-29 | 2 | f | Japan's new policy in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099066 | 24099066 | |
47706 | 47706 | 1928-12-29 | 3 | f | Jewish people start to build their own country. | Other... | http://trove.nla.gov.au/newspaper/page/24099065 | 24099065 | |
47705 | 47705 | 1928-12-29 | 3 | d | People in Rehe province request to replace Tang Yulin. | China | http://trove.nla.gov.au/newspaper/page/24099065 | 24099065 | |
47712 | 47712 | 1928-12-29 | 8 | a | Recent moves of British warships in China. | China | http://trove.nla.gov.au/newspaper/page/24099071 | 24099071 | |
47701 | 47701 | 1928-12-29 | 2 | c | Soviet Russia is expanding its naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/24099066 | 24099066 | |
47702 | 47702 | 1928-12-29 | 2 | c | Students' associations in Beijing encourage their fellow students to concentrate on study. | China | http://trove.nla.gov.au/newspaper/page/24099066 | 24099066 | |
47707 | 47707 | 1928-12-29 | 5 | a | Third and final part of the report on the celebrations organised by the Chinese communities in Auckland, New Zealand, on the National Day of October 10. | New Zealand | http://trove.nla.gov.au/newspaper/page/24099067 | 24099067 | |
47704 | 47704 | 1928-12-29 | 3 | c | Tianjin turns to the world of bandits. | China | http://trove.nla.gov.au/newspaper/page/24099065 | 24099065 |
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]);