This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29573 | 29573 | 1915-01-16 | 3 | c | Vienna prepares for being encircling by enemy troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29574 | 29574 | 1915-01-16 | 3 | c | German troops are marching to fight against Serbia troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29575 | 29575 | 1915-01-16 | 3 | c | Russian troops made several victories in Portland. | Russia | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29576 | 29576 | 1915-01-16 | 3 | c | A British warship is sunk by an enemy submarine in British Gulf. | Britain | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29577 | 29577 | 1915-01-16 | 3 | c | Some Indian war criminals are sent to Turkey to join Mausoleum troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29578 | 29578 | 1915-01-16 | 3 | c | Africa Ally troops defeat the rebellious troops in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29579 | 29579 | 1915-01-16 | 3 | c | Romania enrols a lot of troops for war. | Other... | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29580 | 29580 | 1915-01-16 | 3 | c | Turkish troops attack Egypt. | Other... | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29581 | 29581 | 1915-01-16 | 3 | c | Russian troops and Turkish troops are fighting severely and Russian troops captured many Turkish soldiers. | Russia | http://trove.nla.gov.au/newspaper/page/24094687 | 24094687 | |
29593 | 29593 | 1915-01-16 | 7 | c | Literature world: Yang Yuting writes his experience in Austalia. Zhou Raiting writes a poem for his birthday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 |
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]);