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 |
|---|---|---|---|---|---|---|---|---|---|
| 54637 | 54637 | 1934-11-03 | 2 | a | Comments selected from an American newspaper on General Cai Tingkai. | America | http://trove.nla.gov.au/newspaper/page/24096216 | 24096216 | |
| 54638 | 54638 | 1934-11-03 | 2 | c | China news/ Chinese troops in Liaoning province take over Changbai county town. Jiang Jieshi orders Sichuan army to suppress the communists. Japanese troops in north China. Japanese protest against Chinese government over the murder of Japanese businessman in Shanghai. Construction of the Longhai railway. Japanese plan to invade the west of Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096216 | 24096216 | |
| 54639 | 54639 | 1934-11-03 | 3 | a | Council of Legislature in Nanjing debates the draft constitution. | China | http://trove.nla.gov.au/newspaper/page/24096215 | 24096215 | |
| 54640 | 54640 | 1934-11-03 | 3 | c | Heavy rains in Xuzhou area, north Jiangsu province, and the Yellow River is flooding. | China | http://trove.nla.gov.au/newspaper/page/24096215 | 24096215 | |
| 54641 | 54641 | 1934-11-03 | 3 | d | Chinese communities in Washington welcome General Cai Tingkai. | America | http://trove.nla.gov.au/newspaper/page/24096215 | 24096215 | |
| 54642 | 54642 | 1934-11-03 | 3 | d | Kong Xiangxi denies any changes to the current currency system. | China | http://trove.nla.gov.au/newspaper/page/24096215 | 24096215 | |
| 54643 | 54643 | 1934-11-03 | 3 | e | America purchase silvers from overseas. | America | http://trove.nla.gov.au/newspaper/page/24096215 | 24096215 | |
| 54644 | 54644 | 1934-11-03 | 5 | d | The ten most spoken languages in the world. | South America | http://trove.nla.gov.au/newspaper/page/24096217 | 24096217 | |
| 54645 | 54645 | 1934-11-03 | 6 | f | Australia news/ Federal government raises funds by issuing more bonds. Floods in Wagga Wagga, NSW. Japanese are stealing marine products from north Australia. Chinese gardener Huang Huakang dies in a house fire in Sydney and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096220 | 24096220 |
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]);