names

19 rows where place_id = 759809

✎ 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
4464475 2189556 2189556 defendant Underwode Nicholas   759809 759809 Underwode, Nicholas, of Hanfeld 0
4502411 2201337 2201337 defendant Pokerle Willaim   759809 759809 Pokerle, Willaim, of Hanfeld 9
4940038 2338911 2338911 defendant Graunt John gent 759809 759809 Graunt, John, of Hanfeld, gent 0
4940041 2338912 2338912 defendant Walder William husbandman 759809 759809 Walder, William, of Hanfeld, husbandman 1
4965827 2346709 2346709 defendant Graunt John gent 759809 759809 Graunt, John, of Hanfeld, gent 0
4995547 2355508 2355508 defendant Frensheman Philip carpenter 759809 759809 Frensheman, Philip, of Hanfeld, carpenter 0
4995548 2355508 2355508 defendant Martyn John sawyer 759809 759809 Martyn, John, of Hanfeld, sawyer 1
4995550 2355509 2355509 defendant Frenssheman Philip carpenter 759809 759809 Frenssheman, Philip, of Hanfeld, carpenter 0
4995551 2355509 2355509 defendant Martyn John sawyer 759809 759809 Martyn, John, of Hanfeld, sawyer 1
4998362 2356385 2356385 defendant Gylberd Julia widow 759809 759809 Gylberd, Julia, of Hanfeld, widow 2
5009064 2359533 2359533 defendant Norton Thomas husbandman 759809 759809 Norton, Thomas, of Hanfeld, husbandman 3
5009069 2359534 2359534 defendant Norton Thomas husbandman 759809 759809 Norton, Thomas, of Hanfeld, husbandman 3
5045709 2370352 2370352 defendant Dauncer Robert clerk 759809 759809 Dauncer, Robert, of Hanfeld, clerk 0
5045710 2370352 2370352 defendant Benet Thomas husbandman 759809 759809 Benet, Thomas, of Hanfeld, husbandman 1
5045711 2370352 2370352 defendant Webbe William laborer 759809 759809 Webbe, William, of Hanfeld, laborer 2
5049112 2371367 2371367 defendant Daunser Robert clerk 759809 759809 Daunser, Robert, of Hanfeld, clerk 0
5073642 2378599 2378599 defendant Holden Walter butcher 759809 759809 Holden, Walter, of Hanfeld, butcher 0
5073643 2378599 2378599 defendant Holden William laborer 759809 759809 Holden, William, of Hanfeld, laborer 1
5073644 2378599 2378599 defendant Man William tailor 759809 759809 Man, William, of Hanfeld, tailor 2

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