names

94 rows where place_id = 589050

✎ 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
3596378 1866500 1866500 defendant Whyte John   589050 589050 Whyte, John, of Terlyng 0
3598917 1867288 1867288 defendant Osborn Robert husbandman 589050 589050 Osborn, Robert, of Terlyng, husbandman 1
3668804 1916181 1916181 defendant Bowsey John, junior carpenter 589050 589050 Bowsey, John, junior, of Terlyng, carpenter 0
3730046 1935637 1935637 defendant Knottysford James beer brewer 589050 589050 Knottysford, James, of Terlyng, beer brewer 0
3750231 1941989 1941989 defendant Rochester William gent 589050 589050 Rochester, William, of Terlyng, gent 0
3752780 1942794 1942794 defendant Knottisford James yeoman 589050 589050 Knottisford, James, of Terlyng, yeoman 0
3752994 1942869 1942869 plaintiff Salter Richard yeoman 589050 589050 Salter, Richard, of Terlyng, yeoman 0
3891512 1987426 1987426 defendant Franke Richard yeoman 589050 589050 Franke, Richard, of Terlyng, yeoman 0
3891513 1987426 1987426 defendant Clerke Thomas yeoman 589050 589050 Clerke, Thomas, of Terlyng, yeoman 1
4044865 2040614 2040614 defendant Frenche John yeoman 589050 589050 Frenche, John, of Terlyng, yeoman 0
4090299 2056815 2056815 defendant Richardes Geoffrey yeoman 589050 589050 Richardes, Geoffrey, of Terlyng, yeoman 2
4414539 2169450 2169450 plaintiff Dunnyng John   589050 589050 Dunnyng, John, of Terlyng 0
4468268 2190747 2190747 defendant Inhewe John   589050 589050 Inhewe, John, of Terlyng 0
4497657 2199914 2199914 defendant Dyere William that was servant of William 589050 589050 Dyere, William that was servant of William, of Terlyng 0
4521656 2207103 2207103 plaintiff Geney Alice   589050 589050 Geney, Alice, of Terlyng, formerly wife of Robert 0
4521658 2207104 2207104 plaintiff Geney Alice   589050 589050 Geney, Alice, of Terlyng, formerly wife of Robert 0
4523927 2207817 2207817 plaintiff Herst William butcher 589050 589050 Herst, William, of Terlyng, butcher 0
4528103 2209071 2209071 defendant Smyth Richard   589050 589050 Smyth, Richard, of Terlyng 0
4547134 2215037 2215037 defendant Waryner Thomas   589050 589050 Waryner, Thomas, of Terlyng 0
4549746 2215858 2215858 defendant Herst William   589050 589050 Herst, William, of Terlyng 1
4555566 2217670 2217670 plaintiff Herst William butcher 589050 589050 Herst, William, of Terlyng, butcher 0
4564297 2220404 2220404 defendant Dyere William   589050 589050 Dyere, William, of Terlyng 0
4577730 2224540 2224540 defendant Dene John   589050 589050 Dene, John, of Terlyng 1
4586280 2227127 2227127 defendant Breggeman John   589050 589050 Breggeman, John, of Terlyng 2
4588188 2227699 2227699 defendant Briggeman John   589050 589050 Briggeman, John, of Terlyng 7
4609345 2234022 2234022 defendant Sterre Robert weaver 589050 589050 Sterre, Robert, of Terlyng, weaver 0
4647712 2245389 2245389 defendant Smyth Richard   589050 589050 Smyth, Richard, of Terlyng 0
4658607 2248569 2248569 defendant Grenehell John husbandman 589050 589050 Grenehell, John, of Terlyng, husbandman 1
4665063 2250550 2250550 defendant Dyere William yeoman 589050 589050 Dyere, William, of Terlyng, yeoman 0
4665065 2250551 2250551 defendant Hert Roger yeoman 589050 589050 Hert, Roger, of Terlyng, yeoman 0
4669214 2256075 2256075 defendant Russell John husbandman 589050 589050 Russell, John, of Terlyng, husbandman 4
4669220 2256076 2256076 defendant Berden Nicholas husbandman 589050 589050 Berden, Nicholas, of Terlyng, husbandman 4
4694401 2263748 2263748 defendant Berden Nicholas husbandman 589050 589050 Berden, Nicholas, of Terlyng, husbandman 2
4728704 2274214 2274214 defendant Briggeman John husbandman 589050 589050 Briggeman, John, of Terlyng, husbandman 3
4730943 2274876 2274876 defendant Smyth Richard smith 589050 589050 Smyth, Richard, of Terlyng, smith 2
4747395 2279741 2279741 defendant Hert Roger (legal representative) 589050 589050 Hert, Roger, of Terlyng, executor of 4
4756660 2282449 2282449 plaintiff Bernolf William   589050 589050 Bernolf, William, of Terlyng 0
4766466 2285503 2285503 defendant Taillour Simon husbandman 589050 589050 Taillour, Simon, of Terlyng, husbandman 2
4778574 2289284 2289284 plaintiff Bernolf William   589050 589050 Bernolf, William, of Terlyng 0
4778575 2289284 2289284 defendant Warner Thomas, junior husbandman 589050 589050 Warner, Thomas, junior, of Terlyng, husbandman 0
4788463 2292458 2292458 plaintiff Herfeld Roger   589050 589050 Herfeld, Roger, of Terlyng 0
4825916 2304138 2304138 defendant Doreme Henry   589050 589050 Doreme, Henry, of Terlyng, cirotecarius or glove maker 0
4875461 2319279 2319279 defendant Chertesey William esq 589050 589050 (Chertesey, William, of Terlyng, esq 1
4882392 2321405 2321405 plaintiff Rouchestre John   589050 589050 Rouchestre, John, of Terlyng 0
4885517 2322353 2322353 defendant Auncell John husbandman 589050 589050 Auncell, John, of Terlyng, husbandman 0
4885528 2322355 2322355 defendant Auncell John husbandman 589050 589050 Auncell, John, of Terlyng, husbandman 0
4885557 2322363 2322363 defendant Rouchester John, junior husbandman 589050 589050 Rouchester, John, junior, of Terlyng, husbandman 0
4952525 2342714 2342714 defendant Dyer William   589050 589050 Dyer, William, of Terlyng 0
4981077 2351272 2351272 defendant Rouchestre John husbandman 589050 589050 Rouchestre, John, of Terlyng, husbandman 0
4995996 2355653 2355653 defendant Warner William yeoman 589050 589050 Warner, William, of Terlyng, yeoman 0
5005668 2358556 2358556 plaintiff Rouchestre John (legal representative) 589050 589050 Rouchestre, John, of Terlyng, executors of 0
5016613 2361753 2361753 plaintiff Bury Robert   589050 589050 Bury, Robert, of Terlyng 0
5016619 2361754 2361754 plaintiff Bury Robert   589050 589050 Bury, Robert, of Terlyng 0
5022309 2363419 2363419 defendant Parker John gent 589050 589050 Parker, John, of Terlyng, gent 1
5050713 2371839 2371839 defendant Rouchestre John husbandman 589050 589050 Rouchestre, John, of Terlyng, husbandman 2
5077650 2379812 2379812 defendant Rowchester Robert, junior yeoman 589050 589050 Rowchester, Robert, junior, of Terlyng, yeoman 0
5077651 2379812 2379812 defendant Rowchester John yeoman 589050 589050 Rowchester, John, of Terlyng, yeoman 1
5079062 2380226 2380226 plaintiff Bury Robert   589050 589050 Bury, Robert, of Terlyng 0
5089807 2383393 2383393 defendant Rowchestre Robert, senior yeoman 589050 589050 Rowchestre, Robert, senior, of Terlyng, yeoman 0
5138516 2397766 2397766 defendant Breton John husbandman 589050 589050 Breton, John, of Terlyng, husbandman 2
5138517 2397766 2397766 defendant Brigge alias Bonde John husbandman 589050 589050 Brigge alias Bonde, John, of Terlyng, husbandman 3
5138518 2397766 2397766 defendant Benet alias Warde Richard husbandman 589050 589050 Benet alias Warde, Richard, of Terlyng, husbandman 4
5159276 2403828 2403828 defendant Breton John husbandman 589050 589050 Breton, John, of Terlyng, husbandman 2
5159277 2403828 2403828 defendant Brigge John husbandman 589050 589050 Brigge, John, of Terlyng, husbandman 3
5159278 2403828 2403828 defendant Benet Richard husbandman 589050 589050 Benet, Richard, of Terlyng, husbandman 4
5159368 2403855 2403855 defendant Rouchestre John yeoman 589050 589050 Rouchestre, John, of Terlyng, yeoman 0
5174528 2408251 2408251 defendant Rouchestre John yeoman 589050 589050 Rouchestre, John, of Terlyng, yeoman 0
5214460 2419962 2419962 defendant Bonsy or Bousy Thomas husbandman 589050 589050 Bonsy or Bousy, Thomas, of Terlyng, husbandman 1
5321857 2451608 2451608 defendant Dyer John clerk 589050 589050 Dyer, John, of Terlyng, clerk 0
5321858 2451608 2451608 defendant Rouchester Robert gent 589050 589050 together with Rouchester, Robert, of Terlyng, gent 1
5321859 2451608 2451608 defendant Graunte Joh yeoman 589050 589050 Graunte, Joh, of Terlyng, yeoman 2
5321860 2451608 2451608 defendant Lyon William barber 589050 589050 Lyon, William, of Terlyng, barber 3
5327830 2453391 2453391 defendant Brigge John laborer 589050 589050 Brigge, John, of Terlyng, laborer 0
5339084 2456798 2456798 defendant Rouchester Robert gent 589050 589050 Rouchester, Robert, of Terlyng, gent 0
5339085 2456798 2456798 defendant Graunte John yeoman 589050 589050 Graunte, John, of Terlyng, yeoman 1
5339086 2456798 2456798 defendant Lyon William yeoman 589050 589050 Lyon, William, of Terlyng, yeoman 2
5339088 2456798 2456798 defendant Rouchester Gilbert barber 589050 589050 Rouchester, Gilbert, of Terlyng, barber 4
5339089 2456798 2456798 defendant Dyer John clerk 589050 589050 Dyer, John, of Terlyng, clerk 5
5353179 2461070 2461070 defendant Bemont Richard butcher 589050 589050 Bemont, Richard, of Terlyng, butcher 0
5356020 2461964 2461964 defendant Bousy or Bonsy Robert husbandman 589050 589050 Bousy or Bonsy, Robert, of Terlyng, husbandman 7
5375969 2468076 2468076 plaintiff Rouchester Robert gent 589050 589050 Rouchester, Robert, of Terlyng, gent 0
5375970 2468076 2468076 defendant Byrchard John Chaplain 589050 589050 Byrchard, John, of Terlyng, Chaplain 0
5375971 2468076 2468076 defendant Browne William smith 589050 589050 Browne, William, of Terlyng, smith 1
5502079 2505571 2505571 defendant Osbern Robert husbandman 589050 589050 Osbern, Robert, of Terlyng, husbandman 1
5526079 2512734 2512734 defendant Howman William yeoman 589050 589050 Howman, William, of Terlyng, yeoman 0
5526080 2512734 2512734 defendant Gebon Robert yeoman 589050 589050 Gebon, Robert, of Terlyng, yeoman 1
5539645 2516879 2516879 defendant Colyns John gent 589050 589050 Colyns, John, of Terlyng, gent 3
5578744 2528415 2528415 defendant Turke John yeoman 589050 589050 Turke, John, of Terlyng, yeoman 1
5582062 2529456 2529456 defendant Chapman Henry husbandman 589050 589050 Chapman, Henry, of Terlyng, husbandman 0
5582299 2529538 2529538 defendant Bosy John, senior carpenter 589050 589050 Bosy, John, senior, of Terlyng, carpenter 0
5590750 2532080 2532080 defendant Rouchester John yeoman 589050 589050 Rouchester, John, of Terlyng, yeoman 0
5594117 2533136 2533136 defendant Turk John yeoman 589050 589050 Turk, John, of Terlyng, yeoman 1
5603685 2536021 2536021 defendant Fanner John yeoman 589050 589050 Fanner, John, of Terlyng, yeoman 0
5630354 2553500 2553500 defendant atte Noke John husbandman 589050 589050 atte Noke, John, of Terlyng, 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);