# 4.2.2.2 Prepare source file for statistics Next you need to prepare your ***statistics*** source file. This is a [csv](https://en.wikipedia.org/wiki/Comma-separated_values) file for the statistical parameters that are used to calculate performance metrics and [**completeness rates**](https://www.vitalstrategies.org/wp-content/uploads/Estimating-Completeness-of-Birth-and-Death-Registration.pdf). You can import and create csv files in Excel or Google Drive.\ \ Using our [statistics.csv](https://github.com/opencrvs/opencrvs-countryconfig/blob/develop/src/data-seeding/locations/source/statistics.csv) as an example, download and create a new csv file with the statistical information for your country. | adminPcode | name | male\_population\_2008 | female\_population\_2008 | population\_2008 | crude\_birth\_rate\_2008 | male\_population\_2009 | female\_population\_2009 | population\_2009 | crude\_birth\_rate\_2009 | male\_population\_2010 | female\_population\_2010 | population\_2010 | crude\_birth\_rate\_2010 | male\_population\_2010 | female\_population\_2010 | population\_2010 | crude\_birth\_rate\_2010 | male\_population\_2012 | female\_population\_2012 | population\_2012 | crude\_birth\_rate\_2012 | male\_population\_2013 | female\_population\_2013 | population\_2013 | crude\_birth\_rate\_2013 | male\_population\_2014 | female\_population\_2014 | population\_2014 | crude\_birth\_rate\_2014 | male\_population\_2015 | female\_population\_2015 | population\_2015 | crude\_birth\_rate\_2015 | male\_population\_2016 | female\_population\_2016 | population\_2016 | crude\_birth\_rate\_2016 | male\_population\_2017 | female\_population\_2017 | population\_2017 | crude\_birth\_rate\_2017 | male\_population\_2018 | female\_population\_2018 | population\_2018 | crude\_birth\_rate\_2018 | male\_population\_2019 | female\_population\_2019 | population\_2019 | crude\_birth\_rate\_2019 | male\_population\_2020 | female\_population\_2020 | population\_2020 | crude\_birth\_rate\_2020 | male\_population\_2021 | female\_population\_2021 | population\_2021 | crude\_birth\_rate\_2021 | male\_population\_2022 | female\_population\_2022 | population\_2022 | crude\_birth\_rate\_2022 | | ----------- | ------- | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | ---------------------- | ------------------------ | ---------------- | ------------------------ | | AWn3s2RqgAN | Central | 177555 | 170774 | 348377 | 19.4 | 181676 | 175555 | 357291 | 19.6 | 188087 | 181116 | 369261 | 18.8 | 189251 | 182171 | 371480 | 17.6 | 191308 | 183928 | 375281 | 16.6 | 197533 | 190359 | 387958 | 17.9 | 143825 | 141233 | 285059 | 17.6 | 145664 | 142059 | 287723 | 19.3 | 149012 | 146810 | 295822 | 17.7 | 151786 | 149045 | 300831 | 16.6 | 152859 | 150197 | 303057 | 18.2 | 155068 | 139186 | 294255 | 16.9 | 152874 | 144456 | 297331 | 17.3 | 163391 | 148928 | 312320 | 17.6 | 387162 | 299071 | 686233 | 6.99 | | KozcEjeTyuD | Sulaka | 201028 | 186018 | 387046 | 19 | 201079 | 187184 | 388263 | 21.1 | 205044 | 189817 | 394861 | 17.6 | 207035 | 192464 | 399499 | 18.6 | 213349 | 199019 | 412368 | 20.3 | 213774 | 197747 | 411521 | 19 | 187272 | 180532 | 367806 | 18 | 175569 | 173179 | 348750 | 18.7 | 305507 | 306748 | 612257 | 19.7 | 309110 | 309404 | 618515 | 21.6 | 292729 | 289899 | 582630 | 20.1 | 303743 | 320864 | 624608 | 20 | 347497 | 306895 | 654393 | 18.1 | 365242 | 330116 | 695358 | 16.7 | 356247 | 297534 | 653781 | 17.9 | | B1u1bVtIA92 | Pualula | 245834 | 229646 | 475481 | 21 | 245920 | 228128 | 474048 | 22.7 | 252761 | 234940 | 487701 | 19 | 253865 | 236282 | 490147 | 19.5 | 260700 | 241754 | 502454 | 19.2 | 264423 | 245103 | 509534 | 18 | 267310 | 259051 | 526363 | 18.8 | 261220 | 257310 | 518530 | 19.4 | 280519 | 275429 | 555948 | 18.8 | 284831 | 280377 | 565210 | 20.1 | 278730 | 273515 | 552247 | 17.6 | 285236 | 269631 | 554868 | 17.2 | 300896 | 285807 | 586704 | 15.1 | 269712 | 303358 | 573070 | 15.3 | 260244 | 308373 | 568617 | 16.1 | Each row will represent a unique set of statistics for the highest administrative level in your country, e.g. admin level 1 / State. {% hint style="info" %} In our example you wll see rows of data for each level. But only the highest level is required and used since OpenCRVS v1.8 {% endhint %} Notice that the **adminPcode** and **name** columns are identical to applicable levels created in the csv file in the previous step. The next 4 columns are repeated for however many years you are able to source data from your statistical department. Each year **MUST** contain a minimum of 4 columns: * male\_population\_\ * female\_population\_\ * population\_\ * crude\_birth\_rate\_\ Be careful when adding extra years to not have any spaces in your headers between the name of the header and the year key. You can remove year blocks of 4 columns if you do not have this data, but make sure the available years that you do have run consecutively without any time gaps. You can add statistical data to a location every year going forward using our location APIs. {% hint style="info" %} **Note:** crude death rate is applied globally in the confgure application settngs step later in this documentation. **Note:** At this stage, there is not too much point in you entering data more than 5 years back in time as OpenCRVS can only calculate completeness rates based on the registration information it has available. In future versions, we plan to introduce legacy data import to include historical registrations. At that point, a history of population data becomes really powerful. You could add in legacy rates and develop a BI graph showing how completeness rates have accurately evolved over time due to civil registration policy and technological change. Such data can unlock investment opportunities. {% endhint %} {% hint style="info" %} Do not change or re-format the header row as the seeding process requires these names to be precise in order to parse the csv. Do not use commas in any cell and do not have any empty rows. {% endhint %}