This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47030 | 47030 | 1928-05-12 | 7 | a | Clash between Chinese and Japanese troops in Jinan, Shandong province, and other relevant reports. | Japan | http://trove.nla.gov.au/newspaper/page/24098805 | 24098805 | |
47031 | 47031 | 1928-05-12 | 7 | b | Japanese cabinet to dispatch more troops to Shandong. Another boycott to Japanese goods in Guangdong. More report on the battle between Chinese and Japanese troops along the Jiaozho-Jinan railway. | China | http://trove.nla.gov.au/newspaper/page/24098805 | 24098805 | |
47032 | 47032 | 1928-05-12 | 7 | c | Australia news/ Chairman of the New South Wales Gardening Association requests to limit working hours for the Chinese gardeners. New bank opened in Sydney. Further report on the case of rape in Sydney. Booth collapses during a horse racing in Sydney. A female cashier in Brisbane is found embezzlement. Chinese gardener in New South Wales sues builder for irresponsibility. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098805 | 24098805 |
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]);