No subject
Sun Dec 12 18:29:16 GMT 2010
to the original raw data sources you've used, which is what you're doing in
the spreadsheet. You might event want to think about including a list of all
the datasets you used just as a separate section on the page - so that your
'Data Appendix' shows the context you've used the data in, and links to 'raw
data sources' helps people head off to explore that data in context.
It will be interesting to see if any coverage/use of the report picks up on
the data appendix - and who the users are - as I suspect it won't just be
data-geeks who are interested in the content (lots of people after the raw
numbers and facts, as well as ways of mashing-up and visualising the
data...)
All the best
Tim
On Mon, Aug 8, 2011 at 6:14 PM, David Kane <David.Kane at ncvo-vol.org.uk>wrote:
> **
> Hi - you'll probably have seen the cuts research we released today.
>
> At the risk of being a self-publicist we've also released a "data
> appendix" spreadsheet that contains all the source data we used in creating
> the report. You can find a link to the spreadsheet here:
> http://www.ncvo-vol.org.uk/cuts-report#dataappendix
>
> I guess a wider point is that I often find we're releasing this kind of
> analysed data regularly, and apart from just putting up excel spreadsheets
> (though probably should be using open spreadsheet files!) I'm never sure of
> the best way of making them "open".
>
> I think it's different to "raw" data, like the charity commission register
> for example, because a CSV file can't show you the sructure of the data
> correctly, with lots of small linked tables. So I'm never sure if there's a
> better alternative to producing a big excel file.
>
> _______________________________________________
> open-civil-society mailing list
> open-civil-society at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/open-civil-society
>
>
--
http://www.timdavies.org.uk
07834 856 303.
@timdavies
Co-director of Practical Participation:
http://www.practicalparticipation.co.uk
--------------------------
Practical Participation Ltd is a registered company in England and Wales -
#5381958.
--20cf3005dd3a42ac2d04aa021ae1
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hey David<div><br></div><div>Great work on the report - and good leading by=
example with the data.</div><div><br></div><div>The Five Stars of Linked D=
ata is a good cumulative framework for thinking about different steps of pu=
blishing open data:=A0</div>
<div><br></div><div><a href=3D"http://inkdroid.org/journal/2010/06/04/the-5=
-stars-of-open-linked-data/">http://inkdroid.org/journal/2010/06/04/the-5-s=
tars-of-open-linked-data/</a></div><div><br></div><div>Often a fairly quick=
shortcut to allow you to publish both structured spreadsheets, with data o=
n multiple tabs in context, and to make that data available for those who w=
ant it as CSV, is to share it through Google Docs, as with the permissions =
set right, a carefully crafted URL can give a user the choice of viewing it=
in spreadsheet format online, downloading each sheet as a CSV, or even que=
rying the data directly over the web.</div>
<div><br></div><div>From looking at your data, that's not so important =
as providing links back to the original raw data sources you've used, w=
hich is what you're doing in the spreadsheet. You might event want to t=
hink about including a list of all the datasets you used just as a separate=
section on the page - so that your 'Data Appendix' shows the conte=
xt you've used the data in, and links to 'raw data sources' hel=
ps people head off to explore that data in context.</div>
<div><br></div><div>It will be interesting to see if any coverage/use of th=
e report picks up on the data appendix - and who the users are - as I suspe=
ct it won't just be data-geeks who are interested in the content (lots =
of people after the raw numbers and facts, as well as ways of mashing-up an=
d visualising the data...)</div>
<div><br></div><div>All the best</div><div><br></div><div>Tim</div><div><br=
></div><div><br><br><div class=3D"gmail_quote">On Mon, Aug 8, 2011 at 6:14 =
PM, David Kane <span dir=3D"ltr"><<a href=3D"mailto:David.Kane at ncvo-vol.=
org.uk">David.Kane at ncvo-vol.org.uk</a>></span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;"><u></u>
<div>
<div><font size=3D"2" face=3D"Arial"><span>Hi - you'll probably=20
have seen the cuts research we released today.</span></font></div>
<div><font size=3D"2" face=3D"Arial"><span></span></font>=A0</div>
<div><font size=3D"2" face=3D"Arial"><span>At the risk of being=20
a self-publicist we've also released a</span></font><font size=3D"2" fa=
ce=3D"Arial"><span> "data appendix" spreadsheet that=20
contains all the source data we used in creating the report. You can find a=
link=20
to the spreadsheet here: <a href=3D"http://www.ncvo-vol.org.uk/cuts-report#=
dataappendix" target=3D"_blank">http://www.ncvo-vol.org.uk/cuts-report#data=
appendix</a></span></font></div>
<div><font size=3D"2" face=3D"Arial"><span></span></font>=A0</div>
<div><font size=3D"2" face=3D"Arial"><span>I guess a wider=20
point is that I often find we're releasing this kind of analysed data r=
egularly,=20
and apart from just putting up excel spreadsheets (though probably should b=
e=20
using open spreadsheet files!) I'm never sure of the best way of making=
them=20
"open".</span></font></div>
<div><font size=3D"2" face=3D"Arial"><span></span></font>=A0</div>
<div><font size=3D"2" face=3D"Arial"><span>I think it's=20
different to "raw" data, like the charity commission register for=
example,=20
because a CSV file can't show you the sructure of the data correctly, w=
ith lots=20
of small linked tables. So I'm never sure if there's a better alter=
native to=20
producing a big excel file.</span></font></div></div>
<br>_______________________________________________<br>
open-civil-society mailing list<br>
<a href=3D"mailto:open-civil-society at lists.okfn.org">open-civil-society at lis=
ts.okfn.org</a><br>
<a href=3D"http://lists.okfn.org/mailman/listinfo/open-civil-society" targe=
t=3D"_blank">http://lists.okfn.org/mailman/listinfo/open-civil-society</a><=
br>
<br></blockquote></div><br><br clear=3D"all"><br>-- <br><br><br><a href=3D"=
http://www.timdavies.org.uk" target=3D"_blank">http://www.timdavies.org.uk<=
/a><br>07834 856 303.<br>@timdavies<br><br>Co-director of Practical Partici=
pation: <a href=3D"http://www.practicalparticipation.co.uk" target=3D"_blan=
k">http://www.practicalparticipation.co.uk</a><br>
--------------------------<br>Practical Participation Ltd is a registered c=
ompany in England and Wales - #5381958. <br>
</div>
--20cf3005dd3a42ac2d04aa021ae1--
More information about the open-civil-society
mailing list