names

21 rows where place_id = 768200

✎ 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
4546931 2214972 2214972 defendant Whelere Adam   768200 768200 Whelere, Adam, of Heriettesham 1
4598450 2230753 2230753 plaintiff Taillour John   768200 768200 Taillour, John, of Heriettesham 3
4599460 2231047 2231047 defendant atte Felde John   768200 768200 atte Felde, John, of Heriettesham 5
4626249 2239169 2239169 defendant Cotynge Robert   768200 768200 Cotynge, Robert, of Heriettesham 0
4661581 2249456 2249456 defendant Scot Richard husbandman 768200 768200 Scot, Richard, of Heriettesham, husbandman 1
4664274 2250309 2250309 defendant Frere Thomas husbandman 768200 768200 Frere, Thomas, of Heriettesham, husbandman 0
4664276 2250309 2250309 defendant Walter John laborer 768200 768200 Walter, John, of Heriettesham, laborer 2
4778584 2289287 2289287 defendant Tykeners John repyer or fishmonger 768200 768200 Tykeners, John, of Heriettesham, repyer or fishmonger 3
4782857 2290657 2290657 defendant Walter Richard husbandman 768200 768200 Walter, Richard, of Heriettesham, husbandman 1
4795290 2294677 2294677 defendant Pilcher Richard butcher 768200 768200 Pilcher, Richard, of Heriettesham, butcher 0
4891781 2324171 2324171 defendant Rust Richard rypyer or fishmonger 768200 768200 Rust, Richard, of Heriettesham, rypyer or fishmonger 1
4896461 2325562 2325562 defendant Waryn Robert rypyer or fishmonger 768200 768200 Waryn, Robert, of Heriettesham, rypyer or fishmonger 0
5046518 2370600 2370600 defendant Waryn Robert husbandman 768200 768200 Waryn, Robert, of Heriettesham, husbandman 0
5128338 2394766 2394766 defendant Feld Alexander repyer or one who carries fish inland to sell 768200 768200 Feld, Alexander, of Heriettesham, repyer or one who carries fish inland to sell 2
5131082 2395578 2395578 defendant Hunte Thomas carpenter 768200 768200 Hunte, Thomas, of Heriettesham, carpenter 0
5219223 2421346 2421346 defendant Molet William butcher 768200 768200 Molet, William, of Heriettesham, butcher 0
5234205 2425593 2425593 defendant Stede John (legal representative) 768200 768200 Stede, John, of Heriettesham, laborer, executors of 3
5234207 2425593 2425593 defendant Gotesle Thomas husbandman 768200 768200 Gotesle, Thomas, of Heriettesham, husbandman 5
5238827 2426945 2426945 defendant Molet William butcher 768200 768200 Molet, William, of Heriettesham, butcher 0
5365268 2464811 2464811 defendant Tryppe John repyer 768200 768200 Tryppe, John, of Heriettesham, repyer 2
5610203 2546905 2546905 defendant Parker John   768200 768200 Parker, John, of Heriettesham 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);