names

70 rows where place_id = 591254

✎ 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
3603854 1868878 1868878 defendant Kechyn William husbandman 591254 591254 Kechyn, William, of Skothowe, husbandman 0
3837689 1969699 1969699 defendant Wymer Thomas   591254 591254 Wymer, Thomas, of Skothowe, worsted weaver 0
3839548 1970293 1970293 defendant Nocold Thomas   591254 591254 Nocold, Thomas, of Skothowe, worsted weaver 2
3864272 1978244 1978244 plaintiff Larke Robert husbandman 591254 591254 Larke, Robert, of Skothowe, husbandman 0
3878345 1983005 1983005 plaintiff Larke Robert   591254 591254 Larke, Robert, of Skothowe 0
3954440 2008621 2008621 defendant Pery John   591254 591254 Pery, John, of Skothowe, worsted weaver, administrators of 1
4520316 2206699 2206699 defendant Hardlyng William   591254 591254 Hardlyng, William, of Skothowe 0
4603574 2232304 2232304 defendant Flekke John   591254 591254 Flekke, John, of Skothowe 1
4631646 2240784 2240784 defendant Gerard John   591254 591254 Gerard, John, of Skothowe 4
4653235 2246950 2246950 defendant Clok John yeoman 591254 591254 Clok, John, of Skothowe, yeoman 1
4653239 2246951 2246951 defendant Clok John yeoman 591254 591254 Clok, John, of Skothowe, yeoman 1
4671283 2256670 2256670 defendant Corbyn Willaim sheerman 591254 591254 Corbyn, Willaim, of Skothowe, sheerman 6
4748311 2280013 2280013 defendant Cates John yeoman 591254 591254 Cates, John, of Skothowe, yeoman 3
4753299 2281412 2281412 defendant Smyth Robert   591254 591254 Smyth, Robert, of Skothowe, vicar 1
4785101 2291352 2291352 defendant Hert John butcher 591254 591254 Hert, John, of Skothowe, butcher 0
4845482 2310102 2310102 plaintiff Stub William   591254 591254 Stub, William, of Skothowe 1
4873024 2318522 2318522 plaintiff Stub William   591254 591254 Stub, William, of Skothowe 1
4900105 2326662 2326662 defendant Rust John husbandman 591254 591254 Rust, John, of Skothowe, husbandman 0
4904430 2327998 2327998 defendant Rust William husbandman 591254 591254 Rust, William, of Skothowe, husbandman 0
4916480 2331658 2331658 defendant Rust Robert husbandman 591254 591254 Rust, Robert, of Skothowe, husbandman 1
4929464 2335633 2335633 defendant (illegible) Thomas   591254 591254 ---, Thomas, of Skothowe, vicar 3
4956874 2344015 2344015 defendant Gilberd John husbandman 591254 591254 Gilberd, John, of Skothowe, husbandman 2
4981319 2351335 2351335 defendant Dannard Thomas clerk 591254 591254 Dannard, Thomas, of Skothowe, clerk 0
5000417 2356990 2356990 defendant Elmham Robert gent 591254 591254 Elmham, Robert, of Skothowe, gent 0
5020637 2362929 2362929 defendant Folbergh Robert   591254 591254 Folbergh, Robert, of Skothowe, wright 3
5025082 2364235 2364235 defendant Martyn John singleman or yeoman 591254 591254 Martyn, John, of Skothowe, singleman or yeoman 0
5041323 2369014 2369014 plaintiff Clerk Peter   591254 591254 Clerk, Peter, of Skothowe 0
5041325 2369015 2369015 plaintiff Clerk Peter   591254 591254 Clerk, Peter, of Skothowe 0
5047281 2370809 2370809 defendant Damard Thomas   591254 591254 Damard, Thomas, of Skothowe, vicar 0
5071959 2378103 2378103 plaintiff Stubbe William   591254 591254 Stubbe, William, of Skothowe 0
5079100 2380236 2380236 defendant Suffeld Richard smith 591254 591254 Suffeld, Richard, of Skothowe, smith 1
5087636 2382769 2382769 defendant Brystymber John yeoman 591254 591254 Brystymber, John, of Skothowe, yeoman 0
5089495 2383299 2383299 defendant Thorn Robert   591254 591254 Thorn, Robert, of Skothowe, worsted weaver 0
5089816 2383396 2383396 defendant Dannard Thomas clerk 591254 591254 Dannard, Thomas, of Skothowe, clerk 0
5120908 2392546 2392546 plaintiff Stubbe William   591254 591254 Stubbe, William, of Skothowe 0
5147345 2400367 2400367 defendant Birkele William husbandman 591254 591254 Birkele, William, of Skothowe, husbandman 2
5151490 2401586 2401586 plaintiff Michelys Denis   591254 591254 Michelys, Denis, of Skothowe 1
5167091 2406106 2406106 defendant Birkele William husbandman 591254 591254 Birkele, William, of Skothowe, husbandman 2
5167092 2406106 2406106 defendant Charles John carpenter 591254 591254 Charles, John, of Skothowe, carpenter 3
5169631 2406854 2406854 plaintiff Michelys Denis   591254 591254 Michelys, Denis, of Skothowe 1
5188725 2412430 2412430 plaintiff Hynde William   591254 591254 Hynde, William, of Skothowe, worsted weaver 0
5188726 2412430 2412430 defendant Aleyn William   591254 591254 Aleyn, William, of Skothowe, worsted weaver 0
5203333 2416738 2416738 defendant Birkeley William husbandman 591254 591254 Birkeley, William, of Skothowe, husbandman 1
5203334 2416738 2416738 defendant Charles John carpenter 591254 591254 Charles, John, of Skothowe, carpenter 2
5206222 2417554 2417554 plaintiff Hynde William   591254 591254 Hynde, William, of Skothowe, worsted weaver 0
5206223 2417554 2417554 defendant Aleyns William   591254 591254 Aleyns, William, of Skothowe, worsted weaver 0
5214504 2419971 2419971 defendant Suffeld Richard smith 591254 591254 Suffeld, Richard, of Skothowe, smith 1
5237675 2426601 2426601 defendant Lincoln Nicholas husbandman 591254 591254 Lincoln, Nicholas, of Skothowe, husbandman 0
5240125 2427313 2427313 plaintiff Hynde William   591254 591254 Hynde, William, of Skothowe, worsted weaver 0
5240126 2427313 2427313 defendant Aleyns William   591254 591254 Aleyns, William, of Skothowe, worsted weaver 0
5241906 2427829 2427829 defendant Abot Robert laborer 591254 591254 Abot, Robert, of Skothowe, laborer 2
5252446 2430875 2430875 plaintiff Stubbe John   591254 591254 Stubbe, John, of Skothowe 5
5255052 2431697 2431697 plaintiff Clerk Peter   591254 591254 Clerk, Peter, of Skothowe 0
5278045 2438665 2438665 plaintiff Stubbe Joh   591254 591254 Stubbe, Joh, of Skothowe 5
5284600 2440507 2440507 defendant Smyth Roger husbandman 591254 591254 Smyth, Roger, of Skothowe, husbandman 0
5298775 2444619 2444619 defendant Roper Thomas tailor 591254 591254 Roper, Thomas, of Skothowe, tailor 0
5539972 2516986 2516986 defendant at Kechon William butcher 591254 591254 at Kechon, William, of Skothowe, butcher 1
5551737 2520551 2520551 defendant Grove Thomas   591254 591254 Grove, Thomas, of Skothowe, husbandman, administrators of 0
5556102 2521780 2521780 plaintiff Lely Edmund   591254 591254 Lely, Edmund, of Skothowe 0
5556104 2521781 2521781 plaintiff Lely Edmund   591254 591254 Lely, Edmund, of Skothowe 0
5560755 2523112 2523112 defendant Oke Reginald husbandman 591254 591254 Oke, Reginald, of Skothowe, husbandman 0
5576892 2527817 2527817 defendant Raumson Thomas husbandman 591254 591254 Raumson, Thomas, of Skothowe, husbandman 0
5579999 2528825 2528825 defendant Clerk John husbandman 591254 591254 Clerk, John, of Skothowe, husbandman 1
5580000 2528825 2528825 defendant Fulke Edmund husbandman 591254 591254 Fulke, Edmund, of Skothowe, husbandman 2
5580008 2528827 2528827 defendant Clerk John husbandman 591254 591254 Clerk, John, of Skothowe, husbandman 0
5580009 2528827 2528827 defendant Fulk Edmund husbandman 591254 591254 Fulk, Edmund, of Skothowe, husbandman 1
5602575 2535700 2535700 defendant Moore James gent 591254 591254 Moore, James, of Skothowe, gent 0
5624269 2551539 2551539 plaintiff Larwode Richard   591254 591254 Larwode, Richard, of Skothowe 0
5625342 2551865 2551865 defendant Larwode Richard yeoman 591254 591254 Larwode, Richard, of Skothowe, yeoman 1
5634841 2554891 2554891 defendant Wallere John husbandman 591254 591254 Wallere, John, of Skothowe, husbandman 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);