names

15 rows where place_id = 609478

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3678564 1919352 1919352 defendant Drury John gent 609478 609478 Drury, John, of Rougham, Suff, gent 2
3708483 1928952 1928952 defendant Drury John gent 609478 609478 Drury, John, of Rougham, Suff, gent 0
3708500 1928956 1928956 defendant Drury John gent 609478 609478 Drury, John, of Rougham, Suff, gent 2
3764289 1946490 1946490 defendant West Edmund gent 609478 609478 West, Edmund, of Rougham, Suff, gent 0
3958564 2010066 2010066 defendant Drury John esq 609478 609478 Drury, John, of Rougham, Suff, esq 0
3961575 2011146 2011146 plaintiff Tyllott John maltster 609478 609478 Tyllott, John, of Rougham, Suff, maltster 0
4018305 2031274 2031274 plaintiff Tyllett Leoinard   609478 609478 Tyllett, Leoinard, of Rougham, Suff 0
4275731 2121459 2121459 defendant Markaunt Edmund gent 609478 609478 Markaunt, Edmund, of Rougham, Suff, gent 0
4347586 2146403 2146403 defendant Tillett Thomas, junior yeoman 609478 609478 Tillett, Thomas, junior, of Rougham, Suff, yeoman 0
5042456 2369351 2369351 defendant Hog Robert yeoman 609478 609478 Hog, Robert, of Rougham, Suff, yeoman 1
5042610 2369391 2369391 defendant Hog Robert yeoman 609478 609478 Hog, Robert, of Rougham, Suff, yeoman 1
5164977 2405495 2405495 defendant Hog John husbandman 609478 609478 Hog, John, of Rougham, Suff, husbandman 0
5178649 2409469 2409469 defendant Hog John husbandman 609478 609478 Hog, John, of Rougham, Suff, husbandman 0
5321936 2451631 2451631 defendant Mulley Edmund husbandman 609478 609478 Mulley, Edmund, of Rougham, Suff, husbandman 0
5333335 2455042 2455042 defendant Drewery Thomas esq 609478 609478 Drewery, Thomas, of Rougham, Suff, esq 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);