RiskyEats — pipeline run report

Generated 2026-11-14 17:55 UTC
parquets cleanevening
RiskyEats pipeline report — 2026-11-14T17:55:52+00:00
Host: argos   Variant: evening

== 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 10,712 signals from 175 raw + 59 enriched files
  social-triage:     1,086 candidates (active=550 inactive=26); beats: closures=508 openings=852 other=37 ownership=145
  fsq-normalize:     1,335 unverifiable pending; 0 elevations this run
  render stage:      OK; blog-regen: OK
  deploy:            2,067 files / 157,326,625 bytes

== 1c. Signal source enumeration (listener captures) ==
  total raw captures:       20,467  across 50 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
    2026-08-09        74
    2026-08-10         3
    2026-08-11         4
    2026-08-12         1
    2026-08-13        60
    2026-08-14         9
    2026-08-15        12
    2026-08-17         2
    2026-08-18        83
    2026-08-19         2
    2026-08-20        18
    2026-08-22         1
    2026-08-25         1
    2026-08-26        21
    2026-08-27        26
    2026-08-28        12
    2026-08-29         8
    2026-08-30         8
    2026-08-31         3
    2026-09-01         9
    2026-09-02         7
    2026-09-03        16
    2026-09-04        37
    2026-09-05        29
    2026-09-06       134
    2026-09-07        14
    2026-09-09        12
    2026-09-10         7
    2026-09-11        13
    2026-09-12        19
    2026-09-13        41
    2026-09-14       158
    2026-09-15         4
    2026-09-16         7
    2026-09-17         9
    2026-09-18        10
    2026-09-21        11
    2026-09-22        11
    2026-09-23        12
    2026-09-24        10
    2026-09-25        10
    2026-09-26         6
    2026-09-27         1
    2026-09-28         8
    2026-09-29         8
    2026-09-30         9
    2026-10-01        10
    2026-10-02         7
    2026-10-03         2
    2026-10-05         6
    2026-10-06         8
    2026-10-07         3
    2026-10-08        15
    2026-10-09         4
    2026-10-10         2
    2026-10-11         3
    2026-10-12        10
    2026-10-13        18
    2026-10-14         8
    2026-10-15        11
    2026-10-16         2
    2026-10-17        12
    2026-10-18         1
    2026-10-19         6
    2026-10-20         3
    2026-10-21        16
    2026-10-22         1
    2026-10-23         4
    2026-10-24         3
    2026-10-25         4
    2026-10-26         8
    2026-10-27         9
    2026-10-28        10
    2026-10-30         9
    2026-11-02         2
    2026-11-03         5
    2026-11-04         4
    2026-11-05        11
    2026-11-06         8
    2026-11-07         3
    2026-11-08         1
    2026-11-09         4
    2026-11-10         6
    2026-11-11        13
    2026-11-12         8
    2026-11-13         7
    2026-11-14         2
    consolidated     717
  capture_type breakdown:
    feed                18,983
    publisher_index_scraper     573
    home_feed              251
    publisher_llm_extract     214
    publisher_gnews        168
    publisher_rss_article     109
    permalink               82
    (unknown)               58
    publisher_article       17
    publisher_headline_only      10
    publisher_headline_signal       2
  top 12 FB sources by capture count:
     9,488  groups/letseatsouthflorida
     5,539  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
       156  photo
       139  search

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

== 2. Signal discoveries (statewide) ==
  under_emergency_order           387
  recent_failures               3,240
  worst_offenders               2,000
  bad_actors                    1,811
  permanent_closures              749
  clean_plates                  6,557
  delinquent                        0
  lost_licenses                     0
  new_licenses                  1,650   (-10 vs prev 1,660)

== 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=41    bad=198   closures=7    
  fort-lauderdale         UEO=38    fails=443   bad=188   closures=82   
  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=52    fails=344   bad=165   closures=46   
  license-identity-quarantine  UEO=0     fails=0     bad=0     closures=0    
  miami                   UEO=41    fails=531   bad=180   closures=93   
  news-main-parity        UEO=0     fails=0     bad=0     closures=0    
  north-florida           UEO=32    fails=158   bad=179   closures=61   
  orlando                 UEO=67    fails=569   bad=182   closures=176  
  owners-dict             UEO=0     fails=0     bad=0     closures=0    
  riskyeats-sqlite-manifest  UEO=0     fails=0     bad=0     closures=0    
  southwest-florida       UEO=22    fails=256   bad=188   closures=80   
  tampa-bay               UEO=84    fails=345   bad=176   closures=136  
  treasure-coast          UEO=12    fails=114   bad=187   closures=18   
  venue-key-aliases       UEO=0     fails=0     bad=0     closures=0    
  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=35    fails=439   bad=168   closures=50   

