User:Gareth/Commons Datasets

When transcluded, a Commons .tab page is automatically turned into a wikitable. Alas, this doesn't work outside of Commons.

Graphs derived from the same .tab pages have been included for some examples to demonstrate how tables and graphs can work together.

Apache OpenOffice mailing list messages

Data: The annual average of the number of messages posted to the Apache OpenOffice project's English language mailing lists each month.

Comments: The graph uses the year as the x axis and the number of messages as the y axis. Unfortunately, the table doesn't understand axes - it reflects the structure of the .tab page and treats all columns as equals. A human-written table would use ! to define the years as row headers.

Table issues:

• No ability to set row headers

Year	dev	users	l10n	qa	marketing	api	doc	recruitment
2012	1266	235	211	150	63	30	7
2013	1124	198	225	127	87	35	41
2014	552	328	119	71	18	20	25
2015	340	219	34	16	3	15	12
2016	323	208	18	16	4	1	13	3
2017	253	154	19	2	2	0	1	11

See or edit raw graph data.

Percentage of the population overweight

Data: The percentage of the population either overweight or obese by country and year.

Comments: The inability to customise the table is really apparent here. Quite simply, it's a mess. There is far too much data for this table to be any use. But there is substantial potential to create useful tables by allowing the selection of only a subset of the data. For instance, a table of a single country's data could be created. For display reasons, the "ISO Country Code" field may need to be augmented by a field listing the common country names (e.g. China, France, Zimbabwe) - although these names are used by the corresponding graph.

The graph features a nice level of interactivity and demonstrates the potential when tabular data is combined with map data (the map comes from a .map page) and the graph extension. Once interactive mode has been enabled by pressing the play button, hover over each country to see some data for that country; click along the timeline to select a year; and drag the left or right dotted lines at the edge of the slider to show the percentage change during a particular time period. The graph also allows the year used for the initial display to be specified, considerably extending its potential.

Table issues:

• Data is useless as a table without the ability to select which data to display
• Wide columns caused by lack of text wrapping

Seriously, this table never ends!

See or edit source data.

Gross domestic product of US states

Data: The gross domestic product of US states by year.

Comments: The table suffers the same problem with the years not being row headers as the OpenOffice example. It is also extremely wide, going far beyond the width of the page. Flipping the states from columns into rows would help - up to a point. Being able to limit the data displayed would provide a solution that could be maintained even as the data set is updated. Combining these two approaches could lead to the years (rows) and states (columns) being flipped around and the table covering only the last five years of data. Note how the names consisting of multiple words are wrapped - this occurs because the table takes up the full width of the page's content area (and then some). This autowrapping should be extended to cover situations where one cell is substantially wider than the rest of the column (often caused by the headers for columns consisting of numbers).

Three quite different graphs have been created from this data, two of which use only a subset of the data - that which relates to California, New York and Texas. Additionally, the pie chart uses only the data from 2015. And note that its percentages are calculated automatically. This is the sort of flexibility we need when creating wikitables.

Table issues:

• No ability to set row headers
• Numbers are unformatted and hard to read
• No way to flip axes to improve display
• It would be nice to be able to highlight a row and/or column
• It would be nice to be able to add wikilinks

