names

45 rows where place_id = 591536

✎ 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
3604706 1869135 1869135 defendant Scottowe Thomas husbandman 591536 591536 Scottowe, Thomas, of Corpsty, husbandman 0
3623988 1875035 1875035 defendant Nell William clerk 591536 591536 Nell, William, of Corpsty, clerk 0
3623989 1875035 1875035 defendant Scothowe Thomas butcher 591536 591536 Scothowe, Thomas, of Corpsty, butcher 1
3783168 1952492 1952492 defendant Neel John laborer 591536 591536 Neel, John, of Corpsty, laborer 1
3783169 1952492 1952492 defendant Harward Thomas laborer 591536 591536 Harward, Thomas, of Corpsty, laborer 2
3783173 1952493 1952493 defendant Neell John laborer 591536 591536 Neell, John, of Corpsty, laborer 1
3783174 1952493 1952493 defendant Harward Thomas laborer 591536 591536 Harward, Thomas, of Corpsty, laborer 2
3937134 2002754 2002754 defendant Jagges Nicholas merchant 591536 591536 Jagges, Nicholas, of Corpsty, merchant 0
4313336 2134772 2134772 defendant Colfer William yeoman 591536 591536 Colfer, William, of Corpsty, yeoman 0
4332581 2141185 2141185 defendant Bacon William gent 591536 591536 Bacon, William, of Corpsty, gent 0
4445706 2183610 2183610 defendant Oldhous William   591536 591536 Oldhous, William, of Corpsty 13
4459330 2187968 2187968 defendant Lawes Adam   591536 591536 Lawes, Adam, of Corpsty 0
4480941 2194712 2194712 defendant Dally John   591536 591536 Dally, John, of Corpsty 0
4494911 2199093 2199093 defendant Lawes Thomas   591536 591536 Lawes, Thomas, of Corpsty 4
4524031 2207849 2207849 defendant Fychet John   591536 591536 Fychet, John, of Corpsty 0
4524032 2207849 2207849 defendant Fravy or Frany John   591536 591536 Fravy or Frany, John, of Corpsty 1
4635960 2242082 2242082 defendant Millere Henry   591536 591536 Millere, Henry, of Corpsty 1
4655037 2247459 2247459 defendant Crabbegate John yeoman 591536 591536 Crabbegate, John, of Corpsty, yeoman 1
4677951 2258721 2258721 defendant Crabgate John husbandman 591536 591536 Crabgate, John, of Corpsty, husbandman 0
4708484 2268021 2268021 defendant Certere William yeoman 591536 591536 Certere, William, of Corpsty, yeoman 0
4769409 2286406 2286406 defendant Peese William yeoman 591536 591536 Peese, William, of Corpsty, yeoman 0
4769410 2286406 2286406 defendant Arnald William husbandman 591536 591536 Arnald, William, of Corpsty, husbandman 1
4831222 2305794 2305794 defendant Inglot John husbandman 591536 591536 Inglot, John, of Corpsty, husbandman 4
4841097 2308750 2308750 plaintiff Inglot John   591536 591536 Inglot, John, of Corpsty 0
4841098 2308750 2308750 plaintiff Mores Walter   591536 591536 Mores, Walter, of Corpsty 1
4851941 2312041 2312041 defendant Noloth John husbandman 591536 591536 Noloth, John, of Corpsty, husbandman 4
4858190 2313931 2313931 defendant Skothowe Thomas husbandman 591536 591536 Skothowe, Thomas, of Corpsty, husbandman 1
4866087 2316365 2316365 defendant Skothowe Thomas laborer 591536 591536 Skothowe, Thomas, of Corpsty, laborer 1
4895372 2325212 2325212 defendant Merwen John yeoman 591536 591536 Merwen, John, of Corpsty, yeoman 2
4904427 2327997 2327997 defendant Merwen John yeoman 591536 591536 Merwen, John, of Corpsty, yeoman 2
4965536 2346611 2346611 defendant Morwyn John husbandman 591536 591536 Morwyn, John, of Corpsty, husbandman 1
5022819 2363585 2363585 defendant Tante John laborer 591536 591536 Tante, John, of Corpsty, laborer 0
5022820 2363585 2363585 defendant Inglot John weaver 591536 591536 Inglot, John, of Corpsty, weaver 1
5026872 2364729 2364729 defendant Inglot John weaver 591536 591536 Inglot, John, of Corpsty, weaver 0
5037644 2367884 2367884 defendant Inglot John   591536 591536 Inglot, John, of Corpsty, worsted weaver 0
5071207 2377885 2377885 defendant Goos John shoemaker 591536 591536 Goos, John, of Corpsty, shoemaker 3
5095098 2384982 2384982 plaintiff Seman Thomas   591536 591536 Seman, Thomas, of Corpsty 0
5095099 2384982 2384982 defendant Merwyn John husbandman 591536 591536 Merwyn, John, of Corpsty, husbandman 0
5145522 2399835 2399835 defendant Devenyssh William laborer 591536 591536 Devenyssh, William, of Corpsty, laborer 0
5173272 2407896 2407896 defendant Engelot John weaver 591536 591536 Engelot, John, of Corpsty, weaver 1
5177374 2409076 2409076 defendant Marwyn John husbandman 591536 591536 Marwyn, John, of Corpsty, husbandman 0
5193209 2413743 2413743 defendant Engelot John weaver 591536 591536 Engelot, John, of Corpsty, weaver 1
5529114 2513621 2513621 defendant Skotte William, junior husbandman 591536 591536 Skotte, William, junior, of Corpsty, husbandman 0
5529117 2513622 2513622 defendant Skotte William, junior husbandman 591536 591536 Skotte, William, junior, of Corpsty, husbandman 0
5585608 2530568 2530568 defendant Mason John husbandman 591536 591536 Mason, John, of Corpsty, husbandman 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);