User:Arthurwolf~enwiki
New Measles Graph
[edit]The current Wikipedia page Measles_vaccine provides graphs for cases per year for the US and UK.
I would like to improve that page by providing both the cases and the deaths data, only for the US for now, either by creating a dedicated deaths graph or by improving the existing graph with the death data on top of the current cases data.
Tools
[edit]Trying to use this template as the generator for the graph: https://commons.wikimedia.org/wiki/Template:SVG_Chart
Sources
[edit]- For deaths : Root CDC data repository : Vital Statistics of the United States
- Vital Statistics Rates in the United States, 1900-1940, various tables, Measles data
- Vital Statistics Rates in the United States, 1940-1960, table 65: Death rates for detailed causes, Measles data
- Statistics for 1960-1964, document for each year.
- Statistics for 1965-1979, document for each year.
- For cases :
- Data Source for the number of cases ( and not deaths ), the same source as the original graph I am trying to improve or replace.
There is also some sort of query system allowing to get raw data in easily re-usable formats by defining searches. I was able to get pretty far with the system, selecting for all measles deaths stats in the 20th century, but for some reason was not able to get to usable data. If somebody knows how to use this tool and obtain the data I would be very interested to know what I did wrong, as it seems like a very cool tool.
Raw Data
[edit]Measles Deaths per 100 000 population, per year, extracted manually from the documents in the Sources section
[edit]1900 13.3 1901 7.4 1902 9.3 1903 8.8 1904 11.3 1905 7.4 1906 12.9 1907 9.6 1908 10.6 1909 10.0 1910 12.4 1911 9.9 1912 7.2 1913 12.8 1914 6.8 1915 5.2 1916 11.4 1917 14.1 1918 10.8 1919 3.9 1920 8.8 1921 4.2 1922 4.3 1923 10.7 1924 7.9 1925 8.0 1926 9.8 1927 2.8 1928 4.2 1929 2.7 1930 3.2 1931 3.0 1932 1.6 1933 2.2 1934 5.5 1935 3.1 1936 1.0 1937 1.2 1938 2.5 1940 0.5 1941 1.7 1942 1.0 1943 1.0 1944 1.4 1945 0.2 1946 0.9 1947 0.3 1948 0.6 1949 0.6 1950 0.3 1951 0.4 1952 0.4 1953 0.3 1954 0.3 1955 0.2 1956 0.3 1957 0.2 1958 0.3 1959 0.2 1960 0.2 1961 0.2 1962 0.2 1963 0.2 1964 0.2 1965 0.2 1966 0.1 1967 0.1 1968 0 1969 0 1970 0 Deaths total, independent of the total population 1982 2 1983 4 1984 1 1985 4 1986 2 1987 2 1988 3 1989 32 1990 64 1991 27
Note: I could not find the data for 1939 anywhere, it is missing from all the documents I searched. I left the year empty/missing in my data, so the graphing tool/template will simply trace a line from 1938 to 1940 directly. I do not think this will have a very big impact on what the data shows overall.
If somebody has the data I would be very interrested in it. Or if you have some explanation for why I couldn't find it, that would be great too.
It just now occurs to me that 1939 isn't just any year, maybe that's related?
Measles cases in the United States, per year, extracted from the same source as the original graph
[edit]1944 650291 1945 146013 1946 659843 1947 222375 1948 615104 1949 625281 1950 319124 1951 530118 1952 683077 1953 449146 1954 682720 1955 555156 1956 611936 1957 486799 1958 763094 1959 406162 1960 441703 1961 423919 1962 481530 1963 385156 1964 458083 1965 261904 1966 204136 1967 62705 1968 22231 1969 25826 1970 47351 1971 75290 1972 32275 1973 26690 1974 22094 1975 24374 1976 41126 1977 57345 1978 26871 1979 13597 1980 13506 1981 2124 1982 1714 1983 1497 1984 2587 1985 2822 1986 6282 1987 3655 1988 3396 1989 18193 1990 27786 1991 9643 1992 2237 1993 312
Template
[edit]For reference, here is how I am using the template :
{{SVG Chart | Title = Cases reported to CDC and deaths per 100000 per year in the United States | Description = Data source : CDC | XAxisText = Year | LegendType = box | XMin = 1900 | XMax = 2000 | YMin = 0 | YMax = 16 | YAxisText = Deaths per 100000 | YAxis2Text = Cases | YAxis2TextX = 150 | YAxis2MarkStep = 5 | YAxis2ValueStep = 250000 <!-- this makes the displayed values right --> | FontSize = 60 | GraphStretchHeight = 300 | GraphWidth = 40 | LegendX = 65 | LegendY = 95 | LegendFontSize = 40 | LegendWidth = 155 | Graph1Text = Deaths per 100000 | Graph2Text = Cases reported to CDC | Graph3Text = 1963 : Vaccine use starts | Graph4Text = 1989 : Second dose recommendation | Graph1Values = 1900 13.3 1901 7.4 1902 9.3 1903 8.8 1904 11.3 1905 7.4 1906 12.9 1907 9.6 1908 10.6 1909 10.0 1910 12.4 1911 9.9 1912 7.2 1913 12.8 1914 6.8 1915 5.2 1916 11.4 1917 14.1 1918 10.8 1919 3.9 1920 8.8 1921 4.2 1922 4.3 1923 10.7 1924 7.9 1925 8.0 1926 9.8 1927 2.8 1928 4.2 1929 2.7 1930 3.2 1931 3.0 1932 1.6 1933 2.2 1934 5.5 1935 3.1 1936 1.0 1937 1.2 1938 2.5 1940 0.5 1941 1.7 1942 1.0 1943 1.0 1944 1.4 1945 0.2 1946 0.9 1947 0.3 1948 0.6 1949 0.6 1950 0.3 1951 0.4 1952 0.4 1953 0.3 1954 0.3 1955 0.2 1956 0.3 1957 0.2 1958 0.3 1959 0.2 1960 0.2 1961 0.2 1962 0.2 1963 0.2 1964 0.2 1965 0.2 1966 0.1 1967 0.1 1968 0 1969 0 1970 0 | Graph2Values = 1944 13.00582 1945 2.92026 1946 13.19686 1947 4.4475 1948 12.30208 1949 12.50562 1950 6.38248 1951 10.60236 1952 13.66154 1953 8.98292 1954 13.6544 1955 11.10312 1956 12.23872 1957 9.73598 1958 15.26188 1959 8.12324 1960 8.83406 1961 8.47838 1962 9.6306 1963 7.70312 1964 9.16166 1965 5.23808 1966 4.08272 1967 1.2541 1968 0.44462 1969 0.51652 1970 0.94702 1971 1.5058 1972 0.6455 1973 0.5338 1974 0.44188 1975 0.48748 1976 0.82252 1977 1.1469 1978 0.53742 1979 0.27194 1980 0.27012 1981 0.04248 1982 0.03428 1983 0.02994 1984 0.05174 1985 0.05644 1986 0.12564 1987 0.0731 1988 0.06792 1989 0.36386 1990 0.55572 1991 0.19286 1992 0.04474 1993 0.00624 | Graph3Values = 1963 0 1963.001 16 | Graph4Values = 1989 0 1989.001 13 }}