This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27364 | 27364 | 1913-05-03 | 2 | a-b | Liang Qichao's article on national financial policies. | Other... | http://trove.nla.gov.au/newspaper/page/24092665 | 24092665 | |
27385 | 27385 | 1913-05-03 | 6 | a-b | Impact of Song Jiaoren's case on China. | Other... | http://trove.nla.gov.au/newspaper/page/24092669 | 24092669 | |
27386 | 27386 | 1913-05-03 | 7 | a-b | Australian news/ Chinese consul general's gun wound case. Former Chinese consulate's interpreter sentenced five year jail for gun wounding Chinese consul general. Melbourne's overseas Chinese representative talks about his trip to China. Australian new warship arrives in Melbourne from Britain. Number of overseas Chinese in Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092668 | 24092668 |
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]);