This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32097 | 32097 | 1917-02-17 | 6 | b-c | Guangdong news/ A memorial pagoda to be built in Haizhu. Zhang Mingqi is awarded medal for the Guangdong independence. Lu Rongting on the cleanups of bandits in local villages. Long Jiguang's troops are in desperate need of food. Joint Local Security Committee established in the Si Yi (See Yup) counties (Xinhui, Xinning, Kaiping and Enping). Governor Zhu Qinglan is seeking to permit gambling for more tax income. Xinhui county magistrate Zhuang Yi is charged for harassment. | China | http://trove.nla.gov.au/newspaper/page/24095605 | 24095605 | |
32099 | 32099 | 1917-02-17 | 7 | b-c | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095604 | 24095604 |
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]);