This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33174 | 33174 | 1918-04-06 | 7 | b-c | Australia news/ How rich is Australia and its expenditure for the War this year. Sale of the Sixth War Loan in Sydney and the harvest. Thoughts on the Christmas Day, birthday of Jesus Christ. Population growth in Sydney and the birth rate. Price for train tickets increase in Sydney during the Christmas holiday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097243 | 24097243 | |
33175 | 33175 | 1918-04-06 | 7 | c | Tsar of Russia and his current situations. | Britain | http://trove.nla.gov.au/newspaper/page/24097243 | 24097243 | |
33176 | 33176 | 1918-04-06 | 7 | c | Magician Cheng Liansu dies in London. | Britain | http://trove.nla.gov.au/newspaper/page/24097243 | 24097243 | |
33177 | 33177 | 1918-04-06 | 7 | c-d | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097243 | 24097243 | |
33178 | 33178 | 1918-04-06 | 7 | d | Advertisement by the Australian federal treasurer for the sixth war loan (1927). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097243 | 24097243 | |
33179 | 33179 | 1918-04-06 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097243 | 24097243 |
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]);