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 |
---|---|---|---|---|---|---|---|---|---|
29606 | 29606 | 1915-01-23 | 3 | b | French Public Press reports that enemy troops attack French troops. | France | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29607 | 29607 | 1915-01-23 | 3 | b | Turkey refuse defeats by Russian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29608 | 29608 | 1915-01-23 | 3 | b | Wars cost a lot for all countries involved and Belgium suffers a great loss. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29609 | 29609 | 1915-01-23 | 3 | b | Turkish troops enter Parse. | Britain | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29610 | 29610 | 1915-01-23 | 3 | b | Italian people expect to be neutral in the war. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29611 | 29611 | 1915-01-23 | 3 | b | Statistics show that German troops suffer a great loss in the war. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29612 | 29612 | 1915-01-23 | 3 | b | Submarines attack British seaports again. | Britain | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29613 | 29613 | 1915-01-23 | 3 | b | German troops report that they have won many battles. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29623 | 29623 | 1915-01-23 | 7 | b | Mexico government decides to take back the Britain's right of managing petrol and coal in its country. | America | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
29629 | 29629 | 1915-01-23 | 8 | b | China Associations in America are against Chinese government's plan of making loans from American capitalists. | America | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 | |
29630 | 29630 | 1915-01-23 | 8 | b | Overseas Chinese in Mexico are leading miserable life after the Mexico revolution. | Other... | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 |
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]);