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 |
---|---|---|---|---|---|---|---|---|---|
5043 | 5043 | 1900-04-25 | 2 | a-c | The second and final part of an article on the hardship Chinese suffer in Honolulu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5045 | 5045 | 1900-04-25 | 2 | c-d | Some country New South Wales had snow two weeks ago. This could be a sign that a the regions will experience a good harvest this year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5046 | 5046 | 1900-04-25 | 2 | d | A man who arrived in Lockington from Sydney became ill. Probable cause, new infectious disease. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5047 | 5047 | 1900-04-25 | 2 | d | A report on Ya De, who hanged himself in his garden near Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5050 | 5050 | 1900-04-25 | 2 | d | Reports on the presidential election in the USA. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5052 | 5052 | 1900-04-25 | 2 | d | Guangdong people in Shanghai pray to the Heaven after hearing the news of imperial succession. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5054 | 5054 | 1900-04-25 | 2 | e | Two journalists were detained in Jiangxia county, Hubei province, but were released after the intervention of Japanese consul. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5058 | 5058 | 1900-04-25 | 2 | e | Dozens of Chinese arrived in Sydney on their way to other states. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5059 | 5059 | 1900-04-25 | 2 | e | Victoria experiences heavy rainfall last week. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5060 | 5060 | 1900-04-25 | 2 | e | A carriage in Sydney was turned upside down and some passengers were injured. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5061 | 5061 | 1900-04-25 | 2 | e | Peopll found gold inside a stone. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5073 | 5073 | 1900-04-25 | 3 | b | Another post office in Sydney was robbed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102778 | 24102778 | |
5082 | 5082 | 1900-04-25 | 3 | d | A Chinese Su Hu was seriously injured in an accident on Gibbs Bright ship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102778 | 24102778 | |
5084 | 5084 | 1900-04-25 | 3 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102778 | 24102778 |
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]);