#load libraries and APIs
import time
import datetime
import pandas as pd
import geopandas as gpd
import numpy as np
import shapely
from shapely.geometry import Point, Polygon
import fiona
import folium
import os
import math
#Load data
data_folder = 'Data/'
data = data_folder + '1_jan_17-7_mar_18.csv'
#Read Data
df = pd.read_csv(data)
#Close Date to index
df.index = pd.to_datetime(df['CloseDate'], infer_datetime_format=True, errors='coerce')
df['_index'] = df.index
df = df.sort_index()
#Change datatype of conflicting data types #Boolean to binary
for column in df:
if df[column].dtype == 'bool':
df[column] = (df[column] == True).astype(int)
#Change dataframe to geospatial and check by exporting to shp
geometry = [Point(xy) for xy in zip(df.Longitude, df.Latitude)]
crs = {'init': 'epsg:4326'}
geo_df = gpd.GeoDataFrame(df, crs=crs, geometry=geometry)
#geo_df.to_file(driver='ESRI Shapefile', filename='data.shp')
#geo_df.to_file(driver='GeoJSON', filename='data.json')
#Filter to keep only duplicates
df = df[df['FullStreetAddress'].duplicated(keep=False)]
#Get time Delta and filter dataframe on it
df['Time_Delta'] = df['FullStreetAddress'].apply(lambda x : df[df['FullStreetAddress'] == x]['_index'][0])
df['Time_Delta'] = df['_index'] - df['Time_Delta']
df = df[df['Time_Delta'].dt.days < 1825 ]
#Selected Columns if needed
#columns = ['ListPrice', 'ClosePrice', 'OriginalListPrice', 'TotalTaxes']
#Get All numeric columns
columns = df._get_numeric_data().columns.values.flatten()
#Get Deltas for required columns of all subsequent duplicates
for column in columns:
df['temp'] = 0
df.loc[df['Time_Delta'].dt.days > 0, 'temp'] = df[df['Time_Delta'].dt.days > 0]['FullStreetAddress'].apply(lambda x: df[df['FullStreetAddress'] == x][column][0])
df[column] = df[column] - df['temp']
#Optional Delta Remove if not needed
df.loc[df['Time_Delta'].dt.days > 0, column] = "Delta:" + df[df['Time_Delta'].dt.days > 0][column].astype(str)
#Show First Duplicate Values and subsequest duplicates below it #Sorting
df = df.sort_values(by = ['FullStreetAddress'])
print(df)
Ownership FullStreetAddress PostalCode LotSizeArea \
CloseDate
2017-03-22 Fee Simple 111 50TH ST NE 20019 2875
2017-06-30 Fee Simple 111 50TH ST NE Delta:0 Delta:0
2018-02-16 Fee Simple 1118 HOLBROOK ST NE Delta:0 Delta:0
2017-03-24 Fee Simple 1118 HOLBROOK ST NE 20002 1347
2017-11-30 Fee Simple 1119 SOUTH CAROLINA AVE SE Delta:0 Delta:0
2017-02-21 Fee Simple 1119 SOUTH CAROLINA AVE SE 20003 1275
2017-10-09 Fee Simple 1125 COLUMBIA RD NW 20009 2787
2017-10-09 Fee Simple 1125 COLUMBIA RD NW 20009 2787
2017-07-17 Fee Simple 113 34TH ST SE 20019 1525
2017-09-18 Fee Simple 113 34TH ST SE Delta:0 Delta:0
2017-05-16 Fee Simple 1204 QUINCY ST NW 20011 1639
2017-09-18 Fee Simple 1204 QUINCY ST NW Delta:0 Delta:0
2017-09-01 Fee Simple 1205 42ND PL NE Delta:0 Delta:0
2017-04-14 Fee Simple 1205 42ND PL NE 20019 4160
2017-12-11 Fee Simple 121 56TH ST SE Delta:0 Delta:0
2017-06-09 Fee Simple 121 56TH ST SE 20019 2750
2018-02-23 Fee Simple 1212 BARNABY TER SE Delta:0 Delta:0
2017-11-22 Fee Simple 1212 BARNABY TER SE 20032 1414
2017-03-13 Fee Simple 1214 KIRBY ST NW 20001 572
2018-02-09 Fee Simple 1214 KIRBY ST NW Delta:0 Delta:0
2018-02-13 Fee Simple 1250 HAMLIN ST NE Delta:0 Delta:0
2017-07-21 Fee Simple 1250 HAMLIN ST NE 20017 5001
2017-06-19 Fee Simple 1283 OATES ST NE 20002 2513
2017-08-18 Fee Simple 1283 OATES ST NE Delta:0 Delta:0
2017-08-31 Fee Simple 1308 DELAFIELD PL NW 20011 1789
2018-02-23 Fee Simple 1308 DELAFIELD PL NW Delta:0 Delta:0
2017-01-23 Fee Simple 131 P ST NW 20001 1598
2017-12-05 Fee Simple 131 P ST NW Delta:0 Delta:0
2017-09-05 Fee Simple 1317 KENNEDY ST NW 20011 2765
2018-02-22 Fee Simple 1317 KENNEDY ST NW Delta:0 Delta:0
... ... ... ... ...
2017-05-05 Fee Simple 791 BARNABY ST SE 20032 2475
2017-09-08 Fee Simple 791 BARNABY ST SE Delta:0 Delta:0
2018-02-22 Fee Simple 807 JEFFERSON ST NE Delta:0 Delta:0
2017-08-04 Fee Simple 807 JEFFERSON ST NE 20011 2794
2017-04-12 Fee Simple 811 DECATUR ST NW 20011 1620
2018-01-03 Fee Simple 811 DECATUR ST NW Delta:0 Delta:0
2017-06-01 Fee Simple 813 BUCHANAN ST NW Delta:0 Delta:0
2017-02-02 Fee Simple 813 BUCHANAN ST NW 20011 2850
2017-02-15 Fee Simple 817 Q ST NW 20001 1029
2017-11-10 Fee Simple 817 Q ST NW Delta:0 Delta:0
2017-04-28 Fee Simple 825 LONGFELLOW ST NW 20011 1742
2018-02-05 Fee Simple 825 LONGFELLOW ST NW Delta:0 Delta:40
2017-11-20 Fee Simple 905 47TH PL NE Delta:0 Delta:0
2017-07-27 Fee Simple 905 47TH PL NE 20019 2247
2017-03-16 Fee Simple 909 COLUMBIA RD NW 20001 696
2017-11-02 Fee Simple 909 COLUMBIA RD NW Delta:0 Delta:0
2017-02-24 Fee Simple 912 DELAFIELD PL NW 20011 1620
2017-12-22 Fee Simple 912 DELAFIELD PL NW Delta:0 Delta:0
2017-07-14 Fee Simple 921 EMERSON ST NW 20011 1788
2017-12-15 Fee Simple 921 EMERSON ST NW Delta:0 Delta:0
2017-06-09 Fee Simple 929 QUINCY ST NW 20011 1800
2017-12-29 Fee Simple 929 QUINCY ST NW Delta:0 Delta:0
2017-07-18 Fee Simple 930 9TH ST NE 20002 1000
2018-01-26 Fee Simple 930 9TH ST NE Delta:0 Delta:0
2017-11-14 Fee Simple TOTTEN MEWS NE Delta:0 Delta:0
2017-12-22 Fee Simple TOTTEN MEWS NE Delta:0 Delta:0
2017-09-19 Fee Simple TOTTEN MEWS NE 20017 1800
2017-09-20 Fee Simple TOTTEN MEWS NE Delta:0 Delta:0
2017-09-21 Fee Simple TOTTEN MEWS NE Delta:0 Delta:0
2017-09-29 Fee Simple TOTTEN MEWS NE Delta:0 Delta:0
LivingArea ListPrice ClosePrice Beds \
CloseDate
2017-03-22 0 195000 200000 3
2017-06-30 Delta:0 Delta:144000.0 Delta:150652.77000000002 Delta:0
2018-02-16 Delta:1848 Delta:364999.0 Delta:339150.0 Delta:1
2017-03-24 0 385000 406800 3
2017-11-30 Delta:0 Delta:498500.0 Delta:490100.0 Delta:0
2017-02-21 0 890000 910000 4
2017-10-09 3200 1.25e+06 1.146e+06 6
2017-10-09 3200 1.25e+06 1.146e+06 6
2017-07-17 0 195000 160000 3
2017-09-18 Delta:0 Delta:104900.0 Delta:149000.0 Delta:0
2017-05-16 0 575000 520000 3
2017-09-18 Delta:0 Delta:324900.0 Delta:397500.0 Delta:1
2017-09-01 Delta:0 Delta:210000.0 Delta:215100.0 Delta:1
2017-04-14 0 189900 189900 3
2017-12-11 Delta:0 Delta:238700.0 Delta:189565.0 Delta:0
2017-06-09 0 161200 210335 3
2018-02-23 Delta:2037 Delta:154900.0 Delta:154900.0 Delta:1
2017-11-22 0 195000 195000 3
2017-03-13 0 399000 399000 2
2018-02-09 Delta:0 Delta:130500.0 Delta:130500.0 Delta:0
2018-02-13 Delta:-1930 Delta:370000.0 Delta:450000.0 Delta:1
2017-07-21 1930 530000 450000 3
2017-06-19 0 425000 399900 3
2017-08-18 Delta:1821 Delta:115000.0 Delta:140100.0 Delta:1
2017-08-31 0 480000 460000 3
2018-02-23 Delta:0 Delta:344999.9 Delta:360000.0 Delta:1
2017-01-23 0 736000 720000 4
2017-12-05 Delta:2307 Delta:414000.0 Delta:402500.0 Delta:0
2017-09-05 0 450000 450000 4
2018-02-22 Delta:2620 Delta:399900.0 Delta:431000.0 Delta:0
... ... ... ... ...
2017-05-05 0 160700 175000 3
2017-09-08 Delta:0 Delta:189290.0 Delta:174990.0 Delta:0
2018-02-22 Delta:0 Delta:260000.0 Delta:259000.0 Delta:1
2017-08-04 0 299000 300000 3
2017-04-12 1424 439000 465000 3
2018-01-03 Delta:-1424 Delta:360950.0 Delta:324000.0 Delta:1
2017-06-01 Delta:0 Delta:418750.0 Delta:479850.0 Delta:1
2017-02-02 0 381150 381150 3
2017-02-15 2199 800000 935000 4
2017-11-10 Delta:0 Delta:639000.0 Delta:515000.0 Delta:-1
2017-04-28 1528 495000 475000 3
2018-02-05 Delta:368 Delta:254000.0 Delta:270000.0 Delta:0
2017-11-20 Delta:1100 Delta:185000.0 Delta:189700.0 Delta:1
2017-07-27 0 209900 210200 2
2017-03-16 1253 375000 416000 2
2017-11-02 Delta:-1253 Delta:314900.0 Delta:294000.0 Delta:0
2017-02-24 0 430000 430000 3
2017-12-22 Delta:0 Delta:219999.0 Delta:210000.0 Delta:1
2017-07-14 2460 449900 450000 4
2017-12-15 Delta:0 Delta:319100.0 Delta:315000.0 Delta:0
2017-06-09 0 575000 560000 3
2017-12-29 Delta:2138 Delta:424000.0 Delta:440000.0 Delta:1
2017-07-18 0 549950 435000 2
2018-01-26 Delta:0 Delta:209950.0 Delta:324900.0 Delta:1
2017-11-14 Delta:0 Delta:-53868.0 Delta:-52226.0 Delta:0
2017-12-22 Delta:152 Delta:-16256.0 Delta:-15216.0 Delta:0
2017-09-19 1998 646256 640216 3
2017-09-20 Delta:0 Delta:-24796.0 Delta:-40811.0 Delta:0
2017-09-21 Delta:0 Delta:-26256.0 Delta:-20216.0 Delta:0
2017-09-29 Delta:0 Delta:-71256.0 Delta:-65216.0 Delta:0
ListDate CloseDate ... DualAgency \
CloseDate ...
2017-03-22 2/25/17 3/22/17 ... 1
2017-06-30 5/10/17 6/30/17 ... Delta:0
2018-02-16 1/11/18 2/16/18 ... Delta:0
2017-03-24 3/6/17 3/24/17 ... 1
2017-11-30 10/26/17 11/30/17 ... Delta:0
2017-02-21 1/11/17 2/21/17 ... 0
2017-10-09 10/9/17 10/9/17 ... 1
2017-10-09 10/9/17 10/9/17 ... 1
2017-07-17 6/19/17 7/17/17 ... 0
2017-09-18 8/17/17 9/18/17 ... Delta:0
2017-05-16 4/17/17 5/16/17 ... 1
2017-09-18 8/24/17 9/18/17 ... Delta:0
2017-09-01 8/4/17 9/1/17 ... Delta:-1
2017-04-14 3/27/17 4/14/17 ... 1
2017-12-11 10/18/17 12/11/17 ... Delta:0
2017-06-09 3/9/17 6/9/17 ... 1
2018-02-23 1/17/18 2/23/18 ... Delta:0
2017-11-22 10/20/17 11/22/17 ... 1
2017-03-13 3/13/17 3/13/17 ... 1
2018-02-09 12/19/17 2/9/18 ... Delta:0
2018-02-13 1/18/18 2/13/18 ... Delta:0
2017-07-21 6/24/17 7/21/17 ... 1
2017-06-19 1/24/17 6/19/17 ... 1
2017-08-18 7/22/17 8/18/17 ... Delta:-1
2017-08-31 8/2/17 8/31/17 ... 1
2018-02-23 1/10/18 2/23/18 ... Delta:0
2017-01-23 1/5/17 1/23/17 ... 1
2017-12-05 7/28/17 12/5/17 ... Delta:0
2017-09-05 8/3/17 9/5/17 ... 1
2018-02-22 1/17/18 2/22/18 ... Delta:0
... ... ... ... ...
2017-05-05 3/11/17 5/5/17 ... 0
2017-09-08 8/10/17 9/8/17 ... Delta:1
2018-02-22 1/11/18 2/22/18 ... Delta:0
2017-08-04 7/13/17 8/4/17 ... 1
2017-04-12 3/10/17 4/12/17 ... 1
2018-01-03 12/7/17 1/3/18 ... Delta:0
2017-06-01 4/27/17 6/1/17 ... Delta:1
2017-02-02 2/2/17 2/2/17 ... 0
2017-02-15 1/26/17 2/15/17 ... 0
2017-11-10 10/11/17 11/10/17 ... Delta:1
2017-04-28 4/5/17 4/28/17 ... 1
2018-02-05 10/12/17 2/5/18 ... Delta:0
2017-11-20 10/12/17 11/20/17 ... Delta:0
2017-07-27 5/29/17 7/27/17 ... 1
2017-03-16 2/8/17 3/16/17 ... 0
2017-11-02 9/22/17 11/2/17 ... Delta:0
2017-02-24 2/7/17 2/24/17 ... 1
2017-12-22 9/28/17 12/22/17 ... Delta:0
2017-07-14 6/13/17 7/14/17 ... 1
2017-12-15 11/7/17 12/15/17 ... Delta:0
2017-06-09 5/6/17 6/9/17 ... 1
2017-12-29 12/1/17 12/29/17 ... Delta:0
2017-07-18 4/27/17 7/18/17 ... 1
2018-01-26 12/21/17 1/26/18 ... Delta:-1
2017-11-14 7/25/17 11/14/17 ... Delta:0
2017-12-22 10/15/17 12/22/17 ... Delta:0
2017-09-19 1/27/17 9/19/17 ... 0
2017-09-20 2/28/17 9/20/17 ... Delta:0
2017-09-21 7/11/17 9/21/17 ... Delta:0
2017-09-29 9/15/17 9/29/17 ... Delta:0
Exterior OwnerFirstName \
CloseDate
2017-03-22 Brick NaN
2017-06-30 Brick NaN
2018-02-16 Brick NaN
2017-03-24 Brick and Siding NaN
2017-11-30 Brick Rainbow
2017-02-21 Brick, Combination NaN
2017-10-09 Brick marguerite boudreau
2017-10-09 Brick marguerite boudreau
2017-07-17 Siding - Vinyl NaN
2017-09-18 Siding - Vinyl NaN
2017-05-16 Brick NaN
2017-09-18 Brick NaN
2017-09-01 Siding - Vinyl Sanjeewa
2017-04-14 Brick and Siding NaN
2017-12-11 Brick NaN
2017-06-09 Brick NaN
2018-02-23 Brick and Siding NaN
2017-11-22 Brick and Siding NaN
2017-03-13 Brick NaN
2018-02-09 Brick NaN
2018-02-13 Brick and Siding NaN
2017-07-21 Brick and Siding NaN
2017-06-19 Brick NaN
2017-08-18 Brick NaN
2017-08-31 Brick NaN
2018-02-23 Brick 1308 Delafield
2017-01-23 Brick NaN
2017-12-05 Brick NaN
2017-09-05 Brick NaN
2018-02-22 Brick, Hardiplank, Brick Front NaN
... ... ...
2017-05-05 Brick C/O
2017-09-08 Brick and Siding NaN
2018-02-22 Brick NaN
2017-08-04 Brick and Siding NaN
2017-04-12 Brick NaN
2018-01-03 Brick NaN
2017-06-01 Brick Front, Brick NaN
2017-02-02 Brick Front NaN
2017-02-15 Brick, Stone Estate of Raymond
2017-11-10 Brick NaN
2017-04-28 Brick NaN
2018-02-05 Brick and Siding Posin
2017-11-20 Brick NaN
2017-07-27 Brick Owner of
2017-03-16 Log, Siding - Aluminum / Steel Angela
2017-11-02 Brick NaN
2017-02-24 Siding - Vinyl NaN
2017-12-22 Brick Front NaN
2017-07-14 Brick and Siding NaN
2017-12-15 Brick and Siding, Brick Front NaN
2017-06-09 Brick Janie N.
2017-12-29 Brick and Siding, Hardiplank NaN
2017-07-18 Brick NaN
2018-01-26 Brick NaN
2017-11-14 Brick, Hardiplank Comstock
2017-12-22 Brick, Hardiplank Comstock
2017-09-19 Brick, Hardiplank Comstock
2017-09-20 Brick, Hardiplank Comstock
2017-09-21 Brick, Hardiplank Comstock
2017-09-29 Brick, Hardiplank Comstock
OwnerLastName OwnerOfficePhone YearBuilt _index \
CloseDate
2017-03-22 Fisher NaN 1934 2017-03-22
2017-06-30 LLC Delta:nan Delta:0 2017-06-30
2018-02-16 A&T Property Investm Delta:nan Delta:0 2018-02-16
2017-03-24 Clark NaN 1926 2017-03-24
2017-11-30 Properties Delta:nan Delta:0 2017-11-30
2017-02-21 McClenon NaN 1905 2017-02-21
2017-10-09 Trust, Ed Sauer TTEE NaN 1912 2017-10-09
2017-10-09 Trust, Ed Sauer TTEE NaN 1912 2017-10-09
2017-07-17 Hackley NaN 1989 2017-07-17
2017-09-18 Mehmetoglu Delta:nan Delta:0 2017-09-18
2017-05-16 Could be you NaN 1923 2017-05-16
2017-09-18 Could Be You Delta:nan Delta:0 2017-09-18
2017-09-01 Wickramasekera Delta:nan Delta:0 2017-09-01
2017-04-14 GAINES NaN 1928 2017-04-14
2017-12-11 Care of Broker Delta:nan Delta:0 2017-12-11
2017-06-09 c/o broker NaN 1951 2017-06-09
2018-02-23 DILAN Delta:nan Delta:0 2018-02-23
2017-11-22 PUBLIC RECORD NaN 1978 2017-11-22
2017-03-13 could be you NaN 1911 2017-03-13
2018-02-09 Nantucket Delta:nan Delta:0 2018-02-09
2018-02-13 Dilan Investments LL Delta:nan Delta:0 2018-02-13
2017-07-21 Scott NaN 1918 2017-07-21
2017-06-19 Owner of Record NaN 1924 2017-06-19
2017-08-18 OWNER Delta:nan Delta:0 2017-08-18
2017-08-31 Estate of Fitch NaN 1914 2017-08-31
2018-02-23 Pl. NW, LLC Delta:nan Delta:0 2018-02-23
2017-01-23 JOHNSON NaN 1906 2017-01-23
2017-12-05 5Design Delta:nan Delta:0 2017-12-05
2017-09-05 Owner NaN 1920 2017-09-05
2018-02-22 1317 Kennedy St NW Delta:nan Delta:0 2018-02-22
... ... ... ... ...
2017-05-05 AGENT NaN 1952 2017-05-05
2017-09-08 Stars home LLC Delta:nan Delta:0 2017-09-08
2018-02-22 c/o Agent Delta:nan Delta:0 2018-02-22
2017-08-04 See tax record NaN 1952 2017-08-04
2017-04-12 SEE TAX RECORD NaN 1925 2017-04-12
2018-01-03 YOU! Delta:nan Delta:0 2018-01-03
2017-06-01 Dilan Investments Delta:nan Delta:0 2017-06-01
2017-02-02 Walton NaN 1922 2017-02-02
2017-02-15 J. Milefsky NaN 1904 2017-02-15
2017-11-10 OWNER Delta:nan Delta:-4 2017-11-10
2017-04-28 Brown NaN 1922 2017-04-28
2018-02-05 Investments LLC Delta:nan Delta:0 2018-02-05
2017-11-20 Michaelman Delta:nan Delta:0 2017-11-20
2017-07-27 Record NaN 1913 2017-07-27
2017-03-16 Copeland NaN 1900 2017-03-16
2017-11-02 Owner Delta:nan Delta:0 2017-11-02
2017-02-24 See Showing Time NaN 1924 2017-02-24
2017-12-22 Seiden Delta:nan Delta:0 2017-12-22
2017-07-14 Cobey NaN 1923 2017-07-14
2017-12-15 Owner Of Records Delta:nan Delta:0 2017-12-15
2017-06-09 Hester NaN 1912 2017-06-09
2017-12-29 C/O AGENT Delta:nan Delta:0 2017-12-29
2017-07-18 Owner NaN 1910 2017-07-18
2018-01-26 Cameron Delta:nan Delta:0 2018-01-26
2017-11-14 Homes Delta:nan Delta:0 2017-11-14
2017-12-22 Homes Delta:nan Delta:0 2017-12-22
2017-09-19 Homes NaN 2017 2017-09-19
2017-09-20 Homes Delta:nan Delta:0 2017-09-20
2017-09-21 Homes Delta:nan Delta:0 2017-09-21
2017-09-29 Homes Delta:nan Delta:0 2017-09-29
geometry Time_Delta temp
CloseDate
2017-03-22 POINT (-76.92975 38.89122) 0 days 0
2017-06-30 POINT (-76.92981437 38.89124088) 100 days 1934
2018-02-16 POINT (-76.98494000000001 38.90137) 329 days 1926
2017-03-24 POINT (-76.98494000000001 38.90137) 0 days 0
2017-11-30 POINT (-76.99129121999999 38.88516061) 282 days 1905
2017-02-21 POINT (-76.99129121999999 38.88516061) 0 days 0
2017-10-09 POINT (-77.02840999999999 38.92795) 0 days 0
2017-10-09 POINT (-77.02840999999999 38.92795) 0 days 0
2017-07-17 POINT (-76.95780000000001 38.88836) 0 days 0
2017-09-18 POINT (-76.95780000000001 38.88836) 63 days 1989
2017-05-16 POINT (-77.02752 38.93735) 0 days 0
2017-09-18 POINT (-77.02752 38.93735) 125 days 1923
2017-09-01 POINT (-76.94171948 38.90592087) 140 days 1928
2017-04-14 POINT (-76.94158 38.9059) 0 days 0
2017-12-11 POINT (-76.92140000000001 38.88701) 185 days 1951
2017-06-09 POINT (-76.92140000000001 38.88701) 0 days 0
2018-02-23 POINT (-76.98721999999999 38.83484) 93 days 1978
2017-11-22 POINT (-76.98721999999999 38.83484) 0 days 0
2017-03-13 POINT (-77.01383 38.90669) 0 days 0
2018-02-09 POINT (-77.01383 38.90669) 333 days 1911
2018-02-13 POINT (-76.98929 38.92796) 207 days 1918
2017-07-21 POINT (-76.98929 38.92796) 0 days 0
2017-06-19 POINT (-76.98614999999999 38.90424) 0 days 0
2017-08-18 POINT (-76.98614999999999 38.90424) 60 days 1924
2017-08-31 POINT (-77.03052 38.94878) 0 days 0
2018-02-23 POINT (-77.03052 38.94878) 176 days 1914
2017-01-23 POINT (-77.01335999999999 38.90989) 0 days 0
2017-12-05 POINT (-77.01335999999999 38.90989) 316 days 1906
2017-09-05 POINT (-77.03089 38.95653) 0 days 0
2018-02-22 POINT (-77.03089 38.95653) 170 days 1920
... ... ... ...
2017-05-05 POINT (-76.99411616 38.82983549) 0 days 0
2017-09-08 POINT (-76.99411616 38.82983549) 126 days 1952
2018-02-22 POINT (-76.99364 38.95611) 202 days 1952
2017-08-04 POINT (-76.99364 38.95611) 0 days 0
2017-04-12 POINT (-77.02417 38.94857) 0 days 0
2018-01-03 POINT (-77.02417 38.94857) 266 days 1925
2017-06-01 POINT (-77.02438000000001 38.94649) 119 days 1922
2017-02-02 POINT (-77.02438000000001 38.94649) 0 days 0
2017-02-15 POINT (-77.02365999999999 38.9113) 0 days 0
2017-11-10 POINT (-77.02365999999999 38.9113) 268 days 1904
2017-04-28 POINT (-77.02504 38.95763) 0 days 0
2018-02-05 POINT (-77.02505073 38.95752571) 283 days 1922
2017-11-20 POINT (-76.93445 38.90178) 116 days 1913
2017-07-27 POINT (-76.93445 38.90178) 0 days 0
2017-03-16 POINT (-77.02638 38.92796) 0 days 0
2017-11-02 POINT (-77.02638 38.92796) 231 days 1900
2017-02-24 POINT (-77.02596 38.9488) 0 days 0
2017-12-22 POINT (-77.02596 38.9488) 301 days 1924
2017-07-14 POINT (-77.02623211 38.94974579) 0 days 0
2017-12-15 POINT (-77.02655 38.94999) 154 days 1923
2017-06-09 POINT (-77.02633 38.93786) 0 days 0
2017-12-29 POINT (-77.02633 38.93786) 203 days 1912
2017-07-18 POINT (-76.99404 38.90218) 0 days 0
2018-01-26 POINT (-76.99404 38.90218) 192 days 1910
2017-11-14 POINT (-76.9987546 38.94843214) 56 days 2017
2017-12-22 POINT (-76.9987546 38.94843214) 94 days 2017
2017-09-19 POINT (-76.9987546 38.94843214) 0 days 0
2017-09-20 POINT (-76.9987546 38.94843214) 1 days 2017
2017-09-21 POINT (-76.9987546 38.94843214) 2 days 2017
2017-09-29 POINT (-76.9987546 38.94843214) 10 days 2017
[266 rows x 52 columns]
df
| Ownership | FullStreetAddress | PostalCode | LotSizeArea | LivingArea | ListPrice | ClosePrice | Beds | ListDate | CloseDate | ... | DualAgency | Exterior | OwnerFirstName | OwnerLastName | OwnerOfficePhone | YearBuilt | _index | geometry | Time_Delta | temp | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CloseDate | |||||||||||||||||||||
| 2017-03-22 | Fee Simple | 111 50TH ST NE | 20019 | 2875 | 0 | 195000 | 200000 | 3 | 2/25/17 | 3/22/17 | ... | 1 | Brick | NaN | Fisher | NaN | 1934 | 2017-03-22 | POINT (-76.92975 38.89122) | 0 days | 0 |
| 2017-06-30 | Fee Simple | 111 50TH ST NE | Delta:0 | Delta:0 | Delta:0 | Delta:144000.0 | Delta:150652.77000000002 | Delta:0 | 5/10/17 | 6/30/17 | ... | Delta:0 | Brick | NaN | LLC | Delta:nan | Delta:0 | 2017-06-30 | POINT (-76.92981437 38.89124088) | 100 days | 1934 |
| 2018-02-16 | Fee Simple | 1118 HOLBROOK ST NE | Delta:0 | Delta:0 | Delta:1848 | Delta:364999.0 | Delta:339150.0 | Delta:1 | 1/11/18 | 2/16/18 | ... | Delta:0 | Brick | NaN | A&T Property Investm | Delta:nan | Delta:0 | 2018-02-16 | POINT (-76.98494000000001 38.90137) | 329 days | 1926 |
| 2017-03-24 | Fee Simple | 1118 HOLBROOK ST NE | 20002 | 1347 | 0 | 385000 | 406800 | 3 | 3/6/17 | 3/24/17 | ... | 1 | Brick and Siding | NaN | Clark | NaN | 1926 | 2017-03-24 | POINT (-76.98494000000001 38.90137) | 0 days | 0 |
| 2017-11-30 | Fee Simple | 1119 SOUTH CAROLINA AVE SE | Delta:0 | Delta:0 | Delta:0 | Delta:498500.0 | Delta:490100.0 | Delta:0 | 10/26/17 | 11/30/17 | ... | Delta:0 | Brick | Rainbow | Properties | Delta:nan | Delta:0 | 2017-11-30 | POINT (-76.99129121999999 38.88516061) | 282 days | 1905 |
| 2017-02-21 | Fee Simple | 1119 SOUTH CAROLINA AVE SE | 20003 | 1275 | 0 | 890000 | 910000 | 4 | 1/11/17 | 2/21/17 | ... | 0 | Brick, Combination | NaN | McClenon | NaN | 1905 | 2017-02-21 | POINT (-76.99129121999999 38.88516061) | 0 days | 0 |
| 2017-10-09 | Fee Simple | 1125 COLUMBIA RD NW | 20009 | 2787 | 3200 | 1.25e+06 | 1.146e+06 | 6 | 10/9/17 | 10/9/17 | ... | 1 | Brick | marguerite boudreau | Trust, Ed Sauer TTEE | NaN | 1912 | 2017-10-09 | POINT (-77.02840999999999 38.92795) | 0 days | 0 |
| 2017-10-09 | Fee Simple | 1125 COLUMBIA RD NW | 20009 | 2787 | 3200 | 1.25e+06 | 1.146e+06 | 6 | 10/9/17 | 10/9/17 | ... | 1 | Brick | marguerite boudreau | Trust, Ed Sauer TTEE | NaN | 1912 | 2017-10-09 | POINT (-77.02840999999999 38.92795) | 0 days | 0 |
| 2017-07-17 | Fee Simple | 113 34TH ST SE | 20019 | 1525 | 0 | 195000 | 160000 | 3 | 6/19/17 | 7/17/17 | ... | 0 | Siding - Vinyl | NaN | Hackley | NaN | 1989 | 2017-07-17 | POINT (-76.95780000000001 38.88836) | 0 days | 0 |
| 2017-09-18 | Fee Simple | 113 34TH ST SE | Delta:0 | Delta:0 | Delta:0 | Delta:104900.0 | Delta:149000.0 | Delta:0 | 8/17/17 | 9/18/17 | ... | Delta:0 | Siding - Vinyl | NaN | Mehmetoglu | Delta:nan | Delta:0 | 2017-09-18 | POINT (-76.95780000000001 38.88836) | 63 days | 1989 |
| 2017-05-16 | Fee Simple | 1204 QUINCY ST NW | 20011 | 1639 | 0 | 575000 | 520000 | 3 | 4/17/17 | 5/16/17 | ... | 1 | Brick | NaN | Could be you | NaN | 1923 | 2017-05-16 | POINT (-77.02752 38.93735) | 0 days | 0 |
| 2017-09-18 | Fee Simple | 1204 QUINCY ST NW | Delta:0 | Delta:0 | Delta:0 | Delta:324900.0 | Delta:397500.0 | Delta:1 | 8/24/17 | 9/18/17 | ... | Delta:0 | Brick | NaN | Could Be You | Delta:nan | Delta:0 | 2017-09-18 | POINT (-77.02752 38.93735) | 125 days | 1923 |
| 2017-09-01 | Fee Simple | 1205 42ND PL NE | Delta:0 | Delta:0 | Delta:0 | Delta:210000.0 | Delta:215100.0 | Delta:1 | 8/4/17 | 9/1/17 | ... | Delta:-1 | Siding - Vinyl | Sanjeewa | Wickramasekera | Delta:nan | Delta:0 | 2017-09-01 | POINT (-76.94171948 38.90592087) | 140 days | 1928 |
| 2017-04-14 | Fee Simple | 1205 42ND PL NE | 20019 | 4160 | 0 | 189900 | 189900 | 3 | 3/27/17 | 4/14/17 | ... | 1 | Brick and Siding | NaN | GAINES | NaN | 1928 | 2017-04-14 | POINT (-76.94158 38.9059) | 0 days | 0 |
| 2017-12-11 | Fee Simple | 121 56TH ST SE | Delta:0 | Delta:0 | Delta:0 | Delta:238700.0 | Delta:189565.0 | Delta:0 | 10/18/17 | 12/11/17 | ... | Delta:0 | Brick | NaN | Care of Broker | Delta:nan | Delta:0 | 2017-12-11 | POINT (-76.92140000000001 38.88701) | 185 days | 1951 |
| 2017-06-09 | Fee Simple | 121 56TH ST SE | 20019 | 2750 | 0 | 161200 | 210335 | 3 | 3/9/17 | 6/9/17 | ... | 1 | Brick | NaN | c/o broker | NaN | 1951 | 2017-06-09 | POINT (-76.92140000000001 38.88701) | 0 days | 0 |
| 2018-02-23 | Fee Simple | 1212 BARNABY TER SE | Delta:0 | Delta:0 | Delta:2037 | Delta:154900.0 | Delta:154900.0 | Delta:1 | 1/17/18 | 2/23/18 | ... | Delta:0 | Brick and Siding | NaN | DILAN | Delta:nan | Delta:0 | 2018-02-23 | POINT (-76.98721999999999 38.83484) | 93 days | 1978 |
| 2017-11-22 | Fee Simple | 1212 BARNABY TER SE | 20032 | 1414 | 0 | 195000 | 195000 | 3 | 10/20/17 | 11/22/17 | ... | 1 | Brick and Siding | NaN | PUBLIC RECORD | NaN | 1978 | 2017-11-22 | POINT (-76.98721999999999 38.83484) | 0 days | 0 |
| 2017-03-13 | Fee Simple | 1214 KIRBY ST NW | 20001 | 572 | 0 | 399000 | 399000 | 2 | 3/13/17 | 3/13/17 | ... | 1 | Brick | NaN | could be you | NaN | 1911 | 2017-03-13 | POINT (-77.01383 38.90669) | 0 days | 0 |
| 2018-02-09 | Fee Simple | 1214 KIRBY ST NW | Delta:0 | Delta:0 | Delta:0 | Delta:130500.0 | Delta:130500.0 | Delta:0 | 12/19/17 | 2/9/18 | ... | Delta:0 | Brick | NaN | Nantucket | Delta:nan | Delta:0 | 2018-02-09 | POINT (-77.01383 38.90669) | 333 days | 1911 |
| 2018-02-13 | Fee Simple | 1250 HAMLIN ST NE | Delta:0 | Delta:0 | Delta:-1930 | Delta:370000.0 | Delta:450000.0 | Delta:1 | 1/18/18 | 2/13/18 | ... | Delta:0 | Brick and Siding | NaN | Dilan Investments LL | Delta:nan | Delta:0 | 2018-02-13 | POINT (-76.98929 38.92796) | 207 days | 1918 |
| 2017-07-21 | Fee Simple | 1250 HAMLIN ST NE | 20017 | 5001 | 1930 | 530000 | 450000 | 3 | 6/24/17 | 7/21/17 | ... | 1 | Brick and Siding | NaN | Scott | NaN | 1918 | 2017-07-21 | POINT (-76.98929 38.92796) | 0 days | 0 |
| 2017-06-19 | Fee Simple | 1283 OATES ST NE | 20002 | 2513 | 0 | 425000 | 399900 | 3 | 1/24/17 | 6/19/17 | ... | 1 | Brick | NaN | Owner of Record | NaN | 1924 | 2017-06-19 | POINT (-76.98614999999999 38.90424) | 0 days | 0 |
| 2017-08-18 | Fee Simple | 1283 OATES ST NE | Delta:0 | Delta:0 | Delta:1821 | Delta:115000.0 | Delta:140100.0 | Delta:1 | 7/22/17 | 8/18/17 | ... | Delta:-1 | Brick | NaN | OWNER | Delta:nan | Delta:0 | 2017-08-18 | POINT (-76.98614999999999 38.90424) | 60 days | 1924 |
| 2017-08-31 | Fee Simple | 1308 DELAFIELD PL NW | 20011 | 1789 | 0 | 480000 | 460000 | 3 | 8/2/17 | 8/31/17 | ... | 1 | Brick | NaN | Estate of Fitch | NaN | 1914 | 2017-08-31 | POINT (-77.03052 38.94878) | 0 days | 0 |
| 2018-02-23 | Fee Simple | 1308 DELAFIELD PL NW | Delta:0 | Delta:0 | Delta:0 | Delta:344999.9 | Delta:360000.0 | Delta:1 | 1/10/18 | 2/23/18 | ... | Delta:0 | Brick | 1308 Delafield | Pl. NW, LLC | Delta:nan | Delta:0 | 2018-02-23 | POINT (-77.03052 38.94878) | 176 days | 1914 |
| 2017-01-23 | Fee Simple | 131 P ST NW | 20001 | 1598 | 0 | 736000 | 720000 | 4 | 1/5/17 | 1/23/17 | ... | 1 | Brick | NaN | JOHNSON | NaN | 1906 | 2017-01-23 | POINT (-77.01335999999999 38.90989) | 0 days | 0 |
| 2017-12-05 | Fee Simple | 131 P ST NW | Delta:0 | Delta:0 | Delta:2307 | Delta:414000.0 | Delta:402500.0 | Delta:0 | 7/28/17 | 12/5/17 | ... | Delta:0 | Brick | NaN | 5Design | Delta:nan | Delta:0 | 2017-12-05 | POINT (-77.01335999999999 38.90989) | 316 days | 1906 |
| 2017-09-05 | Fee Simple | 1317 KENNEDY ST NW | 20011 | 2765 | 0 | 450000 | 450000 | 4 | 8/3/17 | 9/5/17 | ... | 1 | Brick | NaN | Owner | NaN | 1920 | 2017-09-05 | POINT (-77.03089 38.95653) | 0 days | 0 |
| 2018-02-22 | Fee Simple | 1317 KENNEDY ST NW | Delta:0 | Delta:0 | Delta:2620 | Delta:399900.0 | Delta:431000.0 | Delta:0 | 1/17/18 | 2/22/18 | ... | Delta:0 | Brick, Hardiplank, Brick Front | NaN | 1317 Kennedy St NW | Delta:nan | Delta:0 | 2018-02-22 | POINT (-77.03089 38.95653) | 170 days | 1920 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2017-05-05 | Fee Simple | 791 BARNABY ST SE | 20032 | 2475 | 0 | 160700 | 175000 | 3 | 3/11/17 | 5/5/17 | ... | 0 | Brick | C/O | AGENT | NaN | 1952 | 2017-05-05 | POINT (-76.99411616 38.82983549) | 0 days | 0 |
| 2017-09-08 | Fee Simple | 791 BARNABY ST SE | Delta:0 | Delta:0 | Delta:0 | Delta:189290.0 | Delta:174990.0 | Delta:0 | 8/10/17 | 9/8/17 | ... | Delta:1 | Brick and Siding | NaN | Stars home LLC | Delta:nan | Delta:0 | 2017-09-08 | POINT (-76.99411616 38.82983549) | 126 days | 1952 |
| 2018-02-22 | Fee Simple | 807 JEFFERSON ST NE | Delta:0 | Delta:0 | Delta:0 | Delta:260000.0 | Delta:259000.0 | Delta:1 | 1/11/18 | 2/22/18 | ... | Delta:0 | Brick | NaN | c/o Agent | Delta:nan | Delta:0 | 2018-02-22 | POINT (-76.99364 38.95611) | 202 days | 1952 |
| 2017-08-04 | Fee Simple | 807 JEFFERSON ST NE | 20011 | 2794 | 0 | 299000 | 300000 | 3 | 7/13/17 | 8/4/17 | ... | 1 | Brick and Siding | NaN | See tax record | NaN | 1952 | 2017-08-04 | POINT (-76.99364 38.95611) | 0 days | 0 |
| 2017-04-12 | Fee Simple | 811 DECATUR ST NW | 20011 | 1620 | 1424 | 439000 | 465000 | 3 | 3/10/17 | 4/12/17 | ... | 1 | Brick | NaN | SEE TAX RECORD | NaN | 1925 | 2017-04-12 | POINT (-77.02417 38.94857) | 0 days | 0 |
| 2018-01-03 | Fee Simple | 811 DECATUR ST NW | Delta:0 | Delta:0 | Delta:-1424 | Delta:360950.0 | Delta:324000.0 | Delta:1 | 12/7/17 | 1/3/18 | ... | Delta:0 | Brick | NaN | YOU! | Delta:nan | Delta:0 | 2018-01-03 | POINT (-77.02417 38.94857) | 266 days | 1925 |
| 2017-06-01 | Fee Simple | 813 BUCHANAN ST NW | Delta:0 | Delta:0 | Delta:0 | Delta:418750.0 | Delta:479850.0 | Delta:1 | 4/27/17 | 6/1/17 | ... | Delta:1 | Brick Front, Brick | NaN | Dilan Investments | Delta:nan | Delta:0 | 2017-06-01 | POINT (-77.02438000000001 38.94649) | 119 days | 1922 |
| 2017-02-02 | Fee Simple | 813 BUCHANAN ST NW | 20011 | 2850 | 0 | 381150 | 381150 | 3 | 2/2/17 | 2/2/17 | ... | 0 | Brick Front | NaN | Walton | NaN | 1922 | 2017-02-02 | POINT (-77.02438000000001 38.94649) | 0 days | 0 |
| 2017-02-15 | Fee Simple | 817 Q ST NW | 20001 | 1029 | 2199 | 800000 | 935000 | 4 | 1/26/17 | 2/15/17 | ... | 0 | Brick, Stone | Estate of Raymond | J. Milefsky | NaN | 1904 | 2017-02-15 | POINT (-77.02365999999999 38.9113) | 0 days | 0 |
| 2017-11-10 | Fee Simple | 817 Q ST NW | Delta:0 | Delta:0 | Delta:0 | Delta:639000.0 | Delta:515000.0 | Delta:-1 | 10/11/17 | 11/10/17 | ... | Delta:1 | Brick | NaN | OWNER | Delta:nan | Delta:-4 | 2017-11-10 | POINT (-77.02365999999999 38.9113) | 268 days | 1904 |
| 2017-04-28 | Fee Simple | 825 LONGFELLOW ST NW | 20011 | 1742 | 1528 | 495000 | 475000 | 3 | 4/5/17 | 4/28/17 | ... | 1 | Brick | NaN | Brown | NaN | 1922 | 2017-04-28 | POINT (-77.02504 38.95763) | 0 days | 0 |
| 2018-02-05 | Fee Simple | 825 LONGFELLOW ST NW | Delta:0 | Delta:40 | Delta:368 | Delta:254000.0 | Delta:270000.0 | Delta:0 | 10/12/17 | 2/5/18 | ... | Delta:0 | Brick and Siding | Posin | Investments LLC | Delta:nan | Delta:0 | 2018-02-05 | POINT (-77.02505073 38.95752571) | 283 days | 1922 |
| 2017-11-20 | Fee Simple | 905 47TH PL NE | Delta:0 | Delta:0 | Delta:1100 | Delta:185000.0 | Delta:189700.0 | Delta:1 | 10/12/17 | 11/20/17 | ... | Delta:0 | Brick | NaN | Michaelman | Delta:nan | Delta:0 | 2017-11-20 | POINT (-76.93445 38.90178) | 116 days | 1913 |
| 2017-07-27 | Fee Simple | 905 47TH PL NE | 20019 | 2247 | 0 | 209900 | 210200 | 2 | 5/29/17 | 7/27/17 | ... | 1 | Brick | Owner of | Record | NaN | 1913 | 2017-07-27 | POINT (-76.93445 38.90178) | 0 days | 0 |
| 2017-03-16 | Fee Simple | 909 COLUMBIA RD NW | 20001 | 696 | 1253 | 375000 | 416000 | 2 | 2/8/17 | 3/16/17 | ... | 0 | Log, Siding - Aluminum / Steel | Angela | Copeland | NaN | 1900 | 2017-03-16 | POINT (-77.02638 38.92796) | 0 days | 0 |
| 2017-11-02 | Fee Simple | 909 COLUMBIA RD NW | Delta:0 | Delta:0 | Delta:-1253 | Delta:314900.0 | Delta:294000.0 | Delta:0 | 9/22/17 | 11/2/17 | ... | Delta:0 | Brick | NaN | Owner | Delta:nan | Delta:0 | 2017-11-02 | POINT (-77.02638 38.92796) | 231 days | 1900 |
| 2017-02-24 | Fee Simple | 912 DELAFIELD PL NW | 20011 | 1620 | 0 | 430000 | 430000 | 3 | 2/7/17 | 2/24/17 | ... | 1 | Siding - Vinyl | NaN | See Showing Time | NaN | 1924 | 2017-02-24 | POINT (-77.02596 38.9488) | 0 days | 0 |
| 2017-12-22 | Fee Simple | 912 DELAFIELD PL NW | Delta:0 | Delta:0 | Delta:0 | Delta:219999.0 | Delta:210000.0 | Delta:1 | 9/28/17 | 12/22/17 | ... | Delta:0 | Brick Front | NaN | Seiden | Delta:nan | Delta:0 | 2017-12-22 | POINT (-77.02596 38.9488) | 301 days | 1924 |
| 2017-07-14 | Fee Simple | 921 EMERSON ST NW | 20011 | 1788 | 2460 | 449900 | 450000 | 4 | 6/13/17 | 7/14/17 | ... | 1 | Brick and Siding | NaN | Cobey | NaN | 1923 | 2017-07-14 | POINT (-77.02623211 38.94974579) | 0 days | 0 |
| 2017-12-15 | Fee Simple | 921 EMERSON ST NW | Delta:0 | Delta:0 | Delta:0 | Delta:319100.0 | Delta:315000.0 | Delta:0 | 11/7/17 | 12/15/17 | ... | Delta:0 | Brick and Siding, Brick Front | NaN | Owner Of Records | Delta:nan | Delta:0 | 2017-12-15 | POINT (-77.02655 38.94999) | 154 days | 1923 |
| 2017-06-09 | Fee Simple | 929 QUINCY ST NW | 20011 | 1800 | 0 | 575000 | 560000 | 3 | 5/6/17 | 6/9/17 | ... | 1 | Brick | Janie N. | Hester | NaN | 1912 | 2017-06-09 | POINT (-77.02633 38.93786) | 0 days | 0 |
| 2017-12-29 | Fee Simple | 929 QUINCY ST NW | Delta:0 | Delta:0 | Delta:2138 | Delta:424000.0 | Delta:440000.0 | Delta:1 | 12/1/17 | 12/29/17 | ... | Delta:0 | Brick and Siding, Hardiplank | NaN | C/O AGENT | Delta:nan | Delta:0 | 2017-12-29 | POINT (-77.02633 38.93786) | 203 days | 1912 |
| 2017-07-18 | Fee Simple | 930 9TH ST NE | 20002 | 1000 | 0 | 549950 | 435000 | 2 | 4/27/17 | 7/18/17 | ... | 1 | Brick | NaN | Owner | NaN | 1910 | 2017-07-18 | POINT (-76.99404 38.90218) | 0 days | 0 |
| 2018-01-26 | Fee Simple | 930 9TH ST NE | Delta:0 | Delta:0 | Delta:0 | Delta:209950.0 | Delta:324900.0 | Delta:1 | 12/21/17 | 1/26/18 | ... | Delta:-1 | Brick | NaN | Cameron | Delta:nan | Delta:0 | 2018-01-26 | POINT (-76.99404 38.90218) | 192 days | 1910 |
| 2017-11-14 | Fee Simple | TOTTEN MEWS NE | Delta:0 | Delta:0 | Delta:0 | Delta:-53868.0 | Delta:-52226.0 | Delta:0 | 7/25/17 | 11/14/17 | ... | Delta:0 | Brick, Hardiplank | Comstock | Homes | Delta:nan | Delta:0 | 2017-11-14 | POINT (-76.9987546 38.94843214) | 56 days | 2017 |
| 2017-12-22 | Fee Simple | TOTTEN MEWS NE | Delta:0 | Delta:0 | Delta:152 | Delta:-16256.0 | Delta:-15216.0 | Delta:0 | 10/15/17 | 12/22/17 | ... | Delta:0 | Brick, Hardiplank | Comstock | Homes | Delta:nan | Delta:0 | 2017-12-22 | POINT (-76.9987546 38.94843214) | 94 days | 2017 |
| 2017-09-19 | Fee Simple | TOTTEN MEWS NE | 20017 | 1800 | 1998 | 646256 | 640216 | 3 | 1/27/17 | 9/19/17 | ... | 0 | Brick, Hardiplank | Comstock | Homes | NaN | 2017 | 2017-09-19 | POINT (-76.9987546 38.94843214) | 0 days | 0 |
| 2017-09-20 | Fee Simple | TOTTEN MEWS NE | Delta:0 | Delta:0 | Delta:0 | Delta:-24796.0 | Delta:-40811.0 | Delta:0 | 2/28/17 | 9/20/17 | ... | Delta:0 | Brick, Hardiplank | Comstock | Homes | Delta:nan | Delta:0 | 2017-09-20 | POINT (-76.9987546 38.94843214) | 1 days | 2017 |
| 2017-09-21 | Fee Simple | TOTTEN MEWS NE | Delta:0 | Delta:0 | Delta:0 | Delta:-26256.0 | Delta:-20216.0 | Delta:0 | 7/11/17 | 9/21/17 | ... | Delta:0 | Brick, Hardiplank | Comstock | Homes | Delta:nan | Delta:0 | 2017-09-21 | POINT (-76.9987546 38.94843214) | 2 days | 2017 |
| 2017-09-29 | Fee Simple | TOTTEN MEWS NE | Delta:0 | Delta:0 | Delta:0 | Delta:-71256.0 | Delta:-65216.0 | Delta:0 | 9/15/17 | 9/29/17 | ... | Delta:0 | Brick, Hardiplank | Comstock | Homes | Delta:nan | Delta:0 | 2017-09-29 | POINT (-76.9987546 38.94843214) | 10 days | 2017 |
266 rows × 52 columns