SlideShare a Scribd company logo
1 of 9
Download to read offline
LINKEDGOV
       The tidying-government-data project




                                Hadley Beeman
@LinkedGov                   Hadley@LinkedGov.org
                                @hadleybeeman



                                                    1
HOW DOES THIS SOUND?
                     Data from government

      Government departments      Local authorities
                             Quangos                         ata
                                                          t d ata a
                                                       or g d at a
                                                    nsp in l d at
                                                  ra end ica e d ata
                                                 T p        r
                                                    S me anc nt d
                                                       u
                                                      N form eme
        Tidie                                           er nag
                                                       P a
    Decr d                                               M
 Hum      ypte
Mach  an-re d
     ine-r adable    XML CSV    RDF    web search
          eada
               ble




                                                                       2
WHAT IS IN OUR WAY?


Codes and acronyms

Holes in the data

Multiple formats

Lack of modelling & connections
                                  http://www.flickr.com/photos/sybrenstuvel/2468506922




                                                                                        3
LINKEDGOV:
THE PROJECT




              4
CROWDSOURCING

 Decrypting budget codes and acronyms

 Adding labels and annotations

 A game!

Hi! You work at the Department for Transport?
            Can you tell us what
                         072529-1092
              means in the dataset
             Budget forecasts Q3 2010-11 DfT

     Programme to improve transport in the South East


                                                        5
FORMATTING &
       LINKING DATA


Connecting datasets

Standardising headings

Assigning URIs

Reformatting the data




                         6
ENGAGING
             GOVERNMENT

  What would you like to know?
  How many government employees work in Victoria St, SW1?



  Result:
                         201,570
Data sources:
Westminster City Council Venues           Reliability score:
BIS employee distribution                          8
DTI site census



                                                               7
HOW CAN YOU HELP?

Building LinkedGov:          Keeping LinkedGov running:
Systems architects           Help us tidy & connect data

Front end developers
                             Share the wealth: tidy your data here
Data standards enthusiasts
                             Spread the word
UX designers

Gamers

Data structure experts




                                       http://xkcd.com/552/




                                                                     8
JOIN US!

We need your ideas! Send an email with your
thoughts to:

JoinUs@LinkedGov.org

Please let us know you’re interested by Mon 20 Sept.




                                                       9

More Related Content

Similar to Linkedgov- intro at Opentech

Trend Talk Birmingham - Willmott Dixon
Trend Talk Birmingham - Willmott Dixon Trend Talk Birmingham - Willmott Dixon
Trend Talk Birmingham - Willmott Dixon PlaceTech
 
Big Data & Data Science
Big Data & Data ScienceBig Data & Data Science
Big Data & Data ScienceBrijeshGoyani
 
Data centric business and knowledge graph trends
Data centric business and knowledge graph trendsData centric business and knowledge graph trends
Data centric business and knowledge graph trendsAlan Morrison
 
Metadata and the Power of Pattern-Finding
Metadata and the Power of Pattern-FindingMetadata and the Power of Pattern-Finding
Metadata and the Power of Pattern-FindingDATAVERSITY
 
Mirko Lorenz Data Driven Journalism Overview Seminar Ordine dei Giornalisti d...
Mirko Lorenz Data Driven Journalism Overview Seminar Ordine dei Giornalisti d...Mirko Lorenz Data Driven Journalism Overview Seminar Ordine dei Giornalisti d...
Mirko Lorenz Data Driven Journalism Overview Seminar Ordine dei Giornalisti d...Massimiliano Crosato
 
Lessons from building a stream-first metadata platform | Shirshanka Das, Stealth
Lessons from building a stream-first metadata platform | Shirshanka Das, StealthLessons from building a stream-first metadata platform | Shirshanka Das, Stealth
Lessons from building a stream-first metadata platform | Shirshanka Das, StealthHostedbyConfluent
 
