Background

In the previous post on this blog, we introduced the idea of taking data that public servants routinely use and turning it into a figure that can be easily updated each time new data is added.

However, there was a step missing in that explanation: getting the data in a suitable shape.

But this is a really important function of a government data scientist (or any data scientist) because data is stored and shared in all sorts of shapes and sizes but to analyse it in R, we really need it in the shape that R needs.

So, this is a blog post about getting data into the shape needed for analysis.

Tidying up

First, we need to load the necessary packages. For locating the files on the system we need here, for reading in the original file we need readxl, for doing all the re-shaping we need tidyverse and for viewing the tables of data we need knitr.

library(here)
library(readxl)
library(tidyverse)
library(knitr)

We can have a look at the original data set in this way

sa_pop <- read_excel(here("static/3101054.xls"), 
sheet = "Data1")

sa_pop %>%
  kable()
…1 Estimated Resident Population ; Male ; 0 ; Estimated Resident Population ; Male ; 1 ; Estimated Resident Population ; Male ; 2 ; Estimated Resident Population ; Male ; 3 ; Estimated Resident Population ; Male ; 4 ; Estimated Resident Population ; Male ; 5 ; Estimated Resident Population ; Male ; 6 ; Estimated Resident Population ; Male ; 7 ; Estimated Resident Population ; Male ; 8 ; Estimated Resident Population ; Male ; 9 ; Estimated Resident Population ; Male ; 10 ; Estimated Resident Population ; Male ; 11 ; Estimated Resident Population ; Male ; 12 ; Estimated Resident Population ; Male ; 13 ; Estimated Resident Population ; Male ; 14 ; Estimated Resident Population ; Male ; 15 ; Estimated Resident Population ; Male ; 16 ; Estimated Resident Population ; Male ; 17 ; Estimated Resident Population ; Male ; 18 ; Estimated Resident Population ; Male ; 19 ; Estimated Resident Population ; Male ; 20 ; Estimated Resident Population ; Male ; 21 ; Estimated Resident Population ; Male ; 22 ; Estimated Resident Population ; Male ; 23 ; Estimated Resident Population ; Male ; 24 ; Estimated Resident Population ; Male ; 25 ; Estimated Resident Population ; Male ; 26 ; Estimated Resident Population ; Male ; 27 ; Estimated Resident Population ; Male ; 28 ; Estimated Resident Population ; Male ; 29 ; Estimated Resident Population ; Male ; 30 ; Estimated Resident Population ; Male ; 31 ; Estimated Resident Population ; Male ; 32 ; Estimated Resident Population ; Male ; 33 ; Estimated Resident Population ; Male ; 34 ; Estimated Resident Population ; Male ; 35 ; Estimated Resident Population ; Male ; 36 ; Estimated Resident Population ; Male ; 37 ; Estimated Resident Population ; Male ; 38 ; Estimated Resident Population ; Male ; 39 ; Estimated Resident Population ; Male ; 40 ; Estimated Resident Population ; Male ; 41 ; Estimated Resident Population ; Male ; 42 ; Estimated Resident Population ; Male ; 43 ; Estimated Resident Population ; Male ; 44 ; Estimated Resident Population ; Male ; 45 ; Estimated Resident Population ; Male ; 46 ; Estimated Resident Population ; Male ; 47 ; Estimated Resident Population ; Male ; 48 ; Estimated Resident Population ; Male ; 49 ; Estimated Resident Population ; Male ; 50 ; Estimated Resident Population ; Male ; 51 ; Estimated Resident Population ; Male ; 52 ; Estimated Resident Population ; Male ; 53 ; Estimated Resident Population ; Male ; 54 ; Estimated Resident Population ; Male ; 55 ; Estimated Resident Population ; Male ; 56 ; Estimated Resident Population ; Male ; 57 ; Estimated Resident Population ; Male ; 58 ; Estimated Resident Population ; Male ; 59 ; Estimated Resident Population ; Male ; 60 ; Estimated Resident Population ; Male ; 61 ; Estimated Resident Population ; Male ; 62 ; Estimated Resident Population ; Male ; 63 ; Estimated Resident Population ; Male ; 64 ; Estimated Resident Population ; Male ; 65 ; Estimated Resident Population ; Male ; 66 ; Estimated Resident Population ; Male ; 67 ; Estimated Resident Population ; Male ; 68 ; Estimated Resident Population ; Male ; 69 ; Estimated Resident Population ; Male ; 70 ; Estimated Resident Population ; Male ; 71 ; Estimated Resident Population ; Male ; 72 ; Estimated Resident Population ; Male ; 73 ; Estimated Resident Population ; Male ; 74 ; Estimated Resident Population ; Male ; 75 ; Estimated Resident Population ; Male ; 76 ; Estimated Resident Population ; Male ; 77 ; Estimated Resident Population ; Male ; 78 ; Estimated Resident Population ; Male ; 79 ; Estimated Resident Population ; Male ; 80 ; Estimated Resident Population ; Male ; 81 ; Estimated Resident Population ; Male ; 82 ; Estimated Resident Population ; Male ; 83 ; Estimated Resident Population ; Male ; 84 ; Estimated Resident Population ; Male ; 85 ; Estimated Resident Population ; Male ; 86 ; Estimated Resident Population ; Male ; 87 ; Estimated Resident Population ; Male ; 88 ; Estimated Resident Population ; Male ; 89 ; Estimated Resident Population ; Male ; 90 ; Estimated Resident Population ; Male ; 91 ; Estimated Resident Population ; Male ; 92 ; Estimated Resident Population ; Male ; 93 ; Estimated Resident Population ; Male ; 94 ; Estimated Resident Population ; Male ; 95 ; Estimated Resident Population ; Male ; 96 ; Estimated Resident Population ; Male ; 97 ; Estimated Resident Population ; Male ; 98 ; Estimated Resident Population ; Male ; 99 ; Estimated Resident Population ; Male ; 100 and over ; Estimated Resident Population ; Female ; 0 ; Estimated Resident Population ; Female ; 1 ; Estimated Resident Population ; Female ; 2 ; Estimated Resident Population ; Female ; 3 ; Estimated Resident Population ; Female ; 4 ; Estimated Resident Population ; Female ; 5 ; Estimated Resident Population ; Female ; 6 ; Estimated Resident Population ; Female ; 7 ; Estimated Resident Population ; Female ; 8 ; Estimated Resident Population ; Female ; 9 ; Estimated Resident Population ; Female ; 10 ; Estimated Resident Population ; Female ; 11 ; Estimated Resident Population ; Female ; 12 ; Estimated Resident Population ; Female ; 13 ; Estimated Resident Population ; Female ; 14 ; Estimated Resident Population ; Female ; 15 ; Estimated Resident Population ; Female ; 16 ; Estimated Resident Population ; Female ; 17 ; Estimated Resident Population ; Female ; 18 ; Estimated Resident Population ; Female ; 19 ; Estimated Resident Population ; Female ; 20 ; Estimated Resident Population ; Female ; 21 ; Estimated Resident Population ; Female ; 22 ; Estimated Resident Population ; Female ; 23 ; Estimated Resident Population ; Female ; 24 ; Estimated Resident Population ; Female ; 25 ; Estimated Resident Population ; Female ; 26 ; Estimated Resident Population ; Female ; 27 ; Estimated Resident Population ; Female ; 28 ; Estimated Resident Population ; Female ; 29 ; Estimated Resident Population ; Female ; 30 ; Estimated Resident Population ; Female ; 31 ; Estimated Resident Population ; Female ; 32 ; Estimated Resident Population ; Female ; 33 ; Estimated Resident Population ; Female ; 34 ; Estimated Resident Population ; Female ; 35 ; Estimated Resident Population ; Female ; 36 ; Estimated Resident Population ; Female ; 37 ; Estimated Resident Population ; Female ; 38 ; Estimated Resident Population ; Female ; 39 ; Estimated Resident Population ; Female ; 40 ; Estimated Resident Population ; Female ; 41 ; Estimated Resident Population ; Female ; 42 ; Estimated Resident Population ; Female ; 43 ; Estimated Resident Population ; Female ; 44 ; Estimated Resident Population ; Female ; 45 ; Estimated Resident Population ; Female ; 46 ; Estimated Resident Population ; Female ; 47 ; Estimated Resident Population ; Female ; 48 ; Estimated Resident Population ; Female ; 49 ; Estimated Resident Population ; Female ; 50 ; Estimated Resident Population ; Female ; 51 ; Estimated Resident Population ; Female ; 52 ; Estimated Resident Population ; Female ; 53 ; Estimated Resident Population ; Female ; 54 ; Estimated Resident Population ; Female ; 55 ; Estimated Resident Population ; Female ; 56 ; Estimated Resident Population ; Female ; 57 ; Estimated Resident Population ; Female ; 58 ; Estimated Resident Population ; Female ; 59 ; Estimated Resident Population ; Female ; 60 ; Estimated Resident Population ; Female ; 61 ; Estimated Resident Population ; Female ; 62 ; Estimated Resident Population ; Female ; 63 ; Estimated Resident Population ; Female ; 64 ; Estimated Resident Population ; Female ; 65 ; Estimated Resident Population ; Female ; 66 ; Estimated Resident Population ; Female ; 67 ; Estimated Resident Population ; Female ; 68 ; Estimated Resident Population ; Female ; 69 ; Estimated Resident Population ; Female ; 70 ; Estimated Resident Population ; Female ; 71 ; Estimated Resident Population ; Female ; 72 ; Estimated Resident Population ; Female ; 73 ; Estimated Resident Population ; Female ; 74 ; Estimated Resident Population ; Female ; 75 ; Estimated Resident Population ; Female ; 76 ; Estimated Resident Population ; Female ; 77 ; Estimated Resident Population ; Female ; 78 ; Estimated Resident Population ; Female ; 79 ; Estimated Resident Population ; Female ; 80 ; Estimated Resident Population ; Female ; 81 ; Estimated Resident Population ; Female ; 82 ; Estimated Resident Population ; Female ; 83 ; Estimated Resident Population ; Female ; 84 ; Estimated Resident Population ; Female ; 85 ; Estimated Resident Population ; Female ; 86 ; Estimated Resident Population ; Female ; 87 ; Estimated Resident Population ; Female ; 88 ; Estimated Resident Population ; Female ; 89 ; Estimated Resident Population ; Female ; 90 ; Estimated Resident Population ; Female ; 91 ; Estimated Resident Population ; Female ; 92 ; Estimated Resident Population ; Female ; 93 ; Estimated Resident Population ; Female ; 94 ; Estimated Resident Population ; Female ; 95 ; Estimated Resident Population ; Female ; 96 ; Estimated Resident Population ; Female ; 97 ; Estimated Resident Population ; Female ; 98 ; Estimated Resident Population ; Female ; 99 ; Estimated Resident Population ; Female ; 100 and over ; Estimated Resident Population ; Persons ; 0 ; Estimated Resident Population ; Persons ; 1 ; Estimated Resident Population ; Persons ; 2 ; Estimated Resident Population ; Persons ; 3 ; Estimated Resident Population ; Persons ; 4 ; Estimated Resident Population ; Persons ; 5 ; Estimated Resident Population ; Persons ; 6 ; Estimated Resident Population ; Persons ; 7 ; Estimated Resident Population ; Persons ; 8 ; Estimated Resident Population ; Persons ; 9 ; Estimated Resident Population ; Persons ; 10 ; Estimated Resident Population ; Persons ; 11 ; Estimated Resident Population ; Persons ; 12 ; Estimated Resident Population ; Persons ; 13 ; Estimated Resident Population ; Persons ; 14 ; Estimated Resident Population ; Persons ; 15 ; Estimated Resident Population ; Persons ; 16 ; Estimated Resident Population ; Persons ; 17 ; Estimated Resident Population ; Persons ; 18 ; Estimated Resident Population ; Persons ; 19 ; Estimated Resident Population ; Persons ; 20 ; Estimated Resident Population ; Persons ; 21 ; Estimated Resident Population ; Persons ; 22 ; Estimated Resident Population ; Persons ; 23 ; Estimated Resident Population ; Persons ; 24 ; Estimated Resident Population ; Persons ; 25 ; Estimated Resident Population ; Persons ; 26 ; Estimated Resident Population ; Persons ; 27 ; Estimated Resident Population ; Persons ; 28 ; Estimated Resident Population ; Persons ; 29 ; Estimated Resident Population ; Persons ; 30 ; Estimated Resident Population ; Persons ; 31 ; Estimated Resident Population ; Persons ; 32 ; Estimated Resident Population ; Persons ; 33 ; Estimated Resident Population ; Persons ; 34 ; Estimated Resident Population ; Persons ; 35 ; Estimated Resident Population ; Persons ; 36 ; Estimated Resident Population ; Persons ; 37 ; Estimated Resident Population ; Persons ; 38 ; Estimated Resident Population ; Persons ; 39 ; Estimated Resident Population ; Persons ; 40 ; Estimated Resident Population ; Persons ; 41 ; Estimated Resident Population ; Persons ; 42 ; Estimated Resident Population ; Persons ; 43 ; Estimated Resident Population ; Persons ; 44 ; Estimated Resident Population ; Persons ; 45 ; Estimated Resident Population ; Persons ; 46 ; Estimated Resident Population ; Persons ; 47 ;
Unit Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons Persons
Series Type Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original Original
Data Type STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK STOCK
Frequency Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual
Collection Month 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12
Series Start 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085 26085
Series End 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252 43252
No. Obs 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48
Series ID A2157405W A2157406X A2157407A A2157408C A2157409F A2157410R A2157411T A2157412V A2157413W A2157414X A2157415A A2157416C A2157417F A2157418J A2157419K A2157420V A2157421W A2157422X A2157423A A2157424C A2157425F A2157426J A2157427K A2157428L A2157429R A2157430X A2157431A A2157432C A2157433F A2157434J A2157435K A2157436L A2157437R A2157438T A2157439V A2157440C A2157441F A2157442J A2157443K A2157444L A2157445R A2157446T A2157447V A2157448W A2157449X A2157450J A2157451K A2157452L A2157453R A2157454T A2157455V A2157456W A2157457X A2157458A A2157459C A2157460L A2157461R A2157462T A2157463V A2157464W A2157465X A2157466A A2157467C A2157468F A2157469J A2157470T A2157471V A2157472W A2157473X A2157474A A2157475C A2157476F A2157477J A2157478K A2157479L A2157480W A2157481X A2157482A A2157483C A2157484F A2157485J A2157486K A2157487L A2157488R A2157489T A2157490A A2157491C A2157492F A2157493J A2157494K A2157495L A2157496R A2157497T A2157498V A2157499W A2157500V A2157501W A2157502X A2157503A A2157504C A2157505F A2157506J A2157507K A2157508L A2157509R A2157510X A2157511A A2157512C A2157513F A2157514J A2157515K A2157516L A2157517R A2157518T A2157519V A2157520C A2157521F A2157522J A2157523K A2157524L A2157525R A2157526T A2157527V A2157528W A2157529X A2157530J A2157531K A2157532L A2157533R A2157534T A2157535V A2157536W A2157537X A2157538A A2157539C A2157540L A2157541R A2157542T A2157543V A2157544W A2157545X A2157546A A2157547C A2157548F A2157549J A2157550T A2157551V A2157552W A2157553X A2157554A A2157555C A2157556F A2157557J A2157558K A2157559L A2157560W A2157561X A2157562A A2157563C A2157564F A2157565J A2157566K A2157567L A2157568R A2157569T A2157570A A2157571C A2157572F A2157573J A2157574K A2157575L A2157576R A2157577T A2157578V A2157579W A2157580F A2157581J A2157582K A2157583L A2157584R A2157585T A2157586V A2157587W A2157588X A2157589A A2157590K A2157591L A2157592R A2157593T A2157594V A2157595W A2157596X A2157597A A2157598C A2157599F A2157600C A2157601F A2157602J A2157603K A2157604L A2157605R A2157606T A2157607V A2157608W A2157609X A2157610J A2157611K A2157612L A2157613R A2157614T A2157615V A2157616W A2157617X A2157618A A2157619C A2157620L A2157621R A2157622T A2157623V A2157624W A2157625X A2157626A A2157627C A2157628F A2157629J A2157630T A2157631V A2157632W A2157633X A2157634A A2157635C A2157636F A2157637J A2157638K A2157639L A2157640W A2157641X A2157642A A2157643C A2157644F A2157645J A2157646K A2157647L A2157648R A2157649T A2157650A A2157651C A2157652F A2157653J A2157654K
26085 11417 11223 11318 11211 10915 11194 11432 12024 12191 12224 12643 12273 12303 12066 11887 11552 11316 10874 10741 10333 10071 10256 9886 10009 11119 8989 8746 8341 7844 7867 7487 7205 7215 6921 6902 7049 6735 6639 6874 6794 7438 7594 7822 7969 7700 8117 7760 7597 7414 7415 7657 6729 6009 5824 6009 5874 6084 6154 5805 5474 5009 4764 4735 4292 3983 4042 3515 3469 3130 2893 2745 2542 2264 1940 1799 1656 1630 1441 1407 1243 1146 934 884 753 639 516 412 361 260 170 131 124 57 45 38 26 19 7 10 6 4 10767 10877 10975 10643 10398 10756 10749 11246 11616 11909 12203 11969 11966 11536 11517 11244 10921 10757 10852 10364 10241 10134 9957 9902 10839 8680 8675 8117 7643 7393 7148 7047 7233 6814 6917 6844 6483 6505 6575 6584 7384 6731 7292 7318 7286 7640 7667 7289 7408 7394 7502 6485 6026 6085 5957 5759 6073 6007 5864 5550 5679 4929 5068 4763 4417 4349 4040 3763 3539 3450 3601 3435 3082 2905 2876 2883 2658 2432 2278 2179 2054 1641 1535 1323 1175 1034 852 703 511 456 326 264 199 130 93 77 38 34 28 16 14 22184 22100 22293 21854 21313 21950 22181 23270 23807 24133 24846 24242 24269 23602 23404 22796 22237 21631 21593 20697 20312 20390 19843 19911 21958 17669 17421 16458 15487 15260 14635 14252 14448 13735 13819 13893 13218 13144 13449 13378 14822 14325 15114 15287 14986 15757 15427 14886
26451 11342 11519 11289 11364 11247 10909 11256 11457 12045 12227 12231 12700 12379 12319 12029 11850 11490 11188 10745 10622 10279 9993 10283 9937 10041 11199 9061 8777 8397 7950 7892 7517 7220 7215 6948 6967 7063 6646 6667 6899 6798 7376 7623 7788 7947 7724 8077 7678 7590 7378 7366 7581 6726 5991 5790 5970 5799 5982 6095 5648 5406 4934 4663 4605 4198 3893 3931 3413 3341 3006 2774 2607 2393 2119 1833 1635 1526 1485 1336 1277 1119 1018 825 767 637 534 422 334 274 194 130 100 93 45 29 28 18 13 3 6 4 10735 10833 10903 11023 10685 10427 10751 10768 11287 11645 11879 12247 12014 11959 11531 11458 11106 10788 10701 10769 10263 10149 10009 9845 9994 10987 8685 8708 8215 7692 7424 7171 7128 7179 6867 6932 6852 6429 6525 6513 6536 7361 6752 7226 7293 7298 7612 7582 7272 7381 7357 7446 6518 5979 6047 5915 5783 6020 6005 5825 5547 5636 4951 4992 4747 4339 4304 4002 3692 3464 3389 3507 3363 2972 2810 2755 2767 2516 2322 2168 2053 1903 1520 1386 1190 1044 912 735 598 415 376 261 204 150 95 69 58 27 20 16 15 22077 22352 22192 22387 21932 21336 22007 22225 23332 23872 24110 24947 24393 24278 23560 23308 22596 21976 21446 21391 20542 20142 20292 19782 20035 22186 17746 17485 16612 15642 15316 14688 14348 14394 13815 13899 13915 13075 13192 13412 13334 14737 14375 15014 15240 15022 15689 15260
26816 10749 11382 11664 11357 11410 11283 10897 11323 11484 12076 12269 12241 12759 12465 12286 11931 11760 11392 11080 10656 10548 10285 9976 10363 10025 10092 11308 9156 8821 8454 8050 7909 7531 7229 7218 6983 7041 7090 6562 6682 6907 6782 7312 7646 7737 7916 7749 8044 7594 7563 7327 7323 7495 6719 5958 5739 5902 5708 5862 6033 5501 5345 4852 4531 4449 4100 3797 3791 3287 3195 2880 2657 2467 2239 1968 1706 1492 1425 1331 1220 1147 981 903 713 647 539 450 352 274 223 152 105 77 69 34 15 20 16 9 1 6 10281 10746 10940 10946 11076 10721 10449 10750 10786 11328 11671 11849 12278 12048 11943 11514 11387 10974 10668 10662 10674 10158 10101 9961 9854 10158 11057 8703 8758 8318 7741 7461 7191 7207 7125 6920 6946 6860 6374 6546 6445 6489 7342 6764 7153 7263 7301 7570 7493 7233 7351 7320 7388 6549 5938 6012 5873 5806 5975 5994 5800 5547 5583 4966 4909 4729 4263 4257 3972 3628 3382 3315 3419 3301 2857 2704 2641 2631 2371 2210 2041 1900 1721 1401 1261 1060 916 788 615 506 345 300 206 151 111 62 50 47 18 15 18 21030 22128 22604 22303 22486 22004 21346 22073 22270 23404 23940 24090 25037 24513 24229 23445 23147 22366 21748 21318 21222 20443 20077 20324 19879 20250 22365 17859 17579 16772 15791 15370 14722 14436 14343 13903 13987 13950 12936 13228 13352 13271 14654 14410 14890 15179 15050 15614
27181 10260 10801 11464 11822 11419 11458 11329 10911 11428 11535 12138 12348 12261 12810 12521 12220 11790 11649 11291 10994 10585 10522 10335 9957 10407 10093 10108 11412 9241 8874 8481 8125 7931 7571 7281 7243 7026 7136 7121 6471 6693 6915 6781 7252 7685 7696 7886 7770 8012 7495 7533 7272 7265 7400 6715 5939 5691 5844 5614 5752 5994 5352 5283 4761 4399 4299 4000 3680 3616 3148 3053 2741 2537 2325 2072 1812 1593 1340 1307 1191 1108 1015 857 790 613 536 434 368 295 222 165 117 79 61 46 27 8 17 12 6 4 9568 10405 10802 11065 10993 11128 10757 10464 10765 10818 11375 11696 11789 12304 12082 11915 11492 11322 10839 10555 10613 10568 10060 10063 9935 9948 10215 11098 8706 8794 8397 7789 7495 7224 7273 7056 6996 6975 6893 6346 6577 6381 6453 7327 6792 7094 7240 7302 7549 7427 7227 7334 7292 7318 6581 5891 5967 5835 5827 5932 5983 5748 5510 5525 4975 4813 4697 4165 4176 3915 3559 3299 3236 3307 3216 2725 2577 2513 2496 2191 2089 1926 1760 1552 1288 1130 936 806 676 498 415 284 254 167 114 81 45 37 39 14 15 19828 21206 22266 22887 22412 22586 22086 21375 22193 22353 23513 24044 24050 25114 24603 24135 23282 22971 22130 21549 21198 21090 20395 20020 20342 20041 20323 22510 17947 17668 16878 15914 15426 14795 14554 14299 14022 14111 14014 12817 13270 13296 13234 14579 14477 14790 15126 15072
27546 10051 10433 10970 11651 12098 11604 11647 11493 11034 11629 11697 12322 12505 12349 12899 12581 12167 11683 11604 11319 11086 10637 10661 10584 10176 10681 10377 10368 11672 9452 9052 8616 8299 8027 7698 7373 7349 7130 7269 7198 6454 6759 6979 6791 7197 7741 7696 7882 7820 7980 7418 7537 7259 7210 7320 6730 5912 5634 5785 5540 5628 5937 5211 5216 4648 4276 4171 3873 3553 3448 3026 2921 2594 2412 2175 1940 1680 1476 1204 1201 1057 1007 885 740 682 533 451 351 296 237 180 124 88 57 48 30 20 5 14 9 6 9681 9705 10690 10981 11292 11167 11297 10970 10653 10895 10945 11485 11772 11804 12388 12172 11969 11546 11361 10873 10607 10771 10753 10357 10373 10216 10204 10457 11344 8869 8976 8591 7926 7600 7316 7417 7099 7120 7046 6978 6350 6644 6390 6447 7330 6851 7065 7246 7346 7556 7352 7210 7319 7276 7286 6635 5859 5928 5819 5863 5891 5965 5720 5482 5451 4972 4699 4646 4065 4099 3859 3485 3201 3152 3199 3125 2590 2453 2393 2369 2023 1980 1810 1618 1384 1147 976 797 683 561 396 338 221 196 141 88 61 28 27 31 9 19732 20138 21660 22632 23390 22771 22944 22463 21687 22524 22642 23807 24277 24153 25287 24753 24136 23229 22965 22192 21693 21408 21414 20941 20549 20897 20581 20825 23016 18321 18028 17207 16225 15627 15014 14790 14448 14250 14315 14176 12804 13403 13369 13238 14527 14592 14761 15128
27912 9784 9867 10456 11010 11682 12187 11621 11645 11498 11016 11701 11728 12347 12523 12300 12871 12546 12023 11549 11541 11333 11090 10620 10644 10642 10150 10708 10391 10349 11714 9455 9028 8566 8334 8010 7715 7379 7337 7180 7308 7180 6336 6738 6941 6737 7120 7741 7616 7815 7824 7930 7323 7511 7221 7160 7206 6701 5848 5558 5718 5422 5493 5868 5032 5116 4532 4135 4002 3743 3436 3291 2892 2762 2450 2282 2040 1813 1564 1347 1042 1086 932 887 745 622 574 449 363 291 235 194 145 87 68 46 40 22 12 5 7 8 9214 9726 9672 10773 10968 11359 11153 11292 10947 10616 10845 10913 11497 11761 11722 12391 12192 11946 11509 11297 10741 10472 10721 10687 10357 10438 10242 10180 10470 11356 8860 8933 8589 7886 7602 7286 7456 7001 7163 7052 6985 6285 6642 6303 6355 7286 6848 6990 7211 7335 7516 7273 7210 7290 7220 7208 6661 5803 5882 5770 5868 5816 5927 5654 5436 5351 4971 4577 4589 3950 3988 3790 3391 3106 3063 3084 3011 2443 2325 2247 2197 1851 1823 1664 1465 1199 1032 834 674 576 471 306 270 168 157 115 60 47 19 19 26 18998 19593 20128 21783 22650 23546 22774 22937 22445 21632 22546 22641 23844 24284 24022 25262 24738 23969 23058 22838 22074 21562 21341 21331 20999 20588 20950 20571 20819 23070 18315 17961 17155 16220 15612 15001 14835 14338 14343 14360 14165 12621 13380 13244 13092 14406 14589 14606
28277 9730 9832 9983 10530 11030 11691 12210 11640 11678 11543 11113 11734 11787 12346 12478 12238 12777 12442 11969 11580 11495 11251 11049 10724 10708 10695 10347 10779 10456 10429 11674 9413 9032 8539 8255 7971 7665 7335 7368 7161 7222 7107 6373 6709 6885 6710 7123 7676 7575 7770 7746 7834 7322 7425 7161 7077 7101 6556 5749 5471 5609 5359 5440 5748 4974 4989 4433 4038 3875 3605 3302 3145 2761 2598 2295 2131 1891 1683 1425 1222 951 962 845 766 636 527 476 370 302 236 186 161 116 64 55 33 30 14 8 5 11 9151 9252 9747 9734 10746 11017 11405 11190 11310 10967 10658 10891 11012 11547 11784 11797 12337 12137 11888 11517 11316 10855 10478 10707 10757 10450 10568 10274 10277 10492 11399 8970 8990 8564 7870 7594 7317 7392 7107 7134 7014 6925 6288 6592 6321 6351 7293 6812 6994 7174 7318 7479 7287 7159 7245 7174 7208 6615 5801 5886 5770 5821 5825 5889 5619 5398 5285 4892 4535 4495 3890 3904 3693 3282 2994 2956 2961 2874 2337 2192 2116 2045 1736 1673 1505 1324 1046 880 702 586 489 398 245 221 130 122 89 45 35 11 29 18881 19084 19730 20264 21776 22708 23615 22830 22988 22510 21771 22625 22799 23893 24262 24035 25114 24579 23857 23097 22811 22106 21527 21431 21465 21145 20915 21053 20733 20921 23073 18383 18022 17103 16125 15565 14982 14727 14475 14295 14236 14032 12661 13301 13206 13061 14416 14488
28642 9578 9710 9892 10059 10559 11039 11699 12220 11689 11704 11561 11173 11741 11851 12318 12415 12136 12634 12299 11884 11558 11438 11189 11029 10774 10757 10721 10504 10793 10483 10457 11585 9328 8999 8509 8183 7930 7620 7279 7371 7101 7121 7004 6423 6692 6811 6656 7084 7575 7518 7714 7672 7743 7350 7339 7098 7012 7015 6432 5627 5369 5484 5298 5368 5598 4890 4868 4310 3924 3755 3446 3161 3011 2624 2420 2145 1989 1734 1537 1288 1110 864 828 746 658 544 455 391 296 241 194 148 122 87 45 41 19 22 10 6 10 9178 9172 9297 9726 9792 10713 11039 11443 11186 11293 10971 10676 10931 11101 11563 11803 11886 12289 12136 11905 11469 11227 10886 10490 10674 10818 10517 10696 10337 10355 10477 11413 9028 8991 8550 7855 7612 7330 7310 7193 7102 6962 6850 6286 6535 6338 6354 7290 6774 7030 7154 7306 7444 7300 7118 7181 7136 7219 6573 5798 5891 5749 5756 5823 5835 5565 5355 5229 4809 4483 4376 3822 3799 3588 3172 2886 2840 2837 2705 2210 2060 1980 1883 1609 1498 1327 1153 901 747 597 506 398 318 194 172 102 94 66 32 26 23 18756 18882 19189 19785 20351 21752 22738 23663 22875 22997 22532 21849 22672 22952 23881 24218 24022 24923 24435 23789 23027 22665 22075 21519 21448 21575 21238 21200 21130 20838 20934 22998 18356 17990 17059 16038 15542 14950 14589 14564 14203 14083 13854 12709 13227 13149 13010 14374
29007 9335 9509 9660 9864 10057 10553 11006 11671 12177 11666 11692 11535 11196 11711 11847 12210 12265 11970 12465 12156 11763 11488 11298 11081 10939 10769 10765 10656 10602 10747 10424 10410 11459 9230 8939 8447 8051 7854 7574 7218 7333 7001 6992 6887 6423 6633 6749 6613 7043 7495 7462 7651 7576 7615 7333 7250 7019 6900 6892 6270 5500 5262 5359 5214 5299 5462 4777 4699 4192 3807 3626 3285 3001 2848 2481 2244 1988 1843 1600 1416 1159 981 780 715 648 559 454 380 312 231 191 163 114 94 66 32 31 12 13 7 8 8846 9118 9136 9295 9670 9795 10632 11009 11442 11153 11239 10925 10638 10898 11111 11544 11790 11889 12240 12094 11790 11320 11101 10871 10468 10648 10852 10496 10725 10293 10348 10414 11355 9067 8966 8509 7818 7575 7327 7228 7248 7026 6885 6777 6287 6467 6335 6336 7267 6735 7043 7123 7278 7378 7294 7063 7144 7101 7208 6510 5777 5864 5714 5695 5804 5765 5501 5299 5161 4721 4424 4260 3746 3699 3461 3069 2771 2710 2722 2557 2084 1928 1841 1733 1500 1335 1167 998 784 628 482 419 305 261 153 129 81 70 51 24 27 18181 18627 18796 19159 19727 20348 21638 22680 23619 22819 22931 22460 21834 22609 22958 23754 24055 23859 24705 24250 23553 22808 22399 21952 21407 21417 21617 21152 21327 21040 20772 20824 22814 18297 17905 16956 15869 15429 14901 14446 14581 14027 13877 13664 12710 13100 13084 12949
29373 9364 9392 9530 9672 9940 10149 10600 11056 11700 12205 11696 11690 11516 11213 11700 11869 12140 12190 11889 12387 12100 11701 11451 11243 11042 10943 10826 10806 10680 10710 10742 10373 10372 11331 9147 8923 8419 7953 7801 7531 7191 7323 6941 6889 6796 6451 6595 6687 6582 7017 7436 7420 7594 7473 7496 7325 7144 6927 6786 6768 6107 5369 5152 5225 5135 5224 5318 4661 4544 4063 3686 3516 3142 2870 2686 2338 2082 1823 1697 1466 1289 1040 865 701 623 579 483 396 326 253 180 152 122 82 77 52 22 26 6 7 3 8840 8811 9116 9154 9316 9621 9829 10644 11083 11480 11178 11219 10919 10660 10955 11185 11533 11793 11935 12133 11962 11594 11127 10938 10809 10425 10564 10815 10447 10731 10216 10315 10294 11249 9053 8928 8441 7776 7546 7326 7140 7318 6968 6812 6701 6277 6396 6335 6318 7263 6691 7042 7080 7237 7313 7297 6994 7090 7048 7195 6436 5746 5838 5671 5600 5773 5697 5424 5233 5080 4611 4343 4150 3676 3594 3331 2963 2668 2597 2584 2383 1963 1795 1694 1571 1374 1194 1013 869 688 538 414 352 238 211 126 93 59 42 35 34 18204 18203 18646 18826 19256 19770 20429 21700 22783 23685 22874 22909 22435 21873 22655 23054 23673 23983 23824 24520 24062 23295 22578 22181 21851 21368 21390 21621 21127 21441 20958 20688 20666 22580 18200 17851 16860 15729 15347 14857 14331 14641 13909 13701 13497 12728 12991 13022
29738 9585 9351 9428 9503 9673 9995 10232 10632 11071 11733 12231 11733 11734 11533 11239 11645 11834 12009 12052 11781 12259 11933 11576 11413 11149 10953 10893 10855 10824 10668 10807 10743 10359 10399 11285 9100 8930 8426 7890 7772 7493 7156 7303 6858 6763 6691 6469 6545 6606 6541 6983 7343 7366 7538 7385 7372 7289 7024 6842 6673 6658 5957 5252 5055 5112 5065 5156 5178 4573 4404 3934 3559 3385 2975 2736 2525 2222 1945 1667 1550 1327 1167 928 756 628 528 513 384 323 270 202 141 122 89 57 57 30 12 18 6 6 9369 8915 8816 9163 9198 9384 9613 9882 10629 11141 11556 11238 11248 10960 10721 11021 11282 11562 11823 11989 12016 11811 11457 11035 10896 10912 10521 10577 10864 10469 10828 10266 10382 10285 11261 9153 8964 8435 7801 7552 7351 7080 7401 6915 6753 6637 6274 6326 6333 6307 7254 6650 7046 7067 7226 7262 7294 6943 7040 7007 7209 6402 5765 5843 5644 5546 5777 5645 5362 5171 5007 4508 4283 4046 3615 3490 3211 2845 2550 2480 2459 2228 1854 1662 1551 1391 1248 1044 869 724 568 431 334 284 169 163 107 71 48 28 36 18954 18266 18244 18666 18871 19379 19845 20514 21700 22874 23787 22971 22982 22493 21960 22666 23116 23571 23875 23770 24275 23744 23033 22448 22045 21865 21414 21432 21688 21137 21635 21009 20741 20684 22546 18253 17894 16861 15691 15324 14844 14236 14704 13773 13516 13328 12743 12871
30103 9655 9629 9403 9490 9527 9703 10057 10273 10696 11130 11764 12287 11822 11788 11566 11223 11590 11738 11960 12032 11736 12194 11864 11521 11420 11168 10992 10869 10821 10812 10648 10783 10763 10374 10436 11391 9177 8955 8497 7958 7809 7530 7199 7305 6853 6785 6713 6436 6566 6594 6493 6946 7319 7307 7480 7351 7338 7199 6952 6743 6640 6571 5867 5171 4963 5014 4961 5029 5026 4437 4227 3781 3432 3199 2821 2604 2357 2060 1800 1526 1400 1195 1053 825 672 542 458 438 321 272 211 150 109 87 72 49 46 21 8 14 7 9315 9411 9001 8863 9201 9231 9418 9650 9924 10677 11164 11579 11282 11248 11008 10735 11052 11234 11511 11794 11906 11927 11693 11398 11008 10955 10947 10555 10636 10901 10490 10862 10333 10408 10326 11308 9179 8916 8504 7845 7583 7348 7129 7351 6898 6787 6653 6237 6327 6356 6276 7178 6666 7013 7038 7189 7259 7220 6950 7043 7000 7158 6363 5710 5784 5581 5503 5702 5600 5282 5078 4874 4421 4147 3946 3535 3379 3067 2753 2440 2349 2305 2077 1695 1523 1426 1271 1088 911 753 620 479 361 266 226 137 135 76 49 33 43 18970 19040 18404 18353 18728 18934 19475 19923 20620 21807 22928 23866 23104 23036 22574 21958 22642 22972 23471 23826 23642 24121 23557 22919 22428 22123 21939 21424 21457 21713 21138 21645 21096 20782 20762 22699 18356 17871 17001 15803 15392 14878 14328 14656 13751 13572 13366 12673
30468 10097 9751 9693 9562 9567 9585 9722 10143 10347 10762 11192 11837 12350 11873 11844 11577 11220 11569 11725 12010 12040 11745 12231 11874 11575 11475 11220 11106 10890 10852 10854 10624 10803 10794 10420 10506 11500 9269 8977 8564 8054 7829 7568 7240 7315 6855 6822 6759 6415 6577 6587 6461 6913 7297 7241 7428 7306 7304 7084 6867 6656 6597 6462 5777 5059 4877 4943 4840 4887 4850 4267 4036 3621 3296 3021 2635 2467 2209 1892 1641 1374 1260 1081 932 707 577 475 388 374 271 215 161 119 87 65 55 34 36 15 2 14 9385 9408 9494 9022 8922 9285 9301 9444 9735 10008 10708 11209 11668 11304 11262 11008 10741 11066 11229 11497 11762 11840 11886 11670 11431 11065 11040 11006 10585 10709 10939 10543 10878 10446 10415 10378 11349 9206 8888 8547 7873 7588 7328 7153 7311 6888 6835 6676 6191 6330 6377 6245 7112 6670 6963 7018 7153 7266 7148 6946 7039 6986 7105 6316 5643 5704 5521 5435 5627 5575 5220 4968 4738 4318 3993 3830 3437 3250 2923 2627 2311 2216 2148 1944 1542 1383 1276 1121 937 781 639 512 403 301 210 175 103 109 47 26 44 19482 19159 19187 18584 18489 18870 19023 19587 20082 20770 21900 23046 24018 23177 23106 22585 21961 22635 22954 23507 23802 23585 24117 23544 23006 22540 22260 22112 21475 21561 21793 21167 21681 21240 20835 20884 22849 18475 17865 17111 15927 15417 14896 14393 14626 13743 13657 13435
30834 10260 10166 9808 9759 9639 9634 9625 9790 10164 10383 10827 11225 11865 12390 11906 11850 11561 11183 11548 11732 12002 12051 11761 12288 11897 11596 11491 11300 11183 10880 10829 10872 10599 10764 10799 10423 10573 11570 9345 8962 8609 8101 7825 7585 7273 7279 6854 6853 6813 6385 6568 6596 6436 6897 7262 7168 7371 7267 7256 6955 6795 6572 6533 6390 5701 4944 4775 4834 4736 4741 4684 4111 3838 3442 3147 2834 2467 2319 2052 1728 1523 1255 1119 965 835 613 503 406 336 308 222 177 134 99 71 48 44 31 27 9 12 9853 9455 9458 9473 9106 9000 9298 9311 9490 9762 10041 10744 11260 11670 11336 11240 11024 10725 11096 11282 11480 11710 11774 11859 11669 11474 11130 11093 11077 10601 10758 10948 10581 10903 10515 10390 10429 11382 9203 8826 8583 7886 7582 7306 7201 7276 6865 6859 6690 6142 6324 6400 6215 7044 6675 6923 7005 7117 7280 7072 6972 7040 6951 7044 6269 5579 5633 5439 5389 5537 5518 5130 4847 4608 4240 3859 3701 3318 3112 2791 2516 2194 2090 1992 1825 1420 1261 1141 978 797 668 538 433 335 241 153 141 86 91 29 38 20113 19621 19266 19232 18745 18634 18923 19101 19654 20145 20868 21969 23125 24060 23242 23090 22585 21908 22644 23014 23482 23761 23535 24147 23566 23070 22621 22393 22260 21481 21587 21820 21180 21667 21314 20813 21002 22952 18548 17788 17192 15987 15407 14891 14474 14555 13719 13712
31199 10212 10276 10144 9874 9763 9679 9639 9604 9801 10161 10417 10863 11284 11885 12423 11905 11816 11512 11153 11553 11668 11912 12038 11766 12335 11862 11648 11534 11334 11192 10831 10774 10864 10563 10758 10840 10435 10574 11641 9371 8937 8621 8126 7813 7587 7280 7240 6852 6864 6844 6350 6592 6580 6394 6857 7228 7101 7303 7216 7198 6850 6743 6483 6461 6291 5609 4841 4654 4690 4592 4563 4496 3955 3673 3263 2988 2650 2303 2164 1884 1572 1370 1137 985 889 737 531 415 351 290 253 176 135 99 73 54 29 34 26 21 12 9672 9862 9498 9498 9528 9139 9032 9325 9269 9481 9747 10019 10790 11269 11664 11342 11202 11008 10692 11090 11197 11394 11587 11696 11783 11631 11484 11157 11137 11108 10593 10778 10926 10550 10901 10569 10367 10406 11393 9192 8757 8581 7884 7574 7279 7211 7216 6827 6887 6687 6081 6311 6416 6178 6953 6667 6870 6972 7086 7285 6989 6967 7019 6915 6980 6207 5500 5547 5377 5334 5437 5420 5031 4741 4459 4124 3720 3577 3198 2968 2644 2386 2057 1934 1853 1685 1274 1125 1001 862 672 577 461 358 275 193 113 107 73 80 30 19884 20138 19642 19372 19291 18818 18671 18929 19070 19642 20164 20882 22074 23154 24087 23247 23018 22520 21845 22643 22865 23306 23625 23462 24118 23493 23132 22691 22471 22300 21424 21552 21790 21113 21659 21409 20802 20980 23034 18563 17694 17202 16010 15387 14866 14491 14456 13679
31564 9926 10240 10313 10188 9973 9737 9686 9678 9642 9843 10159 10430 10846 11328 11920 12470 11959 11766 11552 11213 11611 11599 12018 12152 11895 12437 11937 11761 11548 11348 11306 10784 10761 10806 10538 10772 10827 10499 10567 11745 9430 8929 8610 8162 7799 7612 7256 7203 6885 6902 6844 6307 6594 6544 6305 6827 7177 6988 7208 7168 7107 6696 6636 6337 6408 6190 5458 4703 4521 4582 4423 4377 4284 3779 3512 3097 2830 2461 2159 2008 1729 1404 1228 995 845 785 634 449 352 284 247 202 134 116 71 59 47 27 14 27 17 9557 9677 9916 9520 9523 9512 9106 9016 9291 9230 9461 9769 10019 10852 11290 11682 11362 11152 11089 10689 11079 11181 11346 11447 11685 11832 11566 11527 11215 11193 11144 10566 10862 10920 10646 10904 10638 10311 10417 11337 9201 8681 8613 7880 7589 7237 7191 7135 6750 6897 6683 6023 6297 6416 6126 6859 6618 6807 6914 7029 7294 6919 6917 6981 6866 6863 6122 5399 5470 5275 5249 5304 5327 4900 4591 4317 3987 3534 3412 3084 2807 2477 2236 1909 1789 1687 1544 1129 952 897 726 539 494 399 284 216 147 89 55 56 68 19483 19917 20229 19708 19496 19249 18792 18694 18933 19073 19620 20199 20865 22180 23210 24152 23321 22918 22641 21902 22690 22780 23364 23599 23580 24269 23503 23288 22763 22541 22450 21350 21623 21726 21184 21676 21465 20810 20984 23082 18631 17610 17223 16042 15388 14849 14447 14338
31929 9861 9972 10262 10395 10232 10021 9773 9711 9740 9710 9907 10233 10489 10834 11343 11935 12416 11888 11646 11499 11154 11466 11475 11886 11975 11836 12457 11956 11702 11499 11328 11326 10830 10767 10782 10548 10776 10855 10559 10592 11639 9447 8952 8614 8113 7786 7609 7224 7224 6912 6852 6766 6288 6550 6481 6275 6783 7110 6955 7125 7088 7019 6617 6557 6228 6255 6082 5353 4599 4412 4425 4281 4211 4090 3586 3317 2928 2617 2291 1985 1843 1570 1248 1078 841 726 674 512 360 303 240 190 153 101 89 53 44 34 19 9 29 9599 9598 9724 9977 9583 9587 9568 9127 9052 9283 9265 9507 9811 10057 10815 11250 11677 11317 11152 11075 10577 10980 11120 11260 11439 11652 11867 11614 11531 11214 11196 11167 10580 10873 10892 10675 10984 10622 10404 10434 11203 9261 8746 8568 7853 7600 7258 7116 7136 6760 6844 6657 6071 6310 6343 6142 6853 6588 6812 6899 7018 7291 6892 6860 6938 6797 6790 6034 5354 5403 5197 5173 5201 5181 4754 4427 4141 3815 3392 3242 2942 2643 2347 2064 1758 1655 1503 1359 1008 829 770 611 445 405 319 221 165 109 64 39 85 19460 19570 19986 20372 19815 19608 19341 18838 18792 18993 19172 19740 20300 20891 22158 23185 24093 23205 22798 22574 21731 22446 22595 23146 23414 23488 24324 23570 23233 22713 22524 22493 21410 21640 21674 21223 21760 21477 20963 21026 22842 18708 17698 17182 15966 15386 14867 14340
32295 9928 9864 10075 10315 10490 10284 10040 9843 9755 9828 9746 9985 10278 10541 10845 11366 11958 12341 11817 11590 11463 11103 11369 11436 11793 11882 11825 12493 11989 11603 11495 11352 11348 10871 10816 10807 10523 10867 10876 10608 10633 11568 9459 8960 8614 8073 7760 7590 7226 7246 6910 6804 6715 6288 6507 6415 6235 6731 7029 6917 7026 6998 6904 6521 6468 6117 6077 5910 5270 4471 4283 4243 4114 4025 3890 3382 3086 2722 2415 2125 1819 1658 1408 1105 936 728 640 569 408 296 247 193 147 116 72 60 39 32 23 13 26 9296 9616 9689 9787 10029 9647 9688 9620 9160 9114 9329 9345 9599 9893 10120 10808 11259 11680 11394 11210 11015 10554 10945 11049 11261 11520 11690 11943 11708 11583 11289 11258 11239 10691 10958 10920 10714 11083 10611 10487 10467 11111 9337 8838 8549 7835 7574 7263 7043 7146 6800 6838 6627 6104 6311 6281 6109 6845 6577 6817 6900 7009 7255 6837 6830 6871 6711 6712 5953 5281 5320 5099 5091 5085 5050 4620 4271 3990 3650 3260 3070 2771 2481 2191 1909 1609 1493 1320 1168 894 713 633 501 361 321 248 165 120 78 45 80 19224 19480 19764 20102 20519 19931 19728 19463 18915 18942 19075 19330 19877 20434 20965 22174 23217 24021 23211 22800 22478 21657 22314 22485 23054 23402 23515 24436 23697 23186 22784 22610 22587 21562 21774 21727 21237 21950 21487 21095 21100 22679 18796 17798 17163 15908 15334 14853
32660 10078 9987 9955 10230 10435 10589 10298 10083 9987 9842 9908 9797 10071 10318 10630 10854 11383 11950 12310 11901 11614 11385 11039 11351 11389 11759 11854 11896 12549 11987 11604 11577 11387 11367 10943 10868 10846 10571 10921 10909 10717 10669 11424 9459 8996 8637 8034 7733 7564 7220 7245 6894 6791 6667 6295 6486 6373 6191 6663 6969 6859 6923 6881 6799 6420 6359 5986 5920 5778 5169 4347 4159 4069 3924 3840 3671 3166 2865 2525 2208 1975 1653 1474 1265 987 818 643 555 467 321 229 186 146 112 95 54 46 29 23 17 25 9327 9357 9682 9796 9903 10105 9756 9755 9703 9204 9175 9368 9424 9708 9952 10164 10816 11298 11761 11475 11202 10955 10519 10910 11105 11279 11582 11738 12158 11839 11631 11337 11344 11325 10788 11031 10977 10722 11153 10633 10563 10511 11021 9419 8916 8510 7778 7558 7286 6974 7162 6830 6820 6609 6142 6324 6212 6122 6834 6555 6807 6894 6991 7212 6793 6758 6773 6612 6629 5878 5208 5241 5003 4986 4961 4910 4466 4100 3838 3473 3097 2905 2622 2283 2032 1726 1444 1327 1135 1009 770 606 531 407 286 258 188 116 82 52 80 19405 19344 19637 20026 20338 20694 20054 19838 19690 19046 19083 19165 19495 20026 20582 21018 22199 23248 24071 23376 22816 22340 21558 22261 22494 23038 23436 23634 24707 23826 23235 22914 22731 22692 21731 21899 21823 21293 22074 21542 21280 21180 22445 18878 17912 17147 15812 15291
33025 10127 10177 10059 10040 10400 10490 10666 10329 10150 10112 9875 9972 9843 10119 10375 10696 10870 11389 11951 12356 11986 11585 11347 11036 11310 11361 11741 11826 11906 12516 12053 11612 11584 11371 11350 11008 10926 10890 10603 10950 10926 10786 10700 11275 9470 9038 8648 7989 7706 7562 7173 7240 6893 6768 6622 6297 6453 6306 6154 6610 6877 6788 6809 6776 6675 6311 6263 5829 5717 5614 5032 4191 4028 3870 3741 3647 3444 2928 2648 2338 2008 1815 1467 1298 1107 859 696 543 474 371 233 177 145 104 81 72 42 38 18 14 26 9560 9387 9429 9735 9875 9967 10126 9817 9802 9763 9229 9246 9420 9546 9777 10010 10228 10825 11404 11849 11490 11201 10911 10503 10877 11144 11325 11620 11799 12277 11912 11677 11411 11397 11405 10892 11081 10972 10716 11211 10594 10654 10539 10912 9517 8984 8463 7717 7525 7317 6916 7197 6875 6780 6571 6183 6323 6126 6145 6832 6522 6801 6867 6938 7145 6750 6669 6674 6515 6551 5788 5117 5143 4879 4856 4822 4721 4302 3913 3647 3284 2954 2732 2437 2101 1845 1545 1285 1160 951 834 640 501 432 324 212 194 133 73 50 76 19687 19564 19488 19775 20275 20457 20792 20146 19952 19875 19104 19218 19263 19665 20152 20706 21098 22214 23355 24205 23476 22786 22258 21539 22187 22505 23066 23446 23705 24793 23965 23289 22995 22768 22755 21900 22007 21862 21319 22161 21520 21440 21239 22187 18987 18022 17111 15706
33390 10267 10288 10307 10168 10142 10528 10505 10736 10395 10225 10205 9900 10013 9886 10198 10436 10784 10855 11398 12084 12443 11992 11604 11373 11044 11270 11337 11779 11770 11865 12512 12088 11575 11548 11326 11374 11093 11005 10965 10617 10990 10926 10822 10678 11115 9485 9064 8636 7929 7699 7533 7139 7243 6903 6734 6552 6294 6415 6221 6131 6543 6785 6710 6722 6674 6590 6206 6158 5712 5527 5455 4901 4031 3871 3665 3596 3468 3231 2742 2409 2141 1835 1678 1301 1123 978 732 587 453 398 281 195 143 103 79 52 62 27 12 12 25 9547 9722 9518 9507 9749 9950 10031 10159 9866 9874 9832 9276 9343 9464 9615 9842 10111 10297 10903 11484 11876 11555 11211 10853 10547 10880 11206 11341 11700 11805 12378 12012 11715 11460 11469 11455 10973 11109 10951 10711 11262 10549 10729 10585 10811 9593 9030 8379 7640 7525 7366 6891 7230 6885 6733 6541 6215 6320 6072 6182 6841 6507 6802 6827 6921 7121 6665 6590 6596 6447 6502 5693 5042 5035 4762 4754 4673 4521 4127 3746 3422 3071 2799 2525 2239 1877 1667 1363 1156 1006 777 679 530 428 312 243 173 139 96 64 104 19814 20010 19825 19675 19891 20478 20536 20895 20261 20099 20037 19176 19356 19350 19813 20278 20895 21152 22301 23568 24319 23547 22815 22226 21591 22150 22543 23120 23470 23670 24890 24100 23290 23008 22795 22829 22066 22114 21916 21328 22252 21475 21551 21263 21926 19078 18094 17015
33756 10065 10279 10341 10333 10217 10160 10560 10561 10749 10420 10253 10206 9948 10044 9903 10210 10430 10760 10828 11402 12075 12383 11888 11520 11327 10962 11223 11324 11709 11775 11838 12498 12094 11601 11605 11344 11384 11095 10996 10954 10573 10925 10907 10744 10679 11127 9366 9025 8549 7938 7665 7477 7101 7166 6827 6698 6484 6244 6371 6197 6099 6480 6715 6642 6601 6534 6405 6035 5996 5580 5360 5245 4713 3866 3696 3483 3377 3249 2991 2554 2217 1943 1623 1480 1151 997 854 612 499 375 318 234 155 123 83 61 36 47 10 16 15 9581 9602 9757 9568 9585 9795 9992 10042 10200 9915 9884 9836 9350 9365 9454 9620 9837 10136 10323 10974 11495 11813 11448 11120 10769 10507 10861 11185 11358 11715 11814 12368 12102 11775 11483 11455 11417 11011 11135 10974 10719 11200 10576 10676 10555 10822 9474 9009 8417 7646 7514 7300 6893 7177 6846 6733 6505 6225 6327 6089 6156 6802 6493 6723 6767 6846 7001 6590 6498 6526 6338 6377 5597 4906 4904 4632 4580 4470 4364 3958 3579 3225 2917 2576 2324 2050 1714 1486 1213 1019 868 650 567 428 351 249 190 130 84 75 98 19646 19881 20098 19901 19802 19955 20552 20603 20949 20335 20137 20042 19298 19409 19357 19830 20267 20896 21151 22376 23570 24196 23336 22640 22096 21469 22084 22509 23067 23490 23652 24866 24196 23376 23088 22799 22801 22106 22131 21928 21292 22125 21483 21420 21234 21949 18840 18034
34121 10129 10057 10245 10342 10329 10197 10160 10542 10535 10695 10410 10257 10151 9928 10034 9869 10192 10382 10723 10811 11334 11892 12187 11676 11363 11189 10794 11067 11205 11590 11704 11734 12390 12003 11567 11614 11267 11267 11055 10952 10890 10525 10824 10837 10663 10615 11102 9213 8950 8479 7928 7613 7393 7054 7087 6727 6636 6391 6187 6314 6150 6025 6392 6617 6510 6438 6375 6226 5891 5811 5414 5174 5038 4510 3672 3509 3315 3138 3027 2762 2350 2040 1768 1445 1302 996 872 741 519 408 297 256 195 118 88 58 41 24 30 15 13 9629 9598 9591 9724 9607 9601 9783 9992 10005 10196 9905 9863 9823 9369 9307 9418 9629 9802 10162 10296 10942 11347 11630 11228 10928 10647 10422 10762 11130 11348 11633 11809 12288 12074 11754 11445 11379 11383 10963 11087 10973 10679 11116 10536 10567 10504 10821 9325 8969 8415 7646 7485 7214 6898 7111 6807 6711 6461 6200 6303 6086 6125 6742 6452 6637 6671 6747 6893 6496 6407 6427 6217 6238 5491 4748 4742 4468 4388 4265 4174 3766 3396 3052 2748 2365 2119 1868 1550 1322 1073 898 746 551 465 339 286 195 137 94 75 97 19758 19655 19836 20066 19936 19798 19943 20534 20540 20891 20315 20120 19974 19297 19341 19287 19821 20184 20885 21107 22276 23239 23817 22904 22291 21836 21216 21829 22335 22938 23337 23543 24678 24077 23321 23059 22646 22650 22018 22039 21863 21204 21940 21373 21230 21119 21923 18538
34486 9912 10146 10061 10240 10357 10324 10201 10159 10523 10480 10667 10424 10279 10102 9900 10027 9852 10146 10357 10722 10794 11240 11700 11956 11523 11233 11095 10675 10986 11141 11488 11727 11638 12313 11958 11574 11602 11178 11199 11011 10909 10857 10478 10682 10800 10553 10533 11082 9087 8931 8434 7912 7555 7308 7008 7009 6646 6599 6309 6124 6237 6101 5973 6317 6510 6397 6308 6241 6053 5738 5594 5229 4964 4819 4284 3463 3309 3126 2905 2805 2550 2172 1853 1586 1280 1123 847 749 623 420 321 241 206 148 94 67 47 32 20 18 17 9436 9652 9595 9611 9742 9647 9585 9772 10008 9971 10194 9888 9854 9808 9353 9266 9423 9666 9812 10201 10276 10840 11185 11471 11064 10812 10547 10380 10699 11123 11334 11641 11809 12201 12026 11720 11401 11382 11313 10897 11094 11004 10655 11017 10530 10467 10466 10841 9188 8919 8430 7630 7459 7136 6898 7061 6781 6708 6420 6185 6275 6097 6102 6683 6435 6519 6593 6645 6779 6413 6342 6329 6096 6105 5387 4597 4589 4307 4205 4053 3985 3572 3204 2846 2573 2165 1932 1678 1367 1155 932 777 613 457 374 267 224 145 94 74 97 19348 19798 19656 19851 20099 19971 19786 19931 20531 20451 20861 20312 20133 19910 19253 19293 19275 19812 20169 20923 21070 22080 22885 23427 22587 22045 21642 21055 21685 22264 22822 23368 23447 24514 23984 23294 23003 22560 22512 21908 22003 21861 21133 21699 21330 21020 20999 21923
34851 9977 9925 10146 10055 10239 10346 10312 10181 10132 10477 10449 10637 10415 10261 10024 9868 10012 9807 10115 10380 10718 10669 11053 11437 11685 11289 11073 10931 10522 10871 11065 11385 11669 11513 12232 11883 11536 11534 11121 11135 10958 10880 10797 10394 10586 10717 10405 10433 11050 8947 8890 8378 7884 7487 7216 6943 6919 6577 6554 6226 6050 6158 6065 5913 6201 6379 6250 6144 6118 5884 5584 5374 5060 4772 4604 4086 3267 3110 2927 2690 2551 2327 1976 1650 1409 1133 946 699 622 512 338 247 183 157 121 72 55 41 32 17 16 9421 9460 9636 9592 9603 9723 9597 9572 9760 10008 9925 10171 9883 9824 9757 9338 9259 9429 9713 9813 10157 10156 10707 10955 11247 10869 10710 10446 10294 10677 11069 11341 11575 11786 12048 11954 11697 11393 11345 11209 10867 11093 11035 10583 10926 10493 10395 10405 10817 9041 8889 8424 7633 7440 7063 6904 7004 6753 6690 6355 6153 6259 6113 6072 6631 6391 6414 6493 6534 6664 6331 6251 6226 5989 5956 5257 4417 4427 4143 3996 3828 3777 3361 3013 2643 2392 1948 1709 1487 1196 1010 802 642 500 364 308 205 162 104 79 104 19398 19385 19782 19647 19842 20069 19909 19753 19892 20485 20374 20808 20298 20085 19781 19206 19271 19236 19828 20193 20875 20825 21760 22392 22932 22158 21783 21377 20816 21548 22134 22726 23244 23299 24280 23837 23233 22927 22466 22344 21825 21973 21832 20977 21512 21210 20800 20838
35217 9801 9986 9957 10149 10068 10221 10356 10320 10158 10079 10428 10444 10625 10407 10251 9961 9870 9987 9827 10199 10413 10699 10534 10850 11217 11479 11087 10921 10827 10438 10785 11028 11272 11624 11398 12146 11800 11467 11499 11065 11048 10931 10855 10764 10355 10444 10668 10284 10353 11045 8850 8867 8313 7863 7436 7133 6903 6851 6520 6515 6142 5970 6100 6024 5821 6072 6222 6108 6001 5984 5693 5383 5183 4887 4587 4408 3889 3067 2908 2738 2441 2314 2109 1794 1483 1244 1003 816 590 523 423 269 194 149 126 97 57 35 30 32 29 9261 9431 9466 9629 9601 9608 9666 9565 9566 9757 10004 9911 10190 9884 9781 9720 9390 9292 9487 9798 9828 10060 9985 10536 10723 11124 10729 10609 10364 10271 10614 11055 11330 11501 11715 11892 11916 11707 11360 11276 11153 10836 11123 11042 10540 10849 10471 10316 10375 10809 8887 8836 8434 7652 7430 6998 6919 6959 6733 6660 6291 6148 6239 6138 6038 6569 6340 6323 6421 6441 6529 6238 6166 6123 5864 5792 5110 4222 4247 3976 3771 3585 3577 3175 2827 2434 2216 1731 1504 1287 1034 858 673 534 416 303 239 150 128 92 120 19062 19417 19423 19778 19669 19829 20022 19885 19724 19836 20432 20355 20815 20291 20032 19681 19260 19279 19314 19997 20241 20759 20519 21386 21940 22603 21816 21530 21191 20709 21399 22083 22602 23125 23113 24038 23716 23174 22859 22341 22201 21767 21978 21806 20895 21293 21139 20600
35582 9487 9856 10074 9988 10160 10104 10250 10335 10323 10201 10132 10450 10437 10591 10394 10201 9923 9845 9887 9779 10137 10289 10488 10387 10698 11116 11475 11086 10876 10817 10439 10763 11053 11278 11622 11404 12105 11791 11487 11427 11024 11006 10904 10777 10695 10339 10421 10607 10301 10320 10951 8868 8808 8276 7828 7438 7107 6881 6840 6506 6462 6145 5926 6028 5916 5729 5977 6111 5994 5883 5815 5557 5229 4990 4676 4351 4196 3666 2911 2725 2549 2264 2113 1901 1583 1295 1082 860 693 499 420 344 217 144 121 91 70 37 29 24 31 9096 9287 9502 9522 9674 9633 9614 9704 9566 9574 9738 9994 9916 10146 9826 9723 9614 9333 9228 9433 9719 9701 9880 9852 10447 10690 11121 10740 10651 10418 10281 10634 10999 11342 11504 11725 11903 11918 11724 11368 11223 11128 10788 11047 11002 10548 10826 10508 10343 10362 10824 8936 8816 8392 7631 7431 6997 6916 6962 6726 6640 6294 6111 6186 6057 5996 6514 6243 6286 6342 6346 6447 6153 6011 5986 5728 5664 4946 4080 4102 3829 3594 3422 3356 2964 2620 2212 1985 1549 1322 1132 890 726 552 437 330 241 178 100 96 139 18583 19143 19576 19510 19834 19737 19864 20039 19889 19775 19870 20444 20353 20737 20220 19924 19537 19178 19115 19212 19856 19990 20368 20239 21145 21806 22596 21826 21527 21235 20720 21397 22052 22620 23126 23129 24008 23709 23211 22795 22247 22134 21692 21824 21697 20887 21247 21115
35947 9354 9497 9920 10125 9993 10164 10156 10262 10341 10335 10216 10175 10445 10444 10576 10355 10126 9894 9805 9795 9733 10042 10118 10309 10280 10582 11050 11458 11054 10855 10822 10495 10769 11098 11372 11668 11420 12082 11767 11493 11394 10946 10990 10863 10729 10694 10367 10377 10561 10325 10302 10887 8872 8740 8262 7790 7437 7067 6871 6845 6494 6431 6143 5843 5945 5808 5634 5842 5993 5882 5771 5645 5404 5085 4795 4473 4149 3978 3462 2715 2550 2348 2052 1898 1714 1392 1138 943 728 577 410 351 281 168 110 89 71 52 20 21 31 8960 9117 9322 9533 9560 9729 9702 9611 9677 9579 9592 9752 10023 9947 10102 9793 9726 9574 9298 9191 9411 9651 9617 9770 9801 10369 10681 11105 10755 10687 10526 10325 10694 11013 11353 11538 11747 11946 11922 11723 11386 11170 11134 10742 10996 10935 10582 10814 10523 10400 10353 10854 8977 8814 8355 7627 7431 6974 6932 6975 6692 6637 6311 6047 6123 5971 5959 6445 6149 6246 6266 6272 6376 6057 5834 5849 5590 5517 4777 3957 3934 3663 3407 3225 3112 2717 2393 1989 1761 1353 1144 995 738 595 445 344 254 180 130 60 160 18314 18614 19242 19658 19553 19893 19858 19873 20018 19914 19808 19927 20468 20391 20678 20148 19852 19468 19103 18986 19144 19693 19735 20079 20081 20951 21731 22563 21809 21542 21348 20820 21463 22111 22725 23206 23167 24028 23689 23216 22780 22116 22124 21605 21725 21629 20949 21191
36312 9309 9357 9530 9953 10142 10033 10183 10193 10323 10345 10365 10231 10198 10457 10456 10558 10359 10110 9921 9813 9726 9659 9917 9940 10128 10152 10498 10964 11431 11015 10817 10782 10508 10770 11072 11417 11709 11466 12022 11763 11550 11380 10917 10971 10804 10650 10673 10383 10346 10542 10324 10246 10860 8908 8710 8221 7759 7426 7032 6860 6822 6440 6382 6129 5772 5853 5702 5524 5721 5888 5775 5648 5461 5232 4933 4570 4272 3949 3748 3245 2539 2369 2161 1872 1734 1518 1213 973 786 604 475 326 280 216 129 83 68 53 38 16 40 9042 9029 9173 9334 9601 9561 9757 9771 9625 9728 9620 9621 9800 10029 9964 10128 9789 9766 9624 9274 9147 9284 9491 9440 9613 9728 10263 10653 11097 10747 10729 10495 10304 10773 11041 11366 11558 11778 11940 11925 11720 11399 11149 11140 10772 10937 10902 10598 10777 10539 10453 10365 10852 9024 8782 8328 7583 7394 6942 6914 6968 6692 6643 6331 5987 6055 5896 5914 6395 6064 6202 6199 6193 6284 5961 5672 5705 5435 5337 4580 3819 3774 3497 3215 3060 2855 2494 2181 1770 1538 1188 995 853 598 494 355 269 207 130 94 144 18351 18386 18703 19287 19743 19594 19940 19964 19948 20073 19985 19852 19998 20486 20420 20686 20148 19876 19545 19087 18873 18943 19408 19380 19741 19880 20761 21617 22528 21762 21546 21277 20812 21543 22113 22783 23267 23244 23962 23688 23270 22779 22066 22111 21576 21587 21575 20981
36678 9226 9332 9375 9516 9977 10143 10039 10186 10222 10333 10289 10366 10231 10227 10442 10499 10569 10407 10144 9959 9906 9660 9494 9759 9759 9932 10065 10367 10846 11434 11022 10822 10778 10528 10766 11068 11438 11751 11504 11981 11712 11588 11344 10862 10953 10767 10616 10612 10317 10308 10530 10307 10215 10809 8929 8673 8210 7721 7401 6997 6835 6795 6414 6361 6124 5708 5774 5587 5414 5567 5754 5656 5494 5290 5045 4774 4343 4033 3708 3524 3031 2391 2190 1951 1685 1563 1326 1052 827 658 517 388 261 222 166 102 71 53 47 30 45 8722 9042 9047 9169 9324 9635 9591 9771 9802 9643 9725 9611 9642 9829 10060 9999 10090 9834 9796 9656 9288 9109 9099 9310 9323 9536 9652 10195 10655 11106 10750 10724 10502 10285 10786 11043 11374 11598 11753 11890 11928 11751 11421 11090 11144 10737 10887 10837 10635 10766 10539 10486 10385 10850 9049 8753 8293 7556 7365 6918 6899 6953 6654 6631 6334 5929 5981 5793 5870 6324 5979 6159 6111 6086 6186 5879 5498 5538 5276 5160 4387 3669 3604 3314 3007 2866 2618 2247 1954 1559 1332 1036 824 719 485 388 275 207 153 93 161 17948 18374 18422 18685 19301 19778 19630 19957 20024 19976 20014 19977 19873 20056 20502 20498 20659 20241 19940 19615 19194 18769 18593 19069 19082 19468 19717 20562 21501 22540 21772 21546 21280 20813 21552 22111 22812 23349 23257 23871 23640 23339 22765 21952 22097 21504 21503 21449
37043 8879 9297 9392 9402 9544 10029 10217 10046 10198 10230 10352 10305 10355 10244 10250 10445 10535 10632 10489 10205 10080 9937 9567 9356 9638 9622 9718 9973 10261 10786 11412 11011 10787 10788 10537 10779 11098 11454 11757 11520 11969 11687 11623 11292 10786 10905 10749 10540 10517 10313 10261 10461 10267 10201 10768 8944 8606 8159 7666 7351 6944 6800 6769 6388 6297 6094 5629 5693 5455 5288 5435 5592 5503 5336 5113 4864 4587 4110 3808 3477 3303 2819 2213 2015 1775 1511 1382 1123 884 690 546 425 314 214 170 122 79 53 43 41 57 8674 8797 9058 9029 9171 9341 9669 9590 9807 9837 9612 9715 9627 9671 9839 10093 10061 10161 9889 9936 9715 9280 8964 8926 9096 9198 9375 9516 10098 10598 11062 10742 10689 10524 10315 10783 11044 11417 11603 11726 11889 11883 11716 11381 11063 11182 10713 10859 10760 10628 10733 10545 10502 10342 10851 9086 8723 8226 7504 7365 6889 6902 6951 6609 6603 6342 5876 5907 5703 5811 6240 5867 6086 6015 5968 6083 5766 5305 5362 5094 4975 4168 3495 3411 3097 2803 2680 2371 2021 1728 1347 1139 900 675 582 376 300 212 159 112 179 17553 18094 18450 18431 18715 19370 19886 19636 20005 20067 19964 20020 19982 19915 20089 20538 20596 20793 20378 20141 19795 19217 18531 18282 18734 18820 19093 19489 20359 21384 22474 21753 21476 21312 20852 21562 22142 22871 23360 23246 23858 23570 23339 22673 21849 22087 21462 21399
37408 8997 8938 9375 9456 9442 9596 10012 10254 10035 10232 10263 10373 10335 10414 10301 10314 10492 10605 10727 10526 10173 10067 9944 9584 9382 9613 9659 9737 9916 10244 10806 11412 11014 10834 10846 10554 10800 11106 11476 11753 11518 11962 11641 11556 11233 10867 10863 10794 10531 10509 10264 10216 10388 10193 10150 10703 8896 8543 8077 7586 7295 6854 6718 6675 6267 6199 5981 5530 5572 5375 5184 5310 5423 5320 5148 4903 4656 4358 3919 3604 3249 3065 2622 2012 1819 1571 1314 1177 938 754 564 450 354 260 164 125 84 56 33 25 52 8570 8719 8833 9124 9093 9230 9391 9673 9593 9837 9878 9644 9782 9674 9747 9898 10185 10161 10256 9952 9913 9771 9221 8994 8927 9150 9127 9398 9548 10081 10703 11102 10751 10716 10556 10360 10810 11078 11395 11645 11777 11911 11882 11696 11380 11118 11192 10714 10846 10763 10590 10682 10482 10396 10289 10821 9069 8708 8199 7469 7335 6877 6859 6933 6588 6554 6241 5847 5835 5651 5738 6133 5799 5979 5898 5854 5915 5601 5157 5163 4878 4695 3946 3289 3178 2868 2567 2417 2137 1794 1512 1158 954 719 531 463 291 224 153 112 178 17567 17657 18208 18580 18535 18826 19403 19927 19628 20069 20141 20017 20117 20088 20048 20212 20677 20766 20983 20478 20086 19838 19165 18578 18309 18763 18786 19135 19464 20325 21509 22514 21765 21550 21402 20914 21610 22184 22871 23398 23295 23873 23523 23252 22613 21985 22055 21508
37773 8847 9043 9007 9462 9524 9499 9660 10039 10274 10073 10246 10309 10415 10370 10511 10345 10393 10594 10738 10816 10558 10190 10060 9880 9614 9419 9605 9670 9703 9922 10284 10782 11379 11046 10921 10845 10614 10840 11113 11468 11747 11504 11938 11615 11502 11231 10914 10877 10788 10505 10508 10206 10179 10344 10130 10055 10646 8815 8475 8017 7523 7240 6761 6626 6589 6180 6119 5852 5436 5455 5251 5071 5155 5243 5130 4955 4720 4450 4100 3683 3359 3031 2787 2406 1833 1611 1373 1140 988 773 608 457 346 254 203 119 90 64 36 21 48 8499 8614 8797 8890 9189 9160 9302 9461 9684 9642 9822 9921 9683 9812 9673 9815 9952 10311 10289 10337 10035 9939 9789 9167 8987 8943 9184 9206 9431 9625 10131 10756 11103 10847 10739 10588 10418 10860 11113 11453 11681 11811 11904 11860 11685 11363 11187 11209 10701 10829 10744 10577 10637 10428 10311 10235 10810 9029 8701 8187 7463 7321 6843 6849 6886 6536 6490 6149 5809 5774 5619 5646 6013 5740 5887 5792 5738 5737 5423 4988 4961 4682 4427 3747 3086 2928 2612 2320 2146 1872 1569 1295 1006 776 573 430 361 222 170 112 185 17346 17657 17804 18352 18713 18659 18962 19500 19958 19715 20068 20230 20098 20182 20184 20160 20345 20905 21027 21153 20593 20129 19849 19047 18601 18362 18789 18876 19134 19547 20415 21538 22482 21893 21660 21433 21032 21700 22226 22921 23428 23315 23842 23475 23187 22594 22101 22086
38139 9009 8897 9083 9054 9501 9561 9560 9694 10060 10291 10055 10305 10340 10484 10436 10580 10361 10411 10721 10850 10885 10606 10245 10120 9878 9618 9370 9594 9695 9730 9870 10276 10816 11414 11048 10956 10864 10604 10864 11117 11437 11722 11529 11891 11572 11451 11204 10932 10840 10781 10455 10464 10129 10120 10251 10015 9931 10568 8729 8367 7969 7437 7133 6661 6546 6483 6074 5985 5736 5343 5346 5170 4963 5011 5078 4930 4752 4487 4221 3814 3455 3141 2809 2533 2201 1642 1416 1198 966 821 622 492 362 278 195 151 85 61 46 27 44 8386 8562 8670 8867 8950 9226 9212 9336 9512 9704 9664 9816 9957 9732 9880 9703 9861 10043 10407 10395 10427 10085 9961 9711 9148 9028 8979 9229 9235 9397 9731 10195 10821 11121 10901 10745 10617 10500 10885 11093 11481 11676 11762 11958 11834 11647 11339 11237 11188 10694 10797 10761 10543 10590 10382 10206 10162 10754 8963 8686 8144 7493 7303 6802 6833 6847 6487 6406 6071 5765 5702 5585 5563 5878 5663 5750 5627 5586 5549 5240 4841 4728 4450 4171 3534 2861 2671 2366 2074 1925 1626 1342 1094 839 619 441 327 268 155 122 194 17395 17459 17753 17921 18451 18787 18772 19030 19572 19995 19719 20121 20297 20216 20316 20283 20222 20454 21128 21245 21312 20691 20206 19831 19026 18646 18349 18823 18930 19127 19601 20471 21637 22535 21949 21701 21481 21104 21749 22210 22918 23398 23291 23849 23406 23098 22543 22169
38504 8959 9081 8932 9119 9059 9588 9630 9607 9738 10102 10318 10060 10349 10425 10535 10529 10671 10461 10515 10832 10968 11040 10698 10369 10174 9880 9603 9384 9577 9722 9820 9935 10325 10901 11389 11089 10997 10891 10662 10906 11136 11430 11689 11494 11821 11538 11348 11173 10954 10858 10765 10393 10439 10120 10070 10183 9901 9813 10462 8680 8281 7885 7353 7058 6555 6451 6366 5942 5850 5593 5253 5226 5062 4823 4866 4925 4721 4557 4273 4003 3562 3251 2929 2590 2320 2013 1453 1238 1041 809 671 501 404 290 219 151 107 55 43 32 43 8599 8485 8635 8728 8964 9019 9287 9256 9402 9574 9720 9706 9864 9987 9774 9971 9750 9999 10160 10539 10522 10523 10152 9979 9675 9219 9050 9063 9349 9351 9489 9787 10218 10901 11199 10970 10827 10660 10576 10959 11096 11506 11709 11791 11962 11806 11637 11306 11294 11167 10676 10775 10751 10529 10516 10318 10121 10114 10707 8933 8668 8141 7490 7276 6757 6808 6809 6449 6339 5984 5715 5640 5536 5473 5753 5589 5582 5464 5446 5357 5060 4650 4506 4229 3887 3321 2644 2416 2132 1817 1681 1400 1150 888 685 492 337 241 197 117 204 17558 17566 17567 17847 18023 18607 18917 18863 19140 19676 20038 19766 20213 20412 20309 20500 20421 20460 20675 21371 21490 21563 20850 20348 19849 19099 18653 18447 18926 19073 19309 19722 20543 21802 22588 22059 21824 21551 21238 21865 22232 22936 23398 23285 23783 23344 22985 22479
38869 9166 9006 9197 8991 9175 9181 9721 9717 9704 9873 10205 10404 10097 10408 10558 10592 10597 10788 10550 10625 10941 11067 11263 10824 10454 10223 9857 9583 9414 9594 9780 9893 10011 10441 10982 11457 11163 11098 10975 10749 10993 11208 11473 11708 11529 11837 11509 11291 11160 10971 10849 10797 10355 10418 10078 10001 10065 9784 9690 10378 8600 8187 7795 7272 6987 6461 6336 6260 5836 5729 5446 5148 5109 4936 4679 4685 4745 4514 4353 4049 3786 3294 3018 2692 2371 2089 1817 1260 1060 882 694 537 397 317 211 167 104 68 36 29 58 8668 8614 8614 8738 8835 9071 9121 9402 9344 9491 9645 9771 9812 9905 10055 9888 10061 9842 10079 10309 10692 10642 10648 10310 10094 9721 9289 9161 9173 9426 9483 9623 9924 10305 11047 11286 11075 10960 10749 10724 11051 11153 11528 11776 11868 11973 11793 11619 11254 11362 11168 10671 10757 10769 10520 10484 10289 10016 10054 10661 8879 8642 8120 7477 7252 6742 6774 6745 6393 6275 5895 5641 5560 5470 5392 5614 5487 5450 5315 5292 5148 4852 4449 4251 3982 3577 3072 2397 2133 1888 1580 1460 1190 958 709 549 377 245 173 131 198 17834 17620 17811 17729 18010 18252 18842 19119 19048 19364 19850 20175 19909 20313 20613 20480 20658 20630 20629 20934 21633 21709 21911 21134 20548 19944 19146 18744 18587 19020 19263 19516 19935 20746 22029 22743 22238 22058 21724 21473 22044 22361 23001 23484 23397 23810 23302 22910
39234 9549 9332 9118 9350 9098 9330 9334 9841 9802 9813 9957 10317 10499 10179 10477 10630 10717 10836 10975 10815 10875 11092 11242 11355 10994 10501 10254 9893 9659 9517 9742 9934 9993 10075 10491 11113 11559 11275 11168 11054 10838 11053 11248 11500 11682 11550 11861 11488 11324 11166 10916 10823 10761 10315 10366 10018 9952 10017 9732 9630 10341 8554 8147 7749 7209 6933 6408 6296 6193 5781 5655 5339 5029 4976 4779 4535 4535 4557 4315 4139 3825 3549 3108 2804 2427 2173 1867 1559 1120 911 745 561 435 300 237 160 118 74 46 22 55 9356 8809 8767 8735 8849 8982 9145 9237 9500 9410 9544 9716 9841 9844 9958 10139 10004 10305 10128 10365 10590 10834 10654 10723 10416 10162 9844 9426 9288 9302 9586 9627 9787 10083 10487 11174 11433 11234 11123 10922 10837 11153 11216 11558 11804 11896 11980 11774 11618 11243 11326 11111 10647 10733 10707 10459 10432 10219 9946 10015 10616 8876 8606 8089 7468 7219 6684 6709 6661 6327 6193 5852 5585 5468 5392 5300 5490 5385 5289 5174 5112 4966 4656 4234 4013 3716 3326 2802 2152 1918 1650 1352 1240 976 770 546 422 297 185 127 212 18905 18141 17885 18085 17947 18312 18479 19078 19302 19223 19501 20033 20340 20023 20435 20769 20721 21141 21103 21180 21465 21926 21896 22078 21410 20663 20098 19319 18947 18819 19328 19561 19780 20158 20978 22287 22992 22509 22291 21976 21675 22206 22464 23058 23486 23446 23841 23262
39600 9913 9577 9492 9252 9467 9227 9446 9428 9916 9890 9886 10018 10368 10611 10236 10537 10729 10887 11160 11289 11097 11156 11258 11405 11474 11099 10604 10325 9979 9847 9643 9858 9944 10096 10194 10613 11226 11663 11323 11292 11113 10910 11107 11231 11570 11679 11587 11846 11454 11297 11119 10889 10789 10718 10252 10326 9943 9892 9928 9667 9565 10283 8507 8109 7712 7151 6867 6359 6210 6118 5685 5569 5217 4889 4844 4616 4382 4334 4375 4111 3907 3586 3325 2869 2562 2196 1906 1628 1345 963 769 607 455 333 236 173 117 80 47 32 52 9625 9384 8956 8906 8832 8929 9044 9203 9311 9572 9493 9623 9768 9917 9927 10034 10252 10208 10608 10517 10662 10739 10919 10741 10873 10526 10192 9994 9607 9442 9461 9742 9752 9887 10167 10616 11344 11553 11348 11234 11039 10942 11197 11288 11586 11769 11921 11993 11755 11606 11208 11309 11078 10652 10711 10641 10409 10378 10159 9887 9950 10553 8839 8577 8028 7434 7151 6644 6625 6584 6263 6109 5788 5503 5384 5288 5200 5389 5254 5120 5005 4923 4756 4420 3987 3780 3444 3055 2511 1877 1687 1397 1139 1022 792 603 423 318 218 124 232 19538 18961 18448 18158 18299 18156 18490 18631 19227 19462 19379 19641 20136 20528 20163 20571 20981 21095 21768 21806 21759 21895 22177 22146 22347 21625 20796 20319 19586 19289 19104 19600 19696 19983 20361 21229 22570 23216 22671 22526 22152 21852 22304 22519 23156 23448 23508 23839
39965 10092 9929 9630 9649 9416 9566 9336 9531 9528 9969 9976 9977 10061 10401 10678 10364 10678 10886 11099 11581 11747 11474 11518 11600 11693 11701 11286 10765 10480 10127 10012 9790 9998 9996 10195 10274 10757 11373 11802 11435 11402 11232 10946 11130 11238 11579 11666 11600 11859 11438 11299 11124 10842 10758 10663 10202 10273 9857 9836 9863 9607 9482 10209 8441 8035 7636 7074 6792 6281 6124 6036 5610 5474 5096 4763 4708 4466 4217 4149 4174 3893 3669 3330 3085 2620 2278 1955 1661 1402 1131 790 632 500 373 263 175 126 81 56 31 54 9627 9590 9483 9102 9057 8918 9034 9106 9253 9394 9645 9584 9689 9823 9949 9973 10155 10426 10461 11029 10912 10935 10948 11121 10956 11017 10744 10428 10277 9866 9669 9659 9904 9831 9994 10267 10751 11461 11714 11429 11353 11122 10985 11211 11332 11589 11758 11904 11983 11721 11631 11197 11275 11039 10636 10644 10579 10337 10323 10074 9828 9877 10472 8798 8514 7966 7384 7094 6591 6556 6498 6155 6014 5711 5437 5286 5186 5078 5264 5086 4971 4828 4694 4502 4184 3729 3488 3171 2750 2213 1646 1444 1192 932 825 618 453 322 215 165 235 19719 19519 19113 18751 18473 18484 18370 18637 18781 19363 19621 19561 19750 20224 20627 20337 20833 21312 21560 22610 22659 22409 22466 22721 22649 22718 22030 21193 20757 19993 19681 19449 19902 19827 20189 20541 21508 22834 23516 22864 22755 22354 21931 22341 22570 23168 23424 23504
40330 10182 10056 9932 9719 9845 9552 9708 9451 9612 9622 10017 10069 10052 10124 10472 10775 10497 10826 11068 11378 11907 11998 11621 11713 11770 11741 11741 11406 10911 10640 10284 10177 9929 10102 10063 10281 10373 10843 11503 11917 11569 11498 11236 10980 11123 11267 11596 11624 11589 11860 11431 11329 11120 10813 10703 10614 10165 10189 9782 9763 9794 9525 9416 10106 8376 8002 7587 7006 6734 6189 6036 5946 5541 5367 4964 4617 4562 4307 4053 3979 3947 3667 3440 3068 2830 2405 2044 1746 1453 1212 947 647 507 381 287 190 122 88 59 37 53 9487 9655 9623 9509 9269 9254 9053 9125 9167 9303 9439 9710 9645 9774 9892 10035 10076 10321 10601 10783 11306 11127 11097 11159 11275 11073 11147 10976 10634 10456 10076 9854 9810 10035 9921 10076 10366 10881 11603 11836 11497 11427 11171 10997 11220 11391 11579 11720 11888 11974 11700 11638 11189 11227 10996 10618 10606 10518 10267 10267 9992 9734 9822 10395 8763 8457 7910 7360 7038 6548 6493 6425 6071 5916 5631 5341 5187 5062 4958 5143 4913 4800 4639 4460 4238 3938 3448 3210 2895 2440 1902 1421 1240 1005 760 649 467 346 223 156 242 19669 19711 19555 19228 19114 18806 18761 18576 18779 18925 19456 19779 19697 19898 20364 20810 20573 21147 21669 22161 23213 23125 22718 22872 23045 22814 22888 22382 21545 21096 20360 20031 19739 20137 19984 20357 20739 21724 23106 23753 23066 22925 22407 21977 22343 22658 23175 23344
40695 9820 10032 10043 9970 9781 9998 9639 9813 9537 9692 9704 10066 10109 10084 10182 10533 10879 10651 10975 11227 11604 12052 12045 11699 11729 11762 11683 11647 11364 10931 10712 10321 10274 9955 10150 10097 10262 10427 10906 11555 12011 11632 11550 11267 10989 11119 11271 11547 11583 11561 11879 11418 11315 11084 10760 10635 10536 10106 10119 9723 9693 9716 9473 9337 10034 8305 7932 7493 6941 6663 6101 5955 5862 5449 5269 4842 4471 4421 4128 3882 3798 3740 3422 3182 2837 2611 2147 1818 1499 1264 1015 772 497 397 281 212 142 82 52 37 58 9492 9462 9641 9612 9573 9403 9338 9126 9235 9195 9340 9497 9744 9684 9847 9939 10131 10209 10445 10819 10970 11478 11179 11160 11136 11273 11122 11264 11007 10686 10509 10099 9912 9887 10093 9969 10125 10404 10957 11666 11921 11542 11486 11212 10993 11191 11399 11539 11669 11875 11981 11658 11661 11174 11215 10967 10570 10573 10465 10182 10209 9913 9671 9748 10311 8712 8422 7880 7315 6980 6497 6398 6328 5971 5780 5535 5243 5072 4927 4819 4989 4725 4600 4436 4200 3969 3678 3184 2909 2576 2138 1625 1203 1037 809 576 503 341 247 150 242 19312 19494 19684 19582 19354 19401 18977 18939 18772 18887 19044 19563 19853 19768 20029 20472 21010 20860 21420 22046 22574 23530 23224 22859 22865 23035 22805 22911 22371 21617 21221 20420 20186 19842 20243 20066 20387 20831 21863 23221 23932 23174 23036 22479 21982 22310 22670 23086
41061 10467 9941 10231 10193 10153 9967 10077 9739 9895 9627 9781 9799 10124 10193 10134 10254 10653 11071 10838 11239 11500 11808 12152 12067 11776 11696 11696 11558 11676 11401 10969 10810 10408 10382 10077 10255 10260 10388 10537 10969 11629 12014 11676 11528 11315 10984 11114 11250 11542 11602 11541 11819 11383 11247 11017 10679 10564 10436 10038 10056 9693 9657 9650 9442 9304 9943 8233 7869 7403 6846 6561 5981 5809 5728 5310 5144 4705 4311 4250 3961 3706 3589 3510 3210 2946 2582 2369 1908 1620 1282 1070 836 645 392 317 214 147 100 60 37 65 9764 9633 9629 9812 9796 9770 9524 9401 9219 9271 9269 9412 9568 9800 9748 9933 10036 10269 10372 10706 11046 11112 11505 11237 11203 11127 11254 11179 11378 11124 10901 10620 10211 10066 9989 10186 10071 10191 10448 11076 11745 12014 11618 11537 11293 11051 11205 11401 11592 11711 11865 11994 11660 11633 11172 11192 10962 10529 10555 10440 10167 10205 9886 9661 9720 10272 8662 8326 7808 7226 6912 6447 6331 6249 5898 5672 5429 5125 4923 4772 4678 4795 4516 4361 4155 3952 3696 3394 2890 2581 2238 1849 1374 995 848 633 434 354 244 174 248 20231 19574 19860 20005 19949 19737 19601 19140 19114 18898 19050 19211 19692 19993 19882 20187 20689 21340 21210 21945 22546 22920 23657 23304 22979 22823 22950 22737 23054 22525 21870 21430 20619 20448 20066 20441 20331 20579 20985 22045 23374 24028 23294 23065 22608 22035 22319 22651
41426 10518 10513 10114 10442 10338 10285 10103 10114 9807 9951 9669 9843 9837 10178 10248 10192 10393 10805 11303 11115 11489 11678 11973 12236 12026 11638 11581 11653 11564 11666 11456 11027 10875 10483 10408 10137 10329 10343 10455 10610 11011 11638 11986 11613 11496 11270 10954 11087 11216 11533 11593 11491 11786 11334 11161 10938 10620 10491 10353 9966 9983 9668 9609 9634 9399 9255 9830 8144 7768 7296 6756 6473 5879 5665 5575 5163 4970 4562 4140 4072 3788 3510 3362 3282 2940 2676 2306 2125 1672 1389 1083 898 656 509 320 248 154 102 73 37 61 9906 9859 9757 9767 9897 9923 9886 9553 9415 9277 9322 9283 9474 9638 9824 9833 10013 10133 10434 10608 10966 11186 11166 11524 11188 11187 11161 11320 11282 11506 11271 11013 10733 10319 10159 10074 10219 10125 10230 10523 11114 11759 12096 11644 11573 11369 11071 11247 11378 11615 11728 11832 11951 11680 11621 11173 11183 10920 10503 10530 10426 10146 10209 9862 9636 9652 10187 8595 8278 7723 7159 6846 6398 6259 6177 5802 5540 5307 4981 4766 4625 4514 4609 4290 4098 3889 3658 3384 3075 2589 2294 1965 1574 1133 789 654 480 316 265 163 270 20424 20372 19871 20209 20235 20208 19989 19667 19222 19228 18991 19126 19311 19816 20072 20025 20406 20938 21737 21723 22455 22864 23139 23760 23214 22825 22742 22973 22846 23172 22727 22040 21608 20802 20567 20211 20548 20468 20685 21133 22125 23397 24082 23257 23069 22639 22025 22334
41791 10355 10593 10595 10338 10601 10506 10425 10284 10169 9898 9995 9713 9883 9926 10254 10333 10335 10552 11054 11649 11441 11672 11781 12046 12183 11846 11519 11466 11624 11593 11723 11468 11056 10889 10502 10424 10182 10344 10447 10507 10679 11020 11640 11955 11586 11443 11257 10886 11059 11179 11482 11585 11434 11742 11286 11081 10891 10546 10430 10277 9912 9874 9589 9567 9563 9370 9221 9754 8067 7649 7173 6653 6336 5759 5503 5410 5012 4793 4365 3983 3884 3610 3305 3144 3038 2681 2446 2055 1880 1446 1168 909 744 526 404 250 186 120 73 50 63 9848 10002 9958 9873 9916 9995 10008 10006 9622 9444 9326 9350 9351 9574 9677 9904 9956 10155 10372 10802 10882 11193 11250 11272 11566 11257 11315 11313 11521 11457 11611 11346 11081 10806 10433 10254 10132 10309 10211 10266 10609 11158 11756 12140 11716 11600 11398 11077 11257 11366 11628 11727 11820 11937 11687 11567 11129 11161 10881 10462 10499 10400 10151 10179 9838 9606 9606 10116 8513 8190 7642 7075 6774 6319 6154 6069 5689 5403 5164 4813 4612 4439 4310 4381 4091 3835 3608 3379 3089 2737 2280 1979 1696 1322 927 640 513 375 223 184 271 20203 20595 20553 20211 20517 20501 20433 20290 19791 19342 19321 19063 19234 19500 19931 20237 20291 20707 21426 22451 22323 22865 23031 23318 23749 23103 22834 22779 23145 23050 23334 22814 22137 21695 20935 20678 20314 20653 20658 20773 21288 22178 23396 24095 23302 23043 22655 21963
42156 10215 10402 10697 10727 10486 10758 10612 10514 10371 10198 9934 9982 9754 9887 9976 10340 10500 10491 10785 11463 11960 11627 11819 11930 12076 12035 11783 11436 11426 11649 11600 11705 11434 11068 10919 10532 10380 10200 10367 10504 10553 10742 11024 11626 11913 11540 11388 11182 10834 11039 11142 11448 11580 11395 11686 11238 11021 10839 10481 10345 10189 9820 9778 9536 9522 9505 9286 9145 9635 7937 7537 7048 6519 6187 5614 5348 5213 4847 4612 4180 3804 3682 3390 3069 2903 2809 2429 2183 1802 1622 1242 972 750 600 400 312 184 133 93 50 77 9856 9895 10041 10090 9988 10046 10123 10160 10150 9664 9462 9380 9369 9388 9628 9769 10027 10112 10404 10666 11065 11085 11275 11383 11367 11649 11283 11438 11481 11666 11591 11703 11384 11187 10918 10513 10279 10180 10340 10246 10343 10640 11175 11735 12122 11720 11592 11433 11055 11279 11347 11635 11723 11785 11911 11699 11540 11112 11109 10851 10400 10433 10364 10102 10145 9811 9559 9541 10032 8438 8085 7550 6973 6670 6239 6071 5922 5559 5232 4999 4645 4444 4253 4107 4145 3826 3536 3291 3051 2757 2455 1983 1660 1400 1071 748 482 395 280 158 277 20071 20297 20738 20817 20474 20804 20735 20674 20521 19862 19396 19362 19123 19275 19604 20109 20527 20603 21189 22129 23025 22712 23094 23313 23443 23684 23066 22874 22907 23315 23191 23408 22818 22255 21837 21045 20659 20380 20707 20750 20896 21382 22199 23361 24035 23260 22980 22615
42522 10539 10332 10457 10689 10757 10609 10865 10649 10600 10473 10244 9972 9964 9802 9941 10070 10506 10676 10719 11154 11718 12186 11738 11927 11928 11984 11816 11666 11395 11366 11654 11535 11646 11390 11067 10909 10487 10353 10159 10369 10483 10580 10721 10996 11604 11834 11450 11274 11107 10755 10958 11053 11385 11561 11348 11624 11213 10954 10756 10437 10274 10075 9709 9694 9470 9429 9416 9191 9079 9496 7846 7428 6914 6366 6058 5480 5181 5033 4651 4440 3997 3605 3474 3171 2853 2661 2550 2173 1918 1563 1399 1040 808 609 466 320 237 141 98 67 93 10132 9919 9956 10084 10207 10094 10123 10209 10287 10253 9686 9496 9435 9368 9447 9752 9893 10136 10318 10659 10911 11257 11209 11438 11462 11398 11651 11393 11561 11589 11707 11604 11707 11378 11241 10919 10545 10296 10197 10359 10267 10373 10641 11151 11689 12110 11743 11563 11423 11024 11255 11306 11643 11713 11738 11896 11680 11516 11061 11062 10828 10365 10402 10311 10064 10143 9786 9510 9463 9953 8355 7971 7462 6890 6568 6167 5988 5801 5440 5100 4819 4466 4256 4044 3905 3893 3562 3263 2963 2711 2481 2114 1689 1389 1159 874 571 339 300 206 265 20671 20251 20413 20773 20964 20703 20988 20858 20887 20726 19930 19468 19399 19170 19388 19822 20399 20812 21037 21813 22629 23443 22947 23365 23390 23382 23467 23059 22956 22955 23361 23139 23353 22768 22308 21828 21032 20649 20356 20728 20750 20953 21362 22147 23293 23944 23193 22837
42887 10020 10627 10394 10527 10725 10849 10654 10924 10678 10656 10518 10266 10003 10007 9886 10034 10253 10676 10924 11107 11384 11857 12297 11864 11837 11663 11743 11608 11565 11330 11369 11646 11559 11660 11448 11051 10895 10479 10336 10194 10338 10465 10576 10712 10972 11587 11801 11411 11238 11080 10704 10907 10962 11347 11490 11318 11583 11162 10896 10693 10393 10207 10025 9652 9635 9367 9326 9317 9080 9002 9377 7728 7280 6787 6226 5904 5342 5035 4857 4471 4244 3770 3405 3238 2961 2646 2387 2278 1923 1659 1344 1179 848 646 477 360 234 177 100 75 119 9315 10178 9930 10005 10143 10293 10121 10150 10232 10314 10265 9705 9552 9488 9444 9493 9899 10083 10378 10679 10880 11056 11339 11407 11455 11452 11379 11620 11458 11601 11686 11781 11646 11799 11467 11293 10947 10632 10367 10207 10349 10286 10421 10648 11172 11741 12128 11710 11562 11389 11005 11231 11284 11634 11719 11738 11872 11666 11495 11029 11031 10782 10337 10376 10270 10029 10084 9741 9448 9382 9870 8285 7895 7351 6801 6487 6082 5870 5671 5302 4958 4649 4315 4086 3851 3667 3636 3270 2971 2685 2382 2177 1803 1390 1142 925 679 433 256 208 292 19335 20805 20324 20532 20868 21142 20775 21074 20910 20970 20783 19971 19555 19495 19330 19527 20152 20759 21302 21786 22264 22913 23636 23271 23292 23115 23122 23228 23023 22931 23055 23427 23205 23459 22915 22344 21842 21111 20703 20401 20687 20751 20997 21360 22144 23328 23929 23121
43252 9789 10093 10717 10458 10585 10793 10921 10704 10930 10692 10681 10566 10341 10073 10071 9967 10138 10374 10956 11333 11365 11473 12057 12470 11931 11783 11513 11743 11616 11569 11399 11425 11680 11610 11724 11494 11073 10968 10518 10329 10209 10364 10450 10576 10735 10971 11560 11766 11369 11192 11051 10632 10836 10945 11302 11450 11267 11514 11087 10834 10647 10346 10152 9958 9582 9562 9292 9223 9236 8965 8887 9236 7589 7139 6647 6094 5744 5174 4864 4684 4275 4036 3564 3173 3021 2737 2369 2118 2012 1663 1431 1120 990 690 505 378 275 180 135 72 152 9136 9354 10256 9958 10078 10231 10341 10165 10205 10279 10344 10293 9757 9598 9543 9515 9613 10077 10290 10671 10893 11036 11190 11495 11511 11466 11477 11413 11684 11604 11710 11760 11824 11751 11837 11521 11353 11036 10686 10405 10231 10378 10331 10455 10678 11180 11769 12119 11704 11568 11383 11010 11196 11269 11607 11701 11720 11837 11639 11463 11025 11006 10766 10330 10355 10245 9977 10043 9690 9389 9310 9767 8191 7791 7256 6709 6403 5963 5746 5536 5148 4791 4478 4123 3882 3602 3406 3354 2956 2663 2373 2047 1869 1507 1145 916 730 530 340 167 321 18925 19447 20973 20416 20663 21024 21262 20869 21135 20971 21025 20859 20098 19671 19614 19482 19751 20451 21246 22004 22258 22509 23247 23965 23442 23249 22990 23156 23300 23173 23109 23185 23504 23361 23561 23015 22426 22004 21204 20734 20440 20742 20781 21031 21413 22151 23329 23885

