This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
14576 | 14576 | 1905-07-08 | 3 | a | Protest rallies in many cities of China. Yuan Shikai supports the boycott of American goods. President Roosevelt considers relaxing the restriction on Chinese immigrants. Chinese businessmen in Penang support to boycott American goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800726 | 26800726 | |
14577 | 14577 | 1905-07-08 | 3 | a | France seeks an alliance with Britain to resist Germany. | Britain | http://trove.nla.gov.au/newspaper/page/26800726 | 26800726 | |
14578 | 14578 | 1905-07-08 | 3 | a | China and Britain finalise their treaty with Tibet and organise compensation. | China | http://trove.nla.gov.au/newspaper/page/26800726 | 26800726 | |
14579 | 14579 | 1905-07-08 | 3 | a | American Secretary of States died recently. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800726 | 26800726 | |
14580 | 14580 | 1905-07-08 | 3 | a | Report on the chaos in Poland. | Other... | http://trove.nla.gov.au/newspaper/page/26800726 | 26800726 | |
14581 | 14581 | 1905-07-08 | 3 | a | Russian warship rebels against the Tsar. | Other... | http://trove.nla.gov.au/newspaper/page/26800726 | 26800726 |
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]);