names

47 rows where place_id = 585971

✎ 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
3587606 1863770 1863770 defendant Ynglisse John clothier 585971 585971 Ynglisse, John, of Ryngwode, clothier 3
3588469 1864040 1864040 defendant Ede John yeoman 585971 585971 Ede, John, of Ryngwode, yeoman 1
3610419 1870918 1870918 defendant Tulse Robert tanner 585971 585971 Tulse, Robert, of Ryngwode, tanner 0
3611604 1871296 1871296 defendant Lauerence Thomas husbandman 585971 585971 Lauerence, Thomas, of Ryngwode, husbandman 0
3647076 1909478 1909478 defendant Bedylcombe Henry husbandman 585971 585971 Bedylcombe, Henry, of Ryngwode, husbandman 0
3720524 1932701 1932701 defendant Tulse Robert tanner 585971 585971 Tulse, Robert, of Ryngwode, tanner 0
3731742 1936157 1936157 defendant Tulse Robert tanner 585971 585971 Tulse, Robert, of Ryngwode, tanner 0
4433548 2175255 2175255 defendant Bouche Peter   585971 585971 Bouche, Peter, of Ryngwode 1
4454450 2186402 2186402 defendant Chercheyate John   585971 585971 Chercheyate, John, of Ryngwode 1
4469172 2191025 2191025 defendant Smyth Peter, senior   585971 585971 Smyth, Peter, senior, of Ryngwode 0
4552331 2216683 2216683 plaintiff Felde Richard (legal representative) 585971 585971 Felde, Richard, of Ryngwode, parson, executors of 0
4552337 2216684 2216684 plaintiff Felde Richard (legal representative) 585971 585971 Felde, Richard, of Ryngwode, parson, executors of 0
4622106 2237892 2237892 plaintiff Likyer John   585971 585971 Likyer, John, of Ryngwode 0
4669180 2256066 2256066 plaintiff Bocher Richard   585971 585971 Bocher, Richard, of Ryngwode 0
4669181 2256066 2256066 defendant Lane John shoemaker 585971 585971 Lane, John, of Ryngwode, shoemaker 0
4684407 2260730 2260730 plaintiff Rede Richard chaplain & master 585971 585971 Rede, Richard, of Ryngwode, chaplain & master 3
4684416 2260731 2260731 plaintiff Rede Richard chaplain 585971 585971 Rede, Richard, of Ryngwode, chaplain 3
4721854 2272168 2272168 defendant Barbour John barber 585971 585971 Barbour, John, of Ryngwode, barber 0
4736383 2276509 2276509 plaintiff Symmes Robert   585971 585971 Symmes, Robert, of Ryngwode 0
4747048 2279641 2279641 defendant Calton Robert yeoman 585971 585971 Calton, Robert, of Ryngwode, yeoman 0
4796658 2295106 2295106 defendant Tayllour Robert husbandman 585971 585971 Tayllour, Robert, of Ryngwode, husbandman 0
4799712 2296097 2296097 defendant Donge or Douge Richard carpenter 585971 585971 Donge or Douge, Richard, of Ryngwode, carpenter 0
4820596 2302515 2302515 defendant Pay John husbandman 585971 585971 Pay, John, of Ryngwode, husbandman 1
4829067 2305131 2305131 defendant Shepard John husbandman 585971 585971 Shepard, John, of Ryngwode, husbandman 0
4869728 2317501 2317501 defendant Sheppard John dyer 585971 585971 Sheppard, John, of Ryngwode, dyer 0
4916658 2331720 2331720 defendant Cheseman Thomas laborer 585971 585971 Cheseman, Thomas, of Ryngwode, laborer 4
4920038 2332779 2332779 defendant Toplane Richard husbandman 585971 585971 Toplane, Richard, of Ryngwode, husbandman 1
4934342 2337130 2337130 defendant Hyway Richard laborer 585971 585971 Hyway, Richard, of Ryngwode, laborer 1
4952973 2342851 2342851 defendant Hakepan John husbandman 585971 585971 Hakepan, John, of Ryngwode, husbandman 0
4959663 2344851 2344851 defendant Churcheyate John smith 585971 585971 Churcheyate, John, of Ryngwode, smith 0
4978343 2350472 2350472 defendant Holbeche John tucker 585971 585971 Holbeche, John, of Ryngwode, tucker 2
4993522 2354935 2354935 defendant Boket Thomas (legal representative) 585971 585971 Boket, Thomas, of Ryngwode, executrix of 0
5009329 2359619 2359619 defendant Fox John yeoman 585971 585971 Fox, John, of Ryngwode, yeoman 1
5102752 2387220 2387220 plaintiff Boket Walter   585971 585971 Boket, Walter, of Ryngwode 0
5207529 2417943 2417943 defendant Marchall John yeoman 585971 585971 Marchall, John, of Ryngwode, yeoman 3
5223828 2422654 2422654 defendant Style William yeoman 585971 585971 Style, William, of Ryngwode, yeoman 3
5277595 2438524 2438524 defendant Broket Philip husbandman 585971 585971 Broket, Philip, of Ryngwode, husbandman 0
5316870 2450129 2450129 plaintiff Ede John   585971 585971 Ede, John, of Ryngwode 3
5447995 2489284 2489284 defendant Ede James yeoman 585971 585971 Ede, James, of Ryngwode, yeoman 0
5450705 2490096 2490096 defendant Makerell John husbandman 585971 585971 Makerell, John, of Ryngwode, husbandman 0
5487870 2501259 2501259 plaintiff Jurden Thomas   585971 585971 Jurden, Thomas, of Ryngwode 3
5538574 2516544 2516544 defendant Foweracre Robert cordwainer 585971 585971 Foweracre, Robert, of Ryngwode, cordwainer 0
5552809 2520872 2520872 defendant Elworthe Robert dyer 585971 585971 Elworthe, Robert, of Ryngwode, dyer 0
5559343 2522698 2522698 defendant Peper William (legal representative) 585971 585971 Peper, William, of Ryngwode, yeoman, executrix of 0
5582580 2529620 2529620 defendant Barram William husbandman 585971 585971 Barram, William, of Ryngwode, husbandman 0
5582582 2529621 2529621 defendant Barram William husbandman 585971 585971 Barram, William, of Ryngwode, husbandman 0
5614284 2548252 2548252 plaintiff Edyngdon John de   585971 585971 Edyngdon, John de, of Ryngwode, parson 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);