crimelog
2,485 rows where outcome = "Clear by Warning" sorted by building
This data as json, CSV (advanced)
Suggested facets: datetime (date)
title >30 ✖
- TRAFFIC STOP, 1054 1,563
- ABCC VIOLATION 489
- DRUG INCIDENT 152
- PUBLIC INTOX 132
- ASSIST EMS POLICE 32
- TRESPASSING 24
- PARTY/GATHERING 16
- SUSPICIOUS PERSON 9
- VEHICLE ACCIDENT 8
- DISTURBANCE 6
- LOUD PARTY 5
- SUSPICIOUS EVENT 4
- HIT AND RUN 3
- TRAFFIC PROBLEM 3
- UNDERAGE POSSESSION 3
- ALARM CONDITION 2
- AREA PATROL 2
- ARGUMENT 2
- HARASSMENT 2
- INDECENT EXPOSURE 2
- LOUD MUSIC 2
- LOUD NOISE 2
- OPEN CONTAINER 2
- ASSIST AGENCY 1
- ASSIST AGENCY FIRE 1
- ASSIST EMS FIRE 1
- BATTERY 1
- BREAKING AND ENTERING 1
- ELEVATOR RESCUE 1
- EMERGENCY PHONE 1
- …
Link | rowid | id | title | year | datetime | building ▼ | address | outcome |
---|---|---|---|---|---|---|---|---|
3046 | 3046 | #20-01501 | PARTY/GATHERING | 2020 | 2020-05-02 22:59:00 | 310 SECOND ST UNIT A, MORGANTOWN, WV 26501 | Clear by Warning | |
3048 | 3048 | #20-01499 | PARTY/GATHERING | 2020 | 2020-05-02 20:10:00 | 565 PRICE ST UNIT 1, MORGANTOWN, WV 26501 | Clear by Warning | |
3052 | 3052 | #20-01495 | PARTY/GATHERING | 2020 | 2020-05-02 16:46:00 | 299 WILES ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3075 | 3075 | #20-01527 | TRAFFIC STOP, 1054 | 2020 | 2020-05-09 22:20:00 | PROSPECT ST / NORTH SPRUCE ST, MORGANTOWN | Clear by Warning | |
3085 | 3085 | #20-01535 | TRAFFIC STOP, 1054 | 2020 | 2020-05-12 23:06:00 | UNIVERSITY AVE / SECOND ST, MORGANTOWN | Clear by Warning | |
3091 | 3091 | #20-01549 | TRAFFIC STOP, 1054 | 2020 | 2020-05-17 01:47:00 | UNIVERSITY AVE / FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning | |
3094 | 3094 | #20-01546 | TRAFFIC STOP, 1054 | 2020 | 2020-05-16 20:51:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3120 | 3120 | #20-01542 | TRAFFIC STOP, 1054 | 2020 | 2020-05-15 00:52:00 | STEWART ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3128 | 3128 | #20-01591 | TRAFFIC STOP, 1054 | 2020 | 2020-05-24 21:50:00 | UNIVERSITY AVE / FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning | |
3131 | 3131 | #20-01588 | TRAFFIC STOP, 1054 | 2020 | 2020-05-24 19:54:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3142 | 3142 | #20-01572 | TRAFFIC STOP, 1054 | 2020 | 2020-05-22 01:10:00 | WILLEY ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3144 | 3144 | #20-01593 | TRAFFIC STOP, 1054 | 2020 | 2020-05-25 17:19:00 | 54 CLAY ST, MORGANTOWN | Clear by Warning | |
3146 | 3146 | #20-01599 | TRAFFIC STOP, 1054 | 2020 | 2020-05-26 16:40:00 | PROSPECT ST / PRICE ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3151 | 3151 | #20-01594 | ASSIST EMS POLICE | 2020 | 2020-05-25 20:15:00 | NORTH HIGH ST / MAIDEN LN, MORGANTOWN, WV 26501 | Clear by Warning | |
3158 | 3158 | #20-01622 | PUBLIC INTOX | 2020 | 2020-05-31 02:34:00 | UNIVERSITY AVE / Ensign Ave, MORGANTOWN | Clear by Warning | |
3160 | 3160 | #20-01619 | TRAFFIC STOP, 1054 | 2020 | 2020-05-30 18:01:00 | UNIVERSITY AVE / HOUGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3167 | 3167 | #20-01610 | TRAFFIC STOP, 1054 | 2020 | 2020-05-29 02:14:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3177 | 3177 | #20-01616 | PUBLIC INTOX | 2020 | 2020-05-30 02:22:00 | NORTH HIGH ST / MAIDEN LN, MORGANTOWN, WV 26501 | Clear by Warning | |
3178 | 3178 | #20-01634 | TRAFFIC STOP, 1054 | 2020 | 2020-06-02 20:55:00 | 1 LAW CENTER DR / UNIVERSITY AVE, MORGANTOWN | Clear by Warning | |
3183 | 3183 | #20-01629 | TRAFFIC STOP, 1054 | 2020 | 2020-06-01 23:02:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3190 | 3190 | #20-01649 | TRAFFIC STOP, 1054 | 2020 | 2020-06-07 02:42:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3192 | 3192 | #20-01647 | TRAFFIC STOP, 1054 | 2020 | 2020-06-06 04:21:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3198 | 3198 | #20-01641 | TRAFFIC STOP, 1054 | 2020 | 2020-06-05 01:21:00 | WILLEY ST / UNIVERSITY AVE, MORGANTOWN | Clear by Warning | |
3201 | 3201 | #20-01621 | TRAFFIC STOP, 1054 | 2020 | 2020-05-30 21:46:00 | HIGH ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3219 | 3219 | #20-01661 | TRAFFIC STOP, 1054 | 2020 | 2020-06-11 00:22:00 | UNIVERSITY AVE / EIGHTH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3226 | 3226 | #20-01691 | TRAFFIC STOP, 1054 | 2020 | 2020-06-14 20:56:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3231 | 3231 | #20-01686 | TRAFFIC STOP, 1054 | 2020 | 2020-06-14 00:33:00 | BEECHURST AVE / HOUGH ST, MORGANTOWN | Clear by Warning | |
3232 | 3232 | #20-01685 | TRAFFIC STOP, 1054 | 2020 | 2020-06-13 22:48:00 | COLLEGE AVE / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3237 | 3237 | #20-01677 | TRAFFIC STOP, 1054 | 2020 | 2020-06-13 03:41:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3238 | 3238 | #20-01676 | TRAFFIC STOP, 1054 | 2020 | 2020-06-13 02:56:00 | COLLEGE AVE / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3239 | 3239 | #20-01675 | TRAFFIC STOP, 1054 | 2020 | 2020-06-13 01:09:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3240 | 3240 | #20-01674 | TRAFFIC STOP, 1054 | 2020 | 2020-06-12 23:17:00 | UNIVERSITY AVE / COLLEGE AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3244 | 3244 | #20-01668 | TRAFFIC STOP, 1054 | 2020 | 2020-06-12 01:04:00 | WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3246 | 3246 | #20-01698 | TRAFFIC STOP, 1054 | 2020 | 2020-06-15 22:05:00 | FAYETTE ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3250 | 3250 | #20-01731 | TRAFFIC STOP, 1054 | 2020 | 2020-06-22 22:41:00 | UNIVERSITY AVE / FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning | |
3256 | 3256 | #20-01725 | TRAFFIC STOP, 1054 | 2020 | 2020-06-22 00:35:00 | MEDICAL CENTER DR / ELMER PRINCE DR, MORGANTOWN, WV 26501 | Clear by Warning | |
3260 | 3260 | #20-01721 | TRAFFIC STOP, 1054 | 2020 | 2020-06-21 02:48:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3262 | 3262 | #20-01718 | TRAFFIC STOP, 1054 | 2020 | 2020-06-21 01:13:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3264 | 3264 | #20-01714 | TRAFFIC STOP, 1054 | 2020 | 2020-06-20 17:14:00 | HOUSTON DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3267 | 3267 | #20-01710 | TRAFFIC STOP, 1054 | 2020 | 2020-06-20 01:05:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3268 | 3268 | #20-01709 | TRAFFIC STOP, 1054 | 2020 | 2020-06-20 00:32:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3270 | 3270 | #20-01707 | TRAFFIC STOP, 1054 | 2020 | 2020-06-19 21:55:00 | NORTH SPRUCE ST / WILES ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3285 | 3285 | #20-01732 | TRAFFIC STOP, 1054 | 2020 | 2020-06-23 01:15:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3288 | 3288 | #20-01742 | TRAFFIC STOP, 1054 | 2020 | 2020-06-25 22:16:00 | UNIVERSITY AVE / DILLE ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3290 | 3290 | #20-01767 | TRAFFIC STOP, 1054 | 2020 | 2020-06-28 12:42:00 | NEWTON AVE / STANTON AVE, MORGANTOWN, WV 26505 | Clear by Warning | |
3292 | 3292 | #20-01764 | TRAFFIC STOP, 1054 | 2020 | 2020-06-27 21:56:00 | WILLEY ST / NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3293 | 3293 | #20-01763 | TRAFFIC STOP, 1054 | 2020 | 2020-06-27 21:29:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3300 | 3300 | #20-01755 | TRAFFIC STOP, 1054 | 2020 | 2020-06-27 00:50:00 | UNIVERSITY AVE / CAMPUS DR, MORGANTOWN, WV 26501 | Clear by Warning | |
3302 | 3302 | #20-01753 | TRAFFIC STOP, 1054 | 2020 | 2020-06-27 00:07:00 | CAMPUS DR / WILLEY ST, MORGANTOWN | Clear by Warning | |
3303 | 3303 | #20-01752 | TRAFFIC STOP, 1054 | 2020 | 2020-06-26 23:02:00 | WILLEY ST / NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3304 | 3304 | #20-01751 | TRAFFIC STOP, 1054 | 2020 | 2020-06-26 21:43:00 | WILLEY ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3305 | 3305 | #20-01750 | TRAFFIC STOP, 1054 | 2020 | 2020-06-26 21:01:00 | WILLEY ST / HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3312 | 3312 | #20-01743 | TRAFFIC STOP, 1054 | 2020 | 2020-06-26 01:18:00 | BEECHURST AVE / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3317 | 3317 | #20-01769 | TRAFFIC STOP, 1054 | 2020 | 2020-06-28 22:39:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3318 | 3318 | #20-01768 | TRAFFIC STOP, 1054 | 2020 | 2020-06-28 21:49:00 | WILLEY ST / NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3322 | 3322 | #20-01717 | TRAFFIC STOP, 1054 | 2020 | 2020-06-20 22:10:00 | PROSPECT ST / NORTH HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3324 | 3324 | #20-01778 | TRAFFIC STOP, 1054 | 2020 | 2020-07-01 22:41:00 | UNIVERSITY AVE / EVANSDALE DR, MORGANTOWN, WV 26501 | Clear by Warning | |
3330 | 3330 | #20-01779 | TRAFFIC STOP, 1054 | 2020 | 2020-07-02 01:29:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3332 | 3332 | #20-01806 | TRAFFIC STOP, 1054 | 2020 | 2020-07-05 21:58:00 | UNIVERSITY AVE / FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning | |
3338 | 3338 | #20-01797 | TRAFFIC STOP, 1054 | 2020 | 2020-07-05 00:25:00 | NORTH HIGH ST / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3339 | 3339 | #20-01796 | TRAFFIC STOP, 1054 | 2020 | 2020-07-05 00:23:00 | UNIVERSITY AVE / CAMPUS DR, MORGANTOWN, WV 26501 | Clear by Warning | |
3341 | 3341 | #20-01794 | TRAFFIC STOP, 1054 | 2020 | 2020-07-04 16:32:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3343 | 3343 | #20-01791 | TRAFFIC STOP, 1054 | 2020 | 2020-07-03 23:05:00 | UNIVERSITY AVE / COLLEGE AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3344 | 3344 | #20-01789 | PUBLIC INTOX | 2020 | 2020-07-03 19:06:00 | PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3348 | 3348 | #20-01785 | TRAFFIC STOP, 1054 | 2020 | 2020-07-03 02:57:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3349 | 3349 | #20-01784 | TRAFFIC STOP, 1054 | 2020 | 2020-07-03 02:43:00 | UNIVERSITY AVE / THIRD ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3368 | 3368 | #20-01819 | TRAFFIC STOP, 1054 | 2020 | 2020-07-09 01:15:00 | UNIVERSITY AVE / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3373 | 3373 | #20-01842 | TRAFFIC STOP, 1054 | 2020 | 2020-07-12 02:53:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN | Clear by Warning | |
3374 | 3374 | #20-01841 | TRAFFIC STOP, 1054 | 2020 | 2020-07-12 02:16:00 | CAMPUS DR / BEECHURST AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3375 | 3375 | #20-01840 | TRAFFIC STOP, 1054 | 2020 | 2020-07-12 01:12:00 | UNIVERSITY AVE / FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning | |
3379 | 3379 | #20-01833 | TRAFFIC STOP, 1054 | 2020 | 2020-07-11 02:03:00 | UNIVERSITY AVE / FALLING RUN RD, MORGANTOWN, WV 26501 | Clear by Warning | |
3380 | 3380 | #20-01832 | TRAFFIC STOP, 1054 | 2020 | 2020-07-11 01:23:00 | CAMPUS DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3384 | 3384 | #20-01828 | TRAFFIC STOP, 1054 | 2020 | 2020-07-10 04:06:00 | RIVERVIEW DR / UNIVERSITY AVE, WESTOVER | Clear by Warning | |
3386 | 3386 | #20-01826 | TRAFFIC STOP, 1054 | 2020 | 2020-07-10 01:28:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3402 | 3402 | #20-01872 | TRAFFIC STOP, 1054 | 2020 | 2020-07-19 19:01:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3403 | 3403 | #20-01871 | TRAFFIC STOP, 1054 | 2020 | 2020-07-19 01:05:00 | PRICE ST / PROSPECT ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3406 | 3406 | #20-01866 | TRAFFIC STOP, 1054 | 2020 | 2020-07-17 20:43:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3415 | 3415 | #20-01873 | TRAFFIC STOP, 1054 | 2020 | 2020-07-20 08:22:00 | PROSPECT ST / HIGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3419 | 3419 | #20-01790 | TRAFFIC STOP, 1054 | 2020 | 2020-07-03 22:04:00 | FALLING RUN RD / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3444 | 3444 | #20-01914 | TRAFFIC STOP, 1054 | 2020 | 2020-07-26 22:19:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3448 | 3448 | #20-01910 | TRAFFIC STOP, 1054 | 2020 | 2020-07-26 04:41:00 | UNIVERSITY AVE / law school drive, MORGANTOWN | Clear by Warning | |
3449 | 3449 | #20-01909 | TRAFFIC STOP, 1054 | 2020 | 2020-07-26 01:31:00 | PROSPECT ST / NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3450 | 3450 | #20-01908 | TRAFFIC STOP, 1054 | 2020 | 2020-07-25 23:18:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3451 | 3451 | #20-01907 | TRAFFIC STOP, 1054 | 2020 | 2020-07-25 21:02:00 | NORTH HIGH ST / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3452 | 3452 | #20-01906 | TRAFFIC STOP, 1054 | 2020 | 2020-07-25 20:12:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3456 | 3456 | #20-01902 | TRAFFIC STOP, 1054 | 2020 | 2020-07-24 21:34:00 | UNIVERSITY AVE / HOUGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3457 | 3457 | #20-01901 | TRAFFIC STOP, 1054 | 2020 | 2020-07-24 16:49:00 | UNIVERSITY AVE / CAMPUS DR, MORGANTOWN, WV 26501 | Clear by Warning | |
3461 | 3461 | #20-01897 | TRAFFIC STOP, 1054 | 2020 | 2020-07-24 00:57:00 | BEECHURST AVE / HOUGH ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3484 | 3484 | #20-01939 | TRAFFIC STOP, 1054 | 2020 | 2020-08-01 18:31:00 | UNIVERSITY AVE / THIRD ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3488 | 3488 | #20-01934 | TRAFFIC STOP, 1054 | 2020 | 2020-07-31 00:30:00 | UNIVERSITY AVE / THIRD ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3494 | 3494 | #20-01669 | ARGUMENT | 2020 | 2020-06-12 01:24:00 | SPRUCE ST / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3509 | 3509 | #20-01957 | TRAFFIC STOP, 1054 | 2020 | 2020-08-06 03:04:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3520 | 3520 | #PS20-00602 | TRAFFIC STOP, 1054 | 2020 | 2020-05-24 22:07:00 | Mineral St, Keyser, WV 26726 | Clear by Warning | |
3557 | 3557 | #20-01983 | TRAFFIC STOP, 1054 | 2020 | 2020-08-09 01:34:00 | PROSPECT ST / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning | |
3571 | 3571 | #20-01969 | ASSIST EMS POLICE | 2020 | 2020-08-08 00:41:00 | 60 NEWTON AVE, MORGANTOWN | Clear by Warning | |
3572 | 3572 | #20-01968 | TRAFFIC STOP, 1054 | 2020 | 2020-08-08 00:13:00 | UNIVERSITY AVE / FALLING RUN RD, MORGANTOWN | Clear by Warning | |
3574 | 3574 | #20-01966 | TRAFFIC STOP, 1054 | 2020 | 2020-08-07 23:26:00 | UNIVERSITY AVE / CAMPUS DR, MORGANTOWN, WV 26501 | Clear by Warning | |
3578 | 3578 | #20-01962 | TRAFFIC STOP, 1054 | 2020 | 2020-08-07 01:08:00 | UNIVERSITY AVE / WILLEY ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3581 | 3581 | #20-02003 | TRAFFIC STOP, 1054 | 2020 | 2020-08-10 22:35:00 | WILLEY ST / SPRUCE ST, MORGANTOWN, WV 26501 | Clear by Warning | |
3588 | 3588 | #20-01990 | TRAFFIC STOP, 1054 | 2020 | 2020-08-09 22:40:00 | CAMPUS DR / UNIVERSITY AVE, MORGANTOWN, WV 26501 | Clear by Warning |
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 );