Page MenuHomePhabricator
Paste P12933

WDQS Top-100 user-agent analysis 2020-09
ActivePublic

Authored by JAllemandou on Oct 6 2020, 1:44 PM.
Tags
None
Referenced Files
F32375709: WDQS Top-100 user-agent analysis 2020-09
Oct 6 2020, 1:44 PM
Subscribers
None
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 <petr.kadlec@gmail.com>) |
|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 |
+-------------------------+------------------------+------------------------+------------------------------+-----------------------------+-----------------------------+-------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+