names

26 rows where place_id = 602502

✎ 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
3638975 1907012 1907012 defendant (not given) John vicar of Kelom 602502 602502 Kelom, John, of Prytwell, clerk, vicar of Soppelond 0
3638977 1907013 1907013 defendant (not given) John vicar of Kelom 602502 602502 Kelom, John, of Prytwell, vicar of Soppelond 0
3650445 1910507 1910507 defendant Dawe John husbandman 602502 602502 Dawe, John, of Prytwell, husbandman 3
3650446 1910507 1910507 defendant Harrys Henry husbandman 602502 602502 Harrys, Henry, of Prytwell, husbandman 4
3663060 1914358 1914358 plaintiff (not given) Thomas prior of Norwiche 602502 602502 Norwiche, Thomas, of Prytwell, prior of the House or Priory 0
3669055 1916252 1916252 defendant Lorkyn Thomas shoemaker 602502 602502 Lorkyn, Thomas, of Prytwell, shoemaker 0
3673970 1917898 1917898 plaintiff Fuller William yeoman 602502 602502 Fuller, William, of Prytwell, yeoman 0
3674219 1917976 1917976 defendant Lambe Thomas tailor 602502 602502 Lambe, Thomas, of Prytwell, tailor 0
3790761 1954937 1954937 defendant Byglyn Robert brewer 602502 602502 Byglyn, Robert, of Prytwell, brewer 0
3905623 1992152 1992152 plaintiff Large Richard yeoman 602502 602502 Large, Richard, of Prytwell, yeoman 0
5292958 2442932 2442932 defendant Jerm- Richard clerk 602502 602502 Jerm-, Richard, of Prytwell, clerk 2
5314260 2449282 2449282 defendant Fry John butcher 602502 602502 Fry, John, of Prytwell, butcher 1
5390853 2472449 2472449 defendant Parker John shoemaker 602502 602502 Parker, John, of Prytwell, shoemaker 0
5404553 2476375 2476375 defendant Shodwell Richard gent 602502 602502 Shodwell, Richard, of Prytwell, gent 1
5421570 2481388 2481388 defendant Wodde Thomas yeoman 602502 602502 Wodde, Thomas, of Prytwell, yeoman 0
5422814 2481776 2481776 defendant Wedde Thomas yeoman 602502 602502 Wedde, Thomas, of Prytwell, yeoman 0
5423227 2481910 2481910 defendant Wedde Thomas yeoman 602502 602502 Wedde, Thomas, of Prytwell, yeoman 0
5434825 2485352 2485352 defendant Mathewe John baker 602502 602502 Mathewe, John, of Prytwell, baker 0
5435135 2485438 2485438 defendant Shedwell Richard gent 602502 602502 Shedwell, Richard, of Prytwell, gent 0
5445894 2488662 2488662 plaintiff Frye John   602502 602502 Frye, John, of Prytwell 0
5476346 2497930 2497930 defendant Chapman John purser 602502 602502 Chapman, John, of Prytwell, purser 0
5485378 2500540 2500540 defendant Shodwell Richard gent 602502 602502 Shodwell, Richard, of Prytwell, gent 2
5499340 2504744 2504744 defendant Allewyn Thomas husbandman 602502 602502 Allewyn, Thomas, of Prytwell, husbandman 2
5600833 2535149 2535149 defendant Rede Henry yeoman 602502 602502 Rede, Henry, of Prytwell, yeoman 0
5600834 2535149 2535149 defendant Rede Richard husbandman 602502 602502 Rede, Richard, of Prytwell, husbandman 1
5628295 2552810 2552810 defendant Machayt Simon butcher 602502 602502 Machayt, Simon, of Prytwell, butcher 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);