This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35815 | 35815 | 1920-06-19 | 2 | c-d | Lu Yongxiang proposes to abolish the system of provincial military government. | China | http://trove.nla.gov.au/newspaper/page/24098202 | 24098202 | |
35816 | 35816 | 1920-06-19 | 2 | d-e | Foreign newspapers express pessimism on the future of China. | China | http://trove.nla.gov.au/newspaper/page/24098202 | 24098202 | |
35817 | 35817 | 1920-06-19 | 3 | a | Tang Jiyao on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35818 | 35818 | 1920-06-19 | 3 | a | Japanese build munitions factory in Andong, of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35823 | 35823 | 1920-06-19 | 3 | d | Robbery in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 | |
35835 | 35835 | 1920-06-19 | 8 | a-c | Guangdong news/ China navy and the exercise. Provincial government asks the Beijing government to pay the provisions. Protest against the poultry tax in Guangzhou. Efforts to suppress bandits in Guangdong. Wu Tingfang is removed from his current position. Bandits in Xinxing county. | China | http://trove.nla.gov.au/newspaper/page/24098209 | 24098209 |
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]);