Excel Sample Sheet 32403 | Attachment B District Of Columbia Carsharing Data Formats (2020)

Partial file snippet.

Sheet 1: Cover Sheet

	
	
		Attachment B

District of Columbia
Carsharing Data Formats
	



Sheet 2: Data Formats

	
	
	
	
	
	
	
	
	
	
		Count
		Data Category
		Data Type
		Field Names
		Entry Type
		Field Description
		Example
		Delivery Format Requirement
		Delivery Frequency
	
	
		1
		Fleet Data
		Identification
		provider_name
		string
		Public-facing name of the Carsharing Company
		DeLorean_Carsharing_Company
		CSV File
		Every calendar month within the first ten calendar days
	
	
		2
		Fleet Data
		Identification
		vehicle_id
		string
		Unique vehicle identification number (VIN) assigned by Manufacturer 
		SCEDT26TXCD010001
		CSV File
		Every calendar month within the first ten calendar days
	
	
		3
		Fleet Data
		Identification
		vehicle_plate
		string
		Vehicle license plate
		R12345
		CSV File
		Every calendar month within the first ten calendar days
	
	
		4
		Fleet Data
		Identification
		vehicle_sticker_dc
		string
		Number of current Carsharing Vehicle Sticker
		19-20-10000
		CSV File
		Every calendar month within the first ten calendar days
	
	
		5
		Fleet Data
		Vehicle
		vehicle_make
		string
		Vehicle make
		DeLorean_Motor_Company
		CSV File
		Every calendar month within the first ten calendar days
	
	
		6
		Fleet Data
		Vehicle
		vehicle_model
		string
		Vehicle model
		DeLorean
		CSV File
		Every calendar month within the first ten calendar days
	
	
		7
		Fleet Data
		Vehicle
		vehicle_year
		integer
		Vehicle model year
		1982
		CSV File
		Every calendar month within the first ten calendar days
	
	
		8
		Fleet Data
		Vehicle
		emissions_tier_epa
		string
		The vehicle's EPA emission rating per the EPA’s light-duty vehicle emission standards. This field can read either tier_0, tier_1, tier_2, or tier_3.
		tier_0
		CSV File
		Every calendar month within the first ten calendar days
	
	
		9
		Fleet Data
		Vehicle
		propulsion_type
		string
		The vehicles propulsion type. This field can read all-electric, plug-in_hybrid, traditional_hybrid, internal_combustion, or other. 
		internal_combustion
		CSV File
		Every calendar month within the first ten calendar days
	
	
		10
		Fleet Data
		Maintenance
		maintenance
		integer
		The number of instances that the vehicle was removed from service for maintenance in the past month
		3
		CSV File
		Every calendar month within the first ten calendar days
	
	
		11
		Fleet Data
		Date
		num_days_available
		integer
		The number of days the vehicle was in the Public Right-of-Way and available for revenue generating trips by a customer of the Carsharing Company
		23
		CSV File
		Every calendar month within the first ten calendar days
	
	
		12
		Fleet Data
		Date
		num_days_in_service
		integer
		The number of days the vehicle was in the Public Right-of-Way in the past month
		25
		CSV File
		Every calendar month within the first ten calendar days
	
	
		13
		Fleet Data
		Date
		num_days_not_in_service
		integer
		The number of days the vehicle was not in the Public Right-of-Way in the past month
		5
		CSV File
		Every calendar month within the first ten calendar days
	
	
		14
		Trip
		Location
		start_lat
		float
		The starting latitude of the trip
		38.897095
		CSV File
		Every calendar month within the first ten calendar days
	
	
		15
		Trip
		Location
		start_lon
		float
		The starting longitude of the trip
		-77.006332
		CSV File
		Every calendar month within the first ten calendar days
	
	
		16
		Trip
		Location
		end_lat
		float
		The ending latitude of the trip
		38.897095
		CSV File
		Every calendar month within the first ten calendar days
	
	
		17
		Trip
		Location
		end_lon
		float
		The ending longitude of the trip
		-77.006332
		CSV File
		Every calendar month within the first ten calendar days
	
	
		18
		Trip
		Date
		trip_start_time
		datetime
		Trip start time and date
		2019-08-01T14:30:53Z
		CSV File
		Every calendar month within the first ten calendar days
	
	
		19
		Trip
		Date
		trip_end_time
		datetime
		Trip end time and date
		2019-08-01T16:30:53Z
		CSV File
		Every calendar month within the first ten calendar days
	
	
		20
		Trip
		Trip
		trip_type
		string
		Type of trip. This field can read member, service, rebalancing, for-hire, or other.
		service
		CSV File
		Every calendar month within the first ten calendar days
	
	
		21
		Trip
		Distance
		trip_distance
		integer
		Trip distance in meters
		6000.15
		CSV File
		Every calendar month within the first ten calendar days
	
	
		22
		Trip
		Location
		ward_start
		string
		The Ward the trip starts in. If the vehicle is not in the District, this should read other.
		ward_4
		CSV File
		Every calendar month within the first ten calendar days
	
	
		23
		Trip
		Location
		ward_end
		string
		The Ward the trip ends in. If the vehicle is not in the District, this should read other.
		ward_7
		CSV File
		Every calendar month within the first ten calendar days
	
	
		24
		Parking
		Parking
		parking_zone
		string
		Parking zone information. This field can read dc_non-premium_meter_active, dc_non-premium_meter_inactive, dc_premium_meter_active, dc_premium_meter_inactive, dc_active_rpp, dc_inactive_rpp, dc_non-regulated, or non-dc_parking
		dc_non-premium_meter_active
		CSV File
		Every calendar month within the first ten calendar days
	
	
		25
		Parking
		Parking
		zone_rate
		float
		Parking zone rate. This is the hourly cost of the parking zone. 
		2.3
		CSV File
		Every calendar month within the first ten calendar days
	
	
		26
		Parking
		Date
		parking_start_time
		datetime
		Date and time of the start of the parking event
		2019-08-01T14:30:53Z
		CSV File
		Every calendar month within the first ten calendar days
	
	
		27
		Parking
		Date
		parking_end_time
		datetime
		Date and time of the end of the parking event
		2019-08-01T16:30:53Z
		CSV File
		Every calendar month within the first ten calendar days
	
	
		28
		Parking
		Location
		parking_latitude
		float
		The latitude of parking event
		38.897095
		CSV File
		Every calendar month within the first ten calendar days
	
	
		29
		Parking
		Location
		parking_longitude
		float
		The longitude of parking event
		-77.006332
		CSV File
		Every calendar month within the first ten calendar days
	
	
		30
		Parking
		Location
		parking_ward
		string
		The Ward the vehicle is parked in during parking event. If the vehicle is not in the District, this should read other. 
		ward_8
		CSV File
		Every calendar month within the first ten calendar days
	
	
		31
		Parking
		Date
		parking_minutes
		integer
		Total minutes parked
		120
		CSV File
		Every calendar month within the first ten calendar days
	
	
		32
		Membership
		Membership
		membership_total_dc
		integer
		Report month’s total number of members based in Washington, DC
		10000
		CSV File
		Every calendar month within the first ten calendar days
	
	
		33
		Membership
		Membership
		membership_total_dmv
		integer
		Report month’s total number of members based in the Washington Metropolitan Area
		20000
		CSV File
		Every calendar month within the first ten calendar days
	
	
		34
		Membership
		Membership
		membership_total_ward_1
		integer
		Report month’s total number of members based in Ward 1
		1250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		35
		Membership
		Membership
		membership_total_ward_2
		integer
		Report month’s total number of members based in Ward 2
		1250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		36
		Membership
		Membership
		membership_total_ward_3
		integer
		Report month’s total number of members based in Ward 3
		1250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		37
		Membership
		Membership
		membership_total_ward_4
		integer
		Report month’s total number of members based in Ward 4
		1250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		38
		Membership
		Membership
		membership_total_ward_5
		integer
		Report month’s total number of members based in Ward 5
		1250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		39
		Membership
		Membership
		membership_total_ward_6
		integer
		Report month’s total number of members based in Ward 6
		1250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		40
		Membership
		Membership
		membership_total_ward_7
		integer
		Report month’s total number of members based in Ward 7
		1250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		41
		Membership
		Membership
		membership_total_ward_8
		integer
		Report month’s total number of members based in Ward 8
		1250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		42
		Membership
		Membership
		membership_active_dc
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Washington, DC
		2000
		CSV File
		Every calendar month within the first ten calendar days
	
	
		43
		Membership
		Membership
		membership_active_dmv
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in the Washington Metropolitan Area
		4000
		CSV File
		Every calendar month within the first ten calendar days
	
	
		44
		Membership
		Membership
		membership_active_ward_1
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 1
		250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		45
		Membership
		Membership
		membership_active_ward_2
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 2
		250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		46
		Membership
		Membership
		membership_active_ward_3
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 3
		250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		47
		Membership
		Membership
		membership_active_ward_4
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 4
		250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		48
		Membership
		Membership
		membership_active_ward_5
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 5
		250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		49
		Membership
		Membership
		membership_active_ward_6
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 6
		250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		50
		Membership
		Membership
		membership_active_ward_7
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 7
		250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		51
		Membership
		Membership
		membership_active_ward_8
		integer
		Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 8
		250
		CSV File
		Every calendar month within the first ten calendar days
	
	
		52
		Membership
		Membership
		requests_accessibility
		integer
		Report month's total number of requests for and use of accessible Carsharing Vehicle(s) for the report month 
		25
		CSV File
		Every calendar month within the first ten calendar days
	



