I just solved my own query (below). You can click on
"File" --> "Export" --> ".csv Sheet Only"
whereupon a new window opens in which the data are listed in CSV format
and this can be copied in the normal way by highlighting with the mouse.
(If you have a Google account, and sign in, then more options become
available).
Thanks again for making this available!
Ted.
On 02-May-09 11:07:26, Ted Harding wrote:
> Many thanks, Rob! The "gadget" is neat, and the spreadsheet looks as
> though it displays exactly the information I am interested in.
>
> Just to check: You are updating the spreadsheet from each WHO update,
> by adding extra rows at the bottom (so in principle confirmed cases
> and deaths are cumulative for each listed country, though possibly
> a count may decrease if any cases/deaths get "deconfirmed")?
>
> However, while I can view the spreadsheet nicely when that web-page
> comes up in the browser, I find I cannot copy out of it (although
> highlighting using the mouse appears to select the block of cells
> in the spreadsheet, their contents do not get into the paste-buffer).
>
> Therefore it would be useful to be able to obtain the spreadsheet
> on a regular basis, so as to keep up-to-date with the evolution of
> the data. Is there a direct link, or would you have to send it?
> In the latter case, I would be reluctant to bother you since it would
> be happening at regular intervals! (So I would simply transcribe from
> the spreadsheet -- a bit tedious first time round, but less arduous
> thereafter).
>
> Thanks again,
> Ted.
>
> On 02-May-09 10:10:24, Rob Cook wrote:
>> Ted and others,
>>
>> The DynaMed summary is v useful. We have also been tracking the
>> confirmed cases by country for a google gadget. Based on the data in
>> WHO updates. Other sources, especially newspapers seem to have
>> reported
>> variations on 'suspected' and 'probables' from some countries. My
>> understanding is that some of the 14 reported cases from NZ, for
>> example, were suspected - yet widely reported in N. hemisphere sources
>> as confirmed. Thus we have stuck with WHO daily updates.
>>
>> The draft gadget and underlying spereadsheet is available at the
>> following link. I can send the simple spreadsheet underlying it if you
>> have trouble with access.
>>
>> The axes can be adjusted. It runs best as temporal series of WHO
>> confirmed cases and deaths by country for the last 7 days. We will
>> continue to update.
>> (http://spreadsheets.google.com/ccc?key=rYC3uyjQKj9zEo6dJW-behQ)
>>
>> Rob Cook
>> Programme Director
>> Bazian
>> [log in to unmask]
>>
>>
>> -----Original Message-----
>> From: Evidence based health (EBH) on behalf of Ted Harding
>> Sent: Sat 5/2/2009 12:42 AM
>> To: [log in to unmask]
>> Subject: Re: CATs on swine flu urgently needed
>>
>> On 29-Apr-09 22:21:23, Brian Alper MD wrote:
>>> At DynaMed and EBSCO Publishing (www.ebscohost.com/dynamed) we have
>>> made the swine influenza topic openly available without logging in or
>>> subscribing. We will continue to update this topic as
>>> recommendations,
>>> confirmed case count and eventually evidence reports are published.
>>
>> That is a useful site. Unfortunately, I did not then start to do
>> what now wish I had started to do!
>>
>> Namely, I would like to draw up a series of tables, each like the one
>> you see when you click on "View Topic" under "H1N1 Flu" on the above
>> URL,
>> and then click on "see current confirmed case count" on that site
>> which finally takes you to:
>>
>> http://hldemo.ebscohost.com/DynaMed-SwineFlu/#casecount
>>
>> That is the table for the latest update. What I would like to have
>> assembled is the entire series of successive tables, one such table
>> for each day since the summaries began to be put up on that site.
>>
>> One can access written summaries for the previous updates, but in
>> these it is difficult to pick out the equivalent data in order to
>> draw up the series of tables I seek. If I had had the presence of
>> mind to start accumulating these myself on first visiting the site,
>> I would have pretty well what I want (except perhaps for the first
>> 2 or 3). As it is, I missed the bus!
>>
>> So: does anyone know of a source for what I am looking for?
>> And/or has anyone actually done what I should have done, and would
>> be willing to share the results?
>>
>> Reason: I am interested in following the temporal evolution of
>> this series of data.
>>
>> With thanks,
>> Ted.
>>
>> --------------------------------------------------------------------
>> E-Mail: (Ted Harding) <[log in to unmask]>
>> Fax-to-email: +44 (0)870 094 0861
>> Date: 02-May-09 Time: 00:42:44
>> ------------------------------ XFMail ------------------------------
>>
>
> --------------------------------------------------------------------
> E-Mail: (Ted Harding) <[log in to unmask]>
> Fax-to-email: +44 (0)870 094 0861
> Date: 02-May-09 Time: 12:07:23
> ------------------------------ XFMail ------------------------------
--------------------------------------------------------------------
E-Mail: (Ted Harding) <[log in to unmask]>
Fax-to-email: +44 (0)870 094 0861
Date: 02-May-09 Time: 12:42:06
------------------------------ XFMail ------------------------------
|