IP-WARS.NET - a forward command post of the IP Wars
create account| Front Page|Mission|Standard Operating Procedures|Operating Instructions(aka FAQ's)|Privacy Policy|Site Stats/Info|Admin Actions|Search
Sections:General|IP|SCO v World |Microsoft|grok*/OSRM|IPW Site Meta|Logbooks|Diaries|Legal Documents|View All Articles

Request For Comments: A legal case database


Logbooks

By mikey, Section Logbooks
Posted on Sat Nov 13th, 2004 at 12:08:35 EST

I am considering developing an interface to track and display the legal cases of interest to ip-wars.net.  Functionally I desire something like warmcat's yahoeuvre, that would provide useful ways to derive information from the legal case documentation.

I want to design it around a database that will allow front-end interfaces to be developed that can display the raw data in useful ways.  Examples of useful ways to display the information are the list of legal documents at tuxrocks, the Table of Claims maintained by Al Petrofsky, and the Summary of "most significant" court orders and decisions maintained by Al Petrofsky.

At this point I need help wrapping my mind around a logical view of the database design.  I am not a lawyer, and am not very familiar with the best taxonomy to use for the database.  The closest frame of reference for me is Robert's Rules of Order, which I am very familiar with.

For a loose example a database of information about a deliberative body that uses Roberts Rules could look like:

Table: body_ids
body_id
body_name
body_description

Table: committee_ids
parent_body_id
committee_id
committee_name
committee_description

Table: motion_ids
motion_id
motion_date
motion_number
motion_type (primary, amendment, incidental, secondary, etc..)
motion_title
motion_text
motion_maker (subcommittee_id, officer_id, etc..)
motion_seconder
motion_disposition (yea, nea, table, refer, etc..)

Any ideas on the logical structure and taxonomy for a legal case documentation database would be most welcome.  Does anyone know of an open source project that already does this that I can use for an example?  What do legal researchers use?

The basic information would be, for example:

title of case
short description of case
date case was filed
what court the case is being tried in
name of judge
claim type (claim, counter claim, psj, etc..)
claim date
claim description
claim title
claim status

document name
document date
document legal type (deposition, claim, evidence, etc)
claim document is related to
document submitter? (plaintiff, defendent?)
document type (text, pdf, html)
document provider (pacer, transcribed by x, etc)
document length

As you may tell, I have the itch, I need some figuring out how to scratch it :)

