-
Notifications
You must be signed in to change notification settings - Fork 0
/
yearly-bills-of-mortality-1657-1758.html
227 lines (172 loc) · 14.7 KB
/
yearly-bills-of-mortality-1657-1758.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
<!DOCTYPE html>
<html>
<head>
<!-- [[! Document Settings ]] -->
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!-- [[! Page Meta ]] -->
<title>Dataset: Yearly Bills of Mortality from 1657 to 1758</title>
<meta name="HandheldFriendly" content="True">
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="alternate" type="application/rss+xml" title="CuriousGnu - All Posts" href="https://www.curiousgnu.com/rss/">
<link rel="apple-touch-icon" sizes="57x57" href="/assets/favicons/apple-touch-icon-57x57.png">
<link rel="apple-touch-icon" sizes="60x60" href="/assets/favicons/apple-touch-icon-60x60.png">
<link rel="apple-touch-icon" sizes="72x72" href="/assets/favicons/apple-touch-icon-72x72.png">
<link rel="apple-touch-icon" sizes="76x76" href="/assets/favicons/apple-touch-icon-76x76.png">
<link rel="apple-touch-icon" sizes="114x114" href="/assets/favicons/apple-touch-icon-114x114.png">
<link rel="apple-touch-icon" sizes="120x120" href="/assets/favicons/apple-touch-icon-120x120.png">
<link rel="apple-touch-icon" sizes="144x144" href="/assets/favicons/apple-touch-icon-144x144.png">
<link rel="apple-touch-icon" sizes="152x152" href="/assets/favicons/apple-touch-icon-152x152.png">
<link rel="apple-touch-icon" sizes="180x180" href="/assets/favicons/apple-touch-icon-180x180.png">
<link rel="icon" type="image/png" href="/assets/favicons/favicon-32x32.png" sizes="32x32">
<link rel="icon" type="image/png" href="/assets/favicons/android-chrome-192x192.png" sizes="192x192">
<link rel="icon" type="image/png" href="/assets/favicons/favicon-96x96.png" sizes="96x96">
<link rel="icon" type="image/png" href="/assets/favicons/favicon-16x16.png" sizes="16x16">
<link rel="manifest" href="/assets/favicons/manifest.json">
<link rel="mask-icon" href="/assets/favicons/safari-pinned-tab.svg" color="#5bbad5">
<link rel="shortcut icon" href="/assets/favicons/favicon.ico">
<meta name="msapplication-TileColor" content="#da532c">
<meta name="msapplication-TileImage" content="/assets/favicons/mstile-144x144.png">
<meta name="msapplication-config" content="/assets/favicons/browserconfig.xml">
<meta name="theme-color" content="#ffffff">
<meta property="og:image" content="http://s3.amazonaws.com/cgcdn-static/bills-of-mortality-og.jpg">
<!-- [[! Styles'n'Scripts ]] -->
<link rel="stylesheet" type="text/css" href="/assets/css/screen.css">
<link rel="stylesheet" type="text/css" href="//fonts.googleapis.com/css?family=Merriweather:300,700,700italic,300italic|Open+Sans:700,400,200">
<link rel="stylesheet" type="text/css" href="/assets/css/syntax.css">
<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.css">
<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/highlight.js/9.3.0/styles/googlecode.min.css">
<!-- [[! Ghost outputs important style and meta data with this tag ]] -->
<meta name="referrer" content="origin" />
<link rel="next" href="/page2/" />
<meta name="generator" content="Jekyll 3.0.0" />
<link rel="alternate" type="application/rss+xml" title="CuriousGnu" href="/feed.xml" />
</head>
<body class="home-template nav-closed">
<div class="nav">
<h3 class="nav-title">Menu</h3>
<a href="#" class="nav-close">
<span class="hidden">Close</span>
</a>
<ul>
<li class="nav-home " role="presentation"><a href="/">Home</a></li>
<li class="nav-author " role="presentation"><a href="/author/CuriousGnu">Author</a></li>
<li class="nav-home" role="presentation"><a href="mailto:contact@curiousgnu.com">Contact</a></li>
</ul>
<a class="subscribe-button icon-feed" href="https://www.curiousgnu.com/rss/">Subscribe</a>
</div>
<span class="nav-cover"></span>
<div class="site-wrapper">
<!-- [[! Everything else gets inserted here ]] -->
<!-- < default -->
<!-- The comment above "< default" means - insert everything in this file into -->
<!-- the [body] of the default.hbs template, which contains our header/footer. -->
<!-- Everything inside the #post tags pulls data from the post -->
<!-- #post -->
<header class="main-header no-cover post-head">
<nav class="main-nav overlay clearfix">
<a class="blog-logo" href="/"><img src="/assets/images/logo.png" alt="Blog Logo" /></a>
<a class="menu-button icon-menu" href="#"><span class="word">Menu</span></a>
</nav>
</header>
<main class="content" role="main">
<article class="post post-template">
<header class="post-header">
<h1 class="post-title">Dataset: Yearly Bills of Mortality from 1657 to 1758</h1>
<section class="post-meta">
<!-- <a href='/'>CuriousGnu</a> -->
<time class="post-date" datetime="2017-02-22">22 Feb 2017</time>
<!-- [[tags prefix=" on "]] -->
on
<a href='/tag/Dataset'>Dataset</a>
</section>
</header>
<section class="post-content">
<p>In this blog post, I would like to share the <em>Yearly Bills of Mortality</em> dataset that I recently generated. The <em>Bills of Mortality</em> were a mortality statistic for London and were first published in the 17th century. Besides the number of deaths, they also provide information about the cause of death since 1629. The first time I read about these documents was in a <cite><a href="http://www.telegraph.co.uk/news/science/science-news/8934045/Historic-medical-records-show-deaths-from-lethargy-and-itch.html">newspaper article</a></cite> in The Telegraph about the absurdly sounding causes of death such as itch, lethargy, or grief.</p>
<p><a href="/assets/images/bills-of-mortality/itch.jpg"><img src="/assets/images/bills-of-mortality/itch.jpg" alt="Bills of Mortality - Itch" style="max-width: 300px" /></a></p>
<p>Interestingly, Google digitized the book <em>“Collection of Yearly Bills of Mortality, from 1657 to 1758 Inclusive”</em> and made it available through <cite><a href="https://books.google.com/books/about/Collection_of_Yearly_Bills_of_Mortality.html?id=3wYAAAAAMAAJ">Google Books</a></cite>. In addition to that, <cite><a href="https://archive.org/details/collectionyearl00hebegoog">archive.org</a></cite> offers those scans in a variety of formats. Unfortunately, Google’s optical character recognition (OCR) does not work particularly well on historical documents especially if the data is presented in tables, which makes searching the PDF and analyzing the changes in certain numbers difficult.</p>
<p>Finding those kinds of statistics rather intriguing, I considered the <em>Yearly Bills of Mortality</em> to be a perfect test case for manual data entry services that I am currently testing. The task was to convert the “Diseases and Casualties” table of 102 pages into an Excel table. In the case of different variants of the same causes of death (e.g., <em>hang’d</em> and <em>hanged</em>), a consistent form of spelling was used.</p>
<p><a href="/assets/images/bills-of-mortality/page.jpg"><img src="/assets/images/bills-of-mortality/page.jpg" alt="Bills of Mortality - Page" style="max-width: 500px" /></a></p>
<p>If you are also interested in this subject or just want to explore what killed Londoners between the years 1657 and 1758, you can download the complete dataset here <cite><a href="https://s3.amazonaws.com/cgcdn-misc/yearly_bills_of_mortality_1657_1758.zip">CSV file</a></cite>. Additionally, I uploaded the data to <cite><a href="https://public.tableau.com/profile/curious.gnu#!/vizhome/YearlyBillsofMortality1657-1758/Dashboard1">Tableau Public</a></cite>; you can try it out in the interactive graph below. Please note that I of course cannot guarantee the accuracy of the dataset.</p>
<div class="tableauPlaceholder" id="viz1487713662489" style="position: relative"><noscript><a href="https://www.curiousgnu.com"><img alt="Dashboard 1 " src="https://public.tableau.com/static/images/Ye/YearlyBillsofMortality1657-1758/Dashboard1/1_rss.png" style="border: none" /></a></noscript><object class="tableauViz" style="display:none;"><param name="host_url" value="https%3A%2F%2Fpublic.tableau.com%2F" /> <param name="site_root" value="" /><param name="name" value="YearlyBillsofMortality1657-1758/Dashboard1" /><param name="tabs" value="no" /><param name="toolbar" value="no" /><param name="static_image" value="https://public.tableau.com/static/images/Ye/YearlyBillsofMortality1657-1758/Dashboard1/1.png" /> <param name="animate_transition" value="yes" /><param name="display_static_image" value="yes" /><param name="display_spinner" value="yes" /><param name="display_overlay" value="yes" /><param name="display_count" value="yes" /></object></div>
<script type="text/javascript"> var divElement = document.getElementById('viz1487713662489'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>
<p><br /></p>
<p>In case the graph does not work in your browser, please use this direct link <cite><a href="https://public.tableau.com/profile/curious.gnu#!/vizhome/YearlyBillsofMortality1657-1758/Dashboard1">public.tableau.com</a></cite>. If you have questions or concerns, feel free to write me an <a href="mailto:contact@curiousgnu.com">email</a>.</p>
</section>
<footer class="post-footer">
<!-- Everything inside the #author tags pulls data from the author -->
<!-- #author-->
<figure class="author-image">
<a class="img" href="/author/CuriousGnu" style="background-image: url(/assets/images/casper.png)"><span class="hidden">'s Picture</span></a>
</figure>
<section class="author">
<h4><a href="/author/CuriousGnu">CuriousGnu</a></h4>
<p> I'm Alex, a data and visualization nerd. In this blog, I write from an analyst's point of view about a wide variety of topics ranging from Hollywood movies to crime statistics. I'm constantly looking for public data sources that reveal interesting trends or simply serve as a basis for a fun graph.</p>
<div class="author-meta">
<span class="author-link icon-email"><a href="mailto:contact@curiousgnu.com" target="_top"> contact@curiousgnu.com</a></span>
<span class="author-link icon-link"><a href="/">www.curiousgnu.com</a></span>
</div>
</section>
<!-- /author -->
<section class="share">
<h4>Share this post</h4>
<a class="icon-twitter" href="http://twitter.com/share?text=Dataset: Yearly Bills of Mortality from 1657 to 1758&url=https://www.curiousgnu.com/yearly-bills-of-mortality-1657-1758"
onclick="window.open(this.href, 'twitter-share', 'width=550,height=235');return false;">
<span class="hidden">Twitter</span>
</a>
<a class="icon-facebook" href="https://www.facebook.com/sharer/sharer.php?u=https://www.curiousgnu.com/yearly-bills-of-mortality-1657-1758"
onclick="window.open(this.href, 'facebook-share','width=580,height=296');return false;">
<span class="hidden">Facebook</span>
</a>
<a class="icon-google-plus" href="https://plus.google.com/share?url=https://www.curiousgnu.com/yearly-bills-of-mortality-1657-1758"
onclick="window.open(this.href, 'google-plus-share', 'width=490,height=530');return false;">
<span class="hidden">Google+</span>
</a>
<a href='http://cloud.feedly.com/#subscription%2Ffeed%2Fhttp%3A%2F%2Fwww.curiousgnu.com%2Frss%2F' target='blank'><img id='feedlyFollow' src='/assets/images/feedly-follow-rectangle-flat-small_2x.png' alt='follow us in feedly' width='66' height='20'></a>
</section>
</footer>
</article>
</main>
<aside class="read-next">
<!-- [[! next_post ]] -->
<a class="read-next-story " style="background-image: url(/assets/images/youtube-comments/cover.jpg)" href="/youtube-comments-text-analysis">
<section class="post">
<h2>Text Analysis of YouTube Comments</h2>
<p>According to Alexa.com, an Amazon subsidiary that analysis web traffic, YouTube is the world’s most...</p>
</section>
</a>
<!-- [[! /next_post ]] -->
<!-- [[! prev_post ]] -->
<a class="read-next-story prev " style="background-image: url(/assets/images/manhattan-traffic-collisions/cover.jpg)" href="/manhattan-traffic-collitions">
<section class="post">
<h2 class="title-sm">Visualization: Traffic Collisions in Manhattan</h2>
<p>Today’s blog post is a visualization of traffic collisions in New York City. The New...</p>
</section>
</a>
<!-- [[! /prev_post ]] -->
</aside>
<!-- /post -->
<footer class="site-footer clearfix">
<section class="copyright"><a href="/">CuriousGnu</a> © 2017</section>
<section class="poweredby">Proudly published with <a href="https://jekyllrb.com/">Jekyll</a>
</section>
</footer>
</div>
<!-- [[! Ghost outputs important scripts and data with this tag ]] -->
<script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/jquery/1.12.1/jquery.min.js"></script>
<!-- [[! The main JavaScript file for Casper ]] -->
<script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/fitvids/1.1.0/jquery.fitvids.min.js"></script>
<script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/highlight.js/9.3.0/highlight.min.js"></script>
<script type="text/javascript" src="/assets/js/index.js"></script>
<!-- Add Google Analytics -->
<!-- Google Analytics Tracking code -->
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-74290781-1', 'auto');
ga('send', 'pageview');
</script>
</body>
</html>