Notes for talk on 12th June 2013 to Open Innovation meeting, Glasgow
Notes for talk on 12th June 2013 to Open Innovation meeting, GlasgowNotes for talk on 12th June 2013 to Open Innovation meeting, Glasgow
Notes for talk on 12th June 2013 to Open Innovation meeting, GlasgowPeterWinstanley1
 
Linked Data Visualization Model - KEG VŠE
Linked Data Visualization Model - KEG VŠELinked Data Visualization Model - KEG VŠE
Linked Data Visualization Model - KEG VŠEJiří Helmich
 
2014 11-17 crichton institute talk on open data
2014 11-17 crichton institute talk on open data2014 11-17 crichton institute talk on open data
2014 11-17 crichton institute talk on open dataPeterWinstanley1
 
David McCandless: The Beauty of Data Visualization
David McCandless: The Beauty of Data VisualizationDavid McCandless: The Beauty of Data Visualization
David McCandless: The Beauty of Data VisualizationRajeev Ranjan Dwivedi
 
[Conference] Cognitive Graph Analytics on Company Data and News
[Conference] Cognitive Graph Analytics on Company Data and News[Conference] Cognitive Graph Analytics on Company Data and News
[Conference] Cognitive Graph Analytics on Company Data and NewsOntotext
 
Trade and Growth in the Digital Era
Trade and Growth in the Digital EraTrade and Growth in the Digital Era
Trade and Growth in the Digital EraMartina F. Ferracane
 
Graph databases and SQL Server 2017
Graph databases and SQL Server 2017Graph databases and SQL Server 2017
Graph databases and SQL Server 2017John Staveley
 
Database Survival Guide: Exploratory Webcast
Database Survival Guide: Exploratory WebcastDatabase Survival Guide: Exploratory Webcast
Database Survival Guide: Exploratory WebcastEric Kavanagh
 
[Partner TechShift 2017] AWS와 함께하는 글로벌 클라우드 소프트웨어 사업
[Partner TechShift 2017] AWS와 함께하는 글로벌 클라우드 소프트웨어 사업[Partner TechShift 2017] AWS와 함께하는 글로벌 클라우드 소프트웨어 사업
[Partner TechShift 2017] AWS와 함께하는 글로벌 클라우드 소프트웨어 사업Amazon Web Services Korea
 
JCR 2021 - Présentation "Cidemis en amont : petits rappels"
JCR 2021 - Présentation "Cidemis en amont : petits rappels" JCR 2021 - Présentation "Cidemis en amont : petits rappels"
JCR 2021 - Présentation "Cidemis en amont : petits rappels" ABES
 
Society of Insurance Research, 3rd Party Data
Society of Insurance Research, 3rd Party DataSociety of Insurance Research, 3rd Party Data
Society of Insurance Research, 3rd Party DataKevin McCarthy
 
Agenda Executive Steering Committee Notes
Agenda Executive Steering Committee NotesAgenda Executive Steering Committee Notes
Agenda Executive Steering Committee NotesKSI Koniag
 
Big Data Conference
Big Data ConferenceBig Data Conference
Big Data ConferenceDataTactics
 

Similar to Linkedgov- intro at Opentech (20)

Trend Talk Birmingham - Willmott Dixon
Trend Talk Birmingham - Willmott Dixon Trend Talk Birmingham - Willmott Dixon
Trend Talk Birmingham - Willmott Dixon
 
Big Data & Data Science
Big Data & Data ScienceBig Data & Data Science
Big Data & Data Science
 
Data centric business and knowledge graph trends
Data centric business and knowledge graph trendsData centric business and knowledge graph trends
Data centric business and knowledge graph trends
 
Metadata and the Power of Pattern-Finding
Metadata and the Power of Pattern-FindingMetadata and the Power of Pattern-Finding
Metadata and the Power of Pattern-Finding
 
Mirko Lorenz Data Driven Journalism Overview Seminar Ordine dei Giornalisti d...
Mirko Lorenz Data Driven Journalism Overview Seminar Ordine dei Giornalisti d...Mirko Lorenz Data Driven Journalism Overview Seminar Ordine dei Giornalisti d...
Mirko Lorenz Data Driven Journalism Overview Seminar Ordine dei Giornalisti d...
 
