mjhjmtu

I have 3 comma separated quoted fields.

last crawled,linking page,domain
"Nov 17, 2018","https://allestoringen.be/problemen/bwin/antwerpen","allestoringen.be"
"Aug 11, 2017","http://casino.linkplek.be/","linkplek.be"
"Nov 17, 2018","http://pronoroll.blogspot.com/p/blog-page_26.html","pronoroll.blogspot.com"
etc

I need to remove duplicates on the date fields and find the count of unique linking pages for each unique date (column $2) and count of unique domains for the unique date (column $3). I have tried :

awk 'A[$1 OFS $2]++ END for(k in A) print k, A[k]' FPAT='([^,]*)|("[^"]+")' file
awk 'A[$1 OFS $3]++ END for(k in A) print k, A[k]' FPAT='([^,]*)|("[^"]+")' file

But I am a little confused on getting all 3 columns in a single go.

# script.awk

BEGIN 
 FPAT = "[^"]+"



 # the first if is to avoid processing title row and rows that do not contain fields
 if (NF > 1) 
 # the third field is the linking page column; the second field is a comma
 if ($3 != "" && $1 $3 in unique_linking_pages == 0) 
 unique_linking_pages[$1 $3]
 unique_linking_page_counts[$1]++
 
 # the fifth field is the domain column; the fourth field is a comma
 if ($5 != "" && $1 $5 in unique_domains == 0) 
 unique_domains[$1 $5]
 unique_domain_counts[$1]++
 

 # in case of empty fields in columns 2 and or 3 of the input file,
 # this ensures that all the dates are recorded
 dates[$1]
 


END " unique_linking_page_counts[date] "