glam-datasets
1 row where dataset_issued = "2014-06-24T03:03:45.073887", "file_created" is on date 2018-09-04 and format = "JSON"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date), file_modified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 400 | 400 | TB Home applications 1923 to 1932 | Queensland State Archives | web@archives.qld.gov.au | 2014-06-24T03:03:45.073887 | 2022-06-28T06:47:38.987377 | This index was compiled from the correspondence kept by the [Queensland War Council](https://www.arc… | data.qld.gov.au | https://data.qld.gov.au/dataset/e866f868-e11c-4fce-9df7-365b1b8b3452 | TB Home applications 1923 to 1932 JSON | https://www.data.qld.gov.au/dataset/e866f868-e11c-4fce-9df7-365b1b8b3452/resource/c7205e2a-bafe-4961-9056-37d98d281e94/download/tb-home-applications-1923-1932.json | JSON | This open data file lists the names of returned soldiers suffering from TB who applied to the Queens… | 2018-09-04T05:37:13.928481 | 2018-09-04T05:37:13.841362 | 58880.0 | Creative Commons Attribution 4.0 |
Advanced export
JSON shape: default, array, newline-delimited
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]);