Download options and table customization, with NAICS bookstore example
Summary
Presenter demonstrated Excel and ZIP download formats (ZIP includes geo IDs), how to edit columns and pin headers, and used NAICS code 451211 to show county business patterns listing bookstores (New York County: 96 bookstores).
Weister walked through the table toolbar and download options: "When you click the download button at the top, you'll get a pop up window" offering Excel (presentation‑ready, two tabs) and ZIP (machine‑readable, includes geo IDs). He explained the Excel file contains a metadata tab and a data tab almost identical to the table display, and that the ZIP's flat data format is useful for mapping or programmatic analysis.
Using NAICS industry codes, Weister drilled to bookstores (NAICS 451211), selected all New York counties and inspected the CB2300CBP (county business patterns) table (2023 vintage). He showed how to filter rows (for example to aggregate to one row per county) and noted New York County had 96 bookstore establishments with paid employees in the example.
AI generated
The text on this page is AI generated. Summaries, highlights, analysis, and video transcripts are all produced from the original source material.
AI can make mistakes, so if you spot one, and we will fix it for everyone.
Note: the source content is unaltered by us. Any content source we link to, be it a video, an audio recording, or a document, is presented exactly as its publisher released it. That publisher is usually a government body, sometimes an individual official or another organisation.
