This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50713 | 50713 | 1931-09-19 | 2 | c | Japanese in Manchuria. Hankou turns into hell. Deng Yinda is arrested in Shanghai. Japan requests to implement the Twenty-one Demands. British ambassador donates to the relief work in China. Song Ziwen to raise funds overseas. Deng Yinda is on trial. Nanjing government continues to raise funds. Atrocities of Japanese in Qingdao. Japanese seek to occupy Qingdao. Luxurious banquet in Hankou in the disasters relief. Japanese still want to occupy Manchuria. Floods in Sichuan and Hubei. Leather factory in Harbin on fire. Jin Yunpeng becomes a monk. | China | http://trove.nla.gov.au/newspaper/page/24090527 | 24090527 | |
50719 | 50719 | 1931-09-19 | 5 | c | Hunting a girl in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090528 | 24090528 | |
50728 | 50728 | 1931-09-19 | 8 | c | Australia news/ An old man in Sydney dies with grievance because of his savings in the Savings Bank of New South Wales. Profit of lottery in New South Wales. Dozens of people arrested in Sydney for communist propaganda. The Overseas Chinese Famine Relief Committee in Shanghai acknowledges receipt of the donations from the Chinese communities in Australia. Girl is raped in Sydney. Police arrest in a Sydney dancing club. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 |
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]);