This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42060 | 42060 | 1924-09-06 | 8 | a-d | Guangdong news/ Guangzhou government to issue new bank notes with Sun Yatsen's photo on it. Security for the transportation of grains in Guangdong. Civil corps in Guangdong and their self-defence. Sun Yatsen's Russian military advisor is drowned in Guangzhou. Python found in the flood in Gaoyao county. Sun Yatsen dispatches Fujian army to the front. Xu Chongzhi to issue bonds in order to raise more funds. United self-defence in Nanhai, Dongguan, Zengcheng and Boluo counties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100855 | 24100855 | |
42061 | 42061 | 1924-09-06 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100855 | 24100855 | |
42062 | 42062 | 1924-09-06 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100855 | 24100855 |
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]);