This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 29585 | 29585 | 1915-01-16 | 7 | a-b | Australia news/ Australia government allows newspapers enter Australia from China due to Chinese counseller's negotiation with Australian government. French troops won a victory over Russian troops. Australian envoy is to go to Egypt through Britain. Ships of enemy nations are confiscated by Australian government. Long Yi, a Chinese in Sydney fell down from a horse and is wounded. An European woman in Sydney gives birth to three babies. An European boy in Sydney swallowed a coin and died. | Australia | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 29586 | 29586 | 1915-01-16 | 7 | b | Some enemy airships and planes are forced to return from marching to London by bad weather. | Britain | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 29587 | 29587 | 1915-01-16 | 7 | b | More policemen are in service when news of more enemy planes are to fly across British strait. | Britain | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 29588 | 29588 | 1915-01-16 | 7 | b | Austria is said to be willing for peace negotiation by its own. | France | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 29589 | 29589 | 1915-01-16 | 7 | b | Austrian troops are defeated by Russian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 29590 | 29590 | 1915-01-16 | 7 | b | Russian troops win a number of battles in Portland. | Russia | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 29591 | 29591 | 1915-01-16 | 7 | b | German troops decide to He Su (ppp), a Russian city. | Britain | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 29592 | 29592 | 1915-01-16 | 7 | b-c | Paris military press anounces victory of the Ally army. | France | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 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]);