#fsdb -F t block id start duration uncertainty status a_short sites_up sites_observing observations - 220 1667865600 82800 0 2 - 11 13 ABCDeFGHiJKLM - 422 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 621 1667865600 82800 0 2 - 9 13 ABCDEfGhIjkLM - 681 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 699 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 746 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 889 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1035 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1069 1667865600 82800 0 2 - 11 13 ABCDeFGHiJKLM - 1082 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1237 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1277 1667865600 82800 0 2 - 8 13 AbCDEFGhijKlM - 1531 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 3514 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 3732 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 3766 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 3798 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 3977 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 4371 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 4640 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 4712 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 6106 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 6248 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 6299 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKlM - 6402 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 6485 1667865600 82800 0 2 - 12 13 AbCDEFGHIJKLM - 6508 1667865600 82800 0 2 - 11 13 aBCDEFGHIjKLM - 6590 1667865600 82800 0 2 - 6 13 abCdEFgHijKlM - 6616 1667865600 82800 0 2 - 12 13 aBCDEFGHIJKLM - 6634 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 6647 1667865600 82800 0 2 - 12 13 aBCDEFGHIJKLM - 6649 1667865600 82800 0 2 - 11 13 AbCDEFGhIJKLM - 6664 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 6692 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 6785 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 6794 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 7009 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 7011 1667865600 82800 0 2 - 12 13 ABCDEFGHIJkLM - 7138 1667865600 82800 0 2 - 11 13 ABCDEFGHijKLM - 10102 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 10124 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 10176 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 10977 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 11012 1667865600 82800 0 2 - 10 13 ABCDefGHIjKLM - 11471 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 11518 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 11623 1667865600 82800 0 2 - 11 13 ABCdeFGHIJKLM - 12344 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 12363 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 12413 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 12422 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 12437 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 12558 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 12602 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 12794 1667865600 82800 0 2 - 7 13 ABcDefgHijKLM - 12985 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 13010 1667865600 82800 0 2 - 12 13 ABCDEFgHIJKLM - 13068 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKlM - 13084 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 13808 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 14454 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 16212 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 16336 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 17875 1667865600 82800 0 2 - 12 13 aBCDEFGHIJKLM - 18066 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 18273 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 18325 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 18550 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 19073 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 19971 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 20128 1667865600 82800 0 2 - 10 13 ABCDEfGHijKLM - 20252 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 20264 1667865600 82800 0 2 - 8 13 abcDEFghIJKLM - 20313 1667865600 82800 0 2 - 12 13 ABCDEFgHIJKLM - 20777 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 21101 1667865600 82800 0 2 - 11 13 ABCDeFGHiJKLM - 21610 1667865600 82800 0 2 - 11 13 ABCDEFGHijKLM - 21724 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 21795 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 23223 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 23434 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 23473 1667865600 82800 0 2 - 6 13 abcDEFghiJKLm - 24204 1667865600 82800 0 2 - 12 13 ABCDEFGHIJkLM - 24456 1667865600 82800 0 2 - 10 13 ABCDefGHIjKLM - 24472 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 24527 1667865600 82800 0 2 - 12 13 ABCDeFGHIJKLM - 25967 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 26183 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 26793 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 27989 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 28364 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 28502 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 28694 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 29683 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 30032 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 30259 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 30481 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 30612 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 31020 1667865600 82800 0 2 - 12 13 ABCDeFGHIJKLM - 31162 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 32030 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 32293 1667865600 82800 0 2 - 11 13 abCDEFGHIJKLM - 32449 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 32505 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 33021 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 33095 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 33190 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 33343 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 33413 1667865600 82800 0 2 - 6 13 abcDEFghiJKLm - 33512 1667865600 82800 0 2 - 6 13 abcDEFghiJKLm - 33659 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 34615 1667865600 82800 0 2 - 6 13 AbcdEfGhIjkLM - 35445 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 35715 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 50131 1667865600 82800 0 2 - 12 13 ABCDEFGHIJkLM - 50140 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 50183 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 50617 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 50897 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 50904 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 51023 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51037 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 51301 1667865600 82800 0 2 - 11 13 ABCDEFGHijKLM - 51433 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51521 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51524 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51532 1667865600 82800 0 2 - 11 13 aBCDEFGHIjKLM - 51647 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 51648 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 51959 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 52076 1667865600 82800 0 2 - 9 13 ABCdeFGHijKLM - 52337 1667865600 82800 0 2 - 12 13 ABCDEFgHIJKLM - 52498 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 52559 1667865600 82800 0 2 - 9 13 aBCDEfGHIjKLm - 52790 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 52969 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 53091 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 53118 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 53590 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 53916 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 54188 1667865600 82800 0 2 - 10 13 AbCDEFGhIJKlM - 54262 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 54325 1667865600 82800 0 2 - 11 13 ABCdeFGHIJKLM - 54402 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 54540 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 54993 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 55489 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 55683 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 60023 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 60091 1667865600 82800 0 2 - 12 13 ABCDEfGHIJKLM - 60173 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKlM - 61264 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 63045 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1000299 1667865600 82800 0 2 - 7 13 AbcdEFgHIjKLm - 1000302 1667865600 82800 0 2 - 11 13 ABCDEFGhIJKlM - 1000486 1667865600 82800 0 2 - 10 13 AbCDEFGHiJkLM - 1000666 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1000734 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1001199 1667865600 82800 0 2 - 8 13 aBCdEFGHijKlM - 1001470 1667865600 82800 0 2 - 12 13 ABCDEFgHIJKLM - 1001863 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1001944 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1002067 1667865600 82800 0 2 - 12 13 ABCdEFGHIJKLM - 1002306 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1002317 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1002421 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1002588 1667865600 82800 0 2 - 10 13 ABCDeFghIJKLM - 1002673 1667865600 82800 0 2 - 11 13 ABCdeFGHIJKLM - 1002726 1667865600 82800 0 2 - 12 13 ABCDEFGHIJkLM - 1002802 1667865600 82800 0 2 - 2 13 abcdefghIJklm - 1002906 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003334 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003336 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003498 1667865600 82800 0 2 - 12 13 AbCDEFGHIJKLM - 1003619 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003620 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003621 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003622 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003623 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003624 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003625 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003626 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003627 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003628 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003629 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003630 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003631 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003632 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003633 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1003951 1667865600 82800 0 2 - 11 13 ABCdEFGHIjKLM - 1003954 1667865600 82800 0 2 - 11 13 ABCdEFGHIjKLM - 1003955 1667865600 82800 0 2 - 11 13 ABCdEFGHIjKLM - 1004006 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004045 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004050 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004208 1667865600 82800 0 2 - 11 13 ABCDEFGHijKLM - 1004443 1667865600 82800 0 2 - 11 13 ABCDEFGHijKLM - 1004663 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004685 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM - 1004736 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1004851 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1004866 1667865600 82800 0 2 - 12 13 ABCDEFGHiJKLM - 1004906 1667865600 82800 0 2 - 12 13 ABCDEFGHIJKLm - 1004945 1667865600 82800 0 2 - 12 13 ABCDEFGHIjKLM # | dbcoldefine -F t id observations # | dbcolcreate block status a_short sites_up sites_observing -e 1667865600 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