This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30414 | 30414 | 1915-08-28 | 7 | a | Notice of Chinese counsil general in New Zealand notifies that all Chinese should abide by law of New Zealand and not bring too much money out of New Zealand. | Australia | http://trove.nla.gov.au/newspaper/page/24094966 | 24094966 | |
30415 | 30415 | 1915-08-28 | 7 | a-b | Australia news/Chinese institutions and individuals in Australia are competing to donate for Guangdong floods. A German in New South Wales was fined a hundred pounds for celebrating He Sou (ppp) city being occupied by German troops in Europe War. News from Canada confirms that Yuan Shikai wants to be an emperor and plans to restore imperial system in China. Notice of Australian general procurator on investigating individual's properties in Australia for the Europe War purpose. | Australia | http://trove.nla.gov.au/newspaper/page/24094966 | 24094966 | |
30416 | 30416 | 1915-08-28 | 7 | c | Notice of Guangdong's Gongyitang Association in Sydney on donations for Guangdong floods, with names of donators listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094966 | 24094966 | |
30417 | 30417 | 1915-08-28 | 7 | c | Notice of Gratitude from New Zealand on donations from fellow townsmen for Zhou Yonghe's funeral. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094966 | 24094966 |
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]);