BugsCEP import 20231219: 'No period found for code'

[roger-mahler]

List of all 'No period found for code' errors in latest BugsCEP import.

with error_values as (
    select *, string_to_array(translate(bugs_data, '{}', ''), ',') as data_array, bugs_data
    from bugs_import.bugs_errors
    where TRUE
      and message = 'No period found for code'
) select data_array[4] as period_code, data_array[5] as dating_method, count(*) as count
  from error_values
  group by data_array[4], data_array[5]
  order by 1, 2 desc

period_code	dating_method	count
BS At	Pollen	8
BS Bo	Pollen	2
BS PB	GeolPer	1
BS SB	Pollen	3
BS SB	GeolPer	1
BS YD	GeolPer	13
ERom	ArchPer	2
LNeoNWEuro	null	1
LNeoNWEuro	ArchPer	3
LNeoSEEuro	ArchPer	1
MedGreen	HistPer	8
MedGreen	ArchPer	97
MedIce	ArchPer	261
MigScand	ArchPer	6
Neo	null	4
Neo	Dendro	8
Neo	ArchPer	176
RomIAScand	ArchPer	6