names

38 rows where place_id = 593875

✎ 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
3613705 1871935 1871935 plaintiff Bekke Clement   593875 593875 Bekke, Clement, of Sustede 0
3613707 1871936 1871936 plaintiff Bekke Clement   593875 593875 Bekke, Clement, of Sustede 0
3782842 1952383 1952383 defendant Becke Alice widow 593875 593875 Becke, Alice, of Sustede, widow 2
4744088 2278797 2278797 defendant Kyng John weaver 593875 593875 Kyng, John, of Sustede, weaver 0
4813387 2300302 2300302 defendant Fleg John husbandman 593875 593875 Fleg, John, of Sustede, husbandman 0
4816371 2301211 2301211 plaintiff Lyon John   593875 593875 Lyon, John, of Sustede 0
4865321 2316125 2316125 defendant Custauns Edmund husbandman 593875 593875 Custauns, Edmund, of Sustede, husbandman 3
4987249 2353135 2353135 defendant Thurkeld Richard   593875 593875 Thurkeld, Richard, of Sustede 0
4987927 2353354 2353354 defendant Thurkeld Richard chaplain 593875 593875 Thurkeld, Richard, of Sustede, chaplain 0
5003483 2357915 2357915 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5027321 2364867 2364867 plaintiff Man Nicholas (legal representative) 593875 593875 Man, Nicholas, of Sustede, clerk, executors of 0
5027322 2364867 2364867 plaintiff Damme John, junior   593875 593875 (Damme, John, junior, of Sustede 1
5030049 2365657 2365657 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5060561 2374739 2374739 defendant Imped alias Fuller John husbandman 593875 593875 Imped alias Fuller, John, of Sustede, husbandman 0
5067933 2376906 2376906 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5075034 2379034 2379034 defendant Damme John gent 593875 593875 Damme, John, of Sustede, gent 0
5092533 2384195 2384195 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5092539 2384196 2384196 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5092546 2384197 2384197 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5092554 2384198 2384198 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5116777 2391339 2391339 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5116788 2391340 2391340 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5116794 2391341 2391341 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5136906 2397312 2397312 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5157479 2403320 2403320 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5157485 2403321 2403321 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5173379 2407920 2407920 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5193354 2413784 2413784 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5193360 2413785 2413785 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5208159 2418117 2418117 plaintiff Damme John   593875 593875 Damme, John, of Sustede 3
5208165 2418118 2418118 plaintiff Damme John   593875 593875 Damme, John, of Sustede 4
5214372 2419936 2419936 defendant Damme Simon gent 593875 593875 Damme, Simon, of Sustede, gent 0
5214373 2419936 2419936 defendant Leryngsete John clerk 593875 593875 Leryngsete, John, of Sustede, clerk 1
5333371 2455056 2455056 plaintiff Damme John (legal representative) 593875 593875 Damme, John, of Sustede, executor of Yerdeley, Hugh, of Billyngford, yeoman, executors of 0
5359235 2462927 2462927 defendant Laurence Robert, junior   593875 593875 Laurence, Robert, junior, of Sustede, mason 1
5359236 2462927 2462927 defendant Catte John barker 593875 593875 Catte, John, of Sustede, barker 2
5380840 2469575 2469575 plaintiff Damme Robert   593875 593875 Damme, Robert, of Sustede, parson 0
5435082 2485424 2485424 defendant Catte John tanner 593875 593875 Catte, John, of Sustede, tanner 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);