names

45 rows where place_id = 618020

✎ 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
3722455 1933282 1933282 defendant Laton Thomas tanner 618020 618020 (Laton, Thomas, of Howden, tanner 1
3725558 1934284 1934284 defendant Fyssher Richard clerk 618020 618020 Fyssher, Richard, of Howden, clerk 0
3770898 1948585 1948585 defendant Craven John painter 618020 618020 Craven, John, of Howden, painter 3
3799000 1957598 1957598 defendant Thorpe Richard husbandman 618020 618020 Thorpe, Richard, of Howden, husbandman 0
3816445 1963054 1963054 defendant Hobart Thomas yeoman 618020 618020 Hobart, Thomas, of Howden, yeoman 0
3826248 1966056 1966056 defendant Kyrkby William tanner 618020 618020 Kyrkby, William, of Howden, tanner 3
3826249 1966056 1966056 defendant Busbye John glover 618020 618020 Busbye, John, of Howden, glover 4
3832232 1967994 1967994 defendant Cote Thomas merchant 618020 618020 Cote, Thomas, of Howden, merchant 0
3868133 1979578 1979578 defendant Wawker Thomas butcher 618020 618020 Wawker, Thomas, of Howden, butcher 2
3931222 2000732 2000732 defendant Preston Thomas husbandman 618020 618020 Preston, Thomas, of Howden, husbandman 0
3931223 2000732 2000732 defendant Chep John laborer 618020 618020 Chep, John, of Howden, laborer 1
3931224 2000732 2000732 defendant Butterfeld Thomas laborer 618020 618020 Butterfeld, Thomas, of Howden, laborer 2
3931244 2000739 2000739 defendant Person Thomas butcher 618020 618020 Person, Thomas, of Howden, butcher 0
3939451 2003500 2003500 defendant Tayllgeor William draper 618020 618020 Tayllgeor, William, of Howden, draper 0
3984764 2019307 2019307 plaintiff Thornell Nicholas gent 618020 618020 Thornell, Nicholas, of Howden, gent 0
3997246 2023785 2023785 defendant Burgh William gent 618020 618020 Burgh, William, of Howden, gent 0
4024162 2033345 2033345 defendant Bacon Robert yeoman 618020 618020 Bacon, Robert, of Howden, yeoman 0
4024163 2033345 2033345 defendant Wylsytt John yeoman 618020 618020 Wylsytt, John, of Howden, yeoman 1
4067829 2048805 2048805 defendant Abbot Thomas tanner 618020 618020 Abbot, Thomas, of Howden, tanner 0
4104154 2061759 2061759 defendant Umfrey Simon husbandman 618020 618020 Umfrey, Simon, of Howden, husbandman 0
4202267 2096334 2096334 defendant Pereson Robert yeoman 618020 618020 Pereson, Robert, of Howden, yeoman 0
4202268 2096334 2096334 defendant Bradley Thomas carpenter 618020 618020 Bradley, Thomas, of Howden, carpenter 1
4202269 2096334 2096334 defendant Parkyn Arthur shoemaker 618020 618020 Parkyn, Arthur, of Howden, shoemaker 2
4202270 2096334 2096334 defendant Hall Christopher laborer 618020 618020 Hall, Christopher, of Howden, laborer 3
4217425 2101588 2101588 defendant Gate John esq 618020 618020 Gate, John, of Howden, esq 0
4219949 2102480 2102480 defendant Belt Nicholas yeoman 618020 618020 Belt, Nicholas, of Howden, yeoman 0
4286118 2125090 2125090 defendant Concitt George gent 618020 618020 Concitt, George, of Howden, gent 0
4310073 2133681 2133681 defendant Barker William tanner 618020 618020 Barker, William, of Howden, tanner 0
4310603 2133856 2133856 defendant Davye Simon gent 618020 618020 Davye, Simon, of Howden, gent 3
4311203 2134066 2134066 defendant Barker William innholder 618020 618020 Barker, William, of Howden, innholder 0
4318284 2136502 2136502 defendant Ketlewell Marmaduke yeoman 618020 618020 Ketlewell, Marmaduke, of Howden, yeoman 3
4320931 2137416 2137416 defendant Barker William tanner 618020 618020 Barker, William, of Howden, tanner 0
4321758 2137697 2137697 defendant Davie Simon gent 618020 618020 Davie, Simon, of Howden, gent 0
4363026 2151840 2151840 defendant Gate John esq 618020 618020 Gate, John, of Howden, esq 0
4377456 2157012 2157012 defendant Raye James miller 618020 618020 Raye, James, of Howden, miller 0
4384185 2159402 2159402 defendant Kirkby John   618020 618020 Kirkby, John, of Howden 0
4397565 2163764 2163764 defendant Burrell Richard   618020 618020 Burrell, Richard, of Howden, surgeon 0
4397566 2163764 2163764 defendant Pearson Nicholas gent 618020 618020 Pearson, Nicholas, of Howden, gent 1
4407041 2166913 2166913 defendant Raye James miller 618020 618020 Raye, James, of Howden, miller 0
4697989 2264863 2264863 defendant Melton William fisherman 618020 618020 Melton, William, of Howden, fisherman 0
4697992 2264863 2264863 defendant Higdon John   618020 618020 Higdon, John, of Howden, glove maker 3
5190494 2412964 2412964 plaintiff Lucas Robert yeoman 618020 618020 Lucas, Robert, of Howden, yeoman 0
5190496 2412964 2412964 defendant Parcour William mercer 618020 618020 Parcour, William, of Howden, mercer 1
5242097 2427889 2427889 defendant Yoman Robert chaplain 618020 618020 Yoman, Robert, of Howden, chaplain 0
5578580 2528370 2528370 defendant Colston Robert tiler 618020 618020 Colston, Robert, of Howden, tiler 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);