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 |
|---|---|---|---|---|---|---|---|---|---|
| 55223 | 55223 | 1935-06-29 | 2 | b | Japan's new demands to the Beijing authority over the territory in north China. | China | http://trove.nla.gov.au/newspaper/page/24096481 | 24096481 | |
| 55224 | 55224 | 1935-06-29 | 2 | b | An international spy network smashed in Sichuan province and the report. | China | http://trove.nla.gov.au/newspaper/page/24096481 | 24096481 | |
| 55225 | 55225 | 1935-06-29 | 2 | e | The communists in north Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24096481 | 24096481 | |
| 55226 | 55226 | 1935-06-29 | 2 | e | Chinese judicial authority explains regulations on the marriage of overseas Chinese. | China | http://trove.nla.gov.au/newspaper/page/24096481 | 24096481 | |
| 55227 | 55227 | 1935-06-29 | 2 | f | Rumours in Shanghai on the coming financial crisis. | China | http://trove.nla.gov.au/newspaper/page/24096481 | 24096481 | |
| 55228 | 55228 | 1935-06-29 | 5 | a | Editorial on the loss of north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096482 | 24096482 | |
| 55229 | 55229 | 1935-06-29 | 8 | e | Chinese man detained in New Zealand for opium smuggling. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096487 | 24096487 |
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]);