This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53473 | 53473 | 1933-11-04 | 2 | a | China and Japan to have a face-to-face dialogue, editorial by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53474 | 53474 | 1933-11-04 | 2 | b | Wang Jingwei may resign due to his disagreement with Jiang Jieshi and Song Ziwen. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53475 | 53475 | 1933-11-04 | 2 | c | Wu Tiecheng also acts as General Commander of the police force in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53476 | 53476 | 1933-11-04 | 2 | d | Japanese encourage independence movement in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53477 | 53477 | 1933-11-04 | 2 | e | He Chengrui arrives Chongqing, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53478 | 53478 | 1933-11-04 | 2 | e | American cotton arrive Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53479 | 53479 | 1933-11-04 | 2 | e | Hunan people oppose to the rice export to Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53480 | 53480 | 1933-11-04 | 2 | f | List of antiques of the Forbidden City in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53481 | 53481 | 1933-11-04 | 2 | f | The 19th Route Army search communists in north Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 | |
53482 | 53482 | 1933-11-04 | 2 | f | Huang Shaoxiong returns to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091422 | 24091422 |
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]);