Daily

From FridaV

date	pings	positions	bssids	waypoints	tracks	itracks	media	pmedia	city
2009-11-19 Thu	15610	0	114
2009-11-10 Tue	6376	0	86
2009-10-21 Wed	11409	0	101
2009-10-08 Thu	8	0	8	266	2	1			http://dbpedia.org/resource/Paris
2009-10-07 Wed				312	35				http://dbpedia.org/resource/Paris
2009-10-06 Tue	16983	0	119
2009-10-05 Mon	5238	0	110
2009-10-04 Sun	76734	0	152
2009-10-01 Thu	3012	0	86
2009-09-28 Mon	35125	0	131
2009-09-26 Sat	786	366	18	13629	69	13			http://dbpedia.org/resource/Paris
2009-09-25 Fri	3245	0	101
2009-09-23 Wed	5857	0	99
2009-09-22 Tue	5340	0	105	168	5		4		http://dbpedia.org/resource/Paris
2009-09-21 Mon	15804	0	121				1
2009-09-20 Sun	13216	476	927				67
2009-09-19 Sat							2
2009-09-18 Fri	1267	0	79				3
2009-06-29 Mon	405	0	123				2
2009-06-22 Mon	327	118	182	143	50				http://dbpedia.org/resource/Paris
2009-06-18 Thu					1
2009-06-15 Mon	2211	0	30				1
2009-06-14 Sun	5602	218	194	1705	10	1	74	15	http://dbpedia.org/resource/Paris
2009-06-13 Sat	2136	756	833	1452	27	4	10	3	http://dbpedia.org/resource/Paris
2009-06-12 Fri	18569	2584	1381	8366	29	11	149	124	http://dbpedia.org/resource/Paris
2009-06-10 Wed	5313	194	64	1370	10	4	13	11	http://dbpedia.org/resource/Paris
2009-06-09 Tue	24216	748	808	1973	198	8	23	11	http://dbpedia.org/resource/Paris
2009-06-08 Mon	6478	0	40				3
2009-06-07 Sun	6426	6366	858	28173	309	28	212	182	http://dbpedia.org/resource/Paris
2009-06-06 Sat	19546	16440	126	23489	105	6	145	5	http://dbpedia.org/resource/Paris
2009-06-05 Fri	44747	43737	151	67842	209		3	2	http://dbpedia.org/resource/Paris
2009-06-04 Thu	24926	13515	3856	44764	122	51	109	78	http://dbpedia.org/resource/Paris
2009-06-03 Wed	22064	15389	1346	31428	309	23	17	17	http://dbpedia.org/resource/Paris
2009-06-02 Tue	66790	12092	1403	17541	150	19	284	173	http://dbpedia.org/resource/Paris
2009-06-01 Mon	26939	25951	138	24978	98		4	3	http://dbpedia.org/resource/Paris
2009-05-31 Sun	23269	19470	398	27953	196	4	60		http://dbpedia.org/resource/Paris
2009-05-30 Sat	16849	6671	219	6213	82	12	26		http://dbpedia.org/resource/Paris
2009-05-29 Fri	26661	7550	283	13945	40	2	21		http://dbpedia.org/resource/Paris
2009-05-28 Thu	26689	1461	527	4085	16	8	21	3	http://dbpedia.org/resource/Paris
2009-05-27 Wed	36519	339	511	570	25	2			http://dbpedia.org/resource/Paris
2009-05-26 Tue	17573	103	53	155	2				http://dbpedia.org/resource/Ljubljana
2009-05-25 Mon	57441	50525	32	34989	30				http://dbpedia.org/resource/Ljubljana
2009-05-24 Sun	18922	0	30	4876	14				http://dbpedia.org/resource/Ljubljana
2009-05-23 Sat	9373	0	153
2009-05-22 Fri	4745	0	20
2009-05-21 Thu	10046	0	24	6574	149				http://dbpedia.org/resource/Ljubljana
2009-05-20 Wed	11896	0	134	5752	26				http://dbpedia.org/resource/Ljubljana
2009-05-19 Tue	3320	0	16
2009-05-16 Sat	5131	0	28	4254	4				http://dbpedia.org/resource/Ljubljana
2009-05-15 Fri	81399	0	33	68800	1602				http://dbpedia.org/resource/Ljubljana
2009-05-14 Thu	57216	0	31	106597	439		14	14	http://dbpedia.org/resource/Ljubljana
2009-05-13 Wed				31946	74				http://dbpedia.org/resource/Ljubljana
2009-05-12 Tue				2802	87				http://dbpedia.org/resource/Ljubljana
2009-05-11 Mon				146678	2030				http://dbpedia.org/resource/Ljubljana
2009-05-10 Sun				171140	220				http://dbpedia.org/resource/Ljubljana
2009-05-09 Sat				21962	259				http://dbpedia.org/resource/Ljubljana
2009-05-08 Fri				21216	203				http://dbpedia.org/resource/Ljubljana
2009-05-06 Wed				12749	156				http://dbpedia.org/resource/Ljubljana
2009-05-05 Tue				11875	24				http://dbpedia.org/resource/Ljubljana
2009-03-29 Sun							33
2009-03-28 Sat							10
2009-03-27 Fri							10
2009-03-26 Thu							25
2009-03-25 Wed				4352	14		4		http://dbpedia.org/resource/Ljubljana
2009-03-24 Tue				6441	80				http://dbpedia.org/resource/Ljubljana
2009-03-23 Mon				1944	72				http://dbpedia.org/resource/Ljubljana
2009-02-25 Wed				1799	15				http://dbpedia.org/resource/Ljubljana
2009-02-06 Fri	12318	0	1197	649	15				http://dbpedia.org/resource/Maribor
2009-01-28 Wed				2852	295				http://dbpedia.org/resource/Ljubljana
2009-01-27 Tue				3410	291				http://dbpedia.org/resource/Ljubljana
2008-12-16 Tue					1
2008-11-16 Sun				3222	5				http://dbpedia.org/resource/Istanbul
2008-11-14 Fri				1328	9				http://dbpedia.org/resource/Istanbul
2008-11-12 Wed				712	26				http://dbpedia.org/resource/Istanbul
2008-11-10 Mon				5515	365				http://dbpedia.org/resource/Istanbul
2008-11-09 Sun				3657	31				http://dbpedia.org/resource/Istanbul
2008-11-08 Sat				2681	166				http://dbpedia.org/resource/Istanbul
2007-09-08 Sat				7969	77				http://dbpedia.org/resource/Ljubljana
2007-09-07 Fri				458	77				http://dbpedia.org/resource/Ljubljana
2007-08-05 Sun				2710	254				http://dbpedia.org/resource/Ljubljana
2007-07-30 Mon				8029	196				http://dbpedia.org/resource/Beijing
2007-07-29 Sun				1960	3				http://dbpedia.org/resource/Beijing
2007-07-28 Sat				6512	6				http://dbpedia.org/resource/Beijing
2007-07-27 Fri				6985	13				http://dbpedia.org/resource/Beijing
2007-07-26 Thu				22585	95				http://dbpedia.org/resource/Beijing
2007-07-25 Wed				4808	25				http://dbpedia.org/resource/Beijing
2007-07-24 Tue				9122	25				http://dbpedia.org/resource/Beijing
2007-07-23 Mon				6148	123				http://dbpedia.org/resource/Beijing
2007-07-22 Sun				128	3				http://dbpedia.org/resource/Beijing
2007-07-21 Sat				112	4				http://dbpedia.org/resource/Beijing
2007-07-20 Fri				4905	319				http://dbpedia.org/resource/Beijing
2007-07-19 Thu				268	2				http://dbpedia.org/resource/Beijing
2007-07-12 Thu				9604	18				http://dbpedia.org/resource/London
2007-07-11 Wed				149	4				http://dbpedia.org/resource/London
2007-07-09 Mon				1442	361				http://dbpedia.org/resource/London
2007-07-08 Sun				7420	207				http://dbpedia.org/resource/Paris
2007-05-07 Mon				73	5				http://dbpedia.org/resource/Ljubljana
2007-05-02 Wed				2440	2				http://dbpedia.org/resource/Ljubljana
2007-05-01 Tue				21633	9				http://dbpedia.org/resource/Ljubljana
2007-04-30 Mon				32	3				http://dbpedia.org/resource/Ljubljana
2007-04-26 Thu				34791	99				http://dbpedia.org/resource/Ljubljana
2007-04-25 Wed				1	1				http://dbpedia.org/resource/Ljubljana
2006-10-22 Sun				6258	6				http://dbpedia.org/resource/Ljubljana
2006-10-01 Sun				2077	56				http://dbpedia.org/resource/Maribor
2006-09-30 Sat				433	36				http://dbpedia.org/resource/Maribor
2006-09-28 Thu				1964	313				http://dbpedia.org/resource/Maribor
2006-09-27 Wed				4361	37				http://dbpedia.org/resource/Maribor
2006-09-26 Tue				4158	5				http://dbpedia.org/resource/Ljubljana
2006-09-25 Mon				7514	9				http://dbpedia.org/resource/Ljubljana
2006-07-24 Mon				10626	5				http://dbpedia.org/resource/Ljubljana
2006-07-23 Sun				1258	3				http://dbpedia.org/resource/Ljubljana
2006-06-29 Thu				2255	1				http://dbpedia.org/resource/Ljubljana
2006-06-28 Wed				6989	6				http://dbpedia.org/resource/Ljubljana
2006-06-27 Tue				962	1				http://dbpedia.org/resource/Ljubljana
2006-06-26 Mon				1140	2				http://dbpedia.org/resource/Ljubljana
2006-06-25 Sun				15965	9				http://dbpedia.org/resource/Ljubljana
2006-06-24 Sat				479	1				http://dbpedia.org/resource/Ljubljana
2006-06-23 Fri				676	1				http://dbpedia.org/resource/Ljubljana
2006-06-21 Wed				10326	10				http://dbpedia.org/resource/Ljubljana
2006-06-13 Tue				121					http://dbpedia.org/resource/Ljubljana
2006-06-12 Mon				726	2				http://dbpedia.org/resource/Ljubljana
2006-05-12 Fri				8169	64				http://dbpedia.org/resource/Maribor
2006-05-11 Thu				1096	7				http://dbpedia.org/resource/Maribor
2006-05-10 Wed				4449	49				http://dbpedia.org/resource/Maribor
2006-05-09 Tue				615	22				http://dbpedia.org/resource/Maribor
2006-04-27 Thu				548	1				http://dbpedia.org/resource/Ljubljana
2006-04-26 Wed				441	3				http://dbpedia.org/resource/Ljubljana
2006-01-09 Mon				14086	52				http://dbpedia.org/resource/Manhattan
2006-01-08 Sun				3887	18				http://dbpedia.org/resource/Manhattan
2006-01-07 Sat				922	23				http://dbpedia.org/resource/Manhattan
2006-01-06 Fri				12198	490				http://dbpedia.org/resource/Manhattan
2006-01-05 Thu				2647	45				http://dbpedia.org/resource/Manhattan
2006-01-04 Wed				7549	205				http://dbpedia.org/resource/Manhattan
2006-01-03 Tue				8242	207				http://dbpedia.org/resource/Manhattan
2005-12-31 Sat				818	13				http://dbpedia.org/resource/Manhattan
2005-12-30 Fri				2695	5				http://dbpedia.org/resource/Manhattan
2005-12-28 Wed				1974	7				http://dbpedia.org/resource/Manhattan
2005-12-24 Sat				1435	14				http://dbpedia.org/resource/Manhattan
2005-12-23 Fri				273	3				http://dbpedia.org/resource/Manhattan
2005-11-28 Mon				29821	1347				http://dbpedia.org/resource/Ljubljana
2005-11-27 Sun				29630	1389				http://dbpedia.org/resource/Ljubljana
2005-11-26 Sat				18649	812				http://dbpedia.org/resource/Ljubljana
2005-11-25 Fri				38078	1591				http://dbpedia.org/resource/Ljubljana
2005-11-24 Thu				2204	30				http://dbpedia.org/resource/Ljubljana
2005-11-21 Mon				59496	26				http://dbpedia.org/resource/Ljubljana
2005-11-20 Sun				82107	6				http://dbpedia.org/resource/Ljubljana
2005-11-19 Sat				83662	2				http://dbpedia.org/resource/Ljubljana
2005-11-18 Fri				83419	4				http://dbpedia.org/resource/Ljubljana
2005-11-17 Thu				890	1				http://dbpedia.org/resource/Ljubljana
2005-11-14 Mon				2803	3				http://dbpedia.org/resource/Ljubljana
2005-10-18 Tue				106	1				http://dbpedia.org/resource/Ljubljana
2005-10-17 Mon				428	2				http://dbpedia.org/resource/Ljubljana
2005-10-16 Sun				109	1				http://dbpedia.org/resource/Ljubljana
2005-10-02 Sun				3834	12				http://dbpedia.org/resource/Ljubljana
2005-10-01 Sat				804	1				http://dbpedia.org/resource/Ljubljana
2005-09-28 Wed				341	2				http://dbpedia.org/resource/Ljubljana
2004-11-14 Sun				114	1				http://dbpedia.org/resource/Rotterdam
2004-11-13 Sat				7217	26				http://dbpedia.org/resource/Rotterdam
2004-11-12 Fri				5242	13				http://dbpedia.org/resource/Rotterdam
2004-11-07 Sun				454	1				http://dbpedia.org/resource/Rotterdam
2004-11-04 Thu				826	12				http://dbpedia.org/resource/Rotterdam
2004-11-03 Wed				7846	38				http://dbpedia.org/resource/Rotterdam
2004-11-02 Tue				27	1				http://dbpedia.org/resource/Rotterdam
2004-10-29 Fri				2746	5				http://dbpedia.org/resource/Ljubljana
2004-10-28 Thu				6102	15				http://dbpedia.org/resource/Ljubljana

 SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,'YYYY-MM-DD Dy')) as date,
               pings, positions, bssids, waypoints, tracks, itracks, media, pmedia, 
               xmlelement(name a, xmlattributes(city_url as href),city_url) as city
   FROM frida.overview
  WHERE date IS NOT NULL 
       AND date >= date'2004-01-01'
  ORDER BY to_char(date,'YYYY-MM-DD Dy') DESC