names

44 rows where place_id = 727234

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4270760 2119797 2119797 defendant Reve Richard yeoman 727234 727234 Reve, Richard, of Sulgrave, yeoman 1
4320872 2137393 2137393 defendant Washington Lawrence gent 727234 727234 Washington, Lawrence, of Sulgrave, gent 0
4328528 2139857 2139857 defendant Tompson Lawrence gent 727234 727234 Tompson, Lawrence, of Sulgrave, gent 0
4448569 2184480 2184480 plaintiff Frenche Robert   727234 727234 Frenche, Robert, of Sulgrave, on his own account 0
4462059 2188833 2188833 defendant Folshull John   727234 727234 Folshull, John, of Sulgrave 1
4462062 2188834 2188834 defendant Folehull John   727234 727234 Folehull, John, of Sulgrave 1
4536910 2211814 2211814 plaintiff Stotusbury John   727234 727234 Stotusbury, John, of Sulgrave 0
4644216 2244405 2244405 defendant Stuttesbury John   727234 727234 Stuttesbury, John, of Sulgrave 0
4648201 2245540 2245540 plaintiff Stotusbury John   727234 727234 Stotusbury, John, of Sulgrave 0
4722633 2272394 2272394 defendant Taillour Walter husbandman 727234 727234 Taillour, Walter, of Sulgrave, husbandman 0
4748050 2279942 2279942 plaintiff Lovell John   727234 727234 Lovell, John, of Sulgrave 0
4748051 2279942 2279942 defendant Petyrkyn Richard husbandman 727234 727234 Petyrkyn, Richard, of Sulgrave, husbandman 0
4748052 2279942 2279942 defendant Hert William laborer 727234 727234 Hert, William, of Sulgrave, laborer 1
4751944 2281063 2281063 plaintiff Stotusbury John   727234 727234 Stotusbury, John, of Sulgrave, on his own account 0
4751946 2281064 2281064 plaintiff Stotusbury John   727234 727234 Stotusbury, John, of Sulgrave, on his own account 0
4807607 2298570 2298570 defendant Orchard Robert husbandman 727234 727234 Orchard, Robert, of Sulgrave, husbandman 0
4807608 2298570 2298570 defendant Benet Robert husbandman 727234 727234 Benet, Robert, of Sulgrave, husbandman 1
4813020 2300188 2300188 defendant Wryght Thomas husbandman 727234 727234 Wryght, Thomas, of Sulgrave, husbandman 1
4813021 2300188 2300188 defendant Orchard Robert husbandman 727234 727234 Orchard, Robert, of Sulgrave, husbandman 2
4864803 2315966 2315966 defendant Orchard Robert husbandman 727234 727234 Orchard, Robert, of Sulgrave, husbandman 0
4892988 2324531 2324531 defendant Brook John husbandman 727234 727234 Brook, John, of Sulgrave, husbandman 1
4940062 2338919 2338919 defendant Brook William husbandman 727234 727234 Brook, William, of Sulgrave, husbandman 1
5005817 2358600 2358600 defendant Stotusbury John esq 727234 727234 Stotusbury, John, of Sulgrave, esq 0
5054499 2372923 2372923 defendant Stotusbury Robert gent 727234 727234 Stotusbury, Robert, of Sulgrave, gent 1
5054500 2372923 2372923 defendant Belasyse Walter chapman 727234 727234 Belasyse, Walter, of Sulgrave, chapman 2
5054517 2372924 2372924 defendant Stotusbury Robert gent 727234 727234 Stotusbury,Robert, of Sulgrave, gent 7
5054518 2372924 2372924 defendant Belasyse Walter chapman 727234 727234 Belasyse, Walter, of Sulgrave, chapman 8
5054539 2372929 2372929 defendant Wever Philip weaver 727234 727234 Wever, Philip, of Sulgrave, weaver 0
5221059 2421862 2421862 defendant Lovell John, senior husbandman 727234 727234 Lovell, John, senior, of Sulgrave, husbandman 0
5257062 2432338 2432338 defendant Stotesbury Thomas gent 727234 727234 Stotesbury, Thomas, of Sulgrave, gent 0
5326728 2453061 2453061 defendant Kyry William husbandman 727234 727234 Kyry, William, of Sulgrave, husbandman 2
5361680 2463678 2463678 defendant Lovell John, senior husbandman 727234 727234 Lovell, John, senior, of Sulgrave, husbandman 0
5361681 2463678 2463678 defendant Lovell Thomas husbandman 727234 727234 Lovell, Thomas, of Sulgrave, husbandman 1
5369890 2466170 2466170 defendant Taillour Walter tailor 727234 727234 Taillour, Walter, of Sulgrave, tailor 0
5369891 2466170 2466170 defendant Yonge John husbandman 727234 727234 Yonge, John, of Sulgrave, husbandman 1
5419536 2480762 2480762 defendant Collys Richard husbandman 727234 727234 Collys, Richard, of Sulgrave, husbandman 0
5437921 2486277 2486277 defendant Collis Richard husbandman 727234 727234 Collis, Richard, of Sulgrave, husbandman 0
5459379 2492720 2492720 defendant Benam Geoffrey husbandman 727234 727234 Benam, Geoffrey, of Sulgrave, husbandman 0
5475535 2497681 2497681 defendant Collys Richard husbandman 727234 727234 Collys, Richard, of Sulgrave, husbandman 0
5508516 2507532 2507532 defendant Taylour Walter husbandman 727234 727234 Taylour, Walter, of Sulgrave, husbandman 0
5518240 2510533 2510533 defendant Stotesbury Thomas   727234 727234 Stotesbury, Thomas, of Sulgrave 0
5626851 2552373 2552373 defendant Stotusbury John   727234 727234 Stotusbury, John, of Sulgrave, "prentys of court" 0
5626854 2552373 2552373 defendant Wryght John husbandman 727234 727234 Wryght, John, of Sulgrave, husbandman 3
5626855 2552373 2552373 defendant Mayn John husbandman 727234 727234 Mayn, John, of Sulgrave, husbandman 4

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