names

29 rows where place_id = 658222

✎ 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
3947503 2006198 2006198 defendant Harman John chapman 658222 658222 Harman, John, of Hitchin, Herts, chapman 2
3994963 2022948 2022948 plaintiff Cooker William (legal representative) 658222 658222 Cooker, William, of Hitchin, Herts, yeoman, executors of 0
3994967 2022949 2022949 plaintiff Cooker William (legal representative) 658222 658222 Cooker, William, of Hitchin, Herts, yeoman, executors of 0
3994971 2022950 2022950 plaintiff Cooker William (legal representative) 658222 658222 Cooker, William, of Hitchin, Herts, yeoman, executors of 0
3995437 2023110 2023110 defendant Monke Ralph draper 658222 658222 Monke, Ralph, of Hitchin, Herts, draper 0
4001641 2025366 2025366 defendant Vyzackerley John yeoman 658222 658222 Vyzackerley, John, of Hitchin, Herts, yeoman 0
4037922 2038212 2038212 defendant Kympton John yeoman 658222 658222 Kympton, John, of Hitchin, Herts, yeoman 0
4049867 2042383 2042383 plaintiff Wake Thomas tailor 658222 658222 Wake, Thomas, of Hitchin, Herts, tailor 0
4066979 2048487 2048487 plaintiff Humberston Thomas maltster 658222 658222 Humberston, Thomas, of Hitchin, Herts, maltster 0
4111240 2064269 2064269 defendant Lockwood William ironmonger 658222 658222 Lockwood, William, of Hitchin, Herts, ironmonger 0
4273055 2120550 2120550 defendant Monke William yeoman 658222 658222 Monke, William, of Hitchin, Herts, yeoman 0
4273057 2120551 2120551 defendant Monke William yeoman 658222 658222 Monke, William, of Hitchin, Herts, yeoman 0
4286346 2125160 2125160 defendant Wigg William yeoman 658222 658222 (Wigg, William, of Hitchin, Herts, yeoman 4
4333443 2141464 2141464 defendant Frenche Richard yeoman 658222 658222 Frenche, Richard, of Hitchin, Herts, yeoman 1
4336258 2142415 2142415 defendant Hall Edward weaver 658222 658222 Hall, Edward, of Hitchin, Herts, weaver 0
4340724 2144030 2144030 defendant Moncke William, senior draper 658222 658222 Moncke, William, senior, of Hitchin, Herts, draper 0
4342746 2144735 2144735 defendant Mattocke John gent 658222 658222 Mattocke, John, of Hitchin, Herts, or of Sherington, Bucks, gent 0
4366117 2152924 2152924 defendant Huckell John carpenter 658222 658222 Huckell, John, of Hitchin, Herts, carpenter 2
4372473 2155223 2155223 defendant Dyer John bellfounder 658222 658222 Dyer, John, of Hitchin, Herts, bellfounder 0
4374666 2156002 2156002 defendant Tristram William, senior maltster 658222 658222 Tristram, William, senior, of Hitchin, Herts, yeoman, maltster 0
4384701 2159568 2159568 defendant Hall Edward weaver 658222 658222 Hall, Edward, of Hitchin, Herts, weaver 0
4405937 2166549 2166549 defendant Wylson Alexander chandler 658222 658222 Wylson, Alexander, of Hitchin, Herts, chandler 0
4910317 2329744 2329744 defendant Donton Geoffrey barber 658222 658222 Donton, Geoffrey, of Hitchin, Herts, barber 3
5153110 2402051 2402051 defendant Sleper John yeoman 658222 658222 Sleper, John, of Hitchin, Herts, yeoman 1
5153113 2402051 2402051 defendant Besteny William yeoman 658222 658222 Besteny, William, of Hitchin, Herts, yeoman 4
5191830 2413344 2413344 defendant Bertelot Lawrence gent 658222 658222 Bertelot, Lawrence, of Hitchin, Herts, gent 0
5395590 2473818 2473818 defendant --Lectheworth Thomas yeoman 658222 658222 --Lectheworth, Thomas, of Hitchin, Herts, yeoman 4
5608664 2537611 2537611 defendant Pent Edmund yeoman 658222 658222 Pent, Edmund, of Hitchin, Herts, yeoman 0
5608668 2537612 2537612 defendant Pent Edmund yeoman 658222 658222 Pent, Edmund, of Hitchin, Herts, yeoman 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);