This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36562 | 36562 | 1921-01-29 | 3 | b-c | Tang Jiyao writes to Yunnan authorities and suggests close-door policy for local self-government. | China | http://trove.nla.gov.au/newspaper/page/24093409 | 24093409 | |
36578 | 36578 | 1921-01-29 | 8 | b-c | Guangdong news/ Military government delivers notes to foreign missions in Guangzhou regarding total ban on gambling. Governor Chen Jiongming requests that military and civil affairs should be handled separately. Rewards offered to catch the murderer of Cheng Biguang, former naval commander. Navy farewells Tang Tingguang. Li Yaohan releases a public notice and gives up his military commandership. Tang Tingguang takes his officer of naval commander. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093416 | 24093416 |
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]);