names

69 rows where place_id = 610949

✎ 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
3685996 1921779 1921779 defendant Whitacres William innholder 610949 610949 Whitacres, William, of Tollerton, innholder 0
3746508 1940819 1940819 defendant Shypton Stephen laborer 610949 610949 Shypton, Stephen, of Tollerton, laborer 0
3746509 1940819 1940819 defendant Pully John glover 610949 610949 Pully, John, of Tollerton, glover 1
3746510 1940819 1940819 defendant Syrre John laborer 610949 610949 Syrre, John, of Tollerton, laborer 2
3782599 1952298 1952298 defendant Whytacres Robert innholder 610949 610949 Whytacres, Robert, of Tollerton, innholder 3
3895640 1988747 1988747 defendant Wilson John yeoman 610949 610949 Wilson, John, of Tollerton, yeoman 3
3906888 1992591 1992591 defendant Cussone John yeoman 610949 610949 Cussone, John, of Tollerton, yeoman 0
3906893 1992592 1992592 defendant Dobson Robert yeoman 610949 610949 Dobson, Robert, of Tollerton, yeoman 1
3962858 2011601 2011601 defendant Pratt Thomas chapman 610949 610949 Pratt, Thomas, of Tollerton, chapman 0
3976821 2016464 2016464 defendant Smyth Anthony husbandman 610949 610949 Smyth, Anthony, of Tollerton, husbandman 0
4138563 2074159 2074159 defendant Sheperde William husbandman 610949 610949 Sheperde, William, of Tollerton, husbandman 0
4252060 2113678 2113678 defendant Staynton William yeoman 610949 610949 Staynton, William, of Tollerton, yeoman 0
4265801 2118201 2118201 defendant Staynton William yeoman 610949 610949 Staynton, William, of Tollerton, yeoman 0
4283065 2123975 2123975 defendant Tomlynson Percival husbandman 610949 610949 Tomlynson, Percival, of Tollerton, husbandman 1
4384441 2159487 2159487 defendant Laverocke George husbandman 610949 610949 Laverocke, George, of Tollerton, husbandman 0
4395776 2163172 2163172 defendant Maye John yeoman 610949 610949 Maye, John, of Tollerton, yeoman 0
4441781 2182364 2182364 defendant Brandesly John de   610949 610949 Brandesly, John de, of Tollerton 0
4441788 2182366 2182366 defendant Brandesby John de   610949 610949 Brandesby, John de, of Tollerton 0
4441796 2182368 2182368 defendant Brandesby John de   610949 610949 Brandesby, John de, of Tollerton 0
4462195 2188874 2188874 defendant Gynyngdale Richard de   610949 610949 Gynyngdale, Richard de, of Tollerton 0
4475751 2193088 2193088 defendant Denere Robert   610949 610949 Denere, Robert, of Tollerton 5
4477767 2193713 2193713 defendant Gynedale Richard   610949 610949 Gynedale, Richard, of Tollerton 0
4542211 2213454 2213454 defendant Playfayr Henry   610949 610949 Playfayr, Henry, of Tollerton 2
4571243 2222576 2222576 defendant Genendale Richard   610949 610949 Genendale, Richard, of Tollerton 0
4599503 2231059 2231059 defendant Stokker William   610949 610949 Stokker, William, of Tollerton 0
4618848 2236891 2236891 defendant Stokker William   610949 610949 Stokker, William, of Tollerton 0
4624348 2238594 2238594 defendant Harpour Thomas   610949 610949 Harpour, Thomas, of Tollerton 0
4627640 2239576 2239576 defendant Shepherd John   610949 610949 Shepherd, John, of Tollerton 1
4627642 2239576 2239576 defendant Ludelay Richard   610949 610949 Ludelay, Richard, of Tollerton 3
4641654 2243661 2243661 defendant Harpour John   610949 610949 Harpour, John, of Tollerton 0
4650041 2246025 2246025 defendant Playfayre Henry   610949 610949 Playfayre, Henry, of Tollerton 0
4650055 2246030 2246030 plaintiff Weder William   610949 610949 Weder, William, of Tollerton 0
4682923 2260275 2260275 defendant Jonson Hugh husbandman 610949 610949 Jonson, Hugh, of Tollerton, husbandman 0
4682924 2260275 2260275 defendant Wilkynson Robert husbandman 610949 610949 with Wilkynson, Robert, of Tollerton, husbandman 1
4682925 2260275 2260275 defendant Wylkynson Thomas husbandman 610949 610949 Wylkynson, Thomas, of Tollerton, husbandman 2
4689865 2262385 2262385 defendant Kytson John fisher 610949 610949 Kytson, John, of Tollerton, fisher 4
4746759 2279549 2279549 defendant Stokker William yeoman 610949 610949 Stokker, William, of Tollerton, yeoman 1
4754530 2281797 2281797 defendant Playfayr John husbandman 610949 610949 Playfayr, John, of Tollerton, husbandman 0
4754531 2281797 2281797 defendant Wylkynson Thomas husbandman 610949 610949 Wylkynson, Thomas, of Tollerton, husbandman 1
4754532 2281797 2281797 defendant Shipherd John husbandman 610949 610949 Shipherd, John, of Tollerton, husbandman 2
4754533 2281797 2281797 defendant Wylkynson Robert husbandman 610949 610949 Wylkynson, Robert, of Tollerton, husbandman 3
4794629 2294462 2294462 defendant Tutyng William yeoman 610949 610949 Tutyng, William, of Tollerton, yeoman 1
4794630 2294462 2294462 defendant Kirkeby Alice widow 610949 610949 Kirkeby, Alice, of Tollerton, widow 2
4797760 2295479 2295479 defendant Peresson John husbandman 610949 610949 Peresson, John, of Tollerton, husbandman 0
4808820 2298926 2298926 defendant Maunsell Peter yeoman 610949 610949 Maunsell, Peter, of Tollerton, yeoman 0
4816984 2301414 2301414 plaintiff Maunsell Patrick   610949 610949 Maunsell, Patrick, of Tollerton 0
4824996 2303856 2303856 defendant Haggar John   610949 610949 Haggar, John, of Tollerton yeoman 0
4901441 2327058 2327058 defendant Harpur Richard husbandman 610949 610949 Harpur, Richard, of Tollerton, husbandman 0
4901442 2327058 2327058 defendant Cusson Richard husbandman 610949 610949 Cusson, Richard, of Tollerton, husbandman 1
4901443 2327058 2327058 defendant Wilkynson Robert husbandman 610949 610949 Wilkynson, Robert, of Tollerton, husbandman 2
4946223 2340804 2340804 defendant Pierson John husbandman 610949 610949 Pierson, John, of Tollerton, husbandman 0
4987548 2353231 2353231 defendant russell William husbandman 610949 610949 russell, William, of Tollerton, husbandman 2
5008261 2359306 2359306 defendant Shupton Richard husbandman 610949 610949 Shupton, Richard, of Tollerton, husbandman 1
5008262 2359306 2359306 defendant Shupton William husbandman 610949 610949 Shupton, William, of Tollerton, husbandman 2
5008263 2359306 2359306 defendant Custson Richard husbandman 610949 610949 Custson, Richard, of Tollerton, husbandman 3
5241922 2427833 2427833 defendant Dobson John yeoman 610949 610949 Dobson, John, of Tollerton, yeoman 0
5251282 2430503 2430503 defendant Barry Edmund esq 610949 610949 Barry, Edmund, of Tollerton, esq 0
5303242 2445964 2445964 defendant Thomson John smith 610949 610949 Thomson, John, of Tollerton, smith 0
5303244 2445965 2445965 defendant Thomson John smith 610949 610949 Thomson, John, of Tollerton, smith 0
5307392 2447216 2447216 defendant Stotherd Thomas dyer 610949 610949 Stotherd, Thomas, of Tollerton, dyer 0
5313766 2449144 2449144 plaintiff Brade John   610949 610949 Brade, John, of Tollerton 0
5350532 2460287 2460287 defendant Lumberd Robert butcher 610949 610949 Lumberd, Robert, of Tollerton, butcher 1
5504243 2506241 2506241 defendant Cusson John, senior husbandman 610949 610949 Cusson, John, senior, of Tollerton, husbandman 0
5504246 2506242 2506242 defendant Cusson John, senior husbandman 610949 610949 Cusson, John, senior, of Tollerton, husbandman 0
5508377 2507495 2507495 defendant Horsley John innholder 610949 610949 Horsley, John, of Tollerton, innholder 0
5508378 2507495 2507495 defendant Metcalf Thomas tailor 610949 610949 Metcalf, Thomas, of Tollerton, tailor 1
5508386 2507495 2507495 defendant Gyll William husbandman 610949 610949 Gyll, William, of Tollerton, husbandman 9
5508387 2507495 2507495 defendant Smyth John smith 610949 610949 Smyth, John, of Tollerton, smith 10
5543602 2518104 2518104 defendant Ibson Thomas yeoman 610949 610949 Ibson, Thomas, of Tollerton, 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);