This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 30175 | 30175 | 1915-06-19 | 3 | a | Liu Quiyi demands the president repeatedly on pardoning riot party members in other countries for defending China unitedly. | China | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30176 | 30176 | 1915-06-19 | 3 | a-b | Japanese domestic ministry opposes sending troops to China. | Japan | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30177 | 30177 | 1915-06-19 | 3 | b | Battle situation in west Europe between French and German troops. | France | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30178 | 30178 | 1915-06-19 | 3 | b | Battle situation between Italian and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30179 | 30179 | 1915-06-19 | 3 | b | German submarine sank two of British torpedo ships. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30180 | 30180 | 1915-06-19 | 3 | b | Italian submarine sank one of Austrian destroyers. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30181 | 30181 | 1915-06-19 | 3 | b | Two of German's injured submarines return to German port. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30182 | 30182 | 1915-06-19 | 3 | b | British government loosens age limit of recruiting soldiers. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30183 | 30183 | 1915-06-19 | 3 | b | American state secretary resigns as he opposes the president's policy to Germany. | America | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30184 | 30184 | 1915-06-19 | 3 | b-c | French military reports its achievement in various battles. | France | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30185 | 30185 | 1915-06-19 | 3 | c | Australian troops won battles over Turkish troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30186 | 30186 | 1915-06-19 | 3 | c-d | Russian troops are to retreat from an Austrian city due to strong attack from Austrian troops. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
| 30187 | 30187 | 1915-06-19 | 3 | d | Beijing news/Shanghai politicians propose for depositing money for rescuing China from crisis. Government is to hire an American as a legislative counsellor. Agriculture and Trade Ministry is to designate insurance regulations for public loans. Navy ministry proposes to set up factories to build up domestic ships. Riot party organisations are found in Shanghai. Government advises Chinese people not to reject Japanese goods. | China | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 |
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]);