Lessons from building a stream-first metadata platform | Shirshanka Das, Stealth
Lessons from building a stream-first metadata platform | Shirshanka Das, StealthLessons from building a stream-first metadata platform | Shirshanka Das, Stealth
Lessons from building a stream-first metadata platform | Shirshanka Das, Stealth
 
Cloud... The Story
Cloud... The StoryCloud... The Story
Cloud... The Story
 
Notes for talk on 12th June 2013 to Open Innovation meeting, Glasgow
Notes for talk on 12th June 2013 to Open Innovation meeting, GlasgowNotes for talk on 12th June 2013 to Open Innovation meeting, Glasgow
Notes for talk on 12th June 2013 to Open Innovation meeting, Glasgow
 
Linked Data Visualization Model - KEG VŠE
Linked Data Visualization Model - KEG VŠELinked Data Visualization Model - KEG VŠE
Linked Data Visualization Model - KEG VŠE
 
2014 11-17 crichton institute talk on open data
2014 11-17 crichton institute talk on open data2014 11-17 crichton institute talk on open data
2014 11-17 crichton institute talk on open data
 
David McCandless: The Beauty of Data Visualization
David McCandless: The Beauty of Data VisualizationDavid McCandless: The Beauty of Data Visualization
David McCandless: The Beauty of Data Visualization
 
[Conference] Cognitive Graph Analytics on Company Data and News
[Conference] Cognitive Graph Analytics on Company Data and News[Conference] Cognitive Graph Analytics on Company Data and News
[Conference] Cognitive Graph Analytics on Company Data and News
 
Trade and Growth in the Digital Era
Trade and Growth in the Digital EraTrade and Growth in the Digital Era
Trade and Growth in the Digital Era
 
Graph databases and SQL Server 2017
Graph databases and SQL Server 2017Graph databases and SQL Server 2017
Graph databases and SQL Server 2017
 
Database Survival Guide: Exploratory Webcast
Database Survival Guide: Exploratory WebcastDatabase Survival Guide: Exploratory Webcast
Database Survival Guide: Exploratory Webcast
 
[Partner TechShift 2017] AWS와 함께하는 글로벌 클라우드 소프트웨어 사업
[Partner TechShift 2017] AWS와 함께하는 글로벌 클라우드 소프트웨어 사업[Partner TechShift 2017] AWS와 함께하는 글로벌 클라우드 소프트웨어 사업
[Partner TechShift 2017] AWS와 함께하는 글로벌 클라우드 소프트웨어 사업
 
JCR 2021 - Présentation "Cidemis en amont : petits rappels"
JCR 2021 - Présentation "Cidemis en amont : petits rappels" JCR 2021 - Présentation "Cidemis en amont : petits rappels"
JCR 2021 - Présentation "Cidemis en amont : petits rappels"
 
Society of Insurance Research, 3rd Party Data
Society of Insurance Research, 3rd Party DataSociety of Insurance Research, 3rd Party Data
Society of Insurance Research, 3rd Party Data
 
Agenda Executive Steering Committee Notes
Agenda Executive Steering Committee NotesAgenda Executive Steering Committee Notes
Agenda Executive Steering Committee Notes
 
Big Data Conference
Big Data ConferenceBig Data Conference
Big Data Conference
 

Recently uploaded

"Debugging python applications inside k8s environment", Andrii Soldatenko
"Debugging python applications inside k8s environment", Andrii Soldatenko"Debugging python applications inside k8s environment", Andrii Soldatenko
"Debugging python applications inside k8s environment", Andrii SoldatenkoFwdays
 
Developer Data Modeling Mistakes: From Postgres to NoSQL
Developer Data Modeling Mistakes: From Postgres to NoSQLDeveloper Data Modeling Mistakes: From Postgres to NoSQL
Developer Data Modeling Mistakes: From Postgres to NoSQLScyllaDB
 
