This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33565 | 33565 | 1918-08-31 | 2 | c-d | Competition for the presidency in north China. | China | http://trove.nla.gov.au/newspaper/page/24097412 | 24097412 | |
33571 | 33571 | 1918-08-31 | 3 | c-d | Manufacturing of matches in China and its international status. | China | http://trove.nla.gov.au/newspaper/page/24097411 | 24097411 | |
33583 | 33583 | 1918-08-31 | 7 | c-d | American priest Richard (Chinese name Li jia bai) visits Sydney after living in China for 36 years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097415 | 24097415 | |
33589 | 33589 | 1918-08-31 | 8 | c-d | Guangdong news/ Lu Rongting recommends Qin Chunxuan chief commander of the Southwest military government. Qin Chunxuan issues a circular telegram as the chief commander. Naval commander Tang Tingguang resigns. Provincial legislature to be opened again. Spy from the north is arrested in Guangzhou. Bandits in Kaiping county. Police in Enping county commit robbery. | China | http://trove.nla.gov.au/newspaper/page/24097418 | 24097418 |
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]);