This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50714 | 50714 | 1931-09-19 | 3 | a | A branch of the Comintern is crushed in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 | |
50715 | 50715 | 1931-09-19 | 3 | a | Jiang Jieshi transfers his money to New York. | America | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 | |
50716 | 50716 | 1931-09-19 | 3 | a | Song Ziwen spends a lot for his mother's funeral. | China | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 | |
50717 | 50717 | 1931-09-19 | 3 | b | Jiang Jieshi and Zhang Xueliang discuss solutions to the current crisis. Atrocities of Japanese in Qingdao. More than 40 counties are flooded in Henan province. Missiles manufactured in the munitions factory in Liaoning. Ambition of the Soviet Union for communist propaganda in China. The Grand Canal in Jiangsu province and the floods. | China | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 |
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]);