So, there are several reasons this data is hard to analyse:

  1. The first column should be a date but it looks like an incomprehensible number and is named something odd.
  2. There are rows of information about the data set at the top of the file that we don’t want to use as part of the analysis.
  3. . We have column of data about ages we don’t want to deal with (people over 17).
  4. The columns of population counts are not imported as numbers.

So, lets start…

We re-import the data, this time specifying the format of the first column as a date. And while we’re at it, lets give it a sensible name.

sa_pop <- read_excel(here("static/3101054.xls"), 
           sheet = "Data1", 
           col_types = c("date", rep("text", 250)
           )
) %>%
  rename(Date = `...1`)

We remove the unnecessary rows by using slice to select the rows we want.

sa_pop <- sa_pop %>%
  slice(10:n())

We remove the unnecessary columns by using select to select the columns we want.

sa_pop <- sa_pop %>%
  select(Date, `Estimated Resident Population ;  Persons ;  0 ;`: `Estimated Resident Population ;  Persons ;  17 ;`)

This now gives us nicely rectangular data with each row as a year and each column as an age group.

sa_pop %>%
  head() %>%
  kable()
Date Estimated Resident Population ; Persons ; 0 ; Estimated Resident Population ; Persons ; 1 ; Estimated Resident Population ; Persons ; 2 ; Estimated Resident Population ; Persons ; 3 ; Estimated Resident Population ; Persons ; 4 ; Estimated Resident Population ; Persons ; 5 ; Estimated Resident Population ; Persons ; 6 ; Estimated Resident Population ; Persons ; 7 ; Estimated Resident Population ; Persons ; 8 ; Estimated Resident Population ; Persons ; 9 ; Estimated Resident Population ; Persons ; 10 ; Estimated Resident Population ; Persons ; 11 ; Estimated Resident Population ; Persons ; 12 ; Estimated Resident Population ; Persons ; 13 ; Estimated Resident Population ; Persons ; 14 ; Estimated Resident Population ; Persons ; 15 ; Estimated Resident Population ; Persons ; 16 ; Estimated Resident Population ; Persons ; 17 ;
1971-06-01 22184 22100 22293 21854 21313 21950 22181 23270 23807 24133 24846 24242 24269 23602 23404 22796 22237 21631
1972-06-01 22077 22352 22192 22387 21932 21336 22007 22225 23332 23872 24110 24947 24393 24278 23560 23308 22596 21976
1973-06-01 21030 22128 22604 22303 22486 22004 21346 22073 22270 23404 23940 24090 25037 24513 24229 23445 23147 22366
1974-06-01 19828 21206 22266 22887 22412 22586 22086 21375 22193 22353 23513 24044 24050 25114 24603 24135 23282 22971
1975-06-01 19732 20138 21660 22632 23390 22771 22944 22463 21687 22524 22642 23807 24277 24153 25287 24753 24136 23229
1976-06-01 18998 19593 20128 21783 22650 23546 22774 22937 22445 21632 22546 22641 23844 24284 24022 25262 24738 23969

