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 |
---|---|---|---|---|---|---|---|---|---|
50087 | 50087 | 1931-03-14 | 3 | c | He Long leads his communist troops to attack the border of Sichuan, Hunan and Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24090307 | 24090307 | |
50091 | 50091 | 1931-03-14 | 5 | c | A woman in Guangxi province applies for divorce because her husband is overweighted. Strange mountain cave found in Taishan county, Guangdong. Virginity tested on one of the Ryukyu islands. Visit to a temple in Qujiang county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090309 | 24090309 | |
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 |
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]);