This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2789 | 2789 | 1899-06-17 | 3 | a | A man dies while fossicking for gold Adelaide. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2790 | 2790 | 1899-06-17 | 3 | a | Bendigo boy dies after falling down steps. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2791 | 2791 | 1899-06-17 | 3 | a | Gold price in London. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2792 | 2792 | 1899-06-17 | 3 | a | Many people flee from the Philippines. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2793 | 2793 | 1899-06-17 | 3 | a | A series of murder cases in Queensland are being investigated. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2794 | 2794 | 1899-06-17 | 3 | a-b | Bandits and chaos in Chaozhou region, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2795 | 2795 | 1899-06-17 | 3 | b | Epidemic in Dongguan county, Guangdong province. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2796 | 2796 | 1899-06-17 | 3 | b | The plague in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2797 | 2797 | 1899-06-17 | 3 | b-c | British occupation and Chinese resistance in Kowloon. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2798 | 2798 | 1899-06-17 | 3 | c | Peng Longbiao, leader of bandits in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2799 | 2799 | 1899-06-17 | 3 | c-d | The mining and exporting of gold in Queensland. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2800 | 2800 | 1899-06-17 | 3 | d | The 1500 workers sent to China by the Russian government are actually soldiers. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2801 | 2801 | 1899-06-17 | 3 | d | Typhoon in the Philippines. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2802 | 2802 | 1899-06-17 | 3 | d | Tsar of Russia prepares to hand over the throne to his son. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2803 | 2803 | 1899-06-17 | 3 | d | Chinese man, San Li, owner of a laundry in South Melbourne, was injured in recent attack. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2804 | 2804 | 1899-06-17 | 3 | e | Social chaos aroused in Zengcheng over controversy in the imperial examination. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2805 | 2805 | 1899-06-17 | 3 | e | France manufactures more powerful guns. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2806 | 2806 | 1899-06-17 | 3 | e | Chinese Ya Long was detained for injuring his countryman, Pan Yaze. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2807 | 2807 | 1899-06-17 | 3 | e | Britain orders China to pay more for business. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2808 | 2808 | 1899-06-17 | 3 | f | Russia places more demands on China. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2809 | 2809 | 1899-06-17 | 3 | f | Gold is found in abundance in Victoria. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
2810 | 2810 | 1899-06-17 | 3 | f | Fang Boyuan leaves Guangdong and gets promoted. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 |
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]);