This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7163 | 7163 | 1901-03-06 | 2 | d | Yuan Shikai's son is a local official in east Henan province. He ordered all Christians to go to church. Nobody is allowed to pray at home. | China | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7164 | 7164 | 1901-03-06 | 2 | d | Qin Yunjie and Lu Chuanlin have disagreements. | China | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7165 | 7165 | 1901-03-06 | 2 | d | The events that occured when Gang Yi celebrated his birthday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7166 | 7166 | 1901-03-06 | 2 | d | Heavy snow falls in south Russia. | Australia | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7167 | 7167 | 1901-03-06 | 2 | d | A mail ship sank into ocean near America and dozens of its passengers died. | America | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7168 | 7168 | 1901-03-06 | 2 | d | The expenditure of the Prince's Australian tour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7169 | 7169 | 1901-03-06 | 2 | d | King Edward VII of England visits his relatives in Germany. | Australia | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7170 | 7170 | 1901-03-06 | 2 | d | A man in Sydney was severely punished for raping an underage girl. | Australia | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7171 | 7171 | 1901-03-06 | 2 | d | All prisoners in a Sydney jail escaped. | Australia | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7192 | 7192 | 1901-03-06 | 3 | d | Storm in the Pacific destroys some cargo ships. | Australia | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7193 | 7193 | 1901-03-06 | 3 | d | A passer-by in Newtown, Sydney, was beaten by thugs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7194 | 7194 | 1901-03-06 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 |
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]);