This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21045 | 21045 | 1909-05-22 | 3 | a | Imperial edict on February 7, 8, 10 and 12. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802189 | 26802189 | |
21046 | 21046 | 1909-05-22 | 3 | b | Correspondence from Tokyo. American female missionary is naturalised in Japan. Japan starts new sea route to South America. Agreement between China and Japan on telegram communications. Yokohama welcomes American industrialist. | Japan | http://trove.nla.gov.au/newspaper/page/26802189 | 26802189 | |
21047 | 21047 | 1909-05-22 | 3 | b-c | China news/ Prince regent is keen for political reform and his policy. Foreign missions who appear in the state funeral for the late Emperor Guangxu. Government to collect land and house tax. Prince regent in the court. Effort to borrow foreign loans for the railway construction from Guangzhou to Hankou. Plan for naval rejuvenation. China to redeem Kaiping mines from British. | China | http://trove.nla.gov.au/newspaper/page/26802189 | 26802189 | |
21048 | 21048 | 1909-05-22 | 3 | c-d | Guangdong news/ Proposal for self-government in local towns. Naval training in Guangdong. Fire in Xinchang, of Xinning county. Leather company and the water company in Guangzhou. Dispute over Dongsha island and the trade with Japan. Solution to the Foshan case (in which a Chinese passenger was kicked to death by a Portuguese passenger). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802189 | 26802189 |
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]);