names

139 rows where place_id = 589546

✎ 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
3597929 1866975 1866975 defendant Hert William husbandman 589546 589546 Hert, William, of Yatton, husbandman 2
3597930 1866975 1866975 defendant Oter John husbandman 589546 589546 Oter, John, of Yatton, husbandman 3
3631495 1904664 1904664 defendant Cradoke John husbandman 589546 589546 Cradoke, John, of Yatton, husbandman 0
3631496 1904664 1904664 defendant Durbar John husbandman 589546 589546 Durbar, John, of Yatton, husbandman 1
3642895 1908228 1908228 defendant Coke Robert husbandman 589546 589546 Coke, Robert, of Yatton, husbandman 0
3650504 1910527 1910527 defendant Harrold John husbandman 589546 589546 Harrold, John, of Yatton, husbandman 1
3669226 1916313 1916313 defendant Harrold Johm yeoman 589546 589546 Harrold, Johm, of Yatton, yeoman 2
3680480 1919978 1919978 defendant Durbar John husbandman 589546 589546 Durbar, John, of Yatton, husbandman 1
3693300 1924117 1924117 defendant Turnor John yeoman 589546 589546 Turnor, John, of Yatton, yeoman 0
3767431 1947457 1947457 defendant Thomas alias Priett John yeoman 589546 589546 Thomas alias Priett, John, of Yatton, yeoman 0
3767432 1947457 1947457 defendant Broke or Croke William husbandman 589546 589546 Broke or Croke, William, of Yatton, husbandman 1
3777455 1950698 1950698 defendant Aphowell Walter husbandman 589546 589546 Aphowell, Walter, of Yatton, husbandman 1
3777456 1950698 1950698 defendant Aphowell John husbandman 589546 589546 Aphowell, John, of Yatton, husbandman 2
3866257 1978942 1978942 defendant Knyghte William husbandman 589546 589546 Knyghte, William, of Yatton, husbandman 0
3898057 1989559 1989559 defendant Aphoell Hugh husbandman 589546 589546 Aphoell, Hugh, of Yatton, husbandman 1
3898061 1989560 1989560 defendant ap Hooll John husbandman 589546 589546 ap Hooll, John, of Yatton, husbandman 2
3904094 1991612 1991612 plaintiff Hannam John husbandman 589546 589546 Hannam, John, of Yatton, husbandman 0
3904095 1991612 1991612 plaintiff Irysshe John husbandman 589546 589546 Irysshe, John, of Yatton, husbandman 1
3907109 1992667 1992667 defendant Webbe Richard carpenter 589546 589546 Webbe, Richard, of Yatton, carpenter 0
3908210 1993044 1993044 defendant More Thomas husbandman 589546 589546 More, Thomas, of Yatton, husbandman 0
3920341 1997144 1997144 defendant Dyke Thomas yeoman 589546 589546 Dyke, Thomas, of Yatton, yeoman 0
3921343 1997481 1997481 defendant Tyrry John husbandman 589546 589546 Tyrry, John, of Yatton, husbandman 1
3924803 1998614 1998614 plaintiff Wale John (legal representative) 589546 589546 Wale, John, of Yatton, husbandman, executrix of 0
3955627 2009041 2009041 defendant Apowell Walter yeoman 589546 589546 Apowell, Walter, of Yatton, yeoman 0
3955628 2009041 2009041 defendant Apowell John yeoman 589546 589546 Apowell, John, of Yatton, yeoman 1
3955630 2009042 2009042 defendant Dyke Thomas yeoman 589546 589546 Dyke, Thomas, of Yatton, yeoman 0
3960637 2010821 2010821 defendant Byne James husbandman 589546 589546 Byne, James, of Yatton, husbandman 0
3960640 2010822 2010822 defendant Symes William husbandman 589546 589546 Symes, William, of Yatton, husbandman 1
3962127 2011336 2011336 defendant Wylde John husbandman 589546 589546 Wylde, John, of Yatton, husbandman 0
4000925 2025101 2025101 defendant Turnor Walter yeoman 589546 589546 Turnor, Walter, of Yatton, yeoman 0
4016947 2030763 2030763 defendant Warr William husbandman 589546 589546 Warr, William, of Yatton, husbandman 0
4016948 2030763 2030763 defendant Taylor John husbandman 589546 589546 Taylor, John, of Yatton, husbandman 1
4048148 2041774 2041774 defendant Taylor John husbandman 589546 589546 Taylor, John, of Yatton, husbandman 0
4059709 2045866 2045866 defendant Turner Walter yeoman 589546 589546 Turner, Walter, of Yatton, or of West Norway, yeoman 0
4063212 2047136 2047136 defendant Powell John yeoman 589546 589546 Powell, John, of Yatton, yeoman 6
4078010 2052438 2052438 defendant Antonye Thomas husbandman 589546 589546 Antonye, Thomas, of Yatton, husbandman 0
4081625 2053731 2053731 defendant Torner Walter husbandman 589546 589546 Torner, Walter, of Yatton, husbandman 0
4095441 2058694 2058694 defendant Hurdwyche alias Symes William husbandman 589546 589546 Hurdwyche alias Symes, William, of Yatton, husbandman 1
4107877 2063094 2063094 defendant Heyward Henry laborer 589546 589546 Heyward, Henry, of Yatton, laborer 1
4107879 2063094 2063094 defendant Woodward Walter tailor 589546 589546 Woodward, Walter, of Yatton, tailor 3
4107882 2063095 2063095 defendant Heyward Henry laborer 589546 589546 Heyward, Henry, of Yatton, laborer 1
4107884 2063095 2063095 defendant Woodward Walter laborer 589546 589546 Woodward, Walter, of Yatton, laborer 3
4107889 2063097 2063097 defendant Woodward Walter tailor 589546 589546 Woodward, Walter, of Yatton, tailor 1
4107891 2063097 2063097 defendant Heyward Henry laborer 589546 589546 Heyward, Henry, of Yatton, laborer 3
4112135 2064598 2064598 defendant Dale Henry yeoman 589546 589546 Dale, Henry, of Yatton, yeoman 0
4114809 2065584 2065584 defendant Anthonye Thomas husbandman 589546 589546 Anthonye, Thomas, of Yatton, husbandman 0
4114810 2065584 2065584 defendant Colman John, senior husbandman 589546 589546 Colman, John, senior, of Yatton, husbandman 1
4153713 2079396 2079396 defendant Turnor Walter yeoman 589546 589546 Turnor, Walter, of Yatton, yeoman 0
4153715 2079396 2079396 defendant Gamonde Thomas yeoman 589546 589546 Gamonde, Thomas, of Yatton, yeoman 2
4153717 2079397 2079397 defendant Turnor Walter yeoman 589546 589546 Turnor, Walter, of Yatton, yeoman 0
4153719 2079397 2079397 defendant Gamund Thomas yeoman 589546 589546 Gamund, Thomas, of Yatton, yeoman 2
4167337 2084076 2084076 defendant Slytche Thomas husbandman 589546 589546 Slytche, Thomas, of Yatton, husbandman 0
4167338 2084076 2084076 defendant Mylles alias Crystofer Richard cordwainer 589546 589546 Mylles alias Crystofer, Richard, of Yatton, cordwainer 1
4167339 2084076 2084076 defendant Symes alias Hurdwych William cordwainer 589546 589546 Symes alias Hurdwych, William, of Yatton, husbandman, cordwainer 2
4180144 2088535 2088535 defendant Persons John husbandman 589546 589546 Persons, John, of Yatton, husbandman 0
4180147 2088536 2088536 defendant Parsons John husbandman 589546 589546 Parsons, John, of Yatton, husbandman 0
4190812 2092350 2092350 defendant Porter William yeoman 589546 589546 Porter, William, of Yatton, yeoman 1
4206737 2097897 2097897 defendant Horte Richard gent 589546 589546 Horte, Richard, of Yatton, gent 0
4251113 2113351 2113351 defendant Tucker John tanner 589546 589546 Tucker, John, of Yatton, tanner 3
4288265 2125850 2125850 defendant Wytherydge Robert husbandman 589546 589546 Wytherydge, Robert, of Yatton, husbandman 0
4288266 2125850 2125850 defendant Wytherydge William husbandman 589546 589546 Wytherydge, William, of Yatton, husbandman 1
4302002 2130826 2130826 defendant Symes Philip husbandman 589546 589546 Symes, Philip, of Yatton, husbandman 0
4308222 2133028 2133028 defendant Wornell James yeoman 589546 589546 Wornell, James, of Yatton, yeoman 0
4308223 2133028 2133028 defendant Wornell Thomas, junior yeoman 589546 589546 Wornell, Thomas, junior, of Yatton, yeoman 1
4312101 2134372 2134372 defendant Harrys Thomas husbandman 589546 589546 Harrys, Thomas, of Yatton, husbandman 0
4312103 2134372 2134372 defendant Stevens John husbandman 589546 589546 Stevens, John, of Yatton, husbandman 2
4316489 2135884 2135884 defendant Wytherydge Robert yeoman 589546 589546 Wytherydge, Robert, of Yatton, yeoman 0
4323888 2138400 2138400 defendant Powell William yeoman 589546 589546 Powell, William, of Yatton, yeoman 3
4361733 2151354 2151354 defendant Hawkyns Theophilus yeoman 589546 589546 Hawkyns, Theophilus, of Yatton, yeoman 0
4361734 2151354 2151354 defendant Cotton William husbandman 589546 589546 Cotton, William, of Yatton, husbandman 1
4362300 2151568 2151568 defendant Gage Edmund husbandman 589546 589546 Gage, Edmund, of Yatton, husbandman 0
4362301 2151568 2151568 defendant Porter Thomas husbandman 589546 589546 Porter, Thomas, of Yatton, husbandman 1
4378479 2157373 2157373 defendant Hardwyll William husbandman 589546 589546 Hardwyll, William, of Yatton, husbandman 3
4408089 2167276 2167276 defendant Porter William husbandman 589546 589546 Porter, William, of Yatton, husbandman 2
4551523 2216417 2216417 defendant Haket Thomas   589546 589546 Haket, Thomas, of Yatton 0
4551524 2216417 2216417 defendant Bertelot John   589546 589546 Bertelot, John, of Yatton 1
4575374 2223812 2223812 plaintiff Boteler William   589546 589546 Boteler, William, of Yatton 0
4575380 2223813 2223813 plaintiff Boteler William   589546 589546 Boteler, William, of Yatton 0
4630345 2240399 2240399 defendant Persones John   589546 589546 Persones, John, of Yatton 0
4684768 2260834 2260834 defendant Goundenham John husbandman 589546 589546 Goundenham, John, of Yatton, husbandman 0
4684771 2260834 2260834 defendant Bartelot John husbandman 589546 589546 Bartelot, John, of Yatton, husbandman 3
4701928 2266008 2266008 defendant Chesilden Robert gent 589546 589546 Chesilden, Robert, of Yatton, gent 0
4759454 2283298 2283298 defendant Heyman Thomas husbandman 589546 589546 Heyman, Thomas, of Yatton, husbandman 2
4759456 2283298 2283298 defendant Haket Thomas husbandman 589546 589546 Haket, Thomas, of Yatton, husbandman 4
4794202 2294325 2294325 defendant Dole Edmund husbandman 589546 589546 Dole, Edmund, of Yatton, husbandman 0
4794203 2294325 2294325 defendant Dole John husbandman 589546 589546 Dole, John, of Yatton, husbandman 1
4794204 2294325 2294325 defendant Dole William husbandman 589546 589546 Dole, William, of Yatton, husbandman 2
4812565 2300046 2300046 defendant Pulhare Nicholas husbandman 589546 589546 with Pulhare, Nicholas, of Yatton, husbandman 3
4838460 2307944 2307944 defendant Varler Walter husbandman 589546 589546 Varler, Walter, of Yatton, husbandman 0
4838461 2307944 2307944 defendant Haket Thomas husbandman 589546 589546 Haket, Thomas, of Yatton, husbandman 1
4838462 2307944 2307944 defendant Wattys John husbandman 589546 589546 Wattys, John, of Yatton, husbandman 2
4838463 2307944 2307944 defendant Mason Walter husbandman 589546 589546 Mason, Walter, of Yatton, husbandman 3
4846864 2310525 2310525 defendant Pyke John husbandman 589546 589546 Pyke, John, of Yatton, husbandman 0
4846866 2310525 2310525 defendant Wyke John husbandman 589546 589546 Wyke, John, of Yatton, husbandman 2
4846867 2310525 2310525 defendant Mey John husbandman 589546 589546 Mey, John, of Yatton, husbandman 3
4864277 2315804 2315804 defendant Averey Agnes widow 589546 589546 Averey, Agnes, of Yatton, widow 1
4864278 2315804 2315804 defendant Avery William husbandman 589546 589546 Avery, William, of Yatton, husbandman 2
4865634 2316217 2316217 defendant Haket Thomas husbandman 589546 589546 Haket, Thomas, of Yatton, husbandman 0
4865635 2316217 2316217 defendant Wattys John husbandman 589546 589546 Wattys, John, of Yatton, husbandman 1
4865636 2316217 2316217 defendant Mason Walter husbandman 589546 589546 Mason, Walter, of Yatton, husbandman 2

Next page

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