This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12000 | 12000 | 1903-07-11 | 3 | a | Some people in San Francisco suggest moving Chinatown outside of the city. | America | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12001 | 12001 | 1903-07-11 | 3 | a | Gold found in central Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12002 | 12002 | 1903-07-11 | 3 | a | Chinese man L? Genhao was beaten to death in New South Wales on his way to find a job. | Australia | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12003 | 12003 | 1903-07-11 | 3 | a | Li Liang sues Xian Junhao for defamation but lost the case. Brief report on the legal action between Li Bu and Xian Junhao, and the involvement of Li Yongshou and Li Run. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12004 | 12004 | 1903-07-11 | 3 | b | Report on a monthly meeting of the Sydney Chinese Empire Reform Association. Speakers include Liu Ruxing and Xian Junhao. Proposal to ban opium-smoking. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12005 | 12005 | 1903-07-11 | 3 | b | A father in Russia murders his son because of a dream. | Australia | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12006 | 12006 | 1903-07-11 | 3 | b | Russian troops move to east Asia. Assistant foreign secretary of Britain enters talks on railway building in China. Japan sends gunboat to Yalu River. Russian gunboats in Lushun. Relations between Russia and Japan over the Manchuria issue. | Other... | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12007 | 12007 | 1903-07-11 | 3 | b | A Chinese sailor was punished in Sydney for smuggling opium. | Australia | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12008 | 12008 | 1903-07-11 | 3 | c | Chinese community in Wellington, New Zealand, sends a petition to Parliament seeking for explanations of customs regulations. | Australia | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12009 | 12009 | 1903-07-11 | 3 | c | Two boys in Darlinghurst, Sydney, committed suicide. | Australia | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12010 | 12010 | 1903-07-11 | 3 | c | A painter in London was drowned in wine cellar. | Australia | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12011 | 12011 | 1903-07-11 | 3 | c | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12012 | 12012 | 1903-07-11 | 3 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12013 | 12013 | 1903-07-11 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 |
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]);