This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36201 | 36201 | 1920-10-16 | 3 | a | Mo Rongxin during the war between Guangdong and Fujian. | China | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36202 | 36202 | 1920-10-16 | 3 | a | The war in Chaozhou and Shantou area between Guangdong and Fujian armies. | China | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36203 | 36203 | 1920-10-16 | 3 | b | Tan Haoming dispatches troops to the east. | China | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36204 | 36204 | 1920-10-16 | 3 | b | Munitions factory in Guangzhou is busy manufacturing more weapons for the war. | China | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36205 | 36205 | 1920-10-16 | 3 | b | Tang Jiyao is trying to set up a new parliament and his efforts. | China | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36206 | 36206 | 1920-10-16 | 3 | c | President Xu Shichang in China and the human rights. | China | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36207 | 36207 | 1920-10-16 | 3 | c | Zhang Zuolin ridicules Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36208 | 36208 | 1920-10-16 | 3 | c | Miscellaneous report from China. | China | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36209 | 36209 | 1920-10-16 | 3 | d | Flu in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36210 | 36210 | 1920-10-16 | 3 | d | Banking corporation of the seven countries and their loans to China. | America | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36211 | 36211 | 1920-10-16 | 3 | d | American Red Cross donates to the famine relief in north China. | America | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36212 | 36212 | 1920-10-16 | 3 | d | Russian embassy and their privileges in China. | America | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36213 | 36213 | 1920-10-16 | 3 | d | Chinese government is not able to protect its citizens in Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36214 | 36214 | 1920-10-16 | 3 | e | Japan dispatches more troops to the Far East. | Japan | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 | |
36215 | 36215 | 1920-10-16 | 3 | e | Bolshevik Party on the border of China and Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24098344 | 24098344 |
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]);