This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34621 | 34621 | 1919-06-28 | 3 | a-b | Protest in China against the diplomatic failure (Cao Rulin to be impeached, Zhang Zongxiang besieged, boycott to Japanese goods in Shanghai, and others). | China | http://trove.nla.gov.au/newspaper/page/24097767 | 24097767 | |
34622 | 34622 | 1919-06-28 | 3 | c-e | Students' demonstration in Beijing on May Fourth and the detailed report. | China | http://trove.nla.gov.au/newspaper/page/24097767 | 24097767 | |
34623 | 34623 | 1919-06-28 | 3 | e-f | Miscellaneous report/ Japanese ambassador to America leaves Washington and returns home. Chinese ambassador to Japan resigns. Chinese President Xu Shichang and the cabinet resign. Anti-Japanese movement in Shanghai. America to expand naval forces. Japanese warships on the Chinese ports. Germany wants to delay to sign the treaty. Japanese delegate to the Paris Conference rebuffs Germany. German navy destroy warships. | Other... | http://trove.nla.gov.au/newspaper/page/24097767 | 24097767 |
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]);