This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15425 | 15425 | 1906-03-03 | 6 | a | An article selected from a Chinese newspaper in San Francisco comments that The Eastern Times in Shanghai contributes significantly towards the boycott of American goods in China. | America | http://trove.nla.gov.au/newspaper/page/26800916 | 26800916 | |
15426 | 15426 | 1906-03-03 | 6 | a-b | A French scientist predicts the future of human beings. Residents and migrants in Siberia. Who can claim to be a great man? | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800916 | 26800916 | |
15427 | 15427 | 1906-03-03 | 6 | b | State of Victoria sends two envoys to visit Japan, China for business purpose. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800916 | 26800916 | |
15428 | 15428 | 1906-03-03 | 6 | b | A carpenter's shop in Sydney burned to ashes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800916 | 26800916 | |
15429 | 15429 | 1906-03-03 | 6 | b | Gaoyao (county) fellows in Sydney have built another temple and report on the opening ceremony. Comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800916 | 26800916 | |
15430 | 15430 | 1906-03-03 | 6 | b | "La Fille du Tambour Major" is now playing at the Theatre Royal. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800916 | 26800916 | |
15431 | 15431 | 1906-03-03 | 6 | b | Tung Wah Times thanks readers who have paid their subscription fees. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800916 | 26800916 |
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]);