This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30455 | 30455 | 1915-09-11 | 3 | d | Battle situation between Italian and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094978 | 24094978 | |
30456 | 30456 | 1915-09-11 | 3 | d | Battle situation in west Europe between French and German troops. | France | http://trove.nla.gov.au/newspaper/page/24094978 | 24094978 | |
30457 | 30457 | 1915-09-11 | 3 | d | Beijing news/ Zhang Hu is famous for gambling and once lost 300,000 yuan at one stroke. Central government allocate funds for Guangdong to wipe off bandits. Japanese police in Da Lian, Northeast China, ill-treat Chinese people and many Chinese are killed by them. | China | http://trove.nla.gov.au/newspaper/page/24094978 | 24094978 |
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]);