Trip Report Stats

TABLE | GRAPHS | NUMBER OF DAYS

The button below opens a table showing the number of days represented by my trip reports. Variables:

unique_page_count represents the number of unique trip report pages.
unique_date_count represents the number of days represented by the trip reports.
unique_date_count_YYYY represents the number of days in the corresponding state/province and year.
Selected trip reports are removed (Tib/Fib 2010-11, Knee Surgery 2020-21, Covid 2021, 7-Day Fast) since these don't fall into a State/Province category and they are also trip reports that span long periods of time and skew the data.

The second table is a transpose of the first table and shows totals per year instead of totals per state/province.

Below the tables are some graphs showing a visual breakdown of the number of days by state/province and year and month.

This table and graphs are based on SQL queries to all pages on my site. They may take awhile to load.

Trip Report Stats

TABLE | GRAPHS | NUMBER OF DAYS

First table: Table showing the number of days represented by my trip reports. Variables:

unique_page_count represents the number of unique trip report pages.
unique_date_count represents the number of days represented by the trip reports.
unique_date_count_YYYY represents the number of days in the corresponding state/province and year.
Selected trip reports are removed (Tib/Fib 2010-11, Knee Surgery 2020-21, Covid 2021, 7-Day Fast) since these don't fall into a State/Province category and they are also trip reports that span long periods of time and skew the data.

Second table: The second table is a transpose of the first table and shows totals per year instead of totals per state/province.

Graphs: Below the tables are some graphs showing a visual breakdown of the number of days by state/province and year and month.

This table and graphs are based on SQL queries to all pages on my site. They may take awhile to load.

Total Days Represented by my Trip Reports, by State/Province and Year (Row totals per State/Province)

Total Days Represented by my Trip Reports, by State/Province and Year (Row totals per Year)

state	unique_page_count	unique_date_count	unique_page_count_total_per_state	unique_date_count_total_per_state	unique_date_count_1994	unique_date_count_1998	unique_date_count_1999	unique_date_count_2001	unique_date_count_2002	unique_date_count_2003	unique_date_count_2004	unique_date_count_2005	unique_date_count_2006	unique_date_count_2007	unique_date_count_2008	unique_date_count_2009	unique_date_count_2010	unique_date_count_2011	unique_date_count_2012	unique_date_count_2013	unique_date_count_2014	unique_date_count_2015	unique_date_count_2016	unique_date_count_2017	unique_date_count_2018	unique_date_count_2019	unique_date_count_2020	unique_date_count_2021	unique_date_count_2022	unique_date_count_2023	unique_date_count_2024	unique_date_count_2025
Colorado	222	722	222	722										2			2				6				20	55	100	130	174	92	129	12
Washington	133	405	133	405				1	8	6	9	2	28	30	25	32	33	17	58	30	7	23	30	20	33	8				5
California	53	183	53	183								31		9			3			19		39	11	27	12				1		31
British Columbia	31	128	31	128			7						16	10	5	4	3	6	5	1	3	2	19	10	12	23				2
Wyoming	28	116	28	116	1									4	4			7	12		20		7			5	6	21	5	19	5
Arizona	10	69	10	69											4										6		12	15	15	14	1	2
Utah	13	68	13	68													21				14				3	4	7			1	13	5
Nevada	10	47	10	47										2			1		4		2	14	6		7	8					3
Idaho	4	41	4	41		10															12		4			15
Italy	2	36	2	36													33			3
Switzerland	3	29	3	29								15								14
Oregon	5	23	5	23									7		3			7		1		2		3
Spain	1	15	1	15																												15
Texas	2	15	2	15											11																2	2
Montana	6	14	6	14														3							11
Alberta	10	13	10	13													1	3	2					7
North Carolina	1	6	1	6																				6
Kentucky	1	4	1	4																										4
South Dakota	1	4	1	4																								4
state	unique_page_count	unique_date_count	unique_page_count_total_per_state	unique_date_count_total_per_state	unique_date_count_1994	unique_date_count_1998	unique_date_count_1999	unique_date_count_2001	unique_date_count_2002	unique_date_count_2003	unique_date_count_2004	unique_date_count_2005	unique_date_count_2006	unique_date_count_2007	unique_date_count_2008	unique_date_count_2009	unique_date_count_2010	unique_date_count_2011	unique_date_count_2012	unique_date_count_2013	unique_date_count_2014	unique_date_count_2015	unique_date_count_2016	unique_date_count_2017	unique_date_count_2018	unique_date_count_2019	unique_date_count_2020	unique_date_count_2021	unique_date_count_2022	unique_date_count_2023	unique_date_count_2024	unique_date_count_2025
					∑ = 1	∑ = 10	∑ = 7

year	total	unique_date_count_total_per_year	Colorado	Washington	California	British_Columbia	Wyoming	Arizona	Utah	Nevada	Idaho	Italy	Switzerland	Oregon	Spain	Texas	Montana	Alberta	North_Carolina	Kentucky	South_Dakota
1994	1	1					1
1998	10	10									10
1999	7	7				7
2001	1	1		1
2002	8	8		8
2003	6	6		6
2004	9	9		9
2005	48	48		2	31								15
2006	51	51		28		16								7
2007	57	57	2	30	9	10	4			2
2008	52	52		25		5	4	4						3		11
2009	36	36		32		4
2010	97	97	2	33	3	3			21	1		33						1
2011	43	43		17		6	7							7			3	3
2012	81	81		58		5	12			4								2
2013	68	68		30	19	1						3	14	1
2014	64	64	6	7		3	20		14	2	12
2015	80	80		23	39	2				14				2
2016	77	77		30	11	19	7			6	4
2017	73	73		20	27	10								3				7	6
2018	104	104	20	33	12	12		6	3	7							11
2019	118	118	55	8		23	5		4	8	15
2020	125	125	100				6	12	7
2021	170	170	130				21	15													4
2022	195	195	174		1		5	15
2023	137	137	92	5		2	19	14	1											4
2024	184	184	129		31		5	1	13	3						2
2025	36	36	12					2	5						15	2
year	total	unique_date_count_total_per_year	Colorado	Washington	California	British_Columbia	Wyoming	Arizona	Utah	Nevada	Idaho	Italy	Switzerland	Oregon	Spain	Texas	Montana	Alberta	North_Carolina	Kentucky	South_Dakota
	∑ = 1.938

www.StephAbegg.com

Trip Reports by Region

List of Regions with Trip Reports

STATES LISTED ALPHABETICALLY

UNITED STATES

Arizona

California

Colorado

Idaho

Kentucky

Montana

Nevada

North Carolina

Oregon

South Dakota

Texas

Utah

Washington

Wyoming

INTERNATIONAL

British Columbia & Alberta

Europe

(Switzerland, Italy, & Spain)

Map of Regions with Trip Reports

ZOOM IN AND CLICK ON ICON FOR LINK

Trip Report Stats

TABLE | GRAPHS | NUMBER OF DAYS