This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
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 | |
30419 | 30419 | 1915-08-28 | 8 | a-b | Notice of China's Business and Trade Association in Bendigo, Victoria, on donations for Guangdong floods, with names of donators listed. | Australia | http://trove.nla.gov.au/newspaper/page/24094969 | 24094969 |
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]);