names

86 rows where place_id = 588070

✎ 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
3593266 1865527 1865527 defendant Wynter Thomas husbandman 588070 588070 Wynter, Thomas, of Quaplode, husbandman 1
3676561 1918710 1918710 defendant Botysham John laborer 588070 588070 Botysham, John, of Quaplode, laborer 2
4448312 2184395 2184395 defendant Tries William   588070 588070 Tries, William, of quaplode 0
4501982 2201218 2201218 defendant Cutered John   588070 588070 Cutered, John, of Quaplode 0
4571364 2222628 2222628 defendant Smyth John   588070 588070 Smyth, John, of Quaplode 0
4737320 2276791 2276791 defendant Randes Robert husbandman 588070 588070 Randes, Robert, of Quaplode, husbandman 0
4739359 2277396 2277396 defendant Welby Geoffrey yeoman 588070 588070 Welby, Geoffrey, of Quaplode, yeoman 0
4740177 2277641 2277641 defendant Cawode William husbandman 588070 588070 Cawode, William, of Quaplode, husbandman 6
4768366 2286076 2286076 defendant Pynchebek Gilbert husbandman 588070 588070 Pynchebek, Gilbert, of Quaplode, husbandman 0
4773421 2287661 2287661 defendant Skynner Roger yeoman 588070 588070 Skynner, Roger, of Quaplode, yeoman 0
4782968 2290693 2290693 defendant Swanpekke John husbandman 588070 588070 Swanpekke, John, of Quaplode, husbandman 0
4815377 2300917 2300917 defendant Calowe Simon husbandman 588070 588070 Calowe, Simon, of Quaplode, husbandman 1
4815378 2300917 2300917 defendant Idon John yeoman 588070 588070 Idon, John, of Quaplode, yeoman 2
4848667 2311054 2311054 defendant Gamull Simon husbandman 588070 588070 Gamull, Simon, of Quaplode, husbandman 0
4861740 2315044 2315044 defendant Scarlet Alan husbandman 588070 588070 Scarlet, Alan, of Quaplode, husbandman 0
4865120 2316065 2316065 defendant Scarlet John husbandman 588070 588070 Scarlet, John, of Quaplode, husbandman 0
4865122 2316065 2316065 defendant Birke William husbandman 588070 588070 Birke, William, of Quaplode, husbandman 2
4866502 2316483 2316483 defendant Fyssher Robert husbandman 588070 588070 Fyssher, Robert, of Quaplode, husbandman 0
4866503 2316483 2316483 defendant Randalfe Henry husbandman 588070 588070 Randalfe, Henry, of Quaplode, husbandman 1
4866504 2316483 2316483 defendant Jelowe Simon, senior husbandman 588070 588070 Jelowe, Simon, senior, of Quaplode, husbandman 2
4866505 2316483 2316483 defendant Oky Robert husbandman 588070 588070 Oky, Robert, of Quaplode, husbandman 3
4866506 2316483 2316483 defendant Sharpe Lambert husbandman 588070 588070 Sharpe, Lambert, of Quaplode, husbandman 4
4869206 2317342 2317342 defendant Iden John yeoman 588070 588070 Iden, John, of Quaplode, yeoman 0
4869772 2317514 2317514 defendant Gamull Simon husbandman 588070 588070 Gamull, Simon, of Quaplode, husbandman 0
4874319 2318911 2318911 defendant Gamull Simon, junior husbandman 588070 588070 Gamull, Simon, junior, of Quaplode, husbandman 0
4874320 2318911 2318911 defendant Pereson Adam husbandman 588070 588070 Pereson, Adam, of Quaplode, husbandman 1
4878111 2320107 2320107 defendant Sawyer John   588070 588070 Sawyer, John, of Quaplode, cartwright 0
4881962 2321257 2321257 defendant Skarlet Alan husbandman 588070 588070 Skarlet, Alan, of Quaplode, husbandman 0
4892089 2324267 2324267 defendant Wenesley John husbandman 588070 588070 Wenesley, John, of Quaplode, husbandman 0
4897483 2325873 2325873 defendant Roper Thomas husbandman 588070 588070 Roper, Thomas, of Quaplode, husbandman 3
4901002 2326942 2326942 defendant Spendlove Thomas husbandman 588070 588070 Spendlove, Thomas, of Quaplode, husbandman 1
4907621 2328948 2328948 defendant Ethard John husbandman 588070 588070 Ethard, John, of Quaplode, husbandman 1
4908432 2329193 2329193 defendant Perysson Mary widow 588070 588070 Perysson, Mary, of Quaplode, widow 0
4908433 2329193 2329193 defendant Male Richard husbandman 588070 588070 with Male, Richard, of Quaplode, husbandman 1
5061962 2375179 2375179 defendant Cawode Joan widow 588070 588070 (Cawode, Joan, of Quaplode, widow 1
5061963 2375179 2375179 defendant Cawode John husbandman 588070 588070 Cawode, John, of Quaplode, husbandman 2
5061965 2375179 2375179 defendant Asten John smith 588070 588070 Asten, John, of Quaplode, smith 4
5075155 2379066 2379066 defendant Akke Simon yeoman 588070 588070 Akke, Simon, of Quaplode, yeoman 0
5081468 2380955 2380955 defendant Trassh John husbandman 588070 588070 Trassh, John, of Quaplode, husbandman 3
5081469 2380955 2380955 defendant Goolde William, senior husbandman 588070 588070 Goolde, William, senior, of Quaplode, husbandman 4
5081470 2380955 2380955 defendant Calowe William husbandman 588070 588070 Calowe, William, of Quaplode, husbandman 5
5081471 2380955 2380955 defendant Scarlet Robert husbandman 588070 588070 Scarlet, Robert, of Quaplode, husbandman 6
5100624 2386610 2386610 defendant Wyllyamson Richard barber 588070 588070 Wyllyamson, Richard, of Quaplode, barber 1
5148504 2400689 2400689 defendant Wyvylsey Robert husbandman 588070 588070 Wyvylsey, Robert, of Quaplode, husbandman 0
5162363 2404719 2404719 defendant Godehusbond William husbandman 588070 588070 Godehusbond, William, of Quaplode, husbandman 0
5296116 2443853 2443853 defendant Palfrayman Gilbert husbanman 588070 588070 Palfrayman, Gilbert, of Quaplode, husbanman 1
5359966 2463156 2463156 defendant Pynder John husbandman 588070 588070 Pynder, John, of Quaplode, husbandman 1
5383701 2470422 2470422 defendant Wryght Thomas husbandman 588070 588070 Wryght, Thomas, of Quaplode, husbandman 3
5383702 2470422 2470422 defendant Alexander Robert barber 588070 588070 Alexander, Robert, of Quaplode, barber 4
5383703 2470422 2470422 defendant Galich_ John shoemaker 588070 588070 Galich_, John, of Quaplode, shoemaker 5
5385710 2470983 2470983 defendant Knobyll William husbandman 588070 588070 Knobyll, William, of Quaplode, husbandman 0
5390162 2472247 2472247 defendant Male John husbandman 588070 588070 Male, John, of Quaplode, husbandman 3
5391793 2472729 2472729 defendant Wylsey John husbandman 588070 588070 Wylsey, John, of Quaplode, husbandman 1
5391796 2472729 2472729 defendant Darlyng John husbandman 588070 588070 Darlyng, John, of Quaplode, husbandman 4
5391797 2472729 2472729 defendant Prowet William husbandman 588070 588070 Prowet, William, of Quaplode, husbandman 5
5391802 2472730 2472730 defendant Echard Thomas husbandman 588070 588070 Echard, Thomas, of Quaplode, husbandman 3
5391803 2472730 2472730 defendant Atkyn Thomas husbandman 588070 588070 Atkyn, Thomas, of quaplode, husbandman 4
5391928 2472769 2472769 defendant Idon William yeoman 588070 588070 Idon, William, of Quaplode, yeoman 0
5391930 2472769 2472769 defendant Markam Gilbert   588070 588070 Markam, Gilbert, of Quaplode 2
5392307 2472888 2472888 defendant Male John husbandman 588070 588070 Male, John, of Quaplode, husbandman 2
5397898 2474471 2474471 defendant Knobyll or Knovyll William husbandman 588070 588070 Knobyll or Knovyll, William, of Quaplode, husbandman 0
5402945 2475922 2475922 defendant Male John husbadnman 588070 588070 Male, John, of Quaplode, husbadnman 2
5404776 2476446 2476446 defendant Echard Thomas husbandman 588070 588070 Echard, Thomas, of Quaplode, husbandman 3
5404777 2476446 2476446 defendant Atkyn Thomas husbandman 588070 588070 Atkyn, Thomas, of quaplode, husbandman 4
5404783 2476447 2476447 defendant Darlyng John husbandman 588070 588070 Darlyng, John, of Quaplode, husbandman 4
5404784 2476447 2476447 defendant Prowet William husbandman 588070 588070 Prowet, William, of Quaplode, husbandman 5
5404789 2476448 2476448 plaintiff Echard Thomas husbandman 588070 588070 Echard, Thomas, of Quaplode, husbandman 4
5415920 2479694 2479694 defendant Male John husbandman 588070 588070 Male, John, of Quaplode, husbandman 3
5415922 2479695 2479695 defendant Idon William husbandman 588070 588070 Idon, William, of Quaplode, husbandman 0
5417916 2480285 2480285 defendant Wylsey John husbandman 588070 588070 Wylsey, John, of Quaplode, husbandman 1
5417919 2480285 2480285 defendant Darlyng John husbandman 588070 588070 Darlyng, John, of Quaplode, husbandman 4
5417920 2480285 2480285 defendant Prowet William husbandman 588070 588070 Prowet, William, of Quaplode, husbandman 5
5422102 2481552 2481552 defendant Wright Thomas husbandman 588070 588070 Wright, Thomas, of Quaplode, husbandman 3
5422103 2481552 2481552 defendant Alexander Robert barber 588070 588070 Alexander, Robert, of Quaplode, barber 4
5422104 2481552 2481552 defendant Galthorp John shoemaker 588070 588070 Galthorp, John, of Quaplode, shoemaker 5
5432488 2484688 2484688 defendant Male John husbandman 588070 588070 Male, John, of Quaplode, husbandman 3
5432490 2484689 2484689 defendant Idon William husbandman 588070 588070 Idon, William, of Quaplode, husbandman 0
5465997 2494758 2494758 defendant Knobyll of Knovyll William husbandman 588070 588070 Knobyll of Knovyll, William, of Quaplode, husbandman 0
5472477 2496732 2496732 defendant Belward Gilbert weaver 588070 588070 Belward, Gilbert, of Quaplode, weaver 4
5472478 2496732 2496732 defendant Daweson Gilbert husbandman 588070 588070 Daweson, Gilbert, of Quaplode, husbandman 5
5501279 2505336 2505336 defendant Brix William tiler 588070 588070 Brix, William, of Quaplode, tiler 0
5541072 2517331 2517331 defendant Pynder Thomas tailor 588070 588070 Pynder, Thomas, of Quaplode, tailor 0
5544856 2518500 2518500 plaintiff Sergeant John (legal representative) 588070 588070 Sergeant, John, of Quaplode, executors of 0
5544860 2518500 2518500 defendant Idon William yeoman 588070 588070 Idon, William, of Quaplode, yeoman 0
5544864 2518500 2518500 defendant Spendluff John carpenter 588070 588070 Spendluff, John, of Quaplode, carpenter 4
5632351 2554150 2554150 defendant Horne William husbandman 588070 588070 Horne, William, of Quaplode, husbandman 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);