This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30614 | 30614 | 1915-10-23 | 7 | a | Australia news/ Statistics show Australian population is increasing. Australia premier Fi Sa (nnn) and Finance Minister Pi Shi (nnn) charges Shi Shi Pian Li Ya (nnn) for slanting them. Some people in Sydney advocate to donate for refugees in the Ally's countries. Statistics of Australian soldiers killed and wounded in the Europe War. | Australia | http://trove.nla.gov.au/newspaper/page/24095030 | 24095030 | |
30620 | 30620 | 1915-10-23 | 8 | a | Notice of Chinese consul general in Australia on awards by Chinese Finance Ministry to Chinese in Australia donating to Chinese government. | Australia | http://trove.nla.gov.au/newspaper/page/24095033 | 24095033 |
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]);