This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53650 | 53650 | 1933-12-09 | 6 | a | Train hijacked in north Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091467 | 24091467 | |
53651 | 53651 | 1933-12-09 | 6 | a | Government troops gather on the border of Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24091467 | 24091467 | |
53652 | 53652 | 1933-12-09 | 6 | a | Italian prime minister suggests to sign treaties with France. | Britain | http://trove.nla.gov.au/newspaper/page/24091467 | 24091467 | |
53653 | 53653 | 1933-12-09 | 6 | b | Japanese people request to punish the communists. | Japan | http://trove.nla.gov.au/newspaper/page/24091467 | 24091467 | |
53654 | 53654 | 1933-12-09 | 6 | b | Japanese financial minister resigns. | Japan | http://trove.nla.gov.au/newspaper/page/24091467 | 24091467 | |
53655 | 53655 | 1933-12-09 | 6 | b | Coming war between Fujian troops and the government army. | China | http://trove.nla.gov.au/newspaper/page/24091467 | 24091467 | |
53656 | 53656 | 1933-12-09 | 6 | c | British visitor on the current situations in Soviet Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24091467 | 24091467 | |
53657 | 53657 | 1933-12-09 | 6 | e | Australia news/ Research shows that Chinese first found the continent of Australia in 1755. Federal government dispatches friendship envoys to the East. Storm in Victoria, NSW and South Australia. Tax increased for wheat flour. Citizenship statue of Australian women after marriage with foreigners. Chinese School in Sydney to have a holiday. A notice issued by the Chinese Chamber of Commerce in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091467 | 24091467 |
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]);