names

39 rows where place_id = 597211

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627687 1903520 1903520 defendant Davy Thomas carpenter 597211 597211 Davy, Thomas, of Ketton, carpenter 1
3654178 1911568 1911568 defendant Cotywade Walter husbandman 597211 597211 Cotywade, Walter, of Ketton, husbandman 1
3704512 1927706 1927706 defendant Cok Robert husbandman 597211 597211 Cok, Robert, of Ketton, husbandman 0
3708391 1928919 1928919 defendant Nicollis Richard husbandman 597211 597211 Nicollis, Richard, of Ketton, husbandman 0
3720076 1932553 1932553 defendant Hogeson Thomas husbandman 597211 597211 Hogeson, Thomas, of Ketton, husbandman 0
3730918 1935897 1935897 defendant Hogeson Thomas husbandman 597211 597211 Hogeson, Thomas, of Ketton, husbandman 0
3734290 1936962 1936962 defendant Cooke Robert husbandman 597211 597211 Cooke, Robert, of Ketton, husbandman 2
3739908 1938700 1938700 defendant Greneham Thomas, senior gent 597211 597211 Greneham, Thomas, senior, of Ketton, gent 0
3764384 1946521 1946521 defendant Seman Henry husbandman 597211 597211 Seman, Henry, of Ketton, husbandman 2
3779222 1951223 1951223 defendant Hogeson Thomas husbandman 597211 597211 Hogeson, Thomas, of Ketton, husbandman 0
3779653 1951367 1951367 defendant Nicols Richard husbandman 597211 597211 Nicols, Richard, of Ketton, husbandman 0
3851007 1973906 1973906 defendant Wassell Alice widow 597211 597211 Wassell, Alice, of Ketton, widow 0
3872822 1981122 1981122 defendant Bret John husbandman 597211 597211 Bret, John, of Ketton, husbandman 0
3889955 1986877 1986877 defendant Shypwryght John husbandman 597211 597211 Shypwryght, John, of Ketton, husbandman 1
3889959 1986878 1986878 defendant Shypwryght John husbandman 597211 597211 Shypwryght, John, of Ketton, husbandman 1
3933292 2001430 2001430 plaintiff Greneham Thomas gent 597211 597211 Greneham, Thomas, of Ketton, gent 0
3983509 2018876 2018876 defendant Cockerton Richard butcher 597211 597211 Cockerton, Richard, of Ketton, butcher 0
4059153 2045674 2045674 defendant Bretton Nicholas husbandman 597211 597211 Bretton, Nicholas, of Ketton, husbandman 0
4059154 2045674 2045674 defendant Drewe Thomas husbandman 597211 597211 Drewe, Thomas, of Ketton, husbandman 1
4059155 2045674 2045674 defendant Blancher Anthony husbandman 597211 597211 Blancher, Anthony, of Ketton, husbandman 2
4086531 2055468 2055468 defendant Dyke Robert husbandman 597211 597211 Dyke, Robert, of Ketton, husbandman 2
4101557 2060865 2060865 defendant Pyper alias Man Stephen husbandman 597211 597211 Pyper alias Man, Stephen, of Ketton, husbandman 0
4140002 2074669 2074669 defendant Bateman William glover 597211 597211 Bateman, William, of Ketton, glover 1
4175775 2087000 2087000 defendant Man alias Pyper Stephen husbandman 597211 597211 Man alias Pyper, Stephen, of Ketton, husbandman 0
4191766 2092676 2092676 defendant Pyper alias Man John husbandman 597211 597211 Pyper alias Man, John, of Ketton, husbandman 0
4220168 2102557 2102557 defendant Johnson Jeremy yeoman 597211 597211 Johnson, Jeremy, of Ketton, or of Ashdon, yeoman 0
4282082 2123633 2123633 defendant Warde William gent 597211 597211 Warde, William, of Ketton or of Kelthorp, Rutland, gent 3
4398765 2164168 2164168 defendant Ryse Thomas yeoman 597211 597211 Ryse, Thomas, of Ketton, or of Borlye, Essex, yeoman 0
4398767 2164169 2164169 defendant Sheldrake Francis husbandman 597211 597211 Sheldrake, Francis, of Ketton, husbandman 0
4398768 2164169 2164169 defendant Sheldrake Mark husbandman 597211 597211 Sheldrake, Mark, of Ketton, husbandman 1
4611349 2234610 2234610 plaintiff Clerk William   597211 597211 Clerk, William, of Ketton 0
5159856 2403981 2403981 plaintiff Scherman John husbandman 597211 597211 Scherman, John, of Ketton, husbandman 0
5174840 2408337 2408337 plaintiff Scherman John husbandman 597211 597211 Scherman, John, of Ketton, husbandman 0
5195685 2414482 2414482 plaintiff Scherman John husbandman 597211 597211 Scherman, John, of Ketton, husbandman 0
5547937 2519425 2519425 defendant Person William husbandman 597211 597211 Person, William, of Ketton, husbandman 0
5574678 2527155 2527155 defendant Pyper John laborer 597211 597211 Pyper, John, of Ketton, laborer 2
5581959 2529439 2529439 defendant Davy Thomas husbandman 597211 597211 Davy, Thomas, of Ketton, husbandman 2
5588616 2531447 2531447 plaintiff Pereson William   597211 597211 Pereson, William, of Ketton 0
5599941 2534862 2534862 defendant Greneham Thomas gent 597211 597211 Greneham, Thomas, of Ketton, gent 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);