This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26172 | 26172 | 1912-05-25 | 2 | b-c | Li Yuanhong requires all ministers come to Beijing | Li Yuanhong calls on all ministers to come to Beijing, serving for state affairs despite all difficulties they may face at the moment. | China | http://trove.nla.gov.au/newspaper/page/24092248 | 24092248 |
26187 | 26187 | 1912-05-25 | 3 | b-c | Airships for customers in Austrian capital | Austrian capital Vienna uses airships for tourists in peaceful time which may be used in war time. | Other... | http://trove.nla.gov.au/newspaper/page/24092247 | 24092247 |
26191 | 26191 | 1912-05-25 | 6 | b-c | Sun Yatsen's current activities | Sun Yatsen visited Wuhan, Hongkong and was welcomed. Hongkong governor refused to allow Sun Yatsen coming to Hongkong but was forced to agree later under pressure from the people. Guangdong prepares to celebrate Sun Yatsen's arrival. Guangdong people and official welcomed Sun Yatsen's coming. | China | http://trove.nla.gov.au/newspaper/page/24092252 | 24092252 |
26195 | 26195 | 1912-05-25 | 7 | b-c | Current news of Tongwan in Guangdong | Tongwan in Guangdong is in a desperate situation where high unemployment, widespread roberies, bandits disturbances are common these days. | China | http://trove.nla.gov.au/newspaper/page/24092251 | 24092251 |
26198 | 26198 | 1912-05-25 | 8 | b-c | Uniting conference of Guangdong people and military | Uniting conference of people and military in Guangdong is calling to dissolve redundant troops for relaxing burdens on people. | China | http://trove.nla.gov.au/newspaper/page/24092254 | 24092254 |
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]);