names

17 rows where place_id = 605724

✎ 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
3662677 1914246 1914246 defendant Grace Richard, junior butcher 605724 605724 Grace, Richard, junior, of Newport, Essex, butcher 0
3753710 1943101 1943101 plaintiff Morese Richard   605724 605724 Morese, Richard, of Newport, Essex 1
3884515 1985094 1985094 plaintiff Aldrege alias Bedull Thomas weaver 605724 605724 Aldrege alias Bedull, Thomas, of Newport, Essex, weaver 0
4898065 2326065 2326065 defendant Trumpur John, junior husbandman 605724 605724 Trumpur, John, junior, of Newport, Essex, husbandman 0
4904469 2328006 2328006 defendant Herlyng John husbandman 605724 605724 Herlyng, John, of Newport, Essex, husbandman 0
5066559 2376522 2376522 defendant Revell John yeoman 605724 605724 Revell, John, of Newport, Essex, yeoman 0
5066561 2376523 2376523 defendant Revell John yeoman 605724 605724 Revell, John, of Newport, Essex, yeoman 0
5145996 2399952 2399952 defendant Spencer John clerk 605724 605724 Spencer, John, of Newport, Essex, clerk 4
5216755 2420635 2420635 defendant Sharp John chapman 605724 605724 Sharp, John, of Newport, Essex, chapman 3
5222650 2422341 2422341 defendant Sleyworth Nicholas gent 605724 605724 Sleyworth, Nicholas, of Newport, Essex, gent 0
5235751 2426032 2426032 defendant Holte Thomas yeoman 605724 605724 Holte, Thomas, of Newport, Essex, yeoman 1
5397836 2474452 2474452 defendant Holt Thomas yeoman 605724 605724 Holt, Thomas, of Newport, Essex, yeoman 0
5397838 2474452 2474452 defendant Jerdevyle or Jerdenyle John gent 605724 605724 Jerdevyle or Jerdenyle, John, of Newport, Essex, gent 2
5407995 2477368 2477368 defendant Holt Thomas yeoman 605724 605724 Holt, Thomas, of Newport, Essex, yeoman 0
5408000 2477369 2477369 defendant Holt Thomas yeoman 605724 605724 Holt, Thomas, of Newport, Essex, yeoman 0
5408005 2477370 2477370 defendant Holt Thomas yeoman 605724 605724 Holt, Thomas, of Newport, Essex, yeoman 0
5408007 2477370 2477370 defendant Jardevyle or Jardenyle John tanner 605724 605724 Jardevyle or Jardenyle, John, of Newport, Essex, tanner 2

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