This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45550 | 45550 | 1927-03-12 | 8 | a-d | Guangdong news/ Petitions of the Guangzhou businessmen and Li Jishen. The Huangpu Military Academy and Li Jishen. Li Jishen dispatches troops to take over the Henan area. Old clothes shops in Guangzhou and their business. Strike in Humen area and the solution. Some private schools prefer to stay open. | China | http://trove.nla.gov.au/newspaper/page/24101914 | 24101914 | |
45551 | 45551 | 1927-03-12 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101914 | 24101914 |
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]);