names

66 rows where place_id = 589336

✎ 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
3597265 1866764 1866764 defendant Lotte John husbandman 589336 589336 Lotte, John, of Stokbery, husbandman 0
3597266 1866764 1866764 defendant Culter John husbandman 589336 589336 Culter, John, of Stokbery, husbandman 1
3659238 1913145 1913145 defendant Goodgrome John husbandman 589336 589336 Goodgrome, John, of Stokbery, husbandman 0
3679498 1919657 1919657 defendant Plotte John husbandman 589336 589336 Plotte, John, of Stokbery, husbandman 0
3682937 1920776 1920776 defendant Smyth John smith 589336 589336 Smyth, John, of Stokbery, smith 0
3690974 1923340 1923340 defendant Bukmere Richard husbandman 589336 589336 Bukmere, Richard, of Stokbery, husbandman 0
3690976 1923340 1923340 defendant Knyght John husbandman 589336 589336 Knyght, John, of Stokbery, husbandman 2
3768696 1947856 1947856 defendant Baker John husbandman 589336 589336 Baker, John, of Stokbery, husbandman 0
3794072 1956009 1956009 defendant Goodgrove Edward laborer 589336 589336 Goodgrove, Edward, of Stokbery, laborer 1
3801086 1958256 1958256 defendant Baker John husbandman 589336 589336 Baker, John, of Stokbery, husbandman 0
3808718 1960606 1960606 defendant Bote Robert husbandman 589336 589336 Bote, Robert, of Stokbery, husbandman 0
3808928 1960671 1960671 defendant Kemsley Edward husbandman 589336 589336 Kemsley, Edward, of Stokbery, husbandman 0
3818322 1963636 1963636 defendant Rycard Roger, senior husbandman 589336 589336 Rycard, Roger, senior, of Stokbery, husbandman 3
3818323 1963636 1963636 defendant Rycard Roger, junior husbandman 589336 589336 Rycard, Roger, junior, of Stokbery, husbandman 4
3826758 1966222 1966222 defendant Rolf Matthew husbandman 589336 589336 Rolf, Matthew, of Stokbery, husbandman 0
3827488 1966462 1966462 defendant Rolff Matthew husbandman 589336 589336 Rolff, Matthew, of Stokbery, husbandman 0
3838570 1969990 1969990 defendant Hewes William husbandman 589336 589336 Hewes, William, of Stokbery, husbandman 0
3838571 1969990 1969990 defendant Hyllys John husbandman 589336 589336 Hyllys, John, of Stokbery, husbandman 1
3841245 1970843 1970843 defendant Rolffe Mathew husbandman 589336 589336 Rolffe, Mathew, of Stokbery, husbandman 0
3841351 1970871 1970871 defendant Plott Alexander yeoman 589336 589336 Plott, Alexander, of Stokbery, yeoman 0
3909131 1993351 1993351 defendant Boote Robert husbandman 589336 589336 Boote, Robert, of Stokbery, husbandman 4
4760531 2283645 2283645 defendant Boton John husbandman 589336 589336 Boton, John, of Stokbery, husbandman 0
4811590 2299733 2299733 defendant Belle John clerk 589336 589336 Belle, John, of Stokbery, clerk 0
4830141 2305468 2305468 plaintiff Boton John   589336 589336 Boton, John, of Stokbery 1
4830897 2305688 2305688 plaintiff Boton John   589336 589336 Boton, John, of Stokbery 0
4838025 2307816 2307816 defendant Tomlyn Thomas cooper 589336 589336 Tomlyn, Thomas, of Stokbery, cooper 0
4891313 2324010 2324010 defendant Cokke John husbandman 589336 589336 Cokke, John, of Stokbery, husbandman 0
4917442 2331969 2331969 defendant Cokke John husbandman 589336 589336 Cokke, John, of Stokbery, husbandman 0
5022402 2363451 2363451 defendant Cok John husbandman 589336 589336 Cok, John, of Stokbery, husbandman 0
5046820 2370670 2370670 defendant Cokke John yeoman 589336 589336 Cokke, John, of Stokbery, yeoman 0
5081682 2381027 2381027 defendant Saver- John husbandman 589336 589336 Saver-, John, of Stokbery, husbandman 2
5104987 2387899 2387899 defendant Cokke John yeoman 589336 589336 Cokke, John, of Stokbery, yeoman 2
5105738 2388128 2388128 defendant Cok John husbandman 589336 589336 Cok, John, of Stokbery, husbandman 1
5123316 2393260 2393260 defendant Cok John husbandman 589336 589336 Cok, John, of Stokbery, husbandman 0
5128869 2394929 2394929 defendant (illegible) John husbandman 589336 589336 --, John, of Stokbery, husbandman 0
5136576 2397215 2397215 defendant Beke Richard husbandman 589336 589336 Beke, Richard, of Stokbery, husbandman 0
5147887 2400523 2400523 defendant Cok John husbandman 589336 589336 Cok, John, of Stokbery, husbandman 0
5182855 2410736 2410736 defendant Cok John husbandman 589336 589336 Cok, John, of Stokbery, husbandman 0
5189506 2412671 2412671 defendant Cokke John husbandman 589336 589336 Cokke, John, of Stokbery, husbandman 0
5189508 2412672 2412672 defendant Cokke John husbandman 589336 589336 Cokke, John, of Stokbery, husbandman 0
5193018 2413685 2413685 defendant Beket Richard husbandman 589336 589336 Beket, Richard, of Stokbery, husbandman 0
5203612 2416811 2416811 defendant Cok John husbandman 589336 589336 Cok, John, of Stokbery, husbandman 0
5206518 2417638 2417638 defendant Cok John husbandman 589336 589336 Cok, John, of Stokbery, husbandman 0
5215671 2420307 2420307 defendant Cokke John husbandman 589336 589336 Cokke, John, of Stokbery, husbandman 4
5215694 2420312 2420312 defendant Saverey John laborer 589336 589336 Saverey, John, of Stokbery, laborer 4
5217111 2420744 2420744 defendant Koo John husbandman 589336 589336 Koo, John, of Stokbery, husbandman 1
5229659 2424295 2424295 defendant Gerard John carpenter 589336 589336 Gerard, John, of Stokbery, carpenter 0
5234200 2425592 2425592 defendant Saverey John laborer 589336 589336 Saverey, John, of Stokbery, laborer 4
5245406 2428811 2428811 defendant Plot William carpenter 589336 589336 Plot, William, of Stokbery, carpenter 2
5245407 2428811 2428811 defendant Plot John laborer 589336 589336 Plot, John, of Stokbery, laborer 3
5245408 2428811 2428811 defendant Plot Bartholomew laborer 589336 589336 Plot, Bartholomew, of Stokbery, laborer 4
5317251 2450241 2450241 defendant Buntaunt Richard husbandman 589336 589336 Buntaunt, Richard, of Stokbery, husbandman 2
5372883 2467114 2467114 defendant Beket Simons butcher 589336 589336 Beket, Simons, of Stokbery, butcher 2
5379448 2469163 2469163 defendant Dunton John, senior yeoman 589336 589336 Dunton, John, senior, of Stokbery, yeoman 0
5385524 2470930 2470930 defendant Boket Simon butcher 589336 589336 Boket, Simon, of Stokbery, butcher 0
5394602 2473516 2473516 defendant Boket Simon butcher 589336 589336 Boket, Simon, of Stokbery, butcher 3
5396104 2473970 2473970 defendant Cutler John husbandman 589336 589336 Cutler, John, of Stokbery, husbandman 0
5410800 2478177 2478177 defendant Beket Simon butcher 589336 589336 Beket, Simon, of Stokbery, butcher 0
5445843 2488646 2488646 defendant Beket Simon butcher 589336 589336 Beket, Simon, of Stokbery, butcher 0
5477703 2498350 2498350 defendant Culter John husbandman 589336 589336 Culter, John, of Stokbery, husbandman 3
5514522 2509390 2509390 defendant Saney or Savey William husbandman 589336 589336 Saney or Savey, William, of Stokbery, husbandman 0
5519562 2510955 2510955 defendant Plotte Thomas husbandman 589336 589336 Plotte, Thomas, of Stokbery, husbandman 2
5519563 2510955 2510955 defendant Baker John smith 589336 589336 Baker, John, of Stokbery, smith 3
5519565 2510955 2510955 defendant Norton Thomas husbandman 589336 589336 Norton, Thomas, of Stokbery, husbandman 5
5558500 2522434 2522434 plaintiff Petit William gent 589336 589336 Petit, William, of Stokbery, gent 0
5635134 2554967 2554967 defendant Lyford John husbandman 589336 589336 Lyford, John, of Stokbery, 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);