names

22 rows where place_id = 602153

✎ 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
3648659 1909967 1909967 defendant Mewes Thomas butcher 602153 602153 Mewes, Thomas, of Havont, butcher 0
3648660 1909967 1909967 defendant Roper John tanner 602153 602153 Roper, John, of Havont, tanner 1
4587722 2227566 2227566 defendant Jurdan Simon   602153 602153 Jurdan, Simon, of Havont 0
4669046 2256026 2256026 plaintiff Blakeman William   602153 602153 Blakeman, William, of Havont 0
4675542 2257961 2257961 defendant Candele William husbandman 602153 602153 Candele, William, of Havont, husbandman 0
4797307 2295331 2295331 defendant Melbrigge Valentine husbandman 602153 602153 Melbrigge, Valentine, of Havont, husbandman 0
4805780 2298013 2298013 defendant Arnold Thomas traiklemanger 602153 602153 Arnold, Thomas, of Havont, traiklemanger 0
4805781 2298013 2298013 defendant Laver Andrew shoemaker 602153 602153 with Laver, Andrew, of Havont, shoemaker 1
4820167 2302380 2302380 plaintiff Purye Nicholas   602153 602153 Purye, Nicholas, of Havont, on his own account 0
4876315 2319554 2319554 defendant Kaxston John husbandman 602153 602153 Kaxston, John, of Havont, husbandman 1
4881201 2321023 2321023 defendant Edmond Roger tailor 602153 602153 Edmond, Roger, of Havont, tailor 7
4967600 2347251 2347251 defendant Bocher Roger butcher 602153 602153 Bocher, Roger, of Havont, butcher 1
4982542 2351692 2351692 defendant Daly Richard husbandman 602153 602153 Daly, Richard, of Havont, husbandman 1
5013816 2360890 2360890 plaintiff Barbour John   602153 602153 Barbour, John, of Havont 0
5033512 2366683 2366683 defendant Bocher Richard butcher 602153 602153 Bocher, Richard, of Havont, butcher 1
5095408 2385077 2385077 defendant Gyst John husbandman 602153 602153 Gyst, John, of Havont, husbandman 0
5098535 2386002 2386002 defendant Cormonger Thomas husbandman 602153 602153 Cormonger, Thomas, of Havont, husbandman 0
5122571 2393033 2393033 defendant Hamond John smith 602153 602153 Hamond, John, of Havont, smith 1
5122572 2393033 2393033 defendant Hunt John husbandman 602153 602153 Hunt, John, of Havont, husbandman 2
5122573 2393033 2393033 defendant Foly Peter husbandman 602153 602153 Foly, Peter, of Havont, husbandman 3
5258616 2432816 2432816 defendant Cornemonger William husbandman 602153 602153 Cornemonger, William, of Havont, husbandman 3
5296947 2444101 2444101 defendant Seton John yeoman 602153 602153 Seton, John, of Havont, 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);