This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34291 | 34291 | 1919-03-15 | 8 | a-b | Beijing news/ Another peace association organised in Beijing. Chinese government on the opium ban. Chinese government finds it hard to protect its nationals in Russia. Foreign report on China's deportation of German nationals. Japanese shipping industry in China. | China | http://trove.nla.gov.au/newspaper/page/24097652 | 24097652 | |
34292 | 34292 | 1919-03-15 | 8 | b-c | Guangdong news/ A telegram from the old parliament to the Paris Peace Conference. Provincial treasury invites tenders to the road construction in Guangzhou. Yunnan army commander Li Genyuan seeks to control gambling in the Si Yi countries. Ferry tax in Xinhui county. Bandits in Enping county. | China | http://trove.nla.gov.au/newspaper/page/24097652 | 24097652 |
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]);