date,clinic_id,patient_type,service_category,booking_source,revenue
2024-01-01,Jinniu,returning,general,referral,306.28
2024-01-01,Jinniu,returning,general,,311.61
2024-01-01,Jinniu,new,general,online_booking,358.18
2024-01-01,Jinniu,returning,general,walk-in,326.59
2024-01-01,Jinniu,new,general,walk-in,227.32
2024-01-01,Jinniu,new,general,online_booking,328.41
2024-01-01,Jinniu,returning,cosmetic,online_booking,945.64
2024-01-01,Jinniu,returning,orthodontics,online_booking,5392.2
2024-01-01,Jinniu,new,general,walk-in,285.31
2024-01-01,Wuhou,returning,cosmetic,walk-in,1543.55
2024-01-01,Wuhou,returning,general,online_booking,338.42
2024-01-01,Wuhou,returning,general,online_booking,371.09
2024-01-01,Wuhou,returning,cosmetic,online_booking,1410.06
2024-01-01,Wuhou,new,general,referral,312.66
2024-01-01,Wuhou,new,orthodontics,walk-in,6690.34
2024-01-01,Wuhou,new,general,walk-in,271.66
2024-01-01,Wuhou,returning,cosmetic,walk-in,1758.05
2024-01-01,Wuhou,new,general,online_booking,299.08
2024-01-01,Chenghua,returning,general,online_booking,249.45
2024-01-01,Chenghua,returning,implant,,9308.03
2024-01-01,Chenghua,new,cosmetic,walk-in,953.72
2024-01-01,Chenghua,returning,general,referral,295.05
2024-01-01,Chenghua,returning,general,walk-in,358.71
2024-01-01,Chenghua,returning,cosmetic,online_booking,894.88
2024-01-01,Chenghua,new,cosmetic,walk-in,1272.41
2024-01-01,Chenghua,returning,implant,walk-in,14792.21
2024-01-01,Qingyang,new,implant,walk-in,10283.56
2024-01-01,Qingyang,returning,general,walk-in,214.99
2024-01-01,Qingyang,returning,orthodontics,online_booking,5394.64
2024-01-01,Qingyang,returning,general,walk-in,266.76
2024-01-01,Qingyang,new,cosmetic,walk-in,1215.59
2024-01-01,Qingyang,new,general,walk-in,280.95
2024-01-01,Qingyang,returning,implant,walk-in,9153.91
2024-01-01,Qingyang,returning,general,walk-in,269.68
2024-01-01,Qingyang,returning,orthodontics,walk-in,4309.11
2024-01-01,Shuangliu,returning,cosmetic,referral,1648.13
2024-01-01,Shuangliu,returning,general,walk-in,329.42
2024-01-01,Shuangliu,returning,general,walk-in,347.94
2024-01-01,Shuangliu,returning,orthodontics,referral,4872.85
2024-01-01,Shuangliu,returning,orthodontics,referral,6223.48
2024-01-01,Shuangliu,returning,general,walk-in,349.87
2024-01-01,Shuangliu,new,implant,walk-in,5000
2024-01-01,Shuangliu,returning,implant,walk-in,12920.38
2024-01-02,Jinniu,returning,cosmetic,online_booking,1322.9
2024-01-02,Jinniu,returning,cosmetic,referral,1568.51
2024-01-02,Jinniu,returning,cosmetic,walk-in,1492.79
2024-01-02,Jinniu,new,orthodontics,online_booking,4053.78
2024-01-02,Jinniu,returning,cosmetic,online_booking,1593.02
2024-01-02,Jinniu,returning,general,walk-in,266.28
2024-01-02,Jinniu,returning,general,referral,376.37
2024-01-02,Jinniu,new,general,referral,375.33
2024-01-02,Jinniu,new,general,online_booking,230.03
2024-01-02,Jinniu,returning,cosmetic,walk-in,1503.57
2024-01-02,Wuhou,returning,cosmetic,walk-in,1697.9
2024-01-02,Wuhou,returning,general,walk-in,339.54
2024-01-02,Wuhou,new,cosmetic,referral,1474.97
2024-01-02,Wuhou,new,general,,281.89
2024-01-02,Wuhou,returning,orthodontics,online_booking,4248.42
2024-01-02,Wuhou,new,general,referral,283.15
2024-01-02,Chenghua,new,cosmetic,walk-in,1239.2
2024-01-02,Chenghua,returning,orthodontics,referral,5735.1
2024-01-02,Chenghua,returning,general,walk-in,336.7
2024-01-02,Chenghua,new,cosmetic,referral,1941.31
2024-01-02,Qingyang,new,orthodontics,walk-in,7541.17
2024-01-02,Qingyang,returning,orthodontics,online_booking,4552.25
2024-01-02,Qingyang,returning,general,walk-in,322.56
2024-01-02,Qingyang,returning,general,walk-in,249.26
2024-01-02,Qingyang,new,general,referral,286.97
2024-01-02,Qingyang,returning,general,referral,370.42
2024-01-02,Qingyang,returning,general,referral,297.68
2024-01-02,Shuangliu,returning,general,online_booking,250.81
2024-01-02,Shuangliu,new,cosmetic,walk-in,1378.78
2024-01-02,Shuangliu,returning,implant,online_booking,8861.98
2024-01-02,Shuangliu,returning,general,walk-in,258.21
2024-01-02,Shuangliu,returning,orthodontics,walk-in,4435.97
2024-01-02,Shuangliu,new,general,referral,327.62
2024-01-02,Shuangliu,returning,cosmetic,walk-in,1391.84
2024-01-02,Shuangliu,returning,general,online_booking,299.58
2024-01-03,Jinniu,returning,cosmetic,walk-in,1473.95
2024-01-03,Jinniu,returning,general,walk-in,334.76
2024-01-03,Jinniu,new,cosmetic,walk-in,945.18
2024-01-03,Jinniu,returning,general,walk-in,239.46
2024-01-03,Jinniu,returning,general,walk-in,336.09
2024-01-03,Jinniu,new,cosmetic,online_booking,1647.5
2024-01-03,Wuhou,returning,general,walk-in,300.49
2024-01-03,Wuhou,returning,cosmetic,referral,1982.66
2024-01-03,Wuhou,returning,cosmetic,online_booking,1331.76
2024-01-03,Wuhou,returning,orthodontics,online_booking,4045.61
2024-01-03,Wuhou,new,cosmetic,online_booking,1436.12
2024-01-03,Wuhou,new,cosmetic,walk-in,1037.65
2024-01-03,Wuhou,new,general,walk-in,309.04
2024-01-03,Wuhou,new,orthodontics,online_booking,7410.23
2024-01-03,Wuhou,new,general,referral,233.4
2024-01-03,Chenghua,returning,orthodontics,walk-in,4251.8
2024-01-03,Chenghua,returning,orthodontics,online_booking,7178.67
2024-01-03,Chenghua,returning,cosmetic,walk-in,1333.02
2024-01-03,Chenghua,returning,general,walk-in,304.76
2024-01-03,Chenghua,new,cosmetic,walk-in,1095.87
2024-01-03,Chenghua,returning,general,walk-in,339.82