Public Accountability Chain

September 3, 2023 | Alliance, Ohio

George Appleby, 59, from Alliance, Ohio - undefined on 3 September 2023

Victim Info

NameGeorge Appleby
RaceWhite/European American
Age59
Gendermale

Details

Additional Evidence

NameGeorge Appleby
Date2023-09-03
Manner Of DeathPolice Shooting
Armed Withknife
Age59
Gendermale
RaceW
Race Sourcepublic_record
CityAlliance
StateOH
Was Mental Illness RelatedFalse
Threat Typethreat
Flee Statusnot
Body CameraFalse
Location Precisionblock
Agency Ids4019

Source

Source ID: 9485 - Washington Post

BEACON Data

Mainchain details

The BEACON hash was timestamped at Fri, 08 Sep 2023 00:30:31 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 126242. Submitted in Mainchain Tx DF3535BB2140754CFEAC731F1A7DFAB4408D200B293BE41DC7389F4FE8D06A95, at block height 6846559

Transaction details

Tx DF3535BB2140754CFEAC731F1A7DFAB4408D200B293BE41DC7389F4FE8D06A95
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: JT9zDJUw67EHGhWZEZWb4ux1ZPRjYKGUwP3UtnSLPfEBW9Tqh96+OMEUrG+SfNeHguLi7UAUghfHfkcpCi7Ikw==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"c794afef22d4d169df81e648e80073ea0f94af23c75edd353157e6fcd941acb6","submit_time":"1694133031","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":"126277"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["JT9zDJUw67EHGhWZEZWb4ux1ZPRjYKGUwP3UtnSLPfEBW9Tqh96+OMEUrG+SfNeHguLi7UAUghfHfkcpCi7Ikw=="]},"tx_response":{"height":"6846559","txhash":"DF3535BB2140754CFEAC731F1A7DFAB4408D200B293BE41DC7389F4FE8D06A95","codespace":"","code":0,"data":"0A370A2D2F6D61696E636861696E2E626561636F6E2E76312E4D73675265636F7264426561636F6E54696D657374616D701206080410A2DA07","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\":\"126242\"},{\"key\":\"beacon_timestamp_id_pruned\",\"value\":\"76242\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"c794afef22d4d169df81e648e80073ea0f94af23c75edd353157e6fcd941acb6\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1694133031\"},{\"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":"126242"},{"key":"beacon_timestamp_id_pruned","value":"76242"},{"key":"beacon_timestamp_hash","value":"c794afef22d4d169df81e648e80073ea0f94af23c75edd353157e6fcd941acb6"},{"key":"beacon_timestamp_submit_time","value":"1694133031"},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk"}]}]}],"info":"","gas_wanted":"250000","gas_used":"122588","tx":{"@type":"/cosmos.tx.v1beta1.Tx","body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"c794afef22d4d169df81e648e80073ea0f94af23c75edd353157e6fcd941acb6","submit_time":"1694133031","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":"126277"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["JT9zDJUw67EHGhWZEZWb4ux1ZPRjYKGUwP3UtnSLPfEBW9Tqh96+OMEUrG+SfNeHguLi7UAUghfHfkcpCi7Ikw=="]},"timestamp":"2023-09-08T00:30:29Z","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/126277","index":true}]},{"type":"tx","attributes":[{"key":"signature","value":"JT9zDJUw67EHGhWZEZWb4ux1ZPRjYKGUwP3UtnSLPfEBW9Tqh96+OMEUrG+SfNeHguLi7UAUghfHfkcpCi7Ikw==","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":"126242","index":true},{"key":"beacon_timestamp_id_pruned","value":"76242","index":true},{"key":"beacon_timestamp_hash","value":"c794afef22d4d169df81e648e80073ea0f94af23c75edd353157e6fcd941acb6","index":true},{"key":"beacon_timestamp_submit_time","value":"1694133031","index":true},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk","index":true}]}]}}

Hash Comparison

Hash stored in database: c794afef22d4d169df81e648e80073ea0f94af23c75edd353157e6fcd941acb6

Hash from Mainchain Tx: c794afef22d4d169df81e648e80073ea0f94af23c75edd353157e6fcd941acb6

Dynamically generated hash: c794afef22d4d169df81e648e80073ea0f94af23c75edd353157e6fcd941acb6

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":"George Appleby","date":"2023-09-03","manner_of_death":"Police Shooting","armed_with":"knife","age":"59","gender":"male","race":"W","race_source":"public_record","city":"Alliance","state":"OH","was_mental_illness_related":"False","threat_type":"threat","flee_status":"not","body_camera":"False","location_precision":"block","agency_ids":"4019"}},"evidenceLinks":[],"locationCity":"Alliance","locationCountry":"US","locationHasGeo":true,"locationLat":40.91346620252899,"locationLong":-81.10021227353437,"locationState":"Ohio","locationStateCode":"OH","month":9,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1693699200,"sourceId":"9485","sourceRawData":"{\"id\":\"9485\",\"date\":\"2023-09-03\",\"threat_type\":\"threat\",\"flee_status\":\"not\",\"armed_with\":\"knife\",\"city\":\"Alliance\",\"county\":\"Stark\",\"state\":\"OH\",\"latitude\":\"40.91346620252899\",\"longitude\":\"-81.10021227353437\",\"location_precision\":\"block\",\"name\":\"George Appleby\",\"age\":\"59\",\"gender\":\"male\",\"race\":\"W\",\"race_source\":\"public_record\",\"was_mental_illness_related\":\"False\",\"body_camera\":\"False\",\"agency_ids\":\"4019\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/v2/fatal-police-shootings-data.csv","title":"George Appleby, 59, from Alliance, Ohio - undefined on 3 September 2023","updateHistory":[],"victimAge":59,"victimArmed":"Knife","victimGender":"male","victimName":"George Appleby","victimRace":"White/European American","year":2023}