names

89 rows where place_id = 593877

✎ 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
3613711 1871937 1871937 defendant Hartley Henry tailor 593877 593877 Hartley, Henry, of Tadcaster, tailor 0
3649116 1910108 1910108 defendant Dynham John yeoman 593877 593877 Dynham, John, of Tadcaster, yeoman 2
3654835 1911771 1911771 defendant Sedell Robert yeoman 593877 593877 Sedell, Robert, of Tadcaster, yeoman 1
3674685 1918130 1918130 defendant Lacoke John yeoman 593877 593877 Lacoke, John, of Tadcaster, yeoman 2
3689421 1922849 1922849 defendant Lacok John yeoman 593877 593877 Lacok, John, of Tadcaster, yeoman 0
3689425 1922851 1922851 defendant Gibson Robert husbandman 593877 593877 Gibson, Robert, of Tadcaster, husbandman 0
3700980 1926556 1926556 defendant Lacok John pewterer 593877 593877 Lacok, John, of Tadcaster, pewterer 0
3714574 1930855 1930855 defendant Lacok John yeoman 593877 593877 Lacok, John, of Tadcaster, yeoman 1
3720756 1932781 1932781 defendant Lacoke John pewterer 593877 593877 Lacoke, John, of Tadcaster, pewterer 0
3783324 1952535 1952535 defendant Radclyff Eufania widow 593877 593877 Radclyff, Eufania, of Tadcaster, widow 0
3783325 1952535 1952535 defendant Radclyff William gent 593877 593877 Radclyff, William, of Tadcaster, gent 1
3783327 1952536 1952536 defendant Radclyff Eufanna widow 593877 593877 Radclyff, Eufanna, of Tadcaster, widow 0
3783328 1952536 1952536 defendant Radclyff William gent 593877 593877 Radclyff, William, of Tadcaster, gent 1
3791293 1955110 1955110 defendant Sydall Robert yeoman 593877 593877 Sydall, Robert, of Tadcaster, yeoman 0
3791297 1955112 1955112 defendant Sydall Robert yeoman 593877 593877 Sydall, Robert, of Tadcaster, yeoman 0
3791298 1955112 1955112 defendant Norman Ralph yeoman 593877 593877 Norman, Ralph, of Tadcaster, yeoman 1
3799827 1957864 1957864 defendant Radclyff Susan widow 593877 593877 Radclyff, Susan, of Tadcaster, widow 0
3827198 1966371 1966371 plaintiff Byrdsell John   593877 593877 Byrdsell, John, of Tadcaster 1
3827200 1966371 1966371 defendant Jakson Richard husbandman 593877 593877 Jakson, Richard, of Tadcaster, husbandman 0
3845284 1972087 1972087 defendant Forster Robert yeoman 593877 593877 Forster, Robert, of Tadcaster, yeoman 1
3845751 1972220 1972220 plaintiff Foster Robert   593877 593877 Foster, Robert, of Tadcaster 0
3861170 1977212 1977212 defendant Foster Robert yeoman 593877 593877 Foster, Robert, of Tadcaster, yeoman 0
3906898 1992593 1992593 defendant Gybson Thomas yeoman 593877 593877 Gybson, Thomas, of Tadcaster, yeoman 2
3906899 1992593 1992593 defendant Marshall Robert yeoman 593877 593877 Marshall, Robert, of Tadcaster, yeoman 3
3932419 2001131 2001131 plaintiff Forster Robert   593877 593877 Forster, Robert, of Tadcaster 0
3932421 2001132 2001132 plaintiff Forster Robert gent 593877 593877 Forster, Robert, of Tadcaster, gent 0
3932423 2001133 2001133 plaintiff Forster Robert gent 593877 593877 Forster, Robert, of Tadcaster, gent 0
3950097 2007117 2007117 plaintiff Foster Robert gent 593877 593877 Foster, Robert, of Tadcaster, gent 0
4004955 2026553 2026553 defendant Foster leonard gent 593877 593877 Foster, leonard, of Tadcaster, gent 0
4016514 2030612 2030612 defendant Forster Leonard gent 593877 593877 Forster, Leonard, of Tadcaster, gent, brother of Robert Forster, of Tadcaster, gent 0
4031675 2035995 2035995 plaintiff Foster Robert (legal representative) 593877 593877 Foster, Robert, of Tadcaster, gent, executors of 0
4031681 2035996 2035996 plaintiff Foster Robert (legal representative) 593877 593877 Foster, Robert, of Tadcaster, gent, executors of 0
4033920 2036784 2036784 defendant Laycocke Thomas yeoman 593877 593877 Laycocke, Thomas, of Tadcaster, yeoman 0
4040395 2039063 2039063 defendant Cuthbertson Henry miller 593877 593877 Cuthbertson, Henry, of Tadcaster, miller 8
4040408 2039064 2039064 defendant Cuthbertson Henry miller 593877 593877 Cuthbertson, Henry, of Tadcaster, miller 8
4085127 2054963 2054963 defendant Marshall Edward yeoman 593877 593877 Marshall, Edward, of Tadcaster, yeoman 0
4264291 2117703 2117703 defendant Wardropp alias Scovell John innholder 593877 593877 Wardropp alias Scovell, John, of Tadcaster, innholder 3
4279758 2122838 2122838 defendant Preston Isabel widow 593877 593877 Preston, Isabel, of Tadcaster, widow 1
4288872 2126074 2126074 defendant Taylor Thomas (legal representative) 593877 593877 Taylor, Thomas, of Tadcaster, yeoman, administratrix of 0
4288873 2126074 2126074 defendant Preston Isabel widow 593877 593877 Preston, Isabel, of Tadcaster, widow 1
4344320 2145293 2145293 defendant Barker John husbandman 593877 593877 Barker, John, of Tadcaster, husbandman 0
4400108 2164625 2164625 defendant Burton Arthur butcher 593877 593877 Burton, Arthur, of Tadcaster, butcher 1
4400109 2164625 2164625 defendant Birdsall Otwell yeoman 593877 593877 Birdsall, Otwell, of Tadcaster, yeoman 2
4407991 2167239 2167239 defendant Barker John yeoman 593877 593877 Barker, John, of Tadcaster, yeoman 0
4423414 2172171 2172171 defendant Yarum Thomas de   593877 593877 Yarum, Thomas de, of Tadcaster 0
4450552 2185135 2185135 defendant Barkere William   593877 593877 Barkere, William, of Tadcaster 2
4518645 2206205 2206205 defendant Hardern Thomas   593877 593877 Hardern, Thomas, of Tadcaster 0
4518951 2206289 2206289 plaintiff Driffeld William   593877 593877 Driffeld, William, of Tadcaster 0
4524793 2208093 2208093 defendant Litster William   593877 593877 Litster, William, of Tadcaster 0
4547707 2215221 2215221 defendant Litster William   593877 593877 Litster, William, of Tadcaster 1
4556313 2217916 2217916 defendant Lytster William   593877 593877 Lytster, William, of Tadcaster 0
4564128 2220351 2220351 defendant Barker William   593877 593877 Barker, William, of Tadcaster 0
4615913 2235974 2235974 plaintiff Flesshewer William   593877 593877 Flesshewer, William, of Tadcaster 0
4623768 2238411 2238411 defendant Sleford Thomas de   593877 593877 Sleford, Thomas de, of Tadcaster 0
4632688 2241108 2241108 defendant Soleforth Thomas   593877 593877 Soleforth, Thomas, of Tadcaster 4
4736867 2276659 2276659 defendant Soureby John husbandman 593877 593877 Soureby, John, of Tadcaster, husbandman 1
4739539 2277446 2277446 defendant Soureby John laborer 593877 593877 Soureby, John, of Tadcaster, laborer 4
4742191 2278208 2278208 defendant Blays Richard yeoman 593877 593877 Blays, Richard, of Tadcaster, yeoman 1
4750922 2280752 2280752 defendant Graunge John yeoman 593877 593877 Graunge, John, of Tadcaster, yeoman 0
4750925 2280753 2280753 defendant Graunge John yeoman 593877 593877 Graunge, John, of Tadcaster, yeoman 0
4754844 2281893 2281893 defendant Clerk John husbandman 593877 593877 Clerk, John, of Tadcaster, husbandman 0
4761386 2283904 2283904 defendant Colyer Robert collier 593877 593877 Colyer, Robert, of Tadcaster, collier 0
4825661 2304065 2304065 defendant Hunstan Thoams yeoman 593877 593877 Hunstan, Thoams, of Tadcaster, yeoman 1
4825662 2304065 2304065 defendant Walas Richard yeoman 593877 593877 Walas, Richard, of Tadcaster, yeoman 2
4827713 2304716 2304716 defendant Sampson John   593877 593877 Sampson, John, of Tadcaster, mason 1
4827731 2304722 2304722 defendant Sowerby John laborer 593877 593877 Sowerby, John, of Tadcaster, laborer 1
4827795 2304738 2304738 defendant Grene John husbandman 593877 593877 Grene, John, of Tadcaster, husbandman 0
4829966 2305416 2305416 defendant Waleys Richard tailor 593877 593877 Waleys, Richard, of Tadcaster, tailor 2
4950423 2342098 2342098 defendant Blakburn John butcher 593877 593877 Blakburn, John, of Tadcaster, butcher 3
4950424 2342098 2342098 defendant Banaster John smith 593877 593877 Banaster, John, of Tadcaster, smith 4
5010227 2359856 2359856 defendant Redburn John chaplain 593877 593877 Redburn, John, of Tadcaster, chaplain 0
5043368 2369639 2369639 defendant Bradley John yeoman 593877 593877 Bradley, John, of Tadcaster, yeoman 0
5043369 2369639 2369639 defendant Milner John husbandman 593877 593877 Milner, John, of Tadcaster, husbandman 1
5071703 2378027 2378027 defendant Fethyrk Christopher cordwainer 593877 593877 Fethyrk, Christopher, of Tadcaster, cordwainer 2
5071704 2378027 2378027 defendant Sloforth Robert cordwainer 593877 593877 Sloforth, Robert, of Tadcaster, cordwainer 3
5144013 2399396 2399396 defendant Brounberd Thomas   593877 593877 Brounberd, Thomas, of Tadcaster, arrow maker 0
5144014 2399396 2399396 defendant Brounberd William   593877 593877 Brounberd, William, of Tadcaster, arrow maker 1
5374060 2467488 2467488 defendant Jakson John yeoman 593877 593877 Jakson, John, of Tadcaster, yeoman 3
5374096 2467495 2467495 defendant Jakson John yeoman 593877 593877 Jakson, John, of Tadcaster, yeoman 3
5382149 2469952 2469952 defendant Jakson Thomas yeoman 593877 593877 Jakson, Thomas, of Tadcaster, yeoman 4
5416869 2479964 2479964 defendant Jakson Thomas yeoman 593877 593877 Jakson, Thomas, of Tadcaster, yeoman 3
5425383 2482567 2482567 defendant Borowedale Richard yeoman 593877 593877 Borowedale, Richard, of Tadcaster, yeoman 0
5433852 2485092 2485092 defendant Jakson Thomas yeoman 593877 593877 Jakson, Thomas, of Tadcaster, yeoman 3
5433902 2485100 2485100 defendant Jakson Thomas yeoman 593877 593877 Jakson, Thomas, of Tadcaster, yeoman 3
5433938 2485105 2485105 defendant Jakson Thomas yeoman 593877 593877 Jakson, Thomas, of Tadcaster, yeoman 3
5591705 2532392 2532392 plaintiff Dawson William butcher 593877 593877 Dawson, William, of Tadcaster, butcher 1
5620527 2550279 2550279 defendant Kirkeby john de   593877 593877 Kirkeby, john de, of Tadcaster 1
5633672 2554531 2554531 defendant Hardy Robert   593877 593877 Hardy, Robert, of Tadcaster, wright 0
5633673 2554531 2554531 defendant Weng William miller 593877 593877 Weng, William, of Tadcaster, miller 1

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