names

42 rows where place_id = 681460

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4044995 2040666 2040666 defendant Breaton William yeoman 681460 681460 Breaton, William, of Wombwell, yeoman 1
4044996 2040666 2040666 defendant Sacker Robert yeoman 681460 681460 Sacker, Robert, of Wombwell, yeoman 2
4044997 2040666 2040666 defendant Stones Peter yeoman 681460 681460 Stones, Peter, of Wombwell, yeoman 3
4075313 2051473 2051473 defendant Sacker Robert cordwainer 681460 681460 Sacker, Robert, of Wombwell, cordwainer 1
4079071 2052815 2052815 defendant Horsefull Edward husbandman 681460 681460 Horsefull, Edward, of Wombwell, husbandman 1
4079073 2052815 2052815 defendant Brayton William husbandman 681460 681460 Brayton, William, of Wombwell, husbandman 3
4086463 2055442 2055442 defendant Kettilwell William badger or pedlar 681460 681460 Kettilwell, William, of Wombwell, badger or pedlar 0
4086464 2055442 2055442 defendant Secker Robert shoemaker 681460 681460 Secker, Robert, of Wombwell, shoemaker 1
4088618 2056230 2056230 defendant Hycke Lawrence smith 681460 681460 Hycke, Lawrence, of Wombwell, smith 3
4089570 2056558 2056558 defendant Clarke Henry yeoman 681460 681460 Clarke, Henry, of Wombwell, yeoman 1
4102627 2061239 2061239 defendant Tempest Francis gent 681460 681460 Tempest, Francis, of Wombwell, gent 0
4113725 2065192 2065192 defendant Rowlyngyll alias Kettlewell William husbandman 681460 681460 Rowlyngyll alias Kettlewell, William, of Wombwell, husbandman 2
4113747 2065201 2065201 defendant Wylton Richard yeoman 681460 681460 Wylton, Richard, of Wombwell, yeoman 0
4128940 2070650 2070650 defendant Kettlewell William husbandman 681460 681460 Kettlewell, William, of Wombwell, husbandman 0
4184578 2090115 2090115 defendant Beamond William yeoman 681460 681460 Beamond, William, of Wombwell, or of Darfyld, yeoman 0
4221293 2102946 2102946 defendant Wombwell William gent 681460 681460 Wombwell, William, of Wombwell, or of Ealand juxta Crowle, Lincs, gent 0
4222238 2103270 2103270 defendant Wombwell William gent 681460 681460 Wombwell, William, of Wombwell, gent 0
4223242 2103620 2103620 defendant Wombwell William gent 681460 681460 Wombwell, William, of Wombwell, gent 0
4230060 2106006 2106006 defendant Nelson Nicholas   681460 681460 Nelson, Nicholas, of Wombwell, rope maker 0
4230061 2106006 2106006 defendant Garleck John husbandman 681460 681460 Garleck, John, of Wombwell, or of Aldam House, husbandman 1
4247521 2112159 2112159 defendant Wombwell William gent 681460 681460 Wombwell, William, of Wombwell, gent 0
4249256 2112735 2112735 defendant Wombwell William gent 681460 681460 Wombwell, William, of Wombwell, gent 0
4252592 2113858 2113858 defendant Micklethwayte Roger yeoman 681460 681460 Micklethwayte, Roger, of Wombwell, yeoman 0
4280008 2122920 2122920 defendant Wombwell Thomas esq 681460 681460 Wombwell, Thomas, of Wombwell, esq 0
4281007 2123258 2123258 defendant Wombwell William   681460 681460 Wombwell, William, of Wombwell, gent, son of Thomas 0
4307085 2132612 2132612 defendant Wombwell Thomas esq 681460 681460 Wombwell, Thomas, of Wombwell, esq 0
4316798 2135993 2135993 defendant Wulnes Robert butcher 681460 681460 Wulnes Robert, of Wombwell, butcher 3
4391919 2161922 2161922 defendant Haldsworth John husbandman 681460 681460 Haldsworth, John, of Wombwell, husbandman 0
4391920 2161922 2161922 defendant Armitage John yeoman 681460 681460 Armitage, John, of Wombwell, yeoman 1
4400755 2164840 2164840 defendant Scolefeild Richard husbandman 681460 681460 Scolefeild, Richard, of Wombwell, husbandman 0
4400757 2164841 2164841 defendant Tayler William yeoman 681460 681460 Tayler, William, of Wombwell, yeoman 0
4401425 2165071 2165071 defendant Scolefeild Richard husbandman 681460 681460 Scolefeild, Richard, of Wombwell, husbandman 0
4402488 2165417 2165417 defendant Hyckes Isabel widow 681460 681460 Hyckes, Isabel, of Wombwell, widow 0
4402489 2165417 2165417 defendant Hyckes Lawrence yeoman 681460 681460 Hyckes, Lawrence, of Wombwell, yeoman 1
4555506 2217653 2217653 defendant Turton William   681460 681460 Turton, William, of Wombwell 2
4755560 2282119 2282119 defendant Wombwell Reginald de yeoman 681460 681460 Wombwell, Reginald de, of Wombwell, yeoman 1
5051830 2372162 2372162 defendant bythewater William husbandman 681460 681460 bythewater, William, of Wombwell, husbandman 0
5051832 2372162 2372162 defendant Frape John butcher 681460 681460 Frape, John, of Wombwell, butcher 2
5097193 2385614 2385614 plaintiff Taillior John (legal representative) 681460 681460 Taillior, John, of Wombwell, executors of 0
5228609 2423976 2423976 defendant Wombwell alias Taillour Thomas gent 681460 681460 Wombwell alias Taillour, Thomas, of Wombwell, gent 1
5370737 2466437 2466437 defendant Taillour John draper 681460 681460 Taillour, John, of Wombwell, draper 0
5370740 2466438 2466438 defendant Taillour John draper 681460 681460 Taillour, John, of Wombwell, draper 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);