This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35909 | 35909 | 1920-07-17 | 3 | a | Rumours in Beijing on the peace in the southwest. | China | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35910 | 35910 | 1920-07-17 | 3 | a-b | Zhang Shizhao writes to Wu Tingfang on the tariff revenue. | China | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35911 | 35911 | 1920-07-17 | 3 | b | Celebration of the International Labour Day in Beijing and the arrests. | China | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35912 | 35912 | 1920-07-17 | 3 | b-c | The possible change of the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35913 | 35913 | 1920-07-17 | 3 | c | Fire in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35914 | 35914 | 1920-07-17 | 3 | c | War clouds over the Anfu and Zhili groups in China. | China | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35915 | 35915 | 1920-07-17 | 3 | c | Disputes between Japan and America. | America | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35916 | 35916 | 1920-07-17 | 3 | c | Chinese students and businessmen protest against the Anglo-Japanese treaty. | America | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35917 | 35917 | 1920-07-17 | 3 | c | Political fighting in Beijing. | America | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35918 | 35918 | 1920-07-17 | 3 | d | Foreign missions in Beijing and their warnings to the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35919 | 35919 | 1920-07-17 | 3 | d | Japanese prime minister on the international situations. | America | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35920 | 35920 | 1920-07-17 | 3 | d | Chaos in Beijing. | Britain | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 | |
35921 | 35921 | 1920-07-17 | 3 | e | Duan Qirui to protect the Beijing people. | China | http://trove.nla.gov.au/newspaper/page/24098236 | 24098236 |
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]);