== 3. DBPR / source-parquet drift ==
  ✓ all tracked parquets match baseline
  --- licenses_hr.parquet ---  [ok]
    rows: 70,099   mtime: 2026-11-14T17:04:57+00:00
    columns: 35
  --- inspections.parquet ---  [ok]
    rows: 1,378,811   mtime: 2026-11-14T17:05:21+00:00
    columns: 87
  --- master_business.parquet ---  [ok]
    rows: 70,099   mtime: 2026-11-14T10:00:40+00:00
    columns: 29
  --- new_facilities.parquet ---  [ok]
    rows: 57,047   mtime: 2026-11-14T17:04:29+00:00
    columns: 58
  --- ownership_changes.parquet ---  [ok]
    rows: 43,005   mtime: 2026-11-14T17:04:34+00:00
    columns: 58
  --- oss_places_enriched.parquet ---  [ok]
    rows: 54,794   mtime: 2026-11-14T08:07:54+00:00
    columns: 77

== 3b. Map injections + Sunbiz daily health ==
  ⚠ one or more sources STALE (see below)
  [         ok] FSQ OS Places (map)         1,686,959 rows   29.5d / max 40d
                ↳ release: 2026-10-15 (032547df)
  [         ok] Overture places (map)       1,409,572 rows   30.0d / max 40d
                ↳ release: no pin recorded
  [         ok] OpenStreetMap places (map)     25,178 rows    1.4d / max 10d
  [         ok] OSS enriched (map JOIN)        54,794 rows    0.4d / max 10d
  [      STALE] Sunbiz CORP (daily)        12,894,821 rows   35.4d / max 2d
  [         ok] Sunbiz FIC  (daily)           805,281 rows    0.3d / max 7d

== 3c. DBPR food-archive source health ==
  ✓ every archive file matches its folder
  [        ok ] newfood/newfood_1617.csv  4,455/4,455 rows belong (100%)
  [        ok ] newfood/newfood_1718.csv  4,514/4,514 rows belong (100%)
  [        ok ] newfood/newfood_1819.csv  4,730/4,730 rows belong (100%)
  [        ok ] newfood/newfood_1920.xls  4,550/4,550 rows belong (100%)
  [        ok ] newfood/newfood_2021.csv  5,747/5,747 rows belong (100%)
  [        ok ] newfood/newfood_2122.csv  5,643/5,643 rows belong (100%)
  [        ok ] newfood/newfood_2223.csv  5,659/5,659 rows belong (100%)
  [      INFO ] newfood/newfood_2324.xlsx  6,534/21,619 rows belong (30%)  — combined application log as DBPR publishes it
  [        ok ] newfood/newfood_2425.xlsx  6,262/6,262 rows belong (100%)
  [        ok ] newfood/newfood_2526.xlsx  6,585/6,585 rows belong (100%)
  [        ok ] chgownr/change-owner-food_1718.csv  4,333/4,333 rows belong (100%)
  [        ok ] chgownr/change-owner-food_1819.csv  4,609/4,609 rows belong (100%)
  [        ok ] chgownr/change-owner-food_1920.csv  4,114/4,114 rows belong (100%)
  [        ok ] chgownr/change-owner-food_2021.csv  3,912/3,912 rows belong (100%)
  [        ok ] chgownr/change-owner-food_2122.csv  4,730/4,730 rows belong (100%)
  [        ok ] chgownr/change-owner-food_2223.csv  4,484/4,484 rows belong (100%)
  [        ok ] chgownr/change-owner-food_2324.xlsx  4,544/4,544 rows belong (100%)
  [        ok ] chgownr/change-owner-food_2425.xlsx  4,752/4,752 rows belong (100%)
  [        ok ] chgownr/change-owner-food_2526.xlsx  5,083/5,083 rows belong (100%)

== 3d. Change-of-owner monthly continuity ==
  ✓ no gaps in 110 watched months (2017-08 through the last complete month)