This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31009 | 31009 | 1916-03-04 | 7 | a-b | Australia news/Sydney starts to construct its internal railways. A German shop in Sydney is bombed. Statistics show that crimes in New South Wales increase this year. Infantile paralysis is spreading in New Zealand resulting in schools closing. Government does not regulate the closing time of public bars in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24095182 | 24095182 | |
31010 | 31010 | 1916-03-04 | 7 | c | Wu Elou's poem. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095182 | 24095182 |
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]);