This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29529 | 29529 | 1915-01-02 | 7 | a-c | Australia news/ Sydney China's School have made a great progress these years. Statistics of qualified soldiers in various states in Australia. Statistics show that Sydney business is declining due to the affects of European War. House of Yuan Mei, a Chinese in Sydney is stolen. Bat Hurst is flooding due to heavy rain there. | Australia | http://trove.nla.gov.au/newspaper/page/24094675 | 24094675 | |
29530 | 29530 | 1915-01-02 | 7 | c | European War/ British navy attacks German coast. British airships are attacked by German planes but pilots are rescued by British navy. | Britain | http://trove.nla.gov.au/newspaper/page/24094675 | 24094675 |
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]);