- query
- The Angi URL you submitted, repeated on every row that came from it.
- name
- The company name.
- category
- The trade, echoing the category in the search URL - e.g. plumbing.
- rating
- The headline star rating, as a string with two decimals. Not the same number as the summarised OVERALL rating below.
- review_count
- How many reviews the company has, as a string.
- phone
- Empty in every export we have checked. See the note below.
- description
- The company’s own blurb. Occasionally ends with their website address - there is no separate website column.
- street
- Street line of the company’s address.
- city
- Town or city.
- region
- State, two-letter.
- postal
- The company’s own postcode - not the postcode you searched.
- country
- Country code. US in every export we have checked.
- image
- Company logo or photo, hosted on Angi’s HomeAdvisor CDN.
- hours
- Empty in every export we have checked.
- profile_url
- Link to the company’s Angi listing page.
- id
- Angi’s numeric id for the company, as a string. The same id appears at the end of the profile URL.
- listing_url
- Duplicate of profile_url - the same value under a second name.
- title
- Duplicate of name - the same value under a second name.
- address_street1
- Duplicate of street - the same value under a second name.
- address_street2
- Second address line: suite, unit or PO box. Genuinely sparse - most companies have nothing here.
- address_city
- Duplicate of city - the same value under a second name.
- address_state
- Duplicate of region - the same value under a second name.
- address_country
- Duplicate of country - the same value under a second name.
- address_postalCode
- Duplicate of postal - the same value under a second name. Note the camelCase, alone among the address columns.
- years_in_business
- How long the company has traded, as a number.
- reviews
- Duplicate of review_count - the same value under a second name.
- recommended_rate
- Percentage of reviewers who would recommend the company, as a number from 0 to 100.
- average_ratings_summarized_PROFESSIONALISM
- Summarised sub-rating, as a number.
- average_ratings_summarized_PUNCTUALITY
- Summarised sub-rating, as a number.
- average_ratings_summarized_OVERALL
- Summarised overall sub-rating, as a number. Close to
rating but not equal to it - the two disagreed on every row. - average_ratings_summarized_RESPONSIVENESS
- Summarised sub-rating, as a number.
- average_ratings_summarized_QUALITY
- Summarised sub-rating, as a number.
- average_ratings_summarized_VALUE
- Summarised sub-rating, as a number.
- amenities_emergency_services
- Boolean. Does emergency callouts.
- amenities_free_estimates
- Boolean. Quotes for free.
- amenities_warranties_offered
- Boolean. Offers warranties.
- amenities_veteran_owned
- Boolean. Veteran-owned business.
- amenities_bilingual
- Boolean. Bilingual staff.
- amenities_small_jobs_welcome
- Boolean. Takes small jobs.
- amenities_accepted_payment_methods
- A string, not a boolean - the odd one out among the amenity columns. Only CREDIT_CARD has appeared in the exports we checked, so treat the vocabulary as open.
- amenities_offers_commercial_services
- Boolean. Works commercial as well as residential.
- local_quotes
- Empty in every export we have checked.
- position
- 1-based rank within the query, in the order Angi returned the listing. JSON only - the CSV and XLSX exports stop at forty-two columns.