names

45 rows where place_id = 617141

✎ 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
3717996 1931924 1931924 defendant Long Thomas husbandman 617141 617141 Long, Thomas, of Speldherst, husbandman 1
3853711 1974791 1974791 defendant Stone Thomas miller 617141 617141 Stone, Thomas, of Speldherst, miller 0
3853712 1974791 1974791 defendant Stace John, junior husbandman 617141 617141 Stace, John, junior, of Speldherst, husbandman 1
4313970 2134992 2134992 defendant Sumner Nicholas yeoman 617141 617141 Sumner, Nicholas, of Speldherst, yeoman 0
4317854 2136356 2136356 defendant Gyles Francis carpenter 617141 617141 Gyles, Francis, of Speldherst, carpenter 0
4406973 2166892 2166892 defendant Jennett Elizabeth widow 617141 617141 Jennett, Elizabeth, of Speldherst, widow 2
4785007 2291324 2291324 plaintiff Adam William   617141 617141 Adam, William, of Speldherst 1
4808878 2298944 2298944 defendant Grene John thatcher 617141 617141 Grene, John, of Speldherst, thatcher 0
4822695 2303176 2303176 plaintiff Smyth William   617141 617141 Smyth, William, of Speldherst 0
4922010 2333294 2333294 defendant Crudde John husbandman 617141 617141 Crudde, John, of Speldherst, husbandman 1
5399214 2474845 2474845 defendant Waller John, junior gent 617141 617141 Waller, John, junior, of Speldherst, gent 0
5399216 2474846 2474846 defendant Waller John, junior gent 617141 617141 Waller, John, junior, of Speldherst, gent 0
5416774 2479932 2479932 defendant E_ William laborer 617141 617141 E_, William, of Speldherst, laborer 0
5416775 2479932 2479932 defendant Coyf William   617141 617141 Coyf, William, of Speldherst 1
5416776 2479932 2479932 defendant Gru Richard thatcher 617141 617141 Gru, Richard, of Speldherst, thatcher 2
5416777 2479932 2479932 defendant Crudde John laborer 617141 617141 Crudde, John, of Speldherst, laborer 3
5416778 2479932 2479932 defendant Coyf John laborer 617141 617141 Coyf, John, of Speldherst, laborer 4
5416779 2479932 2479932 defendant Coppyng John laborer 617141 617141 Coppyng, John, of Speldherst, laborer 5
5433703 2485043 2485043 defendant Bregger William laborer 617141 617141 Bregger, William, of Speldherst, laborer 0
5433704 2485043 2485043 defendant Coyf William husbandman 617141 617141 Coyf, William, of Speldherst, husbandman 1
5433705 2485043 2485043 defendant Grumbregge Richard thatcher 617141 617141 Grumbregge, Richard, of Speldherst, thatcher 2
5433706 2485043 2485043 defendant Grudde John laborer 617141 617141 Grudde, John, of Speldherst, laborer 3
5433707 2485043 2485043 defendant Coyf John laborer 617141 617141 Coyf, John, of Speldherst, laborer 4
5433711 2485044 2485044 defendant Bregger William laborer 617141 617141 Bregger, William, of Speldherst, laborer 0
5449355 2489698 2489698 defendant Coyff William husbandman 617141 617141 Coyff, William, of Speldherst, husbandman 1
5449414 2489712 2489712 defendant Bregger William laborer 617141 617141 Bregger, William, of Speldherst, laborer 0
5449415 2489712 2489712 defendant Coyff William husbandman 617141 617141 Coyff, William, of Speldherst, husbandman 1
5449416 2489712 2489712 defendant Grumbregge Richard thatcher 617141 617141 Grumbregge, Richard, of Speldherst, thatcher 2
5449417 2489712 2489712 defendant Crudd John laborer 617141 617141 Crudd, John, of Speldherst, laborer 3
5449418 2489712 2489712 defendant Coyff John laborer 617141 617141 Coyff, John, of Speldherst, laborer, Coppyng, John, of Sheldherst, laborer 4
5456471 2491858 2491858 defendant Holbeme John yeoman 617141 617141 Holbeme, John, of Speldherst, yeoman 1
5461498 2493390 2493390 defendant Bregger William laborer 617141 617141 Bregger, William, of Speldherst, laborer 0
5461499 2493390 2493390 defendant Coyff William husbandman 617141 617141 Coyff, William, of Speldherst, husbandman 1
5461500 2493390 2493390 defendant Grumbregge Richard thatcher 617141 617141 Grumbregge, Richard, of Speldherst, thatcher 2
5461501 2493390 2493390 defendant Crudde John laborer 617141 617141 Crudde, John, of Speldherst, laborer 3
5461502 2493390 2493390 defendant Coyff John laborer 617141 617141 Coyff, John, of Speldherst, laborer, Coppyng, John, of Sheldherst, laborer 4
5468289 2495457 2495457 defendant Holbeme John yeoman 617141 617141 Holbeme, John, of Speldherst, yeoman 1
5473123 2496917 2496917 defendant Coyff William husbandman 617141 617141 Coyff, William, of Speldherst, husbandman 1
5473125 2496917 2496917 defendant Crudde John laborer 617141 617141 Crudde, John, of Speldherst, laborer 3
5473126 2496917 2496917 defendant (illegible) John laborer 617141 617141 _, John, of Speldherst, laborer 4
5473127 2496917 2496917 defendant Toppyng John laborer 617141 617141 Toppyng, John, of Speldherst, laborer 5
5493920 2503088 2503088 defendant Waller John, junior gent 617141 617141 together with Waller, John, junior, of Speldherst, gent 1
5493923 2503089 2503089 defendant Waller John, junior gent 617141 617141 Waller, John, junior, of Speldherst, gent 0
5493927 2503090 2503090 defendant Waller John, junior husbandman 617141 617141 Waller, John, junior, of Speldherst, husbandman 0
5507959 2507385 2507385 defendant Waller John, junior gent 617141 617141 Waller, John, junior, of Speldherst, gent 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);