names

25 rows where place_id = 586020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587709 1863802 1863802 defendant Grevell or Grenell John yeoman 586020 586020 Grevell or Grenell, John, of Berkewey, Herts, yeoman 0
3590372 1864628 1864628 defendant Jenyn Thomas butcher 586020 586020 Jenyn, Thomas, of Berkewey, Herts, butcher 0
3592984 1865431 1865431 defendant Jenny Thomas butcher 586020 586020 Jenny, Thomas, of Berkewey, Herts, butcher 0
3604388 1869039 1869039 defendant Skynner John chapman 586020 586020 Skynner, John, of Berkewey, Herts, chapman 0
3604393 1869040 1869040 defendant Skynner John chapman 586020 586020 Skynner, John, of Berkewey, Herts, chapman 0
3604398 1869041 1869041 defendant Gevell or Grenell John husbandman 586020 586020 Gevell or Grenell, John, of Berkewey, herts, husbandman 0
3604400 1869042 1869042 defendant Grevell or Grebnell John husbandman 586020 586020 Grevell or Grebnell, John, of Berkewey, Herts, husbandman 0
3607936 1870130 1870130 defendant Skynner John chapman 586020 586020 Skynner, John, of Berkewey, Herts, chapman 1
3711238 1929818 1929818 defendant Womwell Richard yeoman 586020 586020 Womwell, Richard, of Berkewey, Herts, yeoman 4
3875330 1981994 1981994 defendant Sterne William gent 586020 586020 Sterne, William, of Berkewey, Herts, gent 0
3931103 2000712 2000712 defendant Gery John yeoman 586020 586020 Gery, John, of Berkewey, Herts, yeoman 1
4658716 2248601 2248601 defendant Reve William hosteler 586020 586020 Reve, William, of Berkewey, Herts, hosteler 1
4658721 2248602 2248602 defendant Reve William hosteler 586020 586020 Reve, William, of Berkewey, Herts, hosteler 1
4698277 2264943 2264943 defendant Rogger John butcher 586020 586020 Rogger, John, of Berkewey, Herts, butcher 2
4843358 2309437 2309437 defendant Reve William (legal representative) 586020 586020 Reve, William, of Berkewey, Herts, executor of 0
4843359 2309437 2309437 defendant Reve William yeoman 586020 586020 Reve, William, of Berkewey, Herts, yeoman 1
4843364 2309438 2309438 defendant Rene or Reve William yeoman 586020 586020 Rene or Reve, William, of Berkewey, Herts, yeoman 1
4844888 2309921 2309921 defendant Bateman John hosteller 586020 586020 Bateman, John, of Berkewey, Herts, hosteller 3
4973323 2348959 2348959 defendant Cook John yeoman 586020 586020 Cook, John, of Berkewey, Herts, yeoman 0
4973327 2348960 2348960 defendant Cook Stephen husbandman 586020 586020 Cook, Stephen, of Berkewey, Herts, husbandman 0
5014797 2361201 2361201 defendant Baker John yeoman 586020 586020 Baker, John, of Berkewey, Herts, yeoman 3
5409947 2477946 2477946 defendant Wombewell Katherine widow 586020 586020 Wombewell, Katherine, of Berkewey, Herts, widow 1
5423637 2482034 2482034 defendant Wombewell Katherine widow 586020 586020 Wombewell, Katherine, of Berkewey, Herts, widow 1
5561198 2523254 2523254 defendant Grevell or Grenell John husbandman 586020 586020 Grevell or Grenell, John, of Berkewey, herts, husbandman 0
5566083 2524679 2524679 defendant Loryng Henry innholder 586020 586020 Loryng, Henry, of Berkewey, Herts, innholder 1

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