names

62 rows where place_id = 665502

✎ 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
3977242 2016610 2016610 defendant Thompson Thomas carpenter 665502 665502 Thompson, Thomas, of Selbye, carpenter 0
3980429 2017769 2017769 plaintiff Percye Richard merchant 665502 665502 Percye, Richard, of Selbye, merchant 0
3990392 2021318 2021318 defendant Tyler William   665502 665502 Tyler, William, of Selbye, ship carpenter 0
3994209 2022684 2022684 defendant Baynes Miles yeoman 665502 665502 Baynes, Miles, of Selbye, yeoman 0
3998261 2024123 2024123 defendant Scoles Ralph yeoman 665502 665502 Scoles, Ralph, of Selbye, yeoman 0
4006035 2026931 2026931 defendant Hutton Richard yeoman 665502 665502 Hutton, Richard, of Selbye, yeoman 7
4006045 2026932 2026932 defendant Hutton Richard yeoman 665502 665502 Hutton, Richard, of Selbye, yeoman 7
4006637 2027152 2027152 plaintiff Londesdale William draper 665502 665502 Londesdale, William, of Selbye, draper 0
4012373 2029146 2029146 defendant Bayne Miles   665502 665502 Bayne, Miles, of Selbye, Yorks yeoman 0
4019295 2031634 2031634 defendant Beckwyth Roger esq 665502 665502 Beckwyth, Roger, of Selbye, esq 0
4019297 2031635 2031635 defendant Beckwyth Roger esq 665502 665502 Beckwyth, Roger, of Selbye, esq 0
4028399 2034809 2034809 defendant Newbye Ambrose yeoman 665502 665502 Newbye, Ambrose, of Selbye, yeoman 1
4029100 2035053 2035053 defendant Horner George yeoman 665502 665502 Horner, George, of Selbye, yeoman 0
4051347 2042906 2042906 defendant Langler James husbandman 665502 665502 Langler, James, of Selbye, husbandman 7
4051359 2042907 2042907 defendant Langler James husbandman 665502 665502 Langler, James, of Selbye, husbandman 7
4060395 2046117 2046117 defendant Beverley John esq 665502 665502 Beverley, John, of Selbye, esq 2
4072895 2050601 2050601 defendant Beverley William gent 665502 665502 Beverley, William, of Selbye, gent 0
4074812 2051291 2051291 defendant Beckwyth Roger esq 665502 665502 Beckwyth, Roger, of Selbye, esq 0
4074813 2051291 2051291 defendant Beckwyth Brian yeoman 665502 665502 Beckwyth, Brian, of Selbye, yeoman 1
4074814 2051291 2051291 defendant Swale John yeoman 665502 665502 Swale, John, of Selbye, yeoman 2
4074815 2051291 2051291 defendant Hicke William yeoman 665502 665502 Hicke, William, of Selbye, yeoman 3
4074816 2051291 2051291 defendant Bridges Miles yeoman 665502 665502 Bridges, Miles, of Selbye, yeoman 4
4074817 2051291 2051291 defendant Norton Richard yeoman 665502 665502 Norton, Richard, of Selbye, yeoman 5
4074889 2051321 2051321 defendant Bekwith Roger esq 665502 665502 Bekwith, Roger, of Selbye, esq 0
4079954 2053133 2053133 defendant Beckwyth Roger esq 665502 665502 Beckwyth, Roger, of Selbye, esq 0
4080164 2053217 2053217 defendant Goldell William chapman or merchant 665502 665502 Goldell, William, of Selbye, chapman or merchant 0
4084148 2054605 2054605 defendant Teler Alice widow 665502 665502 Teler, Alice, of Selbye, widow 1
4085125 2054962 2054962 defendant Hogge Agnes   665502 665502 Hogge, Agnes, of Selbye 0
4086969 2055632 2055632 defendant Foxe James yeoman 665502 665502 Foxe, James, of Selbye, yeoman 0
4091331 2057189 2057189 defendant Beverley William esq 665502 665502 Beverley, William, of Selbye, esq 0
4091333 2057190 2057190 defendant Beverley William esq 665502 665502 Beverley, William, of Selbye, esq 0
4100945 2060654 2060654 defendant Redman William yeoman 665502 665502 Redman, William, of Selbye, yeoman 0
4115633 2065875 2065875 defendant Goldell William chapman or merchant 665502 665502 Goldell, William, of Selbye, chapman or merchant 0
4130280 2071143 2071143 defendant Dobbe Richard tanner 665502 665502 Dobbe, Richard, of Selbye, tanner 0
4132390 2071901 2071901 defendant Ingland William yeoman 665502 665502 Ingland, William, of Selbye, yeoman 0
4144144 2076114 2076114 defendant Beverley John gent 665502 665502 Beverley, John, of Selbye, gent 3
4147983 2077426 2077426 defendant Englande William yeoman 665502 665502 Englande, William, of Selbye, yeoman 0
4149848 2078074 2078074 defendant Hayrebreade William yeoman 665502 665502 Hayrebreade, William, of Selbye, yeoman 0
4153751 2079410 2079410 defendant Dobbe Richard tanner 665502 665502 Dobbe, Richard, of Selbye, tanner 0
4156229 2080252 2080252 defendant Levitte William yeoman 665502 665502 Levitte, William, of Selbye, yeoman 0
4181295 2088939 2088939 defendant Foxe Robert yeoman 665502 665502 Foxe, Robert, of Selbye, or of Wolhouse, yeoman 1
4224070 2103905 2103905 defendant Harryson Robert tanner 665502 665502 Harryson, Robert, of Selbye, tanner 0
4226725 2104819 2104819 defendant Hogge John gent 665502 665502 (Hogge, John, of Selbye, gent 1
4229539 2105819 2105819 defendant Skayff alias Rigg Robert draper 665502 665502 Skayff alias Rigg, Robert, of Selbye, draper 0
4249780 2112908 2112908 defendant Hallyley William yeoman 665502 665502 Hallyley, William, of Selbye, yeoman 0
4253587 2114191 2114191 defendant Petty Thomas yeoman 665502 665502 Petty, Thomas, of Selbye, yeoman 0
4284243 2124416 2124416 defendant Wright Robert tanner 665502 665502 Wright, Robert, of Selbye, tanner 0
4286733 2125308 2125308 defendant Rigg alias Skayf Robert draper 665502 665502 Rigg alias Skayf, Robert, of Selbye, draper 0
4286735 2125309 2125309 defendant Rigg alias Skayf Robert draper 665502 665502 Rigg alias Skayf, Robert, of Selbye, draper 0
4310113 2133692 2133692 defendant Skayfe or Skayse alias Riggs Robert draper 665502 665502 Skayfe or Skayse alias Riggs, Robert, of Selbye, draper 0
4310114 2133692 2133692 defendant Leghe William yeoman 665502 665502 Leghe, William, of Selbye, yeoman 1
4310257 2133740 2133740 defendant Wrighte Robert tanner 665502 665502 Wrighte, Robert, of Selbye, tanner 1
4310263 2133742 2133742 defendant Wrighte Robert tanner 665502 665502 Wrighte, Robert, of Selbye, tanner 1
4310265 2133743 2133743 defendant Wright Robert tanner 665502 665502 Wright, Robert, of Selbye, tanner 0
4310651 2133870 2133870 defendant Thomson Thomas (legal representative) 665502 665502 Thomson, Thomas, of Selbye, millwright, executors of 0
4310652 2133870 2133870 defendant Wilkenson Francis carpenter 665502 665502 (Wilkenson, Francis, of Selbye, carpenter 1
4311291 2134095 2134095 defendant Mackenfeld Anne widow 665502 665502 Mackenfeld, Anne, of Selbye, widow 0
4314629 2135231 2135231 defendant Bradley John yeoman 665502 665502 Bradley, John, of Selbye, yeoman 2
4318167 2136462 2136462 defendant Wright Richard tanner 665502 665502 Wright, Richard, of Selbye, tanner 0
4360091 2150773 2150773 defendant Speight William, junior yeoman 665502 665502 Speight, William, junior, of Selbye, yeoman 0
4370665 2154561 2154561 defendant Harebred William yeoman 665502 665502 Harebred, William, of Selbye, yeoman 1
4390039 2161290 2161290 defendant Sadler Thomas shoemaker 665502 665502 Sadler, Thomas, of Selbye, shoemaker 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);