This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43084 | 43084 | 1925-04-25 | 8 | a-d | Guangdong news/ Notice issued by the Headquarters in Guangzhou on the funeral ceremony for the late Sun Yatsen. A woman in Xinhui county cuts her arm to cure her sister-in-law. Civil corps in See Yup area resist pressgang by Sun Yatsen's army. High alert in Taishan county. Yunnan army in Dongguan and their looting. Troops in Huizhou. Lin Hu wins battle in the Beijiang area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101116 | 24101116 | |
43085 | 43085 | 1925-04-25 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101116 | 24101116 | |
43086 | 43086 | 1925-04-25 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101116 | 24101116 |
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]);