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 |
---|---|---|---|---|---|---|---|---|---|
26369 | 26369 | 1912-07-13 | 2 | a | Notice of Nationalist Association, Sydney about its name change. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092304 | 24092304 | |
26376 | 26376 | 1912-07-13 | 3 | a | New Hong Kong governor attacked by gun shot by Guangdong man who claims hating British men there. Yet he is not hurt. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24092303 | 24092303 | |
26377 | 26377 | 1912-07-13 | 3 | a | New Hong Kong governor attacked by gun shooting by Guangdong man who claims hating British men there. Yet he is not hurt. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24092303 | 24092303 | |
26378 | 26378 | 1912-07-13 | 3 | a | Revolutionaries fight government troops in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24092303 | 24092303 | |
26379 | 26379 | 1912-07-13 | 3 | a | Strange lightening happens during Russian army exercise, killing two and wound dozens. | Russia | http://trove.nla.gov.au/newspaper/page/24092303 | 24092303 | |
26380 | 26380 | 1912-07-13 | 3 | a | German king is to meet Russian king. Britain and France express their concern about their meeting. | Britain | http://trove.nla.gov.au/newspaper/page/24092303 | 24092303 | |
26381 | 26381 | 1912-07-13 | 3 | a | Former premier is forced to tell reasons for resign at gun point. | China | http://trove.nla.gov.au/newspaper/page/24092303 | 24092303 | |
26391 | 26391 | 1912-07-13 | 6 | a | Government public notice about issue of new government regulations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092308 | 24092308 | |
26400 | 26400 | 1912-07-13 | 8 | a | Notice for donation to renovation of Guanghua temple in Xiangshan, Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092310 | 24092310 |
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]);