Transportation Services Index And Seasonally-Adjusted Transportation Data

Department of Transportation

@usgov.dot_gov_seasonally_adjustment_transportation_data

Table List

1 table(163 KB)

Table 1

@usgov.dot_gov_seasonally_adjustment_transportation_data.table_1

163 KB
303 rows
66 columns

id ID	obs_date OBS DATE	asm ASM	asm_d11 ASM D11	asm_d ASM D	asm_d_d11 ASM D D11	asm_i ASM I	asm_i_d11 ASM I D11	rpm RPM	rpm_d11 RPM D11	rpm_d RPM D	rpm_d_d11 RPM D D11	rpm_i RPM I	rpm_i_d11 RPM I D11	load_factor LOAD FACTOR	load_factor_d11 LOAD FACTOR D11	load_factor_d LOAD FACTOR D	load_factor_d_d11 LOAD FACTOR D D11	load_factor_i LOAD FACTOR I	load_factor_i_d11 LOAD FACTOR I D11	enplane_i ENPLANE I	enplane_i_d11 ENPLANE I D11	enplane_d ENPLANE D	enplane_d_d11 ENPLANE D D11	enplane ENPLANE	enplane_d11 ENPLANE D11	air_rpm_tsi AIR RPM TSI	air_rpm_tsi_d11 AIR RPM TSI D11	air_rtmfm AIR RTMFM	air_rtmfm_d11 AIR RTMFM D11	rail_frt_carloads RAIL FRT CARLOADS	rail_frt_carloads_d11 RAIL FRT CARLOADS D11	rail_frt_intermodal RAIL FRT INTERMODAL	rail_frt_intermodal_d11 RAIL FRT INTERMODAL D11	rail_pm RAIL PM	rail_pm_d11 RAIL PM D11	transit TRANSIT	transit_d11 TRANSIT D11	petroleum PETROLEUM	petroleum_d11 PETROLEUM D11	natural_gas NATURAL GAS	natural_gas_d11 NATURAL GAS D11	waterborne WATERBORNE	waterborne_d11 WATERBORNE D11	truck_d11 TRUCK D11	vmt VMT	vmt_d11 VMT D11	tsi_freight TSI Freight	tsi_freight_c TSI Freight C	tsi_passenger TSI Passenger	tsi_passenger_c TSI Passenger C	tsi_total TSI Total	tsi_total_c TSI Total C	ind_pro IND PRO	manuf MANUF	inv_to_sales INV TO SALES	idx_air_rpm IDX AIR RPM	idx_air_rtmfm IDX AIR RTMFM	idx_rail_frt_carloads IDX RAIL FRT CARLOADS	idx_rail_frt_intermodal IDX RAIL FRT INTERMODAL	idx_rail_pm IDX RAIL PM	idx_transit_d11 IDX TRANSIT D11	idx_petroleum_d11 IDX PETROLEUM D11	idx_natural_gas_d11 IDX NATURAL GAS D11	idx_waterborne_d11 IDX WATERBORNE D11	idx_truck_d11 IDX TRUCK D11
SATD200001	Sat Jan 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	76146639	77919728	56288872	57563113	19857767	20356615	48263245	53691833	34913749	39515614	13349496	14176220	63.4	68.9	62	68.6	67.2	69.6	4952	5184	41540	47821	46492	53005	49843099	55944240	2182683	2469777	1354273	1373727	702849	743868	366607410	445980124	724934	769768	215985	212535	2510.5	1811.4	48.4	55.4	79.9	203442	227235	104.9		95.6		101.9		93.9198527963244	79.11616649950591	1.58	0.9486	0.9621	1.0152	1.002	0.957	0.9775	0.9498	0.966	1.1204	1.0672
SATD200002	Tue Feb 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	73011377	78566658	54329819	57829841	18681558	20736817	48580127	55655162	36005847	40663055	12574280	14992107	66.5	70.8	66.3	70.3	67.3	72.3	4812	5444	43714	48563	48526	54007	49931931	57654048	2341123	2528478	1296439	1368818	690991	745801	366139276	444592865	756536	770686	210132	227678	2330.7	1841.1	42	48.6	79	199261	228727	103.6	-1.2	97.7	2.2	101.7	-0.2	94.24381285271566	76.28328913334727	1.56	0.9776	0.9849	1.0116	1.0046	0.9541	0.9787	1.0174	0.9818	0.9844	1.0547
SATD200003	Wed Mar 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	80308529	79341314	59913798	58418543	20394731	20922771	59632014	56835470	43901516	41262819	15730498	15572651	74.3	71.6	73.3	70.6	77.1	74.4	5787	5551	52977	48826	58764	54377	61478163	58627263	2699632	2495706	1404269	1363012	749444	746356	453096388	455047925	843730	786351	216833	219827	2050.6	1721	52.5	52.5	74.7	232490	230237	99.7	-3.8	99.5	1.8	99.6	-2	94.61215944395028	78.39123170067344	1.55	0.9941	0.9722	1.0073	1.0053	0.9765	0.9986	0.9824	0.9178	1.0619	0.9971
SATD200004	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	78139993	79326184	57402637	58371154	20737356	20955031	57636732	57838236	41954244	41804069	15682488	16034167	73.8	72.9	73.1	71.6	75.6	76.5	5688	5700	50344	49812	56032	55512	58981617	58953880	2528558	2549834	1341461	1354921	727542	743208	473751011	466761609	757458	777147	219340	222277	1783.3	1841.3	52.2	50.8	72.4	227698	229068	97.8	-1.9	99.6	0.1	98.4	-1.2	95.21106942450996	79.74955892819796	1.58	0.9996	0.9933	1.0014	1.0011	1.0016	0.9869	0.9933	0.9819	1.0289	0.9669
SATD200005	Mon May 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	80515093	79089555	58896522	58179809	21618571	20909746	59749900	58955091	43168824	42623683	16581076	16331408	74.2	74.5	73.3	73.3	76.7	78.1	5892	5832	52309	50304	58201	56135	61223861	60904210	2528225	2521624	1393416	1359064	752142	741992	481725263	474456974	818246	783440	225649	218904	1632.9	1971.1	53.5	52.5	73.1	242501	229651	98.8	1	102.2	2.6	99.9	1.6	95.4872523079796	78.3497235181343	1.59	1.0327	0.9823	1.0044	0.9994	1.0181	0.9949	0.9782	1.0512	1.063	0.9765
SATD200006	Thu Jun 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	80393854	79009706	58286914	57709822	22106940	21299885	64046964	58279390	45856363	41944660	18190601	16334730	79.7	73.8	78.7	72.7	82.3	76.7	6400	5736	54673	49332	61073	55068	65601574	59472866	2537148	2516361	1343794	1346752	742018	733942	517102460	457988261	793911	788368	225621	220757	1513.1	1881.4	50.4	48.5	75.1	242963	230024	99.8	1	100.6	-1.6	100.1	0.2	95.55619528223858	79.60057820816554	1.6	1.0084	0.9802	0.9953	0.9886	0.9828	1.0011	0.9865	1.0033	0.9822	1.0028
SATD200007	Sat Jul 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	83853711	79009083	60607052	57700808	23246659	21308275	66435577	58231827	47303803	41768640	19131774	16463187	79.2	73.7	78	72.4	82.3	77.3	7014	5821	55568	50249	62582	56070	67898320	58867634	2461623	2477872	1330434	1353619	738911	735750	564747276	472088980	743746	784739	228889	222399	1525.6	1739.5	53.3	49.6	72.9	245140	228840	97.6	-2.2	99.8	-0.8	98.3	-1.7	95.38717711136523	78.83009659281714	1.6	0.9981	0.9652	1.0004	0.991	1.0131	0.9965	0.9939	0.9276	1.0038	0.9728
SATD200008	Tue Aug 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	84702734	79321116	61479288	57929473	23223446	21391643	65252958	57197283	46457758	40831251	18795200	16366032	77	72.1	75.6	70.5	80.9	76.5	6881	5911	54474	50299	61355	56210	67028338	58778999	2623412	2567076	1423542	1354960	792621	735015	558060051	476481276	787064	785715	231542	225260	1653.1	1851.3	50.9	48.3	74.7	247832	229339	99.7	2.1	99.7	-0.1	99.7	1.4	95.13411221479316	77.73921668197734	1.62	0.9966	1	1.0014	0.99	1.0225	0.9978	1.0066	0.9873	0.9779	0.9977
SATD200009	Fri Sep 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	79912506	81489806	57899315	59904823	22013191	21584984	55470176	60234230	38372644	43113447	17097532	17120783	69.4	73.9	66.3	72	77.7	79.3	5859	6432	46363	52284	52222	58716	56441629	61512516	2711279	2763024	1381834	1371644	768195	744284	446489429	481155166	802516	794379	222945	225376	1475	1859.3	47.3	48.5	74	227899	231166	99.7	0.1	103.4	3.6	100.9	1.2	95.53657068002776	79.89786654256757	1.59	1.043	1.0763	1.0137	1.0025	1.0325	1.0088	1.0072	0.9915	0.9816	0.9885
SATD200010	Sun Oct 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	82627553	81130305	60761374	59403685	21866179	21726620	57979416	59453958	41820446	42644222	16158970	16809735	70.2	73.3	68.8	71.8	73.9	77.4	5635	6210	50920	51680	56555	57889	58834210	59918834	2839068	2642773	1442723	1351186	837316	760866	462329685	486360369	851255	801546	234903	234227	1567.8	1874.1	50.8	47.8	74.2	236491	230372	99.5	-0.2	101.7	-1.6	100.2	-0.7	95.18445805292566	78.24718708883486	1.6	1.016	1.0295	0.9986	1.0248	1.0437	1.0179	1.0467	0.9994	0.968	0.9904


