names

23 rows where place_id = 754005

✎ 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
3930208 2000451 2000451 defendant Collyngham Richard   754005 754005 Collyngham, Richard, of Edenstowe, yeoman, Notts, 0
4417365 2170312 2170312 plaintiff Savage Elizabeth   754005 754005 Savage, Elizabeth, of Edenstowe 0
4417367 2170313 2170313 plaintiff Savage Elizabeth   754005 754005 Savage, Elizabeth, of Edenstowe 0
4417369 2170314 2170314 plaintiff Savage Elizabeth   754005 754005 Savage, Elizabeth, of Edenstowe 0
4425252 2172726 2172726 defendant Prodhome William   754005 754005 Prodhome, William, of Edenstowe 6
4427555 2173451 2173451 plaintiff Savage Elizabeth   754005 754005 Savage, Elizabeth, of Edenstowe 0
4517833 2205964 2205964 defendant Walsh John forester 754005 754005 Walsh, John, of Edenstowe, forester 0
4535583 2211406 2211406 plaintiff Smyth John   754005 754005 Smyth, John, of Edenstowe 0
4597878 2230593 2230593 plaintiff Smyth John   754005 754005 Smyth, John, of Edenstowe 0
4608324 2233715 2233715 plaintiff Boteler Geoffrey forester 754005 754005 Boteler, Geoffrey, of Edenstowe, forester 0
4678013 2258738 2258738 defendant Gammull John milner 754005 754005 Gammull, John, of Edenstowe, milner 1
4690161 2262478 2262478 defendant Fyssher John laborer 754005 754005 Fyssher, John, of Edenstowe, laborer 0
4748327 2280016 2280016 defendant Sylversyde John husbandman 754005 754005 Sylversyde, John, of Edenstowe, husbandman 4
4749134 2280229 2280229 defendant Mattelay Richard yeoman 754005 754005 Mattelay, Richard, of Edenstowe, yeoman 3
4834926 2306926 2306926 defendant Huddedeyne John yeoman 754005 754005 Huddedeyne, John, of Edenstowe, yeoman 0
4914995 2331195 2331195 defendant Marschall Richard husbandman 754005 754005 Marschall, Richard, of Edenstowe, husbandman 0
4914998 2331195 2331195 defendant Normanton William husbandman 754005 754005 Normanton, William, of Edenstowe, husbandman 3
4937341 2338045 2338045 defendant Grefson or Greyffon Robert husbandman 754005 754005 Grefson or Greyffon, Robert, of Edenstowe, husbandman 0
5014853 2361222 2361222 defendant Sheffeld Thomas gent 754005 754005 Sheffeld, Thomas, of Edenstowe, gent 0
5063497 2375606 2375606 defendant Batman Roger husbandman 754005 754005 Batman, Roger, of Edenstowe, husbandman 3
5070692 2377730 2377730 defendant Reynold John miller 754005 754005 Reynold, John, of Edenstowe, miller 1
5323948 2452246 2452246 defendant Frances John tailor 754005 754005 Frances, John, of Edenstowe, Notts, tailor 1
5331332 2454445 2454445 defendant Hall John husbandman 754005 754005 Hall, John, of Edenstowe, husbandman 4

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);