This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33702 | 33702 | 1918-10-05 | 7 | b-c | Australia news/ Australia's exports from last year up to this September. Air mail service proposed between Sydney and London. Sydney police raid three Chinese gambling dens. Chinese communities in Sydney celebrate the birthday of Confucius and speakers include Ye Bingnan, Wu Elou, Zheng Fanchang, Liu Ruxing, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097457 | 24097457 | |
33706 | 33706 | 1918-10-05 | 8 | b-c | Beijing news/ Another opinion on the change of political situations in China. Foreign missions in Beijing on the Chinese troops in Manchuria. Guangdong natives in the new parliament in Beijing and their backgrounds. | China | http://trove.nla.gov.au/newspaper/page/24097460 | 24097460 |
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]);