crimelog
8,152 rows where outcome = "Closed - Resolved" sorted by datetime descending
This data as json, CSV (advanced)
title >30 ✖
- ASSIST EMS POLICE 641
- FIRE ALARM 552
- ALARM CONDITION 420
- AREA PATROL 326
- VEHICLE ACCIDENT 225
- TALK WITH OFFICER 217
- WELFARE CHECK 210
- UNSECURE BUILDING 171
- ASSIST AGENCY 147
- PROP ALARM 126
- BURGLAR ALARM 124
- K9 DETAIL 114
- DRUG INCIDENT 106
- ASSIST POLICE POLICE 99
- INFORMATION REPORT 97
- PARTY/GATHERING 90
- BODYCAM 83
- FOUND PROPERTY 82
- SUSPICIOUS EVENT 79
- SUSPICIOUS PERSON 79
- FOPA, 52, FOOT PATROL 78
- ASSIST FIRE DEPT POLICE 71
- ABCC VIOLATION 64
- ELEVATOR RESCUE 61
- PANIC ALARM 53
- DESTRUCTION OF PROPERTY 51
- ADMIN DETAIL POLICE 48
- SUICIDE THREAT 43
- MISC POLICE 31
- TRESPASSING 31
- …
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
12890 | 12890 | #22-03193 | SUSPICIOUS PERSON | 2022 | 2022-12-06 15:27:00 | WVU WISE LIBRARY | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12893 | 12893 | #22-03187 | VEHICLE ACCIDENT | 2022 | 2022-12-06 10:31:00 | WVU FACILITIES MANAGEMENT BUILDING | RAWLEY LN, MORGANTOWN, WV | Closed - Resolved |
12894 | 12894 | #22-03185 | WELFARE CHECK | 2022 | 2022-12-06 06:19:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12941 | 12941 | #22-03272 | LOST PROPERTY | 2022 | 2022-12-05 18:00:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12878 | 12878 | #22-03180 | BACK TICKET TOW | 2022 | 2022-12-05 10:36:00 | WVU Area 11 | 39.634018, -79.956813, MORGANTOWN | Closed - Resolved |
12879 | 12879 | #SR22-03179 | FIRE ALARM | 2022 | 2022-12-05 10:29:00 | WVU MOUNTAINLAIR PARKING GARAGE | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
12880 | 12880 | #22-03178 | ASSIST EMS POLICE | 2022 | 2022-12-05 10:09:00 | WVU OAKLAND HALL-EAST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12882 | 12882 | #22-03175 | ASSIST EMS POLICE | 2022 | 2022-12-05 07:48:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12884 | 12884 | #22-03173 | SUSPICIOUS EVENT | 2022 | 2022-12-05 02:37:00 | SIGMA CHI FRATERNITY | N HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12883 | 12883 | #SR22-03174 | FIRE ALARM | 2022 | 2022-12-05 02:15:00 | WVU CHEMISTRY RESEARCH LABORATORY | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
12885 | 12885 | #22-03172 | FIRE ALARM | 2022 | 2022-12-05 02:15:00 | WVU CHEMISTRY RESEARCH LABORATORY | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
12886 | 12886 | #SR22-03171 | ELEVATOR RESCUE | 2022 | 2022-12-05 02:06:00 | WVU BRAXTON TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12854 | 12854 | #SR22-03170 | FIRE ALARM | 2022 | 2022-12-04 21:28:00 | WVU REYNOLDS HALL | BEECHURST AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12856 | 12856 | #SR22-03168 | PROP ALARM | 2022 | 2022-12-04 14:19:00 | WVU UNIVERSITY PARK APARTMENTS - WEST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12858 | 12858 | #SR22-03166 | PROP ALARM | 2022 | 2022-12-04 10:46:00 | WVU VANDALIA HALL GOLD | FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
12864 | 12864 | #22-03160 | ASSIST EMS POLICE | 2022 | 2022-12-03 11:34:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12865 | 12865 | #22-03159 | PROP ALARM | 2022 | 2022-12-03 03:47:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12871 | 12871 | #22-03153 | ASSIST EMS POLICE | 2022 | 2022-12-02 19:11:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
12873 | 12873 | #22-03151 | WELFARE CHECK | 2022 | 2022-12-02 11:47:00 | WVU BOREMAN NORTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12874 | 12874 | #22-03150 | ASSIST EMS POLICE | 2022 | 2022-12-02 10:33:00 | WVU HODGES HALL | HOUGH ST, MORGANTOWN, WV | Closed - Resolved |
12875 | 12875 | #22-03149 | ARGUMENT | 2022 | 2022-12-02 02:05:00 | WVU SENECA HALL | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12844 | 12844 | #22-03147 | SUICIDE THREAT | 2022 | 2022-12-01 22:31:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12847 | 12847 | #22-03144 | WELFARE CHECK | 2022 | 2022-12-01 16:25:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12850 | 12850 | #22-03139 | WELFARE CHECK | 2022 | 2022-12-01 12:51:00 | WEST RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved | |
12851 | 12851 | #22-03138 | UNSECURE BUILDING | 2022 | 2022-12-01 10:40:00 | WVU ARNOLD HALL | PRICE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12849 | 12849 | #22-03141 | FOUND PROPERTY | 2022 | 2022-12-01 10:37:00 | WVU ARNOLD HALL | PRICE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12852 | 12852 | #22-03137 | ASSIST EMS POLICE | 2022 | 2022-12-01 02:14:00 | WVU VANDALIA HALL BLUE | FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
12831 | 12831 | #22-03134 | FIRE ALARM | 2022 | 2022-11-30 19:22:00 | WVU MOUNTAINEER STATION | VAN VOORHIS RD, MORGANTOWN, WV | Closed - Resolved |
12835 | 12835 | #22-03130 | ALARM CONDITION | 2022 | 2022-11-30 14:49:00 | WVU ART MUSEUM OF WVU | FINE ARTS DR, MORGANTOWN, WV | Closed - Resolved |
12836 | 12836 | #22-03129 | WELFARE CHECK | 2022 | 2022-11-30 13:32:00 | WVU UNIVERSITY PLACE TOWNHOMES SOUTH | GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12838 | 12838 | #SR22-03127 | ASSIST FIRE DEPT POLICE | 2022 | 2022-11-30 12:26:00 | WVU PRESIDENTS HOUSE | RIVERVIEW DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12837 | 12837 | #22-03128 | TALK WITH OFFICER | 2022 | 2022-11-30 12:11:00 | WVU STUDENT SERVICES | COLLEGE AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12840 | 12840 | #SR22-03125 | PROP ALARM | 2022 | 2022-11-30 08:26:00 | WVU UNIVERSITY PLACE NORTH | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12843 | 12843 | #SR22-03122 | UNSECURE BUILDING | 2022 | 2022-11-30 01:41:00 | WVU CHEMISTRY RESEARCH LABORATORY | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
12821 | 12821 | #22-03119 | AUTO TAMPERING | 2022 | 2022-11-29 22:04:00 | WVU BRAXTON TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12823 | 12823 | #22-03117 | ALARM CONDITION | 2022 | 2022-11-29 19:16:00 | WVU STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12826 | 12826 | #22-03114 | ASSIST EMS POLICE | 2022 | 2022-11-29 11:02:00 | WVU HODGES HALL | HOUGH ST, MORGANTOWN, WV | Closed - Resolved |
12827 | 12827 | #SR22-03113 | ASSIST FIRE DEPT POLICE | 2022 | 2022-11-29 09:25:00 | WVU BOREMAN RFL FACILITY | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12828 | 12828 | #22-03112 | FOUND PROPERTY | 2022 | 2022-11-29 05:57:00 | WVU POLICE DEPARTMENT | ELMER PRINCE DR, MORGANTOWN, WV | Closed - Resolved |
12810 | 12810 | #22-03111 | ASSIST EMS POLICE | 2022 | 2022-11-28 20:48:00 | WVU HONORS HALL | SECOND ST, MORGANTOWN, WV | Closed - Resolved |
12811 | 12811 | #SR22-03110 | ELEVATOR RESCUE | 2022 | 2022-11-28 20:05:00 | WVU BRAXTON TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12812 | 12812 | #22-03108 | UNSECURE BUILDING | 2022 | 2022-11-28 14:07:00 | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved | |
12829 | 12829 | #22-03109 | SUSPICIOUS EVENT | 2022 | 2022-11-28 13:27:00 | NORTH SPRUCE ST, MORGANTOWN | Closed - Resolved | |
12815 | 12815 | #SR22-03105 | PROP ALARM | 2022 | 2022-11-28 08:23:00 | WVU UNIVERSITY PLACE NORTH | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12816 | 12816 | #22-03104 | PROP ALARM | 2022 | 2022-11-28 07:48:00 | WVU UNIVERSITY PLACE NORTH | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12805 | 12805 | #22-03101 | MISC POLICE | 2022 | 2022-11-27 21:20:00 | WVU OAKLAND HALL-WEST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12818 | 12818 | #SR22-03102 | UNSECURE BUILDING | 2022 | 2022-11-27 21:05:00 | WVU CHEMISTRY RESEARCH LABORATORY | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
12806 | 12806 | #22-03100 | VEHICLE ACCIDENT | 2022 | 2022-11-27 16:40:00 | WVU UNIVERSITY PLACE PARKING GARAGE | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12793 | 12793 | #22-03092 | PANIC ALARM | 2022 | 2022-11-21 18:46:00 | WVU STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12795 | 12795 | #22-03090 | FOUND PROPERTY | 2022 | 2022-11-21 13:43:00 | WVU SHORT TERM 10 (B&E LOOP) | 39.637487, -79.953285, MORGANTOWN, WV 26501 | Closed - Resolved |
12797 | 12797 | #22-03088 | ASSIST EMS POLICE | 2022 | 2022-11-21 09:22:00 | WVU DENTAL CARE | SUNCREST TOWN CENTRE DR, MORGANTOWN, WV | Closed - Resolved |
12766 | 12766 | #22-03084 | ASSIST EMS POLICE | 2022 | 2022-11-20 10:52:00 | WVU BRAXTON TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12767 | 12767 | #22-03083 | FIRE ALARM | 2022 | 2022-11-20 08:31:00 | WVU CHEMISTRY RESEARCH LABORATORY | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
12768 | 12768 | #SR22-03082 | PROP ALARM | 2022 | 2022-11-20 07:41:00 | WVU UNIVERSITY PLACE NORTH | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12769 | 12769 | #22-03081 | ASSIST EMS POLICE | 2022 | 2022-11-20 01:57:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
12770 | 12770 | #SR22-03080 | PROP ALARM | 2022 | 2022-11-19 23:36:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
12772 | 12772 | #22-03078 | ASSIST EMS POLICE | 2022 | 2022-11-19 16:51:00 | STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12773 | 12773 | #22-03077 | ASSIST EMS POLICE | 2022 | 2022-11-19 16:38:00 | STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12799 | 12799 | #22-03073 | MISC POLICE | 2022 | 2022-11-19 11:33:00 | WVU STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12804 | 12804 | #22-03070 | ASSIST EMS POLICE | 2022 | 2022-11-19 07:40:00 | WVU STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12780 | 12780 | #22-03068 | FIRE ALARM | 2022 | 2022-11-18 23:36:00 | WVU CHEM LAB | PROSPECT ST, MORGANTOWN, WV | Closed - Resolved |
12783 | 12783 | #22-03065 | ALARM CONDITION | 2022 | 2022-11-18 17:04:00 | WVU WISE LIBRARY | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12782 | 12782 | #22-03066 | TALK WITH OFFICER | 2022 | 2022-11-18 17:02:00 | WVU POLICE DEPARTMENT | ELMER PRINCE DR, MORGANTOWN, WV | Closed - Resolved |
12785 | 12785 | #22-03063 | TALK WITH OFFICER | 2022 | 2022-11-18 13:07:00 | WVU POLICE DEPARTMENT | ELMER PRINCE DR, MORGANTOWN, WV | Closed - Resolved |
12787 | 12787 | #22-03061 | ALARM CONDITION | 2022 | 2022-11-18 07:45:00 | WVU ART MUSEUM OF WVU | FINE ARTS DR, MORGANTOWN, WV | Closed - Resolved |
12752 | 12752 | #22-03054 | ASSIST EMS POLICE | 2022 | 2022-11-17 18:26:00 | WVU VANDALIA HALL GOLD | FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
12753 | 12753 | #22-03053 | FIRE ALARM | 2022 | 2022-11-17 18:18:00 | WVU REYNOLDS HALL | BEECHURST AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12757 | 12757 | #22-03049 | TRESPASSING | 2022 | 2022-11-17 13:23:00 | , MORGANTOWN | Closed - Resolved | |
12759 | 12759 | #22-03046 | FOUND PROPERTY | 2022 | 2022-11-17 07:58:00 | WVU SUMMIT HALL | GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12739 | 12739 | #SR22-03039 | ELEVATOR RESCUE | 2022 | 2022-11-16 18:44:00 | WVU SUMMIT HALL | GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12740 | 12740 | #22-03038 | SUICIDE ATTEMPT | 2022 | 2022-11-16 18:31:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12742 | 12742 | #SR22-03036 | PROP ALARM | 2022 | 2022-11-16 17:21:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
12743 | 12743 | #22-03035 | WELFARE CHECK | 2022 | 2022-11-16 15:59:00 | NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved | |
12745 | 12745 | #SR22-03033 | PROP ALARM | 2022 | 2022-11-16 08:06:00 | WVU UNIVERSITY PLACE NORTH | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12747 | 12747 | #SR22-03031 | PROP ALARM | 2022 | 2022-11-16 00:45:00 | WVU UNIVERSITY PLACE NORTH | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12720 | 12720 | #22-03030 | SUICIDE THREAT | 2022 | 2022-11-15 23:26:00 | WVU LAW SCHOOL | LAW CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12721 | 12721 | #22-03029 | ASSIST EMS POLICE | 2022 | 2022-11-15 21:51:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
12722 | 12722 | #22-03028 | DRUG INCIDENT | 2022 | 2022-11-15 20:08:00 | WVU HONORS HALL | SECOND ST, MORGANTOWN, WV | Closed - Resolved |
12723 | 12723 | #22-03027 | ASSIST EMS POLICE | 2022 | 2022-11-15 19:53:00 | WVU COLISEUM | JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12724 | 12724 | #22-03026 | ASSIST EMS POLICE | 2022 | 2022-11-15 18:09:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12725 | 12725 | #22-03025 | SUSPICIOUS EVENT | 2022 | 2022-11-15 18:06:00 | WVU REYNOLDS HALL | BEECHURST AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12728 | 12728 | #22-03022 | WELFARE CHECK | 2022 | 2022-11-15 12:54:00 | WVU POLICE DEPARTMENT | ELMER PRINCE DR, MORGANTOWN, WV | Closed - Resolved |
12729 | 12729 | #22-03021 | LOST PROPERTY | 2022 | 2022-11-15 11:45:00 | WVU EISLAND HALL | HOUGH ST, MORGANTOWN, WV | Closed - Resolved |
12710 | 12710 | #22-03016 | ASSIST EMS POLICE | 2022 | 2022-11-14 21:33:00 | WVU REC CENTER | REC CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12713 | 12713 | #22-03013 | ASSIST EMS POLICE | 2022 | 2022-11-14 14:29:00 | WVU BENNETT TOWER | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12716 | 12716 | #22-03010 | ASSIST FIRE DEPT POLICE | 2022 | 2022-11-14 12:20:00 | WVU SUMMIT HALL | GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12715 | 12715 | #22-03011 | ASSIST EMS POLICE | 2022 | 2022-11-14 12:16:00 | WVU ENGINEERING SCIENCES BLDG | EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12718 | 12718 | #22-03008 | ALARM CONDITION | 2022 | 2022-11-14 08:20:00 | HEALTH SCIENCE CENTER | MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12682 | 12682 | #22-03001 | ASSIST EMS POLICE | 2022 | 2022-11-13 01:43:00 | WVU COLISEUM | JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12683 | 12683 | #22-03000 | TALK WITH OFFICER | 2022 | 2022-11-12 23:34:00 | WVU BOREMAN SOUTH | NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
12687 | 12687 | #22-02996 | ASSIST EMS POLICE | 2022 | 2022-11-12 17:59:00 | COLLEGE PARK | NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
12688 | 12688 | #22-02995 | ALARM CONDITION | 2022 | 2022-11-12 17:52:00 | WVU WISE LIBRARY | UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
12690 | 12690 | #22-02993 | ASSIST EMS POLICE | 2022 | 2022-11-12 16:56:00 | BELMAR AVE, MORGANTOWN | Closed - Resolved | |
12733 | 12733 | #22-02992 | ASSIST EMS POLICE | 2022 | 2022-11-12 14:34:00 | WVU STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12748 | 12748 | #22-02988 | ASSIST EMS POLICE | 2022 | 2022-11-12 12:20:00 | CAPERTON INDOOR FACILITY | ERRETT RODGERS DR, MORGANTOWN, WV | Closed - Resolved |
12694 | 12694 | #22-02987 | ASSIST EMS POLICE | 2022 | 2022-11-12 12:19:00 | WVU MOUNTAINEER STATION | VAN VOORHIS RD, MORGANTOWN, WV | Closed - Resolved |
12695 | 12695 | #22-02986 | ABCC VIOLATION | 2022 | 2022-11-12 12:15:00 | STADIUM DR, MORGANTOWN, WV 26501 | Closed - Resolved | |
12696 | 12696 | #22-02985 | ABCC VIOLATION | 2022 | 2022-11-12 12:06:00 | BLUE LOT | STADIUM DR, MORGANTOWN, WV | Closed - Resolved |
12686 | 12686 | #22-02997 | MISC POLICE | 2022 | 2022-11-12 09:36:00 | STADIUM | ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
12698 | 12698 | #22-02982 | FIRE ALARM | 2022 | 2022-11-12 03:20:00 | WVU MILAN PUSKAR CENTER | ERRETT RODGERS DR, MORGANTOWN, WV | Closed - Resolved |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [crimelog] ( [id] TEXT, [title] TEXT, [year] TEXT, [datetime] TEXT, [building] TEXT, [address] TEXT, [outcome] TEXT );