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 |
---|---|---|---|---|---|---|---|---|---|
52055 | 52055 | 1932-10-22 | 2 | f | Redundancy of the 19th Route Army in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090992 | 24090992 | |
52056 | 52056 | 1932-10-22 | 2 | f | Jiang Jieshi seeks comprise with Japanese. | China | http://trove.nla.gov.au/newspaper/page/24090992 | 24090992 | |
52057 | 52057 | 1932-10-22 | 2 | f | The end of warlord Zhang Zongchang. | China | http://trove.nla.gov.au/newspaper/page/24090992 | 24090992 | |
52067 | 52067 | 1932-10-22 | 5 | f | Chinese communities in Melbourne donate to the war of resistance in China to Japanese invasion. A notice issued by the Chinese Fund-raising Committee in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090993 | 24090993 | |
52087 | 52087 | 1932-10-22 | 8 | f | Australia news/ The trade conference of British colonies in Ottawa, Canada, and new tariff rate for China products. The Tianjin Cafe in Campbell Street, Sydney, is robbed. Three Chinese men are charged in Sydney. The Sydney council is to build new fruit market. Japanese consul in Sydney denies the plan to purchase Timor. | Australia | http://trove.nla.gov.au/newspaper/page/24090998 | 24090998 |
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]);