[jb75]

@jb75 : I get it, there are 2 different dataset into one.

You just have to filter the "Patient" field on non digits chars

 ^[^\d]+$

Then you get the real dataset of the patients. You get 17 613 lines and I've check some patients, that seems good.

For the other dataset, is like a maintenance/operation dataset when you get the patient, the type of maintenance, the date and maybe who was in charge of the maintenance, but that's not really an interesting one, except the date of the checked data of the patient.

Well spotted, thank you very much!

[s0ched]

nice. thats a banger

[nobodycares]

Let’s all take a moment to enjoy the fresh air of this leak, please

[HexDex]

I CANT BREATHE NIGGA 

https://ichef.bbci.co.uk/news/480/cpspro...d.png.webp

hahaha you killed me, I was sure that someone would do that joke

---

Thx!

There was a problem generating the JSON; all the data is misaligned and one value does not correspond to its key. Example, from the beginning of the file:

head SOSoxygene.jsonl

{"Patient": "13703446", "address_id": "REVISION BIPAP", "ext_address_id": "FERNANDEZ RAFAEL", "active": "35", "Etablissement": "Termine - OK", "Voie": "#25ff35", "Complment": "2025-04-07 14:14:00.0", "Code postal": "BIPAP - Maintenance", "Ville": "#fffb0e", "description": "2025-04-10 00:00:00.0", "latitude": "2025-01-10 22:16:54.201369", "longitude": "BOLARD JULIEN  JULIEN"}

{"Patient": "12986305", "address_id": "REMPLISSAGE 1", "ext_address_id": "NAUDIN DOMINIQUE", "active": "30", "Etablissement": "Termine - OK", "Voie": "#25ff35", "Complment": "2024-11-05 09:30:00.0", "Code postal": "CUVE - Remplissage", "Ville": "#fffb0e", "latitude": "2024-02-08 11:28:35.445009", "longitude": "VERGERIO JEAN"}
{"Patient": "13596767", "address_id": "REVISION PPC TELEOBSERVE", "ext_address_id": "LESAGE JEREMY", "active": "35", "Etablissement": "A planifier", "Voie": "#f2ff38", "Code postal": "PPC - Maintenance", "Ville": "#fff405", "description": "2025-12-03 00:00:00.0", "latitude": "2024-12-04 03:06:21.219628", "longitude": "GAGNIER EVA  EVA"}
{"Patient": "13433287", "address_id": "REVISION PPC TELEOBSERVE", "ext_address_id": "BURLON BRUNO", "active": "35", "Etablissement": "A planifier", "Voie": "#f2ff38", "Code postal": "PPC - Maintenance", "Ville": "#fff405", "description": "2025-10-01 00:00:00.0", "latitude": "2024-10-02 03:02:01.07899", "longitude": "RINCON PIERRE  PIERRE"}
{"Patient": "DELPECH PATRICK", "address_id": "10888125", "ext_address_id": "877606", "Voie": "62 ROUTE DE MERLANDE", "Code postal": "33350", "Ville": "STE TERRE", "latitude": "44.83793852", "longitude": "-0.14706296", "Qualit": "9"}
{"Patient": "12960330", "address_id": "FIN DE VIE TURBINE S10 PAR UNE S11", "ext_address_id": "PARIS MARTINE", "active": "35", "Etablissement": "Termine - OK", "Voie": "#25ff35", "Complment": "2024-09-06 11:00:00.0", "Code postal": "PPC - Dpannage", "Ville": "#e8bb9a", "description": "2025-01-25 00:00:00.0", "latitude": "2024-01-27 01:52:01.295738", "longitude": "DAMAGNEZ SEVERINE  SEVERINE"}
{"Patient": "SEMENTERY MARINA", "address_id": "14450052", "Etablissement": "CHEZ SES PARENTS", "Voie": "13 CHEMIN DE CRAVOT", "Code postal": "33590", "Ville": "SAINT VIVIEN DE MEDOC", "latitude": "45.43385", "longitude": "-1.05498"}
{"Patient": "12709820", "address_id": "NE PAS REDECALER / REVISION PPC TELEOBSERVE", "ext_address_id": "BAUDRY NATHALIE", "active": "35", "Etablissement": "Termine - OK", "Voie": "#25ff35", "Complment": "2024-12-04 15:30:00.0", "Code postal": "PPC - Maintenance", "Ville": "#fff405", "description": "2024-09-24 00:00:00.0", "latitude": "2024-01-23 17:01:02.408365", "longitude": "LABEYRIE AXELLE  AXELLE"}
{"Patient": "13645328", "address_id": "REVISION PPC TELEOBSERVE", "ext_address_id": "PHILIPPE ESTRADE VALERIE", "active": "35", "Etablissement": "A planifier", "Voie": "#f2ff38", "Code postal": "PPC - Maintenance", "Ville": "#fff405", "description": "2025-12-23 00:00:00.0", "latitude": "2024-12-23 22:13:55.170403", "longitude": "PATCHE DANY  DANY"}
{"Patient": "13369066", "address_id": "REVISION PPC TELEOBSERVE", "ext_address_id": "VIVAS JACQUES", "active": "35", "Etablissement": "A planifier", "Voie": "#f2ff38", "Code postal": "PPC - Maintenance", "Ville": "#fff405", "description": "2025-09-04 00:00:00.0", "latitude": "2024-09-05 03:28:26.640591", "longitude": "FAVARD ELODIE  ELODIE"}

In red, invalid lines. In green, valid lines.

@HexDex2, did you breach the site yourself and messed up the JSON, or did someone give this file to you? This would have been posted by someone else than you, I would have said it was fake because of the hex color codes in some fields, which are typical of data generators.

Yep, the dataset is a real mess

@jb75 : I get it, there are 2 different dataset into one.

You just have to filter the "Patient" field on non digits chars

 ^[^\d]+$

Then you get the real dataset of the patients. You get 17 613 lines and I've check some patients, that seems good.

For the other dataset, is like a maintenance/operation dataset when you get the patient, the type of maintenance, the date and maybe who was in charge of the maintenance, but that's not really an interesting one, except the date of the checked data of the patient.

Hello, Good catch, that's right, towards the end it was equipment and not patients, I converted it incorrectly (it was an xls export format before).

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Contact Administration.

[T1m3w1z]

Gratuit en plus merci beaucoup bg

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Contact Administration.

[cerber]

Thanks for the Sharing free

[R4st4T00F]

What's the brisky.mp4 doing here?

[nafilah55]

I m gonna try this  thanks bro