Tool for those considering school and/or practice in CA

(Rankings, Profiles, Tuition, Student Life, . . . )
User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Tool for those considering school and/or practice in CA

Postby csc2law » Fri Feb 27, 2009 2:16 am

Hi everybody.

If you've ever looked at the California Bar Association's Attorney Search feature, you know that it is surprisingly useful. You can find info on current and former Bar members, including where they work(ed), where they went to school, etc. But only on an individual basis.

I was inspired to build another tool (anybody using the automated status checker?) that could glean some interesting information from all that data.

If you are at all considering school and/or practice in CA, feel free to check it out at http://californiabar.globl.org/

Among other things, you can do different types of searches that can't be done on the Bar site (e.g. by law school or undergrad), and also generate reports on things like:


There are also general statistics available (e.g. most-represented schools), and a manual search engine. So if you want to, say, look up people who went to your undergrad school and your prospective law schools, you can: e.g. http://californiabar.globl.org/results.php?lawschool=ucla&undergrad=polytechnic

Hopefully the site can withstand use by the many TLSers out there. I figured it might be useful to you. If it gets a lot of use, please be prepared to wait a few seconds for things to show up. I might be able to improve performance if things get hairy.

By the way, I'm still pulling data from the Bar site, and will be doing so for the next few weeks. So keep in mind that it's an incomplete data set. It should be fairly representative at this point (>10,000 members), but do be aware of that.

Also, let me know if you experience any problems/bugs with it, or have suggestions for improvement.

-csc2law

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Sat Feb 28, 2009 4:28 am

More info and updates over in this thread ...

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Tue Mar 03, 2009 4:21 am

Over 35,000 Bar members added now.

If you're interested in working with a specific organization, it's pretty easy to tell whether your potential school(s) have a presence. Among other things.

Anybody have ideas for other stats/reports to generate from this stuff?
http://californiabar.globl.org/

Danteshek
Posts: 2172
Joined: Wed Dec 10, 2008 4:40 pm

Re: Tool for those considering school and/or practice in CA

Postby Danteshek » Tue Mar 03, 2009 6:19 am

csc2law wrote:Over 35,000 Bar members added now.

If you're interested in working with a specific organization, it's pretty easy to tell whether your potential school(s) have a presence. Among other things.

Anybody have ideas for other stats/reports to generate from this stuff?
http://californiabar.globl.org/



What % of the total population of lawyers in CA is represented in this DB? Very useful btw...

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Tue Mar 03, 2009 12:33 pm

What % of the total population of lawyers in CA is represented in this DB? Very useful btw...


Thanks. Good point. I added a note on the General Statistics report that indicates what percentage of the total Bar database has been added so far. As it stands right now, it's about 1/4 done. It should be (at least temporarily) complete within ten days or so.

There are over 160,000 members of the CA Bar! Wow.

-csc2law

Danteshek
Posts: 2172
Joined: Wed Dec 10, 2008 4:40 pm

Re: Tool for those considering school and/or practice in CA

Postby Danteshek » Tue Mar 03, 2009 4:47 pm

csc2law wrote:
What % of the total population of lawyers in CA is represented in this DB? Very useful btw...


Thanks. Good point. I added a note on the General Statistics report that indicates what percentage of the total Bar database has been added so far. As it stands right now, it's about 1/4 done. It should be (at least temporarily) complete within ten days or so.

There are over 160,000 members of the CA Bar! Wow.

-csc2law



You know what would be cool? If you could enter a law school and see a graph with different colorings by county to indicate concentration of alums. Of course the raw data is the first step. But that might be your version 2.0.

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Wed Mar 04, 2009 3:54 pm

Yeah, good idea.

All right, so version 2 has a custom report generator with the ability to display pie charts: For example, Counties per Law school.

Will post more info about it later.

:D

Danteshek
Posts: 2172
Joined: Wed Dec 10, 2008 4:40 pm

Re: Tool for those considering school and/or practice in CA

Postby Danteshek » Wed Mar 04, 2009 4:32 pm

csc2law wrote:Yeah, good idea.

All right, so version 2 has a custom report generator with the ability to display pie charts: For example, Counties per Law school.

Will post more info about it later.

:D



Also, it would be nice if the state/school map had click through capability, so you see a list of attorneys in that county. Next step would be to have a drop down menu of all the employers that employ graduates of that school. The main thing here is to have a "sole practitioner" category or something like that so that there aren't a gazillion employers per county.

The graph looks good but I was thinking more along the lines of a map.

It also might be useful to have out of state data...

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Wed Mar 04, 2009 5:44 pm

Also, it would be nice if the state/school map had click through capability, so you see a list of attorneys in that county.


Google's charting API doesn't allow linking from the chart segments, but the links in the list underneath each chart do what you're talking about.

Next step would be to have a drop down menu of all the employers that employ graduates of that school. The main thing here is to have a "sole practitioner" category or something like that so that there aren't a gazillion employers per county.


Not much I can do there, given the limitations of the Bar Association's database. Solo lawyers are sometimes listed as "Attorney at Law", sometimes they have some business name based on their actual name, and often just their street address is listed. I suppose that kind of match could be grouped in as an "other" category, but it would be pretty fuzzy. There seem to be a number of errors/inconsistencies in the Bar's data, and I have a suspicion that relying on implied rather than explicit information would magnify those a bit too much.

The graph looks good but I was thinking more along the lines of a map.


Ack. Too much work. :)

It also might be useful to have out of state data...


