This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22131 | 22131 | 1909-12-18 | 3 | b | Parliament of the United States of America sits. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22132 | 22132 | 1909-12-18 | 3 | b | Persia starts financial reform. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22133 | 22133 | 1909-12-18 | 3 | b | American adventurer starts his exploration to the North Pole. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22134 | 22134 | 1909-12-18 | 3 | b | German arsenal makes profits. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22135 | 22135 | 1909-12-18 | 3 | b | A silk factory in Britain is burned to ashes. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22136 | 22136 | 1909-12-18 | 3 | b | British man invents big and speedy warship. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22137 | 22137 | 1909-12-18 | 3 | b | Tornado in Lake Eric claims 59 lives. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22138 | 22138 | 1909-12-18 | 3 | b | King of Belgium is seriously ill. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22143 | 22143 | 1909-12-18 | 6 | b | New governor general Yuan Shuxun orders to ban Chinese labourers going to Peru. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802436 | 26802436 | |
22146 | 22146 | 1909-12-18 | 7 | b | Chinese businessman Tan Cheng (Mingzhong) dies in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802435 | 26802435 | |
22147 | 22147 | 1909-12-18 | 7 | b | Zheng Jing, of Glen Innes, murders his Chinese fellow Peng Xue and is now under arrest. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802435 | 26802435 |
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]);