names

58 rows where place_id = 620428

✎ 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
3735639 1937380 1937380 defendant Clopwell Thomas yeoman 620428 620428 Clopwell, Thomas, of Yaxley, Hunts, yeoman 0
3802057 1958540 1958540 defendant Waryn Thomas baker 620428 620428 Waryn, Thomas, of Yaxley, Hunts, baker 1
3887442 1986064 1986064 defendant Cony William yeoman 620428 620428 Cony, William, of Yaxley, Hunts, yeoman 0
3911358 1994117 1994117 defendant Haughton John yeoman 620428 620428 Haughton, John, of Yaxley, Hunts, yeoman 0
3922688 1997904 1997904 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922695 1997905 1997905 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922702 1997906 1997906 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922705 1997907 1997907 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922709 1997908 1997908 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922714 1997909 1997909 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922719 1997910 1997910 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922724 1997911 1997911 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922727 1997912 1997912 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922730 1997913 1997913 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922733 1997914 1997914 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922736 1997915 1997915 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922739 1997916 1997916 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922742 1997917 1997917 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922745 1997918 1997918 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922748 1997919 1997919 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922751 1997920 1997920 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922754 1997921 1997921 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922757 1997922 1997922 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922760 1997923 1997923 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3922766 1997924 1997924 plaintiff Sand John (legal representative) 620428 620428 Sand, John, of Yaxley, Hunts, gent, executor of 0
3928434 1999848 1999848 defendant Davyes Nicholas chapman 620428 620428 Davyes, Nicholas, of Yaxley, Hunts, chapman 0
3930316 2000486 2000486 plaintiff Cony William   620428 620428 Cony, William, of Yaxley, Hunts 0
3930320 2000487 2000487 plaintiff Cony William   620428 620428 Cony, William, of Yaxley, Hunts 0
3930322 2000488 2000488 plaintiff Cony William   620428 620428 Cony, William, of Yaxley, Hunts 0
3947757 2006280 2006280 plaintiff Cony William   620428 620428 Cony, William, of Yaxley, Hunts 0
3947759 2006281 2006281 plaintiff Cony William   620428 620428 Cony, William, of Yaxley, Hunts 0
3947763 2006282 2006282 plaintiff Cony William   620428 620428 Cony, William, of Yaxley, Hunts 0
3947765 2006283 2006283 plaintiff Cony William (legal representative) 620428 620428 Cony, William, of Yaxley, Hunts, executor of 0
3947768 2006284 2006284 plaintiff Cony William gent 620428 620428 Cony, William, of Yaxley, Hunts, gent 0
3993111 2022285 2022285 plaintiff Carier Richard yeoman 620428 620428 Carier, Richard, of Yaxley, Hunts, yeoman 0
3993113 2022286 2022286 plaintiff Carier Richard yeoman 620428 620428 Carier, Richard, of Yaxley, Hunts, yeoman 0
3993193 2022311 2022311 plaintiff Carrier Richard yeoman 620428 620428 Carrier, Richard, of Yaxley, Hunts, yeoman 0
3994839 2022907 2022907 plaintiff Cony William gent 620428 620428 Cony, William, of Yaxley, Hunts, gent 0
4028272 2034764 2034764 plaintiff Coney William gent 620428 620428 Coney, William, of Yaxley, Hunts, gent 0
4028355 2034792 2034792 plaintiff Cony William gent 620428 620428 Cony, William, of Yaxley, Hunts, gent 0
4028357 2034793 2034793 plaintiff Cony William gent 620428 620428 Cony, William, of Yaxley, Hunts, gent 0
4059442 2045771 2045771 defendant Temerland or Tenderlond alias Senderleye Henry yeoman 620428 620428 Temerland or Tenderlond alias Senderleye, Henry, of Yaxley, Hunts, yeoman 0
4067563 2048716 2048716 defendant Hollowell Charles yeoman 620428 620428 Hollowell, Charles, of Yaxley, Hunts, yeoman 0
4173702 2086257 2086257 defendant Conye William esq 620428 620428 Conye, William, of Yaxley, Hunts, esq 0
4173704 2086258 2086258 defendant Conye William esq 620428 620428 Conye, William, of Yaxley, Hunts, esq 0
4173706 2086259 2086259 defendant Conye William esq 620428 620428 Conye, William, of Yaxley, Hunts, esq 0
4173708 2086260 2086260 defendant Conye William gent 620428 620428 Conye, William, of Yaxley, Hunts, esq, or of Stoughton Magna, Hunts, gent 0
4173710 2086261 2086261 defendant Conye William gent 620428 620428 Conye, William, of Yaxley, Hunts, gent 0
4195358 2093923 2093923 defendant Holynghedge William yeoman 620428 620428 Holynghedge, William, of Yaxley, Hunts, yeoman 0
4239647 2109497 2109497 defendant Browne Robert yeoman 620428 620428 Browne, Robert, of Yaxley, Hunts, yeoman 0
4247954 2112301 2112301 defendant Browne Robert yeoman 620428 620428 Browne, Robert, of Yaxley, Hunts, yeoman 0
4339361 2143534 2143534 defendant Rushe George husbandman 620428 620428 Rushe, George, of Yaxley, Hunts, husbandman 0
5285103 2440669 2440669 defendant Sexten John yeoman 620428 620428 Sexten, John, of Yaxley, Hunts, yeoman 0
5285109 2440670 2440670 defendant Sexten John yeoman 620428 620428 Sexten, John, of Yaxley, Hunts, yeoman 0
5382566 2470075 2470075 defendant Grene John yeoman 620428 620428 Grene, John, of Yaxley, Hunts, yeoman 0
5405523 2476659 2476659 defendant Grene John yeoman 620428 620428 Grene, John, of Yaxley, Hunts, yeoman 0
5405528 2476660 2476660 defendant Grene John yeoman 620428 620428 Grene, John, of Yaxley, Hunts, yeoman 0
5581099 2529158 2529158 defendant Broun William gent 620428 620428 Broun, William, of Yaxley, Hunts, gent 3

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