возрожденное сообщество

Изначально, всё было в json формате.
Добавил столбец Line, в нём содержится номер строки, так как массив имел несколько значений на одной строке.
Удалил столбец ParentalName, так как он был пустой.

"SilabPersonId","LastName","FirstName","DateOfBirth","Gender","MobilePhone","Email","Line"
"9213232","Исмаилов","Интиган Мамад оглы","05.11.1981","M","0675000004","[email protected]","1"
"10355677","Черевишник","Сергій Всеволодович","21.04.1966","M","0675000009","[email protected]","2"
"5657837","Наумов","Сергій Харитонович","09.06.1971","M","0675000010","[email protected]","3"
"69000202942","Наумов","Сергій Харітонович","09.06.1971","M","0675000010",,"3"
"5001545652","Калынив","Наталья Сергеевна","21.08.1978","F","0675000013","[email protected]","4"

Изначально, всё было в json формате (битый).
Удалил столбцы status_color и goods (после него json был битый).
Ещё удалил () в номерах телефонов.

"id","customer","tel","email","dop","summ","date","apt","city","brand","trusted","police","juridical","juridical_user","franchise","status"
"51000110","Кокоша Олександр Михайлович","0977059172",,"Заказ от страховой компании INSUR.ANCTM.BIZ (API)","725.99","19.01.2023 14:45:01","ул. Николая Лаврухина, 3 (Троещина)","Киев","АНЦ","Кокоша Олександр Михайлович","124024","Універсальна","Петрук Олександр Петрович","5","відмовлено клієнтом"
"51001320","Пилюшенко Інна Миколаївна","0978810288",,"Заказ от страховой компании INSUR.ANCTM.BIZ (API)","916.93","19.01.2023 15:00:04","ул. Грушевського, 10-В","Васильков","АНЦ","Пилюшенко Інна Миколаївна","107450","Універсальна","Петрук Олександр Петрович","0","виконано"
"51001460","Мельник Ігор Михайлович","0665149811",," INSUR.ANCTM.BIZ","1149.76","19.01.2023 15:01:32","пр. Независимости, 11 (Ленина)","Южноукраинск","АНЦ","Координатор СГ ТАС Трохимець","1455890","СГ ТАС","Світлана Миколаївна Кравець","0","виконано"
"51001610","Шевченко Тарас Григорович","0980796151",," INSUR.ANCTM.BIZ","479.69","19.01.2023 15:03:09","пр. Богдана Хмельницкого, 123 (ул. Героев Сталинграда)","Днепр","АНЦ","Шевченко Тарас Григорович","20913481","Провідна","Кобилянська Вікторія Ігорівна","0","виконано"
"51001760","Язенок Наталія Михайлівна","0961700372",,"Заказ от страховой компании INSUR.ANCTM.BIZ (API)","2116.41","19.01.2023 15:06:02","пр-т. Ивана Мазепы, 13/9","Вышгород","Аптека Копейка","Язенок Наталія Михайлівна","481/3-2-653","УНІКА","Сафарова Світлана Георгіївна","0","виконано"

{
"_id": {
"$oid": "5e3430c354d5dc00e518cabd"
},
"consignee": {
"delivery_address": {
"address_type": "Door",
"address": "prospekt nahimova dom 156 kvartira 14",
"city": "Mariupol",
"region": null,
"zipcode": "87525",
"country": "UA",
"country_name": "Ukraine",
"comments": null,
"ref_city": null,
"ref_address": null,
"ref_warehouse": null,
"warehouse_owner": 12,
"street": null,
"building": null,
"apt": null,
"lang": "en"
},
"name": "Evgeniya Kovantceva",
"type": "Private person",
"code": null,
"public_legal_registry_code": null,
"residency": null,
"account_no": null,
"contact_person_name": "Evgeniya Kovantceva",
"contact_person_surname": null,
"phone_num_main": "380730525836",
"initial_phone_num": "380730525836",
"additional_phone_nums": null,
"email": null,
"notifications": [],
"address": {
"address": "prospekt nahimova dom 156 kvartira 14",
"city": "Mariupol",
"region": null,
"zipcode": "87525",
"country": "UA",
"country_name": "Ukraine",
"address_type": "Door",
"warehouse": null,
"street": null,
"building": null,
"apt": null
}
}
}
{
"_id": {
"$oid": "5e3430c370d2dc00cb2ad6a3"
},
"consignee": {
"delivery_address": {
"address_type": "Door",
"address": "prospekt nahimova dom 156 kvartira 14",
"city": "Mariupol",
"region": null,
"zipcode": "87525",
"country": "UA",
"country_name": "Ukraine",
"comments": null,
"ref_city": null,
"ref_address": null,
"ref_warehouse": null,
"warehouse_owner": 12,
"street": null,
"building": null,
"apt": null,
"lang": "en"
},
"name": "Evgeniya Kovantceva",
"type": "Private person",
"code": null,
"public_legal_registry_code": null,
"residency": null,
"account_no": null,
"contact_person_name": "Evgeniya Kovantceva",
"contact_person_surname": null,
"phone_num_main": "380730525836",
"initial_phone_num": "380730525836",
"additional_phone_nums": null,
"email": null,
"notifications": [],
"address": {
"address": "prospekt nahimova dom 156 kvartira 14",
"city": "Mariupol",
"region": null,
"zipcode": "87525",
"country": "UA",
"country_name": "Ukraine",
"address_type": "Door",
"warehouse": null,
"street": null,
"building": null,
"apt": null
}
}
}
{
"_id": {
"$oid": "5e3430c370d2dc00d21957ac"
},
"consignee": {
"delivery_address": {
"address_type": "Door",
"address": "prospekt nahimova dom 156 kvartira 14",
"city": "Mariupol",
"region": null,
"zipcode": "87525",
"country": "UA",
"country_name": "Ukraine",
"comments": null,
"ref_city": null,
"ref_address": null,
"ref_warehouse": null,
"warehouse_owner": 12,
"street": null,
"building": null,
"apt": null,
"lang": "en"
},
"name": "Evgeniya Kovantceva",
"type": "Private person",
"code": null,
"public_legal_registry_code": null,
"residency": null,
"account_no": null,
"contact_person_name": "Evgeniya Kovantceva",
"contact_person_surname": null,
"phone_num_main": "380730525836",
"initial_phone_num": "380730525836",
"additional_phone_nums": null,
"email": null,
"notifications": [],
"address": {
"address": "prospekt nahimova dom 156 kvartira 14",
"city": "Mariupol",
"region": null,
"zipcode": "87525",
"country": "UA",
"country_name": "Ukraine",
"address_type": "Door",
"warehouse": null,
"street": null,
"building": null,
"apt": null
}
}
}