This is already a seriously big achievement. And we should be proud of how useful it is to have this done in code rather than in cutting and pasting bit of Excel. Its way more efficient to write the code once because now we can run it repeatedly, we’ll never forgot the way we’ve cut and past data and if someone else comes along they can see exactly how it was done.

But to analyse this in R we need to do one last step. We need to re-shape this data into a particular shape. There is lots written on this because its a really common task for data scientists to have to do. So, have a read here if you’d like to explore this more.

For our purpose here lets have a look at the effect of this one line of code using the pivot_longer function.

sa_pop <- sa_pop %>%
  pivot_longer(names_to = "Age", values_to = "Population", -Date)

sa_pop %>%
  head() %>%
  kable()
Date Age Population
1971-06-01 Estimated Resident Population ; Persons ; 0 ; 22184
1971-06-01 Estimated Resident Population ; Persons ; 1 ; 22100
1971-06-01 Estimated Resident Population ; Persons ; 2 ; 22293
1971-06-01 Estimated Resident Population ; Persons ; 3 ; 21854
1971-06-01 Estimated Resident Population ; Persons ; 4 ; 21313
1971-06-01 Estimated Resident Population ; Persons ; 5 ; 21950

What that line of code did was take all the data in the columns that had a population measurement (that is, all the columns except “Date”) and turned them into a single column called “Population”. Then it created a new column called “Age” that inserted the name of each original column into the row that matches both the “Date” and the “Population”.

