names

73 rows where place_id = 640355

✎ 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
3854795 1975144 1975144 defendant Lammyng John yeoman 640355 640355 Lammyng, John, of Otryngham, yeoman 0
4420093 2171187 2171187 plaintiff Bradele William de   640355 640355 Bradele, William de, of Otryngham 0
4488905 2197250 2197250 defendant Coton William   640355 640355 Coton, William, of Otryngham 1
4533101 2210616 2210616 defendant Mekeman John   640355 640355 Mekeman, John, of Otryngham 0
4535170 2211277 2211277 defendant Benne Thomas   640355 640355 Benne, Thomas, of Otryngham 1
4536711 2211758 2211758 plaintiff Stevenman Peter   640355 640355 Stevenman, Peter, of Otryngham 0
4536712 2211758 2211758 defendant Lambyn William   640355 640355 Lambyn, William, of Otryngham 0
4556239 2217890 2217890 defendant Benne Thomas   640355 640355 Benne, Thomas, of Otryngham 0
4564969 2220611 2220611 defendant Benne Thomas   640355 640355 Benne, Thomas, of Otryngham 0
4580217 2225299 2225299 defendant Routh John   640355 640355 Routh, John, of Otryngham 3
4666134 2250875 2250875 defendant Carter Robert weaver 640355 640355 Carter, Robert, of Otryngham, weaver 0
4700657 2265611 2265611 defendant Bylton John de husbandman 640355 640355 Bylton, John de, of Otryngham, husbandman 0
4707318 2267666 2267666 defendant Redemer Thoams gent 640355 640355 Redemer, Thoams, of Otryngham, gent 0
4707319 2267666 2267666 defendant Jonesson Richard husbandman 640355 640355 Jonesson, Richard, of Otryngham, husbandman 1
4707321 2267666 2267666 defendant Patryngton Robert husbandman 640355 640355 Patryngton, Robert, of Otryngham, husbandman 3
4707323 2267667 2267667 defendant Vausur William miller 640355 640355 Vausur, William, of Otryngham, miller 0
4707324 2267667 2267667 defendant Pynchard Robert laborer 640355 640355 Pynchard, Robert, of Otryngham, laborer 1
4723326 2272605 2272605 defendant Ben Emma widow 640355 640355 Ben, Emma, of Otryngham, widow 2
4733419 2275629 2275629 defendant Benne William husbandman 640355 640355 Benne, William, of Otryngham, husbandman 0
4733420 2275629 2275629 defendant Dankyn William husbandman 640355 640355 Dankyn, William, of Otryngham, husbandman 1
4741771 2278087 2278087 defendant Redmer Thomas gent 640355 640355 Redmer, Thomas, of Otryngham, gent 1
4741772 2278087 2278087 defendant Wadworth John husbandman 640355 640355 Wadworth, John, of Otryngham, husbandman 2
4741773 2278087 2278087 defendant Daukyn William yeoman 640355 640355 Daukyn, William, of Otryngham, yeoman 3
4748627 2280094 2280094 defendant Clerk Richard husbandman 640355 640355 (Clerk, Richard, of Otryngham, husbandman 1
4758830 2283115 2283115 defendant Dawekyn William tailor 640355 640355 Dawekyn, William, of Otryngham, tailor 0
4766154 2285405 2285405 defendant Scotte William tailor 640355 640355 Scotte, William, of Otryngham, tailor 0
4767742 2285890 2285890 defendant Wylton William butcher 640355 640355 Wylton, William, of Otryngham, butcher 0
4767747 2285890 2285890 defendant Benne William husbandman 640355 640355 Benne, William, of Otryngham, husbandman 5
4767750 2285891 2285891 defendant Benne William yeoman 640355 640355 Benne, William, of Otryngham, yeoman 1
4767754 2285892 2285892 defendant Alaynbrother Alchon John husbandman 640355 640355 Alaynbrother Alchon, John, of Otryngham, husbandman 0
4767758 2285892 2285892 defendant Alchon Alan husbandman 640355 640355 Alchon, Alan, of Otryngham, husbandman 4
4783982 2291000 2291000 defendant Arnald John   640355 640355 Arnald, John, of Otryngham, franklin 0
4792120 2293636 2293636 defendant Wilton William flesshewer or butcher 640355 640355 Wilton, William, of Otryngham, flesshewer or butcher 0
4792125 2293636 2293636 defendant Benne William husbandman 640355 640355 Benne, William, of Otryngham, husbandman 5
4802690 2297028 2297028 defendant Benne William husbandman 640355 640355 Benne, William, of Otryngham, husbandman 0
4824667 2303759 2303759 defendant Ingram Walter husbandman 640355 640355 Ingram, Walter, of Otryngham, husbandman 0
4824668 2303759 2303759 defendant Vele William husbandman 640355 640355 Vele, William, of Otryngham, husbandman 1
4824669 2303759 2303759 defendant Loweson Hugh husbandman 640355 640355 Loweson, Hugh, of Otryngham, husbandman 2
4824670 2303759 2303759 defendant Lamyn John, senior husbandman 640355 640355 Lamyn, John, senior, of Otryngham, husbandman 3
4824671 2303759 2303759 defendant Drypole John husbandman 640355 640355 Drypole, John, of Otryngham, husbandman 4
4824672 2303759 2303759 defendant Huson Richard husbandman 640355 640355 Huson, Richard, of Otryngham, husbandman 5
4828801 2305044 2305044 defendant Routh William gent 640355 640355 Routh, William, of Otryngham, gent 2
4843748 2309567 2309567 defendant Althon Robert husbandman 640355 640355 Althon, Robert, of Otryngham, husbandman 0
4855545 2313097 2313097 defendant Routh William gent 640355 640355 Routh, William, of Otryngham, gent 2
4862691 2315318 2315318 defendant Daukyn William tailor 640355 640355 Daukyn, William, of Otryngham, tailor 0
4862696 2315318 2315318 defendant Ingram William husbandman 640355 640355 (Ingram, William, of Otryngham, husbandman 5
4862697 2315318 2315318 defendant Ingram Walter husbandman 640355 640355 Ingram, Walter, of Otryngham, husbandman 6
4865783 2316266 2316266 defendant Belowe William tailor 640355 640355 Belowe, William, of Otryngham, tailor 0
4869392 2317396 2317396 defendant Scotte William tailor 640355 640355 Scotte, William, of Otryngham, tailor 0
4875270 2319217 2319217 defendant Benne William yeoman 640355 640355 Benne, William, of Otryngham, yeoman 4
4900442 2326783 2326783 defendant Arnald Margaret widow 640355 640355 Arnald, Margaret, of Otryngham, widow 0
4914049 2330904 2330904 defendant Bale William yeoman 640355 640355 Bale, William, of Otryngham, yeoman 1
4948740 2341589 2341589 defendant Tomson John husbandman 640355 640355 Tomson, John, of Otryngham, husbandman 4
4948741 2341589 2341589 defendant Cristofer John husbandman 640355 640355 Cristofer, John, of Otryngham, husbandman 5
4948742 2341589 2341589 defendant Drypole John, senior husbandman 640355 640355 Drypole, John, senior, of Otryngham, husbandman 6
4948750 2341591 2341591 defendant Daukyn William tailor 640355 640355 Daukyn, William, of Otryngham, tailor 0
4968513 2347551 2347551 defendant Routhe William gent 640355 640355 Routhe, William, of Otryngham, gent 1
4974523 2349343 2349343 defendant Alclyon or Alchon John Alanson husbandman 640355 640355 Alclyon or Alchon, John Alanson, of Otryngham, husbandman 0
5001225 2357240 2357240 defendant Lammyn John, sen husbandman 640355 640355 Lammyn, John, sen, of Otryngham, husbandman 1
5059244 2374330 2374330 defendant Frothyngham Thomas yeoman 640355 640355 Frothyngham, Thomas, of Otryngham, yeoman 1
5090597 2383631 2383631 defendant Atkynson William   640355 640355 Atkynson, William, of Otryngham, shepherd 2
5114972 2390795 2390795 defendant Bonefaunte Robert husbandman 640355 640355 Bonefaunte, Robert, of Otryngham, husbandman 0
5114996 2390802 2390802 defendant Parcour Robert husbandman 640355 640355 Parcour, Robert, of Otryngham, husbandman 0
5114997 2390802 2390802 defendant Alanson John husbandman 640355 640355 Alanson, John, of Otryngham, husbandman 1
5115003 2390804 2390804 defendant Twyer Alexander esq 640355 640355 Twyer, Alexander, of Otryngham, esq 0
5198573 2415338 2415338 defendant Ingram Robert gent 640355 640355 Ingram, Robert, of Otryngham, gent 2
5246020 2429000 2429000 defendant Riddemer Walter husbandman 640355 640355 Riddemer, Walter, of Otryngham, husbandman 2
5315480 2449694 2449694 defendant Vele John yeoman 640355 640355 Vele, John, of Otryngham, yeoman 1
5315481 2449694 2449694 defendant Carter Robert husbandman 640355 640355 Carter, Robert, of Otryngham, husbandman 2
5540357 2517113 2517113 defendant Wasworth John husbandman 640355 640355 Wasworth, John, of Otryngham, husbandman 0
5540358 2517113 2517113 defendant Frowe Richard husbandman 640355 640355 Frowe, Richard, of Otryngham, husbandman 1
5540359 2517113 2517113 defendant Smyth John husbandman 640355 640355 Smyth, John, of Otryngham, husbandman 2
5626658 2552311 2552311 defendant Arnold John gent 640355 640355 Arnold, John, of Otryngham, gent 1

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