This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20699 | 20699 | 1909-02-27 | 2 | b-c | A letter from Yuan Shitong to his brother Yuan Shikai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802092 | 26802092 | |
20703 | 20703 | 1909-02-27 | 3 | b-c | Guangdong news/ Development of telephone communication and postal service in Guangdong counties. Establishment of local legislature assemblies in Guangdong. Governor Zhang Renjun has selected gentry list for the legislature assembly. Land office of the Guangzhou-Hankou railway is now under control of the government. Liang Dingfen is back to Guangdong. Xiangshan county is open to foreign investment. Election of the legislature assembly. Road construction in Panyu county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802091 | 26802091 | |
20717 | 20717 | 1909-02-27 | 6 | b-c | President Roosevelt of the United States writes and comments on the future of China. | America | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20729 | 20729 | 1909-02-27 | 7 | b-c | Yuan Shikai in the court, his power and the removal. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 |
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]);