names

43 rows where place_id = 600460

✎ 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
3641126 1907672 1907672 defendant Golthorp William gent 600460 600460 Golthorp, William, of Shipley, gent 0
3675033 1918221 1918221 defendant Jannes Stephen husbandman 600460 600460 Jannes, Stephen, of Shipley, husbandman 0
3792402 1955485 1955485 defendant Goldthorp William gent 600460 600460 Goldthorp, William, of Shipley, gent 0
3821139 1964507 1964507 plaintiff Rogewey Thomas   600460 600460 Rogewey, Thomas, of Shipley 1
3822886 1965063 1965063 defendant Pytte Eliazabeth widow 600460 600460 Pytte, Eliazabeth, of Shipley, widow 0
4080074 2053179 2053179 defendant Juppe Richard husbandman 600460 600460 Juppe, Richard, of Shipley, husbandman 0
4091341 2057194 2057194 defendant Rawson William gent 600460 600460 Rawson, William, of Shipley, gent 0
4091342 2057194 2057194 defendant Brodley William laborer 600460 600460 Brodley, William, of Shipley, laborer 1
4091343 2057194 2057194 defendant Hobson Nicholas carpenter 600460 600460 Hobson, Nicholas, of Shipley, carpenter 2
4135934 2073185 2073185 defendant Pickerde William yeoman 600460 600460 Pickerde, William, of Shipley, yeoman 0
4135935 2073185 2073185 defendant Hill James yeoman 600460 600460 Hill, James, of Shipley, yeoman 1
4135936 2073185 2073185 defendant Swayne James chapman 600460 600460 Swayne, James, of Shipley, chapman 2
4169923 2084976 2084976 defendant Tempest Robert yeoman 600460 600460 Tempest, Robert, of Shipley, yeoman 1
4221353 2102968 2102968 defendant Rawson William gent 600460 600460 Rawson, William, of Shipley, gent 0
4235210 2107876 2107876 defendant Mascole James yeoman 600460 600460 Mascole, James, of Shipley, yeoman 2
4239312 2109369 2109369 defendant Whittacres Nicholas husbandman 600460 600460 Whittacres, Nicholas, of Shipley, husbandman 0
4242337 2110432 2110432 defendant Blake Thomas yeoman 600460 600460 Blake, Thomas, of Shipley, yeoman 0
4242341 2110434 2110434 defendant Mylward Roland yeoman 600460 600460 Mylward, Roland, of Shipley, yeoman 0
4242343 2110435 2110435 defendant Pryce Robert gent 600460 600460 Pryce, Robert, of Shipley, gent 0
4249556 2112837 2112837 defendant Rawson William yeoman 600460 600460 Rawson, William, of Shipley, yeoman 0
4249557 2112837 2112837 defendant Whitacres Nicholas yeoman 600460 600460 Whitacres, Nicholas, of Shipley, yeoman 1
4290317 2126590 2126590 defendant Weller Hugh yeoman 600460 600460 Weller, Hugh, of Shipley, yeoman 2
4310542 2133839 2133839 defendant Porman Gregory merchant 600460 600460 Porman, Gregory, of Shipley, merchant 2
4322351 2137889 2137889 defendant Rawson William gent 600460 600460 Rawson, William, of Shipley, gent 2
4349128 2146956 2146956 defendant Hunter William husbandman 600460 600460 Hunter, William, of Shipley, husbandman 0
4349130 2146956 2146956 defendant Fether Thomas husbandman 600460 600460 Fether, Thomas, of Shipley, husbandman 2
4349131 2146956 2146956 defendant Smyth William husbandman 600460 600460 Smyth, William, of Shipley, husbandman 3
4371626 2154906 2154906 defendant Atlee John husbandman 600460 600460 Atlee, John, of Shipley, husbandman 0
4380890 2158283 2158283 defendant Rawson William gent 600460 600460 Rawson, William, of Shipley, gent 0
4531644 2210158 2210158 plaintiff Perker Thomas   600460 600460 Perker, Thomas, of Shipley 0
4570769 2222430 2222430 defendant Parker Thomas   600460 600460 Parker, Thomas, of Shipley 0
4654813 2247383 2247383 defendant Sclater John carpenter 600460 600460 Sclater, John, of Shipley, carpenter 0
4745226 2279110 2279110 defendant Bothe William yeoman 600460 600460 Bothe, William, of Shipley, yeoman 0
4745229 2279111 2279111 defendant Bothe William yeoman 600460 600460 Bothe, William, of Shipley, yeoman 0
4746847 2279580 2279580 defendant Valyer William husbandman 600460 600460 Valyer, William, of Shipley, husbandman 1
4747725 2279843 2279843 defendant bothe William de husbandman 600460 600460 bothe, William de, of Shipley, husbandman 2
4877123 2319810 2319810 defendant Adynet John husbandman 600460 600460 Adynet, John, of Shipley, husbandman 1
4877124 2319810 2319810 defendant de More Richard husbandman 600460 600460 de More, Richard, of Shipley, husbandman 2
4974814 2349439 2349439 defendant Veske John gent 600460 600460 Veske, John, of Shipley, gent 1
5335043 2455549 2455549 defendant Eyres John fuller 600460 600460 Eyres, John, of Shipley, fuller 1
5444549 2488271 2488271 defendant Berowe Elizabeth widow 600460 600460 Berowe, Elizabeth, of Shipley, widow 0
5624098 2551485 2551485 plaintiff Lambe John   600460 600460 Lambe, John, of Shipley 0
5624110 2551488 2551488 plaintiff Lambe William   600460 600460 Lambe, William, of Shipley 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);