This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36282 | 36282 | 1920-11-13 | 3 | a | Nanxiong county declares independence and the report. | China | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36283 | 36283 | 1920-11-13 | 3 | a | Hainan island declares independence and the report. | China | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36284 | 36284 | 1920-11-13 | 3 | a-b | Chen Dechun in Guangdong and his mediation by force. | China | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36285 | 36285 | 1920-11-13 | 3 | b | Guangxi army on the war to the east but are defeated. | China | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36286 | 36286 | 1920-11-13 | 3 | b | The Sun Company in Guangzhou serves as temporary storage house for the provincial military government. | China | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36287 | 36287 | 1920-11-13 | 3 | c | Guangxi army in Dongguan county and their harassment. | China | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36288 | 36288 | 1920-11-13 | 3 | c-d | Miscellaneous report from China. | China | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36289 | 36289 | 1920-11-13 | 3 | d | Farmers in Russia and the riots. | Britain | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36290 | 36290 | 1920-11-13 | 3 | d | Denmark purchase coals from China. | Britain | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36291 | 36291 | 1920-11-13 | 3 | d | Presidential election in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36292 | 36292 | 1920-11-13 | 3 | e | Chinese Premier Jin Yunpeng talks to American journalist. | America | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36293 | 36293 | 1920-11-13 | 3 | e | London banks stop to lend to Canadian and Australian banks. | Canada | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36294 | 36294 | 1920-11-13 | 3 | e | Japanese cabinet decides to withdraw troops from the border of China and Korea. | America | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36295 | 36295 | 1920-11-13 | 3 | d | Tianjin Cafe in Sydney is for sale and the advertisement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
36296 | 36296 | 1920-11-13 | 3 | e | Chinese-English dictionary is available from the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 |
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]);