This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20531 | 20531 | 1909-01-16 | 6 | a-b | British authority in Hong Kong deports Wu Xianzi, editor of Commercial Daily (shang bao), for advocating the boycott of Japanese goods. His letter to Chinese community in Hong Kong before leaving. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 | |
20532 | 20532 | 1909-01-16 | 6 | b | Yuan Shikai returns home after being removed from his position. | Britain | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 | |
20533 | 20533 | 1909-01-16 | 6 | b | Britain, Japan and America respond to the removal of Yuan Shikai. | Britain | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 | |
20534 | 20534 | 1909-01-16 | 6 | c | Liang Dunyan is promoted to minister of foreign affairs. | Britain | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 | |
20535 | 20535 | 1909-01-16 | 6 | c | British and Russian naval sailors in Italy help rescue victims after the earthquake. Meanwhile, some robberies occurred after the earthquake. Donations to the Italian earthquake victims from American Red Cross and other sources. | Britain | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 | |
20536 | 20536 | 1909-01-16 | 6 | c | Train bombed in Calcutta, India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 |
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]);