This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50082 | 50082 | 1931-03-14 | 2 | b | Report written by Wan Boping on the steps of Soviet Union to implement communist policy in the railway management in Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090308 | 24090308 | |
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 | |
50092 | 50092 | 1931-03-14 | 5 | e | A notice by the Dongguan gong yi tang in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090309 | 24090309 | |
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]);