names

36 rows where place_id = 608371

✎ 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
3673429 1917710 1917710 defendant Maltywade Stephen husbandman 608371 608371 Maltywade, Stephen, of Westle, husbandman 0
4586482 2227185 2227185 defendant Snode John   608371 608371 Snode, John, of Westle 3
4617064 2236346 2236346 plaintiff Gile Henry   608371 608371 Gile, Henry, of Westle 0
4617984 2236633 2236633 plaintiff Gyle Henry   608371 608371 Gyle, Henry, of Westle 0
4787818 2292255 2292255 defendant Cok Thomas husbandman 608371 608371 Cok, Thomas, of Westle, husbandman 2
4811377 2299668 2299668 defendant Smyth Thomas yeoman 608371 608371 Smyth, Thomas, of Westle, yeoman 0
4829885 2305391 2305391 defendant Dewesby (illegible) husbandman 608371 608371 Dewesby, _, of Westle, husbandman 3
4842527 2309199 2309199 defendant Mavys Thomas carpenter 608371 608371 Mavys, Thomas, of Westle, carpenter 2
4872586 2318383 2318383 defendant Dewesby John husbandman 608371 608371 Dewesby, John, of Westle, husbandman 2
4879999 2320658 2320658 defendant Bate John husbandman 608371 608371 Bate, John, of Westle, or of Carleton juxta Brynkle, Cams, husbandman 0
4884280 2321991 2321991 defendant Ferthyng Thomas yeoman 608371 608371 Ferthyng, Thomas, of Westle, yeoman 1
4890762 2323861 2323861 plaintiff Curteys John   608371 608371 Curteys, John, of Westle 0
5013051 2360645 2360645 defendant Stanton or Stauton John husbandman 608371 608371 Stanton or Stauton, John, of Westle, husbandman 0
5018561 2362311 2362311 defendant Snode Richard (legal representative) 608371 608371 Snode, Richard, of Westle, executors of 2
5018562 2362311 2362311 defendant Wathe Robert clerk 608371 608371 (Wathe, Robert, of Westle, clerk 3
5124762 2393716 2393716 defendant Doget John husbandman 608371 608371 Doget, John, of Westle, husbandman 2
5155216 2402674 2402674 defendant Duke Robert husbandman 608371 608371 Duke, Robert, of Westle, husbandman 1
5161182 2404371 2404371 defendant Heryngeswell John laborer 608371 608371 Heryngeswell, John, of Westle, laborer 2
5164625 2405387 2405387 defendant Doget John husbandman 608371 608371 Doget, John, of Westle, husbandman 2
5174733 2408310 2408310 defendant Broun John husbandman 608371 608371 Broun, John, of Westle, husbandman 4
5177949 2409255 2409255 defendant Doget John husbandman 608371 608371 Doget, John, of Westle, husbandman 2
5212451 2419385 2419385 defendant Duke John husbandman 608371 608371 Duke, John, of Westle, husbandman 3
5220128 2421594 2421594 defendant Duke John husbandman 608371 608371 Duke, John, of Westle, husbandman 5
5220129 2421594 2421594 defendant Nobyll Nicholas husbandman 608371 608371 Nobyll, Nicholas, of Westle, husbandman 6
5250043 2430122 2430122 defendant Nobill Richard husbandman 608371 608371 Nobill, Richard, of Westle, husbandman 2
5422427 2481656 2481656 defendant Duke Robert husbandman 608371 608371 Duke, Robert, of Westle, husbandman 0
5422429 2481656 2481656 defendant Duke John husbandman 608371 608371 Duke, John, of Westle, husbandman 2
5442077 2487551 2487551 defendant D_ John husbandman 608371 608371 D_, John, of Westle, husbandman 2
5442078 2487551 2487551 defendant Byrd John, junior husbandman 608371 608371 Byrd, John, junior, of Westle, husbandman 3
5442079 2487551 2487551 defendant Staunton Richard husbandman 608371 608371 Staunton, Richard, of Westle, husbandman 4
5454814 2491361 2491361 defendant Duke Robert husbandman 608371 608371 Duke, Robert, of Westle, husbandman 0
5454816 2491361 2491361 defendant Duke John husbandman 608371 608371 Duke, John, of Westle, husbandman 2
5454821 2491362 2491362 defendant Duke Robert husbandman 608371 608371 Duke, Robert, of Westle, husbandman 0
5454823 2491362 2491362 defendant Duke John husbandman 608371 608371 Duke, John, of Westle, husbandman 2
5454828 2491363 2491363 defendant Duke Robert husbandman 608371 608371 Duke, Robert, of Westle, husbandman 0
5454830 2491363 2491363 defendant Duke John husbandman 608371 608371 Duke, John, of Westle, husbandman 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);