This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43034 | 43034 | 1925-04-18 | 7 | a | Australian Oriental Navigation Company to build a new liner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43035 | 43035 | 1925-04-18 | 7 | a | A book shop in Tenterfield, New South Wales, is burned to ashes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43036 | 43036 | 1925-04-18 | 7 | a | Notice on the sale of The Famous Newtown Band Art Union, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43037 | 43037 | 1925-04-18 | 7 | a | Eighteen Chinese are arrested in Sydney for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43038 | 43038 | 1925-04-18 | 7 | a | A 14 years old Sydney girl is caught while stealing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43039 | 43039 | 1925-04-18 | 7 | a | Burglary at the Wing Sang Company, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43040 | 43040 | 1925-04-18 | 7 | a-b | King of Britain sends his condolence to the Prime Minister of New Zealand. | Australia | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43041 | 43041 | 1925-04-18 | 7 | b | Bandits in south Manchuria shoot dead two Japanese soldiers. | China | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43042 | 43042 | 1925-04-18 | 7 | b | Western missionary and his wife are released by bandits in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43043 | 43043 | 1925-04-18 | 7 | b | Different religious groups meet in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43044 | 43044 | 1925-04-18 | 7 | b | China and France are in talks on the repayment of Boxer Indemnity and others. | China | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43045 | 43045 | 1925-04-18 | 7 | b-c | The war in Dongjiang area, Guangdong, and Lin Hu's victory. | China | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43046 | 43046 | 1925-04-18 | 7 | c | Message by Liang Yuyun thanks fellows for their help on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 |
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]);