names

46 rows where place_id = 586218

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588191 1863961 1863961 defendant Saxtun William tailor 586218 586218 Saxtun, William, of Egham, tailor 0
3588210 1863967 1863967 defendant Saxton John tailor 586218 586218 Saxton, John, of Egham, tailor 0
3615745 1872565 1872565 defendant Addamson Richard tailor 586218 586218 Addamson, Richard, of Egham, tailor 0
3618340 1873366 1873366 defendant Adamson Richard draper 586218 586218 (Adamson, Richard, of Egham, draper 1
3645519 1908996 1908996 defendant Clerke Thomas yeoman 586218 586218 Clerke, Thomas, of Egham, yeoman 0
3659679 1913283 1913283 defendant Clerke Thomas husbandman 586218 586218 Clerke, Thomas, of Egham, husbandman 3
3659684 1913284 1913284 defendant Clerk Thomas husbandman 586218 586218 Clerk, Thomas, of Egham, husbandman 2
3677147 1918895 1918895 defendant Gate William weaver 586218 586218 Gate, William, of Egham, weaver 0
3677148 1918895 1918895 defendant Goodwyn John laborer 586218 586218 Goodwyn, John, of Egham, laborer 1
3677149 1918895 1918895 defendant Adamson William tailor 586218 586218 Adamson, William, of Egham, tailor 2
3677150 1918895 1918895 defendant Hege John tanner 586218 586218 Hege, John, of Egham, tanner 3
3677151 1918895 1918895 defendant Harthryge Hugh tailor 586218 586218 Harthryge, Hugh, of Egham, tailor 4
3677152 1918895 1918895 defendant Jurden William roper 586218 586218 Jurden, William, of Egham, roper 5
3677153 1918895 1918895 defendant Atwyke John husbandman 586218 586218 Atwyke, John, of Egham, husbandman 6
3677154 1918895 1918895 defendant West Robert husbandman 586218 586218 West, Robert, of Egham, husbandman 7
3707197 1928542 1928542 defendant Byfeld John laborer 586218 586218 Byfeld, John, of Egham, laborer 0
3746223 1940727 1940727 defendant Benorthe John husbandman 586218 586218 Benorthe, John, of Egham, husbandman 0
3746225 1940728 1940728 defendant Benorthe John husbandman 586218 586218 Benorthe, John, of Egham, husbandman 0
3794728 1956226 1956226 defendant Dey Andrew yeoman 586218 586218 Dey, Andrew, of Egham, yeoman 0
3824445 1965516 1965516 defendant Park William husbandman 586218 586218 Park, William, of Egham, husbandman 0
4116855 2066324 2066324 defendant Warde Thomas innholder 586218 586218 Warde, Thomas, of Egham, innholder 0
4228919 2105595 2105595 defendant Bowtell alias Bover Jerome gent 586218 586218 Bowtell alias Bover, Jerome, of Egham, gent 0
4228920 2105595 2105595 defendant Milton John yeoman 586218 586218 Milton, John, of Egham, yeoman 1
4270362 2119669 2119669 defendant Bowell alias Bover Jerome gent 586218 586218 Bowell alias Bover, Jerome, of Egham, gent 0
4270363 2119669 2119669 defendant Milton John yeoman 586218 586218 Milton, John, of Egham, yeoman 1
4289581 2126339 2126339 defendant Norrys John yeoman 586218 586218 Norrys, John, of Egham, yeoman 0
4391965 2161941 2161941 defendant Kytchen William yeoman 586218 586218 Kytchen, William, of Egham, yeoman 0
4503931 2201789 2201789 defendant Rissham Thomas, junior   586218 586218 Rissham, Thomas, junior, of Egham 1
4833166 2306385 2306385 defendant Gilberd John husbandman 586218 586218 Gilberd, John, of Egham, husbandman 0
4906868 2328733 2328733 defendant Squyler Richard husbandman 586218 586218 Squyler, Richard, of Egham, husbandman 0
5022779 2363574 2363574 defendant Milton John, junior   586218 586218 Milton, John, junior, of Egham 0
5059451 2374395 2374395 defendant Lese John laborer 586218 586218 Lese, John, of Egham, laborer 1
5059452 2374395 2374395 defendant Gilbard John husbandman 586218 586218 Gilbard, John, of Egham, husbandman 2
5059457 2374396 2374396 defendant Lese John laborer 586218 586218 Lese, John, of Egham, laborer 1
5059458 2374396 2374396 defendant Gillard John husbandman 586218 586218 Gillard, John, of Egham, husbandman 2
5083009 2381424 2381424 defendant Gaslider Walter husbandman 586218 586218 Gaslider, Walter, of Egham, husbandman 0
5114391 2390605 2390605 defendant Glede William husbandman 586218 586218 Glede, William, of Egham, husbandman 0
5321300 2451465 2451465 defendant Seynton Richard yeoman 586218 586218 Seynton, Richard, of Egham, yeoman 1
5389969 2472193 2472193 defendant Grome John chaplain 586218 586218 Grome, John, of Egham, chaplain 0
5402761 2475866 2475866 defendant Grome John chaplain 586218 586218 Grome, John, of Egham, chaplain 0
5415695 2479636 2479636 defendant Grome John chaplain 586218 586218 Grome, John, of Egham, chaplain 0
5542223 2517698 2517698 defendant Wodcok Hugh chaplain 586218 586218 Wodcok, Hugh, of Egham, chaplain 1
5547197 2519191 2519191 defendant Adamson Richard yeoman 586218 586218 Adamson, Richard, of Egham, yeoman 1
5547198 2519191 2519191 defendant Grome John husbandman 586218 586218 Grome, John, of Egham, husbandman 2
5547199 2519191 2519191 defendant Barkelmewe John husbandman 586218 586218 Barkelmewe, John, of Egham, husbandman 3
5600066 2534905 2534905 defendant Doo Richard tailor 586218 586218 Doo, Richard, of Egham, tailor 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);