The “medals” R post by [TRInker](http:\/\/trinkerrstuff.wordpress.com\/2014\/02\/09\/sochi-olympic-medals-2\/) and re-blogged by [Revolutions](http:\/\/blog.revolutionanalytics.com\/2014\/02\/winter-olympic-medal-standings-presented-by-r.html) were both spiffy and a live example why there’s no point in not publishing raw data.<\/p>\n
You don’t need to have R (or any other language) do the scraping, though. The “`IMPORTHTML`” function (yes, function names seem to be ALL CAPS now over at Google Drive) in Google Drive Spreadsheets can easily do the scraping with just s simple:<\/p>\n
=IMPORTHTML(\"http:\/\/www.sochi2014.com\/en\/medal-standings\",\"table\",0)<\/pre>\nthat will refresh on demand and every hour. <\/p>\n
Here’s a [live URL](https:\/\/docs.google.com\/spreadsheets\/d\/1Al7I7nS0BP50IfThs55OKv5UPI9u-ctZgZRyDQma_G8\/export?format=csv&gid=0) that will give back a CSV of the results which can easily be used in R thusly:<\/p>\n
library(RCurl)\r\n\r\nsochi.medals.URL = \"https:\/\/docs.google.com\/spreadsheets\/d\/1Al7I7nS0BP50IfThs55OKv5UPI9u-ctZgZRyDQma_G8\/export?format=csv&gid=0\"\r\nmedals <- read.csv(textConnection(getURL(sochi.medals.URL)), \r\n stringsAsFactors = FALSE)\r\n\r\nstr(medals)\r\n\r\n'data.frame': 89 obs. of 6 variables:\r\n$ Rank : chr \"1\" \"2\" \"3\" \"4\" ...\r\n$ Country: chr \"Norway\" \"Canada\" \"Netherlands\" \"United States\" ...\r\n$ Gold : int 4 4 3 2 2 1 1 1 1 1 ...\r\n$ Silver : int 3 3 2 1 0 3 2 0 0 0 ...\r\n$ Bronze : int 4 2 3 3 0 3 0 1 0 0 ...\r\n$ Total : int 11 9 8 6 2 7 3 2 1 1 ...\r\n\r\nprint(medals)\r\n\r\n Rank Country Gold Silver Bronze Total\r\n1 1 Norway 4 3 4 11\r\n2 2 Canada 4 3 2 9\r\n3 3 Netherlands 3 2 3 8\r\n4 4 United States 2 1 3 6\r\n5 5 Germany 2 0 0 2\r\n6 6 Russian Fed. 1 3 3 7\r\n7 7 Austria 1 2 0 3\r\n8 8 France 1 0 1 2\r\n9 =9 Belarus 1 0 0 1\r\n10 =9 Korea 1 0 0 1\r\n11 =9 Poland 1 0 0 1\r\n12 =9 Slovakia 1 0 0 1\r\n13 =9 Switzerland 1 0 0 1\r\n14 14 Sweden 0 3 1 4\r\n15 15 Czech Republic 0 2 1 3\r\n16 16 Slovenia 0 1 2 3\r\n17 17 Italy 0 1 1 2\r\n18 =18 China 0 1 0 1\r\n19 =18 Finland 0 1 0 1\r\n20 =20 Great Britain 0 0 1 1\r\n21 =20 Ukraine 0 0 1 1\r\n22 - Albania 0 0 0 0\r\n23 - Andorra 0 0 0 0\r\n24 - Argentina 0 0 0 0\r\n25 - Armenia 0 0 0 0\r\n...\r\n87 - Virgin Isl, B 0 0 0 0\r\n88 - Virgin Isl, US 0 0 0 0\r\n89 - Zimbabwe 0 0 0 0<\/pre>\nWhich frees you up from dealing with the scraping and lets you focus solely on the data.<\/p>\n
You can set it up in your own Google Docs as well, just make sure to publish the spreadhseet to the web (with 'everyone' read permisssions), strip off the `pubhtml` at the end of the published URL and add `export?format=csv&gid=0` in its place.<\/p>\n","protected":false},"excerpt":{"rendered":"
The “medals” R post by [TRInker](http:\/\/trinkerrstuff.wordpress.com\/2014\/02\/09\/sochi-olympic-medals-2\/) and re-blogged by [Revolutions](http:\/\/blog.revolutionanalytics.com\/2014\/02\/winter-olympic-medal-standings-presented-by-r.html) were both spiffy and a live example why there’s no point in not publishing raw data. You don’t need to have R (or any other language) do the scraping, though. The “`IMPORTHTML`” function (yes, function names seem to be ALL CAPS now over at Google […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":3,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":""},"categories":[88,91],"tags":[714],"class_list":["post-2902","post","type-post","status-publish","format-standard","hentry","category-google-docs","category-r","tag-data-hacking"],"yoast_head":"\n
Live Google Spreadsheet For Keeping Track Of Sochi Medals - rud.is<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Live Google Spreadsheet For Keeping Track Of Sochi Medals - rud.is\" \/>\n<meta property=\"og:description\" content=\"The “medals” R post by [TRInker](http:\/\/trinkerrstuff.wordpress.com\/2014\/02\/09\/sochi-olympic-medals-2\/) and re-blogged by [Revolutions](http:\/\/blog.revolutionanalytics.com\/2014\/02\/winter-olympic-medal-standings-presented-by-r.html) were both spiffy and a live example why there’s no point in not publishing raw data. You don’t need to have R (or any other language) do the scraping, though. The “`IMPORTHTML`” function (yes, function names seem to be ALL CAPS now over at Google […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/\" \/>\n<meta property=\"og:site_name\" content=\"rud.is\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-11T17:38:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-02-11T17:39:40+00:00\" \/>\n<meta name=\"author\" content=\"hrbrmstr\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hrbrmstr\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/\"},\"author\":{\"name\":\"hrbrmstr\",\"@id\":\"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886\"},\"headline\":\"Live Google Spreadsheet For Keeping Track Of Sochi Medals\",\"datePublished\":\"2014-02-11T17:38:20+00:00\",\"dateModified\":\"2014-02-11T17:39:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/\"},\"wordCount\":203,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886\"},\"keywords\":[\"data hacking\"],\"articleSection\":[\"Google Docs\",\"R\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/\",\"url\":\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/\",\"name\":\"Live Google Spreadsheet For Keeping Track Of Sochi Medals - rud.is\",\"isPartOf\":{\"@id\":\"https:\/\/rud.is\/b\/#website\"},\"datePublished\":\"2014-02-11T17:38:20+00:00\",\"dateModified\":\"2014-02-11T17:39:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/rud.is\/b\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Live Google Spreadsheet For Keeping Track Of Sochi Medals\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/rud.is\/b\/#website\",\"url\":\"https:\/\/rud.is\/b\/\",\"name\":\"rud.is\",\"description\":\""In God we trust. All others must bring data"\",\"publisher\":{\"@id\":\"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/rud.is\/b\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886\",\"name\":\"hrbrmstr\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1\",\"url\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1\",\"width\":460,\"height\":460,\"caption\":\"hrbrmstr\"},\"logo\":{\"@id\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1\"},\"description\":\"Don't look at me\u2026I do what he does \u2014 just slower. #rstats avuncular \u2022 ?Resistance Fighter \u2022 Cook \u2022 Christian \u2022 [Master] Chef des Donn\u00e9es de S\u00e9curit\u00e9 @ @rapid7\",\"sameAs\":[\"http:\/\/rud.is\"],\"url\":\"https:\/\/rud.is\/b\/author\/hrbrmstr\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Live Google Spreadsheet For Keeping Track Of Sochi Medals - rud.is","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/","og_locale":"en_US","og_type":"article","og_title":"Live Google Spreadsheet For Keeping Track Of Sochi Medals - rud.is","og_description":"The “medals” R post by [TRInker](http:\/\/trinkerrstuff.wordpress.com\/2014\/02\/09\/sochi-olympic-medals-2\/) and re-blogged by [Revolutions](http:\/\/blog.revolutionanalytics.com\/2014\/02\/winter-olympic-medal-standings-presented-by-r.html) were both spiffy and a live example why there’s no point in not publishing raw data. You don’t need to have R (or any other language) do the scraping, though. The “`IMPORTHTML`” function (yes, function names seem to be ALL CAPS now over at Google […]","og_url":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/","og_site_name":"rud.is","article_published_time":"2014-02-11T17:38:20+00:00","article_modified_time":"2014-02-11T17:39:40+00:00","author":"hrbrmstr","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hrbrmstr","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/#article","isPartOf":{"@id":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/"},"author":{"name":"hrbrmstr","@id":"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886"},"headline":"Live Google Spreadsheet For Keeping Track Of Sochi Medals","datePublished":"2014-02-11T17:38:20+00:00","dateModified":"2014-02-11T17:39:40+00:00","mainEntityOfPage":{"@id":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/"},"wordCount":203,"commentCount":6,"publisher":{"@id":"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886"},"keywords":["data hacking"],"articleSection":["Google Docs","R"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/","url":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/","name":"Live Google Spreadsheet For Keeping Track Of Sochi Medals - rud.is","isPartOf":{"@id":"https:\/\/rud.is\/b\/#website"},"datePublished":"2014-02-11T17:38:20+00:00","dateModified":"2014-02-11T17:39:40+00:00","breadcrumb":{"@id":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/rud.is\/b\/"},{"@type":"ListItem","position":2,"name":"Live Google Spreadsheet For Keeping Track Of Sochi Medals"}]},{"@type":"WebSite","@id":"https:\/\/rud.is\/b\/#website","url":"https:\/\/rud.is\/b\/","name":"rud.is","description":""In God we trust. All others must bring data"","publisher":{"@id":"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rud.is\/b\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886","name":"hrbrmstr","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1","url":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1","contentUrl":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1","width":460,"height":460,"caption":"hrbrmstr"},"logo":{"@id":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1"},"description":"Don't look at me\u2026I do what he does \u2014 just slower. #rstats avuncular \u2022 ?Resistance Fighter \u2022 Cook \u2022 Christian \u2022 [Master] Chef des Donn\u00e9es de S\u00e9curit\u00e9 @ @rapid7","sameAs":["http:\/\/rud.is"],"url":"https:\/\/rud.is\/b\/author\/hrbrmstr\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p23idr-KO","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":789,"url":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/","url_meta":{"origin":2902,"position":0},"title":"Google Spreadsheet “importHTML” Rocks For Quick Analytics","author":"hrbrmstr","date":"2012-01-13","format":false,"excerpt":"I usually take a peek at the Internet Traffic Report (ITR) a couple times a day as part of my routine and was a bit troubled by all of the red today: I wanted to do some crunching on the data, and I deliberately do not have Word or Excel\u2026","rel":"","context":"In "Google Docs"","block_context":{"text":"Google Docs","link":"https:\/\/rud.is\/b\/category\/google-docs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2912,"url":"https:\/\/rud.is\/b\/2014\/02\/12\/one-more-yet-another-olympic-medal-live-tracking-shiny-app\/","url_meta":{"origin":2902,"position":1},"title":"One More (Yet-another?) Olympic Medal Live-tracking Shiny App","author":"hrbrmstr","date":"2014-02-12","format":false,"excerpt":"I'm posting this mostly to show how to: - use the Google spreadsheet data-munging \"hack\" from the [previous post](http:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/) in a Shiny context - include it seamlessly into a web page, and - run it locally without a great deal of wrangling The code for the app is [in this\u2026","rel":"","context":"In "data driven security"","block_context":{"text":"data driven security","link":"https:\/\/rud.is\/b\/category\/data-driven-security\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1849,"url":"https:\/\/rud.is\/b\/2012\/12\/17\/easier-html-table-scraping-for-scripts-with-google-drive\/","url_meta":{"origin":2902,"position":2},"title":"Easier HTML Table-scraping For Scripts With Google Drive","author":"hrbrmstr","date":"2012-12-17","format":false,"excerpt":"We had our first, real, snowfall of the season in Maine today and that usually means school delays\/closings. Our \"local\" station \u2013 @WCHS6 \u2013 has a Storm Center Closings page as well as an SMS notification service. I decided this morning that I needed a command line version (and, eventually,\u2026","rel":"","context":"In "Google Docs"","block_context":{"text":"Google Docs","link":"https:\/\/rud.is\/b\/category\/google-docs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2938,"url":"https:\/\/rud.is\/b\/2014\/03\/15\/guardian-words-visualized\/","url_meta":{"origin":2902,"position":3},"title":"Guardian Words: Visualized","author":"hrbrmstr","date":"2014-03-15","format":false,"excerpt":"Andy Kirk (@visualisingdata) & Lynn Cherny (@arnicas) tweeted about the Guardian Word Count service\/archive site, lamenting the lack of visualizations: Want to know num of words written in each day's Guardian paper by section + approx reading time? http:\/\/t.co\/wP4W1EzUsx via @bengoldacre\u2014 Andy Kirk (@visualisingdata) March 15, 2014 This gave me\u2026","rel":"","context":"In "Data Visualization"","block_context":{"text":"Data Visualization","link":"https:\/\/rud.is\/b\/category\/data-visualization\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12332,"url":"https:\/\/rud.is\/b\/2019\/06\/15\/introducing-the-ethercalc-package\/","url_meta":{"origin":2902,"position":4},"title":"Introducing the {ethercalc} package","author":"hrbrmstr","date":"2019-06-15","format":false,"excerpt":"I mentioned EtherCalc in a previous post and managed to scrounge some time to put together a fledgling {ethercalc} package (it's also on GitLab, SourceHut, Bitbucket and GitUgh, just sub out the appropriate URL prefix). I'm creating a package-specific Docker image (there are a couple out there but I'm not\u2026","rel":"","context":"In "R"","block_context":{"text":"R","link":"https:\/\/rud.is\/b\/category\/r\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":6164,"url":"https:\/\/rud.is\/b\/2017\/08\/22\/caching-httr-requests-this-means-warc\/","url_meta":{"origin":2902,"position":5},"title":"Caching httr Requests? This means WAR[C]!","author":"hrbrmstr","date":"2017-08-22","format":false,"excerpt":"I've blathered about my crawl_delay project before and am just waiting for a rainy weekend to be able to crank out a follow-up post on it. Working on that project involved sifting through thousands of Web Archive (WARC) files. While I have a nascent package on github to work with\u2026","rel":"","context":"In "R"","block_context":{"text":"R","link":"https:\/\/rud.is\/b\/category\/r\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/posts\/2902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/comments?post=2902"}],"version-history":[{"count":0,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/posts\/2902\/revisions"}],"wp:attachment":[{"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/media?parent=2902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/categories?post=2902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/tags?post=2902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}