TeamStation AI System Report LATAM IT Salaries 2024
TeamStation AI System Report LATAM IT Salaries 2024TeamStation AI System Report LATAM IT Salaries 2024
TeamStation AI System Report LATAM IT Salaries 2024Lonnie McRorey
 
The Ultimate Guide to Choosing WordPress Pros and Cons
The Ultimate Guide to Choosing WordPress Pros and ConsThe Ultimate Guide to Choosing WordPress Pros and Cons
The Ultimate Guide to Choosing WordPress Pros and ConsPixlogix Infotech
 
Passkey Providers and Enabling Portability: FIDO Paris Seminar.pptx
Passkey Providers and Enabling Portability: FIDO Paris Seminar.pptxPasskey Providers and Enabling Portability: FIDO Paris Seminar.pptx
Passkey Providers and Enabling Portability: FIDO Paris Seminar.pptxLoriGlavin3
 
Unleash Your Potential - Namagunga Girls Coding Club
Unleash Your Potential - Namagunga Girls Coding ClubUnleash Your Potential - Namagunga Girls Coding Club
Unleash Your Potential - Namagunga Girls Coding ClubKalema Edgar
 
Moving Beyond Passwords: FIDO Paris Seminar.pdf
Moving Beyond Passwords: FIDO Paris Seminar.pdfMoving Beyond Passwords: FIDO Paris Seminar.pdf
Moving Beyond Passwords: FIDO Paris Seminar.pdfLoriGlavin3
 
Transcript: New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
Transcript: New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024Transcript: New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
Transcript: New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024BookNet Canada
 
Ensuring Technical Readiness For Copilot in Microsoft 365
Ensuring Technical Readiness For Copilot in Microsoft 365Ensuring Technical Readiness For Copilot in Microsoft 365
Ensuring Technical Readiness For Copilot in Microsoft 3652toLead Limited
 
SALESFORCE EDUCATION CLOUD | FEXLE SERVICES
SALESFORCE EDUCATION CLOUD | FEXLE SERVICESSALESFORCE EDUCATION CLOUD | FEXLE SERVICES
SALESFORCE EDUCATION CLOUD | FEXLE SERVICESmohitsingh558521
 
Generative AI for Technical Writer or Information Developers
Generative AI for Technical Writer or Information DevelopersGenerative AI for Technical Writer or Information Developers
Generative AI for Technical Writer or Information DevelopersRaghuram Pandurangan
 
TrustArc Webinar - How to Build Consumer Trust Through Data Privacy
TrustArc Webinar - How to Build Consumer Trust Through Data PrivacyTrustArc Webinar - How to Build Consumer Trust Through Data Privacy
TrustArc Webinar - How to Build Consumer Trust Through Data PrivacyTrustArc
 
DevoxxFR 2024 Reproducible Builds with Apache Maven
DevoxxFR 2024 Reproducible Builds with Apache MavenDevoxxFR 2024 Reproducible Builds with Apache Maven
DevoxxFR 2024 Reproducible Builds with Apache MavenHervé Boutemy
 
Transcript: New from BookNet Canada for 2024: Loan Stars - Tech Forum 2024
Transcript: New from BookNet Canada for 2024: Loan Stars - Tech Forum 2024Transcript: New from BookNet Canada for 2024: Loan Stars - Tech Forum 2024
Transcript: New from BookNet Canada for 2024: Loan Stars - Tech Forum 2024BookNet Canada
 
Digital Identity is Under Attack: FIDO Paris Seminar.pptx
Digital Identity is Under Attack: FIDO Paris Seminar.pptxDigital Identity is Under Attack: FIDO Paris Seminar.pptx
Digital Identity is Under Attack: FIDO Paris Seminar.pptxLoriGlavin3
 
Tampa BSides - Chef's Tour of Microsoft Security Adoption Framework (SAF)
Tampa BSides - Chef's Tour of Microsoft Security Adoption Framework (SAF)Tampa BSides - Chef's Tour of Microsoft Security Adoption Framework (SAF)
Tampa BSides - Chef's Tour of Microsoft Security Adoption Framework (SAF)Mark Simos
 
