There are way, way more inmates listed in the Cook County table of the same name than in the arrests table for the CPD. The timespan for the former is around 3.5 times longer, but the number of rows is nearly 10x as much; this seems strange since I would expect most Cook County cases to be CPD ones. What's going on here?
Also, the overwhelming majority of Cook County inmates seem to have no charges - the charges table, at least, has far fewer rows. By contrast, the same naive count would suggest that on average CPD arrests seem to have two charges per person. There must be different definitions going on here; what is the difference?
There are way, way more inmates listed in the Cook County table of the same name than in the arrests table for the CPD. The timespan for the former is around 3.5 times longer, but the number of rows is nearly 10x as much; this seems strange since I would expect most Cook County cases to be CPD ones. What's going on here?
Also, the overwhelming majority of Cook County inmates seem to have no charges - the charges table, at least, has far fewer rows. By contrast, the same naive count would suggest that on average CPD arrests seem to have two charges per person. There must be different definitions going on here; what is the difference?