This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33877 | 33877 | 1918-12-07 | 8 | a-b | Names listed for donations to bridge building in Liangdu, of Xiangshan county, collected by Liu Junchen (A. John Sing, 46 Smith Street, Sydney). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097532 | 24097532 | |
33878 | 33878 | 1918-12-07 | 8 | b | Beijing news/ The new president and his network. Some people in Beijing are keen to fight the south. Tang Jiyao in Sichuan. Duan Qirui will not interfere with the peace talks. | China | http://trove.nla.gov.au/newspaper/page/24097532 | 24097532 | |
33879 | 33879 | 1918-12-07 | 8 | c-d | Guangdong news/ New provincial governor to re-structure local security corps. Efforts to arrest bandits in Guangzhou. Kidnap in Boluo county. Mo Rongxin writes to the magistrate of Xiangshan county. Robbery on Dongguan county. Spy Deng Fanglin is arrested. | China | http://trove.nla.gov.au/newspaper/page/24097532 | 24097532 |
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]);