This is a postgres database containing tax data on ~160,000 properties in New Orleans. I heard the assessor's office was unwilling to share the data with the city's open data initiative so I'm releasing it here. I've scraped this data from the tax assessor's web site. Code is available on request.
Here is an example page of a single property.
There are 3 important tables here:
public | properties | table | ben
public | property_sales | table | ben
public | property_values | table | ben
These roughly correspond to the html tables on the site and the naming is pretty much the same except everything is snake-cased.
Also note that the properties have a lng_lat_point
field that is a geometry
type from postgis.
nola_assessor_scraper=# \d properties
id | integer | not null default nextval('properties_id_seq'::regclass)
assessor_id | character varying(255) |
owner_name | text |
land_area_sq_ft | integer |
location_address | text |
mailing_address | text |
property_class | character varying(255) |
municipal_district | character varying(255) |
assessment_area | character varying(255) |
tax_bill_number | character varying(255) |
inserted_at | timestamp without time zone | not null
updated_at | timestamp without time zone | not null
lng_lat_point | geometry(Point,3452) |
parcel_no | character varying(255) |
nola_assessor_scraper=# \d property_sales
id | integer | not null default nextval('property_sales_id_seq'::regclass)
property_id | integer |
date | timestamp without time zone |
price | integer |
grantor | character varying(255) |
grantee | character varying(255) |
notarial_archive_number | character varying(255) |
instrument_number | character varying(255) |
inserted_at | timestamp without time zone | not null
updated_at | timestamp without time zone | not null
nola_assessor_scraper=# \d property_values
id | integer | not null default nextval('property_values_id_seq'::regclass)
property_id | integer |
year | integer |
land_value | integer |
building_value | integer |
total_value | integer |
assessed_land_value | integer |
assessed_building_value | integer |
total_assessed_value | integer |
homestead_exemption_value | integer |
taxable_assessment | integer |
inserted_at | timestamp without time zone | not null
updated_at | timestamp without time zone | not null
Tip: you'll need postgres with postgis installed
- Clone this repo.
- Unzip the sql dump.
- Restore the database with psql.
git clone https://github.com/bhelx/nola-assessor-data.git
cd nola-assessor-data
# You'll need gzip installed to run this
gunzip data.sql.gz
# You may need to change the username here
psql -U postgres nola_assessor_scraper < data.sql
You can find csv exports in the csv_exports
archive.
tar xzvf csv_exports.tar.gz