Advertisement
cristobalsv

Insert Risk SQLite

May 12th, 2024 (edited)
18
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.98 KB | None | 0 0
  1. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('58', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594729709763', '0.125', 'N/A', 'No Risk', 'Low', '0.0', '1715036669780');
  2. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('57', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594727121091', '0.728', 'Signature Verification', 'Historical Risk', 'High', '700.0', '1715036464387');
  3. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('59', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594729971907', '0.079', 'N/A', 'No Risk', 'Low', '0.0', '1715036691711');
  4. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('60', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594730430659', '0.129', 'N/A', 'No Risk', 'Low', '0.0', '1715036730158');
  5. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('61', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594730692803', '0.297', 'N/A', 'No Risk', 'Low', '0.0', '1715036751890');
  6. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('62', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594731020483', '0.533', 'N/A', 'Historical Risk', 'Medium', '0.0', '1715036778917');
  7. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('63', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594731774147', '0.633', 'Signature Verification', 'Historical Risk', 'High', '600.0', '1715036814113');
  8. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('64', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594732331203', '0.973', 'Signature Verification', 'Historical Risk', 'High', '500.0', '1715036846694');
  9. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('65', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594732658883', '0.258', 'N/A', 'No Risk', 'Low', '0.0', '1715036875838');
  10. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('66', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594733412547', '0.512', 'N/A', 'Historical Risk', 'Medium', '0.0', '1715036938706');
  11. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "estimatedSaving", "datetime") VALUES ('67', 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5594733772995', '0.341', 'N/A', 'Historical Risk', 'Medium', '0.0', '1715036965537');
  12. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10340, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5611488116931', 0.152, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5611488116931","shippingAddress":{"address1":"754 Tyre Lane","city":"Grand Ridge","zip":"32442","province":"Florida","country":"United States","address2":null,"latitude":30.6176683,"longitude":-85.0211625,"country_code":"US","province_code":"FL"},"originalTotalPriceSet":{"shopMoney":{"amount":"100.00","currency_code":"USD"}}}', 0, '1715036965537');
  13. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10282, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825682833729', 0.017, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825682833729","shippingAddress":{"address1":"San Carlos Hotel","address2":null,"city":"New York","country":"United States","zip":"10022","latitude":40.7560154,"longitude":-73.971445,"countryCodeV2":"US","province":"New York","provinceCode":"NY"},"originalTotalPriceSet":{"shopMoney":{"amount":"200.0"}}}', 0, '1715036965537');
  14. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10275, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825679163713', 0.212, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825679163713","shippingAddress":{"address1":"2429 Solomon Lane","address2":null,"city":"Nashville","country":"United States","zip":"37207","latitude":null,"longitude":null,"countryCodeV2":"US","province":"Tennessee","provinceCode":"TN"},"originalTotalPriceSet":{"shopMoney":{"amount":"124.95"}}}', 0, '1715036965537');
  15. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10302, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825810432321', 0.326, 'N/A', 'Historical Risk', 'Medium', '{"id":"gid://shopify/Order/5825810432321","shippingAddress":{"address1":"4560 South Hydraulic Avenue","address2":null,"city":"Wichita","country":"United States","zip":"67216","latitude":37.613439,"longitude":-97.315321,"countryCodeV2":"US","province":"Kansas","provinceCode":"KS"},"originalTotalPriceSet":{"shopMoney":{"amount":"450.0"}}}', 0, '1715036965537');
  16. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10342, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5611526717635', 0.066, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5611526717635","shippingAddress":{"address1":"754 Tyre Lane","city":"Grand Ridge","zip":"32442","province":"Florida","country":"United States","address2":null,"latitude":30.6176683,"longitude":-85.0211625,"country_code":"US","province_code":"FL"},"originalTotalPriceSet":{"shopMoney":{"amount":"100.00","currency_code":"USD"}}}', 0, '1715036965537');
  17. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10301, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825809416513', 0.145, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825809416513","shippingAddress":{"address1":"105 Victoria St","address2":null,"city":"Toronto","country":"Canada","zip":"M5C 1N7","latitude":43.6521328,"longitude":-79.3777157,"countryCodeV2":"CA","province":"Ontario","provinceCode":"ON"},"originalTotalPriceSet":{"shopMoney":{"amount":"350.0"}}}', 0, '1715036965537');
  18. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10297, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825808892225', 0.115, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825808892225","shippingAddress":{"address1":"10068 Carinata Drive","address2":null,"city":"Elk Grove","country":"United States","zip":"95757","latitude":38.3920426,"longitude":-121.4040748,"countryCodeV2":"US","province":"California","provinceCode":"CA"},"originalTotalPriceSet":{"shopMoney":{"amount":"350.0"}}}', 0, '1715036965537');
  19. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10281, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825682309441', 0.598, 'N/A', 'Historical Risk', 'Medium', '{"id":"gid://shopify/Order/5825682309441","shippingAddress":{"address1":"151 O Connor St","address2":null,"city":"Ottawa","country":"Canada","zip":"K2P 2L8","latitude":45.4191176,"longitude":-75.6966166,"countryCodeV2":"CA","province":"Ontario","provinceCode":"ON"},"originalTotalPriceSet":{"shopMoney":{"amount":"400.0"}}}', 0, '1715036965537');
  20. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10279, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825680802113', 0.058, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825680802113","shippingAddress":{"address1":"123 West Main Street","address2":null,"city":"Independence","country":"United States","zip":"67301","latitude":37.2229568,"longitude":-95.7078961,"countryCodeV2":"US","province":"Kansas","provinceCode":"KS"},"originalTotalPriceSet":{"shopMoney":{"amount":"84.85"}}}', 0, '1715036965537');
  21. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10272, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825678311745', 0.212, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825678311745","shippingAddress":{"address1":"420 San Pedro Street","address2":null,"city":"Los Angeles","country":"United States","zip":"90013","latitude":34.04501279999999,"longitude":-118.243162,"countryCodeV2":"US","province":"California","provinceCode":"CA"},"originalTotalPriceSet":{"shopMoney":{"amount":"59.9"}}}', 0, '1715036965537');
  22. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10299, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825809252673', 0.243, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825809252673","shippingAddress":{"address1":"420 San Pedro Street","address2":null,"city":"Los Angeles","country":"United States","zip":"90013","latitude":34.04501279999999,"longitude":-118.243162,"countryCodeV2":"US","province":"California","provinceCode":"CA"},"originalTotalPriceSet":{"shopMoney":{"amount":"224.95"}}}', 0, '1715036965537');
  23. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10277, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825680179521', 0.949, 'Signature Verification', 'Historical Risk', 'High', '{"id":"gid://shopify/Order/5825680179521","shippingAddress":{"address1":"23 R Street Northwest","address2":null,"city":"Washington","country":"United States","zip":"20001","latitude":38.912843,"longitude":-77.0099687,"countryCodeV2":"US","province":"District of Columbia","provinceCode":"DC"},"originalTotalPriceSet":{"shopMoney":{"amount":"1109.85"}}}', 1109.85, '1715036965537');
  24. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10274, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825678541121', 0.838, 'Signature Verification', 'Historical Risk', 'High', '{"id":"gid://shopify/Order/5825678541121","shippingAddress":{"address1":"105 Victoria St","address2":null,"city":"Toronto","country":"Canada","zip":"M5C 1N7","latitude":43.6521328,"longitude":-79.3777157,"countryCodeV2":"CA","province":"Ontario","provinceCode":"ON"},"originalTotalPriceSet":{"shopMoney":{"amount":"2629.95"}}}', 2629.95, '1715036965537');
  25. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10280, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825681326401', 0.278, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5825681326401","shippingAddress":{"address1":"42 Main St","address2":null,"city":"Copan","country":"United States","zip":"74022","latitude":36.9157208,"longitude":-95.8024753,"countryCodeV2":"US","province":"Oklahoma","provinceCode":"OK"},"originalTotalPriceSet":{"shopMoney":{"amount":"244.85"}}}', 0, '1715036965537');
  26. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10303, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5825811317057', 0.313, 'N/A', 'Historical Risk', 'Medium', '{"id":"gid://shopify/Order/5825811317057","shippingAddress":{"address1":"5789 Graham Road","address2":null,"city":"Whiteland","country":"United States","zip":"46184","latitude":39.5626586,"longitude":-86.0563909,"countryCodeV2":"US","province":"Indiana","provinceCode":"IN"},"originalTotalPriceSet":{"shopMoney":{"amount":"400.0"}}}', 0, '1715036965537');
  27. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10344, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5614501200067', 0.056, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5614501200067","shippingAddress":{"address1":"754 Tyre Lane","city":"Grand Ridge","zip":"32442","province":"Florida","country":"United States","address2":null,"latitude":30.6176683,"longitude":-85.0211625,"country_code":"US","province_code":"FL"},"originalTotalPriceSet":{"shopMoney":{"amount":"10.00","currency_code":"USD"}}}', 0, '1715036965537');
  28. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10345, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5615495872707', 0.265, 'N/A', 'No Risk', 'Low', '{"id":"gid://shopify/Order/5615495872707","shippingAddress":{"address1":"2454 County Road 4500","city":"Coffeyville","zip":"67337","province":"Kansas","country":"United States","address2":null,"latitude":37.08763,"longitude":-95.65500999999999,"country_code":"US","province_code":"KS"},"originalTotalPriceSet":{"shopMoney":{"amount":"200.00","currency_code":"USD"}}}', 0, '1715036965537');
  29. INSERT INTO "main"."RiskScore" ("id", "shopName", "orderId", "score", "recommendedAction", "categoryOfRisk", "riskLabel", "orderInfo", "estimatedSaving", "datetime") VALUES (10346, 'deliverlitics-store.myshopify.com', 'gid://shopify/Order/5615497412803', 0.952, 'Signature Verification', 'Historical Risk', 'High', '{"id":"gid://shopify/Order/5615497412803","shippingAddress":{"address1":"21407 Virginia Drive","city":"Hollister","zip":"95023","province":"California","country":"United States","address2":null,"latitude":null,"longitude":null,"country_code":"US","province_code":"CA"},"originalTotalPriceSet":{"shopMoney":{"amount":"1359.90","currency_code":"USD"}}}', 1359.9, '1715036965537');
  30.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement