names

21 rows where place_id = 603267

✎ 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
3654013 1911518 1911518 defendant Cowper John chapman 603267 603267 Cowper, John, of Stanford, Lincs, chapman 3
3704526 1927709 1927709 defendant Button Richard fletcher 603267 603267 Button, Richard, of Stanford, Lincs, fletcher 2
3792657 1955562 1955562 defendant Cowper John, senior chapman 603267 603267 Cowper, John, senior, of Stanford, Lincs, chapman 0
3792675 1955565 1955565 defendant Cowper John, senior chapman 603267 603267 Cowper, John, senior, of Stanford, Lincs, chapman 0
3909379 1993437 1993437 defendant Warne Thomas mercer 603267 603267 Warne, Thomas, of Stanford, Lincs, mercer 0
4039563 2038771 2038771 defendant Wood Hugh vintner 603267 603267 Wood, Hugh, of Stanford, Lincs, vintner 0
4134736 2072751 2072751 defendant Dymocke John vintner 603267 603267 Dymocke, John, of Stanford, Lincs, vintner 0
4176187 2087147 2087147 defendant Dyckenson Richard vintner 603267 603267 Dyckenson, Richard, of Stanford, Lincs, vintner 0
4177371 2087558 2087558 defendant Blynckhern James vintner 603267 603267 Blynckhern, James, of Stanford, Lincs, vintner 0
4190112 2092046 2092046 defendant Grene Alexander ironmonger 603267 603267 Grene, Alexander, of Stanford, Lincs, ironmonger 0
4192762 2093028 2093028 defendant Colsell William clerk 603267 603267 Colsell, William, of Stanford, Lincs, clerk 2
4348253 2146638 2146638 defendant Porter Garrard or Jarratt chapman 603267 603267 Porter, Garrard or Jarratt, of Stanford, Lincs, chapman 0
4820671 2302539 2302539 plaintiff Repynggale William butcher 603267 603267 Repynggale, William, of Stanford, Lincs, butcher, on his own account 0
4827381 2304612 2304612 defendant Knyght William draper 603267 603267 Knyght, William, of Stanford, Lincs, draper 0
5000557 2357032 2357032 defendant Chapman Walter husbandman 603267 603267 Chapman, Walter, of Stanford, Lincs, husbandman 2
5324953 2452543 2452543 defendant Chapman alias Harlam William gent 603267 603267 Chapman alias Harlam, William, of Stanford, Lincs, gent 1
5324969 2452546 2452546 defendant Chapman alias Harlam William gent 603267 603267 Chapman alias Harlam, William, of Stanford, Lincs, gent 1
5465322 2494535 2494535 defendant Parnell Thomas chapman 603267 603267 Parnell, Thomas, of Stanford, Lincs, chapman 1
5465327 2494536 2494536 defendant Parnell Thomas chapman 603267 603267 Parnell, Thomas, of Stanford, Lincs, chapman 1
5516912 2510115 2510115 defendant Barford John dyer 603267 603267 Barford, John, of Stanford, Lincs, dyer 0
5564920 2524326 2524326 defendant Brodmer James mercer 603267 603267 Brodmer, James, of Stanford, Lincs, mercer 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);