< PJ and OSRM: her most recent thoughts (300 comments) | Novell Vs Microsoft - Wordperfect (35 comments) >
Display: Sort:
Request For Comments: A legal case database | 26 comments (26 topical, 0 editorial, 4 hidden)
Re: Request For Comments: A legal case database (4.25 / 4) (#1)
by warmcat on Tue Nov 16th, 2004 at 15:35:49 EST
(User Info) http://yah.warmcat.com
I never saw this until you gave a link in an article post.

I started working on something similar, then did the NNTP, Grokwars and it never got very far.  I also had terrible brainache with the absence of legal knowledge trying to sort out relationships.  Here is how far it got:

http://yah.warmcat.com/boardstats.php?&showboard=SCOX&board=1600684464&tid=cald&sid= 1600684464&page=court

Not very far at all, but it is generated from mysql dynamically using the pacer document names table from pacerwatch with some extra fields.  Different css font classes are used for diffent document types, and docs can have a parent.

  • Re: Request For Comments: A legal case database by mikey, 11/16/2004 16:10:24 EST (4.00 / 3)
    • Re: Request For Comments: A legal case database by warmcat, 11/16/2004 16:28:48 EST (3.75 / 4)
      • Re: Request For Comments: A legal case database by mikey, 11/16/2004 17:14:22 EST (none / 2)
Re: Request For Comments: A legal case database (4.25 / 4) (#5)
by codswallet on Wed Nov 17th, 2004 at 00:12:47 EST
(User Info)
I've been programming and designing software for a while now. I started on a machine with two kinds of zero. It was as big as a small semi and had the computing power of a modern cell phone. A bit less, actually.

One thing I learned, is that a clear idea of what you're trying to do should come before things like data structures and software architecture.

Make a list of what you're trying store and what sorts of search paths you want. Post that and let people shoot it full of holes. Wash and repeat until done.

Then you can worry about implementation. You can go through the same review cycle about the design and implementation.

Making design decisions too early is a sure fire way to destroy a project.

  • Re: Request For Comments: A legal case database by mikey, 11/17/2004 01:07:49 EST (4.00 / 3)
    • Re: Request For Comments: A legal case database by DirtyDriver, 11/17/2004 10:25:15 EST (4.00 / 3)
    • Re: Request For Comments: A legal case database by codswallet, 11/17/2004 11:11:20 EST (4.00 / 5)
      • Re: Request For Comments: A legal case database by mikey, 11/17/2004 13:29:04 EST (4.00 / 3)
      • Re: Request For Comments: A legal case database by mikey, 11/17/2004 13:45:18 EST (4.00 / 3)
        • Re: Request For Comments: A legal case database by codswallet, 11/20/2004 14:32:29 EST (3.66 / 3)
          • Re: Request For Comments: A legal case database by br3n, 11/22/2004 13:58:37 EST (4.00 / 3)
            • Re: Request For Comments: A legal case database by codswallet, 11/22/2004 22:26:04 EST (3.66 / 3)
              • Re: Request For Comments: A legal case database by mikey, 11/23/2004 02:07:29 EST (none / 2)
                • Re: Request For Comments: A legal case database by codswallet, 11/23/2004 23:33:23 EST (3.66 / 3)
                  • Re: Request For Comments: A legal case database by mikey, 11/24/2004 01:57:59 EST (none / 2)
                    • Re: Request For Comments: A legal case database by codswallet, 11/24/2004 09:07:07 EST (4.00 / 3)
            • Re: Request For Comments: A legal case database by mikey, 11/22/2004 14:58:49 EST (none / 2)
Bye bye spambot (none / 0) (#23)
by Potential Recruit on Tue Nov 28th, 2006 at 11:00:26 EST
This used to be a spambot post that is flooding the site. Due to volume, I had to resort to this while I work to block access by these bots. My apologies - thanks for your patience.

Jeff

Bye bye spambot (none / 0) (#24)
by Potential Recruit on Tue Nov 28th, 2006 at 11:02:17 EST
This used to be a spambot post that is flooding the site. Due to volume, I had to resort to this while I work to block access by these bots. My apologies - thanks for your patience.

Jeff

Bye bye spambot (none / 0) (#25)
by Potential Recruit on Tue Nov 28th, 2006 at 11:41:36 EST
This used to be a spambot post that is flooding the site. Due to volume, I had to resort to this while I work to block access by these bots. My apologies - thanks for your patience.

Jeff

Bye bye spambot (none / 0) (#26)
by Potential Recruit on Tue Nov 28th, 2006 at 14:29:29 EST
This used to be a spambot post that is flooding the site. Due to volume, I had to resort to this while I work to block access by these bots. My apologies - thanks for your patience.

Jeff

Request For Comments: A legal case database | 26 comments (26 topical, 0 editorial, 4 hidden)
Display: Sort:

Links

Firefox 2

Use OpenOffice.org

Add to Technorati Favorites

Join EFF Today

ToTehMoon web site button

~ Merkey v The Internet et al Docs
~ Yahoeuvre
~ tuxrocks.com (SCO cases legal docs)
~ scofacts.org
~ eagle.petrofsky.org
~ Zen's Den
~ Yahoo SCOX Message Board
~ Lamlaw
~ Microsoft Watch
~ Groklaw
~ Korgwal - a Groklaw mirror
~ nosoftwarepatents.com
~ Flame Warriors
~ SCOXE Wars
~ Get your Merkey Number here!
~ Digital Law Online

Recent Comments

Breaking News and External Article Comments
General News – General Articles
by ColonelZen, January 5
60 comments
» SCO Lifeboat List from Stats_for_all – AncientBrit, May 6
» Not a single comment on the Novell... – sphealey, Jul 22
» Re: Not a single comment on the Novell... – AncientBrit, Aug 8

Eagle Loses Appeals
General News – General Articles
by JCausey, December 15
1 comment
» Re: Eagle Loses Appeals – br3n, Jan 7

The Chinese Room Revisited, Thoughts on...
General News – Diary
by ColonelZen, November 24
1 comment
» Re: The Chinese Room Revisited,... – ColonelZen, Nov 24

How to Transition a Windows Shop to Linux
General News – General Articles
by JCausey, November 21
3 comments
» Re: How to Transition a Windows Shop to... – ColonelZen, Nov 22
» Re: How to Transition a Windows Shop to... – JCausey, Nov 23
» Re: How to Transition a Windows Shop to... – ColonelZen, Nov 23

Advocacy
General News – Diary
by br3n, October 29
3 comments
» Re: Advocacy – br3n, Nov 2
» Re: Advocacy – ColonelZen, Nov 2
» Re: Advocacy – br3n, Nov 4

Very Bad News for Darl and Ralph
SCO v The World – Diary
by ColonelZen, October 13
7 comments
» Re: OT advocacy – br3n, Oct 26
» Re: OT advocacy – JCausey, Oct 28
» Re: OT advocacy – br3n, Oct 29

Some SCOX Financial Analysis
SCO v The World – SCO Related Articles
by JCausey, September 21
13 comments
» Re: Some SCOX Financial Analysis – br3n, Oct 3
» Re: Some SCOX Financial Analysis – ColonelZen, Oct 3
» Re: Some SCOX Financial Analysis – br3n, Oct 6

Open Source in Education - Opening Doors
General News – General Articles
by JCausey, September 28
1 comment
» Re: Open Source in Education - Opening... – br3n, Sep 29

An IPOWER ful experience
General News – Diary
by ColonelZen, September 25
6 comments
» IPOWER SysAdmin Doesn't Do Weekends!! – ColonelZen, Sep 29
» Re: An IPOWER ful experience – ColonelZen, Sep 29
» Re: An IPOWER ful experience – ColonelZen, Sep 29

Learning C#
Microsoft – Diary
by ColonelZen, September 23
1 comment
» Re: Learning C# – ColonelZen, Sep 23

Comment search...

Recent Diaries

SCO has a Potential and Credible BILLION Dollar Liability
by ColonelZen - March 15

The Chinese Room Revisited, Thoughts on Consciousness
by ColonelZen - November 24
1 comment


Advocacy
by br3n - October 29
3 comments


An IPOWER ful experience
by ColonelZen - September 25
6 comments


Learning C#
by ColonelZen - September 23
1 comment


Getting ruby DBI for Mysql and Postgresql working on FC 6
by ColonelZen - March 7

Declaration of Linus Torvalds
by nedu - February 13
1 comment


Declaration of M. Douglas McIlroy
by nedu - February 12
6 comments


Declaration of Ulrich Drepper
by nedu - February 11
1 comment


Declaration of K. Y. Srinivasan
by nedu - February 11


More Diaries...

Login

Make a new account

Username:
Password:

Older Stories

Monday May 28th
Why SCO Does Not Own the Unix Copyrights
   (0 comments)

Thursday April 5th
It Can Really Happen - Eagle Broadband Delisting from AMEX
   (5 comments)

Monday March 12th
OpenOffice.org Sends Open Letter to Dell
   (0 comments)

Tuesday March 6th
Preliminary Order in Prohibition
   (2 comments)

Monday January 15th
[Linux-ia64] optimizing __copy_user
   (12 comments)

Older Stories...

Related Links

~ More on Logbooks
~ Also by mikey

SourceForge Logo Powered by Scoop

All trademarks and copyrights on this page are owned by their respective companies or owners.
Comments, articles and logbooks are owned by the Poster. By posting on the ip-wars.net web site, all posters grant a license to ip-wars.net to publish the content and release it pursuant to the Creative Commons License that covers the rest of the site. For more details, please check out the Standard Operating Procedures. Also, please read the Privacy Policy for the site. Finally, DO NOT send e-mail to the site owner (Jeff Causey) unless you have read and agree to the terms regarding e-mail included in the Standard Operating Procedures.
Everything else © 2004, 2005, 2006, 2007 ip-wars.net and Jeffrey G. Causey and is licensed under a
Creative Commons License
This work is licensed under a Creative Commons License.