names

30 rows where place_id = 613609

✎ 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
3699324 1926005 1926005 defendant Sheringham William husbandman 613609 613609 Sheringham, William, of Ryburgh, husbandman 0
3699326 1926005 1926005 defendant Gybys or Gylys John shragger 613609 613609 Gybys or Gylys, John, of Ryburgh, shragger 2
3712753 1930304 1930304 defendant Sheryngham William   613609 613609 Sheryngham, William, of Ryburgh. Husbandman 0
3831089 1967609 1967609 plaintiff Gottys Richard   613609 613609 Gottys, Richard, of Ryburgh 0
3845210 1972063 1972063 defendant Edryche Joan widow 613609 613609 Edryche, Joan, of Ryburgh, widow 3
3846432 1972438 1972438 plaintiff Gottys Richard   613609 613609 Gottys, Richard, of Ryburgh 0
3915368 1995507 1995507 defendant Andrewes William gent 613609 613609 Andrewes, William, of Ryburgh, gent 0
4496591 2199608 2199608 defendant Trendyll Thomas   613609 613609 Trendyll, Thomas, of Ryburgh 0
4496592 2199608 2199608 defendant Trendyll John   613609 613609 Trendyll, John, of Ryburgh 1
4644221 2244406 2244406 defendant Warner Henry   613609 613609 Warner, Henry, of Ryburgh 0
4674267 2257559 2257559 defendant Teler William husbandman 613609 613609 Teler, William, of Ryburgh, husbandman 3
4687809 2261758 2261758 defendant Rye Simon in the smith 613609 613609 Rye, Simon in the, of Ryburgh, smith 4
4752034 2281086 2281086 defendant Lenot John clerk 613609 613609 Lenot, John, of Ryburgh, clerk 5
4758161 2282926 2282926 plaintiff Bulman John   613609 613609 Bulman, John, of Ryburgh 0
4779922 2289719 2289719 defendant Dokkyng Simon yeoman 613609 613609 Dokkyng, Simon, of Ryburgh, yeoman 2
4780333 2289848 2289848 plaintiff Bulman John   613609 613609 Bulman, John, of Ryburgh 0
4780335 2289849 2289849 plaintiff Bulman John   613609 613609 Bulman, John, of Ryburgh 0
4816273 2301173 2301173 defendant Rysby Richard husbandman 613609 613609 Rysby, Richard, of Ryburgh, husbandman 1
4830059 2305446 2305446 defendant Hobbes William smith 613609 613609 Hobbes, William, of Ryburgh, smith 3
4892232 2324312 2324312 defendant Clerk John yeoman 613609 613609 Clerk, John, of Ryburgh, yeoman 9
4968576 2347567 2347567 defendant Warner Joan widow 613609 613609 Warner, Joan, of Ryburgh, widow 0
4968577 2347567 2347567 defendant Warner Roger laborer 613609 613609 Warner, Roger, of Ryburgh, laborer 1
4968581 2347567 2347567 defendant Warner John laborer 613609 613609 Warner, John, of Ryburgh, laborer 5
4995269 2355432 2355432 defendant Warner Joan widow 613609 613609 Warner, Joan, of Ryburgh, widow 0
4995270 2355432 2355432 defendant Warner Roger laborer 613609 613609 Warner, Roger, of Ryburgh, laborer 1
4995274 2355432 2355432 defendant Warner John laborer 613609 613609 Warner, John, of Ryburgh, laborer 5
5043891 2369801 2369801 defendant Brook John fuller 613609 613609 Brook, John, of Ryburgh, fuller 0
5349158 2459865 2459865 defendant Geyton Thomas yeoman 613609 613609 Geyton, Thomas, of Ryburgh, yeoman 1
5377074 2468418 2468418 defendant Dowenyng William husbandman 613609 613609 Dowenyng, William, of Ryburgh, husbandman 2
5520317 2511173 2511173 defendant Andrews Thomas gent 613609 613609 Andrews, Thomas, of Ryburgh, 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);