crimelog
281 rows where outcome = "Unfounded" and year = 2020 sorted by datetime descending
This data as json, CSV (advanced)
Suggested facets: datetime (date)
title >30 ✖
- DRUG INCIDENT 162
- PARTY/GATHERING 49
- ALARM CONDITION 16
- BURGLAR ALARM 8
- FIRE ALARM 5
- LOUD MUSIC 4
- ASSIST AGENCY 3
- ASSIST POLICE POLICE 3
- ODOR INVESTIGATION 3
- AREA PATROL 2
- DESTRUCTION OF PROPERTY 2
- PANIC ALARM 2
- SUSPICIOUS EVENT 2
- ANIMAL COMPLAINT 1
- ASSIST EMS POLICE 1
- ASSIST FIRE DEPT POLICE 1
- ASSIST PERSON POLICE 1
- BURGLARY 1
- DISTURBANCE 1
- FIGHT 1
- FOPA, 52, FOOT PATROL 1
- FRAUD 1
- HIT AND RUN 1
- HUMANE COMPLAINT 1
- IDENTITY THEFT 1
- INFORMATION REPORT 1
- LARCENY 1
- LARCENY FROM A VEHICLE 1
- LOUD PARTY 1
- RECKLESS DRIVING 1
- …
Link | rowid | id | title | year | datetime ▲ | building | address | outcome |
---|---|---|---|---|---|---|---|---|
6248 | 6248 | #20-03652 | DRUG INCIDENT | 2020 | 2020-12-28 19:21:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
6109 | 6109 | #20-03648 | BURGLAR ALARM | 2020 | 2020-12-24 19:18:00 | WVU SUNCREST EXECUTIVE PLAZA 2 | 1075 VAN VOORHIS RD, MORGANTOWN, WV 26501 | Unfounded |
6099 | 6099 | #20-03637 | IDENTITY THEFT | 2020 | 2020-12-21 17:09:00 | WVU POLICE DEPARTMENT | 992 ELMER PRINCE DR, MORGANTOWN, WV | Unfounded |
6100 | 6100 | #20-03636 | ASSIST AGENCY | 2020 | 2020-12-21 17:00:00 | WVU OAKLAND HALL | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
6036 | 6036 | #20-03569 | BURGLAR ALARM | 2020 | 2020-12-09 17:43:00 | 150 PROSPECT ST, MORGANTOWN, WV 26501 | Unfounded | |
6042 | 6042 | #20-03562 | BURGLAR ALARM | 2020 | 2020-12-08 21:35:00 | 150 PROSPECT ST, MORGANTOWN, WV 26501 | Unfounded | |
5992 | 5992 | #20-03525 | ALARM CONDITION | 2020 | 2020-12-02 07:31:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Unfounded |
5990 | 5990 | #20-03524 | ALARM CONDITION | 2020 | 2020-12-01 15:09:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Unfounded |
6155 | 6155 | #PS20-01357 | ANIMAL COMPLAINT | 2020 | 2020-11-30 16:27:00 | PSC SOFTBALL FIELD | 39.439099, -78.985940 | Unfounded |
5963 | 5963 | #20-03466 | DRUG INCIDENT | 2020 | 2020-11-20 20:11:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5494 | 5494 | #20-03452 | DRUG INCIDENT | 2020 | 2020-11-19 21:29:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Unfounded |
5498 | 5498 | #20-03448 | ALARM CONDITION | 2020 | 2020-11-19 15:27:00 | WVU ART MUSEUM OF WVU | 2 FINE ARTS DR, MORGANTOWN, WV | Unfounded |
5484 | 5484 | #20-03437 | ALARM CONDITION | 2020 | 2020-11-18 15:10:00 | WVU ART MUSEUM OF WVU | 2 FINE ARTS DR, MORGANTOWN, WV | Unfounded |
5474 | 5474 | #20-03429 | DRUG INCIDENT | 2020 | 2020-11-17 17:19:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Unfounded |
6188 | 6188 | #PS20-01309 | ODOR INVESTIGATION | 2020 | 2020-11-16 23:15:00 | PSC FRIEND HALL | 165 CAMPUS DR, KEYSER, WV 26726 | Unfounded |
5465 | 5465 | #20-03426 | DRUG INCIDENT | 2020 | 2020-11-16 22:54:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
5467 | 5467 | #20-03424 | ASSIST EMS POLICE | 2020 | 2020-11-16 19:26:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Unfounded |
5470 | 5470 | #20-03418 | DRUG INCIDENT | 2020 | 2020-11-15 22:58:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Unfounded |
5471 | 5471 | #20-03417 | DRUG INCIDENT | 2020 | 2020-11-15 21:32:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Unfounded |
5426 | 5426 | #20-03415 | DRUG INCIDENT | 2020 | 2020-11-15 11:56:00 | WVU OAKLAND HALL-EAST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
5429 | 5429 | #20-03411 | DRUG INCIDENT | 2020 | 2020-11-15 03:22:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5436 | 5436 | #20-03404 | DRUG INCIDENT | 2020 | 2020-11-14 20:07:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Unfounded |
5449 | 5449 | #20-03389 | DRUG INCIDENT | 2020 | 2020-11-13 23:57:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Unfounded |
5974 | 5974 | #20-03440 | DRUG INCIDENT | 2020 | 2020-11-13 22:11:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5452 | 5452 | #20-03386 | PARTY/GATHERING | 2020 | 2020-11-13 21:57:00 | ALPHA GAMMA RHO FRATERENITY | 201 BELMAR AVE, MORGANTOWN, WV | Unfounded |
5454 | 5454 | #20-03384 | DRUG INCIDENT | 2020 | 2020-11-13 20:23:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
5455 | 5455 | #20-03383 | DRUG INCIDENT | 2020 | 2020-11-13 20:08:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5456 | 5456 | #20-03382 | DRUG INCIDENT | 2020 | 2020-11-13 18:56:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Unfounded |
5412 | 5412 | #20-03377 | DRUG INCIDENT | 2020 | 2020-11-12 23:26:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
5413 | 5413 | #20-03376 | DRUG INCIDENT | 2020 | 2020-11-12 23:18:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
5460 | 5460 | #20-03375 | DRUG INCIDENT | 2020 | 2020-11-12 22:58:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Unfounded |
5417 | 5417 | #20-03371 | DRUG INCIDENT | 2020 | 2020-11-12 18:29:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
5483 | 5483 | #20-03438 | SUSPICIOUS EVENT | 2020 | 2020-11-11 11:08:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5397 | 5397 | #20-03352 | BURGLAR ALARM | 2020 | 2020-11-10 21:33:00 | WVU MINERAL RESOURCES BUILDING | 401 EVANSDALE DR, MORGANTOWN, WV | Unfounded |
5399 | 5399 | #20-03350 | DRUG INCIDENT | 2020 | 2020-11-10 20:34:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5402 | 5402 | #20-03347 | ALARM CONDITION | 2020 | 2020-11-10 17:10:00 | WVU ART MUSEUM OF WVU | 2 FINE ARTS DR, MORGANTOWN, WV | Unfounded |
5403 | 5403 | #20-03343 | DRUG INCIDENT | 2020 | 2020-11-10 10:13:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
5378 | 5378 | #20-03340 | DRUG INCIDENT | 2020 | 2020-11-09 17:33:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
5337 | 5337 | #20-03335 | DRUG INCIDENT | 2020 | 2020-11-08 23:13:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
5382 | 5382 | #20-03332 | DRUG INCIDENT | 2020 | 2020-11-08 14:35:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
5383 | 5383 | #20-03331 | PARTY/GATHERING | 2020 | 2020-11-08 01:37:00 | PI KAPPA PHI FRATERNITY | 650 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Unfounded |
5343 | 5343 | #20-03318 | DRUG INCIDENT | 2020 | 2020-11-07 15:12:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
5348 | 5348 | #20-03313 | PARTY/GATHERING | 2020 | 2020-11-07 00:52:00 | ALPHA SIGMA PHI FRATERNITY | 200 BELMAR AVE, MORGANTOWN, WV 26501 | Unfounded |
5350 | 5350 | #20-03311 | PARTY/GATHERING | 2020 | 2020-11-07 00:09:00 | LAMBDA CHI ALPHA FRATERNITY | 670 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
5321 | 5321 | #20-03291 | DRUG INCIDENT | 2020 | 2020-11-05 23:09:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
5310 | 5310 | #20-03274 | DRUG INCIDENT | 2020 | 2020-11-04 20:06:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
6231 | 6231 | #PS20-01244 | ODOR INVESTIGATION | 2020 | 2020-11-04 20:05:00 | PSC UNIVERSITY PLACE | 20 ARNOLD ST, KEYSER, WV 26726 | Unfounded |
5304 | 5304 | #20-03257 | DRUG INCIDENT | 2020 | 2020-11-03 20:11:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Unfounded |
5305 | 5305 | #20-03256 | DRUG INCIDENT | 2020 | 2020-11-03 19:47:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5300 | 5300 | #20-03249 | ASSIST PERSON POLICE | 2020 | 2020-11-02 15:42:00 | WVU MILAN PUSKAR CENTER | 1 ERRETT RODGERS DR, MORGANTOWN, WV | Unfounded |
5301 | 5301 | #20-03248 | ASSIST AGENCY | 2020 | 2020-11-02 15:41:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
5266 | 5266 | #20-03227 | DRUG INCIDENT | 2020 | 2020-10-31 23:58:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Unfounded |
6242 | 6242 | #PS20-01227 | ODOR INVESTIGATION | 2020 | 2020-10-31 01:30:00 | PSC UNIVERSITY PLACE | 20 ARNOLD ST, KEYSER, WV 26726 | Unfounded |
5275 | 5275 | #20-03215 | DISTURBANCE | 2020 | 2020-10-30 23:38:00 | ALPHA SIGMA PHI FRATERNITY | 200 BELMAR AVE, MORGANTOWN, WV 26501 | Unfounded |
5241 | 5241 | #20-03196 | PARTY/GATHERING | 2020 | 2020-10-29 23:34:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
5297 | 5297 | #20-03191 | DRUG INCIDENT | 2020 | 2020-10-29 23:06:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5015 | 5015 | #20-03177 | DRUG INCIDENT | 2020 | 2020-10-28 17:50:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
5016 | 5016 | #20-03176 | FIRE ALARM | 2020 | 2020-10-28 14:34:00 | WVU MILAN PUSKAR CENTER | 1 ERRETT RODGERS DR, MORGANTOWN, WV | Unfounded |
5008 | 5008 | #20-03161 | DRUG INCIDENT | 2020 | 2020-10-27 12:42:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Unfounded |
5023 | 5023 | #20-03151 | DRUG INCIDENT | 2020 | 2020-10-25 15:59:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
4975 | 4975 | #20-03133 | LOUD PARTY | 2020 | 2020-10-23 23:44:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Unfounded |
4984 | 4984 | #20-03123 | DRUG INCIDENT | 2020 | 2020-10-23 21:33:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Unfounded |
4949 | 4949 | #20-03110 | DRUG INCIDENT | 2020 | 2020-10-22 20:58:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
4922 | 4922 | #20-03086 | DRUG INCIDENT | 2020 | 2020-10-20 21:12:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
4923 | 4923 | #20-03085 | DRUG INCIDENT | 2020 | 2020-10-20 21:08:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
4889 | 4889 | #20-03062 | DRUG INCIDENT | 2020 | 2020-10-18 19:02:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
4891 | 4891 | #20-03060 | PARTY/GATHERING | 2020 | 2020-10-18 15:41:00 | WVU REC CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Unfounded |
4911 | 4911 | #20-03039 | PARTY/GATHERING | 2020 | 2020-10-16 21:27:00 | 224 BELMAR AVE, MORGANTOWN, WV 26501 | Unfounded | |
4915 | 4915 | #20-03035 | DRUG INCIDENT | 2020 | 2020-10-16 14:51:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
4880 | 4880 | #20-03033 | DRUG INCIDENT | 2020 | 2020-10-15 21:07:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
4875 | 4875 | #20-03020 | ASSIST FIRE DEPT POLICE | 2020 | 2020-10-14 14:56:00 | STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Unfounded |
4860 | 4860 | #20-03018 | DRUG INCIDENT | 2020 | 2020-10-13 20:11:00 | WVU LYON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
4862 | 4862 | #20-03016 | AREA PATROL | 2020 | 2020-10-13 14:22:00 | Price Street, MORGANTOWN, WV 26501 | Unfounded | |
4853 | 4853 | #20-03009 | DRUG INCIDENT | 2020 | 2020-10-12 17:11:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Unfounded |
4828 | 4828 | #20-02981 | PARTY/GATHERING | 2020 | 2020-10-10 17:02:00 | 650 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Unfounded | |
4830 | 4830 | #20-02979 | PARTY/GATHERING | 2020 | 2020-10-10 02:08:00 | THETA CHI FRATERNITY | 692 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
4835 | 4835 | #20-02974 | PARTY/GATHERING | 2020 | 2020-10-10 01:44:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
4831 | 4831 | #20-02978 | PARTY/GATHERING | 2020 | 2020-10-09 23:53:00 | SIGMA ALPHA EPSILON FRATERNITY | 117 BELMAR AVE, MORGANTOWN, WV 26501 | Unfounded |
4845 | 4845 | #20-02964 | DRUG INCIDENT | 2020 | 2020-10-09 17:05:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
4802 | 4802 | #20-02954 | DRUG INCIDENT | 2020 | 2020-10-08 23:28:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
4792 | 4792 | #20-02948 | DRUG INCIDENT | 2020 | 2020-10-07 20:57:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
4858 | 4858 | #20-02940 | ROBBERY | 2020 | 2020-10-07 03:28:00 | mountaineer station, MORGANTOWN, WV 26501 | Unfounded | |
4779 | 4779 | #20-02939 | DRUG INCIDENT | 2020 | 2020-10-06 22:11:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
4781 | 4781 | #20-02935 | DRUG INCIDENT | 2020 | 2020-10-06 20:41:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Unfounded |
4759 | 4759 | #20-02924 | DRUG INCIDENT | 2020 | 2020-10-05 20:39:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
4762 | 4762 | #20-02921 | DRUG INCIDENT | 2020 | 2020-10-05 16:07:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
4767 | 4767 | #20-02916 | DRUG INCIDENT | 2020 | 2020-10-05 14:34:00 | WVU OAKLAND HALL-EAST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
4769 | 4769 | #20-02913 | DESTRUCTION OF PROPERTY | 2020 | 2020-10-05 13:43:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
4774 | 4774 | #20-02907 | DRUG INCIDENT | 2020 | 2020-10-05 00:14:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Unfounded |
4732 | 4732 | #20-02895 | DRUG INCIDENT | 2020 | 2020-10-03 21:03:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
4741 | 4741 | #20-02886 | DRUG INCIDENT | 2020 | 2020-10-03 02:45:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Unfounded |
4752 | 4752 | #20-02874 | DRUG INCIDENT | 2020 | 2020-10-02 13:17:00 | WVU OAKLAND HALL-EAST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Unfounded |
4755 | 4755 | #20-02870 | DRUG INCIDENT | 2020 | 2020-10-02 00:04:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
4704 | 4704 | #20-02862 | DRUG INCIDENT | 2020 | 2020-09-30 22:59:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
4711 | 4711 | #20-02851 | DRUG INCIDENT | 2020 | 2020-09-30 01:55:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
4684 | 4684 | #20-02836 | DRUG INCIDENT | 2020 | 2020-09-28 19:07:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Unfounded |
4664 | 4664 | #20-02815 | PARTY/GATHERING | 2020 | 2020-09-26 18:38:00 | FRAT ROW | 500 N HIGH ST, MORGANTOWN, WV | Unfounded |
4665 | 4665 | #20-02814 | PARTY/GATHERING | 2020 | 2020-09-26 15:59:00 | WVU VANDALIA HALL GOLD | 49 FALLING RUN RD, MORGANTOWN, WV 26501 | Unfounded |
4668 | 4668 | #20-02810 | PARTY/GATHERING | 2020 | 2020-09-26 01:42:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
4672 | 4672 | #20-02803 | PARTY/GATHERING | 2020 | 2020-09-25 19:01:00 | PHI SIGMA KAPPA FRATERNITY | 672 NORTH HIGH ST, MORGANTOWN, WV 26501 | Unfounded |
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 );