names

59 rows where place_id = 762289

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4486426 2196466 2196466 defendant Gold William   762289 762289 Gold, William, of Idenne 2
4494227 2198885 2198885 defendant Sandre William   762289 762289 Sandre, William, of Idenne 1
4524439 2207983 2207983 defendant Salerne John   762289 762289 together with Salerne, John, of Idenne 1
4534223 2210969 2210969 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4539779 2212703 2212703 defendant Bereworth John   762289 762289 Bereworth, John, of Idenne, wheel wright 0
4546315 2214783 2214783 defendant Salerne John   762289 762289 Salerne, John, of Idenne 0
4564197 2220375 2220375 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4564199 2220376 2220376 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4596673 2230197 2230197 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4596675 2230198 2230198 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4596677 2230199 2230199 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4596679 2230200 2230200 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4596681 2230201 2230201 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4596684 2230202 2230202 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4628103 2239717 2239717 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4628105 2239718 2239718 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4628108 2239719 2239719 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4628110 2239720 2239720 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4628112 2239721 2239721 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4628114 2239722 2239722 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4628117 2239723 2239723 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4628119 2239724 2239724 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4647189 2245231 2245231 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4647191 2245232 2245232 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4647193 2245233 2245233 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4647195 2245234 2245234 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4647200 2245235 2245235 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4647202 2245236 2245236 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4647204 2245237 2245237 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4647206 2245238 2245238 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
4685606 2261091 2261091 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4711514 2268931 2268931 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4711520 2268932 2268932 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4711524 2268933 2268933 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4711529 2268934 2268934 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4750954 2280763 2280763 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4750958 2280764 2280764 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4750963 2280765 2280765 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4750967 2280766 2280766 plaintiff Salerne John (legal representative) 762289 762289 Salerne, John, of Idenne, executors of 0
4750968 2280766 2280766 plaintiff Salerne Margery   762289 762289 (Salerne, Margery, of Idenne, formerly wife of Testator 1
4821694 2302860 2302860 plaintiff Salerne Margery   762289 762289 Salerne, Margery, of Idenne, formerly wife of John Salerne 0
4933117 2336750 2336750 defendant Crouche Thomas husbandman 762289 762289 Crouche, Thomas, of Idenne, husbandman 0
5630361 2553503 2553503 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630363 2553504 2553504 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630367 2553505 2553505 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630369 2553506 2553506 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630373 2553507 2553507 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630375 2553508 2553508 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630377 2553509 2553509 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630381 2553510 2553510 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630383 2553511 2553511 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630385 2553512 2553512 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630387 2553513 2553513 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630389 2553514 2553514 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630391 2553515 2553515 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630394 2553516 2553516 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630396 2553517 2553517 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630399 2553518 2553518 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 0
5630403 2553519 2553519 plaintiff Salerne John   762289 762289 Salerne, John, of Idenne 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);