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 |
---|---|---|---|---|---|---|---|---|---|
45286 | 45286 | 1926-11-06 | 8 | a-d | Guangdong news/ The Guangzhou government explains proposed solutions to the strikers. Students' association in Huangpu and their declaration to suppress bandits. Xiangshan county authority takes precautions against bandits. Wu Chaoshu and Fu Bingchang. Chinese foreign ministry delivers a note to British ambassador on the boycott. Transportation resumed in Shamian, Guangzhou. A notice by Huang Laiju. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101774 | 24101774 | |
45285 | 45285 | 1926-11-06 | 7 | b | A filial dog saves a baby in Nanhai county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101771 | 24101771 | |
45284 | 45284 | 1926-11-06 | 7 | b | New movement in Guangzhou to boycott foreign goods. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101771 | 24101771 | |
45283 | 45283 | 1926-11-06 | 7 | a-b | Australia news/ Attention to Chinese tomato sellers. Police in Sydney raid an opium den. New South Wales state parliament revises the factory act. Miss Australia selected and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101771 | 24101771 | |
45282 | 45282 | 1926-11-06 | 5 | c | Chinese community in Lyon and their patriotism. | France | http://trove.nla.gov.au/newspaper/page/24101769 | 24101769 | |
45281 | 45281 | 1926-11-06 | 5 | c | Italian Prime Minister Benito Mussolini escapes an assassination. | Other... | http://trove.nla.gov.au/newspaper/page/24101769 | 24101769 | |
45280 | 45280 | 1926-11-06 | 5 | a-c | Miscellaneous report on the martial law enforced in Shanghai and the different responses. | China | http://trove.nla.gov.au/newspaper/page/24101769 | 24101769 | |
45279 | 45279 | 1926-11-06 | 3 | e | The rightist faction of the Nationalist Party issues a declaration in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101767 | 24101767 | |
45278 | 45278 | 1926-11-06 | 3 | e | War clouds over Fujian and Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24101767 | 24101767 | |
45277 | 45277 | 1926-11-06 | 3 | d | Rumours on the possible comprise in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101767 | 24101767 | |
45276 | 45276 | 1926-11-06 | 3 | c | Political situation may change again in north China. | China | http://trove.nla.gov.au/newspaper/page/24101767 | 24101767 | |
45275 | 45275 | 1926-11-06 | 3 | c | Clash between British and Chinese troops in Wanxian, of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101767 | 24101767 | |
45274 | 45274 | 1926-11-06 | 2 | f | Feng Yuxiang's troops retreat. | China | http://trove.nla.gov.au/newspaper/page/24101768 | 24101768 | |
45273 | 45273 | 1926-11-06 | 2 | f | Wu Peifu arrives Zhengzhou and the impacts. | China | http://trove.nla.gov.au/newspaper/page/24101768 | 24101768 | |
45272 | 45272 | 1926-11-06 | 2 | e | A Russian-style national conference in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24101768 | 24101768 | |
45271 | 45271 | 1926-11-06 | 2 | d | Sun Chuanfang, Wu Peifu and Zhang Zuolin to jointly wipe out the communists. | China | http://trove.nla.gov.au/newspaper/page/24101768 | 24101768 | |
45270 | 45270 | 1926-11-06 | 2 | c-d | Editorial on the possible cooperation between Zhang Zuolin and Wu Peifu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101768 | 24101768 |
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]);