scala> spark.sql(""" | SELECT | user_agent_map['os_family'], | user_agent_map['os_major'], | user_agent_map['os_minor'], | user_agent_map['browser_family'], | user_agent_map['browser_major'], | user_agent_map['device_family'], | user_agent_map['wmf_app_version'], | count(1) as c | FROM event.wdqs_external_sparql_query | WHERE year = 2020 and month = 9 | AND http.request_headers['referer'] IS NOT NULL | GROUP BY | user_agent_map['os_family'], | user_agent_map['os_major'], | user_agent_map['os_minor'], | user_agent_map['browser_family'], | user_agent_map['browser_major'], | user_agent_map['device_family'], | user_agent_map['wmf_app_version'] | ORDER BY c DESC | LIMIT 100 | """).show(100, false) +-------------------------+------------------------+------------------------+------------------------------+-----------------------------+-----------------------------+-------------------------------+-------+ |user_agent_map[os_family]|user_agent_map[os_major]|user_agent_map[os_minor]|user_agent_map[browser_family]|user_agent_map[browser_major]|user_agent_map[device_family]|user_agent_map[wmf_app_version]|c | +-------------------------+------------------------+------------------------+------------------------------+-----------------------------+-----------------------------+-------------------------------+-------+ |Windows |10 |- |Chrome |73 |Other |- |1690663| |Windows |10 |- |Chrome |85 |Other |- |753111 | |Other |- |- |Other |- |Other |- |486526 | |Windows |10 |- |Firefox |80 |Other |- |285634 | |Windows |10 |- |Chrome |84 |Other |- |136353 | |Windows |10 |- |Firefox |78 |Other |- |121373 | |Mac OS X |10 |15 |Chrome |85 |Other |- |120678 | |Ubuntu |- |- |Firefox |80 |Other |- |110760 | |Mac OS X |10 |15 |Safari |13 |Other |- |89806 | |Windows |10 |- |Chrome |46 |Other |- |85122 | |Windows |10 |- |Edge |85 |Other |- |83367 | |Windows |7 |- |Firefox |80 |Other |- |71384 | |Mac OS X |10 |14 |Chrome |85 |Other |- |66144 | |Windows |7 |- |Chrome |85 |Other |- |65123 | |Windows |10 |- |Firefox |81 |Other |- |54884 | |Other |- |- |Scrapy |3 |Spider |- |47688 | |Linux |- |- |Chrome |85 |Other |- |44420 | |Mac OS X |10 |15 |Chrome |84 |Other |- |40261 | |Mac OS X |10 |12 |Chrome |85 |Other |- |38547 | |Mac OS X |10 |15 |Firefox |80 |Other |- |35330 | |iOS |13 |6 |Mobile Safari |13 |iPhone |- |31131 | |Windows |10 |- |Opera |70 |Other |- |30945 | |iOS |13 |7 |Mobile Safari |13 |iPhone |- |25408 | |Chrome OS |13099 |110 |Chrome |84 |Other |- |24636 | |Chrome OS |13310 |76 |Chrome |85 |Other |- |21726 | |Windows |10 |- |Firefox |79 |Other |- |21563 | |Windows |10 |- |Edge |87 |Other |- |21123 | |iOS |7 |0 |BingPreview |1 |Spider |- |18331 | |Mac OS X |10 |15 |Safari |14 |Other |- |17684 | |Linux |- |- |Chrome |84 |Other |- |17184 | |Windows |8 |1 |Chrome |85 |Other |- |16865 | |Linux |- |- |Firefox |80 |Other |- |15634 | |Windows |10 |- |Chrome |83 |Other |- |15406 | |Linux |- |- |Firefox |66 |Other |- |14999 | |Mac OS X |10 |13 |Chrome |85 |Other |- |14492 | |Linux |- |- |Chrome |83 |Other |- |14373 | |Chrome OS |13310 |59 |Chrome |85 |Other |- |14209 | |Mac OS X |10 |14 |Firefox |80 |Other |- |13520 | |Windows |7 |- |Chrome |84 |Other |- |13372 | |Windows |8 |1 |Firefox |80 |Other |- |12806 | |Linux |- |- |Firefox |73 |Other |- |12641 | |iOS |14 |0 |Mobile Safari |14 |iPhone |- |12372 | |Mac OS X |10 |14 |Chrome |84 |Other |- |11907 | |Mac OS X |10 |13 |Firefox |80 |Other |- |11637 | |Android |10 |- |Chrome Mobile |85 |Generic Smartphone |- |11352 | |Windows |7 |- |Firefox |81 |Other |- |11273 | |Windows |10 |- |Firefox |68 |Other |- |10201 | |Android |10 |- |MiuiBrowser |12 |Generic Smartphone |- |9953 | |Windows |7 |- |Yandex Browser |20 |Other |- |9415 | |Mac OS X |10 |14 |Safari |13 |Other |- |9303 | |Linux |- |- |Firefox |78 |Other |- |9187 | |Windows |10 |- |Edge |86 |Other |- |7969 | |Windows |XP |- |Chrome |49 |Other |- |7705 | |Linux |- |- |Chrome |45 |Other |- |7638 | |Linux |- |- |HeadlessChrome |83 |Other |- |7579 | |Linux |- |- |Firefox |68 |Other |- |7425 | |Mac OS X |10 |13 |Chrome |84 |Other |- |7173 | |iOS |12 |4 |Mobile Safari |12 |iPad |- |7000 | |Android |5 |1 |Chrome Mobile WebView |50 |wv |- |6965 | |Linux |- |- |Firefox |60 |Other |- |6912 | |Windows |10 |- |Chrome |81 |Other |- |6611 | |Ubuntu |- |- |Firefox |81 |Other |- |6452 | |Windows |10 |- |Yandex Browser |20 |Other |- |6430 | |Android |9 |- |Chrome Mobile |85 |Generic Smartphone |- |6422 | |Windows |10 |- |Edge |18 |Other |- |6242 | |iOS |12 |4 |Mobile Safari |12 |iPhone |- |6213 | |iOS |13 |5 |Mobile Safari |13 |iPhone |- |6167 | |Mac OS X |10 |10 |Firefox |78 |Other |- |6152 | |Ubuntu |- |- |Firefox |79 |Other |- |5979 | |Android |9 |- |Chrome Mobile |85 |XiaoMi Redmi Note 7 |- |5645 | |Android |5 |1 |Amazon Silk |84 |Kindle |- |5481 | |Mac OS X |10 |13 |Safari |13 |Other |- |5382 | |Other |- |- |UptimeRobot |2 |Spider |- |5376 | |Mac OS X |10 |14 |Firefox |68 |Other |- |5358 | |Mac OS X |10 |11 |Safari |11 |Other |- |5275 | |Mac OS X |10 |10 |Firefox |76 |Other |- |5248 | |Mac OS X |10 |15 |Firefox |81 |Other |- |5233 | |Android |10 |- |Firefox Mobile |80 |Generic Smartphone |- |4756 | |Windows |10 |- |Firefox |76 |Other |- |4527 | |Mac OS X |10 |12 |Firefox |80 |Other |- |4431 | |Android |5 |0 |Chrome Mobile |80 |Huawei ALE-L21 |- |4258 | |Chrome OS |13020 |87 |Chrome |83 |Other |- |4215 | |Mac OS X |10 |14 |Safari |12 |Other |- |3818 | |Mac OS X |10 |15 |Firefox |79 |Other |- |3760 | |Windows |7 |- |BingPreview |1 |Spider |- |3732 | |Windows |8 |1 |Firefox |81 |Other |- |3682 | |Mac OS X |10 |11 |Firefox |78 |Other |- |3664 | |Android |10 |- |Chrome Mobile |85 |Huawei POT-LX1 |- |3523 | |Windows |7 |- |Firefox |74 |Other |- |3495 | |Mac OS X |10 |11 |Chrome |85 |Other |- |3469 | |Android |9 |- |Chrome Mobile |85 |Huawei ANE-LX1 |- |3442 | |Linux |- |- |Firefox |81 |Other |- |3401 | |Windows |7 |- |Opera |70 |Other |- |3322 | |Android |7 |1 |Chrome |70 |KFKAWI |- |3296 | |Windows |10 |- |Edge |84 |Other |- |3237 | |Mac OS X |10 |14 |Chrome |77 |Other |- |3179 | |Other |- |- |YandexAccessibilityBot |3 |Spider |- |3170 | |Fedora |- |- |Firefox |81 |Other |- |3162 | |Fedora |- |- |Firefox |80 |Other |- |3127 | |Android |9 |- |Samsung Internet |12 |Samsung SM-G955F |- |3105 | +-------------------------+------------------------+------------------------+------------------------------+-----------------------------+-----------------------------+-------------------------------+-------+ scala> spark.sql(""" | SELECT | user_agent_map['os_family'], | user_agent_map['os_major'], | user_agent_map['os_minor'], | user_agent_map['browser_family'], | user_agent_map['browser_major'], | user_agent_map['device_family'], | user_agent_map['wmf_app_version'], | count(1) as c | FROM event.wdqs_external_sparql_query | WHERE year = 2020 and month = 9 | AND http.request_headers['referer'] IS NULL | GROUP BY | user_agent_map['os_family'], | user_agent_map['os_major'], | user_agent_map['os_minor'], | user_agent_map['browser_family'], | user_agent_map['browser_major'], | user_agent_map['device_family'], | user_agent_map['wmf_app_version'] | ORDER BY c DESC | LIMIT 100 | """).show(100, false) +-------------------------+------------------------+------------------------+-----------------------------------+-----------------------------+-----------------------------+-------------------------------+--------+ |user_agent_map[os_family]|user_agent_map[os_major]|user_agent_map[os_minor]|user_agent_map[browser_family] |user_agent_map[browser_major]|user_agent_map[device_family]|user_agent_map[wmf_app_version]|c | +-------------------------+------------------------+------------------------+-----------------------------------+-----------------------------+-----------------------------+-------------------------------+--------+ |Other |- |- |Other |- |Other |- |78600280| |Linux |- |- |Other |- |Other |- |18838663| |Other |- |- |LaylaAiBot |0 |Spider |- |11750656| |Mac OS X |10 |11 |Chrome |50 |Other |- |7009087 | |Other |- |- |ChicoBot |- |Spider |- |4491646 | |Other |- |- |2020-04 Pywikibot |3 |Spider |- |4292446 | |Other |- |- |bbw-bot |- |Spider |- |3836192 | |Other |- |- |Java |8 |Spider |- |3425339 | |Other |- |- |Python Requests |2 |Other |- |3409229 | |Other |- |- |Other |- |Generic Feature Phone |- |2367944 | |Other |- |- |catbot |0 |Spider |- |1958809 | |Android |6 |0 |Googlebot |2 |Spider |- |1857571 | |Other |- |- |Python/3.7 aiohttp |3 |Other |- |1559899 | |Other |- |- |NOS-Wikidata-Enricher-bot |0 |Spider |- |1249657 | |Other |- |- |Python/3.6 aiohttp |3 |Other |- |1190828 | |Linux |- |- |Chrome |23 |Other |- |1028144 | |Other |- |- |find_conse_on_chorg Pywikibot |4 |Spider |- |990586 | |Windows |10 |- |Chrome |74 |Other |- |899503 | |Other |- |- |curl |7 |Other |- |826016 | |Linux |- |- |Chrome |40 |Other |- |816609 | |Other |- |- |Googlebot |2 |Spider |- |527547 | |Other |- |- |Inkbot |0 |Spider |- |527026 | |Windows |10 |- |Firefox |78 |Other |- |526744 | |Windows |10 |- |Chrome |70 |Other |- |510505 | |Other |- |- |b2 Pywikibot |3 |Spider |- |454144 | |Other |- |- |Apache-HttpClient |4 |Other |- |451895 | |Other |- |- |QueryBot |0 |Spider |- |390839 | |Windows |7 |- |Chrome |75 |Other |- |374700 | |Linux |- |- |Firefox |12 |Other |- |303200 | |Other |- |- |app Pywikibot |3 |Spider |- |282209 | |Other |- |- |got |- |Other |- |272502 | |Windows |7 |- |Firefox |3 |Other |- |254822 | |Other |- |- |Go-http-client |2 |Other |- |239773 | |Windows |8 |- |Chrome |74 |Other |- |238086 | |Other |- |- |gov bot |- |Spider |- |236762 | |Windows |8 |- |Chrome |24 |Other |- |204083 | |iOS |3 |2 |Mobile Safari UI/WKWebView |3 |iPad |- |203376 | |Mac OS X |10 |8 |Chrome |27 |Other |- |196771 | |Other |- |- |efre-lod-enrich-wikidata-bot |0 |Spider |- |195853 | |Windows |10 |- |Chrome |80 |Other |- |189989 | |Other |- |- |AhrefsBot |7 |Spider |- |189124 | |Other |- |- |Other |- |Spider |- |181872 | |Other |- |- |new3 Pywikibot |3 |Spider |- |174841 | |Other |- |- |libwww-perl |6 |Generic Feature Phone |- |174432 | |Other |- |- |okhttp |4 |Other |- |163579 | |Other |- |- |descripciones Pywikibot |3 |Spider |- |160633 | |Windows |10 |- |Chrome |85 |Other |- |158091 | |Other |- |- |TaxonBot |1 |Spider |- |145117 | |Windows |XP |- |IE |6 |Other |- |138882 | |Mac OS X |10 |15 |Chrome |85 |Other |- |124160 | |Windows |7 |- |Chrome |69 |Other |- |120603 | |Other |- |- |commonscat_copy_from_P373 Pywikibot|3 |Spider |- |110882 | |Other |- |- |YandexBot |3 |Spider |- |109018 | |Windows |7 |- |Yeti |1 |Spider |- |108398 | |Windows |10 |- |Firefox |66 |Other |- |107383 | |Windows |7 |- |Chrome |24 |Other |- |102333 | |Windows |7 |- |Chrome |22 |Other |- |102079 | |Windows |8 |- |Chrome |23 |Other |- |102070 | |Mac OS X |10 |11 |Chrome |53 |Other |- |101706 | |Mac OS X |10 |8 |Chrome |24 |Other |- |101535 | |Other |- |- |connect_day_events Pywikibot |4 |Spider |- |90062 | |Other |- |- |ipykernel_launcher Pywikibot |4 |Spider |- |85557 | |Other |- |- |io wiki-crawler |0 |Spider |- |84349 | |Windows |XP |- |Firefox |2 |Other |- |81181 | |Windows |10 |- |Chrome |73 |Other |- |70452 | |Windows |7 |- |Firefox |35 |Other |- |68687 | |Linux |- |- |Firefox |79 |Other |- |60238 | |Other |- |- |Python-urllib |3 |Spider |- |59833 | |Other |- |- |axios |0 |Other |- |58257 | |Windows |10 |- |Firefox |80 |Other |- |53842 | |Mac OS X |10 |13 |Safari |11 |Other |- |52825 | |Windows |7 |- |Chrome |20 |Other |- |51822 | |Windows |8 |- |Chrome |20 |Other |- |51712 | |Windows |8 |- |Chrome |22 |Other |- |51525 | |Windows |8 |- |Chrome |19 |Other |- |51513 | |Mac OS X |10 |8 |Chrome |23 |Other |- |51083 | |Windows |10 |- |Chrome |65 |Other |- |50958 | |Chrome OS |2268 |111 |Chrome |20 |Other |- |50929 | |Mac OS X |10 |13 |Chrome |66 |Other |- |50822 | |Windows |10 |- |Firefox |59 |Other |- |50820 | |Mac OS X |10 |6 |Chrome |22 |Other |- |50735 | |Mac OS X |10 |7 |Chrome |24 |Other |- |50701 | |Windows |8 |1 |Chrome |37 |Other |- |50503 | |Mac OS X |10 |13 |Yandex Browser |18 |Other |- |50478 | |Linux |- |- |Chrome |19 |Other |- |50312 | |Other |- |- |bbbw-bot |- |Spider |- |48404 | |Windows |7 |- |BingPreview |1 |Spider |- |48329 | |Other |- |- |TrpIndexer |0 |Spider |- |48162 | |Other |- |- |dbbw-bot |- |Spider |- |48156 | |Other |- |- |abbw-bot |- |Spider |- |48096 | |Other |- |- |wbbw-bot |- |Spider |- |48063 | |Other |- |- |qbbw-bot |- |Spider |- |48007 | |Other |- |- |cbbw-bot |- |Spider |- |47951 | |Other |- |- |ubbw-bot |- |Spider |- |47932 | |Other |- |- |obbw-bot |- |Spider |- |47891 | |Other |- |- |lbbw-bot |- |Spider |- |47826 | |Other |- |- |hbbw-bot |- |Spider |- |47812 | |Other |- |- |xbbw-bot |- |Spider |- |47807 | |Other |- |- |nbbw-bot |- |Spider |- |47802 | |Other |- |- |tbbw-bot |- |Spider |- |47783 | +-------------------------+------------------------+------------------------+-----------------------------------+-----------------------------+-----------------------------+-------------------------------+--------+ scala> scala> scala> scala> scala> scala> spark.sql(""" | SELECT | user_agent_map['os_family'], | user_agent_map['os_major'], | user_agent_map['os_minor'], | user_agent_map['browser_family'], | user_agent_map['browser_major'], | user_agent_map['device_family'], | user_agent_map['wmf_app_version'], | count(1) as c, | http.request_headers['user-agent'] | FROM event.wdqs_external_sparql_query | WHERE year = 2020 and month = 9 | AND http.request_headers['referer'] IS NULL | GROUP BY | http.request_headers['user-agent'], | user_agent_map['os_family'], | user_agent_map['os_major'], | user_agent_map['os_minor'], | user_agent_map['browser_family'], | user_agent_map['browser_major'], | user_agent_map['device_family'], | user_agent_map['wmf_app_version'] | ORDER BY c DESC | LIMIT 100 | """).show(100, false) +-------------------------+------------------------+------------------------+------------------------------+-----------------------------+-----------------------------+-------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |user_agent_map[os_family]|user_agent_map[os_major]|user_agent_map[os_minor]|user_agent_map[browser_family]|user_agent_map[browser_major]|user_agent_map[device_family]|user_agent_map[wmf_app_version]|c |http.request_headers AS `request_headers`[user-agent] | +-------------------------+------------------------+------------------------+------------------------------+-----------------------------+-----------------------------+-------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |Linux |- |- |Other |- |Other |- |17944099|covid-19-open-data/0.0 (linux-gnu) | |Other |- |- |Other |- |Other |- |12025423|Twisted PageGetter | |Other |- |- |LaylaAiBot |0 |Spider |- |11750656|LaylaAiBot/0.1 (https://johnpaulvaughan.github.io/layla/; johnpaulvaughan@hotmail.com) | |Other |- |- |Other |- |Other |- |11270847|Toolforge - mix-n-match | |Other |- |- |Other |- |Other |- |10786415|TakeItPersonally\, https://github.com/foerstner-lab/TIP-lib\, seidlmayer@zbmed.de | |Mac OS X |10 |11 |Chrome |50 |Other |- |6065523 |Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/50.0.2661.102 Safari/537.36 | |Other |- |- |Other |- |Other |- |5243807 |SAP/1.0 | |Other |- |- |Other |- |Other |- |4649238 |Python/vita (+https://suggap.com) | |Other |- |- |ChicoBot |- |Spider |- |4491645 |ChicoBot Test agent | |Other |- |- |2020-04 Pywikibot |3 |Spider |- |4292446 |2020-04 Pywikibot/3.1.dev0 (-1 (unknown)) requests/2.21.0 Python/3.6.8.final.0 | |Other |- |- |Other |- |Other |- |3533374 |admin@justinmaltais.com | |Other |- |- |Java |8 |Spider |- |3412463 |Java/1.8.0_265 | |Other |- |- |Other |- |Other |- |3038928 |sparqlwrapper 1.8.5 (rdflib.github.io/sparqlwrapper) | |Other |- |- |Other |- |Other |- |2848121 |wikidataintegrator/0.4.6 | |Other |- |- |bbw-bot |- |Spider |- |2383182 |bbw-bot | |Other |- |- |Other |- |Other |- |2364482 |WDQS-example Python/3.7 | |Other |- |- |Other |- |Generic Feature Phone |- |2266618 |https://github.com/bearloga/WikidataQueryServiceR | |Other |- |- |catbot |0 |Spider |- |1958809 |catbot/0.0 (https://github.com/ghuron/wdpy; https://www.wikidata.org/wiki/User:Ghuron) | |Other |- |- |Python Requests |2 |Other |- |1848434 |python-requests/2.22.0 | |Other |- |- |Other |- |Other |- |1724435 |Toolforge - FileCandidates | |Other |- |- |Python/3.7 aiohttp |3 |Other |- |1559899 |Python/3.7 aiohttp/3.6.2 | |Other |- |- |Other |- |Other |- |1513674 |WDQS-example Python/3.6 | |Other |- |- |Other |- |Other |- |1420969 |Apache-Jena-ARQ/3.14.0 | |Other |- |- |Other |- |Other |- |1415927 |WDQS-example Python/3.8 | |Other |- |- |Other |- |Other |- |1317956 |Toolforge - legacy code | |Other |- |- |Other |- |Other |- |1281881 |Lokadata | |Other |- |- |NOS-Wikidata-Enricher-bot |0 |Spider |- |1249657 |NOS-Wikidata-Enricher-bot/0.5.1 (alexandre.carvalho@parceiros.nos.pt) node-fetch-with-proxy/0.1.2 | |Other |- |- |Python/3.6 aiohttp |3 |Other |- |1190828 |Python/3.6 aiohttp/3.6.2 | |Other |- |- |Other |- |Other |- |1113379 |Drupal (+http://drupal.org/) | |Linux |- |- |Chrome |23 |Other |- |1016783 |Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML\, like Gecko) Chrome/23.0.1271.64 Safari/537.11 | |Other |- |- |Other |- |Other |- |999491 |check_http/v2.2 (monitoring-plugins 2.2) | |Other |- |- |find_conse_on_chorg Pywikibot |4 |Spider |- |990586 |find_conse_on_chorg Pywikibot/4.1.1 (-1 (unknown)) requests/2.22.0 Python/3.8.2.final.0 | |Mac OS X |10 |11 |Chrome |50 |Other |- |943563 |tmdh78@naver.com Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/50.0.2661.102 Safari/537.36 | |Windows |10 |- |Chrome |74 |Other |- |899335 |Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/74.0.3729.169 Safari/537.36 | |Linux |- |- |Chrome |40 |Other |- |816604 |Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.12 (KHTML\, like Gecko) Chrome/40.0.1271.64 Safari/537.12 | |Android |6 |0 |Googlebot |2 |Spider |- |691091 |Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/85.0.4183.105 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)| |Other |- |- |Other |- |Other |- |648734 |Scholia | |Other |- |- |Other |- |Other |- |539903 |sparqlwrapper 1.8.2 (rdflib.github.io/sparqlwrapper) | |Linux |- |- |Other |- |Other |- |538605 |Needle/0.9.2 (Node.js v8.11.1; linux x64) | |Other |- |- |Other |- |Other |- |538347 |@kartotherian/geoshapes/1.1.2-wmf.0 (https://mediawiki.org/Maps) | |Other |- |- |Inkbot |0 |Spider |- |527026 |Inkbot/0.1 (www.customink.com) Ruby/0.1 | |Windows |10 |- |Firefox |78 |Other |- |521107 |Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0 | |Windows |10 |- |Chrome |70 |Other |- |510466 |Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/70.0.3538.77 Safari/537.36 | |Other |- |- |Other |- |Other |- |462518 |Mia Test agent | |Other |- |- |b2 Pywikibot |3 |Spider |- |454144 |b2 Pywikibot/3.1.dev0 (g11760) requests/2.21.0 Python/3.5.3.final.0 | |Other |- |- |Other |- |Other |- |451754 |Ruby SPARQL::Client/3.1.0 | |Android |6 |0 |Googlebot |2 |Spider |- |442853 |Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/85.0.4183.93 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) | |Other |- |- |Python Requests |2 |Other |- |441441 |python-requests/2.24.0 | |Other |- |- |Other |- |Other |- |411059 |I don't want to DDOS\, this is part of my research project\, it will not be long. Email is issue at guillaume DOT bernard AT univ DASH lr DOT fr | |Other |- |- |QueryBot |0 |Spider |- |390839 |QueryBot/0.1 (alement+wikidata@gmail.com) | |Other |- |- |curl |7 |Other |- |382342 |curl/7.35.0 | |Other |- |- |Other |- |Other |- |379599 |wikidataintegrator/0.6.5 | |Windows |7 |- |Chrome |75 |Other |- |374667 |Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/75.0.3770.100 Safari/537.36 | |Other |- |- |Other |- |Other |- |357235 |/(tim@timakro.de) Python requests/2.24.0 | |Other |- |- |Other |- |Other |- |353038 |wikidataintegrator/0.6.0 | |Other |- |- |Other |- |Other |- |333133 |MyCoolTool/0.1 dlworb1994@yonsei.ac.kr | |Other |- |- |Other |- |Other |- |326718 |Apache-Jena-ARQ/3.5.0 | |Other |- |- |Python Requests |2 |Other |- |326555 |python-requests/2.23.0 | |Android |6 |0 |Googlebot |2 |Spider |- |322835 |Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/85.0.4183.122 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)| |Linux |- |- |Firefox |12 |Other |- |303107 |User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:12.0) Gecko/20100101 Firefox/12.0 | |Other |- |- |Other |- |Other |- |288187 |Jersey/2.30.1 (HttpUrlConnection 11.0.7) | |Linux |- |- |Other |- |Other |- |286969 |rest-client/2.0.2 (linux-gnu x86_64) ruby/2.5.8p224 | |Android |6 |0 |Googlebot |2 |Spider |- |280885 |Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/85.0.4183.113 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)| |Other |- |- |Python Requests |2 |Other |- |272861 |python-requests/2.18.4 | |Other |- |- |got |- |Other |- |272502 |got (https://github.com/sindresorhus/got) | |Other |- |- |Other |- |Other |- |262324 |Recoin/1.0 (https://www.wikidata.org/wiki/Wikidata:Recoin; balaraman@fbk.eu) | |Windows |7 |- |Firefox |3 |Other |- |254819 |Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 | |Other |- |- |Other |- |Other |- |249229 |wikidataintegrator/0.4.2 | |Other |- |- |Python Requests |2 |Other |- |247138 |python-requests/2.21.0 | |Other |- |- |Go-http-client |2 |Other |- |239773 |Go-http-client/2.0 | |Windows |8 |- |Chrome |74 |Other |- |238086 |Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/74.0.3729. 169 Safari/537.36 | |Other |- |- |gov bot |- |Spider |- |236762 |Library of Congress id.loc.gov bot | |Other |- |- |Other |- |Other |- |235313 |Jersey/2.30.1 (HttpUrlConnection 11.0.8) | |Other |- |- |Other |- |Other |- |211112 |ChemAxon-Marvin/20.15.0 | |Other |- |- |Other |- |Other |- |207616 |Jakarta Commons-HttpClient/3.1 | |Other |- |- |Other |- |Other |- |204339 |Apache-Jena-ARQ/2.13.0 | |iOS |3 |2 |Mobile Safari UI/WKWebView |3 |iPad |- |203376 |Mozilla/5.0 (iPad; U; CPU OS 3_2_1 like Mac OS X; en-us) AppleWebKit/531.21.10 (KHTML\, like Gecko) Mobile/7B405 | |Other |- |- |app Pywikibot |3 |Spider |- |203240 |app Pywikibot/3.1.dev0 (-1 (unknown)) requests/2.24.0 Python/3.6.8.final.0 | |Other |- |- |efre-lod-enrich-wikidata-bot |0 |Spider |- |195853 |efre-lod-enrich-wikidata-bot/0.1 (https://github.com/slub/esmarc) python-requests/2.22 | |Other |- |- |Other |- |Other |- |195783 |osm-wikidata/0.1 (https://github.com/EdwardBetts/osm-wikidata; edward@4angle.com) | |Other |- |- |Other |- |Other |- |189568 |Muziekweb external identifiers validator 1.0 (.NET Core 3.1) | |Other |- |- |AhrefsBot |7 |Spider |- |189124 |Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) | |Mac OS X |10 |8 |Chrome |27 |Other |- |187866 |Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/27.0.1453.116 Safari/537.36 | |Other |- |- |Other |- |Other |- |182241 |PLnode | |Windows |10 |- |Chrome |80 |Other |- |179687 |Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML\, like Gecko) Chrome/80.0.3987.116 Safari/537.36 | |Other |- |- |Other |- |Other |- |179026 |Mozilla | |Other |- |- |Other |- |Other |- |175778 |Phoenix_lambda/0.0.0 | |Other |- |- |new3 Pywikibot |3 |Spider |- |174841 |new3 Pywikibot/3.1.dev0 (g7939) requests/2.21.0 Python/3.5.3.final.0 | |Other |- |- |Other |- |Other |- |171391 |Apache-Jena-ARQ/3.7.0 | |Other |- |- |libwww-perl |6 |Generic Feature Phone |- |171255 |libwww-perl/6.05 | |Other |- |- |Other |- |Other |- |168755 |BeeMusic.Importer (https://beemusic.kantarmedia.fr/; referencement.bipp@kantarmedia.com) | |Other |- |- |descripciones Pywikibot |3 |Spider |- |160633 |descripciones Pywikibot/3.1.dev0 (-1 (unknown)) requests/2.19.1 Python/3.7.0.final.0 | |Other |- |- |Other |- |Other |- |159634 |NK2WP/2.1 (nkp.cz linker service\, run by ) | |Other |- |- |okhttp |4 |Other |- |151129 |okhttp/4.0.0-alpha02 | |Other |- |- |Googlebot |2 |Spider |- |149971 |Mozilla/5.0 AppleWebKit/537.36 (KHTML\, like Gecko; compatible; Googlebot/2.1; +http://www.google.com/bot.html) Chrome/85.0.4183.122 Safari/537.36 | |Other |- |- |curl |7 |Other |- |147987 |GuzzleHttp/6.5.5 curl/7.29.0 PHP/7.3.17 | |Other |- |- |Other |- |Spider |- |146560 |bbw-bot2 | |Other |- |- |Other |- |Other |- |146264 |WDQS-example Python/3.5 | |Other |- |- |Other |- |Other |- |145356 |Apache-Jena-ARQ/3.16.0 | |Other |- |- |TaxonBot |1 |Spider |- |145117 |TaxonBot/1.0 | +-------------------------+------------------------+------------------------+------------------------------+-----------------------------+-----------------------------+-------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+