This data as json, CSV (advanced)
Suggested facets: source, 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 |
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]);