This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48469 | 48469 | 1929-09-14 | 8 | c | Britain refuses to give up their consular jurisdiction in China. | Britain | http://trove.nla.gov.au/newspaper/page/24099363 | 24099363 | |
48470 | 48470 | 1929-09-14 | 8 | c | Internal fighting in the Soviet Russian government. Soviet Russian authority blames German government for failure to protection of their nationals. Russian POWs in China. Russian planes bomb railway stations in China. Russian's plan to attack Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099363 | 24099363 | |
48471 | 48471 | 1929-09-14 | 8 | d | German authority rebuffs Soviet Russia for their blame. | Britain | http://trove.nla.gov.au/newspaper/page/24099363 | 24099363 | |
48472 | 48472 | 1929-09-14 | 8 | e | Jiang Jieshi is injured in an assassination. | China | http://trove.nla.gov.au/newspaper/page/24099363 | 24099363 | |
48473 | 48473 | 1929-09-14 | 8 | e | Australia news/ Chinese Chamber of Commerce in Sydney appeals to Song Faxiang, Chinese Consul-General in Australia, for the ban on rice import. A girl in Newcastle sues her father for rape. A failed bank robbery in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099363 | 24099363 |
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]);