This data as json, CSV (advanced)
Suggested facets: column, date (date)
page_url 1 ✖
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40811 | 40811 | 1923-12-15 | 8 | a-d | Guangdong news/ Chen Qiyuan withdraws money from the bank by force. Sun Yatsen speaks to his troops. Sun Yatsen's English secretary Chen Youren can not assure the takeover of Huizhou. More battles in Guangdong. Guangdong army occupy Boluo and Shilong. Jiang Guangliang escapes. Hong Zhaolin writes to his family. Liu Yushan and Liu Zhenhuan are disbanded. Guangzhou will turn into battle field. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094654 | 24094654 | |
| 40812 | 40812 | 1923-12-15 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094654 | 24094654 | |
| 40813 | 40813 | 1923-12-15 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094654 | 24094654 |
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]);