Ralph Picarello, 39, from Essex, Maryland

May 4, 2022 | Essex, Maryland

Ralph Picarello, 39, from Essex, Maryland - shot on 4 May 2022

Victim Info

NameRalph Picarello
RaceUnknown
Age39
GenderMale

Details

Additional Evidence

NameRalph Picarello
Date2022-05-04
Manner Of Deathshot
Armedknife
Age39
GenderM
Race
CityEssex
StateMD
Signs Of Mental IllnessFalse
Threat Levelother
FleeNot fleeing
Body CameraFalse
Is Geocoding ExactTrue

Source

Source ID: 8021 - Washington Post

BEACON Data

Mainchain details

The BEACON hash was timestamped at Fri, 17 Jun 2022 14:32:27 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 62726. Submitted in Mainchain Tx C9A54A9AE60B4EFE6F922E5C2130F40CC5D38E73A569045AB5BD39CB24989DA1, at block height 134005

Transaction details

Tx C9A54A9AE60B4EFE6F922E5C2130F40CC5D38E73A569045AB5BD39CB24989DA1
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: gPsnFEpfAKqxSyk2203BCPECiLiheYoXWTwUEeOE2DA9YAU/91nNsOK8xXoo4hclOxTZscZj6EtU/d2FYUuZEA==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"3c4ff70cf2372f9e676ce9268ac91105e1e8b1a343416152a4b1b55003c96163","submit_time":"1655476347","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":"62761"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["gPsnFEpfAKqxSyk2203BCPECiLiheYoXWTwUEeOE2DA9YAU/91nNsOK8xXoo4hclOxTZscZj6EtU/d2FYUuZEA=="]},"tx_response":{"height":"134005","txhash":"C9A54A9AE60B4EFE6F922E5C2130F40CC5D38E73A569045AB5BD39CB24989DA1","codespace":"","code":0,"data":"0A210A177265636F72645F626561636F6E5F74696D657374616D70120608041086EA03","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\":\"62726\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"3c4ff70cf2372f9e676ce9268ac91105e1e8b1a343416152a4b1b55003c96163\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1655476347\"},{\"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":"62726"},{"key":"beacon_timestamp_hash","value":"3c4ff70cf2372f9e676ce9268ac91105e1e8b1a343416152a4b1b55003c96163"},{"key":"beacon_timestamp_submit_time","value":"1655476347"},{"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":"3c4ff70cf2372f9e676ce9268ac91105e1e8b1a343416152a4b1b55003c96163","submit_time":"1655476347","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":"62761"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["gPsnFEpfAKqxSyk2203BCPECiLiheYoXWTwUEeOE2DA9YAU/91nNsOK8xXoo4hclOxTZscZj6EtU/d2FYUuZEA=="]},"timestamp":"2022-06-17T14:32:25Z","events":[{"type":"tx","attributes":[{"key":"YWNjX3NlcQ==","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3prLzYyNzYx","index":true}]},{"type":"tx","attributes":[{"key":"c2lnbmF0dXJl","value":"Z1BzbkZFcGZBS3F4U3lrMjIwM0JDUEVDaUxpaGVZb1hXVHdVRWVPRTJEQTlZQVUvOTFuTnNPSzh4WG9vNGhjbE94VFpzY1pqNkV0VS9kMkZZVXVaRUE9PQ==","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":"NjI3MjY=","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9oYXNo","value":"M2M0ZmY3MGNmMjM3MmY5ZTY3NmNlOTI2OGFjOTExMDVlMWU4YjFhMzQzNDE2MTUyYTRiMWI1NTAwM2M5NjE2Mw==","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9zdWJtaXRfdGltZQ==","value":"MTY1NTQ3NjM0Nw==","index":true},{"key":"YmVhY29uX293bmVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true}]}]}}

Hash Comparison

Hash stored in database: 3c4ff70cf2372f9e676ce9268ac91105e1e8b1a343416152a4b1b55003c96163

Hash from Mainchain Tx: 3c4ff70cf2372f9e676ce9268ac91105e1e8b1a343416152a4b1b55003c96163

Dynamically generated hash: 3c4ff70cf2372f9e676ce9268ac91105e1e8b1a343416152a4b1b55003c96163

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":"Ralph Picarello","date":"2022-05-04","manner_of_death":"shot","armed":"knife","age":"39","gender":"M","race":"","city":"Essex","state":"MD","signs_of_mental_illness":"False","threat_level":"other","flee":"Not fleeing","body_camera":"False","is_geocoding_exact":"True"}},"evidenceLinks":[],"locationCity":"Essex","locationCountry":"US","locationHasGeo":true,"locationLat":39.318,"locationLong":-76.471,"locationState":"Maryland","locationStateCode":"MD","month":5,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1651622400,"sourceId":"8021","sourceRawData":"{\"id\":\"8021\",\"name\":\"Ralph Picarello\",\"date\":\"2022-05-04\",\"manner_of_death\":\"shot\",\"armed\":\"knife\",\"age\":\"39\",\"gender\":\"M\",\"race\":\"\",\"city\":\"Essex\",\"state\":\"MD\",\"signs_of_mental_illness\":\"False\",\"threat_level\":\"other\",\"flee\":\"Not fleeing\",\"body_camera\":\"False\",\"longitude\":\"-76.471\",\"latitude\":\"39.318\",\"is_geocoding_exact\":\"True\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/fatal-police-shootings-data.csv","title":"Ralph Picarello, 39, from Essex, Maryland - shot on 4 May 2022","updateHistory":[],"victimAge":39,"victimArmed":"Knife","victimGender":"Male","victimName":"Ralph Picarello","victimRace":"Unknown","year":2022}