This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10494 | 10494 | 1902-05-03 | 3 | a | A local governor in Russia punished for treating people harshly; American parliament restricts the entry of Chinese immigrants; coronation is being prepared. | Britain | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10495 | 10495 | 1902-05-03 | 3 | a | A theatre in Gaoyao county, Guangdong, was destroyed in a fire. | China | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10496 | 10496 | 1902-05-03 | 3 | a | Bandits in Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10497 | 10497 | 1902-05-03 | 3 | a | A prison in Nanhai county, Guangdong, was on riot. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10498 | 10498 | 1902-05-03 | 3 | b | Bandits on the border of Guangdong and Guangxi provinces. | China | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10499 | 10499 | 1902-05-03 | 3 | b | A notice, issued by Tao Mo, Guangdong governor, and De Shou, imperial commissioner of Guangdong, on school admissions in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10500 | 10500 | 1902-05-03 | 3 | c | Several talented people have been recommended by Guangdong governor. | China | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10501 | 10501 | 1902-05-03 | 3 | c | Statistics of the army in Russia. | Australia | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10502 | 10502 | 1902-05-03 | 3 | c | Governor of Yunnan province is to train troops in modern technology. | China | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10503 | 10503 | 1902-05-03 | 3 | c | Protesters in the Philippines surrender themselves to American troops. | Australia | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10504 | 10504 | 1902-05-03 | 3 | d | American navy are to build more gunboats. | Australia | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10505 | 10505 | 1902-05-03 | 3 | d | Several Chinese in Sydney were brought to court for gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10506 | 10506 | 1902-05-03 | 3 | d | An American navy officer was detained in Sydney for smuggling | Australia | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10507 | 10507 | 1902-05-03 | 3 | d | A shop owner in Sydney was injured in firefighting. | Australia | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10508 | 10508 | 1902-05-03 | 3 | d | Empress Dowager and Emperor Guangxu return after paying homage to their ancestor's mausoleum. | China | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 | |
10509 | 10509 | 1902-05-03 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100411 | 24100411 |
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]);