names

32 rows where place_id = 587657

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592067 1865134 1865134 plaintiff Forthey John   587657 587657 Forthey, John, of North Lech 0
3935778 2002272 2002272 defendant Grove John glover 587657 587657 Grove, John, of North Lech, glover 0
4445072 2183432 2183432 defendant Sprot John   587657 587657 Sprot, John, of North Lech 5
4449353 2184746 2184746 defendant Ryche Richard   587657 587657 Ryche, Richard, of North Lech 0
4449356 2184747 2184747 defendant Somury John   587657 587657 Somury, John, of North Lech 0
4449357 2184747 2184747 defendant Skynnere Robert   587657 587657 Skynnere, Robert, of North Lech 1
4449358 2184747 2184747 defendant shepherd Thomas   587657 587657 shepherd, Thomas, of North Lech 2
4449359 2184747 2184747 defendant Walkere John   587657 587657 Walkere, John, of North Lech 3
4449360 2184747 2184747 defendant Smyth William   587657 587657 Smyth, William, of North Lech 4
4449361 2184747 2184747 defendant Harpour John   587657 587657 Harpour, John, of North Lech 5
4449364 2184747 2184747 defendant Chapman Richard   587657 587657 Chapman, Richard, of North Lech 8
4449367 2184747 2184747 defendant Porter Philip   587657 587657 Porter, Philip, of North Lech 11
4449369 2184747 2184747 defendant Colpton Joan de   587657 587657 Colpton, Joan de, of North Lech 13
4466403 2190159 2190159 plaintiff Adynet Thomas   587657 587657 Adynet, Thomas, of North Lech 0
4513983 2204794 2204794 defendant Fysshere John   587657 587657 Fysshere, John, of North Lech 1
4520036 2206597 2206597 plaintiff Eynesham John   587657 587657 Eynesham, John, of North Lech 0
4539203 2212518 2212518 plaintiff Venyton Richard   587657 587657 Venyton, Richard, of North Lech 0
4569095 2221922 2221922 defendant Graunger Thomas   587657 587657 Graunger, Thomas, of North Lech 0
4589061 2227958 2227958 defendant Clifford Mathew   587657 587657 Clifford, Mathew, of North Lech 0
4589065 2227959 2227959 defendant Clifford Mathew   587657 587657 Clifford, Mathew, of North Lech 0
4600654 2231432 2231432 plaintiff Toummes John   587657 587657 Toummes, John, of North Lech 0
4600655 2231432 2231432 defendant Harpour John   587657 587657 Harpour, John, of North Lech 0
4604463 2232565 2232565 defendant Toursy Thomas   587657 587657 Toursy, Thomas, of North Lech 0
4617323 2236435 2236435 defendant Smyth William   587657 587657 Smyth, William, of North Lech 1
4617325 2236435 2236435 defendant Hosyer Richard   587657 587657 Hosyer, Richard, of North Lech 3
4629327 2240104 2240104 defendant Wade William   587657 587657 Wade, William, of North Lech 1
4638049 2242662 2242662 defendant Leget John   587657 587657 Leget, John, of North Lech 0
4678554 2258898 2258898 defendant Beggeworth Robert tailor 587657 587657 Beggeworth, Robert, of North Lech, tailor 0
4730349 2274692 2274692 plaintiff Malle John   587657 587657 Malle, John, of North Lech 0
4814482 2300637 2300637 defendant Bocherd William chapman 587657 587657 Bocherd, William, of North Lech, chapman 1
4818255 2301787 2301787 defendant Tropenell William husbandman 587657 587657 Tropenell, William, of North Lech, husbandman 0
4819980 2302326 2302326 defendant Bocherd William mercer 587657 587657 Bocherd, William, of North Lech, mercer 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);