SAP Build Work Zone - Overview L2-L3.pptx
SAP Build Work Zone - Overview L2-L3.pptxSAP Build Work Zone - Overview L2-L3.pptx
SAP Build Work Zone - Overview L2-L3.pptxNavinnSomaal
 
WordPress Websites for Engineers: Elevate Your Brand
WordPress Websites for Engineers: Elevate Your BrandWordPress Websites for Engineers: Elevate Your Brand
WordPress Websites for Engineers: Elevate Your Brandgvaughan
 
New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024BookNet Canada
 
How AI, OpenAI, and ChatGPT impact business and software.
How AI, OpenAI, and ChatGPT impact business and software.How AI, OpenAI, and ChatGPT impact business and software.
How AI, OpenAI, and ChatGPT impact business and software.Curtis Poe
 

Recently uploaded (20)

"Debugging python applications inside k8s environment", Andrii Soldatenko
"Debugging python applications inside k8s environment", Andrii Soldatenko"Debugging python applications inside k8s environment", Andrii Soldatenko
"Debugging python applications inside k8s environment", Andrii Soldatenko
 
Developer Data Modeling Mistakes: From Postgres to NoSQL
Developer Data Modeling Mistakes: From Postgres to NoSQLDeveloper Data Modeling Mistakes: From Postgres to NoSQL
Developer Data Modeling Mistakes: From Postgres to NoSQL
 
TeamStation AI System Report LATAM IT Salaries 2024
TeamStation AI System Report LATAM IT Salaries 2024TeamStation AI System Report LATAM IT Salaries 2024
TeamStation AI System Report LATAM IT Salaries 2024
 
The Ultimate Guide to Choosing WordPress Pros and Cons
The Ultimate Guide to Choosing WordPress Pros and ConsThe Ultimate Guide to Choosing WordPress Pros and Cons
The Ultimate Guide to Choosing WordPress Pros and Cons
 
Passkey Providers and Enabling Portability: FIDO Paris Seminar.pptx
Passkey Providers and Enabling Portability: FIDO Paris Seminar.pptxPasskey Providers and Enabling Portability: FIDO Paris Seminar.pptx
Passkey Providers and Enabling Portability: FIDO Paris Seminar.pptx
 
Unleash Your Potential - Namagunga Girls Coding Club
Unleash Your Potential - Namagunga Girls Coding ClubUnleash Your Potential - Namagunga Girls Coding Club
Unleash Your Potential - Namagunga Girls Coding Club
 
Moving Beyond Passwords: FIDO Paris Seminar.pdf
Moving Beyond Passwords: FIDO Paris Seminar.pdfMoving Beyond Passwords: FIDO Paris Seminar.pdf
Moving Beyond Passwords: FIDO Paris Seminar.pdf
 
Transcript: New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
Transcript: New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024Transcript: New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
Transcript: New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
 
Ensuring Technical Readiness For Copilot in Microsoft 365
Ensuring Technical Readiness For Copilot in Microsoft 365Ensuring Technical Readiness For Copilot in Microsoft 365
Ensuring Technical Readiness For Copilot in Microsoft 365
 
SALESFORCE EDUCATION CLOUD | FEXLE SERVICES
SALESFORCE EDUCATION CLOUD | FEXLE SERVICESSALESFORCE EDUCATION CLOUD | FEXLE SERVICES
SALESFORCE EDUCATION CLOUD | FEXLE SERVICES
 
Generative AI for Technical Writer or Information Developers
Generative AI for Technical Writer or Information DevelopersGenerative AI for Technical Writer or Information Developers
Generative AI for Technical Writer or Information Developers
 
TrustArc Webinar - How to Build Consumer Trust Through Data Privacy
TrustArc Webinar - How to Build Consumer Trust Through Data PrivacyTrustArc Webinar - How to Build Consumer Trust Through Data Privacy
TrustArc Webinar - How to Build Consumer Trust Through Data Privacy
 
