names

20 rows where place_id = 594521

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616453 1872784 1872784 defendant Willesdon William gent 594521 594521 Willesdon, William, of Chulmelegh, gent 0
3630280 1904319 1904319 defendant Thaccher William laborer 594521 594521 Thaccher, William, of Chulmelegh, laborer 0
3630281 1904319 1904319 defendant Horewode John laborer 594521 594521 Horewode, John, of Chulmelegh, laborer 1
3943852 2004960 2004960 defendant Bennett Philip husbandman 594521 594521 Bennett, Philip, of Chulmelegh, husbandman 1
4007334 2027405 2027405 defendant Crispyn Adam husbandman 594521 594521 Crispyn, Adam, of Chulmelegh, husbandman 0
4045554 2040860 2040860 defendant Heale Henry yeoman 594521 594521 Heale, Henry, of Chulmelegh, yeoman 0
4045556 2040861 2040861 defendant Hele Henry yeoman 594521 594521 Hele, Henry, of Chulmelegh, yeoman 0
4055273 2044285 2044285 defendant Hele George yeoman 594521 594521 Hele, George, of Chulmelegh, yeoman 0
4140504 2074848 2074848 defendant Ferrett Nicholas carpenter 594521 594521 Ferrett, Nicholas, of Chulmelegh, carpenter 0
4611764 2234743 2234743 defendant Lane William   594521 594521 Lane, William, of Chulmelegh, parson 0
4639323 2243014 2243014 defendant Beare John   594521 594521 Beare, John, of Chulmelegh 3
4738468 2277123 2277123 defendant Pakker John tailor 594521 594521 Pakker, John, of Chulmelegh, tailor 0
4738472 2277124 2277124 defendant Pakker John tailor 594521 594521 Pakker, John, of Chulmelegh, tailor 0
4804171 2297493 2297493 defendant Lakehede Richard husbandman 594521 594521 Lakehede, Richard, of Chulmelegh, husbandman 2
5589341 2531669 2531669 defendant Rawe Thomas husbandman 594521 594521 Rawe, Thomas, of Chulmelegh, husbandman 0
5589342 2531669 2531669 defendant Rawe William husbandman 594521 594521 Rawe, William, of Chulmelegh, husbandman 1
5591276 2532237 2532237 defendant at Froste Joan widow 594521 594521 at Froste, Joan, of Chulmelegh, widow 0
5604393 2536238 2536238 defendant Squyer John husbandman 594521 594521 Squyer, John, of Chulmelegh, husbandman 0
5604394 2536238 2536238 defendant Saunder John tucker 594521 594521 Saunder, John, of Chulmelegh, tucker 1
5604395 2536238 2536238 defendant Shore John weaver 594521 594521 Shore, John, of Chulmelegh, weaver 2

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