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 |
---|---|---|---|---|---|---|---|---|---|
45272 | 45272 | 1926-11-06 | 2 | e | A Russian-style national conference in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24101768 | 24101768 | |
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 | |
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 | |
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 | |
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 | |
45274 | 45274 | 1926-11-06 | 2 | f | Feng Yuxiang's troops retreat. | China | http://trove.nla.gov.au/newspaper/page/24101768 | 24101768 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
45273 | 45273 | 1926-11-06 | 2 | f | Wu Peifu arrives Zhengzhou and the impacts. | China | 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]);