Public Accountability Chain

September 28, 2023 | Idabel, Oklahoma

David Rodriguez Lopez, 30, from Idabel, Oklahoma - undefined on 28 September 2023

Victim Info

NameDavid Rodriguez Lopez
RaceWhite/European American
Age30
Gendermale

Details

Additional Evidence

NameDavid Rodriguez Lopez
Date2023-09-28
Manner Of DeathPolice Shooting
Armed Withvehicle
Age30
Gendermale
RaceW
Race Sourcepublic_record
CityIdabel
StateOK
Was Mental Illness RelatedFalse
Threat Typepoint
Flee Statuscar
Body CameraFalse
Location Precision
Agency Ids101;13645;1367

Source

Source ID: 9765 - Washington Post

BEACON Data

Mainchain details

The BEACON hash was timestamped at Thu, 11 Jan 2024 11:56:04 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 126544. Submitted in Mainchain Tx 27FE49F227C9768D07347752E56171DBFAAEFAA69DC8F0234035730F506A8C7B, at block height 8732622

Transaction details

Tx 27FE49F227C9768D07347752E56171DBFAAEFAA69DC8F0234035730F506A8C7B
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: whrkqbT0q3jXEpkGr79hQf8u2JaIaFtGfAXyRE3S591qUxVBQlnp6KXJQdefKG1XfyJSLLxizcCFUgGPlUB9BA==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"44f3da7abc26214cd2f43f809f8b042d10f2f715bd1a7591f37348cbb18bfeb8","submit_time":"1704974164","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":"126579"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["whrkqbT0q3jXEpkGr79hQf8u2JaIaFtGfAXyRE3S591qUxVBQlnp6KXJQdefKG1XfyJSLLxizcCFUgGPlUB9BA=="]},"tx_response":{"height":"8732622","txhash":"27FE49F227C9768D07347752E56171DBFAAEFAA69DC8F0234035730F506A8C7B","codespace":"","code":0,"data":"123F0A352F6D61696E636861696E2E626561636F6E2E76312E4D73675265636F7264426561636F6E54696D657374616D70526573706F6E73651206080410D0DC07","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\":\"126544\"},{\"key\":\"beacon_timestamp_id_pruned\",\"value\":\"76544\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"44f3da7abc26214cd2f43f809f8b042d10f2f715bd1a7591f37348cbb18bfeb8\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1704974164\"},{\"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":"126544"},{"key":"beacon_timestamp_id_pruned","value":"76544"},{"key":"beacon_timestamp_hash","value":"44f3da7abc26214cd2f43f809f8b042d10f2f715bd1a7591f37348cbb18bfeb8"},{"key":"beacon_timestamp_submit_time","value":"1704974164"},{"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":"44f3da7abc26214cd2f43f809f8b042d10f2f715bd1a7591f37348cbb18bfeb8","submit_time":"1704974164","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":"126579"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["whrkqbT0q3jXEpkGr79hQf8u2JaIaFtGfAXyRE3S591qUxVBQlnp6KXJQdefKG1XfyJSLLxizcCFUgGPlUB9BA=="]},"timestamp":"2024-01-11T11:56:02Z","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/126579","index":true}]},{"type":"tx","attributes":[{"key":"signature","value":"whrkqbT0q3jXEpkGr79hQf8u2JaIaFtGfAXyRE3S591qUxVBQlnp6KXJQdefKG1XfyJSLLxizcCFUgGPlUB9BA==","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":"126544","index":true},{"key":"beacon_timestamp_id_pruned","value":"76544","index":true},{"key":"beacon_timestamp_hash","value":"44f3da7abc26214cd2f43f809f8b042d10f2f715bd1a7591f37348cbb18bfeb8","index":true},{"key":"beacon_timestamp_submit_time","value":"1704974164","index":true},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true}]}]}}

Hash Comparison

Hash stored in database: 44f3da7abc26214cd2f43f809f8b042d10f2f715bd1a7591f37348cbb18bfeb8

Hash from Mainchain Tx: 44f3da7abc26214cd2f43f809f8b042d10f2f715bd1a7591f37348cbb18bfeb8

Dynamically generated hash: 44f3da7abc26214cd2f43f809f8b042d10f2f715bd1a7591f37348cbb18bfeb8

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":"David Rodriguez Lopez","date":"2023-09-28","manner_of_death":"Police Shooting","armed_with":"vehicle","age":"30","gender":"male","race":"W","race_source":"public_record","city":"Idabel","state":"OK","was_mental_illness_related":"False","threat_type":"point","flee_status":"car","body_camera":"False","location_precision":"","agency_ids":"101;13645;1367"}},"evidenceLinks":[],"locationCity":"Idabel","locationCountry":"US","locationHasGeo":false,"locationLat":0,"locationLong":0,"locationState":"Oklahoma","locationStateCode":"OK","month":9,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1695859200,"sourceId":"9765","sourceRawData":"{\"id\":\"9765\",\"date\":\"2023-09-28\",\"threat_type\":\"point\",\"flee_status\":\"car\",\"armed_with\":\"vehicle\",\"city\":\"Idabel\",\"county\":\"McCurtain\",\"state\":\"OK\",\"latitude\":\"\",\"longitude\":\"\",\"location_precision\":\"\",\"name\":\"David Rodriguez Lopez\",\"age\":\"30\",\"gender\":\"male\",\"race\":\"W\",\"race_source\":\"public_record\",\"was_mental_illness_related\":\"False\",\"body_camera\":\"False\",\"agency_ids\":\"101;13645;1367\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/v2/fatal-police-shootings-data.csv","title":"David Rodriguez Lopez, 30, from Idabel, Oklahoma - undefined on 28 September 2023","updateHistory":[],"victimAge":30,"victimArmed":"Vehicle","victimGender":"male","victimName":"David Rodriguez Lopez","victimRace":"White/European American","year":2023}