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 |
---|---|---|---|---|---|---|---|---|---|
37939 | 37939 | 1921-12-03 | 6 | c | To plant jujube tree in the Beijing front yard and to encourage industrial effort, written by Liu Rongting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093779 | 24093779 | |
37949 | 37949 | 1921-12-03 | 7 | c | News in brief/ Japanese delegates want to solve the Shandong problem outside of the Washington Conference. Jin Yupen contact Cao Kun, Wu Peifu and other warlords for the north expedition initiated by Sun Yatsen. Wu Peifu to convene a Baoding conference with other warlords. Preparation for the Washington Conference. Warlords in the north prepare to counterattack the north expedition. | China | http://trove.nla.gov.au/newspaper/page/24093778 | 24093778 | |
37950 | 37950 | 1921-12-03 | 7 | c | A reply from Filipino authority to the Overseas Chinese Association in Shanghai on their attitude to the bookkeeping of Chinese shops in the Philippines. | China | http://trove.nla.gov.au/newspaper/page/24093778 | 24093778 |
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]);