 |
 |
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 ------------------------------