DevoxxFR 2024 Reproducible Builds with Apache Maven
DevoxxFR 2024 Reproducible Builds with Apache MavenDevoxxFR 2024 Reproducible Builds with Apache Maven
DevoxxFR 2024 Reproducible Builds with Apache Maven
 
Transcript: New from BookNet Canada for 2024: Loan Stars - Tech Forum 2024
Transcript: New from BookNet Canada for 2024: Loan Stars - Tech Forum 2024Transcript: New from BookNet Canada for 2024: Loan Stars - Tech Forum 2024
Transcript: New from BookNet Canada for 2024: Loan Stars - Tech Forum 2024
 
Digital Identity is Under Attack: FIDO Paris Seminar.pptx
Digital Identity is Under Attack: FIDO Paris Seminar.pptxDigital Identity is Under Attack: FIDO Paris Seminar.pptx
Digital Identity is Under Attack: FIDO Paris Seminar.pptx
 
Tampa BSides - Chef's Tour of Microsoft Security Adoption Framework (SAF)
Tampa BSides - Chef's Tour of Microsoft Security Adoption Framework (SAF)Tampa BSides - Chef's Tour of Microsoft Security Adoption Framework (SAF)
Tampa BSides - Chef's Tour of Microsoft Security Adoption Framework (SAF)
 
SAP Build Work Zone - Overview L2-L3.pptx
SAP Build Work Zone - Overview L2-L3.pptxSAP Build Work Zone - Overview L2-L3.pptx
SAP Build Work Zone - Overview L2-L3.pptx
 
WordPress Websites for Engineers: Elevate Your Brand
WordPress Websites for Engineers: Elevate Your BrandWordPress Websites for Engineers: Elevate Your Brand
WordPress Websites for Engineers: Elevate Your Brand
 
New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
New from BookNet Canada for 2024: BNC CataList - Tech Forum 2024
 
How AI, OpenAI, and ChatGPT impact business and software.
How AI, OpenAI, and ChatGPT impact business and software.How AI, OpenAI, and ChatGPT impact business and software.
How AI, OpenAI, and ChatGPT impact business and software.
 

Linkedgov- intro at Opentech

  • 1. LINKEDGOV The tidying-government-data project Hadley Beeman @LinkedGov Hadley@LinkedGov.org @hadleybeeman 1
  • 2. HOW DOES THIS SOUND? Data from government Government departments Local authorities Quangos ata t d ata a or g d at a nsp in l d at ra end ica e d ata T p r S me anc nt d u N form eme Tidie er nag P a Decr d M Hum ypte Mach an-re d ine-r adable XML CSV RDF web search eada ble 2
  • 3. WHAT IS IN OUR WAY? Codes and acronyms Holes in the data Multiple formats Lack of modelling & connections http://www.flickr.com/photos/sybrenstuvel/2468506922 3
  • 5. CROWDSOURCING Decrypting budget codes and acronyms Adding labels and annotations A game! Hi! You work at the Department for Transport? Can you tell us what 072529-1092 means in the dataset Budget forecasts Q3 2010-11 DfT Programme to improve transport in the South East 5
  • 6. FORMATTING & LINKING DATA Connecting datasets Standardising headings Assigning URIs Reformatting the data 6
  • 7. ENGAGING GOVERNMENT What would you like to know? How many government employees work in Victoria St, SW1? Result: 201,570 Data sources: Westminster City Council Venues Reliability score: BIS employee distribution 8 DTI site census 7
  • 8. HOW CAN YOU HELP? Building LinkedGov: Keeping LinkedGov running: Systems architects Help us tidy & connect data Front end developers Share the wealth: tidy your data here Data standards enthusiasts Spread the word UX designers Gamers Data structure experts http://xkcd.com/552/ 8
  • 9. JOIN US! We need your ideas! Send an email with your thoughts to: JoinUs@LinkedGov.org Please let us know you’re interested by Mon 20 Sept. 9