This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30671 | 30671 | 1915-11-06 | 6 | a | Notice of China's Business and Trade Association in Sydney on donations to Guangdong floods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095047 | 24095047 | |
30672 | 30672 | 1915-11-06 | 6 | a-b | Notice of Chinese consul general in New Zealand on Chinese people filling investigation forms required by New Zealand government. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095047 | 24095047 | |
30673 | 30673 | 1915-11-06 | 6 | b | Beijing news/Chinese Generals' Association cables to support Yuan Shikai to be an emperor. Tianjin businessmen organise a Defending Territory and National Rights Association, protesting France invading non-leased land in Tianjin. An Ally Rescing Party is found in Shanghai, attempting to make riots in China. Dr. Gu De Lu, Yuan Shikai's American counsellor, returns to America due to his dissatisfaction to the Preparation Association. | China | http://trove.nla.gov.au/newspaper/page/24095047 | 24095047 |
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]);