This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38915 | 38915 | 1922-06-24 | 3 | b-c | More report on the war between Wu Peifu and Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38927 | 38927 | 1922-06-24 | 6 | b-c | First part of the Twenty-one Demands, claims made by the Japanese government to special privileges in China during World War I. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094022 | 24094022 | |
38944 | 38944 | 1922-06-24 | 8 | b-c | Guangdong news/ Representatives from charity and commercial circles in Guangzhou will go to welcome Chen Jiongming in Huizhou. Industrial representatives will go to meet Chen Jiongming in Huizhou. Feud and clan fighting between Xie, Li and Liu in Conghua county. Bandits in Zhaoqing. Why Chen Jiongming is reluctant to return (to Guangzhou). Provincial treasurer Cheng Tiandou seeks to resign. National Bank will return to Guangzhou from Wuzhou. Sun Yatsen's army and the pressgang for north expedition. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094024 | 24094024 |
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]);