search

wpinvestigative / arcos

https://wpinvestigative.github.io/arcos/
Other
30 stars 18 forks source link

Missing BUYER_COUNTY #13

Open imusse opened 3 years ago

imusse commented 3 years ago

A few BUYER_COUNTY fields are missing in the 2014 data. Is there a reason for this?

For example, for BUYER_DEA_NO==B99328647, BUYER_ADDRESS2=="175 WEST RD", BUYER_CITY=="ELLINGTON", BUYER_STATE=="CT", BUYER_ZIP=="6209", BUYER_COUNTY==NA. After searching a little, we can see that this buyer is located at Ellington, in Tolland county, CT.

At the WaPo page, the total number of pills for Tolland county is 27,024,214, which matches the result in the database excluding the counties with missing BUYER_COUNTY. If we correct them by hand, the total number of pills in Tolland, CT, should be higher. At the state level, the total does not consider these cities with missing counties, either.

Thanks!

accessarcos commented 3 years ago

I know there are missing counties for independent cities, but none of those are in CT. You have to remember that WaPo is simply providing the information that the DEA gave them and is not correcting it. There are lots of issues with the ARCOS which I hope to address in the coming year. If you happen to find more of the, please post them here or to my Github page.