names

28 rows where place_id = 598550

✎ 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
3633018 1905147 1905147 defendant Callough Simon husbandman 598550 598550 Callough, Simon, of Algerkyrk, husbandman 1
3633019 1905147 1905147 defendant Gybon Thomas armorer 598550 598550 Gybon, Thomas, of Algerkyrk, armorer 2
3655905 1912101 1912101 defendant Hennyng Richard husbandman 598550 598550 Hennyng, Richard, of Algerkyrk, husbandman 0
3655906 1912101 1912101 defendant Pykeryng Richard   598550 598550 Pykeryng, Richard, of Algerkyrk, basket maker 1
3657784 1912686 1912686 defendant Lylly William yeoman 598550 598550 Lylly, William, of Algerkyrk, yeoman 0
3659169 1913125 1913125 defendant Gybon Robert husbandman 598550 598550 Gybon, Robert, of Algerkyrk, husbandman 0
3659174 1913126 1913126 defendant Gybon Robert husbandman 598550 598550 Gybon, Robert, of Algerkyrk, husbandman 0
3664315 1914790 1914790 defendant London Richard husbandman 598550 598550 London, Richard, of Algerkyrk, husbandman 0
3665048 1915015 1915015 defendant Haddon Hugh brewer 598550 598550 (Haddon, Hugh, of Algerkyrk, brewer 1
3690279 1923121 1923121 defendant Wals Robert husbandman 598550 598550 Wals, Robert, of Algerkyrk, husbandman 1
3728941 1935297 1935297 defendant Grice Thomas husbandman 598550 598550 Grice, Thomas, of Algerkyrk, husbandman 1
3736431 1937638 1937638 defendant Bowde Thomas laborer 598550 598550 Bowde, Thomas, of Algerkyrk, laborer 2
4787224 2292072 2292072 defendant Gildento Robert husbandman 598550 598550 Gildento, Robert, of Algerkyrk, husbandman 0
4874326 2318913 2318913 defendant Brunham John gent 598550 598550 Brunham, John, of Algerkyrk, gent 0
4995027 2355369 2355369 defendant Gybon John (legal representative) 598550 598550 Gybon, John, of Algerkyrk, laborer, executors of 0
4996732 2355881 2355881 defendant Abram Mary widow 598550 598550 Abram, Mary, of Algerkyrk, widow 0
5032628 2366426 2366426 defendant Hengill Thomas chaplain 598550 598550 Hengill, Thomas, of Algerkyrk, chaplain 0
5042566 2369382 2369382 defendant London Thomas husbandman 598550 598550 London, Thomas, of Algerkyrk, husbandman 0
5042567 2369382 2369382 defendant London William husbandman 598550 598550 London, William, of Algerkyrk, husbandman 1
5108156 2388822 2388822 defendant Pantre William husbandman 598550 598550 Pantre, William, of Algerkyrk, husbandman 2
5112322 2389991 2389991 defendant Burnham Thomas gent 598550 598550 Burnham, Thomas, of Algerkyrk, gent 1
5112323 2389991 2389991 defendant Proctour William husbandman 598550 598550 Proctour, William, of Algerkyrk, husbandman 2
5165361 2405616 2405616 defendant Bermyngeham Morris   598550 598550 Bermyngeham, Morris, of Algerkyrk, parson 0
5170717 2407156 2407156 defendant Felde Robert yeoman 598550 598550 Felde, Robert, of Algerkyrk, yeoman 0
5220292 2421630 2421630 defendant Tomson John husbandman 598550 598550 Tomson, John, of Algerkyrk, husbandman 2
5589029 2531578 2531578 defendant Clough Robert chapman 598550 598550 Clough, Robert, of Algerkyrk, chapman 2
5612319 2547600 2547600 defendant Polvertoft Roger de   598550 598550 Polvertoft, Roger de, of Algerkyrk 3
5612320 2547600 2547600 defendant Ordyng Robert   598550 598550 Ordyng, Robert, of Algerkyrk 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);