names

39 rows where place_id = 593199

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610887 1871078 1871078 defendant Kay Thomas yeoman 593199 593199 Kay, Thomas, of Almondbury, yeoman 0
3610888 1871078 1871078 defendant Beamount Nicholas husbandman 593199 593199 Beamount, Nicholas, of Almondbury, husbandman 1
3610890 1871078 1871078 defendant Croweder William carpenter 593199 593199 Croweder, William, of Almondbury, carpenter 3
3610891 1871078 1871078 defendant Ermytage William tailor 593199 593199 Ermytage, William, of Almondbury, tailor 4
3626941 1903278 1903278 defendant Beamound Gilbert yeoman 593199 593199 Beamound, Gilbert, of Almondbury, yeoman 0
3700716 1926477 1926477 defendant Hepworth Thomas clothier 593199 593199 Hepworth, Thomas, of Almondbury, clothier 0
3700717 1926477 1926477 defendant Hepworth Thomas sherman 593199 593199 Hepworth, Thomas, of Almondbury, sherman 1
3826604 1966169 1966169 defendant Beamond John yeoman 593199 593199 Beamond, John, of Almondbury, yeoman 0
3883887 1984882 1984882 defendant Appylyerd Richard yeoman 593199 593199 Appylyerd, Richard, of Almondbury, yeoman 1
4004980 2026563 2026563 plaintiff Kaye Giles yeoman 593199 593199 Kaye, Giles, of Almondbury, yeoman 0
4053739 2043717 2043717 defendant Beamonde Roger yeoman 593199 593199 Beamonde, Roger, of Almondbury, yeoman 0
4170399 2085138 2085138 defendant Parkyn John   593199 593199 Parkyn, John, of Almondbury, wright 3
4404255 2165994 2165994 defendant Ford Arthur husbandman 593199 593199 Ford, Arthur, of Almondbury, husbandman 0
4695402 2264039 2264039 defendant Hawemet John husbandman 593199 593199 Hawemet, John, of Almondbury, husbandman 1
4788502 2292466 2292466 defendant Parkyn John yeoman 593199 593199 Parkyn, John, of Almondbury, yeoman 0
4856536 2313426 2313426 defendant Dyson William   593199 593199 together with, Dyson, William, of Almondbury, wright 1
4912252 2330334 2330334 defendant Kay Thomas gent 593199 593199 Kay, Thomas, of Almondbury, gent 1
4912253 2330334 2330334 defendant Marler Robert   593199 593199 Marler, Robert, of Almondbury, servant 2
4912254 2330334 2330334 defendant Kay Peter yeoman 593199 593199 Kay, Peter, of Almondbury, yeoman 3
5068508 2377074 2377074 defendant Bemond Robert yeoman 593199 593199 Bemond, Robert, of Almondbury, yeoman 1
5092971 2384332 2384332 defendant Beamond Richard yeoman 593199 593199 Beamond, Richard, of Almondbury, yeoman 3
5216480 2420550 2420550 defendant Langeld Thomas yeoman 593199 593199 Langeld, Thomas, of Almondbury, yeoman 4
5372122 2466874 2466874 defendant Kay Lawrence mercer 593199 593199 Kay, Lawrence, of Almondbury, mercer 1
5380772 2469554 2469554 defendant Beamont Oliver yeoman 593199 593199 Beamont, Oliver, of Almondbury, yeoman 3
5386082 2471088 2471088 defendant Beamont Oliver yeoman 593199 593199 Beamont, Oliver, of Almondbury, yeoman 4
5389099 2471932 2471932 defendant Key Laurence yeoman 593199 593199 Key, Laurence, of Almondbury, yeoman 0
5389907 2472177 2472177 defendant Kay Laurence, senior yeoman 593199 593199 Kay, Laurence, senior, of Almondbury, yeoman 1
5396407 2474064 2474064 defendant Yeson John (legal representative) 593199 593199 Yeson, John, of Almondbury, executors of 0
5398332 2474588 2474588 defendant Beamont Oliver yeoman 593199 593199 Beamont, Oliver, of Almondbury, yeoman 4
5398338 2474589 2474589 defendant Beamont Oliver yeoman 593199 593199 Beamont, Oliver, of Almondbury, yeoman 4
5398344 2474590 2474590 defendant Beamont Oliver yeoman 593199 593199 Beamont, Oliver, of Almondbury, yeoman 4
5401801 2475578 2475578 defendant Kay Lawrence yeoman 593199 593199 Kay, Lawrence, of Almondbury, yeoman 0
5414751 2479349 2479349 defendant Kay Lawrence yeoman 593199 593199 Kay, Lawrence, of Almondbury, yeoman 0
5414754 2479350 2479350 defendant Kay Lawrence yeoman 593199 593199 Kay, Lawrence, of Almondbury, yeoman 0
5438762 2486517 2486517 defendant Dalton Richard yeoman 593199 593199 Dalton, Richard, of Almondbury, yeoman 12
5476114 2497865 2497865 defendant Dalton Richard yeoman 593199 593199 Dalton, Richard, of Almondbury, yeoman 11
5490100 2501921 2501921 defendant Diconson William weaver 593199 593199 Diconson, William, of Almondbury, weaver 2
5490105 2501922 2501922 defendant Diconson William weaver 593199 593199 Diconson, William, of Almondbury, weaver 3
5577253 2527938 2527938 defendant Armitage Thomas husbandman 593199 593199 Armitage, Thomas, of Almondbury, 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);