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 |
---|---|---|---|---|---|---|---|---|---|
24541 | 24541 | 1911-05-20 | 3 | a | Drug-smoking ban treaty extended | The drug-smoking ban treaty is extended for another seven years. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24542 | 24542 | 1911-05-20 | 3 | a | Fire in Jiling | A big fire disaster happened in Jiling. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24543 | 24543 | 1911-05-20 | 3 | a | Call for revising entry ban on Chinese | Chinese business association call for American government to revise its entry ban on Chinese. | America | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24544 | 24544 | 1911-05-20 | 3 | a | Foreign loans for building railways | Chinese government proposes more loans for building its railways. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24545 | 24545 | 1911-05-20 | 3 | a | Revolutionary party in action | Sun Wen prepares several revolutionary actions around Yangtze river area. | Japan | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24546 | 24546 | 1911-05-20 | 3 | a | Theatre burned down | A theatre in London was burned down. | Britain | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24547 | 24547 | 1911-05-20 | 3 | a | Canada allows a railway in China | Canadian government has approved to build a railway in North China. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24548 | 24548 | 1911-05-20 | 3 | a | Riots in Mexico | Riots happen in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24549 | 24549 | 1911-05-20 | 3 | a | A huge ship will be built | A huge ship will be built. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24564 | 24564 | 1911-05-20 | 8 | a | Confucianism in New York | Confucian teaching and learning in New York. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24091785 | 24091785 |
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]);