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 |
---|---|---|---|---|---|---|---|---|---|
53928 | 53928 | 1934-03-10 | 2 | b | Yan Huiqing on the international affairs. | China | http://trove.nla.gov.au/newspaper/page/24091557 | 24091557 | |
53929 | 53929 | 1934-03-10 | 2 | c | The 19th Route Army to be reorganised. | China | http://trove.nla.gov.au/newspaper/page/24091557 | 24091557 | |
53930 | 53930 | 1934-03-10 | 2 | d | A report on the Muslims rebellion in south Xinjiang. | China | http://trove.nla.gov.au/newspaper/page/24091557 | 24091557 | |
53932 | 53932 | 1934-03-10 | 2 | f | Wu Peifu's envoy arrives Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24091557 | 24091557 | |
53933 | 53933 | 1934-03-10 | 2 | f | Japanese set up radio station in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091557 | 24091557 | |
53934 | 53934 | 1934-03-10 | 3 | a | Muslims in south Xinjiang purchase weapons from Germany. | China | http://trove.nla.gov.au/newspaper/page/24091556 | 24091556 | |
53935 | 53935 | 1934-03-10 | 3 | a | Jiang Jieshi is going to Fujian. | China | http://trove.nla.gov.au/newspaper/page/24091556 | 24091556 | |
53936 | 53936 | 1934-03-10 | 3 | d | The puppet Manchurian government under Japanese control. | China | http://trove.nla.gov.au/newspaper/page/24091556 | 24091556 | |
53939 | 53939 | 1934-03-10 | 5 | a | Sun Dianying and his troops. | China | http://trove.nla.gov.au/newspaper/page/24091558 | 24091558 | |
53940 | 53940 | 1934-03-10 | 5 | c | Wu Peifu mourns Du Xigui. | China | http://trove.nla.gov.au/newspaper/page/24091558 | 24091558 | |
53941 | 53941 | 1934-03-10 | 5 | c | Resistance of Chinese troops to Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091558 | 24091558 | |
53945 | 53945 | 1934-03-10 | 7-8 | a-f | Guangdong news/ Cai Tingkai and the future of the 19th Route Army. Guangzhou municipal government tries to maintain stability of the financial market. Tang Shaoyi on the case of Hengqin island and the disputes with Portuguese. Li Zongren returns to Nanning, capital of Guangxi province. Financial market in Guangzhou before the Chinese New Year. Civilians in Guangdong suburbs oppose to the road construction. Manufacturing of aircraft in Guangzhou. Shunde businessmen in Hong Kong present their petition to the provincial government. | China | http://trove.nla.gov.au/newspaper/page/24091560 | 24091560 | |
53947 | 53947 | 1934-03-10 | 6 | a | Living Buddha on the mission of appeasement to Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091561 | 24091561 | |
53948 | 53948 | 1934-03-10 | 6 | a | Puyi talks to foreign journalists. | China | http://trove.nla.gov.au/newspaper/page/24091561 | 24091561 | |
53950 | 53950 | 1934-03-10 | 6 | a | Recent relations between Japan and Russia. | China | http://trove.nla.gov.au/newspaper/page/24091561 | 24091561 | |
53953 | 53953 | 1934-03-10 | 6 | d | Enthroning ceremony in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091561 | 24091561 |
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]);