Updated Dr.'s Chronology From Television News OCR

We've updated our chronology of Dr.'s from the onscreen OCR'd text of television news that we first released last week. The latest list is updated through 48 hours ago.

Again, creating this list required just a single SQL query:

SELECT DATE(date) day, station, REGEXP_EXTRACT( LOWER(OCRText), r'\bdr[\.]* ([A-Za-z]+ [A-Za-z]+)') name, count(1) cnt FROM `gdelt-bq.gdeltv2.vgegv2_iatv` group by station, day, name having length(name) > 3 and cnt > 1 order by day asc, cnt desc

Download The List.