names

24 rows where place_id = 619383

✎ 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
3729676 1935533 1935533 defendant Coryton Alice widow 619383 619383 Coryton, Alice, of Southwyk, widow 0
3887605 1986103 1986103 defendant Humbage Richard husbandman 619383 619383 Humbage, Richard, of Southwyk, husbandman 0
3887606 1986103 1986103 defendant Humbage John husbandman 619383 619383 Humbage, John, of Southwyk, husbandman 1
4613823 2235338 2235338 defendant Kyng John   619383 619383 Kyng, John, of Southwyk 2
4667136 2255456 2255456 defendant Stokes John husbandman 619383 619383 Stokes, John, of Southwyk, husbandman 2
4700229 2265489 2265489 defendant Stokys John gent 619383 619383 Stokys, John, of Southwyk, gent 0
4700230 2265489 2265489 defendant Veys John husbandman 619383 619383 Veys, John, of Southwyk, husbandman 1
4728856 2274263 2274263 defendant Stoke John husbandman 619383 619383 Stoke, John, of Southwyk, husbandman 0
4765091 2285060 2285060 defendant Gryme John yeoman 619383 619383 Gryme, John, of Southwyk, yeoman 0
4925018 2334256 2334256 defendant Kelly John esq 619383 619383 Kelly, John, of Southwyk, esq 0
4954710 2343362 2343362 defendant Beryman Peter tanner 619383 619383 Beryman, Peter, of Southwyk, tanner 0
4988587 2353544 2353544 defendant Bayle John yeoman 619383 619383 Bayle, John, of Southwyk, yeoman 1
5129955 2395250 2395250 defendant Bole Robert husbandman 619383 619383 Bole, Robert, of Southwyk, husbandman 1
5149190 2400894 2400894 defendant Bole Robert husbandman 619383 619383 Bole, Robert, of Southwyk, husbandman 1
5299211 2444748 2444748 defendant Howeles Richard gent 619383 619383 Howeles, Richard, of Southwyk, gent 0
5299212 2444748 2444748 defendant Howeles Robert gent 619383 619383 Howeles, Robert, of Southwyk, gent 1
5299215 2444748 2444748 defendant Mychell Thomas butcher 619383 619383 Mychell, Thomas, of Southwyk, butcher 4
5299218 2444749 2444749 defendant Howeles Richard gent 619383 619383 Howeles, Richard, of Southwyk, gent 0
5299219 2444749 2444749 defendant Howeles Robert gent 619383 619383 Howeles, Robert, of Southwyk, gent 1
5299222 2444749 2444749 defendant Mychell Thomas butcher 619383 619383 Mychell, Thomas, of Southwyk, butcher 4
5367392 2465455 2465455 defendant Wever William weaver 619383 619383 Wever, William, of Southwyk, weaver 8
5374471 2467620 2467620 defendant Monke John husbandman 619383 619383 Monke, John, of Southwyk, husbandman 0
5444191 2488168 2488168 defendant Mille Thomas chapman 619383 619383 Mille, Thomas, of Southwyk, chapman 2
5554618 2521382 2521382 defendant Playfote William butcher 619383 619383 Playfote, William, of Southwyk, butcher 3

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