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 |
---|---|---|---|---|---|---|---|---|---|
30434 | 30434 | 1915-09-04 | 7 | a-b | Australia news/Notice of Australian general procurator on investigating animals raised by people for the Europe War purpose. Statistics of soldier to be enrolled in various states in Australia. An Australian made destroyer enters the sea to serve the navy in Sydney. A woman from Newcastle is found suffering small pots. People in Freemantle in South Australia celebrate Ally's victory in Li Jia (ppp) strait and destroy German people's properties. | Australia | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
30442 | 30442 | 1915-09-04 | 8 | a | Chinese council general in Australia notifies that all Chinese in Australia should fill up investigating forms issued by Australian general procurator for the Europe War purpose. | Australia | http://trove.nla.gov.au/newspaper/page/24094977 | 24094977 | |
30443 | 30443 | 1915-09-04 | 8 | a-b | Notice of Chinese council general in Australia on awards issued by Chinese Finance Ministry to Chinese people in Australia donating to Chinese government. | Australia | http://trove.nla.gov.au/newspaper/page/24094977 | 24094977 | |
30444 | 30444 | 1915-09-04 | 8 | b-d | Notice of donations for Guangdong floods in Gu Dan (ppp), Lu Ya Da Dun (ppp) and Ha Bu Li Ba Ken (ppp) in Australia, with names of donators listed. | Australia | http://trove.nla.gov.au/newspaper/page/24094977 | 24094977 |
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]);