This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29676 | 29676 | 1915-02-06 | 7 | a-b | Australia news/Germany government does not send Australian people to the camp. Colour-skinned children are not allowed to go to school in Bei Na Da (ppp). Huang Yinzhao killed Liu Bao in Da Bu (ppp), New South Wales. Huang Ji, an old Chinese in Townsville, is dying in hospital from a violent robbery. Thieves steal money from houses of Tian Chen, Li Yuhua, and Huang Zi in New South Wales. Cornell in south Australia is suffering bad draught. Australian government treats Kenya people, | Australia | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 | |
29677 | 29677 | 1915-02-06 | 7 | b | Germany and Austria are reducing amount of food to their people. | Other... | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 | |
29678 | 29678 | 1915-02-06 | 7 | b | Turkish troops invades southern Parse. | Russia | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 | |
29679 | 29679 | 1915-02-06 | 7 | c | People in Portland suffer a shortage of food. | Russia | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 | |
29680 | 29680 | 1915-02-06 | 7 | c | Russian troops won repeated battles in East Europe. | Russia | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 |
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]);