This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51623 | 51623 | 1932-06-18 | 8 | a | Famine in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51624 | 51624 | 1932-06-18 | 8 | a | Resistance in Manchuria to the Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51625 | 51625 | 1932-06-18 | 8 | a | Japanese control of the Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51626 | 51626 | 1932-06-18 | 8 | b | The Nanjing government to resume diplomatic relations with Russia. | China | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51627 | 51627 | 1932-06-18 | 8 | b | Protest in Britain against the income tax. | Britain | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51628 | 51628 | 1932-06-18 | 8 | b | News from India. | Other... | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51629 | 51629 | 1932-06-18 | 8 | c | Questions in the British House of Commons. | Britain | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51630 | 51630 | 1932-06-18 | 8 | c | Australia news/ Banks to cut the interest rate. Bank robbery in Queensland. Another suicide in the Sydney Harbour Bridge. The 32nd meeting of the Chinese Progressive Association in Sydney. Old Chinese man dies in Melbourne with huge assets. Huang Huazhi dies in NSW. Disputes over the NSW state politics. Tobacco import in Sydney. Election result in New South Wales. Clash between civilians and police in Newcastle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 |
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]);