Name: 2016 Parties In New York
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

2016 Parties In New York

Context

This dataset contains all noise complaints calls that were received by the city police with complaint type "Loud music/Party" in 2016. The data contains the time of the call, time of the police response, coordinates, and part of the city.

This data should help match taxi rides from "New York City Taxi Trip Duration" competition to the night rides of partygoers.

Content

The New York city hotline receives non-urgent community concerns, which are made public by the city through NYC Open Data portal. The full dataset contains a variety of complaints ranging from illegal parking to customer complaints. This dataset focuses on Noise complaints that were collected in 2016 and indicate ongoing party in a given neighborhood.

Acknowledgements

https://opendata.cityofnewyork.us/ - NYC Open Data portal contains many other interesting datasets
Photo by Yvette de Wit on Unsplash

Inspiration

After a fun night out in the city majority of people are too exhausted to travel by public transport, so they catch a cab to their home. I hope this data will help the community to find the patterns in the data that will lead to better solutions.

Tables

Bar Locations

@kaggle.somesnm_partynyc.bar_locations

59.19 KB
2440 rows
7 columns


CREATE TABLE bar_locations (
  "location_type" VARCHAR,
  "incident_zip" DOUBLE,
  "city" VARCHAR,
  "borough" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "num_calls" BIGINT
);

Party In Nyc

@kaggle.somesnm_partynyc.party_in_nyc

5.95 MB
225414 rows
8 columns


CREATE TABLE party_in_nyc (
  "created_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "location_type" VARCHAR,
  "incident_zip" DOUBLE,
  "city" VARCHAR,
  "borough" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Test Parties

@kaggle.somesnm_partynyc.test_parties

4.43 MB
625134 rows
2 columns


CREATE TABLE test_parties (
  "id" VARCHAR,
  "num_complaints" BIGINT
);

Train Parties

@kaggle.somesnm_partynyc.train_parties

10.18 MB
1458644 rows
2 columns


CREATE TABLE train_parties (
  "id" VARCHAR,
  "num_complaints" BIGINT
);