names

49 rows where place_id = 595996

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622712 1874632 1874632 defendant Bowyer Richard laborer 595996 595996 Bowyer, Richard, of Trumpyngton, laborer 0
3622713 1874632 1874632 defendant Bowyer Thomas laborer 595996 595996 Bowyer, Thomas, of Trumpyngton, laborer 1
3687510 1922273 1922273 defendant Helme Margery widow 595996 595996 Helme, Margery, of Trumpyngton, widow 1
3722777 1933390 1933390 defendant Pychard Hugh gent 595996 595996 Pychard, Hugh, of Trumpyngton, gent 0
3900113 1990260 1990260 defendant Thompson William husbandman or fuller 595996 595996 Thompson, William, of Trumpyngton, husbandman or fuller 2
3921865 1997657 1997657 defendant Amy Agnes spinster 595996 595996 Amy, Agnes, of Trumpyngton, spinster 0
3944908 2005313 2005313 defendant Ives Thomas husbandman 595996 595996 Ives, Thomas, of Trumpyngton, husbandman 1
3972482 2014954 2014954 defendant Watson John husbandman 595996 595996 Watson, John, of Trumpyngton, husbandman 0
4130972 2071389 2071389 defendant Newsam Francis gent 595996 595996 Newsam, Francis, of Trumpyngton, gent 0
4217787 2101713 2101713 defendant Adams Thomas gent 595996 595996 Adams, Thomas, of Trumpyngton, gent 0
4219671 2102385 2102385 defendant Ansell James gent 595996 595996 Ansell, James, of Trumpyngton, gent 0
4264595 2117801 2117801 defendant Wilson Thomas husbandman 595996 595996 Wilson, Thomas, of Trumpyngton, husbandman 2
4346915 2146172 2146172 defendant Kylburne Henry yeoman 595996 595996 Kylburne, Henry, of Trumpyngton, yeoman 0
4347087 2146238 2146238 defendant West John yeoman 595996 595996 West, John, of Trumpyngton, yeoman 0
4385151 2159720 2159720 defendant Chaplyn Thomas Cams, yeoman 595996 595996 Chaplyn Thomas, of Trumpyngton, Cams, yeoman 0
4391611 2161810 2161810 defendant Chaplyn Thomas yeoman 595996 595996 Chaplyn, Thomas, of Trumpyngton, yeoman 0
4391796 2161878 2161878 defendant Aunsell or Ansell or Anselme James gent 595996 595996 Aunsell or Ansell or Anselme, James, of Trumpyngton, gent 0
4471627 2191790 2191790 plaintiff Chapman William   595996 595996 Chapman, William, of Trumpyngton 0
4472907 2192202 2192202 defendant Lotte John   595996 595996 Lotte, John, of Trumpyngton 2
4472910 2192202 2192202 defendant Lyonnis William   595996 595996 Lyonnis, William, of Trumpyngton 5
4472924 2192204 2192204 defendant Launcy John   595996 595996 Launcy, John, of Trumpyngton 0
4514061 2204821 2204821 defendant Crane William   595996 595996 Crane, William, of Trumpyngton 4
4554442 2217320 2217320 defendant Roulse Henry   595996 595996 Roulse, Henry, of Trumpyngton 1
4566516 2221096 2221096 defendant Roulfe Henry   595996 595996 Roulfe, Henry, of Trumpyngton 0
4600498 2231378 2231378 defendant Herne John in the   595996 595996 Herne, John in the, of Trumpyngton 2
4617461 2236473 2236473 plaintiff Grane William de la   595996 595996 Grane, William de la, of Trumpyngton 0
4715840 2270267 2270267 defendant Barnet Richard husbandman 595996 595996 Barnet, Richard, of Trumpyngton, husbandman 3
4761664 2283992 2283992 defendant Frogge John, sen husbandman 595996 595996 Frogge, John, sen, of Trumpyngton, husbandman 2
4771594 2287093 2287093 defendant Baker John   595996 595996 Baker, John, of Trumpyngton, groom 0
4781074 2290089 2290089 defendant Ferrour or Smith Richard husbandman 595996 595996 Ferrour or Smith, Richard, of Trumpyngton, husbandman 0
4802610 2297002 2297002 defendant Spede John yeoman 595996 595996 Spede, John, of Trumpyngton, yeoman 0
4814300 2300577 2300577 defendant Plouwright John, junior husbandman 595996 595996 Plouwright, John, junior, of Trumpyngton, husbandman 0
4868153 2317015 2317015 defendant Kylburne Richard husbandman 595996 595996 Kylburne, Richard, of Trumpyngton, husbandman 1
4986660 2352944 2352944 plaintiff Cokerell William   595996 595996 Cokerell, William, of Trumpyngton 1
4991489 2354339 2354339 defendant Ploughwright William   595996 595996 Ploughwright, William, of Trumpyngton 1
5025075 2364232 2364232 defendant Philipot Roger gent 595996 595996 Philipot, Roger, of Trumpyngton, gent 3
5064479 2375916 2375916 defendant Bradle Henry   595996 595996 Bradle, Henry, of Trumpyngton 0
5073520 2378564 2378564 defendant Phelipot Roger yeoman 595996 595996 Phelipot, Roger, of Trumpyngton, gent, son of Phelypot, John, of Trumpyngton, Cams, yeoman 0
5101347 2386805 2386805 defendant Cristofer Thomas laborer 595996 595996 Cristofer, Thomas, of Trumpyngton, laborer 5
5110897 2389584 2389584 defendant Bateman William gent 595996 595996 Bateman, William, of Trumpyngton, gent 0
5110898 2389584 2389584 defendant Wode John husbandman 595996 595996 Wode, John, of Trumpyngton, husbandman 1
5110900 2389584 2389584 defendant Pychard Roger, junior husbandman 595996 595996 Pychard, Roger, junior, of Trumpyngton, husbandman 3
5110901 2389584 2389584 defendant Bowyer John husbandman 595996 595996 Bowyer, John, of Trumpyngton, husbandman 4
5110902 2389584 2389584 defendant Rest William husbandman 595996 595996 Rest, William, of Trumpyngton, husbandman 5
5149978 2401126 2401126 defendant Paxton John clerk 595996 595996 Paxton, John, of Trumpyngton, clerk 2
5150974 2401423 2401423 defendant Paxton John clerk 595996 595996 Paxton, John, of Trumpyngton, clerk 2
5203123 2416674 2416674 defendant Moreys John esq 595996 595996 Moreys, John, of Trumpyngton, esq 0
5203130 2416675 2416675 defendant Moreys John esq 595996 595996 Moreys, John, of Trumpyngton, esq 0
5610401 2546964 2546964 defendant Plowrighte Robert   595996 595996 Plowrighte, Robert, of Trumpyngton 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);