Year	Alabama	Alaska	Arizona	Arkansas	California	Colorado	Connecticut	Delaware	District of Columbia	Florida	Georgia	Hawaii	Idaho	Illinois	Indiana	Iowa	Kansas	Kentucky	Louisiana	Maine	Maryland	Massachusetts	Michigan	Minnesota	Mississippi	Missouri	Montana	Nebraska	Nevada	New Hampshire	New Jersey	New Mexico	New York	North Carolina	North Dakota	Ohio	Oklahoma	Oregon	Pennsylvania	Rhode Island	South Carolina	South Dakota	Tennessee	Texas	Utah	Vermont	Virginia	Washington	West Virginia	Wisconsin	Wyoming
1997	104218	25446	132708	60417	1081444	135868	140108	33672	51566	402340	242153	37655	29489	421596	172699	83772	75172	104831	117982	30720	161164	237226	302803	157214	58433	163526	19178	50605	60052	38400	308150	52564	711272	232370	15769	343460	79915	100790	355650	29142	98196	19159	155195	614436	57097	15542	218652	193968	38673	155353	14719
1998	109414	24030	143768	62275	1151119	150555	147911	37298	53802	434494	263950	37585	31142	440034	186520	85629	79118	109619	120493	32394	170417	249090	313403	167034	61112	170692	20381	52399	64707	40652	321334	50566	741272	247372	16761	364985	81672	105526	373744	30783	104039	20328	166282	648156	61717	16143	234071	209988	39881	163831	14946
1999	115015	24684	156145	66715	1248006	164835	154708	41341	57728	464773	287725	39224	34302	463400	195099	88697	82643	115418	126357	34613	180996	264740	337639	175778	63993	178605	20874	54223	71428	42027	337918	53060	790079	265463	16958	378814	84642	107742	390617	32383	110707	21194	174940	683578	65851	17218	251056	230752	41854	173620	15771
2000	119020	26853	165912	68809	1362995	181488	169004	44851	60059	497541	306528	41472	38216	491644	205487	94792	86869	114592	133200	37072	192565	289688	351621	191106	65937	188736	21953	57235	77006	45519	363295	55255	833306	277141	17973	395127	91421	117557	408556	34613	115809	22875	181216	741115	70172	18391	268371	237381	42703	182408	17349
2001	122822	28553	172288	70849	1376163	188108	175290	47762	64888	529627	318226	43089	37611	503157	206558	95934	89331	118302	138911	38834	205459	297197	350578	195810	67445	192227	23054	59846	81363	46967	376678	56378	876598	290541	18971	398945	97441	116653	426020	36281	120008	23951	185896	776521	73507	19368	284485	239397	44057	189229	18831
2002	127873	29763	179605	74097	1431267	193068	178017	46985	69060	562431	325863	45581	38897	513947	214497	100221	91952	123039	140451	40520	217004	304012	364465	203521	69231	197222	23983	61940	85647	49091	391565	58372	890612	300834	20263	414216	99459	121204	437895	38349	124902	26793	194846	788944	76063	20250	293065	248879	45410	196373	19293
2003	134388	32039	192685	78774	1523473	198811	183533	48949	72780	595304	340627	49136	40703	531106	225295	106651	96368	128081	155942	42291	227841	315400	376269	216458	73814	205164	25746	66931	91846	51660	408941	63642	905593	312441	22194	428667	105899	127622	456705	40788	131519	28118	204167	833469	79610	21362	310240	258388	46671	204774	21235
2004	146989	35195	204136	85261	1645084	204242	200407	52376	79040	639276	364062	53755	43610	558969	238563	118023	99242	135666	171375	44887	246838	330072	382666	231170	77778	215606	28019	70644	105062	54327	424935	70358	958357	332545	23262	451195	113929	142328	483757	43713	136369	30261	218126	909635	85690	22664	331335	270385	49519	215990	23466
2005	156750	40063	227358	90319	1766693	220454	210170	53247	83586	700267	388342	58573	47176	586442	245197	123353	104884	143875	199683	46277	263809	345059	395166	243933	81678	224091	30637	73455	118785	57282	443148	74403	1023433	357168	24622	467392	125243	147535	506505	45663	143585	31380	227505	990054	94475	23539	359273	296403	53453	226325	27454
2006	164468	44679	248459	94839	1879520	231920	221420	56001	87496	746170	404206	62054	51157	621232	256434	127961	113362	152133	207507	48311	277634	360557	395550	250027	86291	232795	32914	77547	128311	59947	465027	77984	1077891	386914	26414	480097	137584	163564	525979	48011	151084	32520	239017	1088295	106312	24319	379180	316801	56871	235787	32674
2007	169923	49197	262045	97384	1956523	245949	236640	56968	92846	769817	417700	65210	54507	646665	270245	137598	122498	155441	209455	49452	286687	378864	401522	258917	91422	240613	35947	81926	132167	61370	480912	80896	1114698	397063	28887	492925	145693	170941	559876	48044	160145	35165	243001	1179214	115982	24848	392553	345971	58873	243632	36331
2008	172646	55461	256718	99838	1983926	254784	238211	55293	97372	748320	411866	66692	55853	642698	273475	137741	128108	158847	218781	49949	294564	385445	384270	264299	97134	250088	36917	84873	128363	61442	491855	86318	1113446	415095	32495	492745	156398	180934	579432	47343	162266	37246	249052	1243387	116117	25467	398817	354210	62581	244546	42872
2009	168315	50463	242509	98020	1912115	247270	233562	57350	98415	721755	404575	65382	53882	638032	262068	137069	123986	156319	210879	50405	300929	385698	363146	258166	93669	250436	36079	86961	120202	62205	482143	82838	1148407	407846	32489	479526	143648	181022	573964	47709	160439	36687	246541	1166516	113194	25527	407302	348465	63866	244995	37129
2010	174710	54134	245668	102951	1965886	253374	234528	57471	103831	735098	412485	68225	55258	653476	282259	141697	128542	165974	232596	51456	313952	402652	385021	269937	95810	255865	38375	92231	121713	64159	489130	86079	1204688	416008	36202	498989	149913	191120	596662	49351	164106	38176	252478	1243398	117714	26633	420862	359694	67255	252875	39103
2011	180665	58759	254192	107287	2036297	262719	234233	59937	107738	741455	424126	70017	56744	679776	291570	148843	136884	171835	236248	51490	324830	417283	399437	282397	96968	257225	41187	99935	124445	65214	493343	89261	1229743	427974	42164	528567	163868	199929	615411	49716	170193	42253	263175	1344733	124031	27676	429174	370149	70945	262463	41499
2012	185878	60890	264693	109226	2131199	272799	239462	60628	109685	764136	439058	72532	58105	711370	299996	158246	140964	177046	241378	52580	332500	434098	416701	292920	101351	266245	42349	101973	125440	66948	514662	90146	1301041	438350	52493	550299	174305	196973	637896	50997	174567	43056	278298	1437893	128018	28195	441144	388922	70969	272420	40201
2013	190319	59808	270469	114456	2223892	286835	240975	61109	111890	794644	454238	74630	60854	721876	311150	162305	143471	181135	234608	53348	339443	442090	429644	304063	103523	275911	43229	106765	128205	68558	531072	90834	1330236	454945	54965	564683	186007	196594	659792	52187	181556	44560	288012	1536472	133274	28690	449235	405561	72082	281569	40968
2014	194404	58267	280790	117922	2349338	305309	244784	65888	116309	832340	477522	76835	63272	747641	324425	169843	147585	185748	242102	55325	350430	459118	445209	316973	104284	282034	45058	112087	132653	71100	542549	94707	1391086	474482	59627	591485	196767	203326	684781	53725	191168	45470	298865	1614127	140500	29360	459068	425105	74002	290889	41832
2015	199980	53384	291448	118677	2491619	313329	256306	68864	121119	883861	501522	80599	65460	772182	333363	175809	151845	191897	238075	57332	366242	488100	470611	326833	105871	292718	45845	113458	141070	74269	564360	93230	1445611	499741	55927	607326	188011	216522	708402	55650	201831	47073	316659	1611189	149099	30300	481721	446417	73384	301587	39415
2016	204861	50713	302952	120689	2602672	323692	263379	70387	126815	926817	525360	83917	67275	791608	341909	178766	153258	197043	235109	59275	378280	507913	487239	335147	107680	300891	45994	115345	147475	77855	581122	93297	1487998	517904	52089	625715	182937	226821	724936	57433	209716	48139	328770	1616801	156352	31092	494349	469739	73374	309536	37858

See or edit source data.

See or edit source data.

See or edit source data.

League table

Data: A fictional sports league table.

Comments: Several issues are apparent here; some of the columns would benefit from being made unsortable and the display of the true/false values used in the qualification column is poor - the table used on the .tab page uses checkboxes, which is much better. It would also be nice to highlight a row; this would be useful for "Team in season" articles. Module:Sports table can bold rows when used this way.

Table issues:

• No way to set a column as unsortable
• Wide column caused by lack of text wrapping
• Display of true/false values is terrible
• It would be nice to be able to highlight a row
• It would be nice to be able to add wikilinks

Team	Played	Wins	Draws	Losses	Points	Intergalactic Cup qualification
Toronto Triumph	12	10	0	2	20	1
Penzance Pirates	12	8	1	3	17	1
Nice Crocodiles	12	7	0	5	14
Pyongyang Electricity	12	6	0	6	12
New York City Subways	12	3	0	9	6
Melbourne Weather	12	1	1	10	3