This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37725 | 37725 | 1921-10-15 | 8 | a | Fiction/ A sad woman, part V. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093725 | 24093725 | |
37726 | 37726 | 1921-10-15 | 8 | b-c | Guangdong news/ Plan for cultivation on Xisha islands. Portuguese occupy Chinese territory. Banditry in Zhaoqing. Some county magistrates take the last minutes to make money. Army soldiers in Gaoyao county arrest gamblers. Opium destroyed in Guangzhou. Penalty applies to legislature members in Panyu county who are smoking opium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093725 | 24093725 | |
37727 | 37727 | 1921-10-15 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093725 | 24093725 |
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]);