This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49449 | 49449 | 1930-08-30 | 2 | b | Second part of comments on the red (communist) disasters, selected from a Tianjin newspaper. | China | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49450 | 49450 | 1930-08-30 | 2 | c | Chinese antiquities on exhibition in the New York museum. | America | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49451 | 49451 | 1930-08-30 | 2 | c | More fighting between the Chinese societies in the east of America. | America | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49452 | 49452 | 1930-08-30 | 2 | d | Economic panic in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49453 | 49453 | 1930-08-30 | 2 | d | Wang Chonghui on women's rights of inheritance. | China | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49454 | 49454 | 1930-08-30 | 2 | f | Students of the Beijing University are against Yan Mengyu. | China | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49455 | 49455 | 1930-08-30 | 2 | f | The communist disasters in Changsha, Hunan. | China | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49456 | 49456 | 1930-08-30 | 2 | f | Wang Jingwei proposes to resume diplomatic relations with Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 |
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]);