This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33789 | 33789 | 1918-11-02 | 8 | a | Beijing news/ A politician in Beijing comments on Li Genyuan. A women's association organised in Beijing and the report. | China | http://trove.nla.gov.au/newspaper/page/24097492 | 24097492 | |
33790 | 33790 | 1918-11-02 | 8 | c-d | Guangdong news/ Provincial governor advises local counties to commemorate the birthday of Confucius. Governor Li Yaohan on the value of the bank notes. Mo Rongxin seeks help to suppress all bandits in Gudou Mountain. Former magistrate of Xiangshan county is urged to repay his debt. Two ferries are hijacked in Zhaoqing. Dongguan county magistrate reports his tour to the flooding area. Troops under investigation for harbouring gambling. | China | http://trove.nla.gov.au/newspaper/page/24097492 | 24097492 | |
33791 | 33791 | 1918-11-02 | 8 | c | A notice by the Dongguan Gong Yi Tang in Brisbane to transfer remains of their deceased fellows back to China, and the contact details. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097492 | 24097492 |
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]);