This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21763 | 21763 | 1909-10-09 | 2 | c-d | Beijing news/ Chinese ministry of foreign affairs forbids foreigners from interfering in local affairs. Ministry of civil affairs submits their budget report. Treaty between China and Japan on the Jiandao island dispute. Involvement of foreign loans in the railway construction in Hubei and Hunan province. | China | http://trove.nla.gov.au/newspaper/page/26802352 | 26802352 | |
21776 | 21776 | 1909-10-09 | 3 | c-d | Chinese translation of the new regulation issued by American government specifically on Chinese immigration. | America | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
21797 | 21797 | 1909-10-09 | 8 | c-d | Folk song on opium smoking. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802358 | 26802358 |
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]);