This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50094 | 50094 | 1931-03-14 | 8 | b | Hu Hanmin under house arrest in Tangshan, of Nanjing. Shanxi troops fight Jiang Jieshi again. Overseas Chinese question the Nanjing government for Hu Hanmin's issues. | China | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 | |
50095 | 50095 | 1931-03-14 | 8 | b | British exploration team on their way to Xinjiang, northwest of China. Navigation association in Britain oppose to the exorbitant taxes in the Suez Canal. | Britain | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 | |
50096 | 50096 | 1931-03-14 | 8 | c | Storm in New York and the damages. | America | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 | |
50097 | 50097 | 1931-03-14 | 8 | c | Storm and snow in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 | |
50098 | 50098 | 1931-03-14 | 8 | c | Soviet Union will be major competitor of the world market. | Britain | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 | |
50099 | 50099 | 1931-03-14 | 8 | c | Exercise of the Japanese air force and the injury. | Japan | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 | |
50100 | 50100 | 1931-03-14 | 8 | c | Students in Beijing destroy office of a government newspaper. | China | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 | |
50101 | 50101 | 1931-03-14 | 8 | c | Australia news/ Chinese woman crushed to death by a car in Sydney. Police in Sydney arrest gamblers. Explanation by the Chinese foreign ministry on the resignation of Hu Hanmin. Police union in Sydney and their lawsuit with a Chinese man. Bank in Sydney nearly robbed. Chinese fruit shop robbed in Sydney. Tram company in Sydney fire employees. Chinese man in Sydney is charged with human traffic for illegal immigration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 | |
50102 | 50102 | 1931-03-14 | 8 | e | A meeting notice by the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090314 | 24090314 |
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]);