{"_id": {"$oid": "5e3430c354d5dc00e518cabd"},"consignee": {"delivery_address": {"address_type": "Door","address": "prospekt nahimova dom 156 kvartira 14","city": "Mariupol","region": null,"zipcode": "87525","country": "UA","country_name": "Ukraine","comments": null,"ref_city": null,"ref_address": null,"ref_warehouse": null,"warehouse_owner": 12,"street": null,"building": null,"apt": null,"lang": "en"},"name": "Evgeniya Kovantceva","type": "Private person","code": null,"public_legal_registry_code": null,"residency": null,"account_no": null,"contact_person_name": "Evgeniya Kovantceva","contact_person_surname": null,"phone_num_main": "380730525836","initial_phone_num": "380730525836","additional_phone_nums": null,"email": null,"notifications": [],"address": {"address": "prospekt nahimova dom 156 kvartira 14","city": "Mariupol","region": null,"zipcode": "87525","country": "UA","country_name": "Ukraine","address_type": "Door","warehouse": null,"street": null,"building": null,"apt": null}}}
{"_id": {"$oid": "5e3430c370d2dc00cb2ad6a3"},"consignee": {"delivery_address": {"address_type": "Door","address": "prospekt nahimova dom 156 kvartira 14","city": "Mariupol","region": null,"zipcode": "87525","country": "UA","country_name": "Ukraine","comments": null,"ref_city": null,"ref_address": null,"ref_warehouse": null,"warehouse_owner": 12,"street": null,"building": null,"apt": null,"lang": "en"},"name": "Evgeniya Kovantceva","type": "Private person","code": null,"public_legal_registry_code": null,"residency": null,"account_no": null,"contact_person_name": "Evgeniya Kovantceva","contact_person_surname": null,"phone_num_main": "380730525836","initial_phone_num": "380730525836","additional_phone_nums": null,"email": null,"notifications": [],"address": {"address": "prospekt nahimova dom 156 kvartira 14","city": "Mariupol","region": null,"zipcode": "87525","country": "UA","country_name": "Ukraine","address_type": "Door","warehouse": null,"street": null,"building": null,"apt": null}}}
{"_id": {"$oid": "5e3430c370d2dc00d21957ac"},"consignee": {"delivery_address": {"address_type": "Door","address": "prospekt nahimova dom 156 kvartira 14","city": "Mariupol","region": null,"zipcode": "87525","country": "UA","country_name": "Ukraine","comments": null,"ref_city": null,"ref_address": null,"ref_warehouse": null,"warehouse_owner": 12,"street": null,"building": null,"apt": null,"lang": "en"},"name": "Evgeniya Kovantceva","type": "Private person","code": null,"public_legal_registry_code": null,"residency": null,"account_no": null,"contact_person_name": "Evgeniya Kovantceva","contact_person_surname": null,"phone_num_main": "380730525836","initial_phone_num": "380730525836","additional_phone_nums": null,"email": null,"notifications": [],"address": {"address": "prospekt nahimova dom 156 kvartira 14","city": "Mariupol","region": null,"zipcode": "87525","country": "UA","country_name": "Ukraine","address_type": "Door","warehouse": null,"street": null,"building": null,"apt": null}}}