This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 20807 | 20807 | 1909-03-20 | 6 | b | George Morrison, journalist of The Times of London and based in Beijing, comments on China's effort to borrow foreign loans for railway construction. | Britain | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
| 20808 | 20808 | 1909-03-20 | 6 | b | French parliament approves to collect personal income tax. | Britain | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
| 20809 | 20809 | 1909-03-20 | 6 | b | British government to provide subsidy to Hong Kong administration for the opium ban. | Britain | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
| 20810 | 20810 | 1909-03-20 | 6 | b | Another earthquake hits Italy; a report on the casualties. | Britain | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
| 20811 | 20811 | 1909-03-20 | 6 | b | Germany and Britain are fighting for railway profit in China. | Britain | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
| 20812 | 20812 | 1909-03-20 | 6 | b | Robert Hart still tries to help China. | Britain | http://trove.nla.gov.au/newspaper/page/26802120 | 26802120 | |
| 20822 | 20822 | 1909-03-20 | 7 | b | Chinese man Miu Yang kills another white man on Campbell Street, Sydney, in a fight. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802119 | 26802119 | |
| 20823 | 20823 | 1909-03-20 | 7 | b | Australian foreign minister says new regulations would be necessary for Chinese sailors. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802119 | 26802119 | |
| 20824 | 20824 | 1909-03-20 | 7 | b | Amount of opium confiscated by Australian customs and the number of people charged with opium smuggling in the past three years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802119 | 26802119 | |
| 20825 | 20825 | 1909-03-20 | 7 | b | A trial in Manly, Sydney, on the Chinese gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802119 | 26802119 |
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]);