names

30 rows where place_id = 610849

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3685567 1921636 1921636 defendant Tyler William husbandman 610849 610849 Tyler, William, of Ailesham, husbandman 0
3870534 1980384 1980384 defendant Palmer John, junior laborer 610849 610849 Palmer, John, junior, of Ailesham, laborer 0
3870536 1980385 1980385 defendant Palmer John, senior husbandman 610849 610849 Palmer, John, senior, of Ailesham, husbandman 0
3925519 1998845 1998845 defendant Ryches Andrew laborer 610849 610849 Ryches, Andrew, of Ailesham, laborer 0
3925520 1998845 1998845 defendant Barndy Richard laborer 610849 610849 Barndy, Richard, of Ailesham, laborer 1
4149018 2077774 2077774 defendant Leaman William yeoman 610849 610849 Leaman, William, of Ailesham, yeoman 0
4149019 2077774 2077774 defendant Coo William yeoman 610849 610849 Coo, William, of Ailesham, yeoman 1
4278603 2122450 2122450 defendant Burwaye Clement   610849 610849 Burwaye, Clement, of Ailesham, worsted weaver 1
4390988 2161604 2161604 defendant Bradwell Robert gent 610849 610849 (Bradwell, Robert, of Ailesham, gent 3
4447860 2184256 2184256 defendant Warner Philip   610849 610849 Warner, Philip, of Ailesham 0
4459627 2188065 2188065 defendant Warner Philip   610849 610849 Warner, Philip, of Ailesham 0
4629925 2240280 2240280 defendant Spynk William   610849 610849 Spynk, William, of Ailesham 0
4629930 2240281 2240281 defendant Brunston Edmund   610849 610849 Brunston, Edmund, of Ailesham 3
4648374 2245571 2245571 defendant Wolleman Adam   610849 610849 Wolleman, Adam, of Ailesham 13
4670870 2256566 2256566 defendant Edlynges Thomas   610849 610849 Edlynges, Thomas, of Ailesham, 0
4672062 2256911 2256911 defendant Isak John husbandman 610849 610849 Isak, John, of Ailesham, husbandman 2
4672067 2256912 2256912 defendant Isak John husbandman 610849 610849 Isak, John, of Ailesham, husbandman 3
4684213 2260665 2260665 defendant Bennes Adam   610849 610849 Bennes, Adam, of Ailesham 1
4687104 2261571 2261571 defendant Edlynges Thomas   610849 610849 Edlynges, Thomas, of Ailesham 0
4687105 2261571 2261571 defendant Barbour Richard yeoman 610849 610849 Barbour, Richard, of Ailesham, yeoman 1
4706545 2267424 2267424 defendant Abbes John yeoman 610849 610849 Abbes, John, of Ailesham, yeoman 7
4714858 2269981 2269981 defendant Brunston John   610849 610849 Brunston, John, of Ailesham 2
4718107 2271005 2271005 defendant Brumston Edmund husbandman 610849 610849 Brumston, Edmund, of Ailesham, husbandman 0
4757094 2282590 2282590 defendant Barbour Richard husbandman 610849 610849 Barbour, Richard, of Ailesham, husbandman 0
4778036 2289117 2289117 defendant Colet Bartholomew yeoman 610849 610849 Colet, Bartholomew, of Ailesham, yeoman 0
4823070 2303300 2303300 plaintiff Spynk William   610849 610849 Spynk, William, of Ailesham 0
4825105 2303894 2303894 defendant Barsham William tailor 610849 610849 Barsham, William, of Ailesham, tailor 1
5163919 2405186 2405186 plaintiff Wright Nicholas   610849 610849 Wright, Nicholas, of Ailesham 0
5516347 2509946 2509946 defendant Aleyn Geoffrey smith 610849 610849 Aleyn, Geoffrey, of Ailesham, smith 1
5623739 2551362 2551362 defendant Sterre John baker 610849 610849 Sterre, John, of Ailesham, baker 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);