This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39898 | 39898 | 1923-05-26 | 7 | a | A Sydney missionary has magic skills to cure patients. | Australia | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
| 39899 | 39899 | 1923-05-26 | 7 | a | A meeting of the Chinese Chamber of Commerce in New South Wales and the discussions on new membership, Chinese school, sale of public property in Guangzhou, negotiation with Japan over the Twenty-one Demands, and the visit of Chines football students to Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
| 39900 | 39900 | 1923-05-26 | 7 | a | A Chinese businessman in Sydney is robbed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
| 39901 | 39901 | 1923-05-26 | 7 | a | Counterfeit bank notes found in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
| 39902 | 39902 | 1923-05-26 | 7 | b | Lost golden rings to be picked up at the police office in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
| 39903 | 39903 | 1923-05-26 | 7 | b | A train in New South Wales runs out of control. | Australia | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
| 39904 | 39904 | 1923-05-26 | 7 | b | Chinese consul in Samoa Li Zhaosong entertains new British administrator and businessmen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
| 39905 | 39905 | 1923-05-26 | 7 | b-c | 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/24094419 | 24094419 | |
| 39906 | 39906 | 1923-05-26 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 |
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]);