This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2869 | 2869 | 1899-06-28 | 2 | a | Imperial edicts on prayer ceremony and other issues. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2870 | 2870 | 1899-06-28 | 2 | a-c | The second part of a report submitted by Yu Liansan, Governor of Hunan province. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2871 | 2871 | 1899-06-28 | 2 | c | On lawsuits about defemation and freedom of the press. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2872 | 2872 | 1899-06-28 | 2 | d | Queensland government offers reward for capture of a murderer. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2873 | 2873 | 1899-06-28 | 2 | d | An old woman from Adelaide dies in a train accident. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2874 | 2874 | 1899-06-28 | 2 | d | Russia purchases America weapons. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2875 | 2875 | 1899-06-28 | 2 | d | A man in Italy dies in balloon-flying accident. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2876 | 2876 | 1899-06-28 | 2 | d | A Melbourne mother murders her children. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2877 | 2877 | 1899-06-28 | 2 | d | Bega of New South Wales has the longest grains of rice. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2878 | 2878 | 1899-06-28 | 2 | d | Radio helps a lot in daily life. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2879 | 2879 | 1899-06-28 | 2 | e | Batemans Bay organises a concert to raise funds for the poor. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2880 | 2880 | 1899-06-28 | 2 | e | A ship near Sydney was saved after an accident. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2881 | 2881 | 1899-06-28 | 2 | e | Russia demands more of northeastern China. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2882 | 2882 | 1899-06-28 | 2 | e-f | A heartless lover in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2883 | 2883 | 1899-06-28 | 2 | f | A ship near Adelaide damaged in fire. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2884 | 2884 | 1899-06-28 | 2 | f | A government office in Queensland damaged in fire. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2885 | 2885 | 1899-06-28 | 2 | f | A Sydney woman dies in house fire. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2886 | 2886 | 1899-06-28 | 2 | f | China compensates France for the murder of a missionary in Sichuan. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2887 | 2887 | 1899-06-28 | 2 | f | Russian man in northeastern China killed Chinese. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 |
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]);