names

56 rows where place_id = 602735

✎ 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
3651490 1910827 1910827 defendant Lethume Richard husbandman 602735 602735 Lethume, Richard, of Steton, husbandman 0
3651491 1910827 1910827 defendant Lethume Robert husbandman 602735 602735 Lethume, Robert, of Steton, husbandman 1
3651493 1910827 1910827 defendant Hannesley Joan widow 602735 602735 Hannesley, Joan, of Steton, widow 3
3686969 1922090 1922090 defendant Fairfax William esq 602735 602735 Fairfax, William, of Steton, esq 0
3748226 1941373 1941373 plaintiff Gefrason Thomas yeoman 602735 602735 Gefrason, Thomas, of Steton, yeoman 0
3753890 1943164 1943164 plaintiff Stele John yeoman 602735 602735 Stele, John, of Steton, yeoman 0
3762379 1945877 1945877 plaintiff Gefrason Thomas yeoman 602735 602735 Gefrason, Thomas, of Steton, yeoman 0
3771052 1948634 1948634 plaintiff Stele John yeoman 602735 602735 Stele, John, of Steton, yeoman 0
3775389 1950044 1950044 defendant Fayrefax William esq 602735 602735 Fayrefax, William, of Steton, esq 0
3789119 1954405 1954405 defendant Wakefeld John gent 602735 602735 Wakefeld, John, of Steton, gent 0
3796601 1956811 1956811 plaintiff Fairfax William esq 602735 602735 Fairfax, William, of Steton, esq 0
3813942 1962270 1962270 defendant Fayrefax William esq 602735 602735 Fayrefax, William, of Steton, esq 0
3830184 1967335 1967335 defendant Smyth William husbandman 602735 602735 Smyth, William, of Steton, husbandman 1
3830185 1967336 1967336 plaintiff Fairfax William esq 602735 602735 Fairfax, William, of Steton, esq 0
3830247 1967354 1967354 plaintiff Fayrefax William esq 602735 602735 Fayrefax, William, of Steton, esq 0
3840613 1970629 1970629 plaintiff Mytton Thomas   602735 602735 Mytton, Thomas, of Steton 2
3845288 1972088 1972088 plaintiff Norton Lawrence   602735 602735 Norton, Lawrence, of Steton 3
3845304 1972092 1972092 plaintiff Farefax William   602735 602735 Farefax, William, of Steton 0
3874724 1981763 1981763 defendant Fairefax William   602735 602735 Fairefax, William, of Steton, knight 0
3888637 1986456 1986456 plaintiff Fairfax William   602735 602735 Fairfax, William, of Steton, knight 0
3944526 2005185 2005185 defendant Fayrefax Gabriel gent 602735 602735 Fayrefax, Gabriel, of Steton, gent 0
4003869 2026149 2026149 defendant Garfurth John yeoman 602735 602735 Garfurth, John, of Steton, yeoman 0
4023601 2033151 2033151 defendant Fayrefax Gabriel gent 602735 602735 Fayrefax, Gabriel, of Steton, gent 0
4085074 2054943 2054943 defendant Fayrfax Gabriel esq 602735 602735 Fayrfax, Gabriel, of Steton, esq 0
4221354 2102968 2102968 defendant Garfurthe William gent 602735 602735 Garfurthe, William, of Steton, gent 1
4243613 2110850 2110850 defendant Fairefax William esq 602735 602735 Fairefax, William, of Steton, esq 0
4260954 2116625 2116625 defendant Fairfax William esq 602735 602735 Fairfax, William, of Steton, esq 1
4262479 2117116 2117116 defendant Wentworth Michael esq 602735 602735 Wentworth, Michael, of Steton, esq 0
4262484 2117117 2117117 defendant Wentworth Michael esq 602735 602735 Wentworth, Michael, of Steton, esq 0
4274743 2121112 2121112 defendant Fayrfax William Yorks, esq 602735 602735 Fayrfax William, of Steton, Yorks, esq 1
4297061 2129047 2129047 defendant Fairfax William esq 602735 602735 Fairfax, William, of Steton, esq 0
4311033 2134005 2134005 defendant Fairfax William esq 602735 602735 Fairfax, William, of Steton, esq 0
4321763 2137699 2137699 defendant Fairfax William esq 602735 602735 Fairfax, William, of Steton, esq 0
4388817 2160890 2160890 defendant Fewrom Lawrence yeoman 602735 602735 Fewrom, Lawrence, of Steton, yeoman 2
4394236 2162673 2162673 defendant Garfurth Denis yeoman 602735 602735 Garfurth, Denis, of Steton, yeoman 1
4402063 2165279 2165279 defendant Barrett Denis laborer 602735 602735 Barrett, Denis, of Steton, laborer 0
4488918 2197254 2197254 defendant Benet William   602735 602735 Benet, William, of Steton 4
4488919 2197254 2197254 defendant Shepardson John   602735 602735 Shepardson, John, of Steton 5
4488928 2197254 2197254 defendant Jakeson William   602735 602735 Jakeson, William, of Steton 14
4564456 2220449 2220449 defendant Segrave John   602735 602735 Segrave, John, of Steton 3
4604568 2232593 2232593 defendant Werdale Robert   602735 602735 Werdale, Robert, of Steton 4
4750923 2280752 2280752 defendant Marshall William husbandman 602735 602735 Marshall, William, of Steton, husbandman 1
4819118 2302057 2302057 defendant Perkynson William yeoman 602735 602735 Perkynson, William, of Steton, yeoman 1
4820765 2302568 2302568 defendant Clarell Thomas, junior esq 602735 602735 Clarell, Thomas, junior, of Steton, esq 0
4820766 2302569 2302569 defendant Clarell Thomas, senior gent 602735 602735 Clarell, Thomas, senior, of Steton, gent 0
4829972 2305418 2305418 defendant Milner Thomas miller 602735 602735 Milner, Thomas, of Steton, miller 1
4855277 2313004 2313004 defendant Perkynson William chapman 602735 602735 Perkynson, William, of Steton, chapman 0
4915033 2331207 2331207 defendant Perkynson William yeoman 602735 602735 Perkynson, William, of Steton, yeoman 1
4948931 2341648 2341648 defendant Levet John husbandman 602735 602735 Levet, John, of Steton, husbandman 1
5104448 2387728 2387728 defendant Perkynson William yeoman 602735 602735 Perkynson, William, of Steton, yeoman 0
5185322 2411449 2411449 defendant Perkynson William yeoman 602735 602735 Perkynson, William, of Steton, yeoman 2
5185323 2411449 2411449 defendant Perkynson Peter yeoman 602735 602735 Perkynson, Peter, of Steton, yeoman 3
5368483 2465752 2465752 defendant Garforth William yeoman 602735 602735 Garforth, William, of Steton, yeoman 0
5375053 2467788 2467788 defendant Stot William husbandman 602735 602735 Stot, William, of Steton, husbandman 1
5375054 2467788 2467788 defendant Davy William weaver 602735 602735 Davy, William, of Steton, weaver 2
5444752 2488326 2488326 defendant Garforth William yeoman 602735 602735 Garforth, William, of Steton, yeoman 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);