names

56 rows where place_id = 586926

✎ 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
3590002 1864513 1864513 defendant Palmer John husbandman 586926 586926 Palmer, John, of Russheden, husbandman 1
3619212 1873610 1873610 defendant Frare Thomas miller 586926 586926 Frare, Thomas, of Russheden, miller 0
3738829 1938350 1938350 defendant Smyth William husbandman 586926 586926 Smyth, William, of Russheden, husbandman 1
3801864 1958479 1958479 defendant Smyth William husbandman 586926 586926 Smyth, William, of Russheden, husbandman 0
3861569 1977330 1977330 defendant Clerke alias Sommer Henry butcher 586926 586926 Clerke alias Sommer, Henry, of Russheden, butcher 0
3956535 2009353 2009353 defendant Twynne Richard yeoman 586926 586926 Twynne, Richard, of Russheden, yeoman 0
4034338 2036953 2036953 defendant Bolton Thomas yeoman 586926 586926 Bolton, Thomas, of Russheden, yeoman 0
4166343 2083723 2083723 defendant Marshall Thomas husbandman 586926 586926 Marshall, Thomas, of Russheden, husbandman 0
4414337 2169397 2169397 defendant Basset Robert   586926 586926 Basset, Robert, of Russheden 0
4453567 2186127 2186127 defendant Wryght Richard   586926 586926 Wryght, Richard, of Russheden, parson 0
4548232 2215388 2215388 defendant Barbour John   586926 586926 Barbour, John, of Russheden 0
4548233 2215388 2215388 defendant Horwode John   586926 586926 Horwode, John, of Russheden 1
4556287 2217908 2217908 defendant Barbour John   586926 586926 Barbour, John, of Russheden 0
4556288 2217908 2217908 defendant Horwode John   586926 586926 Horwode, John, of Russheden 1
4577988 2224622 2224622 defendant Smyth John   586926 586926 Smyth, John, of Russheden 2
4694376 2263741 2263741 plaintiff Bocher William   586926 586926 Bocher, William, of Russheden 0
4694379 2263741 2263741 defendant Barker William tanner 586926 586926 Barker, William, of Russheden, tanner 2
4694380 2263742 2263742 plaintiff Bocher William   586926 586926 Bocher, William, of Russheden 0
4714054 2269724 2269724 defendant Curry William drover 586926 586926 Curry, William, of Russheden, drover 0
4752551 2281205 2281205 defendant Wode Thomas husbandman 586926 586926 Wode, Thomas, of Russheden, husbandman 2
4766621 2285552 2285552 defendant Michell William   586926 586926 Michell, William, of Russheden, horse dealer 0
4767529 2285821 2285821 defendant Gurry William butcher 586926 586926 Gurry, William, of Russheden, butcher 0
4803525 2297290 2297290 plaintiff Yongelove John   586926 586926 Yongelove, John, of Russheden 3
4824546 2303726 2303726 defendant Harryes John husbandman 586926 586926 Harryes, John, of Russheden, husbandman 1
4824551 2303728 2303728 defendant Harryes John husbandman 586926 586926 Harryes, John, of Russheden, husbandman 1
4826752 2304402 2304402 defendant Blake Thomas   586926 586926 Blake, Thomas, of Russheden, mason 0
4855305 2313010 2313010 defendant Swette John, junior husbandman 586926 586926 Swette, John, junior, of Russheden, husbandman 4
4867369 2316760 2316760 defendant Couper William butcher 586926 586926 Couper, William, of Russheden, butcher 0
4897340 2325827 2325827 plaintiff Man William   586926 586926 Man, William, of Russheden 0
4897341 2325827 2325827 defendant Russheden John weaver 586926 586926 Russheden, John, of Russheden, weaver 0
4914315 2330991 2330991 defendant Burre John shoemaker 586926 586926 Burre, John, of Russheden, shoemaker 1
4925101 2334283 2334283 defendant Baxter Robert baker 586926 586926 Baxter, Robert, of Russheden, baker 1
4928631 2335384 2335384 defendant Durry William   586926 586926 Durry, William, of Russheden 0
4937082 2337969 2337969 defendant Man William husbandman 586926 586926 (Man, William, of Russheden, husbandman 1
4989480 2353788 2353788 defendant Burgage Thomas husbandman 586926 586926 Burgage, Thomas, of Russheden, husbandman 1
5001726 2357399 2357399 defendant Harries John, sen husbandman 586926 586926 Harries, John, sen, of Russheden, husbandman 0
5009269 2359597 2359597 defendant Gurre William   586926 586926 Gurre, William, of russheden, mason 0
5101570 2386878 2386878 defendant Basset John husbandman 586926 586926 Basset, John, of Russheden, husbandman 2
5125569 2393966 2393966 defendant Bidell William husbandman 586926 586926 Bidell, William, of Russheden, husbandman 0
5128629 2394856 2394856 defendant Bedell William husbandman 586926 586926 Bedell, William, of Russheden, husbandman 0
5138338 2397723 2397723 defendant Pykerell Henry chandler 586926 586926 Pykerell, Henry, of Russheden, chandler 3
5147079 2400283 2400283 defendant Harres John husbandman 586926 586926 Harres, John, of Russheden, husbandman 1
5176869 2408924 2408924 defendant Harryes John   586926 586926 Harryes, John, of Russheden, husbandman, son of John Harryes, sen 3
5178848 2409539 2409539 defendant Wright Walter   586926 586926 Wright, Walter, of Russheden, wright 2
5178871 2409546 2409546 defendant Boywell Thomas husbandman 586926 586926 Boywell, Thomas, of Russheden, husbandman 3
5193258 2413757 2413757 defendant Bedell William husbandman 586926 586926 Bedell, William, of Russheden, husbandman 2
5199657 2415643 2415643 defendant Yong John husbandman 586926 586926 Yong, John, of Russheden, husbandman 0
5214023 2419832 2419832 defendant Conys Nicholas   586926 586926 Conys, Nicholas, of Russheden, mason 2
5273359 2437278 2437278 defendant Hulle Nicholas sadler 586926 586926 Hulle, Nicholas, of Russheden, sadler 0
5314747 2449450 2449450 defendant Harowde Nicholas husbandman 586926 586926 Harowde, Nicholas, of Russheden, husbandman 1
5314748 2449450 2449450 defendant Rothe or Roche William husbandman 586926 586926 Rothe or Roche, William, of Russheden, husbandman 2
5362262 2463858 2463858 defendant Crosse Richard husbandman 586926 586926 Crosse, Richard, of Russheden, husbandman 1
5362263 2463858 2463858 defendant Drewell William baker 586926 586926 Drewell, William, of Russheden, baker 2
5460366 2493040 2493040 defendant Vesdon Nicholas carpenter 586926 586926 Vesdon, Nicholas, of Russheden, carpenter 1
5557630 2522190 2522190 plaintiff Newport John (legal representative) 586926 586926 Newport, John, of Russheden, executors of 0
5557637 2522190 2522190 defendant Alyn Robert husbandman 586926 586926 Alyn, Robert, of Russheden, husbandman 4

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