CREATE TABLE table_1 (
  "id" VARCHAR,
  "obs_date" TIMESTAMP,
  "asm" DOUBLE,
  "asm_d11" DOUBLE,
  "asm_d" DOUBLE,
  "asm_d_d11" DOUBLE,
  "asm_i" DOUBLE,
  "asm_i_d11" DOUBLE,
  "rpm" DOUBLE,
  "rpm_d11" DOUBLE,
  "rpm_d" DOUBLE,
  "rpm_d_d11" DOUBLE,
  "rpm_i" DOUBLE,
  "rpm_i_d11" DOUBLE,
  "load_factor" DOUBLE,
  "load_factor_d11" DOUBLE,
  "load_factor_d" DOUBLE,
  "load_factor_d_d11" DOUBLE,
  "load_factor_i" DOUBLE,
  "load_factor_i_d11" DOUBLE,
  "enplane_i" DOUBLE,
  "enplane_i_d11" DOUBLE,
  "enplane_d" DOUBLE,
  "enplane_d_d11" DOUBLE,
  "enplane" DOUBLE,
  "enplane_d11" DOUBLE,
  "air_rpm_tsi" DOUBLE,
  "air_rpm_tsi_d11" DOUBLE,
  "air_rtmfm" DOUBLE,
  "air_rtmfm_d11" DOUBLE,
  "rail_frt_carloads" BIGINT,
  "rail_frt_carloads_d11" BIGINT,
  "rail_frt_intermodal" BIGINT,
  "rail_frt_intermodal_d11" BIGINT,
  "rail_pm" DOUBLE,
  "rail_pm_d11" DOUBLE,
  "transit" DOUBLE,
  "transit_d11" DOUBLE,
  "petroleum" DOUBLE,
  "petroleum_d11" DOUBLE,
  "natural_gas" DOUBLE,
  "natural_gas_d11" DOUBLE,
  "waterborne" DOUBLE,
  "waterborne_d11" DOUBLE,
  "truck_d11" DOUBLE,
  "vmt" BIGINT,
  "vmt_d11" BIGINT,
  "tsi_freight" DOUBLE,
  "tsi_freight_c" DOUBLE,
  "tsi_passenger" DOUBLE,
  "tsi_passenger_c" DOUBLE,
  "tsi_total" DOUBLE,
  "tsi_total_c" DOUBLE,
  "ind_pro" DOUBLE,
  "manuf" DOUBLE,
  "inv_to_sales" DOUBLE,
  "idx_air_rpm" DOUBLE,
  "idx_air_rtmfm" DOUBLE,
  "idx_rail_frt_carloads" DOUBLE,
  "idx_rail_frt_intermodal" DOUBLE,
  "idx_rail_pm" DOUBLE,
  "idx_transit_d11" DOUBLE,
  "idx_petroleum_d11" DOUBLE,
  "idx_natural_gas_d11" DOUBLE,
  "idx_waterborne_d11" DOUBLE,
  "idx_truck_d11" DOUBLE
);