This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34471 | 34471 | 1919-05-10 | 3 | c-d | News about Siberia. | China | http://trove.nla.gov.au/newspaper/page/24097709 | 24097709 | |
34481 | 34481 | 1919-05-10 | 8 | c-d | Guangdong news/ The power of the military government. Li Chun is working hard for peace. Charity institutions in Guangdong and their work to help famine victims. Rice price going down in Guangzhou. Preparation for railway construction from Guangzhou to Macao. | China | http://trove.nla.gov.au/newspaper/page/24097716 | 24097716 |
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]);