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 |
---|---|---|---|---|---|---|---|---|---|
43055 | 43055 | 1925-04-25 | 3 | b | Zhao Hengti prepares to entertain Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24101109 | 24101109 | |
43061 | 43061 | 1925-04-25 | 5 | b | King of Britain tours the Mediterranean Sea. | Britain | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
43062 | 43062 | 1925-04-25 | 5 | b | Communists in Bulgaria try to assassinate their king. | Britain | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
43063 | 43063 | 1925-04-25 | 5 | b | Australian Oriental Navigation Company has built another big liner. | Australia | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
43064 | 43064 | 1925-04-25 | 5 | b | A boy tries to assassinate Russian ambassador in France. | Britain | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
43080 | 43080 | 1925-04-25 | 7 | b | Bandits in Guangdong. Hotel accommodation in Hong Kong is not safe. Feng Yuxiang's troops in Beijing. Long Jiguang dies in Beijing. Duan Zhigui dies in Tianjin. State funeral prepared for Sun Yatsen. Zhongshan Park in Beijing where Sun Yatsen's coffin lies. | China | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 |
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]);