Last active
December 14, 2015 06:19
-
-
Save rtanglao/5041773 to your computer and use it in GitHub Desktop.
FF17,FF18,FF19-ff20--top tags first week of Input
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | num | |
|---|---|---|
| crash | 1014 | |
| freeze | 402 | |
| website | 89 | |
| keyboard | 41 | |
| spam | 16 | |
| slowness | 2 | |
| add_ons | 1 | |
| startup | 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | num | |
|---|---|---|
| crash | 195 | |
| freeze | 95 | |
| website | 59 | |
| slowness | 30 | |
| spam | 28 | |
| unknown | 17 | |
| ui_issues | 16 | |
| keyboard | 16 | |
| flash | 13 | |
| plugin | 11 | |
| general | 11 | |
| privacy | 11 | |
| startup | 9 | |
| bookmarks | 5 | |
| memory | 4 | |
| sync | 3 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | num | |
|---|---|---|
| crash | 130 | |
| ui_issues | 129 | |
| unknown | 105 | |
| website | 104 | |
| slowness | 93 | |
| flash | 78 | |
| freeze | 75 | |
| customize | 51 | |
| bookmarks | 36 | |
| keyboard | 36 | |
| general | 28 | |
| add_ons | 20 | |
| sync | 17 | |
| privacy | 17 | |
| spam | 15 | |
| download | 12 | |
| memory | 7 | |
| startup | 5 | |
| plugin | 2 | |
| options | 2 |
you can find the google spreadsheet here:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| manufacturer | device | num | |
|---|---|---|---|
| asus | Nexus 7 | 5 | |
| samsung | GT-I9300 | 4 | |
| samsung | SCH-I535 | 3 | |
| HTC | ADR6350 | 3 | |
| samsung | GT-P3113 | 3 | |
| asus | Transformer TF101 | 3 | |
| HTC | PC36100 | 3 | |
| LGE | Nexus 4 | 3 | |
| samsung | Nexus 10 | 2 | |
| samsung | SGH-S959G | 2 | |
| Yulong | 5860E | 2 | |
| asus | ASUS Transformer Pad TF300T | 2 | |
| unknown | SoftwinerEvb | 2 | |
| HTC | HTC Wildfire S A510e | 2 | |
| samsung | SPH-D710BST | 2 | |
| samsung | GT-N7100 | 2 | |
| samsung | SPH-D710 | 1 | |
| Sony Ericsson | LT28at | 1 | |
| NULL | NULL | 1 | |
| TOSHIBA | AT300SE | 1 | |
| unknown | M701C | 1 | |
| HTC | HTC Sensation | 1 | |
| HTC | Nexus One | 1 | |
| LGE | LS670 | 1 | |
| motorola | XT907 | 1 | |
| samsung | GT-P1010 | 1 | |
| samsung | GT-S7500 | 1 | |
| samsung | SCH-I500 | 1 | |
| samsung | SCH-S720C | 1 | |
| samsung | SPH-D600 | 1 | |
| Sony | ST21i2 | 1 | |
| TOSHIBA | AT100 | 1 | |
| asus | ASUS Transformer Pad TF300TG | 1 | |
| unknown | M1005D | 1 | |
| HKC | P771A | 1 | |
| YIFANG | Next7P12 | 1 | |
| HTC | Desire S | 1 | |
| HTC | HTCEVOV4G | 1 | |
| LGE | LG-MS840 | 1 | |
| motorola | MB860 | 1 | |
| samsung | GT-I9100 | 1 | |
| samsung | GT-N8010 | 1 | |
| samsung | SAMSUNG-SGH-I897 | 1 | |
| samsung | SCH-R920 | 1 | |
| samsung | SHW-M180S | 1 | |
| Sony | SGPT13 | 1 | |
| Sony Ericsson | ST18a | 1 | |
| unknown | M10 | 1 | |
| GT-I9300 | GT-I9300 | 1 | |
| HTC | Desire HD | 1 | |
| LENOVO | IdeaTabA2109A | 1 | |
| motorola | DROID RAZR | 1 | |
| samsung | GT-I9003 | 1 | |
| samsung | GT-N7105 | 1 | |
| samsung | SAMSUNG-SGH-I747 | 1 | |
| samsung | SCH-R530U | 1 | |
| samsung | SGH-T989 | 1 | |
| Sony Ericsson | MT27i | 1 | |
| alps | Micromax A110 | 1 | |
| unknown | GEM7112 | 1 | |
| unknown | M710 | 1 | |
| HTC | ADR6400L | 1 | |
| zte | X500_USA_General | 1 | |
| HTC | HTC Sensation 4G | 1 | |
| samsung | GT-I8160 | 1 | |
| samsung | GT-P3100 | 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| manufacturer | device | num | |
|---|---|---|---|
| asus | Nexus 7 | 16 | |
| samsung | GT-I9300 | 5 | |
| samsung | GT-N7100 | 3 | |
| samsung | Nexus 10 | 3 | |
| Acer | A200 | 3 | |
| samsung | SGH-I747M | 3 | |
| motorola | DROID RAZR | 3 | |
| asus | ASUS Transformer Pad TF300T | 3 | |
| samsung | GT-N8010 | 2 | |
| NULL | NULL | 2 | |
| motorola | DROID2 GLOBAL | 2 | |
| samsung | Galaxy Nexus | 2 | |
| Acer | A500 | 2 | |
| samsung | GT-P7510 | 2 | |
| HTC | EVO | 2 | |
| HTC | HTC Glacier | 2 | |
| ZTE | Blade | 1 | |
| motorola | DROID BIONIC | 1 | |
| motorola | MB855 | 1 | |
| QMobile | A6 | 1 | |
| samsung | GT-I9100G | 1 | |
| samsung | GT-P6200 | 1 | |
| Acer | A700 | 1 | |
| samsung | SAMSUNG-SGH-I547 | 1 | |
| Barnes&Noble | BNTV250 | 1 | |
| samsung | SCH-R720 | 1 | |
| HKC | P771A | 1 | |
| samsung | SGH-T889 | 1 | |
| HTC | HTC Desire HD A9191 | 1 | |
| samsung | SPH-D710BST | 1 | |
| HTC | HTC One X+ | 1 | |
| Sony | ST23i | 1 | |
| HUAWEI | HUAWEI U8815 | 1 | |
| unknown | A13MID | 1 | |
| LENOVO | IdeaTab_A1107 | 1 | |
| unknown | M006-Q | 1 | |
| LGE | LS670 | 1 | |
| MID | Aurora-II | 1 | |
| motorola | XT901 | 1 | |
| samsung | GT-P5113 | 1 | |
| asus | Slider SL101 | 1 | |
| samsung | SCH-I605 | 1 | |
| Hisense | E860 | 1 | |
| samsung | SGH-T679 | 1 | |
| HTC | HTC Desire HD | 1 | |
| samsung | SPH-D710 | 1 | |
| HTC | HTC One X | 1 | |
| Sony | LT30p | 1 | |
| HTC | PC36100 | 1 | |
| TOSHIBA | AT100 | 1 | |
| LENOVO | A1_07 | 1 | |
| unknown | IRULU-AL101 | 1 | |
| LGE | LG-P930 | 1 | |
| YIFANG | Next7P12-8G | 1 | |
| LGE | VS920 4G | 1 | |
| ZTE | ZTE-Z990G | 1 | |
| motorola | DROID RAZR HD | 1 | |
| Motorola | XOOM 2 ME | 1 | |
| rockchip | MK808 | 1 | |
| samsung | GT-P5110 | 1 | |
| samsung | SCH-I535 | 1 | |
| Dell Inc. | Dell Streak 7 | 1 | |
| samsung | SGH-T999 | 1 | |
| Smartfren | Andromax U | 1 | |
| HTC | HTCEVOV4G | 1 | |
| Sony Ericsson | ST25i | 1 | |
| kyocera | C5170 | 1 | |
| unknown | iBall i6012 | 1 | |
| LGE | LG-P925 | 1 | |
| unknown | PLAIM900HC | 1 | |
| ZTE | ZTE-N910 | 1 | |
| motorola | MZ601 | 1 | |
| rockchip | MID | 1 | |
| samsung | GT-I9100P | 1 | |
| samsung | GT-N8013 | 1 | |
| Acer | A100 | 1 | |
| Samsung | GT-P6800 | 1 | |
| samsung | SAMSUNG-SGH-I747 | 1 | |
| Dell Inc. | Dell Streak | 1 | |
| samsung | SGH-I317M | 1 | |
| HTC | ADR6330VW | 1 | |
| samsung | SGH-T989 | 1 | |
| HTC | HTC Desire X | 1 | |
| samsung | SPH-L710 | 1 | |
| HTC | HTC Sensation | 1 | |
| Sony Ericsson | LT28at | 1 | |
| huawei | Prism | 1 | |
| unknown | cm_tenderloin | 1 | |
| LENOVO | ThinkPad Tablet | 1 | |
| unknown | M1050S | 1 | |
| LGE | Nexus 4 | 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| manufacturer | device | num | |
|---|---|---|---|
| asus | Nexus 7 | 5 | |
| samsung | GT-N8013 | 3 | |
| samsung | GT-P3100 | 3 | |
| TOSHIBA | AT100 | 2 | |
| ZTE | N860 | 2 | |
| LGE | LG-LS970 | 2 | |
| samsung | GT-I9300 | 2 | |
| samsung | SCH-I800 | 2 | |
| asus | ASUS Transformer Pad TF300T | 2 | |
| samsung | Nexus S | 2 | |
| motorola | DROID RAZR HD | 2 | |
| motorola | DROID RAZR | 2 | |
| samsung | Nexus 10 | 2 | |
| samsung | SAMSUNG-SGH-I997 | 1 | |
| samsung | SCH-S720C | 1 | |
| samsung | SPH-D710BST | 1 | |
| unknown | T02A | 1 | |
| NULL | NULL | 1 | |
| HTC | myTouch_4G_Slide | 1 | |
| LGE | S100(XtremeFlare) | 1 | |
| motorola | MB860 | 1 | |
| samsung | GT-S7562 | 1 | |
| samsung | SAMSUNG-SGH-I847 | 1 | |
| samsung | SPH-D710 | 1 | |
| Sony Ericsson | MT27i | 1 | |
| unknown | SoftwinerEvb | 1 | |
| Yulong | 5860E | 1 | |
| HTC | HTC Sensation | 1 | |
| kyocera | C5170 | 1 | |
| LGE | Nexus 4 | 1 | |
| motorola | MB855 | 1 | |
| samsung | GT-I9070 | 1 | |
| samsung | GT-N8010 | 1 | |
| samsung | GT-P7510 | 1 | |
| samsung | SCH-I605 | 1 | |
| samsung | SGH-T999 | 1 | |
| samsung | YP-G70 | 1 | |
| unknown | Micromax P500(Funbook) | 1 | |
| unknown | X708S | 1 | |
| alps | X401 | 1 | |
| HTC | HTC One X | 1 | |
| HUAWEI | MediaPad 10 FHD | 1 | |
| lge | LG-P990 | 1 | |
| samsung | Galaxy Nexus | 1 | |
| samsung | GT-N7000 | 1 | |
| samsung | GT-P5110 | 1 | |
| samsung | SCH-I535 | 1 | |
| samsung | SGH-T989 | 1 | |
| samsung | SPH-L710 | 1 | |
| unknown | M10 | 1 | |
| unknown | TOUCHMATE | 1 | |
| Acer | A500 | 1 | |
| bn | NookColor | 1 | |
| huawei | Huawei U8800-51 | 1 | |
| LGE | LG-MS840 | 1 | |
| motorola | XT907 | 1 | |
| samsung | GT-I9300T | 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT tc.manufacturer, tc.device, count(distinct(ti.comment_id)) as num | |
| FROM input_comments.tags t | |
| JOIN input_comments.tag_items ti ON ti.tag_id = t.id | |
| JOIN input_comments.comments tc ON ti.comment_id = tc.id | |
| WHERE | |
| tc.created > "2013-02-19" | |
| AND tc.created < "2013-02-25" | |
| AND t.name = 'freeze' | |
| AND tc.version = "19.0" | |
| GROUP BY tc.manufacturer, tc.device ORDER BY num DESC; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT t.name, count(distinct(ti.comment_id)) as num | |
| FROM input_comments.tags t | |
| JOIN input_comments.tag_items ti ON ti.tag_id = t.id | |
| JOIN input_comments.comments tc ON ti.comment_id = tc.id | |
| WHERE | |
| tc.created > "2013-04-02" | |
| AND tc.created < "2013-04-08" | |
| AND tc.version = "20.0.0" | |
| GROUP BY t.name ORDER BY num DESC; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | num | |
|---|---|---|
| ui_issues | 418 | |
| website | 234 | |
| unknown | 135 | |
| customize | 113 | |
| crash | 111 | |
| slowness | 106 | |
| freeze | 99 | |
| video_codecs | 98 | |
| bookmarks | 72 | |
| general | 67 | |
| flash | 57 | |
| keyboard | 38 | |
| privacy | 36 | |
| add_ons | 27 | |
| download | 24 | |
| sync | 20 | |
| spam | 10 | |
| plugin | 5 | |
| memory | 3 | |
| options | 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
My Mobile is Samsung S2 - Jelly Bean
*Website is loading slow
Not Crashed...