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 |
---|---|---|---|---|---|---|---|---|---|
49890 | 49890 | 1931-01-17 | 2 | c | Cultural enterprises of the Chinese communities in America. | America | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49891 | 49891 | 1931-01-17 | 2 | c | Japanese cabinet has finalised its new policy in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49892 | 49892 | 1931-01-17 | 2 | c | Cuba to set up sugar factory in China. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49893 | 49893 | 1931-01-17 | 2 | c | Xiong Shihui and Yang Yongtai are seriously injured in a plane accident. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49901 | 49901 | 1931-01-17 | 3 | c | Problems in Fujian province that need to be solved. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49902 | 49902 | 1931-01-17 | 3 | c | Famine victims in Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49913 | 49913 | 1931-01-17 | 8 | c | American House of Representatives on the China policy. | America | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
49914 | 49914 | 1931-01-17 | 8 | c | Train derails in Tokyo and falls into river. | Japan | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
49915 | 49915 | 1931-01-17 | 8 | c | Independence effort in India. | Britain | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
49916 | 49916 | 1931-01-17 | 8 | c | Australia news/ A reply from the Chinese Consulate-General in Australia to the Chinese Chamber of Commerce in Sydney on the assets left by deceased Chinese fellows. Widow commits suicide in Sydney due to poverty. Convict suicides in the prison. Police in Adelaide arrest strikers. Sailors on board of a ship from Shanghai to Sydney are found smallpox. New Chinese consul-general to Australia Gui Zhi arrives Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 |
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]);