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)

State Trips

@kaggle.ramjasmaurya_trips_by_distancefrom_2019_to_nov_2021.state_trips

5.16 MB
53805 rows
20 columns

unnamed_0 Unnamed: 0	level Level	date Date	state_postal_code State Postal Code	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	row_id Row ID	month Month
	State	2019/01/01	NV	753054	2272063	9139676	2999886	2181216	1039500	1378024	1108436	222837	93301	73578	24471	18427	32-00000-20190101	1
1	State	2019/01/01	FL	4524666	16709556	55258300	16036792	14469767	6658624	7977612	6604304	2113009	796740	412224	95341	93887	12-00000-20190101	1
2	State	2019/01/01	DC	241030	459278	3114055	1314825	833796	367547	344116	183744	42096	10730	8109	3476	5616	11-00000-20190101	1
3	State	2019/01/01	DE	224457	739757	2420942	584323	640348	305441	370359	314102	128454	50542	22701	2474	2198	10-00000-20190101	1
4	State	2019/01/01	CT	853894	2707851	9468961	2375021	2618933	1189575	1331356	1211252	449947	192960	56618	12031	31268	09-00000-20190101	1
5	State	2019/01/01	CO	1500392	4177764	17617208	4658614	4542154	2068250	2609927	2473886	730418	323870	124776	32545	52768	08-00000-20190101	1
6	State	2019/01/01	NH	312645	1039666	3705345	726417	970009	492350	582185	573171	231818	90462	27333	3998	7602	33-00000-20190101	1
7	State	2019/01/01	NJ	2244189	6637104	26078674	7491874	6764617	3009746	3582118	3262723	1233743	486493	155179	28397	63784	34-00000-20190101	1
8	State	2019/01/01	NM	525761	1563262	6475422	1972284	1756894	795723	834525	632375	231297	139256	83929	19001	10138	35-00000-20190101	1
9	State	2019/01/01	NY	5931873	13550603	60957950	18317662	15401822	7187598	8789865	7589390	2294488	857637	329795	72132	117561	36-00000-20190101	1


CREATE TABLE state_trips (
  "unnamed_0" BIGINT,
  "level" VARCHAR,
  "date" VARCHAR,
  "state_postal_code" 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,
  "row_id" VARCHAR,
  "week" BIGINT,
  "month" BIGINT
);