This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49910 | 49910 | 1931-01-17 | 8 | b | American President is optimistic for the future of employment. | America | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
49911 | 49911 | 1931-01-17 | 8 | b | People in Shanghai support to ban dog racing. Disasters of bandits in Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
49912 | 49912 | 1931-01-17 | 8 | b | Silver price runs down sharply. | America | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
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 | |
49917 | 49917 | 1931-01-17 | 8 | e | A notice issued by the Chinese Consulate-General in Australia on the management of assets left by deceased Chinese fellows. | 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]);