This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46466 | 46466 | 1927-11-26 | 2 | b | Editorial by Tung Wah Times on the army men and their destiny. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098608 | 24098608 | |
46479 | 46479 | 1927-11-26 | 3 | f | A notice by the Dongguan gong yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098607 | 24098607 | |
46489 | 46489 | 1927-11-26 | 7 | a | Notice issued by Liu Guangfu and Ye Tonggui on shareholders' meeting of the China-Australia Mail Line at the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098611 | 24098611 | |
46490 | 46490 | 1927-11-26 | 7 | a | Australia news/ A couple in Sydney commits suicide. Butter factory in Melbourne on blaze. Five illegal Chinese immigrants are detained in Sydney. Freemantle customs authority in Western Australia to deport illegal Chinese immigrants soon. Thieves steal post stamps in Sydney. Unemployment in Sydney. Advertisement for Mason Harris & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098611 | 24098611 | |
46493 | 46493 | 1927-11-26 | 8 | e | Advertisement for the Tientsin (Tianjin) Cafe in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098614 | 24098614 |
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]);