This data as json, CSV (advanced)
Suggested facets: source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 31350 | 31350 | 1916-06-24 | 8 | a | The Chinese Constitutionalist Association, 73 George Street North, Sydney, calls for donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095313 | 24095313 | |
| 31351 | 31351 | 1916-06-24 | 8 | a-c | Beijing news/ The Bank of China and the Bank of Communications in Beijing refuse to cash all bank notes. Financial dilemma of the Beijing government. Income of salt tax in China. Foreign missions in Beijing question the government. Sun Yatsen and his new declaration in Shanghai. Emperor Xuantong may come back to power and the rumours. Girl students in Yunnan province are keen to join the army. | China | http://trove.nla.gov.au/newspaper/page/24095313 | 24095313 | |
| 31352 | 31352 | 1916-06-24 | 8 | c-d | Guangdong news/ Current situation in Guangdong and the mediation. Training of civil corps in Guangdong. Liang Qichao leaves Guangzhou. Civil corps in Zengcheng occupy many towns. Civil corps in Dongguan county and their lootings. | China | http://trove.nla.gov.au/newspaper/page/24095313 | 24095313 |
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]);