This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24953 | 24953 | 1911-09-09 | 3 | a | Adieu's fire | Huge fire occurred in Adieu. | Other... | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24954 | 24954 | 1911-09-09 | 3 | a | Japanese general returns home | Dong Xiang, the Japanese general returns to Japan after visiting Europe and America. | America | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24955 | 24955 | 1911-09-09 | 3 | a | Election of American president | Candidates from different parties are competing for the position of president. | America | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24956 | 24956 | 1911-09-09 | 3 | a | Relationship between Japan and Russia | Relations between Japan and Russia are improving. | Russia | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24957 | 24957 | 1911-09-09 | 3 | a | Cases of military spies | German spy and British spies on military sites are found. | Britain | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24958 | 24958 | 1911-09-09 | 3 | a | Debt of royal family in Britain | Statistics of debt of royal family. | Britain | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24959 | 24959 | 1911-09-09 | 3 | a | Strike in Poland | Huge strike occurred in Poland. | Russia | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24960 | 24960 | 1911-09-09 | 3 | a-b | War may happen in Morocco | Morocco crisis among Germany, Britain and France may result in a war. | Britain | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24961 | 24961 | 1911-09-09 | 3 | b | Finland 's crisis | Russia is to occupy more land of Finland. | Britain | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24962 | 24962 | 1911-09-09 | 3 | c | Beijing news | Study arrangement of the emperor. Prince Qing is to resign. Yuan Shikai determines not to take office. Current situation of troops for autumn exercise. Civil law of Europe and Asia. Navy inspects barrel sites. | China | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24963 | 24963 | 1911-09-09 | 3 | c-d | Guangdong news | Guangdong government asks French ambassador to drive away the revolutionaries. People are notified not to be cheated by the revolutionaries. General Fu is awarded a honourable title. Use of foreign loans. Pei Jingfu is to manage Guangdong railways. Guang-Xia railway is to be built. Several murders occurred in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
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]);