This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30053 | 30053 | 1915-05-15 | 3 | c | German troops are attacking Russian troops in various places. | Other... | http://trove.nla.gov.au/newspaper/page/24094840 | 24094840 | |
30054 | 30054 | 1915-05-15 | 3 | c-d | Battle situation in east Europe between Russian, Austrian and German troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094840 | 24094840 | |
30060 | 30060 | 1915-05-15 | 7 | b | Battle situation in west Europe between British, French and German troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094844 | 24094844 | |
30063 | 30063 | 1915-05-15 | 7 | b | Italy is preparing for war, | Other... | http://trove.nla.gov.au/newspaper/page/24094844 | 24094844 | |
30065 | 30065 | 1915-05-15 | 8 | a-c | Various activities of riot party members in other countries/ Zhang Raoqing's views on his party and situation in China. He Haiming's cable on rescuing China from crisis. Sun Yatsen and Chen Qimei's traitor activities in Japan. Huang Xing's cable expressing his views on China. | Other... | http://trove.nla.gov.au/newspaper/page/24094847 | 24094847 |
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]);