RiskyEats — pipeline run report

Generated 2026-08-08 11:51 UTC
parquets cleanmorning
RiskyEats pipeline report — 2026-08-08T11:51:08+00:00
Host: argos   Variant: morning

== 1. Data pulls ==
  rsync passes:        0
  rsync bytes total:   0
  drive batches:       0
  drive files ingested: 0
  git: already up to date

== 1b. News + enrichment pulls ==
  social-resolve:    loaded 9,514 signals from 88 raw + 51 enriched files
  social-triage:     765 candidates (active=762 inactive=3); beats: closures=323 openings=603 other=20 ownership=80
  fsq-normalize:     1,337 unverifiable pending; 0 elevations this run
  render stage:      OK; blog-regen: OK

== 1c. Signal source enumeration (listener captures) ==
  total raw captures:       18,531  across 46 unique FB groups/pages
  per-date capture volume:
    2026-04-29       697
    2026-04-30       206
    2026-05-01     2,483
    2026-05-02     3,008
    2026-05-03       134
    2026-05-04        50
    2026-05-05         7
    2026-05-06     2,560
    2026-05-07        47
    2026-05-08     1,200
    2026-05-09       141
    2026-05-11         2
    2026-05-12        10
    2026-05-13         9
    2026-05-14         6
    2026-05-15         2
    2026-05-17         1
    2026-05-18       560
    2026-05-19       108
    2026-05-20        55
    2026-05-21        66
    2026-05-22        41
    2026-05-23       476
    2026-05-24       526
    2026-05-26       218
    2026-05-27        18
    2026-05-29       217
    2026-06-01        16
    2026-06-02       160
    2026-06-03        77
    2026-06-06        45
    2026-06-09        47
    2026-06-10       319
    2026-06-11         2
    2026-06-12        21
    2026-06-13         1
    2026-06-14     2,974
    2026-06-15        28
    2026-06-16        58
    2026-06-17       139
    2026-06-18     1,016
    2026-06-19         7
    2026-06-20         1
    2026-06-21        10
    2026-06-22         3
    2026-06-23         2
    2026-06-24        21
    2026-06-25        59
    2026-06-26         1
    2026-06-27         2
    2026-06-28        35
    2026-06-29        18
    2026-06-30         2
    2026-07-01         5
    2026-07-02        34
    2026-07-03        11
    2026-07-04        50
    2026-07-06        13
    2026-07-07         7
    2026-07-08         1
    2026-07-09        99
    2026-07-10         1
    2026-07-11         1
    2026-07-13         1
    2026-07-14       164
    2026-07-15        28
    2026-07-16         4
    2026-07-18         1
    2026-07-19         1
    2026-07-20        35
    2026-07-21        10
    2026-07-22        27
    2026-07-23         1
    2026-07-24         1
    2026-07-25         2
    2026-07-26        56
    2026-07-27         3
    2026-07-28         8
    2026-07-29        24
    2026-07-30         1
    2026-07-31         3
    2026-08-02         4
    2026-08-03         3
    2026-08-04         2
    2026-08-05         2
    2026-08-06         3
    2026-08-07         3
    consolidated      10
  capture_type breakdown:
    feed                17,686
    publisher_index_scraper     212
    home_feed              207
    publisher_gnews        168
    publisher_llm_extract      94
    permalink               70
    (unknown)               58
    publisher_article       17
    publisher_rss_article      17
    publisher_headline_only       1
    publisher_headline_signal       1
  top 12 FB sources by capture count:
     8,977  groups/letseatsouthflorida
     4,765  groups/foodiessofl
       894  groups/theonlybocaraton
       747  groups/southfloridaeatslocal
       663  groups/bestofdelraybeach
       410  groups/1635316537302651
       349  groups/CFRRG
       304  groups/kinddiners
       205  groups/AskBoca
       161  groups/469875830146099
       148  photo
       115  groups/570653396601266

== 1d. RSS feeds + HTML index scrapes ==
  publisher-index-scrape stage NOT FOUND in cron log

