This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 54304 | 54304 | 1934-07-14 | 2 | a | Comments on the Soviet Russia and its relations with China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096084 | 24096084 | |
| 54318 | 54318 | 1934-07-14 | 5 | a | A humorous dialogue on Japanese invasion of China, written by Xue Hanmei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096085 | 24096085 | |
| 54327 | 54327 | 1934-07-14 | 6 | e | Australia news/ Federal election to be held. Deputy Prime Minister quit politics. Aboriginal people in Darwin beat Chinese. Italian man arrested in Sydney for opium smuggling. Number of population in New South Wales. China purchase Australian flour. Arms smuggling in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 |
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]);