This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40168 | 40168 | 1923-07-28 | 7 | a | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40169 | 40169 | 1923-07-28 | 7 | a | Postal service in Australia makes profit. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40170 | 40170 | 1923-07-28 | 7 | a | New South Wales premier returns to Sydney after touring Britain, south Europe, America and Canada. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40171 | 40171 | 1923-07-28 | 7 | a | Two trains collide in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40172 | 40172 | 1923-07-28 | 7 | a | Husband and wife suffers in Sydney due to unemployment. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40173 | 40173 | 1923-07-28 | 7 | b-c | Zhi gong tang in Sydney celebrates the birthday of Huang Zhu, chairman of the association. Speakers include Tang Longxiang, Li Xiangbo, Ye Tonggui, Peng Lichuan, Wu Elou, Wu Gen, Lin Dasan and many white people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40174 | 40174 | 1923-07-28 | 7 | c | Epidemics in Glen Innes and Tingha, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40175 | 40175 | 1923-07-28 | 7 | c | A Briton is kidnapped in Yunnan province, China. | Britain | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40176 | 40176 | 1923-07-28 | 7 | c | Chinese treasurer Huang Kaiwen has resigned. | Britain | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40177 | 40177 | 1923-07-28 | 7 | c | First part of an investigation on economic activities in China conducted by the Beijing government (the making and export of hairnet). | China | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40178 | 40178 | 1923-07-28 | 7 | c-d | Bandits on the border of Tibet and Sichuan province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 |
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]);