This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39557 | 39557 | 1923-03-03 | 7 | a | Chinese businessmen who returned from overseas and their companies in China, such as Wing On, Sincere, The Sun, and the new Guangming Manufacturer that is raising funds by floating shares. And comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094322 | 24094322 | |
39558 | 39558 | 1923-03-03 | 7 | a | A Melbourne factory in Footscray is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094322 | 24094322 | |
39559 | 39559 | 1923-03-03 | 7 | a | Street cleaners in Melbourne are on strike. | Australia | http://trove.nla.gov.au/newspaper/page/24094322 | 24094322 | |
39565 | 39565 | 1923-03-03 | 8 | a | Chinese Chamber of Commerce in New South Wales calls for donation to the flooding victims in Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094325 | 24094325 |
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]);