ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Based on PodcastIndex data from 6 Jun
SELECT lastUpdate FROM podcasts ORDER BY lastUpdate DESC limit 1
2
3
How many podcasts on each host only have one episode?
select count(*) AS totalcount,host from podcasts WHERE episodeCount=1 GROUP BY host ORDER BY totalcount DESC LIMIT 20
4
5
692549shows onanchor.fmhave just one episode: which is43%of their1618312shows
select count(*) AS totalhostcount, host from podcasts GROUP BY host ORDER BY totalhostcount DESC
6
454111shows onspreaker.comhave just one episode: which is49%of their918346shows
7
125874shows onivoox.comhave just one episode: which is45%of their280911shows
8
26663shows oncastbox.fmhave just one episode: which is54%of their49651shows
9
16742shows onafr.nethave just one episode: which is93%of their18003shows
10
16353shows onrss.comhave just one episode: which is57%of their28559shows
11
16304shows onsoundcloud.comhave just one episode: which is12%of their134067shows
12
11482shows onsms.cam.ac.ukhave just one episode: which is94%of their12266shows
13
9637shows onpodomatic.comhave just one episode: which is19%of their50096shows
14
6581shows onbuzzsprout.comhave just one episode: which is6%of their105936shows
15
6328shows onpodbean.comhave just one episode: which is8%of their79303shows
16
5237shows onpodcastmachine.comhave just one episode: which is67%of their7764shows
17
4824shows onfeedburner.comhave just one episode: which is9%of their55998shows
18
4183shows onislamhouse.comhave just one episode: which is79%of their5315shows
19
2837shows onpodcasts.comhave just one episode: which is41%of their6859shows
20
2694shows onpodster.fmhave just one episode: which is45%of their6020shows
21
2385shows ontalkshoe.comhave just one episode: which is40%of their5985shows
22
2065shows ongetkhabri.comhave just one episode: which is28%of their7337shows
23
1810shows onradio4all.nethave just one episode: which is87%of their2078shows
24
1495shows onradiofrance-podcast.nethave just one episode: which is34%of their4383shows
25
26
How many podcasts on each host have been updated in the last 90 days
27
select count(*) FROM podcasts
28
761332shows onall platformswere updated in the last 90 days19%of the3929127shows
select count(*) FROM podcasts WHERE newestItemPubdate>1615197600
29
315200shows onanchor.fmwere updated in the last 90 days19%of their1618312shows
select count(*) AS totalcount,host from podcasts WHERE newestItemPubdate>1615197600 GROUP BY host ORDER BY totalcount DESC LIMIT 20
30
95182shows onspreaker.comwere updated in the last 90 days10%of their918346shows
31
59257shows onbuzzsprout.comwere updated in the last 90 days56%of their105936shows
32
31022shows onlibsyn.comwere updated in the last 90 days48%of their64846shows
33
30967shows onpodbean.comwere updated in the last 90 days39%of their79303shows
34
27769shows onsoundcloud.comwere updated in the last 90 days21%of their134067shows
35
15594shows onivoox.comwere updated in the last 90 days6%of their280911shows
36
15090shows onrss.comwere updated in the last 90 days53%of their28559shows
37
9102shows onfeedburner.comwere updated in the last 90 days16%of their55998shows
38
7737shows onsimplecast.comwere updated in the last 90 days53%of their14548shows
39
5451shows oncaptivate.fmwere updated in the last 90 days60%of their9074shows
40
5367shows onacast.comwere updated in the last 90 days50%of their10727shows
41
5364shows onpodigee.iowere updated in the last 90 days59%of their9019shows
42
5295shows onomnycontent.comwere updated in the last 90 days54%of their9794shows
43
5191shows ontransistor.fmwere updated in the last 90 days51%of their10238shows
44
4224shows onmegaphone.fmwere updated in the last 90 days63%of their6725shows
45
3431shows onpodomatic.comwere updated in the last 90 days7%of their50096shows
46
3073shows onaudioboom.comwere updated in the last 90 days30%of their10300shows
47
3056shows onredcircle.comwere updated in the last 90 days53%of their5755shows
48
2525shows onausha.cowere updated in the last 90 days57%of their4438shows
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100