The calculated distance (air line) between Brooklyn and Columbia is approximately 181 miles respectively 292 kilometers.
By car or train, the actual journey to Columbia is certainly longer, as only the direct route (as the crow flies) between Brooklyn and Columbia has been calculated here.