names

42 rows where place_id = 601466

✎ 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
3645497 1908993 1908993 defendant Jowell Henry fuller 601466 601466 Jowell, Henry, of Nedham Markett, fuller 1
3686657 1921981 1921981 defendant Rowght Richard tailor 601466 601466 Rowght, Richard, of Nedham Markett, tailor 0
3704927 1927832 1927832 defendant Awoode Thomas butcher 601466 601466 Awoode, Thomas, of Nedham Markett, butcher 2
3709537 1929291 1929291 plaintiff Raven Thomas   601466 601466 Raven, Thomas, of Nedham Markett 0
3709638 1929323 1929323 defendant Jacob Thomas mercer 601466 601466 Jacob, Thomas, of Nedham Markett, mercer 0
3734670 1937090 1937090 defendant Wode Thomas butcher 601466 601466 Wode, Thomas, of Nedham Markett, butcher 1
3737996 1938098 1938098 defendant Rowce or Rowte Richard tailor 601466 601466 Rowce or Rowte, Richard, of Nedham Markett, tailor 2
3741176 1939101 1939101 defendant Neve Thomas dyer 601466 601466 Neve, Thomas, of Nedham Markett, dyer 2
3741197 1939105 1939105 defendant Neve Thomas dyer 601466 601466 Neve, Thomas, of Nedham Markett, dyer 2
3769034 1947966 1947966 defendant Jacob Thomas mercer 601466 601466 Jacob, Thomas, of Nedham Markett, mercer 0
3770652 1948505 1948505 defendant Bocher Thomas butcher 601466 601466 Bocher, Thomas, of Nedham Markett, butcher 3
3793415 1955805 1955805 defendant Chechelee William laborer 601466 601466 Chechelee, William, of Nedham Markett, laborer 0
3793428 1955809 1955809 defendant Hempston Edward mercer 601466 601466 Hempston, Edward, of Nedham Markett, mercer 1
3795544 1956488 1956488 defendant Stode Robert carver and joiner 601466 601466 Stode, Robert, of Nedham Markett, carver and joiner 1
3803501 1959000 1959000 defendant Newton William husbandman 601466 601466 Newton, William, of Nedham Markett, husbandman 1
3804382 1959307 1959307 defendant Browne John husbandman 601466 601466 Browne, John, of Nedham Markett, husbandman 3
3804831 1959455 1959455 defendant Ravyn Thomas, junior clothmaker 601466 601466 Ravyn, Thomas, junior, of Nedham Markett, clothmaker 1
3804833 1959455 1959455 defendant Browne John dyer 601466 601466 Browne, John, of Nedham Markett, dyer 3
3822832 1965048 1965048 defendant Almott Arnull laborer 601466 601466 Almott, Arnull, of Nedham Markett, laborer 4
3822837 1965049 1965049 defendant Brown John dyer 601466 601466 Brown, John, of Nedham Markett, dyer 3
3859989 1976842 1976842 defendant Woode Thomas butcher 601466 601466 Woode, Thomas, of Nedham Markett, butcher 1
3859991 1976842 1976842 defendant Baron Thomas butcher 601466 601466 Baron, Thomas, of Nedham Markett, butcher 3
3864766 1978411 1978411 defendant A Wode Thomas butcher 601466 601466 A Wode, Thomas, of Nedham Markett, butcher 0
3866395 1978992 1978992 defendant Checheley William singleman 601466 601466 Checheley, William, of Nedham Markett, singleman 0
3866729 1979107 1979107 plaintiff Raven Thomas clothmaker 601466 601466 Raven, Thomas, of Nedham Markett, clothmaker 0
3921952 1997685 1997685 defendant Chamberleyn John clerk 601466 601466 Chamberleyn, John, of Nedham Markett, clerk 1
3994925 2022936 2022936 defendant Fykesse Thomas clothier 601466 601466 Fykesse, Thomas, of Nedham Markett, clothier 0
4029868 2035325 2035325 defendant Scopes Roger husbandman 601466 601466 Scopes, Roger, of Nedham Markett, husbandman 0
4044185 2040373 2040373 defendant Ayswell Thomas joiner 601466 601466 Ayswell, Thomas, of Nedham Markett, joiner 2
4069703 2049450 2049450 defendant Revell Roger yeoman 601466 601466 Revell, Roger, of Nedham Markett, yeoman 0
4154853 2079792 2079792 defendant Cotes Thomas clothier 601466 601466 Cotes, Thomas, of Nedham Markett, clothier 1
4173626 2086230 2086230 defendant Sallmon Robert clothier 601466 601466 Sallmon, Robert, of Nedham Markett, clothier 0
4203348 2096719 2096719 defendant Hunte Roger woollen draper 601466 601466 Hunte. Roger, of Nedham Markett, woollen draper 1
4233704 2107311 2107311 defendant Knappe William clothier 601466 601466 Knappe, William, of Nedham Markett, clothier 1
4240866 2109930 2109930 defendant Deynes Robert butcher 601466 601466 Deynes, Robert, of Nedham Markett, butcher 0
4277370 2122008 2122008 defendant Deynes Robert butcher 601466 601466 Deynes, Robert, of Nedham Markett, butcher 0
4306904 2132555 2132555 defendant Revell Roger mercer 601466 601466 Revell, Roger, of Nedham Markett, mercer 0
4332401 2141127 2141127 defendant Grome Lawrence   601466 601466 Grome, Lawrence, of Nedham Markett, woollen weaver 2
4339814 2143697 2143697 defendant Hatfyld John smith 601466 601466 Hatfyld, John, of Nedham Markett, smith 0
4339815 2143697 2143697 defendant Knapp William clothier 601466 601466 Knapp, William, of Nedham Markett, clothier 1
4352731 2148185 2148185 defendant Colchester William clothier 601466 601466 Colchester, William, of Nedham Markett, clothier 0
4389892 2161243 2161243 defendant Salmon Edmund yeoman 601466 601466 Salmon, Edmund, of Nedham Markett, 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);