John Snowling, 59, from Trabuco Canyon, California

August 23, 2023 | Trabuco Canyon, California

John Snowling, 59, from Trabuco Canyon, California - undefined on 23 August 2023

Victim Info

NameJohn Snowling
RaceUnknown
Age59
Gendermale

Details

Additional Evidence

NameJohn Snowling
Date2023-08-23
Manner Of DeathPolice Shooting
Armed Withgun
Age59
Gendermale
Race
Race Source
CityTrabuco Canyon
StateCA
Was Mental Illness RelatedFalse
Threat Typeshoot
Flee Statusnot
Body CameraFalse
Location Precisionaddress
Agency Ids474

Source

Source ID: 9498 - Washington Post

BEACON Data

Mainchain details

The BEACON hash was timestamped at Thu, 11 Jan 2024 12:06:28 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 126651. Submitted in Mainchain Tx 466B8C964B549F0B423A2466DA6849C20272D06171C4FC68AC20AD2EC862EFC5, at block height 8732731

Transaction details

Tx 466B8C964B549F0B423A2466DA6849C20272D06171C4FC68AC20AD2EC862EFC5
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: XWvzegBaTrDxaalyJ9l7dajiVM9Fuim18LjOgb+SjcAdk03y5iGYZJKlWhWV/vDSbtLqeq9KZ6PD4JAM3RsfCw==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"8d9ec6d3092884d9c0a7cb3dcd3bff90f17acdb97841ed8348e64bb3da019bad","submit_time":"1704974788","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":"126686"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["XWvzegBaTrDxaalyJ9l7dajiVM9Fuim18LjOgb+SjcAdk03y5iGYZJKlWhWV/vDSbtLqeq9KZ6PD4JAM3RsfCw=="]},"tx_response":{"height":"8732731","txhash":"466B8C964B549F0B423A2466DA6849C20272D06171C4FC68AC20AD2EC862EFC5","codespace":"","code":0,"data":"123F0A352F6D61696E636861696E2E626561636F6E2E76312E4D73675265636F7264426561636F6E54696D657374616D70526573706F6E73651206080410BBDD07","raw_log":"[{\"msg_index\":0,\"events\":[{\"type\":\"message\",\"attributes\":[{\"key\":\"action\",\"value\":\"/mainchain.beacon.v1.MsgRecordBeaconTimestamp\"},{\"key\":\"module\",\"value\":\"beacon\"}]},{\"type\":\"record_beacon_timestamp\",\"attributes\":[{\"key\":\"beacon_id\",\"value\":\"4\"},{\"key\":\"beacon_timestamp_id\",\"value\":\"126651\"},{\"key\":\"beacon_timestamp_id_pruned\",\"value\":\"76651\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"8d9ec6d3092884d9c0a7cb3dcd3bff90f17acdb97841ed8348e64bb3da019bad\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1704974788\"},{\"key\":\"beacon_owner\",\"value\":\"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk\"}]}]}]","logs":[{"msg_index":0,"log":"","events":[{"type":"message","attributes":[{"key":"action","value":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp"},{"key":"module","value":"beacon"}]},{"type":"record_beacon_timestamp","attributes":[{"key":"beacon_id","value":"4"},{"key":"beacon_timestamp_id","value":"126651"},{"key":"beacon_timestamp_id_pruned","value":"76651"},{"key":"beacon_timestamp_hash","value":"8d9ec6d3092884d9c0a7cb3dcd3bff90f17acdb97841ed8348e64bb3da019bad"},{"key":"beacon_timestamp_submit_time","value":"1704974788"},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk"}]}]}],"info":"","gas_wanted":"250000","gas_used":"133650","tx":{"@type":"/cosmos.tx.v1beta1.Tx","body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"8d9ec6d3092884d9c0a7cb3dcd3bff90f17acdb97841ed8348e64bb3da019bad","submit_time":"1704974788","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":"126686"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["XWvzegBaTrDxaalyJ9l7dajiVM9Fuim18LjOgb+SjcAdk03y5iGYZJKlWhWV/vDSbtLqeq9KZ6PD4JAM3RsfCw=="]},"timestamp":"2024-01-11T12:06:26Z","events":[{"type":"coin_spent","attributes":[{"key":"spender","value":"und1nwt6chnk0efe8ngwa5y63egmdumht6arlvluh3","index":true},{"key":"amount","value":"1000000000nund","index":true}]},{"type":"coin_received","attributes":[{"key":"receiver","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true},{"key":"amount","value":"1000000000nund","index":true}]},{"type":"und_unlocked","attributes":[{"key":"purchaser","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true},{"key":"amount","value":"1000000000nund","index":true}]},{"type":"coin_spent","attributes":[{"key":"spender","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true},{"key":"amount","value":"1000000000nund","index":true}]},{"type":"coin_received","attributes":[{"key":"receiver","value":"und17xpfvakm2amg962yls6f84z3kell8c5lhuyfdm","index":true},{"key":"amount","value":"1000000000nund","index":true}]},{"type":"transfer","attributes":[{"key":"recipient","value":"und17xpfvakm2amg962yls6f84z3kell8c5lhuyfdm","index":true},{"key":"sender","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true},{"key":"amount","value":"1000000000nund","index":true}]},{"type":"message","attributes":[{"key":"sender","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true}]},{"type":"tx","attributes":[{"key":"fee","value":"1000000000nund","index":true},{"key":"fee_payer","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true}]},{"type":"tx","attributes":[{"key":"acc_seq","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk/126686","index":true}]},{"type":"tx","attributes":[{"key":"signature","value":"XWvzegBaTrDxaalyJ9l7dajiVM9Fuim18LjOgb+SjcAdk03y5iGYZJKlWhWV/vDSbtLqeq9KZ6PD4JAM3RsfCw==","index":true}]},{"type":"message","attributes":[{"key":"action","value":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","index":true}]},{"type":"message","attributes":[{"key":"module","value":"beacon","index":true}]},{"type":"record_beacon_timestamp","attributes":[{"key":"beacon_id","value":"4","index":true},{"key":"beacon_timestamp_id","value":"126651","index":true},{"key":"beacon_timestamp_id_pruned","value":"76651","index":true},{"key":"beacon_timestamp_hash","value":"8d9ec6d3092884d9c0a7cb3dcd3bff90f17acdb97841ed8348e64bb3da019bad","index":true},{"key":"beacon_timestamp_submit_time","value":"1704974788","index":true},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true}]}]}}

