This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27606 | 27606 | 1913-07-19 | 2 | a | Special notice issued by the Chinese Empire Reform Association in Sydney on name change, and the new name will be the Nationalist Association (bing wu guo min dang), 158 George Street North, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092753 | 24092753 | |
27607 | 27607 | 1913-07-19 | 2 | a | Liang Qichao's speech at the first meeting of the Progress Party (jin bu dang). | China | http://trove.nla.gov.au/newspaper/page/24092753 | 24092753 | |
27608 | 27608 | 1913-07-19 | 2 | c | Order issued by President Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24092753 | 24092753 | |
27609 | 27609 | 1913-07-19 | 2 | c | President Yuan Shikai and his worries over internal and external affairs. | China | http://trove.nla.gov.au/newspaper/page/24092753 | 24092753 | |
27610 | 27610 | 1913-07-19 | 2 | c-d | Vice President Li Yuanhong tries to mediate local conflicts. | China | http://trove.nla.gov.au/newspaper/page/24092753 | 24092753 | |
27611 | 27611 | 1913-07-19 | 2 | d | A prominent figure in Shanghai seeks help from Russia and Japan in his fighting with President Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24092753 | 24092753 |
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]);