names

14 rows where place_id = 599213

✎ 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
3635773 1905989 1905989 defendant Tomkyns William laborer 599213 599213 Tomkyns, William, of Sutton Colfeld, laborer 0
3635776 1905990 1905990 defendant Tomkyns William laborer 599213 599213 Tomkyns, William, of Sutton Colfeld, laborer 0
3635779 1905991 1905991 defendant Tomkyns William laborer 599213 599213 Tomkyns, William, of Sutton Colfeld, laborer 0
4478392 2193916 2193916 defendant Stokes Nicholas   599213 599213 Stokes, Nicholas, of Sutton Colfeld, vicar 3
4528233 2209104 2209104 defendant Nowers Robert   599213 599213 Nowers, Robert, of Sutton Colfeld 1
4604383 2232542 2232542 defendant Gybons John   599213 599213 Gybons, John, of Sutton Colfeld 0
4809672 2299189 2299189 defendant Hapethorp John chapman 599213 599213 Hapethorp, John, of Sutton Colfeld, chapman 1
5152625 2401908 2401908 plaintiff Hill Thomas (legal representative) 599213 599213 Hill, Thomas, of Sutton Colfeld, parson, master & clerk, executors of 0
5407115 2477094 2477094 defendant Nayler William drover 599213 599213 Nayler, William, of Sutton Colfeld, drover 3
5568059 2525208 2525208 defendant Colle Richard   599213 599213 Colle, Richard, of Sutton Colfeld, "foyster" 4
5568060 2525208 2525208 defendant Deye Thomas laborer 599213 599213 Deye, Thomas, of Sutton Colfeld, laborer 5
5599658 2534784 2534784 defendant Wylkys William butcher 599213 599213 Wylkys, William, of Sutton Colfeld, butcher 0
5599659 2534784 2534784 defendant Knyght John husbandman 599213 599213 Knyght, John, of Sutton Colfeld, husbandman 1
5599660 2534784 2534784 defendant Sponer Robert carpenter 599213 599213 Sponer, Robert, of Sutton Colfeld, carpenter 2

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);