This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3121 | 3121 | 1899-07-22 | 2 | a-b | Imperial edicts on business in Fujian province, bureaucratic appointments in Sichuan, etc. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3122 | 3122 | 1899-07-22 | 2 | b-c | Movement of official in Beijing. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3123 | 3123 | 1899-07-22 | 2 | c-d | Kang Youwei's visit to Canada. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3124 | 3124 | 1899-07-22 | 2 | d-e | Comments on current emergency in China. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3125 | 3125 | 1899-07-22 | 2 | e | The life of Queen of England. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3126 | 3126 | 1899-07-22 | 2 | f | A Sydney girl dies near Darling Harbour. The cause of her death is as yet unknown. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3127 | 3127 | 1899-07-22 | 2 | f | A girl in Perth dresses as a boy. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3128 | 3128 | 1899-07-22 | 2 | f | A Chinese in Bendigo sues a White man. The court found in favour of the defendant. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3129 | 3129 | 1899-07-22 | 2 | f | An eight year old girl disappeares in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3130 | 3130 | 1899-07-22 | 2 | f | A man in Melbourne arrested for theft. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3131 | 3131 | 1899-07-22 | 2 | f | A Chinese grocery shop on George St, Sydney, was robbed. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3132 | 3132 | 1899-07-22 | 2 | f | Floods cause damage in the USA. | http://trove.nla.gov.au/newspaper/page/24102476 | 24102476 | ||
| 3133 | 3133 | 1899-07-22 | 3 | a | Tax is incurred when cattle cross the border between New South Wales and Victoria. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3134 | 3134 | 1899-07-22 | 3 | a | The quantity and value of imports and exports in Queensland. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3135 | 3135 | 1899-07-22 | 3 | a | Road blocked due to heavy rain in country New South Wales. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3136 | 3136 | 1899-07-22 | 3 | a | Man arrested for forging other's signature. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3137 | 3137 | 1899-07-22 | 3 | a | A man in Melbourne dies before his wedding. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3138 | 3138 | 1899-07-22 | 3 | a | Russia is upset about the friendship between Germany and Britain. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3139 | 3139 | 1899-07-22 | 3 | a | An old man in Western Australia disappeared amidst floods. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3140 | 3140 | 1899-07-22 | 3 | b | Price of sheep increases in Sydney; man in Ballarat finds a woman's ring inside a newly-purchased house; Sydney woman was killed in a train accident; floods in America; refugees; Melbourne woman married four times. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3141 | 3141 | 1899-07-22 | 3 | b | The reunion of two brothers in Tianjin. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3142 | 3142 | 1899-07-22 | 3 | b-c | Story of a family in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3143 | 3143 | 1899-07-22 | 3 | c | A skillful doctor in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3144 | 3144 | 1899-07-22 | 3 | c-d | Story of a herbalist in Xiamen, Fujian province. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3145 | 3145 | 1899-07-22 | 3 | d | More chaos in Shandong after the riots in Rizhao Incident. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3146 | 3146 | 1899-07-22 | 3 | d | A man in Sydney murders his wife. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3147 | 3147 | 1899-07-22 | 3 | d | Immigration regulations, three Japanese were refused entry in Queensland. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3148 | 3148 | 1899-07-22 | 3 | d | Four spies and arsonists were detained in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3149 | 3149 | 1899-07-22 | 3 | e | An Yiyuan, Magistrate of Gaoyao county, issues a notice to bandits in order to ensure social security. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3150 | 3150 | 1899-07-22 | 3 | e | Empress Dowager orders army to fire at any invading foreign gunboats in Zhejiang. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3151 | 3151 | 1899-07-22 | 3 | e | Beijing experiences an earthquake. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3152 | 3152 | 1899-07-22 | 3 | e | Empress Dowager now meets officials in the official palace. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3153 | 3153 | 1899-07-22 | 3 | e | Huang Aitang, Magistrate of Shanghai county, reported to the Empress Dowager on the local situation. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3154 | 3154 | 1899-07-22 | 3 | f | Chen Village in Panyu has a big celebration on the completion of an alter. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3155 | 3155 | 1899-07-22 | 3 | f | Japanese envoy meets the Empress and the Emperor in Beijing. | http://trove.nla.gov.au/newspaper/page/24102475 | 24102475 | ||
| 3156 | 3156 | 1899-07-22 | 4 | a | His Majesty holds court recently in Beijing. | http://trove.nla.gov.au/newspaper/page/24102477 | 24102477 | ||
| 3157 | 3157 | 1899-07-22 | 4 | a | New Governor of NSW tours northern towns. | http://trove.nla.gov.au/newspaper/page/24102477 | 24102477 | ||
| 3158 | 3158 | 1899-07-22 | 4 | a | Gold price in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102477 | 24102477 |
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]);