1,228 rows

View and edit SQL

Suggested facets: type

Link rowid date type description city
1 20180115 robbery A Man Dressed as Spider-Man Is on a Robbery Spree NYC
2 20180115 murder Life? Dont talk to me about life. Albany
3 20180115 murder Mama, I killed a man, put a gun against his head... Reno
5 20180215 murder Someone killed the guard! He took an arrow to the knee! SQL City
6 20180115 theft Big Bully stole my lunch money! Chicago
7 20180115 fraud Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Seattle
8 20170712 theft A lone hunter stalks the night, firing arrows into the Darkness. There is no hiding, no escape. In the distance, the beast falters, tethered to the void. The killing blow comes without hesitation, without mercy. SQL City
9 20170820 arson Wield the Hammer of Sol with honor, Titan, it is a thing of legend, both past and future. SQL City
10 20171110 robbery The Gjallarhorn shoulder-mounted rocket system was forged from the armor of Guardians who fell at the Twilight Gap. Gifted to the survivors of that terrible battle, the Gjallarhorn is seen as a symbol of honor and survival. SQL City
11 20180103 bribery Apparently, Cayde thought it necessary to expose this extremely rare vegetable to a Hive summoning ritual. SQL City
12 20180115 assault Hamilton: Lee, do you yield? Burr: You shot him in the side! Yes he yields! SQL City
13 20180115 assault Report Not Found SQL City
14 20170101 fraud forgotten to ask.’ Long Beach
15 20170101 fraud Alice did not wish to offend the Dormouse again, so she began very Oceanside
16 20170101 theft ‘Yes,’ said Alice, ‘we learned French and music.’ Chicago
17 20170101 smuggling ‘Now tell me, Pat, what’s that in the window?’ Gilbert
18 20170101 assault twist it up into a sort of knot, and then keep tight hold of its right Nashville
19 20170102 arson with a smile. There was a dead silence. Las Vegas
20 20170102 bribery glass table. ‘Now, I’ll manage better this time,’ she said to herself, Riverside
21 20170102 theft days and days.’ Canton
22 20170102 smuggling ‘Yes,’ said Alice, ‘we learned French and music.’ Alexandria
23 20170103 arson witness.’ And he added in an undertone to the Queen, ‘Really, my dear, Rochester
24 20170104 blackmail see what was the matter with it. There could be no doubt that it had Lacey
25 20170105 theft came, carried on the breeze that followed them, the melancholy words:-- McAllen
26 20170105 robbery uglifying!’ it exclaimed. ‘You know what to beautify is, I suppose?’ Seaside
27 20170106 blackmail rather sharply; ‘I advise you to leave off this minute!’ She generally Lewisville
28 20170106 blackmail CHAPTER X. The Lobster Quadrille Jackson
29 20170106 theft ‘Of course it is,’ said the Duchess, who seemed ready to agree to High Point
30 20170107 bribery The hedgehog was engaged in a fight with another hedgehog, which seemed Lorain
31 20170107 smuggling Savannah
32 20170107 blackmail This answer so confused poor Alice, that she let the Dormouse go on for Newark
33 20170107 theft felt certain it must be really offended. ‘We won’t talk about her any Oklahoma City
34 20170107 murder ‘It proves nothing of the sort!’ said Alice. ‘Why, you don’t even know Memphis
35 20170108 murder get” is the same thing as “I get what I like”!’ Round Lake Beach
36 20170108 theft Alice tried to fancy to herself what such an extraordinary ways of Louisville
37 20170108 murder HEARTHRUG, Jacksonville
38 20170109 robbery finished, her sister kissed her, and said, ‘It WAS a curious dream, Grand Rapids
39 20170109 fraud his fan and gloves--that is, if I can find them.’ As she said this, she North Port
40 20170109 arson mouth; but she did it at last, and managed to swallow a morsel of the Port St. Lucie
41 20170109 arson for the next moment a shower of little pebbles came rattling in at the Little Rock
42 20170109 bribery condemn Visalia
43 20170110 blackmail Alice was not much surprised at this, she was getting so used to queer Kailua
44 20170111 murder Springdale
45 20170111 bribery (In which the cook and the baby joined):-- Lancaster
46 20170112 smuggling Melbourne
47 20170113 fraud Dinah, and saying to her very earnestly, ‘Now, Dinah, tell me the truth: Paterson
48 20170113 blackmail ‘There’s no sort of use in knocking,’ said the Footman, ‘and that for Fort Collins
49 20170113 assault Reading
50 20170114 fraud ‘Off with their heads!’ and the procession moved on, three of the Chicago
51 20170114 blackmail Orange
52 20170114 fraud ‘I couldn’t afford to learn it.’ said the Mock Turtle with a sigh. ‘I Lorain
53 20170115 assault ‘Nothing WHATEVER?’ persisted the King. Jersey City
54 20170115 theft The Knave shook his head sadly. ‘Do I look like it?’ he said. (Which he Hollywood
55 20170115 robbery think,’ Alice went on, ‘that they’d let Dinah stop in the house if it Cincinnati
56 20170116 blackmail Ontario
57 20170116 assault my fur and whiskers! She’ll get me executed, as sure as ferrets are Plano
58 20170116 blackmail Fish-Footman was gone, and the other was sitting on the ground near the Tallahassee
59 20170116 bribery Memphis
60 20170116 smuggling living would be like, but it puzzled her too much, so she went on: ‘But Las Cruces
61 20170117 assault with the words ‘DRINK ME,’ but nevertheless she uncorked it and put it Anaheim
62 20170117 bribery you liked with the clock. For instance, suppose it were nine o’clock in San Bernardino
63 20170118 robbery the pool, and the great hall, with the glass table and the little door, Charlotte
64 20170118 arson minute or two, which gave the Pigeon the opportunity of adding, ‘You’re Wilmington
65 20170118 theft on.’ Denton
66 20170119 smuggling and sadly:-- Riverside
67 20170119 robbery Asheville
68 20170121 arson voice, ‘Why the fact is, you see, Miss, this here ought to have been a Knoxville
69 20170121 murder her, to pass away the time. Murfreesboro
70 20170122 robbery Houston
71 20170122 bribery Oakland
72 20170122 bribery Omaha
73 20170122 murder came near her, she began, in a low, timid voice, ‘If you please, sir--’ Temecula
74 20170122 assault Layton
75 20170123 blackmail Arvada
76 20170123 assault Sterling Heights
77 20170124 arson Arlington
78 20170124 murder about something, my dear, and that makes you forget to talk. I can’t Santa Clarita
79 20170124 robbery a little shriek, and went on: ‘--that begins with an M, such as Macon
80 20170124 murder Waterbury
81 20170125 murder age knew the meaning of it at all. However, ‘jury-men’ would have done Laredo
82 20170125 theft ‘Can’t remember WHAT things?’ said the Caterpillar. New Bedford
83 20170126 arson ‘I won’t!’ said Alice. Richmond
84 20170127 arson tried to get her head down to them, and was delighted to find that her Birmingham
85 20170127 blackmail thousand miles down, I think--’ (for, you see, Alice had learnt several Richland
86 20170128 theft ‘--as far out to sea as you can--’ Newark
87 20170128 theft ‘The Queen of Hearts, she made some tarts, New Orleans
88 20170128 assault wag my tail when I’m angry. Therefore I’m mad.’ Nashua
89 20170129 arson of things--I can’t remember half of them--and it belongs to a farmer, Bridgeport
90 20170129 bribery ‘I’m sure I’m not Ada,’ she said, ‘for her hair goes in such long Daytona Beach
91 20170129 blackmail ‘Call the first witness,’ said the King; and the White Rabbit blew three Paterson
92 20170129 robbery Saint Louis
93 20170129 assault OUT OF ITS WAISTCOAT-POCKET, and looked at it, and then hurried on, Irving
94 20170130 fraud Lancaster
95 20170130 arson Allentown
96 20170130 fraud a bit.’ Raleigh
97 20170131 bribery Layton
98 20170131 bribery Apple Valley
99 20170131 bribery every line: Fort Collins
100 20170201 fraud close by her. Tuscaloosa

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE crime_scene_report (
        date integer,
        type text,
        description text,
        city text
Powered by Datasette · Query took 17.681ms · About: NUKnightLab/sql-mysteries