This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17209 | 17209 | 1907-04-06 | 3 | b-c | Wife of Prince of Britain agrees to contribute to the Australian Women's Exhibition that will be held in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/26801282 | 26801282 | |
17220 | 17220 | 1907-04-06 | 6 | b-c | Philanthropism. American Red Cross donates to famine victims of north Jiangsu and Anhui provinces. Red Cross in San Francisco donate to famine victims of north Jiangsu province. And comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801289 | 26801289 | |
17237 | 17237 | 1907-04-06 | 8 | b-c | Survey. A detailed survey of business in Shanghai in 1906. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801287 | 26801287 |
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]);