This data as json, CSV (advanced)
Suggested facets: date (date)
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 |
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]);