This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2568 | 2568 | 1899-05-27 | 2 | a-b | The third part of a report submitted by Li Hongzhang and Fu Liang. | http://trove.nla.gov.au/newspaper/page/24102412 | 24102412 | ||
2569 | 2569 | 1899-05-27 | 2 | b-c | A biography of Liu Guangdi, one of the six martyrs. | http://trove.nla.gov.au/newspaper/page/24102412 | 24102412 | ||
2570 | 2570 | 1899-05-27 | 2 | c-f | Correspondence of Ou Qujia on recent development in Chinese affairs. | http://trove.nla.gov.au/newspaper/page/24102412 | 24102412 | ||
2571 | 2571 | 1899-05-27 | 2 | f | The underlying motive behind the international peace conference is to carve up China. | http://trove.nla.gov.au/newspaper/page/24102412 | 24102412 | ||
2572 | 2572 | 1899-05-27 | 2 | f | Britain changes its attitude towards the railway building in China. | http://trove.nla.gov.au/newspaper/page/24102412 | 24102412 |
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]);