This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39018 | 39018 | 1922-11-18 | 3 | a | Sun Yatsen on his secret contact with German and Russian. | China | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39019 | 39019 | 1922-11-18 | 3 | a-c | Second and final part of a report claims that the retired Qing family members seize public properties and the social response. | China | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39020 | 39020 | 1922-11-18 | 3 | c | Zhang Zuolin and Russian authority have different opinions on the shareholders meeting of the Manchurian railway. | China | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39021 | 39021 | 1922-11-18 | 3 | c-d | A seminar in Shanghai on silk production. | China | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39022 | 39022 | 1922-11-18 | 3 | d | China prepares for the Far Eastern Sports Game that to be held in Osaka. | China | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39023 | 39023 | 1922-11-18 | 3 | e | Interest conflict over the Chinese presidency. | China | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39024 | 39024 | 1922-11-18 | 3 | f | A ship on fire in the Yangtze River. | America | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39025 | 39025 | 1922-11-18 | 3 | f | Earthquake in Chile. | Canada | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39026 | 39026 | 1922-11-18 | 3 | f | A theatre in Switzerland is burned to ashes. | Other... | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39027 | 39027 | 1922-11-18 | 3 | f | Oil tanker on fire in Italy. | Britain | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 |
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]);