names

18 rows where place_id = 649399

✎ 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
3906488 1992462 1992462 defendant Burchwell Philip husbandman 649399 649399 Burchwell, Philip, of Lynham, husbandman 0
3906489 1992462 1992462 defendant Lanser Thomas husbandman 649399 649399 Lanser, Thomas, of Lynham, husbandman 1
4222654 2103415 2103415 defendant Dunnyngton Dorothy widow 649399 649399 Dunnyngton, Dorothy, of Lynham, widow 0
4705575 2267113 2267113 defendant Smyth Robert smith 649399 649399 Smyth, Robert, of Lynham, smith 1
4721514 2272060 2272060 defendant Crokker John   649399 649399 Crokker, John, of Lynham 0
4751466 2280911 2280911 defendant Haynys Thomas ploughman 649399 649399 Haynys, Thomas, of Lynham, ploughman 0
4751501 2280922 2280922 plaintiff Smerforde William   649399 649399 Smerforde, William, of Lynham 0
4833374 2306444 2306444 defendant Blakeman John butcher 649399 649399 Blakeman, John, of Lynham, butcher 4
4834548 2306814 2306814 plaintiff Crokker John   649399 649399 Crokker, John, of Lynham 0
4834552 2306815 2306815 plaintiff Crokker John   649399 649399 Crokker, John, of Lynham 0
4888019 2323059 2323059 plaintiff Crokker John (legal representative) 649399 649399 Crokker, John, of Lynham, or of Hele, esq, executors of 0
4910495 2329796 2329796 defendant Crokkey John (legal representative) 649399 649399 Crokkey, John, of Lynham, executors of 0
4910498 2329796 2329796 defendant Hillesdon Andrew gent 649399 649399 Hillesdon, Andrew, of Lynham, gent 3
4990209 2353979 2353979 defendant Somersed Thomas husbandman 649399 649399 Somersed, Thomas, of Lynham, husbandman 0
5281901 2439782 2439782 defendant Hillersdon Andrew gent 649399 649399 Hillersdon, Andrew, of Lynham, gent 0
5367545 2465497 2465497 defendant Walsh Edward laborer 649399 649399 Walsh, Edward, of Lynham, laborer 0
5367912 2465588 2465588 defendant Halsh Edward laborer 649399 649399 Halsh, Edward, of Lynham, laborer 0
5516280 2509924 2509924 defendant Ricardes John husbandman 649399 649399 Ricardes, John, of Lynham, husbandman 1

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