Skip to content

Instantly share code, notes, and snippets.

View Starkyv's full-sized avatar
🎯
Focusing

mothilv Starkyv

🎯
Focusing
View GitHub Profile
@Starkyv
Starkyv / rsk_oil_gas_downtime_200rows.csv
Created June 25, 2025 05:55
Upload rsk_oil_gas_downtime_200rows.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 15 columns, instead of 12 in line 6.
date,asset_id,site_name,region,facility_type,potential_production_boe,produced_boe,planned_downtime_hours,unplanned_downtime_hours,total_downtime_hours,revenue_per_boe_usd,revenue_loss_usd,primary_downtime_cause,uptime_pct,data_source_downtime
2025-06-27,OG03,Aberdeen Delta,Aberdeen,Onshore Terminal,12000,11080.0,1.33,0.5,1.84,73.09,67243.0,Supply Constraint,92.33,Excel Log
2025-07-22,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,12923.0,2.57,4.2,6.77,78.15,396768.0,Equipment Failure,71.79,PI Historian
2025-07-02,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,14475.0,2.3,2.4,4.7,68.27,240652.0,Equipment Failure,80.42,PI Historian
2025-07-29,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,16740.0,1.68,0.0,1.68,64.35,81081.0,Supply Constraint,93.0,PI Historian
2025-05-20,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,15855.0,0.89,1.98,2.86,68.37,146654.0,Planned Maintenance,88.08,Maximo API
2025-06-19,OG01,NorthSea Alpha,North Sea,Offshore Platform,25000,15333.0,3.94,5.33,9.28,74.6,72115
@Starkyv
Starkyv / MoH_Qatar_Sample_Health_Data.csv
Created June 24, 2025 05:03
Upload MoH_Qatar_Sample_Health_Data.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 16 columns, instead of 2 in line 7.
Date,Region,Facility_Type,Department,Gender,Age_Group,Visit_Type,Nationality,Insurance_Type,Diagnosis_Category,Day_of_Week,Is_Holiday,Admission_Status,Bed_Occupancy,Wait_Time_Minutes,Treatment_Cost
2025-01-01,Al Rayyan,Primary Health Center,Cardiology,Male,46-60,Inpatient,Qatari,Self-Paid,Mental Health,Wednesday,False,Discharged,76,108,2192.0
2025-01-01,Al Rayyan,Hospital,Pediatrics,Female,18-30,Inpatient,Qatari,Self-Paid,Cardiovascular,Wednesday,False,Admitted,72,79,3744.0
2025-01-01,Al Rayyan,Hospital,Pediatrics,Female,18-30,Teleconsultation,Expats,Self-Paid,Infectious,Wednesday,False,Discharged,76,52,2230.0
2025-01-01,Al Khor,Primary Health Center,Oncology,Male,46-60,Outpatient,Qatari,Public,Mental Health,Wednesday,False,Discharged,83,36,457.0
2025-01-01,Al Khor,Clinic,Cardiology,Female,31-45,Inpatient,Expats,Private,Mental Health,Wednesday,False,Discharged,95,61,2522.0
2025-01-01,Doha,Clinic,Cardiology,Male,0-17,Outpatient,Expats,Public,Cardiovascular,Wednesday,False,Referred,87,104,4357.0
2025-01-02,Al R
@Starkyv
Starkyv / rsk_oil_gas_downtime_200rows.csv
Created June 23, 2025 10:50
Upload rsk_oil_gas_downtime_200rows.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 15 columns, instead of 12 in line 6.
date,asset_id,site_name,region,facility_type,potential_production_boe,produced_boe,planned_downtime_hours,unplanned_downtime_hours,total_downtime_hours,revenue_per_boe_usd,revenue_loss_usd,primary_downtime_cause,uptime_pct,data_source_downtime
2025-06-27,OG03,Aberdeen Delta,Aberdeen,Onshore Terminal,12000,11080.0,1.33,0.5,1.84,73.09,67243.0,Supply Constraint,92.33,Excel Log
2025-07-22,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,12923.0,2.57,4.2,6.77,78.15,396768.0,Equipment Failure,71.79,PI Historian
2025-07-02,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,14475.0,2.3,2.4,4.7,68.27,240652.0,Equipment Failure,80.42,PI Historian
2025-07-29,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,16740.0,1.68,0.0,1.68,64.35,81081.0,Supply Constraint,93.0,PI Historian
2025-05-20,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,15855.0,0.89,1.98,2.86,68.37,146654.0,Planned Maintenance,88.08,Maximo API
2025-06-19,OG01,NorthSea Alpha,North Sea,Offshore Platform,25000,15333.0,3.94,5.33,9.28,74.6,72115
@Starkyv
Starkyv / rsk_oil_gas_downtime_200rows.csv
Created June 23, 2025 10:36
Upload rsk_oil_gas_downtime_200rows.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 15 columns, instead of 12 in line 6.
date,asset_id,site_name,region,facility_type,potential_production_boe,produced_boe,planned_downtime_hours,unplanned_downtime_hours,total_downtime_hours,revenue_per_boe_usd,revenue_loss_usd,primary_downtime_cause,uptime_pct,data_source_downtime
2025-06-27,OG03,Aberdeen Delta,Aberdeen,Onshore Terminal,12000,11080.0,1.33,0.5,1.84,73.09,67243.0,Supply Constraint,92.33,Excel Log
2025-07-22,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,12923.0,2.57,4.2,6.77,78.15,396768.0,Equipment Failure,71.79,PI Historian
2025-07-02,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,14475.0,2.3,2.4,4.7,68.27,240652.0,Equipment Failure,80.42,PI Historian
2025-07-29,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,16740.0,1.68,0.0,1.68,64.35,81081.0,Supply Constraint,93.0,PI Historian
2025-05-20,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,15855.0,0.89,1.98,2.86,68.37,146654.0,Planned Maintenance,88.08,Maximo API
2025-06-19,OG01,NorthSea Alpha,North Sea,Offshore Platform,25000,15333.0,3.94,5.33,9.28,74.6,72115
@Starkyv
Starkyv / rsk_oil_gas_downtime_200rows.csv
Created June 23, 2025 08:34
Upload rsk_oil_gas_downtime_200rows.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 15 columns, instead of 12 in line 6.
date,asset_id,site_name,region,facility_type,potential_production_boe,produced_boe,planned_downtime_hours,unplanned_downtime_hours,total_downtime_hours,revenue_per_boe_usd,revenue_loss_usd,primary_downtime_cause,uptime_pct,data_source_downtime
2025-06-27,OG03,Aberdeen Delta,Aberdeen,Onshore Terminal,12000,11080.0,1.33,0.5,1.84,73.09,67243.0,Supply Constraint,92.33,Excel Log
2025-07-22,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,12923.0,2.57,4.2,6.77,78.15,396768.0,Equipment Failure,71.79,PI Historian
2025-07-02,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,14475.0,2.3,2.4,4.7,68.27,240652.0,Equipment Failure,80.42,PI Historian
2025-07-29,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,16740.0,1.68,0.0,1.68,64.35,81081.0,Supply Constraint,93.0,PI Historian
2025-05-20,OG02,IrishSea Beta,Irish Sea,Offshore Platform,18000,15855.0,0.89,1.98,2.86,68.37,146654.0,Planned Maintenance,88.08,Maximo API
2025-06-19,OG01,NorthSea Alpha,North Sea,Offshore Platform,25000,15333.0,3.94,5.33,9.28,74.6,72115
@Starkyv
Starkyv / rsk_oil_gas_sample_dataset_with_extras.csv
Created June 23, 2025 08:18
Upload rsk_oil_gas_sample_dataset_with_extras.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 21 columns, instead of 4 in line 5.
date,asset_id,site_name,region,facility_type,flare_volume_mscf,methane_leak_kg,produced_water_bbl,corrosion_rate_mm_per_year,pressure_cycles,overdue_work_orders,ghg_intensity_tCO2e_per_BOE,data_source_flare,data_source_integrity,data_source_ghg,wellhead_pressure_psi,equipment_uptime_pct,inspection_score_pct,scope1_emissions_tCO2e,energy_consumption_mwh,incident_severity_index
2025-05-01,OG01,NorthSea Alpha,North Sea,Offshore Platform,199.9,18.6,929,0.226,4,0,0.048,LIMS Export,Maximo API,Excel ESG,2554.0,97.16,86.4,118.7,42.3,0
2025-05-02,OG01,NorthSea Alpha,North Sea,Offshore Platform,191.2,30.1,683,0.124,3,2,0.041,LIMS Export,CorrosionRB CSV,Excel ESG,2400.0,98.16,86.7,117.5,53.0,0
2025-05-03,OG01,NorthSea Alpha,North Sea,Offshore Platform,139.5,23.1,618,0.079,7,1,0.048,PI Historian,Maximo API,ArcGIS,3093.0,97.64,90.4,62.7,60.1,0
2025-05-04,OG01,NorthSea Alpha,North Sea,Offshore Platform,158.2,21.1,569,0.169,3,2,0.047,PI Historian,SAP PM,ArcGIS,2486.0,98.58,88.9,82.0,47.5,0
2025-05-05,OG01,NorthSea Alpha,Nor
@Starkyv
Starkyv / rsk_ticc_synthetic_data(Testing, inspection, certification and compliance) New.csv
Created June 20, 2025 10:53
Upload rsk_ticc_synthetic_data(Testing, inspection, certification and compliance) New.csv
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 2.
PK?a]I:O�[Content_Types].xml���n�0E�����*1tQU�E���\{B,�� ����P[Q��M�d��sǎ<-�- � ���'2�:맥x�<�w"CR�(<�b(Fë�d3n�X��(�K���Fa"x�T!5��5MeTz�� oz�[��'�S�!��G���Q����� ��a-lY�P1:�q].��E�7��;; �6�5 ��Kh+6}��3���*ыjX%M��"J��]�� Ue5�Ǽ��@L�Y�e>��!����=j�O$.�DZ9��GŘ@��q��������6��9� i����ök�(�O�wb��r��?����y��7J| \��{os��>~PK?�I��K _rels/.rels���N�0 @�|E���nH��� ��&4>�$n���ă�@ �i�q��g���<��R� ,��·����iq* �#2p� ��f�L#J�ɽ�YH�z���u�=M�+��O�iB)���v������t�ɀ愩��@ں%��1�5ln[o��a� gZ��(dL��y�W�*P��]V׻�=��HС���hS�N��Z�u�] �όKB������#wY c�2�'7�|PK?Du[���xl/_rels/workbook.xml.rels���j�0D��
��ZvJ)�s)�\�����LlIh�i�� M��Čؙ����Ћ&�WP%�&�η
>wo�� �����H�����k�3�H"�xR��㋔d����&�As���Q��nQ.��I�i�W�bk���@�ƈ��M�| �k@�7*�wH{r��Cuj�\,���*r*��0�9a8���I�ͻ �9��>/�q���W��;��~p��6��ڿ0����#PK?��IL�
xl/worksheets/sheet1.xml��ݶ#���{�BC�'�����ǖ�nZM�Œ��W�e[�m�C�n�����Bd1b�R]I��L�
�|�����
@Starkyv
Starkyv / rsk_ticc_synthetic_data(Testing, inspection, certification and compliance).csv
Created June 20, 2025 10:41
Upload rsk_ticc_synthetic_data(Testing, inspection, certification and compliance).csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 15 columns, instead of 11 in line 9.
date,region,site_type,service_line,test_type,tests_performed,tests_failed,failure_rate_pct,inspection_count,non_conformities_found,audit_score,certification_due,certification_issued,revenue_gbp,cost_gbp
2025-05-11,North-West,Chemical Plant,Testing,Steel,66,3,4.55,15,0,88.0,No,No,8490.55,6247.74
2025-05-26,North-West,Rail Upgrade,Compliance,Soil,88,2,2.27,13,0,91.7,Yes,Yes,11833.73,7159.17
2025-05-05,Central,Rail Upgrade,Inspection,Water,82,3,3.66,15,0,96.3,Yes,Yes,12308.67,9032.14
2025-05-15,North-West,Chemical Plant,Testing,Concrete,79,4,5.06,14,0,90.4,No,No,13200.03,8748.96
2025-05-12,South-West,Wind Farm,Testing,Air,82,4,4.88,13,0,96.8,Yes,Yes,11341.17,7741.47
2025-05-19,North-West,Rail Upgrade,Compliance,Soil,92,6,6.52,14,0,75.3,Yes,Yes,13369.49,8025.51
2025-05-07,Scotland,Construction Site,Certification,Water,68,3,4.41,17,0,80.8,No,No,13003.25,10311.5
2025-05-01,North-West,Landfill,Testing,Water,96,4,4.17,19,0,96.4,Yes,Yes,11488.54,8009.41
2025-05-05,Central,Wind Farm,Compliance,Water,70,3,4.29,13,0,95.5
@Starkyv
Starkyv / data.csv
Created June 17, 2025 15:51
Upload data.csv
We can't make this file beautiful and searchable because it's too large.
Appointment date,Age range,Ethnicity,Health Facility,Health Facility District,Health Facility State,Health Facility Type,ICD-10 Diagnosis,Sex
2025-02-07,0-9,Bajau,Klinik Kesihatan Telipok,Kota Kinabalu,Sabah,Type 4,"Acute upper respiratory infection, unspecified",Male
2025-02-07,0-9,Bajau,Klinik Kesihatan Telipok,Kota Kinabalu,Sabah,Type 4,"Viral infection, unspecified",Female
2025-02-07,0-9,Bajau,Klinik Kesihatan Telupid,Beluran,Sabah,Type 4,"Acute tonsillitis, unspecified",Male
2025-02-07,0-9,Bidayuh,Klinik Kesihatan UTC Kuching,Kuching,Sarawak,Type 7,"Otitis externa, unspecified",Male
2025-02-07,0-9,Chinese,Klinik Kesihatan Bandar Botanik,Klang,Selangor,Type 1,"Acute upper respiratory infection, unspecified",Female
2025-02-07,0-9,Chinese,Klinik Kesihatan Bandar Botanik,Klang,Selangor,Type 1,"Acute upper respiratory infection, unspecified",Male
2025-02-07,0-9,Chinese,Klinik Kesihatan Bandar Tun Hussein Onn,Hulu Langat,Selangor,Type 1,"Acute upper respiratory infection, unspecified",Female
2025-02-07,0-9,Chi
@Starkyv
Starkyv / data.csv
Created June 17, 2025 15:51
Upload data.csv
We can't make this file beautiful and searchable because it's too large.
Appointment date,Age range,Ethnicity,Health Facility,Health Facility District,Health Facility State,Health Facility Type,ICD-10 Diagnosis,Sex
2025-02-07,0-9,Bajau,Klinik Kesihatan Telipok,Kota Kinabalu,Sabah,Type 4,"Acute upper respiratory infection, unspecified",Male
2025-02-07,0-9,Bajau,Klinik Kesihatan Telipok,Kota Kinabalu,Sabah,Type 4,"Viral infection, unspecified",Female
2025-02-07,0-9,Bajau,Klinik Kesihatan Telupid,Beluran,Sabah,Type 4,"Acute tonsillitis, unspecified",Male
2025-02-07,0-9,Bidayuh,Klinik Kesihatan UTC Kuching,Kuching,Sarawak,Type 7,"Otitis externa, unspecified",Male
2025-02-07,0-9,Chinese,Klinik Kesihatan Bandar Botanik,Klang,Selangor,Type 1,"Acute upper respiratory infection, unspecified",Female
2025-02-07,0-9,Chinese,Klinik Kesihatan Bandar Botanik,Klang,Selangor,Type 1,"Acute upper respiratory infection, unspecified",Male
2025-02-07,0-9,Chinese,Klinik Kesihatan Bandar Tun Hussein Onn,Hulu Langat,Selangor,Type 1,"Acute upper respiratory infection, unspecified",Female
2025-02-07,0-9,Chi