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 |
---|---|---|---|---|---|---|---|---|---|
44538 | 44538 | 1926-03-20 | 7 | Clash between Chinese and Japanese troops in Dagu, near Tianjin. | Japan | http://trove.nla.gov.au/newspaper/page/24101497 | 24101497 | ||
44522 | 44522 | 1926-03-20 | 5 | a | Hospital workers are also on strike in Guangzhou, and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44532 | 44532 | 1926-03-20 | 6 | a | Advertisement articles for Holdenson & Nielson Fresh Food, Howart and McPhail in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101498 | 24101498 | |
44535 | 44535 | 1926-03-20 | 7 | a | The Chinese School in Sydney seeks to employ a teacher and the advertisement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101497 | 24101497 | |
44536 | 44536 | 1926-03-20 | 7 | a | Miu Huili resigns from his position at the Tung Wah Times and his notice | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101497 | 24101497 | |
44539 | 44539 | 1926-03-20 | 8 | a-d | Guangdong news/ Reorganisation of the provincial government. Borodin applies for resignation but refused. Peasants' association in local Guangdong. Bandits in Panyu hijack army ferry. New office set up in Xinhui to protect navigation. Market in Dongguan reopened after a strike. The Communists in Guangzhou seek to control all newspapers. | China | http://trove.nla.gov.au/newspaper/page/24101500 | 24101500 | |
44518 | 44518 | 1926-03-20 | 3 | b | Zhang Taiyan on Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24101493 | 24101493 | |
44523 | 44523 | 1926-03-20 | 5 | b | Many Chinese flee Guangdong and arrive Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44524 | 44524 | 1926-03-20 | 5 | b | Situation in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44525 | 44525 | 1926-03-20 | 5 | b | Chinese government pays its telegram charges to the post office. | China | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44526 | 44526 | 1926-03-20 | 5 | b | Jiang Jieshi leaves Guangzhou for Hong Kong. | Britain | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44527 | 44527 | 1926-03-20 | 5 | b | A passenger plane in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44528 | 44528 | 1926-03-20 | 5 | b | Report on the strike of hospital workers in Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44537 | 44537 | 1926-03-20 | 7 | b | Australia news/ Damages of the bush fire in Victoria. Mails are stolen in Sydney. A young woman commits suicide in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101497 | 24101497 | |
44533 | 44533 | 1926-03-20 | 6 | b-c | A special report on the strike in Guangzhou and its influence on the market & business. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101498 | 24101498 | |
44514 | 44514 | 1926-03-20 | 2 | b-d | Australian-born Chinese youth should learn their native language at the Sydney Chinese School, an article written by Luo Fuquan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101494 | 24101494 | |
44519 | 44519 | 1926-03-20 | 3 | c | The Fengtian conference and Zhang Zuolin's new moves. | China | http://trove.nla.gov.au/newspaper/page/24101493 | 24101493 | |
44529 | 44529 | 1926-03-20 | 5 | c | The war in north China. | Britain | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44530 | 44530 | 1926-03-20 | 5 | c | Japan dispatches gunboats to Dagu, near Tianjin. | America | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44531 | 44531 | 1926-03-20 | 5 | c | Chinese employees leave the Boji Hospital in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44534 | 44534 | 1926-03-20 | 6 | c-d | Fourth part of the survey on the forestry in Shanxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101498 | 24101498 | |
44515 | 44515 | 1926-03-20 | 2 | d | Xiong Xiling on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24101494 | 24101494 | |
44520 | 44520 | 1926-03-20 | 3 | d | Fengtian provincial authority explains to the Chinese students returned from Japan. | China | http://trove.nla.gov.au/newspaper/page/24101493 | 24101493 | |
44516 | 44516 | 1926-03-20 | 2 | e | A cabinet meeting of the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24101494 | 24101494 | |
44521 | 44521 | 1926-03-20 | 3 | e | Sun Chuanfang seeks relatives in Suzhou, of Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24101493 | 24101493 | |
44517 | 44517 | 1926-03-20 | 2 | f | Zhang Taiyan replies to Gu Zhongxiu. | China | http://trove.nla.gov.au/newspaper/page/24101494 | 24101494 |
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]);