This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26037 | 26037 | 1912-04-20 | 3 | a-b | Portuguese republic faces financial crisis | Portuguese republic faces severe financial crisis, monarch seems to be back. | France | http://trove.nla.gov.au/newspaper/page/24092207 | 24092207 |
26043 | 26043 | 1912-04-20 | 6 | a-b | Detail of Beijing coup | Detail of coup in some important parts of Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/24092212 | 24092212 |
26046 | 26046 | 1912-04-20 | 8 | a-b | Australian news | Value of newly-built warship by Britain for Australia. Annual expenses of federal government. Treasurer of New South Wales died. New South Wales richest businesswoman died. Norwegian ship strangely sunk in South Australia dock. Mother and two sons drowned in Brisbane. Scholar dreams post from Britain to Australia could be shortened to less than 14 days. British navy tells Japan intends to invade Australia. Former key writer of The Tung Wah Times returns to China. Melbourne born Chinese boy allowed to stay in Australia. Chinese in Brisbane celebrate establishment of republic China. Japanese keen to learn Australian railway. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26050 | 26050 | 1912-04-20 | 8 | a-b | South and North governments forced to unite | South Nanjing and North Beijing governments forced to unite due to worsening economy. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
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]);