Created
October 16, 2013 18:21
-
-
Save pmocek/7012387 to your computer and use it in GitHub Desktop.
sample of public records received from Seattle Police Department via [request](https://www.muckrock.com/foi/seattle-69/alpr-data-review-request-log-6422/) for ALPR data review request log
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ==> tbl_Images.txt <== | |
| 477D3D07-84A9-489F-85AF-4EA93F4BF069|2013-05-13 11:00:39.960|AE04180B-35D7-E111-9D4B-00A0D525C26C| 1|01F59F98-BAFD-4E53-B995-000009BCF456|A | NULL | |
| 4C38CD46-87A2-4AAC-8646-559E0D108280|2013-07-09 12:36:35.633|A2DD0344-39E3-E211-993E-00A0D52CFB18| 1|0A37C779-758C-4F1D-B069-00003634583C|A | NULL | |
| 9238D0EB-2BF4-4BBB-8EB9-43E7A11945BF|2013-07-24 10:53:16.483|AC04180B-35D7-E111-9D4B-00A0D525C26C| 1|ADD45538-F9BE-49ED-A594-0001003DDF15|A | NULL | |
| 30CBD2FB-7874-4E38-BC74-BDC119518A95|2013-07-12 19:33:07.877|AC04180B-35D7-E111-9D4B-00A0D525C26C| 1|E71CDE9A-E228-41D6-9EC2-00013074DA65|A | NULL | |
| 4C1713A6-358C-4687-8AF5-72639916885B|2013-07-29 12:13:05.820|AC04180B-35D7-E111-9D4B-00A0D525C26C| 1|2576100F-6F8B-4F19-9F24-00014B063D11|A | NULL | |
| C80234D5-FFE8-4CCE-96FA-A0E469D45281|2013-07-29 13:53:25.170|A4847121-DDF0-E211-9953-00A0D52CFB18| 1|1621ED5B-B123-4A0E-A3EC-0001507A1C18|A | NULL | |
| 63D86B83-129B-4876-9AC5-B1A890A01CB3|2013-07-22 09:29:41.873|A4847121-DDF0-E211-9953-00A0D52CFB18| 1|21A34455-DA73-4B3F-8DDC-0001619394D9|A | NULL | |
| D1DC7288-5180-4832-B749-9B80BEB6A354|2013-07-19 18:39:03.837|A4847121-DDF0-E211-9953-00A0D52CFB18| 1|25AA62ED-EAB4-4E18-B99C-000196843301|A | NULL | |
| F294E18B-8CFF-411F-9AAE-EDC503653E00|2013-07-01 10:25:37.093|AC04180B-35D7-E111-9D4B-00A0D525C26C| 1|F415463C-9632-4886-841A-0001D8B015DE|A | NULL | |
| 1B44037E-9741-46FB-A160-EFDAF87D7DB8|2013-07-31 12:59:49.860|A4847121-DDF0-E211-9953-00A0D52CFB18| 1|AFD6A15B-76D0-4297-A39B-0001FFE532A3|A | NULL | |
| ==> tbl_t_audits.txt <== | |
| audit_id|login_id|timestamp|location|latitude|longitude|information|xaxis|yaxis|zaxis | |
| 246470| 473|2013-05-11 11:32:12.720|PEO 31646 | 0.0| 0.0|Login attempt | 1.0| 0.0| 0.0 | |
| 246471| 473|2013-05-11 11:32:12.750|PEO 31646 | 0.0| 0.0|Login | 1.0| 0.0| 0.0 | |
| 246472| 473|2013-05-11 11:34:26.953|PEO 31646 | 47.583295| -122.323953|Deleting Hot List 'FBI_HOTLIST' | -0.36066841900231367| -0.56999330385665403| 0.73825871149140365 | |
| 246473| 473|2013-05-11 11:34:27.407|PEO 31646 | 47.583295| -122.323953|Deleting Hot List 'HOTLISTS' | -0.36066841900231367| -0.56999330385665403| 0.73825871149140365 | |
| 246474| 473|2013-05-11 11:34:27.530|PEO 31646 | 47.583295| -122.323953|Deleting Hot List 'SCOFFLAW' | -0.36066841900231367| -0.56999330385665403| 0.73825871149140365 | |
| 246475| 473|2013-05-11 11:34:30.890|PEO 31646 | 47.583295| -122.323953|Importing Hot List 'FBI_HOTLIST' | -0.36066841900231367| -0.56999330385665403| 0.73825871149140365 | |
| 246476| 473|2013-05-11 11:34:37.423|PEO 31646 | 47.583295| -122.323953|Importing Hot List 'HOTLISTS' | -0.36066841900231367| -0.56999330385665403| 0.73825871149140365 | |
| 246477| 473|2013-05-11 11:34:46.890|PEO 31646 | 47.583295| -122.323953|Importing Hot List 'SCOFFLAW' | -0.36066841900231367| -0.56999330385665403| 0.73825871149140365 | |
| 246478| 473|2013-05-11 14:08:45.063|PEO 31646 | 47.601694999999999| -122.3329|Hit on 248XHD from SCOFFLAW | -0.36063060119713364| -0.56973662150419668| 0.73847528841334809 | |
| ==> tbl_t_reads.txt <== | |
| 22530018|8381D | 473| 87|2013-05-11 15:36:47.610| |PEO 31646 | 47.590195000000001| -122.334575| -0.36072652769995889| -0.56985130516454185| 0.73833993676070309| 0| | 0 | |
| 22530019|042WFE | 473| 72|2013-05-11 15:35:51.203| |PEO 31646 | 47.590195000000001| -122.334603| -0.36072680618179853| -0.56985112888023681| 0.73833993676070309| 0| | 0 | |
| 22530020|271YME | 473| 92|2013-05-11 15:35:42.407| |PEO 31646 | 47.590195000000001| -122.334603| -0.36072680618179853| -0.56985112888023681| 0.73833993676070309| 0| | 0 | |
| 22530021|A60845S | 473| 87|2013-05-11 15:35:29.500| |PEO 31646 | 47.590195000000001| -122.334603| -0.36072680618179853| -0.56985112888023681| 0.73833993676070309| 0| | 0 | |
| 22530022|AFM0189 | 473| 88|2013-05-11 15:34:11.967| |PEO 31646 | 47.590192999999999| -122.33460599999999| -0.36072684980411174| -0.56985113176917279| 0.73833991321869807| 0| | 0 | |
| 22530023|ALW7409 | 473| 85|2013-05-11 15:34:08.297| |PEO 31646 | 47.590192999999999| -122.33460599999999| -0.36072684980411174| -0.56985113176917279| 0.73833991321869807| 0| | 0 | |
| 22530024|AJA5768 | 473| 86|2013-05-11 15:34:06.360| |PEO 31646 | 47.590192999999999| -122.33460599999999| -0.36072684980411174| -0.56985113176917279| 0.73833991321869807| 0| | 0 | |
| 22530025|B76806G | 473| 89|2013-05-11 15:34:03.907| |PEO 31646 | 47.590192999999999| -122.33460599999999| -0.36072684980411174| -0.56985113176917279| 0.73833991321869807| 0| | 0 | |
| 22530026|918UVI | 473| 91|2013-05-11 15:34:02.047| |PEO 31646 | 47.590192999999999| -122.33460599999999| -0.36072684980411174| -0.56985113176917279| 0.73833991321869807| 0| | 0 | |
| 22530027|290VQO | 473| 97|2013-05-11 15:33:58.827| |PEO 31646 | 47.590192999999999| -122.33460599999999| -0.36072684980411174| -0.56985113176917279| 0.73833991321869807| 0| | 0 | |
| ==> tbl_Vehicles.txt <== | |
| 2944471D-C57B-4CDD-9461-3294217CE565|2013-05-11 11:47:56.757| 1|1ESF1 |FB0CACF5-A493-43CF-90A7-CD269F3FF04B|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.593457722993818| -122.32377940394005|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| BD4D3E53-6649-4873-B052-BF55474C3218|2013-05-11 11:47:58.053| 1|D1ESEL |6C53B5DC-E70D-4D8C-908D-A126DCD18060|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.593459668051949| -122.3238070730729|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| 1AF4A6D4-FBB5-4304-81A0-99DB08D6702A|2013-05-11 11:47:58.477| 1|NSTRUCT |0A3D2BB6-9E63-4BE1-B4F3-24849A4191E7|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.593460485062892| -122.32383659540102|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| 3FB5458D-8E8A-435D-8823-F9BE422FC2E2|2013-05-11 11:48:21.040| 1|44385D |FDB25659-8754-4B1A-8125-4B98B7CAC88E|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.593478214334127| -122.32271641648157|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| 6CE3B8A5-28C5-4B92-B3C1-ACDA0D23BEA2|2013-05-11 11:48:28.757| 1|N1THCAUT |EE58E5B8-7A77-4D2B-A542-F1194BC471F9|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.593152788452628| -122.32263242546007|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| 9A217120-07E6-4FF1-84AE-B3F6F414E132|2013-05-11 11:48:45.947| 1|EX1T0N |8914DCC5-8966-46E8-941E-47EA2CB6E5E6|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.592831591290434| -122.32243893125451|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| 19DA059D-243A-4BCA-B0FD-5A9EBC551ADC|2013-05-11 11:48:46.133| 1|N1THGA |DBC069CF-47BB-4A1C-9BE6-F4D1ADD85603|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.592831591290434| -122.32243893125451|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| A2F0B620-D76B-446D-A3DF-8EDAC999C73E|2013-05-11 11:48:47.210| 1|EX1T0N |DC6D2282-EC52-49C3-ABB6-E6F7FA7306DB|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.592809358542688| -122.32242733405997|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| E75B8C0F-378E-497A-97CE-FD9925966161|2013-05-11 11:48:47.507| 1|N1THGA |7090DC73-1825-43F6-94FC-DD8125109F26|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.592809358542688| -122.32242733405997|04F46295-A54B-499C-80CD-201DD09A3E60 | |
| 0A100474-BB7F-4325-A1CF-F098CAE4C302|2013-05-11 11:48:48.163| 1|EX1T0N |91A8A363-BDA1-41BC-B87C-AE0134185D44|42248D13-B9DB-4664-8769-F75BBDFAFEFC| 47.593070440954385| -122.32245031429221|04F46295-A54B-499C-80CD-201DD09A3E60 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment