This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38103 | 38103 | 1922-01-07 | 6 | a | An open letter from Shanghai city residents to American President Warren Harding and the Washington Conference. | China | http://trove.nla.gov.au/newspaper/page/24093819 | 24093819 | |
38104 | 38104 | 1922-01-07 | 6 | a | News in brief/ Zhang Zuolin on the new cabinet organised by Liang Shiyi and the Chinese constitution. Chinese newspapers support to elect Xu Shichang Chinese president. American ambassador in Beijing opposes to appointment of Zhang Jingyao in the new cabinet. | Other... | http://trove.nla.gov.au/newspaper/page/24093819 | 24093819 | |
38105 | 38105 | 1922-01-07 | 6 | b | Leon Trotsky reports to the Soviet parliament in Moscow the reduction of Red Army troops. | Russia | http://trove.nla.gov.au/newspaper/page/24093819 | 24093819 | |
38106 | 38106 | 1922-01-07 | 6 | b | Flooding in Shandong province. | America | http://trove.nla.gov.au/newspaper/page/24093819 | 24093819 | |
38107 | 38107 | 1922-01-07 | 6 | b | Poems by Shouzhou (anonymous author) on his tour to the Sydney botany garden. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093819 | 24093819 | |
38108 | 38108 | 1922-01-07 | 6 | b | Swimming in Sydney beach (Bondi, Manly and Coogee), by Yu Wenhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093819 | 24093819 |
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]);