names

70 rows where place_id = 591768

✎ 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
3605516 1869390 1869390 plaintiff Keele John   591768 591768 Keele, John, of Depyng 0
3692410 1923804 1923804 defendant Wake Thomas gent 591768 591768 Wake, Thomas, of Depyng, gent 1
3717794 1931867 1931867 defendant Androwes Alan yeoman 591768 591768 Androwes, Alan, of Depyng, yeoman 0
3718239 1931988 1931988 defendant Tego William yeoman 591768 591768 Tego, William, of Depyng, yeoman 0
3733592 1936751 1936751 defendant Andrewes Alan yeoman 591768 591768 Andrewes, Alan, of Depyng, yeoman 0
3740078 1938752 1938752 defendant Wake Thomas gent 591768 591768 Wake, Thomas, of Depyng, gent 0
3747461 1941121 1941121 defendant Androwes Alan yeoman 591768 591768 Androwes, Alan, of Depyng, yeoman 0
3776949 1950534 1950534 defendant Fall William husbandman 591768 591768 Fall, William, of Depyng, husbandman 0
3776951 1950535 1950535 defendant Fall William husbandman 591768 591768 Fall, William, of Depyng, husbandman 0
3906348 1992408 1992408 defendant Bradrike Roger yeoman 591768 591768 Bradrike, Roger, of Depyng, yeoman 1
3911215 1994076 1994076 defendant Gerne Roger merchant of the staple 591768 591768 Gerne, Roger, of Depyng, merchant of the staple 1
3911218 1994077 1994077 defendant Grene Roger merchant of the staple 591768 591768 Grene, Roger, of Depyng, merchant of the staple 1
3924619 1998548 1998548 plaintiff Tygo William (legal representative) 591768 591768 Tygo, William, of Depyng, executors of 0
3924623 1998549 1998549 plaintiff Tygo William (legal representative) 591768 591768 Tygo, William, of Depyng, executors of 0
4434394 2175509 2175509 defendant Wryghte Robert le   591768 591768 Wryghte, Robert le, of Depyng 0
4453300 2186043 2186043 defendant Buk Richard   591768 591768 Buk, Richard, of Depyng 0
4453301 2186043 2186043 defendant Charte Nicholas   591768 591768 Charte, Nicholas, of Depyng 1
4463198 2189185 2189185 defendant Bardolf Robert   591768 591768 Bardolf, Robert, of Depyng 1
4463961 2189400 2189400 plaintiff Wake Alice   591768 591768 Wake, Alice, of Depyng 0
4509477 2203431 2203431 defendant Depyng Thomas   591768 591768 Depyng, Thomas, of Depyng 0
4562951 2219981 2219981 defendant Snawe William   591768 591768 Snawe, William, of Depyng 0
4568747 2221808 2221808 defendant Inges William   591768 591768 Inges, William, of Depyng 0
4580028 2225240 2225240 plaintiff Crunker Thomas   591768 591768 Crunker, Thomas, of Depyng 0
4656337 2247875 2247875 defendant Aunkkys Robert husbandman 591768 591768 Aunkkys, Robert, of Depyng, husbandman 0
4663158 2249944 2249944 plaintiff Gelons William   591768 591768 Gelons, William, of Depyng 0
4666356 2250953 2250953 plaintiff Ive John   591768 591768 Ive, John, of Depyng 0
4666361 2250954 2250954 plaintiff Ive John butcher 591768 591768 Ive, John, of Depyng, butcher 0
4673126 2257236 2257236 plaintiff Cowehirde John   591768 591768 Cowehirde, John, of Depyng 0
4682546 2260162 2260162 defendant Twywell John   591768 591768 Twywell, John, of Depyng, bailiff 4
4682547 2260162 2260162 defendant Wolgare John   591768 591768 Wolgare, John, of Depyng, bailiff 5
4716801 2270582 2270582 plaintiff Wulgar John   591768 591768 Wulgar, John, of Depyng 0
4730315 2274680 2274680 defendant Swan John husbandman 591768 591768 Swan, John, of Depyng, husbandman 3
4730328 2274684 2274684 plaintiff Malberthorp John   591768 591768 Malberthorp, John, of Depyng 0
4730331 2274685 2274685 plaintiff Malberthorp John   591768 591768 Malberthorp, John, of Depyng 0
4746231 2279393 2279393 plaintiff Harvy or Harby John   591768 591768 Harvy or Harby, John, of Depyng 0
4752563 2281209 2281209 defendant Swan John husbandman 591768 591768 Swan, John, of Depyng, husbandman 2
4762630 2284290 2284290 defendant Swoon John husbandman 591768 591768 Swoon, John, of Depyng, husbandman 0
4786263 2291746 2291746 defendant Swoon John husbandman 591768 591768 Swoon, John, of Depyng, husbandman 0
4804729 2297679 2297679 defendant Warner William fisher 591768 591768 Warner, William, of Depyng, fisher 0
4812852 2300136 2300136 defendant Lambert Joseph husbandman 591768 591768 Lambert, Joseph, of Depyng, husbandman 1
4818079 2301728 2301728 defendant Twywell John yeoman 591768 591768 Twywell, John, of Depyng, yeoman 0
4822821 2303221 2303221 defendant Thorney Simon husbandman 591768 591768 Thorney, Simon, of Depyng, husbandman 0
4823960 2303568 2303568 defendant Andrewe Robert husbandman 591768 591768 Andrewe, Robert, of Depyng, husbandman 0
4845914 2310229 2310229 defendant Tollard William husbandman 591768 591768 Tollard, William, of Depyng, husbandman 4
4845915 2310229 2310229 defendant Jorle Thomas husbandman 591768 591768 Jorle, Thomas, of Depyng, husbandman 5
4857142 2313616 2313616 defendant Fyssher Geoffrey fisher 591768 591768 Fyssher, Geoffrey, of Depyng, fisher 0
4873409 2318639 2318639 defendant Bolower John butcher 591768 591768 Bolower, John, of Depyng, butcher 0
4873531 2318672 2318672 defendant Tollard William husbandman 591768 591768 Tollard, William, of Depyng, husbandman 5
4888271 2323138 2323138 defendant Parker Thomas   591768 591768 Parker, Thomas, of Depyng, shepherd 0
4900624 2326835 2326835 defendant Holme John weaver 591768 591768 Holme, John, of Depyng, weaver 0
4900625 2326835 2326835 defendant Ive William butcher 591768 591768 Ive, William, of Depyng, butcher 1
4900626 2326835 2326835 defendant Baxter Ralph baker 591768 591768 Baxter, Ralph, of Depyng, baker 2
4912075 2330278 2330278 defendant Gryndill Stephen   591768 591768 Gryndill, Stephen, of Depyng 2
4934727 2337258 2337258 plaintiff Baker John   591768 591768 Baker, John, of Depyng 0
4972086 2348589 2348589 defendant Parys John husbandman 591768 591768 Parys, John, of Depyng, husbandman 3
5149876 2401093 2401093 defendant Underwode Thomas shoemaker 591768 591768 Underwode, Thomas, of Depyng, shoemaker 1
5222921 2422418 2422418 defendant Gryndell John husbandman 591768 591768 Gryndell, John, of Depyng, husbandman 1
5233166 2425287 2425287 defendant Bocher Richard butcher 591768 591768 Bocher, Richard, of Depyng, butcher 2
5339036 2456781 2456781 defendant Drangton William husbandman 591768 591768 Drangton, William, of Depyng, husbandman 1
5339037 2456781 2456781 defendant Tymyng William barker 591768 591768 Tymyng, William, of Depyng, barker 2
5441463 2487368 2487368 defendant Gryndell Thomas husbandman 591768 591768 Gryndell, Thomas, of Depyng, husbandman 2
5536989 2516056 2516056 defendant Thakker William yeoman 591768 591768 Thakker, William, of Depyng, yeoman 1
5544863 2518500 2518500 defendant Thakkar William yeoman 591768 591768 Thakkar, William, of Depyng, yeoman 3
5544865 2518500 2518500 defendant Bee Robert butcher 591768 591768 Bee, Robert, of Depyng, butcher 5
5581051 2529146 2529146 defendant Vyllers Edward esq 591768 591768 Vyllers, Edward, of Depyng, esq 0
5581053 2529147 2529147 defendant Vyllers Edward esq 591768 591768 Vyllers, Edward, of Depyng, esq 0
5606983 2537076 2537076 plaintiff Villers Edward esq 591768 591768 Villers, Edward, of Depyng, esq 0
5607008 2537086 2537086 plaintiff Vyllers Edward esq 591768 591768 Vyllers, Edward, of Depyng, esq 0
5607010 2537087 2537087 plaintiff Vyllers Edward esq 591768 591768 Vyllers, Edward, of Depyng, esq 0
5622742 2551042 2551042 defendant Toller William   591768 591768 Toller, William, of Depyng 1

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);