names

31 rows where place_id = 619284

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3729074 1935344 1935344 defendant Musgrave alias Wever Thomas husbandman 619284 619284 Musgrave alias Wever, Thomas, of Barnewell, Nhants, husbandman 2
3729079 1935345 1935345 defendant Musgrave alias Wever Thomas husbandman 619284 619284 Musgrave alias Wever, Thomas, of Barnewell, Nhants, husbandman 2
3822027 1964783 1964783 defendant Criston Thomas husbandman 619284 619284 Criston, Thomas, of Barnewell, Nhants, husbandman 0
3867912 1979500 1979500 defendant Clyfton Thomas husbandman 619284 619284 Clyfton, Thomas, of Barnewell, Nhants, husbandman 0
3867914 1979501 1979501 defendant Clyfton Thomas husbandman 619284 619284 Clyfton, Thomas, of Barnewell, Nhants, husbandman 0
4073859 2050942 2050942 plaintiff Presgrave William yeoman 619284 619284 Presgrave, William, of Barnewell, Nhants, yeoman 0
4106466 2062603 2062603 defendant Gage John smith 619284 619284 Gage, John, of Barnewell, Nhants, smith 1
4126325 2069705 2069705 defendant Clement John yeoman 619284 619284 Clement, John, of Barnewell, Nhants, yeoman 0
4170727 2085254 2085254 defendant Clement William yeoman 619284 619284 Clement, William, of Barnewell, Nhants, yeoman 1
4226580 2104773 2104773 defendant Pell Alexander gent 619284 619284 Pell, Alexander, of Barnewell, Nhants, gent 0
4235927 2108140 2108140 defendant Clement John yeoman 619284 619284 Clement, John, of Barnewell, Nhants, yeoman 1
4236347 2108286 2108286 defendant Clement William yeoman 619284 619284 Clement, William, of Barnewell, Nhants, yeoman 1
4242112 2110356 2110356 defendant Clement or Clemens William yeoman 619284 619284 Clement or Clemens, William, of Barnewell, Nhants, yeoman 0
4244919 2111286 2111286 defendant Clement William yeoman 619284 619284 Clement, William, of Barnewell, Nhants, yeoman 1
4251804 2113594 2113594 defendant Clement or Clemens William yeoman 619284 619284 Clement or Clemens, William, of Barnewell, Nhants, yeoman 0
4254127 2114377 2114377 defendant Pell Alexander gent 619284 619284 Pell, Alexander, of Barnewell, Nhants, gent 0
4298875 2129692 2129692 defendant Clement John yeoman 619284 619284 Clement, John, of Barnewell, Nhants, yeoman 1
4304265 2131628 2131628 defendant Clement John yeoman 619284 619284 Clement, John, of Barnewell, Nhants, yeoman 0
4309704 2133550 2133550 defendant Clement John yeoman 619284 619284 Clement, John, of Barnewell, Nhants, yeoman 0
4319771 2137026 2137026 defendant Clement John yeoman 619284 619284 Clement, John, of Barnewell, Nhants, yeoman 2
4914495 2331054 2331054 defendant Feldyng Reginald yeoman 619284 619284 Feldyng, Reginald, of Barnewell, Nhants, yeoman 2
5093810 2384590 2384590 defendant Smyth Nicholas smith 619284 619284 Smyth, Nicholas, of Barnewell, Nhants, smith 1
5119825 2392234 2392234 defendant Smyth Nicholas smith 619284 619284 Smyth, Nicholas, of Barnewell, Nhants, smith 1
5314125 2449240 2449240 defendant Thorpe Roger gent 619284 619284 Thorpe, Roger, of Barnewell, Nhants, gent 2
5389596 2472086 2472086 defendant Haldenby Thomas gent 619284 619284 Haldenby, Thomas, of Barnewell, Nhants, gent 0
5393225 2473115 2473115 defendant Lawe Thomas clerk 619284 619284 Lawe, Thomas, of Barnewell, Nhants, clerk 0
5399807 2475040 2475040 defendant Lawe Thomas clerk 619284 619284 Lawe, Thomas, of Barnewell, Nhants, clerk 0
5419452 2480736 2480736 defendant Lawe Thomas clerk 619284 619284 Lawe, Thomas, of Barnewell, Nhants, clerk 0
5470291 2496033 2496033 defendant Haldenby Thomas gent 619284 619284 Haldenby, Thomas, of Barnewell, Nhants, gent 0
5483305 2499954 2499954 defendant Thorp Roger gent 619284 619284 Thorp, Roger, of Barnewell, Nhants, gent 0
5483866 2500118 2500118 defendant Wryght Richard husbandman 619284 619284 Wryght, Richard, of Barnewell, Nhants, husbandman 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);