This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52815 | 52815 | 1933-04-29 | 6 | a | Aggression of Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52816 | 52816 | 1933-04-29 | 6 | b | Japan and Russia may break off due to the disputes over the railway management. | China | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52817 | 52817 | 1933-04-29 | 6 | b | British newspapers on the Japanese invasion of China. | Britain | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52818 | 52818 | 1933-04-29 | 6 | c | Crisis in Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52819 | 52819 | 1933-04-29 | 6 | c | Epidemic in India. | Other... | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52820 | 52820 | 1933-04-29 | 6 | d | Japanese to rebuild the military port in Lushun, of Liaoning province. | Japan | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52821 | 52821 | 1933-04-29 | 6 | d | Zhang Xueliang to tour Italy. | Other... | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52822 | 52822 | 1933-04-29 | 6 | d | Japanese seek to organise another puppet government in north China. | China | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52823 | 52823 | 1933-04-29 | 6 | e | Australia news/ Memorial services on the ANZAC day. Bank security shoots dead robber. Fire in Brisbane. Restrictions on the import of Fijian bananas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 |
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]);