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]);