names

20 rows where place_id = 598049

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630897 1904484 1904484 defendant Turnour Humphrey yeoman 598049 598049 Turnour, Humphrey, of Odyam, Hants, yeoman 1
3645699 1909058 1909058 defendant Wellys James tanner 598049 598049 Wellys, James, of Odyam, Hants, tanner 3
3645704 1909059 1909059 defendant Wellys James tanner 598049 598049 Wellys, James, of Odyam, Hants, tanner 3
3672288 1917332 1917332 defendant Crosswell John clothier 598049 598049 Crosswell, John, of Odyam, Hants, clothier 0
3676648 1918734 1918734 defendant Chalcrosse John husbandman 598049 598049 Chalcrosse, John, of Odyam, Hants, husbandman 2
3712653 1930272 1930272 defendant Creswell Thomas (legal representative) 598049 598049 Creswell, Thomas, of Odyam, Hants, yeoman, executor of 0
3763337 1946163 1946163 defendant Wellys James tanner 598049 598049 Wellys, James, of Odyam, Hants, tanner 0
3763344 1946165 1946165 defendant Wellys James tanner 598049 598049 Wellys, James, of Odyam, Hants, tanner 1
3842500 1971188 1971188 defendant Chalscrofte John innholder 598049 598049 Chalscrofte, John, of Odyam, Hants, innholder 0
3842506 1971189 1971189 defendant Chalscrofte John innholder 598049 598049 Chalscrofte, John, of Odyam, Hants, innholder 0
3980253 2017703 2017703 defendant Vans or Vaus Nicholas (legal representative) 598049 598049 Vans or Vaus, Nicholas, of Odyam, Hants, esq, executrix of 0
4052476 2043306 2043306 defendant Berewe George gent 598049 598049 Berewe, George, of Odyam, Hants, gent 1
4052479 2043307 2043307 defendant Berowe George gent 598049 598049 Berowe, George, of Odyam, Hants, gent 1
4359732 2150640 2150640 defendant Osborne John yeoman 598049 598049 Osborne, John, of Odyam, Hants, yeoman 0
4877823 2320026 2320026 defendant Middelton Henry husbandman 598049 598049 Middelton, Henry, of Odyam, Hants, husbandman 3
5242754 2428086 2428086 defendant Hille John   598049 598049 Hille, John, of Odyam, Hants, get 0
5242756 2428087 2428087 defendant Hille John gent 598049 598049 Hille, John, of Odyam, Hants, gent 0
5528006 2513322 2513322 defendant Wodeman John gent 598049 598049 Wodeman, John, of Odyam, Hants, gent 1
5595074 2533427 2533427 defendant Wellys James yeoman 598049 598049 Wellys, James, of Odyam, Hants, yeoman 2
5595142 2533449 2533449 defendant Wellys James yeoman 598049 598049 Wellys, James, of Odyam, Hants, yeoman 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);