Public Accountability Chain

July 30, 2023 | McAllen, Texas

Ronaldo Alvarado, 25, from McAllen, Texas - undefined on 30 July 2023

Victim Info

NameRonaldo Alvarado
RaceUnknown
Age25
Gendermale

Details

Additional Evidence

NameRonaldo Alvarado
Date2023-07-30
Manner Of DeathPolice Shooting
Armed Withgun
Age25
Gendermale
Race
Race Source
CityMcAllen
StateTX
Was Mental Illness RelatedFalse
Threat Typeshoot
Flee Statuscar
Body CameraFalse
Location Precisionblock
Agency Ids17101

Source

Source ID: 10089 - Washington Post

BEACON Data

Mainchain details

The BEACON hash was timestamped at Wed, 31 Jan 2024 00:31:15 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 126855. Submitted in Mainchain Tx 99F38A0468575BBBF5ED80D9556C7FB2AF2D4C27DEC0D1D9B498AE3369A32F40, at block height 9027587

Transaction details

Tx 99F38A0468575BBBF5ED80D9556C7FB2AF2D4C27DEC0D1D9B498AE3369A32F40
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: LtUHdaGuunhUHmBOyQ7eLyNcLcGdNFIPtofLT+xjiEJRwLFJD9kfMtUnsDq1qoaXHflYjbpp2CCzjGBbYzAxRA==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"540624afae7eb4e1755dcd99a86d96440b579d09bac14e22e9707580062d552c","submit_time":"1706661075","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":"126890"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["LtUHdaGuunhUHmBOyQ7eLyNcLcGdNFIPtofLT+xjiEJRwLFJD9kfMtUnsDq1qoaXHflYjbpp2CCzjGBbYzAxRA=="]},"tx_response":{"height":"9027587","txhash":"99F38A0468575BBBF5ED80D9556C7FB2AF2D4C27DEC0D1D9B498AE3369A32F40","codespace":"","code":0,"data":"123F0A352F6D61696E636861696E2E626561636F6E2E76312E4D73675265636F7264426561636F6E54696D657374616D70526573706F6E7365120608041087DF07","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\":\"126855\"},{\"key\":\"beacon_timestamp_id_pruned\",\"value\":\"76855\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"540624afae7eb4e1755dcd99a86d96440b579d09bac14e22e9707580062d552c\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1706661075\"},{\"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":"126855"},{"key":"beacon_timestamp_id_pruned","value":"76855"},{"key":"beacon_timestamp_hash","value":"540624afae7eb4e1755dcd99a86d96440b579d09bac14e22e9707580062d552c"},{"key":"beacon_timestamp_submit_time","value":"1706661075"},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk"}]}]}],"info":"","gas_wanted":"250000","gas_used":"130840","tx":{"@type":"/cosmos.tx.v1beta1.Tx","body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"540624afae7eb4e1755dcd99a86d96440b579d09bac14e22e9707580062d552c","submit_time":"1706661075","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":"126890"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["LtUHdaGuunhUHmBOyQ7eLyNcLcGdNFIPtofLT+xjiEJRwLFJD9kfMtUnsDq1qoaXHflYjbpp2CCzjGBbYzAxRA=="]},"timestamp":"2024-01-31T00:31:13Z","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/126890","index":true}]},{"type":"tx","attributes":[{"key":"signature","value":"LtUHdaGuunhUHmBOyQ7eLyNcLcGdNFIPtofLT+xjiEJRwLFJD9kfMtUnsDq1qoaXHflYjbpp2CCzjGBbYzAxRA==","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":"126855","index":true},{"key":"beacon_timestamp_id_pruned","value":"76855","index":true},{"key":"beacon_timestamp_hash","value":"540624afae7eb4e1755dcd99a86d96440b579d09bac14e22e9707580062d552c","index":true},{"key":"beacon_timestamp_submit_time","value":"1706661075","index":true},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true}]}]}}

Hash Comparison

Hash stored in database: 540624afae7eb4e1755dcd99a86d96440b579d09bac14e22e9707580062d552c

Hash from Mainchain Tx: 540624afae7eb4e1755dcd99a86d96440b579d09bac14e22e9707580062d552c

Dynamically generated hash: 540624afae7eb4e1755dcd99a86d96440b579d09bac14e22e9707580062d552c

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":"Ronaldo Alvarado","date":"2023-07-30","manner_of_death":"Police Shooting","armed_with":"gun","age":"25","gender":"male","race":"","race_source":"","city":"McAllen","state":"TX","was_mental_illness_related":"False","threat_type":"shoot","flee_status":"car","body_camera":"False","location_precision":"block","agency_ids":"17101"}},"evidenceLinks":[],"locationCity":"McAllen","locationCountry":"US","locationHasGeo":true,"locationLat":26.22112039836998,"locationLong":-98.24263245678131,"locationState":"Texas","locationStateCode":"TX","month":7,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1690675200,"sourceId":"10089","sourceRawData":"{\"id\":\"10089\",\"date\":\"2023-07-30\",\"threat_type\":\"shoot\",\"flee_status\":\"car\",\"armed_with\":\"gun\",\"city\":\"McAllen\",\"county\":\"Hidalgo\",\"state\":\"TX\",\"latitude\":\"26.22112039836998\",\"longitude\":\"-98.24263245678131\",\"location_precision\":\"block\",\"name\":\"Ronaldo Alvarado\",\"age\":\"25\",\"gender\":\"male\",\"race\":\"\",\"race_source\":\"\",\"was_mental_illness_related\":\"False\",\"body_camera\":\"False\",\"agency_ids\":\"17101\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/v2/fatal-police-shootings-data.csv","title":"Ronaldo Alvarado, 25, from McAllen, Texas - undefined on 30 July 2023","updateHistory":[],"victimAge":25,"victimArmed":"Gun","victimGender":"male","victimName":"Ronaldo Alvarado","victimRace":"Unknown","year":2023}