This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30031 | 30031 | 1915-05-08 | 8 | a | Chinese miserable experience in Mid-America. | America | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30032 | 30032 | 1915-05-08 | 8 | a | Record of Panama Canal Sports Contest. | America | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30033 | 30033 | 1915-05-08 | 8 | a | Chinese team in Panama Sports Contest sends a vase to American team. | Other... | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30034 | 30034 | 1915-05-08 | 8 | a-b | A Chinese Hell exhibition in Panama Sports Contest was banned as a result of Chinese protests. | Other... | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30035 | 30035 | 1915-05-08 | 8 | b-c | Brief biography of Sun Yatsen by the Chinese government (end). | China | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30036 | 30036 | 1915-05-08 | 8 | c | Chinese Revolution Preserving Association declares ten crimes of Chen Junming. | China | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30037 | 30037 | 1915-05-08 | 8 | c | Yunnan police executed 5 riot party members. | China | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30038 | 30038 | 1915-05-08 | 8 | c | Wang Jinfa, a riot party leader, is pardoned by the amnesty. | China | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30039 | 30039 | 1915-05-08 | 8 | c-d | Miss Song, a follower of Sun Yatsen, is trying to get pardoned by the amnesty regulations in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30040 | 30040 | 1915-05-08 | 8 | d | Guangdong news/ Police department in Guangdong asks all local areas unite to defend themselves. Detectives in Huiyang, Guangdong find internal information of the riot party. Guangdong government is to severely punish those involved in gambling and opium deals. A femal gambler in Guangdong sells her daughter for more gambling funds. Su Yusheng, a previous military official, is not allowed to be freed for his bribery crime. Some riot party members in Zhenchen, Guangdong, are arrested. | China | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 |
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]);