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 |
---|---|---|---|---|---|---|---|---|---|
55732 | 55732 | 1936-01-18 | 3 | b | British on the air defence in the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24096711 | 24096711 | |
55727 | 55727 | 1936-01-18 | 2 | b | Jiang Jieshi becomes Premier of China and other changes of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096712 | 24096712 | |
55728 | 55728 | 1936-01-18 | 2 | c | University students in Shanghai and their demonstration against autonomous movement in north China. | China | http://trove.nla.gov.au/newspaper/page/24096712 | 24096712 | |
55729 | 55729 | 1936-01-18 | 2 | c | China and Japan are talking over the crisis in north China. | China | http://trove.nla.gov.au/newspaper/page/24096712 | 24096712 | |
55730 | 55730 | 1936-01-18 | 2 | e | He Yingqin returns to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096712 | 24096712 | |
55731 | 55731 | 1936-01-18 | 3 | a | Associations in Shanghai request the Nanjing government to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096711 | 24096711 | |
55734 | 55734 | 1936-01-18 | 3 | b | Japanese strategies to invade China. | China | http://trove.nla.gov.au/newspaper/page/24096711 | 24096711 | |
55737 | 55737 | 1936-01-18 | 6-7 | a-d | Guangdong news/ Zhongshan University students and their demonstration against Japanese invasion. Chinese airforce troops are stronger. The southwest authority putss forward their proposals to the central government to resistance of Japanese invasion. The business in Guangzhou. Illeal opium growing in Panyu county. | China | http://trove.nla.gov.au/newspaper/page/24096716 | 24096716 | |
55739 | 55739 | 1936-01-18 | 8 | e | New Year's celebrations in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096718 | 24096718 | |
55740 | 55740 | 1936-01-18 | 8 | f | The Chinese communist troops are fleeing to Guizhou. | China | http://trove.nla.gov.au/newspaper/page/24096718 | 24096718 | |
55741 | 55741 | 1936-01-18 | 8 | f | Crisis in north China. | China | http://trove.nla.gov.au/newspaper/page/24096718 | 24096718 | |
55735 | 55735 | 1936-01-18 | 3 | e | Japanese economic invasion of China. | Japan | http://trove.nla.gov.au/newspaper/page/24096711 | 24096711 | |
55733 | 55733 | 1936-01-18 | 3 | b | The future of an independent Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24096711 | 24096711 | |
55736 | 55736 | 1936-01-18 | 5 | c | A notice issued by the Chinese consulate-general in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096713 | 24096713 | |
55738 | 55738 | 1936-01-18 | 8 | a | Editorial by Tung Wah Times condemns the Republic News (min bao) in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096718 | 24096718 | |
55742 | 55742 | 1936-01-18 | 8 | g | Australia news/ New Lord Mayor of Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096718 | 24096718 |
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]);