This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38089 | 38089 | 1922-01-07 | 2 | a-b | New Year's greetings to the Republic of China, editorial by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093815 | 24093815 | |
38094 | 38094 | 1922-01-07 | 3 | a-b | Liang Qichao comments on the Shandong problem. | America | http://trove.nla.gov.au/newspaper/page/24093814 | 24093814 | |
38110 | 38110 | 1922-01-07 | 7 | a-b | Australian trade commissioner Edward Little reports stock exchange and trust company in Shanghai. | Australia | http://trove.nla.gov.au/newspaper/page/24093818 | 24093818 | |
38120 | 38120 | 1922-01-07 | 8 | a-b | Guangdong news/ Further report on the backgrounds of the new county magistrates recently elected by the people in Guangdong. Sun Yatsen is planning to move his presidential office to Guilin in Guangxi province. Members of the provincial legislature assembly demand reimbursement from the financial department. Proposed administrative structure at the county level. Road Administrative Office to be disbanded. Negotiation between China and Portugal on the Macao dispute. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093821 | 24093821 |
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]);