This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46826 | 46826 | 1928-03-10 | 7 | a | Yellow River is flooding in Shandong province. A Japanese cargo is stranded in the Taiwan Strait. The Communist Party members in Hunan province set fire to temples. Many people of Lufeng and Haifeng county are fleeing the Communist disasters. | China | http://trove.nla.gov.au/newspaper/page/24098723 | 24098723 | |
46827 | 46827 | 1928-03-10 | 7 | a | Britain, France, Germany, Italy and Japan to have a conference for world peace. | Other... | http://trove.nla.gov.au/newspaper/page/24098723 | 24098723 | |
46828 | 46828 | 1928-03-10 | 7 | a | Beijing government appoints Pan Fu, Gu Weijun and others to the international tariff conference. | China | http://trove.nla.gov.au/newspaper/page/24098723 | 24098723 | |
46829 | 46829 | 1928-03-10 | 7 | b | Australia news/ A priest in Melbourne is charged with murdering his wife. Young woman is raped in Darlinghurst, Sydney. A woman is detained in Sydney for shoplift. Wool production in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098723 | 24098723 | |
46830 | 46830 | 1928-03-10 | 7 | d | A notice by the gong yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098723 | 24098723 |
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]);