This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45373 | 45373 | 1926-12-18 | 7 | a-b | Australia news/ Notice for Christmas holiday. Heat waves in Sydney and the casualties. Mother and son die one after another in Sydney. Sydney customs check luggage carefully. New post office to be set up in Hay Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101819 | 24101819 | |
45374 | 45374 | 1926-12-18 | 7 | b | Bandits in Xiangshan, Guangdong, and the robbery. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101819 | 24101819 | |
45375 | 45375 | 1926-12-18 | 7 | c | Wu Peifu and his wife. | China | http://trove.nla.gov.au/newspaper/page/24101819 | 24101819 | |
45376 | 45376 | 1926-12-18 | 7 | d | Military commanders under Sun Chuanfang. | China | http://trove.nla.gov.au/newspaper/page/24101819 | 24101819 |
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]);