We're updating the issue view to help you get more done. 

Expose statistics about tag usage to the wider world.

Description

Fans and journalists are interested in what works are being created and what works are being deleted.

We want to dump the tags associated with all works created on all days . if this is run repeatedly then as well as each dump giving you what new works where created in a month by comparing two dumps you can see what tags were used on the works which have been deleted and which day the deleted works were created on.

The file format should have the day number starting from the last full day, it should display the start time and stop time of the period with timezone information, It should include the day of the week so that information is easily exposed.

Additionally the first line of the day should list the number of works created.

otherwise the type of tag and the name of the tag and the tag id, followed by how many works used that tag.

eg

1 2 3 4 5 6 7 Created_at,language,restricted,complete,word_count,tags 2019-06-25,en,false,true,2175,11+10081061+25228206+29853308+29853296+29853287+29853206+9874783+742970+32849923+1276510+32849926+32849929+32849932+116+16 2019-06-25,en,false,false,1395,12+136512+36704+10760+3548+1048+1803+2211+3725+3726+1589+2174+12261+4060892+882015+17019+16 2019-06-25,zh,false,true,4756,13+27251507+575567+3379967+197870+25081+32849941+32849944+32849947+32849950+23+14 2019-06-25,en,false,true,1050,10+27251507+575567+197870+25081+234149+110+135453+1582+32849959+23+16 2019-06-25,en,false,false,1107,11+414093+1001939+10801369+5466945+1936694+14153618+727283+9794104+32197+7270007+19564+7269+8594914+17053086+3175+74988+8777869+58423+7254251+7262858+8055451+7347962+17723082+9970+128980+11872312+54767+1052507+9685564+31179232+32849962+827327+15016+604127+14 2019-06-25,en,false,true,100,10+414093+7269+479641+21+16

 

 

1 2 3 4 5 6 7 8 count_of_days,to,from,day_of_week,tag_type,tag_ids,count 1,2019-06-27T00:00:00+00:00,2019-06-26T00:00:00+00:00,Wednesday,works,all_works,3191 1,2019-06-27T00:00:00+00:00,2019-06-26T00:00:00+00:00,Wednesday,category,116,290 1,2019-06-27T00:00:00+00:00,2019-06-26T00:00:00+00:00,Wednesday,category,23,1703 1,2019-06-27T00:00:00+00:00,2019-06-26T00:00:00+00:00,Wednesday,category,21,452 1,2019-06-27T00:00:00+00:00,2019-06-26T00:00:00+00:00,Wednesday,category,2246,166 1,2019-06-27T00:00:00+00:00,2019-06-26T00:00:00+00:00,Wednesday,category,22,755 1,2019-06-27T00:00:00+00:00,2019-06-26T00:00:00+00:00,Wednesday,category,24,123

 

 

1 2 3 4 5 6 7 8 9 10 id,type,name,canonical,cached_count,adult,merger_id,unwrangleable 1,Media,TV Shows,true,570,false,,false 2,Media,Movies,true,828,false,,false 3,Media,Books & Literature,true,91,false,,false 4,Media,Cartoons & Comics & Graphic Novels,true,94,false,,false 5,Media,Anime & Manga,true,296,false,,false 6,Media,Music & Bands,true,6,false,,false 7,Media,Celebrities & Real People,true,6,false,,false 8,Media,Other Media,true,1,false,,false 9,Rating,Not Rated,true,539531,true,,false

 

Environment

None

Status

Assignee

james_

Reporter

james_

Roadmap

Misc

Priority

Low

Affects versions

0.9.247

Fix versions

None

Components

BackEnd

Difficulty

Medium

Required Access Level

None

Milestone

Internal 0.9