sudo apt-get install maven (or sudo apt update sudo apt install maven) git clone https://github.com/commoncrawl/cc-index-table.git cd cc-index-table mvn package vagrant@node1:~/cc-index-table$ ./src/script/convert_url_index.sh https://commoncrawl.s3.amazonaws.com/cc-index/collections/CC-MAIN-2019-30/indexes/cdx-00000.gz hdfs:///user/vagrant/cc-index-table spark: https://jaceklaskowski.gitbooks.io/mastering-apache-spark/spark-shell.html ============ Dr Bainbridge found the following vagrant file that will set up hadoop and spark presumably for cluster computing: https://github.com/martinprobson/vagrant-hadoop-hive-spark Vagrant: * Guide: https://www.vagrantup.com/intro/getting-started/index.html * Common cmds: https://blog.ipswitch.com/5-vagrant-commands-you-need-to-know * vagrant reload = vagrant halt + vagrant up https://www.vagrantup.com/docs/cli/reload.html * https://stackoverflow.com/questions/46903623/how-to-use-firefox-ui-in-vagrant-box * https://stackoverflow.com/questions/22651399/how-to-install-firefox-in-precise64-vagrant-box sudo apt-get -y install firefox * vagrant install emacs: https://medium.com/@AnnaJS15/getting-started-with-virtualbox-and-vagrant-8d98aa271d2a * hadoop conf: sudo vi /usr/local/hadoop-2.7.6/etc/hadoop/mapred-site.xml * https://data-flair.training/forums/topic/mkdir-cannot-create-directory-data-name-node-is-in-safe-mode/ --- ==> node1: Forwarding ports... node1: 8080 (guest) => 8081 (host) (adapter 1) node1: 8088 (guest) => 8089 (host) (adapter 1) node1: 9083 (guest) => 9084 (host) (adapter 1) node1: 4040 (guest) => 4041 (host) (adapter 1) node1: 18888 (guest) => 18889 (host) (adapter 1) node1: 16010 (guest) => 16011 (host) (adapter 1) node1: 22 (guest) => 2200 (host) (adapter 1) ==> node1: Running 'pre-boot' VM customizations... ==> node1: Checking for guest additions in VM... node1: The guest additions on this VM do not match the installed version of node1: VirtualBox! In most cases this is fine, but in rare cases it can node1: prevent things such as shared folders from working properly. If you see node1: shared folder errors, please make sure the guest additions within the node1: virtual machine match the version of VirtualBox you have installed on node1: your host and reload your VM. node1: node1: Guest Additions Version: 5.1.38 node1: VirtualBox Version: 5.2 ------------ At http://commoncrawl.org/2018/10/september-2018-crawl-archive-now-available/, it says "The September crawl contains 500 million new URLs, not contained in any crawl archive before. New URLs stem from the continued seed donation of URLs from mixnode.com ..." https://www.mixnode.com/ "The entire web, in your hands Mixnode turns the web into a database that you can run queries against. Say goodbye to web crawling, forget about web scraping, never run a spider again: get all the web data that you need using simple SQL queries." -------------- https://commoncrawl.github.io/cc-crawl-statistics/plots/languages http://commoncrawl.org/2018/08/august-2018-crawl-archive-now-available/ The JSON for the index files (that we downloaded for .nz) already contained a "languages:" field. The above page mentions that this shows the primary, upto 3, detected languages of the document. "Language Annotations We now run the Compact Language Detector 2 (CLD2) on HTML pages to identify the language of a document. CLD2 is able to identify 160 different languages and up to 3 languages per document. The detected languages resp. the ISO-639-3 code are shown in the URL index as a new field, e.g., "languages": "zho,eng". The WARC metadata records contain the full CLD2 response including scores and text coverage: languages-cld2: {"reliable":true,"text-bytes":3783,"languages":[{"code":"zh","code-iso-639-3":"zho","text-covered":0.93,"score":1943.0,"name":"Chinese"},{"code":"en","code-iso-639-3":"eng","text-covered":0.05,"score":523.0,"name":"ENGLISH"}]} On github you’ll find the Java bindings to the CLD2 native library and the distribution of the primary document languages as part of our crawl statistics. Please note that the columnar index does not contain the detected languages for now. " http://commoncrawl.org/2018/10/september-2018-crawl-archive-now-available/ "the columnar index contains the content language of a web page as a new field. Please read the instructions below how to upgrade your tools to read newly added fields." http://commoncrawl.org/2018/03/index-to-warc-files-and-urls-in-columnar-format/ SPARK (Spark SQL): https://github.com/commoncrawl/cc-index-table with example on selecting languages https://commoncrawl.s3.amazonaws.com/cc-index/collections/CC-MAIN-2019-30/indexes/cluster.idx ./convert_url_index.sh https://commoncrawl.s3.amazonaws.com/cc-index/collections/CC-MAIN-2019-30/indexes/cdx-00000.gz hdfs:///user/vagrant/cc-index-table --- https://www.aclweb.org/anthology/L16-1443 (2016, as per https://pbn.nauka.gov.pl/sedno-webapp/getReport/38108) https://dkpro.github.io/dkpro-c4corpus/ "DKPro C4CorpusTools is a collection of tools for processing CommonCrawl corpus, including Creative Commons license detection, boilerplate removal, language detection, and near-duplicate removal." https://zoidberg.ukp.informatik.tu-darmstadt.de/jenkins/job/DKPro%20C4Corpus/org.dkpro.c4corpus$dkpro-c4corpus-doc/doclinks/1/#_including_c4corpustools_in_your_java_projects - Including C4CorpusTools in your Java projects - Working with C4Corpus - Word count example https://github.com/farhansiddiqui/webscale_nlp https://github.com/commoncrawl/language-detection-cld2 --------- There's already python code for getting text: https://spark-in.me/post/parsing-common-crawl-in-two-simple-commands https://gist.github.com/Smerity/afe7430fdb4371015466 https://spark-in.me/post/parsing-common-crawl-in-two-simple-commands "But it turns out - it is not. This can be attributed to the effort that has been made to make the CC more accessible. The killer feature for me was the presence of their index weighting only ~200Gb, that also features a language detection option, i.e. you do not need to analyze top-level-domains or do any significant data mining." What does the "language detection option" discussion above mean? ------------ Skipping CrawlDiagnostics (see below) and robots.txt gz files: http://commoncrawl.org/2018/08/august-2018-crawl-archive-now-available/ "HTTP 304 notmodified" responses are now stored as WARC revisit records in the "crawldiagnostics" subset along with 404s, redirects and other non-200 responses. For now the revisit records contain a payload digest although there is no payload sent together with HTTP 304 responses. The stupid reason is that the columnar index requires the digest field and we want to make sure that all tools continue to work as expected. The SHA-1 digest of an empty payload (zero bytes) is used for the revisit records. http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/#revisit ‘revisit’ General A ‘revisit’ record describes the revisitation of content already archived, and might include only an abbreviated content body which has to be interpreted relative to a previous record. Most typically, a ‘revisit’ record is used instead of a ‘response’ or ‘resource’ record to indicate that the content visited was either a complete or substantial duplicate of material previously archived. ... ------- WET FILES: https://stackoverflow.com/questions/16649535/access-a-common-crawl-aws-public-dataset/25297965#25297965 http://commoncrawl.org/2019/07/june-2019-crawl-archive-now-available/ File List #Files Total Size Compressed (TiB) WET files CC-MAIN-2019-26/wet.paths.gz 56000 7.59 http://commoncrawl.org/2015/04/announcing-the-common-crawl-index/ (Instructions) https://gist.github.com/svemir/4207353 (Hadoop related) A Common Crawl Experiment https://gist.github.com/Smerity/afe7430fdb4371015466 Extract just the text from Common Crawl WARC WET files https://stackoverflow.com/tags/common-crawl/hot?filter=all https://stackoverflow.com/questions/45920527/get-offset-and-length-of-a-subset-of-a-wat-archive-from-common-crawl-index-serve/46152773#46152773 "The Common Crawl index does not contain offsets into WAT and WET files. So, the only way is to search the whole WAT/WET file for the desired record/URL. Eventually, it would be possible to estimate the offset because the record order in WARC and WAT/WET files is the same." https://dmorgan.info/posts/common-crawl-python/ https://groups.google.com/forum/#!topic/common-crawl/pdI3w09AAbQ Example: WARC: tikauka:[142]/Scratch/anupama/maori-lang-detection>wget https://commoncrawl.s3.amazonaws.com/crawl-data/CC-MAIN-2019-30/segments/1563195526237.47/crawldiagnostics/CC-MAIN-20190719115720-20190719141720-00077.warc.gz WET: tikauka:[142]/Scratch/anupama/maori-lang-detection>wget https://commoncrawl.s3.amazonaws.com/crawl-data/CC-MAIN-2019-30/segments/1563195526237.47/wet/CC-MAIN-20190719115720-20190719141720-00508.warc.wet.gz tikauka:[142]/Scratch/anupama/maori-lang-detection>gunzip CC-MAIN-20190719115720-20190719141720-00508.warc.wet.gz -------------------------------------------- http://webdatacommons.org/ https://dzone.com/articles/need-billions-of-web-pages-dont-bother-crawling Ran Geva 2017-04-09 Like (0) Excellent article! CommonCrawl is an amazing resourouce. You should also check out webdatacommons.org that is using their data and extract structured data (using RDFa, Microdata..) If I may add a shameless plug here and tell you about Webhose.io [PAYWARE/SERVICES]. We provide an API to structured web data. The idea is the same as the one you presented. Instead of crawling the web, we already crawl millions of sites, download the data, structure and organize it so anyone can easily consume it and plug into their own system. Reply https://stackoverflow.com/questions/12097848/finding-all-domains-of-a-country -> http://urlsearch.commoncrawl.org/ -> http://index.commoncrawl.org/ -> INSTRUCTIONS: https://groups.google.com/forum/#!msg/common-crawl/3QmQjFA_3y4/vTbhGqIBBQAJ Go to: http://index.commoncrawl.org/ Grab the newest gzipped archive file. Then open it and find the cluster.idx file listed in it. Copy its relative URL, prefix with https://commoncrawl.s3.amazonaws.com/ THEN: wharariki:[101]/Scratch/ak19/heritrix/heritrix-3.4.0-SNAPSHOT>wget https://commoncrawl.s3.amazonaws.com/cc-index/collections/CC-MAIN-2019-26/indexes/cluster.idx --2019-07-29 17:40:45-- https://commoncrawl.s3.amazonaws.com/cc-index/collections/CC-MAIN-2019-26/indexes/cluster.idx Resolving commoncrawl.s3.amazonaws.com (commoncrawl.s3.amazonaws.com)... 52.216.8.171 Connecting to commoncrawl.s3.amazonaws.com (commoncrawl.s3.amazonaws.com)|52.216.8.171|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 125059234 (119M) [binary/octet-stream] Saving to: ‘cluster.idx’ cluster.idx 100%[============================================================>] 119.27M 8.51MB/s in 15s 2019-07-29 17:41:01 (7.83 MB/s) - ‘cluster.idx’ saved [125059234/125059234] wharariki:[102]/Scratch/ak19/heritrix/heritrix-3.4.0-SNAPSHOT>grep '^nz,' cluster.idx | cut -f2 | uniq cdx-00237.gz cdx-00238.gz Prefix "https://commoncrawl.s3.amazonaws.com/cc-index/collections/CC-MAIN-2019-26/indexes/" to the listed gz files and wget them: https://commoncrawl.s3.amazonaws.com/cc-index/collections/CC-MAIN-2019-26/indexes/cdx-00237.gz https://commoncrawl.s3.amazonaws.com/cc-index/collections/CC-MAIN-2019-26/indexes/cc-index/collections/CC-MAIN-2019-26/indexes/cdx-00238.gz Unzip those, and we have all URLs with TLD .nz: wharariki:[131]/Scratch/ak19/heritrix/heritrix-3.4.0-SNAPSHOT>gunzip cdx-00237.gz wharariki:[132]/Scratch/ak19/heritrix/heritrix-3.4.0-SNAPSHOT>gunzip cdx-00238.gz The first of these files includes Norwegian TLDs (start with "no,") and the second gz file includes TLDs that start with "org,". So extract just those that start with "^nz," [https://www.unix.com/shell-programming-and-scripting/176608-how-copy-lines-starts-either-3-4-into-new-file.html]. wharariki:[107]/Scratch/ak19/heritrix/heritrix-3.4.0-SNAPSHOT>egrep "^nz," cdx-00238 > nz-only-TLDs-from-237-238.txt wharariki:[108]/Scratch/ak19/heritrix/heritrix-3.4.0-SNAPSHOT>egrep "^nz," cdx-00238 >> nz-only-TLDs-from-237-238.txt Checking the abacusinstitute.ac.nz is also in the current June 2019 list: egrep "ac,abacusinstitute" nz-only-TLDs-from-237-238.txt OTHER: https://www.tutorialspoint.com/hadoop/hadoop_mapreduce http://stormcrawler.net/ http://storm.apache.org/getting-help.html https://dzone.com/articles/need-billions-of-web-pages-dont-bother-crawling Basically, each release is split into 100 segments. Each segment has three types of files: WARC, WAT, and WET. As explained on the Get Started page: WARC files store the raw crawl data. WAT files store computed metadata for the data stored in the WARC. WET files store extracted plaintext from the data stored in the WARC. Note that WAT and WET are in the WARC format too! In fact, the WARC format is nothing more than an envelope with metadata and content. In the case of the WARC files, that content is the HTTP requests and responses, whereas, for the WET files, it is simply the plain text extracted from the WARCs. The WAT files contain a JSON representation of metadata extracted from the WARCs, e.g. title, links etc. Resources The Get Started page on the CommonCrawl website contains useful pointers to libraries and code in various programming languages to process the datasets. There is also a list of tutorials and presentations. It is also worth noting that CommonCrawl provides an index per release, allowing you to search for URLs (including wildcards) and retrieve the segment and offset therein where the content of the URL is stored, e.g.: { "urlkey": "org,apache)/", "timestamp": "20170220105827", "status": "200", "url": "http://apache.org/", "filename": "crawl-data/CC-MAIN-2017-09/segments/1487501170521.30/warc/CC-MAIN-20170219104610-00206-ip-10-171-10-108.ec2.internal.warc.gz", "length": "13315", "mime": "text/html", "offset": "14131184", "digest": "KJREISJSKKGH6UX5FXGW46KROTC6MBEM" } This is useful but only if you are interested in a limited number of URLs which you know in advance. In many cases, what you know in advance is what you want to extract, not where it will be extracted from. For situations such as these, you will need distributed batch-processing using MapReduce in Apache Hadoop or Apache Spark. https://www.forbes.com/sites/kalevleetaru/2017/09/28/common-crawl-and-unlocking-web-archives-for-research/#7067d4313b83 One large web archive has bucked this trend and stood alone among its peers: Common Crawl. Similar to other large web archiving initiatives like the Internet Archive, Common Crawl conducts regular web wide crawls of the open web and preserves all of the content it downloads in the standard WARC file format. Unlike many other archives, it focuses primarily on preserving HTML web pages and does not archive images, videos, JavaScript files, CSS stylesheets, etc. Its goal is not to preserve the exact look and feel of a website on a given snapshot in time, but rather to collect a vast cross section of HTML web pages from across the web in a single place to enable large-scale data mining at web scale. ... The project excludes sites which have robots.txt exclusion policies, following the historical policy of many other web archives, though it is worth noting that the Internet Archive earlier this year began slowly phasing out its reliance on such files due to their detrimental effect on preservation completeness. Common Crawl also allows sites to request removal from their index. Other than these cases, Common Crawl attempts to crawl as much of the remaining web as possible, aiming for a representative sample of the open web. ... Ms. Crouse [Director of Common Crawl] noted the risk adverse nature of the web archiving community as a whole (historically many adhered and still adhere to a strict “opt in” policy requiring prior approval before crawling a site) and the unwillingness of many archives to modernize their thinking on copyright and to engage more closely with the legal community in ways that could help them expand fair use horizons. In particular, she noted “since we [in the US] are beholden to the Copyright Act, while living in a digital age, many well-intentioned organizations devoted to web science, archiving, and information provision may benefit from a stronger understanding of how copyright is interpreted in present day, and its hard boundaries” and that “many talented legal advisers and groups are interested in the precedent-setting nature of this topic; some are willing to work Pro Bono.” ... Returning to the difference between Common Crawl’s datasets and traditional preservation-focused web archiving, Ms. Crouse emphasized that they capture only HTML pages and exclude multimedia content like images, video and other dynamic content. She noted that a key aspect of their approach to fair use is that web pages are intended for consumption by human beings one at a time using a web browser, while Common Crawl concatenates billions of pages together in the specialized WARC file format designed for machine data mining. Specifically, “Common Crawl does not offer separate/individual web pages for easy consumption. The three data formats that are provided include text, metadata, and raw data, and the data is concatenated” and “the format of the output is not a downloaded web page. The output is in WARC file format which contains the components of a page that are beneficial to machine-level analysis and make for space- efficient archiving (essentially: header, text, and some metadata).” As Ms. Crouse put it, “this is big data intended for machine learning/readability. Further, our intention for its use is for public benefit i.e. to encourage research and innovation, not direct consumption.” She noted that “from the layperson’s perspective, it is not at all trivial at present to extract a specific website’s content (that is, text) from a Common Crawl dataset. This task generally requires one to know how to install and run a Hadoop cluster, among other things. This is not structured data. Further it is likely that not all pages of that website will be included (depending on the parameters for depth set for the specific crawl).” This means that “the bulk of [Common Crawl’s] users are from the noncommercial, educational, and research sectors. At a higher level, it’s important to note that we provide a broad and representative sample of the web, in the form of web crawl data, each month. No one really knows how big the web is, and at present, we limit our monthly data publication to approximately 3 billion pages.” Common Crawl believes it addresses this through the fact that its archive represents only a sample of each website crawled, rather than striving for 100% coverage. Specifically, Ms. Crouse noted that “at present, [crawls are] in monthly increments that are discontinuous month-to-month. We do only what is reasonable, necessary, and economical to achieve a representative sample. For instance, we limit the number of pages crawled from any given domain so, for large content owners, it is highly probable that their content, if included in a certain month’s crawl data, is not wholly represented and thus not ideal for mining for comprehensive results … if the content owner is not a large site, or in a niche market, their URL is less likely to be included in the seeds in the frontier, and, since we limit depth (# of links followed) for the sake of both economy and broader representative web coverage, 'niche' content may not even appear in a given month’s dataset.” To put it another way, Common Crawl’s mission is to create a “representative sample” of the web at large by crawling a sampling of pages and limiting the number of pages from each site they capture. Thus, their capture of any given site will represent a discontinuous sampling of pages that can change from month to month. A researcher wishing to analyze a single web site in its entirety would therefore not be able to turn to Common Crawl and would instead have to conduct their own crawl of the site or turn to a commercial aggregator that partners with the content holder to license the complete contents of the site. In Common Crawl’s view this is a critical distinction that sets it apart from both traditional web archiving and the commercial content aggregators that generate data mining revenue for content owners. By focusing on creating a “representative sample” of the web at large, rather than attempting to capture a single site in its entirety (and in fact ensuring that it does not include more than a certain number of pages per site), the crawl self-limits itself to being applicable only to macro-level research examining web scale questions. Such “web scale” questions cannot be answered through any existing open dataset and by incorporating specific design features Common Crawl ensures that more traditional research questions, like data mining the entirety of a single site, which might be viewed as redistribution of that site or competing with its owner’s ability to license its content for data mining, is simply not possible. ------------