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": "OlyCAP conference room. They will all be there until Wednesday the 4th unless stated otherwise. \r\n\r\nCheers!\r\n\r\nOn Tue, Nov 25, 2025, at 1:47 PM, Michael Crozier wrote:\r\n> What\u2019s the location?\r\n> \r\n> Mike Crozier\r\n> 206-715-0298\r\n> Michaelcrozier111@gmail.com\r\n> \r\n>> On Nov 25, 2025, at 1:00\u202fPM, Ashley Schenkel <ashley.schenkel@gmail.com> wrote:\r\n>> \ufeff\r\n>> Tonight we kill trees for the entertainment of our guests. \r\n>> They can't come after us if they're all dead! \r\n>> \r\n>> We'll be testing your writing weapon to ensure Snagla is the only orc who glows. \r\n>> Her parents fed her a \"pretty poison\" as a child, so now she's a glow schtick. \r\n>> \r\n>> Stay Precious,\r\n>> Ashley\r\n>> \r\n>> *\"I cannot do all the good that the world needs, but the world needs all the good that I can do.\" ~Jana Stanfield*\r\n>> \r\n>> \r\n>> -- \r\n>> You received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\n>> To unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\n>> To view this discussion visit https://groups.google.com/d/msgid/ptmurder/CAFRDBvcDpFCrPpu4QO9QHV6E_ND5NxTXVNmZEDU3iwAOe6fDBg%40mail.gmail.com <https://groups.google.com/d/msgid/ptmurder/CAFRDBvcDpFCrPpu4QO9QHV6E_ND5NxTXVNmZEDU3iwAOe6fDBg%40mail.gmail.com?utm_medium=email&utm_source=footer>.\r\n> \r\n> \r\n> -- \r\n> You received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\n> To unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\n> To view this discussion visit https://groups.google.com/d/msgid/ptmurder/B1E10B76-AC72-4FAB-8CF0-297F60E24E45%40gmail.com <https://groups.google.com/d/msgid/ptmurder/B1E10B76-AC72-4FAB-8CF0-297F60E24E45%40gmail.com?utm_medium=email&utm_source=footer>.\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/34fb3e3f-100e-42ec-a3c4-e917278b0718%40app.fastmail.com.\r\n", "attachments": [], "metadata": {"subject": "Re: Muster tonight @ 5:45pm; Bring Your Favorite Unique Writing Weapon!", "date": "Tue, 25 Nov 2025 13:48:25 -0800", "headers": {"Return-Path": "<ptmurder+bncBDG5ZHORTUARBP6ITDEQMGQE5RD75CQ@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "by mailuser.phl.internal (Postfix, from userid 501)\r\n\tid 4D3651060065; Tue, 25 Nov 2025 16:48:44 -0500 (EST)", "Return-path": "<ptmurder+bncBDG5ZHORTUARBP6ITDEQMGQE5RD75CQ@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Tue, 25 Nov 2025 21:48:49 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1764107325; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=PABiHVImh/671r+8tXx8lHIMQrWMQ35/6XBLQs3WjzRn/QTrKzpu2Jyp8GOusKUFn+\r\n         M4UfOcG1TOHcT88KohkBe/fPsm058sI6FqD1wtQDfgClQqIUqmstEobAjJqGgievVSDa\r\n         9J3cIDpuD55QL8RLUSGhlNmgSeBc/usioe8AnPNbKDqFFt+bSTcNJrKUTJMDJaufVmDC\r\n         06GKnr7fzT0gB8nV9e3uGqkljLgsG9TwyiKRSMEqphrCEQhqYkC2Xi6ZFzQT2wl73As5\r\n         oLfizFqQVQuzJgShJEfu69zgGbb7fl1hjK2WQASdAG1VpCGSNQt5lIcZJTLbDj+jj1UF\r\n         H2cQ==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=subject:references:in-reply-to:message-id:to:from:date:mime-version\r\n         :feedback-id:dkim-signature:dkim-signature;\r\n        bh=VIvsuYgwAkPvICmc2//yQugf4ZuQKQTFhxfOsaw97BY=;\r\n        fh=zml4yL/ZCJwmiFXJlUMUQWY4zN9tswd6GmlUm/Iqbxo=;\r\n        b=XQOG7VEqTRhto9hdX0pxxmqdHsT/AN6sX6+zBkKI5ilBS1ciIAg2AnKgwK14zQOW6i\r\n         tKWTRlsvp0kCgx2c2YecTigLCyXY5Zbs6W9qnxOAVY3LBFj4tUrRBcuw3JKPqciAaV7t\r\n         8N3+crZVKmUBzCcF3qAHn/IiMh9rJJKyO3kdlaBNwffIxiBl5QJ6KyjUH1MorKRc2gkW\r\n         dTN82GAw9+HSnAli1D8te878Ntw3M+Tf4NncUhZoheVn+pW6QAYDS7sMKviYyVv9sBjP\r\n         G6uJtIvLYxo6WDI5FXn4g8zyzM/PesuDDqFAyKYv70pjO+Clt6IDbAomqcKmvl34IPUC\r\n         swHQ==;\r\n        dara=google.com", "ARC-Authentication-Results": "i=1; gmr-mx.google.com;\r\n       dkim=pass header.i=@stillcrazy.pro header.s=fm1 header.b=RBYClXih;\r\n       dkim=pass header.i=@messagingengine.com header.s=fm3 header.b=RgQbP0sn;\r\n       spf=pass (google.com: domain of ramon@stillcrazy.pro designates 202.12.124.156 as permitted sender) smtp.mailfrom=ramon@stillcrazy.pro;\r\n       dmarc=pass (p=NONE sp=REJECT dis=NONE) header.from=stillcrazy.pro", "DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=googlegroups.com; s=20230601; t=1764107327; x=1764712127; 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:subject:references:in-reply-to:message-id:to:from\r\n         :date:mime-version:feedback-id:sender:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=32PueCALCg3ETV1N4kgqIshM3dnF1YxelCJpEs8efWU=;\r\n        b=fxBVZz6Y6u2/wNf2P/Q3I5OEOq6pT2G6ks3/F8A+WM82OmOJLrhoElrxzVBhbUzk5T\r\n         GvzQnI3rqIipQNZ7nf+hyauXPdvwIS+J0MRcB4OzY/+W1OXEqecUJoSdSFgB1xvrGlXu\r\n         /fTshYnpCXMj/10EMadqGTiHTgnxGgcFLbwXbEDsBM3Fr7ABEmuRFKrDydoDcYTwB6Wz\r\n         NHe1SKGCD/YNsr1QHBjvGaj6quXViPeE22OaySEP1OWT9pKZ6jJUk61yoUDaZyUu7afZ\r\n         JxvtbQoGSqbflZhOcXKIgbbD2tect6ZPOX7JuhxoOn6hNIhJnivvj2UCe7gkQ/7/I6gF\r\n         bbCQ==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1764107327; x=1764712127;\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:subject\r\n         :references:in-reply-to:message-id:to:from:date:mime-version\r\n         :feedback-id:x-beenthere:x-gm-message-state:sender:from:to:cc\r\n         :subject:date:message-id:reply-to;\r\n        bh=32PueCALCg3ETV1N4kgqIshM3dnF1YxelCJpEs8efWU=;\r\n        b=vCUS5bYvrP59Ux+LJb5TZ7dmB1SM349RUAph/LduXtuiaXPsyZbj0S5pCwFowNRl3D\r\n         Ta/n6gEkkx6SnvtBFmFCNAo2wP2SL9mRAyCuu/yxJV2ZUdiGS4loDcZzo98Dj2VOTGBH\r\n         3vOPp3+1aNy75n6aMp+KARNSsGGXJSWzQa7TZbSGbY51cnbmIlSY9Y0wEQq/Ew6aWoWG\r\n         3+xzZIbVk7iJW7WEkz0W/xOKXtwTLt3JcV799BceVnpv52vQcnbjccPpHJeKHqGsHEAt\r\n         aRt2lHvhDaGJBC7p028FELTs1vd5N5v46jfJBAZ7PHZVVoY1dXof5kNj61NSEExyhdpL\r\n         ywIg==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCVwyahvdeGO7j1+PlHWvKnFmWON4Oa6CkZ359XXka/TEJi6nRDHGDx80g11DpkH6kkqiiHK7vPEWg==@googlegroups.com", "X-Gm-Message-State": "AOJu0YyNFwQMZ5TngJkFb2kc10ilhDmW4hU1BxbQAmfQWrcjySe/WwjD\r\n\txANLORQEBQ2/UsKjMwVSECVm3PSVkhyQi5h/cyaMIMfSJIB0hv1zsTQ=", "X-Google-Smtp-Source": "AGHT+IHk0+VoQnUxd6zht1Ub0dOwuO6TaZ44McaCKzHKIZYZeWUCQS7/Sn/YTCMevA90h9xhjaQZ0w==", "X-Received": "by 2002:a17:902:ce05:b0:26c:2e56:ec27 with SMTP id d9443c01a7336-29b6c404f19mr158532645ad.19.1764107325857;\r\n        Tue, 25 Nov 2025 13:48:45 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+abYYBEQ+XZSdWeJc8MIhv4011rfQAJXgYx4Qal+k0hUQ==\"", "Received-SPF": "pass (google.com: domain of ramon@stillcrazy.pro designates 202.12.124.156 as permitted sender) client-ip=202.12.124.156;", "X-ME-Sender": "<xms:PCQmadKJjrdg6Mrpqet-lq3_Wqarq1k_Vln1lnuXzf1Yqzkq055KsQ>\r\n    <xme:PCQmaT8uqjwhb_jFWvm_fZMT-fyHXwziNhuc6J80igrIZNZptP13lyI32R3gj_nau\r\n    E4M_eSxjJ4Admuixq91JEHLChbSuVeveZnzkTTpbHUBmX9A_qFHIEE>", "X-ME-Proxy-Cause": "gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddvgedvheekucetufdoteggodetrf\r\n    dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu\r\n    rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegouf\r\n    hushhpvggtthffohhmrghinhculdegledmnecujfgurhepofggfffhvffkjghfufgtsegr\r\n    tderreertdejnecuhfhrohhmpedftfgrmhhonhcuffgrihhlvgihfdcuoehrrghmohhnse\r\n    hsthhilhhltghrrgiihidrphhroheqnecuggftrfgrthhtvghrnhepgfdtjeetgfeugedt\r\n    feejveejvdeltddtheduveevuefhffefieejieeukeehteehnecuffhomhgrihhnpehgoh\r\n    hoghhlvgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl\r\n    fhhrohhmpehrrghmohhnsehsthhilhhltghrrgiihidrphhrohdpnhgspghrtghpthhtoh\r\n    epvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepmhhitghhrggvlhgtrhhoiihi\r\n    vghrudduudesghhmrghilhdrtghomhdprhgtphhtthhopehpthhmuhhruggvrhesghhooh\r\n    hglhgvghhrohhuphhsrdgtohhm", "X-ME-Proxy": "<xmx:PCQmadoxWOGVTUWKUOERM4IHAXD6emhM8wVrkkyk-kF_mWgoJVdPWw>\r\n    <xmx:PCQmaVq14gjz_y6ndGPLa0Gst53QO6jfCcQo7QMJxXpaskqLk0G3sQ>\r\n    <xmx:PCQmaX0Jt-ZLNKgaqZ1QKVVNW3sxlm6TJr-YzCsuQL48V5uQbPgXMw>\r\n    <xmx:PCQmaUChi_tIO8Mowk3WjUrASxEGqMYwffXEscTQWZE7HU40nK2Ofw>\r\n    <xmx:PCQmaTZ80tchn0i__B-yCWCBoHilpAOnzz6TaukAgEPsUFfdofI7yU4n>", "Feedback-ID": "i44f64897:Fastmail", "X-Mailer": "MessagingEngine.com Webmail Interface", "MIME-Version": "1.0", "X-ThreadId": "AsAS59JGFfas", "Date": "Tue, 25 Nov 2025 13:48:25 -0800", "From": "\"Ramon Dailey\" <ramon@stillcrazy.pro>", "To": "\"Michael Crozier\" <michaelcrozier111@gmail.com>, ptmurder@googlegroups.com", "Message-Id": "<34fb3e3f-100e-42ec-a3c4-e917278b0718@app.fastmail.com>", "In-Reply-To": "<B1E10B76-AC72-4FAB-8CF0-297F60E24E45@gmail.com>", "References": "<CAFRDBvcDpFCrPpu4QO9QHV6E_ND5NxTXVNmZEDU3iwAOe6fDBg@mail.gmail.com>\r\n <B1E10B76-AC72-4FAB-8CF0-297F60E24E45@gmail.com>", "Subject": "Re: Muster tonight @ 5:45pm; Bring Your Favorite Unique Writing Weapon!", "Content-Type": "multipart/alternative;\r\n boundary=c3b28caa72c74fae9227f00ba2e9be55", "X-Original-Sender": "ramon@stillcrazy.pro", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@stillcrazy.pro header.s=fm1 header.b=RBYClXih;       dkim=pass\r\n header.i=@messagingengine.com header.s=fm3 header.b=RgQbP0sn;       spf=pass\r\n (google.com: domain of ramon@stillcrazy.pro designates 202.12.124.156 as\r\n permitted sender) smtp.mailfrom=ramon@stillcrazy.pro;       dmarc=pass\r\n (p=NONE sp=REJECT dis=NONE) header.from=stillcrazy.pro", "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='googlegroups.com' status='pass' reason=''", "DKIMCheck": "Server passes DKIM test, 0 Spam score", "X-Spam-Score": "1.9 (+)", "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.9 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\r\n  0.0 RCVD_IN_DNSWL_BLOCKED  RBL: ADMINISTRATOR NOTICE: The query to DNSWL\r\n                             was blocked.  See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#DnsBlocklists-dnsbl-block\r\n                              for more information.\r\n                             [209.85.216.61 listed in list.dnswl.org]\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.216.61 listed in wl.mailspike.net]\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 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_VALID_EF          Message has a valid DKIM or DK signature from\r\n                             envelope-from domain\r\n -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature\r\n  0.0 ARC_VALID              Message has a valid ARC signature\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\r\n  1.5 HTML_MESSAGE           BODY: HTML included in message\r\n -0.0 DKIMWL_WL_MED          DKIMwl.org - Medium trust sender\r\n -1.0 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager", "SpamTally": "Final spam score: 19"}}}

TEXT NOT NULL

standardized_payload

{"subject": "Re: Muster tonight @ 5:45pm; Bring Your Favorite Unique Writing Weapon!", "sender": "\"Ramon Dailey\" <ramon@stillcrazy.pro>", "timestamp": "2025-11-25T21:48:25+00:00", "body": "OlyCAP conference room. They will all be there until Wednesday the 4th unless stated otherwise. \r\n\r\nCheers!\r\n\r\nOn Tue, Nov 25, 2025, at 1:47 PM, Michael Crozier wrote:\r\n> What\u2019s the location?\r\n> \r\n> Mike Crozier\r\n> 206-715-0298\r\n> Michaelcrozier111@gmail.com\r\n> \r\n>> On Nov 25, 2025, at 1:00\u202fPM, Ashley Schenkel <ashley.schenkel@gmail.com> wrote:\r\n>> \ufeff\r\n>> Tonight we kill trees for the entertainment of our guests. \r\n>> They can't come after us if they're all dead! \r\n>> \r\n>> We'll be testing your writing weapon to ensure Snagla is the only orc who glows. \r\n>> Her parents fed her a \"pretty poison\" as a child, so now she's a glow schtick. \r\n>> \r\n>> Stay Precious,\r\n>> Ashley\r\n>> \r\n>> *\"I cannot do all the good that the world needs, but the world needs all the good that I can do.\" ~Jana Stanfield*\r\n>> \r\n>> \r\n>> -- \r\n>> You received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\n>> To unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\n>> To view this discussion visit https://groups.google.com/d/msgid/ptmurder/CAFRDBvcDpFCrPpu4QO9QHV6E_ND5NxTXVNmZEDU3iwAOe6fDBg%40mail.gmail.com <https://groups.google.com/d/msgid/ptmurder/CAFRDBvcDpFCrPpu4QO9QHV6E_ND5NxTXVNmZEDU3iwAOe6fDBg%40mail.gmail.com?utm_medium=email&utm_source=footer>.\r\n> \r\n> \r\n> -- \r\n> You received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\n> To unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\n> To view this discussion visit https://groups.google.com/d/msgid/ptmurder/B1E10B76-AC72-4FAB-8CF0-297F60E24E45%40gmail.com <https://groups.google.com/d/msgid/ptmurder/B1E10B76-AC72-4FAB-8CF0-297F60E24E45%40gmail.com?utm_medium=email&utm_source=footer>.\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/34fb3e3f-100e-42ec-a3c4-e917278b0718%40app.fastmail.com.\r\n", "attachments": [], "raingull_id": "4c96698a-a2f0-4e7e-9be5-95512e6eebab"}

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 84 in core_messages