names

26 rows where place_id = 587425

✎ 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
3591380 1864928 1864928 defendant Mapyll Richard husbandman 587425 587425 Mapyll, Richard, of Lamburn, husbandman 0
3694454 1924471 1924471 defendant Beamond Gilbert chaplain 587425 587425 Beamond, Gilbert, of Lamburn, chaplain 0
3801970 1958511 1958511 defendant Bodinebras or Boemebras Richard clerk 587425 587425 Bodinebras or Boemebras, Richard, of Lamburn, clerk 0
3801973 1958512 1958512 defendant Boemebras Richard clerk 587425 587425 Boemebras, Richard, of Lamburn, clerk 0
4674126 2257514 2257514 defendant Payn William husbandman 587425 587425 Payn, William, of Lamburn, husbandman 2
4689371 2262236 2262236 defendant Chyselden John esq 587425 587425 Chyselden, John, of Lamburn, esq 0
4842387 2309154 2309154 defendant Brightriche Roger husbandman 587425 587425 Brightriche, Roger, of Lamburn, husbandman 0
4842389 2309154 2309154 defendant Nute John husbandman 587425 587425 Nute, John, of Lamburn, husbandman 2
4869865 2317546 2317546 defendant Bryghtriche Roger husbandman 587425 587425 Bryghtriche, Roger, of Lamburn, husbandman 0
4869867 2317546 2317546 defendant Nute John husbandman 587425 587425 Nute, John, of Lamburn, husbandman 2
4876130 2319494 2319494 defendant Cooke Isabel widow 587425 587425 Cooke, Isabel, of Lamburn, widow 1
4928923 2335470 2335470 plaintiff Spynage alias Spynnage William   587425 587425 Spynage alias Spynnage, William, of Lamburn 0
4935765 2337578 2337578 defendant Laxston Thomas yeoman 587425 587425 Laxston, Thomas, of Lamburn, yeoman 0
4990041 2353932 2353932 defendant Pach Richard husbandman 587425 587425 Pach, Richard, of Lamburn, husbandman 0
5223358 2422525 2422525 defendant Gymbill Richard husbandman 587425 587425 Gymbill, Richard, of Lamburn, husbandman 0
5223359 2422525 2422525 defendant Poynttell John husbandman 587425 587425 Poynttell, John, of Lamburn, husbandman 1
5233406 2425360 2425360 defendant Pacche John husbandman 587425 587425 Pacche, John, of Lamburn, husbandman 2
5287349 2441323 2441323 defendant Ballard Roger husbandman 587425 587425 Ballard, Roger, of Lamburn, husbandman 0
5310570 2448196 2448196 defendant Ballard Roger yeoman 587425 587425 Ballard, Roger, of Lamburn, yeoman 0
5357481 2462406 2462406 defendant Pache John yeoman 587425 587425 Pache, John, of Lamburn, yeoman 4
5388683 2471819 2471819 defendant Pacche Thomas husbandman 587425 587425 Pacche, Thomas, of Lamburn, husbandman 0
5445464 2488541 2488541 defendant Wattys John husbandman 587425 587425 Wattys, John, of Lamburn, husbandman 2
5585631 2530576 2530576 defendant Harvy John husbandman 587425 587425 Harvy, John, of Lamburn, husbandman 0
5585633 2530576 2530576 defendant Elys Edmund collier 587425 587425 Elys, Edmund, of Lamburn, collier 2
5585634 2530576 2530576 defendant Mawdesley William clerk 587425 587425 Mawdesley, William, of Lamburn, clerk 3
5594428 2533236 2533236 defendant Pache Robert collier 587425 587425 Pache, Robert, of Lamburn, collier 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);