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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
55741 | 55741 | 1936-01-18 | 8 | f | Crisis in north China. | 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 | |
55739 | 55739 | 1936-01-18 | 8 | e | New Year's celebrations in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096718 | 24096718 | |
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 | |
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 | |
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 | |
55735 | 55735 | 1936-01-18 | 3 | e | Japanese economic invasion of China. | Japan | 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 | |
55733 | 55733 | 1936-01-18 | 3 | b | The future of an independent Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24096711 | 24096711 | |
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 | |
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 | |
55730 | 55730 | 1936-01-18 | 2 | e | He Yingqin returns to Nanjing. | 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 | |
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 | |
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 |
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]);