Category Archives: Computers

My set of quick research bookmarks

One of the topics that came up during the Civil Beat panel discussion of corruption is how we do our work as investigative reporters. By “work”, I’m not necessarily speaking of paid employment. Work is something done seriously, with focus, whether for pay or as an uncompensated activity. A “hobby,” if you will. I’m mostly retired in the paid-employment sense, but still work hard in that other sense of using my experience and skills to work on issues of import.

Along those lines, I decided to share the bookmarks I’ve collected to search for public records I use daily when digging into a story or just working around the fringes trying to get a better sense of whether there is a story.

I have these set up in a separate bookmark folder in my browser for quick access. It’s not an exhaustive list of resources. It’s a starter kit of useful links, you could say.

If you’ve got other suggestions, please share them.

They aren’t in any particular order, just where they landed as I gathered them in one place.

I’ll just walk through the list from the top.

• Judiciary opinions. This goes to a list of appellate decisions in Hawaii state courts. It is often a source of detailed information about people and situations that is unavailable elsewhere.

• Hawaii Business Express. This is the business search via the Business Registration Division of the Department of Commerce and Consumer Affairs. If you’re looking for info on a business, this is one place to start. You can learn when a business was first registered, its current status, past business filings (name changes, trademarks, change of officers, etc). Searching and basic information is free, and you can also download documents for a fee of $1 per page.

• eCourt Documents. This is a link to the Judiciary Electronic Filing and Service System. It’s used to access dockets of most state court cases and to download copies of documents, again for a fee. I have a subscription which allows unlimited downloads, and make heavy use of it when digging into a story.

• Hawaii Information Service. This is subscription service which maintains a computer database of public records. Although primarily used by realtors for tracking real property records, it also includes value-added searches of state business registration and professional/vocational licensing. You can do searches here that can’t be done on the free public systems. Expensive, but worth every cent. I don’t remember when I first subscribed. It was a real splurge, but I’ve never once regretted it. A goldmine for reporters, investigators, lawyers, as well as realtors.

• Hawaii Legal Research. A useful compilation of links used in legal research, current and historical. When I’m kind of stuck, I’ll browse these links for ideas of how to proceed.

• Conveyances. This links to the basic search at the Bureau of Conveyances. If you are researching a person or business, you can check for mortgages and other secured loans, liens, trace real property ownership and transfers, judgements, etc. Again, copies of documents are available for a fee. Under normal non-Covid circumstances, you can go to the bureau and inspect documents without any fee.

• iLind.net Log-in. A quick link when I’m updating something on my own WordPress blog.

• Professional and Vocational Licensing. This is a free search through individuals and businesses with licenses issued by the state. Everything from contractors and electricians to vehicle salespersons and massage therapists. You’ll have to look up the list of license categories.

• Complaints. Search consumer complaints against licensed individuals and businesses filed with the state’s Regulated Industries Complaints Office.

• Honolulu Advertiser–Search the for stories appearing in the former Advertiser before its merger with the Honolulu Star-Bulletin in 2010. This search is via Newspapers.com.

• Pacific Business News. I subscribe to PBN for their current business news, but also for their excellent searchable archive of past stories.

• Campaign Spending Commission. Go to the source for information on candidates and noncandidate committees (businesses, unions, and political action committees), campaign contributions, etc.

• RECAP. An add-on utility (I use it with Firefox) for searching the PACER system of federal court records. When a RECAP user pays to download a file, a copy is automatically uploaded to RECAP and is then available for free for subsequent users. It often can save you real money when researching a case.

• HPD Arrest Logs. I just recently added this link. It’s raw data, but I’ve made good use of it so far.

• Newspapers.com. Worth every penny of the annual subscription fee.

Comments “down,” troubleshooting later today

Thanks to those of you who alerted me to the problem with the “comments” function that cropped up in the past day or so.

I don’t know exactly what the problem is, but I know how it happened.

Last week, I was notified that the site was plastered with SEO spam, hidden links that were invisible to me, but that boosted the Google rankings of other referenced sites, mostly with, well, less than savory subjects.

At one point, my hosting service was ready to suspend my account if I didn’t get the site cleaned up. I spent several days between tech support at my hosting service and techies at the separate company that manages the firewall for the site. Eventually the site came up clean.

But there were additional instructions. Make sure WordPress and plug-ins are up to date. Okay. I updated WordPress to the latest version, then turned to plug-ins. I ditched unused plug-ins, updated those that were activated.

Somewhere among those changes I managed to do something that is blocking comments from displaying properly.

So far, the comments still exist. When I sign in as site administrator, the comments are visible to me. But although individual posts have a note saying how many comments have been submitted, but they aren’t displaying properly.

Hey, if there are any gurus who recognize this problem and how to solve it on self-hosted WordPress sites, any advice or suggestions would be appreciated. Otherwise, I’ll be searching online hoping to find the magic solution.

I hate what the last WordPress update did to its blog editor

This is aimed at those of you who do some blogging of your own.

Why, or why, did WordPress suddenly revamp the whole look and feel of its editing mode in the last software update?

I have enough trouble finding time to keep this blog active, and I just don’t have the available time or interest in figuring out just how to find and use all the basics, much less any bells and whistles, in the latest WordPress incarnation.

Am I alone in this?

My on-the-fly solution has been to return to using MarsEdit, a nice little bit of software that I had set aside a couple of years ago. Their latest version has been updated but feels very familiar and comfortable. I wish I could say the same for WP.

If you’re interested: MarsEdit by Red Sweater Software.

Spam, spam, spam, and spam!

Several days ago, I received alerts from the hosting service I use for this blog, and from Sucuri.net, a second service that provides a separate level of security. I signed with with that service several years ago when this site was overwhelmed by one or more hackers and forced offline for several days.

In any case, I was warned that SEO spam had been found in certain files and I needed to take action to clean up the site.

To tell the truth, I was working on something else and repressed the job. Until this morning, that is, when I got a followup from my hosting service advising they would suspend my account in 48-hours if I failed to take care of the problem.

It didn’t help that when I ran Google’s Transparency Report, it didn’t find any problems. That encouraged me to procrastinate.

Well, the next problem was that I had no idea what needed to be done. And then, to compound the problem, I provided the wrong password to Sucuri, making it impossible for them to initiate a malware removal scan.

Finally I managed to contact both services and request their assistance, and managed to locate and provide the correct password.

It wasn’t long before I heard back from Hostrocket, my hosting service. The identified a few spammy files that had been deleted, and a few more outdated plug-ins that needed to be deleted.

Then I got a report from Sucuri. They reported identifying and clearing literally hundreds of hidden spam links tucked away in out of the way places invisible to me.

You’ll can easily look up and read about SEO spam, as it is apparently a widespread problem, especially with WordPress installations like this one. Here’s the brief Sucuri summary of the issue.

So…I’m sorry for whatever affects these bits of malware may have been causing to those who visited this blog. Hopefully now everything has been rendered spic and span, and all of my layers of security have been updated. Maybe it will make things run faster. We’ll see.