Traffic Volume Counts

City of New York

@usgov.city_of_new_york_traffic_volume_counts

Table List

1 table(1.62 MB)

Table 1

@usgov.city_of_new_york_traffic_volume_counts.table_1

1.62 MB
42756 rows
31 columns

id ID	segmentid SegmentID	roadway_name Roadway Name	from From	to To	direction Direction	date Date	n_12_00_1_00_am 12:00-1:00 AM	n_1_00_2_00am 1:00-2:00AM	n_2_00_3_00am 2:00-3:00AM	n_3_00_4_00am 3:00-4:00AM	n_4_00_5_00am 4:00-5:00AM	n_5_00_6_00am 5:00-6:00AM	n_6_00_7_00am 6:00-7:00AM	n_7_00_8_00am 7:00-8:00AM	n_8_00_9_00am 8:00-9:00AM	n_9_00_10_00am 9:00-10:00AM	n_10_00_11_00am 10:00-11:00AM	n_11_00_12_00pm 11:00-12:00PM	n_12_00_1_00pm 12:00-1:00PM	n_1_00_2_00pm 1:00-2:00PM	n_2_00_3_00pm 2:00-3:00PM	n_3_00_4_00pm 3:00-4:00PM	n_4_00_5_00pm 4:00-5:00PM	n_5_00_6_00pm 5:00-6:00PM	n_6_00_7_00pm 6:00-7:00PM	n_7_00_8_00pm 7:00-8:00PM	n_8_00_9_00pm 8:00-9:00PM	n_9_00_10_00pm 9:00-10:00PM	n_10_00_11_00pm 10:00-11:00PM	n_11_00_12_00am 11:00-12:00AM
1	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	NB	Mon Jan 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	20	10	11	14	13	20	34	66	100	52	68	85	85	94	104	105	147	120	91	83	74	49	42	42
2	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	NB	Tue Jan 10 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	21	16	8	6	13	13	31	70	67	45	57	67	73	95	102	98	133	131	95	73	70	63	42	35
3	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	NB	Wed Jan 11 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	27	14	6	5	12	16	34	75	69	71	67	70	90	89	115	115	130	143	106	89	68	64	56	43
4	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	NB	Thu Jan 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	22	7	7	8	11	12	33	75	89	66	70	60	105	103	71	127	122	144	122	76	64	58	64	43
5	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	NB	Fri Jan 13 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	31	17	7	5	13	28	29	68	84	64	83	89	88	113	113	126	133	135	102	106	58	58	55	54
6	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	NB	Sat Jan 14 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	42	27	21	18	21	13	17	18	46	53	29
7	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	SB	Mon Jan 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	27	12	12	4	22	27	66	154	155	138	105	124	140	120	165	197	152	174	128	95	87	73	57	42
8	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	SB	Tue Jan 10 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	26	16	11	13	16	27	59	156	177	131	107	108	122	131	192	180	161	171	120	96	90	70	63	49
9	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	SB	Wed Jan 11 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	32	16	8	9	15	26	63	169	178	148	139	131	126	137	178	194	168	160	143	114	78	64	49	45
10	15540	BEACH STREET	UNION PLACE	VAN DUZER STREET	SB	Thu Jan 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	24	12	7	18	11	23	61	146	177	128	117	111	134	134	171	184	157	167	148	112	86	77	63	51


CREATE TABLE table_1 (
  "id" BIGINT,
  "segmentid" BIGINT,
  "roadway_name" VARCHAR,
  "from" VARCHAR,
  "to" VARCHAR,
  "direction" VARCHAR,
  "date" TIMESTAMP,
  "n_12_00_1_00_am" DOUBLE,
  "n_1_00_2_00am" DOUBLE,
  "n_2_00_3_00am" DOUBLE,
  "n_3_00_4_00am" DOUBLE,
  "n_4_00_5_00am" DOUBLE,
  "n_5_00_6_00am" DOUBLE,
  "n_6_00_7_00am" DOUBLE,
  "n_7_00_8_00am" DOUBLE,
  "n_8_00_9_00am" DOUBLE,
  "n_9_00_10_00am" DOUBLE,
  "n_10_00_11_00am" DOUBLE,
  "n_11_00_12_00pm" DOUBLE,
  "n_12_00_1_00pm" DOUBLE,
  "n_1_00_2_00pm" DOUBLE,
  "n_2_00_3_00pm" DOUBLE,
  "n_3_00_4_00pm" DOUBLE,
  "n_4_00_5_00pm" DOUBLE,
  "n_5_00_6_00pm" DOUBLE,
  "n_6_00_7_00pm" DOUBLE,
  "n_7_00_8_00pm" DOUBLE,
  "n_8_00_9_00pm" DOUBLE,
  "n_9_00_10_00pm" DOUBLE,
  "n_10_00_11_00pm" DOUBLE,
  "n_11_00_12_00am" DOUBLE
);