names

31 rows where place_id = 594530

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616503 1872798 1872798 defendant Mowerethorp George butcher 594530 594530 Mowerethorp, George, of Hoo, Kent, butcher 1
3692315 1923765 1923765 defendant Cobham Edward gent 594530 594530 Cobham, Edward, of Hoo, Kent, gent 3
3698743 1925823 1925823 defendant Cobham Edward gent 594530 594530 Cobham, Edward, of Hoo, Kent, gent 0
3698752 1925826 1925826 defendant Cobham Edward gent 594530 594530 Cobham, Edward, of Hoo, Kent, gent 3
3698757 1925827 1925827 defendant Cobham Edward gent 594530 594530 Cobham, Edward, of Hoo, Kent, gent 3
3712336 1930176 1930176 defendant Cobham Edward gent 594530 594530 Cobham, Edward, of Hoo, Kent, gent 0
3768134 1947670 1947670 defendant Pratt John yeoman 594530 594530 Pratt, John, of Hoo, Kent, yeoman 2
3799443 1957743 1957743 defendant Cobham Joan widow 594530 594530 Cobham, Joan, of Hoo, Kent, widow 5
3812634 1961840 1961840 defendant Hekys William mariner 594530 594530 Hekys, William, of Hoo, Kent, mariner 1
3857537 1975992 1975992 defendant Rolffe Stephen husbandman 594530 594530 Rolffe, Stephen, of Hoo, Kent, husbandman 0
3921158 1997428 1997428 defendant Prett John yeoman 594530 594530 Prett, John, of Hoo, Kent, yeoman 1
3921162 1997429 1997429 defendant Prett John yeoman 594530 594530 Prett, John, of Hoo, Kent, yeoman 1
3925155 1998722 1998722 defendant Roo Thomas husbandman 594530 594530 Roo, Thomas, of Hoo, Kent, husbandman 2
4091413 2057217 2057217 defendant Carre Thomas husbandman 594530 594530 Carre, Thomas, of Hoo, Kent, husbandman 1
4586243 2227119 2227119 defendant Everard Baldwin   594530 594530 Everard, Baldwin, of Hoo, Kent 3
4586252 2227120 2227120 defendant Everard Baldwin   594530 594530 Everard, Baldwin, of Hoo, Kent 3
4722340 2272310 2272310 defendant Esthwayt Nicholas husbandman 594530 594530 Esthwayt, Nicholas, of Hoo, Kent, husbandman 0
4915428 2331329 2331329 defendant Shirewode John   594530 594530 Shirewode, John, of Hoo, Kent, parson of St Mary's church 2
4915433 2331330 2331330 defendant Shirewode John   594530 594530 Shirewode, John, of Hoo, Kent, parson of St Mary's church 2
5122967 2393148 2393148 defendant Clerk John shipman 594530 594530 Clerk, John, of Hoo, Kent, shipman 1
5122973 2393149 2393149 defendant Clerk John shipman 594530 594530 Clerk, John, of Hoo, Kent,shipman 1
5252878 2431013 2431013 defendant Banaster William yeoman 594530 594530 Banaster, William, of Hoo, Kent, yeoman 1
5307913 2447383 2447383 defendant Banastre William husbandman 594530 594530 Banastre, William, of Hoo, Kent, husbandman 0
5358955 2462851 2462851 plaintiff Preste Henry (legal representative) 594530 594530 Preste, Henry, of Hoo, Kent, or of Rothewell, miller, executor of 0
5370123 2466239 2466239 defendant West Thomas butcher 594530 594530 West, Thomas, of Hoo, Kent, butcher 0
5370125 2466240 2466240 defendant West Thomas butcher 594530 594530 West, Thomas, of Hoo, Kent, butcher 0
5401202 2475405 2475405 defendant Cobham William esq 594530 594530 Cobham, William, of Hoo, Kent, esq 0
5401203 2475405 2475405 defendant Pympe Thomas gent 594530 594530 Pympe, Thomas, of Hoo, Kent, gent 1
5414226 2479190 2479190 defendant Cobham William esq 594530 594530 Cobham, William, of Hoo, Kent, esq 0
5450393 2490004 2490004 defendant Wodegrene William waterman 594530 594530 Wodegrene, William, of Hoo, Kent, waterman 1
5462538 2493704 2493704 defendant Wodegrene William slater 594530 594530 Wodegrene, William, of Hoo, Kent, slater 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);