SQLite Web: db.sqlite3

id

Primary key. INTEGER NOT NULL

raingull_id

char(32) NOT NULL

status

varchar(20) NOT NULL

service_message_id

varchar(255)

subject

varchar(255)

sender

varchar(255)

timestamp

datetime

payload

{"content": "Mary - 360-531-0200 - maryjcrozier@gmail.com\r\nDavid- 360-531-0557 - david_crozier28@msn.com\r\nMike - 206-715-0298 - michaelcrozier111@gmail.com\r\n\r\nOn Sun, Oct 5, 2025 at 6:47\u202fPM Ashley Schenkel <ashley.schenkel@gmail.com>\r\nwrote:\r\n\r\n> Hey bloody green monsters!\r\n>\r\n> I\u2019m working on our rehearsal schedule, and it would be helpful for me to\r\n> have your contact info (text # or email address) so I can get the most\r\n> people to the read throughs. I don\u2019t want to fill up your inbox asking one\r\n> person a question on the group chat. Thanks!\r\n>\r\n> Gore & Grime,\r\n>\r\n> Ashley\r\n> (619) 822-8142\r\n> Ashley.Schenkel@gmail.com\r\n>\r\n> *\"I cannot do all the good that the world needs, but the world needs all\r\n> the good that I can do.\" ~Jana Stanfield*\r\n>\r\n> --\r\n> You received this message because you are subscribed to the Google Groups\r\n> \"Port Townsend Murder Mysteries\" group.\r\n> To unsubscribe from this group and stop receiving emails from it, send an\r\n> email to ptmurder+unsubscribe@googlegroups.com.\r\n> To view this discussion visit\r\n> https://groups.google.com/d/msgid/ptmurder/CAFRDBvenTDCS0ryGgLuoE7aGmd%3D2-d45ukbQsBwv%3DGJ9S5n2QQ%40mail.gmail.com\r\n> <https://groups.google.com/d/msgid/ptmurder/CAFRDBvenTDCS0ryGgLuoE7aGmd%3D2-d45ukbQsBwv%3DGJ9S5n2QQ%40mail.gmail.com?utm_medium=email&utm_source=footer>\r\n> .\r\n>\r\n\r\n-- \r\nYou received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\nTo unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\nTo view this discussion visit https://groups.google.com/d/msgid/ptmurder/CA%2BgCv2cPc9O%2BGG5_n-Rrq_DrcDRGz3Azahc19U0GbHKjGLWZjQ%40mail.gmail.com.\r\n", "attachments": [], "metadata": {"subject": "Re: Rehearsal Scheduling", "date": "Sun, 5 Oct 2025 18:51:03 -0700", "headers": {"Return-Path": "<ptmurder+bncBCNODQHT7QJRBL6BRTDQMGQEXPZD2DI@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "by mail-lj1-x235.google.com with SMTP id 38308e7fff4ca-36a6a39752bso45321911fa.0\r\n        for <ptmurder@googlegroups.com>; Sun, 05 Oct 2025 18:51:40 -0700 (PDT)", "Return-path": "<ptmurder+bncBCNODQHT7QJRBL6BRTDQMGQEXPZD2DI@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Mon, 06 Oct 2025 01:51:44 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1759715500; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=TIGHOP/wMJ7xxJ9kuWSz+I+izoGMANkyO69CrqqM46y7gJHJutSmxNvVDzvwT/cBl7\r\n         462tgUZTewRhya6qWvJksuNR5N7fLe9n6CVAR2bvwbwMcw6nMriyc1UDREsxYpawL5BZ\r\n         zmRNp9AC9oKXB6P9c7fXPDAXmc7V/WS5STIgG2Gi8J/hh++JTVu2yO6Dfsdv5/JMG07N\r\n         ojZ141hCSumn6Je10lcvRKKVnVP8M3TWxNsokt3sRy0rJtNfLVmUv0DO5582VBRTCMDK\r\n         zKA0rpwBxJPR79ZE7t452pWUPjRfIGlE8tuPMTPCnWZr0ae6opGMAhkG/OK35gGQu78m\r\n         9PyA==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=to:subject:message-id:date:from:in-reply-to:references:mime-version\r\n         :dkim-signature;\r\n        bh=ly51dyA8xd8iIEuVvmRejDGvA2ifCp9RaxKkmcG+kzY=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=jswtKrRPiusS00ToImFIRvDhHSqgyZmFMMNxHJm5KAdG9Epf06Ut3XD5INDg90wZv3\r\n         RqsP710k/MvA8wUJixU/N08H8kvFQ+eIDicbVS4g2kjcROeuc/v+HNBD6PNvly6rcXNP\r\n         g3NeanJ8IO6KX4pfsby8NQfM3B1UHDkMPkRMKZ+IdLF1/Lsg2+07utbpKfOPaMh/bMUE\r\n         XJun8e1qDoSJXV0wtvws4xphvCvX/3lA99P8bVEnHT9fm5FZXdo0rpmE3MQzcGvpx8qH\r\n         Ohn8Kv88iYx521c2ndluEU24r9dHlXMVDzCkk7zfC5/snYcXbGOTH3tBI6xtxKYeqLf+\r\n         6Smw==;\r\n        dara=google.com", "ARC-Authentication-Results": "i=1; gmr-mx.google.com;\r\n       dkim=pass header.i=@gmail.com header.s=20230601 header.b=ZGCiCJqb;\r\n       spf=pass (google.com: domain of maryjcrozier@gmail.com designates 2a00:1450:4864:20::235 as permitted sender) smtp.mailfrom=maryjcrozier@gmail.com;\r\n       dmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;\r\n       dara=pass header.i=@googlegroups.com", "DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=gmail.com; s=20230601; t=1759715504; x=1760320304; darn=raingull.org;\r\n        h=list-unsubscribe:list-archive:list-help:list-post:list-id\r\n         :mailing-list:precedence:reply-to:x-original-authentication-results\r\n         :x-original-sender:to:subject:message-id:date:from:in-reply-to\r\n         :references:mime-version:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=xFEotZTbO9PYQfY647ujtJbw+Vu6rpZilI/nTqAUMLU=;\r\n        b=j5Jpfuqm4CQVqWE5wGqrfI/x4G2ItXUWZFyx+CjURKNct02qm+LvxsvFYLR1DwDTHD\r\n         25nKN6+K7v5gtl6FdgP8YkymngD0CWAkv2YiAl1gen79ZYkbIEB3vd5r7drx2afwun7e\r\n         c2ERVT6GNgIsU+NOucMEaAGWtKk74HE+HKmA0JxnOVQ7fLIoosW5XWYPxUtVLYOAIC9+\r\n         eMuQVIYY1ZZuLHTfkmANVC6CCUKyN2a4ekNo600e+B1aNjwSFDv+fho+OP2kPZPAwucP\r\n         g05SN/tEBJEEaTMUFc3sBWQA6qSlwIMkcAZ/GuO+r1DsbjRgeHb/ReChXnXWVR/5OJ+q\r\n         8sLg==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1759715504; x=1760320304;\r\n        h=list-unsubscribe:list-archive:list-help:list-post\r\n         :x-spam-checked-in-group:list-id:mailing-list:precedence:reply-to\r\n         :x-original-authentication-results:x-original-sender:to:subject\r\n         :message-id:date:from:in-reply-to:references:mime-version\r\n         :x-beenthere:x-gm-message-state:sender:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=xFEotZTbO9PYQfY647ujtJbw+Vu6rpZilI/nTqAUMLU=;\r\n        b=e3Fapg7yGcBssGf77Ow8nzpd6H4jx5Y9X9u+N1AoiTbkzJhLhUh9HZkE3IuvZQ8Nw4\r\n         xMGBwUSHXFox/dDCyLKk5IQguzJZG5g4LCsSDN/vHujRvvDen/QLTsoz5Zhjs9W3Fiul\r\n         eGfRYjwxSv/YG3lXpYSw/LiIK5IZr3aQjI0iGOWS1ZfybtFedJt6bGSr9krq3BhWfsUF\r\n         31t6TjpNeW8dh90lMtG5L5XZQvA1qmsCOlOPazd3f2Y9rDH4aGvILhKPoBLoeZbUpWAv\r\n         jLJDXGIHupTY0amFEMAH9HuImz6GsXW2PIkef3neCdcP1RnqnHxfwdohFXcCr7wLivSy\r\n         EwdQ==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCWv8qu6zP6dWrg+HaFoLimmcgJQIYtS7B1qJZdJDHyEuwqtFVptaQYhCL2wPEewUJl2ve6B@raingull.org", "X-Gm-Message-State": "AOJu0YxftoLl4Ro1trTsLVOwo5N9+gtU1B0Cco225nr1pAIJf1SS3R53\r\n\tndC4V4PXWSYqzwbjg0PfxsV8ISEL79JT061tFIwl+J2HssiVpcIS7Ek=", "X-Google-Smtp-Source": "AGHT+IEM3WRVLJyZW9Vk9HSHSEsJ10m2ayFvtYlyyax81u86KowXJ92ZHTr6RJCtgSeR2+zS6i3bhQ==", "X-Received": "by 2002:a05:651c:2127:b0:372:90ab:8bbe with SMTP id\r\n 38308e7fff4ca-374c36f4df0mr32675061fa.17.1759715499535; Sun, 05 Oct 2025\r\n 18:51:39 -0700 (PDT)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"ARHlJd64CTs8ylneTSFnb4ZyxBAlppEEAphBmiVwYNZn7KCmeg==\"", "Received-SPF": "pass (google.com: domain of maryjcrozier@gmail.com designates 2a00:1450:4864:20::235 as permitted sender) client-ip=2a00:1450:4864:20::235;", "X-Gm-Gg": "ASbGnctdwMFJhA78obE/Vr1V60a7rw6dLMq0Ga4odPgl6Mx3HRkOfw4plhWZKchDtUR\r\n\tNKbnTKVvFN0y6h+cZYOPwc/mYv9Pay1iIGk9uQizmsjEkVUL2AZHbSVrXOl7XQu7KRO3/BMuN/l\r\n\tGzDn/31yid6TgfEE/QkoAyzwh9kmJb5HmUvhfu1UO5Tj+NyhfxZDftDyOeV/DAU2zyPqcyxhv5f\r\n\tUTWZAk/CwVLyEgEMQ8CUpDsXIKx3L+V196+NdEtYSxOCIgsbfev4w==", "MIME-Version": "1.0", "References": "<CAFRDBvenTDCS0ryGgLuoE7aGmd=2-d45ukbQsBwv=GJ9S5n2QQ@mail.gmail.com>", "In-Reply-To": "<CAFRDBvenTDCS0ryGgLuoE7aGmd=2-d45ukbQsBwv=GJ9S5n2QQ@mail.gmail.com>", "From": "Mary Crozier <maryjcrozier@gmail.com>", "Date": "Sun, 5 Oct 2025 18:51:03 -0700", "X-Gm-Features": "AS18NWBq0hhuDZZfO6nH4715rz-OFcQVi-gVblIddY4K1mBkMGzeZpbD8o_xfx0", "Message-ID": "<CA+gCv2cPc9O+GG5_n-Rrq_DrcDRGz3Azahc19U0GbHKjGLWZjQ@mail.gmail.com>", "Subject": "Re: Rehearsal Scheduling", "To": "ptmurder@googlegroups.com", "Content-Type": "multipart/alternative; boundary=\"000000000000417134064073b1d0\"", "X-Original-Sender": "maryjcrozier@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=ZGCiCJqb;       spf=pass\r\n (google.com: domain of maryjcrozier@gmail.com designates 2a00:1450:4864:20::235\r\n as permitted sender) smtp.mailfrom=maryjcrozier@gmail.com;       dmarc=pass\r\n (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;       dara=pass header.i=@googlegroups.com", "Reply-To": "ptmurder@googlegroups.com", "Precedence": "list", "Mailing-list": "list ptmurder@googlegroups.com; contact ptmurder+owners@googlegroups.com", "List-ID": "<ptmurder.googlegroups.com>", "X-Spam-Checked-In-Group": "ptmurder@googlegroups.com", "X-Google-Group-Id": "27968096625", "List-Post": "<https://groups.google.com/group/ptmurder/post>, <mailto:ptmurder@googlegroups.com>", "List-Help": "<https://groups.google.com/support/>, <mailto:ptmurder+help@googlegroups.com>", "List-Archive": "<https://groups.google.com/group/ptmurder", "List-Unsubscribe": "<mailto:googlegroups-manage+27968096625+unsubscribe@googlegroups.com>,\r\n <https://groups.google.com/group/ptmurder/subscribe>", "X-DKIM": "signer='gmail.com' status='pass' reason=''", "DKIMCheck": "Server passes DKIM test, 0 Spam score", "X-Spam-Score": "1.8 (+)", "X-Spam-Report": "Spam detection software, running on the system \"heracles.mxrouting.net\", has\r\n performed the tests listed below against this email.\r\n Information: https://mxroutedocs.com/directadmin/spamfilters/\r\n ---\r\n Content analysis details:   (1.8 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\r\n  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was blocked.\r\n                             See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block\r\n                              for more information.\r\n                             [URI: googlegroups.com]\r\n -0.0 RCVD_IN_DNSWL_NONE     RBL: Sender listed at https://www.dnswl.org/, no\r\n                             trust\r\n                             [209.85.167.61 listed in list.dnswl.org]\r\n  0.0 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\r\n  0.0 ARC_SIGNED             Message has a ARC signature\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n -0.1 DKIM_VALID_EF          Message has a valid DKIM or DK signature from\r\n                             envelope-from domain\r\n -0.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n  0.0 ARC_VALID              Message has a valid ARC signature\r\n -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [maryjcrozier(at)gmail.com]\r\n  0.0 RCVD_IN_VALIDITY_RPBL_BLOCKED RBL: ADMINISTRATOR NOTICE: The query to\r\n                              Validity was blocked.  See\r\n                             https://knowledge.validity.com/hc/en-us/articles/20961730681243\r\n                              for more information.\r\n                             [209.85.167.61 listed in bl.score.senderscore.com]\r\n  0.0 RCVD_IN_VALIDITY_CERTIFIED_BLOCKED RBL: ADMINISTRATOR NOTICE: The\r\n                             query to Validity was blocked.  See\r\n                             https://knowledge.validity.com/hc/en-us/articles/20961730681243\r\n                              for more information.\r\n                          [209.85.167.61 listed in sa-trusted.bondedsender.org]\r\n  0.0 RCVD_IN_VALIDITY_SAFE_BLOCKED RBL: ADMINISTRATOR NOTICE: The query to\r\n                              Validity was blocked.  See\r\n                             https://knowledge.validity.com/hc/en-us/articles/20961730681243\r\n                              for more information.\r\n                             [209.85.167.61 listed in sa-accredit.habeas.com]\r\n  0.0 HTML_FONT_FACE_BAD     BODY: HTML font face is not a word\r\n  1.5 HTML_MESSAGE           BODY: HTML included in message\r\n  0.0 FREEMAIL_FORGED_FROMDOMAIN 2nd level domains in From and EnvelopeFrom\r\n                              freemail headers are different\r\n -1.0 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager", "SpamTally": "Final spam score: 18"}}}

