This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9034 | 9034 | 1901-11-09 | 2 | a | Imperial edicts on August 5. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9035 | 9035 | 1901-11-09 | 2 | a-b | The second and final part of a report on the establishment of the Department of Foreign Affairs. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9036 | 9036 | 1901-11-09 | 2 | b-c | An essay commenting on the cancellation of imperial martial arts examinations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9037 | 9037 | 1901-11-09 | 2 | c | Both Liu Kunyi and Tao Mo seek retirement. | Other... | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9038 | 9038 | 1901-11-09 | 2 | c | Zheng Wenqin, a local magistrate in Shanxi province, has committed suicide. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9039 | 9039 | 1901-11-09 | 2 | c | A copy of peaceful agreement from Shanxi province as a solution to missionary incident. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9040 | 9040 | 1901-11-09 | 2 | d | Budget for the imperial return to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9041 | 9041 | 1901-11-09 | 2 | d | Some remnants have been found in Yuannan and Guizhou provinces. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9042 | 9042 | 1901-11-09 | 2 | d | Modern and technical schools established in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9043 | 9043 | 1901-11-09 | 2 | d | Rong Lu in the court. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9044 | 9044 | 1901-11-09 | 2 | e | Drought in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9045 | 9045 | 1901-11-09 | 2 | e | Guangdong has suspended the creation of official positions. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9046 | 9046 | 1901-11-09 | 2 | e | Hail and storm in Russia. | Australia | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9047 | 9047 | 1901-11-09 | 2 | e | Small watches in Switzerland. | Other... | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9048 | 9048 | 1901-11-09 | 2 | e | Some sharks near the coast of America have been marked for study purpose. | America | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9049 | 9049 | 1901-11-09 | 2 | e | China's international trade status. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9050 | 9050 | 1901-11-09 | 2 | f | Dozens of German people are going to explore the South Pole. | Japan | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9051 | 9051 | 1901-11-09 | 2 | f | French governor in Saigon likes employing some Chinese labourers from Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9052 | 9052 | 1901-11-09 | 2 | f | Letter from Emperor Guangxu to the Emperor of Japan and reply. | Japan | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 |
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]);