Juan Adrian Garcia, 47, from Napa, California

October 5, 2020 | Napa, California

Juan Adrian Garcia, 47, from Napa, California - shot on 5 October 2020

Victim Info

NameJuan Adrian Garcia
RaceHispanic/Latino
Age47
GenderMale

Details

Additional Evidence

NameJuan Adrian Garcia
Date2020-10-05
Manner Of Deathshot
Armedunarmed
Age47
GenderM
RaceH
CityNapa
StateCA
Signs Of Mental IllnessFalse
Threat Levelother
FleeNot fleeing
Body CameraTrue

Source

Source ID: 6221 - Washington Post

Cross References

This report has possible entries from multiple sources

Fatal Encounters -Juan Adrian Garcia, 47, from Napa, California, on 5 October 2020
Killed By Police -Juan Adrian Garcia, 47, from California on 5 October 2020

BEACON Data

Mainchain details

The BEACON hash was timestamped at Sat, 18 Jun 2022 09:04:33 GMT and successfully submitted to Mainchain. The BEACON Timestamp ID is 67563. Submitted in Mainchain Tx EBF0D55F9C4B28B5BD2E4631710FB3D91A7FBC5962E76E3F8872E224547846FA, at block height 145717

Transaction details

Tx EBF0D55F9C4B28B5BD2E4631710FB3D91A7FBC5962E76E3F8872E224547846FA
Sent from: und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk
Public Key Type: /cosmos.crypto.secp256k1.PubKey
Public Key: A675rrH9WWpxIibCwaEs18WyVdsrByOXRqVay8/b8hGh
Signature: HENJzeKbE8i4aHlEO0CiuUJbEa0x9I4uc7SUMPHl4z08YiYLBMW5pqVCgjjxXBa8woFowxnztqnZhi539ohnJA==
Raw Tx data: {"tx":{"body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"d4b08d27d9dc43825f89ed0bc25b85a375671fa19490a30878921546ad23f23d","submit_time":"1655543073","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":"67598"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["HENJzeKbE8i4aHlEO0CiuUJbEa0x9I4uc7SUMPHl4z08YiYLBMW5pqVCgjjxXBa8woFowxnztqnZhi539ohnJA=="]},"tx_response":{"height":"145717","txhash":"EBF0D55F9C4B28B5BD2E4631710FB3D91A7FBC5962E76E3F8872E224547846FA","codespace":"","code":0,"data":"0A210A177265636F72645F626561636F6E5F74696D657374616D701206080410EB8F04","raw_log":"[{\"events\":[{\"type\":\"message\",\"attributes\":[{\"key\":\"action\",\"value\":\"record_beacon_timestamp\"},{\"key\":\"module\",\"value\":\"beacon\"}]},{\"type\":\"record_beacon_timestamp\",\"attributes\":[{\"key\":\"beacon_id\",\"value\":\"4\"},{\"key\":\"beacon_timestamp_id\",\"value\":\"67563\"},{\"key\":\"beacon_timestamp_hash\",\"value\":\"d4b08d27d9dc43825f89ed0bc25b85a375671fa19490a30878921546ad23f23d\"},{\"key\":\"beacon_timestamp_submit_time\",\"value\":\"1655543073\"},{\"key\":\"beacon_owner\",\"value\":\"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk\"}]}]}]","logs":[{"msg_index":0,"log":"","events":[{"type":"message","attributes":[{"key":"action","value":"record_beacon_timestamp"},{"key":"module","value":"beacon"}]},{"type":"record_beacon_timestamp","attributes":[{"key":"beacon_id","value":"4"},{"key":"beacon_timestamp_id","value":"67563"},{"key":"beacon_timestamp_hash","value":"d4b08d27d9dc43825f89ed0bc25b85a375671fa19490a30878921546ad23f23d"},{"key":"beacon_timestamp_submit_time","value":"1655543073"},{"key":"beacon_owner","value":"und1hf4jjflctvxcfxh5mc47yqvugwcugm9xzevszk"}]}]}],"info":"","gas_wanted":"250000","gas_used":"99708","tx":{"@type":"/cosmos.tx.v1beta1.Tx","body":{"messages":[{"@type":"/mainchain.beacon.v1.MsgRecordBeaconTimestamp","beacon_id":"4","hash":"d4b08d27d9dc43825f89ed0bc25b85a375671fa19490a30878921546ad23f23d","submit_time":"1655543073","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":"67598"}],"fee":{"amount":[{"denom":"nund","amount":"1000000000"}],"gas_limit":"250000","payer":"","granter":""},"tip":null},"signatures":["HENJzeKbE8i4aHlEO0CiuUJbEa0x9I4uc7SUMPHl4z08YiYLBMW5pqVCgjjxXBa8woFowxnztqnZhi539ohnJA=="]},"timestamp":"2022-06-18T09:04:31Z","events":[{"type":"tx","attributes":[{"key":"YWNjX3NlcQ==","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3prLzY3NTk4","index":true}]},{"type":"tx","attributes":[{"key":"c2lnbmF0dXJl","value":"SEVOSnplS2JFOGk0YUhsRU8wQ2l1VUpiRWEweDlJNHVjN1NVTVBIbDR6MDhZaVlMQk1XNXBxVkNnamp4WEJhOHdvRm93eG56dHFuWmhpNTM5b2huSkE9PQ==","index":true}]},{"type":"und_unlocked","attributes":[{"key":"cHVyY2hhc2Vy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","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":"message","attributes":[{"key":"YWN0aW9u","value":"cmVjb3JkX2JlYWNvbl90aW1lc3RhbXA=","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":"Njc1NjM=","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9oYXNo","value":"ZDRiMDhkMjdkOWRjNDM4MjVmODllZDBiYzI1Yjg1YTM3NTY3MWZhMTk0OTBhMzA4Nzg5MjE1NDZhZDIzZjIzZA==","index":true},{"key":"YmVhY29uX3RpbWVzdGFtcF9zdWJtaXRfdGltZQ==","value":"MTY1NTU0MzA3Mw==","index":true},{"key":"YmVhY29uX293bmVy","value":"dW5kMWhmNGpqZmxjdHZ4Y2Z4aDVtYzQ3eXF2dWd3Y3VnbTl4emV2c3pr","index":true}]}]}}

Hash Comparison

Hash stored in database: d4b08d27d9dc43825f89ed0bc25b85a375671fa19490a30878921546ad23f23d

Hash from Mainchain Tx: d4b08d27d9dc43825f89ed0bc25b85a375671fa19490a30878921546ad23f23d

Dynamically generated hash: d4b08d27d9dc43825f89ed0bc25b85a375671fa19490a30878921546ad23f23d

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":"Juan Adrian Garcia","date":"2020-10-05","manner_of_death":"shot","armed":"unarmed","age":"47","gender":"M","race":"H","city":"Napa","state":"CA","signs_of_mental_illness":"False","threat_level":"other","flee":"Not fleeing","body_camera":"True"}},"evidenceLinks":[],"locationCity":"Napa","locationCountry":"US","locationHasGeo":false,"locationLat":0,"locationLong":0,"locationState":"California","locationStateCode":"CA","month":10,"source":"WashingtonPost","sourceAdditionalData":[],"sourceDatetime":1601856000,"sourceId":"6221","sourceRawData":"{\"id\":\"6221\",\"name\":\"Juan Adrian Garcia\",\"date\":\"2020-10-05\",\"manner_of_death\":\"shot\",\"armed\":\"unarmed\",\"age\":\"47\",\"gender\":\"M\",\"race\":\"H\",\"city\":\"Napa\",\"state\":\"CA\",\"signs_of_mental_illness\":\"False\",\"threat_level\":\"other\",\"flee\":\"Not fleeing\",\"body_camera\":\"True\",\"longitude\":\"-122.271\",\"latitude\":\"38.258\",\"is_geocoding_exact\":\"True\"}","sourceRawDataFormat":"json","sourceUrl":"https://raw.githubusercontent.com/washingtonpost/data-police-shootings/master/fatal-police-shootings-data.csv","title":"Juan Adrian Garcia, 47, from Napa, California - shot on 5 October 2020","updateHistory":[],"victimAge":47,"victimArmed":"Unarmed","victimGender":"Male","victimName":"Juan Adrian Garcia","victimRace":"Hispanic/Latino","year":2020}