This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38595 | 38595 | 1922-04-22 | 2 | b-d | Wang Chonghui talks about the Washington Conference on his return to Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24093944 | 24093944 | |
38627 | 38627 | 1922-04-22 | 8 | b-d | Guangdong news/ Presidential palace on fire. A mad man breaks in military headquarters but is arrested. Presidential office may move to Guilin. American ambassador leaves Guangdong. A ferry in Xiangshan county is hijacked. Trade union association to be organised in Guangdong. A travel to Songlong, Xiangshan county. Division commander Hong Zhaolin resigns. Literary class prepared for servicemen. A duel in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093950 | 24093950 |
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]);