This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55312 | 55312 | 1935-08-03 | 3 | e | Japan and Germany may have a military alliance. | America | http://trove.nla.gov.au/newspaper/page/24096520 | 24096520 | |
55320 | 55320 | 1935-08-03 | 8 | e | Australia news/ It is time to lodge personal tax again. Red snow in Victoria. Old attendant in the Sydney See Yup Temple dies suddenly. Many Italian immigrants are applying for Australian citizenship. Chinese man killed in a tram accident in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096527 | 24096527 |
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]);