names

24 rows where place_id = 601390

✎ 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
3645139 1908887 1908887 defendant Baxster Robert smith 601390 601390 Baxster, Robert, of Bardwell, smith 1
3775730 1950158 1950158 defendant Walter John miller 601390 601390 Walter, John, of Bardwell, miller 2
3780648 1951674 1951674 defendant Seffrey William husbandman 601390 601390 Seffrey, William, of Bardwell, husbandman 1
3796145 1956659 1956659 defendant Beynde John husbandman 601390 601390 Beynde, John, of Bardwell, husbandman 0
3820148 1964178 1964178 defendant Kegyll John husbandman 601390 601390 Kegyll, John, of Bardwell, husbandman 2
3905514 1992113 1992113 plaintiff Kyppyng Richard (legal representative) 601390 601390 Kyppyng, Richard, of Bardwell, clerk, executor of 0
3905516 1992113 1992113 defendant West John husbandman 601390 601390 West, John, of Bardwell, husbandman 0
3905517 1992113 1992113 defendant Wendowte John, senior husbandman 601390 601390 Wendowte, John, senior, of Bardwell, husbandman 1
3951131 2007464 2007464 defendant Ede Robert husbandman 601390 601390 Ede, Robert, of Bardwell, husbandman 0
3956890 2009480 2009480 defendant Ede Robert husbandman 601390 601390 Ede, Robert, of Bardwell, husbandman 0
4000207 2024842 2024842 defendant Wyndout John husbandman 601390 601390 Wyndout, John, of Bardwell, husbandman 1
4006323 2027040 2027040 defendant Pymme Richard thatcher 601390 601390 Pymme, Richard, of Bardwell, thatcher 0
4029242 2035103 2035103 defendant Doo John yeoman 601390 601390 Doo, John, of Bardwell, yeoman 0
4046209 2041085 2041085 defendant Cage Thomas yeoman 601390 601390 Cage, Thomas, of Bardwell, yeoman 0
4054130 2043864 2043864 defendant Cage Thomas yeoman 601390 601390 Cage, Thomas, of Bardwell, yeoman 0
4056571 2044737 2044737 defendant Cage Thomas yeoman 601390 601390 Cage, Thomas, of Bardwell, yeoman 0
4056573 2044738 2044738 defendant Cage Thomas yeoman 601390 601390 Cage, Thomas, of Bardwell, yeoman 0
4059187 2045683 2045683 defendant Cage Thomas yeoman 601390 601390 Cage, Thomas, of Bardwell, yeoman 1
4097247 2059335 2059335 defendant Glover William husbandman 601390 601390 Glover, William, of Bardwell, husbandman 2
4110846 2064134 2064134 defendant Doo John husbandman 601390 601390 Doo, John, of Bardwell, husbandman 0
4280270 2123005 2123005 defendant Kent Robert yeoman 601390 601390 Kent, Robert, of Bardwell, yeoman 0
4406861 2166863 2166863 defendant Crofts Charles gent 601390 601390 Crofts, Charles, of Bardwell, gent 1
5123850 2393432 2393432 defendant Sponer William husbandman 601390 601390 Sponer, William, of Bardwell, husbandman 0
5123851 2393432 2393432 defendant Sponer Robert husbandman 601390 601390 Sponer, Robert, of Bardwell, husbandman 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);