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 |
---|---|---|---|---|---|---|---|---|---|
45236 | 45236 | 1926-10-23 | 2 | c | Editorial on the conflict in China between the south and the north and its future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101752 | 24101752 | |
45237 | 45237 | 1926-10-23 | 2 | d | Progress of the reorganisation of the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24101752 | 24101752 | |
45238 | 45238 | 1926-10-23 | 2 | e | American ambassador in Beijing comments on the current situation in China and the Sino-American relations. | China | http://trove.nla.gov.au/newspaper/page/24101752 | 24101752 | |
45239 | 45239 | 1926-10-23 | 2 | f | Associations in Beijing on the devaluation of rouble. | China | http://trove.nla.gov.au/newspaper/page/24101752 | 24101752 | |
45240 | 45240 | 1926-10-23 | 3 | c-d | British gunboats fire at Wanxian in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101751 | 24101751 | |
45241 | 45241 | 1926-10-23 | 3 | d | Zhang Zuolin leads his troops to enter the Shanhaiguan. | China | http://trove.nla.gov.au/newspaper/page/24101751 | 24101751 | |
45242 | 45242 | 1926-10-23 | 3 | e | The Northern Expedition in Hubei province and the new administrative efforts. | China | http://trove.nla.gov.au/newspaper/page/24101751 | 24101751 | |
45243 | 45243 | 1926-10-23 | 5 | a-c | Miscellaneous report on the war in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24101753 | 24101753 | |
45244 | 45244 | 1926-10-23 | 5 | c | Friendship agreement between China and Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24101753 | 24101753 | |
45245 | 45245 | 1926-10-23 | 5 | c | Liu Zuolong starts to attack Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24101753 | 24101753 | |
45246 | 45246 | 1926-10-23 | 6 | a-b | Disaster Relief Society in Shanghai writes to the New South Wales Chinese Chamber of Commerce and acknowledges receipt of the donations to famine areas in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101756 | 24101756 | |
45247 | 45247 | 1926-10-23 | 6 | c | A meeting of the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24101756 | 24101756 | |
45248 | 45248 | 1926-10-23 | 6 | c | The longest undersea cable in the world. | Other... | http://trove.nla.gov.au/newspaper/page/24101756 | 24101756 | |
45249 | 45249 | 1926-10-23 | 6 | c-d | Further report on Japan air navigation plan with China. | Japan | http://trove.nla.gov.au/newspaper/page/24101756 | 24101756 | |
45250 | 45250 | 1926-10-23 | 7 | a | Australia news/ Wilson is sentenced to eight months' imprisonment for tobacco smuggling. Timely rain in Lismore, New South Wales. Chinese opium addicts are penalised in Sydney. Theatre in Brisbane has new looks. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101755 | 24101755 | |
45251 | 45251 | 1926-10-23 | 7 | a-c | Miscellaneous report on the war in China. | China | http://trove.nla.gov.au/newspaper/page/24101755 | 24101755 | |
45252 | 45252 | 1926-10-23 | 7 | d | Britain is considering to recognise the Guangzhou government. | Britain | http://trove.nla.gov.au/newspaper/page/24101755 | 24101755 | |
45253 | 45253 | 1926-10-23 | 8 | a-d | Guangdong news/ Celebrations in Guangzhou on the birthday of Confucius. Railway management agrees to demands of the strikers. Strike of the workers of the Ningyang railway. British gunboats leave the Guangzhou bay. Floods retreat in Gaoyao. Another effort to collect gambling tax. Gambling in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101758 | 24101758 |
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]);