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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
47608 | 47608 | 1928-11-24 | 5 | d | Association of widows in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099027 | 24099027 | |
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 | |
47595 | 47595 | 1928-11-24 | 2 | b | Birthday celebration for Confucius in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24099026 | 24099026 | |
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 | |
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 | |
47611 | 47611 | 1928-11-24 | 8 | a | Famine in Soviet Russia. | Britain | 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 | |
47600 | 47600 | 1928-11-24 | 2 | f | Feng Yuxiang destroys temples in Shandong 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 | |
47614 | 47614 | 1928-11-24 | 8 | a | Floods in America. | America | 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 | |
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 | |
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 | |
47602 | 47602 | 1928-11-24 | 3 | b | Japanese troops in Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099025 | 24099025 | |
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 | |
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 | |
47613 | 47613 | 1928-11-24 | 8 | a | Smallpox detected in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
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 | |
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 | |
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 |
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]);