This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45759 | 45759 | 1927-05-28 | 7 | a-b | Australia news/ Strike in Sydney following the sack of child labour. Australian federal government provides flour to the British troops in China. Prince Edward, Duke of York, leave Perth, Western Australia. New South Wales state government issues new regulations on the railway operation. News on the football match between Chinese and Australian teams. Expenses for the welcome of Prince Edward. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102004 | 24102004 | |
45760 | 45760 | 1927-05-28 | 7 | c-d | Students in Harvard University dies for love. | America | http://trove.nla.gov.au/newspaper/page/24102004 | 24102004 |
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]);