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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 55733 | 55733 | 1936-01-18 | 3 | b | The future of an independent Philippines. | Other... | 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 | |
| 55735 | 55735 | 1936-01-18 | 3 | e | Japanese economic invasion of China. | Japan | 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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]);