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 |
---|---|---|---|---|---|---|---|---|---|
20534 | 20534 | 1909-01-16 | 6 | c | Liang Dunyan is promoted to minister of foreign affairs. | Britain | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 | |
20535 | 20535 | 1909-01-16 | 6 | c | British and Russian naval sailors in Italy help rescue victims after the earthquake. Meanwhile, some robberies occurred after the earthquake. Donations to the Italian earthquake victims from American Red Cross and other sources. | Britain | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 | |
20536 | 20536 | 1909-01-16 | 6 | c | Train bombed in Calcutta, India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802024 | 26802024 | |
20544 | 20544 | 1909-01-16 | 7 | c | Chinese community in Coolangatta, Queensland, donate to Chinese navy building and their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802023 | 26802023 | |
20545 | 20545 | 1909-01-16 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802023 | 26802023 |
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]);