names

28 rows where place_id = 609975

✎ 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
3681315 1920245 1920245 defendant Godsaff Hugh yeoman 609975 609975 Godsaff, Hugh, of Parva Elyngham, yeoman 0
3951092 2007448 2007448 defendant Ryxe Robert   609975 609975 Ryxe, Robert, of Parva Elyngham, wheelwright 0
3976178 2016235 2016235 defendant Bonell Richard husbandman 609975 609975 Bonell, Richard, of Parva Elyngham, husbandman 0
3993479 2022410 2022410 defendant Myddleton John clerk 609975 609975 Myddleton, John, of Parva Elyngham, clerk 0
4657549 2248253 2248253 defendant Cuccok Thomas yeoman 609975 609975 Cuccok, Thomas, of Parva Elyngham, yeoman 0
4657550 2248253 2248253 defendant Gerard John husbandman 609975 609975 Gerard, John, of Parva Elyngham, husbandman 1
4657551 2248253 2248253 defendant Grene John husbandman 609975 609975 Grene, John, of Parva Elyngham, husbandman 2
4860606 2314675 2314675 defendant Cokho Thomas yeoman 609975 609975 Cokho, Thomas, of Parva Elyngham, yeoman 0
4887207 2322840 2322840 defendant Monter or Mouter Robert yeoman 609975 609975 Monter or Mouter, Robert, of Parva Elyngham, yeoman 7
4892253 2324319 2324319 defendant Martyn William yeoman 609975 609975 Martyn, William, of Parva Elyngham, yeoman 1
4897770 2325968 2325968 defendant Monter Robert yeoman 609975 609975 Monter, Robert, of Parva Elyngham, yeoman 7
4905191 2328220 2328220 defendant Monter Robert yeoman 609975 609975 Monter, Robert, of Parva Elyngham, yeoman 6
4945527 2340579 2340579 defendant Dekys John laborer 609975 609975 Dekys, John, of Parva Elyngham, laborer 2
4974962 2349484 2349484 plaintiff Monter Robert   609975 609975 Monter, Robert, of Parva Elyngham 0
5071303 2377912 2377912 defendant Methewold Robert husbandman 609975 609975 Methewold, Robert, of Parva Elyngham, husbandman 3
5105977 2388187 2388187 defendant Gerard John husbandman 609975 609975 Gerard, John, of Parva Elyngham, husbandman 4
5114459 2390627 2390627 defendant Methewold Robert gent 609975 609975 Methewold, Robert, of Parva Elyngham, gent 0
5114515 2390645 2390645 defendant Methwold Robert gent 609975 609975 Methwold, Robert, of Parva Elyngham, gent 0
5281465 2439647 2439647 defendant Salet Richard husbandman 609975 609975 Salet, Richard, of Parva Elyngham, husbandman 2
5293892 2443184 2443184 defendant Martyn John husbandman 609975 609975 Martyn, John, of Parva Elyngham, husbandman 3
5312357 2448732 2448732 defendant Selot Richard yeoman 609975 609975 Selot, Richard, of Parva Elyngham, yeoman 0
5314283 2449290 2449290 defendant Selot Richrd husbandman 609975 609975 Selot, Richrd, of Parva Elyngham, husbandman 1
5314284 2449290 2449290 defendant Whytred Simon husbandman 609975 609975 Whytred, Simon, of Parva Elyngham, husbandman 2
5503713 2506075 2506075 defendant Salet Richard husbandman 609975 609975 Salet, Richard, of Parva Elyngham, husbandman 2
5504733 2506397 2506397 defendant Carter Robert husbandman 609975 609975 Carter, Robert, of Parva Elyngham, husbandman 0
5524068 2512317 2512317 defendant Bele Thomas yeoman 609975 609975 Bele, Thomas, of Parva Elyngham, yeoman 0
5524069 2512317 2512317 defendant Edryche John yeoman 609975 609975 Edryche, John, of Parva Elyngham, yeoman 1
5524959 2512403 2512403 defendant Bele Thomas yeoman 609975 609975 Bele, Thomas, of Parva Elyngham, yeoman 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);