crimelog
8,175 rows where outcome = "Closed - Resolved"
This data as json, CSV (advanced)
Suggested facets: year, datetime (date)
| Link | rowid ▼ | id | title | year | datetime | building | address | outcome |
|---|---|---|---|---|---|---|---|---|
| 3 | 3 | #19-05434 | VEHICLE ACCIDENT | 2019 | 2019-12-19 16:53:00 | PI KAPPA ALPHA FRATERNITY | 112 WAVERLY ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 4 | 4 | #19-05431 | BURGLAR ALARM | 2019 | 2019-12-19 10:30:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 10 | 10 | #19-05425 | TALK WITH OFFICER | 2019 | 2019-12-13 23:46:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 13 | 13 | #19-05422 | ASSIST EMS POLICE | 2019 | 2019-12-18 14:43:00 | WVU ARMSTRONG HALL | 94 BEECHURST AVE, MORGANTOWN, WV | Closed - Resolved |
| 19 | 19 | #19-05416 | TRESPASSING | 2019 | 2019-12-17 18:23:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
| 31 | 31 | #19-05403 | BURGLAR ALARM | 2019 | 2019-12-17 11:49:00 | WVU STUDENT RECREATION CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 32 | 32 | #19-05402 | BURGLAR ALARM | 2019 | 2019-12-17 11:26:00 | WVU MINERAL RESOURCES BUILDING | 401 EVANSDALE DR, MORGANTOWN, WV | Closed - Resolved |
| 34 | 34 | #19-05400 | FIRE ALARM | 2019 | 2019-12-17 06:37:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 36 | 36 | #19-05398 | FIGHT | 2019 | 2019-12-16 16:52:00 | WVU STUDENT RECREATION CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 37 | 37 | #19-05395 | FIRE ALARM | 2019 | 2019-12-16 12:07:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 38 | 38 | #19-05394 | ASSIST EMS POLICE | 2019 | 2019-12-16 10:11:00 | 80 NEWTON AVE, MORGANTOWN, WV 26501 | Closed - Resolved | |
| 39 | 39 | #19-05393 | ASSIST EMS POLICE | 2019 | 2019-12-16 09:28:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 41 | 41 | #19-05391 | MISC POLICE | 2019 | 2019-12-15 16:10:00 | 1550 UNIVERSITY AVE Mountainlair, MORGANTOWN, WV | Closed - Resolved | |
| 43 | 43 | #19-05389 | ASSIST POLICE POLICE | 2019 | 2019-12-15 12:41:00 | 10008 WILLEY ST, MORGANTOWN | Closed - Resolved | |
| 44 | 44 | #19-05388 | ASSIST EMS POLICE | 2019 | 2019-12-15 07:22:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Closed - Resolved |
| 58 | 58 | #19-05374 | FIRE ALARM | 2019 | 2019-12-14 20:50:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 62 | 62 | #19-05370 | SUICIDE THREAT | 2019 | 2019-12-14 02:56:00 | WVU OAKLAND HALL-EAST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 64 | 64 | #19-05368 | ASSIST EMS POLICE | 2019 | 2019-12-14 02:54:00 | WVU BUSINESS AND ECONOMICS BUILDING | 1601 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 65 | 65 | #19-05367 | PANIC ALARM | 2019 | 2019-12-14 01:38:00 | WVU EVANSDALE CROSSING | 62 MORRILL WAY, MORGANTOWN, WV | Closed - Resolved |
| 69 | 69 | #19-05363 | SUSPICIOUS PERSON | 2019 | 2019-12-13 16:31:00 | WVU MOUNTAINEER STATION | 1112 VAN VOORHIS RD, MORGANTOWN, WV | Closed - Resolved |
| 76 | 76 | #19-05356 | ASSIST EMS POLICE | 2019 | 2019-12-13 17:21:00 | WVU MOUNTAINEER STATION | 1112 VAN VOORHIS RD, MORGANTOWN, WV | Closed - Resolved |
| 79 | 79 | #19-05353 | ASSIST EMS POLICE | 2019 | 2019-12-13 14:54:00 | WVU UNIVERSITY PARK APARTMENTS - EAST | 480 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 80 | 80 | #19-05352 | LOST PROPERTY | 2019 | 2019-12-13 14:08:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 81 | 81 | #19-05351 | ASSIST AGENCY | 2019 | 2019-12-13 03:25:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
| 85 | 85 | #19-05347 | SUSPICIOUS EVENT | 2019 | 2019-12-12 21:39:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 89 | 89 | #19-05343 | ASSIST EMS POLICE | 2019 | 2019-12-12 18:29:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 90 | 90 | #19-05342 | LOUD PARTY | 2019 | 2019-12-07 02:24:00 | WVU BOREMAN NORTH | 602 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 91 | 91 | #19-05340 | TALK WITH OFFICER | 2019 | 2019-12-12 09:20:00 | WVU ERICKSON ALUMNI CENTER | 1 ALUMNI DR, MORGANTOWN, WV | Closed - Resolved |
| 109 | 109 | #19-05322 | ASSIST AGENCY | 2019 | 2019-12-11 10:14:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 116 | 116 | #19-05315 | TALK WITH OFFICER | 2019 | 2019-12-11 05:11:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 117 | 117 | #19-05314 | UNSECURE BUILDING | 2019 | 2019-12-11 03:31:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 124 | 124 | #19-05306 | ASSIST EMS POLICE | 2019 | 2019-12-10 14:03:00 | WVU DENTAL CARE | 451 SUNCREST TOWN CENTRE DR, MORGANTOWN, WV | Closed - Resolved |
| 125 | 125 | #19-05305 | ASSIST EMS POLICE | 2019 | 2019-12-10 14:12:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 126 | 126 | #19-05304 | TALK WITH OFFICER | 2019 | 2019-12-10 13:34:00 | WVU ALLEN HALL | 355 OAKLAND ST, MORGANTOWN, WV | Closed - Resolved |
| 127 | 127 | #19-05303 | TRAFFIC STOP, 1054 | 2019 | 2019-12-10 13:42:00 | ADVANCE AUTO PARTS MON BLVD | 830 MONONGAHELA BLVD, MORGANTOWN, WV | Closed - Resolved |
| 128 | 128 | #19-05301 | ASSIST EMS POLICE | 2019 | 2019-12-10 11:44:00 | WVU LIFE SCIENCES BUILDING | 53 CAMPUS DR, MORGANTOWN, WV | Closed - Resolved |
| 140 | 140 | #19-05289 | TALK WITH OFFICER | 2019 | 2019-12-09 16:52:00 | WVU WHITE HALL | 135 WILLEY ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 142 | 142 | #19-05287 | VEHICLE ACCIDENT | 2019 | 2019-12-09 13:35:00 | WESTERN AVE, MORGANTOWN, WV 26501 | Closed - Resolved | |
| 145 | 145 | #19-05284 | ASSIST POLICE POLICE | 2019 | 2019-12-09 10:29:00 | CHICK FIL A | 334 PATTESON DR, MORGANTOWN, WV | Closed - Resolved |
| 149 | 149 | #19-05280 | ASSIST EMS POLICE | 2019 | 2019-12-09 08:50:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 150 | 150 | #19-05279 | ASSIST EMS POLICE | 2019 | 2019-12-06 08:39:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 152 | 152 | #19-05277 | WELFARE CHECK | 2019 | 2019-12-09 06:09:00 | WVU SUMMIT HALL | 211 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 158 | 158 | #19-05271 | ASSIST EMS POLICE | 2019 | 2019-12-08 20:25:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Closed - Resolved |
| 161 | 161 | #19-05268 | DRUG INCIDENT | 2019 | 2019-12-08 16:37:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 162 | 162 | #19-05267 | ALARM CONDITION | 2019 | 2019-12-08 15:23:00 | WVU LAW SCHOOL | 1 LAW CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 169 | 169 | #19-05259 | FIRE ALARM | 2019 | 2019-12-07 22:34:00 | WVU BOREMAN RFL GARAGE | 617 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 172 | 172 | #19-05256 | ARGUMENT | 2019 | 2019-12-07 20:03:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 175 | 175 | #19-05253 | FIRE ALARM | 2019 | 2019-12-07 16:52:00 | WVU BOREMAN RFL GARAGE | 617 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 176 | 176 | #19-05252 | DRUG OVERDOSE | 2019 | 2019-12-07 15:00:00 | WVU MOUNTAINEER STATION | 1112 VAN VOORHIS RD, MORGANTOWN, WV | Closed - Resolved |
| 179 | 179 | #19-05248 | WELFARE CHECK | 2019 | 2019-12-07 04:35:00 | COLLEGE PARK | 60 NEWTON AVE, MORGANTOWN, WV | Closed - Resolved |
| 187 | 187 | #19-05240 | WELFARE CHECK | 2019 | 2019-12-06 23:17:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 189 | 189 | #19-05238 | ELEVATOR RESCUE | 2019 | 2019-12-06 23:13:00 | WVU VANDALIA HALL GOLD | 49 FALLING RUN RD, MORGANTOWN, WV 26501 | Closed - Resolved |
| 192 | 192 | #19-05235 | ASSIST EMS POLICE | 2019 | 2019-12-06 22:35:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 194 | 194 | #19-05233 | ASSIST EMS POLICE | 2019 | 2019-12-06 22:02:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 197 | 197 | #19-05230 | ASSIST EMS POLICE | 2019 | 2019-12-06 21:05:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 198 | 198 | #19-05229 | ASSIST EMS POLICE | 2019 | 2019-12-06 19:00:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Closed - Resolved |
| 202 | 202 | #19-05221 | LARCENY | 2019 | 2019-12-06 08:20:00 | WVU BROOKS HALL | 98 BEECHURST AVE, MORGANTOWN, WV | Closed - Resolved |
| 203 | 203 | #19-05220 | FLOODED STRUCTURE | 2019 | 2019-12-06 03:25:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 209 | 209 | #19-05214 | ASSIST EMS POLICE | 2019 | 2019-12-05 23:25:00 | WVU BRAXTON TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 210 | 210 | #19-05213 | FIRE ALARM | 2019 | 2019-12-05 23:07:00 | WVU BOREMAN RFL FACILITY | 617 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 215 | 215 | #19-05207 | FIRE ALARM | 2019 | 2019-12-05 19:24:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 216 | 216 | #19-05206 | ASSIST EMS POLICE | 2019 | 2019-12-05 18:41:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 217 | 217 | #19-05205 | TALK WITH OFFICER | 2019 | 2019-12-05 17:23:00 | WVU STUDENT HEALTH BUILDING | 390 Birch St, MORGANTOWN, WV 26501 | Closed - Resolved |
| 219 | 219 | #19-05203 | ASSIST EMS POLICE | 2019 | 2019-12-05 16:47:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 223 | 223 | #19-05199 | TALK WITH OFFICER | 2019 | 2019-12-05 09:15:00 | WVU SHORT TERM 7 ( SUNNYSIDE) | 39.637549, -79.955584, MORGANTOWN, WV 26501 | Closed - Resolved |
| 224 | 224 | #19-05198 | ALARM CONDITION | 2019 | 2019-12-05 13:40:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 226 | 226 | #19-05196 | SUSPICIOUS EVENT | 2019 | 2019-12-05 08:45:00 | WVU ONE WATERFRONT PLACE | 1 WATERFRONT PL, MORGANTOWN, WV | Closed - Resolved |
| 228 | 228 | #19-05194 | BURGLAR ALARM | 2019 | 2019-12-05 10:13:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 229 | 229 | #19-05193 | WELFARE CHECK | 2019 | 2019-12-04 21:10:00 | WVU HONORS HALL | 250 SECOND ST, MORGANTOWN, WV | Closed - Resolved |
| 234 | 234 | #19-05188 | ASSIST EMS POLICE | 2019 | 2019-12-04 16:40:00 | WVU BUSINESS AND ECONOMICS BUILDING | 1601 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 237 | 237 | #19-05185 | ASSIST EMS POLICE | 2019 | 2019-12-04 15:08:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 252 | 252 | #19-05168 | ASSIST EMS POLICE | 2019 | 2019-12-03 11:21:00 | WVU PRT STATION-BEECHURST AVE | 96 BEECHURST AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 261 | 261 | #19-05159 | BURGLAR ALARM | 2019 | 2019-12-02 13:06:00 | WVU LAW SCHOOL | 1 LAW CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 262 | 262 | #19-05158 | ASSIST EMS POLICE | 2019 | 2019-12-02 12:46:00 | WVU MOUNTAIN LAIR | 1550 UNIVERSITY AVE, MORGANTOWN, WV | Closed - Resolved |
| 270 | 270 | #19-05150 | ASSIST EMS POLICE | 2019 | 2019-12-01 21:43:00 | WVU BROOKE TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 271 | 271 | #19-05149 | DRUG INCIDENT | 2019 | 2019-12-01 21:19:00 | WVU LINCOLN HALL | 1014 RAWLEY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 276 | 276 | #19-05208 | TALK WITH OFFICER | 2019 | 2019-11-23 16:26:00 | WVU OAKLAND HALL-EAST | 438 OAKLAND ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 279 | 279 | #19-05141 | VEHICLE ACCIDENT | 2019 | 2019-11-29 16:33:00 | FAMILY HOUSE DR, MORGANTOWN, WV 26501 | Closed - Resolved | |
| 280 | 280 | #19-05140 | BURGLAR ALARM | 2019 | 2019-11-29 13:09:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 282 | 282 | #19-05138 | INFORMATION REPORT | 2019 | 2019-11-27 14:28:00 | WVU SHORT TERM 4 (REC CENTER) | 39.647516,-79.971475, MORGANTOWN, WV 26501 | Closed - Resolved |
| 283 | 283 | #19-05137 | ASSIST EMS POLICE | 2019 | 2019-11-27 14:16:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 284 | 284 | #19-05136 | BURGLAR ALARM | 2019 | 2019-11-27 12:46:00 | WVU STUDENT RECREATION CENTER | 2001 REC CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 285 | 285 | #19-05135 | MISC POLICE | 2019 | 2019-11-23 09:19:00 | WVU POLICE DEPARTMENT | 992 ELMER PRINCE DR, MORGANTOWN, WV | Closed - Resolved |
| 287 | 287 | #19-05132 | ALARM CONDITION | 2019 | 2019-11-26 08:15:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 288 | 288 | #19-05131 | ALARM CONDITION | 2019 | 2019-11-26 07:46:00 | HEALTH SCIENCE CENTER | 64 MEDICAL CENTER DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 292 | 292 | #19-05126 | ALARM CONDITION | 2019 | 2019-11-25 10:14:00 | WVU ART MUSEUM OF WVU | 2 FINE ARTS DR, MORGANTOWN, WV | Closed - Resolved |
| 293 | 293 | #19-05125 | FIRE ALARM | 2019 | 2019-11-25 09:14:00 | WVU ENGINEERING SCIENCES BLDG | 395 EVANSDALE DR, MORGANTOWN, WV | Closed - Resolved |
| 296 | 296 | #19-05122 | ASSIST EMS POLICE | 2019 | 2019-11-24 03:42:00 | WVU UNIVERSITY PLACE NORTH | 2161 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 298 | 298 | #19-05120 | DOMESTIC DISPUTE | 2019 | 2019-11-23 18:13:00 | WVU BENNETT TOWER | 356 EVANSDALE DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 300 | 300 | #19-05118 | ASSIST EMS POLICE | 2019 | 2019-11-23 13:38:00 | WVU STADIUM | 3 ERRETT RODGERS DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 304 | 304 | #19-05114 | ASSIST EMS POLICE | 2019 | 2019-11-23 12:07:00 | BROWN LOT | 0 LAW CENTER DR, MORGANTOWN, WV | Closed - Resolved |
| 306 | 306 | #19-05111 | ASSIST FIRE DEPT POLICE | 2019 | 2019-11-23 01:10:00 | WVU BOREMAN RFL GARAGE | 617 NORTH SPRUCE ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 309 | 309 | #19-05108 | ASSIST EMS POLICE | 2019 | 2019-11-22 22:59:00 | WVU COLISEUM | 11 JERRY WEST DR, MORGANTOWN, WV 26501 | Closed - Resolved |
| 310 | 310 | #19-05107 | DRUG INCIDENT | 2019 | 2019-11-22 18:32:00 | WVU SENECA HALL | 2151 UNIVERSITY AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 312 | 312 | #19-05104 | ASSIST EMS POLICE | 2019 | 2019-11-22 11:24:00 | WVU STUDENT HEALTH BUILDING | 390 BIRCH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 318 | 318 | #19-05098 | TALK WITH OFFICER | 2019 | 2019-11-22 02:13:00 | WVU BOREMAN SOUTH | 600 NORTH HIGH ST, MORGANTOWN, WV 26501 | Closed - Resolved |
| 326 | 326 | #19-05090 | DESTRUCTION OF PROPERTY | 2019 | 2019-11-21 23:46:00 | WVU DADISMAN HALL | 693 NORTH HIGH ST, MORGANTOWN, WV | Closed - Resolved |
| 331 | 331 | #19-05085 | FIRE ALARM | 2019 | 2019-11-21 17:49:00 | WVU UNIVERSITY PLACE TOWNHOMES NORTH | 256 GRANT AVE, MORGANTOWN, WV 26501 | Closed - Resolved |
| 333 | 333 | #19-05083 | WELFARE CHECK | 2019 | 2019-11-21 17:21:00 | 331 BEECHURST AVE UNIT 133A, MORGANTOWN, WV 26501 | Closed - Resolved | |
| 334 | 334 | #19-05082 | VEHICLE ACCIDENT | 2019 | 2019-11-21 11:30:00 | WVU POLICE DEPARTMENT | 992 ELMER PRINCE 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 );