We need SQL access to that database: select state, count(*) from vessel_registration group by 1 order by 1;
Sorry, couldn’t help myself :) Cheers, Randy > On Feb 1, 2018, at 9:36 AM, Frederick G Street via CnC-List > <cnc-list@cnc-list.com> wrote: > > Bill — just for grins, I sent off an inquiry to the National Vessel > Documentation Center asking if it was possible to tell me how many documented > vessels were in a particular state. I received the following reply: > >>> This is in response to your e-mail dated January 26, 2018 asking question >>> concerning the National Vessel Documentation Center's database. >>> >>> The National Vessel Documentation Center is unable to search for vessels by >>> state. We search by Coast Guard official number, hull number and/or owner >>> name. > > As I’m sure they have a “real” database with all of this info, this just > means they aren’t interested in doing it… > > — Fred > > Fred Street -- Minneapolis > S/V Oceanis (1979 C&C Landfall 38) -- on the hard in Bayfield, WI :^( > >> On Jan 26, 2018, at 9:00 AM, coltrek via CnC-List <cnc-list@cnc-list.com >> <mailto:cnc-list@cnc-list.com>> wrote: >> >> I'll bet you can count the number of documented vessels in Colorado on one >> hand ! >> >> >> Bill > > _______________________________________________ > > Thanks everyone for supporting this list with your contributions. Each and > every one is greatly appreciated. If you want to support the list - use > PayPal to send contribution -- https://www.paypal.me/stumurray >
_______________________________________________ Thanks everyone for supporting this list with your contributions. Each and every one is greatly appreciated. If you want to support the list - use PayPal to send contribution -- https://www.paypal.me/stumurray
