names

177 rows where place_id = 615257

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3707934 1928779 1928779 defendant Braderigge Alice widow 615257 615257 Braderigge, Alice, of Richemond, widow 0
3707935 1928779 1928779 defendant Swayn John yeoman 615257 615257 Swayn, John, of Richemond, yeoman 1
3713987 1930672 1930672 defendant Tristram John yeoman 615257 615257 Tristram, John, of Richemond, yeoman 0
3752425 1942680 1942680 plaintiff Quarton Michael (legal representative) 615257 615257 Quarton, Michael, of Richemond, chaplain, executor of Wawton, John, of Richemond, mercer, administrator of 0
3767708 1947537 1947537 defendant Cogill Henry merchant 615257 615257 Cogill, Henry, of Richemond, merchant 0
3767720 1947540 1947540 defendant Cogill Henry merchant 615257 615257 Cogill, Henry, of Richemond, merchant 2
3769133 1948000 1948000 plaintiff Quarton Michael (legal representative) 615257 615257 Quarton, Michael, of Richemond, chaplain, executor of Wawton, John, of Rychemond, mercer, administrator of 0
3774820 1949852 1949852 defendant Grisby Thomas laborer 615257 615257 Grisby, Thomas, of Richemond, laborer 1
3785410 1953224 1953224 defendant Cogill Henry merchant 615257 615257 Cogill, Henry, of Richemond, merchant 0
3785414 1953225 1953225 defendant Cogill Henry merchant 615257 615257 Cogill, Henry, of Richemond, merchant 2
3790751 1954932 1954932 defendant Tristram William clerk 615257 615257 Tristram, William, of Richemond, clerk 0
3818449 1963669 1963669 defendant Cogyll Henry merchant 615257 615257 Cogyll, Henry, of Richemond, merchant 0
3822157 1964826 1964826 defendant Bery Christopher merchant 615257 615257 Bery, Christopher, of Richemond, merchant 0
3822158 1964826 1964826 defendant Johnson Charles merchant 615257 615257 Johnson, Charles, of Richemond, merchant 1
3841145 1970808 1970808 defendant Bethom William yeoman 615257 615257 Bethom, William, of Richemond, yeoman 1
3874323 1981638 1981638 defendant Berye Christopher chapman 615257 615257 Berye, Christopher, of Richemond, chapman 1
3877930 1982862 1982862 defendant Moyses John yeoman 615257 615257 Moyses, John, of Richemond, yeoman 0
3977498 2016701 2016701 plaintiff Lightfote Francis merchant 615257 615257 Lightfote, Francis, of Richemond, merchant 0
3977499 2016701 2016701 plaintiff Hutchynson Richard merchant 615257 615257 Hutchynson, Richard, of Richemond, merchant 1
3977781 2016799 2016799 plaintiff Lyghtfoote Francis merchant 615257 615257 Lyghtfoote, Francis, of Richemond, merchant 0
3977782 2016799 2016799 plaintiff Hutchynson Richard merchant 615257 615257 Hutchynson, Richard, of Richemond, merchant 1
3977785 2016800 2016800 plaintiff Lyghtfoote Francis yeoman 615257 615257 Lyghtfoote, Francis, of Richemond, yeoman 0
3978803 2017166 2017166 plaintiff More John clerk 615257 615257 More, John, of Richemond, clerk 0
3978805 2017166 2017166 defendant Croke Henry   615257 615257 Croke, Henry, of Richemond, surgeon 1
3990013 2021181 2021181 defendant Johnson Arthur (legal representative) 615257 615257 Johnson, Arthur, of Richemond, yeoman, executors of 0
3990014 2021181 2021181 defendant Pepper William   615257 615257 (Pepper, William, of Richemond, gent, administratrator during minority of Ralph Johnson 1
4006533 2027118 2027118 plaintiff Lightfoote Francis chapman 615257 615257 Lightfoote, Francis, of Richemond, chapman 0
4006534 2027118 2027118 plaintiff Hutchinson Richard chapman 615257 615257 Hutchinson, Richard, of Richemond, chapman 1
4067992 2048859 2048859 defendant Parkes William carpenter 615257 615257 Parkes, William, of Richemond, carpenter 1
4070888 2049887 2049887 defendant Pepper John gent 615257 615257 Pepper, John, of Richemond, gent 0
4264374 2117728 2117728 defendant Johnson Anthony clerk 615257 615257 Johnson, Anthony, of Richemond, clerk 0
4264375 2117728 2117728 defendant Johnson John draper 615257 615257 Johnson, John, of Richemond, draper 1
4269703 2119456 2119456 defendant Pierson Marmaduke merchant 615257 615257 Pierson, Marmaduke, of Richemond, merchant 2
4269713 2119459 2119459 defendant Pierson Marmaduke merchant 615257 615257 Pierson, Marmaduke, of Richemond, merchant 2
4307817 2132875 2132875 defendant Hutchenson Arthur mercer 615257 615257 Hutchenson, Arthur, of Richemond, mercer 0
4388020 2160622 2160622 defendant Willance Richard draper 615257 615257 Willance, Richard, of Richemond, draper 2
4430508 2174310 2174310 defendant Routh William de   615257 615257 Routh, William de, of Richemond, bailiff 3
4437727 2176552 2176552 defendant Hussher Robert le   615257 615257 Hussher, Robert le, of Richemond 1
4440364 2181898 2181898 defendant Wygot Thomas   615257 615257 Wygot, Thomas, of Richemond 2
4441355 2182232 2182232 defendant Bullok John   615257 615257 Bullok, John, of Richemond 0
4445132 2183448 2183448 defendant Clergenet Hugh   615257 615257 Clergenet, Hugh, of Richemond 0
4445133 2183448 2183448 defendant Bennok William   615257 615257 Bennok, William, of Richemond 1
4448420 2184436 2184436 defendant Collesson John   615257 615257 Collesson, John, of Richemond 0
4450424 2185094 2185094 defendant Marchall John   615257 615257 Marchall, John, of Richemond 1
4451400 2185410 2185410 plaintiff Hilyard John master of the hospital of St Giles near Richmond 615257 615257 Hilyard, John, of Richemond, master of the hospital of St Giles near Richmond 0
4454464 2186408 2186408 plaintiff Lytster John   615257 615257 Lytster, John, of Richemond 0
4454465 2186408 2186408 defendant Langthorn John   615257 615257 Langthorn, John, of Richemond 0
4463585 2189305 2189305 defendant Milner Thomas   615257 615257 Milner, Thomas, of Richemond 1
4463587 2189306 2189306 defendant Shroude John   615257 615257 Shroude, John, of Richemond 0
4466213 2190096 2190096 defendant Shroud John   615257 615257 Shroud, John, of Richemond 1
4489140 2197319 2197319 defendant Muston William de   615257 615257 Muston, William de, of Richemond 0
4494157 2198865 2198865 plaintiff Blakburn Nicholas de   615257 615257 Blakburn, Nicholas de, of Richemond, on his own account 0
4498301 2200126 2200126 plaintiff Forester Thomas   615257 615257 Forester, Thomas, of Richemond, on his own account 0
4498720 2200235 2200235 defendant Litster John   615257 615257 Litster, John, of Richemond 5
4511097 2203922 2203922 defendant Wryght Henry   615257 615257 Wryght, Henry, of Richemond 1
4511774 2204127 2204127 defendant Tebald John   615257 615257 Tebald, John, of Richemond 3
4533410 2210718 2210718 defendant Muston William de   615257 615257 Muston, William de, of Richemond 2
4550289 2216036 2216036 plaintiff Dalby Thomas de (legal representative) 615257 615257 Dalby, Thomas de, of Richemond, formerly archdeacon & residentary canon of St Peter's church & prebendary of the prebend of Thokeryngton, in the same church, executors of 0
4564803 2220556 2220556 defendant Colson William   615257 615257 Colson, William, of Richemond, son of John 0
4564839 2220570 2220570 plaintiff Sheffeld Richard   615257 615257 Sheffeld, Richard, of Richemond 0
4564854 2220570 2220570 defendant Hagger Thomas chaplain 615257 615257 Hagger, Thomas, of Richemond, chaplain 14
4566500 2221090 2221090 defendant Taverner Nicholas   615257 615257 Taverner, Nicholas, of Richemond 0
4568584 2221754 2221754 plaintiff Wade Thomas   615257 615257 Wade, Thomas, of Richemond 0
4573284 2223179 2223179 plaintiff Barbour Robert   615257 615257 Barbour, Robert, of Richemond 0
4588240 2227716 2227716 plaintiff Kerperby John   615257 615257 Kerperby, John, of Richemond 0
4588241 2227716 2227716 defendant Litster William   615257 615257 Litster, William, of Richemond 0
4611263 2234586 2234586 defendant Fanner Richard   615257 615257 Fanner, Richard, of Richemond 0
4619976 2237228 2237228 defendant Gille John de   615257 615257 Gille, John de, of Richemond 1
4622494 2238014 2238014 defendant Catrik Richard   615257 615257 Catrik, Richard, of Richemond 7
4636688 2242296 2242296 defendant Rypon John mercer 615257 615257 Rypon, John, of Richemond, mercer 0
4637359 2242482 2242482 defendant Bennok Roger smith 615257 615257 Bennok, Roger, of Richemond, smith 0
4654188 2247192 2247192 defendant Penny Robert mercer 615257 615257 Penny, Robert, of Richemond, mercer 2
4654189 2247192 2247192 defendant Capon John mercer 615257 615257 Capon, John, of Richemond, mercer 3
4654190 2247192 2247192 defendant Tilson John barber 615257 615257 Tilson, John, of Richemond, barber 4
4662441 2249726 2249726 defendant Salter William salter 615257 615257 Salter, William, of Richemond, salter 2
4673544 2257355 2257355 defendant Conton or Courton George shoemaker 615257 615257 Conton or Courton, George, of Richemond, shoemaker 0
4673848 2257440 2257440 defendant Kirkby Robert draper 615257 615257 Kirkby, Robert, of Richemond, draper 1
4673849 2257440 2257440 defendant Draper Rowaldus draper 615257 615257 Draper, Rowaldus, of Richemond, draper 2
4673850 2257440 2257440 defendant Swayne William tailor 615257 615257 Swayne, William, of Richemond, tailor 3
4679253 2259119 2259119 defendant Middilton Gerard de   615257 615257 Middilton, Gerard de, of Richemond, mercer, executors 3
4679254 2259119 2259119 defendant Barbour Thomas barber 615257 615257 (Barbour, Thomas, of Richemond, barber 4
4685824 2261158 2261158 defendant Flesshewer Roger butcher 615257 615257 Flesshewer, Roger, of Richemond, butcher 0
4685825 2261158 2261158 defendant Roger-servant Flesshewer Roger butcher 615257 615257 Roger-servant Flesshewer, Roger, of Richemond, butcher 1
4687403 2261658 2261658 defendant Huddeswell William   615257 615257 Huddeswell, William, of Richemond, bailiff 0
4687404 2261658 2261658 defendant Clergmat John   615257 615257 Clergmat, John, of Richemond, bailiff 1
4687406 2261658 2261658 defendant Draper Roland   615257 615257 Draper, Roland, of Richemond, bailiff 3
4690724 2262645 2262645 defendant Frank William   615257 615257 Frank, William, of Richemond 4
4690733 2262646 2262646 defendant Frank William   615257 615257 Frank, William, of Richemond 4
4694196 2263686 2263686 defendant Morasson Richard skinner 615257 615257 Morasson, Richard, of Richemond, skinner 4
4703907 2266597 2266597 defendant Peny William chapman 615257 615257 Peny, William, of Richemond, chapman 4
4719476 2271435 2271435 defendant Bowes John tailor 615257 615257 Bowes, John, of Richemond, tailor 2
4719479 2271435 2271435 defendant Hudson Wiliam miller 615257 615257 Hudson, Wiliam,of Richemond, miller 5
4750421 2280603 2280603 defendant Bennok John merchant 615257 615257 Bennok, John, of Richemond, chapman, formerly servant of Robert Middilton, of York, merchant 0
4776668 2288694 2288694 defendant Barbour Robert barber 615257 615257 Barbour, Robert, of Richemond, barber 2
4776669 2288694 2288694 defendant Warde William flesshewer or butcher 615257 615257 Warde, William, of Richemond, flesshewer or butcher 3
4789965 2292936 2292936 defendant Ordewe John draper 615257 615257 Ordewe, John, of Richemond, draper 1
4797748 2295475 2295475 defendant Hudson John yeoman 615257 615257 Hudson, John, of Richemond, yeoman 0
4814810 2300745 2300745 defendant Rowald William draper 615257 615257 Rowald, William, of Richemond, draper 0
4814811 2300745 2300745 defendant Swayne William draper 615257 615257 Swayne, William, of Richemond, draper 1
4814812 2300745 2300745 defendant Lucas Robert draper 615257 615257 Lucas, Robert, of Richemond, draper 2

Next page

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