This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17832 | 17832 | 1907-07-20 | 8 | a-b | Second part of the report, prepared by Xu Rui, envoy of Chinese government, suggests to set up China Prosperity Commercial Company (zhongguo zhenxing shangwu zong gongsi) among overseas Chinese communities in order to protect the interest of China and overseas Chinese communities. The company will include steamship company, bank and insurance company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801410 | 26801410 | |
17833 | 17833 | 1907-07-20 | 8 | b | Poems & couplets in memory of cutting pigtails. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801410 | 26801410 | |
17834 | 17834 | 1907-07-20 | 8 | b-c | Fable. A rich man in East Asia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801410 | 26801410 | |
17835 | 17835 | 1907-07-20 | 8 | c | Historical story. The law of Brotherhood Society (ge lao hui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801410 | 26801410 | |
17836 | 17836 | 1907-07-20 | 8 | c-d | Jokes. A letter from opium addict of Fujian province to his Guangdong partner, and reply from the Guangdong addict. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801410 | 26801410 | |
17837 | 17837 | 1907-07-20 | 8 | d | Poem written by an adulteress. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801410 | 26801410 |
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]);