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 |
---|---|---|---|---|---|---|---|---|---|
47618 | 47618 | 1928-11-24 | 8 | b-c | Australia news/ Bandits and robberies in Sydney. Result of the federal election. A Chinese thief is brought to trial in Melbourne. Train derails in Sydney and two people killed. Women thieves in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47617 | 47617 | 1928-11-24 | 8 | b | Famine in north China and the relief work. | China | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47616 | 47616 | 1928-11-24 | 8 | b | More pirates found in the South China Sea. | China | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47615 | 47615 | 1928-11-24 | 8 | a | A man in London murders his wife and the further report. | Britain | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47614 | 47614 | 1928-11-24 | 8 | a | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47613 | 47613 | 1928-11-24 | 8 | a | Smallpox detected in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47612 | 47612 | 1928-11-24 | 8 | a | American authority detains Communist activists and the report. | America | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47611 | 47611 | 1928-11-24 | 8 | a | Famine in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47610 | 47610 | 1928-11-24 | 8 | a | A British female missionary is kidnapped in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47609 | 47609 | 1928-11-24 | 6-7 | a-d | Guangdong news/ A thorough search in Guangzhou for the Communist Party members. Fruit shops in Guangzhou and their appeal to the national commercial chamber conference in Shanghai. Boycott to Japanese goods and services. Portuguese troops occupy Chinese territory and the negotiations. Endless search and arrest of the Communists in Guangzhou and the report. Bandits and the Communists in Haifeng and Lufeng county. Road transportation in Zhongshan county. Road construction in Dongguan. Bandits in Xinhui county. Clan feud and fighting between Yu and Tan families in Taishan county. Bandits in Taishan county loot village schools. Chen Hanchuan is arrested and escorted to Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24099030 | 24099030 | |
47608 | 47608 | 1928-11-24 | 5 | d | Association of widows in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099027 | 24099027 | |
47607 | 47607 | 1928-11-24 | 5 | a | Hong Kong news/ Pirates hijack ship and commit murder. Opium seized from a Guangxi ship. Post stamps can kill. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099027 | 24099027 | |
47606 | 47606 | 1928-11-24 | 3 | f | China and France reach agreement over the case of Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099025 | 24099025 | |
47605 | 47605 | 1928-11-24 | 3 | e | A conference of the National chamber of commerce in Shanghai and the report. | China | http://trove.nla.gov.au/newspaper/page/24099025 | 24099025 | |
47604 | 47604 | 1928-11-24 | 3 | d | The war clouds over the east of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24099025 | 24099025 | |
47603 | 47603 | 1928-11-24 | 3 | c | Sun Chuanfang and the agricultural cultivation in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099025 | 24099025 | |
47602 | 47602 | 1928-11-24 | 3 | b | Japanese troops in Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099025 | 24099025 | |
47601 | 47601 | 1928-11-24 | 2 | f | Candidates for the ministers of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24099026 | 24099026 | |
47600 | 47600 | 1928-11-24 | 2 | f | Feng Yuxiang destroys temples in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099026 | 24099026 | |
47599 | 47599 | 1928-11-24 | 2 | e | The Communist disasters and bandits in the west of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24099026 | 24099026 | |
47598 | 47598 | 1928-11-24 | 2 | e | Feng Yuxiang's troops reach the Tianjin-Pukou railway line. | China | http://trove.nla.gov.au/newspaper/page/24099026 | 24099026 | |
47597 | 47597 | 1928-11-24 | 2 | c | Japanese plenipotentiary arrives in Nanjing and his talks with representatives of the Nanjing government Wang Zhengting, Zhou Longguang and others on the treaty issues, Jinan and other matters. | China | http://trove.nla.gov.au/newspaper/page/24099026 | 24099026 | |
47596 | 47596 | 1928-11-24 | 2 | c | New draft of the tariff regulations for China. | China | http://trove.nla.gov.au/newspaper/page/24099026 | 24099026 | |
47595 | 47595 | 1928-11-24 | 2 | b | Birthday celebration for Confucius in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24099026 | 24099026 |
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]);