This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30795 | 30795 | 1915-12-11 | 2 | b-c | Comment on current events/ Overseas Chinese in Australia should promote Chinese education for their children. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095084 | 24095084 | |
30804 | 30804 | 1915-12-11 | 3 | b-c | China and Russia have signed a Ha Ke Tu (ppp) treaty on solving problems involved with Exterior Mongolia. | France | http://trove.nla.gov.au/newspaper/page/24095083 | 24095083 | |
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]);