Public Accountability Chain

March 25, 2024 | Waterloo, Iowa

John Piazza, 41, from Waterloo, Iowa - undefined on 25 March 2024

Victim Info

NameJohn Piazza
RaceUnknown
Age41
Gendermale

Details

Additional Evidence

NameJohn Piazza
Date2024-03-25
Manner Of DeathPolice Shooting
Armed Withgun
Age41
Gendermale
Race
Race Source
CityWaterloo
StateIA
Was Mental Illness RelatedFalse
Threat Typepoint
Flee Status
Body CameraFalse
Location Precisionaddress
Agency Ids3270

Source

Source ID: 10268 - Washington Post

BEACON Data

Mainchain details

The BEACON hash was timestamped at Fri, 05 Apr 2024 00:30:14 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 127006. Submitted in Mainchain Tx 409AF3AB44F5D9F14D48B68775D2BCBAC5B08C0B961A679144D7C039604170D0, at block height 10008552

Transaction details

Tx 409AF3AB44F5D9F14D48B68775D2BCBAC5B08C0B961A679144D7C039604170D0
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: zsOL+nn1IkjBntp1bgEv3FONXWdrKhPgLhw3vzCEPEoBdGdBdPTwjhz+NIL35ZxYc7nnbekNyPe1/V4yiI5npA==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"e233caadead263953f497f1ae165f53348807c9cd093f95d9b35e0697357572d","submit_time":"1712277014","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":"127041"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["zsOL+nn1IkjBntp1bgEv3FONXWdrKhPgLhw3vzCEPEoBdGdBdPTwjhz+NIL35ZxYc7nnbekNyPe1/V4yiI5npA=="]},"tx_response":{"height":"10008552","txhash":"409AF3AB44F5D9F14D48B68775D2BCBAC5B08C0B961A679144D7C039604170D0","codespace":"","code":0,"data":"123F0A352F6D61696E636861696E2E626561636F6E2E76312E4D73675265636F7264426561636F6E54696D657374616D70526573706F6E736512060804109EE007","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\":\"127006\"},{\"key\":\"beacon_timestamp_id_pruned\",\"value\":\"77006\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"e233caadead263953f497f1ae165f53348807c9cd093f95d9b35e0697357572d\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1712277014\"},{\"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":"127006"},{"key":"beacon_timestamp_id_pruned","value":"77006"},{"key":"beacon_timestamp_hash","value":"e233caadead263953f497f1ae165f53348807c9cd093f95d9b35e0697357572d"},{"key":"beacon_timestamp_submit_time","value":"1712277014"},{"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":"e233caadead263953f497f1ae165f53348807c9cd093f95d9b35e0697357572d","submit_time":"1712277014","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":"127041"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["zsOL+nn1IkjBntp1bgEv3FONXWdrKhPgLhw3vzCEPEoBdGdBdPTwjhz+NIL35ZxYc7nnbekNyPe1/V4yiI5npA=="]},"timestamp":"2024-04-05T00:30:12Z","events":[{"type":"coin_spent","attributes":[{"key":"c3BlbmRlcg==","value":"dW5kMW53dDZjaG5rMGVmZThuZ3dhNXk2M2VnbWR1bWh0NmFybHZsdWgz","index":true},{"key":"YW1vdW50","value":"MTAwMDAwMDAwMG51bmQ=","index":true}]},{"type":"coin_received","attributes":[{"key":"cmVjZWl2ZXI=","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true},{"key":"YW1vdW50","value":"MTAwMDAwMDAwMG51bmQ=","index":true}]},{"type":"und_unlocked","attributes":[{"key":"cHVyY2hhc2Vy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true},{"key":"YW1vdW50","value":"MTAwMDAwMDAwMG51bmQ=","index":true}]},{"type":"coin_spent","attributes":[{"key":"c3BlbmRlcg==","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true},{"key":"YW1vdW50","value":"MTAwMDAwMDAwMG51bmQ=","index":true}]},{"type":"coin_received","attributes":[{"key":"cmVjZWl2ZXI=","value":"dW5kMTd4cGZ2YWttMmFtZzk2MnlsczZmODR6M2tlbGw4YzVsaHV5ZmRt","index":true},{"key":"YW1vdW50","value":"MTAwMDAwMDAwMG51bmQ=","index":true}]},{"type":"transfer","attributes":[{"key":"cmVjaXBpZW50","value":"dW5kMTd4cGZ2YWttMmFtZzk2MnlsczZmODR6M2tlbGw4YzVsaHV5ZmRt","index":true},{"key":"c2VuZGVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true},{"key":"YW1vdW50","value":"MTAwMDAwMDAwMG51bmQ=","index":true}]},{"type":"message","attributes":[{"key":"c2VuZGVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true}]},{"type":"tx","attributes":[{"key":"ZmVl","value":"MTAwMDAwMDAwMG51bmQ=","index":true},{"key":"ZmVlX3BheWVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true}]},{"type":"tx","attributes":[{"key":"YWNjX3NlcQ==","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3prLzEyNzA0MQ==","index":true}]},{"type":"tx","attributes":[{"key":"c2lnbmF0dXJl","value":"enNPTCtubjFJa2pCbnRwMWJnRXYzRk9OWFdkcktoUGdMaHczdnpDRVBFb0JkR2RCZFBUd2poeitOSUwzNVp4WWM3bm5iZWtOeVBlMS9WNHlpSTVucEE9PQ==","index":true}]},{"type":"message","attributes":[{"key":"YWN0aW9u","value":"L21haW5jaGFpbi5iZWFjb24udjEuTXNnUmVjb3JkQmVhY29uVGltZXN0YW1w","index":true}]},{"type":"message","attributes":[{"key":"bW9kdWxl","value":"YmVhY29u","index":true}]},{"type":"record_beacon_timestamp","attributes":[{"key":"YmVhY29uX2lk","value":"NA==","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9pZA==","value":"MTI3MDA2","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9pZF9wcnVuZWQ=","value":"NzcwMDY=","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9oYXNo","value":"ZTIzM2NhYWRlYWQyNjM5NTNmNDk3ZjFhZTE2NWY1MzM0ODgwN2M5Y2QwOTNmOTVkOWIzNWUwNjk3MzU3NTcyZA==","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9zdWJtaXRfdGltZQ==","value":"MTcxMjI3NzAxNA==","index":true},{"key":"YmVhY29uX293bmVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true}]}]}}

Hash Comparison

Hash stored in database: e233caadead263953f497f1ae165f53348807c9cd093f95d9b35e0697357572d

Hash from Mainchain Tx: 77006

Dynamically generated hash: e233caadead263953f497f1ae165f53348807c9cd093f95d9b35e0697357572d

Hashes Match?

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 Piazza","date":"2024-03-25","manner_of_death":"Police Shooting","armed_with":"gun","age":"41","gender":"male","race":"","race_source":"","city":"Waterloo","state":"IA","was_mental_illness_related":"False","threat_type":"point","flee_status":"","body_camera":"False","location_precision":"address","agency_ids":"3270"}},"evidenceLinks":[],"locationCity":"Waterloo","locationCountry":"US","locationHasGeo":true,"locationLat":42.499199034657856,"locationLong":-92.38078527116473,"locationState":"Iowa","locationStateCode":"IA","month":3,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1711324800,"sourceId":"10268","sourceRawData":"{\"id\":\"10268\",\"date\":\"2024-03-25\",\"threat_type\":\"point\",\"flee_status\":\"\",\"armed_with\":\"gun\",\"city\":\"Waterloo\",\"county\":\"Black Hawk\",\"state\":\"IA\",\"latitude\":\"42.499199034657856\",\"longitude\":\"-92.38078527116473\",\"location_precision\":\"address\",\"name\":\"John Piazza\",\"age\":\"41\",\"gender\":\"male\",\"race\":\"\",\"race_source\":\"\",\"was_mental_illness_related\":\"False\",\"body_camera\":\"False\",\"agency_ids\":\"3270\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/v2/fatal-police-shootings-data.csv","title":"John Piazza, 41, from Waterloo, Iowa - undefined on 25 March 2024","updateHistory":[],"victimAge":41,"victimArmed":"Gun","victimGender":"male","victimName":"John Piazza","victimRace":"Unknown","year":2024}