This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39029 | 39029 | 1922-11-18 | 6 | b | Statistics on the cotton production in China (Zhili, Shandong, Shanxi, Henan, Shaanxi, Jiangsu, Zhejiang, Anhui, Hubei, and Jiangxi). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094192 | 24094192 | |
39030 | 39030 | 1922-11-18 | 6 | b | Political situation in Fujian province after the left of Li Houji. | China | http://trove.nla.gov.au/newspaper/page/24094192 | 24094192 | |
39036 | 39036 | 1922-11-18 | 7 | b | Peking (Beijing) Cafe in Melbourne on fire and the damages. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39037 | 39037 | 1922-11-18 | 7 | b | A Chinese market gardener in Sydney hides his money in kerosene tank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39038 | 39038 | 1922-11-18 | 7 | b | Tung Wah Times farewells to Zhao Yu and Wu Jinze. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 |
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]);