This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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]);