names

65 rows where place_id = 680784

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4042103 2039666 2039666 defendant Makyns William yeoman 680784 680784 Makyns, William, of Waghen, yeoman 0
4042104 2039666 2039666 defendant Bethell Edward yeoman 680784 680784 Bethell, Edward, of Waghen, yeoman 1
4042105 2039666 2039666 defendant Tompson Bartholomew husbandman 680784 680784 Tompson, Bartholomew, of Waghen, husbandman 2
4042106 2039666 2039666 defendant Truslay John carpenter 680784 680784 Truslay, John, of Waghen, carpenter 3
4042107 2039666 2039666 defendant Bayxter Thomas husbandman 680784 680784 Bayxter, Thomas, of Waghen, husbandman 4
4042108 2039666 2039666 defendant Kydd William husbandman 680784 680784 Kydd, William, of Waghen, husbandman 5
4042109 2039666 2039666 defendant Prattye Robert husbandman 680784 680784 Prattye, Robert, of Waghen, husbandman 6
4042110 2039666 2039666 defendant Tompson Richard husbandman 680784 680784 Tompson, Richard, of Waghen, husbandman 7
4042111 2039666 2039666 defendant Mary John husbandman 680784 680784 Mary, John, of Waghen, husbandman 8
4042112 2039666 2039666 defendant Sturwall Henry husbandman 680784 680784 Sturwall, Henry, of Waghen, husbandman 9
4042113 2039666 2039666 defendant Browne Ralph husbandman 680784 680784 Browne, Ralph, of Waghen, husbandman 10
4042114 2039666 2039666 defendant Marten Bartholomew husbandman 680784 680784 Marten, Bartholomew, of Waghen, husbandman 11
4042115 2039666 2039666 defendant Harper William husbandman 680784 680784 Harper, William, of Waghen, husbandman 12
4042116 2039666 2039666 defendant Noble John husbandman 680784 680784 Noble, John, of Waghen, husbandman 13
4171297 2085422 2085422 defendant Shipwright Lawrence husbandman 680784 680784 Shipwright, Lawrence, of Waghen, husbandman 0
4493699 2198728 2198728 plaintiff Bate John   680784 680784 Bate, John, of Waghen 1
4509908 2203584 2203584 plaintiff Baker Beatrice   680784 680784 Baker, Beatrice, of Waghen, formerly wife of Robert 0
4509909 2203584 2203584 defendant Paynton Richard   680784 680784 Paynton, Richard, of Waghen 0
4510871 2203855 2203855 plaintiff Bate John   680784 680784 Bate, John, of Waghen 1
4538228 2212244 2212244 defendant Donce John   680784 680784 Donce, John, of Waghen 0
4538230 2212245 2212245 defendant Donce John   680784 680784 Donce, John, of Waghen 0
4559466 2218909 2218909 plaintiff Merflete Robert   680784 680784 Merflete, Robert, of Waghen, vicar 0
4567728 2221472 2221472 defendant Dounce John   680784 680784 Dounce, John, of Waghen 0
4603687 2232340 2232340 defendant Sandreson William   680784 680784 Sandreson, William, of Waghen 0
4634602 2241674 2241674 defendant Saundreson William   680784 680784 Saundreson, William, of Waghen 0
4677947 2258720 2258720 defendant Waghen John husbandman 680784 680784 Waghen, John, of Waghen, husbandman 0
4681557 2259843 2259843 plaintiff Merflete Robert   680784 680784 Merflete, Robert, of Waghen, vicar 0
4700659 2265611 2265611 defendant Poynton Thomas husbandman 680784 680784 Poynton, Thomas, of Waghen, husbandman 2
4737923 2276967 2276967 defendant Middilton William husbandman 680784 680784 Middilton, William, of Waghen, husbandman 0
4737924 2276967 2276967 defendant Hayton John shoemaker 680784 680784 Hayton, John, of Waghen, shoemaker 1
4763001 2284413 2284413 plaintiff Geffreyson John   680784 680784 Geffreyson, John, of Waghen 0
4767751 2285891 2285891 defendant Halyday John husbandman 680784 680784 Halyday, John, of Waghen, husbandman 2
4768711 2286192 2286192 plaintiff North Peter   680784 680784 North, Peter, of Waghen 0
4786700 2291895 2291895 plaintiff Geffrayson John   680784 680784 Geffrayson, John, of Waghen 0
4799062 2295883 2295883 plaintiff Thomson John   680784 680784 Thomson, John, of Waghen 0
4799310 2295960 2295960 plaintiff Tomson John   680784 680784 Tomson, John, of Waghen 0
4804039 2297446 2297446 defendant Colman alias Merflete Hugh   680784 680784 Colman alias Merflete, Hugh, of Waghen, shipwright 0
4843740 2309565 2309565 defendant Peyntour Richard husbandman 680784 680784 Peyntour, Richard, of Waghen, husbandman 0
4843741 2309565 2309565 defendant Peyntour William laborer 680784 680784 Peyntour, William, of Waghen, laborer 1
4843751 2309567 2309567 defendant Haliday John husbandman 680784 680784 Haliday, John, of Waghen, husbandman 3
4852414 2312172 2312172 defendant Sclater Walter slater 680784 680784 Sclater, Walter, of waghen, slater 0
4852415 2312172 2312172 defendant Sclater Richard laborer 680784 680784 Sclater, Richard, of Waghen, laborer 1
4852416 2312172 2312172 defendant Sclater Thomas laborer 680784 680784 Sclater, Thomas, of Waghen, laborer 2
4854122 2312701 2312701 plaintiff Wyvyngton Thomas   680784 680784 Wyvyngton, Thomas, of Waghen 0
4859050 2314210 2314210 defendant Threshaldoun Maurice husbandman 680784 680784 Threshaldoun, Maurice, of Waghen, husbandman 0
4871099 2317937 2317937 defendant Payntour Richard husbandman 680784 680784 Payntour, Richard, of Waghen, husbandman 0
4871100 2317937 2317937 defendant Payntour William laborer 680784 680784 Payntour, William, of Waghen, laborer 1
4871109 2317940 2317940 defendant Bate John   680784 680784 Bate, John, of Waghen, wright 1
4871110 2317940 2317940 defendant Horton Thomas laborer 680784 680784 Horton, Thomas, of Waghen, laborer 2
4871111 2317940 2317940 defendant Horton Richard weaver 680784 680784 Horton, Richard, of Waghen, weaver 3
4948754 2341592 2341592 defendant Thresshaldoune Thomas husbandman 680784 680784 Thresshaldoune, Thomas, of Waghen, husbandman 1
4948755 2341592 2341592 defendant Corte William husbandman 680784 680784 Corte, William, of Waghen, husbandman 2
4948756 2341592 2341592 defendant Forster Robert husbandman 680784 680784 Forster, Robert, of Waghen, husbandman 3
4948762 2341594 2341594 defendant Donce or Douce John husbandman 680784 680784 Donce or Douce, John, of Waghen, husbandman 1
5003636 2357954 2357954 defendant Waghen Margaret widow 680784 680784 Waghen, Margaret, of Waghen, widow 1
5115380 2390926 2390926 defendant Fotehede Robert husbandman 680784 680784 (Fotehede, Robert, of Waghen, husbandman 1
5115381 2390926 2390926 defendant Fotehede Isabel widow 680784 680784 together with Fotehede, Isabel, of Waghen, widow 2
5115382 2390926 2390926 defendant Fotehede George husbandman 680784 680784 Fotehede, George, of Waghen, husbandman 3
5121685 2392772 2392772 defendant Horton Thomas   680784 680784 Horton, Thomas, of Waghen, "fereman" 1
5132547 2396013 2396013 defendant Douce Thomas husbandman 680784 680784 Douce, Thomas, of Waghen, husbandman 2
5132548 2396013 2396013 defendant Halyday Robert husbandman 680784 680784 Halyday, Robert, of Waghen, husbandman 3
5191448 2413239 2413239 defendant Chamber Thomas yeoman 680784 680784 Chamber, Thomas, of Waghen, yeoman 0
5191449 2413239 2413239 defendant Dounam John yeoman 680784 680784 Dounam, John, of Waghen, yeoman 1
5191456 2413241 2413241 defendant Dounam Thomas yeoman 680784 680784 Dounam, Thomas, of Waghen, yeoman 0
5623799 2551383 2551383 defendant Richardesson John yeoman 680784 680784 Richardesson, John, of Waghen, 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);