This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26232 | 26232 | 1912-06-01 | 8 | a-b | Japanese commenting Yuan Shikai | A Japanese National Party member points out that Yuan Shikai is the man who conspired the imperial abdication and he has connections with Sun Yatsen for a long time. | Other... | http://trove.nla.gov.au/newspaper/page/24092262 | 24092262 |
26233 | 26233 | 1912-06-01 | 8 | b | Guangdong governor Chen Junming's notice | Guangdong governor Chen Junming notified people fleeing to Hong Kong and Maucao that Guangdong is safe and they can return home now. | China | http://trove.nla.gov.au/newspaper/page/24092262 | 24092262 |
26234 | 26234 | 1912-06-01 | 8 | b | Ridiculous stories of Guangdong Railway Company's board election | Disagreement on candidates resulted in a fight in Guangdong Railway Company's board election. | China | http://trove.nla.gov.au/newspaper/page/24092262 | 24092262 |
26235 | 26235 | 1912-06-01 | 8 | b | Current news of Zhen Chen town | Bandits robbed villages in Zhen Chen town and people have no way to cope with them. | China | http://trove.nla.gov.au/newspaper/page/24092262 | 24092262 |
26236 | 26236 | 1912-06-01 | 8 | c | Chinese pilot team | A team of five planes in Shanghai is going to Guangzhou for training pilots. | China | http://trove.nla.gov.au/newspaper/page/24092262 | 24092262 |
26237 | 26237 | 1912-06-01 | 8 | c | Sydney Donation Bureau's notice | Thanks for donations for the military funds in China. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092262 | 24092262 |
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]);