names

53 rows where place_id = 599776

✎ 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
3638232 1906778 1906778 defendant Partryche John husbandman 599776 599776 Partryche, John, of Shotley, husbandman 1
3664099 1914724 1914724 defendant Everard William   599776 599776 Everard, William, of Shotley, shipwright 0
3692831 1923952 1923952 defendant Branston Nicholas carpenter 599776 599776 Branston, Nicholas, of Shotley, carpenter 0
3692833 1923953 1923953 defendant Branston Richard tailor 599776 599776 Branston, Richard, of Shotley, tailor 0
3693850 1924277 1924277 defendant Yaxley Thomas clerk 599776 599776 Yaxley, Thomas, of Shotley, clerk 0
3748667 1941510 1941510 defendant Creme John husbandman 599776 599776 Creme, John, of Shotley, husbandman 0
3748668 1941510 1941510 defendant Pylborough John husbandman 599776 599776 Pylborough, John, of Shotley, husbandman 1
3778583 1951014 1951014 defendant Stratton William gent 599776 599776 Stratton, William, of Shotley, gent 0
3788933 1954350 1954350 defendant Battell John laborer 599776 599776 Battell, John, of Shotley, laborer 0
3788934 1954350 1954350 defendant Smyth John mariner 599776 599776 Smyth, John, of Shotley, mariner 1
3806352 1959900 1959900 defendant Mepoll John husbandman 599776 599776 Mepoll, John, of Shotley, husbandman 3
3886134 1985613 1985613 defendant Stratton George gent 599776 599776 Stratton, George, of Shotley, gent 0
3910021 1993659 1993659 defendant Pylbarowe John husbandman 599776 599776 Pylbarowe, John, of Shotley, husbandman 0
3910022 1993659 1993659 defendant Smyth John mariner 599776 599776 Smyth, John, of Shotley, mariner 1
3910023 1993659 1993659 defendant Burward Robert mariner 599776 599776 Burward, Robert, of Shotley, mariner 2
3953272 2008213 2008213 defendant Rychemond Thomas yeoman 599776 599776 Rychemond, Thomas, of Shotley, yeoman 0
3953274 2008214 2008214 defendant Rychemond Thomas yeoman 599776 599776 Rychemond, Thomas, of Shotley, yeoman 0
4126410 2069733 2069733 defendant Moore Robert   599776 599776 Moore, Robert, of Shotley, shipwright or coach maker 2
4126415 2069734 2069734 defendant Stevens Simon shoemaker 599776 599776 Stevens, Simon, of Shotley, shoemaker 2
4145010 2076414 2076414 defendant Mannynge Robert yeoman 599776 599776 Mannynge, Robert, of Shotley, yeoman 0
4145011 2076414 2076414 defendant Backler Mary widow 599776 599776 Backler, Mary, of Shotley, widow 1
4149876 2078086 2078086 defendant Stevens Simon shoemaker 599776 599776 Stevens, Simon, of Shotley, shoemaker 0
4149877 2078086 2078086 defendant Mannyng Robert husbandman 599776 599776 Mannyng, Robert, of Shotley, husbandman 1
4237038 2108536 2108536 defendant Smyth Roger   599776 599776 Smyth, Roger, of Shotley, sailor 2
4241193 2110042 2110042 defendant Hubberd John yeoman 599776 599776 Hubberd, John, of Shotley, yeoman 2
4285003 2124685 2124685 defendant Smythe Roger   599776 599776 Smythe, Roger, of Shotley, Suff, sailor 0
4291155 2126903 2126903 defendant Abbes Christopher clerk 599776 599776 Abbes, Christopher, of Shotley, clerk 0
4304183 2131595 2131595 defendant Smyth Roger   599776 599776 Smyth, Roger, of Shotley, sailor 0
4390395 2161410 2161410 defendant Smythe Richard husbandman 599776 599776 Smythe, Richard, of Shotley, husbandman 3
4762469 2284244 2284244 defendant Mosell Thomas husbandman 599776 599776 Mosell, Thomas, of Shotley, husbandman 0
4762474 2284245 2284245 defendant Mosell Thomas husbandman 599776 599776 Mosell, Thomas, of Shotley, husbandman 0
4841370 2308835 2308835 defendant Pouter Thomas yeoman 599776 599776 Pouter, Thomas, of Shotley, yeoman 2
4955508 2343608 2343608 defendant Heberd Alice gent 599776 599776 Heberd, Alice, of Shotley, widow of Heberd, John, gent 0
5015374 2361377 2361377 defendant Algoode John yeoman 599776 599776 Algoode, John, of Shotley, yeoman 2
5015375 2361377 2361377 defendant Burward Robert husbandman 599776 599776 Burward, Robert, of Shotley, husbandman 3
5064383 2375892 2375892 defendant Mors John yeoman 599776 599776 Mors, John, of Shotley, yeoman 12
5150349 2401232 2401232 defendant Stroute John husbandman 599776 599776 Stroute, John, of Shotley, husbandman 1
5150350 2401232 2401232 defendant Stroute Thomas husbandman 599776 599776 Stroute, Thomas, of Shotley, husbandman 2
5158236 2403529 2403529 defendant Elys Thomas husbandman 599776 599776 Elys, Thomas, of Shotley, husbandman 0
5167513 2406228 2406228 defendant Stroute Thomas weaver 599776 599776 Stroute, Thomas, of Shotley, weaver 0
5168915 2406637 2406637 defendant Stroute John husbandman 599776 599776 Stroute, John, of Shotley, husbandman 1
5168916 2406637 2406637 defendant Stroute Thomas husbandman 599776 599776 Stroute, Thomas, of Shotley, husbandman 2
5175286 2408464 2408464 defendant Stroute Thomas husbandman 599776 599776 Stroute, Thomas, of Shotley, husbandman 1
5193925 2413952 2413952 defendant Elys Thomas husbandman 599776 599776 Elys, Thomas, of Shotley, husbandman 0
5246625 2429174 2429174 defendant Stront Thomas weaver 599776 599776 Stront, Thomas, of Shotley, weaver 3
5248886 2429796 2429796 defendant Pyksomer Robert tailor 599776 599776 Pyksomer, Robert, of Shotley, tailor 0
5248887 2429796 2429796 defendant Tyler Richard laborer 599776 599776 Tyler, Richard, of Shotley, laborer 1
5248889 2429796 2429796 defendant Pyksomer Robert carpenter 599776 599776 Pyksomer, Robert, of Shotley, carpenter 3
5251275 2430502 2430502 defendant Strout William fuller 599776 599776 Strout, William, of Shotley, fuller 0
5316262 2449950 2449950 defendant Chapman John gent 599776 599776 (Chapman, John, of Shotley, gent 1
5518799 2510713 2510713 plaintiff Artell Thomas   599776 599776 Artell, Thomas, of Shotley 0
5536495 2515899 2515899 defendant Arcle Thomas mariner 599776 599776 Arcle, Thomas, of Shotley, mariner 3
5536496 2515899 2515899 defendant Adams John mariner 599776 599776 Adams, John, of Shotley, mariner 4

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);