This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34641 | 34641 | 1919-07-05 | 3 | b | Chinese parliament has no sub-committee specifically on the Sino-Japan relations. | China | http://trove.nla.gov.au/newspaper/page/24097775 | 24097775 | |
34652 | 34652 | 1919-07-05 | 6 | b | Chinese Diplomatic Association in Beijing (guo min wai jiao xie hui) issues protest telegram. | China | http://trove.nla.gov.au/newspaper/page/24097780 | 24097780 | |
34653 | 34653 | 1919-07-05 | 6 | b | General Chamber of Commerce in Beijing issues protest telegram. | China | http://trove.nla.gov.au/newspaper/page/24097780 | 24097780 | |
34656 | 34656 | 1919-07-05 | 7 | b | Chinese premier Qian Nengxun talks to American journalist on the future of China. | America | http://trove.nla.gov.au/newspaper/page/24097779 | 24097779 | |
34657 | 34657 | 1919-07-05 | 7 | b | Earthquake in Italy. | Britain | http://trove.nla.gov.au/newspaper/page/24097779 | 24097779 | |
34658 | 34658 | 1919-07-05 | 7 | b | Japanese newspapers on their relations with China. | Japan | http://trove.nla.gov.au/newspaper/page/24097779 | 24097779 | |
34663 | 34663 | 1919-07-05 | 8 | b | Beijing news/ President Xu Shichang on the students demonstration in Beijing. Chinese government issues orders to its delegation at the Paris Conference on the Qingdao issues. Different political factions in Beijing (jin bu xi and jiao tong xi). French government seeks to employ some more Chinese labourers. | China | http://trove.nla.gov.au/newspaper/page/24097782 | 24097782 |
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]);