This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32680 | 32680 | 1917-11-17 | 2 | c-d | An article written by anonymous author on the current situations in Guangdong and the solution proposals. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095908 | 24095908 | |
32699 | 32699 | 1917-11-17 | 8 | c-d | Guangdong news/ Naval forces in Guangdong. Mo Qingyu and his talks with the naval commanders. Yang Jindong returns to Guangzhou from Hong Kong. Sun Yatsen and his ambitions. Vietnamese authority refuses to give in to Yunnan army. Stamp duties apply to pawn business and the acts. Drought in Gaoyao county. A military conference in the cement factory, Guangzhou, convened by Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24095914 | 24095914 |
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]);