This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31141 | 31141 | 1916-04-15 | 6 | a-b | Correspondence from Yunnan. | China | http://trove.nla.gov.au/newspaper/page/24095232 | 24095232 | |
31143 | 31143 | 1916-04-15 | 7 | a-b | Australia news/ Greek restaurateur is murdered in Sydney. A famed journalist dies in Melbourne. Chinese gambling in Sydney. A Chinese boy, 10, arrives Sydney as illegal immigrant. | Australia | http://trove.nla.gov.au/newspaper/page/24095231 | 24095231 | |
31148 | 31148 | 1916-04-15 | 8 | a-b | Beijing news/ Bank of China and the Bank of Communications are in chaos. Yuan Shikai is awaiting another mediation. Duan Zhigui is also suspected. Salt price goes up. More people are executed in Beijing. Ruan Zhongshu is on his way to Xuzhou once again. Yuan Shikai sends more money to Britain. Government officials in Wuhan are leaving with their families. | China | http://trove.nla.gov.au/newspaper/page/24095234 | 24095234 |
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]);