names

25 rows where place_id = 607339

✎ 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
3652891 1911230 1911230 plaintiff Wente Geoffrey   607339 607339 Wente, Geoffrey, of Wodbregge, twill weaver 0
3668801 1916180 1916180 plaintiff Bale William, junior   607339 607339 Bale, William, junior, of Wodbregge 0
3670496 1916734 1916734 defendant Burtur William butcher 607339 607339 Burtur, William, of Wodbregge, butcher 0
3670941 1916880 1916880 plaintiff Cantell Robert   607339 607339 Cantell, Robert, of Wodbregge 0
3683482 1920962 1920962 defendant Smyth William, junior merchant 607339 607339 Smyth, William, junior, of Wodbregge, merchant 0
3683484 1920963 1920963 defendant Smyth William, junior merchant 607339 607339 Smyth, William, junior, of Wodbregge, merchant 0
3710708 1929669 1929669 plaintiff Smyth William merchant 607339 607339 Smyth, William, of Wodbregge, merchant 0
3842818 1971287 1971287 defendant Waren Robert husbandman 607339 607339 Waren, Robert, of Wodbregge, husbandman 1
3861860 1977425 1977425 defendant Morgan Robert yeoman 607339 607339 Morgan, Robert, of Wodbregge, yeoman 2
3866361 1978983 1978983 defendant Hollond Edward beer brewer 607339 607339 Hollond, Edward, of Wodbregge, beer brewer 0
3900580 1990426 1990426 plaintiff Cantell Robert (legal representative) 607339 607339 Cantell, Robert, of Wodbregge, executors of 0
3900583 1990426 1990426 defendant Wareyn Robert husbandman 607339 607339 Wareyn, Robert, of Wodbregge, husbandman 0
5062006 2375191 2375191 defendant Prentyse John yeoman 607339 607339 Prentyse, John, of Wodbregge, yeoman 1
5068259 2377011 2377011 defendant Benet Roger glover 607339 607339 Benet, Roger, of Wodbregge, glover 0
5089819 2383397 2383397 defendant Dooll John   607339 607339 Dooll, John, of Wodbregge, tallow chandler 1
5254313 2431477 2431477 defendant Brame or Braine Thomas dyer 607339 607339 Brame or Braine, Thomas, of Wodbregge, dyer 0
5390381 2472312 2472312 defendant Nicholas James beer brewer 607339 607339 Nicholas, James, of Wodbregge, beer brewer 0
5390382 2472312 2472312 defendant Lunt Robert   607339 607339 Lunt, Robert, of Wodbregge 1
5461054 2493255 2493255 defendant Nicholas James beer brewer 607339 607339 Nicholas, James, of Wodbregge, beer brewer 0
5472637 2496782 2496782 defendant Nicholas James beer brewer 607339 607339 Nicholas, James, of Wodbregge, beer brewer 0
5548645 2519646 2519646 defendant Russell John turner 607339 607339 Russell, John, of Wodbregge, turner 0
5549489 2519904 2519904 defendant Bulle John yeoman 607339 607339 Bulle, John, of Wodbregge, yeoman 6
5549497 2519905 2519905 defendant Bulle John yeoman 607339 607339 Bulle, John, of Wodbregge, yeoman 5
5570383 2525907 2525907 defendant Bele John merchant 607339 607339 Bele, John, of Wodbregge, merchant 1
5578762 2528421 2528421 defendant Goryson Henry merchant 607339 607339 Goryson, Henry, of Wodbregge, merchant 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);