names

16 rows where place_id = 786212

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4696334 2264334 2264334 defendant Stoteyerd John husbandman 786212 786212 Stoteyerd, John, of Rotherfield, husbandman 4
4696335 2264334 2264334 defendant Stoteyerd Richard husbandman 786212 786212 Stoteyerd, Richard, of Rotherfield, husbandman 5
4696336 2264334 2264334 defendant Tonner Thomas husbandman 786212 786212 Tonner, Thomas, of Rotherfield, husbandman 6
4702360 2266148 2266148 defendant Wylde William laborer 786212 786212 Wylde, William, of Rotherfield, laborer 0
4702553 2266210 2266210 defendant Cheseman William   786212 786212 together with Cheseman, William, of Rotherfield, "cynyer" or "syvyer" 1
4710123 2268519 2268519 defendant Pendere John husbandman 786212 786212 Pendere, John, of Rotherfield, husbandman 0
4716974 2270641 2270641 defendant Daly Thomas husbandman 786212 786212 Daly, Thomas, of Rotherfield, husbandman 0
4716976 2270642 2270642 defendant Daly Thomas husbandman 786212 786212 Daly, Thomas, of Rotherfield, husbandman 0
4716977 2270642 2270642 defendant Smart John laborer 786212 786212 Smart, John, of Rotherfield, laborer 1
4716979 2270643 2270643 defendant Daly Thomas husbandman 786212 786212 Daly, Thomas, of Rotherfield, husbandman 0
4769106 2286316 2286316 defendant Pendere John butcher 786212 786212 Pendere, John, of Rotherfield, butcher 12
4769109 2286316 2286316 defendant Bocher John butcher 786212 786212 Bocher, John, of Rotherfield, butcher 15
4769117 2286316 2286316 defendant Smale William forester 786212 786212 Smale, William, of Rotherfield, forester 23
4813840 2300439 2300439 defendant atte Hall Thomas husbandman 786212 786212 atte Hall, Thomas, of Rotherfield, husbandman 0
5001206 2357233 2357233 defendant Mason Thomas syvyer or maker of seives 786212 786212 Mason, Thomas, of Rotherfield, syvyer or maker of seives 0
5395120 2473672 2473672 defendant Benet Simon trogger or trug maker 786212 786212 Benet, Simon, of Rotherfield, trogger or trug maker 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);