== 2. Signal discoveries (statewide) ==
  under_emergency_order           543   (+543 vs prev 0)
  recent_failures               1,452   (+1,452 vs prev 0)
  worst_offenders               2,000   (+2,000 vs prev 0)
  bad_actors                    1,744   (+1,744 vs prev 0)
  permanent_closures            3,421   (+3,421 vs prev 0)
  clean_plates                 12,454   (+12,454 vs prev 0)
  delinquent                    2,827   (+2,827 vs prev 0)
  lost_licenses                     0
  new_licenses                  1,164   (+1,164 vs prev 0)

== 2b. Per-metro counts (UEO / failures / bad-actors / closures) ==
  build-meta              UEO=0     fails=0     bad=0     closures=0    
  cards-dict              UEO=0     fails=0     bad=0     closures=0    
  florida-keys            UEO=4     fails=36    bad=187   closures=25   
  fort-lauderdale         UEO=38    fails=136   bad=185   closures=186  
  gate-results            UEO=0     fails=0     bad=0     closures=0    
  generation              UEO=0     fails=0     bad=0     closures=0    
  image-assets            UEO=0     fails=0     bad=0     closures=0    
  jacksonville            UEO=66    fails=125   bad=169   closures=441  
  license-identity-quarantine  UEO=0     fails=0     bad=0     closures=0    
  miami                   UEO=72    fails=239   bad=176   closures=405  
  news-main-parity        UEO=0     fails=0     bad=0     closures=0    
  north-florida           UEO=55    fails=72    bad=172   closures=731  
  orlando                 UEO=92    fails=332   bad=167   closures=852  
  owners-dict             UEO=0     fails=0     bad=0     closures=0    
  riskyeats-sqlite-manifest  UEO=0     fails=0     bad=0     closures=0    
  southwest-florida       UEO=51    fails=166   bad=184   closures=232  
  tampa-bay               UEO=89    fails=154   bad=162   closures=388  
  treasure-coast          UEO=16    fails=57    bad=183   closures=41   
  venue-render-failures   UEO=0     fails=0     bad=0     closures=0    
  venue_percentiles       UEO=0     fails=0     bad=0     closures=0    
  venues-manifest         UEO=0     fails=0     bad=0     closures=0    
  west-palm-beach         UEO=60    fails=135   bad=159   closures=120  

== 3. DBPR / source-parquet drift ==
  ✓ all tracked parquets match baseline
  --- licenses_hr.parquet ---  [ok]
    rows: 69,262   mtime: 2026-08-08T11:37:30+00:00
    columns: 35
  --- inspections.parquet ---  [ok]
    rows: 1,074,971   mtime: 2026-08-08T11:31:18+00:00
    columns: 87
  --- master_business.parquet ---  [ok]
    rows: 69,262   mtime: 2026-08-08T09:00:38+00:00
    columns: 29
  --- new_facilities.parquet ---  [ok]
    rows: 91,838   mtime: 2026-08-08T11:30:59+00:00
    columns: 53
  --- ownership_changes.parquet ---  [ok]
    rows: 46,870   mtime: 2026-08-08T11:31:00+00:00
    columns: 53
  --- oss_places_enriched.parquet ---  [ok]
    rows: 54,239   mtime: 2026-08-08T07:14:43+00:00
    columns: 77

== 3b. Map injections + Sunbiz daily health ==
  ✓ all map + Sunbiz sources present and fresh
  [         ok] FSQ OS Places (map)         1,675,210 rows    8.8d / max 40d
  [         ok] Overture places (map)       1,129,965 rows    8.8d / max 40d
  [         ok] OpenStreetMap places (map)     24,598 rows    1.2d / max 10d
  [         ok] OSS enriched (map JOIN)        54,239 rows    0.2d / max 10d
  [         ok] Sunbiz CORP (daily)        12,720,803 rows    0.1d / max 2d
  [         ok] Sunbiz FIC  (daily)            87,222 rows    0.1d / max 7d