This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30288 | 30288 | 1915-07-17 | 7 | a | Special cables from Guangdong describe the huge floods in various places in Guangdong and call for donations. | China | http://trove.nla.gov.au/newspaper/page/24094916 | 24094916 | |
30289 | 30289 | 1915-07-17 | 7 | b | Notice of China's Business and Trade Association in Sydney calling for donations to Guangdong floods. | Other... | http://trove.nla.gov.au/newspaper/page/24094916 | 24094916 | |
30290 | 30290 | 1915-07-17 | 7 | b | Letter of consul general in Australia to China's Business and Trade Association on issue of public loans. | Australia | http://trove.nla.gov.au/newspaper/page/24094916 | 24094916 | |
30291 | 30291 | 1915-07-17 | 7 | b-c | Australia news/Hong Kong Tung Wah Hospital calls for donations for Guangdong floods. Regulations of recruiting soldiers in New South Wales. Agriculture Exhibition is to be held for collecting money in Australia Day for wounded soldiers. Ya Rui, a Chinese in Sydney, is released after being charged as illegal immigrant. | Australia | http://trove.nla.gov.au/newspaper/page/24094916 | 24094916 |
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]);