names

62 rows where place_id = 587204

✎ 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
3590744 1864745 1864745 defendant Cok John husbandman 587204 587204 Cok, John, of Wylby, husbandman 0
3671931 1917219 1917219 defendant Calver Robert husbandman 587204 587204 Calver, Robert, of Wylby, husbandman 0
3704987 1927853 1927853 plaintiff Grene John yeoman 587204 587204 Grene, John, of Wylby, yeoman 0
3748124 1941339 1941339 defendant Grene John yeoman 587204 587204 Grene, John, of Wylby, yeoman 0
3762212 1945827 1945827 defendant Grene John yeoman 587204 587204 Grene, John, of Wylby, yeoman 0
3780886 1951756 1951756 plaintiff Grene John   587204 587204 Grene, John, of Wylby 0
3781339 1951906 1951906 defendant Payne Thomas, junior husbandman 587204 587204 Payne, Thomas, junior, of Wylby, husbandman 0
3781340 1951906 1951906 defendant Payne Thomas, senior husbandman 587204 587204 Payne, Thomas, senior, of Wylby, husbandman 1
3787180 1953781 1953781 defendant Felster John mercer 587204 587204 Felster, John, of Wylby, mercer 2
3802305 1958619 1958619 defendant Grene John yeoman 587204 587204 Grene, John, of Wylby, yeoman 2
3802309 1958621 1958621 defendant Grene John yeoman 587204 587204 Grene, John, of Wylby, yeoman 0
3814937 1962589 1962589 plaintiff Grene John   587204 587204 Grene, John,of Wylby 0
3817239 1963305 1963305 defendant Grene John yeoman 587204 587204 Grene, John, of Wylby, yeoman 0
3846699 1972523 1972523 defendant Grene John yeoman 587204 587204 Grene, John, of Wylby, yeoman 0
3852496 1974388 1974388 defendant Fylby Thomas tanner 587204 587204 Fylby, Thomas, of Wylby, tanner 1
3862025 1977486 1977486 plaintiff Grendlyng John   587204 587204 Grendlyng, John, of Wylby 0
3862223 1977549 1977549 plaintiff Grindlyng John   587204 587204 Grindlyng, John, of Wylby 0
3886987 1985911 1985911 defendant Grene John yeoman 587204 587204 Grene, John, of Wylby, yeoman 0
3887052 1985934 1985934 defendant Grene John gent 587204 587204 Grene, John, of Wylby, gent 0
3907120 1992672 1992672 defendant Hode alias Horde John clerk 587204 587204 Hode alias Horde, John, of Wylby, clerk 0
3908990 1993300 1993300 defendant Raynoldys Roger clerk 587204 587204 Raynoldys, Roger, of Wylby, clerk 2
3914944 1995348 1995348 defendant Grene Edward gent 587204 587204 Grene, Edward, of Wylby, gent 0
3916777 1995979 1995979 plaintiff Fylby William (legal representative) 587204 587204 Fylby, William, of Wylby, executors of 0
3916779 1995979 1995979 defendant Stanton alias Thrower Giles butcher 587204 587204 Stanton alias Thrower, Giles, of Wylby, butcher 0
3916780 1995979 1995979 defendant Fylby Thomas tanner 587204 587204 Fylby, Thomas, of Wylby, tanner 1
3917151 1996098 1996098 plaintiff Goldsmyth John, senior yeoman 587204 587204 Goldsmyth, John, senior, of Wylby, yeoman 0
3940581 2003859 2003859 defendant Stanton Giles yeoman 587204 587204 Stanton, Giles, of Wylby, yeoman 0
4028083 2034694 2034694 defendant Grene Edward gent 587204 587204 Grene, Edward, of Wylby, gent 2
4042934 2039950 2039950 defendant Fylby Robert yeoman 587204 587204 Fylby, Robert, of Wylby, yeoman 0
4042939 2039951 2039951 defendant Fylby Robert yeoman 587204 587204 Fylby, Robert, of Wylby, yeoman 0
4168175 2084354 2084354 defendant Robwood John yeoman 587204 587204 Robwood, John, of Wylby, yeoman 0
4469421 2191098 2191098 defendant Elger John   587204 587204 Elger, John, of Wylby 1
4944602 2340294 2340294 defendant Jurdan John husbandman 587204 587204 Jurdan, John, of Wylby, husbandman 0
5013237 2360705 2360705 plaintiff Atheythe William clerk 587204 587204 Atheythe, William, of Wylby, clerk 0
5026326 2364590 2364590 defendant Coldham Richard yeoman 587204 587204 Coldham, Richard, of Wylby, yeoman 2
5033680 2366730 2366730 defendant Banham William yeoman 587204 587204 Banham, William, of Wylby, yeoman 2
5033681 2366730 2366730 defendant Coldeham William yeoman 587204 587204 Coldeham, William, of Wylby, yeoman 3
5136597 2397222 2397222 defendant Hamond Thomas husbandman 587204 587204 Hamond, Thomas, of Wylby, husbandman 0
5157155 2403230 2403230 defendant Hamond Thomas husbandman 587204 587204 Hamond, Thomas, of Wylby, husbandman 0
5236922 2426380 2426380 defendant Moderey William husbandman 587204 587204 Moderey, William, of Wylby, husbandman 0
5239233 2427061 2427061 defendant Taylour John husbandman 587204 587204 Taylour, John, of Wylby, husbandman 1
5248047 2429566 2429566 defendant Walsham Robert butcher 587204 587204 Walsham, Robert, of Wylby, butcher 0
5281249 2439592 2439592 defendant Walsam Thomas husbandman 587204 587204 Walsam, Thomas, of Wylby, husbandman 6
5298423 2444514 2444514 defendant Coldred John husbandman 587204 587204 Coldred, John, of Wylby, husbandman 2
5301432 2445380 2445380 defendant Hervy John husbandman 587204 587204 Hervy, John, of Wylby, husbandman 0
5319194 2450836 2450836 plaintiff Harvy John   587204 587204 Harvy, John, of Wylby 0
5319195 2450836 2450836 defendant Goderam Bartholomew weaver 587204 587204 Goderam, Bartholomew, of Wylby, weaver 0
5319196 2450836 2450836 defendant Elsey James laborer 587204 587204 Elsey, James, of Wylby, laborer 1
5319766 2451004 2451004 defendant Hervy John husbandman 587204 587204 Hervy, John, of Wylby, husbandman 4
5354360 2461429 2461429 defendant Mounteney William gent 587204 587204 Mounteney, William, of Wylby, gent 0
5354361 2461429 2461429 defendant Nele John husbandman 587204 587204 Nele, John, of Wylby, husbandman 1
5354362 2461429 2461429 defendant Hamond Robert, junior husbandman 587204 587204 Hamond, Robert, junior, of Wylby, husbandman 2
5357354 2462366 2462366 plaintiff Mownteney William gent 587204 587204 Mownteney, William, of Wylby, gent 0
5362148 2463827 2463827 defendant Mounteney William gent 587204 587204 Mounteney, William, of Wylby, gent 0
5362368 2463887 2463887 defendant Mounteney William gent 587204 587204 Mounteney, William, of Wylby, gent 0
5491687 2502407 2502407 defendant Wysse John chaplain 587204 587204 Wysse, John, of Wylby, chaplain 1
5492305 2502613 2502613 defendant Wysse John chaplain 587204 587204 Wysse, John, of Wylby, chaplain 1
5493237 2502886 2502886 defendant Mounteney William gent 587204 587204 Mounteney, William, of Wylby, gent 0
5493240 2502887 2502887 defendant Mounteney William gent 587204 587204 Mounteney, William, of Wylby, gent 0
5511536 2508457 2508457 defendant Barnshawe Roger yeoman 587204 587204 Barnshawe, Roger, of Wylby, yeoman 0
5575308 2527368 2527368 defendant Fytte Robert husbandman 587204 587204 Fytte, Robert, of Wylby, husbandman 0
5586142 2530706 2530706 defendant Mounteney William gent 587204 587204 Mounteney, William, of Wylby, 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);