crimelog

11 rows where outcome = "Handled by Hospital Security "

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date)

Link rowid ▼ id title year datetime building address outcome
15401 15401 CRS23-02028 Clery - Hospital Security 2023 2023-08-09 13:33:00 RUBY MEMORIAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
15409 15409 CRS23-02155 Clery - Hospital Security 2023 2023-08-18 18:11:00 RUBY HOSPITAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
15413 15413 CRS23-02159 Clery - Hospital Security 2023 2023-08-21 00:45:00 RUBY HOSPITAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
15631 15631 CRS23-02294 Clery - Hospital Security 2023 2023-08-26 20:51:00 RUBY HOSPITAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
16187 16187 CRS23-02878 Clery - Hospital Security 2023 2023-10-04 18:14:00 RUBY MEMORIAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
16320 16320 CRS23-03007 Clery - Hospital Security 2023 2023-10-18 14:15:00 RUBY MEMORIAL HOSPITAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
17420 17420 CRS24-00440 Clery - Hospital Security 2024 2024-02-03 15:41:00 RUBY HOSPITAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
17886 17886 CRS24-00924 Clery - Hospital Security 2024 2024-03-21 19:33:00   1 MEDICAL CENTER DR, MORGANTOWN, WV 26501 Handled by Hospital Security
17887 17887 CRS24-00926 Clery - Hospital Security 2024 2024-03-25 12:26:00 RUBY MEMORIAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
18218 18218 CRS24-01257 Clery - Hospital Security 2024 2024-04-22 20:00:00 RUBY MEMORIAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security
18420 18420 CRS24-01471 Clery - Hospital Security 2024 2024-05-07 23:58:00 RUBY MEMORIAL 81 STADIUM DR, MORGANTOWN, WV 26501 Handled by Hospital Security

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [crimelog] (
   [id] TEXT,
   [title] TEXT,
   [year] TEXT,
   [datetime] TEXT,
   [building] TEXT,
   [address] TEXT,
   [outcome] TEXT
);