names

52 rows where place_id = 593684

✎ 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
3612917 1871688 1871688 plaintiff Aleyn William yeoman 593684 593684 Aleyn, William, of Raylegh, yeoman 0
3631426 1904641 1904641 defendant Fannyng Thomas yeoman 593684 593684 Fannyng, Thomas, of Raylegh, yeoman 2
3658697 1912973 1912973 defendant Aleyn Thomas yeoman 593684 593684 Aleyn, Thomas, of Raylegh, yeoman 0
3701675 1926766 1926766 plaintiff Brown John   593684 593684 Brown, John, of Raylegh 0
3710854 1929713 1929713 plaintiff Squyer John yeoman 593684 593684 Squyer, John, of Raylegh, yeoman 0
3765627 1946914 1946914 defendant Bode Henry yeoman 593684 593684 Bode, Henry, of Raylegh, yeoman 0
3792568 1955533 1955533 defendant Alen Thomas yeoman 593684 593684 Alen, Thomas, of Raylegh, yeoman 1
3827795 1966560 1966560 defendant Alen John (legal representative) 593684 593684 Alen, John, of Raylegh, gent, executor of 1
3857061 1975841 1975841 plaintiff Alen Thomas yeoman 593684 593684 Alen, Thomas, of Raylegh, yeoman 0
3857829 1976086 1976086 defendant Cawston Thomas yeoman 593684 593684 Cawston, Thomas, of Raylegh, yeoman 0
3870855 1980504 1980504 plaintiff Alen Thomas yeoman 593684 593684 Alen, Thomas, of Raylegh, yeoman 0
3870857 1980505 1980505 plaintiff Alen Thomas yeoman 593684 593684 Alen, Thomas, of Raylegh, yeoman 0
3875069 1981893 1981893 defendant Elott alias Assheton John tailor 593684 593684 Elott alias Assheton, John, of Raylegh, tailor 0
3879345 1983344 1983344 defendant Loone William   593684 593684 Loone, William, of Raylegh 0
3904380 1991712 1991712 defendant Stafford Thomas tailor 593684 593684 Stafford, Thomas, of Raylegh, tailor 0
3904382 1991712 1991712 defendant Goore John weaver 593684 593684 Goore, John, of Raylegh, weaver 2
3908314 1993078 1993078 defendant Aleyn Thomas gent 593684 593684 Aleyn, Thomas, of Raylegh, gent 0
3920628 1997247 1997247 defendant Aleyn Thomas (legal representative) 593684 593684 Aleyn, Thomas, of Raylegh, yeoman, administrator of 0
4539169 2212506 2212506 plaintiff Tasborgh William   593684 593684 Tasborgh, William, of Raylegh, parson 1
4562727 2219898 2219898 defendant Spycer Henry   593684 593684 Spycer, Henry, of Raylegh 0
4805126 2297806 2297806 defendant Oudeby John gent 593684 593684 Oudeby, John, of Raylegh, gent 0
4929085 2335516 2335516 defendant Fullere John yeoman 593684 593684 Fullere, John, of Raylegh, yeoman 0
5023878 2363894 2363894 defendant Bowedon Thomas   593684 593684 Bowedon, Thomas, of Raylegh, "hierd" or herder 0
5047315 2370814 2370814 defendant Steleman William yeoman 593684 593684 Steleman, William, of Raylegh, yeoman 4
5047316 2370814 2370814 defendant Hytham John yeoman 593684 593684 Hytham, John, of Raylegh, yeoman 5
5083462 2381552 2381552 defendant Standrop Thomas yeoman 593684 593684 Standrop, Thomas, of Raylegh, yeoman 0
5083464 2381553 2381553 defendant Standrop Thomas yeoman 593684 593684 Standrop, Thomas, of Raylegh, yeoman 0
5133984 2396435 2396435 defendant Berkham John husbandman 593684 593684 Berkham, John, of Raylegh, husbandman 1
5141136 2398531 2398531 defendant Lyvys William laborer 593684 593684 Lyvys, William, of Raylegh, laborer 1
5147591 2400433 2400433 defendant Blreward Ralph   593684 593684 Blreward, Ralph, of Raylegh, parson of the parish church 0
5147593 2400434 2400434 defendant Doreward Ralph   593684 593684 Doreward, Ralph, of Raylegh, parson 0
5225849 2423234 2423234 defendant Fulham Walter husbandman 593684 593684 Fulham, Walter, of Raylegh, husbandman 2
5263342 2434282 2434282 defendant Tukke William yeoman 593684 593684 Tukke, William, of Raylegh, yeoman 1
5282612 2439978 2439978 defendant Hemery John husbandman 593684 593684 Hemery, John, of Raylegh, husbandman 2
5369241 2465979 2465979 defendant Underwode John yeoman 593684 593684 Underwode, John, of Raylegh, yeoman 1
5369243 2465980 2465980 defendant Underwode John yeoman 593684 593684 Underwode, John, of Raylegh, yeoman 0
5433662 2485035 2485035 defendant Hewson John yeoman 593684 593684 Hewson, John, of Raylegh, yeoman 0
5433663 2485035 2485035 defendant Huson Robert yeoman 593684 593684 Huson, Robert, of Raylegh, yeoman 1
5449375 2489704 2489704 defendant Hewson John yeoman 593684 593684 Hewson, John, of Raylegh, yeoman 0
5449376 2489704 2489704 defendant Heuson Robert yeoman 593684 593684 Heuson, Robert, of Raylegh, yeoman 1
5470719 2496163 2496163 defendant Belton Robert gent 593684 593684 Belton, Robert, of Raylegh, gent 0
5521505 2511541 2511541 defendant Botyll William, junior mercer 593684 593684 Botyll, William, junior, of Raylegh, mercer 0
5525146 2512457 2512457 plaintiff Grene John   593684 593684 Grene, John, of Raylegh 0
5525350 2512519 2512519 defendant Buttyll John   593684 593684 Buttyll, John, of Raylegh, yeoman, administrators of 0
5525351 2512519 2512519 defendant Buttyll William yeoman 593684 593684 (Buttyll, William, of Raylegh, yeoman 1
5525352 2512519 2512519 defendant Buttill Thomas yeoman 593684 593684 Buttill, Thomas, of Raylegh, yeoman 2
5537862 2516329 2516329 defendant Trayfford Edward yeoman 593684 593684 Trayfford, Edward, of Raylegh, yeoman 0
5537864 2516330 2516330 defendant Trayfford Edward yeoman 593684 593684 Trayfford, Edward, of Raylegh, yeoman 0
5543158 2517975 2517975 defendant Bonour John, senior husbandman 593684 593684 Bonour, John, senior, of Raylegh, husbandman 0
5566612 2524829 2524829 defendant Aleyn William yeoman 593684 593684 Aleyn, William, of Raylegh, yeoman 0
5578200 2528253 2528253 defendant Brodewater Nicholas tailor 593684 593684 Brodewater, Nicholas, of Raylegh, tailor 1
5627080 2552437 2552437 defendant Coke John tailor 593684 593684 Coke, John, of Raylegh, tailor 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);