names

55 rows where place_id = 591912

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605955 1869524 1869524 defendant Quynby Henry clothman 591912 591912 Quynby, Henry, of Farnham, Surrey, clothman 1
3645353 1908955 1908955 defendant Creswell Hugh clothier 591912 591912 Creswell, Hugh, of Farnham, Surrey, clothier 1
3712650 1930272 1930272 plaintiff Whyte Robert (legal representative) 591912 591912 Whyte, Robert, of Farnham, Surrey, clothman, executors of 0
3769438 1948101 1948101 defendant Quynby John clothman 591912 591912 Quynby, John, of Farnham, Surrey, clothman 1
3834844 1968837 1968837 plaintiff Mores John gent 591912 591912 Mores, John, of Farnham, Surrey, gent 1
4022671 2032833 2032833 plaintiff Aston Robert gent 591912 591912 Aston, Robert, of Farnham, Surrey, gent 0
4106285 2062538 2062538 defendant Wattes John chapman 591912 591912 Wattes, John, of Farnham, Surrey, chapman 1
4106289 2062539 2062539 defendant Wattes John chapman 591912 591912 Wattes, John, of Farnham, Surrey, chapman 1
4111161 2064245 2064245 defendant Drue Thomas, junior gent 591912 591912 Drue, Thomas, junior, of Farnham, Surrey, gent 0
4241374 2110101 2110101 defendant Knyght Thomas gent 591912 591912 Knyght, Thomas, of Farnham, Surrey, gent 0
4241378 2110102 2110102 defendant Knyght Thomas gent 591912 591912 Knyght, Thomas, of Farnham, Surrey, gent 0
4353271 2148372 2148372 defendant Sely or Ceely John chapman 591912 591912 Sely or Ceely, John, of Farnham, Surrey, chapman 0
4371000 2154684 2154684 defendant Burton Edward gent 591912 591912 Burton, Edward, of Farnham, Surrey, gent 1
4695077 2263953 2263953 defendant Kaym William smith 591912 591912 Kaym, William, of Farnham, Surrey, smith 0
4700880 2265676 2265676 defendant Porter alias Wade Richard husbandman 591912 591912 Porter alias Wade, Richard, of Farnham, Surrey, husbandman 0
4714795 2269962 2269962 defendant Idewyn John chapman 591912 591912 Idewyn, John, of Farnham, Surrey, chapman 0
4716564 2270499 2270499 defendant Swaby Nicholas laborer 591912 591912 Swaby, Nicholas, of Farnham, Surrey, laborer 0
4721891 2272179 2272179 defendant Coupere William husbandman 591912 591912 Coupere, William, of Farnham, Surrey, husbandman 0
4768463 2286111 2286111 defendant Cone or Cove Richard   591912 591912 Cone or Cove, Richard, of Farnham, Surrey, wool man 0
4792288 2293676 2293676 defendant Lauerans John merchant 591912 591912 Lauerans, John, of Farnham, Surrey, merchant 0
4800936 2296482 2296482 defendant Rede John dyer 591912 591912 Rede, John, of Farnham, Surrey, dyer 2
4859898 2314466 2314466 defendant Osteler Thomas husbandman 591912 591912 Osteler, Thomas, of Farnham, Surrey, husbandman 3
4909430 2329488 2329488 defendant Weley Constantia   591912 591912 Weley, Constantia, of Farnham, Surrey, widow, formerly wife of Thomas Weley 0
4941641 2339405 2339405 defendant Leverok Simon mercer 591912 591912 Leverok, Simon, of Farnham, Surrey, mercer 1
4946694 2340966 2340966 defendant Laverok Simon chapman 591912 591912 Laverok, Simon, of Farnham, Surrey, chapman 0
4967940 2347354 2347354 defendant Hervy John husbandman 591912 591912 Hervy, John, of Farnham, Surrey, husbandman 3
4967942 2347355 2347355 defendant Hayward William husbandman 591912 591912 Hayward, William, of Farnham, Surrey, husbandman 0
4971204 2348326 2348326 defendant Wyne John draper 591912 591912 Wyne, John, of Farnham, Surrey, draper 0
4978767 2350599 2350599 defendant Hatte John weaver 591912 591912 Hatte, John, of Farnham, Surrey, weaver 0
5023945 2363916 2363916 defendant Hat John weaver 591912 591912 Hat, John, of Farnham, Surrey, weaver 0
5060322 2374661 2374661 defendant Perys Thomas gent 591912 591912 Perys, Thomas, of Farnham, Surrey, gent 1
5065986 2376350 2376350 defendant Dunnyng John husbandman 591912 591912 Dunnyng, John, of Farnham, Surrey, husbandman 0
5072511 2378263 2378263 defendant Osteler John ostler 591912 591912 Osteler, John, of Farnham, Surrey, ostler 2
5083795 2381655 2381655 defendant Hervy John husbandman 591912 591912 Hervy, John, of Farnham, Surrey, husbandman 0
5083800 2381656 2381656 defendant Hervy John husbandman 591912 591912 Hervy, John, of Farnham, Surrey, husbandman 0
5173942 2408077 2408077 defendant Janyn John yeoman 591912 591912 Janyn, John, of Farnham, Surrey, yeoman 0
5200474 2415899 2415899 defendant Elys John (legal representative) 591912 591912 Elys, John, of Farnham, Surrey, chapman, executors of 2
5200475 2415899 2415899 defendant Smyth William chapman 591912 591912 (Smyth, William, of Farnham, Surrey, chapman 3
5200791 2415991 2415991 defendant Elys John (legal representative) 591912 591912 Elys, John, of Farnham, Surrey, executors of 2
5200792 2415991 2415991 defendant Smythe William   591912 591912 (Smythe, William, of Farnham, Surrey 3
5208342 2418167 2418167 defendant Auntresey Henry dyer 591912 591912 Auntresey, Henry, of Farnham, Surrey, dyer 0
5208356 2418169 2418169 defendant Auntresey Henry dyer 591912 591912 Auntresey, Henry, of Farnham, Surrey, dyer 1
5210433 2418783 2418783 defendant Lokyer Edmund   591912 591912 Lokyer, Edmund, of Farnham, Surrey, black smith 0
5233626 2425424 2425424 defendant White John gent 591912 591912 White, John, of Farnham, Surrey, gent 1
5236521 2426267 2426267 defendant Smyth Richard chapman 591912 591912 Smyth, Richard, of Farnham, Surrey, chapman 2
5244833 2428660 2428660 defendant Somer William drover 591912 591912 Somer, William, of Farnham, Surrey, drover 0
5244835 2428661 2428661 defendant Somer William drover 591912 591912 Somer, William, of Farnham, Surrey, drover 0
5250623 2430304 2430304 plaintiff Whyte Robert merchant 591912 591912 Whyte, Robert, of Farnham, Surrey, merchant 0
5295765 2443755 2443755 defendant Lyner or Lyver Richard yeoman 591912 591912 Lyner or Lyver, Richard, of Farnham, Surrey, yeoman 4
5310486 2448172 2448172 defendant Lyver Richard yeoman 591912 591912 Lyver, Richard, of Farnham, Surrey, yeoman 4
5358968 2462853 2462853 defendant Serson Richard clothmaker 591912 591912 Serson, Richard, of farnham, Surrey, clothmaker 2
5555925 2521727 2521727 defendant Avenell John yeoman 591912 591912 Avenell, John, of Farnham, Surrey, yeoman 0
5559958 2522868 2522868 defendant Quynby Henry clothmaker 591912 591912 Quynby, Henry, of Farnham, Surrey, clothmaker 0
5574882 2527226 2527226 defendant Quynby Henry clothmaker 591912 591912 Quynby, Henry, of Farnham, Surrey, clothmaker 0
5579920 2528800 2528800 defendant Quynby Henry clothier 591912 591912 Quynby, Henry, of Farnham, Surrey, clothier 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);