This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34836 | 34836 | 1919-08-30 | 2 | d-e | Petition representatives from Shandong province meet Chinese President Xu Shichang in Beijing and the report. | China | http://trove.nla.gov.au/newspaper/page/24097844 | 24097844 | |
34837 | 34837 | 1919-08-30 | 2 | e-f | A protest gathering at the Central Park in Beijing on the Shandong issue. | China | http://trove.nla.gov.au/newspaper/page/24097844 | 24097844 | |
34838 | 34838 | 1919-08-30 | 2 | f | Newspapers in Shanghai report the boycott to Japanese goods in China and the effects. | China | http://trove.nla.gov.au/newspaper/page/24097844 | 24097844 | |
34839 | 34839 | 1919-08-30 | 3 | b | Anti-Japanese movement in China and Japan's new China policy. | China | http://trove.nla.gov.au/newspaper/page/24097843 | 24097843 | |
34853 | 34853 | 1919-08-30 | 8 | b | Guangdong news/ Qin Chunxuan requests for resumption of peace talks between the south and the north. The problems of provincial governor. | China | http://trove.nla.gov.au/newspaper/page/24097850 | 24097850 |
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]);