Spreadsheet: 130841d1322612654-adding-zeros-when-not-found-bird_example
Sheet: Example data

 | location | date | 4-letter SPECIES code | number of individuals
 | 33 | 2011-05-15 00:00:00 | BTNW | 1
 | 33 | 2011-05-15 00:00:00 | YWAR | 1
 | 33 | 2011-05-15 00:00:00 | NOCA | 1
 | 33 | 2011-05-15 00:00:00 | WOTH | 1
 | 33 | 2011-05-15 00:00:00 | BBWA | 1
 | 33 | 2011-05-15 00:00:00 | HOWR | 1
 | 33 | 2011-05-15 00:00:00 | MAWA | 1
 | 33 | 2011-05-15 00:00:00 | COYE | 1
 | 33 | 2011-05-15 00:00:00 | OVEN | 1
 | 33 | 2011-05-15 00:00:00 | RWBL | 6
 | 33 | 2011-05-15 00:00:00 | YWAR | 1
 | 33 | 2011-05-15 00:00:00 | BAOR | 1
 | 33 | 2011-05-15 00:00:00 | YWAR | 1
 | 33 | 2011-05-15 00:00:00 | BGGN | 1
 | 33 | 2011-05-15 00:00:00 | EAWP | 1
 | 33 | 2011-05-15 00:00:00 | BAWW | 1
 | 33 | 2011-05-15 00:00:00 | BTBW | 1
 | 33 | 2011-05-15 00:00:00 | TEWA | 1
 | 33 | 2011-05-04 00:00:00 | YWAR | 1
 | 33 | 2011-05-04 00:00:00 | YWAR | 1
 | 33 | 2011-05-04 00:00:00 | BGGN | 1
 | 33 | 2011-05-04 00:00:00 | HOWR | 1
 | 33 | 2011-05-04 00:00:00 | YWAR | 1
 | 33 | 2011-05-04 00:00:00 | BAEA | 1
 | 33 | 2011-05-04 00:00:00 | NOCA | 1
 | 33 | 2011-05-04 00:00:00 | DOWO | 1
 | 33 | 2011-05-04 00:00:00 | COGR | 8
 | 33 | 2011-05-04 00:00:00 | EUST | 6
 | 33 | 2011-05-04 00:00:00 | NOCA | 1
 | 33 | 2011-05-04 00:00:00 | RWBL | 10
 | 33 | 2011-05-04 00:00:00 | AMRO | 1
 | 33 | 2011-05-04 00:00:00 | NOCA | 1
 | 33 | 2011-05-04 00:00:00 | BLJA | 1
 | 33 | 2011-05-04 00:00:00 | WTSP | 3
 | 33 | 2011-05-07 00:00:00 | YWAR | 1
 | 33 | 2011-05-07 00:00:00 | YWAR | 1
 | 33 | 2011-05-07 00:00:00 | YWAR | 1
 | 33 | 2011-05-07 00:00:00 | WAVI | 1
 | 33 | 2011-05-07 00:00:00 | RCKI | 1
 | 33 | 2011-05-07 00:00:00 | HOWR | 1
 | 33 | 2011-05-07 00:00:00 | BAOR | 1
 | 33 | 2011-05-07 00:00:00 | GRCA | 1
 | 33 | 2011-05-07 00:00:00 | MYWA | 5
 | 33 | 2011-05-07 00:00:00 | PAWA | 1
 | 33 | 2011-05-07 00:00:00 | NOPA | 1
 | 33 | 2011-05-07 00:00:00 | NOCA | 1
 | 33 | 2011-05-07 00:00:00 | BAOR | 1
 | 33 | 2011-05-07 00:00:00 | BLJA | 3
 | 33 | 2011-05-07 00:00:00 | MYWA | 1
 | 33 | 2011-05-07 00:00:00 | BAWW | 1
 | 33 | 2011-05-07 00:00:00 | WTSP | 1
 | 33 | 2011-05-07 00:00:00 | COYE | 1
 | 33 | 2011-05-07 00:00:00 | RBWO | 1
 | 33 | 2011-05-07 00:00:00 | MYWA | 1
 | 33 | 2011-05-07 00:00:00 | BAOR | 2
 | 33 | 2011-05-07 00:00:00 | DCCO | 7
 | 33 | 2011-05-07 00:00:00 | RWBL | 10
 | 33 | 2011-05-07 00:00:00 | COGR | 8
 | 33 | 2011-05-07 00:00:00 | WTSP | 1
 | 119 | 2011-04-24 00:00:00 | AMRO | 1
 | 119 | 2011-04-24 00:00:00 | AMRO | 1
 | 119 | 2011-04-24 00:00:00 | NOCA | 1
 | 119 | 2011-04-24 00:00:00 | NOFL | 1
 | 119 | 2011-04-24 00:00:00 | AMRO | 1
 | 119 | 2011-04-24 00:00:00 | RBWO | 1
 | 119 | 2011-04-24 00:00:00 | AMGO | 1
 | 119 | 2011-04-24 00:00:00 | BGGN | 1
 | 119 | 2011-04-24 00:00:00 | BLJA | 1
 | 119 | 2011-04-24 00:00:00 | BLJA | 4
 | 119 | 2011-04-24 00:00:00 | WTSP | 1
 | 119 | 2011-04-24 00:00:00 | GBHE | 2
 | 119 | 2011-04-24 00:00:00 | WODU | 1
 | 119 | 2011-04-24 00:00:00 | RBWO | 1
 | 119 | 2011-04-24 00:00:00 | MODO | 1
 | 119 | 2011-04-24 00:00:00 | BGGN | 1
 | 119 | 2011-04-24 00:00:00 | AMRO | 1
 | 119 | 2011-04-24 00:00:00 | RWBL | 23
 | 119 | 2011-04-24 00:00:00 | TUTI | 1
 | 119 | 2011-04-24 00:00:00 | DCCO | 1
 | 119 | 2011-04-24 00:00:00 | RWBL | 3
 | 119 | 2011-04-24 00:00:00 | DOWO | 1
 | 119 | 2011-04-24 00:00:00 | NOCA | 1
 | 119 | 2011-04-24 00:00:00 | BCCH | 1
 | 119 | 2011-04-24 00:00:00 | BRTH | 1
 | 119 | 2011-04-29 00:00:00 | BAWW | 1
 | 119 | 2011-04-29 00:00:00 | MYWA | 6
 | 119 | 2011-04-29 00:00:00 | DOWO | 2
 | 119 | 2011-04-29 00:00:00 | BGGN | 1
 | 119 | 2011-04-29 00:00:00 | BLJA | 4
 | 119 | 2011-04-29 00:00:00 | BGGN | 1
 | 119 | 2011-04-29 00:00:00 | TUTI | 2
 | 119 | 2011-04-29 00:00:00 | WBNU | 1
 | 119 | 2011-04-29 00:00:00 | PAWA | 2
 | 119 | 2011-04-29 00:00:00 | TUVU | 1
 | 119 | 2011-04-29 00:00:00 | RTHA | 1
 | 119 | 2011-04-29 00:00:00 | MYWA | 2
 | 119 | 2011-04-29 00:00:00 | AMRO | 1
 | 119 | 2011-04-29 00:00:00 | NOCA | 1
 | 119 | 2011-05-06 00:00:00 | MYWA | 1
 | 119 | 2011-05-06 00:00:00 | BLJA | 1
 | 119 | 2011-05-06 00:00:00 | BLJA | 8
 | 119 | 2011-05-06 00:00:00 | BLJA | 1
 | 119 | 2011-05-06 00:00:00 | TUTI | 1
 | 119 | 2011-05-06 00:00:00 | BGGN | 1
 | 119 | 2011-05-06 00:00:00 | GRCA | 1
 | 119 | 2011-05-06 00:00:00 | AMGO | 1
 | 119 | 2011-05-06 00:00:00 | RBWO | 1
 | 119 | 2011-05-06 00:00:00 | DOWO | 1
 | 119 | 2011-05-06 00:00:00 | NOCA | 1
 | 119 | 2011-05-06 00:00:00 | MYWA | 1
 | 119 | 2011-05-06 00:00:00 | BTNW | 1
 | 119 | 2011-05-06 00:00:00 | BAOR | 1
 | 119 | 2011-05-06 00:00:00 | BAOR | 1
 | 119 | 2011-05-06 00:00:00 | BCCH | 1
 | 119 | 2011-05-06 00:00:00 | NOCA | 1
 | 119 | 2011-05-06 00:00:00 | CHSW | 2
 | 119 | 2011-05-06 00:00:00 | MYWA | 1
 | 119 | 2011-05-06 00:00:00 | HOWR | 1
 | 119 | 2011-05-06 00:00:00 | BLBW | 1
 | 119 | 2011-05-06 00:00:00 | BTNW | 1