names

76 rows where place_id = 605602

✎ 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
3662290 1914121 1914121 defendant Wylson Thomas butcher 605602 605602 Wylson, Thomas, of Blyth, butcher 0
3750239 1941992 1941992 defendant Warner William yeoman 605602 605602 Warner, William, of Blyth, yeoman 0
3782193 1952183 1952183 plaintiff Holleke alias Spades Bartholomew   605602 605602 Holleke alias Spades, Bartholomew, of Blyth 0
3816336 1963018 1963018 defendant Byngley Richard carpenter 605602 605602 Byngley, Richard, of Blyth, carpenter 0
3817641 1963419 1963419 defendant Waryner William yeoman 605602 605602 Waryner, William, of Blyth, yeoman 0
3864307 1978256 1978256 defendant Stamyden William yeoman 605602 605602 Stamyden, William, of Blyth, yeoman 3
3876651 1982435 1982435 defendant Bugmere Gregory husbandman 605602 605602 Bugmere, Gregory, of Blyth, husbandman 0
3882616 1984450 1984450 defendant Byngley Richard husbandman 605602 605602 Byngley, Richard, of Blyth, husbandman 0
3925569 1998864 1998864 defendant Wylson Nicholas butcher 605602 605602 Wylson, Nicholas, of Blyth, butcher 4
4441294 2182210 2182210 defendant Chapman John   605602 605602 Chapman, John, of Blyth 1
4450333 2185063 2185063 plaintiff Hapull John chaplain 605602 605602 Hapull, John, of Blyth, chaplain 0
4538012 2212169 2212169 defendant Watson Adam   605602 605602 Watson, Adam, of Blyth 0
4546123 2214734 2214734 defendant Crokehay Robert   605602 605602 Crokehay, Robert, of Blyth 0
4558885 2218739 2218739 defendant Holmeker Richard   605602 605602 Holmeker, Richard, of Blyth 0
4605555 2232857 2232857 defendant Toreworth John tanner 605602 605602 Toreworth, John, of Blyth, tanner 1
4615215 2235768 2235768 defendant Baggeley Thomas   605602 605602 Baggeley, Thomas, of Blyth 0
4636213 2242159 2242159 plaintiff Bageley Thomas   605602 605602 Bageley, Thomas, of Blyth 0
4645431 2244732 2244732 defendant Beyston Thomas de   605602 605602 Beyston, Thomas de, of Blyth, vicar 0
4654973 2247439 2247439 defendant Lytster Richard dyer 605602 605602 Lytster, Richard, of Blyth, dyer 0
4683513 2260445 2260445 defendant Baglay Thomas draper 605602 605602 Baglay, Thomas, of Blyth, draper 0
4712275 2269153 2269153 defendant Bagley Thomas de draper 605602 605602 Bagley, Thomas de, of Blyth, draper 3
4726786 2273648 2273648 defendant Baggeley Thomas draper 605602 605602 Baggeley, Thomas, of Blyth, draper 0
4732869 2275456 2275456 defendant Skemer John yeoman 605602 605602 Skemer, John, of Blyth, yeoman 0
4745924 2279312 2279312 defendant Bocher Henry husbandman 605602 605602 Bocher, Henry, of Blyth, husbandman 1
4753623 2281503 2281503 defendant Bagelay Thomas draper 605602 605602 Bagelay, Thomas, of Blyth, draper 0
4760949 2283766 2283766 defendant Torwoth John husbandman 605602 605602 Torwoth, John, of Blyth, husbandman 0
4772239 2287290 2287290 defendant Bagley Thomas chapman 605602 605602 Bagley, Thomas, of Blyth, chapman 1
4794748 2294496 2294496 defendant Baiteclyff Thomas yeoman 605602 605602 Baiteclyff, Thomas, of Blyth, yeoman 2
4797395 2295358 2295358 defendant Bagley Thomas chapman 605602 605602 Bagley, Thomas, of Blyth, chapman 1
4797406 2295359 2295359 defendant Bagley Thomas chapman 605602 605602 Bagley, Thomas, of Blyth, chapman 1
4800579 2296363 2296363 defendant Bageley Thomas draper 605602 605602 Bageley, Thomas, of Blyth, draper 0
4802949 2297108 2297108 defendant Whytby Thomas barber 605602 605602 Whytby, Thomas, of Blyth, barber 0
4823263 2303365 2303365 defendant Hudson Richard yeoman 605602 605602 Hudson, Richard, of Blyth, yeoman 1
4837546 2307678 2307678 defendant Cotyngham John   605602 605602 Cotyngham, John, of Blyth, prior 0
4870549 2317762 2317762 defendant Henryot or Heuryot Hugh barker 605602 605602 Henryot or Heuryot, Hugh, of Blyth, barker 1
4870551 2317762 2317762 defendant Lyndesey John dyer 605602 605602 Lyndesey, John, of Blyth, dyer 3
4894170 2324870 2324870 defendant Bellowe John laborer 605602 605602 Bellowe, John, of Blyth, laborer 2
4973543 2349036 2349036 defendant Barbour George barber 605602 605602 Barbour, George, of Blyth, barber 0
4997966 2356251 2356251 defendant Tyas William butcher 605602 605602 Tyas, William, of Blyth, butcher 3
4997967 2356251 2356251 defendant Glasyer William glasier 605602 605602 Glasyer, William, of Blyth, glasier 4
4999310 2356667 2356667 defendant Belewes Joan widow 605602 605602 Belewes, Joan, of Blyth, widow 0
5012113 2360393 2360393 defendant Hankok Robert yeoman 605602 605602 Hankok, Robert, of Blyth, yeoman 0
5012116 2360394 2360394 defendant Hankok Robert yeoman 605602 605602 Hankok, Robert, of Blyth, yeoman 0
5034260 2366875 2366875 defendant Hudson Richard yeoman 605602 605602 Hudson, Richard, of Blyth, yeoman 0
5060118 2374595 2374595 plaintiff Saddeby John   605602 605602 Saddeby, John, of Blyth 1
5081529 2380976 2380976 defendant Hodsone Richard yeoman 605602 605602 Hodsone, Richard, of Blyth, yeoman 0
5094923 2384927 2384927 defendant Hudson Richard yeoman 605602 605602 Hudson, Richard, of Blyth, yeoman 5
5106472 2388326 2388326 defendant Watson John yeoman 605602 605602 Watson, John, of Blyth, yeoman 0
5106473 2388326 2388326 defendant Stronge Robert yeoman 605602 605602 Stronge, Robert, of Blyth, yeoman 1
5119086 2392021 2392021 defendant Edyngborugh Henry yeoman 605602 605602 Edyngborugh, Henry, of Blyth, yeoman 3
5122917 2393134 2393134 defendant Smyth Oliver smith 605602 605602 Smyth, Oliver, of Blyth, smith 1
5122928 2393136 2393136 defendant Smyth Oliver smith 605602 605602 Smyth, Oliver, of Blyth, smith 0
5325439 2452693 2452693 defendant Jappe John yeoman 605602 605602 Jappe, John, of Blyth, yeoman 0
5325440 2452693 2452693 defendant Bagley John laborer 605602 605602 Bagley, John, of Blyth, laborer 1
5325441 2452693 2452693 defendant Edmond John shoemaker 605602 605602 Edmond, John, of Blyth, shoemaker 2
5325442 2452693 2452693 defendant Gybson Peter tailor 605602 605602 Gybson, Peter, of Blyth, tailor 3
5334990 2455535 2455535 defendant Wyddur John, senior butcher 605602 605602 Wyddur, John, senior, of Blyth, butcher 0
5334991 2455535 2455535 defendant Wyddur John, junior laborer 605602 605602 Wyddur, John, junior, of Blyth, laborer 1
5334992 2455535 2455535 defendant Wyddur Thomas laborer 605602 605602 Wyddur, Thomas, of Blyth, laborer 2
5334993 2455535 2455535 defendant Tryne or Tryve Peter laborer 605602 605602 Tryne or Tryve, Peter, of Blyth, laborer 3
5347781 2459459 2459459 defendant Wyder John, senior butcher 605602 605602 Wyder, John, senior, of Blyth, butcher 0
5347782 2459459 2459459 defendant Faldyngworth James laborer 605602 605602 Faldyngworth, James, of Blyth, laborer 1
5347783 2459459 2459459 defendant Edynburgh Henry laborer 605602 605602 Edynburgh, Henry, of Blyth, laborer 2
5364281 2464488 2464488 defendant Marshall John draper 605602 605602 Marshall, John, of Blyth, draper 0
5426259 2482809 2482809 plaintiff Couper John smith 605602 605602 Couper, John, of Blyth, smith 0
5496689 2503930 2503930 defendant Peeke William mercer 605602 605602 Peeke, William, of Blyth, mercer 0
5525283 2512500 2512500 defendant Estfeld Henry chaplain 605602 605602 Estfeld, Henry, of Blyth, chaplain 0
5559882 2522852 2522852 defendant Marshall Robert yeoman 605602 605602 Marshall, Robert, of Blyth, yeoman 0
5559883 2522852 2522852 defendant Broke Christopher barber 605602 605602 Broke, Christopher, of Blyth, barber 1
5559885 2522852 2522852 defendant Rawlynson John yeoman 605602 605602 Rawlynson, John, of Blyth, yeoman 3
5559897 2522853 2522853 defendant Marshall Robert yeoman 605602 605602 Marshall, Robert, of Blyth, yeoman 0
5559898 2522853 2522853 defendant Croke Christopher barber 605602 605602 Croke, Christopher, of Blyth, barber 1
5559900 2522853 2522853 defendant Rawlynson John yeoman 605602 605602 Rawlynson, John, of Blyth, yeoman 3
5559901 2522853 2522853 defendant Gybson Peter tailor 605602 605602 Gybson, Peter, of Blyth, tailor 4
5573341 2526760 2526760 defendant Pek John chaplain 605602 605602 Pek, John, of Blyth, chaplain 0
5615910 2548777 2548777 plaintiff Hareworth Thomas de   605602 605602 Hareworth, Thomas de, of Blyth 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);