names

44 rows where place_id = 602413

✎ 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
3650024 1910376 1910376 defendant Edmondys Thomas clerk 602413 602413 Edmondys, Thomas, of Barnby, clerk 0
3678217 1919241 1919241 defendant Laghton Thomas laborer 602413 602413 Laghton, Thomas, of Barnby, laborer 1
3703681 1927432 1927432 defendant Thornton Thomas husbandman 602413 602413 Thornton, Thomas, of Barnby, husbandman 0
3733207 1936618 1936618 defendant Thornton Thomas husbandman 602413 602413 Thornton, Thomas, of Barnby, husbandman 0
3733463 1936708 1936708 plaintiff Warner Edmund   602413 602413 Warner, Edmund, of Barnby 2
3733464 1936708 1936708 defendant Dey William carpenter 602413 602413 Dey, William, of Barnby, carpenter 0
3748705 1941524 1941524 defendant Barnby Charles esq 602413 602413 Barnby, Charles, of Barnby, esq 0
3763141 1946104 1946104 defendant Barnby Charles esq 602413 602413 Barnby, Charles, of Barnby, esq 0
4132779 2072049 2072049 defendant Watson George miller 602413 602413 Watson, George, of Barnby, miller 2
4156695 2080419 2080419 defendant Watson George miller 602413 602413 Watson, George, of Barnby, miller 2
4311234 2134075 2134075 defendant Andrew George laborer 602413 602413 Andrew, George, of barnby, laborer 3
4352883 2148234 2148234 defendant Holland William yeoman 602413 602413 Holland, William, of Barnby, yeoman 0
4507512 2202809 2202809 defendant Doket Richard   602413 602413 Doket, Richard, of Barnby 0
4629754 2240228 2240228 defendant Blake William   602413 602413 Blake, William, of Barnby 0
4642568 2243945 2243945 defendant Hambald Robert   602413 602413 Hambald, Robert, of Barnby 2
4672790 2257130 2257130 defendant Wryght Richard husbandman 602413 602413 Wryght, Richard, of Barnby, husbandman 1
4673127 2257236 2257236 defendant Paynell John esq 602413 602413 Paynell, John, of Barnby, esq 0
4730263 2274670 2274670 defendant Upton John   602413 602413 Upton, John, of Barnby, bailiff 1
4734833 2276051 2276051 defendant Mason William   602413 602413 Mason, William, of Barnby, mason 0
4790497 2293120 2293120 defendant atte Touneshende William husbandman 602413 602413 atte Touneshende, William, of Barnby, husbandman 0
4804936 2297748 2297748 defendant Brayt Thomas husbandman 602413 602413 Brayt, Thomas, of Barnby, husbandman 0
4815628 2300995 2300995 defendant Bradshawe Richard husbandman 602413 602413 Bradshawe, Richard, of Barnby, husbandman 1
4840412 2308543 2308543 defendant Lepar Robert husbandman 602413 602413 Lepar, Robert, of Barnby, husbandman 2
4840414 2308543 2308543 defendant Alen Robert husbandman 602413 602413 Alen, Robert, of Barnby, husbandman 4
4840415 2308543 2308543 defendant Wayt Edmund husbandman 602413 602413 Wayt, Edmund, of Barnby, husbandman 5
4840417 2308543 2308543 defendant Lokewod John husbandman 602413 602413 Lokewod, John, of Barnby, husbandman 7
4842562 2309210 2309210 defendant Tounende William husbandman 602413 602413 Tounende, William, of Barnby, husbandman 1
4886532 2322650 2322650 defendant Upton John   602413 602413 Upton, John, of Barnby, bailiff 0
4887629 2322964 2322964 defendant Barnby John husbandman 602413 602413 Barnby, John, of Barnby, husbandman 3
4887679 2322976 2322976 defendant Jelotte John tailor 602413 602413 Jelotte, John, of Barnby, tailor 1
4891292 2324004 2324004 defendant Upton John   602413 602413 Upton, John, of Barnby, bailiff 0
4903231 2327619 2327619 defendant Gelot John tailor 602413 602413 Gelot, John, of Barnby, tailor 0
4957267 2344138 2344138 defendant Barnby Thomas gent 602413 602413 Barnby, Thomas, of Barnby, gent 1
4957272 2344139 2344139 defendant Barnby Thomas gent 602413 602413 Barnby, Thomas, of Barnby, gent 1
4976912 2350047 2350047 defendant Barnby William yeoman 602413 602413 Barnby, William, of Barnby, yeoman 1
5019113 2362484 2362484 defendant Wyllughby Thomas husbandman 602413 602413 Wyllughby, Thomas, of Barnby, husbandman 2
5124649 2393682 2393682 defendant Bradshawe Richard yeoman 602413 602413 Bradshawe, Richard, of Barnby, yeoman 1
5163006 2404908 2404908 defendant Thomlynson John husbandman 602413 602413 Thomlynson, John, of Barnby on Moor, husbandman 1
5292864 2442905 2442905 defendant Kynder John yeoman 602413 602413 Kynder, John, of Barnby, yeoman 0
5513083 2508946 2508946 defendant Cotes Stephen husbandman 602413 602413 Cotes, Stephen, of Barnby, husbandman 0
5513084 2508946 2508946 defendant Cotes William husbandman 602413 602413 Cotes, William, of Barnby, husbandman 1
5513085 2508946 2508946 defendant Cotes John laborer 602413 602413 Cotes, John, of Barnby, laborer 2
5567605 2525098 2525098 defendant Hobbes William husbandman 602413 602413 Hobbes, William, of Barnby, husbandman 4
5575666 2527479 2527479 defendant Broun John tailor 602413 602413 Broun, John, of Barnby, tailor 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);