02 — What’s in a drop
One spreadsheet, every plumbing permit
Each drop is a spreadsheet (CSV + Excel) of commercial plumbing permits issued in Philadelphia in the last 7 days, pulled from the city’s open L&I records, updated daily at the source. Columns: permit number, issue date, permit type, type of work, contractor name as published, and the contractor’s published business address. That’s the contractor’s own business address — not the project address.
First Drop covers all commercial permit types. The plumbing filter is a Four Mondays and Full Quarter feature — on those, each drop is filtered to plumbing permits and includes a per-contractor count for the week, so you can see who’s busiest.