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 |
---|---|---|---|---|---|---|---|---|---|
45814 | 45814 | 1927-06-18 | 3 | c | Military commanders in Henan and Fengtian province condemn Jin Yunpeng. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45815 | 45815 | 1927-06-18 | 3 | c | Borodin's wife arrives Beijing under custody. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45823 | 45823 | 1927-06-18 | 5 | c | Attempt to bomb the communist meeting in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24102028 | 24102028 | |
45824 | 45824 | 1927-06-18 | 5 | c | Demonstration at the front of American consulate in Vancouver. | Canada | http://trove.nla.gov.au/newspaper/page/24102028 | 24102028 | |
45832 | 45832 | 1927-06-18 | 7 | c | A letter from Wu Elou (Xiuguang) in Hong Kong reporting his meeting with Ye Tonggui, Huang Huannan, Xia Congzhou and other Chinese businessmen returned from Australia, and the change in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 |
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]);