This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47822 | 47822 | 1929-02-16 | 2 | f | Famine in Shaanxi province. | China | |||
47823 | 47823 | 1929-02-16 | 2 | f | Yang Sen is dismissed and under investigation. | China | |||
47829 | 47829 | 1929-02-16 | 3 | f | The conclusion of investigation on opium smuggling in Shanghai. | China | |||
47830 | 47830 | 1929-02-16 | 3 | f | Wuhan authority moves troops to be against Anhui faction. | China | |||
47831 | 47831 | 1929-02-16 | 3 | f | Jiang Jieshi moves Xu Yuanquan's troops to the south into Anhui province. | China |
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]);