This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18178 | 18178 | 1907-09-28 | 2 | a | A notice from customs department of Australian federal government offers reward to anyone who reports opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801484 | 26801484 | |
18179 | 18179 | 1907-09-28 | 2 | a-b | Report written by Kang Youwei on his meeting and talks with President of Mexico. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801484 | 26801484 | |
18180 | 18180 | 1907-09-28 | 2 | b-c | Influence of assassination upon Chinese politics (Empress Dowager comments on revolutionaries, government officials in Beijing comment on revolutionaries, Tie Liang comments on revolutionaries, local governors and imperial commissioners comment on revolutionaries.) | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801484 | 26801484 | |
18181 | 18181 | 1907-09-28 | 2 | c | Important report. Beijing government to set up a political advisory committee. | Britain | http://trove.nla.gov.au/newspaper/page/26801484 | 26801484 | |
18182 | 18182 | 1907-09-28 | 2 | c-d | Special report. An article written by Yuan Shikai refutes anti-Manchurianism. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801484 | 26801484 |
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]);