home / public

reports

7 rows where domain_id = 2691 sorted by checked_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: server, responses_count, cookies_count

id domain_id input_url final_url http_status server page_load_ms consent_phase_ms total_ms responses_count cookies_count local_storage_count analytics_score analytics_verdict checked_at ▲
e68a195a-e0de-4c96-9d50-026229a31aa4 2691 2691 https://insidan.kommunal.se/ https://login.microsoftonline.com/ab1389e2-39b2-4227-a2c2-41697e7483a4/oauth2/authorize?response_type=code&client_id=f2a70972-5048-4ea2-81d8-0d27c9a59d94&scope=openid&nonce=44e7f4e0-0a54-4574-adc3-e0af471de852&redirect_uri=https%3a%2f%2finsidan.kommunal.se%2f&state=AppProxyState%3a%7b%22InvalidTokenRetry%22%3anull%2c%22IsMsofba%22%3afalse%2c%22OriginalRawUrl%22%3a%22https%3a%5c%2f%5c%2finsidan.kommunal.se%5c%2f%22%2c%22RequestProfileId%22%3anull%2c%22SessionId%22%3a%225c4328d8-8d83-40f6-9c14-71df415b3ebb%22%7d%23EndOfStateParam%23&client-request-id=5c4328d8-8d83-40f6-9c14-71df415b3ebb&claims=%7b%22id_token%22%3a%7b%22xms_cc%22%3a%7b%22values%22%3a%5b%22CP1%22%5d%7d%7d%7d 200 20.190.147.8:443 11785 86 11871 15 11 0 0 none 1781012763108
4949b06f-6134-4d1e-b14d-fe69b91b34a3 2691 2691 https://bryggan.ftv.regionstockholm.se/ https://login.microsoftonline.com/73c667fd-62b7-4783-8cbf-cf2f2e3a3067/oauth2/authorize?response_type=code&client_id=a369cced-e6e1-47a3-a218-90dd486da88e&scope=openid&nonce=eeea8a51-ba35-40c5-a787-b3b1f28d5899&redirect_uri=https%3a%2f%2fbryggan.ftv.regionstockholm.se%2f&state=AppProxyState%3a%7b%22InvalidTokenRetry%22%3anull%2c%22IsMsofba%22%3afalse%2c%22OriginalRawUrl%22%3a%22https%3a%5c%2f%5c%2fbryggan.ftv.regionstockholm.se%5c%2f%22%2c%22RequestProfileId%22%3anull%2c%22SessionId%22%3a%22126c05c8-7d64-49d0-acb7-e81830c6d966%22%7d%23EndOfStateParam%23&client-request-id=126c05c8-7d64-49d0-acb7-e81830c6d966&claims=%7b%22id_token%22%3a%7b%22xms_cc%22%3a%7b%22values%22%3a%5b%22CP1%22%5d%7d%7d%7d 200 40.126.53.19:443 11714 62 11776 15 11 0 0 none 1781012668104
a429af7c-afb7-4b78-86d9-3a6d3543e201 2691 2691 https://goteborgonline.sharepoint.com/sites/digitalanavet https://login.microsoftonline.com/df455cc5-0c91-4825-9168-7f9de7d28a05/oauth2/authorize?client%5Fid=00000003%2D0000%2D0ff1%2Dce00%2D000000000000&response%5Fmode=form%5Fpost&ear%5Fjwe%5Fcrypto=eyJhbGciOiJFQ0RILUVTIiwiZW5jIjoiQTI1NkdDTSIsImFwdiI6IkFBQUFDVVZoY2tOc2FXVnVkR2dBQUFCRlEwc3pNQUFBQUJsdTlRZ2pLRmFBaUJ1Y0h2YllTekRnU0tFMi9tTHBvS0Q3ZytTK2RkbUZTRXEzajNNajZkQ05Kc2M0LzFZSis1bm43SWlaQVhaeTRvWGFoMmM4THl3ZTlaTHpWZUVIL1N5eGVHVUhuVklsdkZvZi9sU3ZzSTZEYWFlWUw5SjI1d0FBQUJnNm15STBOM0xJbjBWWmk2N0F1ZUlMbGhmT0k4Q2tNNzQ9In0%3D&ear%5Fjwk=eyJhbGciOiJFQ0RILUVTIiwiY3J2IjoiUC0zODQiLCJ4IjoiQUFBQU1CbHU5UWdqS0ZhQWlCdWNIdmJZU3pEZ1NLRTIvbUxwb0tEN2crUytkZG1GU0VxM2ozTWo2ZENOSnNjNC8xWUordz09IiwieSI6IkFBQUFNSm5uN0lpWkFYWnk0b1hhaDJjOEx5d2U5Wkx6VmVFSC9TeXhlR1VIblZJbHZGb2YvbFN2c0k2RGFhZVlMOUoyNXc9PSIsImt0eSI6IkVDIn0%3D&spa%5Fclient%5Fid=08e18876%2D6177%2D487e%2Db8b5%2Dcf950c1e598c&client%5Finfo=1&response%5Ftype=code%20id%5Ftoken%20spa%5Frt&resource=00000003%2D0000%2D0ff1%2Dce00%2D000000000000&scope=openid&nonce=FA447F597A752C6E4E9CA1DE44C1FFF869E61A2D3085D01C%2D1B6581417909D0DC5940719A168F1AEEFA85C9AC7E7826B87631A371A09E15CE&redirect%5Furi=https%3A%2F%2Fgoteborgonline%2Esharepoint%2Ecom%2F%5Fforms%2Fdefault%2Easpx&state=OD0wJjMyPUFBTG9UQUFBQUJRNzI4MlFkU1lLamZBU0pYSiUyRmI4aVo4VzV2aHQxSCUyRlpnNzdoVkh0T0lVREglMkJSZTV2VjQlMkJwanUlMkJtMDc5JTJCMng4dDlnQVFsdSUyQmxseGVLTEhUSHIlMkZWU0FocENZM3VzVTNTbmdFcEslMkZhVFNYT3l1V0NZJTJGZlcySENIQ3JBMnJSRU1TUUJON1pXNUslMkZSR01XalMwYm1XODRTeFIlMkJFMHRtbmNmMUc2YWNvelJKWlYwbmt2TTh3NzVQMmg3NVBBT2RORFlYY1ltZFNWdVRweDNDeXU4a0ZLYzRySEVtN0Voa3BiZmJIbmZzS2ppNDhzdVUyZXdObVNMVk9ZSyUyQklIalV1NSUyQkNnRVZSZXJKa0pueW92NXMlMkZDdSUyRlNXbjBLaEl1SUdvU3NMY2tEbTZXN2g0SDcxV094VnNDZ2kxT0pxV3FKMGpXMkI2THA3YXlmUWRhMWVBamo1JTJCOUlvSGl4TGhXNVpLdVg0UUhoYmIlMkJNZ2JDRDRVTHYzeTZJZHR3JTNEJTNE&claims=%7B%22id%5Ftoken%22%3A%7B%22xms%5Fcc%22%3A%7B%22values%22%3A%5B%22CP1%22%5D%7D%7D%7D&wsucxt=1&cobrandid=11bd8083%2D87e0%2D41b5%2Dbb78%2D0bc43c8a8e8a&client%2Drequest%2Did=acec1ba2%2De03e%2D1001%2D58f7%2D1e86820ae797 200 40.126.53.19:443 12607 57 12664 22 14 0 0 none 1781012502850
346c7006-b20a-4803-93a7-82389f8d6a43 2691 2691 https://aurora.umu.se/ https://login.microsoftonline.com/5a4ba6f9-f531-4f32-9467-398f19e69de4/oauth2/authorize?client%5Fid=00000003%2D0000%2D0ff1%2Dce00%2D000000000000&response%5Fmode=form%5Fpost&ear%5Fjwe%5Fcrypto=eyJhbGciOiJFQ0RILUVTIiwiZW5jIjoiQTI1NkdDTSIsImFwdiI6IkFBQUFDVVZoY2tOc2FXVnVkR2dBQUFCRlEwc3pNQUFBQUp2Z0VEZW9va2dwWkN5S3RiUDd6VmFCTyt6akxGNEZ4RE9IWWtpbE1GUi9kcmoxVFc3M25oVDFOSFNybE83YmFZK0U0S3g0YUhFK0VwNlpjM2RjMms1YnNkTFdPK0Q0VmxQNnA1eXZxcjBqWkFXWGZjYjQyU01JdTJWakJXVWZ2QUFBQUJobFBqdEplSVRRSmNpVk5rSDh6d3R4WDdZZ20zLzVDdVk9In0%3D&ear%5Fjwk=eyJhbGciOiJFQ0RILUVTIiwiY3J2IjoiUC0zODQiLCJ4IjoiQUFBQU1KdmdFRGVvb2tncFpDeUt0YlA3elZhQk8rempMRjRGeERPSFlraWxNRlIvZHJqMVRXNzNuaFQxTkhTcmxPN2JhUT09IiwieSI6IkFBQUFNSStFNEt4NGFIRStFcDZaYzNkYzJrNWJzZExXTytENFZsUDZwNXl2cXIwalpBV1hmY2I0MlNNSXUyVmpCV1VmdkE9PSIsImt0eSI6IkVDIn0%3D&spa%5Fclient%5Fid=08e18876%2D6177%2D487e%2Db8b5%2Dcf950c1e598c&client%5Finfo=1&response%5Ftype=code%20id%5Ftoken%20spa%5Frt&resource=00000003%2D0000%2D0ff1%2Dce00%2D000000000000&scope=openid&nonce=2A55D24F8645E2A67B3A9E7C066496CB628D65D59338DAE8%2DCD8701536CB654DC20183F4A8736D496E31877604789E99EFE37B57DCC03D88C&redirect%5Furi=https%3A%2F%2Fumeauniversity%2Esharepoint%2Ecom%2F%5Fforms%2Fdefault%2Easpx&state=OD0wJjMyPUFBTG9UUUFBQUJRNzI4MlFkU1lLamZBU0pYSiUyRmI4aVo4VzV2aGdtTkNkVUFwSlpLbnJEWkluTE0wbVdhM3oyeThjMVlFM2RoZUUwUTd2bjdpTnROcXdoNklsZUgwb20xTHlUWGdTV0N0USUyQm5hZHBVU2Rmd3RSS2J2VVdocFUxdkJFJTJCZiUyQmJTQjM1Sk1XNlAlMkZxcnA1aVRsSE1VQ3JFR08zRVJ2bjJDbUN4MGglMkJWciUyRiUyRkNYNTJkWUU0SUYwWnM3SzJuWGJkbjQwQ2dtQkk3RkZOZ1FJa3ZteGc0RGFqOEs2NkhkaklrMWpuTTVUJTJCUnVFcmlyQ0ZkekxSRFg2UUFxTmJsZk9Dcm5wSGQlMkYxWURRcCUyRjRCYUx4N3ZXSG05MHJqUzA3akNRcGRrOHJHcVJUSU5Kd2J2ZlhCVjZ4JTJGNklpNFdUJTJGMHI3S3dpbkRadUdIVHVQVE9hJTJCUjRPa0VqVmpXYmxzY3g2d0JzamtzRmtmczBPSURUQ21yWjNZdHFHRzdrdlglMkIwYyUzRA&claims=%7B%22id%5Ftoken%22%3A%7B%22xms%5Fcc%22%3A%7B%22values%22%3A%5B%22CP1%22%5D%7D%7D%7D&wsucxt=1&cobrandid=11bd8083%2D87e0%2D41b5%2Dbb78%2D0bc43c8a8e8a&client%2Drequest%2Did=26ec1ba2%2Db06f%2D1001%2D6daa%2Dd3c47d5fa7c6 200 20.190.177.23:443 12679 87 12766 18 11 0 0 none 1781011954706
f3dab836-8f44-4d47-8530-f0f6e82cf51b 2691 2691 https://plexus.lg.se/ https://login.microsoftonline.com/414f742c-509b-4122-9fc7-f9ccb5ad6ecb/oauth2/authorize?response_type=code&client_id=7f53ca5c-f323-447e-9ca4-0bcf58c62750&scope=openid&nonce=1a93df83-163d-4bdc-a050-e07bef115ef6&redirect_uri=https%3a%2f%2fplexus.lg.se%2f&state=AppProxyState%3a%7b%22InvalidTokenRetry%22%3anull%2c%22IsMsofba%22%3afalse%2c%22OriginalRawUrl%22%3a%22https%3a%5c%2f%5c%2fplexus.lg.se%5c%2f%22%2c%22RequestProfileId%22%3anull%2c%22SessionId%22%3a%22ff990890-52ca-47bc-9b39-8b36d0083688%22%7d%23EndOfStateParam%23&client-request-id=ff990890-52ca-47bc-9b39-8b36d0083688&claims=%7b%22id_token%22%3a%7b%22xms_cc%22%3a%7b%22values%22%3a%5b%22CP1%22%5d%7d%7d%7d 200 20.190.177.22:443 11910 60 11970 20 14 0 0 none 1781011890262
2e8d48bb-abee-47ea-b6ca-38a7768010ff 2691 2691 https://trelleborgse.omniacloud.eu/ https://login.microsoftonline.com/7ccf74f4-0d21-4f64-9ae8-5dc8b1a9477b/oauth2/v2.0/authorize?state={%22redirectUrl%22%3A%22https%3A%2F%2Ftrelleborgse.omniacloud.eu%2F%22%2C%22adminConsentSessionId%22%3Anull%2C%22isMFAModeRetry%22%3Afalse%2C%22requestTempToken%22%3Afalse}&client_id=4d98d1e1-a669-4192-8b03-4fb9454919ca&redirect_uri=https%3A%2F%2Ftrelleborgse.omniacloud.eu%2Fapi%2Fauth%2Fazuread%2Flogin%2Fcode&response_type=code%20id_token&response_mode=form_post&nonce=769c13a2-6e18-434b-9203-cf626512528b&scope=openid%20offline_access 200 40.126.53.18:443 11752 82 11834 21 12 0 0 none 1781011822722
f7c10161-c821-4271-b7d3-0c5eebe58c4c 2691 2691 https://insidan.uppsala.se/ https://login.microsoftonline.com/86932a36-37af-4204-89f2-ed1ee095f45a/oauth2/authorize?client%5Fid=00000003%2D0000%2D0ff1%2Dce00%2D000000000000&response%5Fmode=form%5Fpost&ear%5Fjwe%5Fcrypto=eyJhbGciOiJFQ0RILUVTIiwiZW5jIjoiQTI1NkdDTSIsImFwdiI6IkFBQUFDVVZoY2tOc2FXVnVkR2dBQUFCRlEwc3pNQUFBQUw1UTY1MnR6TlA3OFgyOHMxQ3RXcmFpMWVTODkvVXc1QkpESGxJT2ZuZHUyMFVHb0hLL2JBRDFqSWZrT20yNEhra2VINUxyL05YZms4MzEvVTNjU240a2puR1pydmxZTHdrY0txcnlhUysxcm1HdnIzU2IyQjJTT3VOTW9FOXBUQUFBQUJnczlqRU9GVFBqS0NJMDZlS3M3TGsySGVWTlpwKzlTSTQ9In0%3D&ear%5Fjwk=eyJhbGciOiJFQ0RILUVTIiwiY3J2IjoiUC0zODQiLCJ4IjoiQUFBQU1MNVE2NTJ0ek5QNzhYMjhzMUN0V3JhaTFlUzg5L1V3NUJKREhsSU9mbmR1MjBVR29ISy9iQUQxaklma09tMjRIZz09IiwieSI6IkFBQUFNRWtlSDVMci9OWGZrODMxL1UzY1NuNGtqbkdacnZsWUx3a2NLcXJ5YVMrMXJtR3ZyM1NiMkIyU091Tk1vRTlwVEE9PSIsImt0eSI6IkVDIn0%3D&spa%5Fclient%5Fid=08e18876%2D6177%2D487e%2Db8b5%2Dcf950c1e598c&client%5Finfo=1&response%5Ftype=code%20id%5Ftoken%20spa%5Frt&resource=00000003%2D0000%2D0ff1%2Dce00%2D000000000000&scope=openid&nonce=E353E51A1DE5FACAA89B43DFE8FBBCF0A0079B6EC337BCCE%2DF5E46AE49A596DD940D8B9A3E7B499BE612131FB55AA9BFA849F9049AFD8508D&redirect%5Furi=https%3A%2F%2Fuppsalakommun1%2Esharepoint%2Ecom%2F%5Fforms%2Fdefault%2Easpx&state=OD0wJjMyPUFBTG9ZUUFBQUJRNzI4MlFkU1lLamZBU0pYSiUyRmI4aVo4VzV2aHRYR3Z2TnI5VmRLb3NwUlN0ZklMTEh3TXQxOGM3SHl2d2dnS3dPcEI2NzlEcEtGd3RvQkx5YUIzaFRoQ2gxQk5DanlqS1g0ZDNadlQweWs2MktwclFuODhYaUp3SnBhZlpzNTdva0pVM0dzYW1rUWtSeFhPdlBYTWN1bHlVaDhIekZuczJ4UUk2a1FnRmNCdkpCY0xRd09iWCUyQnhXMGZob29pZFdjcm9lSG1oUENzTHB3ZmQ4VlhrSFpYaWlWQlRpSDAwemJiZ2FpY0Q0cXptbWRiZEpZaXlwJTJGSGY5Q1hFUCUyQjFYcFZKWWVuWUFmd2xYWlhGcUx4cnhOU2h0NWRvMWVFcGI0bDU5Qmt5QmNoeWhDY05YcW5yJTJGcTQzVXRoOFowb2xBbXp0THNyaXJ5bHhUQ0poYnMzbDVDSktXTlRqNnRVd3hOdiUyRlk4WG0zbWhJQ0NuVHRkUm9jekFkUWNHTSUzRA&claims=%7B%22id%5Ftoken%22%3A%7B%22xms%5Fcc%22%3A%7B%22values%22%3A%5B%22CP1%22%5D%7D%7D%7D&wsucxt=1&cobrandid=11bd8083%2D87e0%2D41b5%2Dbb78%2D0bc43c8a8e8a&client%2Drequest%2Did=9deb1ba2%2D7071%2D1001%2D5dd8%2Dc00c7e843aeb 200 20.190.181.0:443 12811 75 12886 21 0 0 0 none 1781011393728

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE reports (
  id                  TEXT    PRIMARY KEY,
  domain_id           INTEGER NOT NULL REFERENCES domains(id),
  input_url           TEXT    NOT NULL,
  final_url           TEXT    NOT NULL,
  http_status         INTEGER NOT NULL,
  server              TEXT,
  page_load_ms        INTEGER,
  consent_phase_ms    INTEGER,
  total_ms            INTEGER,
  responses_count     INTEGER,
  cookies_count       INTEGER,
  local_storage_count INTEGER,
  analytics_score     INTEGER,
  analytics_verdict   TEXT,
  checked_at          INTEGER NOT NULL
);
CREATE INDEX idx_reports_domain_checked ON reports(domain_id, checked_at DESC);
Powered by Datasette · Queries took 26.107ms