# select wmo, wban, day from obs group by wmo, wban, day having count(*) > 1; wmo | wban | day --------+-------+------------ 722520 | 12920 | 1965-03-10 722520 | 12920 | 1965-03-11 722535 | 12909 | 1973-12-01 722535 | 12909 | 1973-12-02 722535 | 12909 | 1973-12-03 722535 | 12909 | 1973-12-05 722535 | 12909 | 1973-12-06 722535 | 12909 | 1973-12-07 722535 | 12909 | 1973-12-08 722535 | 12909 | 1973-12-09 722535 | 12909 | 1973-12-10 722535 | 12909 | 1973-12-11 722535 | 12909 | 1973-12-12 722535 | 12909 | 1973-12-15 722535 | 12909 | 1973-12-17 722535 | 12909 | 1973-12-18 722535 | 12909 | 1973-12-19 722535 | 12909 | 1973-12-21 722535 | 12909 | 1973-12-22 722535 | 12909 | 1973-12-23 722535 | 12909 | 1973-12-24 722535 | 12909 | 1973-12-25 722535 | 12909 | 1973-12-26 722535 | 12909 | 1973-12-28 722535 | 12909 | 1973-12-29 722535 | 12909 | 1973-12-30 722535 | 12909 | 1973-12-31 722540 | 13904 | 1999-05-24 722540 | 13904 | 1999-05-25 722540 | 13904 | 1999-05-26 722540 | 13904 | 1999-05-27 722540 | 13904 | 1999-05-28 722540 | 13904 | 1999-05-29 722540 | 13904 | 1999-05-30 722540 | 13904 | 1999-05-31 722540 | 13904 | 1999-06-01 722540 | 13904 | 1999-07-01 722540 | 13904 | 1999-07-02 722540 | 13904 | 1999-07-03 722540 | 13904 | 1999-07-04 722540 | 13904 | 1999-07-05 722540 | 13904 | 1999-07-06 722540 | 13904 | 1999-07-07 722540 | 13904 | 1999-07-08 722540 | 13904 | 1999-07-09 722540 | 13904 | 1999-07-10 722540 | 13904 | 1999-07-11 722540 | 13904 | 1999-07-12 722540 | 13904 | 1999-07-13 722540 | 13904 | 1999-07-14 722540 | 13904 | 1999-07-15 722540 | 13904 | 1999-07-16 722540 | 13904 | 1999-07-17 722540 | 13904 | 1999-07-18 722540 | 13904 | 1999-07-19 722540 | 13904 | 1999-07-20 722540 | 13904 | 1999-07-21 722540 | 13904 | 1999-07-22 722540 | 13904 | 1999-07-23 722540 | 13904 | 1999-07-24 722540 | 13904 | 1999-07-25 722540 | 13904 | 1999-07-26 722540 | 13904 | 1999-07-27 722540 | 13904 | 1999-07-28 722540 | 13904 | 1999-07-29 722540 | 13904 | 1999-07-30 722540 | 13904 | 1999-07-31 722540 | 13904 | 1999-08-01 722540 | 13904 | 1999-08-02 722540 | 13904 | 1999-08-03 722540 | 13904 | 1999-08-04 722540 | 13904 | 1999-08-05 722540 | 13904 | 1999-08-06 722540 | 13904 | 1999-08-07 722540 | 13904 | 1999-08-08 722540 | 13904 | 1999-08-09 722540 | 13904 | 1999-08-10 722540 | 13904 | 1999-08-11 722540 | 13904 | 1999-08-12 722540 | 13904 | 1999-08-13 722540 | 13904 | 1999-08-14 722540 | 13904 | 1999-08-15 722540 | 13904 | 1999-08-16 722540 | 13904 | 1999-08-17 722540 | 13904 | 1999-08-18 722540 | 13904 | 1999-08-19 722540 | 13904 | 1999-08-20 722540 | 13904 | 1999-08-21 722540 | 13904 | 1999-08-22 722540 | 13904 | 1999-08-23 722540 | 13904 | 1999-08-24 722540 | 13904 | 1999-08-25 722540 | 13904 | 1999-08-26 722540 | 13904 | 1999-08-27 722540 | 13904 | 1999-08-28 722540 | 13904 | 1999-08-29 722540 | 13904 | 1999-08-30 722540 | 13904 | 1999-08-31 722540 | 13904 | 1999-09-01 722540 | 13904 | 1999-09-02 722540 | 13904 | 1999-09-03 722540 | 13904 | 1999-09-04 722540 | 13904 | 1999-09-05 722540 | 13904 | 1999-09-06 722540 | 13904 | 1999-09-07 722540 | 13904 | 1999-09-08 722540 | 13904 | 1999-09-09 722540 | 13904 | 1999-09-10 722540 | 13904 | 1999-09-11 722540 | 13904 | 1999-09-12 722540 | 13904 | 1999-09-13 722540 | 13904 | 1999-09-14 722540 | 13904 | 1999-09-15 722540 | 13904 | 1999-09-16 722540 | 13904 | 1999-09-17 722540 | 13904 | 1999-09-18 722540 | 13904 | 1999-09-19 722540 | 13904 | 1999-09-20 722540 | 13904 | 1999-09-21 722540 | 13904 | 1999-09-22 722540 | 13904 | 1999-09-23 722540 | 13904 | 1999-09-24 722540 | 13904 | 1999-09-25 722540 | 13904 | 1999-09-26 722540 | 13904 | 1999-09-27 722540 | 13904 | 1999-09-28 722540 | 13904 | 1999-09-29 722540 | 13904 | 1999-09-30 722540 | 13904 | 1999-10-01 722540 | 13904 | 1999-10-02 722540 | 13904 | 1999-10-03 722540 | 13904 | 1999-10-04 722540 | 13904 | 1999-10-05 722540 | 13904 | 1999-10-06 722540 | 13904 | 1999-10-07 722540 | 13904 | 1999-10-08 722540 | 13904 | 1999-10-09 722540 | 13904 | 1999-10-10 722540 | 13904 | 1999-10-11 722540 | 13904 | 1999-10-12 722540 | 13904 | 1999-10-13 722540 | 13904 | 1999-10-14 722540 | 13904 | 1999-10-15 722540 | 13904 | 1999-10-16 722540 | 13904 | 1999-10-17 722540 | 13904 | 1999-10-18 722540 | 13904 | 1999-10-19 722540 | 13904 | 1999-10-20 722540 | 13904 | 1999-10-21 722540 | 13904 | 1999-10-22 722540 | 13904 | 1999-10-23 722540 | 13904 | 1999-10-24 722540 | 13904 | 1999-10-25 722540 | 13904 | 1999-10-26 722540 | 13904 | 1999-10-27 722540 | 13904 | 1999-10-28 722540 | 13904 | 1999-10-29 722540 | 13904 | 1999-10-30 722540 | 13904 | 1999-10-31 722540 | 13904 | 1999-11-01 722540 | 13904 | 1999-11-02 722540 | 13904 | 1999-11-03 722540 | 13904 | 1999-11-04 722540 | 13904 | 1999-11-05 722540 | 13904 | 1999-11-06 722540 | 13904 | 1999-11-07 722540 | 13904 | 1999-11-08 722540 | 13904 | 1999-11-09 722540 | 13904 | 1999-11-10 722540 | 13904 | 1999-11-11 722540 | 13904 | 1999-11-12 722540 | 13904 | 1999-11-13 722540 | 13904 | 1999-11-14 722540 | 13904 | 1999-11-15 722540 | 13904 | 1999-11-16 722540 | 13904 | 1999-11-17 722540 | 13904 | 1999-11-18 722540 | 13904 | 1999-11-19 722540 | 13904 | 1999-11-20 722540 | 13904 | 1999-11-21 722540 | 13904 | 1999-11-22 722540 | 13904 | 1999-11-23 722540 | 13904 | 1999-11-24 722540 | 13904 | 1999-11-25 722540 | 13904 | 1999-11-26 722540 | 13904 | 1999-11-27 722540 | 13904 | 1999-11-28 722540 | 13904 | 1999-11-29 722540 | 13904 | 1999-11-30 722540 | 13904 | 1999-12-01 722540 | 13904 | 1999-12-02 722540 | 13904 | 1999-12-03 722540 | 13904 | 1999-12-04 722540 | 13904 | 1999-12-05 722540 | 13904 | 1999-12-06 722540 | 13904 | 1999-12-07 722540 | 13904 | 1999-12-08 722540 | 13904 | 1999-12-09 722540 | 13904 | 1999-12-10 722540 | 13904 | 1999-12-11 722540 | 13904 | 1999-12-12 722540 | 13904 | 1999-12-13 722540 | 13904 | 1999-12-14 722540 | 13904 | 1999-12-15 722540 | 13904 | 1999-12-16 722540 | 13904 | 1999-12-17 722540 | 13904 | 1999-12-18 722540 | 13904 | 1999-12-19 722540 | 13904 | 1999-12-20 722540 | 13904 | 1999-12-21 722540 | 13904 | 1999-12-22 722540 | 13904 | 1999-12-23 722540 | 13904 | 1999-12-24 722540 | 13904 | 1999-12-25 722540 | 13904 | 1999-12-26 722540 | 13904 | 1999-12-27 722540 | 13904 | 1999-12-28 722540 | 13904 | 1999-12-29 722540 | 13904 | 1999-12-30 722540 | 13904 | 1999-12-31 722630 | 23034 | 1952-03-01 722650 | 23023 | 1952-03-01 722915 | 93114 | 1989-11-15 723600 | 23051 | 1977-08-28 723600 | 23051 | 1977-08-29 723600 | 23051 | 1977-08-30 723600 | 23051 | 1977-08-31 725111 | 14751 | 1985-06-01 725111 | 14751 | 1985-06-02 725111 | 14751 | 1985-06-03 725111 | 14751 | 1985-06-04 725111 | 14751 | 1985-06-05 725111 | 14751 | 1985-06-06 725111 | 14751 | 1985-06-07 725111 | 14751 | 1985-06-08 725111 | 14751 | 1985-06-09 725111 | 14751 | 1985-06-10 725111 | 14751 | 1985-06-11 725111 | 14751 | 1985-06-12 725111 | 14751 | 1985-06-13 725111 | 14751 | 1985-06-14 725111 | 14751 | 1985-06-15 725111 | 14751 | 1985-06-16 725111 | 14751 | 1985-06-17 725111 | 14751 | 1985-06-18 725111 | 14751 | 1985-06-19 725111 | 14751 | 1985-06-20 725111 | 14751 | 1985-06-21 725111 | 14751 | 1985-06-22 725111 | 14751 | 1985-06-23 725111 | 14751 | 1985-06-24 725111 | 14751 | 1985-06-25 725111 | 14751 | 1985-06-26 725111 | 14751 | 1985-06-27 725111 | 14751 | 1985-06-28 725111 | 14751 | 1985-06-29 725111 | 14751 | 1985-06-30 725111 | 14751 | 1985-07-01 725111 | 14751 | 1985-07-02 725111 | 14751 | 1985-07-03 725111 | 14751 | 1985-07-04 725111 | 14751 | 1985-07-05 725111 | 14751 | 1985-07-06 725111 | 14751 | 1985-07-07 725111 | 14751 | 1985-07-08 725111 | 14751 | 1985-07-09 725111 | 14751 | 1985-07-10 725111 | 14751 | 1985-07-11 725111 | 14751 | 1985-07-12 725111 | 14751 | 1985-07-13 725111 | 14751 | 1985-07-14 725111 | 14751 | 1985-07-15 725111 | 14751 | 1985-07-16 725111 | 14751 | 1985-07-17 725111 | 14751 | 1985-07-18 725111 | 14751 | 1985-07-19 725111 | 14751 | 1985-07-20 725111 | 14751 | 1985-07-21 725111 | 14751 | 1985-07-22 725111 | 14751 | 1985-07-23 725111 | 14751 | 1985-07-24 725111 | 14751 | 1985-07-25 725111 | 14751 | 1985-07-26 725111 | 14751 | 1985-07-27 725111 | 14751 | 1985-07-28 725111 | 14751 | 1985-07-29 725111 | 14751 | 1985-07-30 725111 | 14751 | 1985-07-31 725111 | 14751 | 1985-08-01 725111 | 14751 | 1985-08-02 725111 | 14751 | 1985-08-03 725111 | 14751 | 1985-08-04 725111 | 14751 | 1985-08-05 725111 | 14751 | 1985-08-06 725111 | 14751 | 1985-08-07 725111 | 14751 | 1985-08-08 725111 | 14751 | 1985-08-09 725111 | 14751 | 1985-08-10 725111 | 14751 | 1985-08-11 725111 | 14751 | 1985-08-12 725111 | 14751 | 1985-08-13 725111 | 14751 | 1985-08-14 725111 | 14751 | 1985-08-15 725111 | 14751 | 1985-08-16 725111 | 14751 | 1985-08-17 725111 | 14751 | 1985-08-18 725111 | 14751 | 1985-08-19 725111 | 14751 | 1985-08-20 725111 | 14751 | 1985-08-21 725111 | 14751 | 1985-08-22 725111 | 14751 | 1985-08-23 725111 | 14751 | 1985-08-24 725111 | 14751 | 1985-08-25 725111 | 14751 | 1985-08-26 725111 | 14751 | 1985-08-27 725111 | 14751 | 1985-08-28 725111 | 14751 | 1985-08-29 725111 | 14751 | 1985-08-30 725111 | 14751 | 1985-08-31 725111 | 14751 | 1985-09-01 725111 | 14751 | 1985-09-02 725111 | 14751 | 1985-09-03 725111 | 14751 | 1985-09-04 725111 | 14751 | 1985-09-05 725111 | 14751 | 1985-09-06 725111 | 14751 | 1985-09-07 725111 | 14751 | 1985-09-08 725111 | 14751 | 1985-09-09 725111 | 14751 | 1985-09-10 725111 | 14751 | 1985-09-11 725111 | 14751 | 1985-09-12 725111 | 14751 | 1985-09-13 725111 | 14751 | 1985-09-14 725111 | 14751 | 1985-09-15 725111 | 14751 | 1985-09-16 725111 | 14751 | 1985-09-17 725111 | 14751 | 1985-09-18 725111 | 14751 | 1985-09-19 725111 | 14751 | 1985-09-20 725111 | 14751 | 1985-09-21 725111 | 14751 | 1985-09-22 725111 | 14751 | 1985-09-23 725111 | 14751 | 1985-09-24 725111 | 14751 | 1985-09-25 725111 | 14751 | 1985-09-26 725111 | 14751 | 1985-09-27 725111 | 14751 | 1985-09-28 725111 | 14751 | 1985-09-29 725111 | 14751 | 1985-09-30 725111 | 14751 | 1985-10-01 725111 | 14751 | 1985-10-02 725111 | 14751 | 1985-10-03 725111 | 14751 | 1985-10-04 725111 | 14751 | 1985-10-05 725111 | 14751 | 1985-10-06 725111 | 14751 | 1985-10-07 725111 | 14751 | 1985-10-08 725111 | 14751 | 1985-10-09 725111 | 14751 | 1985-10-10 725111 | 14751 | 1985-10-11 725111 | 14751 | 1985-10-12 725111 | 14751 | 1985-10-13 725111 | 14751 | 1985-10-14 725111 | 14751 | 1985-10-15 725111 | 14751 | 1985-10-16 725111 | 14751 | 1985-10-17 725111 | 14751 | 1985-10-18 725111 | 14751 | 1985-10-19 725111 | 14751 | 1985-10-20 725111 | 14751 | 1985-10-21 725111 | 14751 | 1985-10-22 725111 | 14751 | 1985-10-23 725111 | 14751 | 1985-10-24 725111 | 14751 | 1985-10-25 725111 | 14751 | 1985-10-26 725111 | 14751 | 1985-10-27 725111 | 14751 | 1985-10-28 725111 | 14751 | 1985-10-29 725111 | 14751 | 1985-10-30 725111 | 14751 | 1985-10-31 725111 | 14751 | 1985-11-01 725111 | 14751 | 1985-11-02 725111 | 14751 | 1985-11-03 725111 | 14751 | 1985-11-04 725111 | 14751 | 1985-11-05 725111 | 14751 | 1985-11-06 725111 | 14751 | 1985-11-07 725111 | 14751 | 1985-11-08 725111 | 14751 | 1985-11-09 725111 | 14751 | 1985-11-10 725111 | 14751 | 1985-11-11 725111 | 14751 | 1985-11-12 725111 | 14751 | 1985-11-13 725111 | 14751 | 1985-11-14 725111 | 14751 | 1985-11-15 725111 | 14751 | 1985-11-16 725111 | 14751 | 1985-11-17 725111 | 14751 | 1985-11-18 725111 | 14751 | 1985-11-19 725111 | 14751 | 1985-11-20 725111 | 14751 | 1985-11-21 725111 | 14751 | 1985-11-22 725111 | 14751 | 1985-11-23 725111 | 14751 | 1985-11-24 725111 | 14751 | 1985-11-25 725111 | 14751 | 1985-11-26 725111 | 14751 | 1985-11-27 725111 | 14751 | 1985-11-28 725111 | 14751 | 1985-11-29 725111 | 14751 | 1985-11-30 725111 | 14751 | 1985-12-01 725111 | 14751 | 1985-12-02 725111 | 14751 | 1985-12-03 725111 | 14751 | 1985-12-04 725111 | 14751 | 1985-12-05 725111 | 14751 | 1985-12-06 725111 | 14751 | 1985-12-07 725111 | 14751 | 1985-12-08 725111 | 14751 | 1985-12-09 725111 | 14751 | 1985-12-10 725111 | 14751 | 1985-12-11 725111 | 14751 | 1985-12-12 725111 | 14751 | 1985-12-13 725111 | 14751 | 1985-12-14 725111 | 14751 | 1985-12-15 725111 | 14751 | 1985-12-16 725111 | 14751 | 1985-12-17 725111 | 14751 | 1985-12-18 725111 | 14751 | 1985-12-19 725111 | 14751 | 1985-12-20 725111 | 14751 | 1985-12-21 725111 | 14751 | 1985-12-22 725111 | 14751 | 1985-12-23 725111 | 14751 | 1985-12-24 725111 | 14751 | 1985-12-25 725111 | 14751 | 1985-12-26 725111 | 14751 | 1985-12-27 725111 | 14751 | 1985-12-28 725111 | 14751 | 1985-12-29 725111 | 14751 | 1985-12-30 725111 | 14751 | 1985-12-31 941200 | | 1952-03-01 942030 | | 1952-03-01 942120 | | 1952-03-01 943000 | | 1952-03-01 943120 | | 1952-03-01 943350 | | 1952-03-01 943740 | | 1952-03-01 944030 | | 1952-03-01 944300 | | 1952-03-01 944760 | | 1952-03-01 945100 | | 1952-03-01 946370 | | 1952-03-01 946460 | | 1952-03-01 946530 | | 1952-03-01 946590 | | 1952-03-01 946930 | | 1952-03-01 947760 | | 1952-03-01 947910 | | 1952-03-01 948210 | | 1952-03-01 948650 | | 1952-03-01 949070 | | 1952-03-01 949100 | | 1952-03-01 949260 | | 1952-02-29 949680 | | 1952-03-01 | 88703 | 1964-12-31 (466 rows)