rAudioExposureEvent
29 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | startDate | endDate | value | sourceName | sourceVersion | device | creationDate | metadata_HKMetadataKeyAudioExposureLevel |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2022-09-24 03:49:24 +0100 | 2022-09-24 03:52:09 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-09-24 03:52:09 +0100 | 91.135 dBASPL |
| 2 | 2 | 2022-09-24 04:13:59 +0100 | 2022-09-24 04:16:44 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-09-24 04:16:44 +0100 | 91.5763 dBASPL |
| 3 | 3 | 2022-09-27 07:18:04 +0100 | 2022-09-27 07:20:54 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-09-27 07:20:54 +0100 | 90.0265 dBASPL |
| 4 | 4 | 2022-09-27 20:09:40 +0100 | 2022-09-27 20:12:35 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-09-27 20:12:35 +0100 | 93.0044 dBASPL |
| 5 | 5 | 2022-09-28 08:37:33 +0100 | 2022-09-28 08:40:13 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-09-28 08:40:13 +0100 | 92.3604 dBASPL |
| 6 | 6 | 2022-09-29 09:45:58 +0100 | 2022-09-29 09:48:48 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-09-29 09:48:48 +0100 | 93.4303 dBASPL |
| 7 | 7 | 2022-09-29 10:32:28 +0100 | 2022-09-29 10:35:08 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-09-29 10:35:08 +0100 | 95.0109 dBASPL |
| 8 | 8 | 2022-10-04 21:54:26 +0100 | 2022-10-04 21:57:21 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-10-04 21:57:21 +0100 | 95.1637 dBASPL |
| 9 | 9 | 2022-10-04 22:44:36 +0100 | 2022-10-04 22:47:31 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282a80>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 2022-10-04 22:47:31 +0100 | 107.448 dBASPL |
| 10 | 10 | 2022-10-12 20:01:59 +0100 | 2022-10-12 20:04:54 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-12 20:04:54 +0100 | 91.8846 dBASPL |
| 11 | 11 | 2022-10-13 20:50:12 +0100 | 2022-10-13 20:52:57 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-13 20:52:57 +0100 | 90.3975 dBASPL |
| 12 | 12 | 2022-10-13 21:33:17 +0100 | 2022-10-13 21:36:02 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-13 21:36:02 +0100 | 93.4363 dBASPL |
| 13 | 13 | 2022-10-13 22:09:47 +0100 | 2022-10-13 22:12:27 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-13 22:12:27 +0100 | 98.2266 dBASPL |
| 14 | 14 | 2022-10-13 22:48:47 +0100 | 2022-10-13 22:51:37 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-13 22:51:37 +0100 | 98.8804 dBASPL |
| 15 | 15 | 2022-10-13 23:19:37 +0100 | 2022-10-13 23:22:17 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-13 23:22:17 +0100 | 94.7544 dBASPL |
| 16 | 16 | 2022-10-14 20:40:08 +0100 | 2022-10-14 20:42:53 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-14 20:42:53 +0100 | 90.1615 dBASPL |
| 17 | 17 | 2022-10-22 14:15:11 +0100 | 2022-10-22 14:18:01 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-22 14:18:01 +0100 | 101.813 dBASPL |
| 18 | 18 | 2022-10-22 15:27:31 +0100 | 2022-10-22 15:30:11 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282d50>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0.2> | 2022-10-22 15:30:11 +0100 | 90.6208 dBASPL |
| 19 | 19 | 2022-10-28 18:23:21 +0100 | 2022-10-28 18:26:16 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-10-28 18:26:16 +0100 | 90.0098 dBASPL |
| 20 | 20 | 2022-10-28 19:36:51 +0100 | 2022-10-28 19:39:46 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-10-28 19:39:46 +0100 | 90.0668 dBASPL |
| 21 | 21 | 2022-11-02 20:02:44 +0100 | 2022-11-02 20:05:29 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-11-02 20:05:29 +0100 | 90.3331 dBASPL |
| 22 | 22 | 2022-11-10 21:34:05 +0100 | 2022-11-10 21:36:55 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-11-10 21:36:55 +0100 | 94.9362 dBASPL |
| 23 | 23 | 2022-11-17 20:04:31 +0100 | 2022-11-17 20:07:21 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-11-17 20:07:21 +0100 | 99.2416 dBASPL |
| 24 | 24 | 2022-11-18 19:10:22 +0100 | 2022-11-18 19:13:02 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-11-18 19:13:02 +0100 | 92.9033 dBASPL |
| 25 | 25 | 2022-11-19 22:02:07 +0100 | 2022-11-19 22:04:57 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-11-19 22:04:57 +0100 | 92.8356 dBASPL |
| 26 | 26 | 2022-12-10 16:49:50 +0100 | 2022-12-10 16:52:40 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-12-10 16:52:40 +0100 | 98.577 dBASPL |
| 27 | 27 | 2022-12-10 17:22:05 +0100 | 2022-12-10 17:24:55 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-12-10 17:24:55 +0100 | 91.4897 dBASPL |
| 28 | 28 | 2022-12-17 23:28:43 +0100 | 2022-12-17 23:31:28 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282282b70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.1> | 2022-12-17 23:31:28 +0100 | 90.3082 dBASPL |
| 29 | 29 | 2022-12-26 22:54:32 +0100 | 2022-12-26 22:57:22 +0100 | HKCategoryValueEnvironmentalAudioExposureEventMomentaryLimit | jerWatch | 1 | <<HKDevice: 0x282280fa0>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.2> | 2022-12-26 22:57:22 +0100 | 90.1255 dBASPL |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [rAudioExposureEvent] ( [startDate] TEXT, [endDate] TEXT, [value] TEXT, [sourceName] TEXT, [sourceVersion] TEXT, [device] TEXT, [creationDate] TEXT, [metadata_HKMetadataKeyAudioExposureLevel] TEXT );