This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17040 | 17040 | 1907-03-09 | 3 | b-c | Italian women submit petition to the parliament and demand the right to vote. | Australia | http://trove.nla.gov.au/newspaper/page/26801250 | 26801250 | |
17041 | 17041 | 1907-03-09 | 3 | c | Two thousand political offenders are sent on exile in Russia within one month. | Australia | http://trove.nla.gov.au/newspaper/page/26801250 | 26801250 | |
17042 | 17042 | 1907-03-09 | 3 | c | A Russian duke narrowly escapes an assassination. | Australia | http://trove.nla.gov.au/newspaper/page/26801250 | 26801250 | |
17043 | 17043 | 1907-03-09 | 3 | c | Canadian flour sells well in China. | Australia | http://trove.nla.gov.au/newspaper/page/26801250 | 26801250 | |
17044 | 17044 | 1907-03-09 | 3 | c | Californian authority issues new law which prohibit foreigners from purchasing property. | Australia | http://trove.nla.gov.au/newspaper/page/26801250 | 26801250 | |
17046 | 17046 | 1907-03-09 | 3 | c | Thailand government invites Japanese naval officer to train their torpedo boat staff. | Australia | http://trove.nla.gov.au/newspaper/page/26801250 | 26801250 |
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]);