names

42 rows where place_id = 753421

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4413181 2168993 2168993 defendant atte Wode Isabel   753421 753421 atte Wode, Isabel, of Sharnebrok, formerly wife of Nigel 0
4413186 2168994 2168994 defendant atte Wode Isabel   753421 753421 atte Wode, Isabel, of Sharnebrok, formerly wife of Nigel 0
4413357 2169053 2169053 defendant atte Wattre Hugh   753421 753421 atte Wattre, Hugh, of Sharnebrok 0
4586310 2227133 2227133 defendant Walton Richard   753421 753421 Walton, Richard, of Sharnebrok 0
4597904 2230602 2230602 plaintiff Smyth John   753421 753421 Smyth, John, of Sharnebrok 0
4597905 2230602 2230602 defendant Basse Simon   753421 753421 Basse, Simon, of Sharnebrok 0
4597906 2230602 2230602 defendant Basse John   753421 753421 Basse, John, of Sharnebrok 1
4640351 2243293 2243293 defendant Walton Richard   753421 753421 Walton, Richard, of Sharnebrok 2
4641162 2243506 2243506 defendant Basse John   753421 753421 Basse, John, of Sharnebrok 0
4645079 2244631 2244631 defendant Barbour Simon   753421 753421 Barbour, Simon, of Sharnebrok 0
4647544 2245341 2245341 defendant Carmykan William laborer 753421 753421 Carmykan, William, of Sharnebrok, laborer 0
4649223 2245824 2245824 defendant Basse John   753421 753421 Basse, John, of Sharnebrok 6
4685792 2261146 2261146 defendant Basse Simon husbandman 753421 753421 Basse, Simon, of Sharnebrok, husbandman 0
4685793 2261146 2261146 defendant Basse John husbandman 753421 753421 Basse, John, of Sharnebrok, husbandman 1
4685795 2261147 2261147 defendant Basse Simon husbandman 753421 753421 Basse, Simon, of Sharnebrok, husbandman 0
4719173 2271344 2271344 defendant Braklee John husbandman 753421 753421 Braklee, John, of Sharnebrok, husbandman 1
4720501 2271750 2271750 defendant Spaldewyk John   753421 753421 Spaldewyk, John, of Sharnebrok, vicar & clerk 0
4722801 2272445 2272445 defendant Smyth John butcher 753421 753421 Smyth, John, of Sharnebrok, butcher 1
4724711 2273026 2273026 defendant Ware John husbandman 753421 753421 Ware, John, of Sharnebrok, husbandman 0
4724713 2273026 2273026 defendant Taillour William husbandman 753421 753421 Taillour, William, of Sharnebrok, husbandman 2
4728835 2274257 2274257 defendant Spaldewyk John   753421 753421 Spaldewyk, John, of Sharnebrok, vicar 0
4728836 2274257 2274257 defendant Basse John husbandman 753421 753421 Basse, John, of Sharnebrok, husbandman 1
4790315 2293054 2293054 defendant Smyth John butcher 753421 753421 Smyth, John, of Sharnebrok, butcher 4
4791754 2293519 2293519 defendant Smyth John butcher 753421 753421 Smyth, John, of Sharnebrok, butcher 0
4798376 2295679 2295679 defendant Smyth John butcher 753421 753421 Smyth, John, of Sharnebrok, butcher 0
4856255 2313328 2313328 defendant Stalworth John smith 753421 753421 Stalworth, John, of Sharnebrok, smith 0
4876536 2319627 2319627 plaintiff Smyth John   753421 753421 Smyth, John, of Sharnebrok 0
4876539 2319627 2319627 defendant Barbour Simon husbandman 753421 753421 Barbour, Simon, of Sharnebrok, husbandman 2
4876540 2319627 2319627 defendant Valet Simon husbandman 753421 753421 Valet, Simon, of Sharnebrok, husbandman 3
4876542 2319627 2319627 defendant Testard John husbandman 753421 753421 Testard, John, of Sharnebrok, husbandman 5
4885410 2322322 2322322 defendant Smyth Thomas smith 753421 753421 Smyth, Thomas, of Sharnebrok, smith 1
4885411 2322322 2322322 defendant Heywode John gent 753421 753421 Heywode, John, of Sharnebrok, gent 2
4885412 2322322 2322322 defendant Wodham William husbandman 753421 753421 Wodham, William, of Sharnebrok, husbandman 3
4885413 2322322 2322322 defendant Smyth John smith 753421 753421 Smyth, John, of Sharnebrok, smith 4
4892920 2324516 2324516 defendant Warde John husbandman 753421 753421 Warde, John, of Sharnebrok, husbandman 0
4892921 2324517 2324517 plaintiff Stalworth Thomas smith 753421 753421 Stalworth, Thomas, of Sharnebrok, smith 0
4942024 2339488 2339488 defendant Savage William husbandman 753421 753421 Savage, William, of Sharnebrok, husbandman 0
4942025 2339488 2339488 defendant Kirkeby Richard laborer 753421 753421 Kirkeby, Richard, of Sharnebrok, laborer 1
4942026 2339488 2339488 defendant Styward William butcher 753421 753421 Styward, William, of Sharnebrok, butcher 2
4963784 2346080 2346080 defendant Ware John (legal representative) 753421 753421 Ware, John, of Sharnebrok, executors of 0
4994379 2355194 2355194 defendant Styward William butcher 753421 753421 Styward, William, of Sharnebrok, butcher 0
5250103 2430139 2430139 defendant Havoron William husbandman 753421 753421 Havoron, William, of Sharnebrok, husbandman 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);