TEXT NOT NULL

standardized_payload

{"subject": "Re: Rehearsal Scheduling", "sender": "Mary Crozier <maryjcrozier@gmail.com>", "timestamp": "2025-10-06T01:51:03+00:00", "body": "Mary - 360-531-0200 - maryjcrozier@gmail.com\r\nDavid- 360-531-0557 - david_crozier28@msn.com\r\nMike - 206-715-0298 - michaelcrozier111@gmail.com\r\n\r\nOn Sun, Oct 5, 2025 at 6:47\u202fPM Ashley Schenkel <ashley.schenkel@gmail.com>\r\nwrote:\r\n\r\n> Hey bloody green monsters!\r\n>\r\n> I\u2019m working on our rehearsal schedule, and it would be helpful for me to\r\n> have your contact info (text # or email address) so I can get the most\r\n> people to the read throughs. I don\u2019t want to fill up your inbox asking one\r\n> person a question on the group chat. Thanks!\r\n>\r\n> Gore & Grime,\r\n>\r\n> Ashley\r\n> (619) 822-8142\r\n> Ashley.Schenkel@gmail.com\r\n>\r\n> *\"I cannot do all the good that the world needs, but the world needs all\r\n> the good that I can do.\" ~Jana Stanfield*\r\n>\r\n> --\r\n> You received this message because you are subscribed to the Google Groups\r\n> \"Port Townsend Murder Mysteries\" group.\r\n> To unsubscribe from this group and stop receiving emails from it, send an\r\n> email to ptmurder+unsubscribe@googlegroups.com.\r\n> To view this discussion visit\r\n> https://groups.google.com/d/msgid/ptmurder/CAFRDBvenTDCS0ryGgLuoE7aGmd%3D2-d45ukbQsBwv%3DGJ9S5n2QQ%40mail.gmail.com\r\n> <https://groups.google.com/d/msgid/ptmurder/CAFRDBvenTDCS0ryGgLuoE7aGmd%3D2-d45ukbQsBwv%3DGJ9S5n2QQ%40mail.gmail.com?utm_medium=email&utm_source=footer>\r\n> .\r\n>\r\n\r\n-- \r\nYou received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\nTo unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\nTo view this discussion visit https://groups.google.com/d/msgid/ptmurder/CA%2BgCv2cPc9O%2BGG5_n-Rrq_DrcDRGz3Azahc19U0GbHKjGLWZjQ%40mail.gmail.com.\r\n", "attachments": [], "raingull_id": "497981c5-6c26-486b-abc5-f5c8fe0018b6"}

TEXT

attachments

TEXT NOT NULL

is_urgent

bool NOT NULL

error_message

TEXT

created_at

datetime NOT NULL

updated_at

datetime NOT NULL

standardized_at

datetime

user_id

varchar(8)

service_id

bigint NOT NULL

db.sqlite3 — core_messages

Update row 9 in core_messages