Hash Comparison

Hash stored in database: 8d9ec6d3092884d9c0a7cb3dcd3bff90f17acdb97841ed8348e64bb3da019bad

Hash from Mainchain Tx: 8d9ec6d3092884d9c0a7cb3dcd3bff90f17acdb97841ed8348e64bb3da019bad

Dynamically generated hash: 8d9ec6d3092884d9c0a7cb3dcd3bff90f17acdb97841ed8348e64bb3da019bad

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 Snowling","date":"2023-08-23","manner_of_death":"Police Shooting","armed_with":"gun","age":"59","gender":"male","race":"","race_source":"","city":"Trabuco Canyon","state":"CA","was_mental_illness_related":"False","threat_type":"shoot","flee_status":"not","body_camera":"False","location_precision":"address","agency_ids":"474"}},"evidenceLinks":[],"locationCity":"Trabuco Canyon","locationCountry":"US","locationHasGeo":true,"locationLat":33.68305123039543,"locationLong":-117.62056013294499,"locationState":"California","locationStateCode":"CA","month":8,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1692748800,"sourceId":"9498","sourceRawData":"{\"id\":\"9498\",\"date\":\"2023-08-23\",\"threat_type\":\"shoot\",\"flee_status\":\"not\",\"armed_with\":\"gun\",\"city\":\"Trabuco Canyon\",\"county\":\"Orange\",\"state\":\"CA\",\"latitude\":\"33.68305123039543\",\"longitude\":\"-117.62056013294499\",\"location_precision\":\"address\",\"name\":\"John Snowling\",\"age\":\"59\",\"gender\":\"male\",\"race\":\"\",\"race_source\":\"\",\"was_mental_illness_related\":\"False\",\"body_camera\":\"False\",\"agency_ids\":\"474\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/v2/fatal-police-shootings-data.csv","title":"John Snowling, 59, from Trabuco Canyon, California - undefined on 23 August 2023","updateHistory":[],"victimAge":59,"victimArmed":"Gun","victimGender":"male","victimName":"John Snowling","victimRace":"Unknown","year":2023}