Sheet 3: YYYY-MM_x_fleet.csv

	
	
		provider_name
		vehicle_id
		vehicle_plate
		vehicle_sticker_dc
		vehicle_make
		vehicle_model
		vehicle_year
		emissions_tier_epa
		propulsion_type
		maintenance
		num_days_available
		num_days_in_service
		num_days_not_in_service
	
	
		string
		string
		string
		string
		string
		string
		integer
		string
		string
		integer
		integer
		integer
		integer

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet cover attachment bdistrict of columbiacarsharing data formats count category type field names entry description example delivery format requirement frequency fleet identification provider name string publicfacing the carsharing company delorean csv file every calendar month within first ten days vehicle id unique number vin assigned by manufacturer scedttxcd plate license r sticker dc current make motor model year integer emissions tier epa s emission rating per rsquo lightduty standards this can read either or propulsion vehicles allelectric plugin hybrid traditional internal combustion other maintenance instances that was removed from service for in past date num available public rightofway and revenue generating trips a customer not trip location start lat float starting latitude lon longitude end ending time datetime tz member rebalancing forhire distance meters ward starts if is district should ends parking zone information nonpremium meter active inactive premium rpp nonreg...

Related files

Share

Help

Count	Data Category	Data Type	Field Names	Entry Type	Field Description	Example	Delivery Format Requirement	Delivery Frequency
1	Fleet Data	Identification	provider_name	string	Public-facing name of the Carsharing Company	DeLorean_Carsharing_Company	CSV File	Every calendar month within the first ten calendar days
2	Fleet Data	Identification	vehicle_id	string	Unique vehicle identification number (VIN) assigned by Manufacturer	SCEDT26TXCD010001	CSV File	Every calendar month within the first ten calendar days
3	Fleet Data	Identification	vehicle_plate	string	Vehicle license plate	R12345	CSV File	Every calendar month within the first ten calendar days
4	Fleet Data	Identification	vehicle_sticker_dc	string	Number of current Carsharing Vehicle Sticker	19-20-10000	CSV File	Every calendar month within the first ten calendar days
5	Fleet Data	Vehicle	vehicle_make	string	Vehicle make	DeLorean_Motor_Company	CSV File	Every calendar month within the first ten calendar days
6	Fleet Data	Vehicle	vehicle_model	string	Vehicle model	DeLorean	CSV File	Every calendar month within the first ten calendar days
7	Fleet Data	Vehicle	vehicle_year	integer	Vehicle model year	1982	CSV File	Every calendar month within the first ten calendar days
8	Fleet Data	Vehicle	emissions_tier_epa	string	The vehicle's EPA emission rating per the EPA’s light-duty vehicle emission standards. This field can read either tier_0, tier_1, tier_2, or tier_3.	tier_0	CSV File	Every calendar month within the first ten calendar days
9	Fleet Data	Vehicle	propulsion_type	string	The vehicles propulsion type. This field can read all-electric, plug-in_hybrid, traditional_hybrid, internal_combustion, or other.	internal_combustion	CSV File	Every calendar month within the first ten calendar days
10	Fleet Data	Maintenance	maintenance	integer	The number of instances that the vehicle was removed from service for maintenance in the past month	3	CSV File	Every calendar month within the first ten calendar days
11	Fleet Data	Date	num_days_available	integer	The number of days the vehicle was in the Public Right-of-Way and available for revenue generating trips by a customer of the Carsharing Company	23	CSV File	Every calendar month within the first ten calendar days
12	Fleet Data	Date	num_days_in_service	integer	The number of days the vehicle was in the Public Right-of-Way in the past month	25	CSV File	Every calendar month within the first ten calendar days
13	Fleet Data	Date	num_days_not_in_service	integer	The number of days the vehicle was not in the Public Right-of-Way in the past month	5	CSV File	Every calendar month within the first ten calendar days
14	Trip	Location	start_lat	float	The starting latitude of the trip	38.897095	CSV File	Every calendar month within the first ten calendar days
15	Trip	Location	start_lon	float	The starting longitude of the trip	-77.006332	CSV File	Every calendar month within the first ten calendar days
16	Trip	Location	end_lat	float	The ending latitude of the trip	38.897095	CSV File	Every calendar month within the first ten calendar days
17	Trip	Location	end_lon	float	The ending longitude of the trip	-77.006332	CSV File	Every calendar month within the first ten calendar days
18	Trip	Date	trip_start_time	datetime	Trip start time and date	2019-08-01T14:30:53Z	CSV File	Every calendar month within the first ten calendar days
19	Trip	Date	trip_end_time	datetime	Trip end time and date	2019-08-01T16:30:53Z	CSV File	Every calendar month within the first ten calendar days
20	Trip	Trip	trip_type	string	Type of trip. This field can read member, service, rebalancing, for-hire, or other.	service	CSV File	Every calendar month within the first ten calendar days
21	Trip	Distance	trip_distance	integer	Trip distance in meters	6000.15	CSV File	Every calendar month within the first ten calendar days
22	Trip	Location	ward_start	string	The Ward the trip starts in. If the vehicle is not in the District, this should read other.	ward_4	CSV File	Every calendar month within the first ten calendar days
23	Trip	Location	ward_end	string	The Ward the trip ends in. If the vehicle is not in the District, this should read other.	ward_7	CSV File	Every calendar month within the first ten calendar days
24	Parking	Parking	parking_zone	string	Parking zone information. This field can read dc_non-premium_meter_active, dc_non-premium_meter_inactive, dc_premium_meter_active, dc_premium_meter_inactive, dc_active_rpp, dc_inactive_rpp, dc_non-regulated, or non-dc_parking	dc_non-premium_meter_active	CSV File	Every calendar month within the first ten calendar days
25	Parking	Parking	zone_rate	float	Parking zone rate. This is the hourly cost of the parking zone.	2.3	CSV File	Every calendar month within the first ten calendar days
26	Parking	Date	parking_start_time	datetime	Date and time of the start of the parking event	2019-08-01T14:30:53Z	CSV File	Every calendar month within the first ten calendar days
27	Parking	Date	parking_end_time	datetime	Date and time of the end of the parking event	2019-08-01T16:30:53Z	CSV File	Every calendar month within the first ten calendar days
28	Parking	Location	parking_latitude	float	The latitude of parking event	38.897095	CSV File	Every calendar month within the first ten calendar days
29	Parking	Location	parking_longitude	float	The longitude of parking event	-77.006332	CSV File	Every calendar month within the first ten calendar days
30	Parking	Location	parking_ward	string	The Ward the vehicle is parked in during parking event. If the vehicle is not in the District, this should read other.	ward_8	CSV File	Every calendar month within the first ten calendar days
31	Parking	Date	parking_minutes	integer	Total minutes parked	120	CSV File	Every calendar month within the first ten calendar days
32	Membership	Membership	membership_total_dc	integer	Report month’s total number of members based in Washington, DC	10000	CSV File	Every calendar month within the first ten calendar days
33	Membership	Membership	membership_total_dmv	integer	Report month’s total number of members based in the Washington Metropolitan Area	20000	CSV File	Every calendar month within the first ten calendar days
34	Membership	Membership	membership_total_ward_1	integer	Report month’s total number of members based in Ward 1	1250	CSV File	Every calendar month within the first ten calendar days
35	Membership	Membership	membership_total_ward_2	integer	Report month’s total number of members based in Ward 2	1250	CSV File	Every calendar month within the first ten calendar days
36	Membership	Membership	membership_total_ward_3	integer	Report month’s total number of members based in Ward 3	1250	CSV File	Every calendar month within the first ten calendar days
37	Membership	Membership	membership_total_ward_4	integer	Report month’s total number of members based in Ward 4	1250	CSV File	Every calendar month within the first ten calendar days
38	Membership	Membership	membership_total_ward_5	integer	Report month’s total number of members based in Ward 5	1250	CSV File	Every calendar month within the first ten calendar days
39	Membership	Membership	membership_total_ward_6	integer	Report month’s total number of members based in Ward 6	1250	CSV File	Every calendar month within the first ten calendar days
40	Membership	Membership	membership_total_ward_7	integer	Report month’s total number of members based in Ward 7	1250	CSV File	Every calendar month within the first ten calendar days
41	Membership	Membership	membership_total_ward_8	integer	Report month’s total number of members based in Ward 8	1250	CSV File	Every calendar month within the first ten calendar days
42	Membership	Membership	membership_active_dc	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Washington, DC	2000	CSV File	Every calendar month within the first ten calendar days
43	Membership	Membership	membership_active_dmv	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in the Washington Metropolitan Area	4000	CSV File	Every calendar month within the first ten calendar days
44	Membership	Membership	membership_active_ward_1	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 1	250	CSV File	Every calendar month within the first ten calendar days
45	Membership	Membership	membership_active_ward_2	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 2	250	CSV File	Every calendar month within the first ten calendar days
46	Membership	Membership	membership_active_ward_3	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 3	250	CSV File	Every calendar month within the first ten calendar days
47	Membership	Membership	membership_active_ward_4	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 4	250	CSV File	Every calendar month within the first ten calendar days
48	Membership	Membership	membership_active_ward_5	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 5	250	CSV File	Every calendar month within the first ten calendar days
49	Membership	Membership	membership_active_ward_6	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 6	250	CSV File	Every calendar month within the first ten calendar days
50	Membership	Membership	membership_active_ward_7	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 7	250	CSV File	Every calendar month within the first ten calendar days
51	Membership	Membership	membership_active_ward_8	integer	Report month's total number of active members (have used a Carsharing Vehicle at least once in the report month) based in Ward 8	250	CSV File	Every calendar month within the first ten calendar days
52	Membership	Membership	requests_accessibility	integer	Report month's total number of requests for and use of accessible Carsharing Vehicle(s) for the report month	25	CSV File	Every calendar month within the first ten calendar days

Related files

Share

Share to social media

Help

Login Area