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 |
|---|---|---|---|---|---|---|---|---|---|
| 44589 | 44589 | 1926-04-10 | 2 | b-d | Second and final part of Jiang Kanghu's warning to the Chinese people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101518 | 24101518 | |
| 44590 | 44590 | 1926-04-10 | 2 | d-f | Second and final part of a report on Wu Peifu's strategy to deal with the current situations. | China | http://trove.nla.gov.au/newspaper/page/24101518 | 24101518 | |
| 44591 | 44591 | 1926-04-10 | 2 | f | Duan Qirui steps down for the second time and his circular telegram. | China | http://trove.nla.gov.au/newspaper/page/24101518 | 24101518 | |
| 44592 | 44592 | 1926-04-10 | 3 | a | Xu Shiying writes to Sun Chuanfang and the letter. | China | http://trove.nla.gov.au/newspaper/page/24101517 | 24101517 | |
| 44593 | 44593 | 1926-04-10 | 3 | b-d | China's treasury, the tariff revenue and association. | China | http://trove.nla.gov.au/newspaper/page/24101517 | 24101517 | |
| 44594 | 44594 | 1926-04-10 | 3 | d-f | Names listed for donations to the Zengcheng fellows association in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101517 | 24101517 | |
| 44595 | 44595 | 1926-04-10 | 5 | a | The Duan Qirui government in Beijing comes to an end, comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
| 44596 | 44596 | 1926-04-10 | 5 | b | Bandits hijack ferry on its way from Guangzhou to Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
| 44597 | 44597 | 1926-04-10 | 5 | b | Police in Dublin, Ireland, seize large number of weapons. | Britain | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
| 44598 | 44598 | 1926-04-10 | 5 | b | Trade treaty signed between Japan and Germany. | Japan | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
| 44599 | 44599 | 1926-04-10 | 5 | b | Students are arrested in Tokyo for distributing propaganda leaflets. | Japan | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
| 44600 | 44600 | 1926-04-10 | 5 | c | A theatre collapses in Mexico during performance. | America | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
| 44601 | 44601 | 1926-04-10 | 5 | c | China may have a big war. | America | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
| 44602 | 44602 | 1926-04-10 | 5 | c | Wu Peifu and Zhang Zuolin start air strike on Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
| 44603 | 44603 | 1926-04-10 | 6 | a-b | Science and Esperanto, an international conference. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101522 | 24101522 | |
| 44604 | 44604 | 1926-04-10 | 6 | b | Chinese in Russia and their loss due to the revolution. | Russia | http://trove.nla.gov.au/newspaper/page/24101522 | 24101522 | |
| 44605 | 44605 | 1926-04-10 | 7 | b-c | Australia news/ The Chinese School in Sydney starts new semester. Two women thieves are arrested in Sydney. Visitors to the Royal Agricultural Show in Sydney. A ship sinks near Brisbane. Federal tax revenue increases. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101521 | 24101521 | |
| 44606 | 44606 | 1926-04-10 | 7 | e | Deposed Korean emperor is ill. | Japan | http://trove.nla.gov.au/newspaper/page/24101521 | 24101521 | |
| 44607 | 44607 | 1926-04-10 | 7 | e | Fire in Cairo, Egypt. | Other... | http://trove.nla.gov.au/newspaper/page/24101521 | 24101521 | |
| 44608 | 44608 | 1926-04-10 | 8 | a-d | Guangdong news/ Ministry of Finance on the new stamp duties. The resignation of Jiang Jieshi and the reason. High alert in Huizhou city. The whereabouts of Wei Bangping. Refugees in Guangzhou. Springs found in Xiqiao mountain. Family feud and fighting in Taishan county. Order to disband local security troops. | China | http://trove.nla.gov.au/newspaper/page/24101524 | 24101524 | |
| 44609 | 44609 | 1926-04-10 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101524 | 24101524 |
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]);