This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38914 | 38914 | 1922-06-24 | 3 | b | Why Zhang Zuolin is defeated and an analysis. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38915 | 38915 | 1922-06-24 | 3 | b-c | More report on the war between Wu Peifu and Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38916 | 38916 | 1922-06-24 | 3 | d | The war in Jiangxi province (Li Liejun and his troops have entered Nanxiong). | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38917 | 38917 | 1922-06-24 | 3 | d-e | Sun Chuanfang suggests to resume the old parliament with Li Yuanhong as the President. This suggestion is also supported by Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38918 | 38918 | 1922-06-24 | 3 | e | Yan Huiqing becomes acting premier while retains his foreign affairs minister. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38919 | 38919 | 1922-06-24 | 3 | e | Guangdong army enters Jiangxi province. | America | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38920 | 38920 | 1922-06-24 | 3 | f | Fire in the Long Island, New York. | America | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38921 | 38921 | 1922-06-24 | 3 | f | Representatives from three northeastern provinces meet in Fengtian and declare self-government. | America | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38922 | 38922 | 1922-06-24 | 3 | f | Sun Yatsen has fled Guangzhou, and another report. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38923 | 38923 | 1922-06-24 | 3 | f | Chinese President Li Yuanhong pardons Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38924 | 38924 | 1922-06-24 | 3 | f | Sun Yatsen's army are defeated by government troops from the north. | Britain | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38925 | 38925 | 1922-06-24 | 3 | f | Canadian government is planning to impose strict restriction upon Chinese immigrants. | Canada | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 |
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]);