names

46 rows where place_id = 592424

✎ 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
3607660 1870051 1870051 plaintiff Sayer William yeoman 592424 592424 Sayer, William, of Detlyng, yeoman 0
3634153 1905482 1905482 defendant Bendon Valentine husbandman 592424 592424 Bendon, Valentine, of Detlyng, husbandman 0
3642803 1908197 1908197 defendant Webbe William clothmaker 592424 592424 Webbe, William, of Detlyng, clothmaker 0
3642805 1908198 1908198 defendant Webbe William clothmaker 592424 592424 Webbe, William, of Detlyng, clothmaker 0
3652625 1911157 1911157 defendant Polhell Richard husbandman 592424 592424 Polhell, Richard, of Detlyng, husbandman 1
3654569 1911691 1911691 defendant Polle alias Polhyll Richard husbandman 592424 592424 Polle alias Polhyll, Richard, of Detlyng, husbandman 0
3672670 1917455 1917455 defendant Benynden Valentine husbandman 592424 592424 Benynden, Valentine, of Detlyng, husbandman 1
3685315 1921559 1921559 defendant Benyngden Thomas smith 592424 592424 Benyngden, Thomas, of Detlyng, smith 0
3685317 1921560 1921560 defendant Benyngden Thomas smith 592424 592424 Benyngden, Thomas, of Detlyng, smith 0
3695324 1924762 1924762 defendant Benden Thomas smith 592424 592424 Benden, Thomas, of Detlyng, smith 2
3695688 1924883 1924883 defendant Benyngden Thomas husbandman 592424 592424 Benyngden, Thomas, of Detlyng, husbandman 0
3795155 1956350 1956350 defendant Webbe William gent 592424 592424 Webbe, William, of Detlyng, gent 0
3822978 1965095 1965095 defendant Polhyll Richard husbandman 592424 592424 Polhyll, Richard, of Detlyng, husbandman 0
3824675 1965591 1965591 defendant Webbe William gent 592424 592424 Webbe, William, of Detlyng, gent 0
3850019 1973593 1973593 plaintiff Marshe Geoffrey husbandman 592424 592424 Marshe, Geoffrey, of Detlyng, husbandman 0
3888305 1986352 1986352 defendant Webbe William gent 592424 592424 Webbe, William, of Detlyng, gent 0
3994750 2022875 2022875 defendant Mylles John tiler 592424 592424 Mylles John, of Detlyng, tiler 2
4504428 2201939 2201939 plaintiff Ros John   592424 592424 Ros, John, of Detlyng 0
4670795 2256546 2256546 defendant Horton John husbandman 592424 592424 Horton, John, of Detlyng, husbandman 1
4670798 2256546 2256546 defendant Webbe Thomas laborer 592424 592424 Webbe, Thomas, of Detlyng, laborer 4
4732071 2275212 2275212 defendant Webbe Thomas laborer 592424 592424 Webbe, Thomas, of Detlyng, laborer 2
4763328 2284518 2284518 defendant Culter John laborer 592424 592424 Culter, John, of Detlyng, laborer 1
4786965 2291987 2291987 defendant Culter Clement husbandman 592424 592424 Culter, Clement, of Detlyng, husbandman 0
4786966 2291987 2291987 defendant Culter John laborer 592424 592424 Culter, John, of Detlyng, laborer 1
4794636 2294464 2294464 defendant Monk Richard husbandman 592424 592424 Monk, Richard, of Detlyng, husbandman 0
4810044 2299295 2299295 defendant Culter Edmund laborer 592424 592424 Culter, Edmund, of Detlyng, laborer 0
4894510 2324956 2324956 defendant Fox William laborer 592424 592424 Fox, William, of Detlyng, laborer 1
4917443 2331969 2331969 defendant de Coulter Clement husbandman 592424 592424 with de Coulter, Clement, of Detlyng, husbandman 1
4948860 2341627 2341627 defendant Fox William (legal representative) 592424 592424 Fox, William, of Detlyng, clerk, executors of 0
4948862 2341627 2341627 defendant Bacheler Thomas husbandman 592424 592424 Bacheler, Thomas, of Detlyng, husbandman 2
5025196 2364263 2364263 defendant Bacheler William yeoman 592424 592424 Bacheler, William, of Detlyng, yeoman 4
5025198 2364264 2364264 defendant Gubter John husbandman 592424 592424 Gubter, John, of Detlyng, husbandman 0
5101635 2386902 2386902 defendant Bans or Baus Robert   592424 592424 Bans or Baus, Robert, of Detlyng, tile maker 0
5136352 2397153 2397153 defendant Downe John   592424 592424 Downe, John, of Detlyng 1
5136353 2397153 2397153 defendant Parker Andrew   592424 592424 Parker, Andrew, of Detlyng 2
5314935 2449517 2449517 defendant Monke Richard husbandman 592424 592424 Monke, Richard, of Detlyng, husbandman 0
5375835 2468035 2468035 defendant Brode Richard husbandman 592424 592424 Brode, Richard, of Detlyng, husbandman 1
5521140 2511427 2511427 defendant Dykerton George husbandman 592424 592424 Dykerton, George, of Detlyng, husbandman 1
5553960 2521199 2521199 defendant Beauden Thomas smith 592424 592424 Beauden, Thomas, of Detlyng, smith 0
5574094 2526989 2526989 defendant Bykerton George husbandman 592424 592424 Bykerton, George, of Detlyng, husbandman 0
5586805 2530913 2530913 defendant Begenden Valentine husbandman 592424 592424 Begenden, Valentine, of Detlyng, husbandman 1
5589458 2531704 2531704 defendant Begenden Thomas smith 592424 592424 Begenden, Thomas, of Detlyng, smith 2
5589675 2531768 2531768 defendant Webbe William clothmaker 592424 592424 Webbe, William, of Detlyng, clothmaker 2
5595824 2533606 2533606 defendant Benyngdon Thomas smith 592424 592424 Benyngdon, Thomas, of Detlyng, smith 0
5606053 2536782 2536782 defendant Webbe William clothmaker 592424 592424 Webbe, William, of Detlyng, clothmaker 0
5610411 2546969 2546969 defendant Beneyt John   592424 592424 Beneyt, John, of Detlyng 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);