names

37 rows where place_id = 593059

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610260 1870866 1870866 defendant Hill William yeoman 593059 593059 Hill, William, of Wolverley, yeoman 0
3661164 1913768 1913768 plaintiff Jones Humphrey husbandman 593059 593059 Jones, Humphrey, of Wolverley, husbandman 0
3661166 1913768 1913768 plaintiff Hondy Roger husbandman 593059 593059 Hondy, Roger, of Wolverley, husbandman 2
3661179 1913772 1913772 defendant Cookes Thomas husbandman 593059 593059 Cookes, Thomas, of Wolverley, husbandman 1
3744828 1940281 1940281 defendant Benett John husbandman 593059 593059 Benett, John, of Wolverley, husbandman 0
3744829 1940281 1940281 defendant Benett Richard husbandman 593059 593059 Benett, Richard, of Wolverley, husbandman 1
3767002 1947345 1947345 defendant Jones Richard husbandman 593059 593059 Jones, Richard, of Wolverley, husbandman 2
3767003 1947345 1947345 defendant Hill John, junior husbandman 593059 593059 Hill, John, junior, of Wolverley, husbandman 3
3791196 1955079 1955079 defendant Hunt Richard, junior husbandman 593059 593059 Hunt, Richard, junior, of Wolverley, husbandman 2
3813382 1962100 1962100 plaintiff Dycons Richard (legal representative) 593059 593059 Dycons, Richard, of Wolverley, yeoman, executor of 0
3821567 1964640 1964640 defendant Hurtell John husbandman 593059 593059 Hurtell, John, of Wolverley, husbandman 3
3821568 1964640 1964640 defendant Goodyere Roger husbandman 593059 593059 Goodyere, Roger, of Wolverley, husbandman 4
3821569 1964640 1964640 defendant Holyman Roger husbandman 593059 593059 Holyman, Roger, of Wolverley, husbandman 5
3821570 1964640 1964640 defendant Pytte James husbandman 593059 593059 Pytte, James, of Wolverley, husbandman 6
3821571 1964640 1964640 defendant Rogers John husbandman 593059 593059 Rogers, John, of Wolverley, husbandman 7
3918739 1996597 1996597 defendant Pytt Roger husbandman 593059 593059 Pytt, Roger, of Wolverley, husbandman 0
4075962 2051699 2051699 plaintiff Sebrighte John gent 593059 593059 Sebrighte, John, of Wolverley, gent 0
4075964 2051700 2051700 plaintiff Sebrighte John gent 593059 593059 Sebrighte, John, of Wolverley, gent 0
4081361 2053640 2053640 defendant Inkes or Jukes Roger husbandman 593059 593059 Inkes or Jukes, Roger, of Wolverley, husbandman 0
4098364 2059740 2059740 defendant Farmer William capper 593059 593059 Farmer, William, of Wolverley, capper 1
4409985 2167947 2167947 defendant Warren alias Warham Thomas, junior husbandman 593059 593059 Warren alias Warham, Thomas, junior, of Wolverley, husbandman 0
4409986 2167947 2167947 defendant Warren alias Warham Gilbert husbandman 593059 593059 Warren alias Warham, Gilbert, of Wolverley, husbandman 1
4597996 2230629 2230629 defendant Holbar_ John   593059 593059 Holbar_, John, of Wolverley 1
4828953 2305099 2305099 defendant Taillour John husbandman 593059 593059 Taillour, John, of Wolverley, husbandman 3
5173230 2407884 2407884 defendant Hondy John husbandman 593059 593059 Hondy, John, of Wolverley, husbandman 1
5193146 2413726 2413726 defendant Hondy or Houdy John husbandman 593059 593059 Hondy or Houdy, John, of Wolverley, husbandman 1
5275505 2437904 2437904 defendant Wodde Thomas esq 593059 593059 Wodde, Thomas, of Wolverley, esq 5
5394718 2473550 2473550 defendant Penne Thomas husbandman 593059 593059 Penne, Thomas, of Wolverley, husbandman 0
5403671 2476119 2476119 defendant Penne Thomas husbandman 593059 593059 Penne, Thomas, of Wolverley, husbandman 0
5434460 2485247 2485247 defendant Wode Thomas gent 593059 593059 Wode, Thomas, of Wolverley, gent 0
5445488 2488547 2488547 defendant Woode Thomas gent 593059 593059 Woode, Thomas, of Wolverley, gent 0
5503983 2506157 2506157 defendant Pacchet William husbandman 593059 593059 Pacchet, William, of Wolverley, husbandman 0
5518413 2510585 2510585 defendant Wode Henry yeoman 593059 593059 Wode, Henry, of Wolverley, yeoman 0
5518416 2510586 2510586 defendant Wode Henry yeoman 593059 593059 Wode, Henry, of Wolverley, yeoman 0
5533658 2515076 2515076 defendant Woode John gent 593059 593059 Woode, John, of Wolverley, gent 0
5542530 2517787 2517787 defendant Holbarowe John yeoman 593059 593059 Holbarowe, John, of Wolverley, yeoman 0
5555481 2521605 2521605 defendant Toye Humphrey husbandman 593059 593059 Toye, Humphrey, of Wolverley, husbandman 0

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);