names

43 rows where place_id = 607819

✎ 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
3670908 1916867 1916867 defendant Fulham Edward husbandman 607819 607819 Fulham, Edward, of Loughton, husbandman 0
3807552 1960270 1960270 defendant Jacson Richard bricklayer 607819 607819 Jacson, Richard, of Loughton, bricklayer 0
3955083 2008841 2008841 defendant Alcock alias Awebott Roger husbandman 607819 607819 Alcock alias Awebott, Roger, of Loughton, husbandman 2
4062931 2047042 2047042 defendant Damas Chales cooper 607819 607819 Damas, Chales, of Loughton, cooper 2
4147568 2077291 2077291 defendant Dallyson William esq 607819 607819 Dallyson, William, of Loughton, esq 0
4199440 2095353 2095353 defendant Hedges John yeoman 607819 607819 Hedges, John, of Loughton, yeoman 0
4277788 2122155 2122155 defendant Edwardes Richard yeoman 607819 607819 Edwardes, Richard, of Loughton, yeoman 1
4420142 2171200 2171200 plaintiff Braundys Ascelina   607819 607819 Braundys, Ascelina, of Loughton, formerly wife of Adam 0
4459217 2187927 2187927 defendant Piper John   607819 607819 Piper, John, of Loughton 0
4651519 2246479 2246479 defendant Markes John, junior husbandman 607819 607819 Markes, John, junior, of Loughton, husbandman 1
4785531 2291496 2291496 defendant Pelham John   607819 607819 Pelham, John, of Loughton, knight 0
4786510 2291827 2291827 plaintiff Galewey William   607819 607819 Galewey, William, of Loughton 0
4837527 2307673 2307673 plaintiff Franklen John   607819 607819 Franklen, John, of Loughton 0
4864771 2315956 2315956 plaintiff Frankleyn John   607819 607819 Frankleyn, John, of Loughton 0
4904175 2327918 2327918 defendant Fryday Robert husbandman 607819 607819 Fryday, Robert, of Loughton, husbandman 0
4912182 2330310 2330310 defendant Wylcok Walter husbandman 607819 607819 Wylcok, Walter, of Loughton, husbandman 1
4922548 2333469 2333469 plaintiff Loughton John   607819 607819 Loughton, John, of Loughton 0
5000833 2357120 2357120 defendant Shepherde William husbandman 607819 607819 Shepherde, William, of Loughton, husbandman 1
5023929 2363910 2363910 defendant Man John   607819 607819 Man, John, of Loughton, mason 0
5050004 2371622 2371622 defendant Hull John wheeler 607819 607819 Hull, John, of Loughton, wheeler 1
5050010 2371623 2371623 defendant Hull John wheeler 607819 607819 Hull, John, of Loughton, wheeler 1
5071091 2377847 2377847 defendant Berysby William husbandman 607819 607819 Berysby, William, of Loughton, husbandman 0
5087308 2382667 2382667 defendant Carter Thomas yeoman 607819 607819 Carter, Thomas, of Loughton, yeoman 1
5162218 2404680 2404680 defendant Shendele Thomas husbandman 607819 607819 Shendele, Thomas, of Loughton, husbandman 7
5179013 2409587 2409587 defendant Adam Robert husbandman 607819 607819 Adam, Robert, of Loughton, husbandman 1
5180178 2409945 2409945 defendant Aunysley William gent 607819 607819 Aunysley, William, of Loughton, gent 0
5201718 2416268 2416268 defendant Adam Robert husbandman 607819 607819 Adam, Robert, of Loughton, husbandman 1
5217838 2420948 2420948 defendant Thomas Thomas yeoman 607819 607819 Thomas, Thomas, of Loughton, yeoman 0
5291303 2442460 2442460 defendant Roger John yeoman 607819 607819 Roger, John, of Loughton, yeoman 0
5295773 2443758 2443758 defendant Gelon William yeoman 607819 607819 Gelon, William, of Loughton, yeoman 0
5310951 2448311 2448311 defendant Hille John husbandman 607819 607819 Hille, John, of Loughton, husbandman 0
5314061 2449224 2449224 defendant Rogers John husbandman 607819 607819 Rogers, John, of Loughton, husbandman 2
5314062 2449224 2449224 defendant Amys John husbandman 607819 607819 Amys, John, of Loughton, husbandman 3
5337631 2456323 2456323 defendant Aleyn John husbandman 607819 607819 Aleyn, John, of Loughton, husbandman 1
5359697 2463071 2463071 defendant Rogers John yeoman 607819 607819 Rogers, John, of Loughton, yeoman 0
5359698 2463071 2463071 defendant Custe or Cufte John husbandman 607819 607819 Custe or Cufte, John, of Loughton, husbandman 1
5369269 2465989 2465989 defendant Rogers John yeoman 607819 607819 Rogers, John, of Loughton, yeoman 0
5390849 2472447 2472447 defendant Clerk John husbandman 607819 607819 Clerk, John, of Loughton, husbandman 1
5461658 2493425 2493425 defendant Couham Robert husbandman 607819 607819 Couham, Robert, of Loughton, husbandman 1
5461659 2493425 2493425 defendant Jordan John husbandman 607819 607819 Jordan, John, of Loughton, husbandman 2
5562175 2523535 2523535 defendant Courtney Philip esq 607819 607819 Courtney, Philip, of Loughton, esq 0
5573182 2526707 2526707 defendant Trutale Robert gent 607819 607819 Trutale, Robert, of Loughton, gent 0
5594975 2533399 2533399 defendant Clerk John yeoman 607819 607819 Clerk, John, of Loughton, 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);