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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 |
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]);