The Bar database doesn't track county data for out-of-state addresses (they're all marked 'Non-California'), but out-of-state cities do show up all right, e.g. in http://californiabar.globl.org/report.php?mi=address1&ma=city&miv=&mav=new+york&fn=li&li=20&g=2&pp=5

Thanks for the feedback.

-csc2law

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Wed Mar 04, 2009 6:42 pm

And of course, there are much more fun reports, such as (from the other thread about this):

Which schools lead the state in disbarred graduates?

Where not to work if you want to avoid Harvard grads

:wink:

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Wed Mar 11, 2009 1:27 pm

Update:


Good luck everybody.

UnknownElementX
Posts: 39
Joined: Mon Dec 22, 2008 12:43 am

Re: Tool for those considering school and/or practice in CA

Postby UnknownElementX » Wed Mar 11, 2009 3:11 pm

The only downside is that these figures don't really show hiring preferences, as you don't know the total number of people who wanted to go to these places. for example I am from So Cal and considering Columbia. for me these figures don't mean much because I don't know how many Columbia law students are even trying to get into the California market (which is likely small).

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Wed Mar 11, 2009 4:36 pm

True. The best you can get is some firms that clearly favor a particular school, e.g. a few of the fancy firms that seem to select disproportionately from Stanford.

In your case, you can at least find out which firms have hired Columbia grads in the past (and may be more likely to in the future).

Danteshek
Posts: 2172
Joined: Wed Dec 10, 2008 4:40 pm

Re: Tool for those considering school and/or practice in CA

Postby Danteshek » Wed Mar 11, 2009 7:31 pm

At some point you should sift through the data and combine duplicate employer records. For instance, in the current data "Ofc of the District Attorney" is separate from "Office of the District Attorney." There are many other examples.

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Thu Mar 12, 2009 12:28 am

Yeah, I plan to do it once the first run through the database is done.

User avatar
pany1985
Posts: 389
Joined: Wed Jan 28, 2009 9:08 am

Re: Tool for those considering school and/or practice in CA

Postby pany1985 » Thu Mar 12, 2009 12:28 am

It's so confusing having two of these threads with the same name

mbdymu02
Posts: 6
Joined: Mon Oct 27, 2008 1:17 pm

Re: Tool for those considering school and/or practice in CA

Postby mbdymu02 » Sun Mar 15, 2009 4:27 pm

.

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Fri Mar 20, 2009 7:53 pm

Just a heads up that apparently the 162,000 member number is for active members of the California Bar, not the overall total. So that pushes back the completion date for my site by a few days.

More than 162,000 attorneys actively licensed to practice in the state. That means every person in the state could have their own personal , dedicated lawyer for almost two days a year. Even infants. :shock: An overgeneralization sure, and yes some of them don't work in CA, but still...

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Tue Mar 24, 2009 12:43 pm

Thought I'd let you all know that my spidering program has finished scanning through the Bar's website. That means http://californiabar.globl.org/ has has (for the moment) a complete view of the California Bar membership.

This includes:
  • 210,039 member records (152,455 currently active)
  • 14,848 Hastings alumni
  • Graduates of 331 different law schools and 1,677 undergraduate institutions
  • 34,808 organizations/firms (not counting small private practices)

Things I noticed today:

I also added the ability to exclude specific terms and include only active members on the report generator.

Anyway, let me know if you spot any problems. I know that some of the smaller firms may still have inconsistent naming, but hopefully only a few. The automation to fix that isn't smart enough to fix certain things. If you come across one, feel free to contact me.

-csc2law

User avatar
csc2law
Posts: 51
Joined: Sat Nov 22, 2008 2:02 am

Re: Tool for those considering school and/or practice in CA

Postby csc2law » Fri Oct 16, 2009 1:00 pm

Just bumping this for those who didn't know about it...

User avatar
The Brainalist
Posts: 317
Joined: Wed Oct 14, 2009 1:12 pm

Re: Tool for those considering school and/or practice in CA

Postby The Brainalist » Fri Oct 16, 2009 1:36 pm

This is great. Thanks!

So much for undergrad not mattering. It seems like you have to go to Berkeley UG to improve your chances of going to law school. :(

wired
Posts: 472
Joined: Tue Jun 23, 2009 2:29 pm

Re: Tool for those considering school and/or practice in CA

Postby wired » Fri Oct 16, 2009 2:02 pm

Thank you so so much! I am going to law school because I want to work in a specific gov't office in CA. This helps me figure out my best options. Thank you!

Inygma
Posts: 629
Joined: Thu Oct 02, 2008 7:11 pm

Re: Tool for those considering school and/or practice in CA

Postby Inygma » Mon Oct 19, 2009 4:04 pm

Amazing job!

Danteshek
Posts: 2172
Joined: Wed Dec 10, 2008 4:40 pm

Re: Tool for those considering school and/or practice in CA

Postby Danteshek » Sun Jul 25, 2010 4:18 pm

Bumping. Has OP been updating the database?

User avatar
20160810
Posts: 19648
Joined: Fri May 02, 2008 1:18 pm

Re: Tool for those considering school and/or practice in CA

Postby 20160810 » Mon Jul 26, 2010 2:53 am

The Brainalist wrote:This is great. Thanks!

So much for undergrad not mattering. It seems like you have to go to Berkeley UG to improve your chances of going to law school. :(

FWIW, Berkeley UG doesn't help much either. :|




Return to “Choosing a Law School”

Who is online

Users browsing this forum: muggleclutch and 8 guests