Lawyers Database v.2.0.0
149,225 Business places
AccountWelcome, guestSign in / Register
Current release story
Explore 149,225 selected attorney and law-firm business locations across all 50 states, with linked contacts, practical formats, and clear guidance on coverage and licensing.

Explore 149,225 selected attorney and law-firm business locations across all 50 U.S. states. Use published business names, street locations and available contact channels for directories, mapping and research.
Lawyer and Law Firm Locations supplies core locations. Lawyer and Law Firm Contacts adds published phone and website contacts. Complete Lawyers Directory adds expanded traceability and labeled historical reference fields.
A listing does not establish an individual attorney license, specialty credential, availability, endorsement, or real-time operating status. This is a selective business-place directory, not an exhaustive census of lawyers or a bar-verified individual registry. Operating status and contacts can be unknown or outdated. Verify important details with the relevant licensing authority and business before use. Published contacts do not imply consent for unsolicited marketing.
Every tier includes matching UTF-8 CSV, JSON and SQLite, schemas, field definitions, samples, statistics and documentation.
USAGE
Import, modify, combine and analyze within one organization, including work by supervised contractors.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Usage License
Choose this package abovePUBLICATION
All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Publication License
Choose this package aboveMASTER
All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Master License
Choose this package aboveRelease structure
Review the published tables, record coverage, and field names included with release 2.0.0.
Data dictionary
| Table | Records | Fields |
|---|---|---|
| locations | 149225 | location_id, location_name, address_line_1, city, state_code, postal_code, country_code, latitude, longitude, business_segment, business_category, operating_status, confidence |
| contacts | 270406 | contact_id, location_id, contact_type, contact_value, verification_status |
Release at a glance
A selected directory of attorney and law-firm business-place listings across all 50 U.S. states. Names and categories do not verify an individual attorney license, specialty credential, availability, or legal outcomes.
This release represents 50 state or territory codes. The 12 largest totals are shown below.
Showing the 12 largest groups from 27 represented values.
Select a table to review its schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.
Inspect the data
Switch tables to review representative fields and rows from every table advertised for this release.
| location_id | location_name | address_line_1 | city | state_code | postal_code | country_code | latitude | longitude | business_segment | business_category | operating_status | confidence |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OD87:d0d3a527f35e5f430e81027f | 49th Estate Planning | 8800 Glacier Hwy #222 | Juneau | AK | 99801 | US | 58.36404037475586 | -134.57882690429688 | Attorney or law firm | Wills Trusts And Probate | open | 0.9199122190475464 |
| OD87:fbbdc8270b50406fe86bf5dc | Beahm Law | 7083 Hollywood Blvd | Los Angeles | CA | 90028 | US | 34.101558685302734 | -118.34439849853516 | Attorney or law firm | Criminal Defense Law | open | 0.85 |
| OD87:310677464e6a75c68c34ef63 | Law Office of Kelly G. Jette | 225 E 4th Ave | Escondido | CA | 92025 | US | 33.11982727050781 | -117.07747650146484 | Attorney or law firm | Wills Trusts And Probate | open | 0.9199122190475464 |
| OD87:a61fd18cfb4d31c97e668517 | Schwartz, Semerdjian, Cauley & Moot, Llp | 101 W Broadway Ste 810 | San Diego | CA | 92101-8229 | US | 32.714874267578125 | -117.1646957397461 | Law-named legal business | Legal Service | open | 0.9902192950248718 |
| OD87:977bd39d24ea71984d09f700 | Joseph J. Colarusso, Attorney At Law | 1234 Summer St Ste 409 | Stamford | CT | 06905-5510 | US | 41.06130599975586 | -73.54174041748047 | Law-named legal business | Legal Service | open | 0.999503392291069 |
| OD87:fbe010d3a3aa05d41b06a4b5 | Law Office of Gale H. Moore, P.A. | 801 W Bay Dr | Largo | FL | 33770 | US | 27.915170669555664 | -82.7969741821289 | Attorney or law firm | Divorce And Family Law | open | 0.9199122190475464 |
| OD87:9048e31d8408347e37db3807 | Zimmerman & Frachtman, P.A. | 6991 N State Rd 7 | Parkland | FL | 33073 | US | 26.31812286376953 | -80.20317077636719 | Attorney or law firm | Personal Injury Law | open | 0.9199122190475464 |
| OD87:67cc200e4f1c950bc36c80ff | Bentz Holguin Law Firm | 100 N La Salle St | Chicago | IL | 60602-2448 | US | 41.883445739746094 | -87.63276672363281 | Law-named legal business | Legal Service | open | 0.9199122190475464 |
| OD87:c007add95aba2b2301bec0e8 | Thomas Rothe, Attorney at Law | 713 E 54th St | Indianapolis | IN | 46220 | US | 39.85093307495117 | -86.1451644897461 | Attorney or law firm | Bankruptcy Law | open | 0.9199122190475464 |
| OD87:323604abe2c37ea8c425c45e | Law Offices of William E. Scannell | 60 Stoneybrook Drive | Bridgewater | MA | 02324 | US | 41.947357177734375 | -70.9840087890625 | Attorney or law firm | Bankruptcy Law | unknown | 0.85 |
| OD87:3738752f947619dc3a7c21b7 | University of Michigan Law School | 625 S State St | Ann Arbor | MI | 48109 | US | 42.27376174926758 | -83.74052429199219 | Attorney or law firm | Attorney Or Law Firm | open | 0.9722161889076233 |
| OD87:cf81a8bf146b46947e8e2923 | Guidry Law Firm Pllc | 338 S Sharon Amity Rd | Charlotte | NC | 28211-2806 | US | 35.175254821777344 | -80.80221557617188 | Law-named legal business | Legal Service | open | 0.95 |
| OD87:550e2b68430bd9942765c24f | Szaferman Lakind Attorneys At Law | 68 N Bridge St | Somerville | NJ | 08876-1953 | US | 40.57060241699219 | -74.61072540283203 | Law-named legal business | Legal Service | open | 0.9995401048660278 |
| OD87:34c347e60428049a6f0d30b1 | Law Offices of David Slater | 240 W 73rd St | New York | NY | 10023 | US | 40.7796745300293 | -73.98267364501953 | Attorney or law firm | Attorney Or Law Firm | open | 0.9199122190475464 |
| OD87:0f5455f6a7dcd7fc7143bd0c | Replogle Law Office, Llc - Trademark And Business Lawyer | 4031 Colonel Glenn Hwy | Beavercreek Township | OH | 45431-2700 | US | 39.77265548706055 | -84.08088684082031 | Law-named legal business | Legal Service | open | 0.95 |
| OD87:1e14e81fb7fc613e067b02ab | Molnar Law Offices | 31 W 1st St Unit J | Wind Gap | PA | 18091-1515 | US | 40.839759826660156 | -75.29688262939453 | Attorney or law firm | Divorce And Family Law | open | 0.9199122190475464 |
| OD87:44b9f099be94f8fb9a647ec9 | Abogado Ruiz Law Firm, PLLC | 3718 E Broadway St | Pearland | TX | 77581 | US | 29.563356399536133 | -95.28358459472656 | Attorney or law firm | Personal Injury Law | open | 0.9902192950248718 |
| OD87:c094d0c8cf3cc52f7e672e00 | Moran Law Firm, Pllc | 100 E Ferguson St Ste 1200 | Tyler | TX | 75702-5700 | US | 32.352256774902344 | -95.30007934570312 | Attorney or law firm | Divorce And Family Law | open | 0.9199122190475464 |
| OD87:3d8f3ec11022c031446f538f | Law Office Of W. Andrew Patzig | 2006 Old Greenbrier Rd Ste 7 | Chesapeake | VA | 23320-2648 | US | 36.793270111083984 | -76.23577880859375 | Law-named legal business | Legal Service | open | 0.95 |
| OD87:31c8a75b2e9416590c72c815 | Zubrod Law Office | 219 E 18th St | Cheyenne | WY | 82001 | US | 41.135555267333984 | -104.81327819824219 | Attorney or law firm | Attorney Or Law Firm | open | 0.9199122190475464 |
| contact_id | location_id | contact_type | contact_value | verification_status |
|---|---|---|---|---|
| OD87:d0d3a527f35e5f430e81027f:phone | OD87:d0d3a527f35e5f430e81027f | phone | +19073125436 | published_unverified |
| OD87:5e9c6faf783ce1302b366876:phone | OD87:5e9c6faf783ce1302b366876 | phone | 16267777700 | published_unverified |
| OD87:2a939c288b7ee202e8dff1b2:phone | OD87:2a939c288b7ee202e8dff1b2 | phone | 19163185142 | published_unverified |
| OD87:bebb0bfd151bf721b655344b:website | OD87:bebb0bfd151bf721b655344b | website | https://www.silverthorneattorneys.com/ | published_unverified |
| OD87:6ffe48b29aaa52be4c55f49a:phone | OD87:6ffe48b29aaa52be4c55f49a | phone | +18602756700 | published_unverified |
| OD87:57c0d1ceea03480fdfae5f5f:phone | OD87:57c0d1ceea03480fdfae5f5f | phone | +17277967774 | published_unverified |
| OD87:064185d8acd2e4091cd7de93:phone | OD87:064185d8acd2e4091cd7de93 | phone | 17622577020 | published_unverified |
| OD87:dcf2b7ce91943c3558be2a4b:phone | OD87:dcf2b7ce91943c3558be2a4b | phone | 16305686656 | published_unverified |
| OD87:ada92b20393d20acba32a2d8:website | OD87:ada92b20393d20acba32a2d8 | website | https://amramp.com/kansas-city/ | published_unverified |
| OD87:8f692e4ca095cbcc204c0c8e:phone | OD87:8f692e4ca095cbcc204c0c8e | phone | 8774882667 | published_unverified |
| OD87:8e3e8ee93349af560bd2f655:phone | OD87:8e3e8ee93349af560bd2f655 | phone | +15865801680 | published_unverified |
| OD87:4d31ce242e49648653a942c5:phone | OD87:4d31ce242e49648653a942c5 | phone | 13366453959 | published_unverified |
| OD87:de196acf68244ecdb7eae98b:website | OD87:de196acf68244ecdb7eae98b | website | https://www.teamlaw.com/firm-overview/ | published_unverified |
| OD87:f68b8180ec03d56265b43970:phone | OD87:f68b8180ec03d56265b43970 | phone | 5183711299 | published_unverified |
| OD87:cac7e06bbfed7d1e7cc9b637:website | OD87:cac7e06bbfed7d1e7cc9b637 | website | https://www.rcolaw.com | published_unverified |
| OD87:9ff9d75fe370e58501a44d54:phone | OD87:9ff9d75fe370e58501a44d54 | phone | +17178446907 | published_unverified |
| OD87:67c33ec48fa0170d010e594f:phone | OD87:67c33ec48fa0170d010e594f | phone | +19792776247 | published_unverified |
| OD87:d4588bb79c3a8389c9457711:website | OD87:d4588bb79c3a8389c9457711 | website | http://www.mmorenolaw.com/ | published_unverified |
| OD87:bd80b447c3c9da813d705d7b:phone | OD87:bd80b447c3c9da813d705d7b | phone | 17033484646 | published_unverified |
| OD87:31c8a75b2e9416590c72c815:website | OD87:31c8a75b2e9416590c72c815 | website | http://zubrodlaw.com | published_unverified |
149,225 primary business places. Related contact and reference rows are not additional locations.
Need a closer fit?
A clear path from download to project
Understand the files, check the sample coverage, and choose the license that fits your use.