This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10960 | 10960 | 1902-08-30 | 3 | a | New South Wales has timely rain after a long drought. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
10961 | 10961 | 1902-08-30 | 3 | a | Epidemic has been eradicated in Fremantle, Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
10962 | 10962 | 1902-08-30 | 3 | a | An old Chinese man died on arrival in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
10963 | 10963 | 1902-08-30 | 3 | a | Best wishes to Mei Guangda from Ashfield council and some others. Mei Guangda is recovering from an injury. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
10964 | 10964 | 1902-08-30 | 3 | a | Baby found in Darling Harbour, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
10965 | 10965 | 1902-08-30 | 3 | a | Chen Sanli has been invited to set up universities in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
10966 | 10966 | 1902-08-30 | 3 | a | Dong Fuxiang in exile. | Other... | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 |
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]);