Taxi Trips

City of San Francisco

@usgov.city_of_san_francisco_taxi_trips_8c270

Table List

1 table(153.81 MB)

Table 1

@usgov.city_of_san_francisco_taxi_trips_8c270.table_1

153.81 MB
4129083 rows
28 columns

vehicle_placard_number Vehicle Placard Number	driver_id Driver Id	start_time_local Start Time Local	end_time_local End Time Local	pickup_location_latitude Pickup Location Latitude	pickup_location_longitude Pickup Location Longitude	pickup_location Pickup Location	dropoff_location_latitude Dropoff Location Latitude	dropoff_location_longitude Dropoff Location Longitude	dropoff_location Dropoff Location	hail_type Hail Type	sfo_pickup Sfo Pickup	qa_flags Qa Flags	fare_type Fare Type	meter_fare_amount Meter Fare Amount	sf_exit_fee Sf Exit Fee	other_fees Other Fees	tip Tip	extra_amount Extra Amount	total_fare_amount Total Fare Amount	fare_time_milliseconds Fare Time Milliseconds	trip_distance_meters Trip Distance Meters	data_as_of Data As Of	data_loaded_at Data Loaded At
1478	A-9413	2022/12/24 12:12:25 AM	2022/12/24 12:53:45 AM	37.617	-122.386	POINT (-122.386 37.617)	37.935	-122.518	POINT (-122.518 37.935)	street	1		meter_fare	97.1		5.5			102.6	2081284	44257	2025/04/04 10:37:03 AM	2025/04/07 04:16:16 PM
448	-	2023/01/23 06:37:21 AM	2023/01/23 06:49:34 AM	37.794	-122.396	POINT (-122.396 37.794)	37.776	-122.394	POINT (-122.394 37.776)	street		LP-OI-	meter_fare	13.25					13.25	733248	2735.8848	2025/04/04 10:36:57 AM	2025/04/07 04:16:16 PM
140	F-6768	2023/10/21 08:13:59 PM	2023/10/21 08:19:49 PM	37.614	-122.385	POINT (-122.385 37.614)	37.602	-122.37	POINT (-122.37 37.602)	street	1		meter_fare	13.25	5.5				18.75	349867	4506.2	2025/04/04 10:37:06 AM	2025/04/07 04:16:16 PM
231	B-7010	2022/12/24 12:12:41 AM	2022/12/24 12:31:49 AM	37.615	-122.385	POINT (-122.385 37.615)	37.786	-122.41	POINT (-122.41 37.786)	street	1	LP-	meter_fare	49.65				5.5	55.15	983000	22445.549	2025/04/04 10:37:03 AM	2025/04/07 04:16:16 PM
448	-	2023/01/23 06:37:21 AM	2023/01/23 06:49:34 AM	37.794	-122.396	POINT (-122.396 37.794)	37.776	-122.394	POINT (-122.394 37.776)	street		LP-OI-DR-	meter_fare	13.25					13.25	733248	2735.8848	2025/04/04 10:36:57 AM	2025/04/07 04:16:16 PM
803	F-8277	2023/10/21 08:14:11 PM	2023/10/21 08:40:02 PM	37.615	-122.39	POINT (-122.39 37.615)	37.796	-122.404	POINT (-122.404 37.796)	street	1	IT-	meter_fare	55.5				5.5	61	1043000	23555.76	2025/04/04 10:37:06 AM	2025/04/07 04:16:16 PM
1491	D-0091	2022/12/24 12:12:45 AM	2022/12/24 12:33:57 AM	37.615	-122.385	POINT (-122.385 37.615)	37.788	-122.41	POINT (-122.41 37.788)	street	1	TF-	meter_fare	53.55					53.55	993000	23684.48	2025/04/04 10:37:03 AM	2025/04/07 04:16:16 PM
66	B-4597	2023/01/23 06:37:33 AM	2023/01/23 06:55:00 AM	37.775	-122.428	POINT (-122.428 37.775)	37.789	-122.423	POINT (-122.423 37.789)	flywheel_app			meter_fare	16.31		1.25	5		22.56	245000	2896.2	2025/04/04 10:36:57 AM	2025/04/07 04:16:16 PM
1350	D-4546	2023/10/21 08:14:16 PM	2023/10/21 08:20:51 PM	37.75	-122.433	POINT (-122.433 37.75)	37.751	-122.434	POINT (-122.434 37.751)	dispatch		LP-IT-	meter_fare	8.7					8.7	394599	1287.5	2025/04/04 10:37:06 AM	2025/04/07 04:16:16 PM
398	D-6632	2022/12/24 12:12:58 AM	2022/12/24 12:31:49 AM	37.614	-122.385	POINT (-122.385 37.614)	37.782	-122.393	POINT (-122.393 37.782)	street	1	LP-IT-	meter_fare	50.3	5.5				55.8	1130976	21887.1	2025/04/04 10:37:03 AM	2025/04/07 04:16:16 PM


CREATE TABLE table_1 (
  "vehicle_placard_number" VARCHAR,
  "driver_id" VARCHAR,
  "start_time_local" VARCHAR,
  "end_time_local" VARCHAR,
  "pickup_location_latitude" DOUBLE,
  "pickup_location_longitude" DOUBLE,
  "pickup_location" VARCHAR,
  "dropoff_location_latitude" DOUBLE,
  "dropoff_location_longitude" DOUBLE,
  "dropoff_location" VARCHAR,
  "hail_type" VARCHAR,
  "paratransit" DOUBLE,
  "sfo_pickup" BIGINT,
  "qa_flags" VARCHAR,
  "fare_type" VARCHAR,
  "meter_fare_amount" DOUBLE,
  "upfront_pricing" DOUBLE,
  "promo_rate" DOUBLE,
  "tolls" DOUBLE,
  "sf_exit_fee" DOUBLE,
  "other_fees" DOUBLE,
  "tip" DOUBLE,
  "extra_amount" DOUBLE,
  "total_fare_amount" DOUBLE,
  "fare_time_milliseconds" BIGINT,
  "trip_distance_meters" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);