This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47682 | 47682 | 1928-12-22 | 2 | e | Song Meiling to be mayor of Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47683 | 47683 | 1928-12-22 | 2 | e | Express train resumes service on the Tianjin-Pukou railway. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47684 | 47684 | 1928-12-22 | 2 | e | Hu Hanmin replies to the Shanghai commercial chambers. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47685 | 47685 | 1928-12-22 | 2 | e | Jiang Jieshi comments on the affairs of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47688 | 47688 | 1928-12-22 | 3 | e | Zhang Ji delivers a public speech after becoming chairman of the Nationalist branch in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24099057 | 24099057 |
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]);