This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38427 | 38427 | 1922-03-18 | 2 | b-c | Li Yuanhong talks to journalist about the third government proposed by Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24093904 | 24093904 | |
38435 | 38435 | 1922-03-18 | 3 | b-c | Former American official writes and proposes to use one language throughout the world. | America | http://trove.nla.gov.au/newspaper/page/24093903 | 24093903 | |
38455 | 38455 | 1922-03-18 | 8 | b-c | Guangdong news/ Labour dispute and the voice of national unification. Xu Shuzheng returns to Guangdong from Guangxi. News on the north expedition. Governor Chen Jiongming orders to stop fighting of the legislature members in Gaoyao county. Branches proposed for the Guangzhou-Hankou railway. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093910 | 24093910 |
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]);