This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52825 | 52825 | 1933-05-06 | 2 | c | Shang Zhen personally command his troops in the heavy snow in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091212 | 24091212 | |
52826 | 52826 | 1933-05-06 | 2 | d | The communist troops in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24091212 | 24091212 | |
52827 | 52827 | 1933-05-06 | 2 | d | Wang Jingwei suddenly changes his attitude towards Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091212 | 24091212 | |
52828 | 52828 | 1933-05-06 | 2 | e | Feng Yuxiang writes to Jiang Jieshi and puts forward his 12 proposals to fight Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091212 | 24091212 | |
52829 | 52829 | 1933-05-06 | 2 | e | Ma Zhanshan to return China from Russia. | China | http://trove.nla.gov.au/newspaper/page/24091212 | 24091212 | |
52830 | 52830 | 1933-05-06 | 2 | e | Preparation for Li Yuanhong's funeral. | China | http://trove.nla.gov.au/newspaper/page/24091212 | 24091212 | |
52831 | 52831 | 1933-05-06 | 3 | a | The war in north China and miscellaneous reports. | China | http://trove.nla.gov.au/newspaper/page/24091211 | 24091211 | |
52834 | 52834 | 1933-05-06 | 3 | e | Feng Yuxiang wants to fight Japanese at the front. | China | http://trove.nla.gov.au/newspaper/page/24091211 | 24091211 | |
52835 | 52835 | 1933-05-06 | 3 | e | Aviation school moves from Hangzhou to Luoyang in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24091211 | 24091211 | |
52836 | 52836 | 1933-05-06 | 5 | a | News from Chahaer, Suiyuan province. | China | http://trove.nla.gov.au/newspaper/page/24091213 | 24091213 | |
52837 | 52837 | 1933-05-06 | 5 | c | Chinese General Song Zheyuan and his story. | China | http://trove.nla.gov.au/newspaper/page/24091213 | 24091213 | |
52838 | 52838 | 1933-05-06 | 5 | d | Japan prepares for a war with Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24091213 | 24091213 | |
52840 | 52840 | 1933-05-06 | 7-8 | a-f | Guangdong news/ The southwest authority against the plenary session recently organised by the Nanjing government. Jiang Jieshi seeks compromise with Japanese. Efforts to suppress the communist in south Jiangxi province. Troops gather in Guangzhou and may go to fight Japanese in the north. Peng Juesheng has been executed. Xu Jingtang has new appointment. Air defence and the exercise in Guangzhou. It is not easy to live in Guangzhou. Wen Zongyao on the aviation association. Ghosts discovered in Guangzhou suburb. A love story in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24091215 | 24091215 | |
52841 | 52841 | 1933-05-06 | 6 | a | Rumours on the truce talks between China and Japan. News on the battles in north China between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091216 | 24091216 |
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]);