This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32232 | 32232 | 1917-04-14 | 6 | c | Guangdong news/ Central government urges military governor Lu Rongting to resume working after a holiday. Provincial legislature supports to remain neutral in the World War I. Troops harass local villages while suppressing bandits. Lu Rongting is on the way to Beijing. Some gambling are permitted in Guangdong. Village cleanups of bandits in See Yup (si yi) counties. Banditry in Kaiping county. French companies are recruiting labours in Guangdong and the response of governor Zhu Qinglan. | China | http://trove.nla.gov.au/newspaper/page/24095661 | 24095661 | |
32235 | 32235 | 1917-04-14 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095660 | 24095660 |
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]);