John Vogel, 80, from St. Paul, Nebraska

August 14, 2021 | St. Paul, Nebraska

John Vogel, 80, from St. Paul, Nebraska - shot on 14 August 2021

Victim Info

NameJohn Vogel
RaceUnknown
Age80
GenderMale

Details

Additional Evidence

NameJohn Vogel
Date2021-08-14
Manner Of Deathshot
Armedgun
Age80
GenderM
Race
CitySt. Paul
StateNE
Signs Of Mental IllnessFalse
Threat Levelattack
FleeNot fleeing
Body CameraFalse
Is Geocoding ExactTrue

Source

Source ID: 7099 - Washington Post

Cross References

This report has possible entries from multiple sources

Mapping Police Violence -John Vogel, 80, from St. Paul, Nebraska, on 14 August 2021

BEACON Data

Mainchain details

The BEACON hash was timestamped at Fri, 17 Jun 2022 17:01:20 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 63531. Submitted in Mainchain Tx 2A0014BBA4A2BD9F15F8A31A544D93AB35C6D9658123967D90F8823236EE3154, at block height 135574

Transaction details

Tx 2A0014BBA4A2BD9F15F8A31A544D93AB35C6D9658123967D90F8823236EE3154
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: Fj5Evl+cyGDVfBliiJDjH7HKh72cPd+FrF5YvSkMZBVaQ1hDRo+G26ANZlRo+663XP55AzL12mz+f63qQHkVnQ==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"d1cd676273cd0e33ab5c5bf53f4dbd40bc35dbb7eca80fda2f52c0da7676ee8e","submit_time":"1655485280","owner":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk"}],"memo":"","timeout_height":"0","extension_options":[],"non_critical_extension_options":[]},"auth_info":{"signer_infos":[{"public_key":{"@type":"/cosmos.crypto.secp256k1.PubKey","key":"A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh"},"mode_info":{"single":{"mode":"SIGN_MODE_DIRECT"}},"sequence":"63566"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["Fj5Evl+cyGDVfBliiJDjH7HKh72cPd+FrF5YvSkMZBVaQ1hDRo+G26ANZlRo+663XP55AzL12mz+f63qQHkVnQ=="]},"tx_response":{"height":"135574","txhash":"2A0014BBA4A2BD9F15F8A31A544D93AB35C6D9658123967D90F8823236EE3154","codespace":"","code":0,"data":"0A210A177265636F72645F626561636F6E5F74696D657374616D701206080410ABF003","raw_log":"[{\"events\":[{\"type\":\"message\",\"attributes\":[{\"key\":\"action\",\"value\":\"record_beacon_timestamp\"},{\"key\":\"module\",\"value\":\"beacon\"}]},{\"type\":\"record_beacon_timestamp\",\"attributes\":[{\"key\":\"beacon_id\",\"value\":\"4\"},{\"key\":\"beacon_timestamp_id\",\"value\":\"63531\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"d1cd676273cd0e33ab5c5bf53f4dbd40bc35dbb7eca80fda2f52c0da7676ee8e\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1655485280\"},{\"key\":\"beacon_owner\",\"value\":\"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk\"}]}]}]","logs":[{"msg_index":0,"log":"","events":[{"type":"message","attributes":[{"key":"action","value":"record_beacon_timestamp"},{"key":"module","value":"beacon"}]},{"type":"record_beacon_timestamp","attributes":[{"key":"beacon_id","value":"4"},{"key":"beacon_timestamp_id","value":"63531"},{"key":"beacon_timestamp_hash","value":"d1cd676273cd0e33ab5c5bf53f4dbd40bc35dbb7eca80fda2f52c0da7676ee8e"},{"key":"beacon_timestamp_submit_time","value":"1655485280"},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk"}]}]}],"info":"","gas_wanted":"250000","gas_used":"99708","tx":{"@type":"/cosmos.tx.v1beta1.Tx","body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"d1cd676273cd0e33ab5c5bf53f4dbd40bc35dbb7eca80fda2f52c0da7676ee8e","submit_time":"1655485280","owner":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk"}],"memo":"","timeout_height":"0","extension_options":[],"non_critical_extension_options":[]},"auth_info":{"signer_infos":[{"public_key":{"@type":"/cosmos.crypto.secp256k1.PubKey","key":"A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh"},"mode_info":{"single":{"mode":"SIGN_MODE_DIRECT"}},"sequence":"63566"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["Fj5Evl+cyGDVfBliiJDjH7HKh72cPd+FrF5YvSkMZBVaQ1hDRo+G26ANZlRo+663XP55AzL12mz+f63qQHkVnQ=="]},"timestamp":"2022-06-17T17:01:18Z","events":[{"type":"tx","attributes":[{"key":"YWNjX3NlcQ==","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3prLzYzNTY2","index":true}]},{"type":"tx","attributes":[{"key":"c2lnbmF0dXJl","value":"Rmo1RXZsK2N5R0RWZkJsaWlKRGpIN0hLaDcyY1BkK0ZyRjVZdlNrTVpCVmFRMWhEUm8rRzI2QU5abFJvKzY2M1hQNTVBekwxMm16K2Y2M3FRSGtWblE9PQ==","index":true}]},{"type":"und_unlocked","attributes":[{"key":"cHVyY2hhc2Vy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true},{"key":"YW1vdW50","value":"MTAwMDAwMDAwMG51bmQ=","index":true}]},{"type":"transfer","attributes":[{"key":"cmVjaXBpZW50","value":"dW5kMTd4cGZ2YWttMmFtZzk2MnlsczZmODR6M2tlbGw4YzVsaHV5ZmRt","index":true},{"key":"c2VuZGVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true},{"key":"YW1vdW50","value":"MTAwMDAwMDAwMG51bmQ=","index":true}]},{"type":"message","attributes":[{"key":"c2VuZGVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true}]},{"type":"message","attributes":[{"key":"YWN0aW9u","value":"cmVjb3JkX2JlYWNvbl90aW1lc3RhbXA=","index":true}]},{"type":"message","attributes":[{"key":"bW9kdWxl","value":"YmVhY29u","index":true}]},{"type":"record_beacon_timestamp","attributes":[{"key":"YmVhY29uX2lk","value":"NA==","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9pZA==","value":"NjM1MzE=","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9oYXNo","value":"ZDFjZDY3NjI3M2NkMGUzM2FiNWM1YmY1M2Y0ZGJkNDBiYzM1ZGJiN2VjYTgwZmRhMmY1MmMwZGE3Njc2ZWU4ZQ==","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9zdWJtaXRfdGltZQ==","value":"MTY1NTQ4NTI4MA==","index":true},{"key":"YmVhY29uX293bmVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true}]}]}}

Hash Comparison

Hash stored in database: d1cd676273cd0e33ab5c5bf53f4dbd40bc35dbb7eca80fda2f52c0da7676ee8e

Hash from Mainchain Tx: d1cd676273cd0e33ab5c5bf53f4dbd40bc35dbb7eca80fda2f52c0da7676ee8e

Dynamically generated hash: d1cd676273cd0e33ab5c5bf53f4dbd40bc35dbb7eca80fda2f52c0da7676ee8e

Hashes Match?

YES

How is the comparison calculated?

The hash stored in the database is used as the identifier for this report, and can be seen in the URL. The hash from the Mainchain Tx is the hash sent to and stored on Mainchain. Finally, the "generated hash" is generated each time this page is loaded, using the same data used for the hash submitted to Mainchain.

Raw data used to generate the hash, using the Node.js crypto.createHash('sha256') algorithm: {"content":"","evidenceAdditional":{"type":"text","data":{"name":"John Vogel","date":"2021-08-14","manner_of_death":"shot","armed":"gun","age":"80","gender":"M","race":"","city":"St. Paul","state":"NE","signs_of_mental_illness":"False","threat_level":"attack","flee":"Not fleeing","body_camera":"False","is_geocoding_exact":"True"}},"evidenceLinks":[],"locationCity":"St. Paul","locationCountry":"US","locationHasGeo":true,"locationLat":41.215,"locationLong":-98.454,"locationState":"Nebraska","locationStateCode":"NE","month":8,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1628899200,"sourceId":"7099","sourceRawData":"{\"id\":\"7099\",\"name\":\"John Vogel\",\"date\":\"2021-08-14\",\"manner_of_death\":\"shot\",\"armed\":\"gun\",\"age\":\"80\",\"gender\":\"M\",\"race\":\"\",\"city\":\"St. Paul\",\"state\":\"NE\",\"signs_of_mental_illness\":\"False\",\"threat_level\":\"attack\",\"flee\":\"Not fleeing\",\"body_camera\":\"False\",\"longitude\":\"-98.454\",\"latitude\":\"41.215\",\"is_geocoding_exact\":\"True\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/fatal-police-shootings-data.csv","title":"John Vogel, 80, from St. Paul, Nebraska - shot on 14 August 2021","updateHistory":[],"victimAge":80,"victimArmed":"Gun","victimGender":"Male","victimName":"John Vogel","victimRace":"Unknown","year":2021}