bigquery.sql

-- https://bigquery.cloud.google.com
SELECT count(*) AS count, url
FROM
(
  SELECT id, REGEXP_EXTRACT(content, r'(https?://[^\s]*\.pdf)') AS url
  FROM [bigquery-public-data:github_repos.sample_contents]
  WHERE REGEXP_MATCH(content, r'https?://[^\s]*\.pdf')
)
GROUP BY url
ORDER BY count desc
LIMIT 100;

results-20161123-113432.json

{"count":"630","url":"https://aclweb.org/anthology/D/D15/D15-1063.pdf"}
{"count":"380","url":"http://www.sun.com/software/products/lustre/docs/GPLv2.pdf"}
{"count":"72","url":"http://www.pdf"}
{"count":"42","url":"http://www.opengl.org/registry/doc/GLSLangSpec.4.20.8.pdf"}
{"count":"41","url":"http://www.magic-software.com/License/free.pdf"}
{"count":"39","url":"http://www.lakemedelsverket.se/upload/om-lakemedelsverket/publikationer/information-fran-lakemedelsverket/2012/Rev%20130422_inneh%c3%a5llsf_Info%20fr%c3%a5n%20LV_nr%206_2012_webb.pdf"}
{"count":"36","url":"http://www.ecma-international.org/publications/files/ECMA-ST/Ecma-262.pdf"}
{"count":"35","url":"http://refractiveindex.info/download/data/2015/ohara_2015-12-01.pdf"}
{"count":"26","url":"http://www.geometrictools.com/License/WildMagicLicense.pdf"}
{"count":"26","url":"http://onyxneon.com/books/modern_perl/modern_perl_a4.pdf"}
{"count":"26","url":"http://refractiveindex.info/download/data/2015/schott-optical-glass-collection-datasheets-july-2015-us.pdf"}
{"count":"24","url":"http://www.t10.org/ftp/t10/drafts/s2/s2-r10l.pdf"}
{"count":"23","url":"http://www.blf.net/endodiab/endodiab/Vp_Thyreotoxicos_files/Vardprogram_2010_tyreotxikos_endokrinsektionen_finalt.pdf"}
{"count":"22","url":"http://www.secc.co.jp/pdf/os_e/2004/e_os_all.pdf"}
{"count":"21","url":"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/183962/Open-Standards-Principles-FINAL.pdf"}
{"count":"21","url":"http://refractiveindex.info/download/data/2015/HIKARI_Catalog.pdf"}
{"count":"19","url":"http://csrc.nist.gov/publications/nistpubs/800-38a/sp800-38a.pdf"}
{"count":"18","url":"http://www.socialstyrelsen.se/Lists/Artikelkatalog/Attachments/19657/2015-1-12.pdf"}
{"count":"17","url":"http://www.apoteketfarmaci.se/NyheterOchFakta/Farmaci%20Broschyrer/SortimentFort_Livsmedel_utan_pris.pdf"}
{"count":"17","url":"http://www.blf.net/nefrolog/dok/nefrotiskt_syndrom.pdf"}
{"count":"17","url":"http://www.lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/Att_forebygga_aterosklerotisk_hjart-karlsjukdom_med%20_lakemedel_behandlingsrekommendation.pdf"}
{"count":"15","url":"http://www.socialstyrelsen.se/lists/artikelkatalog/attachments/18085/2010-6-29.pdf"}
{"count":"15","url":"http://www.blf.net/gastro/vardprogram/VP%20GERD%20BLF%202010_ver1.0.pdf"}
{"count":"14","url":"http://code.org/files/student-progress.pdf"}
{"count":"14","url":"http://refractiveindex.info/download/data/2012/schott_optical_glass_collection_datasheets_dec_2012_us.pdf"}
{"count":"14","url":"http://www.visionopen.com/members/jiapei/publications/pei_sm2dreport2010.pdf"}
{"count":"14","url":"http://www.intel.com/technology/serialata/pdf/rev1_0.pdf"}
{"count":"13","url":"http://www.lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/080313_primarprevention.pdf"}
{"count":"12","url":"http://www.rdrop.com/users/paulmck/paper/rclockpdcsproof.pdf"}
{"count":"12","url":"http://ltarkiv.lakartidningen.se/2012/temp/pda40731.pdf"}
{"count":"12","url":"http://www.cs.indiana.edu/pub/techreports/TR425.pdf"}
{"count":"11","url":"http://www.intel.com/hardwaredesign/hpetspec_1.pdf"}
{"count":"11","url":"https://lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/Rev%20130806_Rekommendation_neonatal%20sepsis_webb.pdf"}
{"count":"10","url":"http://www.ripe.net/db/support/db-terms-conditions.pdf"}
{"count":"10","url":"http://www.magic-software.com/License/WildMagic.pdf"}
{"count":"10","url":"http://www.usb.org/developers/devclass_docs/HID1_11.pdf"}
{"count":"10","url":"http://www.khronos.org/registry/gles/specs/2.0/GLSL_ES_Specification_1.0.17.pdf"}
{"count":"9","url":"http://support.amd.com/us/Processor_TechDocs/41322.pdf"}
{"count":"9","url":"http://swedeye.org/wp-content/uploads/Kliniska-riktlinjer_-Endoftalmit.pdf"}
{"count":"9","url":"http://www.demenscentrum.se/globalassets/arbeta_med_demens_pdf/skalor_instrument/mmse-sr_protokoll_farg.pdf"}
{"count":"9","url":"http://www8.cs.umu.se/kurser/5DV058/VT09/lectures/spooknotes.pdf"}
{"count":"9","url":"http://www.copyright.gov/legislation/dmca.pdf"}
{"count":"9","url":"http://csrc.nist.gov/publications/fips/fips197/fips-197.pdf"}
{"count":"9","url":"http://www.agner.org/optimize/calling_conventions.pdf"}
{"count":"9","url":"http://www.imsglobal.org/ipr/imsipr_policyFinal.pdf"}
{"count":"9","url":"http://www.courts.state.va.us/courts/circuit/resources/manuals/cc_manual_civil/glossary.pdf"}
{"count":"9","url":"http://www.lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/2011_02_02_Rek%20Eilepsi-webb.pdf"}
{"count":"9","url":"http://docs.oasis-open.org/camp/camp-spec/v1.1/camp-spec-v1.1.pdf"}
{"count":"8","url":"http://www.jpeg.org/public/fcd14492.pdf"}
{"count":"8","url":"https://lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/Att_forebygga_aterosklerotisk_hjart-karlsjukdom_med%20_lakemedel_behandlingsrekommendation.pdf"}
{"count":"8","url":"http://people.redhat.com/drepper/tls.pdf"}
{"count":"8","url":"http://www.usb.org/developers/docs/USB_LANGIDs.pdf"}
{"count":"8","url":"http://csrc.nist.gov/publications/fips/fips180-3/fips180-3_final.pdf"}
{"count":"8","url":"http://www.intel.com/content/dam/doc/datasheet/82599-10-gbe-controller-datasheet.pdf"}
{"count":"8","url":"http://ltarkiv.lakartidningen.se/2005/temp/pda30573.pdf"}
{"count":"8","url":"http://www.socialstyrelsen.se/Lists/Artikelkatalog/Attachments/17790/2009-11-4.pdf"}
{"count":"7","url":"http://www.ngs.noaa.gov/PUBS_LIB/inverse.pdf"}
{"count":"7","url":"http://www.nic.net.ge/policy_en.pdf"}
{"count":"7","url":"http://ec.europa.eu/health/files/eudralex/vol-<br>1/dir_2011_62/dir_2011_62_sv.pdf"}
{"count":"7","url":"http://hrst.mit.edu/hrs/apollo/public/archive/1701.pdf"}
{"count":"7","url":"http://www.gemplus.com/smart/rd/publications/pdf/NS98pkcs.pdf"}
{"count":"7","url":"http://www.me.berkeley.edu/~mcmains/pubs/DAC05OffsetPolygon.pdf"}
{"count":"7","url":"http://www.lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/Rek%20-%20farmakologisk%20beh%20av%20bakteriella%20hud-%20och%20mjukdelsinfektioner.pdf"}
{"count":"7","url":"http://www.tarsnap.com/scrypt/scrypt.pdf"}
{"count":"7","url":"http://www.lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/HCV_kunskapsunderlag_2014-07-03.pdf"}
{"count":"7","url":"http://www.hcp.med.harvard.edu/ncs/ftpdir/adhd/18Q-Swedish%20FINAL.pdf"}
{"count":"7","url":"http://www.lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/Neuro%20rek.pdf"}
{"count":"7","url":"http://www.ecma-international.org/publications/files/ECMA-ST/ECMA-262.pdf"}
{"count":"7","url":"http://www.swift.com/dsp/resources/documents/IBAN_Registry.pdf"}
{"count":"7","url":"http://www.intel.com/Assets/PDF/specupdate/314554.pdf"}
{"count":"7","url":"http://www.yageo.com/pdf/yageo/Leaded-R_CFR_2008.pdf\"&gt;http://www.yageo.com/pdf/yageo/Leaded-R_CFR_2008.pdf"}
{"count":"7","url":"http://www.karolinska.se/upload/hyperbarmedicin/HBO%20Focus%20report%202011-02-10.pdf"}
{"count":"7","url":"https://csedweek.org/csteacher/mirrorimages.pdf"}
{"count":"7","url":"http://www.lakemedelsverket.se/upload/nyheter/2013/lakemedelsverkets_arsredovisning_2012.pdf"}
{"count":"6","url":"http://www.janusinfo.se/Global/Lakemedelskommitt%C3%A9er/Patientens%20samlade%20l%C3%A4kemedleslista%20vers%201.02finalt.pdf"}
{"count":"6","url":"http://www.adobe.com/devnet/acrobat/pdfs/FontPolicies.pdf"}
{"count":"6","url":"http://www.cs.princeton.edu/gfx/pubs/Sander_2007_%3ETR/tipsy.pdf"}
{"count":"6","url":"http://www.nrscotland.gov.uk/files/registration/reglist.pdf"}
{"count":"6","url":"https://nodejs.org/images/trademark-policy.pdf"}
{"count":"6","url":"http://ltarkiv.lakartidningen.se/2005/temp/pda29953.pdf"}
{"count":"6","url":"http://www.unicode.org/charts/PDF/U1D400.pdf"}
{"count":"6","url":"http://www.nice.org.uk/nicemedia/live/11786/43608/43608.pdf"}
{"count":"6","url":"http://www.sun.com/products-n-solutions/hardware/docs/pdf/806-3985-10.pdf"}
{"count":"6","url":"http://try.crashlytics.com/terms/terms-of-service.pdf"}
{"count":"6","url":"http://download.microsoft.com/download/8/0/1/801a191c-029d-4af3-9642-555f6fe514ee/cff.pdf"}
{"count":"6","url":"http://www.adobe.com/devnet/acrobat/pdfs/js_developer_guide.pdf"}
{"count":"6","url":"http://www.cs.cmu.edu/~rwh/theses/okasaki.pdf"}
{"count":"6","url":"http://www.x86-64.org/documentation/abi.pdf"}
{"count":"6","url":"http://www.socialstyrelsen.se/Lists/Artikelkatalog/Attachments/8942/2007-102-2_20071022.pdf"}
{"count":"6","url":"http://csrc.nist.gov/groups/STM/cavp/documents/rng/931rngext.pdf"}
{"count":"6","url":"http://itc.ktu.lt/itc354/Riskus354.pdf"}
{"count":"6","url":"http://www.nessus.org/plugins/RegisteredFeed.pdf"}
{"count":"6","url":"http://www.cacr.math.uwaterloo.ca/hac/about/chap14.pdf"}
{"count":"6","url":"http://samtools.sourceforge.net/SAM1.pdf"}
{"count":"6","url":"http://www.gaisler.com/products/grlib/grip.pdf"}
{"count":"6","url":"http://static.mrfeinberg.com/bv_ch03.pdf"}
{"count":"6","url":"http://www.double.co.nz/dust/col0798.pdf"}
{"count":"6","url":"http://www.open-std.org/jtc1/sc22/wg21/docs/papers/2008/n2798.pdf"}
{"count":"6","url":"http://csrc.nist.gov/publications/fips/fips180-2/fips180-2.pdf"}
{"count":"5","url":"http://www.lakemedelsverket.se/upload/halso-och-sjukvard/behandlingsrekommendationer/Rev%20130422_inneh%c3%a5llsf%c3%b6rt_Handl%c3%a4ggning%20av%20faryngotonsilliter%20i%20%c3%b6ppen%20v%c3%a5rd%20-%20ny%20rekommendation_webb.pdf"}

full results at https://docs.google.com/spreadsheets/d/1zjJLsCS5d3Mv22D5k0ApetJUq4p-uRk0D7Z8g7EY8TM/edit#gid=386801670, from the HN thread https://news.ycombinator.com/item?id=13023737