This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29554 | 29554 | 1915-01-09 | 6 | a-b | Overseas Chinese in Da Xi Di (ppp), Australia, write to Chinese Counsellor in Australia for protecting Chinese interest there. Names listed. | Australia | http://trove.nla.gov.au/newspaper/page/24094684 | 24094684 | |
29555 | 29555 | 1915-01-09 | 6 | b | Situation of overseas Chinese in Da Xi Di (ppp) after German warships destroyed the town. | Other... | http://trove.nla.gov.au/newspaper/page/24094684 | 24094684 | |
29556 | 29556 | 1915-01-09 | 6 | b-c | News of bandits parties/ Some bandits party members are coming to Shanghai and Governor Zhen orders to prepare for arresting them. Nanjing government is notified to arrest some bandits party members from Hubei. Chinese navy warships are to stay in Shanghai for defending. | China | http://trove.nla.gov.au/newspaper/page/24094684 | 24094684 |
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]);