Public Accountability Chain

September 24, 2023 | Mesa, Arizona

Joel Castaneda, 42, from Mesa, Arizona - undefined on 24 September 2023

Victim Info

NameJoel Castaneda
RaceUnknown
Age42
Gendermale

Details

Additional Evidence

NameJoel Castaneda
Date2023-09-24
Manner Of DeathPolice Shooting
Armed Withgun
Age42
Gendermale
Race
Race Source
CityMesa
StateAZ
Was Mental Illness RelatedFalse
Threat Typeshoot
Flee Statusnot
Body CameraFalse
Location Precisionintersection
Agency Ids319

Source

Source ID: 9749 - Washington Post

BEACON Data

Mainchain details

The BEACON hash was timestamped at Thu, 11 Jan 2024 11:57:00 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 126554. Submitted in Mainchain Tx F0EF7BE34DB8125F4FF951D08477BCA6406A554998EA8DD3F77922295781D059, at block height 8732632

Transaction details

Tx F0EF7BE34DB8125F4FF951D08477BCA6406A554998EA8DD3F77922295781D059
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: BceqmP//9hEGJmQ/9KEoxnMVph7wx7MdIxDH+4NtIz59uBrSBGdESxjvH/DUSt8jwUYXJJmwIGfucyPHzHx8VQ==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"c76aac72ccd5065d835b1d406e3d331c82e59f7d48f7b33d15ce5f8e296ef650","submit_time":"1704974220","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":"126589"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["BceqmP//9hEGJmQ/9KEoxnMVph7wx7MdIxDH+4NtIz59uBrSBGdESxjvH/DUSt8jwUYXJJmwIGfucyPHzHx8VQ=="]},"tx_response":{"height":"8732632","txhash":"F0EF7BE34DB8125F4FF951D08477BCA6406A554998EA8DD3F77922295781D059","codespace":"","code":0,"data":"123F0A352F6D61696E636861696E2E626561636F6E2E76312E4D73675265636F7264426561636F6E54696D657374616D70526573706F6E73651206080410DADC07","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\":\"126554\"},{\"key\":\"beacon_timestamp_id_pruned\",\"value\":\"76554\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"c76aac72ccd5065d835b1d406e3d331c82e59f7d48f7b33d15ce5f8e296ef650\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1704974220\"},{\"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":"126554"},{"key":"beacon_timestamp_id_pruned","value":"76554"},{"key":"beacon_timestamp_hash","value":"c76aac72ccd5065d835b1d406e3d331c82e59f7d48f7b33d15ce5f8e296ef650"},{"key":"beacon_timestamp_submit_time","value":"1704974220"},{"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":"c76aac72ccd5065d835b1d406e3d331c82e59f7d48f7b33d15ce5f8e296ef650","submit_time":"1704974220","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":"126589"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["BceqmP//9hEGJmQ/9KEoxnMVph7wx7MdIxDH+4NtIz59uBrSBGdESxjvH/DUSt8jwUYXJJmwIGfucyPHzHx8VQ=="]},"timestamp":"2024-01-11T11:56:59Z","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/126589","index":true}]},{"type":"tx","attributes":[{"key":"signature","value":"BceqmP//9hEGJmQ/9KEoxnMVph7wx7MdIxDH+4NtIz59uBrSBGdESxjvH/DUSt8jwUYXJJmwIGfucyPHzHx8VQ==","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":"126554","index":true},{"key":"beacon_timestamp_id_pruned","value":"76554","index":true},{"key":"beacon_timestamp_hash","value":"c76aac72ccd5065d835b1d406e3d331c82e59f7d48f7b33d15ce5f8e296ef650","index":true},{"key":"beacon_timestamp_submit_time","value":"1704974220","index":true},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true}]}]}}

Hash Comparison

Hash stored in database: c76aac72ccd5065d835b1d406e3d331c82e59f7d48f7b33d15ce5f8e296ef650

Hash from Mainchain Tx: c76aac72ccd5065d835b1d406e3d331c82e59f7d48f7b33d15ce5f8e296ef650

Dynamically generated hash: c76aac72ccd5065d835b1d406e3d331c82e59f7d48f7b33d15ce5f8e296ef650

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":"Joel Castaneda","date":"2023-09-24","manner_of_death":"Police Shooting","armed_with":"gun","age":"42","gender":"male","race":"","race_source":"","city":"Mesa","state":"AZ","was_mental_illness_related":"False","threat_type":"shoot","flee_status":"not","body_camera":"False","location_precision":"intersection","agency_ids":"319"}},"evidenceLinks":[],"locationCity":"Mesa","locationCountry":"US","locationHasGeo":true,"locationLat":33.407832874960135,"locationLong":-111.81413053524669,"locationState":"Arizona","locationStateCode":"AZ","month":9,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1695513600,"sourceId":"9749","sourceRawData":"{\"id\":\"9749\",\"date\":\"2023-09-24\",\"threat_type\":\"shoot\",\"flee_status\":\"not\",\"armed_with\":\"gun\",\"city\":\"Mesa\",\"county\":\"Maricopa\",\"state\":\"AZ\",\"latitude\":\"33.407832874960135\",\"longitude\":\"-111.81413053524669\",\"location_precision\":\"intersection\",\"name\":\"Joel Castaneda\",\"age\":\"42\",\"gender\":\"male\",\"race\":\"\",\"race_source\":\"\",\"was_mental_illness_related\":\"False\",\"body_camera\":\"False\",\"agency_ids\":\"319\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/v2/fatal-police-shootings-data.csv","title":"Joel Castaneda, 42, from Mesa, Arizona - undefined on 24 September 2023","updateHistory":[],"victimAge":42,"victimArmed":"Gun","victimGender":"male","victimName":"Joel Castaneda","victimRace":"Unknown","year":2023}