This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29971 | 29971 | 1915-04-24 | 8 | a | Description of Panama International Exhibition. | Other... | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 | |
29972 | 29972 | 1915-04-24 | 8 | a | Chinese businessmen suffer greatly from the Canadian Bank's bankruptcy. | Canada | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 | |
29973 | 29973 | 1915-04-24 | 8 | a-b | Brief biography of Sun Yatsen by the central government ( to be continued). | China | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 | |
29974 | 29974 | 1915-04-24 | 8 | b | Brief biography of Huang Xing by the central government (to be continued). | China | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 | |
29975 | 29975 | 1915-04-24 | 8 | c | Two women revolutionaries are arrested in Fujian. | China | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 | |
29976 | 29976 | 1915-04-24 | 8 | c-d | Details of Gu Zhongyu ( head of a riot party)'s arrest by secret detectives. | China | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 | |
29977 | 29977 | 1915-04-24 | 8 | d | Guangdong news/Engineers are inspecting Sheshangwei's water conservancy works in Guangdong. Russian officials passing through Guangdong are protected by the government. Yuan troop defeats bandits troop in Xiangshan, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 |
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]);