This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19068 | 19068 | 1908-03-21 | 6 | a | Notice from the Tung Wah Times for seal engraving service. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801674 | 26801674 | |
19069 | 19069 | 1908-03-21 | 6 | a | A notice from the Chinese Empire Reform Association in Sydney to its members and other Chinese fellows in Australia regarding the Political Research Society (zheng wen she), a political party established in Tokyo to replace the Chinese Empire Reform Association and now headquartered in Shanghai, admission into this party, Kang Youwei's proposed visit to Australia, and other issues of the Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801674 | 26801674 | |
19070 | 19070 | 1908-03-21 | 6 | a-b | Special report. Guangdong navy seizes large amounts of weapons smuggled by Sun Yatsen's revolutionaries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801674 | 26801674 | |
19071 | 19071 | 1908-03-21 | 6 | b-c | A special report written by Wu Tongbo on his visit to the Chinese community in Manila. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801674 | 26801674 | |
19072 | 19072 | 1908-03-21 | 6 | c | China apologises to Japan for seizing a Japanese cargo ship smuggling weapons for Chinese revolutionary. | Britain | http://trove.nla.gov.au/newspaper/page/26801674 | 26801674 | |
19073 | 19073 | 1908-03-21 | 6 | c | Emperor Guangxu's certificate of marriage is found in south Germany. | Britain | http://trove.nla.gov.au/newspaper/page/26801674 | 26801674 |
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]);