This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40133 | 40133 | 1923-07-21 | 6 | a | Poems by Miao Huili and Wu Elou (Xiuguang), editor of the Tung Wah Times, farewells Gao Ruilin on his return to China, and poems in reply by Gao Ruilin. Poems by Zhu Tingjia on the current situation in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40134 | 40134 | 1923-07-21 | 6 | b-c | An open letter from Guangdong commercial chamber to the army commanders. | China | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40135 | 40135 | 1923-07-21 | 6 | c-d | Competition of international shipping industry in China. | China | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40136 | 40136 | 1923-07-21 | 6 | d | American donation to the famine research in China. | America | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40137 | 40137 | 1923-07-21 | 6 | d | Japan seeks cooperation from Turkish government for the Asian interest. | Other... | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40138 | 40138 | 1923-07-21 | 6 | d | Ammunition factory in Germany has no directors. | Germany | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 |
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]);