glam-datasets

1 row where dataset_description = "Between 1916 and 1919 the South Australian Red Cross Information Bureau undertook research into over eight thousand enquiries from family and friends of missing Australian Imperial Force personnel who fought in WW1. The data contains the names and service detail of the soldier enquired upon and eyewitness; name and address of enquirer, dates of death, locations, National Archives barcode for soldier war service records, date range of enquiry, battalion name." and "start_date" is on date 1915-01-01

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), dataset_modified (date), end_date (date), file_created (date), file_modified (date)

start_date (date) ✖

  • 1915-01-01 · 1 ✖

source

format

dataset_description ✖

  • Between 1916 and 1919 the South Australian Red Cross Information Bureau undertook research into over eight thousand enquiries from family and friends of missing Australian Imperial Force personnel who fought in WW1. The data contains the names and service detail of the soldier enquired upon and eyewitness; name and address of enquirer, dates of death, locations, National Archives barcode for soldier war service records, date range of enquiry, battalion name. · 1 ✖
Link rowid ▼ dataset_title publisher author dataset_issued dataset_modified dataset_description source info_url start_date end_date file_title download_url format file_description file_created file_modified file_size licence
783 783 South Australian Red Cross Information Bureau State Library of South Australia State Library of South Australia 2015-06-16T07:13:31.330095 2016-07-04T06:14:08.552618 Between 1916 and 1919 the South Australian Red Cross Information Bureau undertook research into over… data.sa.gov.au https://data.sa.gov.au/data/dataset/59af795b-aa47-4633-8405-b61b9da8e574 1915-01-01 1919-12-30 SARCIB WW1 Collections data https://sarcib.ww1.collections.slsa.sa.gov.au/sites/default/files/sarcib-data.json JSON SARCIB WW1 Collections data in JSON format. **Data description** Note that in the data, (1) fiel… 2015-06-16T17:15:04.211243 2022-08-09T14:16:17   Creative Commons Attribution

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [glam-datasets] (
   [dataset_title] TEXT,
   [publisher] TEXT,
   [author] TEXT,
   [dataset_issued] TEXT,
   [dataset_modified] TEXT,
   [dataset_description] TEXT,
   [source] TEXT,
   [info_url] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [file_title] TEXT,
   [download_url] TEXT,
   [format] TEXT,
   [file_description] TEXT,
   [file_created] TEXT,
   [file_modified] TEXT,
   [file_size] TEXT,
   [licence] TEXT
);
CREATE INDEX [idx_glam-datasets_source_publisher_format_licence]
    ON [glam-datasets] ([source], [publisher], [format], [licence]);