Featured Post

QAnon: The Q-Sort Personality Profile Builder

Gettin Billy with It QAnon is based on Q-Sort: A psychological technique of which there are many variations, resulting in 50 descript...

Saturday, June 2, 2018

The "Russian" Botnet: Passes23.sqlite

The Apple store in Nashville, TN is closed for "renovations," in case you were wondering.  

This is from Passes23.sqlite under Passes:


Chaseville, NY
The DNC and DHS

U iC indexsqlite_autoindex_felica_transit_applet_state_1felica_transit_applet_state ë% 33 °qtablepayment_transactionpayment_transaction CREATE TABLE payment_transaction (pid INTEGER, pass_pid INTEGER NOT NULL, payment_application_pid INTEGER, identifier TEXT, service_identifier TEXT, payment_hash TEXT, payment_hash_component_1 TEXT, payment_hash_component_2 TEXT, currency_code TEXT, amount INTEGER, subtotal_amount INTEGER, locality TEXT, administrative_area TEXT, transaction_date INTEGER  NOT NULL, transaction_status_changed_date INTEGER, location_date INTEGER, location_latitude REAL, location_longitude REAL, location_altitude REAL, location_horizontal_accuracy REAL, location_vertical_accuracy REAL, start_station_code BLOB, start_station TEXT, end_station_code BLOB, end_station TEXT, transaction_status INTEGER, transaction_type INTEGER, transit_type INTEGER, transit_modifiers INTEGER, en_route INTEGER, station_code_provider TEXT, technology_type INTEGER, transaction_source INTEGER, has_notification_service_data INTEGER, processed_for_location INTEGER, processed_for_merchant_cleanup INTEGER, processed_for_stations INTEGER, merchant_name TEXT, merchant_maps_name TEXT, merchant_raw_name TEXT, merchant_industry_category TEXT, merchant_industry_code INTEGER, merchant_phone_number TEXT, merchant_maps_identifier INTEGER, merchant_result_provider_identifier INTEGER, merchant_url TEXT, merchant_location_latitude REAL, merchant_location_longitude REAL, merchant_postal_address TEXT, ocean INTEGER,board TEXT,beach TEXT,foreign_exchange_information_destination_currency_code TEXT,foreign_exchange_information_destination_amount INTEGER,foreign_exchange_information_exchange_rate TEXT,primary_funding_source_amount INTEGER,primary_funding_source_currency_code TEXT,secondary_funding_source_amount INTEGER,secondary_funding_source_currency_code TEXT,secondary_funding_source_network INTEGER,secondary_funding_source_dpan_suffix TEXT,secondary_funding_source_fpan_identifier TEXT,secondary_funding_source_description TEXT,request_device_score_identifier TEXT,send_device_score_identifier TEXT,device_score_identifiers_required INTEGER,device_score_identifiers_submitted INTEGER,metadata TEXT,is_cloud_kit_archived INTEGER,expiration_date INTEGER,adjustment_type INTEGER,PRIMARY KEY (pid))ÅG 55 Ç1tablepayment_express_modepayment_express_mode CREATE TABLE payment_express_mode (pid INTEGER, payment_application_pid INTEGER NOT NULL ON CONFLICT IGNORE, express_mode TEXT, PRIMARY KEY (pid))Ö 33 âStablepayment_applicationpayment_application CREATE TABLE payment_application (pid INTEGER, seid TEXT, aid TEXT, dpan_id TEXT, dpan_suffix TEXT, sanitized_dpan TEXT, fpan_id TEXT, fpan_suffix TEXT, state INTEGER, suspended_reason TEXT, supports_contactless_payment INTEGER, supports_in_app_payment INTEGER, supports_optional_authentication INTEGER, applet_data_format TEXT, applet_currency_code TEXT, payment_network_identifier INTEGER, pass_pid INTEGER, in_app_pin_required_amount INTEGER, in_app_pin_required_currency TEXT, display_name TEXT, auxiliary_application INTEGER,payment_type INTEGER, requires_deferred_authorization INTEGER, PRIMARY KEY (pid))Å !! ÉItablepass_grouppass_group CREATE TABLE pass_group (pid INTEGER, group_order INTEGER, pass_type_id TEXT, pass_style INTEGER, grouping_id TEXT, minimum_date INTEGER, maximum_date INTEGER, ingested_date INTEGER, nfc_enabled INTEGER, PRIMARY KEY (pid))Å K Å#indexpass_type_identifier_hash_indexpass_type CREATE INDEX pass_type_identifier_hash_index ON pass_type (identifier_hash)

I forgot to mention that this was routed through the state of (Southern) New York to the Ukraine.

© Copyright 2018, The Cyberculturalist

No comments: