This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45343 | 45343 | 1926-12-04 | 8 | a-d | Guangdong news/ Security check on all merchants' ships. Foreign governments warns the Guangzhou authority on the new tax. Tax on prostitution in Guangzhou and the opposition. Wei Bangping is wanted. The Communists in Qiongshan county. A delegation of Japanese school principals visits Guangdong. Robbery in Shiqi town. News from Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24101804 | 24101804 | |
45344 | 45344 | 1926-12-04 | 8 | e | Gold price in Hong Kong. Liner Timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101804 | 24101804 | |
45345 | 45345 | 1926-12-04 | 8 | e | Wang Zhongyou is sought by his relatives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101804 | 24101804 |
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]);