This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30110 | 30110 | 1915-05-29 | 8 | a-b | Reports from other countries warn against treaty between China and Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
30111 | 30111 | 1915-05-29 | 8 | b | News of Panama International Sports Contest. | America | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
30112 | 30112 | 1915-05-29 | 8 | b | American Airship Company is to send Chen Xuda to China to open a pilot training school. | America | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
30113 | 30113 | 1915-05-29 | 8 | b-c | American President says that America has not decided its attitude to treaty between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
30114 | 30114 | 1915-05-29 | 8 | c | American government secretly negotiates with Japan, disappointing American people. | China | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
30115 | 30115 | 1915-05-29 | 8 | c-d | Liang Qicao goes to southern China to investigate politics. Sun Yatsen asks Japan to use force to compel China to give in. History Bureau is editing a collection of Chinese heroes. Zhang Zhouling in Northeast China prevents people from expelling Japanese goods. Views on industry in East Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
30116 | 30116 | 1915-05-29 | 8 | d | Guangdong news/Long Jiguang advises generals in Guangdong to follow government's orders. Foreign Ministry cables to Guangdong to keep secret of treaty between Japan and China. Yian Mengfan refuses to take office in Financial Department in Guangdong on gambling issue. Local goods are selling well in Guangdong after expelling Japanese goods. | China | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 |
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]);