names

47 rows where place_id = 622892

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3749487 1941750 1941750 defendant Thrope Thomas gent 622892 622892 Thrope, Thomas, of Torkesey, Lincs, gent 0
3929569 2000238 2000238 defendant Nevyll William esq 622892 622892 Nevyll, William, of Torkesey, Lincs, esq 0
3958013 2009868 2009868 defendant Nevyll William esq 622892 622892 Nevyll, William, of Torkesey, Lincs, esq 0
3996893 2023655 2023655 defendant Thorpe Robert gent 622892 622892 Thorpe, Robert, of Torkesey, Lincs, gent 0
3998845 2024342 2024342 defendant Thorpe Robert gent 622892 622892 Thorpe, Robert, of Torkesey, Lincs, or of Brent Illeghe, Suff, gent 0
4005045 2026590 2026590 defendant Thorpe Robert gent 622892 622892 Thorpe, Robert, of Torkesey, Lincs, gent 0
4005047 2026591 2026591 defendant Thorpe Robert gent 622892 622892 Thorpe, Robert, of Torkesey, Lincs, gent 0
4010136 2028394 2028394 defendant Nevyll William gent 622892 622892 Nevyll, William, of Torkesey, Lincs, gent 0
4012691 2029263 2029263 defendant Nevell William esq 622892 622892 Nevell, William, of Torkesey, Lincs, esq 0
4014368 2029858 2029858 defendant Nevell William esq 622892 622892 Nevell, William, of Torkesey, Lincs, esq 0
4015192 2030124 2030124 defendant Nevyll William gent 622892 622892 Nevyll, William, of Torkesey, Lincs, gent 0
4019832 2031824 2031824 defendant Thorpe Robert gent 622892 622892 Thorpe, Robert, of Torkesey, Lincs, gent 0
4031630 2035975 2035975 defendant Thorpe Robert gent 622892 622892 Thorpe, Robert, of Torkesey, Lincs, or of Brent Illeigh, Suff, gent 0
4053962 2043794 2043794 defendant Hardyng William gent 622892 622892 Hardyng, William, of Torkesey, Lincs, gent 0
4074925 2051333 2051333 defendant Johnson Richard gent 622892 622892 Johnson, Richard, of Torkesey, Lincs, gent 0
4147816 2077377 2077377 defendant Syngleton Charles gent 622892 622892 Syngleton, Charles, of Torkesey, Lincs, gent 1
4276513 2121725 2121725 defendant Browne Edward husbandman 622892 622892 Browne, Edward, of Torkesey, Lincs, husbandman 0
4276515 2121726 2121726 defendant Browne Edward husbandman 622892 622892 Browne, Edward, of Torkesey, Lincs, husbandman 0
4677721 2258649 2258649 defendant Sparowe John shipman 622892 622892 Sparowe, John, of Torkesey, Lincs, shipman 0
4693924 2263604 2263604 defendant Grenak Robert husbandman 622892 622892 Grenak, Robert, of Torkesey, Lincs, husbandman 0
4820240 2302399 2302399 defendant Swaton Thomas husbandman 622892 622892 Swaton, Thomas, of Torkesey, Lincs, husbandman 2
4893480 2324660 2324660 defendant Pace Nicholas merchant 622892 622892 Pace, Nicholas, of Torkesey, Lincs, merchant 0
5000041 2356894 2356894 defendant Bocher Richard butcher 622892 622892 Bocher, Richard, of Torkesey, Lincs, butcher 0
5001509 2357334 2357334 defendant Hudleston Nicholas gent 622892 622892 Hudleston, Nicholas, of Torkesey, Lincs, gent 0
5001512 2357335 2357335 defendant Hudleston Nicholas   622892 622892 Hudleston, Nicholas, of Torkesey, Lincs 0
5006262 2358727 2358727 defendant Edward John baker 622892 622892 Edward, John, of Torkesey, Lincs, baker 2
5018074 2362170 2362170 defendant Barbour William merchant 622892 622892 Barbour, William, of Torkesey, Lincs, merchant 0
5027976 2365060 2365060 defendant Barbour William merchant 622892 622892 Barbour, William, of Torkesey, Lincs, merchant 3
5049721 2371540 2371540 defendant Welles John yeoman 622892 622892 Welles, John, of Torkesey, Lincs, yeoman 0
5083806 2381657 2381657 defendant Canell or Cavell Margery widow 622892 622892 Canell or Cavell, Margery, of Torkesey, Lincs, widow 1
5138953 2397888 2397888 defendant Clayton William esq 622892 622892 Clayton, William, of Torkesey, LIncs, esq 8
5159136 2403788 2403788 defendant Upton John shipman 622892 622892 Upton, John, of Torkesey, Lincs, shipman 2
5174374 2408207 2408207 defendant Upton John shipman 622892 622892 Upton, John, of Torkesey, Lincs, shipman 2
5174807 2408329 2408329 defendant Claxston William esq 622892 622892 Claxston, William, of Torkesey, Lincs, esq 2
5194991 2414285 2414285 defendant Upton John shipman 622892 622892 Upton, John, of Torkesey, Lincs, shipman 2
5194998 2414286 2414286 defendant Upton John shipman 622892 622892 Upton, John, of Torkesey, Lincs, shipman 2
5259000 2432929 2432929 defendant Chapman Joan widow 622892 622892 Chapman, Joan, of Torkesey, Lincs, widow 4
5291076 2442392 2442392 defendant Fox Nicholas chapman 622892 622892 Fox, Nicholas, of Torkesey, Lincs, chapman 3
5298706 2444596 2444596 defendant Lyntham Robert yeoman 622892 622892 Lyntham, Robert, of Torkesey, Lincs, yeoman 0
5313193 2448979 2448979 defendant Lyntham Robert yeoman 622892 622892 Lyntham, Robert, of Torkesey, Lincs, yeoman 0
5313195 2448980 2448980 defendant Lyntham Robert yeoman 622892 622892 Lyntham, Robert, of Torkesey, Lincs, yeoman 0
5347639 2459417 2459417 defendant Lyntham or Lyncham Robert yeoman 622892 622892 Lyntham or Lyncham, Robert, of Torkesey, Lincs, yeoman 1
5347646 2459418 2459418 defendant Lyntham or Lyncham Robert yeoman 622892 622892 Lyntham or Lyncham, Robert, of Torkesey, Lincs, yeoman 1
5361262 2463549 2463549 defendant Unton Richard yeoman 622892 622892 Unton, Richard, of Torkesey, Lincs, yeoman 0
5563868 2524042 2524042 defendant Banes James yeoman 622892 622892 Banes, James, of Torkesey, Lincs, yeoman 0
5580076 2528848 2528848 defendant Cleyton William clerk 622892 622892 Cleyton, William, of Torkesey, Lincs, clerk 3
5627001 2552416 2552416 defendant Chamberleyn John yeoman 622892 622892 Chamberleyn, John, of Torkesey, Lincs, yeoman 1

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);