names

75 rows where place_id = 591223

✎ 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
3603771 1868850 1868850 defendant Fawcet Richard dyer 591223 591223 Fawcet, Richard, of Soureby, dyer 0
3672177 1917296 1917296 defendant Haull William husbandman 591223 591223 Haull, William, of Soureby, husbandman 1
3785145 1953142 1953142 defendant Patenson John yeoman 591223 591223 Patenson, John, of Soureby, yeoman 0
3785146 1953142 1953142 defendant Symson John yeoman 591223 591223 Symson, John, of Soureby, yeoman 1
4526780 2208654 2208654 plaintiff Lascelles William   591223 591223 Lascelles, William, of Soureby 0
4632910 2241165 2241165 defendant Miles Thomas weaver 591223 591223 Miles, Thomas, of Soureby, weaver 0
4659047 2248699 2248699 defendant Knyght John husbandman 591223 591223 Knyght, John, of Soureby, husbandman 1
4667835 2255645 2255645 defendant Hole John husbandman 591223 591223 Hole, John, of Soureby, husbandman 0
4667836 2255645 2255645 defendant Wedop Thomas yeoman 591223 591223 Wedop, Thomas, of Soureby, yeoman 1
4667837 2255645 2255645 defendant Prestlay John husbandman 591223 591223 Prestlay, John, of Soureby, husbandman 2
4667859 2255649 2255649 defendant Horneclyff Robert yeoman 591223 591223 Horneclyff, Robert, of Soureby, yeoman 4
4667860 2255649 2255649 defendant Wedop Thomas husbandman 591223 591223 Wedop, Thomas, of Soureby, husbandman 5
4667862 2255649 2255649 defendant Denton John yeoman 591223 591223 Denton, John, of Soureby, yeoman 7
4694237 2263699 2263699 defendant Garth John yeoman 591223 591223 Garth, John, of Soureby, yeoman 0
4695989 2264232 2264232 defendant Lassels William gent 591223 591223 Lassels, William, of Soureby, gent 0
4706306 2267354 2267354 defendant Forster John yeoman 591223 591223 Forster, John, of Soureby, yeoman 0
4718902 2271253 2271253 defendant Symson Richard husbandman 591223 591223 Symson, Richard, of Soureby, husbandman 0
4718904 2271253 2271253 defendant Toppyng William yeoman 591223 591223 Toppyng, William, of Soureby, yeoman 2
4718905 2271253 2271253 defendant Clerk Thomas, sen husbandman 591223 591223 Clerk, Thomas, sen, of Soureby, husbandman 3
4718906 2271253 2271253 defendant Clerke John husbandman 591223 591223 Clerke, John, of Soureby, husbandman 4
4718907 2271253 2271253 defendant Jacson William tailor 591223 591223 Jacson, William, of Soureby, tailor 5
4734393 2275925 2275925 defendant Bette Robert husbandman 591223 591223 Bette, Robert, of Soureby, husbandman 2
4734394 2275925 2275925 defendant Catrik Richard husbandman 591223 591223 Catrik, Richard, of Soureby, husbandman 3
4735351 2276200 2276200 defendant Blamyre John yeoman 591223 591223 Blamyre, John, of Soureby, yeoman 6
4747665 2279825 2279825 defendant Yarwyth Robert yeoman 591223 591223 Yarwyth, Robert, of Soureby, yeoman 0
4747666 2279825 2279825 defendant Yarwyth John husbandman 591223 591223 Yarwyth, John, of Soureby, husbandman 1
4747667 2279825 2279825 defendant Thirnhome Thomas husbandman 591223 591223 Thirnhome, Thomas, of Soureby, husbandman 2
4747668 2279825 2279825 defendant Thirnhome William husbandman 591223 591223 Thirnhome, William, of Soureby, husbandman 3
4747669 2279825 2279825 defendant Werdale William husbandman 591223 591223 Werdale, William, of Soureby, husbandman 4
4757772 2282805 2282805 defendant Relf Thomas, sen yeoman 591223 591223 Relf, Thomas, sen, of Soureby, yeoman 3
4764812 2284975 2284975 defendant Ellerton John yeoman 591223 591223 Ellerton, John, of Soureby, yeoman 3
4770113 2286621 2286621 defendant Yarwyth Robert smith 591223 591223 Yarwyth, Robert, of Soureby, smith 1
4783976 2290998 2290998 defendant Blakhall John yeoman 591223 591223 Blakhall, John, of Soureby, yeoman 0
4794742 2294494 2294494 defendant Yarwych Thomas yeoman 591223 591223 Yarwych, Thomas, of Soureby, yeoman 1
4802638 2297011 2297011 defendant Merche John yeoman 591223 591223 Merche, John, of Soureby, yeoman 6
4809888 2299255 2299255 defendant Patonson William yeoman 591223 591223 Patonson, William, of Soureby, yeoman 1
4815287 2300891 2300891 defendant Marche John yeoman 591223 591223 Marche, John, of Soureby, yeoman 3
4815288 2300891 2300891 defendant Bek John de yeoman 591223 591223 Bek, John de, of Soureby, yeoman 4
4831922 2306012 2306012 defendant Clerk William yeoman 591223 591223 Clerk, William, of Soureby, yeoman 0
4833280 2306419 2306419 defendant Briseby Thomas   591223 591223 Briseby, Thomas, of Soureby 3
4842128 2309073 2309073 plaintiff Lassels William   591223 591223 Lassels, William, of Soureby 0
4856010 2313252 2313252 defendant Stalker William walker 591223 591223 (Stalker, William, of Soureby, walker 1
4856011 2313252 2313252 defendant Becke John yeoman 591223 591223 Becke, John, of Soureby, yeoman 2
4860817 2314744 2314744 defendant Clerke Richard yeoman 591223 591223 Clerke, Richard, of Soureby, yeoman 3
4862921 2315388 2315388 defendant Ellerton John husbandman 591223 591223 Ellerton, John, of Soureby, husbandman 3
4866401 2316460 2316460 defendant Rothemell Thomas yeoman 591223 591223 Rothemell, Thomas, of Soureby, yeoman 0
4868772 2317205 2317205 defendant Brysby Thomas yeoman 591223 591223 Brysby, Thomas, of Soureby, yeoman 1
4869624 2317462 2317462 plaintiff Lassels William   591223 591223 Lassels, William, of Soureby 0
4873593 2318682 2318682 defendant Glenton Richard yeoman 591223 591223 Glenton, Richard, of Soureby, yeoman 10
4874923 2319101 2319101 defendant Wardale William laborer 591223 591223 Wardale, William, of Soureby, laborer 1
4875216 2319201 2319201 defendant del Hall Richard yeoman 591223 591223 del Hall, Richard, of Soureby, yeoman 0
4992319 2354594 2354594 defendant Patanson William yeoman 591223 591223 Patanson, William, of Soureby, yeoman 4
4998206 2356333 2356333 defendant del Bek Adam yeoman 591223 591223 del Bek, Adam, of Soureby, yeoman 0
5006803 2358890 2358890 defendant Symson John yeoman 591223 591223 Symson, John, of Soureby, yeoman 0
5027030 2364778 2364778 defendant Symson John yeoman 591223 591223 Symson, John, of Soureby, yeoman 0
5027031 2364778 2364778 defendant Symson Robert yeoman 591223 591223 Symson, Robert, of Soureby, yeoman 1
5085231 2382081 2382081 defendant Rikerdby Richard yeoman 591223 591223 Rikerdby, Richard, of Soureby, yeoman 2
5085251 2382082 2382082 defendant Hewar John yeoman 591223 591223 Hewar, John, of Soureby, yeoman 11
5085252 2382082 2382082 defendant Ricardby Richard yeoman 591223 591223 Ricardby, Richard, of Soureby, yeoman 12
5238536 2426863 2426863 defendant Stable John husbandman 591223 591223 Stable, John, of Soureby, husbandman 1
5292646 2442845 2442845 defendant Robankys Thomas yeoman 591223 591223 Robankys, Thomas, of Soureby, yeoman 11
5348019 2459522 2459522 defendant Rymour William husbandman 591223 591223 Rymour, William, of Soureby, husbandman 0
5348020 2459522 2459522 defendant Badyson Thomas husbandman 591223 591223 Badyson, Thomas, of Soureby, husbandman 1
5348021 2459522 2459522 defendant Staynes Thomas husbandman 591223 591223 Staynes, Thomas, of Soureby, husbandman 2
5348022 2459522 2459522 defendant Forster Thomas husbandman 591223 591223 Forster, Thomas, of Soureby, husbandman 3
5377815 2468644 2468644 defendant Reymour William husbandman 591223 591223 Reymour, William, of Soureby, husbandman 3
5433201 2484895 2484895 defendant Hall Richard chaplain 591223 591223 Hall, Richard, of Soureby, chaplain 1
5449226 2489655 2489655 defendant Hall Richard chaplain 591223 591223 Hall, Richard, of Soureby, chaplain 1
5461203 2493298 2493298 defendant Hall Richard chaplain 591223 591223 Hall, Richard, of Soureby, chaplain 1
5567481 2525058 2525058 defendant Monkhous John yeoman 591223 591223 Monkhous, John, of Soureby, yeoman 3
5567482 2525058 2525058 defendant Monkhous Christopher yeoman 591223 591223 Monkhous, Christopher, of Soureby, yeoman 4
5567483 2525058 2525058 defendant Monkhous William yeoman 591223 591223 Monkhous, William, of Soureby, yeoman 5
5567484 2525058 2525058 defendant Monkhous Richard yeoman 591223 591223 Monkhous, Richard, of Soureby, yeoman 6
5567485 2525058 2525058 defendant Alcok Thomas yeoman 591223 591223 Alcok, Thomas, of Soureby, yeoman 7
5635732 2555132 2555132 defendant Scayf Thomas yeoman 591223 591223 Scayf, Thomas, of Soureby, yeoman 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);