names

28 rows where place_id = 768656

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4550997 2216249 2216249 defendant Petyt John   768656 768656 Petyt, John, of Sudbury, Suffolk 0
4702822 2266281 2266281 defendant Hunt John clerk 768656 768656 Hunt, John, of Sudbury, Suffolk, clerk 0
4704174 2266684 2266684 plaintiff Hudlesho Richard   768656 768656 Hudlesho, Richard, of Sudbury, Suffolk 0
4708776 2268115 2268115 defendant Darre Richard yeoman 768656 768656 Darre, Richard, of Sudbury, Suffolk, yeoman 4
4710839 2268746 2268746 plaintiff Roberd Henry   768656 768656 Roberd, Henry, of Sudbury, Suffolk 0
4713547 2269556 2269556 defendant Reve John mercer 768656 768656 Reve, John, of Sudbury, Suffolk, mercer 0
4714845 2269977 2269977 plaintiff Turnour John   768656 768656 Turnour, John, of Sudbury, Suffolk 0
4735471 2276239 2276239 defendant Bust John yeoman 768656 768656 Bust, John, of Sudbury, Suffolk, yeoman 2
4761851 2284050 2284050 defendant Legerd William chapman 768656 768656 Legerd, William, of Sudbury, Suffolk, chapman 0
4849285 2311254 2311254 defendant (not given) Robert vicar of Derham alias Brawuch 768656 768656 Derham alias Brawuch, Robert, of Sudbury, Suffolk, vicar of All Saints church 0
4849297 2311259 2311259 defendant (not given) Robert vicar of Derham 768656 768656 Derham, Robert, of Sudbury, Suffolk, vicar of All Souls church 0
4987280 2353145 2353145 defendant Cresse William esq 768656 768656 Cresse, William, of Sudbury, Suffolk, esq 1
4989143 2353690 2353690 defendant Deynes Robert   768656 768656 Deynes, Robert, of Sudbury, Suffolk, wood man 0
4991602 2354370 2354370 defendant Hunt John   768656 768656 Hunt, John, of Sudbury, Suffolk 1
5147064 2400280 2400280 defendant Brese Richard   768656 768656 Brese, Richard, of Sudbury, Suffolk, glove maker 2
5149733 2401055 2401055 defendant Mayster William grocer 768656 768656 Mayster, William, of Sudbury, Suffolk, grocer 0
5152262 2401791 2401791 defendant Lovell John vintner 768656 768656 Lovell, John, of Sudbury, Suffolk, vintner 0
5162614 2404788 2404788 defendant Goday Thomas (legal representative) 768656 768656 Goday, Thomas, of Sudbury, Suffolk, carpenter, executor of 0
5162618 2404789 2404789 defendant Synton William shoemaker 768656 768656 Synton, William, of Sudbury, Suffolk, shoemaker 1
5176595 2408840 2408840 defendant Gooday Thomas (legal representative) 768656 768656 Gooday, Thomas, of Sudbury, Suffolk, carpenter, executor of 0
5186640 2411842 2411842 defendant Coteler John chapman 768656 768656 Coteler, John, of Sudbury, Suffolk, chapman 0
5189077 2412537 2412537 defendant (not given) Thomas prior of Banes 768656 768656 Banes, Thomas, of Sudbury, Suffolk, prior of the house of St Bartholomew alias Banes, Thomas, prior of the house or church of St Enswithe, in Folkestone, Kent 0
5189125 2412552 2412552 defendant (not given) Thomas prior of Banes 768656 768656 Banes, Thomas, of Sudbury, Suffolk, alias prior of the house or church of St Enswythe, in Folkestone, Kent 2
5203194 2416696 2416696 defendant Brese Richard   768656 768656 Brese, Richard, of Sudbury, Suffolk, glove maker 0
5205285 2417302 2417302 defendant Coteler John chapman 768656 768656 Coteler, John, of Sudbury, Suffolk, chapman 0
5206383 2417600 2417600 defendant (not given) Thomas prior of Banes 768656 768656 Banes, Thomas, of Sudbury, Suffolk, prior of the house of St Bartholomew alias Banes, Thomas, prior of the house or church of St Enswithe, in Folkestone, Kent 0
5305333 2446601 2446601 defendant Turtell John shoemaker 768656 768656 Turtell, John, of Sudbury, Suffolk, shoemaker 1
5311223 2448383 2448383 defendant Howard Thomas yeoman 768656 768656 Howard, Thomas, of Sudbury, Suffolk, yeoman 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);