This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46182 | 46182 | 1927-09-17 | 5 | a | Feng Yuxiang dispatches troops to attack Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46183 | 46183 | 1927-09-17 | 5 | a | Anti-Japanese movement in Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46184 | 46184 | 1927-09-17 | 5 | a | The Communist uprising in Lithuania. | Britain | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46185 | 46185 | 1927-09-17 | 5 | a | Relations between France and Russia. | France | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46186 | 46186 | 1927-09-17 | 5 | a | Hatred to the Communists in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46187 | 46187 | 1927-09-17 | 5 | b | Soviet Russian authority treats strikers cruelly. | Russia | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46188 | 46188 | 1927-09-17 | 5 | b | Italian consul in Paris is murdered. | France | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46189 | 46189 | 1927-09-17 | 5 | b | Martial law in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46190 | 46190 | 1927-09-17 | 5 | b | Comprise between Nanjing and Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46191 | 46191 | 1927-09-17 | 5 | c | Liu Zuolong executes his deputy. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46192 | 46192 | 1927-09-17 | 5 | c | Yan Xishan on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46193 | 46193 | 1927-09-17 | 5 | c | Jiang Yanxing is drowned. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46194 | 46194 | 1927-09-17 | 5 | c | Economic panic in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46195 | 46195 | 1927-09-17 | 5 | b | Borodin is detained in Xin'an, Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46196 | 46196 | 1927-09-17 | 5 | c | Peng Hanzhang is executed. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46197 | 46197 | 1927-09-17 | 5 | d | Liu Zuolong is executed. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 |
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]);