This data as json, CSV (advanced)
description 1 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28739 | 28739 | 1914-04-18 | 8 | c | Guangdong news/ Governor Li Kaishen and the new coins. Handwoven clothes unsalable in Guangzhou and Foshan. Military budget of Guangdong province. Chamber of commerce suggests to lift the ban on gambling and is ridiculed. Evil gentry Mr Yin in Dongguan county. Bandits in Songlong town, Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24093084 | 24093084 |
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]);