names

28 rows where place_id = 603199

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653838 1911462 1911462 defendant Cokette John yeoman 603199 603199 Cokette, John, of Thaksted, Essex, yeoman 0
3661824 1913981 1913981 defendant Apulford John yeoman 603199 603199 Apulford, John, of Thaksted, Essex, yeoman 0
3708583 1928984 1928984 defendant Taylour John chapman 603199 603199 Taylour, John, of Thaksted, Essex, chapman 1
3714741 1930911 1930911 defendant Aburforth John draper 603199 603199 Aburforth, John, of Thaksted, Essex, draper 0
3722098 1933174 1933174 defendant Atkyns William bricklayer 603199 603199 Atkyns, William, of Thaksted, Essex, bricklayer 0
3775691 1950145 1950145 defendant Apylforth John clothmaker 603199 603199 Apylforth, John, of Thaksted, Essex, clothmaker 1
3780676 1951686 1951686 defendant Nicols Robert yeoman 603199 603199 Nicols, Robert, of Thaksted, essex, yeoman 0
3796836 1956890 1956890 defendant Marsham Thomas pardoner 603199 603199 Marsham, Thomas, of Thaksted, Essex, pardoner 2
3869934 1980186 1980186 defendant Spencer John draper 603199 603199 Spencer, John, of Thaksted, Essex, draper 1
3876486 1982383 1982383 defendant Teyler John pedder 603199 603199 Teyler, John, of Thaksted, Essex, pedder 0
3888885 1986530 1986530 defendant Northie Thomas haberdasher 603199 603199 Northie, Thomas, of Thaksted, Essex, haberdasher 0
4670004 2256316 2256316 defendant Jankyn Ralph cutler 603199 603199 Jankyn, Ralph, of Thaksted, Essex, cutler 1
4852059 2312074 2312074 defendant Rynger John smith 603199 603199 Rynger, John, of Thaksted, Essex, smith 1
4862354 2315234 2315234 defendant Elyere Robert butcher 603199 603199 Elyere, Robert, of Thaksted, Essex, butcher 0
4935195 2337411 2337411 defendant Basset John cutler 603199 603199 Basset, John, of Thaksted, Essex, cutler 0
5000981 2357166 2357166 defendant Eweyne Roger smith 603199 603199 Eweyne, Roger, of Thaksted, Essex, smith 2
5000986 2357167 2357167 defendant Eweyne Roger smith 603199 603199 Eweyne, Roger, of Thaksted, Essex, smith 2
5047240 2370796 2370796 defendant Spycer John yeoman 603199 603199 Spycer, John, of Thaksted, Essex, yeoman 2
5051271 2371993 2371993 defendant Sawarde Thomas   603199 603199 Sawarde, Thomas, of Thaksted, Essex, inland fish seller 1
5276397 2438165 2438165 defendant Rewys Nicholas   603199 603199 Rewys, Nicholas, of Thaksted, Essex, vicar 1
5290191 2442134 2442134 defendant Travers John painter 603199 603199 Travers, John, of Thaksted, Essex, painter 0
5393940 2473326 2473326 defendant Styward David clerk & vicar 603199 603199 Styward, David, of Thaksted, Essex, clerk & vicar 1
5407122 2477097 2477097 defendant Styward David clerk & vicar 603199 603199 Styward, David, of Thaksted, Essex, clerk & vicar 1
5420307 2480999 2480999 defendant Styward David clerk & vicar 603199 603199 Styward, David, of Thaksted, Essex, clerk & vicar 1
5484070 2500171 2500171 defendant Damary Richard yeoman 603199 603199 Damary, Richard, of Thaksted, Essex, yeoman 0
5523763 2512257 2512257 defendant Hasilwod Thomas   603199 603199 Hasilwod, Thomas, of Thaksted, Essex, blade smith 0
5525642 2512612 2512612 defendant Fanne John yeoman 603199 603199 Fanne, John, of Thaksted, Essex, yeoman 1
5525647 2512613 2512613 defendant Fanne John yeoman 603199 603199 Fanne, John, of Thaksted, Essex, yeoman 1

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