Trips By US People(from 2019 To Nov 2021)

Trips travel in all modes of transportation in USA during pre-post covid times.

@kaggle.ramjasmaurya_trips_by_distancefrom_2019_to_nov_2021

Table List

2 tables(5.27 MB)

National Trips

@kaggle.ramjasmaurya_trips_by_distancefrom_2019_to_nov_2021.national_trips

118.68 KB
1055 rows
18 columns

unnamed_0 Unnamed: 0	level Level	date Date	population_staying_at_home Population Staying At Home	population_not_staying_at_home Population Not Staying At Home	number_of_trips Number Of Trips	number_of_trips_1 Number Of Trips \u003c1	number_of_trips_1_3 Number Of Trips 1-3	number_of_trips_3_5 Number Of Trips 3-5	number_of_trips_5_10 Number Of Trips 5-10	number_of_trips_10_25 Number Of Trips 10-25	number_of_trips_25_50 Number Of Trips 25-50	number_of_trips_50_100 Number Of Trips 50-100	number_of_trips_100_250 Number Of Trips 100-250	number_of_trips_250_500 Number Of Trips 250-500	number_of_trips_500 Number Of Trips \u003e\u003d500	week Week	month Month
	National	2019/01/01	77433867	248733553	897784368	241667151	234284795	108078903	129670778	116904343	40432062	15686639	7525563	1806022	1728112		1
1	National	2019/01/02	61305201	264862219	1139452281	291276735	285887315	138039296	171637514	167412698	56148976	17739183	7817044	1962301	1531219		1
2	National	2019/01/03	63050480	263116940	1162752684	296375014	290074425	140771581	175775410	172027487	57632422	18366626	8124548	2038099	1567072		1
3	National	2019/01/04	61803652	264363768	1181953829	293159631	295643296	145251819	181324645	176144493	58761592	19315785	8687318	2096065	1569185		1
4	National	2019/01/05	64389745	261777675	1180476620	295459014	304168709	148540651	180941769	165239790	54842134	19363939	8490791	1991159	1438664		1
5	National	2019/01/06	66498949	259668471	1073940581	268535036	285817694	136432949	163231150	144091310	46931537	17418975	8160971	1917898	1403061	1	1
6	National	2019/01/07	62840591	263326829	1144741952	301592063	286444719	137699110	169846852	165178406	55660657	17491604	7584683	1815569	1428289	1	1
7	National	2019/01/08	63064293	263103127	1141497715	299541016	285368410	136696978	169468215	166322929	55968279	17369502	7471402	1856802	1434182	1	1
8	National	2019/01/09	62305155	263862265	1135628554	291070223	285839600	137586966	170647903	166169173	55640198	17543261	7709071	1923976	1498183	1	1
9	National	2019/01/10	61355771	264811649	1161334504	297556678	290556495	140392680	174998777	171169293	57136281	18087977	7940284	1975790	1520249	1	1


CREATE TABLE national_trips (
  "unnamed_0" BIGINT,
  "level" VARCHAR,
  "date" VARCHAR,
  "population_staying_at_home" BIGINT,
  "population_not_staying_at_home" BIGINT,
  "number_of_trips" BIGINT,
  "number_of_trips_1" BIGINT,
  "number_of_trips_1_3" BIGINT,
  "number_of_trips_3_5" BIGINT,
  "number_of_trips_5_10" BIGINT,
  "number_of_trips_10_25" BIGINT,
  "number_of_trips_25_50" BIGINT,
  "number_of_trips_50_100" BIGINT,
  "number_of_trips_100_250" BIGINT,
  "number_of_trips_250_500" BIGINT,
  "number_of_trips_500" BIGINT,
  "week" BIGINT,
  "month" BIGINT
);