names

60 rows where place_id = 588869

✎ 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
3595848 1866340 1866340 defendant Forde John yeoman 588869 588869 Forde, John, of Ansty, yeoman 0
3649701 1910280 1910280 defendant Sylvestero Thomas miller 588869 588869 Sylvestero, Thomas, of Ansty, miller 0
3666332 1915421 1915421 defendant Togood Richard laborer 588869 588869 Togood, Richard, of Ansty, laborer 0
3687126 1922147 1922147 defendant Canon John husbandman 588869 588869 Canon, John, of Ansty, husbandman 0
3764458 1946545 1946545 defendant Wylewood George tailor 588869 588869 Wylewood, George, of Ansty, tailor 1
3799039 1957610 1957610 defendant Darlyng Richard laborer 588869 588869 Darlyng, Richard, of Ansty, laborer 2
3801609 1958402 1958402 plaintiff Gynne Henry   588869 588869 (Gynne, Henry, of Ansty 1
3874956 1981846 1981846 defendant Wylson James tailor 588869 588869 Wylson, James, of Ansty, tailor 0
3919823 1996966 1996966 defendant Grynne Robert yeoman 588869 588869 Grynne, Robert, of Ansty, yeoman 0
4094561 2058391 2058391 defendant Chapman William yeoman 588869 588869 Chapman, William, of Ansty, yeoman 0
4094562 2058391 2058391 defendant Darlyng William yeoman 588869 588869 Darlyng, William, of Ansty, yeoman 1
4358723 2150287 2150287 defendant Mytchell Thomas gent 588869 588869 Mytchell, Thomas, of Ansty, gent 0
4358727 2150288 2150288 defendant Mytchell Thomas gent 588869 588869 Mytchell, Thomas, of Ansty, gent 0
4379735 2157846 2157846 defendant Gyn Robert husbandman 588869 588869 Gyn, Robert, of Ansty, husbandman 1
4453256 2186026 2186026 defendant Sydenham John   588869 588869 Sydenham, John, of Ansty, shepherd 1
4457699 2187418 2187418 defendant Pourte John   588869 588869 Pourte, John, of Ansty 0
4500383 2200740 2200740 defendant Corner Hugh   588869 588869 Corner, Hugh, of Ansty 0
4508748 2203211 2203211 defendant Alot John   588869 588869 Alot, John, of Ansty 1
4512313 2204291 2204291 defendant Porter William   588869 588869 Porter, William, of Ansty 1
4605758 2232917 2232917 defendant Ode John   588869 588869 Ode, John, of Ansty 0
4624796 2238736 2238736 plaintiff Ode William   588869 588869 Ode, William, of Ansty, 0
4677794 2258674 2258674 defendant Ode William husbandman 588869 588869 Ode, William, of Ansty, husbandman 0
4678347 2258835 2258835 defendant Ode William yeoman 588869 588869 Ode, William, of Ansty, yeoman 0
4736300 2276482 2276482 defendant Kenne John husbandman 588869 588869 Kenne, John, of Ansty, husbandman 0
4742071 2278178 2278178 defendant Jeke William husbandman 588869 588869 Jeke, William, of Ansty, husbandman 0
4742072 2278178 2278178 defendant Willesson Richard husbandman 588869 588869 Willesson, Richard, of Ansty, husbandman 1
4758011 2282880 2282880 defendant Banden Richard husbandman 588869 588869 Banden, Richard, of Ansty, husbandman 1
4820129 2302371 2302371 defendant Banden or Bauden Richard husbandman 588869 588869 Banden or Bauden, Richard, of Ansty, husbandman 3
4838775 2308055 2308055 defendant Rodeswell Nicholas husbandman 588869 588869 Rodeswell, Nicholas, of Ansty, husbandman 0
4840816 2308663 2308663 defendant Milner Richard miller 588869 588869 Milner, Richard, of Ansty, miller 1
4840817 2308663 2308663 defendant Smyth Richard smith 588869 588869 Smyth, Richard, of Ansty, smith 2
4844528 2309807 2309807 defendant Reddyswell Nicholas husbandman 588869 588869 Reddyswell, Nicholas, of Ansty, husbandman 0
4845017 2309957 2309957 defendant Gyleth William (legal representative) 588869 588869 Gyleth, William, of Ansty, master & parson, executor of 0
4851847 2312012 2312012 defendant Redeswell Nicholas yeoman 588869 588869 Redeswell, Nicholas, of Ansty, yeoman 0
4854823 2312858 2312858 defendant Toly Richard husbandman 588869 588869 Toly, Richard, of Ansty, husbandman 2
4865866 2316295 2316295 defendant Clerk John husbandman 588869 588869 Clerk, John, of Ansty, husbandman 0
4865941 2316320 2316320 defendant Redeswell Nicholas husbandman 588869 588869 Redeswell, Nicholas, of Ansty, husbandman 0
4933062 2336731 2336731 defendant Seman Thomas husbandman 588869 588869 Seman, Thomas, of Ansty, husbandman 0
4953261 2342937 2342937 defendant Forde Peter husbandman 588869 588869 Forde, Peter, of Ansty, husbandman 0
4961025 2345257 2345257 defendant Reymond William carpenter 588869 588869 Reymond, William, of Ansty, carpenter 1
4961028 2345258 2345258 defendant Reymond William carpenter 588869 588869 Reymond, William, of Ansty, carpenter 1
5033399 2366649 2366649 defendant Rogger Richard husbandman 588869 588869 Rogger, Richard, of Ansty, husbandman 1
5042605 2369390 2369390 plaintiff Donham William gent 588869 588869 Donham, William, of Ansty, gent 0
5076090 2379348 2379348 defendant Wryght Robert smith 588869 588869 Wryght, Robert, of Ansty, smith 0
5076091 2379348 2379348 defendant Raynold William husbandman 588869 588869 Raynold, William, of Ansty, husbandman 1
5115247 2390885 2390885 defendant Waryn Richard husbandman 588869 588869 Waryn, Richard, of Ansty, husbandman 0
5136341 2397150 2397150 defendant Tytervyle Richard   588869 588869 Tytervyle, Richard, of of Ansty 2
5201037 2416058 2416058 defendant Payn William yeoman 588869 588869 Payn, William, of Ansty, yeoman 1
5346300 2458984 2458984 defendant Forde John yeoman 588869 588869 Forde, John, of Ansty, yeoman 1
5349725 2460050 2460050 defendant Forde John, senior yeoman 588869 588869 Forde, John, senior, of Ansty, yeoman 0
5363547 2464251 2464251 defendant Forthe John husbandman 588869 588869 Forthe, John, of Ansty, husbandman 0
5363549 2464252 2464252 defendant Forthe John husbandman 588869 588869 Forthe, John, of Ansty, husbandman 0
5369387 2466021 2466021 defendant Smyth Geoffrey (legal representative) 588869 588869 Smyth, Geoffrey, of Ansty, executors of 2
5389875 2472168 2472168 defendant Ratclyf Robert yeoman 588869 588869 Ratclyf, Robert, of Ansty, yeoman 0
5405677 2476699 2476699 defendant Ratclyf Robert yeoman 588869 588869 Ratclyf, Robert, of Ansty, yeoman 0
5415604 2479611 2479611 defendant Ratclyff Robert yeoman 588869 588869 Ratclyff, Robert, of Ansty, yeoman 0
5415609 2479612 2479612 defendant Ratclyff Robert yeoman 588869 588869 Ratclyff, Robert, of Ansty, yeoman 0
5475446 2497654 2497654 defendant Astlot (illegible) husbandman 588869 588869 Astlot, _, of Ansty, husbandman 0
5533906 2515147 2515147 defendant Hartisfeld Thomas yeoman 588869 588869 Hartisfeld, Thomas, of Ansty, yeoman 2
5562595 2523662 2523662 defendant Dardys John hubandman 588869 588869 Dardys, John, of Ansty, hubandman 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);