02 — What’s in a drop
One spreadsheet, every concrete permit
Each drop is a spreadsheet (CSV + Excel) of commercial Building 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. Concrete work has no permit type of its own in Philadelphia — the concrete slice is the Building rows whose work description names concrete work.
First Drop covers all commercial permit types. The concrete filter is a Four Mondays and Full Quarter feature — on those, each drop is filtered to the concrete rows inside Building permits and includes a per-contractor count for the week, so you can see who’s busiest.