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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
55741 | 55741 | 1936-01-18 | 8 | f | Crisis in north China. | 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 | |
55730 | 55730 | 1936-01-18 | 2 | e | He Yingqin returns to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096712 | 24096712 | |
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 | |
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 | |
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 | |
55733 | 55733 | 1936-01-18 | 3 | b | The future of an independent Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24096711 | 24096711 | |
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 |
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]);