This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15610 | 15610 | 1906-04-28 | 2 | a | San Francisco and its history, business, gold mining, education, and many others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 | |
15611 | 15611 | 1906-04-28 | 2 | a-b | Chronology of earthquakes (and statistics of casualties) in the world from 742 to 1899. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 | |
15612 | 15612 | 1906-04-28 | 2 | b | Tour of the three Chinese officials in the United States for an investigation on political reform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 | |
15613 | 15613 | 1906-04-28 | 2 | b-d | Police headquarters in Beijing suggests setting up medical study association. German navy commander tells the parliament that fortifications in Jiaozhou, Shandong province, need reinforced for possible future chaos in China. Army training office in Beijing is considering to set up military band. An employee of the Board of Commerce reports forestation in Zhili province and business in Fengtian. Foreign media comments removal of Li Lianying from the imperial court. Board of Commerce had drafted a new law for newspaper publishing. British consul and the negotiation over with Chinese authorities for the missionary case in Nanchang county, Jiangxi province. A French missionary in Yunnan province kills ordinary people in broad daylight and bullies others. | China | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 |
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]);