Using it

Before we dive into using it, this is a good place to fix the final problem we identified in the data, that the population values are text rather than numbers.

sa_pop <- sa_pop %>%
  mutate(Population = as.numeric(Population))

Then, for the sake of plotting neatly, lets just take the age from “Age” and leave of the “Estimated Resident Population” bit and take just the year from “Date”.

sa_pop <- sa_pop %>%
  mutate(Age = str_extract(Age, "\\d+(?=\\D*$)")) %>%
  mutate(Age = as.numeric(Age))  %>%
  mutate(Date = str_sub(Date, 1, 4))

Data in this shape is sooooo useful for testing different analyses. So, just to finish this post off, we might wonder, what is the population of South Australia for each age of childhood in each year?

We could show this on a single plot with age on the horizontal axis and each year as a different line.

sa_pop %>%
  mutate(Date = as.factor(Date)) %>%
  ggplot(aes(x = Age, y = Population, colour = Date)) + 
  geom_line()

Interpreting this many lines might be unclear so we can quickly select a few exemplars and re-plot it.

sa_pop %>%
  filter(Date %in% c(1980, 1990, 2000, 2010)) %>%
  mutate(Date = as.factor(Date)) %>%
  ggplot(aes(x = Age, y = Population, colour = Date)) + 
  geom_line()

Or we might want to try and show the interaction between age and date. This is useful to see the effect of particular cohorts aging.

sa_pop %>%
  ggplot(aes(x = Age, y = Date, fill = Population)) + 
  geom_tile() + 
  scale_fill_gradient(low="yellow", high="red")

# Summing up

This sort of work, finding, shaping, naming and generally tending to the data is a really important part of the job of a data scientist. I hope that by doing this work in code it makes the process more efficient. But I also hope it makes us more proud of having done it. Its not just an annoying part of the work that no one sees. By writing it in code this work is front and center and the top of our work. And who knows, by drawing attention to it, it might even provoke someone into sharing the original data in a better format to begin with!