names

27 rows where place_id = 586217

✎ 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
3588189 1863960 1863960 defendant Saxton John tailor 586217 586217 Saxton, John, of Egham, Surrey, tailor 0
3601644 1868170 1868170 defendant Clerk Thomas dyer 586217 586217 Clerk, Thomas, of Egham, Surrey, dyer 1
3636227 1906121 1906121 defendant Adamson Richard yeoman 586217 586217 Adamson, Richard, of Egham, Surrey, yeoman 1
3871067 1980576 1980576 defendant Avelyng alias Haelyn John bargeman 586217 586217 Avelyng alias Haelyn, John, of Egham, Surrey, bargeman 0
3944449 2005159 2005159 plaintiff Bartilmewe Joan widow 586217 586217 Bartilmewe, Joan, of Egham, Surrey, widow 0
4066013 2048133 2048133 defendant Kynge John yeoman 586217 586217 Kynge, John, of Egham, Surrey, yeoman 0
4093265 2057909 2057909 defendant Goringe Thomas smith 586217 586217 Goringe, Thomas, of Egham, Surrey, smith 1
4193015 2093124 2093124 defendant Bowtell alias Bover Thomas gent 586217 586217 Bowtell alias Bover, Thomas, of Egham, Surrey, gent 0
4283980 2124314 2124314 defendant Norrys John yeoman 586217 586217 Norrys, John, of Egham, Surrey, yeoman 1
4286271 2125142 2125142 defendant Owen Edward embroiderer 586217 586217 Owen, Edward, of Egham, Surrey, gent, embroiderer 0
4328626 2139889 2139889 defendant Reynold John yeoman 586217 586217 Reynold, John, of Egham, Surrey, yeoman 1
4340657 2144002 2144002 defendant Owen Edward embroiderer 586217 586217 Owen, Edward, of Egham, Surrey, gent, or of London, embroiderer 0
4347004 2146206 2146206 defendant Prentyce John husbandman 586217 586217 Prentyce, John, of Egham, Surrey, husbandman 0
4370852 2154630 2154630 defendant Prentyce John husbandman 586217 586217 Prentyce, John, of Egham, Surrey, husbandman 0
4378868 2157518 2157518 defendant Standen John   586217 586217 Standen, John, of Egham, Surrey, clerk, vicar 0
5017827 2362094 2362094 defendant Elys Simon yeoman 586217 586217 Elys, Simon, of Egham, Surrey, yeoman 0
5152144 2401764 2401764 defendant Butyll John smith 586217 586217 Butyll, John, of Egham, Surrey, smith 3
5156652 2403101 2403101 defendant Mileham Robert tanner 586217 586217 Mileham, Robert, of Egham, Surrey, tanner 0
5172777 2407769 2407769 defendant Mileham Robert tanner 586217 586217 Mileham, Robert, of Egham, Surrey, tanner 0
5192588 2413565 2413565 defendant Mileham Robert tanner 586217 586217 Mileham, Robert, of Egham, Surrey, tanner 0
5207516 2417940 2417940 defendant Mylys Nicholas husbandman 586217 586217 Mylys, Nicholas, of Egham, Surrey, husbandman 0
5280995 2439522 2439522 defendant Gilbert Thomas Walter 586217 586217 Gilbert, Thomas, of Egham, Surrey, husbandman, son of Gylbert, Walter 0
5291419 2442493 2442493 defendant Lese John husbandman 586217 586217 Lese, John, of Egham, Surrey, husbandman 0
5321299 2451465 2451465 defendant Mylton alias Middelton Henry gent 586217 586217 Mylton alias Middelton, Henry, of Egham, Surrey, gent 0
5542222 2517698 2517698 defendant Wodcok Seth clerk 586217 586217 Wodcok, Seth, of Egham, Surrey, clerk 0
5547196 2519191 2519191 defendant Wodecok Seth clerk 586217 586217 Wodecok, Seth, of Egham, Surrey, clerk 0
5601723 2535441 2535441 defendant Gonner John husbandman 586217 586217 Gonner, John, of Egham, Surrey, husbandman 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);