This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39848 | 39848 | 1923-05-12 | 7 | a | Bandits in Lincheng, Shandong province, hijack a train and kidnap some foreign passengers. | America | http://trove.nla.gov.au/newspaper/page/24094403 | 24094403 | |
| 39849 | 39849 | 1923-05-12 | 7 | a | A notice issued by the Chinese consulate-general in Melbourne says some government bonds can be cashed now. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094403 | 24094403 | |
| 39850 | 39850 | 1923-05-12 | 7 | b | Fundraising for Sydney hospitals and the involvement of Chinese communities & associations like Lai Gee Club (li zhi hui), zhi gong tang, the Nationalist Party, Chinese Chamber of Commerce in New South Wales, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094403 | 24094403 | |
| 39851 | 39851 | 1923-05-12 | 7 | b-c | Sydney police raid Chinese gambling dens in Alexandria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094403 | 24094403 | |
| 39852 | 39852 | 1923-05-12 | 7 | c-d | Report on the battle between Yunnan and Guangxi armies. | China | http://trove.nla.gov.au/newspaper/page/24094403 | 24094403 | |
| 39853 | 39853 | 1923-05-12 | 7 | d | A public notice issued by the Tung Wah Times about its dispute with Min Bao, organ of the Nationalist Party in Sydney, and involvement of Ye Bingnan, Li Ganquan, Yu Rong, Ma Shupei, Huang Yougong, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094403 | 24094403 | |
| 39854 | 39854 | 1923-05-12 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094403 | 24094403 |
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]);