This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35858 | 35858 | 1920-06-26 | 8 | a | The Twenty-first part of the disgraceful history of China, written by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098219 | 24098219 | |
35859 | 35859 | 1920-06-26 | 8 | b-c | Guangdong news/ Military personnel are not allowed to interfere with civil politics. Efforts to promote China products in Guangzhou. River Projects Office prepares for the summer floods. Li Yaohan's land properties are confiscated by the Gaoyao county authority. Bandits in Dongguan county. | http://trove.nla.gov.au/newspaper/page/24098219 | 24098219 |
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]);