names

44 rows where place_id = 589596

✎ 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
3598109 1867038 1867038 defendant Hayteley William barker 589596 589596 Hayteley, William, of Yoxhale, barker 0
3622369 1874533 1874533 defendant Onerley or Oveley Thomas husbandman 589596 589596 Onerley or Oveley, Thomas, of Yoxhale, husbandman 0
4536810 2211785 2211785 plaintiff Stokley William   589596 589596 Stokley, William, of Yoxhale 0
4547918 2215284 2215284 plaintiff Caumpeden John   589596 589596 Caumpeden, John, of Yoxhale 0
4576306 2224095 2224095 defendant Jolypere Roger   589596 589596 Jolypere, Roger, of Yoxhale 0
4650870 2246275 2246275 defendant Rous John   589596 589596 Rous, John, of Yoxhale 2
4771038 2286922 2286922 plaintiff Rous Henry   589596 589596 Rous, Henry, of Yoxhale 0
4793670 2294133 2294133 defendant Herne John yeoman 589596 589596 Herne, John, of Yoxhale, yeoman 0
4820795 2302585 2302585 defendant Hervy John yeoman 589596 589596 Hervy, John, of Yoxhale, yeoman 0
4820796 2302585 2302585 defendant Hervy William yeoman 589596 589596 Hervy, William, of Yoxhale, yeoman 1
4820799 2302586 2302586 defendant Hervy William yeoman 589596 589596 Hervy, William, of Yoxhale, yeoman 0
4820849 2302610 2302610 defendant Campden John weaver 589596 589596 Campden, John, of Yoxhale, weaver 3
4820850 2302610 2302610 defendant Scottie John laborer 589596 589596 Scottie, John, of Yoxhale, laborer 4
4820851 2302610 2302610 defendant Broun Thomas husbandman 589596 589596 Broun, Thomas, of Yoxhale, husbandman 5
4820858 2302612 2302612 defendant Aleyn pater husbandman 589596 589596 Aleyn, pater, of Yoxhale, husbandman 1
4820860 2302612 2302612 defendant Ody William husbandman 589596 589596 Ody, William, of Yoxhale, husbandman 3
4820861 2302612 2302612 defendant Leycestre Roger shoemaker 589596 589596 Leycestre, Roger, of Yoxhale, shoemaker 4
4820870 2302615 2302615 defendant Yoxhale William gent 589596 589596 Yoxhale, William, of Yoxhale, gent 0
4820872 2302615 2302615 defendant Campdene John weaver 589596 589596 Campdene, John, of Yoxhale, weaver 2
4820873 2302615 2302615 defendant Bulle John butcher 589596 589596 Bulle, John, of Yoxhale, butcher 3
4820875 2302615 2302615 defendant Taillour William tailor 589596 589596 Taillour, William, of Yoxhale, tailor 5
4880218 2320725 2320725 defendant Pant John   589596 589596 Pant, John, of Yoxhale, gent, son of Pant, Henry 4
4880224 2320726 2320726 defendant Pant John   589596 589596 Pant, John, of Yoxhale, gent, son of Pant, Henry 4
4888806 2323290 2323290 defendant Campeden William yeoman 589596 589596 Campeden, William, of Yoxhale, yeoman 0
4952659 2342752 2342752 defendant Belchere Robert yeoman 589596 589596 Belchere, Robert, of Yoxhale, yeoman 1
5044492 2369983 2369983 defendant Couper Richard husbandman 589596 589596 Couper, Richard, of Yoxhale, husbandman 0
5067777 2376862 2376862 defendant Bealcher Roger yeoman 589596 589596 Bealcher, Roger, of Yoxhale, yeoman 0
5087678 2382783 2382783 defendant Gardell Henry husbandman 589596 589596 Gardell, Henry, of Yoxhale, husbandman 2
5110229 2389399 2389399 defendant Trimmell Henry yeoman 589596 589596 Trimmell, Henry, of Yoxhale, yeoman 0
5223771 2422637 2422637 defendant Ilkesley James husbandman 589596 589596 Ilkesley, James, of Yoxhale, husbandman 0
5231158 2424713 2424713 defendant Brette John husbandman 589596 589596 Brette, John, of Yoxhale, husbandman 1
5300018 2444969 2444969 defendant Hygge William husbandman 589596 589596 Hygge, William, of Yoxhale, husbandman 0
5300019 2444969 2444969 defendant Welles John yeoman 589596 589596 Welles, John, of Yoxhale, yeoman 1
5309411 2447855 2447855 defendant Rous Robert husbandman 589596 589596 Rous, Robert, of Yoxhale, husbandman 0
5309413 2447856 2447856 defendant Rous Robert husbandman 589596 589596 Rous, Robert, of Yoxhale, husbandman 0
5324980 2452551 2452551 plaintiff Rous Robert   589596 589596 Rous, Robert, of Yoxhale 0
5325003 2452560 2452560 plaintiff Rows Robert   589596 589596 Rows, Robert, of Yoxhale 0
5417279 2480085 2480085 defendant Wodeward John husbandman 589596 589596 Wodeward, John, of Yoxhale, husbandman 0
5417732 2480228 2480228 defendant Wodeward John husbandman 589596 589596 Wodeward, John, of Yoxhale, husbandman 0
5502972 2505840 2505840 defendant Campden Robert gent 589596 589596 Campden, Robert, of Yoxhale, gent 0
5554125 2521248 2521248 defendant Roger Richard butcher 589596 589596 Roger, Richard, of Yoxhale, butcher 0
5554128 2521248 2521248 defendant Irpe Roger cooper 589596 589596 Irpe, Roger, of Yoxhale, cooper 3
5554189 2521269 2521269 defendant Roger Richard butcher 589596 589596 Roger, Richard, of Yoxhale, butcher 0
5554192 2521269 2521269 defendant Irpe Roger cooper 589596 589596 Irpe, Roger, of Yoxhale, cooper 3

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