This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30238 | 30238 | 1915-07-03 | 7 | a-b | Australia news/ Australian Defense Minister expresses his concerns on current war situation and praises support of Australian people and soldiers in the war. Statistics of Australian soldiers killed and wounded in the war. A Japanese training warship comes to Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
30244 | 30244 | 1915-07-03 | 8 | a-b | Notice of consul general in Australia/ Name list of Chinese in Australia awarded by Chinese government for their donations to China. | Australia | http://trove.nla.gov.au/newspaper/page/24094903 | 24094903 |
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]);