4.2.2.2 Prepare source file for statistics

Next you need to prepare your statistics source file. This is a csv file for the statistical parameters that are used to calculate performance metrics and completeness rates. You can import and create csv files in Excel or Google Drive. Using our statistics.csv as an example, download and create a new csv file with the statistical information for your country.\

adminPcodenamemale_population_2008female_population_2008population_2008crude_birth_rate_2008male_population_2009female_population_2009population_2009crude_birth_rate_2009male_population_2010female_population_2010population_2010crude_birth_rate_2010male_population_2010female_population_2010population_2010crude_birth_rate_2010male_population_2012female_population_2012population_2012crude_birth_rate_2012male_population_2013female_population_2013population_2013crude_birth_rate_2013male_population_2014female_population_2014population_2014crude_birth_rate_2014male_population_2015female_population_2015population_2015crude_birth_rate_2015male_population_2016female_population_2016population_2016crude_birth_rate_2016male_population_2017female_population_2017population_2017crude_birth_rate_2017male_population_2018female_population_2018population_2018crude_birth_rate_2018male_population_2019female_population_2019population_2019crude_birth_rate_2019male_population_2020female_population_2020population_2020crude_birth_rate_2020male_population_2021female_population_2021population_2021crude_birth_rate_2021male_population_2022female_population_2022population_2022crude_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 an administrative division in your country.

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_<year>

  • female_population_<year>

  • population_<year>

  • crude_birth_rate_<year>

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 using the FHIR Location API.

Note: crude death rate is applied globally in the 3.2.5 Set up Application Settings 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.

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.

Last updated