John William Stockton, 52, from Purcell, Oklahoma

July 24, 2023 | Purcell, Oklahoma

John William Stockton, 52, from Purcell, Oklahoma - undefined on 24 July 2023

Victim Info

NameJohn William Stockton
RaceWhite/European American
Age52
Gendermale

Details

Additional Evidence

NameJohn William Stockton
Date2023-07-24
Manner Of DeathPolice Shooting
Armed Withknife
Age52
Gendermale
RaceW
Race Sourcepublic_record
CityPurcell
StateOK
Was Mental Illness RelatedFalse
Threat Typethreat
Flee Status
Body CameraFalse
Location Precisionintersection
Agency Ids1705

Source

Source ID: 9390 - Washington Post

BEACON Data

Mainchain details

The BEACON hash was timestamped at Thu, 27 Jul 2023 00:30:30 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 126148. Submitted in Mainchain Tx 398BEFA2398201E4F02C616D47B62341113A15B8E505ED2B9C2C4A018FDA8220, at block height 6201943

Transaction details

Tx 398BEFA2398201E4F02C616D47B62341113A15B8E505ED2B9C2C4A018FDA8220
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: ln6UeLYQzF/921S3EodSUYSwc73dYqEEgi4IfUM9q8EWN63+txr/GzYmdQC9Z46/Rjj7FDLl8mj7ZfTE2wo1Mg==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"c07de09f50672a277629890a17ab5996552b9fd6a025727c0cbda494480665b7","submit_time":"1690417830","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":"126183"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["ln6UeLYQzF/921S3EodSUYSwc73dYqEEgi4IfUM9q8EWN63+txr/GzYmdQC9Z46/Rjj7FDLl8mj7ZfTE2wo1Mg=="]},"tx_response":{"height":"6201943","txhash":"398BEFA2398201E4F02C616D47B62341113A15B8E505ED2B9C2C4A018FDA8220","codespace":"","code":0,"data":"0A370A2D2F6D61696E636861696E2E626561636F6E2E76312E4D73675265636F7264426561636F6E54696D657374616D701206080410C4D907","raw_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\":\"126148\"},{\"key\":\"beacon_timestamp_id_pruned\",\"value\":\"76148\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"c07de09f50672a277629890a17ab5996552b9fd6a025727c0cbda494480665b7\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1690417830\"},{\"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":"126148"},{"key":"beacon_timestamp_id_pruned","value":"76148"},{"key":"beacon_timestamp_hash","value":"c07de09f50672a277629890a17ab5996552b9fd6a025727c0cbda494480665b7"},{"key":"beacon_timestamp_submit_time","value":"1690417830"},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk"}]}]}],"info":"","gas_wanted":"250000","gas_used":"122642","tx":{"@type":"/cosmos.tx.v1beta1.Tx","body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"c07de09f50672a277629890a17ab5996552b9fd6a025727c0cbda494480665b7","submit_time":"1690417830","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":"126183"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["ln6UeLYQzF/921S3EodSUYSwc73dYqEEgi4IfUM9q8EWN63+txr/GzYmdQC9Z46/Rjj7FDLl8mj7ZfTE2wo1Mg=="]},"timestamp":"2023-07-27T00:30:28Z","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/126183","index":true}]},{"type":"tx","attributes":[{"key":"signature","value":"ln6UeLYQzF/921S3EodSUYSwc73dYqEEgi4IfUM9q8EWN63+txr/GzYmdQC9Z46/Rjj7FDLl8mj7ZfTE2wo1Mg==","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":"126148","index":true},{"key":"beacon_timestamp_id_pruned","value":"76148","index":true},{"key":"beacon_timestamp_hash","value":"c07de09f50672a277629890a17ab5996552b9fd6a025727c0cbda494480665b7","index":true},{"key":"beacon_timestamp_submit_time","value":"1690417830","index":true},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true}]}]}}

Hash Comparison

Hash stored in database: c07de09f50672a277629890a17ab5996552b9fd6a025727c0cbda494480665b7

Hash from Mainchain Tx: c07de09f50672a277629890a17ab5996552b9fd6a025727c0cbda494480665b7

Dynamically generated hash: c07de09f50672a277629890a17ab5996552b9fd6a025727c0cbda494480665b7

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 William Stockton","date":"2023-07-24","manner_of_death":"Police Shooting","armed_with":"knife","age":"52","gender":"male","race":"W","race_source":"public_record","city":"Purcell","state":"OK","was_mental_illness_related":"False","threat_type":"threat","flee_status":"","body_camera":"False","location_precision":"intersection","agency_ids":"1705"}},"evidenceLinks":[],"locationCity":"Purcell","locationCountry":"US","locationHasGeo":true,"locationLat":35.01148716419962,"locationLong":-97.37313267684831,"locationState":"Oklahoma","locationStateCode":"OK","month":7,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1690156800,"sourceId":"9390","sourceRawData":"{\"id\":\"9390\",\"date\":\"2023-07-24\",\"threat_type\":\"threat\",\"flee_status\":\"\",\"armed_with\":\"knife\",\"city\":\"Purcell\",\"county\":\"McClain\",\"state\":\"OK\",\"latitude\":\"35.01148716419962\",\"longitude\":\"-97.37313267684831\",\"location_precision\":\"intersection\",\"name\":\"John William Stockton\",\"age\":\"52\",\"gender\":\"male\",\"race\":\"W\",\"race_source\":\"public_record\",\"was_mental_illness_related\":\"False\",\"body_camera\":\"False\",\"agency_ids\":\"1705\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/v2/fatal-police-shootings-data.csv","title":"John William Stockton, 52, from Purcell, Oklahoma - undefined on 24 July 2023","updateHistory":[],"victimAge":52,"victimArmed":"Knife","victimGender":"male","victimName":"John William Stockton","victimRace":"White/European American","year":2023}