This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26992 | 26992 | 1913-02-15 | 2 | a | Sydney Nationalist Association's notice about change of its name and objectives. | Other... | http://trove.nla.gov.au/newspaper/page/24092577 | 24092577 | |
26993 | 26993 | 1913-02-15 | 2 | a-b | Liang Qichao's article on provincial government. | Other... | http://trove.nla.gov.au/newspaper/page/24092577 | 24092577 | |
26994 | 26994 | 1913-02-15 | 2 | b-c | President Yuan's orders: appointment of new chief for foreign affairs in Henan; Chen Jiongmin as Guangdong army chief; appointment of new Mongolian deputy chiefs; appointments of new army logistic and vet colleges' principals; and official China Bank. | Other... | http://trove.nla.gov.au/newspaper/page/24092577 | 24092577 | |
26995 | 26995 | 1913-02-15 | 2 | c | Army chief refuses Russian conditions on Mongolia. | Other... | http://trove.nla.gov.au/newspaper/page/24092577 | 24092577 | |
26996 | 26996 | 1913-02-15 | 2 | c-d | Issue of six percent national treasury bonds. | Other... | http://trove.nla.gov.au/newspaper/page/24092577 | 24092577 | |
26997 | 26997 | 1913-02-15 | 2 | d | Financial Ministry's two-year budget. | Other... | http://trove.nla.gov.au/newspaper/page/24092577 | 24092577 |
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]);