#fsdb -F t block id start duration uncertainty status a_short sites_up sites_observing observations - 220 1667260800 82800 0 2 - 11 13 ABCDeFGHiJKLM - 422 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 621 1667260800 82800 0 2 - 9 13 ABCDEfGhIjkLM - 699 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 889 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1035 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1069 1667260800 82800 0 2 - 11 13 ABCDeFGHiJKLM - 1082 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1237 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1277 1667260800 82800 0 2 - 8 13 AbCDEFGhijKlM - 1531 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 3514 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 3732 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 3766 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 3977 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 4371 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 4640 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 4712 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 4924 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 6043 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 6106 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 6248 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 6299 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKlM - 6402 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 6485 1667260800 82800 0 2 - 12 13 AbCDEFGHIJKLM - 6508 1667260800 82800 0 2 - 11 13 aBCDEFGHIjKLM - 6521 1667260800 82800 0 2 - 12 13 ABCDEFGHIJkLM - 6590 1667260800 82800 0 2 - 6 13 abCdEFgHijKlM - 6616 1667260800 82800 0 2 - 12 13 aBCDEFGHIJKLM - 6634 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 6647 1667260800 82800 0 2 - 12 13 aBCDEFGHIJKLM - 6649 1667260800 82800 0 2 - 10 13 abCDEFGhIJKLM - 6664 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 6692 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 6758 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 6783 1667260800 82800 0 2 - 9 13 AbCDEFghiJKLM - 6785 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 6804 1667260800 82800 0 2 - 6 13 abCDefGHIjKlm - 7009 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 7011 1667260800 82800 0 2 - 12 13 ABCDEFGHIJkLM - 7039 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 7138 1667260800 82800 0 2 - 11 13 ABCDEFGHijKLM - 10102 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 10124 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 10176 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 10243 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 11012 1667260800 82800 0 2 - 10 13 ABCDefGHIjKLM - 11471 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 11518 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 11623 1667260800 82800 0 2 - 11 13 ABCdeFGHIJKLM - 12344 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 12363 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 12413 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 12422 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 12437 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 12558 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 12712 1667260800 82800 0 2 - 10 13 aBCDEfGHIjKLM - 12794 1667260800 82800 0 2 - 7 13 ABcDefgHijKLM - 12985 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 13010 1667260800 82800 0 2 - 12 13 ABCDEFgHIJKLM - 13068 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKlM - 13808 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 14454 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 16212 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 16336 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 17875 1667260800 82800 0 2 - 12 13 aBCDEFGHIJKLM - 18066 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 18273 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 18325 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 18833 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 19019 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 19073 1667260800 82800 0 2 - 11 13 ABCDEfGHIjKLM - 19526 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 19971 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 20128 1667260800 82800 0 2 - 10 13 ABCDEfGHijKLM - 20252 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 20264 1667260800 82800 0 2 - 8 13 abcDEFghIJKLM - 20313 1667260800 82800 0 2 - 12 13 ABCDEFgHIJKLM - 21101 1667260800 82800 0 2 - 11 13 ABCDeFGHiJKLM - 21554 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 21610 1667260800 82800 0 2 - 11 13 ABCDEFGHijKLM - 21724 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 21795 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 23434 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 23473 1667260800 82800 0 2 - 6 13 abcDEFghiJKLm - 23581 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 24204 1667260800 82800 0 2 - 12 13 ABCDEFGHIJkLM - 24456 1667260800 82800 0 2 - 10 13 ABCDefGHIjKLM - 24472 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 24527 1667260800 82800 0 2 - 12 13 ABCDeFGHIJKLM - 25967 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 26183 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 26793 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 28364 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 28502 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 28694 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 29171 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 29683 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 30032 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 30259 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 30481 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 30612 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 31020 1667260800 82800 0 2 - 12 13 ABCDeFGHIJKLM - 31162 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 31346 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 31772 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 32030 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 32133 1667260800 82800 0 2 - 11 13 ABCdeFGHIJKLM - 32449 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 32505 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 33021 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 33095 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 33190 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 33343 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 33413 1667260800 82800 0 2 - 6 13 abcDEFghiJKLm - 33489 1667260800 82800 0 2 - 11 13 ABCdeFGHIJKLM - 33512 1667260800 82800 0 2 - 6 13 abcDEFghiJKLm - 33659 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 33783 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 33934 1667260800 82800 0 2 - 11 13 ABCdeFGHIJKLM - 34615 1667260800 82800 0 2 - 6 13 AbcdEfGhIjkLM - 50131 1667260800 82800 0 2 - 12 13 ABCDEFGHIJkLM - 50140 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 50617 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 50897 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 50904 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 51023 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51037 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 51301 1667260800 82800 0 2 - 11 13 ABCDEFGHijKLM - 51433 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51524 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51532 1667260800 82800 0 2 - 11 13 aBCDEFGHIjKLM - 51647 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51648 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 51959 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 52337 1667260800 82800 0 2 - 12 13 ABCDEFgHIJKLM - 52498 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 52559 1667260800 82800 0 2 - 9 13 aBCDEfGHIjKLm - 52790 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 52804 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 52969 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 53118 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 53197 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 53420 1667260800 82800 0 2 - 11 13 ABCdeFGHIJKLM - 54188 1667260800 82800 0 2 - 10 13 AbCDEFGhIJKlM - 54262 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 54325 1667260800 82800 0 2 - 11 13 ABCdeFGHIJKLM - 54402 1667260800 82800 0 2 - 11 13 ABCDEFGHIjkLM - 54540 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 54993 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 55683 1667260800 82800 0 2 - 11 13 ABCDEFGHIjkLM - 60023 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 60091 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 60173 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKlM - 1000070 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1000299 1667260800 82800 0 2 - 7 13 abcdEFgHIJKLm - 1000302 1667260800 82800 0 2 - 11 13 ABCDEFGhIJKlM - 1000666 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1000734 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1000979 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1001199 1667260800 82800 0 2 - 8 13 aBCdEFGHijKlM - 1001470 1667260800 82800 0 2 - 12 13 ABCDEFgHIJKLM - 1001863 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1001944 1667260800 82800 0 2 - 11 13 ABCDEFGHIjkLM - 1002067 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 1002306 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1002421 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1002673 1667260800 82800 0 2 - 11 13 ABCdeFGHIJKLM - 1002762 1667260800 82800 0 2 - 11 13 ABCDEFGHIjKlM - 1002952 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003116 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003334 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003336 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003498 1667260800 82800 0 2 - 12 13 AbCDEFGHIJKLM - 1003499 1667260800 82800 0 2 - 12 13 ABCDEFGHIJkLM - 1003619 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003620 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003621 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003622 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003623 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003624 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003625 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003626 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003627 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003628 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003629 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003630 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003631 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003632 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003633 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003649 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1003951 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 1003954 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 1003955 1667260800 82800 0 2 - 12 13 ABCdEFGHIJKLM - 1004006 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004045 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004050 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004196 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004208 1667260800 82800 0 2 - 11 13 ABCDEFGHijKLM - 1004443 1667260800 82800 0 2 - 11 13 ABCDEFGHijKLM - 1004568 1667260800 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004728 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 1004729 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 1004736 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1004741 1667260800 82800 0 2 - 12 13 ABCDEfGHIJKLM - 1004751 1667260800 82800 0 2 - 12 13 ABCDEFGHIJkLM - 1004851 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1004866 1667260800 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1004906 1667260800 82800 0 2 - 12 13 ABCDEFGHIJKLm # | dbcoldefine -F t id observations # | dbcolcreate block status a_short sites_up sites_observing -e 1667260800 start -e 82800 duration -e 0 uncertainty # | dbroweval '{ $_ = _observations; _sites_up = tr/A-Z//; _sites_observing = length(_observations); _status = (_sites_up == _sites_observing ? 1 : 2); }' # | dbcol block id start duration uncertainty status a_short sites_up sites_observing observations