This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30816 | 30816 | 1915-12-11 | 8 | a | Strange legal case in Beijing/ Wu Baojun is sentenced to death for his conspiracy on looting properties of his previous master. | Canada | http://trove.nla.gov.au/newspaper/page/24095092 | 24095092 | |
30817 | 30817 | 1915-12-11 | 8 | a-b | Interesting stories of prostitutes in Beijing/ Two well-known prostitutes are arrested for their fighting in public due to their jealous to each other. | China | http://trove.nla.gov.au/newspaper/page/24095092 | 24095092 | |
30818 | 30818 | 1915-12-11 | 8 | b | Government troops have almost wiped off bandits in Yunnan but British and German people are active there for unknown reasons. | China | http://trove.nla.gov.au/newspaper/page/24095092 | 24095092 | |
30819 | 30819 | 1915-12-11 | 8 | b-c | Guangdong news/Guangdong Officials in Beijing advise Guangdong to plant more trees while regulating rivers for preventing future floods. Governor Long is welcomed for his taking position in Guangdong. Names of officials examining newspapers in Guangdong. Dian Bei county in Guangdong suffers tornado disaster, resulting in heavy loss. A man slanting a troop leader is sentenced to death in Guangdong. Overseas Chinese in Burma donates to Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24095092 | 24095092 |
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]);