This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37506 | 37506 | 1921-08-27 | 3 | b | Dalu News comments on the role and function of provincial legislature assembly. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093662 | 24093662 | |
37507 | 37507 | 1921-08-27 | 3 | b | Hubei fellows association in Beijing sends petition to Xu Shichang and requests to remove Wang Zhanyuan. | China | http://trove.nla.gov.au/newspaper/page/24093662 | 24093662 | |
37523 | 37523 | 1921-08-27 | 7 | b | Many Chinese labourers in Cuba become unemployed due to the suddenly decline of sugar price and close-down of sugar factories. An open letter written by Huang Tiesheng, on behalf of Chinese labourers in Cuba, asks for help from the Chinese communities, especially their Gaoyao fellows, in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37524 | 37524 | 1921-08-27 | 7 | b | American and British authorities on the peace in the Pacific region. | Canada | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 |
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]);