names

40 rows where case_id = 2343313

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4954505 2343313 2343313 plaintiff Stanley Thomas esq   Stanley, Thomas, esq 0
4954506 2343313 2343313 defendant Vernay John clerk 587826 587826 Vernay, John, of Lychefeld, clerk 0
4954507 2343313 2343313 defendant Joly John clerk 587826 587826 Joly, John, of Lychefeld, clerk 1
4954508 2343313 2343313 defendant SayntJon William smith 587826 587826 SayntJon, William, of Lychefeld, smith 2
4954509 2343313 2343313 defendant Couper William cooper 587826 587826 Couper, William, of Lychefeld, cooper 3
4954510 2343313 2343313 defendant Huchons John dyer 587826 587826 Huchons, John, of Lychefeld, dyer 4
4954511 2343313 2343313 defendant Botteler Thomas yeoman 591118 591118 Botteler, Thomas, of Longdon, yeoman 5
4954512 2343313 2343313 defendant Assh William currier 587826 587826 Assh, William, of Lychefeld, currier 6
4954513 2343313 2343313 defendant Assh John shoemaker 587826 587826 Assh, John, of Lychefeld, shoemaker 7
4954514 2343313 2343313 defendant Bryde Robert mercer 587826 587826 Bryde, Robert, of Lychefeld, mercer 8
4954515 2343313 2343313 defendant Waleys Richard weaver 587826 587826 Waleys, Richard, of Lychefeld, weaver 9
4954516 2343313 2343313 defendant Wedon John shoemaker 587826 587826 Wedon, John, of Lychefeld, shoemaker 10
4954517 2343313 2343313 defendant Shawe John dyer 587826 587826 Shawe, John, of Lychefeld, dyer 11
4954518 2343313 2343313 defendant Grene Thomas tailor 587826 587826 Grene, Thomas, of Lychefeld, tailor 12
4954519 2343313 2343313 defendant Skynner Thomas skinner 587826 587826 Skynner, Thomas, of Lychefeld, skinner 13
4954520 2343313 2343313 defendant Turnour John fletcher 587826 587826 Turnour, John, of Lychefeld, fletcher 14
4954521 2343313 2343313 defendant Couper Nicholas cooper 587826 587826 Couper, Nicholas, of Lychefeld, cooper 15
4954522 2343313 2343313 defendant Buggyng John   587826 587826 Buggyng, John, of Lychefeld, groom 16
4954523 2343313 2343313 defendant Webbe Robert yeoman 826901 826901 Webbe, Robert, of Edyhale, yeoman 17
4954524 2343313 2343313 defendant Webbe John husbandman 826902 826902 Webbe, John, of Homourwych, husbandman 18
4954525 2343313 2343313 defendant Swenfen Thomas, junior gent 826903 826903 Swenfen, Thomas, junior, of Swenfen, gent 19
4954526 2343313 2343313 defendant Grys John barker 587826 587826 Grys, John, of Lychefeld, barker 20
4954527 2343313 2343313 defendant Merston John   587826 587826 Merston, John, of Lychefeld, cap maker 21
4954528 2343313 2343313 defendant Darby John shoemaker 587826 587826 Darby, John, of Lychefeld, shoemaker 22
4954529 2343313 2343313 defendant Barbour William barber 587826 587826 Barbour, William, of Lychefeld, barber 23
4954530 2343313 2343313 defendant Aslome Hugh sherman 587826 587826 Aslome, Hugh, of Lychefeld, sherman 24
4954531 2343313 2343313 defendant Dykman Richard tailor 587826 587826 Dykman, Richard, of Lychefeld, tailor 25
4954532 2343313 2343313 defendant Jayler John yeoman 587826 587826 Jayler, John, of Lychefeld, yeoman 26
4954533 2343313 2343313 defendant Butteler Nicholas weaver 587826 587826 Butteler, Nicholas, of Lychefeld, weaver 27
4954534 2343313 2343313 defendant Yoxall John husbandman 587826 587826 Yoxall, John, of Lychefeld, husbandman 28
4954535 2343313 2343313 defendant Heuster Richard dyer 587826 587826 Heuster, Richard, of Lychefeld, dyer 29
4954536 2343313 2343313 defendant Heuster John yeoman 587826 587826 Heuster, John, of Lychefeld, yeoman 30
4954537 2343313 2343313 defendant Willysford John draper 587826 587826 Willysford, John, of Lychefeld, draper 31
4954538 2343313 2343313 defendant Brakley John yeoman 587826 587826 Brakley, John, of Lychefeld, yeoman 32
4954539 2343313 2343313 defendant Hardyng John yeoman 587826 587826 Hardyng, John, of Lychefeld, yeoman 33
4954540 2343313 2343313 defendant Leycroft John skinner 587826 587826 Leycroft, John, of Lychefeld, skinner 34
4954541 2343313 2343313 defendant Fourbour Edmund furbisher 587826 587826 Fourbour, Edmund, of Lychefeld, furbisher 35
4954542 2343313 2343313 defendant Heth John hosier 587826 587826 Heth, John, of Lychefeld, hosier 36
4954543 2343313 2343313 defendant Walker Robert walker 587826 587826 Walker, Robert, of Lychefeld, walker 37
4954544 2343313 2343313 defendant Nowell John saddler 587826 587826 Nowell, John, of Lychefeld, saddler 38

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);