softwareheritage=> SELECT DISTINCT ON (ov.visit) ov.visit, ov.type, ov.date, ovs.date as status_date, ovs.status
FROM origin_visit ov
INNER JOIN origin o ON o.id = ov.origin
INNER JOIN origin_visit_status ovs USING (origin, visit)
WHERE o.url = 'https://github.com/python/cpython'
ORDER BY ov.visit ASC, ovs.date DESC;
visit | type | date | last_status_date | last_status
-------+------+-------------------------------+-------------------------------+-------------
1 | git | 2015-08-09 01:50:27.739002+00 | 2015-08-09 01:50:27.739002+00 | full
2 | git | 2016-03-15 17:22:43.546268+00 | 2016-03-15 17:22:43.546268+00 | full
3 | git | 2016-03-27 18:46:40.816045+00 | 2016-03-27 18:46:40.816045+00 | full
4 | git | 2016-04-04 09:46:06.594034+00 | 2016-04-04 09:46:06.594034+00 | full
5 | git | 2016-06-01 05:37:35.428762+00 | 2016-06-01 05:37:35.428762+00 | full
6 | git | 2016-06-16 09:49:09.802569+00 | 2016-06-16 09:49:09.802569+00 | full
7 | git | 2016-08-13 20:00:28.724135+00 | 2016-08-13 20:00:28.724135+00 | full
8 | git | 2016-08-17 04:54:28.578226+00 | 2016-08-17 04:54:28.578226+00 | full
9 | git | 2016-08-29 16:34:18.686581+00 | 2016-08-29 16:34:18.686581+00 | full
10 | git | 2016-09-07 06:26:03.673207+00 | 2016-09-07 06:26:03.673207+00 | full
11 | git | 2016-09-14 08:41:36.564949+00 | 2016-09-14 08:41:36.564949+00 | full
12 | git | 2016-09-23 08:50:51.526694+00 | 2016-09-23 08:50:51.526694+00 | full
13 | git | 2017-02-16 07:59:08.276504+00 | 2017-02-16 07:59:08.276504+00 | partial
14 | git | 2017-05-05 06:22:05.182498+00 | 2017-05-05 06:22:05.182498+00 | full
15 | git | 2018-03-03 14:56:52.264666+00 | 2018-03-03 14:56:52.264666+00 | partial
16 | git | 2018-06-05 15:23:48.247372+00 | 2018-06-05 15:23:48.247372+00 | partial
17 | git | 2018-06-29 00:36:23.333685+00 | 2018-06-29 00:36:23.333685+00 | partial
18 | git | 2018-07-06 04:48:03.262723+00 | 2018-07-06 04:48:03.262723+00 | partial
19 | git | 2018-07-11 00:15:18.379304+00 | 2018-07-11 00:15:18.379304+00 | partial
20 | git | 2018-07-11 23:29:54.057517+00 | 2018-07-11 23:29:54.057517+00 | partial
21 | git | 2018-07-13 01:42:11.111385+00 | 2018-07-13 01:42:11.111385+00 | partial
22 | git | 2018-07-13 17:47:20.369667+00 | 2018-07-13 17:47:20.369667+00 | partial
23 | git | 2018-07-14 03:07:41.08928+00 | 2018-07-14 03:07:41.08928+00 | partial
24 | git | 2018-07-14 15:07:59.328917+00 | 2018-07-14 15:07:59.328917+00 | partial
25 | git | 2018-07-15 09:57:07.004397+00 | 2018-07-15 09:57:07.004397+00 | partial
26 | git | 2018-07-15 18:07:47.241913+00 | 2018-07-15 18:07:47.241913+00 | partial
27 | git | 2018-07-17 05:25:27.236151+00 | 2018-07-17 05:25:27.236151+00 | partial
28 | git | 2018-07-18 10:55:12.645412+00 | 2018-07-18 10:55:12.645412+00 | partial
29 | git | 2018-07-19 03:50:21.165414+00 | 2018-07-19 03:50:21.165414+00 | partial
30 | git | 2018-07-19 18:50:42.348047+00 | 2018-07-19 18:50:42.348047+00 | partial
31 | git | 2018-07-20 13:38:59.9417+00 | 2018-07-20 13:38:59.9417+00 | partial
32 | git | 2018-07-28 10:57:30.235203+00 | 2018-07-28 10:57:30.235203+00 | partial
33 | git | 2018-08-29 19:48:17.276148+00 | 2018-08-29 19:48:17.276148+00 | partial
34 | git | 2018-08-30 17:31:59.471929+00 | 2018-08-30 17:31:59.471929+00 | partial
35 | git | 2018-08-31 04:59:46.840014+00 | 2018-08-31 04:59:46.840014+00 | partial
36 | git | 2018-09-01 21:14:55.38103+00 | 2018-09-01 21:14:55.38103+00 | partial
37 | git | 2018-09-02 10:35:37.644481+00 | 2018-09-02 10:35:37.644481+00 | partial
38 | git | 2018-09-02 23:04:49.192911+00 | 2018-09-02 23:04:49.192911+00 | partial
39 | git | 2018-09-03 15:06:38.546511+00 | 2018-09-03 15:06:38.546511+00 | partial
40 | git | 2018-09-04 12:23:40.650738+00 | 2018-09-04 12:23:40.650738+00 | partial
41 | git | 2018-09-06 02:19:17.356141+00 | 2018-09-06 02:19:17.356141+00 | partial
42 | git | 2018-09-06 10:10:08.899682+00 | 2018-09-06 10:10:08.899682+00 | partial
43 | git | 2018-09-06 21:11:07.165577+00 | 2018-09-06 21:11:07.165577+00 | partial
44 | git | 2018-09-08 03:31:34.120029+00 | 2018-09-08 03:31:34.120029+00 | partial
45 | git | 2018-09-10 13:16:18.957123+00 | 2018-09-10 13:16:18.957123+00 | partial
46 | git | 2018-09-11 12:02:16.17506+00 | 2018-09-11 12:02:16.17506+00 | partial
47 | git | 2018-09-16 16:54:42.910339+00 | 2018-09-16 16:54:42.910339+00 | partial
48 | git | 2018-09-17 12:23:51.366085+00 | 2018-09-17 12:23:51.366085+00 | partial
49 | git | 2018-09-18 04:47:14.854145+00 | 2018-09-18 04:47:14.854145+00 | partial
50 | git | 2018-09-19 00:12:34.633115+00 | 2018-09-19 00:12:34.633115+00 | partial
51 | git | 2018-09-20 02:33:52.76492+00 | 2018-09-20 02:33:52.76492+00 | partial
52 | git | 2018-09-20 20:15:56.698628+00 | 2018-09-20 20:15:56.698628+00 | full
53 | git | 2018-09-20 22:33:15.127139+00 | 2018-09-20 22:33:15.127139+00 | full
54 | git | 2018-09-21 20:54:47.156741+00 | 2018-09-21 20:54:47.156741+00 | partial
55 | git | 2018-09-23 11:50:31.266525+00 | 2018-09-23 11:50:31.266525+00 | full
56 | git | 2018-09-24 20:03:32.886445+00 | 2018-09-24 20:03:32.886445+00 | full
57 | git | 2018-09-25 02:58:03.443585+00 | 2018-09-25 02:58:03.443585+00 | full
58 | git | 2018-09-27 06:19:53.978236+00 | 2018-09-27 06:19:53.978236+00 | full
59 | git | 2018-09-28 17:11:37.081062+00 | 2018-09-28 17:11:37.081062+00 | partial
60 | git | 2018-09-29 21:57:24.418869+00 | 2018-09-29 21:57:24.418869+00 | full
61 | git | 2018-10-01 02:34:10.901134+00 | 2018-10-01 02:34:10.901134+00 | full
62 | git | 2018-10-01 05:43:27.134214+00 | 2018-10-01 05:43:27.134214+00 | full
63 | git | 2018-10-05 15:48:04.298225+00 | 2018-10-05 15:48:04.298225+00 | full
64 | git | 2018-10-08 12:47:47.275795+00 | 2018-10-08 12:47:47.275795+00 | full
65 | git | 2018-10-09 10:34:11.824382+00 | 2018-10-09 10:34:11.824382+00 | full
66 | git | 2018-10-09 20:48:50.328618+00 | 2018-10-09 20:48:50.328618+00 | full
67 | git | 2018-10-10 08:59:00.671019+00 | 2018-10-10 08:59:00.671019+00 | full
68 | git | 2018-10-11 23:58:43.850242+00 | 2018-10-11 23:58:43.850242+00 | full
69 | git | 2018-10-13 17:19:04.995245+00 | 2018-10-13 17:19:04.995245+00 | full