This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37258 | 37258 | 1921-07-02 | 6 | a | Second part of the report on industrial development in China (tariff collection, telegraph, agricultural products). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37259 | 37259 | 1921-07-02 | 6 | b | Pessimism over Guangdong/ Cargo ship hijacked, robbery on board of passenger ferries and looting in the village. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37260 | 37260 | 1921-07-02 | 6 | b | Negotiation between China and Germany on a peace treaty. | France | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37261 | 37261 | 1921-07-02 | 6 | b-c | Chinese ambassador to Washington comments on the Britain-Japan alliance. | Canada | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37262 | 37262 | 1921-07-02 | 6 | c | War breaks out between Guangdong and Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37263 | 37263 | 1921-07-02 | 6 | c | Advertisement for Sun Tuey Wah Chockson & Co, 71-79 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37264 | 37264 | 1921-07-02 | 6 | c | Business for sale by Chern Lee in Norrowmine, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37265 | 37265 | 1921-07-02 | 6 | d | Advertisement for Dr Williams' Pink Pill for pale people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37266 | 37266 | 1921-07-02 | 6 | d | Advertisement for Chinese doctor Sue Fong, Emmaville, specialist for sexually transmitted diseases. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37267 | 37267 | 1921-07-02 | 6 | d | Advertisement for The Commonwealth Studio, 337 Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37268 | 37268 | 1921-07-02 | 6 | d | Advertisement for Tillook & Co Ltd, Merchants and Manufacturers, Kent and Liverpool Streets, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37269 | 37269 | 1921-07-02 | 6 | e | Advertisement for Sun Man Lee & Co, 16 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37270 | 37270 | 1921-07-02 | 6 | e | Advertisement for Tiy Loy & Co, Botany Road, Alexandria, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37271 | 37271 | 1921-07-02 | 6 | e | Advertisement for Gibbs Brights & Co, Insurance Department, 41 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37272 | 37272 | 1921-07-02 | 6 | f | Sydney market report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 |
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]);