Friday, September 19, 2014

New York City Comptroller Data (compstat, claimstat, or missingstat?)

The New York City Comptroller in 2014 announced ClaimStat with great shouts.

Here we take the data from the comptroller's page and run some statistical analysis.

We also ask the question, "where is the property damage claims data?"

For claims data, see police damage claim data and tree damage claim data 


How long to you believe on average does it take for our New York City Comptroller to settle a police related claim?  

It turns out that on average it takes 319 days.

The average settlement is for $16K

See the statistics below:

See 

POLICE:
min_date_settled1/15/2013 0:00:00
max_date_settled6/27/2014 0:00:00
min_days13
max_days525
avg_days319
min_claim_amount250
max_claim_amount125000
avg_claim_amount16294
count341
total_claim_amount5556500

See https://bigquery.cloud.google.com/table/personal-real-estate:nyc.claims_flat to access the claims data in a SQL database

Access to the statistics sheet: