This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44585 | 44585 | 1926-04-03 | 7 | a-c | Australia news/ Health authority in New South Wales issues new order on the hygiene issues. An old Chinese dies in Sydney. Chinese gardens in New South Wales are flooded. Women thieves found in Sydney. A Chinese shop in Queensland is required to demolish for unhygiene. Flu in New South Wales. Christmas holiday in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101513 | 24101513 | |
44586 | 44586 | 1926-04-03 | 7 | c | Rumours say Duan Qirui escapes to Japanese embassy in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101513 | 24101513 | |
44587 | 44587 | 1926-04-03 | 7 | c | Beijing in battles. | China | http://trove.nla.gov.au/newspaper/page/24101513 | 24101513 |
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]);