names

43 rows where place_id = 588734

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591538 1864979 1864979 defendant Kenstone Robert   588734 588734 Kenstone, Robert, of Woxbrigge, Middx, tallow chandler 2
3591550 1864981 1864981 defendant Kenston Robert   588734 588734 Kenston, Robert, of Woxbrigge, Middx, tallow chandler 3
3595408 1866197 1866197 defendant Melton John plumber 588734 588734 Melton, John, of Woxbrigge, Middx, plumber 0
3595410 1866198 1866198 defendant Melton John plumber 588734 588734 Melton, John, of Woxbrigge, Middx, plumber 0
3621856 1874377 1874377 defendant Clynton Richard (legal representative) 588734 588734 Clynton, Richard, of Woxbrigge, Middx, gent, executors of 0
3628303 1903715 1903715 defendant Lenaker Robert dyer 588734 588734 Lenaker, Robert, of Woxbrigge, Middx, dyer 1
3876334 1982329 1982329 defendant Harrys Isabel widow 588734 588734 Harrys, Isabel, of Woxbrigge, Middx, widow 1
4673403 2257319 2257319 defendant Lamborne Nicholas yeoman 588734 588734 Lamborne, Nicholas, of Woxbrigge, Middx, yeoman 2
4674709 2257701 2257701 defendant Catesden Robert husbandman 588734 588734 Catesden, Robert, of Woxbrigge, Middx, husbandman 0
4674714 2257703 2257703 defendant Gatesden Robert husbandman 588734 588734 Gatesden, Robert, of Woxbrigge, Middx, husbandman 0
4674943 2257773 2257773 defendant Clarence William chapman 588734 588734 Clarence, William, of Woxbrigge, Middx, chapman 0
4677507 2258579 2258579 defendant Stafford Thomas yeoman 588734 588734 Stafford, Thomas, of Woxbrigge, Middx, yeoman 1
4730223 2274655 2274655 defendant Beyer Walter dyer 588734 588734 Beyer, Walter, of Woxbrigge, Middx, dyer 0
4742784 2278397 2278397 defendant Gromet Thomas, senior butcher 588734 588734 Gromet, Thomas, senior, of Woxbrigge, Middx, butcher 0
4742786 2278398 2278398 defendant Gromett Thomas, senior butcher 588734 588734 Gromett, Thomas, senior, of Woxbrigge, Middx, butcher 0
4747459 2279759 2279759 defendant Culverhous Thomas husbandman 588734 588734 Culverhous, Thomas, of Woxbrigge, Middx, husbandman 0
4791099 2293314 2293314 defendant Clarence William chapman 588734 588734 Clarence, William, of Woxbrigge, Middx, chapman 0
4803071 2297147 2297147 defendant Colteman John, senior carpenter 588734 588734 Colteman, John, senior, of Woxbrigge, Middx, carpenter 0
4823689 2303500 2303500 defendant Ravell Thomas husbandman 588734 588734 Ravell, Thomas, of Woxbrigge, Middx, husbandman 2
5016347 2361673 2361673 defendant Staunton Richard pinner 588734 588734 Staunton, Richard, of Woxbrigge, Middx, pinner 0
5155806 2402862 2402862 defendant Good John yeoman 588734 588734 Good, John, of Woxbrigge, Middx, yeoman 0
5212104 2419280 2419280 defendant Middelton Robert tiler 588734 588734 Middelton, Robert, of Woxbrigge, Middx, tiler 1
5221212 2421903 2421903 defendant Kynton Walter yeoman 588734 588734 Kynton, Walter, of Woxbrigge, Middx, yeoman 3
5273253 2437245 2437245 defendant Langham Richard butcher 588734 588734 Langham, Richard, of Woxbrigge, Middx, butcher 1
5278488 2438816 2438816 defendant Mulso Henry chapman 588734 588734 Mulso, Henry, of Woxbrigge, Middx, chapman 0
5278491 2438817 2438817 defendant Mulso Henry chapman 588734 588734 Mulso, Henry, of Woxbrigge, Middx, chapman 0
5289070 2441812 2441812 defendant Langham Richard butcher 588734 588734 Langham, Richard, of Woxbrigge, Middx, butcher 1
5316713 2450086 2450086 defendant Oxston John husbandman 588734 588734 Oxston, John, of Woxbrigge, Middx, husbandman 3
5321372 2451485 2451485 defendant Asshby alias Tommes Thomas gent 588734 588734 Asshby alias Tommes, Thomas, of Woxbrigge, Middx, gent 0
5321378 2451486 2451486 defendant Asshby alias Tommes Thomas gent 588734 588734 Asshby alias Tommes, Thomas, of Woxbrigge, Middx, gent 0
5321904 2451620 2451620 defendant Langham Richard ironmonger 588734 588734 Langham, Richard, of Woxbrigge, Middx, butcherPa-, William,of London, ironmonger 2
5333935 2455224 2455224 defendant Oxston John husbandman 588734 588734 Oxston, John, of Woxbrigge, Middx, husbandman 3
5334724 2455449 2455449 defendant Crippes John yeoman 588734 588734 Crippes, John, of Woxbrigge, Middx, yeoman 0
5334727 2455450 2455450 defendant Crippes John yeoman 588734 588734 Crippes, John, of Woxbrigge, Middx, yeoman 0
5335505 2455690 2455690 defendant Annesley James yeoman 588734 588734 Annesley, James, of Woxbrigge, Middx, yeoman 0
5337168 2456188 2456188 defendant Elkyngton Richard capper 588734 588734 Elkyngton, Richard, of Woxbrigge, Middx, capper 0
5382683 2470107 2470107 defendant Brokyng John brasier 588734 588734 Brokyng, John, of Woxbrigge, Middx, brasier 3
5392847 2473027 2473027 defendant Brokyng John brasier 588734 588734 Brokyng, John, of Woxbrigge, Middx, brasier 3
5421824 2481463 2481463 defendant Golofer William dyer 588734 588734 Golofer, William, of Woxbrigge, Middx, dyer 2
5421828 2481464 2481464 defendant Golofer William dyer 588734 588734 Golofer, William, of Woxbrigge, Middx, dyer 2
5455169 2491464 2491464 defendant Brokyn John innholder 588734 588734 Brokyn, John, of Woxbrigge, Middx, innholder 1
5543041 2517940 2517940 defendant Kyllyngworth Thomas gent 588734 588734 Kyllyngworth, Thomas, of Woxbrigge, Middx, gent 2
5586249 2530743 2530743 defendant Harrys John grocer 588734 588734 Harrys, John, of Woxbrigge, Middx, innholder, or of London, grocer 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);