names

41 rows where place_id = 756821

✎ 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
4440723 2182013 2182013 plaintiff Berwys Christine   756821 756821 Berwys, Christine, of Bemynstre 0
4452784 2185882 2185882 plaintiff Knyght John   756821 756821 Knyght, John, of Bemynstre 0
4457649 2187399 2187399 defendant Antony John   756821 756821 Antony, John, of Bemynstre or Beaminster 4
4472533 2192078 2192078 defendant Dyere Thomas   756821 756821 Dyere, Thomas, of Bemynstre 0
4499108 2200364 2200364 defendant Budde William   756821 756821 Budde, William, of Bemynstre 0
4532764 2210519 2210519 defendant Mason John   756821 756821 Mason, John, of Bemynstre 0
4543400 2213824 2213824 defendant Dudde William   756821 756821 Dudde, William, of Bemynstre 0
4554326 2217282 2217282 defendant Bykelegh John   756821 756821 Bykelegh, John, of Bemynstre 0
4554328 2217283 2217283 defendant Don John   756821 756821 Don, John, of Bemynstre 0
4554329 2217283 2217283 defendant Bukham John   756821 756821 Bukham, John, of Bemynstre 1
4554330 2217283 2217283 defendant Paul Thomas   756821 756821 Paul, Thomas, of Bemynstre 2
4565974 2220912 2220912 plaintiff Spiryng William (legal representative) 756821 756821 Spiryng, William, of Bemynstre, executors of 0
4567858 2221519 2221519 plaintiff Touker Thomas   756821 756821 Touker, Thomas, of Bemynstre 0
4570412 2222319 2222319 defendant Combe William   756821 756821 Combe, William, of Bemynstre 0
4570536 2222359 2222359 defendant Cabbell Roger   756821 756821 Cabbell, Roger, of Bemynstre 0
4570537 2222359 2222359 defendant Deygher Thomas   756821 756821 Deygher, Thomas, of Bemynstre 1
4570541 2222359 2222359 defendant Mirfeld William   756821 756821 Mirfeld, William, of Bemynstre 5
4622119 2237895 2237895 defendant Dudilbury William   756821 756821 Dudilbury, William, of Bemynstre, vicar 0
4734529 2275966 2275966 defendant Note Roger husbandman 756821 756821 Note, Roger, of Bemynstre, husbandman 0
4744994 2279049 2279049 defendant Norman John husbandman 756821 756821 Norman, John, of Bemynstre, husbandman 0
4778980 2289403 2289403 defendant Reynald William tailor 756821 756821 Reynald, William, of Bemynstre, tailor 0
4778981 2289403 2289403 defendant Davy William husbandman 756821 756821 Davy, William, of Bemynstre, husbandman 1
4778982 2289403 2289403 defendant Davy Thomas husbandman 756821 756821 Davy, Thomas, of Bemynstre, husbandman 2
4779876 2289704 2289704 defendant Bocher John husbandman 756821 756821 Bocher, John, of Bemynstre, husbandman 0
4782607 2290574 2290574 defendant Coche William husbandman 756821 756821 Coche, William, of Bemynstre, husbandman 1
4793843 2294196 2294196 defendant Dygon William butcher 756821 756821 Dygon, William, of Bemynstre, butcher 0
4794073 2294280 2294280 defendant Touker Richard ticker 756821 756821 Touker, Richard, of Bemynstre, ticker 0
4866028 2316344 2316344 defendant Chike Thomas husbandman 756821 756821 Chike, Thomas, of Bemynstre, husbandman 0
4866029 2316344 2316344 defendant Geryn Robert laborer 756821 756821 Geryn, Robert, of Bemynstre, laborer 1
4952171 2342615 2342615 defendant Veyfere John husbandman 756821 756821 Veyfere, John, of Bemynstre, husbandman 3
4976419 2349910 2349910 defendant Davy Thomas yeoman 756821 756821 Davy, Thomas, of Bemynstre, yeoman 0
5058560 2374116 2374116 plaintiff Davy Thomas   756821 756821 Davy, Thomas, of Bemynstre 0
5062698 2375401 2375401 plaintiff Hoggys Richard   756821 756821 Hoggys, Richard, of Bemynstre 0
5232846 2425190 2425190 defendant Roope John, senior husbandman 756821 756821 Roope, John, senior, of Bemynstre, husbandman 0
5232847 2425190 2425190 defendant Carswell John barber 756821 756821 Carswell, John, of Bemynstre, barber 1
5232848 2425190 2425190 defendant Roope John, junior husbandman 756821 756821 Roope, John, junior, of Bemynstre, husbandman 2
5232849 2425190 2425190 defendant More John singleman 756821 756821 More, John, of Bemynstre, singleman 3
5617261 2549215 2549215 defendant Pires John   756821 756821 Pires, John, of Bemynstre 0
5620637 2550322 2550322 defendant Rede William   756821 756821 Rede, William, of Bemynstre 1
5620922 2550416 2550416 defendant Henghelet William   756821 756821 Henghelet, William, of Bemynstre 0
5622160 2550848 2550848 defendant Marchal John   756821 756821 Marchal, John, of Bemynstre 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);