names

45 rows where place_id = 696193

✎ 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
4113259 2065009 2065009 defendant Wheatley William laborer 696193 696193 Wheatley, William, of Leicestershire, laborer 1
4185804 2090530 2090530 defendant Stanley John chapman 696193 696193 Stanley, John, of Leicestershire, chapman 0
4466024 2190032 2190032 defendant Sextenby John de   696193 696193 Sextenby, John de, of Leicestershire 1
4466030 2190034 2190034 defendant Greyleby John de   696193 696193 Greyleby, John de, of Leicestershire 0
4469212 2191039 2191039 plaintiff Blakfordeby Thomas de   696193 696193 Blakfordeby, Thomas de, of Leicestershire 0
4469214 2191040 2191040 plaintiff Blakfordeby Thomas de   696193 696193 Blakfordeby, Thomas de, of Leicestershire 0
4474641 2192733 2192733 defendant Broune John   696193 696193 Broune, John, of Leicestershire 0
4498475 2200171 2200171 defendant Burbache Nicholas   696193 696193 Burbache, Nicholas, of Leicestershire 0
4526227 2208492 2208492 defendant Skenyngton John   696193 696193 Skenyngton, John, of Leicestershire 2
4533004 2210592 2210592 defendant Hatter William   696193 696193 Hatter, William, of Leicestershire 2
4555571 2217672 2217672 defendant Thorp Thomas   696193 696193 Thorp, Thomas, of Leicestershire 0
4556198 2217881 2217881 defendant Nevyle John   696193 696193 Nevyle, John, of Leicestershire, knight 1
4556208 2217882 2217882 defendant Nevyle John   696193 696193 Nevyle, John, of Leicestershire, knight 1
4557627 2218319 2218319 defendant Belgrave Peter   696193 696193 Belgrave, Peter, of Leicestershire 1
4566908 2221213 2221213 defendant Gerard John esq 696193 696193 Gerard, John, of Leicestershire, esq 3
4566915 2221215 2221215 defendant Gerard John esq 696193 696193 Gerard, John, of Leicestershire, esq 3
4578484 2224760 2224760 defendant Kyghley Gilbert   696193 696193 Kyghley, Gilbert, of Leicestershire 0
4578486 2224761 2224761 defendant Kyghley Gilbert   696193 696193 Kyghley, Gilbert, of Leicestershire 0
4593839 2229348 2229348 defendant Wrygth Robert   696193 696193 Wrygth, Robert, of Leicestershire, son of Joan Wrigth, living in Fresby 1
4614776 2235632 2235632 defendant Langton John   696193 696193 Langton, John, of Leicestershire 0
4619280 2237024 2237024 defendant Smyth Robert   696193 696193 Smyth, Robert, of Leicestershire 0
4630748 2240509 2240509 defendant P_ John   696193 696193 P_, John, of Leicestershire 5
4648589 2245642 2245642 plaintiff Symond John   696193 696193 Symond, John, of Leicestershire 0
4667849 2255647 2255647 plaintiff Palemre John   696193 696193 Palemre, John, of Leicestershire 3
4677411 2258551 2258551 defendant Asteley Thomas esq 696193 696193 Asteley, Thomas, of Leicestershire, esq 0
4702792 2266273 2266273 defendant Asteley Thomas esq 696193 696193 Asteley, Thomas, of Leicestershire, esq 0
4757813 2282821 2282821 plaintiff Brokesby Bartholomew esq 696193 696193 Brokesby, Bartholomew, of Leicestershire, esq 0
4805228 2297835 2297835 plaintiff Brokesby Bartholomew   696193 696193 Brokesby, Bartholomew, of Leicestershire 0
4808646 2298869 2298869 plaintiff Dalby Thomas   696193 696193 Dalby, Thomas, of Leicestershire 0
4988920 2353634 2353634 defendant Creweker John   696193 696193 Creweker, John, of Leicestershire 0
5132381 2395968 2395968 defendant Hore William draper 696193 696193 Hore, William, of Leicestershire, draper 4
5161117 2404352 2404352 plaintiff Staunton Thomas esq 696193 696193 Staunton, Thomas, of Leicestershire, esq 0
5161121 2404353 2404353 plaintiff Staunton Thomas esq 696193 696193 Staunton, Thomas, of Leicestershire, esq 0
5175630 2408558 2408558 plaintiff Staunton Thomas esq 696193 696193 Staunton, Thomas, of Leicestershire, esq 0
5197059 2414884 2414884 plaintiff Staunton Thomas esq 696193 696193 Staunton, Thomas, of Leicestershire, esq 0
5272111 2436924 2436924 defendant Doreward John butcher 696193 696193 Doreward, John, of Leicestershire, butcher 2
5383344 2470315 2470315 plaintiff (illegible) Thomas   696193 696193 _, Thomas, of Leicestershire, knight 0
5383994 2470510 2470510 plaintiff Barkeley Thomas   696193 696193 Barkeley, Thomas, of Leicestershire, knight 0
5407247 2477135 2477135 defendant Collez Thomas husbandman 696193 696193 Collez, Thomas, of Leicestershire, husbandman 0
5409094 2477687 2477687 plaintiff Barkeley Thomas   696193 696193 Barkeley, Thomas, of Leicestershire, knight 0
5420499 2481053 2481053 defendant (illegible) Thomas husbandman 696193 696193 _, Thomas, of Leicestershire, husbandman 0
5422510 2481678 2481678 plaintiff Barkeley Thomas   696193 696193 Barkeley, Thomas, of Leicestershire, knight 0
5423029 2481837 2481837 plaintiff Berkeley Thomas   696193 696193 Berkeley, Thomas, of Leicestershire, knight 0
5477393 2498254 2498254 defendant Potman William gent // Beatrice 696193 696193 Potman, William, of Leicestershire, gent // Beatrice 1
5633134 2554366 2554366 plaintiff Symond John   696193 696193 Symond, John, of Leicestershire 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);