names

78 rows where place_id = 599724

✎ 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
3637979 1906698 1906698 defendant Newland Joan widow 599724 599724 Newland, Joan, of Sydbury, widow 3
3644425 1908675 1908675 defendant Ganneclyff William husbandman 599724 599724 Ganneclyff, William, of Sydbury, husbandman 4
3657216 1912521 1912521 defendant Trailman John clerk 599724 599724 Trailman, John, of Sydbury, clerk 0
3670184 1916622 1916622 defendant Aysshelegh William gent 599724 599724 Aysshelegh, William, of Sydbury, gent 0
3683899 1921098 1921098 defendant Blakemore William husbandman 599724 599724 Blakemore, William, of Sydbury, husbandman 0
3691168 1923400 1923400 defendant Ayssheley William   599724 599724 Ayssheley, William, of Sydbury, gent, son of Tremayle, John 0
3694488 1924481 1924481 defendant Terell John husbandman 599724 599724 Terell, John, of Sydbury, husbandman 0
3694489 1924481 1924481 defendant Brent John husbandman 599724 599724 Brent, John, of Sydbury, husbandman 1
3697962 1925586 1925586 defendant Benet Richard yeoman 599724 599724 Benet, Richard, of Sydbury, yeoman 0
3711709 1929974 1929974 defendant Blakmore William husbandman 599724 599724 Blakmore, William, of Sydbury, husbandman 0
3713747 1930598 1930598 plaintiff Assheley William gent 599724 599724 Assheley, William, of Sydbury, gent 0
3721245 1932947 1932947 defendant Crokhay John husbandman 599724 599724 Crokhay, John, of Sydbury, husbandman 0
3737147 1937852 1937852 defendant Knell Richard carpenter 599724 599724 Knell, Richard, of Sydbury, carpenter 0
3743375 1939801 1939801 defendant Stowell George husbandman 599724 599724 Stowell, George, of Sydbury, husbandman 0
3743376 1939801 1939801 defendant Lympeny John gent 599724 599724 Lympeny, John, of Sydbury, gent 1
3743377 1939801 1939801 defendant Eliott John husbandman 599724 599724 Eliott, John, of Sydbury, husbandman 2
3743378 1939801 1939801 defendant Westeland John yeoman 599724 599724 Westeland, John, of Sydbury, yeoman 3
3743379 1939801 1939801 defendant Lympeny Joan widow 599724 599724 Lympeny, Joan, of Sydbury, widow 4
3754528 1943373 1943373 defendant Halstowe William husbandman 599724 599724 Halstowe, William, of Sydbury, husbandman 0
3754924 1943489 1943489 defendant Ayshelegh William, senior gent 599724 599724 Ayshelegh, William, senior, of Sydbury, gent 0
3762862 1946022 1946022 defendant Walker William gent 599724 599724 Walker, William, of Sydbury, gent 0
3822651 1964989 1964989 defendant Stawell George gent 599724 599724 Stawell, George, of Sydbury, gent 0
3831116 1967618 1967618 defendant Seward Michael husbandman 599724 599724 Seward, Michael, of Sydbury, husbandman 0
3831682 1967807 1967807 defendant Parson William yeoman 599724 599724 Parson, William, of Sydbury, yeoman 0
3838250 1969882 1969882 defendant Whitmore William husbandman 599724 599724 Whitmore, William, of Sydbury, husbandman 1
3843151 1971384 1971384 defendant Lane alias Whyte Robert husbandman 599724 599724 Lane alias Whyte, Robert, of Sydbury, husbandman 0
3852162 1974274 1974274 defendant Stokker Henry butcher 599724 599724 Stokker, Henry, of Sydbury, butcher 0
3852163 1974274 1974274 defendant Tyrle Ralph husbandman 599724 599724 Tyrle, Ralph, of Sydbury, husbandman 1
3852164 1974274 1974274 defendant Stotes or Scotes John husbandman 599724 599724 Stotes or Scotes, John, of Sydbury, husbandman 2
3855273 1975284 1975284 defendant Blakemore William husbandman 599724 599724 Blakemore, William, of Sydbury, husbandman 0
3863151 1977878 1977878 defendant Hals John esq 599724 599724 Hals, John, of Sydbury, esq 2
3869174 1979937 1979937 defendant Cowde John clerk 599724 599724 Cowde, John, of Sydbury, clerk 3
3895036 1988549 1988549 defendant Hals John gent 599724 599724 Hals, John, of Sydbury, gent 0
3930110 2000417 2000417 defendant Arundell William gent 599724 599724 Arundell, William, of Sydbury, gent 0
3930112 2000417 2000417 defendant Seward Richard husbandman 599724 599724 Seward, Richard, of Sydbury, husbandman 2
3930115 2000418 2000418 defendant Arundell William gent 599724 599724 Arundell, William, of Sydbury, gent 0
3980879 2017924 2017924 defendant Heddon John, junior husbandman 599724 599724 Heddon, John, junior, of Sydbury, husbandman 0
4131785 2071685 2071685 defendant Warren Nicholas yeoman 599724 599724 Warren, Nicholas, of Sydbury, yeoman 0
4249360 2112769 2112769 defendant Harvye John gent 599724 599724 Harvye, John, of Sydbury, gent 0
4333889 2141619 2141619 defendant More Thomas gent 599724 599724 More, Thomas, of Sydbury, gent 0
4380308 2158061 2158061 defendant More Thomas gent 599724 599724 More, Thomas, of Sydbury, gent 0
4675009 2257793 2257793 defendant Cherde John carpenter 599724 599724 Cherde, John, of sydbury, carpenter 1
4679856 2259305 2259305 defendant Carter Richard laborer 599724 599724 Carter, Richard, of Sydbury, laborer 0
4689843 2262380 2262380 defendant Knolle John gent 599724 599724 Knolle, John, of Sydbury, gent 0
4710618 2268675 2268675 defendant Carter John husbandman 599724 599724 Carter, John, of Sydbury, husbandman 0
4710619 2268675 2268675 defendant Carter Richard laborer [ possibly in Devon ] 599724 599724 Carter, Richard, of Sydbury, laborer [ possibly in Devon ] 1
4715464 2270174 2270174 defendant Knolle John gent 599724 599724 Knolle, John, of Sydbury, gent 0
4887558 2322947 2322947 defendant Tremayle John gent 599724 599724 Tremayle, John, of Sydbury, gent 0
4887564 2322950 2322950 defendant Tremayll John gent 599724 599724 Tremayll, John, of Sydbury, gent 0
4984338 2352243 2352243 defendant Tremayle John gent 599724 599724 Tremayle, John, of Sydbury, gent 0
5108291 2388858 2388858 defendant Tremayle John gent 599724 599724 Tremayle, John, of Sydbury, gent 0
5108293 2388859 2388859 defendant Tremayle John gent 599724 599724 Tremayle, John, of Sydbury, gent 0
5123434 2393299 2393299 defendant Netheway John gent 599724 599724 Netheway, John, of Sydbury, gent 0
5191340 2413205 2413205 defendant Crokker Baldewin husbandman 599724 599724 Crokker, Baldewin, of Sydbury, husbandman 0
5191341 2413205 2413205 defendant Beket Nicholas   599724 599724 Beket, Nicholas, of Sydbury, glove maker 1
5191342 2413205 2413205 defendant Wryght Robert husbandman 599724 599724 Wryght, Robert, of Sydbury, husbandman 2
5191343 2413205 2413205 defendant Nosutter John husbandman 599724 599724 Nosutter, John, of Sydbury, husbandman 3
5217305 2420797 2420797 defendant Wyse Richard smith 599724 599724 Wyse, Richard, of Sydbury, smith 0
5283513 2440230 2440230 defendant Waryn Walter husbandman 599724 599724 Waryn, Walter, of Sydbury, husbandman 0
5334349 2455344 2455344 defendant Wyche Robert husbandman 599724 599724 Wyche, Robert, of Sydbury, husbandman 0
5364201 2464460 2464460 defendant Wood William Master or Warden of the College of St Gregory 599724 599724 Wood, William, of Sydbury, Master or Warden of the College of St Gregory 0
5364733 2464631 2464631 defendant Wryght William husbandman 599724 599724 Wryght, William, of Sydbury, husbandman 1
5435222 2485465 2485465 defendant Rogger John yeoman 599724 599724 Rogger, John, of Sydbury, yeoman 0
5437963 2486289 2486289 defendant Hoye Thomas chaplain 599724 599724 Hoye, Thomas, of Sydbury, chaplain 1
5452067 2490500 2490500 defendant Heye Thomas chaplain 599724 599724 Heye, Thomas, of Sydbury, chaplain 1
5464007 2494151 2494151 defendant Hoye Thomas chaplain 599724 599724 Hoye, Thomas, of Sydbury, chaplain 1
5464010 2494152 2494152 defendant Hoye Thomas chaplain 599724 599724 Hoye, Thomas, of Sydbury, chaplain 1
5475554 2497688 2497688 defendant Hoye Thomas chaplain 599724 599724 together with Hoye, Thomas, of Sydbury, chaplain 1
5475558 2497690 2497690 defendant Hoy Thomas chaplain 599724 599724 Hoy, Thomas, of Sydbury, chaplain 0
5484752 2500363 2500363 defendant Brace William laborer 599724 599724 Brace, William, of Sydbury, laborer 2
5484755 2500363 2500363 defendant Hewe John yeoman 599724 599724 Hewe, John, of Sydbury, yeoman 5
5508050 2507412 2507412 defendant Smyth William husbandman 599724 599724 Smyth, William, of Sydbury, husbandman 0
5528857 2513547 2513547 defendant Spray Thomas butcher 599724 599724 Spray, Thomas, of Sydbury, butcher 0
5532995 2514863 2514863 defendant Serle John husbandman 599724 599724 Serle, John, of Sydbury, husbandman 0
5532997 2514863 2514863 defendant Cotford Richard husbandman 599724 599724 Cotford, Richard, of Sydbury, husbandman 2
5577293 2527953 2527953 defendant Caponter alias Carponte Michael (legal representative) 599724 599724 Caponter alias Carponte, Michael, of Sydbury, executors of 0
5577294 2527953 2527953 defendant Abrygge alias Hoper John husbandman 599724 599724 (Abrygge alias Hoper, John, of Sydbury, husbandman 1
5577819 2528132 2528132 defendant Weryng William husbandman 599724 599724 Weryng, William, of Sydbury, husbandman 2

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