This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33 | 33 | 1898-07-02 | 3 | a | China proposes to set up Ministry of Commerce to deal with international trade. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
34 | 34 | 1898-07-02 | 3 | a | Rice shop in Zengcheng, Guangdong, robbed. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
35 | 35 | 1898-07-02 | 3 | a | Current situation, Luzon, Philippines | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
36 | 36 | 1898-07-02 | 3 | b | Silkworm breeding, silk production, in Victoria, South Australia | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
37 | 37 | 1898-07-02 | 3 | b | German ambassador in Beijing requests to build a railway in China, from Tianjin to Pukou. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
38 | 38 | 1898-07-02 | 3 | b | Chinese government proposes to set up Hong Kong - Shanghai Banking Corporation. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
39 | 39 | 1898-07-02 | 3 | c | Russia, France and Germany will unite to hold back the entry of Britain into China. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
40 | 40 | 1898-07-02 | 3 | c | Big pearl found in Africa and purchased by French businessman. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
41 | 41 | 1898-07-02 | 3 | c-d | Chinese navy warship sinks in Eastern Sea. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
42 | 42 | 1898-07-02 | 3 | d | Militiamen clash with local aboriginals in Luzon and cause losses. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
43 | 43 | 1898-07-02 | 3 | d | Young bully in Xinhui county, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
44 | 44 | 1898-07-02 | 3 | d-e | Japanese government to issue bonds to raise money for military purpose. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
45 | 45 | 1898-07-02 | 3 | e | German troops destroy Confucius statue and temple in Jimo county, Shandong. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
46 | 46 | 1898-07-02 | 3 | e-f | Many die in disease epidemic in Guangdong | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 | ||
47 | 47 | 1898-07-02 | 3 | f | Xiangshan county, Guangdong. Young man convinces sister-in-law to enter prostitution in brother's absence. | http://trove.nla.gov.au/newspaper/page/24102048 | 24102048 |
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]);