names

17 rows where place_id = 595284

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619836 1873780 1873780 defendant Fanham Thomas yeoman 595284 595284 Fanham, Thomas, of Chetgrave, yeoman 1
3804895 1959475 1959475 defendant Bungay William tailor 595284 595284 Bungay, William, of Chetgrave, tailor 0
3825674 1965883 1965883 defendant Wyllyomson Roger husbandman 595284 595284 Wyllyomson, Roger, of Chetgrave, husbandman 2
3851758 1974139 1974139 plaintiff Peyntour John clerk 595284 595284 Peyntour, John, of Chetgrave, clerk 0
3915146 1995424 1995424 defendant Chamler or Chamber Thomas husbandman 595284 595284 Chamler or Chamber, Thomas, of Chetgrave, husbandman 0
3915147 1995424 1995424 defendant Dyman Robert yeoman 595284 595284 Dyman, Robert, of Chetgrave, yeoman 1
4018155 2031216 2031216 defendant Skarnyng Thomas husbandman 595284 595284 Skarnyng, Thomas, of Chetgrave, husbandman 0
4069940 2049532 2049532 defendant Fyske Thomas carpenter 595284 595284 Fyske, Thomas, of Chetgrave, carpenter 0
4105010 2062065 2062065 defendant Waller Geoffrey butcher 595284 595284 Waller, Geoffrey, of Chetgrave, butcher 0
4107996 2063133 2063133 defendant Skaringe John husbandman 595284 595284 (Skaringe, John, of Chetgrave, husbandman 2
4111431 2064336 2064336 defendant Grenleff Walter husbandman 595284 595284 Grenleff, Walter, of Chetgrave, husbandman 0
4177319 2087540 2087540 defendant Fyske Thomas carpenter 595284 595284 Fyske, Thomas, of Chetgrave, carpenter 0
4251121 2113354 2113354 defendant Norman William miller 595284 595284 Norman, William, of Chetgrave, miller 0
4251123 2113354 2113354 defendant Fyske Robert weaver 595284 595284 Fyske, Robert, of Chetgrave, weaver 2
4286175 2125109 2125109 defendant Day John yeoman 595284 595284 Day, John, of Chetgrave, yeoman 0
5243899 2428407 2428407 defendant Bacon Peter yeoman 595284 595284 Bacon, Peter, of Chetgrave, yeoman 6
5549668 2519948 2519948 defendant Styward Joan widow 595284 595284 Styward, Joan, of Chetgrave, widow 7

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