This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10432 | 10432 | 1902-04-26 | 3 | a | A Japanese gunboat arrived in New Castle, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10433 | 10433 | 1902-04-26 | 3 | a | A passenger ship in America was on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10434 | 10434 | 1902-04-26 | 3 | a | A Chinese newspaper in Singapore claims that Luo Fenglu, Chinese ambassador to Britain, sent Luo Zongyao and Xie Mengchi to Australia and Canada to disband the Chinese Empire Reform Association there. Comments written by the Tung Wah editor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10435 | 10435 | 1902-04-26 | 3 | b | Rumours in Nanhai and Panyu counties, Guangdong, on the drought. | China | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10436 | 10436 | 1902-04-26 | 3 | b | A story in Guangzhou on fengshui and fortune. | China | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10437 | 10437 | 1902-04-26 | 3 | c | A family tragedy in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10438 | 10438 | 1902-04-26 | 3 | c | Imperial edicts to stop foot-binding. | China | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10439 | 10439 | 1902-04-26 | 3 | c | A gentry scholar in Xinhui county, Guangdong, has unique opinion on the imperial examination. | China | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10440 | 10440 | 1902-04-26 | 3 | c | The gap between Manchurian and Han nationalities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10441 | 10441 | 1902-04-26 | 3 | d | A shop in Dongguan, Guangdong, was destroyed in fire after burglary. | China | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10442 | 10442 | 1902-04-26 | 3 | d | Earthquake in America. | Australia | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10443 | 10443 | 1902-04-26 | 3 | d | A big fire in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10444 | 10444 | 1902-04-26 | 3 | e | More Chinese in Sydney arrested for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10445 | 10445 | 1902-04-26 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 |
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]);