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